Last time DB2 REORG was executed

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]... Read more →

Out of Office Message for DBA

As a DBA you are busy , so make an effort to leave a detailed out of office message. Your responsibilities may cover Production Support, tuning , capacity planning, consulting, programming, and anything database related from the Enterprise application through to storage. When you go on holiday – it’s the end of the world! That is nonsense. No need for panic! A well organised and risk aware IT organisation plans ahead and business continues as normal. That’s the theory. In practise , you may have a certain level of experience and specialities – where there isn’t backup. But usually there’s... Read more →