DB2 MANAGER USER GUIDE
LIFECYCLE DIRECTORTM
312564001
PART NUMBER
Page
Lifecycle Director DB2 Manager User Guide
Version
EC Revision C
Export Destination Control Statement
Restricted Rights
Limitations on Warranties and Liability
Proprietary Information Statement
DB2 MANAGER PARAMETER SPECIFICATION
Table of contents
INSTALLATION AND IMPLEMENTATION
DB2 MANAGER CONTROL REGION
INTRODUCTION
MESSAGES AND CODES
APPENDICES
DB2 MANAGER ERROR AND REASON CODES
OTD260XX – CONTROL REGION WRITER MESSAGES
CONTROL REGION RETURN CODES
Introduction
Product Description Introduction
Product Functions
Row migration
Access to migrated rows
Retrieval of migrated rows
Update of migrated rows
Deletion of migrated rows
DB2 Manager storage configuration
Management of migrated rows
Product implementation
Database reorganization
Database backup and recovery
DB2 management processing
Pre-requisitesfor DB2 Manager implementation
StorageTek Proprietary
This page is intentionally left blank
DB2 Manager User Guide
Archive Manager implementation
Installation and Implementation
DB2 Manager implementation procedures
Description
Install distribution libraries
Dataset Name
Update DB2 Manager parameter library
Perform MVS host system modifications
b. Create DB2 Manager control region procedure
d. Update the system Program Properties Table PPT
c. Assign DB2 Manager user identification
e. Update FLPA or MLPA definitions
f. Allocate DB2 Manager SMF record identifier
g. Perform tape management system changes
i. Update automated reply software controls
Perform DB2 system modifications
Access required
Resource type
Resource name
b. Create DB2 Manager application plan
Define Archive Manager databases
Enter the value ‘4’
Data retention
Database Enter the value ‘32760’. blocksize
Volume serial number Unit of allocation
DB2 Manager User Guide
Verify DB2 Manager installation
DB2 Manager User Guide
StorageTek Proprietary
DB2 Manager Parameter Specification
General parameter format
ENVCNTL parameters
ENVCNTL: SMFRECID
ENVCNTL: READTIMEOUT
ENVCNTL: OBJSIZE
TAPECNTL: MAXTRDR
ENVCNTL: WRITETIMEOUT
TAPECNTL parameters
TAPECNTL: MAXDRDR
TAPECNTL: MAXTWTR
TAPECNTL: MAXSCHED
TAPECNTL: MAXQLEN
TAPECNTL: RETAINTAPE
TAPECNTL: TAPEWAIT
TAPECNTL: COMMAND
StorageTek Proprietary
This page is intentionally left blank
DB2 Manager User Guide
DB2 Manager Control Region
Control region initialization
DB2 Manager User Guide
FLPA/MLPA storage
Control region components
Figure 4: Structure of DB2 Manager control region
DB2 Manager User Guide
StorageTek Proprietary
Processing requests for access to migrated rows
SQL SELECT processing
SQL UPDATE processing
SQL DELETE processing
SQL error codes
DB2 Manager operator interface
Display summary status
DBID
Stg level
Example
Display detail status
Manager database for update processing
A request to commit updates to an Archive
Manager database after completion of update
Force purge task
DB2 Manager User Guide
StorageTek Proprietary
Purge task
StorageTek Proprietary
Alter DB2 Manager configuration
DB2 Manager User Guide
StorageTek Proprietary
Valid parameters for the SET command are
DB2 Manager User Guide
MAXSCHED
MAXQLEN
RETAINTAPE
TAPEWAIT
DB2 Manager User Guide
StorageTek Proprietary
Terminate DB2 Manager control region
SMF processing
DB2 Manager User Guide
StorageTek Proprietary
SMF header section
Offset
Length
Format
Record descriptor section
Database section
Offset
Length
Request section
Offset
Length
Format
Offset
0 8 16 24
Length
Format
Offset
Length
Format
Description
Operational considerations
Use of the MAXTRDR parameter
Offset
Length
Use of the MAXQLEN parameter
Allocation recovery
Use of the MAXDRDR parameter
Shutdown processing
Resource unavailable condition
Table migration processing Introduction
Enabling a DB2 table for migration processing
Example
Restrictions
Enabling activities
where
Disabling activities
DB2 Manager User Guide
StorageTek Proprietary
OTDBP100 - the table migration utility
Functions
SYSIN parameter specification
JCL requirements
The following parameters may be specified
•LCDDBID =
•COMMIT = nnnnn
•RESTART=YES|NO
NEWTAPE=YES NO
•DB2SSID=xxxx
•PLAN=xxxxxxxx
•S100PRI=nnnnnnn
SQLIN entry specification
PARMLIB requirements
Print reports
Utility failure and restart considerations
Operator commands
Condition codes
DB2 database reorganization
DB2 table backup and recovery
Data management processing
Archive Manager database backup and recovery
Archive Manager database backup
Archive Manager database recovery
The procedure in each case is summarized below
1.Loss of individual tape volumes
2.Loss of entire database
DB2 Manager User Guide
DB2 Manager User Guide
StorageTek Proprietary
OTDBP120 - the row restore utility
DB2 Manager Utilities
DD entries should be specified as follows
Functions
JCL requirements
SYSIN parameter specification
A parameter entry has the general format
•PLAN=xxxxxxxx
•COMMIT = nnnnn|0
•INDEXONLY=Y|N
•S120PRI=nnnnnnn
SQLIN entry specification
•S120UNIT=xxxxxxxx
Print reports
Condition codes
Utility failure and restart considerations
the utility has been executed successfully
Clean-upprocessing
OTDBP130 - the pre-fetchutility
DD entries should be specified as follows
Functions
JCL requirements
SYSIN parameter specification
A parameter entry has the general format
SQLIN entry specification
PLAN=xxxxxxxx
Print reports
DB2 Manager User Guide
after processing the request
Condition codes
Utility failure and restart considerations
OTDBP140 - the table analysis utility
Archive Manager housekeeping processing
Functions
JCL requirements
SYSIN parameter specification
DD entries should be specified as follows
SQLIN entry specification
The following parameters may be specified
Print reports
oConcatenated DB2 key of row
OTDBP170 - the database housekeeping utility
Figure 5: Detailed table analysis report
Condition codes
Utility failure and restart considerations
DB2 Manager User Guide
Functions
JCL requirements
SYSIN parameter specification
DD entries should be specified as follows
•PLAN=xxxxxxxx
SQLIN entry specification
Print reports
Figure 6: Detailed processing report
Condition codes
Archive Manager database maintenance
Utility failure and restart considerations
DB2 Manager User Guide
StorageTek Proprietary
DB2 Manager User Guide
StorageTek Proprietary
StorageTek Proprietary
This page is intentionally left blank
DB2 Manager User Guide
Messages and Codes
OTD100xx – table migration utility messages
OTD10001 OPEN failed for xxxxxxxx dataset
DB2 Manager User Guide
OTD10012 Error locating ODCT
OTD10015 The control region is not active
DB2 Manager User Guide
OTD10021 Insufficient storage for workareas
OTD120xx – row restore utility messages
OTD12006 Insufficient storage for workareas
INDEXONLY processing
SORTOUT
OTD130xx – pre-fetchutility messages
OTD13006 Insufficient storage for workareas
INDEXONLY processing
OTD140xx - table analysis utility messages
OTD14001 OPEN failed for SYSIN|SQLIN dataset
OTD14006 Insufficient storage for workareas
OTD14007 Load failed for program DSNALI | DSNHLI2
DB2 Manager User Guide
DB2 Manager User Guide
OTD170xx – database housekeeping utility messages
OTD17006 Insufficient storage for workareas
DB2 Manager User Guide
OTD20001 Error opening parameter file SYSPARM
OTD20000 Enter request
OTD20004
OTD20008 ODCT GETMAIN failure
OTD20014 Error Xxx received attaching task tnnn
OTD20013 GETMAIN failure Xxx allocating task tnnn
OTD20016 OTDBP300 is not in Link Pack Area
OTD20017 Intercept successfully established
OTD20019 Error locating DB2 Manager ASCB | Jobname
OTD20030 Error received posting requestor ECB
OTD20034 Error X’xx’ received loading program
OTD20050 Missing or invalid request - ignored
OTD20052 Configuration altered successfully
OTD20051 Invalid Set operands - request ignored
OTD20058 Display processing completed
OTD20060 Task tnnn has been shutdown successfully
WAIT – the task is currently waiting for work
OTD20071 Invalid Purge operands – request ignored
OTD20091 Invalid Shutdown operands
OTD20093 Shutdown in progress
OTD20096 Shutdown processing complete
OTD220xx – control region scheduler messages
OTD20095 Communications table storage area freed
OTD22004 Invalid request on Scheduler Queue
OTD22009 Scheduler task nnn terminated
T=Snnn
OTD250xx – control region tape reader messages
OTD25004 Insufficient storage for workareas
OTD25005 Tape rdr task nnn initialization failed
OTD25007 Tape rdr task nnn abend Sxxx intercepted
OTD25009 Tape rdr task nnn terminated
OTD25013 Error xx received writing SMF record
OTD25404 Insufficient storage for workareas
OTD254xx – control region disk reader messages
OTD25401 Invalid ODRH received on entry
OTD25409 Disk rdr task nnn terminated
OTD25405 Disk rdr task nnn initialization failed
OTD25407 Disk rdr task nnn abend Sxxx intercepted
OTD26001 Invalid ODWH received on entry
OTD260xx – control region writer messages
OTD25413 Error xx received writing SMF record
OTD26004 Insufficient storage for workareas
OTD26005 Tape wtr task nnn initialization failed
OTD26007 Tape wtr task nnn abend Sxxx intercepted
OTD26009 Tape wtr task nnn terminated
OTD26013 Error xx received writing SMF record
OTD27001 Invalid ODCT received on entry
OTD27003 ODRE table is not valid
OTD27004 Insufficient storage for workareas
OTD27008 Hnnn request timed out - ODRE
DB2 Manager error and reason codes
OTD27005 Housekeeping task Hnnn terminated
Reason code Explanation hex
Reason code Explanation hex
0A00
Action
Action
Control region return codes
Reason code Explanation hex
brackets
Explanation
hex value in
Explanation
hex value in
brackets
DB2 Manager User Guide
Appendices
Appendix A: Sample JCL members
StorageTek Proprietary
OTDBDEF
DB2 Manager User Guide
DB2 Manager User Guide
StorageTek Proprietary
DB2 Manager User Guide
StorageTek Proprietary
StorageTek Proprietary
OTDBPKG
DB2 Manager User Guide
StorageTek Proprietary
OTDBPLAN
DB2 Manager User Guide
DB2 Manager User Guide
StorageTek Proprietary
Index
MLPA, MODIFY, 43, 46, 51, N new tape volume, O
F FLPA, FORCE, 56 force purge, H HLQ,
Host Software Component, 25, 72 housekeeping
failure, 117 housekeeping processing, 13 HSC, I
READTIMEOUT, 37, 53, 59, 60, 62, 63, 126, 171,
tape recycling, tape volume recovery,
R reader task,
selection criteria, 95, 99, 102 utility failure,
tape volume recycling,
updated row,
WRITETIMEOUT, 38, 53, 59, 60, 62,
database housekeeping, 13, 95,
∎Contact Us
Reader’s Comment Form
Publication Information
Questions and Comments
Storage Technology Corporation
BUSINESS REPLY CARD
Code:______________________
StorageTek Proprietary
NEED MORE INFORMATION?
ABOUT STORAGETEK
WORLD HEADQUARTERS