This parameter identifies the sync point manager (SPM)
log file size in 4 KB pages.
- 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 - 1000]
- Unit of measure
- Pages (4 KB)
The log file is contained in the spmlog subdirectory under sqllib and is created the
first time SPM is started.
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 might 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.