Summary of the content on the page No. 1
PART NUMBER
VERSION NUMBER EDITION NUMBER
312564001 1
1.1
TM
LIFECYCLE DIRECTOR
DB2 MANAGER USER GUIDE
PRODUCT TYPE
SOFTWARE
Summary of the content on the page No. 2
Summary of the content on the page No. 3
Lifecycle Director™ DB2 Manager User Guide Version 1.1 EC 132056 Revision C
Summary of the content on the page No. 4
Information contained in this publication is subject to change without notice. We welcome your feedback. Please contact the Global Learning Solutions Feedback System at: GLSFS@Stortek.com or Global Learning Solutions Storage Technology Corporation One StorageTek Drive Louisville, CO 80028-3256 USA Please include the publication name, part number, and edition number in your correspondence if they are available. Export Destination Control Statement These commodities, technology or software were
Summary of the content on the page No. 5
Table of contents INTRODUCTION..................................................................................................................7 PRODUCT DESCRIPTION .................................................................................................8 INTRODUCTION .........................................................................................................8 PRODUCT FUNCTIONS .........................................................................................
Summary of the content on the page No. 6
ENVCNTL: SMFRECID ................................................................................................35 ENVCNTL: OBJSIZE.....................................................................................................36 ENVCNTL: READTIMEOUT ........................................................................................36 ENVCNTL: WRITETIMEOUT.......................................................................................37 TAPECNTL PARAMETERS .............
Summary of the content on the page No. 7
Allocation recovery........................................................................................................72 Shutdown processing .....................................................................................................73 'Resource unavailable' condition...................................................................................74 TABLE MIGRATION PROCESSING..............................................................................75 INTRODUCTION .....
Summary of the content on the page No. 8
SQLIN entry specification............................................................................................102 Print reports.................................................................................................................103 Condition codes ...........................................................................................................104 Utility failure and restart considerations ....................................................................104 A
Summary of the content on the page No. 9
OTD260XX – CONTROL REGION WRITER MESSAGES.............................................162 OTD270XX - CONTROL REGION HOUSEKEEPING TASK MESSAGES.........................165 DB2 MANAGER ERROR AND REASON CODES.........................................................166 CONTROL REGION RETURN CODES.........................................................................169 APPENDICES..............................................................................................................
Summary of the content on the page No. 10
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 database management software. For ease of reference, the product will be referred to as DB2 Manager throughout the remainder of this manual. In addition, the Archive Manager component of Lifecycle
Summary of the content on the page No. 11
Product Description 1 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 product, which primarily uses tape cartridge media for storage of archived objects. Archive Manager also optionally enables disk copies of objects in an Archive Manager database to be retained. The pro
Summary of the content on the page No. 12
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 generate one or more tape mounts in order to service the application program’s SQL request. Access to rows is not necessarily performed in the physical sequence in which migrated rows are stor
Summary of the content on the page No. 13
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 amount of DB2 housekeeping processing (in particular, image-copy and re-organization processing) required for the database containing the table(s) enabled for DB2 Manager migration processing.
Summary of the content on the page No. 14
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 migration of the row from DB2. The following factors will govern the length of time taken to access a migrated row stored in a tape-resident object in an Archive Manager database: - The t
Summary of the content on the page No. 15
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. The updated row will be stored back in a non-archive partition of the table - the corresponding 18-byte archive stub in the archive partition will be deleted allowing this space to be r
Summary of the content on the page No. 16
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 migrated. Customer-specified rules, using SQL command syntax, are used to select migrated rows for restore. • Table analysis utility. This will analyze a table which has been enabled for
Summary of the content on the page No. 17
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 Archive Manager object will have the same primary key identifier. DB2 Manager will increment the primary key by 1 when creating a new object. 3. Archive date. This is automatical
Summary of the content on the page No. 18
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 the way in which rows are referenced from a DB2 application program. Every possible means of accessing a migrated row via SQL commands is supported, including joins and unions. Mult
Summary of the content on the page No. 19
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 rows to be retrieved from Archive Manager. If Archive Manager objects are held on tape storage only, this is likely to generate a substantial amount of tape activity and could take an exc
Summary of the content on the page No. 20
This page is intentionally left blank DB2 Manager User Guide 17 StorageTek Proprietary
