[DB2 z/OS] (1) Catching un-copied tablespaces (2) What kind of backup is done here?

Philip Sevetson

[DB2 z/OS] (1) Catching un-copied tablespaces (2) What kind of backup is done here?
Quick note: I've put a couple of SQL SELECT statements in the Code Place.
The first uses the DB2-on-Z catalog (SYSTABLES and SYSCOPY) to identify tablespaces and/or partitions where no recent copy has taken place.
The second uses the same objects to identify what kind of backup or LOAD activity has taken place recently.
The result sets for both queries are mildly "conversational".

--Phil
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**