Manuals / StorageTek / Household Appliance / Water System

StorageTek 312564001 manual Appendices, OTD260XX – CONTROL REGION WRITER MESSAGES

Models: 312564001

1 189

Download 189 pages 56.09 Kb

Page 9

OTD260XX – CONTROL REGION WRITER MESSAGES	162
OTD270XX - CONTROL REGION HOUSEKEEPING TASK MESSAGES	165
DB2 MANAGER ERROR AND REASON CODES	166
CONTROL REGION RETURN CODES	169
APPENDICES	172
A PPENDIX A: S AMPLE JCL MEMBERS	172

DB2 Manager User Guide	5
StorageTek Proprietary

Image 9

StorageTek 312564001 manual Appendices, OTD260XX – CONTROL REGION WRITER MESSAGES, DB2 MANAGER ERROR AND REASON CODES

Contents

LIFECYCLE DIRECTORTM DB2 MANAGER USER GUIDE312564001 PART NUMBERPage Version EC Revision CLifecycle Director DB2 Manager User Guide Restricted Rights Export Destination Control StatementLimitations on Warranties and Liability Proprietary Information StatementTable of contents INSTALLATION AND IMPLEMENTATIONDB2 MANAGER PARAMETER SPECIFICATION DB2 MANAGER CONTROL REGION INTRODUCTION MESSAGES AND CODES DB2 MANAGER ERROR AND REASON CODES APPENDICESOTD260XX – CONTROL REGION WRITER MESSAGES CONTROL REGION RETURN CODESIntroduction Product Description Introduction Row migration Product FunctionsRetrieval of migrated rows Access to migrated rowsUpdate of migrated rows Deletion of migrated rows Management of migrated rows DB2 Manager storage configurationProduct 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 b. Create DB2 Manager control region procedure Perform MVS host system modificationsd. Update the system Program Properties Table PPT c. Assign DB2 Manager user identificatione. Update FLPA or MLPA definitions g. Perform tape management system changes f. Allocate DB2 Manager SMF record identifieri. Update automated reply software controls Perform DB2 system modifications Resource type Access requiredResource name b. Create DB2 Manager application planEnter the value ‘4’ Define Archive Manager databasesData retention Database Enter the value ‘32760’. blocksize Volume serial number Unit of allocation DB2 Manager User Guide Verify DB2 Manager installation StorageTek Proprietary DB2 Manager User GuideGeneral parameter format DB2 Manager Parameter SpecificationENVCNTL: SMFRECID ENVCNTL parametersENVCNTL: OBJSIZE ENVCNTL: READTIMEOUTENVCNTL: WRITETIMEOUT TAPECNTL parametersTAPECNTL: MAXTRDR TAPECNTL: MAXDRDR TAPECNTL: MAXSCHED TAPECNTL: MAXTWTRTAPECNTL: RETAINTAPE TAPECNTL: MAXQLENTAPECNTL: TAPEWAIT TAPECNTL: COMMAND This page is intentionally left blank DB2 Manager User GuideStorageTek Proprietary Control region initialization DB2 Manager Control RegionDB2 Manager User Guide Control region components Figure 4: Structure of DB2 Manager control regionFLPA/MLPA storage StorageTek Proprietary DB2 Manager User GuideSQL SELECT processing Processing requests for access to migrated rowsSQL UPDATE processing SQL error codes DB2 Manager operator interfaceSQL DELETE processing Display summary status Stg level DBIDExample Manager database for update processing Display detail statusA request to commit updates to an Archive Manager database after completion of updateForce purge task StorageTek Proprietary DB2 Manager User GuidePurge task Alter DB2 Manager configuration DB2 Manager User GuideStorageTek Proprietary Valid parameters for the SET command are DB2 Manager User GuideStorageTek Proprietary MAXQLEN MAXSCHEDRETAINTAPE TAPEWAITStorageTek Proprietary DB2 Manager User GuideTerminate DB2 Manager control region SMF processing StorageTek Proprietary DB2 Manager User GuideOffset SMF header sectionLength FormatDatabase section Record descriptor sectionOffset LengthOffset Request sectionLength Format0 8 16 24 OffsetLength FormatLength OffsetFormat DescriptionUse of the MAXTRDR parameter Operational considerationsOffset LengthUse of the MAXQLEN parameter Use of the MAXDRDR parameter Allocation recoveryShutdown processing Resource unavailable condition Enabling a DB2 table for migration processing Table migration processing IntroductionRestrictions Enabling activitiesExample where Disabling activities StorageTek Proprietary DB2 Manager User GuideOTDBP100 - the table migration utility Functions JCL requirements SYSIN parameter specification•LCDDBID = The following parameters may be specified•COMMIT = nnnnn •RESTART=YES|NO•DB2SSID=xxxx NEWTAPE=YES NO•PLAN=xxxxxxxx •S100PRI=nnnnnnnSQLIN entry specification Print reports PARMLIB requirementsOperator commands Condition codesUtility failure and restart considerations DB2 table backup and recovery Data management processingDB2 database reorganization Archive Manager database backup Archive Manager database backup and recoveryArchive Manager database recovery 1.Loss of individual tape volumes The procedure in each case is summarized below2.Loss of entire database DB2 Manager User GuideStorageTek Proprietary DB2 Manager User GuideDB2 Manager Utilities OTDBP120 - the row restore utilityFunctions JCL requirementsDD entries should be specified as follows A parameter entry has the general format SYSIN parameter specification•COMMIT = nnnnn|0 •PLAN=xxxxxxxx•INDEXONLY=Y|N •S120PRI=nnnnnnn•S120UNIT=xxxxxxxx SQLIN entry specificationCondition codes Print reportsUtility failure and restart considerations the utility has been executed successfullyOTDBP130 - the pre-fetchutility Clean-upprocessingFunctions JCL requirementsDD entries should be specified as follows A parameter entry has the general format SYSIN parameter specificationPLAN=xxxxxxxx SQLIN entry specificationDB2 Manager User Guide Print reportsCondition codes Utility failure and restart considerationsafter processing the request Archive Manager housekeeping processing OTDBP140 - the table analysis utilityFunctions JCL requirementsDD entries should be specified as follows SYSIN parameter specificationThe following parameters may be specified SQLIN entry specificationoConcatenated DB2 key of row Print reportsFigure 5: Detailed table analysis report OTDBP170 - the database housekeeping utilityCondition codes Utility failure and restart considerationsFunctions JCL requirementsDB2 Manager User Guide DD entries should be specified as follows SYSIN parameter specificationSQLIN entry specification Print reports•PLAN=xxxxxxxx Condition codes Figure 6: Detailed processing reportUtility failure and restart considerations Archive Manager database maintenanceStorageTek Proprietary DB2 Manager User GuideStorageTek Proprietary DB2 Manager User GuideThis page is intentionally left blank DB2 Manager User GuideStorageTek Proprietary OTD100xx – table migration utility messages Messages and CodesOTD10001 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 OTD14007 Load failed for program DSNALI | DSNHLI2 OTD14006 Insufficient storage for workareasDB2 Manager User Guide DB2 Manager User Guide OTD170xx – database housekeeping utility messages OTD17006 Insufficient storage for workareas DB2 Manager User Guide OTD20000 Enter request OTD20001 Error opening parameter file SYSPARMOTD20004 OTD20008 ODCT GETMAIN failure OTD20013 GETMAIN failure Xxx allocating task tnnn OTD20014 Error Xxx received attaching task tnnnOTD20017 Intercept successfully established OTD20016 OTDBP300 is not in Link Pack AreaOTD20019 Error locating DB2 Manager ASCB | Jobname OTD20030 Error received posting requestor ECB OTD20050 Missing or invalid request - ignored OTD20034 Error X’xx’ received loading programOTD20051 Invalid Set operands - request ignored OTD20052 Configuration altered successfullyOTD20058 Display processing completed OTD20060 Task tnnn has been shutdown successfully WAIT – the task is currently waiting for work OTD20071 Invalid Purge operands – request ignored OTD20093 Shutdown in progress OTD20091 Invalid Shutdown operandsOTD220xx – control region scheduler messages OTD20095 Communications table storage area freedOTD20096 Shutdown processing complete OTD22004 Invalid request on Scheduler Queue T=Snnn OTD22009 Scheduler task nnn terminatedOTD250xx – control region tape reader messages OTD25005 Tape rdr task nnn initialization failed OTD25004 Insufficient storage for workareasOTD25007 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 OTD26005 Tape wtr task nnn initialization failed OTD26004 Insufficient storage for workareasOTD26009 Tape wtr task nnn terminated OTD26007 Tape wtr task nnn abend Sxxx interceptedOTD27001 Invalid ODCT received on entry OTD26013 Error xx received writing SMF recordOTD27003 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 0A00 Reason code Explanation hexAction ActionReason code Explanation hex Control region return codesExplanation hex value inbrackets hex value in Explanationbrackets DB2 Manager User GuideAppendix A: Sample JCL members AppendicesOTDBDEF DB2 Manager User GuideStorageTek Proprietary StorageTek Proprietary DB2 Manager User GuideStorageTek Proprietary DB2 Manager User GuideOTDBPKG DB2 Manager User GuideStorageTek Proprietary OTDBPLAN DB2 Manager User GuideStorageTek Proprietary StorageTek Proprietary DB2 Manager User GuideIndex F FLPA, FORCE, 56 force purge, H HLQ, MLPA, MODIFY, 43, 46, 51, N new tape volume, OHost Software Component, 25, 72 housekeeping failure, 117 housekeeping processing, 13 HSC, Itape recycling, tape volume recovery, READTIMEOUT, 37, 53, 59, 60, 62, 63, 126, 171,R reader task, selection criteria, 95, 99, 102 utility failure,updated row, tape volume recycling,WRITETIMEOUT, 38, 53, 59, 60, 62, database housekeeping, 13, 95,Reader’s Comment Form ∎Contact UsPublication Information Questions and CommentsBUSINESS REPLY CARD Code:______________________Storage Technology Corporation StorageTek Proprietary ABOUT STORAGETEK WORLD HEADQUARTERSNEED MORE INFORMATION?