Manuals / StorageTek / Household Appliance / Water System

StorageTek 312564001 manual DB2 MANAGER USER GUIDE, Lifecycle Directortm, Part Number

Models: 312564001

1 189

Download 189 pages 56.09 Kb

Page 1

PART NUMBER

PART NUMBER

312564001

VERSION NUMBER

1.1

EDITION NUMBER

1

LIFECYCLE DIRECTORTM

DB2 MANAGER USER GUIDE

PRODUCT TYPE SOFTWARE

Image 1

StorageTek 312564001 manual DB2 MANAGER USER GUIDE, Lifecycle Directortm, Part Number, Version Number, Edition Number

Contents

LIFECYCLE DIRECTORTM DB2 MANAGER USER GUIDE312564001 PART NUMBERPage EC Revision C VersionLifecycle Director DB2 Manager User Guide Restricted Rights Export Destination Control StatementLimitations on Warranties and Liability Proprietary Information StatementINSTALLATION AND IMPLEMENTATION Table of contentsDB2 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 DB2 management processing Database backup and recoveryDatabase reorganization Pre-requisitesfor DB2 Manager implementation DB2 Manager User Guide This page is intentionally left blankStorageTek Proprietary DB2 Manager implementation procedures Installation and ImplementationArchive Manager implementation Dataset Name Install distribution librariesDescription 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: READTIMEOUTTAPECNTL parameters ENVCNTL: WRITETIMEOUTTAPECNTL: MAXTRDR TAPECNTL: MAXDRDR TAPECNTL: MAXSCHED TAPECNTL: MAXTWTRTAPECNTL: RETAINTAPE TAPECNTL: MAXQLENTAPECNTL: TAPEWAIT TAPECNTL: COMMAND DB2 Manager User Guide This page is intentionally left blankStorageTek Proprietary Control region initialization DB2 Manager Control RegionDB2 Manager User Guide Figure 4: Structure of DB2 Manager control region Control region componentsFLPA/MLPA storage StorageTek Proprietary DB2 Manager User GuideSQL SELECT processing Processing requests for access to migrated rowsSQL UPDATE processing DB2 Manager operator interface SQL error codesSQL 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 DB2 Manager User Guide Alter DB2 Manager configurationStorageTek Proprietary DB2 Manager User Guide Valid parameters for the SET command areStorageTek 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 IntroductionEnabling activities RestrictionsExample 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 requirementsCondition codes Operator commandsUtility failure and restart considerations Data management processing DB2 table backup and recoveryDB2 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 utilityJCL requirements FunctionsDD 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-upprocessingJCL requirements FunctionsDD entries should be specified as follows A parameter entry has the general format SYSIN parameter specificationPLAN=xxxxxxxx SQLIN entry specificationDB2 Manager User Guide Print reportsUtility failure and restart considerations Condition codesafter 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 considerationsJCL requirements FunctionsDB2 Manager User Guide DD entries should be specified as follows SYSIN parameter specificationPrint reports SQLIN entry specification•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 GuideDB2 Manager User Guide This page is intentionally left blankStorageTek 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 operandsOTD20095 Communications table storage area freed OTD220xx – control region scheduler messagesOTD20096 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 OTD25401 Invalid ODRH received on entry OTD254xx – control region disk reader messagesOTD25404 Insufficient storage for workareas OTD25407 Disk rdr task nnn abend Sxxx intercepted OTD25405 Disk rdr task nnn initialization failedOTD25409 Disk rdr task nnn terminated OTD25413 Error xx received writing SMF record OTD260xx – control region writer messagesOTD26001 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 workareasOTD27005 Housekeeping task Hnnn terminated DB2 Manager error and reason codesOTD27008 Hnnn request timed out - ODRE Reason code Explanation hex 0A00 Reason code Explanation hexAction ActionReason code Explanation hex Control region return codeshex value in Explanationbrackets hex value in Explanationbrackets DB2 Manager User GuideAppendix A: Sample JCL members AppendicesDB2 Manager User Guide OTDBDEFStorageTek Proprietary StorageTek Proprietary DB2 Manager User GuideStorageTek Proprietary DB2 Manager User GuideDB2 Manager User Guide OTDBPKGStorageTek Proprietary DB2 Manager User Guide OTDBPLANStorageTek 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 CommentsCode:______________________ BUSINESS REPLY CARDStorage Technology Corporation StorageTek Proprietary WORLD HEADQUARTERS ABOUT STORAGETEKNEED MORE INFORMATION?