RE: onstat -k and tblsnum?
DATABASE sysmaster;
SELECT dbsname, tabname, HEX(partnum) tblsnum
FROM systabnames
WHERE HEX(partnum) matches "*100002";
results:
------------------------------------------------------------------------------
---------------
dbsname tabname tblsnum
sysmaster sysdatabases 0x00100002
Hope this helps,
Will
>===== Original Message From "Henderson, Scott" <SHenderson@purolator.com>
=====
>Folks,
>
>Need some help. An application is experiencing locking problems, and 243
>errors.
>
>How can I find out which table belongs in tblsnum. Part of the output of
>onstat -k reports on tblsnum, I want to determine which table in which>database is in trouble. Querying syslocks revealed nothing, 0 rows
>returned. onstat -k|grep X|wc -l returns > 600. Turns out there is a bug
>(#114583) in all versions of IDS 7.3x.
>
>HPUX-11.0
>IDS 7.30FC7
>
>Regards,
>Scott Henderson
------------------------------------------------------------
This e-mail has been sent to you courtesy of OperaMail, as a free service from
Opera Software, makers of the award-winning Web Browser, Opera. Visit us at
http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail
account is waiting at: http://www.operamail.com/
------------------------------------------------------------