StorageTek 312564001 manual

Contents

Main Page Page Page Page Page Page Product Description Row migration Access to migrated rows Retrieval of migrated rows Update of migrated rows Deletion of migrated rows Management of migrated rows Database backup and recovery Database reorganization Installation and Implementation Install distribution libraries Update DB2 Manager parameter library Perform MVS host system modifications Page Page Page Perform DB2 system modifications Page Define Archive Manager databases 3. Figure 1 - base database definition panel OTSN4300 Figure 2 - storage level definition panel OTSN4301 4. 1. Figure 3 - Access Method Services control panel OTSN4302 Page DB2 Manager Parameter Specification ENVCNTL: SMFRECID ENVCNTL: OBJSIZE ENVCNTL: READTIMEOUT ENVCNTL: WRITETIMEOUT TAPECNTL: MAXTRDR TAPECNTL: MAXDRDR TAPECNTL: MAXTWTR TAPECNTL: MAXSCHED TAPECNTL: MAXQLEN TAPECNTL: RETAINTAPE TAPECNTL: TAPEWAIT TAPECNTL: COMMAND DB2 Manager Control Region DB2 SQL SELECT processing SQL UPDATE processing SQL DELETE processing SQL error codes Display summary status Page Display detail status Force purge task 56 DB2 Manager User Guide StorageTek Proprietary Purge task 58 DB2 Manager User Guide StorageTek Proprietary Alter DB2 Manager configuration Page Page Terminate DB2 Manager control region Page SMF header section Record descriptor section Database section Request section Page Use of the MAXTRDR parameter Use of the MAXQLEN parameter Use of the MAXDRDR parameter Allocation recovery Shutdown processing 'Resource unavailable' condition Table migration processing Restrictions Enabling activities o Example: Disabling activities Page Page PARMLIB requirements Print reports Condition codes Utility failure and restart considerations Operator commands DB2 table backup and recovery DB2 database reorganization Archive Manager database backup and recovery Archive Manager database backup Archive Manager database recovery Page Page DB2 Manager Utilities Page Page Clean-up processing Page Page Page Archive Manager housekeeping processing Functions JCL requirements Page Page Figure 5: Detailed table analysis report Page Page Page Figure 6: Detailed processing report Utility failure and restart considerations Archive Manager database maintenance Page Page Messages and Codes Page Page Page Page Page Page Page Page Page Page Page Page Page Page messages Page messages Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page messages Page Page Page 172 DB2 Manager User Guide StorageTek Proprietary Appendices Appendix A: Sample JCL members StorageTek Proprietary OTDBDEF Member OTDBDEF creates the DB2 Manager system database. 174 DB2 Manager User Guide StorageTek Proprietary StorageTek Proprietary 176 DB2 Manager User Guide StorageTek Proprietary OTDBPKG Member OTDBPKG creates the DB2 Manager DB2 application packages. StorageTek Proprietary OTDBPLAN Member OTDBPLAN creates the DB2 application plan required for execution of DB2 Manager. 178 DB2 Manager User Guide StorageTek Proprietary Index Page Page Page Readers Comment Form Contact Us State____________________________________________ Zip Code:______________________ BUSINESS REPLY CARD Page NEED MORE INFORMATION? www.storagetek.com ABOUT STORAGETEK WORLD HEADQUARTERS