PCLOSE—Pseudo close interval
Use the Modify Pseudo Close Interval panel or the PCLOSE command to specify the pseudo close interval. This interval determines when a table space is switched from an internal status of read-write to read-only. Pseudo close flushes the table space buffers, and writes a record to SYSLGRNG.
Modify Pseudo Close Interval panel
Command ===> _________________________________________________________________
Command: CURRENT
Description . . . . . . . . : PSEUDO CLOSE INTERVAL
Type the new pseudo close values that you wish to change to. Then press Enter.
Psuedo Close Parameters
Frequency . . . . . . . . . ______ (1 - 32767 or delta)
Time . . . . . . . . . . . . ______ (0 - 32767 or delta)
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). |
checkpointFreq* | Checkpoint frequency (the number of checkpoints that can be taken while there is no activity on a table before a pseudo close occurs). Specify one of the following values:
|
checkpointTime* | Checkpoint time (the number of minutes that must pass while no update activity occurs on a table before a pseudo close occurs). Specify one of the following values:
|
NORESET | The changes you request remain in effect until the Db2 subsystem is cycled. |
* Db2 uses either the checkpoint frequency or the checkpoint time to trigger pseudo close, whichever value reaches its threshold first. | |
Db2 parameter values
Field | Installation panel | CLIST parameter | ZPARM macro | ZPARM parameter |
|---|---|---|---|---|
Frequency | DSNTIPL | PCLOSEN | DSN6SYSP | PCLOSEN |
Time | DSNTIPL | PCLOSET | DSN6SYSP | PCLOSET |