onstat -g opn

I am looking for a SMI query version of onstat -g opn <tid> I have written a script which takes the output of onstat -g opn <tid> and runs a query but I think a SMI query would be much cleaner. Any ideas what table houses the open tables for a thread? TIA. Sent via Deja.com http://www.deja.com/ Before you buy.

I like to search the system catalogs to find the corresponding tables. select tabname, a.* from syscolumns A, systables B where colname matches "*ucount*" and A.tabid = B.tabid tabname sysptntab colname ucount tabid 122 colno 5 coltype 1 collength 2 colmin colmax extended_id 0 So.... select * from sysptntab; Ray cyclonejls@my-deja.com wrote: > > I am looking for a SMI query version of onstat -g opn <tid> > > I have written a script which takes the output of onstat -g opn <tid> > and runs a query but I think a SMI query would be much cleaner. > > Any ideas what table houses the open tables for a thread? > > TIA. > > Sent via Deja.com http://www.deja.com/ > Before you buy.

Curiosity: What is "onstat -g opn" for ? In article <39AEA759.28FA9D03@informix.com>, Ray Canuel <rayc@informix.com> wrote: > I like to search the system catalogs to find the corresponding tables. > > select tabname, a.* from syscolumns A, systables B > where colname matches "*ucount*" > and A.tabid = B.tabid> > tabname sysptntab > colname ucount > tabid 122 > colno 5 > coltype 1 > collength 2 > colmin > colmax > extended_id 0 > > So.... > > select * from sysptntab;> > Ray > > cyclonejls@my-deja.com wrote: > > > > I am looking for a SMI query version of onstat -g opn <tid> > > > > I have written a script which takes the output of onstat -g opn <tid> > > and runs a query but I think a SMI query would be much cleaner. > > > > Any ideas what table houses the open tables for a thread? > > > > TIA. > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. > Sent via Deja.com http://www.deja.com/ Before you buy.