Re: To Tim Wajke: mail bounced

On Sat, 11 Feb 1995, Joe Lumbley wrote: > > Tim asked about the tablespace number 1000002 in the tbstat -k output. I > believe this tablespace tracks users. I'm not sure what Informix calls > it internally. It's like tablespace tablespace in that it's a "phantom". > Every time a user accesses the engine, there's a lock on this tablespace. > >From the "1xxxxxx" number, it's in the rootdbs. The name of the user can > be found by grepping for the owner's address (from the tbstat -k output) in > the output of tbstat -u. In my understanding, 1000002 is actually database tblspace, where entries of all database are kept along with an address to the systables of the database. That's why everytime a user access a row, there is a lock on this address (1000002) > > Does anyone else have more details about this tablespace and also the > "1000003" tablspace? 1000003 and onwards are propably tblspace tblspace, I don't know for sure. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Calvin Ng email: <calvinng@technet.sg> --------------------------------------------------------------------------- [DISCLAIMER] Read at your own risks. The author is not liable for any consequences directly or indirectly involved with reading this mail. This mail MAY NOT be interpreted as those of my employer's. --------------------------------------------------------------------------- This mail is sent with the help of Chameleon TCP/IP for Windows. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=