Manuel D’UtilisationTable des matièresIntroduction10Product Description11Introduction11Product Functions12Row migration12Access to migrated rows13Retrieval of migrated rows13Update of migrated rows14Deletion of migrated rows15Management of migrated rows16DB2 Manager storage configuration16Product implementation17DB2 management processing18Database backup and recovery18Database reorganization18Pre-requisites for DB2 Manager implementation19Installation and Implementation21Archive Manager implementation21DB2 Manager implementation procedures21Install distribution libraries22Update DB2 Manager parameter library23Perform MVS host system modifications24Perform DB2 system modifications28Define Archive Manager databases30Verify DB2 Manager installation34DB2 Manager Parameter Specification37General parameter format37ENVCNTL parameters38ENVCNTL: SMFRECID38ENVCNTL: OBJSIZE39ENVCNTL: READTIMEOUT39ENVCNTL: WRITETIMEOUT40TAPECNTL parameters40TAPECNTL: MAXTRDR40TAPECNTL: MAXDRDR41TAPECNTL: MAXTWTR42TAPECNTL: MAXSCHED42TAPECNTL: MAXQLEN43TAPECNTL: RETAINTAPE43TAPECNTL: TAPEWAIT44TAPECNTL: COMMAND45DB2 Manager Control Region47Control region initialization47Control region components49Processing requests for access to migrated rows51SQL SELECT processing51SQL UPDATE processing52SQL DELETE processing53SQL error codes53DB2 Manager operator interface53Display summary status54Display detail status57Force purge task58Purge task60Alter DB2 Manager configuration61Terminate DB2 Manager control region65SMF processing66SMF header section68Record descriptor section69Database section69Request section70Operational considerations73Use of the MAXTRDR parameter73Use of the MAXQLEN parameter74Use of the MAXDRDR parameter75Allocation recovery75Shutdown processing76'Resource unavailable' condition77Table migration processing78Introduction78Enabling a DB2 table for migration processing78Restrictions79Enabling activities79Disabling activities81OTDBP100 - the table migration utility83Functions84JCL requirements85SYSIN parameter specification85SQLIN entry specification88PARMLIB requirements89Print reports89Condition codes90Utility failure and restart considerations90Operator commands90Data management processing91DB2 table backup and recovery91DB2 database reorganization91Archive Manager database backup and recovery92Archive Manager database backup92Archive Manager database recovery93DB2 Manager Utilities96OTDBP120 - the row restore utility96Functions97JCL requirements97SYSIN parameter specification98SQLIN entry specification100Print reports101Condition codes101Utility failure and restart considerations101Clean-up processing102OTDBP130 - the pre-fetch utility102Functions103JCL requirements103SYSIN parameter specification104SQLIN entry specification105Print reports106Condition codes107Utility failure and restart considerations107Archive Manager housekeeping processing108OTDBP140 - the table analysis utility108Functions108JCL requirements108SYSIN parameter specification109SQLIN entry specification110Print reports111Condition codes112Utility failure and restart considerations112OTDBP170 - the database housekeeping utility112Functions113JCL requirements113SYSIN parameter specification114SQLIN entry specification115Print reports115Condition codes116Utility failure and restart considerations117Archive Manager database maintenance117Messages and Codes121OTD100xx – table migration utility messages121OTD120xx – row restore utility messages128OTD130xx – pre-fetch utility messages132OTD140xx – table analysis utility messages135OTD170xx – database housekeeping utility messages140OTD200xx – control region master processor messag143OTD220xx – control region scheduler messages157OTD250xx – control region tape reader messages160OTD254xx – control region disk reader messages163OTD260xx – control region writer messages165OTD270xx - control region housekeeping task messages168DB2 Manager error and reason codes169Control region return codes171Appendices175Appendix A: Sample JCL members175Taille: 2,2 MoPages: 189Language: EnglishOuvrir le manuel