Operational considerations | StorageTek 312564001 specs

Offset

60

62

64

72

80

84

Length

2

2

8

8

4

12

Format	Description

Bin	Record number within object containing
	stored/retrieved row
Bin	Number of records containing
	stored/retrieved row
char	Requester’s jobname
char	Requester’s userid.
char	Identifier of system on which request
	originated

-Reserved

Operational considerations

This section discusses miscellaneous topics relating to the operation of the DB2 Manager control region and its environment. This includes a discussion of performance considerations for retrieval of migrated rows from an Archive Manager database using DB2 Manager.

Use of the MAXTRDR parameter

	The MAXTRDR parameter is used to limit the number of tape cartridge drives
	that DB2 Manager will allocate concurrently for performing simultaneous
	access to multiple tape volumes in response to migrated row retrieval
	requests. It is intended to enable users to prevent DB2 Manager from
	depleting the number of available cartridge drives on a system to the extent
	that other work will be unable to complete.
	Once at the MAXTRDR limit, DB2 Manager will reject any other request
	which would require an extra tape drive in order for it to be satisfied, with a
	‘resource unavailable’ condition, or optionally queue the request internally if a
	non-zero value has been specified for the TAPEWAIT parameter in the
	TAPECNTL parameter library member. In this latter case DB2 Manager will
	retry the request at 1-second intervals until a tape drive becomes available or
	until the TAPEWAIT interval is exceeded.
	Rejection of a request due to the MAXTRDR value having been reached or
	due to the TAPEWAIT interval having been exceeded will generate an SQL –
	652 error and reason code (in field SQLERRD(6) in the SQLCA) of X’1015’.
	The value chosen for MAXTRDR should ensure that occurrence of this
	condition is minimized, while still allowing other work on the system to
	continue without delay. If necessary, the value of MAXTRDR may be varied
	during the day to correspond to variations in the system workload.
70	DB2 Manager User Guide
	StorageTek Proprietary

Image 73

StorageTek 312564001 manual Operational considerations, Use of the Maxtrdr parameter

Contents

Lifecycle Directortm Page Version Lifecycle Director DB2 Manager User Guide 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 Row migration Product Functions Retrieval of migrated rows Access to migrated rows Update of migrated rows Deletion of migrated rows Management of migrated rows DB2 Manager storage configuration Product implementation DB2 management processing Database backup and recoveryDatabase reorganization Pre-requisites for DB2 Manager implementation Page DB2 Manager implementation procedures Installation and ImplementationArchive Manager implementation Dataset Name Description Install distribution libraries Tapecntl Update DB2 Manager parameter library Update the system Program Properties Table PPT Create DB2 Manager control region procedurePerform MVS host system modifications Assign DB2 Manager user identification Update Flpa or Mlpa definitions Perform tape management system changes Allocate DB2 Manager SMF record identifier Perform STK Host Software Component HSC changes Update automated reply software controls Perform DB2 system modifications Create LCDDB2 system database and grant access authorities Create DB2 Manager application plan Resource type Resource name Access required Enter the value ‘4’ Define Archive Manager databases 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 General parameter format DB2 Manager Parameter Specification Envcntl Smfrecid Envcntl parameters Envcntl Objsize Tapecntl parameters Envcntl Writetimeout Tapecntl Maxdrdr Tapecntl Maxtwtr Tapecntl Maxqlen Tapecntl Tapewait Tapecntl Command Page Control region initialization DB2 Manager Control Region Start LCDDB2 DB2 Control region componentsPage SQL Select processing Processing requests for access to migrated rows SQL Update processing DB2 Manager operator interface SQL error codesSQL Delete processing Display summary status Stg level Dbid Example Display detail status LCDDB2,D T=T1 Force purge task LCDDB2,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 section Database section Record descriptor section Request section Offset Length Format Description Offset Length Format Use of the Maxtrdr parameter Operational considerations Use of the Maxqlen parameter Use of the Maxdrdr parameter Allocation recovery Shutdown processing Resource unavailable condition Enabling a DB2 table for migration processing Table migration processing Introduction Enabling activities Restrictions Otdbind ASC Cluster Disabling activities Page OTDBP100 the table migration utility Functions JCL requirements Sysin parameter specification RESTART=YESNO NEWTAPE=YESNO Sqlin entry specification Print reports Parmlib requirements Condition 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 recovery Archive Manager database recovery Page Page DB2 Manager Utilities OTDBP120 the row restore utility Exec 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 processing Exec 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 utility DSN=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 utility 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 OTD100xx table migration utility messages Messages and CodesOTD10000 Row Migration Utility ended with completion code OTD10003 Mandatory exec parameters have not been specified OTD10001 Open failed for xxxxxxxx datasetOTD10005 Load failed for program Dsnali DSNHLI2 120 DB2 Manager User Guide StorageTek Proprietary OTD10011 Return code Xxx’ retrieving Name/Token pair OTD10012 Error locating Odct OTD10016 Normal run requested but restart run required OTD10015 The control region is not activeOTD10017 Unable to obtain Odre request element Page OTD10021 Insufficient storage for workareas OTD12000 Row Restore Utility ended with completion code OTD120xx row restore utility messagesOTD12001 Open failed for xxxxxxxx dataset OTD12006 Insufficient storage for workareas OTD12004 Mandatory exec parameters have not been specifiedOTD12007 Load failed for program Dsnali DSNHLI2 DB2 Manager User Guide 127 StorageTek Proprietary Sortout OTD13000 Batch Pre-fetch Utility ended with completion code OTD130xx pre-fetch utility messagesOTD13001 Open failed for xxxxxxxx dataset OTD13006 Insufficient storage for workareas OTD13004 Mandatory exec parameters have not been specifiedOTD13007 Load failed for program Dsnali DSNHLI2 DB2 Manager User Guide 131 StorageTek Proprietary OTD13015 Archive Manager is not at the correct level OTD140xx table analysis utility messagesOTD14000 Table Analysis Utility ended with completion code OTD14004 Mandatory exec parameters have not been specified OTD14001 Open failed for Sysinsqlin dataset OTD14007 Load failed for program Dsnali DSNHLI2 OTD14006 Insufficient storage for workareasPage Page OTD17001 Open failed for Sysinsqlin dataset OTD170xx database housekeeping utility messages OTD17006 Insufficient storage for workareas OTD17004 Mandatory exec parameters have not been specifiedOTD17007 Load failed for program Dsnali DSNHLI2 Page OTD200xx control region master processor messages OTD20001 Error opening parameter file SysparmOTD20000 Enter request OTD20004 OTD20006 Envcntl Tapecntl parameter validation errorsOTD20005 Envcntl Tapecntl parameters being processed OTD20011 Timeout error during initialization of task tnnn OTD20010 Error Xxx during initialization of task tnnnOTD20007 Envcntl Tapecntl parameters successfully processed OTD20008 Odct Getmain failure OTD20013 Getmain failure Xxx allocating task tnnn OTD20014 Error Xxx received attaching task tnnn OTD20017 Intercept successfully established OTD20016 OTDBP300 is not in Link Pack Area OTD20020 Lifecycle Director V1.1 initialization starting OTD20019 Error locating DB2 Manager Ascb JobnameOTD20021 Initialization completed successfully OTD20026 Control region already initialized job terminating OTD20032 Command rejected enter request via Modify command OTD20030 Error received posting requestor ECBOTD20028 Unable to continue after abend job terminating OTD20029 Recursive abends intercepted job terminating OTD20049 Task tnnn shutdown request has failed error OTD20034 Error X’xx’ received loading programOTD20050 Missing or invalid request ignored OTD20051 Invalid Set operands request ignored OTD20052 Configuration altered successfully OTD20055 Missing/invalid operand request rejected OTD20056 Errors altering configuration check system statusOTD20057 Requested task tnnn does not exist request ignored OTD20058 Display processing completed OTD20061 Invalid Display operands request ignored OTD20060 Task tnnn has been shutdown successfully OTD20067 Request nnn Stg Level=x Tape=yyyyy Blockid=zzzzzzzz OTD20071 Invalid Purge operands request ignored OTD20082 Controller received error posting requestor ECBOTD20072 Task tnnn is already being purged request ignored OTD20073 Task tnnn purge request is being processed OTD20083 Task tnnn has not been purged request ignored OTD20094 Error freeing communications table storageOTD20091 Invalid Shutdown operands OTD20092 Do you want to proceed with shutdown y/n? OTD20095 Communications table storage area freed OTD220xx control region scheduler messagesOTD20096 Shutdown processing complete OTD22004 Invalid request on Scheduler Queue OTD22003 Storage Release Error Return Code=Xxx T=Snnn OTD22009 Scheduler task nnn terminated OTD22008 Scheduler task nnn abend Sxxx intercepted OTD25001 Invalid Odrh received on entry OTD250xx control region tape reader messages OTD25004 Insufficient storage for workareas OTD25003 Unable to get exclusive access to Odre resourceOTD25005 Tape rdr task nnn initialization failed OTD25007 Tape rdr task nnn abend Sxxx intercepted OTD25013 Error xx received writing SMF record OTD254xx control region disk reader messages OTD25403 Unable to get exclusive access to Odre resourceOTD25401 Invalid Odrh received on entry OTD25404 Insufficient storage for workareas OTD25407 Disk rdr task nnn abend Sxxx intercepted OTD25405 Disk rdr task nnn initialization failedOTD25409 Disk rdr task nnn terminated OTD260xx control region writer messages OTD25413 Error xx received writing SMF recordOTD26001 Invalid Odwh received on entry OTD26004 Insufficient storage for workareas OTD26003 Unable to get exclusive access to Odre resourceOTD26005 Tape wtr task nnn initialization failed OTD26009 Tape wtr task nnn terminated OTD26007 Tape wtr task nnn abend Sxxx intercepted OTD270xx control region housekeeping task messages OTD27005 Housekeeping task Hnnn terminated DB2 Manager error and reason codesOTD27007 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 Appendix a Sample JCL members Appendices 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 ∎ Contact Us Reader’s Comment Form Business Reply Card StorageTek Proprietary About Storagetek World Headquarters