Oninit® Archive
Results for “onstat -j”
Extending chunk capacity
Hi, in a 24x7 Informix v14.10, x86 SuSE linux instance with 2KB and 16K dbspaces and smart-blobspaces, with +250 chunks, we neede to grow the disk capacity and we are considering the option of extend chunk capacity instead of adding new chunks. We have successfully tested the fol…
unable to select, delete the data and unable to drop the table, response says Long transaction detected
Post your onstat -g seg, onstat -l, and onstat -d reports and we will try to help. Arr ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------…
monitoring session memory
Onstat –g afr can be useful as well…
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…
Block during checkpoint
HI Here I attach the onstat -g ckp output plus onstat -d // ------------------------------ ABeMie ------------------------------…
IDS not writing to online.log
Also, onstat - always has the same output…
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…
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 …
Re: RE: Which session is using the most cpu resour
since 11.50 there is also an onstat available for that purpose - onstat -g cpu…
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…
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…
Map temp tables to session
On Wednesday, December 26, 2012 2:16:37 PM UTC-5, mmura...@gmail.com wrote: > On Wednesday, December 26, 2012 1:12:14 PM UTC-5, DA wrote: > > > Hello, > > > > > > > > > > > > We are running informix 11.50.FC6X5. Is there anyway to map temp tables back to the original session tha…
Why cant I create a database in a dbspace ?
Do you see datadbs I the onstat -d report or in sysmaster:sysdbspaces? How did you add the datadbs dbspace? Art On Dec 10, 2012 10:58 AM, "FRANK J. COMPUTER" <frank_in_pr@hotmail.com> wrote: > 11.70.FC6 Developer Edition on Windows 7 Pro 64-bit: > > Downloaded via IIUG link an…
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.…
LRU Queues - more or less
onstat -F shows 0 LRU Writes…
Informix 10.00.TC5 CKPT REQ Logica Log Full
I can't add new log with onparams because Informix seems non reponding after FAST RECOVERY. I logged on Informix server with user informix and from the command prompt tryied to use some command but informix responds only to analysis commands like onstat, onlog ecc... I tryied t…
Is KAIO in use
Hi, You're right. I did a third test with no KAIOON parameter and I got this : informix@pthd02:pthdpthd_tcp:/produits/informix> env | grep KAIO IFMX_AIOKAIO_NUM_REQ=12288 informix@pthd02:pthdpthd_tcp:/produits/informix> oninit WARNING : If you intend to use J/Foundation or GLS…
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…
onstat -g ses output
Greetings, Can someone define or point me to a document that defines all of the output from the onstat -g ses session_id command? Specifically, I am interested in knbowing what this output section means: Host variables : address type flags value ---------…
Physical restore failed - function write physical
Hi, I have a dataserver on an AIX box. I made an ontape backup of this dataserver. Now, I'm trying to restore this backup on another AIX box where the source raw devices was created with differents names and differents links path names. I create à file (convert.txt) containing …
Fatal error in server row processing - SQL error -
Dunno if ya did this already - but look in the log file that hpl creates, usually /tmp to see if there is anymore detail. You may also dicker with onpladm commands to list and describe the various elements of the HPL load job - you may find the error come up again. You could try …
Application slow and data not saved
On Tue, Nov 10, 2009 at 18:28, MUMIN MARJUKI <mumin@akapost.com> wrote: > I have IDS v7.30.UC7 running on Solaris 2.6 with 1024Mb RAM and 1 CPU > 400Mhz . > There is 2 application db at this IDS. The problem is application will > running > slow and sometime data cannot be saved …
ANYONE KNOW IDS USERS OR CONSULTING FIRMS IN NYC
I am looking for work in the New York City metro area. Can anyone refer me to an end-user or a consulting firm?.. below is my resume: Frank J. Rotolo, frank.pr@msn.com _______________________________________________________________________________ Summary: Over twenty six years…
HPL Deluxe mode
Hi all, IDS 11.10 FC3 on solaris 10 I am trying to unload and load all the tables from a database using HPL!!! I have filetered out tables with unsupported datatypes and referenced by other tables (yet to create a mapping etc) and successfully completed my unload using: onploa…
onstat -g iov
No doubt the real answer is RTFM. But, can anyone give me or point me to a good description of the i/o -wakeup ratio, and why 0.5 is "good"?: onstat -g iov -r 5 IBM Informix Dynamic Server Version 10.00.FC8W2 -- On-Line (Prim) -- Up 81 days 06:27:37 -- 46892464 Kbytes AIO I/…
sessions to database question
The easiest way to do this is from command line: for i in `onstat -g sql | grep <db-name> | awk '{print $1}'`^J do^J onmode -z "$i"^J done^J`^J' --- On Tue, 1/20/09, John Moore <johnmoore@pdsi-software.com> wrote: From: John Moore <johnmoore@pdsi-software.com> Subject: session…
Problema con logs
Puedes enviar el archivo de log desed q se te presento el problema. saludosThe freedom of Linux ... The power of Informix> To: ids@iiug.org> From: jeansagi.ifx@gmail.com> Subject: Re: Problema con logs [14228]> Date: Sat, 6 Dec 2008 01:31:14 -0500> > > Que puedo hacer con esto..…
Hex function on 64-bit addresses
DS 10.00.FC0 HP-UX b.11 64-bit IDS and OS Greetings, family. I am trying to write some bizarre SQL (would I write any other kind? ;-) on sysmaster. One of the columns is an address that would appear in the output of "onstat -b", if I have understood it correctly. In onstat -…
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…
Random problems with performance in IDS 10 TC6
On 3 Sep, 22:48, Obnoxio The Clown <obno...@serendipita.com> wrote: > kem...@gmail.com wrote: > > Has anyone had similar problems? Any ideas on what to look for or > > check? > > Post the output from: > > onstat -C > onstat -C hot > onstat -C all > > If the last one is too big, e…
RE: XPS 8.1
OK. I noticed that there is no "oncheck". That is one of the commands that I need to know how to replace. Also, any other commands that I may want to use to check things. I look forward to hearing from you. Larry> To: ids@iiug.org> From: jack.parker4@verizon.net> Subject: RE: XP…
Understanding the Logical Log Usage
Am using version 10.00.UC7X1 and have a few *basic* questions on the usage of the logical log file. The database has a logging mode of unbuffered logging with a page size is 2048 bytes (as returned by onstat -b). I have 3 log files with each file being 5000 KB in size. I have a …
3 parameter/onstat questions
I just got off the chat-with-labs with John Miller. He left me with 3 questions I am hoping to get more info about, having failed to get anything useful from the version 10 docs. I'm on ids10.0.fc5. 1) He strongly recommended having the chunk mode set to expanded 'always'. He sa…
"tty" column in onstat -u
(HP-UX 11i, IDS9.30HC5) Just a comment, really, and wondering if this is the same on other systems? Doing a remote dbaccess query from one box to another, I've found that when I do an 'onstat -u' on the target machine, under the 'tty' column it shows the tty of the session on th…
Ip for a network session
onstat -g ses look under "hostname"...…
Re: tblsnum in onstat -k
Sounds good... select * from syslocks.... is easier.. Superboer way fast=http://www.clipjes.nl/clip/nederlands/n/normaal_- _oerend_hard.html On 6 dec, 01:30, mohitanch...@gmail.com wrote: > Version IDS 10: > > Is following sql correct to retrieve associated table for that lock…
tblsnum in onstat -k
Version IDS 10: Is following sql correct to retrieve associated table for that lock listed in onstat -k: select * from sysptnhdr where hex(partnum) = tblsnum; or select * from systabnames where hex(partnum) =tblsnum;…
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…
onstat -a runaway process
Greetings, family (if y'all haven't disowned my by now ;-) We have a problem (so what else it new) with onstat -a: we have a script that periodically runs onstat -a and oncheck -pe. The onstat occasionally starts to eat CPU and the user calls us DBAs to kill the process. If s…
sysmaster question
Jack, This is to be expected. There are other I/O activities that take place at the chunk/dbspace/disk level that do not pertain to any specific table. Look for John Miller III presentation on Understanding Onstat. I think it was a chat with the lab last year so it will be…
monitoring load
IDS 10, RedHat Linux Which onstat tells me that there are threads waiting to be processed? - onstat -g wai or - onstat -g rea TIA. Bob…
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 …
onstat -u and IDS maximum concurrent sessions
I believe it's the maximum amount of user threads that the db has allocated control blocks for, up to the current snapshot. Bob Roussey Unix / Informix Administration Robert.Roussey@SpiritAir.com -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org…
running onstat commands against a shared memory du
Is it on the same box as the instance itself? Because onstat against a dump file has to load the entire file into memory. So if you have 6 Gig, and 4 Gig is already taken by the informix instance, you will get error -28 attempting to load the segment. ----- Original Message --…
record locked
a combination of onstat -k and onstat -u…
Performance issue after 732 to 94fc6 upgrade
Sorry, the previous posting of with the onstat output file did not have the sequence of onstat commands. They were in order: informix211 /tmp$ onstat -g cac >> retwa.stats.out informix212 /tmp$ onstat -p > retwa.statsdone.out informix213 /tmp$ onstat -d >> retwa.statsdone.out inf…
help on onstat
hi, please help me how to leave onstat -i mode? thanks…
who locks a record?
onstat -k followed by an onstat -u…
onstat -g ath
ok, but if I make onstat -g sql [sid] -r 2 I see many output IBM Informix Dynamic Server Version 9.40.TC5 -- On-Line -- Up 12:16:04 -- 366464 Kbytes Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 597 EXEC PROCEDURE db1 DR Wait 5 0 0 …
HP-UX KAIOON
Shouldn't there be any kio vp's in then onstat output?…
Re: Track a session to a Buffer
onstat -b/-B/-X would be your friends.…
Re: MGM Mutex Locks hangs the system
What OS and version? What Informix version? What mutex locks? onstat -g mgm gives? onstat -g lmx gives? onstat -s gives?…
Error Dopping Temp DB Space
How does it show up on 'onstat -d update'?…
Re: IDS 10.0 error writing to /dev/null under Solaris only
On 05/10/2005 08:55 PM, Neil Truby wrote: > Here's a funny thing: > > On HP-UX: > ======== > $ onstat -V > IBM Informix Dynamic Server Version 10.00.HC1 Software Serial Number > AAA#B000000 > $ uname -a > HP-UX sal B.11.11 U 9000/800 2012393627 unlimited-user license > $ dbac…
RE: IDS 10.0 error writing to /dev/null under Solaris only
Don't know if it's relevant, but on all my Sun boxes (5.8 and 5.9) /dev/null is a hard link to /devices/pseudo/mm@0:null. Admittedly the underlying permissions match yours, but it may have some bearing. Haven't got IDS 10 to test, but IDS 7 and 9 both output OK. $ls -al /dev/nul…
RE: IDS 10.0 error writing to /dev/null under Solaris only
Hi Neil. I got the same error message. Here is my environment. [tsutoo@bygzam work]% onstat -V IBM Informix Dynamic Server Version 10.00.FC1 Software Serial Number AAA#B000000 [tsutoo@bygzam work]% uname -a SunOS bygzam 5.8 Generic_117350-06 sun4u sparc SUNW,UltraAX-i2 […
IDS 10.0 error writing to /dev/null under Solaris only
Here's a funny thing: On HP-UX: ======== $ onstat -V IBM Informix Dynamic Server Version 10.00.HC1 Software Serial Number AAA#B000000 $ uname -a HP-UX sal B.11.11 U 9000/800 2012393627 unlimited-user license $ dbaccess stores_demo << !^Joutput to /dev/null^Jselect * from cus…
Re: Number of user license
Joseph Dimech wrote: > I'm not sure about the scheme you have shown. It was about right at one time. It is no longer relevant. > But when do an onstat -u I get > the following information at the end of the output: > > 14 active, 128 total, 24 maximum concurrent > Does this mea…
Transaction Rollback
onstat -x…
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: Stuck in Fast Recovery
Oops, sorry - so used to speaking to other Unix users :-o Apologies -----Original Message----- From: Sebastian, Norma J. [mailto:NormaJean.Sebastian@tellabs.com] Sent: 19 January 2005 04:59 PM To: Dirk Moolman; informix-list@iiug.org Subject: RE: Stuck in Fast Recovery Dude,…
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…
RE: SQL Tracing tools?
Sebastian, Norma J. wrote: > > You said sqlidebug and sqliprint are "internal tools". > Would that be internal as in onstat used to be 'internal'/undocumented > feature.... > Or are they "internal tools" as in you have to get them from IBM? > I've checked the SQL syntax and refe…
HPL Hangs...
David, from your other post I assume you are on AIX? By any chance, do you have a multiprocessor machine with Power4 CPU's? If so, you might run into a known issue with Power4 architecture which impacts HPL. The AIX command prtconf should tell which kind of CPU's you have ... o…
RE: onpload - assert fails, mt_shm_alloc problem?
try the following, one thing at a time 1. bounce the engine and try the onpload command 2. make sure there are no hung share memory segments 3. drop and re-create the onpload database and try the command 4. set IPLOAD_VMSIZE to 9000, then 12000 or 14000 and try the command (you …
onpload - assert fails, mt_shm_alloc problem?
Hi team Using onpload in command-line mode and with commands that used to work on our IDS7.31, HP-UX10.20 setup is now failing under IDS9.30HC5, HP-UX11i with messages: =============================================================================== 12:17:49 No symbol table found…
Re: database market share 2003
"Serge Rielau" <srielau@ca.eye-be-em.com> wrote in message news:c9ajht$29j$1@hanover.torolab.ibm.com... > Data Goob wrote: > > > You can even start out without shared-nothing, no clusters > > at all with DB2, play with it in the same configuration as Oracle if you > > want to com…
RE: Informix licenses
Norm, I think the are two ways to do that: 1. Try to find Your license agreement 2. Dump the serial number with 'onstat -V' (smth like 'ABC#J123456) and try to contact Informix sales rep (or even support engineer) to ask them to find this information in their database by the ser…
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…
onstat -F
What does the "data" column in onstat -F output signify? Where is this documented? Thanks Andy…
Re: High lngspins - IDS 9.30 UC2
Thanks to Simmons, Mark and Obnoxio. We are running UPD STATS every night by a cron job. So I don't think UPD STATS would be a potential issue. I will be posting onstat -g spi and other onstat soon as advised by Obnoxio. Hari "Hari Gupta" <hariog@yahoo.com> wrote in message news…
Re: High lngspins - IDS 9.30 UC2
Hmm, well my first inclination would be to recommend that you update statistics, if you have not done so already. You may well be right that the sequential scans were an issue before the upgrade, but I would not rule out that the optimizer is making different [not always good] c…
High lngspins - IDS 9.30 UC2
Hi All, We have recently upgraded IDS 9.21UC3 to IDS 9.30 UC3 on RHL 7.3 (Kernel - 2.4.18-27.7.xbigmem). Platform - Dell PE6600 - Quard Xeon, dual channel, 8GB RAM - HT. Channel-A has 8 72 GB mirror & stripped and Channel-B has got 8 36 GB mirror & stripped. I have been keeping…
RE: 7.x to 9.x Performance issue in the extreme
Try running onstat -g ses SESSION_ID for the session that is taking so long. Assuming you are correct about the hardware resources being adequate, I'd look for this session or the application process that started the session to be waiting on some condition. Maybe a lock or some …
RE: HPL hangs server
> -----Original Message----- > From: Pravin Kedia [SMTP:kedia@us.ibm.com] > Sent: Wednesday, August 27, 2003 10:23 AM > To: Bill Dare > Cc: 'informix-list@iiug.org'; owner-informix-list@iiug.org > Subject: Re: HPL hangs server > > > > > > > Hi Bill, > > Allocating lot of shared m…
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…
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 …
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…
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 …
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 …
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…
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…
Re: onmode -F
We had a similar situation with IDS 7.30.UC7XB several months ago. Occasionally, when we'd run "onmode -F", our engine would go out to lunch and force us to shutdown/restart. After upgrading to IDS 7.30.UC7XL the problem went away. If you continue seeing the problem I'd contact…
Re: onmode -F
I've never seen aproblem using onmode -F. Note that if you run onstat -g seg you can identify which and if any segments will actually be freed by onmode -F. These will be 95% or more unused meaning only overhead pages have been allocated. If a segment is not unused onmode -F w…
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…
problem with onstat -p "pagreads" value decrementing
In article <8ghgs8$59j$1@news.mathworks.com>, Ben Draper <bdraper@mathworks.com> writes >I assure you that the counter is not rolling over. > >I'm seeing the counter go from (1 example) 5602893 to 3536618 and then the >number gradually climbs as you'd expect it to... > > onstat…
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…
Kernel I/O on AIX 4.3.x
Did you check to see if it is actually configured. do an lsattr -E -l aio0 to verify that the aio subsystem has been configured/ Are you using logical volumes, if so make sure that you are using raw logical volumes. Have you rebooted the system, if so make sure that in the attrib…
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: rootdbs size?
From: William Rice <ricew@operamail.com> > >onstat -c >onstat -m >onstat -d >onstat -D >onstat -p >onstat -P | tail -5 >onstat -R >onstat -F >onstat -g seg I feel like I'm stuck in a time loop! ______________________________________________________ Get Your Private, Free Email a…
Posting from the Informix-list
onstat -g ntd Nona…
buffer usage
Parker, J wrote: > > Was hoping all you geniuses could lend a hand. > > Thanks in advance > > onstat -P > shows a large usage of buffers (14,874) on our system to be associated with > partnum=0 [output SNIPPED] Not to worry it just means that there are 14,874 buffers unused, ie …
DBSPACETEMP (<<< sigh >>>)
looking at onstat -d doesn't always tell you if a DBSPACETEMP variable has been set. Onstat -d will only tell you if the dbspace that was created from the get go was set as temp. For example, if you create a dbspace called 'dbspace1' and don't set it as temp, you won't see the …
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. …
Re: IDS 7.31 hangs during checkpoint
This sounds like a bug that we have been fighting with in 7.31.UC4. Tech support told us that it was a timing issue, that a table created (for us, in sysmaster database) during a checkpoint would hang the server (and this includes temp tables required for such SQL features such a…
system catalog cleanup
"Thomas J. Girsch" wrote: > > I'm afraid I already know the answer to this, but is there any way to > defragment (i.e., "clean up the extent interleaving") of the system catalog > tables, short of dropping the database and recreating it? I've got a 100+ > GB database that has sy…
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.…
Re: IDS and Linux
Thank you for quick respond. Finally I found the problem. Kire Prostizenovski wrote: > > Check your system message log file, as set by MSGPATH in your $ONCONFIG > file. > > Regards, > > Kire > > Kire Prostizenovski > Business Analyst > J Blackwood and Son Limited > 13 Cooper Str…
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: …
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…
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é…
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: 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…
RE: dbimport - Long Transaction Aborted
When doing a dbimport of a large database (i.e., larger than your logical logs / long-transaction parameters can handle), do NOT set your logging mode on the dbimport command line ("-l" or "-l buffered"). Instead, just let it do the default of unlogged mode for the database. Af…
Re:dbimport - Long Transaction Aborted
>>I am trying to use dbimport to make a copy of my >>database. This worked just >>fine 2 weeks ago. I received the following error from >>dbimport while it is >>running "create unique index": >> >> 458 - Long Transaction aborted. >> >>We are running Informix 7.23.UC2 on SunOS …
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…
Modifying a stored procedure
"Thomas J. Girsch" wrote: > > You're running into the stored procedure cache. Have a look at onstat -g > spc to see which procedures are currently being cached. > > Not sure how to flush them out of the cache, although I'm sure it's in the > manual. > > Micha Meier wrote in mess…
onstat & vmstat CPU measurements
Greetings, I'm trying to calibrate CPU utilisation on our system using onstat, "ps -el" (both updated before and after a test job) and vmstat (updated every second). onstat's view of CPU utilisation appears to be pretty much consistent with that reported by "ps -el", but these a…
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…
Re: Online command to get status
J.-M. Gimenes H. Zalkind (jmg-hz@calva.net) wrote: : Hi, : : I am running Informix 7.23 UC5 on Solaris 2.6 : : I need to know an Informix command (quick online command I can include : in a script) to get status of Informix server (Quiescent, On-Line, : Recovery...). : : I thought…
Re: Script to find 'active' IDS 7.2x threads
Thomas J. Girsch wrote in message <363f83a4.0@news.one.net>... >What's wrong with onstat -g act? > >Or the sysmaster database, for that matter? > >The Wilcoxons wrote in message <71nr8s$lo6$1@nw003t.infi.net>... >>Here is a script we have used to track 'active' threads in IDS 7.2…
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…
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 -- -------------------------------------------------------------------------…
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…
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: Tables locked
You need to query the systables to get the tblspace num (tblsnum) use tblsnum for the table that is locked. use your onstat -k and look for the tblsnum and look accross to the owner column. do an onstat -u | grep 'address' (from onstat -k) this is the address associated with the…
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…
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…
Novice needs tuning help!
Hello, I've included a zip file of an onstat -a. Can anyone tell this informix novice any obvious problems or changes I can make to improve performance for my OLTP application? I'm running Informix Online 7.22 on a Sun SPARC Ultra-2 with 128K RAM (Solaris 2.5.1). Thank you! …
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 …
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 …
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??…
Re: Update statistics bug
Vickey - Looks like this query is a PDQ (Parallel Data Query) job. The 'sqlexec thread is sort of a parent thread; that's the controller and coordinator of the job, and what communicates with the user or front end. The 'scan_5.0' and 'scan_6.0' threads are (as their name impli…
Re: Monitoring all SQL statements
Assuming you're running OnLine 7.X, there are several ways. As one person suggested, if you can control the SQL, put a "SET EXPLAIN ON" at the beginning of the SQL and it will give you the statements run, as well as optimizer info, in a file called sqexplain.out. But if you had…
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…
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…
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…
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~…
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 } >…
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.…
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…
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: dbspace space report
In Article<3sn8fn$9k0@cssun.mathcs.emory.edu> > From: GESJOBER@ADM1.byu.edu (Glen Sjoberg) > Newsgroups: comp.databases.informix > Subject: dbspace space report > Date: 26 Jun 1995 17:23:03 -0400 > > ... > > I was just about to write a script that would do a tbstat -d for each > …
Re: Informix manuals online
In article <1994Sep21.205858.7411@rpslmc.edu>, rja@sispro.sis.rpslmc.edu (Roger J. Allen) writes: |> Malcolm Weallans (onlinedbc@cix.compulink.co.uk) wrote: |> : I'm not sure who said what here. However:- |> : > In article <jlumbleyCtu5BB.6KF@netcom.com>, jlumbley@netcom.com (Jo…
Re: Informix manuals online
Malcolm Weallans (onlinedbc@cix.compulink.co.uk) wrote: : I'm not sure who said what here. However:- : > In article <jlumbleyCtu5BB.6KF@netcom.com>, jlumbley@netcom.com (Joe : > Lumbley) writes: : > > Hey, we're getting closer! : > > Tim Schaefer : > tschaefe@encore.com [stuff d…