New and changed functions

This topic summarizes the recent enhancements and changes in Db2® Cloning Tool.

2024-05-03

Description Related APARs
The ALTER-BUFFERPOOL keyword was added to the Db2 Cloning Tool Subsystem Cloning DB2UPDATE command to allow updating of the BUFFERPOOL attributes record in the BSDS. The topics DB2UPDATE, DB2UPDATE command syntax, and DB2UPDATE command and keyword definitions were updated and messages were added. UI90282
Application cloning supports cross-LPAR cloning using staging (interim) volumes when the source and the target LPAR do not have shared DASD. The topics Non-SMS managed volumes, Using job templates, Predefined processing variables, and Data set processing variables were updated. The INTERIM-HLQ and TARGET-COPY keywords were added to COPY command syntax and COPY command and keyword definitions, and the DIRECTION keyword was added to HLQDDDF command syntax and HLQDDDF command and keyword definitions. The cloning scenario Cross-LPAR application cloning using an interim set of volumes and messages were added. UI90282
The topic Re-creating existing target objects was clarified to remove storage groups from the list of objects that always have DDL created when EXPLODE-OBJECTS is set to Y. UI90387
The WLM-ENV-ROUTINES-DDL parameter was added to the Db2 Cloning Tool Subsystem Cloning DB2SQL command. The topics DB2SQL command syntax and DB2SQL command and keyword definitions were updated and messages were added and updated. UI91962
The CREATE-INDEX-DEFER PROCESS-DDL parameter was added to the Db2 Cloning Tool Table Space Cloning COPY command to create new indexes in the source job with the DEFER YES option. The topics Options for rebuilding indexes, COPY command syntax, COPY command and keyword definitions, and SET command and keyword definitions were updated and messages were added and updated. UI93095
The topic Db2 13 function level support was updated to add the toleration and support PTFs for Db2 13 function levels 503 and 504. UI80671, UI91221, UI96500
Support for a product-default encryption key was removed. The topics Deprecated and removed functions and parameters and CKZINI keyword syntax and descriptions were updated and messages were updated and removed. UI80370
The EATTR and MAXVOLS attributes were added to the CATWORK-ATTR keyword of the subsystem cloning COPY command. The topic COPY command and keyword definitions was updated. None
For the table space cloning COPY command, if the target data sets do not exist, the default class of the source data sets is used. Corrections were made to the DATACLAS, MGMTCLAS, and STORCLAS keywords for the DATA-MOVER(PGM) command in the topic COPY command and keyword definitions. None

2022-12-12

Description Related APARs
The topic Db2 13 function level support was updated to add the PTFs for Db2 function level 502. UI80671, UI83538

2022-11-21

Description Related APARs
The IGNORE-SQL-WARNINGS keyword allows you to specify the SQL warnings to be ignored when generated DDL statements are run. The subsystem cloning topics DB2SCHEMA-UPDATE command syntax and DB2SCHEMA-UPDATE command and keyword definitions, and the table space cloning topicsCOPY command syntax and COPY command and keyword definitions were updated. Messages CKZ28077E, CKZ53515E, and CKZ535116E were added. UI79745 (PH41578)
You can change data set allocations for temporary data sets used in table space cloning jobs with new TEMP-DATASET SET command keywords and PARMLIB parameters. The topics SET command syntax, SET command and keyword definitions, and CKZINI keyword syntax and descriptions were updated. Messages CKZ53208I and CKZ53209W were added. UI79745 (PH41578)
The MINILOG-HLQ-TARGET parameter was added to application cloning to allow different high-level qualifiers for minilog data sets on source and target LPARs during cross-LPAR target log apply processing. The topics COPY command syntax and COPY command and keyword definitions were updated and messages CKZ66987I, CKZ66988I, and CKZ66989I were added. UI78229
Db2 subsystem cloning provides a better diagnostic message when BACKINFO-REFORMAT cannot be used because cloning is being performed from a Db2 system level backup dump tape. Message CKZ06044E was added. UI78229 (PH41794)
Support for the IGNORE-SQL-WARNINGS keyword was added to the ISPF UI for subsystem and application cloning. Message CKZ109E was added. UI79979 (PH44525)
Use of an internal network encryption key was deprecated. Message CKZ53238I was added. For more information, refer to Deprecated and removed functions and parameters. UI80370
The DDL-REPORT keyword was added so that you can print an application cloning report listing the dropped and created objects processed by the DDL generator. Topics COPY command syntax and COPY command and keyword definitions were updated. Messages CKZ00096W, CKZ00099W, CKZ54129I, CKZ54130I, and CKZ54131W were added. UI82681
The CREATE-DEP-OBJECTS keyword was added to application cloning to control the types of non-data objects to be created by the DDL generator. Topics COPY command syntax and COPY command and keyword definitions were updated. Messages CKZ53510I and CKZ53511E were added. UI82681
For Db2 Cloning Tool Subsystem Cloning, the DB2CLEAR-INDOUBT command was added. This command automatically recovers all threads in an indoubt state by committing or aborting them and/or purging information that is displayed in an indoubt thread report. The following topics were added: The topics Db2 Cloning Tool Subsystem Cloning commands, Status of transactions in flight, and DB2START were modified and messages were added. UI82681

2022-06-01

Description Related APARs
Db2 Cloning Tool now supports Db2 13 for z/OS as a source or a target for subsystem and application cloning. For application cloning, a Db2 13 subsystem can be a target for a Db2 11, 12, or 13 source subsystem. Application cloning from a Db2 13 subsystem to Db2 11 or 12 subsystem is not supported. For subsystem cloning, both the source and target Db2 subsystems must be the same Db2 version. The topic Db2 13 function level support was added. The topics Set up your environment prior to customization and Worksheets: Gathering parameter values for Tools Customizer, and messages CKZ555E and CKZ25444I were updated. UI80671

2022-05-23

Description Related APARs
Db2 Cloning Tool Table Space Cloning can notify replication tools when replacing data of target objects that are used as sources for the replication tools. The following topics were added or updated, and messages were added: PH38763
The requirement for the MINI_LOG_V14 table for application cloning log apply processing was removed. The topics Worksheets: Gathering parameter values for Tools Customizer and Using LOG-APPLY to make consistent copies of table spaces and index spaces and message CKZ801E were updated. PH35778
The DEFINED keyword was added to the Db2 Cloning Tool Table Space Cloning LISTDEF command to control whether DEFINE NO source objects are included in the cloning. The topic Considerations for source objects created using DEFINE NO and messages were added, and the topics LISTDEF command syntax and LISTDEF command and keyword definitions were updated. PH32434
The TAPE-DSN keyword was added to the Db2 Cloning Tool Subsystem Cloning COPY-BY-DS command to allow you to specify processing for data sets that are on tape and are not excluded by the EXCLUDE-SRCNAME-MASKS keyword. The topics Planning for subsystem cloning by data set, COPY-BY-DS command syntax, and COPY-BY-DS command and keyword definitions were updated and messages were added. PH40818
Information was added to describe how index log apply can be used to process indexes during table space cloning. In addition, the default value of SKIP-SYSLGRNX is changed to Y when INDEX-LOG-APPLY is specified. The topics Using LOG-APPLY to make consistent copies of table spaces and index spaces and COPY command and keyword definitions were updated, and messages were added and updated. PH41401
The topic Db2 12 function level support was updated to add the PTFs for Db2 function level 510. UI75063, UI76016
Cloning scenarios for cloning using system-level backups or interim volumes were updated. The topics in Cloning scenarios were updated. None
Messages used for log apply processing were updated and renumbered. None

2021-11-04

Description Related APARs
Information was added to clarify which SMS classes are used to allocate target data sets for DATA-MOVER PGM SRCIMCPY. The topic Considerations for target objects created using DEFINE NO was updated. PH33515
If a table is slated for UNLOAD/LOAD processing, but the table is enabled for system-period data versioning, it is excluded from UNLOAD/LOAD processing. The topic How Db2 Cloning Tool Table Space Cloning checks object compatibility and message CKZ54305I were updated. PH35552

2021-07-22

Description Related APARs
Db2 Cloning Tool Table Space Cloning can now generate STOP and START commands for source and target objects for all DATA-MOVER types. The following topics were updated: PH32434
The LOAD-RI, LOAD-NOCHECKPEND, and TARGET-JOB-CHECK-DDN keywords were added to COPY command UNLOAD-LOAD processing to support using UNLOAD/LOAD for objects with RI. The topics How Db2 Cloning Tool Table Space Cloning checks object compatibility, Strategies for resolving object mismatches, COPY command syntax, COPY command and keyword definitions were updated. PH32434
The MATERIALIZE-DEFINE-NO-TARGET parameter was added to the Db2 Cloning Tool Table Space Cloning COPY command to allow automated cloning to target objects created using DEFINE NO. The topics Considerations for target objects created using DEFINE NO, COPY command syntax, and COPY command and keyword definitions were updated. PH32434
When using the Db2 Cloning Tool Subsystem Cloning COPY-BY-DS command, it is recommended to specify rename masks for VSAM data sets by using the cluster names. The topics RENAME considerations for COPY-BY-DS and COPY-BY-DS step JCL example were updated. PH30831
Db2 Cloning Tool application cloning can correctly stop and start objects in RREPL status. The topics How Db2 Cloning Tool Table Space Cloning starts and stops table spaces and index spaces, COPY command and keyword definitions, SET command and keyword definitions, and CKZINI keyword syntax and descriptions were changed and several messages updated. PH30831
When customizing Db2 Cloning Tool, the Db2 APPLCOMPAT bind option supports the value V12R1M508 for package binds in Db2 12 function level 508 subsystems. The topic Db2 12 function level support was updated. PH29209
Support was added for GDG extended data sets to subsystem cloning. The topic Target ICF catalog considerations was modified and messages were added or changed. PH29209
Support was added for PBR2 in log apply processing. The following topics were updated: PH29209
Index REBUILD processing was optimized for rebuilding large numbers of indexes when the amount of disk space for sort data sets is limited. The MAX-CLAUSES-PER-REBUILD parameter was added to the topics SET and SET command and keyword definitions. In addition, the topic Options for rebuilding indexes was updated and messages were added. PH29209
The REST API was updated for recent enhancements to and fixes for Db2 Cloning Tool. The topic Variable input file parameters was updated. PH29209
You can now use the Db2 Cloning Tool Subsystem Cloning COPY command with FASTREP(REQ) and active cascading FlashCopy relationships. Messages were added or modified to support this enhancement. PH29209
Re-creation of materialized query tables in a Db2 11 CM environment was clarified in Re-creating existing target objects and several messages were added or changed. PH27289
Authorization requirements for the Db2 command SET LOG command, which is used when log apply is enabled, were added to Function authorization requirements. PH27289

2020-08-11

Description Related APARs
Some parameters were removed from table space cloning and are no longer supported. See Deprecated and removed functions and parameters for a list of the parameters and descriptions of Db2 Cloning Tool behavior when the parameters are not removed from existing jobs. The following topics were updated: PH24502
When customizing Db2 Cloning Tool, the Db2 APPLCOMPAT bind option supports the value V12R1M507 for package binds in Db2 12 function level 507 subsystems. PH24502
Support was added in Db2 Cloning Tool Subsystem Cloning for Remote Pair FlashCopy for XRC. The following topics were updated and messages were added: PH24502
The RESET-LOGRBA keyword of the table space cloning COPY command has an additional parameter to allow Db2 Cloning Tool to control when the RBA is reset. The topics COPY command syntax, COPY command and keyword definitions, and CKZINI keyword syntax and descriptions were updated. PH24502
The NOT-DB2-SLB keyword was added to better handle subsystem cloning from a system-level backup when backup volumes do not contain SLBs. The topics DB2ALTERBSDS, DB2ALTERBSDS command syntax, and DB2ALTERBSDS command and keyword definitions were updated and messages were added. PH24502
The UNLOAD-LOAD-EARLY-VALIDATION parameter was added to the Db2 Cloning Tool Table Space Cloning COPY command to facilitate earlier validation of required templates and control statements in the UNLOAD-LOAD process. The topics COPY command syntax and COPY command and keyword definitions were updated and messages were added. PH24502
The TARGET-JOB-MAX-RC parameter was added to the Db2 Cloning Tool Table Space Cloning SET command to override the MAX-RC PARMLIB value when running the target job. The topics SET command syntax and SET command and keyword definitions were updated and message CKZ50017E was added. PH24502
In the classic ISPF interface, some table space cloning DD names were modified in Setting default DD specifications for table space cloning and Table space cloning DD descriptions. PH24502
Information on restricted support in log apply for PBR RPN table spaces was added to the topics Db2 12 function level support, Set up your environment prior to customization, Using image copies to clone table spaces and index spaces, Using LOG-APPLY to make consistent copies of table spaces and index spaces, and COPY command and keyword definitions. PH24502
The Db2 Cloning Tool Table Space Cloning option DATA-MOVER PGM(SRCVSCPY) has been deprecated. The topic Deprecated and removed functions and parameters was updated. None