Manuals / StorageTek / Household Appliance / Water System

StorageTek 312564001 manual Table of contents, Installation And Implementation

Models: 312564001

1 189

Download 189 pages 56.09 Kb

Page 5

Table of contents
INTRODUCTION	7
PRODUCT DESCRIPTION	8
INTRODUCTION	8
PRODUCT FUNCTIONS	9
Row migration	9
Access to migrated rows	10
Management of migrated rows	13
DB2 MANAGER STORAGE CONFIGURATION	13
PRODUCT IMPLEMENTATION	14
DB2 MANAGEMENT PROCESSING	15
Database backup and recovery	15
Database reorganization	15
PRE-REQUISITES FOR DB2 MANAGER IMPLEMENTATION	16
INSTALLATION AND IMPLEMENTATION	18
ARCHIVE MANAGER IMPLEMENTATION	18
DB2 MANAGER IMPLEMENTATION PROCEDURES	18
Install distribution libraries	19
Update DB2 Manager parameter library	20
Perform MVS host system modifications	21
Perform DB2 system modifications	25
Define Archive Manager databases	27
VERIFY DB2 MANAGER INSTALLATION	32
DB2 MANAGER PARAMETER SPECIFICATION	34
GENERAL PARAMETER FORMAT	34
ENVCNTL PARAMETERS	35
DB2 Manager User Guide	1
StorageTek Proprietary

Image 5

StorageTek 312564001 manual Table of contents, Installation And Implementation, DB2 MANAGER PARAMETER SPECIFICATION

Contents

LIFECYCLE DIRECTORTM DB2 MANAGER USER GUIDE312564001 PART NUMBERPage Lifecycle Director DB2 Manager User Guide VersionEC Revision C Restricted Rights Export Destination Control StatementLimitations on Warranties and Liability Proprietary Information StatementDB2 MANAGER PARAMETER SPECIFICATION Table of contentsINSTALLATION AND IMPLEMENTATION 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 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 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: 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 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 StorageTek Proprietary Alter DB2 Manager configurationDB2 Manager User Guide StorageTek Proprietary Valid parameters for the SET command areDB2 Manager User Guide 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 IntroductionExample RestrictionsEnabling activities 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 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 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 utilityDD entries should be specified as follows FunctionsJCL requirements 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-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 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 considerationsDB2 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 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 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 interceptedOTD27001 Invalid ODCT received on entry OTD26013 Error xx received writing SMF recordOTD27003 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 0A00 Reason code Explanation hexAction ActionReason code Explanation hex Control region return codesbrackets Explanationhex value in hex value in Explanationbrackets DB2 Manager User GuideAppendix 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 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 CommentsStorage Technology Corporation BUSINESS REPLY CARDCode:______________________ StorageTek Proprietary NEED MORE INFORMATION? ABOUT STORAGETEKWORLD HEADQUARTERS