- 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
- Satellite Database Server with local 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, refer to the Installing and Configuring DB2 Clients.
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:
- Determine that there are no indoubt transactions by using the LIST DRDA
INDOUBT TRANSACTIONS command.
- If there are none, stop the database manager.
- Update the Database Manager Configuration with a new SPM log file
size.
- 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.)
- Start the database manager. (A new SPM log of the specified size is
created during the startup of the database manager.)