Manuals / StorageTek / Household Appliance / Water System

StorageTek 312564001 manual Otdbpkg

Models: 312564001

1 189

Download 189 pages 56.09 Kb

Page 179

OTDBPKG

Member OTDBPKG creates the DB2 Manager DB2 application packages.

//OTDBPKG		JOB
//*	DB2 Manager DB2 package creation job.
//*	DB2 Manager DB2 package 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 packages
//*	This job creates the DB2 application packages
//*	required for DB2 Manager implementation.
//*	Amend the job as follows before submitting:
//*	Amend the job as follows before submitting:
//*	1.	Alter the STEPLIB DD card to specify name of the
//*	1.	Alter the STEPLIB DD card to specify name of the
//*		DB2 runtime load library on the host system.
//*	2.	Change the name of the DB2 subsystem (DB2) in
//*	2.	Change the name of the DB2 subsystem (DB2) in
//*		the DSN statement to match the subsystem name
//*		in use on the host system.
//*	3.	Change the dataset name on the DBRMLIB card
//*	3.	Change the dataset name on the DBRMLIB card
//*		to specify the name of the DB2 Manager DBRM
//*		library unloaded from file 2 of the distribution tape.
//*

//BIND	EXEC	PGM=IKJEFT01,DYNAMNBR=20
//STEPLIB	DD	DSN=DB2.runtime.library,DISP=SHR
//DBRMLIB	DD	DSN=Database.Manager.DBRM.library,DISP=SHR
//SYSTSPRT	DD	SYSOUT=*
//SYSPRINT	DD	SYSOUT=*
//SYSUDUMP	DD	SYSOUT=*
//SYSTSIN	DD	*

DSN SYSTEM(DB2)
BIND PACKAGE(OTDBL100)		-
	MEMBER(OTDBL100)	-
	ACTION(REPLACE)	-
	VALIDATE(BIND)	-
	ISOLATION(CS)	-
	FLAG(E)	-
	SQLERROR(CONTINUE)	-
	RELEASE(COMMIT)	-
	EXPLAIN(NO)	-
	KEEPDYNAMIC(YES)
BIND PACKAGE(OTDBL120)		-
	MEMBER(OTDBL120)	-
	ACTION(REPLACE)	-
	VALIDATE(BIND)	-
	ISOLATION(CS)	-
	FLAG(E)	-
	SQLERROR(CONTINUE)	-
	RELEASE(COMMIT)	-
	EXPLAIN(NO)	-
176	DB2 Manager User Guide
	StorageTek Proprietary

Image 179

StorageTek 312564001 manual Otdbpkg

Contents

Lifecycle Directortm Page Version Lifecycle Director DB2 Manager User GuideExport 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 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-requisites for DB2 Manager implementation Page Archive Manager implementation Installation and ImplementationDB2 Manager implementation procedures Dataset Name Description Install distribution librariesTapecntl Update DB2 Manager parameter libraryAssign DB2 Manager user identification Create DB2 Manager control region procedureUpdate the system Program Properties Table PPT Perform MVS host system modificationsUpdate Flpa or Mlpa definitions Perform tape management system changes Allocate DB2 Manager SMF record identifierPerform STK Host Software Component HSC changes Update automated reply software controlsPerform DB2 system modifications Create LCDDB2 system database and grant access authoritiesCreate DB2 Manager application plan Resource type Resource name Access requiredEnter the value ‘4’ Define Archive Manager databasesBase 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 General parameter format DB2 Manager Parameter SpecificationEnvcntl Smfrecid Envcntl parametersEnvcntl Objsize Tapecntl parameters Envcntl WritetimeoutTapecntl Maxdrdr Tapecntl Maxtwtr Tapecntl Maxqlen Tapecntl Tapewait Tapecntl Command Page Control region initialization DB2 Manager Control RegionStart LCDDB2 DB2 Control region componentsPage SQL 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 Display detail status LCDDB2,D T=T1 Force purge taskLCDDB2,P T=T1 Purge task Alter DB2 Manager configuration Page Maxsched LCDDB2,SET READTIMEOUT=10 Terminate DB2 Manager control region IEE600I Reply to 13 Isshutdown SMF processingPage Offset Length Format Description SMF header sectionDatabase section Record descriptor sectionRequest section Offset Length Format Description Offset Length Format Use of the Maxtrdr parameter Operational considerationsUse 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 RestrictionsOtdbind ASC Cluster Disabling activities Page OTDBP100 the table migration utility Functions JCL requirements Sysin parameter specificationRESTART=YESNO NEWTAPE=YESNO Sqlin 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 Page Page DB2 Manager Utilities OTDBP120 the row restore utilityExec PGM=OTDBP120,REGION=4096K Sysin parameter specification INDEXONLY=YN Where Acno = ‘123456789’ Objects will be satisfied via DB2 only OTDBP130 the pre-fetch utility Clean-up processingExec PGM=OTDBP130,REGION=4096K Sysin parameter specification PRINT=DETAILSUMMARY Print reports Problem. Refer to for a description of the messages Archive Manager housekeeping processing OTDBP140 the table analysis utilityDSN=Table.identification.file,DISP=SHR Select key1, key2, .. .., keyn from tablename 108 DB2 Manager User Guide StorageTek Proprietary Detailed table analysis report OTDBP170 the database housekeeping utility110 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 OTD10000 Row Migration Utility ended with completion code Messages and CodesOTD100xx table migration utility messages OTD10005 Load failed for program Dsnali DSNHLI2 OTD10001 Open failed for xxxxxxxx datasetOTD10003 Mandatory exec parameters have not been specified 120 DB2 Manager User Guide StorageTek Proprietary OTD10011 Return code Xxx’ retrieving Name/Token pair OTD10012 Error locating OdctOTD10017 Unable to obtain Odre request element OTD10015 The control region is not activeOTD10016 Normal run requested but restart run required Page OTD10021 Insufficient storage for workareas OTD12001 Open failed for xxxxxxxx dataset OTD120xx row restore utility messagesOTD12000 Row Restore Utility ended with completion code OTD12007 Load failed for program Dsnali DSNHLI2 OTD12004 Mandatory exec parameters have not been specifiedOTD12006 Insufficient storage for workareas DB2 Manager User Guide 127 StorageTek Proprietary Sortout OTD13001 Open failed for xxxxxxxx dataset OTD130xx pre-fetch utility messagesOTD13000 Batch Pre-fetch Utility ended with completion code OTD13007 Load failed for program Dsnali DSNHLI2 OTD13004 Mandatory exec parameters have not been specifiedOTD13006 Insufficient storage for workareas DB2 Manager User Guide 131 StorageTek Proprietary OTD14000 Table Analysis Utility ended with completion code OTD140xx table analysis utility messagesOTD13015 Archive Manager is not at the correct level OTD14004 Mandatory exec parameters have not been specified OTD14001 Open failed for Sysinsqlin datasetOTD14007 Load failed for program Dsnali DSNHLI2 OTD14006 Insufficient storage for workareasPage Page OTD17001 Open failed for Sysinsqlin dataset OTD170xx database housekeeping utility messagesOTD17007 Load failed for program Dsnali DSNHLI2 OTD17004 Mandatory exec parameters have not been specifiedOTD17006 Insufficient storage for workareas Page OTD20000 Enter request OTD20001 Error opening parameter file SysparmOTD200xx control region master processor messages OTD20005 Envcntl Tapecntl parameters being processed OTD20006 Envcntl Tapecntl parameter validation errorsOTD20004 OTD20008 Odct Getmain failure OTD20010 Error Xxx during initialization of task tnnnOTD20011 Timeout error during initialization of task tnnn OTD20007 Envcntl Tapecntl parameters successfully processedOTD20013 Getmain failure Xxx allocating task tnnn OTD20014 Error Xxx received attaching task tnnnOTD20017 Intercept successfully established OTD20016 OTDBP300 is not in Link Pack AreaOTD20026 Control region already initialized job terminating OTD20019 Error locating DB2 Manager Ascb JobnameOTD20020 Lifecycle Director V1.1 initialization starting OTD20021 Initialization completed successfullyOTD20029 Recursive abends intercepted job terminating OTD20030 Error received posting requestor ECBOTD20032 Command rejected enter request via Modify command OTD20028 Unable to continue after abend job terminatingOTD20050 Missing or invalid request ignored OTD20034 Error X’xx’ received loading programOTD20049 Task tnnn shutdown request has failed error OTD20051 Invalid Set operands request ignored OTD20052 Configuration altered successfullyOTD20058 Display processing completed OTD20056 Errors altering configuration check system statusOTD20055 Missing/invalid operand request rejected OTD20057 Requested task tnnn does not exist request ignoredOTD20061 Invalid Display operands request ignored OTD20060 Task tnnn has been shutdown successfullyOTD20067 Request nnn Stg Level=x Tape=yyyyy Blockid=zzzzzzzz OTD20073 Task tnnn purge request is being processed OTD20082 Controller received error posting requestor ECBOTD20071 Invalid Purge operands request ignored OTD20072 Task tnnn is already being purged request ignoredOTD20092 Do you want to proceed with shutdown y/n? OTD20094 Error freeing communications table storageOTD20083 Task tnnn has not been purged request ignored OTD20091 Invalid Shutdown operandsOTD20096 Shutdown processing complete OTD220xx control region scheduler messagesOTD20095 Communications table storage area freed OTD22004 Invalid request on Scheduler Queue OTD22003 Storage Release Error Return Code=Xxx T=SnnnOTD22009 Scheduler task nnn terminated OTD22008 Scheduler task nnn abend Sxxx interceptedOTD25001 Invalid Odrh received on entry OTD250xx control region tape reader messagesOTD25007 Tape rdr task nnn abend Sxxx intercepted OTD25003 Unable to get exclusive access to Odre resourceOTD25004 Insufficient storage for workareas OTD25005 Tape rdr task nnn initialization failedOTD25013 Error xx received writing SMF record OTD25404 Insufficient storage for workareas OTD25403 Unable to get exclusive access to Odre resourceOTD254xx control region disk reader messages OTD25401 Invalid Odrh received on entryOTD25409 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 OTD25413 Error xx received writing SMF recordOTD260xx control region writer messages OTD26005 Tape wtr task nnn initialization failed OTD26003 Unable to get exclusive access to Odre resourceOTD26004 Insufficient storage for workareas OTD26009 Tape wtr task nnn terminated OTD26007 Tape wtr task nnn abend Sxxx interceptedOTD270xx control region housekeeping task messages OTD27008 Hnnn request timed out Odre DB2 Manager error and reason codesOTD27005 Housekeeping task Hnnn terminated OTD27007 Housekeeping task nnn abend Sxxx interceptedReason code Explanation hex Action Control region return codes Explanation DB2 Manager User Guide 171 StorageTek Proprietary Appendix a Sample JCL members AppendicesOtdbdef 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 ∎ Contact Us Reader’s Comment FormBusiness Reply Card StorageTek Proprietary About Storagetek World Headquarters