REFSHAGE—Default current refresh age
Use the Modify Default Current Refresh Age panel or the REFSHAGE command to specify the default value for the CURRENT REFRESH AGE special register if no value is explicitly set using the SQL statement SET CURRENT REFRESH AGE. If you accept the default value of 0, query rewrite using deferred materialized query tables is disabled. The special register CURRENT REFRESH AGE specifies the maximum refresh age that a materialized query table can have.
Modify Default Current Refresh Age panel
Command ===> _________________________________________________________________
Command: CURRENT
Description . . . . . . . . : DEFAULT CURRENT REFRESH AGE
Type the new Default Current Degree Special Register value to change to. Then press Enter.
Default Current Refresh Age Special Register Value Parameter
Refresh Age . . . . . . . . ANY (0 or ANY)
Command syntax and parameters
Value | Description |
|---|---|
DB2ssid | Db2 subsystem ID or the name of the Db2 data sharing group to which the command applies. |
opertuneID | OPERTUNE system profile name (if OPERTUNE is running as a started task) or the batch job name (if OPERTUNE is running as a batch job). |
0 | Whether Db2 will consider materialized query tables in automatic query rewrite. Specify one of the following values:
|
NORESET | The changes you request remain in effect until the Db2 subsystem is cycled. |
Db2 parameter values
Field | Installation panel | CLIST parameter | ZPARM macro | ZPARM parameter |
|---|---|---|---|---|
Current refresh age | DSNTIP8 | None | DSN6SPRM | REFSHAGE |