Allocating Image Copy Data Sets
To archive, extract or compare data from Db2® image copy data sets in multiple partitions of the same tablespace stored on the same tape volume, you must manually edit the JCL to allocate the data sets. Multiple image copy data sets cataloged on the same tape volume can not be allocated using dynamic allocation. This is a z/OS limitation. If you attempt to use dynamic allocation, the archive, extract, or compare process fails with a dynamic allocation error.
For image copy data sets of one or more partitioned tablespaces
on the same tape, either:
- concatenate image copy data sets under one DD Name of your choice, or
- code individual DD Names for allocation of image copy data sets. Use a pattern, such as xxxxPPPP where xxxx is the DD Name prefix and PPPP is the maximum number of partitions in that tablespace. For example, if a tablespace contains 5 partitions, the DD Name would be IMGC0001, IMGC0002, and so on.
Example:
| Table | Partition | Tape Allocation Requirement |
|---|---|---|
| SALES | TAPEVL1 - LABEL(1,SL) | // T01$0001 DD DISP=OLD,DSN=(dsname) IC Dataset for SALES Table |
| CUSTOMER | PART1 TAPEVL1 - LABEL(2,SL) | // T02$0001 DD DISP=OLD,DSN=(dsname) IC Dataset for CUSTOMER Table Part #1 |
| CUSTOMER | PART2 TAPEVL1 - LABEL(3,SL) | // T02$0002 DD DISP=OLD,DSN=(dsname) IC Dataset for CUSTOMER Table Part #2 |
| CUSTOMER | PART3 TAPEVL1 - LABEL(4,SL) | // T02$0003 DD DISP=OLD,DSN=(dsname) IC Dataset for CUSTOMER Table Part #3 |
| CUSTOMER | PART4 TAPEVL1 - LABEL(5,SL) | // T02$0004 DD DISP=OLD,DSN=(dsname) IC Dataset for CUSTOMER Table Part #4 |
| CUSTOMER | PART5 TAPEVL1 - LABEL(6,SL) | // T02$0005 DD DISP=OLD,DSN=(dsname) IC Dataset for CUSTOMER Table Part #5 |
| ORDERS | TAPEVL1 - LABEL(7,SL) | // T03$0001 DD DISP=OLD,DSN=(dsname) IC Dataset for ORDERS Table |
| DETAILS | TAPEVL2 - LABEL(1,SL) | JCL allocation not required because it resides on a different tape |