Improving batch processing performance in data sharing

You might improve the performance of large batch processes in a data sharing environment by removing group buffer pool dependency for a table space, index space, or partition.

Procedure

To remove group buffer pool dependency to improve batch process performance:

On the same member that runs the batch process, issue an ACCESS DATABASE command for a table space, index space, or partition, and specify the MODE(NGBPDEP) keyword.

Db2 attempts to remove group buffer pool dependency for the specified page set or partition. This operation drains the page set or partition. End of change

Example

The following command physically closes the entire non-partitioned table space DSN9003 of database DSN9001 and removes group buffer pool dependency.

-ACCESS DATABASE(DSN9001) SPACENAM(DSN9003) MODE(NGBPDEP)

Output similar to the following output indicates that the command completed successfully:

  -DSNTDDIS 'ACCESS DATABASE' NORMAL COMPLETION