SHRLEVEL REFERENCE method
With the High-speed Structure Change SHRLEVEL REFERENCE method, other applications are allowed to have read-only access while the transformation is done.
To convert objects by using the SHRLEVEL REFERENCE method, follow the steps in the order shown in the following table.
To perform this step | Use this BMC solution component | Reference |
|---|---|---|
Create a target set of objects, using the source objects as a template. | BMC Database Administration for DB2 (BMC AMI Change Manager for Db2 component) | |
Issue a Db2 command to start the source table space with read-only status. | None | |
Create a consistent copy of the Db2 table spaces and indexes. | BMC Recovery Management for Db2 (Online Consistent Copy or Instant Snapshot with SHRLEVEL REFERENCE) | |
Create and run a job that transforms the table spaces and indexes. | BMC Recovery Management for Db2 ( component) | |
Perform RUNSTATS. | None | |
Issue a Db2 command to stop the table space. | None | |
Rename the objects. Re-create alias and view triggers. | BMC Database Administration for DB2(BMC AMI Change Manager for Db2 component) | |
Start the database in read-write status. | None | |
Run binds. | None | |
Modify the batch jobs that reference the source table spaces. | None |
The following figure provides a hypothetical timeline using the steps in the Steps for using the SHRLEVEL REFERENCE method table.
