Personal tools
You are here: Home → DB2 → How To's → How to know what tables are in REORG PENDING
Navigation
Log in


Forgot your password?
 
Document Actions

How to know what tables are in REORG PENDING

from SYSIBMADM.ADMINTABINFO where REORG_PENDING = 'Y'



perform the command below to find out what tables are in REORG PENDING

 

db2 " select TABSCHEMA, TABNAME from SYSIBMADM.ADMINTABINFO where REORG_PENDING = 'Y'"

 

if do you want to generate a script to reorg all tables in reorg peding, execute the statement below:

 

db2 -x "select 'reorg table', substr(rtrim(TABSCHEMA)||'.'||rtrim(TABNAME),1,20), ';' \
from SYSIBMADM.ADMINTABINFO where REORG_PENDING = 'Y'"

 

 

 

 
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls