SHRLEVEL
SHRLEVEL REFERENCE
SHRLEVEL REFERENCE is the default and allows read-only access by other programs to the target space during the rebuild process.
SHRLEVEL CHANGE
SHRLEVEL CHANGE allows read-write application access to Db2 table space and index space objects during the rebuild process.
Performing an online rebuild index by specifying SHRLEVEL CHANGE offers the following benefits:
Allows full access to Db2 data during most of the rebuild
Delivers significantly improved data availability by greatly reducing the outage for the Db2 objects
Operates in a nondestructive manner, which allows you to make the objects available without having to recover in the event of a failure
Important
Online index rebuild is a feature of the Recovery Management for Db2 solution. Using the SHRLEVEL CHANGE option to perform an online index rebuild requires a valid Recovery Management for Db2 solution password.
| Option | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| MAXRO | MAXRO specifies the maximum length of time for the last iteration of log processing.
| ||||||||
| LONGLOG | LONGLOG specifies the action to take if BMC AMI Recover determines that a longlog condition exists. A longlog condition exists when BMC AMI Recover determines over a period of time that the Db2 subsystem is generating log records for the objects that you are rebuilding faster than BMC AMI Recover is applying the records. After detecting that a longlog condition exists, BMC AMI Recover sends an action write-to-operator (WTO) notification and continues to apply the log records until the delay interval specified on the DELAY option expires. If the longlog condition still exists, BMC AMI Recover takes the action that you specify with one of the following options.
| ||||||||
| DELAY | DELAY specifies the number of seconds that are to elapse from the time BMC AMI Recover detects a longlog condition until it performs the action specified by the LONGLOG option. If the longlog condition no longer exists at the end of the time period specified by DELAY, the timer is reset. When BMC AMI Recover detects the next longlog condition, it restarts the timer, using the original DELAY value. The value must be a positive integer (0 or greater). The default value is 1200. | ||||||||
| DRAIN_WAIT | DRAIN_WAIT specifies the number of seconds that REBUILD INDEX is to wait when draining the table space or index. The specified time is the aggregate time for objects that are to be checked. integer can be any integer from 0 to 1800. If you do not specify DRAIN_WAIT or if you specify a value of 0, BMC AMI Recover uses the value of the lock timeout subsystem parameter IRLMRWT. | ||||||||
| RETRY | RETRY specifies the maximum number of retries that REBUILD INDEX should attempt. integer can be any integer from 0 to 255. REBUILD INDEX uses 1 as the default if you do not specify a value. | ||||||||
| RETRY_DELAY | RETRY_DELAY specifies the minimum number of seconds between retries. integer can be any integer from 1 to 1800. If you do not specify RETRY_DELAY, REBUILD INDEX uses the DRAIN_WAIT value x RETRY value. |
Comments
Log in or register to comment.