Oninit® Archive
Results for “onstat -b”
script to check status of dbspaces & chunks
Thanks Kagel & Parker It worked for me but i can't query the sysmaster db if temporary dbspaces got corrupted/down/inconsistent I got the following error while running query on sysmaster 229: Could not open or create a temporary file. -bash-3.00$ onstat -d IBM Informix Dynami…
Large memory segment vs smaller ones
Hi Dennis. Yes: " vmo -p -o v_pinshm=1". You must have RESIDENT 2 or more for large pages as they must be pinned. The "rsam" pool is in the dynamic segment. You need RESIDENT 2 or more. It doesn't sound like the problem is with the buffer pool but the "rsam" pool. Your BTR is fin…
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…
What prevents a RSS to roll forward as fast as its primary?
David, (a) I was checking `onstat -l | grep C-` while the replica lagging, it showed almost same values as `onstat -g rss verbose`. (b) Could the apply contention be an issue if a single thread performs 99.99% of apply job when lagging? ------------------------------ Sincerely, D…
Buffer wait occurs when performing INSERT in multiple sessions
Hello All, In my customer's system, a buffer wait often occurs when an INSERT statement is performed on the same table in multiple sessions. In that case, there are about 1000 sessions with the first flag value of B in the onstat -u command. And the online log file shows the mess…
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 …
ontape -l show 100% full logs but ontape -a doesn't flush them
Arjen: Not to worry. As long as that 'B' is in the third flag position the log is available to be reused when it's turn comes up. The first flag position is 'A' for a newly added log, then it goes to 'F' once the server has been archived after adding a new log, then to 'U' where …
Index page size recommendations
16 k for indices is a good starting point. After that is depends on the data. If I am using TS then I would tend to have dedicate spaces as well. And yes you need a buffer pool for each page size. Paul Watson Oninit LLC +1-913-387-7529 www.oninit.com Oninit® is a registered trade…
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…
Problem with backup
Original post: Hello, every time we release a copy with onbar , the Database server gets blocked one to three minutes. Is this normal ? Our version is 12.10.FC3WE and the command is onbar -b -w Thank Response: The answer is possibly. At the start of every backup, the server…
output from onstat -x
Hi all onstat -x shows the running transactions. What does the following output mean? See the decreasing negative times at the end of the rows and the increasing number of locks. Also the flags (A-B----). What is implied? Are we running in a Long Transaction? B40DBS0S-db1:/home…
Bufferpool configuration
Hi informix community, on a SPARC M10-1 Server we have a informix 12.10FC10 instance. Currently this instace use a buffer pool with around 7GB. Now i have the chance to configure the buffers up to 40GB. I would like to use the following configuration of the buffer pool: BUFFER…
BUFFERPOOL Configuration
Oh, one more reason to use multiple page size buffer pools: - To be able to isolate the IOs against some objects from those of other objects so that, for example, index IO activity does not flush data pages from the cache.…
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.…
Waiting for Next Logical Log File to be Freed
I'm stuck and I can't bring my database up: [informix@slnxstmaibfsbfp01 ~]$ onstat - IBM Informix Dynamic Server Version 11.70.FC4 -- Fast Recovery (CKPT REQ) -- Up 00:06:08 -- 250712 Kbytes Blocked:CKPT DYNAMIC_LOG [informix@slnxstmaibfsbfp01 ~]$ onstat -d IBM Informix Dynami…
Informix 12.1 Blocking Checkpoints
> On 7 Nov 2017, at 10:48, NATYURAL HORACIO <horacio.natyural@gmail.com> wrote: > > Hi, > > > Based on the current workload, the physical log might be too small > to accommodate the time it takes to flush the buffer pool during > checkpoint processing. The server might block tran…
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…
identify what is allocating memory
original post: Hi , How identify what/who is consuming memory in a specific virtual memory segment ? With onstat -g ses , there is no session with high memory allocated. The amount of users sessions is keeping at regular average... No buffers pool was allocated automatically (I…
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…
Buffer pools in 11.50.FC5
IDS 11.50.FC5 Solaris 10 Sparc I need some guidance on BUFFERPOOL. I am receiving the 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 threads. I am not sure how that translat…
Move tables to another dbspace
Thank's We had performance issues in the same hour two times a day almost everyday, when is the most users sessions. The cpu goes to top, and we identify with onstat -u | egrep B--P a lot of sessions waiting for a resource, all in the same address, like this 402f086d8 B--PX-- 2…
Waits in database
Greetings I have a degradation in a IDS 11.50. With onstat -u I detect a lot of waits in a resource, but I cant identity wich user causes this The output is: /informix/ids1150 [casiopea2] (informix): onstat -u | egrep 1440 2bdde5ba8 B--PX-- 944923 masiste - 1440e1440 0 0 30309…
IDS not writing to online.log
Look for an open transaction that spans all the logs in onstat -x Dan -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of STEVEN AB Sent: Thursday, January 05, 2017 7:45 AM To: ids@iiug.org Subject: IDS not writing to online.log [384…
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…
Odd Bufferpool Behaviou
Original post: AIX 6.1 IDS 11.70.FC8X8 I have a new machine with a lot of extra memory. Given that, I added a bunch of new buffers (4k, 8k, & 16k) and went to town testing away. Long story short, with all those new buffers, I get virtual segments added at startup. In onstat -g …
IDS 12.10- BEST PRATICES Database Design
Hi, We are plan to do database reorganize to follow best practices database design from IBM to get best performance for our database. Our design as below: (all dbspaces size 2K) rootdbs - 1 logdbs - 1, allocated log file phydbs - 1, allocated physical log datadbs - 7, allocated…
sysmaster tables for onstat -u and onstat -g ath
Greetings. In my quest to produce Perl scripts that consolidate the output of onstat commands, it has been mostly straightforward to break up a line into into its component pieces of data. For example, onstat -u, every line has exactly one string in every column. Not so for som…
onstat -a order
Hi All, On Informix v.12.1, what is the order of the results for 'onstat -a'? Our file is 234MB large, so I'm breaking it down into the individual pieces. I've gotten to the 'onstat -g all' section, but am stuck on the section with the heading: Thread Thread id Cancelled I/Os C…
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)…
onstat -d
I am sure it must exist Does someone have a script to give a pretty layout of onstat -d ............. The dbspace, and following that the chunks belonging to that dbspace ? My company decided not to stick to naming conventions, and now I am trying to match dbspaces with chunks …
Performance issue after migrate to IDS from Online
Hi Art. Thanks for answering. 1. We are using AUS, but Statistics seems to be working well. (you can see the info at very bottom) 2. I think Informix Online's dbaccess doesn't have the -ss option. Nevertheless we have a script that modifies the original database schema file add…
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…
onstat -d
Hi, I see a line in onstat -d output that say metadata Size Free Bpages Metadata 17324 4005 17324 I see the free space was drastically reduced when I run cdr commands. My question is, what will happened with that space if it gets empty ? Thanks in advance. --001a11c11a8c11f…
Re: Re: Re: Re: 908: Attempt to connect to databas
Hi, Here are : 1-) an excerpt of onstat -l output : 70000004219eb20 97 U-B---- 40309 3:491573 5120 15 0.29 70000004219eb88 98 U-B---- 40310 3:496693 5120 602 11.76 70000004219ebf0 99 U-B---- 40311 3:501813 5120 27 0.53 70000004219ec58 100 U-B---- 40312 3:506933 5120 5 0.10 700…
Stuck Transaction with BTS!
The most important thing would be to get onstat -g stk of the thread fo= r the txn. From: "MICHAEL HOFFMAN" <mrh@panix.com> To: ids@iiug.org Date: 10/29/2014 05:23 PM Subject: Re: Stuck Transaction with BTS! [34059] Sent by: ids-bounces@iiug.org I did push the logical logs pass…
RSS not working
chunks on secondary are good bash-4.2$ onstat -d IBM Informix Dynamic Server Version 11.50.FC9 -- Fast Recovery (RSS) -- Up 22:32:53 -- 1200896 Kbytes Dbspaces address number flags fchunk nchunks pgsize flags owner name 7000000307d7028 1 0x40401 1 2 4096 NP B informix rootdbs 7…
Physical Log Size
IDS 11.70.FC8 AIX 1 6 00CC96664C00 I received the following message in the online.log file ..... is it something to be concerned about ? Based on the current workload, the physical log might be too small to accommodate the time it takes to flush the buffer pool during checkpoi…
Onstat -d
Hi, Every day I run onstat -d command, and notice that every 3 or 4 weeks rootdbs has from 2 to 8 free pages less. Why this happend? Enviado desde mi iPhone…
new bufferpool
original post This concerns ids12.10TC3IE . These are the old lines in my onconfig... #BUFFERPOOL default,buffers=10000,lrus=8,lru_min_dirty=50.00,lru_max_dirty=60.50 #BUFFERPOOL size=4K,buffers=100000,lrus=8,lru_min_dirty=20.00,lru_max_dirty=30.00 #BUFFERPOOL size=16K,buffers=…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Buffer Size and Use
Folks, We recently had a conversation with a well-respected name in the Informix world, recently, concerning our bufferpool configuration. When exported, our database takes up only about 18 GB. We had a buffer pool of 12 GB, figuring that the more memory resident, the better. Al…
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.…
onstat -g ckp Question
When we are transferring an index from the primary to the secondary we = have a problem. All the work and maintain a clean buffer pool on the primary= is done all the index is being built. However on the secondary there is no= way to keep the buffer pool clean. If we do not keep …
IDS 7.31 resize drop and recreate new logical logs
Hi Art, Thank you for your reply. Here's what i've got when trying to add/drop logfile. => onstat - Informix Dynamic Server Version 7.31.FD1XC -- On-Line -- => onparams -a -d logdbs01 -s 10000 Informix Dynamic Server must be in quiescent mode. [informix]:/appl/informix => ons…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
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,…
Bufferpool max size in Windows Server 2008 64bit
Hi, I restarted engine once more and now it looks right. So, probable user error! Are there other memory parameters that would benefit from very large values? Thanks, Lauri d:\\\\Program Files\\\\IBM\\\\Informix\\\\11.70>onstat -X IBM Informix Dynamic Server Version 11.70.FC…
onstat errors
Hi Art We are old dostats fans. Last version we compiled is: dostats: Features Version 6.00, Source Revision: 1.172 ! Copyright 1996-2009 by Art S. Kagel. License for private usage (including use by commercial enterprise for its own needs) is granted. Commercial and exploita…
onstat & SMI
Good day. Is it possible to get information from SMI similar as "onstat -g sql <sid>" shows? Especially we need current sql and last parsed sql... Thank you in advance. P.S. IDS 11.50FC9 for AIX.…
buffer pool and dbimport (11.70FC5)
Hi, I'm facing a problem and i don't understand how is it possible ... I'm loading (dbimport) a big table (> 3 Million records) and my buffer pool becomes quickly full (700000 buffers with LRU min = 0.50 and max 1.00). Checkpoint is not trigger until CKPINTVL (180) and you can im…
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…
Disabling LRU flush
Hi, IFX 11.70 FC 5 Innovator-C , Linux 64bits OpenSuse. I'm working with database load. Basically I'm using HPL, unfortunately some tables have huge rowsize0 (1 row size = 2 pages) and lvarchar datatype which force use deluxe mode. Consequently use buffer pool , and then LRU fl…
BTR on each buffer pool?
This concerns IBM Informix Dynamic Server Version 11.70.TC5IE . I have a 16k page size space where I put a temp space and all primary and foreign key indexes. Since I can select nbuffs, bufwaits, bufwrites, pagreads from sysmaster:sysbufpool I can get the BTR on each pool. Should…
Correct method of sizing resident pool...
Hi all, I have a script that reads an onconfig file and outputs an estimated memory footprint of the instance. However, I am finding it hard to accurately predict the resident section size. According to http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp?topic=/com…
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…
DBSpace Full?
We are trying to insert data into a table and get the following error WARNING: DBspace dldata1 is full Seems pretty straight forward... except the space is not full. Only the last chunk added is full. (see onstat -d below) informix@psdb03sat:~> onstat -d | grep 19 8e33ee80 …
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 …
ZFS and Informix
I'm well aware that the buffer pool has nothing to do with the underlying file system. We're just trying to figure out what scales better. We know that ZFS's ARC scales very well (the algorithms come from IBM !!). I trust though the people that have been out in the trenches worki…
Informix Status Explanations
hi, can anyone shed light on this for me. what does this mean? status yield bufwait- does it mean i'm lacking buffer pools? what does this indicate? cond wait netnorm - session is not doing anything. running- does it mean the sql is currently running. yield lockwaits - does th…
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…
Increase buffer pool size
Dear All, i found the following line in the message log of an IDS 10.00 on a Linux Box having 3GB memory: WARNING: Buffer pool size is too small for read ahead operation I would like to increase this parameter, as obviously it has the default size of 5000 buffers with a 2k page…
Informix question
Original Post: Hi, I have two confused question. 1 When a update SQL will update totally 3 pages in bufferpool? How many mutex IDS will allocate for this thread in the buffer-head entry in the buffer table? 2. What the temporary sbspace will be used for? thanks for your time.…
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…
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.…
out of physical log
Hi Art, I've done "onmode -c" and "onmode -l" and the physical dbs has 0 remaining. All logs are backed up as per "onstat -l". Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-1 0 32 10 1 10.00 phybegin physize phypos phyused %used 300035 24947 17422 0 0.0…
waiting on write of the logical log buffer
Yes We have HDR + 2 RSS using buffered loging. Round trip time is: ---- PING Statistics---- 9 packets transmitted, 9 packets received, 0% packet loss round-trip (ms) min/avg/max/stddev = 0.397/0.510/0.923/0.16 output of onstat -l: Physical Logging Buffer bufused bufsize numpage…
Could not open or create a temporary file
On Jan 25, 12:01 am, "Habichtsberg, Reinhard" <RHabichtsb...@arz- emmendingen.de> wrote: > Hi all > > Version of IDS 11.50.FC7W3 > > We have configured two exclusive temp dbspaces (nothing new, they exist > for years). > > Onstat -d: > 277279488 4 0x42001 4 …
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.…
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…
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…
onstat -l
I'm seeing a couple of extra lines in the output of 'onstat -l', which I can't find documented in the 11.50 administrators guide and references. The lines in question look like this: Buffer Waiting Buffer ioproc flags L-1 0 0x1 0 L-2 0 0x1 0 The exact lines varies (L-1 through…
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 .......…
force drop dbspace with first chunk inconsistent?
Hi, we have in a test environment a dbpspace with it's first chunk in state I (inconsistent) and we can't drop the dbspace (we don't need it, but it's not possible to drop it). I'd like to know if there's a way to force the dropping of the dbspace. The dbspace itself is, accordin…
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…
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 )
Hello, In the below mentioned output of onstat -l , there is a portion "Buffer Waiting". What does this "Buffer Waiting" mean? How could this output be useful for a database administrator? onstat -l ################################################### Physical Logging Buffer buf…
RE: Long Checkpoints with HDR and 11.5.
Art Kagel wrote: No, Jacques, IDS secondaries do not share buffer pool updates with the primary. Only the logical log buffers are transferred, so only the server's transaction rate would affect the data transfer rate between the servers and that would be about the same regardles…
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…
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??????…
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…
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…
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…
physical log might be too small
Hello, We are getting following error while checking checkpoints "Based on the current workload, the physical log might be too small to accommodate the time it takes to flush the buffer pool during checkpoint processing. The server might block transactions during checkpoints. I…
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…
what is the 0x40000 meaning
onstat -d ddress number flags fchunk nchunks flags owner name 1e468e490 1 0x40001 1 1 N B informix rootdbs 1e5d1a9b8 2 0x41001 2 5 N B informix npmdbs 1e5d1c028 3 0x40001 6 1 N B informix epmdbs1 what is the 0x40000 meaning…
Question about ISAM reads vs output of onstat -u
Environment: Informix 7.31 S.O. HP-UX 11i The ISAM reads (output of onstat -g ppf) and disk reads are the same ? I followed the next steps: 1. session a: onstat -z 2. Session b: I run a query in dbaccess 3. Session a: onstat -g ppf | grep 0xb00091 (a particular table reads in…
Adding BLOB Chunks to DBSpaces
>My question is I added the following chunk to a dbspace using the following command. > >onspaces -a dbspacename -p /dev/mapper/rawpartition -o 8 -s 5120000 > >How come now when I run onstat -d update it shows the chunk as half the size? 2560000 KB. > >Size Free >185f9328 9 5 4 2…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
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…
oninit fails reporting problem with DBSPACETEMP
DBSPACETEMP are tempdbs1 and tempdbs2 Output of onstat -d: IBM Informix Dynamic Server Version 11.50.UC3 -- On-Line -- Up 00:00:33 -- 1091824 Kbytes Dbspaces address number flags fchunk nchunks pgsize flags owner name 4a09a808 1 0x40001 1 1 2048 N B informix rootdbs 4a09ac18 2 …
Buffer Pool
Hi, We are running informix 9.4 FC5xs with SAP. Our SAP admin recently advised that the INFORMIX buffers were set to low. Based on some SAP recommendation, we increased the buffers parameter from 301049 to 501049 (about 600Mb to a little les than 1Gb. 2 days later I found the fo…
-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…
Fatal error
Dear Friends, When i am try to onlining the informix i got this messages informix@DBSERVER> oninit -v -y Checking group membership to determine server run modesucceeded Reading configuration file '/export/home/informix/IDS0/etc/onconfig.voms'...succeeded Creating /INFORMIXTMP/.…
Question about sysindexes.clust
I can provide you with a copy of the onstat -p but don't have the others. I will get them in future tests (I'm hoping we are almost done for now). On Tue, Nov 18, 2008 at 3:32 PM, Obnoxio The Clown <obnoxio@serendipita.com>wrote: > Eric Rowell wrote: > > Any suggestions would b…
Re: Best Use of Free Memory
David, I see the confusion now. The English phrase, "Needs to acquire a buffer," is too vague. There are really two major cases, but the manual is only addressing one (the rarer one). The cases are: 1. The required data is already in the buffer pool. In this case the thread nee…
Best Use of Free Memory
BUFFERS is generally a good place place to use extra memory, subject to a couple caveats: 1. If the working set already fits in the current buffer pool, adding still more buffers will not produce any noticeable performance increase. Check "onstat -g buf" output for your %cached.…
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…
If there were no onstat...
IDS v10.00.UC8 Solaris 8 6-1, 175 Bats: Left Throws: Right Born: 11/17/1967 in Independence, MO. Pretend there was no onstat -x (or any onstat) to get info about open transactions. You wanted to find out if there were any open transactions in a logical log file older than the cu…
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…
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…
Blocked:CKPT
PLEASE always include the post to which you are replying. I happen to remember what you are talking about and that this is a response to me, but anyone following this using the email gateway or perusing the archives may not know what's happening. Hmm. OK, so not blocked on logs.…
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!…
chunk is down
My box is aix 5.3 , ids 10 FC3R1. I start my ids and run 'onstat -d' 700000031d801c8 14 10 0 512000 0 PD-B /dev/ rtmpdb1 tmp dbspace is down. $ ls -l /dev/rmptdb1 crw-rw---- 1 informix informix 10, 20 Feb 25 13:39 /dev/rtmpdb1 owner , group name…
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…
Logical Logs
Hi All Gurus, I'm new to this forum and IDS. Please advise me how to remove/delete the logical logs No.1 till No.3 from onstat -l, i assume flag D indicates DELETE ( pls corret me if wrong) And would it possible to readjust LOGSIZE to smaller value say "16384" from any availabl…
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!…
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…
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…
Re: 9.40FC9 BUFFERS limit
On Jul 25, 4:41 pm, <eshkambx-i...@yahoo.com> wrote: > Hi > > Does anyone know what is real maximum number (not from release notes) of BUFFERS parameter for IDS > 9.40FC9 for Solaris 10? Exact Solaris version is: Solaris 10 11/06 s10s_u3wos_10 SPARC. > > Situation: > > We have ne…
description of onstat -g ntt
Hi Karl, From IBM Performance Guide v9.4, we can find this explanation on the q-exceed field: << output output field Description -------------------------------------------------------------------------------- -------------- onstat -g ntm q-exceeds Number of times the free buff…
Re: Strange behaviour of the buffer pool
On Jul 17, 8:57 am, RoB <pluma...@gmail.com> wrote: > >My post to the news group is taking forever. In any case, I looked > >around a bit and it seems like the easiest way to get your resident > >section to become larger, other then BUFFERS in the $ONCONFIG, is the > >LOCKS para…
Re: Strange behaviour of the buffer pool
On 17 Jul, 12:10, RoB <pluma...@gmail.com> wrote: > Hi all, > > IDS: 9.40.FC3W2 > OS: HP-UX 11.11 > > What am I missing here? An instance is unexplainably allocating 224 MB > of buffer pool in addition to the amount configured. > > The BUFFERS onconfig parameter is set to 6250 (=…
Re: Strange behaviour of the buffer pool
Looking at a larger instance on the same versions I can see the "resident" pool being 354MB while the "res-buff" being the same the BUFFERS setting: onstat -g mem|grep " R " res-buff R c00000001669d040 1280004096 2848 2 2 resident R c000000000491040 …
Strange behaviour of the buffer pool
Hi all, IDS: 9.40.FC3W2 OS: HP-UX 11.11 What am I missing here? An instance is unexplainably allocating 224 MB of buffer pool in addition to the amount configured. The BUFFERS onconfig parameter is set to 6250 (= 12.2MB): onstat -c|egrep "BUFF|SHM" BUFFERS …
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Re: Slow database creation and loading
On Jun 18, 10:50 pm, "Jack Parker" <jack.park...@verizon.net> wrote: > If you are using HPL, that grabs it's own memory. Data does not go through > the normal buffer pool (unless you are using deluxe mode). You might not > want to increase buffers. I need to double check but I…
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.…
onstat -p
Dear forumers, Attached is the "onstat -p" command : Do you think my bufwaits is high ?? Or is there anything significant from this information that need attention for performance reasons ? -------------------------------------------------------------------------------- ------…
onstat -p
The following is the output of onstat -p, I am curious why numckpts: 2325 < ckpwaits : 2683 ? How is that possible? Thanks, Frank informix@erika $ onstat -p IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 36 days 02:20:10 -- 1976640 Kbytes Profile dskreads pagr…
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…
help with tuning issue
How does lrumax and mindirty look like???? if at time1 all is ok and at time b all is bad, may be the # of dirty pages is simply too big??? wild guess..... explain would help so does a onstat -R when all is ok and all is bad... Superboer.…
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. …
error initializing
Hi: when initializing my INFORMIX leaves the following message to me error: $ oninit -v Checking group membership to determine server run mode...succeeded Reading configuration file '/usr/informix/etc/onconfig.nazca'...succeeded Creating /INFORMIXTMP/.infxdirs...succeeded Creat…
Total length of columns in constraint is too long
Hi, We recently migrated our application from MySQL to IDS. While the migration (post DDL and few other code changes) worked just fine in a dev. environment on windows, while executing DDL scripts on Linux, IDS throws this error. Basically I have a unique constraint on 3 columns…
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'…
Onstat Reference
It's taken a while but I've finally got our onstat reference pages (www.oninit.com/onstat) up to data with all the recent (ish) stuff. The V11 changes will be in place when the V11 Beta goes public. I'm happy to be told where they are wrong. If you like it then use it, if you …
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…
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…
record locked
a combination of onstat -k and onstat -u…
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…
Checking indexes after large deletes
Adam Tauno Williams wrote: >> I can't seem to get "onstat -g btc" to return anything in 9.21 FC4 or >> 10.0 FC4. > > It doesn't do anything on my "10.00.UC4" box. > > There is "btree cleaner info", with "onstat -C". Is that the same > thing? > Yes ... onstat -C Use the -C opti…
help on onstat
hi, please help me how to leave onstat -i mode? thanks…
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?…
who locks a record?
onstat -k followed by an onstat -u…
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…
How do it get writes form the lrus in V10
> -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Bill > Marshall > Sent: Wednesday, May 03, 2006 7:21 AM > To: ids@iiug.org > Subject: How do it get writes form the lrus in V10 [6648] > > > I have a new HP Intel 32 bit chip mach…
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/…
Re: Thoughts on Logical Log use requested
Ok, here's some information as requested by TBP & OTC, The onstat -l was taken today (unable to run cmd on Sun), the list of log times for Sunday (yesterday) follow that. Choosing one of the logs at random (No. 160439) it filled in 10 mins 3 secs and consists of (among others) …
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
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!…
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…
Check INFORMIXDIR and DBLANG.FAILED
Hill, what could have caused it ? angel:/opt/informixids/msg/en_us/0333}oninit -v Checking group membership to determine server run modesucceeded Reading configuration file '/opt/informixids/etc/onconfig.angel'...succeeded Creating /INFORMIXTMP/.infxdirs ... succeeded Creating …
Optimizing a BaaN installation
> Query sysmaster:syscfgtab (sysmaster:sysconfig is a view that hides undocumented paramaters)! 64 DD_HASHSIZE 1 31 31 65 DD_HASHMAX 1 10 10 95 DS_HASHSIZE 1 31 31 96 DS_POOLSIZE 1 127 127 111 DS_MAX_QUERIES 0 1 1 -1 112 DS_TOTAL_MEMORY 0 2048 2048 -1 113 DS_MAX_SCANS 0 1048…
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.…
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 …
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…
oninit: Dictionary Cache and SPL Routine Cache error
I am having some trouble initializing shared memory on Solaris 9 with Informix IDS 9.4. --------------- $ oninit -ivy Checking group membership to determine server run modesucceeded Reading configuration file '/dbms/informix/etc/onconfig.site'...succeeded Creating /INFORMIXTMP/…
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…
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…
Re: Re: oninit error .. [5496]
$ oninit -ivy Checking group membership to determine server run modesucceeded Reading configuration file '/opt/informix/etc/onconfig.padbv2'...succeeded Creating /INFORMIXTMP/.infxdirs ... succeeded Creating infos file "/opt/informix/etc/.infos.padbv2" ... "/opt/informix/etc/.co …
Latch waits
I'm seeing quite a highish level of latch waits (lchwaits) - whats the best way to reduce this? Increase the shared memory?…
Installation problem
I am attempting to upgrade an Informix installation from 7.3x on Sun 5.7 to 9.4 on Sun 5.9. When I run oninit -ivy I get the following: Creating buffer pool 200002 kbytes...succeeded Initializing rhead structure...succeeded init_alarm failed fyi: I installed a new version of IS…
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:…
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…
error the running INSTANCIA
Hi: Cuando inicio la instancia me sale el siguiente mensaje de error.... alguna idea, se los agradecere. Me pueden dar una pista ??? saludos ============================================================= Checking group membership to determine server run modesucceeded Reading co…
error the running INSTANCIA
Hi: Cuando inicio la instancia me sale el siguiente mensaje de error.... alguna idea, se los agradecere. Me pueden dar una pista ??? saludos ============================================================= Checking group membership to determine server run modesucceeded Readin…
Transaction Rollback
onstat -x…
How to determine optimum buffer size?
Hello, how do I (or how do you) determine the optimum buffer size (on IDS 9.40, but I think it's a generic question) ? I have a machine with almost 'unlimited' memory (96 GB RAM). Therefore I could define a large number of buffer pages. But I'm not sure if at some point the adm…
What counts sysbufhdr.reusecnt ?
Hi, I found the table sysbufhdr in the sysmaster database apparently containing information about the database buffer pages. One column has the name 'reusecnt' - does anybody know what exactly that column counts? Most entries have reusecnt=0 and I have one system (with a very la…
Re: RESIDENT and BUFFERPOOL
David E. Grove wrote: >>On Solaris the 4MB page size is used for any segment made resident, no >>matter how many there are. > > Since page size is now settable in IDS 10, does the above have any > implication on specifying a BUFFERPOOL page size? I'm no sure whether you understa…
Re: RESIDENT and BUFFERPOOL
David E. Grove wrote: >>On Solaris the 4MB page size is used for any segment made resident, no >>matter how many there are. > > Since page size is now settable in IDS 10, does the above have any > implication on specifying a BUFFERPOOL page size? I'm no sure whether you understa…
Re: Expert advice needed on Buffer management
jpierrot@chubb.com wrote: > Hi gang, His per-session buffer pool requirement calculation is completely bogus since most sessions will be sharing the use of the same pages of data and which pages are shared and which are uniquely used by a single session will differ from server t…
Expert advice needed on Buffer management
Hi gang, I received this below from the architecture Dept. trying to simulate Production like performance in QC and development envs. Assuming performance testing would be equal in all those environments if buffers are adjusted to a certain value. Please advise! My question to yo…
Expert advice needed on Buffer management
Hi gang, I received this below from the architecture Dept. trying to simulate Production like performance in QC and development envs. Assuming performance testing would be equal in all those environments if buffers are adjusted to a certain value. Please advise! My question to yo…
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…
IDS 10 Download?
So many questions... I have played with multiple buffer pools and different page sizes... creating a dbspace with an 8k page size..oh wow! Make size is only 16K though...oracle (where I guess this idea came from) allows 64K! onstat -h (buffer hash chain info) gives two outputs …
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…
onstat -p
We are running IDS 9.3 on Tru64. Most of the onstat -p statistics quit being accumulated 3 days ago and I = have no idea how to restart accumulation without restarting the = instance. What/how causes the stats to not accumulate? How do you begin accumulation again? Copy of onst…
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…
onstat --p
Hi: Considerations can recommend me that parametros and/or deberia to make for being able to improve the performance of my motor, because deacuerdo when coming out of onstat - p Êched=91.21 and to be 98 Thank's ========================================================== Profil…
onstat --p
Hi: Considerations can recommend me that parametros and/or deberia to make for being able to improve the performance of my motor, because deacuerdo when coming out of onstat - p %cached=91.21 and to be 98 Thank's ========================================================== Prof…
No space left on device to create index
Hi, I failed to create an index on a table having about 300,000+ rows. The message says 'no space left on device'. Using 'onstat -d', you can tell there're plenty of space. Also, in the instance where the data was exported from there's less space in each individual dbspace than …
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'?…
need help with onstat -C & B-tree cleaning threads / IDS 9.40
Hi all, some weeks ago someone posted a detailed description how to configure the number of new style B-tree cleaner threads according to monitoring results from onstat -C. I cannot find it anymore anywhere :( I don't even remember, if it was posted here, on the common IIUG li…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
problems of Inztallation's
Hi: I have problems with thle installation of IDS. Plataform: HP-UX 11.11 IDS: 7.31 FD8 I cannot initialize !!! If I want to iniciarlize via onmonitor .... the error is: shared memory not initialized for INFORMIXSERVER 'crazy_tcp If i want to inicialize vi command ..... the err…
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…
RE: Logbackup failed - ISAM error: cannot allocate memory.
--=====================_1237475816==.ALT Content-Type: text/plain; charset="us-ascii"; format=flowed I do not know if this fits, but we were having a memory leak problem with 9.30UC1. We ran out of memory whenever we did an "unload to <file> select <col...> from <table>" where…
Re: Logbackup failed - ISAM error: cannot allocate memory.
The following stats were taken while the instance is running ok ... after I bounced it and was able to restart ontape -c. If/when it decides to give the ISAM error again, I'll redo the commands and repost. BTW ... the online.log file gave this message, too: shmat: [EMFILE][24]: …
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…
Intitialization problem
Hi, I have a problem with IDS 7.31 on SCO 5.0.5 When trying to initialize IDS and it hangs. Here is the oninit -v command: # oninit -v Checking group membership to determine server run modesucceeded Reading configuration file '/usr/informix/etc/onconfig'...succeeded Creating …
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…
Re: Logical logs from rootdbs to own logspace
"Andrew Hamm" <ahamm@mail.com> wrote in message news:2kh0tsF2cbhcU1@uni-berlin.de... > Really? I hope you are talking about a long-forgotten feature of a Version > Five then, 'cos this works beaudifully: > onstat - IBM Informix Dynamic Server Version 9.40.TC2E1 -- On-Line -- …
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 …
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?…
Informix IDS problem
Hi All, When I try to start the IDS 9.40 on HP PA-RISC machine, I get the following error. If I reinstall the IDS it works properly. If I shut down & restart the database it fails with the below message.. Checking group membership to determine server run modesucceeded Reading …
RE: Clearing Buffer Pool
Informix (unlike MS SQL) keeps all pages in the buffer pool 'forever' - until page becames replaced by another page... ------------------------------------------ Alexey Sonkin > From: Dave Griffen [mailto:dgriffen@nospam.finishline.com] > > I do mean to remove all non essential…
RE: Clearing Buffer Pool
To clear the buffer pool from dirty pages, generate a chackpoint with 'onmode -c' If You mean to remove all pages from it, then it's impossible. ------------------------------------------ Alexey Sonkin > -----Original Message----- > > Does anyone know if there is a way to clea…
Clearing Buffer Pool
Does anyone know if there is a way to clear the buffer pool without bouncing the engine?…
multiple userthreads per session
Hi, while this shows, that there are several user threads, it unfortunately doesn't show, what these threads are doing in detail. You probably want to do the following onstat commands also: "onstat -g ath", "onstat -g ses <session id>", "onstat -g sql <session id>" and possibly …
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.…
Re: DDR Down - how up with it?
Madison Pruet wrote: > Case Number? What happens if you run cdr start? $ onstat -g ddr Informix Dynamic Server Version 9.30.UC5 -- On-Line -- Up 53 days 19:47:04 -- 282848 Kbytes DDR -- Down -- $ cdr start command failed -- Enterprise Replication already active (63) > …
DDR Down - how up with it?
Hi this is a CDR question on IDS 9.30 / AIX 5.1 platform. We have 3 servers A, B and C. CDR rep1 from A to B work in Primary/Target mode. CDR rep2 from B to C is configured in Update Anywhere mode, but doesn't work since onstat -g ddr shows: DDR Down. Because of rep1 we don't w…
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…
Backed up logs less than 100%
Hi everybody! Our client is using online Dynamic Server 9.21.UC5 on UNIX (AIX 4.3). They reported a problem with database performance (long response time). I asked them for the output from ‘onstat –l’: Physical Logging Buffer bufused bufsize numpages numwrits…
Performance is getting worst after turn on the LRUAGE
On Sun, 28 Mar 2004 22:40:01 -0500, miyaki wrote: Other is usually 'unused pages'. Look at the top of the onstat -P report. On the line for address zero (0), is the value under Other very large? Those are unused buffer pages, ie no data pages have been loaded into them. There…
Onstat -D / onstat -u mismatch
IDS 9.21.UC6, Solaris 2.8 building an ETX index, into logged smartdbs, onstat -u shows the nreads column ticking up. The nwrites is remaining at zero. Onstat -D shows heavy reads on one smartdbs where the data is, and heavy writes on smartdbs where the index is heading. onstat…
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,…
Re: buffers used
On Mon, 01 Mar 2004 11:12:14 -0500, tomL wrote: > hello all, > > how can i find out what is the actual percentage of buffers being used at > any given moment? Used or active? Onstat -b will display all used buffer headers, onstat -P will show a summary report of the types and …
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…
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: Buffers and LRU.
Madison, the standard interpretation of LRU is Least Recently Used. The standard usage of such a queue is as follows: Each queue has an MRU (Most Recently Used) end and an LRU end. When a buffer is touched (either read or written) it is moved to the MRU end of the queue. When a…
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…
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…
Buffers and LRU.
The buffer pool is the page cache of the engine. The LRUs are simply a means of chaining the buffers together. There are two chains per LRU - the free and the dirty. (Actually a free buffer has a page in it, but it is not dirty.) There are multiple LRUs so that if a thread tri…
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…
RE: database restore with ontape -r on Informix Online Dynamic Server 7.31 on Linux
"Colin Bull" <c.bull@videonetworks.com> wrote in message news:btmcr4> That will make it a lot tidier, should be able to use a case statement. > I will revise next week sometime. > http://www.smooth1.demon.co.uk/ifaq06.htm#6.33 6.33 What status codes does onstat return? On 21st …
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.…
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…
onstat -F
What does the "data" column in onstat -F output signify? Where is this documented? Thanks Andy…
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?…
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…
K AIO
Hi, Is K AIO of any use when the db is on advfs files? (Runinng 7.31 on Tru64 5.1b) How can it be activated? (onstat -g iov doesn't show any kio)…
How to create dbspace
hello I am working on informix 9.3 on win2k with ArcSDE when i am loading data the dbspace exhuasted after restarting the servis i am able to run the service but unable to connect Plz find the below the details of onstat -d d:\\PROGRA~1\\Informix\\bin\\onstat -d: Informix Dy…
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…
not initializing shared memory
mt_shm_remove: WARNING: may not have removed all/correct segments what do you do about that?…
Re: Disks for informix
Firstly you need to know what portions of these disks have already been allocated. I normally start by producing a map of each drive. This is best done by using the output of onstat -d and mapping the portions of each disk that have been allocated. But you do need to know how …
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…
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…
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…
is hdr on?
Hi ! I have 2 Informix servers (7.31UC7) with HDR - server1 and server2. Is HDR on? --------------------------------------------------------------------------- server1: [informix@server1]$onstat -g dri Informix Dynamic Server Version 7.31.UC7 -- On-Line (Prim) -- Up 23 day…
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…
onstat flags
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_000_01C2C163.7472F850 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C2C163.7472F850" ------_=_NextPa…
regarding concept of physical logging??
hello, i have a serious confusion regarding tha concept of physical logging, this might sound silly for an expert kindly bear with me and explain.. according to what the book says.. physical logbuffer contains the before images of the data that taken from disk for modification..…
onstat -b
Hello all, Below is the output of onstat -b : informix@test:/usr/informix> onstat -b Informix Dynamic Server Version 7.30.UC8 -- On-Line -- Up 6 days 21:06:56 -- 506592 Kbytes Buffers address userthread flgs pagenum memaddr nslots pgflgs xflgs owner waitlist 31427e88 0 …
RE: what is light scan and look aside??
All of these 'advanced' questions. Are you retreading from some other vendor? You should consider a course. Light Scan: Normally when you read a table, you go through the buffer pool. That is your row is retrieved from disk, stuck into a buffer, an LRU entry is made to track…
onstat -b
Hello all, Below is the output of onstat -b : informix@test:/usr/informix> onstat -b Informix Dynamic Server Version 7.30.UC8 -- On-Line -- Up 6 days 21:06:56 -- 506592 Kbytes Buffers address userthread flgs pagenum memaddr nslots pgflgs xflgs owner waitlist 31427e88 0 …
RE: onstat
On Tue, 30 Jan 2001 dr_pablo@my-deja.com wrote: >> I have seen vendor-supplied scripts, which use the following >> exit codes from "onstat". I do not know where they are documented. > >Here's the URL to the FAQ page containing the info: > >http://www.iiug.org/resources/faq/ifaq0…
RE: onstat
I got this email awhile back: >PEOple, > >For those of you who do not know, it is very tough to determine the *real* >status of IDS. "onstat -" will return, stating that the server is "online" >but many times it is in the process of a "fast recovery", etc. In >addition, "onsta…
RE: onstat
The exit codes were posted into a FAQ at the IIUG web site at one time. Wayne E Martin Informix Database Administrator Kmart Corporation -----Original Message----- From: Bogdan Neagu [mailto:bogdan.neagu@alcatel.com] Sent: Monday, January 29, 2001 11:17 AM To: informix-list@iiu…
RE: onstat
Hi Bernstein. Please visit following site. >exit codes from "onstat". I do not know where they are documented. http://www.informix.com/informix/iuc/ppt/ts_ids.ppt And search "onstat". Regards. -- Tsutomu Ogiwara Technical Group & Red Brick Group, Informix Sales Promotion …
Re: onstat
At 11:17 01/01/29 -0500, Bogdan Neagu wrote: Hi Bogdan. When the meaning of the question is different, I'm sorry. onstat returns the following. The server status is expressed as a number 0 Initialisation 1 Quiescent 2 Recovery 3 Backup 4 Shutdown 5 Online 6 Abort Regards. >…
RE: onstat
I have seen vendor-supplied scripts, which use the following exit codes from "onstat". I do not know where they are documented. integer inf_dwn1=255 # Informix mode is down integer inf_dwn2=-1 # Informix mode is down (60_USAP2) integer inf_init=0 # Informix mode is Initia…
Using directives within Informix 4GL
Does anybody knows how to use directives within an Informix 4GL program ?? What I want to do is a query like this: select --+ordered * from a,b,c where a.a = b.b and b.b = c.c The directive is not followed when the query runs. I can see that when I use onstat -g sql or when …
onstat
Hi all. I was told by our DBA that onstat has different exit codes depending on the engine's mode (or mood). So, if I test $result (in C shell) or $? (Bourne / Korn shell), I should get a numeric value. My tests show 1=Quiescent, 5=On-Line. Does anyone know what these values …
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…
AW: onstat -b
Hello Tony, The onstat -b command provides a list of the buffers in the buffer pool that are currently being modified (i. e. in use) according to information contained in the buffer headers. HTH Heinz -----Ursprungliche Nachricht----- Von: Tony Woods [SMTP:twoods786@hotmail.c…
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…
onstat -b
Hello all, Below is the output of onstat -b : informix@test:/usr/informix> onstat -b Informix Dynamic Server Version 7.30.UC8 -- On-Line -- Up 6 days 21:06:56 -- 506592 Kbytes Buffers address userthread flgs pagenum memaddr nslots pgflgs xflgs owner waitlist 31427e88 0 …
Re: How to end a user session...
Use: onmode -z "sessid" where sessid is given to you by onstat -u command. Doina ----- Original Message ----- From: Denmark B. Weatherburn <dweatherb@btl.net> To: Informix Users Group <informix-list@iiug.org> Sent: Friday, January 12, 2001 1:28 AM Subject: How to end a user se…
How to end a user session...
Denmark B. Weatherburn wrote in message <93lgi4$ivq$1@news.xmission.com>... > >Hi Listers, > >My question is how to end a user session once I've identified it using >onstat -u? > >Thanks, > >Denmark W. > Thank you for asking this question instead of going out shooting. onmode -…
system page size!
I am confused with the system page size, now? Where can I see what system page size informix is using? The last line of onstat -b tells me 2048 buffer size.... but on HP-UX dmesg shows this: physical page size = 4096 bytes, logical page size = 4096 bytes Is this physical page …
How I can determine if my CPU VPs are starved of CPU !
If you have a version of top , run it at peak period and monitor the cpu utilization of your cpu vps (oninit processes). If ALL are close to 100% (say, about 90%), you need to add cpu vps. If you already have cpuvps = number of physical cpus, you've reached your hardware limit. …
RE: DataBase Log Status...
In article <93dl69$1jk$1@news.xmission.com>, mosserp@WellsFargo.COM writes > >I believe that you have to take the instance down to quiescent (onmode -uy) >before you can start logging on a database. Try doing: >-- onmode -uy >-- ontape -s -L 0 -B dbname >-- onmode -m > >HTH, >Pa…
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…
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…
problem by restore with ontape
dear newsgroupmembers, we restore from system a to system b. on system b we set the TAPEDEV to the tape on system a with a:/dev/rStp0 everything works well so far. after restoring 2.127.529 pages the system response to the onstat was:"shared memory not initialized for INFORMIXSE…
bug in onstat -t ?
onstat -t gives following output (look at column npages): Tblspaces n address flgs ucnt tblnum physaddr npages nused npdata nrows nextns resident 17 c0000000995f8908 0 1 100001 10000e -9223372036854775558 250 0 0 5 0 120 c0000000995f8d78 …
Onstat -P
Hello all, I am hoping you can clear up something for me. I am curious about the onstat -P command. The Admin Guide/Manual for 7.3x has one pithy statement about "display for all partitions the partition number and break up of pages in the buffer pool belonging to the partitio…
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 …
onstat on IDS2000
Hello all IHAC with IDS2000 ans the output of onstat -d is the following : Informix Dynamic Server 2000 Version 9.20.UC3X4 -- On-Line -- Up 6 days 16:59:45 -- 459440 Kbytes Dbspaces 500d1d08 6 8001 6 1 N S informix usersbs0101 Chunks address chk…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
RE: Informix 32 bits or 64 bits??
"Andrew Ford" <aford@simpletel.com> wrote in message news:8pocpk$s6a$1@news.xmission.com... > We've installed IDS 7.31.FC4, which is supposed to be 64bit as per > Informix. When I do an onstat -b the buffer size is listed as 2048. Isn't > this wrong, if it were a 64 bit version…
onstat -u - Why so many redunant user id's????
Can anyone tell me why I'm getting so many redundant/duplicate user process id's when I run onstat -u? Below is an output from the following command: onstat -u | grep pamc why is sessid 54753 repeated? 40050c60 Y-B---- 54753 pamc 3 9085b5b0 0 3 0 0…
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…
Re: poor performance revisted
From: "Ty O'Kelly" <tokelly@maxor.invalid.com> > >Obnoxio The Clown wrote: > > > > > >onstat -P | tail -5: > > > > > > > > > >Percentages: > > > > >Data 6.77 > > > > >Btree 92.40 > > > > >Other 0.82 > > > > > > > > This looks ugly. What is the output of > > > > > > > > onstat -B…
poor performance revisted
Obnoxio The Clown wrote: > > > >onstat -P | tail -5: > > > > > > > >Percentages: > > > >Data 6.77 > > > >Btree 92.40 > > > >Other 0.82 > > > > > > This looks ugly. What is the output of > > > > > > onstat -B | grep " d0 " | wc -l > > > > 0 > > Hmmmm...what's the smiley for rai…
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…
Re: Performance problems with large SELECTS in 7.3x ?
Stefan Weideneder wrote: > > Hi, > > I tried to select some pages of a table that was a bit larger > than my buffer pool. I estimated that my statement will take > about 5 seconds but it took 12 seconds. > I found out, that the server spent approx. 7 seconds for > "buffer waits".…
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?…
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…
Re: Slowness
Thanks for all the posts. I did make some changes and it seems to have sped up quite a bit - my developer was out for a few days, so he'll be the final "judge" - he's the one with the query problems... Also one of our tables got error 136 (extents), so I had to "fix" that p…
Re: Long Transaction
Well, if i reduce the LTXHWM, isn't it the Longtrx will occur more frequent?? Or i should said i need to increase the number of LTXHWM and LTXEHWM?? below is the output of onstat -l and onstat -p Informix Dynamic Server Version 7.30.UC5 -- On-Line -- Up 6 days 16:26:22 -- 16…
Fatal error in shared memory creation
When I type oninit, it said: Fatal error in shared memory creation Why ? Thanks…
onstat -u
I have a telnet user who consistently is walking out the door without logging off. Here's how I assume I should go about killing the user, with the problem listed below. 1. Do a who -u | grep username (identify tty port) 2. Do a onstat -u | grep username (to identify session i…
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 …
Re: Onstat
Are you executing onstat with -r 1 option? It happens sometimes. Try with -r 5 option. Vinod Bhansali --- Srinivas Sreekumar <SRINIVAS_SK@inf.com> wrote: > Hi all, > > I recently installed Informix dynamic server > 7.31.UC6 on HP UX 11.0 > > I am getting an error while running …
RE: Onstat
I had a low value for the shared memory kernal parameter for my unix server. When I increased it it started working.. Thansk, Srini -----Original Message----- From: Marat [mailto:maratkotik@mail.ru] Sent: Monday, May 15, 2000 7:41 PM To: informix-list@iiug.org Subject: Re: Onst…
Onstat
Hi all, I recently installed Informix dynamic server 7.31.UC6 on HP UX 11.0 I am getting an error while running onstat. "Changing data structure forced command termination. " can someone interpret this message for me and tell me the action to be taken. Thanks, Srini…
RE: -346 UPDATE ERROR
What was the ISAM error? Will >===== Original Message From "Bhaskarla, Sunil" <Sunil.Bhaskarla@Eclipsys.com> ===== >Hi, >I am getting repeatedly hit by error >-346: >Could not update a row in the table. >While the database server was processing an UPDATE, it received an >unexpec…
-346 UPDATE ERROR
Hi, If your update statement is in an ESQLC program you have to print out sqlca.sqlerrd[1] to know wich ISAM error occours. With ISAM error code, you can know the cause (-144 for example is key value locked). It could be a syntax error, too. bye fabio "Bhaskarla, Sunil" ha scrit…
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…
onstat -p
_______________________________________________________________ This message and any attachments are intended for the individual or entity named above. If you are not the intended recipient, please do not read, copy, use or disclose this communication to others; also please not…
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…
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 …
Re: How do I check LRU contention - onstat -g spi ????
On Tue, 11 Apr 2000 13:30:59 -0400, "Art S. Kagel" <kagel@bloomberg.net> wrote: >bothwellno@spam.duke.edu wrote: > >> Art S. Kagel & Family <kagel@erols.com> wrote: >> : InfoJones wrote: >> : [output SNIPPED] >> >> : To determine whether buffer contention or LRU contention is in…
Re: How do I check LRU contention - onstat -g spi ????
bothwellno@spam.duke.edu wrote: > Art S. Kagel & Family <kagel@erols.com> wrote: > : InfoJones wrote: > : [output SNIPPED] > > : To determine whether buffer contention or LRU contention is involved > : try to calculate your buffer turnover rate: > > : Buffer Turnovers = (dskread…
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…
Re: How do I check LRU contention - onstat -g spi ????
Art S. Kagel & Family <kagel@erols.com> wrote: : InfoJones wrote: : [output SNIPPED] : To determine whether buffer contention or LRU contention is involved : try to calculate your buffer turnover rate: : Buffer Turnovers = (dskreads + bufwrits) / BUFFERS : BTR = (Buffer Turnove…
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…
Posting from the Informix-list
onstat -g ntd Nona…
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
onstat -u
I am running Informix 8.2 on HP-UX 11.0. When I issue onstat -u command it shows the following: address flags sessid user tty wait tout locks nreads nwrites Under flags option: There are seven flags, the Seventh place flag is I know B,C,D,F; but it also shows M sometime. …
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…
RE: checkpoints taking as much as 25 secs
Scott Huppert wrote: > > It's logical that turning the entire buffer pool every 10 minutes is > probably bad, but what is a reasonable time frame? Is there any rule of > thumb? On a busy server that is NOT primarily a DSS/DW server I'd like to see the buffer pool turnover rate …
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…
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 …
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…
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…
ovbuff vs. fgwrites question
Bobby Medus <jeepin@eatmydirt.com> wrote in message news:382C304D.90240C61@texas.net... > This may be a stupid question but you know the old saying..... > > I noticed an increase in 'ovbuff' on the onstat -p. This is a very > small database running on NT and so I increased my b…
Last parsed SQL statement
In article <809j4f$11b$1@news.xmission.com>, "Howard, Paul" <PaulHow@medcmp.com> wrote: > > When onstat -g sql <sessionid> is executed is gives the Last parsed > SQL statement. Is there anyway of querying the sysmaster database to get > this statement? > I don't have an onlin…
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…
onstat & SMI
Hi, does anybody knows what query (queries) I must run to produce same output as onstat -u command? I'm not sure for flags, which fields in SMI represents those flags. Thnx in advance.…
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: 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…
RE: Spurious phys/log log-related messages in message log?
Do you get any errors from: oncheck -ce oncheck -cr If so, probably a corrupt dbspace. Murray Wood -----Original Message----- From: Red Valsen [SMTP:red_valsen@yahoo.com] Sent: Friday, September 10, 1999 12:11 AM To: informix-list@iiug.org Subject: Spurious phys/log log-rela…
Spurious phys/log log-related messages in message log?
We recently brought a new Solaris 2.6 x86-based server online for application development. It sports 512 MB memory, 2 processors and 4 x 4.23 GB disk drives. We're running IDS 7.30.UC2 and using cooked files. I've moved phys and logical logs to a separate dbspace, increasing th…
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…
Re: logicallogs
From: him_lommel@t-online.de (Andreas Lommel) > >In the IECC database list my databases have the status LOGGING MODE - >no. >But the logical logs (onstat -l) are in use. Why ??? You will always have logical logs displayed in onstat -l, they're needed for DDL statements to run, w…
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…
Onstat command
This is a multi-part message in MIME format. --------------DE4F14609E17179D45AF0716 Content-Type: multipart/alternative; boundary="------------73DD82890539D87E4735A41C" --------------73DD82890539D87E4735A41C Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: …
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.…
onstat -z
Is there any way to tell the last time someone ran "onstat -z"? This seems like it should actually be logged in the online.log file rather than having to rely upon my fellow DBA's to communicate the fact that they reset things. Especially when I have to monitor hundreds of syste…
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…
onstat
Hello after executing an onstat following message appears in the first lines: "Changing data structure forced command termination" What does this mean? Why does the Profile (as in a normal onstat) not appear and the onstat view only shows me the sessid? Regards André…
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…
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.…
onstat options....
Hi Users, Which is the best site(s) / Book(s) to explain in detail all the columns of different options in onstat. There are a few changes in onstat results from 7.2x to 7.3.... so need something which explains all these. Thanks in advance, Pramod ___________________________…
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…
Re: Out of buffer?
On Wed, 26 May 1999, Mark D. Stock wrote: > Xavier wrote: > > > > 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…
Re: Out of buffer?
Xavier wrote: > > 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 time…
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.…
Re: onstat
In article <7hpivn$l4u$1@news.gte.com>, michael.talbot@telops.gte.com says... > Hello, > > Question from a unix/informix neophyte: > > > > When I issue the onstat command I get the following reply. Does anyone know how to resolve this? > > /tmp-> onstat > shared memory not initi…
Re: onstat
Either the environment variable INFORMIXSERVER is not set (or isn't set to the correct value) or the Informix database engine is down. What is the value of DBSERVERNAME in the ONCONFIG file? John Carlson Informix DBA WHSmith USA Hello, > > Question from a unix/informix neophyt…
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…
ONSTAT
HI folks, looking for help using onstat -g que I would like to know if Enterprise Replication is working I don't know the meaning of this output.. Any help will be really appreciated. Thanks Javier Puente…
onstat columns
Does anyone have a listing, even partial, of on onstat command column meanings? Informix's references are completely unhelpful, or nearly so, in describing, for example, what the "q-limits" column of "onstat -g ntd" means or how it's calculated, except for saying that the comman…
Re: onstat -u / onstat -g ses Problem
Informix Netherlands advised to start the database with the environment variable SINGLESEG_OFF=1. Try it! Regards Hans Bosma Database Administrator NCCW(Netherlands Ing Thoralf Bihlo wrote: > > I´ve got an HPUX 10.20 / Serie 800 Server with Informix Dynamic Server > 7.30 UC6. >…
REQ: Problem with onstat -u / onstat -g ses
I´ve got an HPUX 10.20 / Serie 800 Server with Informix Dynamic Server 7.30 UC6. My SHMVIRTSIZE is 32k and onstat -g seg shows that I have just one Segment. When I try an onstat -u or onstat -g ses I get the Error: >Changing data structure forced program termination< during the …
onstat -l
When my machine is blocked in a CKPT, onstat -l shows ... Buffer Waiting Buffer ioproc flags L-1 57c6ab54 0x1 0 L-3 57c69884 0x1 0 ... which is not documented anywhere. I can guess what it means, but does anyone know what exactly it means (and what flags ar…
Re: RESIDENT and PDQ
Chuck Renaud wrote in message <7ddp91$hpf$1@news.xmission.com>... > >As for light scans--those only happen if the table being read is >larger than the buffer pool. So if you max out your buffers, you >won't get light scans unless they're huge tables... So, would this mean that …
RE: Empty dbspaces.
Your dbspaces will have some space used for system overhead even when they are not being used to store any data. Using oncheck -pe should verify this for you. Example from my system shows this... Chunk: 5 /dev/informix/dbs_blob2 Size Used Free …
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…
Delete
Hi. I've a question. When execute a delete by where on field not indexes, it sequential scan table' s page. Before to delete records, it casche pages in buffer pool ? Tank you.…
Re: Buffer Waits
> hmm, could you go into a bit detail on the light-scan? I have a DSS system > but I am not sure how to make it use light scan. I read something on the > book about it, but it wasn't very clear on exactly how to utilize it or > how to check it. thanks yan Here's some more inform…
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…
RE: onstat -t
onstat -t shows tblnum in hex. So you can link it with hex(partnum) of systabnames to get your tablename. HTH Sathish -----Original Message----- From: David Tamburin [mailto:david.tamburin@protegrity.com] Sent: Wednesday, January 27, 1999 4:16 PM To: informix-list@iiug.org Subje…
onstat -t
Hello, Is there anyway to tell what the actual tablenames are when you execute a onstat -t ? I know that tblnum is the tablespace number, but what can this be related too to tell me something useful? Thank you david.tamburin@protegrity.com david Tamburin…
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…
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…
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: 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…
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…
Re: Best database for web backend on Linux?
On Wed, 21 Oct 1998 13:03:49 +0000, Evan Carew <ecarew@yahoo.com> wrote: >Simply put, The main reason I have selected Sybase over Oracle in the >recent past has to do with cache management. In every case, if >you try to use Oracle stored procedures in the same environment with >…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
onstat -u
I was running an 'onstat -u' command and have been receiving the following message: "changing data structures forced command termination" I was wondering if any of you have seen this message and might know what it means and how to correct it? David Meyer Guerilla Software…
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…
Re: Reducing checkpoint intervals...
Hi, in my opinion you must reduce LRU_MAX_DIRTY and LRU_MIN_DIRTY. It's not a good idea to reduce the time interval between the checkpoints because each checkpoint costs a lot of overhead ( thread-synchronisation and checkpoint-waits ). How about: http://www.weideneder.de/info…
onstat -h
Does anyone have any info about the meanings of the output of the onstat -h (hash chain info) in IDS 7.3? It's not in the hardcopy or in the 7.3 Admin manual, and I'm trying to document it. Thanks, joe -- -------------------------------------------------------------------------…
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…
Re: Performance problems with large SELECTS in 7.3x ?
Stefan Weideneder wrote: > > Hi, > > I tried to select some pages of a table that was a bit larger > than my buffer pool. I estimated that my statement will take > about 5 seconds but it took 12 seconds. > I found out, that the server spent approx. 7 seconds for > "buffer waits".…
Performance problems with large SELECTS in 7.3x ?
Hi, I tried to select some pages of a table that was a bit larger than my buffer pool. I estimated that my statement will take about 5 seconds but it took 12 seconds. I found out, that the server spent approx. 7 seconds for "buffer waits". Now I added a few buffers to the buffer…
Re: How could I get Informix page size?
In article <6rt68c$rbb@news.itfs.nsk.su>, "Ivan Lyakhovenko" <van@xtech.ru> wrote: > Hello All! > > My Informix application displays server general information such as dbspace > (chunks) size. It should be platform independent. How could I get page size from > SYSMASTER databas…
onstat -D vs onstat -g iof
Informx gurus: --------------------------- This is a copy of a post that I previously send, however seems that because of the problems with the informix-list not many people had the opportunity to read it. I am sorry if you already read this message. ----------------------------…
onstat -D vs. onstat -g iof
Informx gurus: Could some one explain the output of onstat -D and compare it with the output of onstat -g iof? On my online 7.23 running on AIX 4.2 I get the following for onstat -D: address chk/dbs offset page Rd page Wr pathname .... 400382c8 2 2 1 40261 303…
onstat commands
Does anyone know of a source that describes all of the onstat commands? The 7.x manuals are pretty good, but some of the explanations are a bit brief. ==================================================================== Harold Luse Phone: (970) 491-4120…
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: onstat -g ses
>Hi, >In the onstat -g ses output , what is the basis for allocation of 'total >memory' ? >There is also the figure 'used memory' , why not just allocate required >memory ? Well, we could do that but then that would 1) fragment memory and 2) create bottlenecks. Memory in shared…
onstat
I tried to run onstat not as user informix and i got onstat:Share memory:permission denied. The env. looks fine , the informix server is up. I am running 7.23. You have to have Informix priv. to run onstat ? Thanks Gabriel Weisz…
Re: onstat
Gabriel Weisz wrote: > > I tried to run onstat not as user informix and i got > onstat:Share memory:permission denied. > The env. looks fine , the informix server is up. > I am running 7.23. You have to have Informix priv. to run onstat ? No. Check the permis…
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…
onstat -t output
Hi, The output of onstat -t shows zero in the column 'nrows' , whereas ' nused ' and 'npdata' have non-zero values . Why is this so ? TIA Sathish…
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…
Onstat -R
Can someone explain the onstat -R headings.. Is the percentage free or used. Been digging thru the texts.. examples but little explanation? INFORMIX-OnLine Version 7.24.FC4 -- On-Line -- Up 4 days 17:40:47 -- 36320 Kbytes 8 buffer LRU queue pairs # f/m length % of pair…
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: +…
onstat -g ...
Hi guys, Where I can find explainations about the output format (headers and key words) reported after executing onstat -g ... In the Informix Administrator's Guide there is an explaination of all other options of "onstat", but for "-g" option I did not find detailed informati…
onstat -k
Thanks to everyone who answered the onstat -k tblsnum question. I appreciate it. ==================================================================== Harold Luse Phone: (970) 491-4120 Veterinary Teaching Hospital Fax: (970) 491-1275 Colorado S…
onstat -k
How would one link the tblsnum field of an onstat -k with a table name? Locks address wtlist owner lklist type tblsnum rowid key#/bsiz 3008c64c 0 4004a354 0 HDR+S 100002 230 0 3008c680 0 40042814 0 S 100002 22f …
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…
onstat -u
Here's a good question. Sample: 4004d214 Y--P--- 4999 dbolte 91 40c936d8 4004d654 Y--P--- 4965 tgreenwa 56 40129f98 0 1 2071 4004ded4 Y--P--- 4484 bhitchen 32 40b4c5c0 0 1 136 4004e314 Y--P--- 5023 hwhite 77 40006f8c 0 …
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…
onstat and tbstat
Hi, We have just upgraded from 5.x to 7.x. Those tbxxxx files are now onxxxx files, but they still exist lots of tbxxxx like tbstat, tbmonitor, and so on, are these files different from the new version onstat and onmonitor or they are the just the same but with different names??…
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.…
onlog -n hung, online (CKPT REQD)
Hi, I wanted to examine the current logical log file, (I was not logged in as informix). onstat -l showed the following: a22e648 1 U---C-L 24596 100a03 250 247 98.80 a22e664 2 U-B---- 24590 100afd 250 250 100.00 a22e680 3…
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: onstat -d,onstat -D
I believe 1001 indicates that the dbspace is a blobspace. I know that 2001 indicates that the space is a temporary dbspace. "Tony_Reynolds(Accounting & Purchasing System") wrote in message <67972r$caj@cssun.mathcs.emory.edu>... >Can anyone tell me the difference between a dbspa…
Re: onstat -d,onstat -D
I believe it in indicates that table in dbspace has been dropped. -Lin "Tony_Reynolds(Accounting & Purchasing System") <tr-2959@mail.necgroup.co.uk> wrote: > Can anyone tell me the difference between a dbspaces address with a > flag of 1 and a dbspaces address with a flag of 100…
onstat -d,onstat -D
Can anyone tell me the difference between a dbspaces address with a flag of 1 and a dbspaces address with a flag of 1001...... Tony Reynolds, NEC Group, Birmingham , UK 8-)) tr-2959@necgroup.co.uk tonyreynolds2@compuserve.com…
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…
Onstat Utility
Hi, I'm using onstat -g ath and see threads that are slleping forever. What could this be? Are users not exiting properly from Informix? How do I kill these processes. Thanks Bob…
onstat and threads
Hi, I'm run onstat -g ath and I see threads that are sleeping forever. Do I kill these processes and what could it possibly be from. Users not exiting properly? Bob…
Documentation on the ouput of onstat -g options
Hi All, Is there any documentation around which explains the output of onstat -g options for example the following is the output of onstat -g ses <session id> tid name rstcb flags curstk status 2326 sqlexec 119b65d4 B--PR-- 2032 119b65d4 sleep…
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…
Re: informix logical logfiles
I suspect either you just restarted your database engine or may have run onstat -z which might? zero out these statistics. Are either of these true? -Bill } } > We use informix online 7.11 and I think our applicaton behave a bit strange. } > } > After } > onstat -l } > } > Buffe…
informix logical logfiles
> We use informix online 7.11 and I think our applicaton behave a bit strange. > > After > onstat -l > > Buffer bufused bufsize numpages numwrits pages/io > P-1 0 16 0 0 0.00 > phybegin physize phypos phyused %used > 108b75 10000 …
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 …
Re: onstat -u, B-flag
Alexander Selg wrote: > > June Tong wrote: > > > > Alexander Selg (alexander.selg@siemens.at) wrote: > > The Problem was, that our UPDATE STATISTICS HIGH, which runs every day > for 29 tables, didn't come to all tables because it needs to much time > (after 24h the process contro…
Re: onstat -u, B-flag
Alexander Selg wrote: > > Hello All ! > > The command "onstat -u" gives some information about the userthreads. In > the 2.column you can see the flags to each thread. The 1.position > indicates the resource a thread is waiting for. > My question is: if there is a "B" on the 1.po…
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…
Re: onstat -u, B-flag
June Tong wrote: > > Alexander Selg (alexander.selg@siemens.at) wrote: > : The command "onstat -u" gives some information about the userthreads. In > : the 2.column you can see the flags to each thread. The 1.position > : indicates the resource a thread is waiting for. > : My que…
Re: onstat -u, B-flag
Alexander Selg (alexander.selg@siemens.at) wrote: : The command "onstat -u" gives some information about the userthreads. In : the 2.column you can see the flags to each thread. The 1.position : indicates the resource a thread is waiting for. : My question is: if there is a "B" o…
RE: onstat -u, B-flag
Alexander, Your session id 386 is waiting on a buffer, has issued a begin work, is the primary thread for the session and was executing an rsam call. You can find what kind of buffer it is waiting by running the following sql statement. SELECT is_wbuff , is_wlogbuff FROM sysse…
onstat -u, B-flag
Hello All ! The command "onstat -u" gives some information about the userthreads. In the 2.column you can see the flags to each thread. The 1.position indicates the resource a thread is waiting for. My question is: if there is a "B" on the 1.position, which means the thread is w…
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…
RE: Spooling all SQL Statements
In article <5ko05e$p9k@cssun.mathcs.emory.edu>, lperson@mcny.com (Lou Person) wrote: >We are sending sql statements to OWS from an >application. Is there anyway to "spool" all sql >statements which are sent to the server? Meaning, >can we store all SQL statements, which OWS …
Onstat question
When we use the Onstat -u , sometimes we get this display: onstat -u INFORMIX-OnLine Version 7.12.UC1 -- On-Line -- Up 11 days 20:31:52 -- 142096 Kbytes Userthreads address flags sessid user tty wait tout locks nreads nwrites 332c020 ---P--D 0 inf…
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…
onstat options
Hi, What are the best indicators of response time, trans/sec, and general load for monitoring an informix database... using the onstat program? Any help would be appreciated. Thanks Mark~…
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 …
Re: onstat
Steve Romankiw wrote: } } In onstat, what does "total" refer to. } } . } . } 1192132c Y--P--- 537 winterm - 12434068 0 1 240 } 0 } 13 active, 128 total, 44 maximum concurrent } } Thanks. } } Steve Romankiw } Executive Risk Inc. For Online 7.1, the total fi…
Re: onstat
Carol Davies wrote: } } Steve Romankiw wrote: } > } > In onstat, what does "total" refer to. } > } > . } > . } > 1192132c Y--P--- 537 winterm - 12434068 0 1 240 } > 0 } > 13 active, 128 total, 44 maximum concurrent } > } > Thanks. } > } > Steve Romankiw } >…
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: onstat
Steve Romankiw wrote: > > In onstat, what does "total" refer to. > > . > . > 1192132c Y--P--- 537 winterm - 12434068 0 1 240 > 0 > 13 active, 128 total, 44 maximum concurrent > > Thanks. > > Steve Romankiw > Executive Risk Inc. From the Informix Administrat…
onstat
In onstat, what does "total" refer to. . . 1192132c Y--P--- 537 winterm - 12434068 0 1 240 0 13 active, 128 total, 44 maximum concurrent Thanks. Steve Romankiw Executive Risk Inc.…
Re: shmdt: errno = 22
Double check the shared memory parameters Informix suggests for 7.12 for your kernel. Good Luck, Arun…
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…
onstat documentation
Does anybody have any good documentation for onstat? In case it varies to much from one version to the other I have online 7.11UC1. thanks…
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.…
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…
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: 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: Freeing logical logs
In article <347cc$f3014.14d@news.leg.wa.gov>, fry_ja@leg.wa.gov (Jason Fry) says: > >. This is the output of the onstat -l command > >address number flags uniqid begin size used >%used >88d988 1 U-B---- 16 203acd 5000 5000 etc ..... …
Freeing logical logs
I've finally backed up my logical log files, but they are still not free. This is the output of the onstat -l command address number flags uniqid begin size used %used 88d988 1 U-B---- 16 203acd 5000 5000 100.00 88d9a4 2 U-B…
Re: Good Buffer Size For Tuning Informix?
Chris Jenkins (chrisj@informix.com) wrote: : The only really important factor in determining the number of buffers is : the read and write cache hit ratios reported by tbstat -p. Keep : increasing the number of buffers until these cache hit rates do not : increase when the system…
ONSTAT question
Hi there. onstat -u (version 7.1) sometimes shows a user thread with position 1 of the flag field set to Y. The Informix manual says it means "Waiting for condition". I cannot find anything else. What is a condition, and why is my thread waiting for it? Thanks for any help Ba…
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: Keeping clean pages in shared memory
> If you have a DSS app, the buffer pool does not become dirty, so the > LRU_MAX_DIRTY will not have any impact. ...unless of course you're generating temp tables. Which just about all apps do at some time or another. akent@cix.compulink.co.uk (Andy Kent) ----------------------…
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: 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…