StorageTek 312564001 manual

PA R T N U M B E R VERSION NUMBER PRODUCT TYPE SOF TW ARE EDITION NUMBER LIFECYCLE DIRECTOR DB2 MANAGER USER GUIDE 312564001 1.1 1 TM[...]

[...]

Lifecycle Director™ DB2 Manager User Guide V ersion 1.1 EC 132056 Revision C[...]

ii First Edition 312564001 StorageTek Protected Information cont ained in this pu blicatio n is subject to change without no tice. We welcome yo ur feedback. Please cont act the Global Learning Solutions Feedback System at: GLSFS@S tortek.com or Global Learning Solutions S tor age T echnology Corporation One S tor ageT ek Drive Louisville, CO 80028[...]

DB2 Manager User Guide 1 StorageTek Proprietary T able of content s INTRODUCTION.................................................................................................................. 7 PRODUCT DESCRIPTION ................................................................................................. 8  I NTRODUCTION ...............[...]

2 DB2 Manager User Guide StorageTek Proprietary ENVCNTL: SMFRECID ................................................................................................ 35 ENVCNTL: OBJSIZE ..................................................................................................... 36 ENVCNTL: READTIMEOUT .........................................[...]

DB2 Manager User Guide 3 StorageTek Proprietary Allocation recovery ........................................................................................................ 72 Shutdown processing ..................................................................................................... 73 'Resource unavailable' condition ......[...]

4 DB2 Manager User Guide StorageTek Proprietary SQLIN entry specification ............................................................................................ 102 Print reports ................................................................................................................. 1 03 Condition codes ..............................[...]

DB2 Manager User Guide 5 StorageTek Proprietary  OTD260 XX – CONTROL REGION WRITER MESSAGES ............................................. 162  OTD270 XX - CONTROL REGION HOUSEKEEPING TASK MESSAGES ......................... 165  DB2 M ANAGER ERROR AND REASON CODES ......................................................... 166  C ONTROL [...]

DB2 Manager User Guide 7 StorageTek Proprietary Introduction This Lifecycle Director DB2 Manager User Guide provides all the information required for installation, implementation and operation of the DB2 Manager product for the enabling of Lifecycle Director support for the storage and retrieval of table rows using IBM's DB2 relational databas[...]

8 DB2 Manager User Guide StorageTek Proprietary Product Description  Introduction Storage Technology's DB2 Manager software product is designed to implement Archive Manager support for storage of table rows using IBM's DB2 relational database management product. Archive Manager is a Storage Technology archival database management produ[...]

DB2 Manager User Guide 9 StorageTek Proprietary request. Standard DB2 processing then requires the use of a cursor mechanism in order to access each row from the result table, rows being retrieved via an SQL FETCH command. In cases where rows in the result table have been migrated from DB2 to Archive Manager, the resulting FETCH commands may genera[...]

10 DB2 Manager User Guide StorageTek Proprietary within the table to be released and re-used, enabling a reduction in the overall size of the DB2 tablespace used for table storage. Reduction in the tablespace size will give a corresponding reduction in the overall amount of disk space required to support DB2 database usage, and also reduce the amou[...]

DB2 Manager User Guide 11 StorageTek Proprietary A migrated row which has been retrieved from an Archive Manager database is presented back to the calling application on reference via SQL. No indication is given to the application that the row has been retrieved from Archive Manager, and the contents of the row will be identical to those prior to m[...]

12 DB2 Manager User Guide StorageTek Proprietary updated row will be stored back in the DB2 table from which it was originally migrated. All reference to the migrated copy of the row in the Archive Manager database will have been deleted, causing this row to be unreferenced. This will effectively “re-migrate” the row from Archive Manager to DB2[...]

DB2 Manager User Guide 13 StorageTek Proprietary Management of migrated rows A set of batch utilities is supplied with the product in order to assist in management of migrated rows. The following utilities are supplied with v1.1 of the product: • Row restore utility. This will allow migrated rows to be returned to the table from which they were m[...]

14 DB2 Manager User Guide StorageTek Proprietary 2. Primary key. This is a 4-byte (fullword) binary value, which is automatically assigned by DB2 Manager during migration processing. A primary key value of 1 will be assigned to the object containing the first row archived from a table after it has been enabled for archival. All rows within a single[...]

DB2 Manager User Guide 15 StorageTek Proprietary Rows which have a high likelihood of being updated after archival may cause a significant amount of archival and re-archival processing. A table containing rows which are likely to be updated in this manner are not suitable for migration using DB2 Manager. DB2 Manager does not impose limitations on t[...]

16 DB2 Manager User Guide StorageTek Proprietary exclusive storage of migrated row stubs, and one or more partitions for storage of non-migrated rows. Database reorganization processing should not be performed on the partition containing the migrated row stubs, unless absolutely necessary. Reorganization of this partition will cause all migrated ro[...]

DB2 Manager User Guide 17 StorageTek Proprietary This page is intentionally left blank[...]

18 DB2 Manager User Guide StorageTek Proprietary Inst allation and Implement ation This section describes the activities required to install and implement DB2 Manager for use in migrating and retrieving DB2 table rows to and from Archive Manager in a hos t system environment. After all activities described in this section have been successfully com[...]

DB2 Manager User Guide 19 StorageTek Proprietary Install distribution libraries DB2 Manager V1.1 is distributed on a standard-labeled magnetic tape cartridge in SMP/E RELFILE format. The cartridge has a serial number of OTD110. The distribution tape will contain the following datasets: Dataset Name Description 1 SMPMCS SMP/E modification control st[...]

20 DB2 Manager User Guide StorageTek Proprietary On completion of the above step a partitioned dataset containing JCL to be used during the remainder of the installation process will have been created. 2) Edit member SMPEDEF from the installation JCL dataset unloaded in the preceding step, as described within the dataset member itself. This job wil[...]

DB2 Manager User Guide 21 StorageTek Proprietary After unloading the sample parameter library, review all parameter values, and amend as necessary to reflect t he host system's operating environment, and your own requirements for DB2 Manager migration and retrieval processing. Refer to chapter 3 of this manual for a full description of the DB2[...]

22 DB2 Manager User Guide StorageTek Proprietary The following is an example of how to specify the PPT entry in the appropriate SCHEDxx member of SYS1.PARMLIB: PPT PGMNAME(OTDBP200) NOSWAP KEY(7) SYST e. Update FLPA or MLPA definitions. The DB2 Manager SQL intercept module OTDBP300 from the distribution LPA library must be installed in the FLPA or [...]

DB2 Manager User Guide 23 StorageTek Proprietary f. Allocate DB2 Manager SMF record identifier. The DB2 Manager control region will optionally create SMF records during object retrieval processing. This option is controlled via the SMFRECID parameter in the ENVCNTL parameter library member. If it is required that DB2 Manager should create SMF recor[...]

24 DB2 Manager User Guide StorageTek Proprietary Primary or secondary DB2 Manager tape datasets will be released under the following circumstances: • The Archive Manager tape backup utility will automatically uncatalog backup datasets which are being recreated during the migration process (this will occur when objects are added to a partially-use[...]

DB2 Manager User Guide 25 StorageTek Proprietary To avoid any unnecessary and unpredictable delays due to this situation, any automated operator reply facility which is present on the host system should be configured to reply 'CANCEL' to the above message for any DB2 Manager retrieval request (ie) a request for retrieval from an Archive M[...]

26 DB2 Manager User Guide StorageTek Proprietary Resource type Resource name Access required DATABASE LCDDB2 CREATETAB TABLESPACE LCDDB2.LCDDB2TS USE OF TABLE LCDDB2.PLAN_TABLE SELECT,DELETE, INSERT,UPDATE TABLE LCDDB2.REGISTRY SELECT,DELETE,I NSERT,UPDATE Member OTDBDEF in the distributed DB2 Manager JCL library supplies a job to allocate and defi[...]

DB2 Manager User Guide 27 StorageTek Proprietary Define Archive Manager databases DB2 Manager uses the Archive Manager co mponent of the Lifecycle Director of DB2 product for storage and retrieval of objects. Migrated rows are held in one or more Archive Manager databases, one Archive Manager database being used per DB2 table which has been enabled[...]

28 DB2 Manager User Guide StorageTek Proprietary Data retention period This entry should be allowed to default to a value of 0 years and 0 days (ie) no automatic expiry. Archive Manager objects should not be allowed to expire. They will be explicitly deleted by the DB2 Manager database housekeeping utility when they do not contain any more active m[...]

DB2 Manager User Guide 29 StorageTek Proprietary OTSN4301 Lifecycle Director Enter values Archive Manager V2.6 Storage Level Definition COMMAND ===> ------------------------------------------------------------------------------- Primary index name ===> OTDB.V1R1.TEST.INDEX Storage level ===> 0 More: + Database blocksize ===> Maximum blo[...]

30 DB2 Manager User Guide StorageTek Proprietary index definition parameters for the Archive Manager database being defined. 5. After all database definition and initialization parameters have been accepted, one or more Access Method Services (AMS) control panels will be displayed to allow customization of AMS parameters used by Archive Manager whe[...]

DB2 Manager User Guide 31 StorageTek Proprietary OTSN4302 Lifecycle Director Enter values Archive Manager V2.6 Access Method Services Control COMMAND ===> ------------------------------------------------------------------------------- Primary index name ===> OTDB.V1R1.TEST.INDEX Primary index control: Volume serial number ===> Unit of allo[...]

32 DB2 Manager User Guide StorageTek Proprietary be used for allocation of the index component of the dataset (KSDS only). This should be a valid VSAM control interval size. If omitted, a control interval size of 2k is used for the index component. Delete before define? Optional entry. Enter the value 'Y' if Archive Manager should attempt[...]

DB2 Manager User Guide 33 StorageTek Proprietary[...]

34 DB2 Manager User Guide StorageTek Proprietary DB2 Manager Parameter S pecification DB2 Manager uses its own parameter library to allow users to control the operation of the product. This parameter library is a partitioned dataset containing the following members: ENVCNTL - used to specify general parameters relating to the DB2 Manager operating [...]

DB2 Manager User Guide 35 StorageTek Proprietary record. Individual keyword parameters may not be continued over more than one record. An asterisk ('*') in character position 1 will indicate a comment record, which will be ignored for parameter validation processing. Any departure from this general format will be indicated with individual[...]

36 DB2 Manager User Guide StorageTek Proprietary ENVCNTL: OBJSIZE OBJSIZE = nnnnn Requirement: Optional Default: 1000 Validation: 'nnnnn' = a 1- to 5-digit numeric value in the range 1-65535. Use: The OBJSIZE parameter is used to specify the maximum number of migrated rows to be stored per Archive Manager object. Notes: Increasing the max[...]

DB2 Manager User Guide 37 StorageTek Proprietary request will be rejected with a ‘timeout’ condition. An SQL error of –652 will be returned to the requesting application. Field SQLERRD(6) in the SQLCA will contain the hexadecimal value x’0A’. ENVCNTL: WRITETIMEOUT WRITETIMEOUT = nnnn Requirement: Optional Default: 10 Validation: ‘nnnn?[...]

38 DB2 Manager User Guide StorageTek Proprietary Use: The MAXTRDR parameter specifies the number of active tape-reader subtasks which are to be created in the DB2 Manager control region. Notes: This parameter indirectly controls the maximum number of tape drives which may be concurrently allocated by the control region. If TAPEWAIT=0 is specified, [...]

DB2 Manager User Guide 39 StorageTek Proprietary and may improve retrieval response times. If this parameter is omitted, a default value of MAXDRDR=4 will be used. TAPECNTL: MAXTWTR MAXTWTR = nnn Requirement: Optional Default: 4 Validation: nnn = 1-3 digit numeric value in range 1 - 255 Use: The MAXTWTR parameter specifies the number of active tape[...]

40 DB2 Manager User Guide StorageTek Proprietary scheduler subtask introduces some processing overhead, so care should be taken to avoid over-allocation of this setting. This setting may be varied during DB2 Manager operation via the 'SET MAXSCHED’ operator command. If this parameter is omitted, a default value of MAXSCHED=4 will be used. TA[...]

DB2 Manager User Guide 41 StorageTek Proprietary Requirement: Optional Default: 0 Validation: nnnn = 1-4 digit numeric value in range 0 - 1440 Use: The RETAINTAPE parameter specifies the number of minutes for which a tape is to remain mounted after all outstanding retrieval requests from that tape have been processed by the DB2 Manager control regi[...]

42 DB2 Manager User Guide StorageTek Proprietary If set to 0 (the default), no internal queuing of requests will take place in the above circumstances and the request will be rejected with a ‘resource unavailable’ reason code. If the TAPEWAIT parameter value is in the range 1-1439, requests will be queued internally until processed or until the[...]

DB2 Manager User Guide 43 StorageTek Proprietary This page is intentionally left blank[...]

44 DB2 Manager User Guide StorageTek Proprietary DB2 Manager Control Region All access to Archive Manager databases containing migrated rows is performed via the DB2 Manager control region. This is a started task, which must be initiated prior to performing any DB2 row migration or retrieval activities. This chapter describes the operation and cont[...]

DB2 Manager User Guide 45 StorageTek Proprietary • The distributed DB2 Manager and Archive Manager load libraries must be available to this task, either via the system linklist, or from the procedure's STEPLIB concatenation. • The DB2 Manager control region must run with APF-authorization. Both the DB2 Manager and Archive Manager load libr[...]

46 DB2 Manager User Guide StorageTek Proprietary  Control region components The control region must be initialized in order to enable DB2 Manager to access migrated rows, and to allow migration of rows from DB2 to Archive Manager. Figure 4 illustrates the structure of the control region and the migrated row access mechanism. This also shows the [...]

DB2 Manager User Guide 47 StorageTek Proprietary The following control region components are illustrated in Figure 4: • Control processor. This component is responsible for initiation and termination of the control region, and for processing operator requests. • Writer tasks. There will be one or more writer tasks – the number of writer tasks[...]

48 DB2 Manager User Guide StorageTek Proprietary  Processing requests for access to migrated rows Once DB2 Manager initialization has been completed, batch, TSO, CICS or IMS programs will be able to access migrated rows using standard SQL processing, without modification. DB2 Manager implements support for access to migrated rows which is made v[...]

DB2 Manager User Guide 49 StorageTek Proprietary volume. This will improve response times for subsequent requests to the same tape volume, but may cause an additional processing overhead if the tape has to be dismounted prior to the task allocating a different tape volume (as required in task selection criterion (3) above). Refer to page 40 for a d[...]

50 DB2 Manager User Guide StorageTek Proprietary SQL DELETE processing A request by an application to delete a migrated row via an SQL DELETE command will cause that row to be retrieved via the process described in the preceding section. The row will then be deleted, causing the archive stub for the row to be removed from the DB2 table. All referen[...]

DB2 Manager User Guide 51 StorageTek Proprietary • Terminate the DB2 Manager control region. All messages issued by DB2 Manager in response to an operator request are documented in chapter 7 of this manual. This section specifies operator request formats, and gives examples of DB2 Manager responses to these requests. Display summary status D(ISPL[...]

52 DB2 Manager User Guide StorageTek Proprietary the status of the internal scheduler queue lock and the length of the scheduler queue, in message OTD20062. In addition, message OTD20063 will be displayed for each reader, writer and scheduler task in the system, giving the following details: Status - this field indicates the current status of the i[...]

DB2 Manager User Guide 53 StorageTek Proprietary Tape - identifies the sequence number within Archive Manager database Lastuse - for tasks with status = WTRT, this gives the time (in format HH:MM:SS) that the last request for retrieval from this tape volume was completed. This timestamp is used by DB2 Manager to determine which tape volume will be [...]

54 DB2 Manager User Guide StorageTek Proprietary Display detail status D(ISPLAY) T(ASK = (T|D|W|S)nnn This request is used to produce a detailed display of the status of the DB2 Manager control region retrieval configuration. The DISPLAY command may be abbreviated to the single character 'D'. The TASK parameter may be abbreviated to the s[...]

DB2 Manager User Guide 55 StorageTek Proprietary Example: F LCDDB2,D T=T1 ...... OTD20063 Task T001: Status=BUSY Qlen=001 DBID=ST01 Stg_level=0 Tape=00002 OTD20066 Request 001: Type=Retrieve DBID=ST01 Jobname=WATERSGJ OTD20067 Request 001: Stg_level=0 Tape=00002 Blockid=01400005 OTD20058 Display processing completed Force purge task F(ORCE) T(ASK =[...]

56 DB2 Manager User Guide StorageTek Proprietary OTD20062 Maxtrdr=004 Maxdrdr=004 Maxtwtr=004 Maxsched=004 Maxqlen=100 OTD20062 Retaintape=0001 Tapewait=0004 Objsize=00100 OTD20062 Readtimeout=0005 Writetimeout=0005 OTD20062 Scheduler: Queue is unlocked; Queue length=000 OTD20063 Task T001: Status=BUSY Qlen=001 DBID=ST01 Stg_level=0 Tape=00002 OTD2[...]

DB2 Manager User Guide 57 StorageTek Proprietary Purge task P(URGE) T(ASK) = (T|D|W|S)nnn The PURGE command is used to terminate a tape or disk reader task, a writer task or a scheduler task in the DB2 Manager control region. All outstanding requests in the task queue will be allowed to complete normally before task termination. The command may be [...]

58 DB2 Manager User Guide StorageTek Proprietary OTD20063 Task D003: Status=WAIT Qlen=000 OTD20063 Task D004: Status=WAIT Qlen=000 OTD20063 Task W001: Status=WAIT Qlen=000 OTD20063 Task W002: Status=WAIT Qlen=000 OTD20063 Task W003: Status=WAIT Qlen=000 OTD20063 Task W004: Status=WAIT Qlen=000 OTD20063 Task S001: Status=WAIT Qlen=000 OTD20063 Task [...]

DB2 Manager User Guide 59 StorageTek Proprietary WRITETIMEOUT parameters. The command may be abbreviated to the single character 'S'. The values of MAXTRDR, MAXDRDR, MAXSCHED, MAX QLEN, RETAINTAPE, TAPEWAIT, OBJSIZE, READTIMEOUT and WRITETIMEOUT are initially set during DB2 Manager control region initialization from the corresponding para[...]

60 DB2 Manager User Guide StorageTek Proprietary If the value of MAXTWTR is to be increased, DB2 Manager will increase the number of initialized writer tasks, by restarting terminated tasks, and/or adding new tasks. If the value of MAXTWTR is to be decreased, DB2 Manager will terminate a number of existing writer tasks equal to the decrease in the [...]

DB2 Manager User Guide 61 StorageTek Proprietary 65535. This change will take effect the next time a database is connected for update processing by the DB2 Manager table migration utility. READTIMEOUT - DB2 Manager will alter the current setting of the READTIMEOUT parameter to the value specified in the SET command. ‘nnnn’ must be a 1-4 digit n[...]

62 DB2 Manager User Guide StorageTek Proprietary OTD20063 Task D002: Status=WAIT Qlen=000 OTD20063 Task D003: Status=WAIT Qlen=000 OTD20063 Task D004: Status=WAIT Qlen=000 OTD20063 Task W001: Status=TERM Qlen=000 OTD20063 Task W002: Status=TERM Qlen=000 OTD20063 Task W003: Status=WAIT Qlen=000 OTD20063 Task W004: Status=WAIT Qlen=000 OTD20063 Task [...]

DB2 Manager User Guide 63 StorageTek Proprietary IEE600I REPLY TO 13 IS;SHUTDOWN 14 OTD20092 Do you want to proceed with shutdown (y/n)? R 14,Y IEE600I REPLY TO 14 IS;Y OTD20093 Shutdown in progress OTD20060 Task H001 has been shutdown successfully OTD25009 Tape rdr task 004 terminated OTD20060 Task T004 has been shutdown successfully OTD25009 Tape[...]

64 DB2 Manager User Guide StorageTek Proprietary If requested, DB2 Manager will create SMF records at the following points: a. When all requests for retrieval of rows from a single tape cartridge volume have been completed by a tape reader task (ie) immediately before a busy task returns to wait status. The SMF record will contain one request secti[...]

DB2 Manager User Guide 65 StorageTek Proprietary 4. Termination of request processing by the reader or writer task in the control region. Analysis of timestamp intervals will provide timings for the following activities: • 4 - 1 : total time for DB2 Manager to process the request. • 2 - 1: time spent in control region scheduler queue. • 3 - 2[...]

66 DB2 Manager User Guide StorageTek Proprietary Record descriptor section The SMF header section is immediately followed by the DB2 Manager record descriptor section. It has a fixed length of 38 bytes. Offset Length Format Description 18 6 bin Reserved. 24 4 bin Offset of database section. This is the offset from the start of the SMF record of the[...]

DB2 Manager User Guide 67 StorageTek Proprietary Offset Length Format Description 1 3 Char DB2 Manager reader/writer task number. 4 4 char Identifier of Archive Manager database being processed. 8 16 - Reserved for future use Request section The request section starts at the offset specified in the record descriptor section of the DB2 Manager SMF r[...]

68 DB2 Manager User Guide StorageTek Proprietary Offset Length Format Description 0 8 bin Request start timestamp. This gives the date and time that the request was received by the DB2 Manager edit routine. It has the format: bytes 0-3: time in hundredths of a second since midnight that request processing started. bytes 4-7: date that request proce[...]

DB2 Manager User Guide 69 StorageTek Proprietary Offset Length Format Description request processing ended. bytes 4-7: date that request processing ended, in packed decimal format 0cyydddF, where F is the sign. 32 2 char Return code. 34 2 bin Supplementary return code 1 36 2 bin Supplementary return code 2 38 2 Bin Request type: 0 – read request [...]

70 DB2 Manager User Guide StorageTek Proprietary Offset Length Format Description 60 2 Bin Record number within object containing stored/retrieved row 62 2 Bin Number of records containing stored/retrieved row 64 8 char Requester’s jobname 72 8 char Requester’s userid. 80 4 char Identifier of system on which request originated 84 12 - Reserved [...]

DB2 Manager User Guide 71 StorageTek Proprietary In a mixed operating environment which consists of both library and free- standing tape drives, the STK Host Software Component will ensure that all primary DB2 Manager tapes will be located in a library storage module. The value of MAXTRDR used in this environment should not exceed the total number [...]

72 DB2 Manager User Guide StorageTek Proprietary Rejection of a request due to the MAXQLEN value having been reached or due to the TAPEWAIT interval having been exceeded will generate an SQL – 652 error with a reason code of X'1015' in field SQLERRD(6) in the SQLCA. Use of the MAXDRDR parameter The MAXDRDR parameter is used to control t[...]

DB2 Manager User Guide 73 StorageTek Proprietary In the DB2 Manager environment, lack of available tape drives will cause the DB2 Manager control region to enter allocation recovery. Issuing a reply of WAIT will now mean that the application issuing the SQL command which caused the tape allocation request will have to wait indefinitely for another [...]

74 DB2 Manager User Guide StorageTek Proprietary • Extended CSA storage used by DB2 Manager (approximately 212k in extended subpool 241) will not be released, and will be unavailable for use by other jobs in the system until the next IPL. 'Resource unavailable' condition DB2 Manager will return a ‘resource unavailable’ condition to [...]

DB2 Manager User Guide 75 StorageTek Proprietary T able migration processing  Introduction DB2 Manager provides functions to perform the migration of rows from DB2 to Archive Manager storage. These functions are provided by the DB2 Manager table migration utility, OTDBP100. The table migration utility is executed as a batch process, and should b[...]

76 DB2 Manager User Guide StorageTek Proprietary Restrictions DB2 tables which are to be eligible for processing by DB2 Manager must adhere to the following restrictions: • Each row in the table must be indexed by a unique key. The indexing key can consist of one or multiple columns in the table. • The table must not contain large objects (LOBs[...]

DB2 Manager User Guide 77 StorageTek Proprietary FIELD13 TIMESTAMP , OTDBIND CHAR(1) DEFAULT '0' ) IN OTDBSYST.TAB1TS EDITPROC OTDBP300; • For existing non-partitioned tables, a new partitioning index to the new table must be created, as follows: CREATE INDEX dbname.indexname ON dbname.tabname ( OTDBIND ASC ) CLUSTER (PART 1 VALUES(&apo[...]

78 DB2 Manager User Guide StorageTek Proprietary • The contents of the existing table should be unloaded, and loaded into the new table. This will create an exact copy of the original table, with the modifications described above. • The original table should be dropped from DB2. • A view should be created of the new table. The view must have [...]

DB2 Manager User Guide 79 StorageTek Proprietary migration-enabled table – the last partition in this table should be removed when creating the disabled table. Alternatively, if the original tablespace used to hold the table prior to enabling it for migration processing still exists, this may be used. • A new table must be created in this table[...]

80 DB2 Manager User Guide StorageTek Proprietary  OTDBP100 - the table migration utility Migration of rows from a DB2 table to Archive Manager storage is performed using the DB2 Manager table migration utility. This is executed as a batch job, and processes a single DB2 table per execution. An SQLIN dataset entry is used to specify the selection[...]

DB2 Manager User Guide 81 StorageTek Proprietary Functions The table migration utility performs the following functions: • It processes and validates a series of parameters from a SYSIN file, and an object selection parameter from f ile SQLIN which will govern execution of the utility. A parameter specification and validation report is written to[...]

82 DB2 Manager User Guide StorageTek Proprietary JCL requirements The following JCL may be used to execute the utility: //* //STEP100 EXEC PGM=OTDBP100,REGION=4096K //* //STEPLIB DD DSN=Database.Manager.load.library,DISP=SHR // DD DSN=Archive.Manager.load.library,DISP=SHR //* //SYSIN DD DSN=Execution.parameter.file,DISP=SHR //SQLIN DD DSN=Migration[...]

DB2 Manager User Guide 83 StorageTek Proprietary to character position 71 of the record. Individual keyword parameters may not be continued over more than one record. An asterisk ('*') in character position 1 will indicate a comment record, which will be ignored for parameter validation processing. The following parameters may be specifie[...]

84 DB2 Manager User Guide StorageTek Proprietary • NEWTAPE=YES|NO This is an optional parameter used to cause a new tape volume in the Archive Manager database to be opened at the start of migration processing. If omitted, the default value of “NO” is used. • DB2SSID=xxxx This mandatory parameter is used to specify the subsystem identifier [...]

DB2 Manager User Guide 85 StorageTek Proprietary at the first commit point (as controlled via the COMMIT parameter) after reaching this value. ‘nnnnnn’ must be a 1-6 digit numeric value in the range 0-999999. A value of 0 indicates that there is no maximum to the number of rows to be migrated during execution of the utility. If this parameter i[...]

86 DB2 Manager User Guide StorageTek Proprietary PARMLIB requirements The following ENVCNTL parameter library entries are used by the DB2 Manager control region during table migration processing. It should be verified that these are set as required prior to the start of table migration processing. If not, they may be altered via the DB2 Manager ‘[...]

DB2 Manager User Guide 87 StorageTek Proprietary Condition codes The table migration utility will set a condition code on completion. This code may take the following values: 0 - the utility has been executed successfully. 4 - a warning condition has been encountered during processing of the utility. A warning message will have been written to the [...]

88 DB2 Manager User Guide StorageTek Proprietary Further executions of the table migration job for the appropriate DB2 table may subsequently be performed as normal.  Data management processing Following successful execution of a table migration process, a number of follow-up activities may be required in order to complete the management of migr[...]

DB2 Manager User Guide 89 StorageTek Proprietary Reorganization of other (non-migrated) partitions in the tablespace should be performed as normal. Regular reorganization will, in particular, be required for a period of time after implementation of DB2 Manager migration, in order to reclaim disk space occupied by rows which have been migrated to Ar[...]

90 DB2 Manager User Guide StorageTek Proprietary administration facility. The backup duplex copy is created at the same time as the backup copy. Each copy will contain a single standard-labeled dataset. The contents of each copy will be identical. The following dataset naming standards are used by Archive Manager to identify eac h copy in an Archiv[...]

DB2 Manager User Guide 91 StorageTek Proprietary Archive Manager database recovery may be required in the following circumstances: 1. loss of an individual tape volume from with an Archive Manager tape database (eg) due to media failure 2. loss of an entire Archive Manager database (eg) due to loss of data center. In both the above cases, standard [...]

92 DB2 Manager User Guide StorageTek Proprietary If disaster recovery is being performed on another processor, all disk datasets used by DB2 Manager and Archive Manager, and all user catalog entries from the primary facility, must be restored for use on the disaster recovery facility. There is no requirement for physical recovery of any tape datase[...]

DB2 Manager User Guide 93 StorageTek Proprietary DB2 Manager Utilities A number of batch utility programs are supplied with DB2 Manager, for provision of a range of facilities for supporting the DB2 Manager operational environment, and for extending functional capabilities supplied with other components of the product. These utilities consist of: ?[...]

94 DB2 Manager User Guide StorageTek Proprietary A print report is issued by the utility giving details of the execution parameters, the row restore selection criteria and summary information about the rows restored from Archive Manager. Functions The DB2 Manager row restore utility performs the following functions: • It will process and validate[...]

DB2 Manager User Guide 95 StorageTek Proprietary STEPLIB : Enter the names of the DB2 Manager and Archive Manager product load libraries. OTASxxxx : Enter the name of the primary index dataset of the Archive Manager database used for storage of objects from the DB2 table being processed by the utility. ‘xxxx’ should be set to the 4-character va[...]

96 DB2 Manager User Guide StorageTek Proprietary This mandatory parameter is used to specify the subsystem identifier of the DB2 subsystem to be used during execution of the utility. The subsystem identifier ‘xxxx’ can be 1-4 characters in length. • PLAN=xxxxxxxx This is an optional parameter which is used to specify the DB2 plan name to be u[...]

DB2 Manager User Guide 97 StorageTek Proprietary This is an optional parameter specifying the number of secondary extent blocks to be used during allocation of temporary dataset OTDBS120 used during execution of the utility. ‘nnnnnnn’ is a 1-7 digit numeric value in the range 1-8388607. If omitted, a default value of 10000 will be used. The len[...]

98 DB2 Manager User Guide StorageTek Proprietary Print reports The row restore utility will write a number of print reports to the SYSPRINT dataset during execution. These consist of: • Parameter specification and validation report. This will contain a list of SYSIN parameters specified (or defaulted) for execution of the utility, and a validatio[...]

DB2 Manager User Guide 99 StorageTek Proprietary the failed execution. No special actions need to be taken prior to re-starting the failed row restore job. Clean-up processing Following successful execution of the row restore utility, the storage used in the Archive Manager database for rows which have been restored to DB2 will no longer be accessi[...]

100 DB2 Manager User Guide StorageTek Proprietary expiration of this time interval. Refer to the Lifecycle Director Archive Manager User Guide for information about setting pre-fetch retention periods in a database, and about executing the object management utility. Functions The DB2 Manager pre-fetch utility performs the following functions: • I[...]

DB2 Manager User Guide 101 StorageTek Proprietary STEPLIB : Enter the names of the DB2 Manager and Archive Manager product load libraries. OTASxxxx : Enter the name of the primary index dataset of the Archive Manager database used for storage of objects from the DB2 table being processed by the utility. ‘xxxx’ should be set to the 4-character v[...]

102 DB2 Manager User Guide StorageTek Proprietary This mandatory parameter is used to specify the subsystem identifier of the DB2 subsystem to be used during execution of the utility. The subsystem identifier ‘xxxx’ can be 1-4 characters in length. • PLAN=xxxxxxxx This is an optional parameter which is used to specify the DB2 plan name to be [...]

DB2 Manager User Guide 103 StorageTek Proprietary Contents of character positions 72-80 in each record will be ignored. A maximum of 15 records may be present in the SQLIN file. Pre-fetch rules are specified in the format of a standard DB2-compatible SQL SELECT command, which must have the general format: SELECT key1, key2, .... keyn FROM table_nam[...]

104 DB2 Manager User Guide StorageTek Proprietary o Primary key and archive date of the object containing the row to be pre-fetched o Return and supplementary codes received from Archive Manager after processing the request o The concatenated key of the DB2 row to be pre-fetched Note that there may be multiple entries in this report for the same Ar[...]

DB2 Manager User Guide 105 StorageTek Proprietary After correcting the error, the utility may be rerun normally. No special actions need to be taken prior to re-starting the failed pre-fetch job. Archive Manager housekeeping processing Pre-fetched objects will be retained on disk in the Archive Manager database for the period of time specified in t[...]

106 DB2 Manager User Guide StorageTek Proprietary //* //STEPLIB DD DSN=Database.Manager.load.library,DISP=SHR // DD DSN=Archive.Manager.load.library,DISP=SHR //* //OTASxxxx DD DSN=Archive.Manager.index.dataset,DISP=SHR //SYSIN DD DSN=Execution.parameter.file,DISP=SHR //SQLIN DD DSN=Table.identification.file,DISP=SHR //SYSPRINT DD SYSOUT=* //* DD en[...]

DB2 Manager User Guide 107 StorageTek Proprietary to character position 71 of the record. Individual keyword parameters may not be continued over more than one record. An asterisk ('*') in character position 1 will indicate a comment record, which will be ignored for parameter validation processing. The following parameters may be specifi[...]

108 DB2 Manager User Guide StorageTek Proprietary received by the utility, which will cause it to terminate with a condition code of 12. In these circumstances, the SQL statement should be corrected and the job restarted. Print reports The table analysis utility will write a number of print reports to the SYSPRINT dataset during execution. These co[...]

DB2 Manager User Guide 109 StorageTek Proprietary Figure 5: Detailed table analysis report Condition codes The table analysis utility will set a condition code on completion. This code may take the following values: 0 - the utility has been executed successfully. 4 - a warning condition has been encountered during processing of the utility. A warni[...]

110 DB2 Manager User Guide StorageTek Proprietary migrated rows in the DB2 table will be resolved by the utility. This is required to ensure that re-organization of non-archive partitions can occur without reference to migrated rows in the Archive Manager database. The table to be processed is identified by the customer via an SQL command. Executio[...]

DB2 Manager User Guide 111 StorageTek Proprietary DD entries should be specified as follows: STEPLIB : Enter the names of the DB2 Manager and Archive Manager product load libraries. OTASxxxx : Enter the name of the primary index dataset of the Archive Manager database used for storage of objects from the DB2 table being processed by the utility. ?[...]

112 DB2 Manager User Guide StorageTek Proprietary This mandatory parameter is used to specify the subsystem identifier of the DB2 subsystem to be used during execution of the utility. The subsystem identifier ‘xxxx’ can be 1-4 characters in length. • PLAN=xxxxxxxx This is an optional parameter which is used to specify the DB2 plan name to be [...]

DB2 Manager User Guide 113 StorageTek Proprietary • Parameter specification and validation report. This will contain a list of execution parameters specified (or defaulted) in file SYSIN, and a validation error report if errors are detected in parameter specification. It will also specify the table identification statement coded in the SQLIN file[...]

114 DB2 Manager User Guide StorageTek Proprietary 4 - a warning condition has been encountered during processing of the utility. A warning message will have been written to the SYSPRINT dataset. The utility has been executed successfully. 8 - an error condition has been encountered during processing of the utility. An error message will have been w[...]

DB2 Manager User Guide 115 StorageTek Proprietary utility should not be permitted, by letting the data retention period default to zero values when defining the Archive Manager database. Refer to “Define Archive Manager databases” on page 27 for information on this issue. The database maintenance procedure should be performed at regular interva[...]

116 DB2 Manager User Guide StorageTek Proprietary 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 concurr[...]

DB2 Manager User Guide 117 StorageTek Proprietary This page is intentionally left blank[...]

118 DB2 Manager User Guide StorageTek Proprietary Messages and Codes DB2 Manager components communicate with the user through informational, warning and error messages. All DB2 Manager messages begin with the characters 'OTD', followed by a 5-character numeric identifier. DB2 Manager messages may be displayed on the system log or in an DB[...]

DB2 Manager User Guide 119 StorageTek Proprietary OTD10001 OPEN failed for xxxxxxxx dataset Explanation: An attempt to open a non-VSAM dataset has failed. ‘xxxxxxxx’ identifies the filename assigned by the program to the dataset. Execution of the utility will be terminated with condition code 12. Action: Consult other available system messages [...]

120 DB2 Manager User Guide StorageTek Proprietary OTD10006 DB2 CAF error occurred during CONNECT |OPEN |CLOSE | DISCONNECT processing. Return Code = xxx, Reason Code = X'yyyyyyyy’ Explanation: A DB2 Call Attachment Facility error has occurred attempting to perform the type of processing identified in the message. ‘xxx’ gives the return c[...]

DB2 Manager User Guide 121 StorageTek Proprietary Explanation: The column name identified in the message has been specified as a key field in the SQLIN file, but the column does not exist in the DB2 table. Execution of the utility is terminated with condition code 12. Action: Check that the names of the columns which uniquely index each row in the [...]

122 DB2 Manager User Guide StorageTek Proprietary OTD10013 Return code ‘xx’ received during execution of TCBTOKEN | LOCASCB | ENQ macro. Explanation: An error has been received attempting to execute the system macro identified in the message. ‘xx’ is the return code received from the macro call. Execution of the utility is terminated with c[...]

DB2 Manager User Guide 123 StorageTek Proprietary Explanation: The utility has been unable to obtain an DB2 Manager control region request element from ECSA storage, in order to pass a request to the control region. Execution of the utility is terminated with condition code 12. Action: This can occur if more than 1024 concurrent migrated row storag[...]

124 DB2 Manager User Guide StorageTek Proprietary reason for the error can be identified, contact your local STK support representative. OTD10021 Insufficient storage for w orkareas Explanation: An attempt by the utility to allocated virtual storage has failed Execution of the utility will be terminated with condition code 12. Action: Increase the [...]

DB2 Manager User Guide 125 StorageTek Proprietary  OTD120xx – row restore utility messages Messages from the DB2 Manager row restore utility will be written to the SYSPRINT dataset. OTD12000 Row Restore Utility ended with completion code xx Explanation: The DB2 Manager row restore utility has terminated. ‘xx’ gives the job completion code.[...]

126 DB2 Manager User Guide StorageTek Proprietary OTD12003 Key xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx was not found in DB2 table Explanation: The column name identified in the message has been specified as a key field in the SQLIN file, but the column does not exist in the DB2 table. Execution of the utility is terminated with condition code 12. Action: Ch[...]

DB2 Manager User Guide 127 StorageTek Proprietary macro call. Execution of the utility is terminated with condition code 12. Action: Consult IBM system macro documentation for a description of the error. Take the appropriate corrective action and re-submit the job. If no obvious cause for the error can be determined, contact your local STK support [...]

128 DB2 Manager User Guide StorageTek Proprietary Explanation: Identification of objects to be restored from Archive Manager to DB2 cannot be performed via index-only processing, and a SQLIN parameter of INDEXONLY=Y has been specified (or defaulted). Execution of the utility cannot continue, and is terminated with a condition code 12. Action: Refer[...]

DB2 Manager User Guide 129 StorageTek Proprietary and re-submit the job. If no obvious reason for the error can be identified, contact your local STK support representative.  OTD130xx – pre-fetch utility messages Messages from the DB2 Manager pre-fetch utility will be written to the SYSPRINT dataset. OTD13000 Batch Pre-fetch Utility ended with[...]

130 DB2 Manager User Guide StorageTek Proprietary OTD13003 Key xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx was not found in DB2 table Explanation: The column name identified in the message has been specified as a key field in the SQLIN file, but the column does not exist in the DB2 table. Execution of the utility is terminated with condition code 12. Action: Ch[...]

DB2 Manager User Guide 131 StorageTek Proprietary Explanation: An error has been received attempting to execute the system macro identified in the message. ‘xx’ is the return code received from the macro call. Execution of the utility is terminated with condition code 12. Action: Consult IBM system macro documentation for a description of the e[...]

132 DB2 Manager User Guide StorageTek Proprietary Explanation: Identification of objects to be pre-fetch by Archive Manager cannot be performed via index-only processing, and a SQLIN parameter of INDEXONLY=Y has been specified (or defaulted). Execution of the utility cannot continue, and is terminated with a condition code 12. Action: Refer to a de[...]

DB2 Manager User Guide 133 StorageTek Proprietary SYSPRINT dataset. The utility has been executed successfully. 8 - an error condition has been encountered during processing of the utility. An error message will have been written to the SYSPRINT dataset. Execution of the utility has continued. 12 - a serious error has been encountered during proces[...]

134 DB2 Manager User Guide StorageTek Proprietary Action: Refer to page 106 of this manual for a description of SYSIN parameter formats for the table analysis utility. Correct the parameter error and re-submit the job. OTD14005 Invalid or duplicate exec | SQLIN parameter. Please refer to the DB2 Manager User Manual for valid specifications Explanat[...]

DB2 Manager User Guide 135 StorageTek Proprietary OTD14008 Return code ‘xx’ received during execution of TCBTOKEN | ENQ macro Explanation: An error has been received attempting to execute the system macro identified in the message. ‘xx’ is the return code received from the macro call. Execution of the utility is terminated with condition co[...]

136 DB2 Manager User Guide StorageTek Proprietary Action: Check that the correct DB2 table name has been specified in the SQLIN file. If not, correct the entry and re-submit the job. OTD14012 All columns in the DB2 table have been specified as KEY fields Explanation: There are no non-indexed columns in the table being analyzed. The utility requires[...]

DB2 Manager User Guide 137 StorageTek Proprietary  OTD170xx – database housekeeping utility messages Messages from the DB2 Manager database housekeeping utility will be written to the SYSPRINT. OTD17000 Database Housekeeping Utility ended with completion code xx Explanation: The DB2 Manager database housekeeping utility has terminated. ‘xx?[...]

138 DB2 Manager User Guide StorageTek Proprietary OTD17003 Key xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx was not found in DB2 table Explanation: The column name identified in the message has been specified as a key field in the SQLIN file, but the column does not exist in the DB2 table. Execution of the utility is terminated with condition code 12. Action: Ch[...]

DB2 Manager User Guide 139 StorageTek Proprietary Explanation: An error has been received attempting to execute the system macro identified in the message. ‘xx’ is the return code received from the macro call. Execution of the utility is terminated with condition code 12. Action: Consult IBM system macro documentation for a description of the e[...]

140 DB2 Manager User Guide StorageTek Proprietary OTD17013 Retrieval using the specified KEY fields cannot be made via INDEXONLY processing Explanation: Scanning of the table using the key fields specified in the SELECT statement in the SQLIN file cannot be performed via index-only processing. Execution of the utility cannot continue, and is termin[...]

DB2 Manager User Guide 141 StorageTek Proprietary Action: Examine other system messages for more information on the open error. Take the appropriate corrective action and restart the control region. OTD20002 Error X'xxxx' locating member ENVCNTL | TAPECNTL on SYSPARM Explanation: Hexadecimal error code 'xxxx' has been received a[...]

142 DB2 Manager User Guide StorageTek Proprietary OTD20007 ENVCNTL | TAPECNTL parameters successfully processed Explanation: Validation of parameters in the ENVCNTL or TAPECNTL member of the DB2 Manager parameter library has completed successfully. Control region initialization processing continues. Action: None. This is an informational message. O[...]

DB2 Manager User Guide 143 StorageTek Proprietary If no other abnormal message is present, or the cause of the error is not apparent from any displayed message, contact your DB2 Manager product support representative. OTD20012 Return code X'xx' retrieving | creating | deleting Name/Token pair Explanation: An error has occurred retrieving,[...]

144 DB2 Manager User Guide StorageTek Proprietary Explanation: All sub-tasks of the type identified in the message have been successfully initialized during start-up of the DB2 Manager control region. ‘nnn’ gives the number of sub-tasks initialized. Action: None. This is an informational message. OTD20016 OTDBP300 is not in Link Pack Area Expla[...]

DB2 Manager User Guide 145 StorageTek Proprietary OTD20019 Error locating DB2 Manager ASCB | Jobname Explanation: An error has been detected attempting to locate the ASCB for the DB2 Manager control region, or retrieving the started task name assigned to the control region. Action: This indicates an internal error in DB2 Manager processing. Report [...]

146 DB2 Manager User Guide StorageTek Proprietary Action: A system abend has been trapped during processing of an operator request. If possible, DB2 Manager will recover from the abend. Operator requests may continue to be entered as normal. If it is not possible for DB2 Manager to recover from the abend, control region processing will be terminate[...]

DB2 Manager User Guide 147 StorageTek Proprietary Explanation: ‘COMMAND=MODIFY’ is set in the Archive Manager/OAM TAPECNTL parameter library member, but an MVS command other than ‘MODIFY’ has been issued to the DB2 Manager control region. Action: Re-enter the DB2 Manager command using the standard MVS MODIFY command structure. Refer to “D[...]

148 DB2 Manager User Guide StorageTek Proprietary Explanation: An invalid operator command has been entered in response to the DB2 Manager OTD20000 message or via MODIFY command. Action: Re-enter the correct operator command in response to the OTD20000 message or via MODIFY command. OTD20051 Invalid Set operand(s) - request ignored Explanation: An [...]

DB2 Manager User Guide 149 StorageTek Proprietary OTD20055 Missing/invalid operand - request rejected Explanation: A mandatory operand is missing from an DB2 Manager operator command. Action: Re-enter the command with the correct syntax. Refer to “DB2 Manager operator interface” on page 50 for a description of operator command formats. OTD20056[...]

150 DB2 Manager User Guide StorageTek Proprietary OTD20060 Task tnnn has been shutdown successfully Explanation: A request to purge the identified sub-task has been completed successfully. ‘t’ identifies the sub-task type (‘D’ – disk reader; ‘H’ – housekeeping; ‘S’ – scheduler; ‘T’ – tape reader; ‘W’ – writer) and [...]

DB2 Manager User Guide 151 StorageTek Proprietary WAIT – the task is currently waiting for work WTSH – a shutdown request has been queued for the task BUSY – the task is currently processing requests BYSH – the task is currently processing requests, and will terminate when all requests have been processed TERM – the task has terminated ?[...]

152 DB2 Manager User Guide StorageTek Proprietary OTD20071 Invalid Purge operand(s) – request ignored Explanation: An invalid operand has been entered with the PURGE operator command. Action: Ensure that the PURGE command is specified correctly and re-enter the command. Refer to page 55 for details of the operator PURGE command. OTD20072 Task tnn[...]

DB2 Manager User Guide 153 StorageTek Proprietary OTD20083 Task tnnn has not been purged – request ignored Explanation: A FORCE request has been entered for task 'tnnn', where ‘t’ identifies the sub-task type (‘D’ – disk reader; ‘H’ – housekeeping; ‘S’ – scheduler; ‘T’ – tape reader; ‘W’ – writer) and ?[...]

154 DB2 Manager User Guide StorageTek Proprietary If no apparent cause of the error can be identified, contact your DB2 Manager product support representative. The ECSA storage used for the DB2 Manager communications table in this invocation of the control region will be unavailable for allocation until after the next IPL of the system. Approximate[...]

DB2 Manager User Guide 155 StorageTek Proprietary OTD22002 Scheduler initialization error: insufficient storage available for workareas Explanation: A request for virtual storage in the DB2 Manager control region has been rejected by the operating system. Control region initialization processing is aborted. Action: Allocate more virtual storage to [...]

156 DB2 Manager User Guide StorageTek Proprietary OTD22006 Scheduler terminating because of recursive abends T=Snnn Explanation: An abend condition has been detected by a scheduler task, when attempting to recover from an earlier abend condition. ‘nnn’ identifies the scheduler task receiving the error. The scheduler task will terminate automati[...]

DB2 Manager User Guide 157 StorageTek Proprietary Explanation: An error has been received by scheduler task ‘nnn’ opening or reading the primary index dataset of Archive Manager database ‘xxxx’. ‘aa’ and ‘bb’ give the hexadecimal return and reason codes from the VSAM request. The migrated row access request being processed by the ta[...]

158 DB2 Manager User Guide StorageTek Proprietary OTD25003 Unable to get exclusive access to ODRE resource Explanation: A tape reader task has been unable to gain exclusive access to the scheduler request queue within 1 minute. Processing of the request continues, but request queue integrity in the DB2 Manager control region may have been compromis[...]

DB2 Manager User Guide 159 StorageTek Proprietary Explanation: Tape reader task number ‘nnn’ has terminated processing in response to an operator command, or following an unrecoverable error condition. Action: None. This is an informational message. OTD25011 Return code xx Supp codes X' yyyy zzzz' received opening | reading | closing [...]

160 DB2 Manager User Guide StorageTek Proprietary Action: Refer to IBM documentation for an explanation of the system abend code displayed in the message. If no apparent cause for the problem can be identifier, report the error to your StorageTek customer support representative.  OTD254xx – control region disk reader messages Messages from DB2[...]

DB2 Manager User Guide 161 StorageTek Proprietary Explanation: A request by a disk reader task for virtual storage in the DB2 Manager control region has been rejected by the operating system. Disk reader task initialization processing is aborted. Action: Allocate more virtual storage to the control region, by increasing the value of the SIZE parame[...]

162 DB2 Manager User Guide StorageTek Proprietary Action: Refer to the Archive Manager User Manual for an explanation of the return and supplementary codes displayed in the message. Take the appropriate corrective action and re-submit the request. OTD25412 Unrecoverable error condition - disk reader task nnn terminating Explanation: An error condit[...]

DB2 Manager User Guide 163 StorageTek Proprietary Action: Examine the system log for other abnormal messages issued by the DB2 Manager control region. If there is no apparent reason for the failure, contact your local DB2 Manager product support representative. OTD26003 Unable to get exclusive access to ODRE resource Explanation: A tape writer task[...]

164 DB2 Manager User Guide StorageTek Proprietary OTD26007 Tape w tr task nnn abend Sxxx intercepted Explanation: A system abend has been intercepted during operation of tape writer task ‘nnn’. The system abend code is 'xxx'. Tape writer processing will continue. Action: A system abend has been trapped during processing of a migrated [...]

DB2 Manager User Guide 165 StorageTek Proprietary OTD26013 Error xx received w riting SMF record Explanation: An error has been detected by a tape writer task writing a record to the SMF dataset. ‘xx’ gives the return code received from the SMFWTM macro. Tape writer task processing will continue normally. Action: Refer to IBM documentation for [...]

166 DB2 Manager User Guide StorageTek Proprietary Explanation: A request by a housekeeping task for virtual storage in the DB2 Manager control region has been rejected by the operating system. Housekeeping task initialization processing is aborted. Action: Allocate more virtual storage to the control region, by increasing the value of the SIZE para[...]

DB2 Manager User Guide 167 StorageTek Proprietary communicated back to the calling program via generation of an SQL –652 error. The two bytes at character positions 6 and 7 in field SQLERRD in the SQL communication area (SQLCA) at the time of the error will contain a reason code giving additional information about the error condition. Messages gi[...]

168 DB2 Manager User Guide StorageTek Proprietary Reason code (hex) Explanation Action : Refer to IBM documentation on the LOCASCB macro for a description of the error. Take the appropriate corrective action before continuing with DB2 Manager processing. 0A00 A request has been unable to obtain exclusive access to the DB2 Manager control region sch[...]

DB2 Manager User Guide 169 StorageTek Proprietary Reason code (hex) Explanation processing. Stop and restart the control region to try to clear the error condition. If this does not work, report the problem to your local DB2 Manager support representative. 10xx An error condition has been received by the DB2 Manager control region during processing[...]

170 DB2 Manager User Guide StorageTek Proprietary Return code (hex value in brackets) Explanation 21 ( 15 ) No free tape reader task available to perform migrated row retrieval request, or task processing tape volume containing migrated row is currently at its maximum request level (as set by the MAXQLEN initialization parameter). If a non-zero val[...]

DB2 Manager User Guide 171 StorageTek Proprietary Return code (hex value in brackets) Explanation xx Any other return code issued by the control region indicates that an error has been received from an Archive Manager call. A message will be issued by the control region giving details of the call and the return and reason codes received from Archiv[...]

172 DB2 Manager User Guide StorageTek Proprietary Appendices Appendix A: Sample JCL members Appendix A gives listings of members on the distributed DB2 Manager sample JCL library. LCDDB2 Member LCDDB2 is a sample procedure for execution of the DB2 Manager control region started task. //* //* Lifecycle Director //* DB2 Manager started task procedure[...]

DB2 Manager User Guide 173 StorageTek Proprietary OTDBDEF Member OTDBDEF creates the DB2 Manager system database. //OTDBDEF JOB //* //* DB2 Manager system database creation job. //* //* Change history: //* GW 19-Mar-03 V1.1 created //* GW 02-Apr-04 V1.1 re-branded //* //* This job creates the database manager system database. It //* includes steps [...]

174 DB2 Manager User Guide StorageTek Proprietary CYLINDERS(1 1) - UNIQUE ) - DATA - (NAME(DSN610.DSNDBD.LCDDB2.REGIX1.I0001.A001)) <=== DEFINE CLUSTER - (NAME(DSN610.DSNDBC.LCDDB2.REGIX2.I0001.A001) - <=== LINEAR - SHAREOPTIONS(3 3) - VOLUMES(vvvvvv) - <=== CYLINDERS(1 1) - UNIQUE ) - DATA - (NAME(DSN610.DSNDBD.LCDDB2.REGIX2.I0001.A001)) [...]

DB2 Manager User Guide 175 StorageTek Proprietary MIXOPSEQ SMALLINT NOT NULL WITH DEFAULT, VERSION VARCHAR(64) NOT NULL WITH DEFAULT, COLLID CHAR(18) NOT NULL WITH DEFAULT, ACCESS_DEGREE SMALLINT, ACCESS_PGROUP_ID SMALLINT, JOIN_DEGREE SMALLINT, JOIN_PGROUP_ID SMALLINT, SORTC_PGROUP_ID SMALLINT, SORTN_PGROUP_ID SMALLINT, PARALLELISM_MODE CHAR(1), M[...]

176 DB2 Manager User Guide StorageTek Proprietary OTDBPKG Member OTDBPKG creates the DB2 Manager DB2 application packages. //OTDBPKG JOB //* //* DB2 Manager DB2 package creation job. //* //* 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 applicatio[...]

DB2 Manager User Guide 177 StorageTek Proprietary 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) - SQL[...]

178 DB2 Manager User Guide StorageTek Proprietary //* //* 2. Change the name of the DB2 subsystem (DB2) in //* the DSN statements to match the subsystem name //* in use on the host system. //* //* 3. Replace the character string 'pppppppp' with //* the name of the DB2 plan to be generated. //* //* 4. Change the plan name in the RUN statem[...]

StorageTek Proprietary Index A Access Method Services, 31 allocation recovery, 74 AMS, 31 APF-authorization, 22, 46 archive date, 14 archive indicator, 10 Archive Manager, 7, 8, 13, 28 database, 13, 28, 46, 82 database administration, 28 database backup, 91 database definition, 118 database identifier, 14, 54, 55, 97, 103, 108, 113 database mainten[...]

F FLPA, 23 FORCE, 56 force purge, 56 H HLQ, 28 Host Software Component, 25, 72 housekeeping failure, 117 housekeeping processing, 13 HSC, 25 I IEF238D, 25, 74, 75 IEF247I, 25 image copy, 15 implementation, 14, 19 INDEXONLY, 98, 104 installation verification, 33 L large objects, 78 LCDDB2, 175 LCDDB2 database, 26 LCDDB2.PLAN_TABLE, 26 LCDDB2.REGISTR[...]

StorageTek Proprietary R reader task, 72 READTIMEOUT, 37, 53, 59, 60, 62, 63, 126, 171, 173 reason codes, 170 record offset, 14 recovery status, 93 recycle threshold, 118 re-migration selection criteria, 95, 99, 102 utility failure, 101 REPLY, 46, 51, 63 request queue, 41 request queue length, 53, 72 request status, 53 resource unavailable, 42, 56,[...]

tape volume recycling, 117 TAPECNTL, 22, 38 TAPEWAIT, 39, 41, 42, 43, 49, 53, 59, 60, 62, 71, 73, 74, 75, 173 timestamps, 66 TSO/ISPF, 28 U unique key, 78, 87, 99, 105, 110, 115 unit name, 30 updated row, 50 user identification, 22 user SVC, 28 utilities database housekeeping, 13, 95, 101, 112, 140 re-migration, 13, 95, 101, 128, 132 table analysis[...]

StorageTek Proprietary Reader’s Comment Form ∎ Contact Us Submit your questions, comments, and suggestions to StorageTek’s Global Learning Solutions. We appreciate your correspondence and are committed to responding to you. Publication Information Publication Name: Publication Part Number: Questions and Comments: Note: Staples can cause probl[...]

If you would like a reply, please print: Your Name:_____________________________________________________________________ Company Name:_____________________________Department:__________________________ Street Address:__________________________________________________________________ City:______________________________________________________________[...]

StorageTek Proprietary[...]

NEED MORE INFORMATION? www.storagetek.com ABOUT STORAGET EK Storage T echnology Corporation (NYSE: STK) is a $2 billion global company that en ables businesses, throug h its information life cycle management stra tegy , to align th e cost of s torage with the value of in formation. The compan y’ s innovative storage solutio ns manage the complexi[...]