Effects of the storage pool paging option on database recovery

 

The shared pool paging option controls whether the system dynamically adjusts the paging characteristics of the storage pool for optimum performance.

• The system does not dynamically adjust paging characteristics for a paging option of *FIXED.

• The system dynamically adjusts paging characteristics for a paging option of *CALC.

• You can also control the paging characteristics through an application programming interface. For more information, see Change Pool Tuning Information API (QWCCHGTN) in the Application programming interfaces (APIs) topic.

A shared pool paging option other than *FIXED can have an impact on data loss for nonjournaled physical files in a system failure. When you do not journal physical files, data loss from a system failure, where memory is not saved, can increase for *CALC or USRDFN paging options. You can write file changes to auxiliary storage less frequently for these options. There is a risk of data loss for nonjournaled files with the *FIXED option, but the risk can be higher for *CALC or user-defined (USRDFN) paging options. For more information about the paging option, see Automatically tune performance of the Performance topic.

 

Parent topic:

Database recovery process after an abnormal system end

 

Related concepts

Adjusting performance automatically
Application programming interfaces
Performance

 

Related reference

Change Pool Tuning Information (QWCCHGTN) API