Manuals / StorageTek / Household Appliance / Water System

StorageTek 312564001 manual Explanation, hex value in, brackets, DB2 Manager User Guide

Models: 312564001

1 189

Download 189 pages 56.09 Kb

Page 174

Return code	Explanation
(hex value in
brackets)

xxAny other return code issued by the control region indicates that an error has been received from an Archive Manager call. A message will be issued by the control region giving details of the call and the return and reason codes received from Archive Manager. Refer to the Archive Manager User Manual for a description of this error condition.

DB2 Manager User Guide	171
StorageTek Proprietary

Image 174

StorageTek 312564001 manual Explanation, hex value in, brackets, DB2 Manager User Guide

Contents

312564001 DB2 MANAGER USER GUIDELIFECYCLE DIRECTORTM PART NUMBERPage Version EC Revision CLifecycle Director DB2 Manager User Guide Limitations on Warranties and Liability Export Destination Control StatementRestricted Rights Proprietary Information StatementTable of contents INSTALLATION AND IMPLEMENTATIONDB2 MANAGER PARAMETER SPECIFICATION DB2 MANAGER CONTROL REGION INTRODUCTION MESSAGES AND CODES OTD260XX – CONTROL REGION WRITER MESSAGES APPENDICESDB2 MANAGER ERROR AND REASON CODES 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 d. Update the system Program Properties Table PPT Perform MVS host system modificationsb. Create DB2 Manager control region procedure 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 Resource name Access requiredResource type 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 A request to commit updates to an Archive Display detail statusManager database for update processing 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 RETAINTAPE MAXSCHEDMAXQLEN TAPEWAITDB2 Manager User Guide StorageTek ProprietaryTerminate DB2 Manager control region SMF processing DB2 Manager User Guide StorageTek ProprietaryLength SMF header sectionOffset FormatOffset Record descriptor sectionDatabase section LengthLength Request sectionOffset FormatLength Offset0 8 16 24 FormatFormat OffsetLength DescriptionOffset Operational considerationsUse of the MAXTRDR parameter 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 requirements•COMMIT = nnnnn The following parameters may be specified•LCDDBID = •RESTART=YES|NO•PLAN=xxxxxxxx NEWTAPE=YES NO•DB2SSID=xxxx •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 2.Loss of entire database The procedure in each case is summarized below1.Loss of individual tape volumes 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•INDEXONLY=Y|N •PLAN=xxxxxxxx•COMMIT = nnnnn|0 •S120PRI=nnnnnnnSQLIN entry specification •S120UNIT=xxxxxxxxUtility failure and restart considerations Print reportsCondition codes 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 Functions OTDBP140 - the table analysis utilityArchive Manager housekeeping processing JCL requirementsSYSIN parameter specification DD entries should be specified as followsSQLIN entry specification The following parameters may be specifiedPrint reports oConcatenated DB2 key of rowCondition codes OTDBP170 - the database housekeeping utilityFigure 5: Detailed table analysis report 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 OTD25007 Tape rdr task nnn abend Sxxx intercepted OTD25004 Insufficient storage for workareasOTD25005 Tape rdr task nnn initialization failed 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 terminatedOTD27003 ODRE table is not valid OTD26013 Error xx received writing SMF recordOTD27001 Invalid ODCT received on entry OTD27004 Insufficient storage for workareasDB2 Manager error and reason codes OTD27005 Housekeeping task Hnnn terminatedOTD27008 Hnnn request timed out - ODRE Reason code Explanation hex Action Reason code Explanation hex0A00 ActionControl region return codes Reason code Explanation hexExplanation hex value inbrackets brackets Explanationhex value in 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 Host Software Component, 25, 72 housekeeping MLPA, MODIFY, 43, 46, 51, N new tape volume, OF FLPA, FORCE, 56 force purge, H HLQ, failure, 117 housekeeping processing, 13 HSC, IR reader task, READTIMEOUT, 37, 53, 59, 60, 62, 63, 126, 171,tape recycling, tape volume recovery, selection criteria, 95, 99, 102 utility failure,WRITETIMEOUT, 38, 53, 59, 60, 62, tape volume recycling,updated row, database housekeeping, 13, 95,Publication Information ∎Contact UsReader’s Comment Form Questions and CommentsBUSINESS REPLY CARD Code:______________________Storage Technology Corporation StorageTek Proprietary ABOUT STORAGETEK WORLD HEADQUARTERSNEED MORE INFORMATION?