Manuals / StorageTek / Household Appliance / Water System

StorageTek 312564001 manual This page is intentionally left blank, DB2 Manager User Guide

Models: 312564001

1 189

Download 189 pages 56.09 Kb

Page 20

This page is intentionally left blank

DB2 Manager User Guide	17
StorageTek Proprietary

Image 20

StorageTek 312564001 manual This page is intentionally left blank, DB2 Manager User Guide, StorageTek Proprietary

Contents

DB2 MANAGER USER GUIDE LIFECYCLE DIRECTORTM312564001 PART NUMBERPage Lifecycle Director DB2 Manager User Guide VersionEC Revision C Export Destination Control Statement Restricted RightsLimitations on Warranties and Liability Proprietary Information StatementDB2 MANAGER PARAMETER SPECIFICATION Table of contentsINSTALLATION AND IMPLEMENTATION 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 reorganization Database backup and recoveryDB2 management processing Pre-requisitesfor DB2 Manager implementation StorageTek Proprietary This page is intentionally left blankDB2 Manager User Guide Archive Manager implementation Installation and ImplementationDB2 Manager implementation procedures Description Install distribution librariesDataset Name 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: OBJSIZETAPECNTL: MAXTRDR ENVCNTL: WRITETIMEOUTTAPECNTL parameters TAPECNTL: MAXDRDR TAPECNTL: MAXTWTR TAPECNTL: MAXSCHEDTAPECNTL: MAXQLEN TAPECNTL: RETAINTAPETAPECNTL: TAPEWAIT TAPECNTL: COMMAND StorageTek Proprietary This page is intentionally left blankDB2 Manager User Guide DB2 Manager Control Region Control region initializationDB2 Manager User Guide FLPA/MLPA storage Control region componentsFigure 4: Structure of DB2 Manager control region DB2 Manager User Guide StorageTek ProprietaryProcessing requests for access to migrated rows SQL SELECT processingSQL UPDATE processing SQL DELETE processing SQL error codesDB2 Manager operator interface 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 StorageTek Proprietary Alter DB2 Manager configurationDB2 Manager User Guide StorageTek Proprietary Valid parameters for the SET command areDB2 Manager User Guide 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 processingExample RestrictionsEnabling activities 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 reportsUtility failure and restart considerations Operator commandsCondition codes DB2 database reorganization DB2 table backup and recoveryData management processing 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 UtilitiesDD entries should be specified as follows FunctionsJCL requirements 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-fetchutilityDD entries should be specified as follows FunctionsJCL requirements SYSIN parameter specification A parameter entry has the general formatSQLIN entry specification PLAN=xxxxxxxxPrint reports DB2 Manager User Guideafter processing the request Condition codesUtility failure and restart considerations 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 considerationsDB2 Manager User Guide FunctionsJCL requirements SYSIN parameter specification DD entries should be specified as follows•PLAN=xxxxxxxx SQLIN entry specificationPrint reports Figure 6: Detailed processing report Condition codesArchive Manager database maintenance Utility failure and restart considerationsDB2 Manager User Guide StorageTek ProprietaryDB2 Manager User Guide StorageTek ProprietaryStorageTek Proprietary This page is intentionally left blankDB2 Manager User Guide 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 progressOTD20096 Shutdown processing complete OTD220xx – control region scheduler messagesOTD20095 Communications table storage area freed 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 OTD25404 Insufficient storage for workareas OTD254xx – control region disk reader messagesOTD25401 Invalid ODRH received on entry OTD25409 Disk rdr task nnn terminated OTD25405 Disk rdr task nnn initialization failedOTD25407 Disk rdr task nnn abend Sxxx intercepted OTD26001 Invalid ODWH received on entry OTD260xx – control region writer messagesOTD25413 Error xx received writing SMF record 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 workareasOTD27008 Hnnn request timed out - ODRE DB2 Manager error and reason codesOTD27005 Housekeeping task Hnnn terminated Reason code Explanation hex Reason code Explanation hex 0A00Action ActionControl region return codes Reason code Explanation hexbrackets Explanationhex value in Explanation hex value inbrackets DB2 Manager User GuideAppendices Appendix A: Sample JCL membersStorageTek Proprietary OTDBDEFDB2 Manager User Guide DB2 Manager User Guide StorageTek ProprietaryDB2 Manager User Guide StorageTek ProprietaryStorageTek Proprietary OTDBPKGDB2 Manager User Guide StorageTek Proprietary OTDBPLANDB2 Manager User Guide 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 CommentsStorage Technology Corporation BUSINESS REPLY CARDCode:______________________ StorageTek Proprietary NEED MORE INFORMATION? ABOUT STORAGETEKWORLD HEADQUARTERS