Otdbplan | StorageTek 312564001 manual

KEEPDYNAMIC(YES)
BIND PACKAGE(OTDBL130)	-
MEMBER(OTDBL130)	-
ACTION(REPLACE)	-
VALIDATE(BIND)	-
ISOLATION(CS)	-
FLAG(E)	-
SQLERROR(CONTINUE)	-
RELEASE(COMMIT)	-
EXPLAIN(NO)	-
KEEPDYNAMIC(YES)
BIND PACKAGE(OTDBL140)	-
MEMBER(OTDBL140)	-
ACTION(REPLACE)	-
VALIDATE(BIND)	-
ISOLATION(CS)	-
FLAG(E)	-
SQLERROR(CONTINUE)	-
RELEASE(COMMIT)	-
EXPLAIN(NO)	-
KEEPDYNAMIC(YES)
BIND PACKAGE(OTDBL170)	-
MEMBER(OTDBL170)	-
ACTION(REPLACE)	-
VALIDATE(BIND)	-
ISOLATION(CS)	-
FLAG(E)	-
SQLERROR(CONTINUE)	-
RELEASE(COMMIT)	-
EXPLAIN(NO)	-
KEEPDYNAMIC(YES)
/*

OTDBPLAN

Member OTDBPLAN creates the DB2 application plan required for execution of DB2 Manager.

//OTDBPLAN JOB
//*	DB2 Manager DB2 plan creation job.
//*	DB2 Manager DB2 plan creation job.
//*	Change history:
//*	Change history:
//*	GW 19-Mar-03 V1.1 created
//*	GW 02-Apr-04 V1.1 re-branded
//*	GW 30-Apr-04 V1.1 OTDBL130 added
//*	This job creates the DB2 application plan
//*	This job creates the DB2 application plan
//*	required for DB2 Manager implementation.
//*	Review lines marked with a "<===" before submitting
//*	Review lines marked with a "<===" before submitting
//*	and amend as follows:
//*	1. Alter the STEPLIB DD cards to specify name of the
//*	1. Alter the STEPLIB DD cards to specify name of the
//*	DB2 runtime load library on the host system.
	DB2 Manager User Guide	177
	StorageTek Proprietary

Image 180

StorageTek 312564001 manual Otdbplan

Contents

Lifecycle Directortm Page Lifecycle Director DB2 Manager User Guide Version Export Destination Control Statement Table of contents DB2 Manager Control Region Introduction Enabling a DB2 Table for Migration Processing Messages and Codes Appendices Introduction Product Description Introduction Product Functions Row migration Access to migrated rows Retrieval of migrated rows Update of migrated rows Deletion of migrated rows DB2 Manager storage configuration Management of migrated rows Product implementation Database backup and recovery DB2 management processingDatabase reorganization Pre-requisites for DB2 Manager implementation Page Installation and Implementation DB2 Manager implementation proceduresArchive Manager implementation Install distribution libraries Dataset Name Description Update DB2 Manager parameter library Tapecntl Create DB2 Manager control region procedure Update the system Program Properties Table PPTPerform MVS host system modifications Assign DB2 Manager user identification Update Flpa or Mlpa definitions Allocate DB2 Manager SMF record identifier Perform tape management system changes Update automated reply software controls Perform STK Host Software Component HSC changes Create LCDDB2 system database and grant access authorities Perform DB2 system modifications Resource type Resource name Access required Create DB2 Manager application plan Define Archive Manager databases Enter the value ‘4’ Base database definition panel OTSN4300 Storage level definition panel OTSN4301 Volume serial number Unit of allocation Access Method Services control panel OTSN4302 Verify DB2 Manager installation DB2 Manager User Guide StorageTek Proprietary DB2 Manager Parameter Specification General parameter format Envcntl parameters Envcntl Smfrecid Envcntl Objsize Envcntl Writetimeout Tapecntl parameters Tapecntl Maxdrdr Tapecntl Maxtwtr Tapecntl Maxqlen Tapecntl Tapewait Tapecntl Command Page DB2 Manager Control Region Control region initialization Start LCDDB2 Control region components DB2Page Processing requests for access to migrated rows SQL Select processing SQL Update processing SQL error codes DB2 Manager operator interfaceSQL Delete processing Display summary status Dbid Stg level Example Display detail status Force purge task LCDDB2,D T=T1 LCDDB2,P T=T1 Purge task Alter DB2 Manager configuration Page Maxsched LCDDB2,SET READTIMEOUT=10 Terminate DB2 Manager control region SMF processing IEE600I Reply to 13 IsshutdownPage SMF header section Offset Length Format Description Record descriptor section Database section Request section Offset Length Format Description Offset Length Format Operational considerations Use of the Maxtrdr parameter Use of the Maxqlen parameter Allocation recovery Use of the Maxdrdr parameter Shutdown processing Resource unavailable condition Table migration processing Introduction Enabling a DB2 table for migration processing Restrictions Enabling activities Otdbind ASC Cluster Disabling activities Page OTDBP100 the table migration utility Functions Sysin parameter specification JCL requirements RESTART=YESNO NEWTAPE=YESNO Sqlin entry specification Parmlib requirements Print reports Operator commands Condition codesUtility failure and restart considerations DB2 table backup and recovery Data management processingDB2 database reorganization Archive Manager database backup and recovery Archive Manager database backup Archive Manager database recovery Page Page OTDBP120 the row restore utility DB2 Manager Utilities Exec PGM=OTDBP120,REGION=4096K Sysin parameter specification INDEXONLY=YN Where Acno = ‘123456789’ Objects will be satisfied via DB2 only Clean-up processing OTDBP130 the pre-fetch utility Exec PGM=OTDBP130,REGION=4096K Sysin parameter specification PRINT=DETAILSUMMARY Print reports Problem. Refer to for a description of the messages OTDBP140 the table analysis utility Archive Manager housekeeping processing DSN=Table.identification.file,DISP=SHR Select key1, key2, .. .., keyn from tablename 108 DB2 Manager User Guide StorageTek Proprietary OTDBP170 the database housekeeping utility Detailed table analysis report 110 DB2 Manager User Guide StorageTek Proprietary Sysin parameter specification Ignored. a maximum of 15 records may be present in this file Detailed processing report Archive Manager database maintenance Page Page Page Messages and Codes OTD100xx table migration utility messagesOTD10000 Row Migration Utility ended with completion code OTD10001 Open failed for xxxxxxxx dataset OTD10003 Mandatory exec parameters have not been specifiedOTD10005 Load failed for program Dsnali DSNHLI2 120 DB2 Manager User Guide StorageTek Proprietary OTD10012 Error locating Odct OTD10011 Return code Xxx’ retrieving Name/Token pair OTD10015 The control region is not active OTD10016 Normal run requested but restart run requiredOTD10017 Unable to obtain Odre request element Page OTD10021 Insufficient storage for workareas OTD120xx row restore utility messages OTD12000 Row Restore Utility ended with completion codeOTD12001 Open failed for xxxxxxxx dataset OTD12004 Mandatory exec parameters have not been specified OTD12006 Insufficient storage for workareasOTD12007 Load failed for program Dsnali DSNHLI2 DB2 Manager User Guide 127 StorageTek Proprietary Sortout OTD130xx pre-fetch utility messages OTD13000 Batch Pre-fetch Utility ended with completion codeOTD13001 Open failed for xxxxxxxx dataset OTD13004 Mandatory exec parameters have not been specified OTD13006 Insufficient storage for workareasOTD13007 Load failed for program Dsnali DSNHLI2 DB2 Manager User Guide 131 StorageTek Proprietary OTD140xx table analysis utility messages OTD13015 Archive Manager is not at the correct levelOTD14000 Table Analysis Utility ended with completion code OTD14001 Open failed for Sysinsqlin dataset OTD14004 Mandatory exec parameters have not been specified OTD14006 Insufficient storage for workareas OTD14007 Load failed for program Dsnali DSNHLI2Page Page OTD170xx database housekeeping utility messages OTD17001 Open failed for Sysinsqlin dataset OTD17004 Mandatory exec parameters have not been specified OTD17006 Insufficient storage for workareasOTD17007 Load failed for program Dsnali DSNHLI2 Page OTD20001 Error opening parameter file Sysparm OTD200xx control region master processor messagesOTD20000 Enter request OTD20006 Envcntl Tapecntl parameter validation errors OTD20004OTD20005 Envcntl Tapecntl parameters being processed OTD20010 Error Xxx during initialization of task tnnn OTD20011 Timeout error during initialization of task tnnnOTD20007 Envcntl Tapecntl parameters successfully processed OTD20008 Odct Getmain failure OTD20014 Error Xxx received attaching task tnnn OTD20013 Getmain failure Xxx allocating task tnnn OTD20016 OTDBP300 is not in Link Pack Area OTD20017 Intercept successfully established OTD20019 Error locating DB2 Manager Ascb Jobname OTD20020 Lifecycle Director V1.1 initialization startingOTD20021 Initialization completed successfully OTD20026 Control region already initialized job terminating OTD20030 Error received posting requestor ECB OTD20032 Command rejected enter request via Modify commandOTD20028 Unable to continue after abend job terminating OTD20029 Recursive abends intercepted job terminating OTD20034 Error X’xx’ received loading program OTD20049 Task tnnn shutdown request has failed errorOTD20050 Missing or invalid request ignored OTD20052 Configuration altered successfully OTD20051 Invalid Set operands request ignored OTD20056 Errors altering configuration check system status OTD20055 Missing/invalid operand request rejectedOTD20057 Requested task tnnn does not exist request ignored OTD20058 Display processing completed OTD20060 Task tnnn has been shutdown successfully OTD20061 Invalid Display operands request ignored OTD20067 Request nnn Stg Level=x Tape=yyyyy Blockid=zzzzzzzz OTD20082 Controller received error posting requestor ECB OTD20071 Invalid Purge operands request ignoredOTD20072 Task tnnn is already being purged request ignored OTD20073 Task tnnn purge request is being processed OTD20094 Error freeing communications table storage OTD20083 Task tnnn has not been purged request ignoredOTD20091 Invalid Shutdown operands OTD20092 Do you want to proceed with shutdown y/n? OTD220xx control region scheduler messages OTD20095 Communications table storage area freedOTD20096 Shutdown processing complete OTD22003 Storage Release Error Return Code=Xxx T=Snnn OTD22004 Invalid request on Scheduler Queue OTD22008 Scheduler task nnn abend Sxxx intercepted OTD22009 Scheduler task nnn terminated OTD250xx control region tape reader messages OTD25001 Invalid Odrh received on entry OTD25003 Unable to get exclusive access to Odre resource OTD25004 Insufficient storage for workareasOTD25005 Tape rdr task nnn initialization failed OTD25007 Tape rdr task nnn abend Sxxx intercepted OTD25013 Error xx received writing SMF record OTD25403 Unable to get exclusive access to Odre resource OTD254xx control region disk reader messagesOTD25401 Invalid Odrh received on entry OTD25404 Insufficient storage for workareas OTD25405 Disk rdr task nnn initialization failed OTD25407 Disk rdr task nnn abend Sxxx interceptedOTD25409 Disk rdr task nnn terminated OTD25413 Error xx received writing SMF record OTD260xx control region writer messagesOTD26001 Invalid Odwh received on entry OTD26003 Unable to get exclusive access to Odre resource OTD26004 Insufficient storage for workareasOTD26005 Tape wtr task nnn initialization failed OTD26007 Tape wtr task nnn abend Sxxx intercepted OTD26009 Tape wtr task nnn terminated OTD270xx control region housekeeping task messages DB2 Manager error and reason codes OTD27005 Housekeeping task Hnnn terminatedOTD27007 Housekeeping task nnn abend Sxxx intercepted OTD27008 Hnnn request timed out Odre Reason code Explanation hex Action Control region return codes Explanation DB2 Manager User Guide 171 StorageTek Proprietary Appendices Appendix a Sample JCL members Otdbdef 174 DB2 Manager User Guide StorageTek Proprietary DB2 Manager User Guide 175 StorageTek Proprietary Otdbpkg Otdbplan 178 DB2 Manager User Guide StorageTek Proprietary Index Maxdisk Page TSO/ISPF Reader’s Comment Form ∎ Contact Us Business Reply Card StorageTek Proprietary About Storagetek World Headquarters