RE: Detached index rowid under onstat -k

More info which we may find useful, I had a case opened with Informix as well - >I checked and found that if there are multiple detached indexes to the table >all the locks placed on the indexes does show as K-1 ... but there is a >small difference ... if u check the partnum column it'll be different. >Looking at this column and cross checking with oncheck -pT output will tell >u exactly which index is locked. > >On further investigations, I found that if the indexes are attached indexes >then it'll show as K-1, K-2 and so on ... 'cos the index information is >stored in the Slot 4 of the partition page of the table. But , in case of a >detached index the engine stores the indexes in a separate partition page >(which is like a separate table for the engine) and not in the slot#4 of the >table partition page (that's the reason oncheck -pt <table_name> won't show >u the index information ... u have to use oncheck -pT in order to get the >info) and I guess that's the reason its showing K-1 for all indexes as >onstat is not able to differentiate whether this is the 1st index or 2nd >index ('cos of a value in the rstcb_t structure). But, since the partnum is >different I guess the customer can say which index is locked looking at the >output. Thanks for your help, John -----Original Message----- From: Art S. Kagel [mailto:kagel@bloomberg.net] Sent: Tuesday, November 02, 1999 4:09 PM To: informix-list@iiug.org Subject: Re: Detached index rowid under onstat -k "Porcello, John" wrote: > > The following is an example of a exclusive lock on a detached index. My > question is the need for an explanation of rowid and key#/bsiz columns. The > only information I can dig up is the following: > > rowid >six digits is an Index key value lock (What does the 0x186ea03 value > actually relate to?) > Key#/bsiz is Index key number or #bytes of varchar locked. (Does K- 1 relate > to the char(3) key value?) The 'K- 1' just means the first key/index. If the lock were a column lock on a BLOB or SBLOB where you can lock just part of the column this would be the size of the lock while the rowid would indicate the starting position. Art S. Kagel > Detached index(600329) (char(3),date,char(8),date) > > Locks > address wtlist owner lklist type > tblsnum rowid key#/bsiz > 200648990 20cdc3ab8 20cdce628 20060b5e0 HDR+X > 600329 186ea03 K- 1 > > TIA, > John E. Porcello, Jr., ICP, MCSE > Corporate DBA > Kaman Corporation > jep-corp@kaman.com > > My views and opinions may not reflect those of Kaman Corporation.