Oninit® Archive
Results for “onstat -g nss”
sysrstcb
Thanks Art. So the only way to look the session and the table is use onstat -g opn to get TID then, search for SID at sysrstcb?…
Network tuning advice needed
Greetings All, I am looking for some advice on a new (to me) configuration. Up until now, we have always had our engine running on the same server as our application. That has now changed. We now have a setup with the application on one server and the engine on a dedicated datab…
Sessions and transactions
Hi Y'all (with a capital Y ) A few weeks ago I posted a question about transactions and, with the help of Markus, I was able to create the query and wrapping script that I was planning. My manager liked the idea but now asked for a similar scripts to summarize session, so we can…
Error -25587 using a shared memory connection.
Weird, and 25587 apparently being a rare error. Any signs of sessions having been terminated (onmode -z, maybe induced by some server side config - session limit)? ------------------------------ Andreas Legner Informix Dev HCL Software ------------------------------…
Dates and times for Sessions at TechXchange?
I have confirmed with TechXchange that no dates or times are available (yet) for sessions at TechXchange... Tom ------------------------------ Tom Ross ------------------------------…
Changing DBSPACETEMP run-time
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, is there a way to change DBSPACETEMP for a session inside 4GL? ------------------------------ Sincerely, Dennis ------------------------------…
Question of dostats
Yes. Many dostats rune used two connections egging you cannot do over a shared memory connection. There is an option to use a shared memory connection but then you can only process one database per run. Art ------------------------------ Art S. Kagel, President and Principal Con…
onstat -g ses returns "Changing data structure forced command termination"
Hello Art, Thank you for your prompt reply. Is there any other way to monitor the session information? ------------------------------ Stavros Tseriotis ------------------------------…
flags (onstat -g ses)
John: So, the smoking gun may be the "PDQ is set to 10%". That may cause sessions to go into a wait state that is not documented by any flags in onstat. The onstat -g mgm report will tell the tale. Here's the thing to remember about PDQ. It controls the percentage of PDQ resource…
Shared Memory
Hello, Today I checked the Informix shared memory by onstat -g seg on Informix 14.10FC6X3 informix [rs-om-ifx-201] on_nebula21 $ onstat -g seg IBM Informix Dynamic Server Version 14.10.FC6X3 -- On-Line -- Up 16:43:49 -- 10327040 Kbytes 2021-09-03 15:36:42 Segment Summary: id …
monitoring session memory
IDS 11.70FC4 I seem to be having some serious session memory leaks. Sadly it is intermittent. All the clients are using DBD::Informix (perl) to access the database. I have to run onmode -F quite frequently and restart some of the clients so it looks like something is not being cl…
Validate backup : archecker –tdsv and CommVault
Signal 15 is SIGTERM - some other process or session killed the onbar session or the underlying archecker session. The bar_debug file might have more detail. ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt…
onstat statement
Dears, Kindly let me know if I run onstat - g stm command to check current sql statement which give the Session ID but sometimes if I try to kill the session by onmode -z <id> , it doesn't kill the session. So do I need to connect the session id with onstat -k session id ? kindly…
ADO - activex data object
What do I require, to connect "ado activex data object" to Informix ? AIX 7.2 IBM Informix Dynamic Server Version 12.10.FC9W1 Regards Dirk…
How to kill a session using SQL
Thank you. This is great. Question. Want to query the client port no. for a database session. Are you aware of what sysmaster table/view this would be in?…
RSS Encryption Performance Hit?
Does ENCRYPT_SMX need to be set only on the RSS, only on the Primary, or on both? After enabling this network encryption, how can one verify that it is operating? Thank you. DG…
Who shut down my Instance?
No, Benji, there is not record kept of what session executed the onmode to shutdown the instance.…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
Re: 12.10.FC9 1809 Error
i'm just connecting on shared memory (onipcshm in sqlhosts) regards…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Clear out temp space?
Thank you, John. So, they were likely files, not tables, and I could have observed them with an 'ls' command? Then, I might have been able to identify the session by inspecting the contents of the file. Then, kill the session (assuming I could identify it)? DG…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
Issues With Restore
I tried it well 10 times now, but it is now saying: Warning: Fatal error in shared memory creation…
Thousands -27001 errors
Hi, I've noticed that we have around 25 thousands -27001 errors in online.log after I checked the database because of an EG crash in IIB. EG crashed because it couldn't lock a table in informix they said. Because of this I saw all the network errors , which started since 2 days a…
sid vs pid
What is the difference between the sid and the pid (in the syssessions table of the sysmaster database)? I assume that sid stands for session ID and pid for process ID. If that is correct, then a session could have more than one process running at a time. Is that right?…
sqlhosts file
For the sqlhosts file, if you have two servers (primary and secondary for HDR), will the sqlhosts file have 3 entries? Primary One for shared memory with name of primary and two for tcp(one for each server)? Secondary Same thing(3 entries) except for shared memory, it will have…
IDS not writing to online.log
tried to onmode -z session but no success btw, this is not prod environement…
ids 11.50 shared memory for Workgroup Edition
Solaris 10 11.50.FC5 For the Workgroup Edition, is the maximum memory allowed shared between instances on the same server; or does each instance on the same server have access to the maximum allowable shared memory? Larry…
12.10.FC6 Mac port released
IBM Informix 12.10.FC6 release for Mac OS is officially available! John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS)…
shared memory issue
Hi I am frequently getting below error, I know I am using workgroup Edition hence there is a limit, Using shared memory... however transaction are so less hence dont expect this error very frequently Warning: The IBM IDS Growth Edition license restriction limits the total share…
Panic analysis
Folks, IDS 12.10 FC4, Linux 6. The following log is the only info we have about the crash ( no other info dumped ) You can see it was struggling to add lot memories segments before Panic .... The Panic was a also VERY curious one with some unexpected process terminated ... Wha…
listener-thread: err = -25580: oserr = 32.......
Guys, IDS12.10 FC4 RHEL Recently, suddenly see these error excessively. Any comments or able to trace it? Thanks Frank 14:24:07 CDR Spool transaction queue completed 14:27:02 listener-thread: err = -25580: oserr = 32: errstr = : System error occurred in network function. Syst…
session/query using temp db space
Hi, Can you guide me to identify session/query which is consuming temp db space Thanks.…
IO Wait and PDQ
Agreed, but I can guarantee this is the only session using PDQ during the test cases.…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Using SQLTRACE
So it will trace the current sessions not new ones ?…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
does this mean a dropped network connection
John Not necessarily a network problem, but yes, the server lost contact with the application. Could be network, could be the user just shutdown the app while a query was still running, or just pressed the power off buttton on the PC !! Keith On 3 December 2013 13:44, John Adam…
Option for audit logging new sessions
We have a need to log all created sessions (successful logins only) to an external file (session id, date/time, hostname, username, etc). Is there an audit log configuration somewhere that we can use to do this? Thanks -Justin…
when use IfxDataReader.GetIfxDateTime to NULL valu
Hello, The version of Informix products in my environment is: Database server: AIX IBM Informix Dynamic Server Version 10.00.FC5 IBM Informix CSDK Version 2.90 IBM-ESQL Version 2.90.FC4 Client: PC Windows IBM Informix-ESQL 3.70.TC5DE.…
cant access DBSERVERALIASES
entry as follows dbt633_ecms_uat onsoctcp wldbt633 1526 everthing seems ok now there have been some network errors…
Concurrent Sessions
Hi All, We would soon be involved in a Complance audit. Any clues on how the official count of concurrent sessions is arrived at? Thanks in advance, Jay…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Map temp tables to session
Hello, We are running informix 11.50.FC6X5. Is there anyway to map temp tables back to the original session that created those tables? We have reporting users that don't use explicit temp tables (create temp table), though they do have many subqueries and multisets. Most of t…
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
shared memory
This concerns IDS 11.70.TC5IE on Windows Server 2008 . This article http://publib.boulder.ibm.com/infocenter/idshelp/v117/index.jsp?topic=%2Fcom.ibm .perf.doc%2Fids_prf_750.htm defines buffer_value = (BUFFERS * pagesize) + (BUFFERS * 254) + 250000and goes on to say: âIf you hav…
Temporary Tables Structure, how to get it ?
I know that temp tables are locale to the user sessions, what I need is to get the structure of the temp table, while inside the session, Do you know if it is possible to access this information inside the session ? Thanks Marcos Cassinerio…
ontape pipe restore times
This would be faster than gzip if you are now CPU rather than network limited (no difference with gunzip): http://zlib.net/pigz Regards, Doug Lawry…
Join my network on LinkedIn
LinkedIn ------------ akli imecaoudene requested to add you as a connection on LinkedIn: ------------------------------------------ I'd like to add you to my professional network on LinkedIn. Accept invitation from akli imecaoudene http://www.linkedin.com/e/-dryrhn-h52re…
Memory down and shared memory not initialized
I compiled utils2_ak. When executing printFreeB I got a message the library libifsql.so could not be found. So I put the lines below in /etc/ld.so.conf and exectued ldconfig. /opt/informix/lib /opt/informix/lib/c++ /opt/informix/lib/cli /opt/informix/lib/csm /opt/informix/lib/dm…
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
Linux: oninit returns "shared memory base address illegal", fails to start
Art, I've been getting that error message "Insufficient free huge pages in /proc/meminfo for shared memory segment. Requested: 204800000 bytes. Available: 0 bytes. The default memory page size will be used." since I first installed and configured. The engine…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
Network
I have a query that we are running between 2 LPAR's on the same P6. Both systems are IDS 11.70.fc3x9 and AIX 6.1. The table contains about 3.2 million rows... database eisds01@dss_lnk; select * from c3ods@ods_lnk:temp_event_item into temp test_data with no log; 3+ minutes dat…
Need a Help, Access login and sql traces
thanks i also found a way to do it, with server studio, but i still need to log sessions, the successfuls and the unsuccessful ones. your script and also server studio logs only the successfuls sessions. i understrand that there is a way to logs unsuccessful sessions with infor…
migration checklist 7.31 to 11.7
Art: Thanks for the notes... I'm getting a bit more confident that the small scale, SQL stuff for site specific jobs won't be that big of an issue (as long as the OS and environment doesn't change that much without the developers telling us). FYI I found a migration presentatio…
RE: Session Timeout on IDS10
Are your connections passing through a firewall? That could be the cause. We've seen that happen on idle connections. _____ From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Laurie Gustin Sent: Wednesday, November 30, 2011 12:51 PM To:…
Session Timeout on IDS10
We are having an issue with idle sessions timing out after 60 minutes on our IDS 10.0 server (HP-UX 11i). I have looked through all the documentation and can't find any default time out setting. Does anyone know of anything that may be contributing to this problem? Thanks …
Informix process reads a lot of pages
>So, running "onstat -g ses" shows no output except the report header line? "onstat -g ses <session id>" shows the report header. "onstat -g ses" shows some sessions, but not this session which reads a lot of pages…
Shared memory connection to HDR Secondary
Folks, IDS11.50 FC8, Redhat Linux It is not allowed to have a shared memory connection to a HDR Secondary( with dbacess..), is it? Thanks, Frank --001517588cfa01cb4304b178d099…
Join my network on LinkedIn
LinkedIn ------------ Pedro Ivo has indicated you are a Friend ------------------------------------------ Eu gostaria de adicioná-lo à minha rede profissional no LinkedIn. Accept invitation from Pedro Ivo http://www.linkedin.com/e/-dryrhn-gtq5nirr-1t/TE9gQQCW5u…
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
Join my network on LinkedIn
LinkedIn ------------ Pedro Ivo requested to add you as a connection on LinkedIn: ------------------------------------------ I'd like to add you to my professional network on LinkedIn. Accept invitation from Pedro Ivo http://www.linkedin.com/e/-dryrhn-gqkq4n8o-29/TE9gQQCW…
What is virtual about Informix "virtual segment of shared memory"?
In the IDS memory architecture, why is the "virtual" portion of shared memory called "virtual?" It seems to reside in that portion of physical memory that the O/S designates to share between multiple processes, but never seems to have anything to do with swapping/paging to disk.…
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
network traffic
Hi guys! Does anybody know where can I find some presentation that explain the steps to reduce network traffic between client/server? I've seen once, in 2007 presented by Vlaunir Silva (IBM US) at IBM Brasil on a Informix Workshop. He showed how to reduce the network traffic and…
Environment for session
Hi All Quick question regarding the session environment. Sample here: Environment for session 176: Variable Value [values-list] CLIENT_LOCALE en_US.8859-1 CLNT_PAM_CAPABLE 1 DBDELIMITER | DBPATH . [.] [//ipdb] DBPRINT lpr DBTEMP /tmp GL_DATETIME %iY/%m/%d %H:%M:%S I did no…
get top 5 i/o busy session
How to get top 10 i/o busy session by running 'onstat -u' and order by " nreads+nwrites" column that addition values of "nreads and nwrites" onstat -u | sort -rnk9 | head -n5 will get top 5 nreads sessions onstat -u | sort -rnk10| head -n5 will get top 5 nwrites sessions…
Instance Crashed !!
What must be the ratio of Resident Memory & Shared Memory that we can allocate initially ? What is the impact of # of Buffers & its size to the size of Resident Memory. Thanks.…
database name of current session ?
Hello, How can i find database name of current session using select statement? Thanks…
sysmaster query
Hi, Is there any sysmaster query which is substitute of onstat -g ses <session id> command ?…
Shared memory segments
Don't have an answer for you off hand, but I did fix your subject line so it doesn't look like spam. --EEM -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of qingchuntrade Sent: Monday, December 27, 2010 7:54 PM…
wait on lock more than 30 seconds
kindly give me the query which can find all the sessions waiting for a session and also session which applied locks.…
network errors
OS: HP/UX 11.11 IDS: 9.4FC3 (we are in the process of upgrading, but new server/db not ready for production yet) We started seeing these errors in our log Friday when users complained of not being able to connect. We checked back over time and there have been a few here and ther…
Tool to estimate the size of an index
Sorry, I forgot to provide the version of the installation: IBM Informix Dynamic Server Version 11.50.FC4 Operative System: AIX Version 6.1…
informix dropping idle connections
Cesar this script appears to kill idle unix login sessions not database connections…
Shared memory connection - IDS 10.00.FC8 on HP-UX
HI all, I have shell script which am running from server has dbaccess command ( example - dbaccess database_name test.sql ) (test.sql contains delete statements) while running this shell script it takes shared memory connection which I can see through (onstat -g nss and ps -eaf…
CDR Grouper FanOut thread is aborting
Folks, Build Version: 11.10.UC2 Build OS: AIX 5.3 The ER does not work properly due to a "out of virtual shared memory " problem in one site. Is there any EASY DRUG to treat "CDR Grouper FanOut thread is aborting." ? (instead of recreating whole the ER) Thanks, Frank .......…
Queries waiting for mutex
Hello all, Yesterday afternoon we ran into a problem. All sessions selecting or modifying data stopped responding to users. Onstat -u showed all of these sessions in a status of waiting for mutex 'S--P---'. After gathering onstat -a and onstat -g all information, I restarted Inf…
monitoring CPU
how can we map the out put with session id?…
Re: How to identify a run away process in Database
Hi John, What I mean by runaway process is. 1. the session id exists on the db (but how do i know if it is runaway process?) but can't find the pid on the OS level. Given the "onstat -g ses sessionid", can i say that the session id is runaway process? What is the hint that it …
listener-thread Network error
Hello Everybody, I have a problem with a instance. I´m runing IDS 11.50.FC7 on HP-UX B.11.31 And every five minutes in the online.log put a message like this:"listener-thread: err = -25582". Almost of the time appears exactly like this: 12:01:25 listener-thread: err = -25580:…
Can't access sysindexes remotely
Hi, We are using IBM Informix Dynamic Server Version 11.50.FC6 using Platform: SunOS 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 Thanks…
Shared memory problem
IDS 9.40 UC4 on Linux (yes, I know ...) 1. Initialising the instance with a shared memory connection it just hangs at: 01:09:26 Maximum server connections 0 01:09:26 Dataskip is now OFF for all dbspaces 01:09:26 On-Line Mode 01:09:26 Building 'sysmaster' database ... Never…
Connections blocked - Connect Timeout Expired
Correction (zero NET VPS after changing VPCLASS to cpu); With; NETTYPE soctcp,7,350,NET VPCLASS net,num=7,noage Results in; 7 Network VP, and 1 CPU VP. With; NETTYPE soctcp,7,350,NET VPCLASS cpu,num=7,noage Results in; 0 Network VP and 7 CPU VP!…
frozen sessions
Can somebody tell me what a session in a "cond wait PC_I hash" condition mean? I have multiple sessions that are all stuck at the same place. The statements are all called from stored procedures. The last one executing (spil_send_mail) only inserts into a table, but that's whe…
frozen sessions
Can somebody tell me what a session in a "cond wait PC_I hash" condition mean? I've never seen a session in this state before. I have multiple sessions that are all stuck at the same place. The statements are all called from stored procedures. The last one executing (spil_send_…
Alarm for New virtual shared memory segment
Hello, I was wondering if there is any way for Informix to alert us if it "Dynamically allocated new virtual shared memory segment". I tried getting the ALARMPROGRAM to alert, though it seems that this action does not trigger the ALARMPROGRAM. Any ideas? 16:17:26 Requested s…
951: Incorrect password or user informix is not kn
Hi, I forgot to mention that, on this instance i can connect with an unix user other than 'informix'. Doesn't this alleviates the assumption of 'a lack of shared memory or a problem with shared memory' ? Regards…
Buffer Waiting ( onstat -l )
The number of times that threads (sessions) had to wait to obtain a buffer. It's measure of system concurrency.…
how to get session-id ?!
If I have thousands of sessions in if66 , I don't know which session connect if88 through session 40 , All I know is that session 40 of if88 is the session which application connect to if66 and then run sql like "select * from stores@if88:customer" , I want to find out which sess…
IDS 9.40 on windows stops working
Hi all, We now have installed IDS 9.40 on Windows XP. When I put connect the standalone pc on a network, the database engine does not respond anymore. I need to do a restart of the service to work with the engine again. I have the same situation when I started our application wi…
IDS 10.00 maximum concurrent sessions
Hi Art, Thanks for your quick respose. We are using shared memory connections . Also noted that there is no limit for the concurrent sessions. My issue is i want to control the number of sessions, i.e. maximum number of concurrent sessions. Say for ex i dont want the maximum num…
Change Lock Mode For Session
Hi All, Is there any way to force a particular lock mode on a informix session? I have a client app connecting to my database with lock mode set to not wait. This lack of a short wait can cause issues with a locking due to a manual process I'm running over the data currently…
Network Buffer Pools
IDS 11.50.FC5 AIX 5.3 For HDR replication between two AIX 5.3 servers, is there a suggested value for the following environment parameters: 1. IFX_NETBUF_PVTPOOL_SIZE 2. IFX_NETBUF_SIZE 3. Sqlhosts option b (client buffer size) The primary has 64GB of memory while the second…
shared memory parameters
Having trouble with share memory parameters. I am trying to locate each piece of the memory size number reported by "onstat -". So far I have been able to correlate changes in onconfig with changes in that onstat number. However, I haven't been able to get it all and can't seem t…
2 shared memory segments
Informix 10.00.HC5 HP-UX 11i v2 Recently, I've started getting message like the following when I restart the server Could not create single shared memory segment with resident and non-resident partitions. Proceeding to create 2 shared memory segments instead. Sometimes, the se…
Get Session Env variables
How can I get/monitor session environment variable information from the Database? We are using IDS 11.50.FC4. Specifically, I would like to see which DBSPACETEMP a session is using based on what that particular application sets it to. --Dave…
How to secure ODBC connection
Sorry. You cannot encrypt ODBC. For internal systems you can restrict access to your company's internal network or use your company's network hardware to do encryption. For both internal and external (i.e. internet) you can encrypt with something like SSL, ssh or sftp. -L.S.…
shared memory not initialized for INFORMIXSERVER
When I try to start Informix Dynamix Server the following massage appears: shared memory not initialized for INFORMIXSERVER Any idea???…
shered memory not initialized for INFORMIXSERVER
When I am trying to start informix server the following massage apears: shared memory not initialized for INFORMIXSERVER Any idea??????…
how to check defunct processes/session
One way is to look at the reads and writes column in the onstat -u over a period of time for each session (the session id can be grepped out of the onstat -u output). If you find a session whose reads and writes are not incrementing it could be hung. MM…
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
shared memory not initializing
Hi All, Can anybody help me. My shared memory not initializing and IDS was working fine before restore and restored was failed in the middle. I have executed oncheck -pr and getting below error. ONCONFIG config file error on element PHYSFILE. Value in reserved page: 30000 Val…
mutex dbs_partn and pt_170003
Did you check the mutex locks with "onstat -g lmx" and get the session id what is locking it??…
Table accessed
I am pretty sure that version of Informix has the onstat utility. When a session connects to the database look at the output from onstat -g sql, locate the session id of the connected user and then run onstat -g sql <session id>. If the user is accessing a table it will show up t…
Lock table overflow
Can anybody let me know why we got this error below and their resolutions. We are using IDS 7.13 running on HP-UNIX 10.01. 16:04:08 Lock table overflow - user id 6012, session id 5214 16:04:08 Lock table overflow - user id 6012, session id 5214 16:04:08 Lock table overflow - use…
shared memory not initialized for INFORMIXSERVER
________________________________ From: Tang, Wally, CTR, DMA-Riv/IT Sent: Friday, September 18, 2009 9:28 AM To: 'ids@iiug.org' Subject: shared memory not initialized for INFORMIXSERVER Hi, On our development server (IDS 7.31.UD6 on HPUX B.11.11), when we executed dbaccess dbn…
Re: Occasional onbar log backup hangs
Hello JPM, I had onbar logs (and backups) hang almost every week. Our problem was usually that our network had brief (1 second or more) outages during the day. Since I could not get our network guys to fix it (and other issues with onbar), I got off of it. I switched to a col…
Re: Get Active Sessions
Omar, Thank you. Yes that seems to work. I just need to grep for the sqlexec and map that to onstat -u. Works well. Thank you very much. --David On Wed, Aug 12, 2009 at 3:14 PM, Omar Muñoz <omarmun@yahoo.com> wrote: > Hi. > > You obtain active threads by using onstat -g…
Get Active Sessions
Hello, Using either onstats or SQL to query sysmaster, how can I get a list of all active sessions. By active I mean sessions that are running something and don't just have an idle connection to the DB. I found scripts for killing idle sessions though none for getting active s…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
Informix virtual shared memory
We are running Informix 9.40.FC4 on HPUX-11i. For the past few weeks, we are experiencing this problem. The informix server keeps continuosuly allocating memory and never releases it back and allocates many virtual shared memory segments and finally runs out of shared memory and …
IDS instance memory
Hi, We are running 4 IDS (11.5 FC4) instances on a sun sparc machine with 8 GB physical memory. We can see the shared memory through "onstat -" command which is around 1 G. This machine is purely acting as databases server and no other application is runnig on it (like web applic…
Error sql -998 (???)
Hi , Can you able to find what is the sql last parsed in that session during onstat -g ses? rgds schillache…
Re: I am in a transaction ?? (I4GL)
To know if your current session has transaction opened use dbinfo to get your session id and : select address into waddress from sysrstcb where sid=? select bitval(flags,2) 0-No trans opened/1-The transaction is opened from systxptab where owner= waddress Best regards…
Lock mode
Is there a way to set "lock mode to wait" once for a program or does it need to be reset for every single session to the database? Is there a configuration parameter (on the database side) to set the lock mode to wait for all sessions coming to the database? Thanks ___________…
Re: Connection manager redirect
A Network error, because the client at the public network can't connect directly to the IDS server at the private network, it's for that reason we use the connection manager between them. We want to know if always the connection manager is used only to the initial connection to t…
Re: Compression overview...
Peter, There was a good session on this at the conference, by Scott Lashley. Look for it when they post the conference slides. Nick…
Informix Dynamic Server Scheduler question
Thank you for your answer! The thing is that the table contains records about particular sessions and all other sessions must be able to use them. Application's behavior depends on records in this table inserted by other applications' sessions. After a session is no longer active…
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
Re: The ultimate firewall
Obnoxio The Clown wrote: > http://obotheclown.blogspot.com/2009/02/best-hardware-firewall-in-world.html > > Wowzers! ;o) > I beg to differ http://www.cyberwalker.com/images/editorial/network-plug.jpg Is the ultimate firewall…
How to find which sessions are referencing a synonym
How to find which sessions are referencing a synonym Is it possible to know which sessions are "using" a synonym ? I use the 7.31 version The documentation indicates that "onstat -g opn" displays a list of the partitions (tables/indexes), (but no synonyms) May be another comm…
LTAPEDEV /dev/null from ON-Monitor
...or you could run 'ontape -c' for continuous log log backups; do it in a spare terminal session or use 'at now' or similar.…
-25588 error after CPU & fiber channel failure
John, See if the app can connect if it uses the network connection (carsitcp) instead of the shared memory connection. Mike…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
RE: ids connections lost to vpn
Thanks to all that replied. I agree with im_gumby's assessment: "... Or just lazy programmers assuming that when you connect to the VPN all network traffic should go through the VPN." There are some network connection settings that could be played with in the ipv4/ipv6 area. I j…
Network errors appear in online.log
Hello again! We have several errors appearing in online.log, and we don´t know how we could debug them, or fix. ----------------------------------- The first number is error: -25580 System error occurred in network function Is there any log we could analyse to track this problem…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
virtual portion memory size
I believe that parameter can be tweaked in '/etc/system' and is called 'shmmax' >From /usr/include/sys/shm.h: /* * Shared Memory information structure */ struct shminfo { int shmmax, /* max shared memory segment size */ shmmin, /* min shared memory segment size */ shmmni, /*…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
The max size of BUFFERS in IDS9.40FC7 at Solaris?
That is means the maxsize of share memory segment is limited to 4GB... OK,Thanks all!…
what is using tmp dbspace ?
Is there a way to tell what session is using the tmp dbspaces ? Thanks, floyd…
Network connection is broken
Hello, Im having an error while attempting to execute a command dbschema on an instance of IDS - 9.40.FC2 on aix 5.2., it displays the following message: netuno:/desenv/hotel/htsp>dbschema -d system -t cmp_cmpotp DBSCHEMA Schema Utility INFORMIX-SQL Version 9.40.FC2 Copyright…
ER backing up on network
Version: Informix Dynamic Server 2000 Version 9.21.UC5XF Yes, we are in the plans with our 3rd party vendor responsible for upgrades to upgrade to 10, finally. However.... we are running ER between a server in Denver and a server in Dallas. Both are rs6000, one runs AIX 4.3, the…
Re: hadr checks
a network glitch that attached the SAN to DB2 as well as Informix secondary *may* have caused a corrupted page on the DB2 side. so i wanted to see if there were further check on informix hadr.…
Failed to grant minimum permission requests.
Hi Shesh, thanks for your response,already there is fulltrust permission,and already have network permissions too.pls suggest ...…
The pioneering personals site that revolutionized online dating, with nearly million members-Millionaire!{$500K-$2M/year} A friend network, blogs, chatrooms and much more.
The pioneering personals site that revolutionized online dating, with nearly million members-Millionaire!{$500K-$2M/year} A friend network, blogs, chatrooms and much more. http://arealtgp.servik.com/Millionaire.htm…
what is holding the log in this session
I have a session that is running stuff from ec code in an ids10 non logged database. I know that at the beginning of the program, some indexes are created, and lots of inserts happen to a table. This is a batch process that takes over 24 hours to run. It has continued to abort wi…
Ip for a network session
Is there a reasonable way to get the source ip address for all network connected session? I don't see an onstat option that looks obvious for this. -- -------------------------------------------- Chris Salch Programmer/Analyst LeTourneau University…
RE: Monitor sessions
I think it's great that you're putting together a script to do this sort of thing. I think Paul is absolutely right, you need some commentary so that it doesn't take more than 10 seconds to understand. I would also highly recommend NOT using onstat for this sort of thing. The …
Re: Monitor sessions
On Jan 16, 11:22 am, mohitanch...@gmail.com wrote: > On Jan 16, 10:10 am, mohitanch...@gmail.com wrote: > > > > > On Jan 16, 5:29 am, scottishpoet <drybur...@yahoo.com> wrote: > > > > On Jan 16, 12:43 am, mohitanch...@gmail.com wrote: > > > > > Version: IDS 10 > > > > > I am tryi…
What is IPA abbreviation ?
Hi all IBM INFORMIX DYNAMIC SERVER 10.00 PRODUCT RELEASE bug_number 168928 description WITH NON-DEFAULT PAGE SIZE AND ACTIVE IPA'S, TABLE LEVEL RESTORES FAIL product_code ONUTILS component_code ARCHECKR What is IPA ? Thanks…
Monitor sessions
Version: IDS 10 I am trying to write a script that will find out those threads or sessions that are stuck at particular step for more than x mts. It could be stuck to acquire a lock on a resouce, or waiting for buffer or checkpoint or using lot of logical logs or may be just run…
IDS10 ODBC
Tried this. I got a "conection refused". May be the Express Edition did'nt allow connections from the network ?…
Re: Counting Sessions
On Dec 4, 2:04 pm, Nog <n...@gfm.co.uk> wrote: > On Dec 4, 12:23 pm, "Art S. Kagel" <art.ka...@gmail.com> wrote: > > > > > On Dec 4, 7:14 am, Nog <n...@gfm.co.uk> wrote: > > > > Hi, > > > > I'm Using IDS V10.00.UC5 on SUSE linux. > > > > I want to keep a count the number of sessi…
Counting Sessions
Hi, I'm Using IDS V10.00.UC5 on SUSE linux. I want to keep a count the number of sessions occurring hourly/daily on my instance. I was using a cron script to execute the following sql and store the result hourly; select DBINFO('sessionid') from systables where tabid = 99; Th…
Update from Digital 7.31.FD1to ....
Baan IV run not on the same machine and connect to the informix server with an 1GB crossoverethernetcable. so we use not Shared Memory to access the database!…
What is ids11 new function RSS for?
The HDR primary sometimes waits for a response from the secondary (for example after a checkpoint) so can suffer if there are network latency issues With RSS the primary does not wait for response from the secondary so these soort of network issues do not affect the performance …
Networker and Informix
People, We are currently implementing Legato Networker to backup our Informix instances. From the testing performed it seems that the process that backups up the logical logs is taking around 25 seconds to backup a 2Mb log file. From the initial diagnosis it seems that Informix …
Re: Informix Session Information
Marco Greco wrote: > Dave wrote: >> Hello, We have the following situation. Our 4GL developers have a need >> to identify and save in a variable the current session isolation >> level. If the isolation level is not "dirty read" they would set it >> to dirty read. Then they woul…
Re: Informix Session Information
Informix DBA wrote: > Marco, > > I completely agree you are 100% correct and yes I did get the 4 million > lines of code speech. Though, I am just doing my part to try and help out. > > If you have any other solutions/ideas, please let me know. > > -- David > Informix DBA > …
Re: Informix Session Information
Marco, I completely agree you are 100% correct and yes I did get the 4 million lines of code speech. Though, I am just doing my part to try and help out. If you have any other solutions/ideas, please let me know. -- David Informix DBA in4mixdba@gmail.com On 10/16/07, M…
Informix Session Information
Hello, We have the following situation. Our 4GL developers have a need to identify and save in a variable the current session isolation level. If the isolation level is not "dirty read" they would set it to dirty read. Then they would execute some lines of code. As a final step…
Re: Network connection is broken
On Jul 9, 9:52 am, "LoicPhil" <l...@nospam.org> wrote: > Hi, > > I'm experiencing a strange issue with my Informix server. > > When I try to connect from a PHP script, I get the error > "(-25582) Network connection is broken". > > There is no problem on the network though, the se…
Re: informix connection interrupt within 10 seconds
I want to know what network problem caused the connection to drop.Are there any settings on OS or informix can cause this problem?…
shared memory limitations
Hi folks does someone know what are the maximum shared memory size that can be used both in IDS9 and IDS10 Thanks…
informix connection interrupt within 10 seconds
On Aug 22, 4:14 am, starduo...@gmail.com wrote: > WINSQL reported error like this:Error: System error occurred in > network function. (State:S1000, Native Code: FFFF9C14). FFFF9C14 maps to the integer -25580 which is the Informix error: > finderr -25580 -25580 System error oc…
shared memory already exists
I am using IDS 9.40, I get message informix log below, after I shutdown and take offline the database: 14:38:05 IBM Informix Dynamic Server Started. 14:38:05 shmget: [EEXIST][17]: key 52564801: shared memory already exists 14:38:05 mt_shm_init: can't create resident segment Cou…
Re: shared memory not initialized
Tom I may have missed this in the variety of posts ! but do i understand this is a new installation and has never run? If so have you actually initialised the engine (oninit -i) at any time? Keith On 13/08/07, Ogiwara Tsutomu <tsutomu_ogiwara@hotmail.com> wrote: > Hi Tom. > > …
Re: shared memory not initialized
Thanks Andreas, The system is resolving the host name fine. uname -n reports informix. when i ping informix, i get a reply from the correct IP, 192.168.26.66 Still no luck Tom On Aug 9, 4:55 am, Andreas Breitfeld <abrei...@de.ibm.com> wrote: > Maybe my hint regarding the 'set…
RE: shared memory not initialized
You didn't need to run oninit -v the second time, the first time (oninit -ivy) was enough. The second time around it tries to pop memory back in the same place as the last one. Check if the first one is still running: onstat - It probably is. If not, then you may have corrup…
RE: shared memory not initialized
The holy trinity is ONCONFIG, sqlhosts and /etc/services. Your entries look ok at this point - sounds like your rootdbs either does not exist or has wrong ownership/permissions (previous note). You also need environment variables: INFORMIXSERVER=informixserver (in your case) ON…
shared memory not initialized
I have just installed Informix 10 on a CentOS 4.5 system. When I run oninit -v to start the dbserver, I get the following, and then it dumps me back to bash: [root@informix informix]# oninit -v Your evaluation license will expire on 2007-10-30 00:00:00 Checking group membershi…
ODBC to Solaris 10
Test connection was NOT successful.[Informix][Informix ODBC Driver][Informix] System Error occurred in network function. This is the error return from the test ODBC. What could possibly be the problem.…
Network connection is broken
Hi, I'm experiencing a strange issue with my Informix server. When I try to connect from a PHP script, I get the error "(-25582) Network connection is broken". There is no problem on the network though, the server correctly receives the connection from the client, the request …
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Network Connection is broken
we got ID 10 FC4 on solaris 10, suddenly we notice the above message in the log, and the connections are becoming very slow.... can anyone please help..... regards...…
IDS 10.0 and Legato Networker
We just upgraded from IDS 7.31 to IDS 10.0 We backup the database with Legato Networker 7.2.2 and the Networker Module for Informix 2.0. We noticed the backup failing when the dbspace backup was complete and it tried to backup the logical logs. 2007-06-04 11:48:45 541 11050 /inf…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
how to fix the error "hpkaioaddseg: ASYNC_ADDSEG.
OK, it happen as Andreas Kutsche says. - enough memory/swapspace/shared memory available, enough segments available the IDS allocates a lots of segments,so the error act.…
Re: KILL SESSIONS
Couldn't one just do an onstat -k and find which sessions are having a shared lock on the database and kill those ? For me, yea, bounce the engine is the quickest, but just for sake of argument.... ======================== -<<Floyd Wellershaus>>- Database Administrator Unix Adm…
Re: KILL SESSIONS
On 13/04/07, Drazen Kruhek <drazen.kruhek@trgocentar.com> wrote: > something without restarting engine? > why informix didn't have options onmode -z all or something? > ----- Original Message ----- > From: "Keith Simmons" <smiley73@googlemail.com> > Newsgroups: comp.databases.inf…
KILL SESSIONS
How to kill all sessions in one time on IDS 9.4! I doing dbexport database ,but some sesionss is active(user is not end a aplication) so i can't do dbexport.…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
querying sysmaster to get last sql executed
Hi all, Does anyone know how to get current or last sql sentence execute by a session? I know that onstat -g ses <session id> shows it, but I want to get it trough sysmaster. is it possible? Regards…
Available Immediately ( Siebel, C/C++ Unix, Network Engineer, QA Tester)
Hi, Following 4 consultants are available immediately with Us: 1) Manish Shukla / Siebel 2) Khalid Ansari / C/C++ Unix 3) Rubeel / Network engineer 4) Bhaskar / QA Tester Thanks & Regards Sudin 402 218 2179 sudin@kraftware.com…
shared memory already exists
HI, guys, AIX5.3 , IDS UC5 If we see the following problem, the only way is to turn off/on the power? informix@otto $ oninit oninit: Fatal error in shared memory creation informix@otto $ informix@otto $ onstat -m *** WARNING: IBM Informix Dynamic Server is no longer running. …
Rogue user session
Hi, Informix Dynamic Server Version 7.31.UD7, solaris 8 I've got a rogue user session connected to my instance that I need to remove, if possible without bouncing the engine. snippet frm onstat -u 4ef13618 T--P--- 32885750 userxyz console 539f5f5c 0 0 0 0 4ef1d618 T--…
IDS is busy all the time
Hi Bodgan, Yes, I am sure. The session was started at 09:27, last access was 09:33, which mets the crash timepoint. No locks. According to onstat -g sql, the session does nothing. In onstat -g ses, I can see that the session is not connected to any DB, but has two memory pools. …
shared memory
In our IDS 7.31 server, onstat -g seg displays seven 'V's (Memory Segments). SHMVIRTSIZE 100000 SHMADD 100000 SHMTOTAL 0 At present 6th "V" is in use and one is free. Each memory segment is quickly getting exhausted. Why its getting utilised very quickly im running update stat…
Re: ISQL install problem
Hi Clive, I do have an unlimited shared memory connection, but am not sure of any others - is there a way that I can check this? Thanks Andy…
shared memory and tempdb spaces
I'm pretty new to Informix and AIX and have a bit of a problem. The Informix log is showing the error "out of shared memory segments". From the other posts I've figured that we've hit the 2GB SHM limit and are probably going to move to the 64bit platform, but in the meantime I'…
RE: Network receive failed
Thanks, I will try both these options (increasing nettype, and the reply from ("big potato"?) - running 1 shm pollthread) :-) -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of hariog@yahoo.com Sent: 17 November …
RE: Network receive failed
Hi, I have a problem at a clients machine, where we are getting a lot of these messages in the online.log 13:52:41 listener-thread: err = -25587: oserr = 0: errstr = : Network receive failed. They are all connecting directly to the server, and using shared memory connections. …
Network receive failed
Hi, I have a problem at a clients machine, where we are getting a lot of these messages in the online.log 13:52:41 listener-thread: err = -25587: oserr = 0: errstr = : Network receive failed. They are all connecting directly to the server, and using shared memory connections. …
informix help
but if the 2 PCs are at different network, how should i do the connection?…
Re: Odd network error message
I once experienced a kind of network attack with similar consequences. Check the network logs. "Neil Truby" <neil.truby@ardenta.com> wrote in message news:4nuov3Fc7kt4U1@individual.net... > On every Informix server on the subnet - dev, test, production, doesn't > matter - we've …
Odd network error message
On every Informix server on the subnet - dev, test, production, doesn't matter - we've been getting this message for a day or two. Any ideas what it means?: 08:33:30 listener-thread: err = -25580: oserr = 104: errstr = : System error occurred in network function. System error…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
Number of Active user sessions
Hello, How can I query the sysmaster SMI tables to get the number of "Active" user sessions. I know that I can get the total number of user sessions from syssessions. However, I would like the "Active" sessions. Thank you in advance, Have a great day... TGIF... Dave In4Mix…
Shared Memory
HI,I hava a problem. /home/informix/etc>onstat - Informix Dynamic Server Version 9.30.UC4 -- On-Line -- Up 103 days 05:37:36 -- 269068 Kbytes How does it is calculate for "269068 Kbytes" ? tks…
RE: Contiguous shared memory segment allocation failed at 0xd0000000
SHMBASE is different in your config from standard - why? How much shared memory is allocated to this instance (onstat -g seg) ? How many locks do you need for this process (16:10:23 dynamically allocated 100000 locks) ? OR you could lock the table. You need to configure LOCK…
Contiguous shared memory segment allocation failed at 0xd0000000
I was doing a mass update, delete ( big transaction) and found the info in online log, 16:10:21 Maximum server connections 21 16:10:23 Requested shared memory segment size rounded from 8604KB to 8608KB 16:10:23 Contiguous shared memory segment allocation failed at 0xd0000000.…
Contiguous shared memory segment allocation failed
I was doing a mass update, delete ( big transaction) and found the info in online log, 16:10:21 Maximum server connections 21 16:10:23 Requested shared memory segment size rounded from 8604KB to 8608KB 16:10:23 Contiguous shared memory segment allocation failed at 0xd0000000. Al…
shared memory not initialized for INFORMIXSERVER
Greetings all- I'm looking for a nudge in the right direction for an issue I'm having. I'm running IDS 7.31.UD3 on W2k Server SP4. localhost name is cognos INFORMIXSERVER=data_archive I am working at the console of just the server. (not connecting via network) I am getting an …
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
onstat shared memory error
I am running INFORMIX IDS9.40 on Slackware 10.1 and everything works fine except that informix cannot run onstat due to the shared memory: permission denied error. The database chunks reside on a smart array disk system, so I did a raw /dev/raw/raw1 /dev/cciss/c0d0p3 so I woul…
Update statistics and shared memory
We are not exactly sure what our problem is, but any help would be greatly appreciated. We are running IDS 7.31.UD3-1 on AIX 4.3.3. We have been experiencing a problem for a number of years, but it had not been one that has caused us any major problems untill recently. Here is t…
Restore and network down problem
I loaded informix and did a restore of the ontape backup (ontape -r). but I get the error of networkdown after the restore was done. When I restored I did not recreate the database I only created the chunks and dbspaces. Did i do something wrong here? here are the results and s…
Informix Network down error
I loaded informix and did a restore of the ontape backup. but I get the error of networkdown after the restore was done. When I restored I did not recreate the database I only created the chunks and dbspaces. Did i do something wrong here? here are the results and settings I hav…
Network down
I getting this error "network down" when I use on monitor. I am using informix 7.31 on HP UX 11.11. What could be the problem. I have checked the sqlhosts file and it is ok.…
UNIX/Windows network security
I have two different Informix instances running in two separate machines in the same network: One in UNIX and another in Windows: 1st machine: -------------- OS: SCO UNIX hostname: thasos Informix DS 9.21, server name: ol_aegean user: akin Database dbakin $ cat /etc/hosts.equiv…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: shared memory segment size
The resident portion of shared memory depends on # of BUFFERS + # of LOCKS + LOGBUFF + PHYSBUFF + some SHM headers for more details - http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.admin.doc/admin276.htm Regards, Nilesh Friday, May 05, 2006 10:31…
shared memory segment size
Why has my shared memory segment this size? This is the output from onstat -g seg Segment Summary: id key addr size ovhd class blkused blkfree 36 1384138753 a000000 1613758464 266640 R 393773 211 37 1384138754 6a…
Re: Two child process having different process id but the same session id - Possible?
i have already tried using DISCONNECT ALL before to no avail, but i did you're suggestion of checking the parent's session after sql_detach is called and amazingly it happens that the parent's session is still active after sql_detach and when the child connects it sometimes (rare…
RE: PRINTING OVER THE NETWORK
sorry: remsh is not an internal or external command in WINDOWS Willaert Doris <Doris.Willaert@alcopa2wheels.com> escribi�: LET p_pipe = "remsh remote_machine lp -dlpt1 -s" START REPORT report_name TO PIPE p_pipe --------------------------------- From: informix-…
RE: PRINTING OVER THE NETWORK
LET p_pipe = "remsh remote_machine lp -dlpt1 -s" START REPORT report_name TO PIPE p_pipe ________________________________ From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Luis Carlos Díaz Otero Sent: woensdag 19 april 2006 17:06 To: …
PRINTING OVER THE NETWORK
Sorry if it looks like a newbie or dumb question. I have a WINDOWS XP network. If i want to print on my local printer i do: START REPORT report_name TO PRINTER or, if i have the report in a file, i do: PRINT /d:printer_device filename Where printer_device may …
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
number of pages read during sequential scans
I think the following could work: * Establish two sessions in a special test program to the IDS: One is the test session which executes a query, fetches data etc., the other session watches the data for the test session in sysmaster:syssesprof. * The te…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: MaxConnect
Shouldn't network poll threads run in NET VP's?…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
RE: Track a session to a Buffer
Hi Zev. You mean the following ? Userthreads address flags sessid user tty wait c000000007c17338 B--PR-- 175155 testdb - c000000000e104b8 If this is correct, probably btscanner is holding buffer. onstat -b -> onstat -g ath -- Tsutomu Ogiwara fro…
Re: Track a session to a Buffer
onstat -b/-B/-X would be your friends.…
Track a session to a Buffer
Hi All, I just had a case where onstat -u returned a 'B' as the first flag in the second column for over 100 sessions. The wait column for all the sessions had the same hex number. Is it possible to track down the session that is causing all the others to wait? I tried onstat…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
DBDATE format issues
Make sure the session that creates the stored procedure or does update statistics on the stored procedure has the correct DBDATE setting.…
Shared Memory challenge on AIX 5.1
One of my sites has 1 Gbyte of RAM. I have configured them to use 512Mbytes of Virtual Shared Memory and about 256 Mbytes of Resident Share Memory. RESIDENT is set to 0. During normal processing everything is OK with those settings. Occasionally the size of the virtual shared m…
How to get ip address of client ?
If the ip doesn't resolve to a name then the number given in onstat -g ses (?) is the Hex Ip address smitin@gmail.com wrote: > Ok, I forgot to mention "ip address of a client" in the body of my > message. If I know session id, and I want to get ip address for that > session -…
Re: HDR over secondary network
Andreas Legner wrote: > Hmmm ... if two networks are used, srvB and srvB-sync would resolve to different ip addresses, > similar would be true for srvA and srvA-sync, wouldn't it? > Correct. The machines are on two networks. as srvA and srvB they have IP addresses such as X.X.…
HDR over secondary network
HPUX machines, Informix 9.4 We have a primary database server, srvA, and a server we want to use HDR to back the database up to, srvB. Both machines are on our primary network, as well as a sync network, where they have a different set of IP addresses (which are identified in…
Enterprise Replication, hour syncronization
NTP (Network Time Proctol) is your friend!…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
temp table existence
Is there a way to tell which session owns it?…
Re: IDS 7.30 do not start - NT
Your server only has 512M of memory. Check you onconfig parms and reduce the number of buffers, SHMVIRTSIZE, locks etc to reduce the amount of share memory requested, then start your server. Good luck, Brian >Hello, > >i have a problem with the informix database. It is on WIN …
Re: Network Driver Cannot Open Network Device!!
Hi, I think you are somehow running out of some system resource. However, I'm not sure it is due to kernel parameters. As you are on Solaris, I assume you use TLI (protocol ontlitcp in sqlhosts file). TLI errno 8 simpy means "System error" - which is not very much help. Errno …
Network Driver Cannot Open Network Device!!
Hi, In no particular pattern, i get this error, and the only way out is to reboot the server (and take downtime), which is not good. It could happen after several monhts, or several days. 16:56:11 NSF putlocal: t_open error: t_errno = 8, errno = 12. 16:56:11 listener-thread:…
Network Driver Cannot Open Network Device!!
Hi, In no particular pattern, i get this error, and the only way out is to reboot the server (and take downtime), which is not good. It could happen after several monhts, or several days. 16:56:11 NSF putlocal: t_open error: t_errno = 8, errno = 12. 16:56:11 listener-thread:…
Shared Memory not Initialized for INFORMIXSERVER on Informix IDS 7.31
For more informatio in my Log file appears: 09:23:21 (3) failure, system out of semaphores 09:23:21 Dynamically allocated new message shared memory segment (size 352KB) 09:23:21 Requested shared memory segment size rounded from 344KB to 352KB 09:23:21 Requested shared memory seg…
Thread network information (onstat -g ntu) header
Header from output onstat -g ntu : Individual thread network information (basic): netscb type thread name sid fd poll reads writes q-nrm q-pvt q-exp Explain 'read' and 'writes' fields ? There are in Kb, network buffers or other ?…
unable to attach to shared memory
Hi All, Tech Specs: IDS 7.31.FD7 O/S - Solaris 5.8 Generic_117350-26 sun4u sparc SUNW,Sun-Fire oncheck and onmonitor are giving errors: shmat: [22]: operating system error Unable to attach to shared memory. onstat -g seg gives Informix Dynamic Server Version 7.31.FD7 …
Shared Memory Permission Denied
Hi, when i execute onstat with informix user send this message: onstat: = Shared memory: permission denied. or when i go into onmonitor and sel. an option send the message: Unable to attach to shared memory. Permission denied Informix IDS 7.31.UD3 Unix, Solaris 5.6 thanks in a…
Onbar with Legato Networker
Does anyone have experience with using Legato Networker as the storage manager for onbar? In particular, we want to write the data to disk devices not tape. Our IT guys aren't much help but they suggested that we might need an add on module to be able to use disk devices. BTW thi…
SESSION ID ?
Hi, I have many applications that connects to the Informix Engine quite often. I would like to track the session id of a specific application that updates a specific table ( say employee. ). This sid will be used to capture information from syssessions table. ( hostname and proe…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
set session authorization
hello everyone! just wanted to find out one thing ... :-) when you do set session authorization... where do all the rights stay??? in what tables or views??? it should be somewhere ...…
Latch waits
I'm seeing quite a highish level of latch waits (lchwaits) - whats the best way to reduce this? Increase the shared memory?…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
Informix and legato networker
I am installing Legato networker with a Informix 7.31 TD1 system. The Informix database exists with a Microsoft cluster running on a pair of Windows 2000 Advanced servers. All seems to be configured Ok and it backs up ok both the Level 0 backups as well as the logical logs. Wha…
Re: Network Down
Did you ever figure out why you were getting network down message? We have benn running our database for three years and just recently we get this message. It happens only a few times a week. ONSTAT looks okay. Just ONMONITOR gets this message and applications can not access the …
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
RE: WARNING: Network Down / Error Writing to network
Are you using the correct settings as mentioned in the release notes ( tcp / ipc) ? Is this a new installation of an in place upgrade ? -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Geezer From The Freezer Sent: …
RE: WARNING: Network Down / Error Writing to network
I would download the current verions (UD8) and install that. UC4 is quite old. MW > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org] On Behalf Of Geezer > From The Freezer > Sent: Thursday, 28 April 2005 2:21 a.m. > To: in…
WARNING: Network Down / Error Writing to network
Just installed Informix 7.31UC4 on Solaris and when running onmonitor I get WARNING: Network Down Any idea how to get around this problem. Help would be most appreciated.…
When is sql statement cleared from sysmaster
When is the sql statement cleared from sysmaster? I am doing onstat -g ses and onstat -g sql for a session and there is no sql statement shown. Does that mean that this session has never run an sql statement? I am particularly interested as I have a web application front-ending…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
Re: Informix 7.23 connection problem
Obnoxio The Chav wrote: > Cristoff said: > >>There is no chanse for upgrading. The system just close any next >>connection. After some time it blocks the network card. We have NETTYPE >>set up, but it probably needs initialisation. > > > What do you mean "blocks the network card"…
RE: Informix 7.23 connection problem
There is no chanse for upgrading. The system just close any next connection. After some time it blocks the network card. We have NETTYPE set up, but it probably needs initialisation.…
Re: Network Error??
Randy, I agree with Clive, the error message clealrly indicates that there is something wrong with your network setup. I would ask the SA to do a thorough check up of the network setup. On Tue, 18 Jan 2005 19:49:37 +0000, Clive Eisen <clive@serendipita.com> wrote: > Kennedy, Ra…
Network Error??
IDS 9.40FC3 HP-UX hp9ux3 B.11.11 U 9000/800 (ta) Trying to track down the root cause of these errors: 14:36:53 listener-thread: err = -25580: oserr = 232: errstr = : System error occurred in network function. System error = 232. 14:37:59 listener-thread: err = -25573: oserr =…
RE: Session's memory
> -----Original Message----- > From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On > Behalf Of rotor > Subject: RE: Session's memory > > > Hi, rotor (Leonid ?) > Yes, I am. :-) [AS] Nice to see You.. > > > onstat -g afr SESSION_ID > Don't understand what I…
RE: Session's memory
> Hi, rotor (Leonid ?) Yes, I am. :-) > onstat -g afr SESSION_ID Don't understand what I can see here. > There is a chance that that the memory leak is caused by > the server bug... Not sure. This is IDS 7.31.TD6 - from my expirience stable enough. > the application doesn't de…
Re: Session's memory
> your "Current statement name" > is indicating this as the number in your [cursor] "name" keeps an > increasing order. Yes, I see. Does the "Current statement name" is cursor name really? -- ���������� �������� ���� ������������ http://webmail.delfi.lv sending to informix-list…
RE: Session's memory
Hi, rotor (Leonid ?) The first thing to do is to investigate the session's memory structure using onstat -g afr SESSION_ID There is a chance that that the memory leak is caused by the server bug... but I'm quite sure that memory leak is caused by the VERY poor application desi…
Re: Session's memory
rotor wrote: > Hi community! > Who knows in which circumstances server allocates memory for a > session? I have 'onstat -g ses 183 -r 1' output during 10 minutes. I > don't see any criminal there. Except one - memory. It grows up to 400 > Mb per 10 min! 20 sessions like this one…
MT_EX_OS
Hello, Can someone help me with the following problem ? IBM Informix Dynamic Server Version 7.31.UD8 -- On-Line -- Up 01:58:29 -- 245760 Kbytes 09:49:44 Exception Recursion while handling: MT_EX_OS, Context: mem 09:59:44 VP Notify mechanism incomplete after 5 minutes. Th…
Resolution for '-25557 Network internal error'
'-25557 Network internal error' is resolved by adding this to the Path environment variable : C:\\Program Files\\Informix\\Connect\\bin sending to informix-list…
-25557 Network internal error
Hello, When a user tries to connect through PowerBuilder 10 to Informix 9 he gets an error 25557. Description of the error is -25557 Network internal error. If this internal error recurs, please note all circumstances and contact Informix Technical Support. I-Login test work…
Re: shared memory weirdness
Ian Spare wrote: >We're running a very old version of HPUX and Informix, the system will >shortly be retired so we're limping along for a short time. > >We're running out of shared memory though and it's killing the database, >to an extent it's something we're going to have live…
shared memory weirdness
We're running a very old version of HPUX and Informix, the system will shortly be retired so we're limping along for a short time. We're running out of shared memory though and it's killing the database, to an extent it's something we're going to have live with but something puz…
Error numbers 25572,25574, 27001
Hi We are currently using Informix Dynamic Server Version 7.31.UC4 on Unix SysV R4 MPRAS. We keep getting frequent Informix freezes on our server caused by the error numbers 25572,25574, 27001. In this state connections to the application fail: listener-thread: err = -25572: os…
SQL Session Problem
We have recently upgrade our servers and Informix versions from Solaris 6, IDS 7.3 to Solaris 8, IDS 9.4, ESQL 9.52 from SDK 2.80. We run an archive program every week which runs various selects on the database and then archives data. This process used to process five records ev…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
RE: Terminating a parent session...
check your "expect" script, you should be able to do this by the "send" command in the "expect" script. make sure you send an "exit" with "\\r" in the expect script. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of V…
Re: Terminating a parent session...
You may wrap the invocation to the 4gl module in a shell script, and as last instruction issue the following: kill -9 0 That will kill your processes and sign you off. -- Juan de Villeros On Thu, 23 Sep 2004 12:25:28 +0530, Vijay Kumar <rudrappa@india.hp.com> wrote: > Hi All,…
Re: Terminating a parent session...
You may wrap the invocation to the 4gl module in a shell script, and as last instruction issue the following: kill -9 0 That will kill your processes and sign you off. -- Juan de Villeros On Thu, 23 Sep 2004 12:25:28 +0530, Vijay Kumar <rudrappa@india.hp.com> wrote: > Hi All,…
Re: Terminating a parent session...
--0__=88BBE58BDFD4ED0B8f9e8a93df938690918c88BBE58BDFD4ED0B Content-type: multipart/alternative; Boundary="1__=88BBE58BDFD4ED0B8f9e8a93df938690918c88BBE58BDFD4ED0B" --1__=88BBE58BDFD4ED0B8f9e8a93df938690918c88BBE58BDFD4ED0B Content-type: text/plain; charset=US-ASCII Content-tran…
Terminating a parent session...
Hi All, We have an Informix 4gl interactive module, which when completes its execution must kill the Unix session itself. Is there any way of doing so. We are using this because we want to execute an application in a remote machine. For this expect tool executes an interactive …
RE: Slow network connection
Erwin- Another possibility might be to uninstall the server and reinstall without the domain components. The downside there is that all users must have a local account. --EEM > -----Original Message----- > From: Erwin Lotter [mailto:lotter_NO_S_PAM_@zsw-bw.de] > Sent: Frida…
Re: Slow network connection
Everett, that's a very nice idea. However, I thinks I will not be able to follow it: First, the database NT is a workstation, not a server NT. Also, our domain controller is a Win2K server. With a lot of help from Murray I found out, that the authentication at the domain takes l…
RE: Slow network connection
Erwin- You could set up the database NT box as a backup domain controller, allowing it to authenticate its own requests...If it isn't too busy otherwise. If you're running HADR, you could set the redundant server as a domain controller and hopefully, since you can't guarantee t…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Re: Slow network connection
I have to make a correction: The database does accept windows users from the domain too, but I don't need that.…
Re: Slow network connection
It seems that you are right. I have found out the following: In dbaccess, a connect takes (less than) a second, except after I have changed the user password: the first connect then takes a minute, subsequent connects take a second again. The very same happens when I start a cli…
RE: Slow network connection
This sounds like a Windows authentication problem. Where does this take place - locally or at a DNS? How many users exist in the user table - and can you reduce that list? When you dbaccess from the command line on the database server, how long does it take for the authenticat…
Slow network connection
Hi there, I'm running Informix Online V7.3 on Windows NT4 (sp3). In the beginning all worked fine, but after about 1 year I observed an extended delay when I connect to the server (via the native Informix driver that come with PowerBuilder 5) over the network from any client. In…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Session memory usage
Hi, does someone know how much memory a user session takes on a Informix database server? How many concurrent user sessions can a normal server (4 GB primary memory) handle, before connection pooling is needed? /Fredrik…
Fatal error in shared memory
Trying to set-up Informix 7.31 UC4 on Solaris 2.6 everytime I try and start informix I get oninit: Fatal error in shared memory initialization I have set SHMBASE to 0x1000000 and also tried 0x1000000 as suggested in the documentation - both fail. The system has 512Mb of RAM and…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
Which session is using the most cpu resouce?
Can I tell which session is using the most cpu resouce? I can use ps check which process or thread using the most cpu resouce. But Can I make a relationship between threads or sessions of informix and processes or threads of operate system?…
onload consuming shared memory
Hi all, we're just about to start a full database restore to recover from a failed onload session. I just want to try and determine what might have gone wrong to see if how we can do it better next time. We want to onload a table with blob data of about 300000 rows and 11GB of …
Re: MAXIMUM SESSIONS
"Hamid HABZI" <HHABZI@bmcebank.co.ma> wrote in message news:<cane4a$jtv$1@news.xmission.com>... > Hi, > How can i know what is the maximum number of sessions in a period of time. > IDS 7.31.UD6 on AIX 5.1 I use the following SQL against sysmaster: SELECT COUNT(*) FROM sysses…
RE: MAXIMUM SESSIONS
Hi Hamid. onstat -u ? -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: "Hamid HABZI" <HHABZI@bmcebank.co.ma> >To: <informix-list@iiug.org> >Subject: MAXIMUM SESSIONS >Date: Tue, 15 Jun 2004 17:46:10 -0000 > >Hi, >How can i know what is the maximum number of sessions …
MAXIMUM SESSIONS
Hi, How can i know what is the maximum number of sessions in a period of time. IDS 7.31.UD6 on AIX 5.1 Tank you for helping. sending to informix-list…
shared memory not initiaized for INFORMIXSERVER
I'm removing the indexes and recreating them in my informix database and all the onstat commands were working fine. Now all of a sudden I am seeing this error when performing any onstat commands: shared memory no initialized for INFORMIXSERVER 'informixservername' Why is this?…
onbar backup with Legato Networker
Hi, Currently, we can have manual backup of our informix instance with "onbar -b -w -L 0" on the command line and onbar sends the backup data to legato. Our problem is, if we want to start the backup from networker server, it doesn't work. It gives XBSA BSAObjestCrate error and …
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
Network Down
Hi All, I am trying to initiate a new database like I've done a few times before. To me, it looks seems OK, but when I start the server I get this message: ** WARNING: Network Down **--On-Line------- Press CTRL-W for Help. -------- I have checked the onconfig-file an /etc/serv…
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
Temp Tables
How can i know what temp tables are in my session with script...…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
OnLine Connection Error enabling/disabling the network connection
Hello, All! I've set-up a Toshiba Tecra with Win-Xp Pro running a Perl web based application on IIS and Informix OnLine 9.4: all the pieces seems work fine but if the PC is turned on without the network connection and after that I active a network connection (locale, via a netwo…
Washington Area Informix Users Group Forum 2004 - April 21, 2004
Lester Knutsen wrote: > * Mystery Sessions from DB2 development lab in Toronto Serge ?…
Shared memory and SELECT-Performance
Hi all, IDS 9.4 UC3 / RH 9 I have a performance-question: The quality of our application depends strongly on the execution-time of one single SQL-Select-Statement. Of course, the parameters in it's Where-Clause are different from time to time and from user to user, but we can u…
Sessions and Memory
IDS: 9.21.UC6 Solaris: 8 I've about 10(ish) databases all web based, all accessed via the WebBlade, one query in one of the databases is causing the engine to allocate another segment. How can the query be traced? Cheers -- Paul Watson # Oninit Ltd # G…
SHARED MEMORY LIMIT
Is posible to use with informix of 32 bits more than 2GB of shared memory in a Linux Machine? The base address in onconfig is: SHMBASE 0x41000000 Thanks in advance,…
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
RE: -25587 network receive failed
Remember that you also use tcp (network) connections on the server, to connect to Informix - check your server limits (kernel parameters), or the number of allowed connections to Informix -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
-25587 network receive failed
Aix 5.1L Informix 7.32 UD6 A night batch process keeps failing about 50% of the time, with this error: -25587 Network receive failed. Yet there is no networking involved, the process is started on our IBM pSeries 650 and ends there. The process used to work perfectly every nigh…
-25587 Network receive failed
Aix 5.1L Informix 7.32 UD6 A night batch process keeps failing about 50% of the time, with this error: -25587 Network receive failed. Yet there is no networking involved, the process is started on our IBM pSeries 650 and ends there. The process used to work perfectly every nigh…
Re: Temporary table
On Fri, 16 Jan 2004 15:44:21 -0500, Curtis Crowson wrote: > roeferr@ig.com.br (Ferronato) wrote in message > news:<df1bdeb4.0312240634.7b2ae02e@posting.google.com>... <SNIP> >> > How can I define if defined temp table exists in the current session? > > OK while we are on the sub…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
Shared memory problem
Platform : Win2000 / IDS 9.30.TC3 I get the following error when increasing the buffers. shmat [ENOMEM] [12]: out of available data space, check system MAXMEM shmdt: errno 22 mt_shm_init : can't create virtual segment. The server has 2 Gig of physical memory of which approx. 9…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
FW: Log errors - network ?
I am getting the following errors running my logical logs (continuous backup). We've been having A LOT of network problems lately, and my question is - could these also be network related ? I can only think that somehow I am getting tcp errors, and this is affecting Unix (or t…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
Temporary table
Hi! How can I define if defined temp table exists in the current session? -- Sauron…
Shared memory problem???
Environment: RH Linux 7.1 Kernel 2.4.10-ac11 Informix IDS 9.21.UC4 Dual x86 Processor 1.5 GB Memory 8 temp dbspaces, 256MB each 100 full time users during the day My Informix shared memory parameters are as follows: LOCKS 2000 # Maximum number of locks BUFFERS 180000 # Maximum …
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Sick server session
IDS 9.21 on Red Hat My client's database session is really not too well. The database server will not accept memory-type operations, such as onmode -k or onstat -F. There are also no oninit proceses running. An onstat -g seg shows single segments, but an ipcs -m shows multiple…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
Re: Shared memory. Error.
Hi. Make sure your permission of onstat and oninit like this. % ls -l $INFORMIXDIR/bin/onstat -rwxr-sr-x 1 informix informix % ls -l $INFORMIXDIR/bin/oninit -rwsr-sr-- 1 root informix I think oninit has wrong permisson. Regards. -- Tsutomu Ogiwara from Tokyo Japan. I…
RE: Shared memory. Error.
It looks like You are on Linux You can try to verify whether 'raw10' points to the correct block device: 'raw -q dev/raw/raw10' ------------------------------------------ Alexey Sonkin Senior Database Administrator > -----Original Message----- > From: inf [mailto:inf@terr.es]…
Re: Shared memory. Error.
Hi, Paul As you can see, the file /dev/raw/raw10 has the correct permissions: 0 crw-rw---- 1 informix informix 162, 10 ago 31 2002 raw10 but the error appears... Any suggestion ? "inf" <inf@terr.es> escribi� en el mensaje news:bor348$fgf$1@nsnmpen2-gest.nuria.telefonica…
Re: max number of connections
On Tue, 11 Nov 2003 12:42:00 -0500, Micha wrote: <SNIP>> We use both ontlitcp for remote connections and onipcshm for local > connections. NETTYPE is not defined in onconfig. How can nettype limit the > number of shared memory connections? AFAICT, the remote connections actually…
RE: Shared memory. Error.
You only can tell, that a link to a file has correct permissions, not a file itself Please, make 'ls -l /dev/raw/raw10' ------------------------------------------ Alexey Sonkin Senior Database Administrator > -----Original Message----- > From: inf [mailto:inf@terr.es] > Sent: …
Shared memory. Error.
Hi, - When starting informix the following error appears: 12:52:14 Informix Dynamic Server 2000 Initialized -- Shared Memory Initialized. 12:52:14 Physical Recovery Started. 12:52:14 The chunk '/home/informix/dbs/tempdbs' must have owner-ID "informix" a nd group-ID "root". 1…
WARNING: Network Down
Greetings! Trying to finish an install for IDS 9.21 on Linux but getting WARNING: Network Down message. The log shows the following entry: Get Shadow Passworkd for user [informix] faild! Check for password aging/account lock-out. listener-thread: err = -951: oserr = 0: errstr = …
Network driver bind issue
Hi, I'm having a problem starting up a database. Oninit -v shows everything starting no problem and I am brought back to the command line happily. However, onstat after that shows the shared memory is not initialized. In the log we have: listener-thread: err = -25572: oserr = 9…
Re: Server session stats
me here wrote: > > Didnt even notice. I am a bit dyslexic at the best of times. As an > aside, why is dyslexic so hard to spell?? I am sure some sadist > created that word. If a dyslexic was also cross-eyed, would they be able to read properly?…
connection problem
Hi everyone, did someone meet the following issue? We use Informix Online 5.00 UC2 on a Unix box (AT&T UNIX SYSTEM V Release 4.0). Currently only 91 users can connect to the database. Afterwards no new user can login - till someone logs out and the user can connect to the server…
Server session stats
Does anyone have any good admin queries (SQL) that can be run to report on current server stats. Simiar results to "onstat -u" I can query the syssessions view on sysmaster and have trolled the newsgroups and web for useful queries. A lot of the reporting scripts where Unix shel…
Re: Problems with Shared Memory
U r limited to 50 connections in all ... if you are using SHM connections ... are the users spawning more than one connection to the engine when they run the program ... I would suggest increasing the number of connections to say 100 to see if it works or not ... onstat -g ses a…
RE: Problems with Shared Memory
Yes, -25588. $ finderr -25588 -25588 The appl process cannot connect to the database server server-name. But it's not true because some users are connected to. No ISAM-Error associated. TIA. -----Mensaje original----- De: owner-informix-list@iiug.org [mailto:owner-informix-li…
RE: Problems with Shared Memory
4 -----Mensaje original----- De: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]En nombre de Obnoxio The Clown Enviado el: viernes 12 de septiembre de 2003 14:46 Para: informix-list@iiug.org Asunto: Re: Problems with Shared Memory Diego Morales wrote: > > >…
Problems with Shared Memory
I have problems with Shared Memory. Only 5 or 6 users can login at the same time at database using shared memory INFORMIXSERVER. All run ok changing them to tcp... but they are running a 4gl app and I want them throw INFORMIXSERVER shm. I check the sqlhosts and NETTYPE and I t…
Informx Session Id limit
Hi All We are running informix 9.21 on solaris, and have small database with 1.2GB. I observed the sessions id 260009 and keeps increasing, we had shutdown database last few days ago, but session id has been reverted back . As i am new to informix, any of u clarify my queries …
not initializing shared memory
mt_shm_remove: WARNING: may not have removed all/correct segments what do you do about that?…
Changed the IP address on an informix 9.3 machine
I changed the IP address on the informix 9.3 machine and now when I try to bring informix online it says that the network is not connected? Is there something inside of informix 9.3 that references the IP address of the machine that I need to change…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
transaction/session id in SE7.2
Hi I am using InformixSE7.2 (on linux) and have been trying to write a stored procedure which, amongst other things, gets hold of the session id. Ideally I would like the current transaction id but I haven't found out how to get hold of that! This is the first time I've used I…
Shared memory: permission denied.
Hi all, Informix Dynamic Server Version 9.40.FC1 I receice the error Shared memory: permission denied when I run onstat - and this is the output of ipcs Message Queues: T ID KEY MODE OWNER GROUP q 0 0x4190051c --rw------- root system Sh…
Remote session
Hi there. This one is about connections between servers. Imagine the following situation: In a remote node (calvin), a query is being executed, e,g,: select * from database@hobbes:table_name In local node (hobbes), its possible to find out the details of the remote (say clien…
Re: Shared Memory Problems, Informix IDS 7.31 install on SCO UnixWare 7.1.1
Thanks for all of your help. I lowered the amount of initialy reqquested shared memory and things seem to be working fine. Thanks, John M…
virtual shared memory segment
hello, this is our output from onstat -g seg : Segment Summary: id key addr size ovhd class blkused blkfree 7680 1381386241 80000000 592850944 245712 R* 144714 25 (shared) 1381386241 a3563000 201334784 6760 V 49154 0 46597 13…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
Re. Shared Memory Parameters
Hi Everyone, Which file needs to be changed on AIX 5.1(9.3 UC3) for memory parameters, is it "/etc/system" but it does not exist on unix box. SHMTOTAL is set to 0 in ONCONFIG, but the total memeory does not exceed 2GB although we have 4GB of ram, could not find any info. Any id…
Informix & Storage Area Network
Hi, I would like to have more information on Informix and SAN. We plan tyo buy a SAN solution and we want to be aware how other people do. I work with Informix 7.31FD2 How do you manage backup, mirror copy, snapshot, etc. Thanks ... And if you can refer me to any good web sit…
Database sessions!
Is there a way to close idle database sessions after a certain time?We have too many open database sessions concurrently which most of them are not used by any users anymore.And this causes additional Virtual segments because of a large session pool..I know it has to do with the …
killing a process
I have a hung informix instance. Does anyone have any info on how to kill the active sessions? tia…
EMERGENCY: Logs attached
EMERGENCY: I have a down system. I am trying to to a cold restore using command "ontape -r". The command keeps failing after prompting to back up the logs. The only error message which appears on the screen is : "oninit: Fatal error in shared memory creation". Additional error me…
linux kernel 2.4 + informix
HI ? I must setting Linux and IIF200 on DELL PowerEdge 6400 server . that server has 6Gbyes main memory, 120Gbyes hard disk. first i have install Redhat 6.2 official. and i have upgraded kernel 2.4 from kernel 2.2.16 . ( because for awaring 6Gbyes main memory at Linux) l…
How to end a user session...
Hi Listers, My question is how to end a user session once I've identified it using onstat -u? Thanks, Denmark W.…
Re: SET LOG question
Bogdan Neagu wrote: > Hi all. > > Let's say I have a database with Buffered Logging. > > I open a session and do a SET LOG; that redefines the logging mode to > unbuffered for this session only ( yes ? no ?) Only for that particular session. > > > How can I retrieve the loggin…
SET LOG question
Hi all. Let's say I have a database with Buffered Logging. I open a session and do a SET LOG; that redefines the logging mode to unbuffered for this session only ( yes ? no ?) How can I retrieve the logging mode of the session ? Does the server write imediatelly the transacti…
-25574 Network driver cannot open the network device
-25574 Network driver cannot open the network device I'm getting the above on with Informix 7.31 UC5 on a SCO 505 server. What seems to have caused this is an increase in the number of users. Where would I start for increasing something in the onconfig file? Thanks Gary Quir…
Shared Memory
Hi all, I need help on how to identify what process and users trying to allocate more shared memory segments (onstat -g seg) ? and how to releases this memory segment (virtual portion) ? TQ…
how to find how many user connected to database a day
Thanh Ngo wrote: > > Hi all, > 'onstat -g ses' show me who is currently connecting to > server. Is there a way I can count how many users were > connecting to server in a day or so? > > Any help would be appreciated. Record, daily, the max session id from onstat -g ses and subtr…
Database is on line ,but has warnings
WARNING: Network Down **--Recovery------- Press CTRL-W for Help. ------ Why? thank you Sent via Deja.com http://www.deja.com/ Before you buy.…
SID of a temporary table
> Is there any way to retrieve the ID of the session in which a temporary > table was created from another session? Thanks…
SID of a temporary table
Is there any way to retrieve the ID of the session in which a temporary table was created?…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
SHMAT error
Oncheck allocates a shared memory segment for sorting memory. If your kernel's shared memory parameters are too small you can get that error. Art S. Kagel "Sinha, Niraj" wrote: > > Folks, > I get following error while running oncheck comand. > I knwo that it is UNIXsystem erro…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Re: logical logs
Assuming it's a long transaction use: onstat -x The session with a "R" in it's flag list is the session rolling back, and therefore the session that generated your long transaction. -FPL >>> Aboobacker V V <aboo@syd-co.au.dhl.com> 08/31/00 08:16PM >>> Hi all, How to find out…
logical logs
Hi all, How to find out which session causing the logical logs to fill up. Regards Aboo…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
Session begin time
Hi All, How to identify the start time of a session. Plese help. Regards Aboo…
Informix 7.31 and Windows2000
Somebody has installed it on Windows 2000 ? The Instance Manager can't initialize shared memory.. Thanks in advance. -=SIMO=-…
SCO IPC
OK - I've RTFMed, but still in need of help. I am running SCO Unix 5.0.{245}, with Informix IDS.2000 Dynamic Server. Trying to initialize shared memory does not appear to work. The system utility "ipcs" does not report any shared memory being allocated, and the oninit -i seems…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
change of server made network problems
Hello again, I have some informix network problems. I moved my Informix ON-Line Dynamic Server to another Server (diferent host and IP), and when I startup the server, it starts OK, but says this: ** WARNING: Network Down **--On-Line--- So I have no network connections. I chan…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
Mystery Session
Hi, Under the IECC console in IDS 7.3 for NT, when there is only one user accessing the database, under sessions the user name of the client is displayed and another client, which looks like this: < (� Has anybody else experienced this? or know what it is??? /Kirk…
ERROR: -25574: Network driver cannot open the network.
Hello, Server: SCO Open Server 5.0.2 256 MB Ram Online 7.22 UC2 10:54:55 NSF putlocal: t_open error: t_errno = 8, errno = 6. 10:54:55 listener-thread: err = -25574: Network driver cannot open the network. Thanks in advance.…
Fatal error in shared memory creation
When I type oninit, it said: Fatal error in shared memory creation Why ? Thanks…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
Shared Memory segment (5 of them)
Hi gurus, Recently, I noticed 5 extra shared memory segments created in my Informix 7.30 UC7. What could have caused this and how to remove/prevent these segments from created again? AFAIK, more shared memory segments means less efficient shared memory usage. Am I right? Thank …
Consultants - FREE Zero Impact Sql & Service Level Monitor
> "It does this on a separate box - the network must be configured such > that it can see all the packets" > > Neil, don't you contradict yourself? Everything has some cost. Nothing > comes for nothing. It is zero impact on SQL Server and any other device on the network. There…
Open database
Is Informix an open database? * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
Re: oninit -v
From: "Stefansson" <bs@rhi.hi.is> > >oninit -v >returns an error: >Allocating and attaching to shared memory...FAILED >onint: Fatal error in shared memory creation > >What can be causing this and what could be able to solve this problem ? It could be something holding on to shar…
Error 25574
Hello everybody ! During execution of an ESQL/C program I've got the following error code: -25574 Network driver cannot open the network device. A system call has failed. See the UNIX system administrator for assistance. Does anyone know anything about this bug ? Regards Ry…
oninit -v
oninit -v returns an error: Allocating and attaching to shared memory...FAILED onint: Fatal error in shared memory creation What can be causing this and what could be able to solve this problem ? Thanks. B. Stefansson…
Problems with RedHat Linux 6.0 and IDS 7.30
Hi, I'm novice in Linux and after installing the IDS 7.30 on a RedHat 6.0 machine when the IDS try to create the shared memory i got a list with messgaes like this: dupfd: fd 1025 max 1024 finally i got the message: error on shared memory creation. Where I can find information …
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
Trace utility similar to Oracle's
there are many ways to look at a session; look at onstat -g ses <session id> for starters. if you do onstat -g sql you will see a list of session id's and the databases they use. another interesting way is to use xtree, if you can open it in an xterm client. this gives you a pic…
Serials and Stored procedures
Rob Wilson <rwilson@ntsource.com> wrote in message news:m7Vq4.886$Mn3.7118@newsfeed.slurp.net... > When you use DBINFO, you will get the last serial value from _your_ > session. Even if other people have made inserts after this session's, > you will have the correct number. Exc…
onstat -g con
we're running Informix 7.3 on HP-UX 11 when I run onstat -g con (show threads which are waiting on something) I see "netnorm" as the condition being waited for. This is documented as meaning "thread waiting for a request to be placed in network queue". Is this normal? Is tha…
System catalogue
Sounds like HDR to me. * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!…
Re: Session id
Jaroslaw select dbinfo('sessionid') from systables where tabid = 1; HTH Sujit Jaroslaw Pulkiewicz <pulkiewi@quantum.de> on 01/09/2000 12:49:34 PM Please respond to Jaroslaw Pulkiewicz <pulkiewi@quantum.de> To: informix-list@iiug.org cc: Subject: Session id Hi, How to re…
Session id
Hi, How to retrieve the ID of the current session from within SPL ? Regards. Jaroslaw Pulkiewicz…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
IECC - no sessions
Hi I have IDS 7.30 on solaris 2.6. When I start the IECC 3.00 TC1 I see databases, dataspaces, table,.. - but I don`t see open sessions. What`s wrong ??…
network down error
We have a new installation of 7.24.UC5X7 on an IBM S80 and when we get around 100 users connected new users cannot connect to the database. Onmonitor gives the error "Network Down". When you check shared memory with onstat it says that shared memory is not initialized but when yo…
HELP- database won't start !!
Informix error is 25572, os err 227. Network driver cannot bind a name to a port.... Any assistance is appreciated.…
RE: accessing shared memory
Hi John, You need to change permissions to shared mode (s) for necessary executables in $INFORMIXDIR/bin directory. thanks Ravi Yarlagadda Informix Certified Professional -----Original Message----- From: John Horton [mailto:john.horton@cognito.co.uk] Sent: Tuesday, December 14…
accessing shared memory
Hi How do I set up a user so that they can access shared memory (ie. they can use the onstat - command) . Currently only root can access shared memory (not even informix can access shared memory or use the onstat - command) I have tried stting up the group so that informix is a …
shared memory problems
Hi I am having some difficulty getting some programs to work on a linux box (they are being ported from an HP9000) The problem I am (currently) having is that one of the processes requires shared memory to be allocated. The program requests two loads of shared memory , the first …
i.star information needed
tqma@my-deja.com wrote: > > A search for 'i.star' on informix.com did not show up anything. > Where can I find information about this feature of IDS-7.3, please. IStar and INet were the Informix server and client networking products for Online 4 & 5 engines. The IDS 6/7/8/9 pro…
Re: SQL running on unix
current * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Network Appliance
Anyone have any experience/comments on using Informix with Network Appliance file servers? They have software called SnapMirror (replication) and SnapRestore (data recovery) that keeps versions of disk pages. Has anyone used this with an Informix DB? Christopher A. Franks Senio…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
disconnect session
Hi, I have informix dbs 7.30 on solaris 2.6. How can I disconnect a user session ?…
disconnect user
Hi, I have informix dbs 7.30 on solaris 2.6. How can I disconnect a user session ?…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
shared memory
Beim Start mit oninit erscheint folgende Fehlermeldung 21:00:20 shmget: [EEXIST][17]: key 52564801: shared memory already exists 21:00:20 mt_shm_init: can't create resident segment Was fehlt noch bei der Einstellung ? Wer kann mir helfen…
Re: NetWorker
From: thopper@imsn.net > >I am looking for a way (script? command?) to shutdown Informix before a >NetWorker backup and startup Informix after the backup is completed. I >see in the man pages a command "savepnpc." Would I use this? If so, Why do you want to shut Informix down…
RE: NetWorker
Tiffany Are you trying to back up the Informix chunks? Do you know whether you could ever restore and re-use these files (in all circumstances) ? There are several choices, but at some sites we do: 1. An Informix archive to disk 2. Backup the archive file, not the chunks. M…
NetWorker
Hi, I am looking for a way (script? command?) to shutdown Informix before a NetWorker backup and startup Informix after the backup is completed. I see in the man pages a command "savepnpc." Would I use this? If so, how do I implement this. My supervisor is thinking that a cr…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
onSNMP?
An interface daemon to SNMP (Simple Network Management Protocol) tools so that they can monitor IDS servers. Art S. Kagel Top Cat wrote: > > What is onSNMP?…
strange session
When i start IDS7.30.FC7 on HP 11: oninit -s into quiescent mode, my logfile shows: 07:18:39 Quiescent Mode 07:18:39 Checkpoint Completed: duration was 1 seconds. 07:19:01 (20) connection rejected - no calls allowed for sqlexec 07:19:01 listener-thread: err = -27002: oserr…
IECC - no users shown
I have a IDS 7.30 on OS solaris 2.6. When I open the IECC I don`t see the sessions. With onstat -g ses the sessions are shown. I brought the IDS down, and started new. Who can help ?…
RE: Fatal error in shared memory creation
Check the release notes for SHMBASE parameter value. Try to start Informix with SHMBASE value 0 -----Original Message----- From: Jerome BARRET [SMTP:jejgphy@hotmail.com] Sent: 06 ������, 1999 06:43 � To: informix-list@iiug.org Subject: Fatal error in shared memory creation…
Fatal error in shared memory creation
When I want to startup for the first time, in the oninit program, this message appears : "Fatal error in shared memory creation". In the part shared memory parameter, the parameter are the default parameters. Thank you for your help…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
How many memory is a session used ?
Dear ALL : Is there a way to monitor the memory usage of every session ? I mean, how can I determine which session used the maximum amount memory ? Thank for any answer and suggestion. I use Informix Online Dynamic Server 7.22UC3 on HP-UX 10.20. Jung-Hui Cheng cheng@dbtel.com.t…
Dynamically allocated new shared memory segment ???!!!
Dear ALL : Our system appear the following messages in seconds : 09:11:02 dynamically allocated new shared memory segment (size 8388608) 09:11:30 dynamically allocated new shared memory segment (size 8388608) 09:11:50 dynamically allocated new shared memory segment (size 8…
Shared memory limits in 64-bit environment
Is there any practical shared memory limits in HP/UX 11 (N-serie) with 64-bit Informix ?. -Jukka…
Loading into Shared Memory...
Hi, Can i explicitly ask Informix to load a table into Shared-Memory? And then later on sync the copy of table on disk \\ with the one in shared memory? Any suggetions welcome Thanks Anand Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
error 951
Hi guys, When trying to connect to a network server from a client, I get an error 951. any ideas would help. I'm sure that the user name i'm using is correct, and I can access the server and database without any problems from the console through the network port.…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
SCO: shared memory problem...
Hello, I am having a problem that, hopefully, one of you have had before, or have heard about before. There box is a PII system with 128MB RAM running SCO OpenServer 5.0.5 with the latest patches. The error oninit -v gives: oninit: Fatal error in shared memory creation The er…
error while creating online instance
While creating a new online instance using "oninit -ivy", this is the following error message that we get. Creating infos file "/usr/informix/etc/.infos.kil_serv3" ... succeeded Writing to infos file ... succeeded oninit: Fatal error in shared memory creation We have created in…
Network problems with IDS 7.3 and Linux Kernel 2.2.x
The network connection works fine with Kernel 2.0.36. So if you don't need to use Kernel 2.2.x ... Harald Raffelt…
Usage of INFORMIXSHMBASE
It replaces, or supplants, the SHMBASE ONCONFIG file parameter's value. It is the preferred attached address for shared memory if you are using a shared memory connection. Art S. Kagel Wu wrote: > > What's the usage of this environment variable -> INFORMIXSHMBASE ? > > thanx…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Re: running out of Unix Shared memory segments
You may want to check how many shared memory segments are allocated to Informix and other programs; use the unix command "ipcs". If you normally have many Informix segments you could change the onconfig file parameters for SHMADD and the initial shared memory parameter to increa…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
Shared Memory on Linux
How do I configure Redhat Linux to get rid of the Shared Memory Error when I try to start Informix (IDS 7.3)? Thanks. Aris…
how to caculate resident shared memory size?
hi,all could you tell me how to caculate resident shared memory size? thank you.…
Timeout
We use a centralized IDS 7.30.TC2 server to keep information on our customers. When a customer enters a remote site, which have IWS 7.30.TC3 servers, the data is retrieved from the central site if it is newer than the data on the local server. Because some of our sites are in r…
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
Re: ZERO Impact Performance Monitor for Informix BETA program
> C.1 The functionality for the monitoring of a SHARED MEMORY CONNECTION > when the SQL was issued across the network (e.g. telnet session) will be > available next week. Okay, but wouldn't this also work for a network connection for a telnet session also? What relevance does …
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
Shared Memory
I have a question about the shared memory segments Informix adds dynamically in version 7.x. I use onmode -F to free the unused shared memory but this seems to only ever free up one segment regardless of how much is unused. Has anybody used this to free more than one segme…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Informix error.
Does anyone know what this error is about: shmat: [EINVAL][22]: shared memory base address illegal Thanks, Fred Lee…
IECC over a dialup connection
I'm trying to use IECC over a dial-up connection, and cannot seem to connect to the server. When I'm directly connected to the network, I can connect to the server fine, but when dialed in to the network, I can't seem to see the server(s) (but I know they are there, and accessabl…
networking databases
Hi I am developing a database ith Access 97.However I need to network it but have no idea about how to do this. Someone told me it was easier to use Visual Basic as a front end and network it from there, and I have also heard about going through the ODBC. I have absolutely no ide…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
test - please ignore
This is a test. Please ignore Sujata -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: matching sessions with databases
If you do an onstat -g sql, there is a column that tells you which database each session is connected to. So you could do an "onstat -g sql | grep <db>" to see which sessions are accessing a particular database. Sean Gilmour wrote in message <3655FF8E.AC274878@css.mot.com>... >…
Re: matching sessions with databases
Hi Nicole, If you run a onstat -g ses # of the session id at the bottom it will tell you the current database for that session id. Nicole Guffey wrote: > Is there a utility, or a piece of code, that identifies which > database (or even dbspace) a session is accessing? > > …
matching sessions with databases
Is there a utility, or a piece of code, that identifies which database (or even dbspace) a session is accessing? Thank You, Nicole Guffey Nguffey@jdriscoll.com…
Re: Warning:Network down
In article <72vbgc$n1l$1@nnrp1.dejanews.com>, huesing@my-dejanews.com wrote: > Hallo! > We try to create a new chunk by using onmonitor. > When onmonitor starts up a warning appears: Network down > The create fails with "no permissions to write to network or user unknown on > t…
Informix Warning: network down/no permission
H1 Environment:SOLARIS 5.6 --INFORMIX 7.3 we try to create a new chunk by using onmonitor. When onmonitor starts up a warning appears:network down. The create fails with :no permission to write to network or user unknown . Is someone able to help us or is there any idea?? Thank…
Warning:Network down
Hallo! We try to create a new chunk by using onmonitor. When onmonitor starts up a warning appears: Network down The create fails with "no permissions to write to network or user unknown on the database server" There are no problems with oninit and dbaccess (creating tables etc) …
warning:network down
Hallo! We try to create an new chunk by using onmonitor. When onmonitor starts up a warning appears : network down The create fails with "no permission to write to network or user unknown. Our environment is SOLARIS 5.6 -Informix Online 7.3 with oninit and dbaccess there are no p…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Extracting a viewable tif image from a BLOB?
I wish to get a tif image from a BLOB field to a location on a shared drive so that others on the network can view it from their PC's. Any suggestions? Thanks, Rolly Vipond FBS…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Triggering-Question
Hello! I want to call a 4GL-Programm from a trigger. Is there a way to do this? Bye Andy M. Bettin -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Cost of Sessions
Hello. Does anyone have or know where I can information on the cost of creating a database session? We're using ODS 7.22.UC1 on Solaris 2.5.1 using ESQL/C. I'm interested in for time-to-create, memory usage, cpu usage, etc... Thanks! -- Joseph Kormann jkormann@mcs.mds.lmco.com …
merging 2 databases
Hello Version 5.06.UC2 of Informix Is it possible to merge an exported database with a running informix database and not have any data be lost? Thanks Steve Nolan Bay Networks…
Shared Memory ??
--------------F10AFCC198D69640B04B5FAB Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello! I just installed the Informix OnLine Workgroup Server 7.20 in Sun Sparc 5 with solaris 2.5.1, but when I try to run some utilities (e.g. onspaces, oninit) it…
Session Timeout
Dear All, Greetings. If the user terminal is not active (idle) for a certain period and is = not running any process (like batch updating) and so forth, how do I use = the OS to kill the inactive user session. Basically, I would need a UNIX script to accomplish that but my cur…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Re: dbservername/dbserveraliases/nettype
"Scott Kolaya" <skolay1@nycap.rr.com> offerred: +>BTW be careful to not use the same port for shared memory and tcp in +>the sqlhosts on the server > +>Art S. Kagel +We've been using the same port for shared memory and tcp for a year now in +production. Yes, shared memory connec…
shared memory
This is a multi-part message in MIME format. --------------F12A58D21005157C74BAD832 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit hello; how do i go about initalizing shared memory for informix 7.2 on a sun? --------------F12A58D21005157C74BAD8…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
sid <--> tid
Hi everyone. How I can determine, to what user session (sid) belongs thread ( tid ) Thanks. Serg…
How to get the current sid !
How can I get the current Informix-session-id within an current session ? We use Informix Online 7.2 Thanks Rene Kursawe…
Oninit sessions
I am in the process of doing some system related research. I was wondering what is the typical number of VPs that would be defined on a production node? Do the number of servers also relate to the number of VPs being defined? Many thanks. -Ken.…
oninit sessions
Does anybody know what the aproximate number of oninit sessions should be under normal operating conditions for Informix 7.2. I am asking because I have 28 oninit processes running on our Sun-Ultra and I am worried that something got corrupted on our machine after a hard crash th…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Re: Informix 7.22 Online under AIX 4.1 ERRORS !!!!!
>> shmat: [EINVAL][22]:shared memory base adress illegal >> using 0xd0000000, needs 0xffffffff >> >From onconfig : >SHMBASE 0x30000000 c Shared memory base address PMFJI, but isn't this the important one? The machine specific release notes detail the correct share…
Re: DB 7.21 (HP-UX 10.20) hangs while backup
if RESIDENT is set to 1 the shared memory used by informix will not be swapped to disk by UNIX if UNIX needs more memory. It's generally not a good idea to set to 1 if you're having problems or you're limited on memory. Scott Kolaya…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
Network driver cannot open the network device
We are testing client/server applications with INFORMIX-4GL Version 6.05.UD1 and INFORMIX-OnLine Version 7.12.UC5 on DG/UX R3.10. We can use dbaccess from client to access server database. Therefore we believe INFORMIXSERVER/DIR,PATH, sqlhosts, services and hosts.equiv are set u…
online workgroup server 7.22 on NT Server CLI probs
I'm running online workgroup server 7.22 on NT server 4 with service pack 3. I cant however get ilogin to work. I get the 406 error. Do I need to do anthing with shared memory before this will work? How does shared memory work with NT? email to ag@roninsrv.demon.co.uk Thanks, …
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
-123 ISAM error : no shared memory ... TOP URGENT !!!!!
How to solve Shared Memory can't attach error in AIX 3.X ... Error Message was appeared after run dbaccess ... -529 Cannot attach to shared memory -123 ISAM error : no shared memory. Please send me a solution : brianip@magician.com.hk…
can't attach shared memory , TOP URGENT !!!
How to solve Shared Memory can't attach error in AIX 3.X ... Error Message was appeared after run dbaccess ... -529 Cannot attach to shared memory -123 ISAM error : no shared memory.…
Detecting cursors in OnLine 7.x
Is there a way to see how many cursors a particular session id has open in ODS 7.23? -- Scott Kolaya kolaya@acmenet.net…
Re: Trusted user question
Mark Check your hosts.equiv file? Go strangle your network administrator until he gets his certification...... Could be a combo subnet mask and router problem. ---------- Stan the baby DBA…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Re: memory
Thuc Nguyen wrote: > > Hi > > I am running Online 7.23 on HP 10.20 > > We want to find out why we allocate alot of memory per user and never > release it. > > Is that memory leak? Actually you are probably not allocating any memory "per user". If your default connection, or the…
SPL glob var. set from outside session
Hi, is it possible to set a global SPL variable from outside the session in which it applies ? tnx -Peter Groarke…
Isolation Level
Hi. How can I know the current isolation level for a session? Thanks.…
Re: Informix Online 5.0 and Solaris 2.5
>"Shared memory not initailzed" does (necessarily) imply a problem with >the UNIX server's shared memory; This first line should have read ".... does not (necessarily imply a problem ...." Also, I've checked my release files and your shared memory settings seem fine. Neil Trub…
Transaction Id/ Connection Id
Hello, With Informix Ver7.xx It is possible to have multiple connections/sessions to the Informix online server in the same process. Within each such connection to the database we can have a transaction, Thus we can have more than one transaction within a DB server. For each s…
Re: memory
In article <5v76b7$pg0@cssun.mathcs.emory.edu>, Thuc Nguyen <thucn@email.utcourts.gov> writes >I looked at the log file of Online 7.23 running on HP 10.20 > >What does "dynamically allocated new shared memory segment" mean? >and how can I resolve that problem? > > >14:57:23 Chec…
memory
I looked at the log file of Online 7.23 running on HP 10.20 What does "dynamically allocated new shared memory segment" mean? and how can I resolve that problem? 14:57:23 Checkpoint Completed: duration was 2 seconds. 14:57:43 dynamically allocated new shared memory segment …
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
Username for this session
Hello, I am involved in a LiveWirePro application with OWS 7.12TC5. In a particular Insert statement, one of the fields is the name of the user who is currently performing the Insert operation. Is there a variable in Informix like Oracle has "userid" which holds this value and …
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Network connection.,,
Hello all, I'm trying to connect to a INFORMIX-OnLine Version 7.12.UC1 (online dynamic server) with a esql/c application (INFORMIX-ESQL Version 7.12.UC1). I have doubled-checked the sqlhosts files, onconfig, hosts.equiv, hosts files, and restarted the database engine, only to ge…
Informix access through firewall
I have the following set up for my WEB. external network NT 4.0 running IIS ----firewall------ middle network NT 4.0 internal network running HPUX 9.0 Informix 5 My informix database resides on the internal network and I need to get my Informix infomation to/from the WEB. I wo…
orphan sessions in ODS 7.2
Greetings... Does anybody out there know a way to identify orphan sessions in a 7.2 engine? Andy…
Re: Shared Memory allocation error
<SNIP> > I am having a problem with online ver 7.10.UD1 running on AIX 4.1.4.0. > When I run a query on a view that joins many tables online begins > allocating additional shared memory until it hits an illegal address. <SNIP> > SHMVIRTSIZE 8000 # initial virtual…
Shared Memory allocation error
All: I am having a problem with online ver 7.10.UD1 running on AIX 4.1.4.0. When I run a query on a view that joins many tables online begins allocating additional shared memory until it hits an illegal address. At this time the query hangs but the engine stays up. If anyone c…
Re: Backup tools
Mr Cheuk Kong Lo wrote: > > Can anyone give me some input on the 3rd party backup tools? > We are considering to use Networker on our AIX+Informix (7.12) > server. In particular, how does Datatools' SQL BackTrack, > Networker and On-Bar (Informix 7.2x, we may upgrade soon) compar…
Shared memory
My director told me that Digital dialed into our Unix box (AT&T running Informix 5.05) and saw that every sqlturbo is getting 5000 pages of memory. Does anyone know if this set in the tbconfig file? I can't find any information about this. If I can reduce this, it may benefit …
Informix ODS 7.21 online backup - beta code available
All, The evaluation beta for BusinesSuite Module for Informix, version 1.1 (beta) is now available on Legato's web site, under www.legato.com/forms (see NetWorker beta programs). BusinesSuite Module for Informix -------------------------------- * online backup for Informix ODS …
Legato Networker Backup?
Does anyone use Legato Networker to backup Informix? Have you had any problems? What issues did you face? MO…
Shared Virtual Memory Question/Engine Shutdown
Our project site recently received a binary executable from a sister site which updated approximately 5000 stored procedures. The executable brought down the engine due to shared memory limitations. When looking at the data (onconfig, memory on machine, etc. as stated below), t…
Re: shmdt: errno = 22
Double check the shared memory parameters Informix suggests for 7.12 for your kernel. Good Luck, Arun…
Solved: Please help: OWS don' trust me...(NT 3,51 OL 7.12)
So, don't ever let this to be different: Program manager - Control Panel - Network - Computer name = xxxx and Program manager - Control Panel - Network - TCP/IP protocol - DNS - Host Name = yyyy Thanks to everyone. Andrej…
Re: HELP I'm in crisis
You need to avoid dynamic shared memory segments on HP at all costs. If your SHMVERTSIZE is 60000, I would suspect that would be enough. However, if your application is leaving a lot of open statements (i.e. not issueing a FREE on a prepared statement or CURSOR) then each user t…
Shared memory
I guess i missed some previous discussion about shared memory problems. I'll appreciatesome info about the followinfg error message: "Cannot attach shared memmory" from the Rapid Developement System, Informix 4GL V4.10 under AIX. Ramiro Rela.…
MS-Access - Informix 5.0
Please recommend an (easy to set up) ODBC software to link MS-Access 2.0 under WfW3.11 to an Informix 5.0 DB under Unix. Network Protocol is TCP/IP. Thanks - Hartmuth…
Re: initializing shared memory
} From: Gene Terry Sanford <tsanford@csti-md.com> } Subject: initializing shared memory } } We are runnning informix 4.1 on SCO OpenSever 5.02. } When we run tbinit to initialize shared memory we get } the following error: } } tbinit: shmat[EINVAL][22]: shared memory base addres…
initializing shared memory
We are runnning informix 4.1 on SCO OpenSever 5.02. When we run tbinit to initialize shared memory we get the following error: tbinit: shmat[EINVAL][22]: shared memory base address illegal using 0x80480000, needs 0x80000000 tbinit: fatal error in shared memory creation. Our…
Re: Shared Memory Not released
>Brian Li <cphdcbl@ted.cs.depaul.edu> wrote in article ><511nel$aft@shrike.depaul.edu>... >> >> Dear Informix experts, >> >> We are currently have Informix Dynamic Online running on our HP T500 >machine >> and recently have shared memory problem which is only known to be solved …
>1 Virtual Shared Memory Segment slow down
I've been told by Informix that having >1 virtual shared memory segment slows down your Informix Online Database server. Informix normally has 3 share memory segments 1 Fixed size 'Resident' shared memory segment for disk cache etc. 1 Fixed size 'Message' shared…
Test - don't read
This is a test of the emergency broadcast network.…
Re: ARCHIVE SID?
kosovali wrote: > I've got also this message when i try to retrieve an archvie from another server : error 1191 Need a transit vset for a network request. I'm lost with all that stuff!!…
ifmxload
Does anyone have any idea what ifmxload or ifmxload.dat does? I have this running on 5.0...I've never heard of it before. Tks.. -- ---------------------------------------------------------------------------- Ed Bidinotto bidinott@ucar.edu BIS Network…
IFMXLD
Does anyone know what ifmxld does in 5.0 or what the ifmxld.dat file is? Tks in advance.. Ed -- ---------------------------------------------------------------------------- Ed Bidinotto bidinott@ucar.edu BIS Network Mgr (…
ontape, Networker and Solaris
Has anyone used Legato's idtasm software module to automate informix archiving using Legato Networker software? I have downloaded the idtasm software and would like pointers on installing it. jake@surf.com…
SHARED MEMORY
Hi All When doing kernel performance tuning for a Informix 5.0 system with 512MB memory and 50GB disk, should the the shared memory be included into the kernel parameter tuning or excluded. Watching the memory use with 'cpqmon' it appears that these calculations should be done …
SHARED MEMORY
Hi All When doing kernel performance tuning for a Informix 5.0 system with 512MB memory and 50GB disk, should the the shared memory be included into the kernel parameter tuning or excluded. Watching the memory use with 'cpqmon' it appears that these calculations should be done …
Re: SHARED MEMORY
At 12:36 PM 6/19/96 -0700, Paul Middleton wrote: >When doing kernel performance tuning for a Informix 5.0 system with 512MB >memory and 50GB disk, should the the shared memory be included into the >kernel parameter tuning or excluded. > >Watching the memory use with 'cpqmon' it a…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: Panic!: SCO OpenServer can't trap INTERRUPT from dbaccess
I believe that you can solve this problem by installing the SCO maintenance patch for OpenServer 5.0. Good luck! Christos Liacouras Transaction Network Services, Inc.…
Test Message
This is a test message -- Dave Harding __________________________ TRIVIUM Project BBC Network Radio __________________________ HARDID02@bh.bbc.co.uk…
Re: Loading tables in Shared Memory
peeyush wrote: > > Hi, > > I need to know how to load some of the frequently used tables (like master > reference tables which are accessed very frequently) into SHARED MEMORY. By > loading them into shared memory, they permanently reside there until they > are unloaded, and the …
Re: Loading tables in Shared Memory
peeyush (peeyush@toj.com) wrote: : Hi, : I need to know how to load some of the frequently used tables (like master : reference tables which are accessed very frequently) into SHARED MEMORY. By : loading them into shared memory, they permanently reside there until they : are unl…
Re: Q: Does ESQL/C require a local engine?
> I would like to install ESQL/C on a system without a local engine. > However, OnLine 7.10 will reside on the network. Can I do this? Should be no problem...…
Q: Does ESQL/C require a local engine?
I would like to install ESQL/C on a system without a local engine. However, OnLine 7.10 will reside on the network. Can I do this? Thanks. Edwin Babadaglian edwinb@panix.com…
Technical databases
I am a PC analyst with great intrest in my trade,networking and computer security can anywone tell me what database resorces there are available to someone with such interests or point me in the right direction? Please respond to Matthew_Pritchard@bendnet.com…
NewEra run on OS/2 win-os2 ?
Can run NewEra on OS/2 win-os2 Session ?…
Slow screen redraws with VT220/FTP
Are you sure that this is not a network problem ?? Have you tried with other termcap settings ?? -- Terry Boyland…
Re: RE: NewEra on Windows 95
There are some networking issues with Win 95 that we are trying to resolve to get NewEra 2.0 supported on Win95 and WinNT before the 3.0 release. Stay tuned.…
Error -25574 on Informix 7.1
Has anyone seen error -25574 "Network driver cannot open the network drive" on informix 7.1? Any suggestions would be helpful. Reply to matts@iqsc.com.…
informix app on network
We are considering an application package that is written with informix and are wondering if it will run on a Lantastic network? Has anyone had experience with informix on a lantastic peer-to-peer or on the new lantastic dedicated server?…
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
Re: report writer(generator)
try IQ for WIndows...simple to use.... requires a network solution at this time character based version scheduled for near future…
NewEra
Does anyone know if NewEra will run under Win/OS2 session in OS/2? Thanks…
REPLIICATION VENDORS
Does anyone know the current state of replication technology? Who has products, and what engines/networks/platforms they support, and whatever other interesting info that is current? Please also reply to (mkhomo@mcs.com)…
Re: OnLine shared memory question
>From: res@din.lois.perm.su (Igor G. Popov) >Subject: OnLine shared memory question >Date: Fri, 28 Oct 94 16:55:07 +0600 >X-Informix-List-Id: <news.9512> >When I attempt to increase BUFFERS value in tbconfig, >initializing fail and print message: >tbinit: shmat[EINV…
Re: NFS mounted database
Why use a NFS mounted database when all the database vendors have perfectly good networking products to allow you to perform the same function. NFS is definitely not the right way to go here and I am not surprised it isn't supported. NFS is a Networked File System not a Networked…
Tuxedo Mailing List
I can't subscribe the "Tuxedo Mailing List", because it isn't prossible to get the network adress of imc.com. If somebody is reading this mail, who has access to the wanted list, please send me the network - address or help me to sign on. heimo Bergler Heimo Ungerdorf 116 A-820…
<No Subject Supplied>
Does anyone know of any front end products that will allow the retreival of info from an Oracle database and bring it back to an Informix database in a clent-server relationship over a network?…
Re: ODBC with Oracle and Informix on the same server.
> To clarify this and my other posting I have been informed that the > Visionware product is actually two products. They have an ODBC > product and a network transport product, sold independently, but which > can work together. The network transport product replaces the > datab…
Re: Online and Shared memory
ywleung@ouray.denver.colorado.edu (YIU WAH LEUNG) writes: >I went into a theoretical discussion with my workmate on how Informix handles >shared memory that is defined by using tbmonitor/Parameter/Shared memory. >He said that the size of the shared memory that defined in Informi…
network security
We have a system set up with two RS/6000s, one as our database server and one as a "software server". Our users rexec a command from their PCs to run our application on the latter machine. We run I-Net and I-Star for the communications between the machines. The users have to h…
QUEL query language
Are there any QUEL references available on the network, or any books availableon the subject?…
distributed data base issue
I wonder if informix can manipulate a distributed data base in network? Or, can informix be able to place on file server and can have a several desktop computers linked to file server via lan? RonS…
Re: Bizzare sqlerror codes
In article <8817@emory.mathcs.emory.edu>, patrice@mediatech.COM (Patrice Badger) writes: |> -46 Protocol family not supported |> I don't even have error -46 |> in my Informix manual. What is it? That's because it's a Unix error that's just being passed on by Info…
Help me, BLOBbers
(This is a refinement of a previously submitted question:) I have a '386 running Unix and On-Line. Networked to this host, I have some PCs with VGA monitors. The network soft is TCP/IP. I'll run network terminals (with telnet) on the PCs, and then I'll trig a pro…