Sync Point Manager Log File Size (spm_log_file_sz)

Configuration Type

Database manager

Applies to

• Database Server with local and remote clients
• Database Server with local clients
• Partitioned Database Server with local and remote clients

Parameter Type

Configurable

Default [Range]

256 [ 4 - 1 000 ]

Unit of Measure

Pages (4KB)

This parameter identifies the Sync Point Manager (SPM) log file size in 4K pages. The log file is contained in the spmlog sub-directory under sqllib and is created the first time SPM is started.

For more information on the Sync Point Manager, see the appendix on "LU 6.2 Sync Point Manager Considerations" in the Quick Beginnings or the DB2 Connect Enterprise Edition Quick Beginnings appropriate to your operating system environment.

Recommendation: The Sync Point Manager log file size should be large enough to maintain performance, but small enough to prevent wasted space. The size required depends on the number of transactions using protected conversations, and how often COMMIT or ROLLBACK is issued.

To change the size of the SPM log file:

1. Determine that there are no indoubt transactions by using the LIST DRDA INDOUBT TRANSACTIONS command.
2. If there are none, stop the database manager.
3. Update the Database Manager Configuration with a new SPM log file size.
4. Go to the $HOME/sqllib directory and issue rm -fr spmlog to delete the current SPM log. (Note: This shows the AIX command. Other systems may require a different remove or delete command.)
5. Start the database manager. (A new SPM log of the specified size is created during the startup of the database manager.)

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]