Manuals / StorageTek / Household Appliance / Water System

StorageTek 312564001 manual DB2 Manager User Guide, StorageTek Proprietary

Models: 312564001

1 189

Download 189 pages 56.09 Kb

Page 119

database, a different recycle threshold may be supplied for each storage level.

As Archive Manager uses a discrete set of tape cartridge volumes and disk datasets for each database, it is possible to perform the Archive Manager database maintenance procedure on multiple DB2 Manager databases concurrently. Each procedure will require a minimum of two tape cartridge drives.

Refer to the Archive Manager User Manual for a complete description of the Archive Manager object management and database maintenance utilities and Archive Manager database housekeeping procedures.

116	DB2 Manager User Guide
	StorageTek Proprietary

Image 119

StorageTek 312564001 manual DB2 Manager User Guide, StorageTek Proprietary

Contents

PART NUMBER DB2 MANAGER USER GUIDELIFECYCLE DIRECTORTM 312564001Page Lifecycle Director DB2 Manager User Guide VersionEC Revision C Proprietary Information Statement Export Destination Control StatementRestricted Rights Limitations on Warranties and LiabilityDB2 MANAGER PARAMETER SPECIFICATION Table of contentsINSTALLATION AND IMPLEMENTATION 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 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 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: READTIMEOUTTAPECNTL: MAXTRDR ENVCNTL: WRITETIMEOUTTAPECNTL parameters TAPECNTL: MAXDRDR TAPECNTL: MAXSCHED TAPECNTL: MAXTWTRTAPECNTL: RETAINTAPE TAPECNTL: MAXQLENTAPECNTL: TAPEWAIT TAPECNTL: COMMAND StorageTek Proprietary This page is intentionally left blankDB2 Manager User Guide Control region initialization DB2 Manager Control RegionDB2 Manager User Guide FLPA/MLPA storage Control region componentsFigure 4: Structure of DB2 Manager control region StorageTek Proprietary DB2 Manager User GuideSQL SELECT processing Processing requests for access to migrated rowsSQL UPDATE processing SQL DELETE processing SQL error codesDB2 Manager operator interface 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 StorageTek Proprietary Alter DB2 Manager configurationDB2 Manager User Guide StorageTek Proprietary Valid parameters for the SET command areDB2 Manager User Guide 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 IntroductionExample RestrictionsEnabling activities 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 requirementsUtility failure and restart considerations Operator commandsCondition codes DB2 database reorganization DB2 table backup and recoveryData management processing 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 utilityDD entries should be specified as follows FunctionsJCL requirements 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-upprocessingDD entries should be specified as follows FunctionsJCL requirements A parameter entry has the general format SYSIN parameter specificationPLAN=xxxxxxxx SQLIN entry specificationDB2 Manager User Guide Print reportsafter processing the request Condition codesUtility failure and restart considerations 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 codesDB2 Manager User Guide FunctionsJCL requirements DD entries should be specified as follows SYSIN parameter specification•PLAN=xxxxxxxx SQLIN entry specificationPrint reports Condition codes Figure 6: Detailed processing reportUtility failure and restart considerations Archive Manager database maintenanceStorageTek Proprietary DB2 Manager User GuideStorageTek Proprietary DB2 Manager User GuideStorageTek Proprietary This page is intentionally left blankDB2 Manager User Guide 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 operandsOTD20096 Shutdown processing complete OTD220xx – control region scheduler messagesOTD20095 Communications table storage area freed 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 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 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 validOTD27008 Hnnn request timed out - ODRE DB2 Manager error and reason codesOTD27005 Housekeeping task Hnnn terminated Reason code Explanation hex Action Reason code Explanation hex0A00 ActionReason code Explanation hex Control region return codesbrackets Explanationhex value in DB2 Manager User Guide Explanationhex value in bracketsAppendix A: Sample JCL members AppendicesStorageTek Proprietary OTDBDEFDB2 Manager User Guide StorageTek Proprietary DB2 Manager User GuideStorageTek Proprietary DB2 Manager User GuideStorageTek Proprietary OTDBPKGDB2 Manager User Guide StorageTek Proprietary OTDBPLANDB2 Manager User Guide 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 InformationStorage Technology Corporation BUSINESS REPLY CARDCode:______________________ StorageTek Proprietary NEED MORE INFORMATION? ABOUT STORAGETEKWORLD HEADQUARTERS