StorageTek Lifecycle Director DB2 Manager 312564001 User Manuals

Table of Contents

• Introduction

  10
• Product Description

  11
  • Introduction

    11
  • Product Functions

    12
    • Row migration

      12
    • Access to migrated rows

      13
      • Retrieval of migrated rows

        13
      • Update of migrated rows

        14
      • Deletion of migrated rows

        15
    • Management of migrated rows

      16
  • DB2 Manager storage configuration

    16
  • Product implementation

    17
  • DB2 management processing

    18
    • Database backup and recovery

      18
    • Database reorganization

      18
  • Pre-requisites for DB2 Manager implementation

    19
• Installation and Implementation

  21
  • Archive Manager implementation

    21
  • DB2 Manager implementation procedures

    21
    • Install distribution libraries

      22
    • Update DB2 Manager parameter library

      23
    • Perform MVS host system modifications

      24
    • Perform DB2 system modifications

      28
    • Define Archive Manager databases

      30
  • Verify DB2 Manager installation

    34
• DB2 Manager Parameter Specification

  37
  • General parameter format

    37
  • ENVCNTL parameters

    38
    • ENVCNTL: SMFRECID

      38
    • ENVCNTL: OBJSIZE

      39
    • ENVCNTL: READTIMEOUT

      39
    • ENVCNTL: WRITETIMEOUT

      40
  • TAPECNTL parameters

    40
    • TAPECNTL: MAXTRDR

      40
    • TAPECNTL: MAXDRDR

      41
    • TAPECNTL: MAXTWTR

      42
    • TAPECNTL: MAXSCHED

      42
    • TAPECNTL: MAXQLEN

      43
    • TAPECNTL: RETAINTAPE

      43
    • TAPECNTL: TAPEWAIT

      44
    • TAPECNTL: COMMAND

      45
• DB2 Manager Control Region

  47
  • Control region initialization

    47
  • Control region components

    49
  • Processing requests for access to migrated rows

    51
    • SQL SELECT processing

      51
    • SQL UPDATE processing

      52
    • SQL DELETE processing

      53
    • SQL error codes

      53
  • DB2 Manager operator interface

    53
    • Display summary status

      54
    • Display detail status

      57
    • Force purge task

      58
    • Purge task

      60
    • Alter DB2 Manager configuration

      61
    • Terminate DB2 Manager control region

      65
  • SMF processing

    66
    • SMF header section

      68
    • Record descriptor section

      69
    • Database section

      69
    • Request section

      70
  • Operational considerations

    73
    • Use of the MAXTRDR parameter

      73
    • Use of the MAXQLEN parameter

      74
    • Use of the MAXDRDR parameter

      75
    • Allocation recovery

      75
    • Shutdown processing

      76
    • 'Resource unavailable' condition

      77
• Table migration processing

  78
  • Introduction

    78
  • Enabling a DB2 table for migration processing

    78
    • Restrictions

      79
    • Enabling activities

      79
    • Disabling activities

      81
  • OTDBP100 - the table migration utility

    83
    • Functions

      84
    • JCL requirements

      85
    • SYSIN parameter specification

      85
    • SQLIN entry specification

      88
    • PARMLIB requirements

      89
    • Print reports

      89
    • Condition codes

      90
    • Utility failure and restart considerations

      90
    • Operator commands

      90
  • Data management processing

    91
    • DB2 table backup and recovery

      91
    • DB2 database reorganization

      91
    • Archive Manager database backup and recovery

      92
      • Archive Manager database backup

        92
      • Archive Manager database recovery

        93
• DB2 Manager Utilities

  96
  • OTDBP120 - the row restore utility

    96
    • Functions

      97
    • JCL requirements

      97
    • SYSIN parameter specification

      98
    • SQLIN entry specification

      100
    • Print reports

      101
    • Condition codes

      101
    • Utility failure and restart considerations

      101
    • Clean-up processing

      102
  • OTDBP130 - the pre-fetch utility

    102
    • Functions

      103
    • JCL requirements

      103
    • SYSIN parameter specification

      104
    • SQLIN entry specification

      105
    • Print reports

      106
    • Condition codes

      107
    • Utility failure and restart considerations

      107
    • Archive Manager housekeeping processing

      108
  • OTDBP140 - the table analysis utility

    108
    • Functions

      108
    • JCL requirements

      108
    • SYSIN parameter specification

      109
    • SQLIN entry specification

      110
    • Print reports

      111
    • Condition codes

      112
    • Utility failure and restart considerations

      112
  • OTDBP170 - the database housekeeping utility

    112
    • Functions

      113
    • JCL requirements

      113
    • SYSIN parameter specification

      114
    • SQLIN entry specification

      115
    • Print reports

      115
    • Condition codes

      116
    • Utility failure and restart considerations

      117
    • Archive Manager database maintenance

      117
• Messages and Codes

  121
  • OTD100xx – table migration utility messages

    121
  • OTD120xx – row restore utility messages

    128
  • OTD130xx – pre-fetch utility messages

    132
  • OTD140xx – table analysis utility messages

    135
  • OTD170xx – database housekeeping utility messages

    140
  • OTD200xx – control region master processor messag

    143
  • OTD220xx – control region scheduler messages

    157
  • OTD250xx – control region tape reader messages

    160
  • OTD254xx – control region disk reader messages

    163
  • OTD260xx – control region writer messages

    165
  • OTD270xx - control region housekeeping task messages

    168
  • DB2 Manager error and reason codes

    169
  • Control region return codes

    171
• Appendices

  175
  • Appendix A: Sample JCL members

    175