IBM Support

How to find the database name and the table name from an tableId

Question & Answer


Question

In sysmgr.log, there are entries that shows "tableId". 2016-08-11 11:00:52.842985 EDT Warning: Disk/FPGA error has been detected on the disk - DISK_FPGA_ERROR  [hwId=1153, hwType=disk, diskHwId=1153, spuHwId=1307, location=Logical Name:'spa2.diskEncl4.disk1' Logical Location:'1st rack, 8th disk enclosure, disk in Row 1/Column 1', errType=3, errCode=116, oper=0, retries=0, dataPartition=1, lba=1642499, tableId=695299, dataSliceId=50, block=33598881, fpgaEngineId=6, fpgaBoardSerial=1233F58250613, devSerial=Y012UF28X0P0, diskModel=ST1000NM0001, diskMfg=IBM-ESXS, diskSerial=Z1N2CFRK0000C2508AH9, eventSource=system, errString=Disk/FPGA error encountered, reasonCode=1018] How to identify the table from the tableId?

Answer

In the log, the tableId is 695299. You can run the following query to identify the table name and the database name
SELECT b.objname AS dbname, a.objname AS tablename FROM _t_object a, _t_object b WHERE a.objid=<tableId> AND a.objdb=b.objid;

Replace the <tableId> with the one from the sysmgr.log
In this case,

$ nzsql -c "SELECT b.objname AS dbname, a.objname AS tablename FROM _t_object a, _t_object b WHERE a.objid=1024036 AND a.objdb=b.objid"
DBNAME | TABLENAME
--------+-----------
SYSTEM | TABLE1
(1 row)

$

[{"Product":{"code":"SSULQD","label":"IBM PureData System"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Administration","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.0.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

More support for:
IBM PureData System

Software version:
1.0.0

Document number:
288595

Modified date:
17 October 2019

UID

swg21996538

Page Feedback