Using BMC AMI Copy page-integrity features

For table space copies, 

BMC AMI Copy

 optionally ensures that the pages being copied have correct internal formats, are structurally undamaged, and can be used to recover your data if a recovery becomes necessary. The items checked depend on the option you select and the version of Db2 you are using.

Important

Page checking does not apply to the copy of index spaces. BMC AMI Copy will perform minimum checking similar to CHECKTSLEVEL 0.

The CHECKTSLEVEL option performs page integrity checks by identifying damaged pages during the copy process. You can then take action to repair table spaces or to recover from a prior copy. CHECKTSLEVEL also prevents undetected duplication of damaged table spaces in image copies. When a check fails, BMC AMI Copy issues a message identifying the affected page (or pages) and the nature of the integrity issue.

When you specify CHECKTSLEVEL in the COPY or COPY IMAGECOPY command of BMC AMI Copy, you can choose from three levels of page integrity checking: CHECKTSLEVEL 0, CHECKTSLEVEL 1, or CHECKTSLEVEL 2. If you specify none of these, BMC AMI Copy defaults to the value of the CHECKLVL installation option. The default for CHECKLVL is set to 0.

Additional information is available as follows:

CHECKTSLEVEL 0

CHECKTSLEVEL 0 performs standard minimal checking.

Specifically, BMC AMI Copy automatically checks the page number, the broken page indicator, the consistency of the header and trailer bytes, and the validity of the page log RBA or LRSN. 

CHECKTSLEVEL 1

CHECKTSLEVEL 1 performs intrapage checks, consistency and validity checks on both segmented and nonsegmented table space maps, and also checks data page structure.

These checks are additional to those performed by CHECKTSLEVEL 0. 

CHECKTSLEVEL 2

CHECKTSLEVEL 2 performs the same intrapage checks as those described for CHECKTSLEVEL 1.

It also performs interpage checks on pointer records and table segment chains and ensures the agreement of space map pages and the associated data pages. When checking catalog and directory table spaces, CHECKTSLEVEL 2 also checks hash chains and ring pointer chains.

Important

Specifying CHECKTSLEVEL 2 in any of the following cases results in BMC AMI Copy termination and a return code of 8:

  • Making SHRLEVEL CHANGE or SHRLEVEL ANY copies
  • Processing single data set copies of a multi-data-set, nonpartitioned table space
  • Making incremental copies using the FULL NO option (If an incremental image copy is produced as a result of using the FULL AUTO, CHANGELIMIT, or FULL AUTO FULLPCT option, CHECKTSLEVEL 2 is automatically adjusted to CHECKTSLEVEL 1.)

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*