Manuals / StorageTek / Household Appliance / Water System

StorageTek 312564001 manual DB2 Manager User Guide, StorageTek Proprietary

Models: 312564001

1 189

Download 189 pages 56.09 Kb

Page 36

DB2 Manager User Guide	33
StorageTek Proprietary

Image 36

StorageTek 312564001 manual DB2 Manager User Guide, StorageTek Proprietary

Contents

DB2 MANAGER USER GUIDE LIFECYCLE DIRECTORTM312564001 PART NUMBERPage Version EC Revision CLifecycle Director DB2 Manager User Guide Export Destination Control Statement Restricted RightsLimitations on Warranties and Liability Proprietary Information StatementTable of contents INSTALLATION AND IMPLEMENTATIONDB2 MANAGER PARAMETER SPECIFICATION DB2 MANAGER CONTROL REGION INTRODUCTION MESSAGES AND CODES APPENDICES DB2 MANAGER ERROR AND REASON CODESOTD260XX – CONTROL REGION WRITER MESSAGES CONTROL REGION RETURN CODESIntroduction Product Description Introduction Product Functions Row migrationAccess to migrated rows Retrieval of migrated rowsUpdate of migrated rows Deletion of migrated rows DB2 Manager storage configuration Management of migrated rowsProduct implementation Database backup and recovery DB2 management processingDatabase reorganization Pre-requisitesfor DB2 Manager implementation This page is intentionally left blank DB2 Manager User GuideStorageTek Proprietary Installation and Implementation DB2 Manager implementation proceduresArchive Manager implementation Install distribution libraries Dataset NameDescription Update DB2 Manager parameter library Perform MVS host system modifications b. Create DB2 Manager control region procedured. Update the system Program Properties Table PPT c. Assign DB2 Manager user identificatione. Update FLPA or MLPA definitions f. Allocate DB2 Manager SMF record identifier g. Perform tape management system changesi. Update automated reply software controls Perform DB2 system modifications Access required Resource typeResource name b. Create DB2 Manager application planDefine 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 ProprietaryDB2 Manager Parameter Specification General parameter formatENVCNTL parameters ENVCNTL: SMFRECIDENVCNTL: READTIMEOUT ENVCNTL: OBJSIZEENVCNTL: WRITETIMEOUT TAPECNTL parametersTAPECNTL: MAXTRDR TAPECNTL: MAXDRDR TAPECNTL: MAXTWTR TAPECNTL: MAXSCHEDTAPECNTL: MAXQLEN TAPECNTL: RETAINTAPETAPECNTL: TAPEWAIT TAPECNTL: COMMAND This page is intentionally left blank DB2 Manager User GuideStorageTek Proprietary DB2 Manager Control Region Control region initializationDB2 Manager User Guide Control region components Figure 4: Structure of DB2 Manager control regionFLPA/MLPA storage DB2 Manager User Guide StorageTek ProprietaryProcessing requests for access to migrated rows SQL SELECT processingSQL UPDATE processing SQL error codes DB2 Manager operator interfaceSQL DELETE processing Display summary status DBID Stg levelExample Display detail status Manager database for update processingA request to commit updates to an Archive Manager database after completion of updateForce purge task DB2 Manager User Guide StorageTek ProprietaryPurge task Alter DB2 Manager configuration DB2 Manager User GuideStorageTek Proprietary Valid parameters for the SET command are DB2 Manager User GuideStorageTek Proprietary MAXSCHED MAXQLENRETAINTAPE TAPEWAITDB2 Manager User Guide StorageTek ProprietaryTerminate DB2 Manager control region SMF processing DB2 Manager User Guide StorageTek ProprietarySMF header section OffsetLength FormatRecord descriptor section Database sectionOffset LengthRequest section OffsetLength FormatOffset 0 8 16 24Length FormatOffset LengthFormat DescriptionOperational considerations Use of the MAXTRDR parameterOffset LengthUse of the MAXQLEN parameter Allocation recovery Use of the MAXDRDR parameterShutdown processing Resource unavailable condition Table migration processing Introduction Enabling a DB2 table for migration processingRestrictions Enabling activitiesExample where Disabling activities DB2 Manager User Guide StorageTek ProprietaryOTDBP100 - the table migration utility Functions SYSIN parameter specification JCL requirementsThe following parameters may be specified •LCDDBID =•COMMIT = nnnnn •RESTART=YES|NONEWTAPE=YES NO •DB2SSID=xxxx•PLAN=xxxxxxxx •S100PRI=nnnnnnnSQLIN entry specification PARMLIB requirements Print reportsOperator commands Condition codesUtility failure and restart considerations DB2 table backup and recovery Data management processingDB2 database reorganization Archive Manager database backup and recovery Archive Manager database backupArchive Manager database recovery The procedure in each case is summarized below 1.Loss of individual tape volumes2.Loss of entire database DB2 Manager User GuideDB2 Manager User Guide StorageTek ProprietaryOTDBP120 - the row restore utility DB2 Manager UtilitiesFunctions JCL requirementsDD entries should be specified as follows SYSIN parameter specification A parameter entry has the general format•PLAN=xxxxxxxx •COMMIT = nnnnn|0•INDEXONLY=Y|N •S120PRI=nnnnnnnSQLIN entry specification •S120UNIT=xxxxxxxxPrint reports Condition codesUtility failure and restart considerations the utility has been executed successfullyClean-upprocessing OTDBP130 - the pre-fetchutilityFunctions JCL requirementsDD entries should be specified as follows SYSIN parameter specification A parameter entry has the general formatSQLIN entry specification PLAN=xxxxxxxxPrint reports DB2 Manager User GuideCondition codes Utility failure and restart considerationsafter processing the request OTDBP140 - the table analysis utility Archive Manager housekeeping processingFunctions JCL requirementsSYSIN parameter specification DD entries should be specified as followsSQLIN entry specification The following parameters may be specifiedPrint reports oConcatenated DB2 key of rowOTDBP170 - the database housekeeping utility Figure 5: Detailed table analysis reportCondition codes Utility failure and restart considerationsFunctions JCL requirementsDB2 Manager User Guide SYSIN parameter specification DD entries should be specified as followsSQLIN entry specification Print reports•PLAN=xxxxxxxx Figure 6: Detailed processing report Condition codesArchive Manager database maintenance Utility failure and restart considerationsDB2 Manager User Guide StorageTek ProprietaryDB2 Manager User Guide StorageTek ProprietaryThis page is intentionally left blank DB2 Manager User GuideStorageTek Proprietary Messages and Codes OTD100xx – table migration utility messagesOTD10001 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 | DSNHLI2DB2 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 requestOTD20004 OTD20008 ODCT GETMAIN failure OTD20014 Error Xxx received attaching task tnnn OTD20013 GETMAIN failure Xxx allocating task tnnnOTD20016 OTDBP300 is not in Link Pack Area OTD20017 Intercept successfully establishedOTD20019 Error locating DB2 Manager ASCB | Jobname OTD20030 Error received posting requestor ECB OTD20034 Error X’xx’ received loading program OTD20050 Missing or invalid request - ignoredOTD20052 Configuration altered successfully OTD20051 Invalid Set operands - request ignoredOTD20058 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 progressOTD220xx – control region scheduler messages OTD20095 Communications table storage area freedOTD20096 Shutdown processing complete OTD22004 Invalid request on Scheduler Queue OTD22009 Scheduler task nnn terminated T=SnnnOTD250xx – control region tape reader messages OTD25004 Insufficient storage for workareas OTD25005 Tape rdr task nnn initialization failedOTD25007 Tape rdr task nnn abend Sxxx intercepted OTD25009 Tape rdr task nnn terminatedOTD25013 Error xx received writing SMF record OTD254xx – control region disk reader messages OTD25401 Invalid ODRH received on entryOTD25404 Insufficient storage for workareas OTD25405 Disk rdr task nnn initialization failed OTD25407 Disk rdr task nnn abend Sxxx interceptedOTD25409 Disk rdr task nnn terminated OTD260xx – control region writer messages OTD25413 Error xx received writing SMF recordOTD26001 Invalid ODWH received on entry OTD26004 Insufficient storage for workareas OTD26005 Tape wtr task nnn initialization failedOTD26007 Tape wtr task nnn abend Sxxx intercepted OTD26009 Tape wtr task nnn terminatedOTD26013 Error xx received writing SMF record OTD27001 Invalid ODCT received on entryOTD27003 ODRE table is not valid OTD27004 Insufficient storage for workareasDB2 Manager error and reason codes OTD27005 Housekeeping task Hnnn terminatedOTD27008 Hnnn request timed out - ODRE Reason code Explanation hex Reason code Explanation hex 0A00Action ActionControl region return codes Reason code Explanation hexExplanation hex value inbrackets Explanation hex value inbrackets DB2 Manager User GuideAppendices Appendix A: Sample JCL membersOTDBDEF DB2 Manager User GuideStorageTek Proprietary DB2 Manager User Guide StorageTek ProprietaryDB2 Manager User Guide StorageTek ProprietaryOTDBPKG DB2 Manager User GuideStorageTek Proprietary OTDBPLAN DB2 Manager User GuideStorageTek Proprietary DB2 Manager User Guide StorageTek ProprietaryIndex 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, IREADTIMEOUT, 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 FormPublication Information Questions and CommentsBUSINESS REPLY CARD Code:______________________Storage Technology Corporation StorageTek Proprietary ABOUT STORAGETEK WORLD HEADQUARTERSNEED MORE INFORMATION?