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

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