CHKPTHLP

This command helps to flush the data in parallel to the CHECKPOINT command in ISQL.

Scope

SQLUtil Only

SQLUtil Syntax

>> CHKPTHLP DBEnvironment Name: DBEnvironmentName Maintenance Word: MaintenanceWord Enter the number of buffers to be skipped: NumberofBuffers Continue (y/n)?: Y[es] N[o]

Parameters

DBEnvironmentName: is the name of a DBEnvironment.
MaintenanceWord: is the maintenance word.
NumberofBuffers: is the number of buffers to be skipped. (Expected to be in the range of 100 to 400,000.)

Description

This can only be used in HP-UX and not in MPE.
Flushes the data in parallel to the CHECKPOINT statement given in ISQL session and should be given only after invoking CHECKPOINT in ISQL. It reduces the time needed by flushing the data in a parallel manner.
Can be called in many sessions of SQLUtil in parallel when the CHECKPOINT statement is used in another session of ISQL to reduce the time required to take checkpoints when there are large numbers of buffers to be flushed.
There is an option to skip the number of buffers.

Authorization

You must be the DBECreator, the superuser, or supply the correct maintenance word to use this command.

Example

   >> chkpthlp

   DBEnvironment Name: tst 

   Maintenance Word:  Return

   Enter the number of buffers to be skipped: 1000 

   Continue? (y/n)?: Y

   Chkpthlp successful 

   >>