14 November,2013 by Tom Collins
Question: How can I find the last date & time of a DB2 reorg action?
Answer: The list history command using the REORG option , returns the history view of REORG activity on a database
Example of db2 list history of REORG returning ALL REORG activity.
db2 list history REORG ALL FOR mydatabase247
For full details usage use db2 ? list history
db2 "? list history" LIST HISTORY {BACKUP | ROLLFORWARD | REORG | CREATE TABLESPACE | ALTER TABLESPACE | DROPPED TABLE | LOAD | RENAME TABLESPACE | ARCHIVE LOG} {ALL | SINCE timestamp |CONTAINING {schema.object_name | object_name}} FOR [DATABASE] database-alias
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |