Manuals / StorageTek / Household Appliance / Water System

StorageTek 312564001 manual Version, EC Revision C, Lifecycle Director DB2 Manager User Guide

Models: 312564001

1 189

Download 189 pages 56.09 Kb

Page 3

Lifecycle

Director™

DB2 Manager

User Guide

Version 1.1

EC 132056

Revision C

Image 3

StorageTek 312564001 manual Version, EC Revision C, Lifecycle Director DB2 Manager User Guide

Contents

PART NUMBER DB2 MANAGER USER GUIDELIFECYCLE DIRECTORTM 312564001Page Version EC Revision CLifecycle Director DB2 Manager User Guide Proprietary Information Statement Export Destination Control StatementRestricted Rights Limitations on Warranties and LiabilityTable of contents INSTALLATION AND IMPLEMENTATIONDB2 MANAGER PARAMETER SPECIFICATION DB2 MANAGER CONTROL REGION INTRODUCTION MESSAGES AND CODES CONTROL REGION RETURN CODES APPENDICESDB2 MANAGER ERROR AND REASON CODES OTD260XX – CONTROL REGION WRITER MESSAGESIntroduction 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 c. Assign DB2 Manager user identification Perform MVS host system modificationsb. Create DB2 Manager control region procedure d. Update the system Program Properties Table PPTe. 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 b. Create DB2 Manager application plan Access requiredResource type Resource nameEnter 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 after completion of update Display detail statusManager database for update processing A request to commit updates to an ArchiveForce 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 TAPEWAIT MAXSCHEDMAXQLEN RETAINTAPEStorageTek Proprietary DB2 Manager User GuideTerminate DB2 Manager control region SMF processing StorageTek Proprietary DB2 Manager User GuideFormat SMF header sectionOffset LengthLength Record descriptor sectionDatabase section OffsetFormat Request sectionOffset LengthFormat Offset0 8 16 24 LengthDescription OffsetLength FormatLength Operational considerationsUse of the MAXTRDR parameter OffsetUse 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•RESTART=YES|NO The following parameters may be specified•LCDDBID = •COMMIT = nnnnn•S100PRI=nnnnnnn NEWTAPE=YES NO•DB2SSID=xxxx •PLAN=xxxxxxxxSQLIN 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 DB2 Manager User Guide The procedure in each case is summarized below1.Loss of individual tape volumes 2.Loss of entire databaseStorageTek 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•S120PRI=nnnnnnn •PLAN=xxxxxxxx•COMMIT = nnnnn|0 •INDEXONLY=Y|N•S120UNIT=xxxxxxxx SQLIN entry specificationthe utility has been executed successfully Print reportsCondition codes Utility failure and restart considerationsOTDBP130 - 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 JCL requirements OTDBP140 - the table analysis utilityArchive Manager housekeeping processing FunctionsDD entries should be specified as follows SYSIN parameter specificationThe following parameters may be specified SQLIN entry specificationoConcatenated DB2 key of row Print reportsUtility failure and restart considerations OTDBP170 - the database housekeeping utilityFigure 5: Detailed table analysis report Condition codesFunctions 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 OTD25009 Tape rdr task nnn terminated OTD25004 Insufficient storage for workareasOTD25005 Tape rdr task nnn initialization failed OTD25007 Tape rdr task nnn abend Sxxx interceptedOTD25013 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 interceptedOTD27004 Insufficient storage for workareas OTD26013 Error xx received writing SMF recordOTD27001 Invalid ODCT received on entry OTD27003 ODRE table is not validDB2 Manager error and reason codes OTD27005 Housekeeping task Hnnn terminatedOTD27008 Hnnn request timed out - ODRE Reason code Explanation hex Action Reason code Explanation hex0A00 ActionReason code Explanation hex Control region return codesExplanation hex value inbrackets DB2 Manager User Guide Explanationhex value in bracketsAppendix 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 failure, 117 housekeeping processing, 13 HSC, I MLPA, MODIFY, 43, 46, 51, N new tape volume, OF FLPA, FORCE, 56 force purge, H HLQ, Host Software Component, 25, 72 housekeepingselection criteria, 95, 99, 102 utility failure, READTIMEOUT, 37, 53, 59, 60, 62, 63, 126, 171,tape recycling, tape volume recovery, R reader task,database housekeeping, 13, 95, tape volume recycling,updated row, WRITETIMEOUT, 38, 53, 59, 60, 62,Questions and Comments ∎Contact UsReader’s Comment Form Publication InformationBUSINESS REPLY CARD Code:______________________Storage Technology Corporation StorageTek Proprietary ABOUT STORAGETEK WORLD HEADQUARTERSNEED MORE INFORMATION?