Manuel d'utilisation / d'entretien du produit 312564001 du fabricant StorageTek
Aller à la page of 189
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.
DB2 Manager User Guide 1 StorageTek Proprietary T able of content s INTRODUCTION.................................................................................................................. 7 PRODUCT DESCRIPTION ..................................
2 DB2 Manager User Guide StorageTek Proprietary ENVCNTL: SMFRECID ................................................................................................ 35 ENVCNTL: OBJSIZE ....................................................................
DB2 Manager User Guide 3 StorageTek Proprietary Allocation recovery ........................................................................................................ 72 Shutdown processing .......................................................
4 DB2 Manager User Guide StorageTek Proprietary SQLIN entry specification ............................................................................................ 102 Print reports ..................................................................
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 .
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 .
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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 aut.
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 shou.
26 DB2 Manager User Guide StorageTek Proprietary Resource type Resource name Access required DATABASE LCDDB2 CREATETAB TABLESPACE LCDDB2.LCDDB2TS USE OF TABLE LCDDB2.
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.
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.
DB2 Manager User Guide 29 StorageTek Proprietary OTSN4301 Lifecycle Director Enter values Archive Manager V2.6 Storage Level Definition COMMAND ===> ------------------------------------------------------------------------------- Primary index name ===> OTDB.
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 ac.
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.
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.
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.
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.
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.
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’.
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.
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.
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.
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 min.
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.
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.
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.
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.
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.
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 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).
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.
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.
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.
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.
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'.
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.
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 Wr.
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.
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=W.
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, RETA.
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.
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.
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=T.
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 O.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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 requi.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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, .
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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 d.
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 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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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 req.
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.
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’ iden.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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).
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.
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.
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.
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.
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, ACC.
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.
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.
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.
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, 2.
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.
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 criter.
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 .
StorageTek Proprietary Reader’s Comment Form ∎ Contact Us Submit your questions, comments, and suggestions to StorageTek’s Global Learning Solutions.
If you would like a reply, please print: Your Name:_____________________________________________________________________ Company Name:_____________________________Department:__________________________.
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.
Un point important après l'achat de l'appareil (ou même avant l'achat) est de lire le manuel d'utilisation. Nous devons le faire pour quelques raisons simples:
Si vous n'avez pas encore acheté StorageTek 312564001 c'est un bon moment pour vous familiariser avec les données de base sur le produit. Consulter d'abord les pages initiales du manuel d'utilisation, que vous trouverez ci-dessus. Vous devriez y trouver les données techniques les plus importants du StorageTek 312564001 - de cette manière, vous pouvez vérifier si l'équipement répond à vos besoins. Explorant les pages suivantes du manuel d'utilisation StorageTek 312564001, vous apprendrez toutes les caractéristiques du produit et des informations sur son fonctionnement. Les informations sur le StorageTek 312564001 va certainement vous aider à prendre une décision concernant l'achat.
Dans une situation où vous avez déjà le StorageTek 312564001, mais vous avez pas encore lu le manuel d'utilisation, vous devez le faire pour les raisons décrites ci-dessus,. Vous saurez alors si vous avez correctement utilisé les fonctions disponibles, et si vous avez commis des erreurs qui peuvent réduire la durée de vie du StorageTek 312564001.
Cependant, l'un des rôles les plus importants pour l'utilisateur joués par les manuels d'utilisateur est d'aider à résoudre les problèmes concernant le StorageTek 312564001. Presque toujours, vous y trouverez Troubleshooting, soit les pannes et les défaillances les plus fréquentes de l'apparei StorageTek 312564001 ainsi que les instructions sur la façon de les résoudre. Même si vous ne parvenez pas à résoudre le problème, le manuel d‘utilisation va vous montrer le chemin d'une nouvelle procédure – le contact avec le centre de service à la clientèle ou le service le plus proche.
