Friday, January 14, 2011

DB2 Specific Working Titbits

We can find if a table needs to be reorged or not by using the following query.

db2 "select tabschema,tabname from SYSIBMADM.ADMINTABINFO where reorg_pending='Y'"

To get the information about the Table and Schema from the TBSSPACEID and TableID use the following SQL.

SELECT C.TABSCHEMA, C.TABNAME,
C.COLNAME
FROM SYSCAT.TABLES AS T,
SYSCAT.COLUMNS AS C
WHERE T.TBSPACEID = 3
AND T.TABLEID = 258
AND C.COLNO = 6
AND C.TABSCHEMA = T.TABSCHEMA
AND C.TABNAME = T.TABNAME


Selecting or Generating the Next Value for a particular Sequence in DB2.

For example say we have a sequece name PAYMENT_TABLE_SEQ,  and we want to check wheather this sequence is working or not we can do it by
the following SQL in DB2,

values(NEXTVAL FOR PAYMENT_TABLE_SEQ ) 


Using the above we can generate the next value for a particular Sequence and also make sure that the sequence is working


No comments :

Post a Comment