- 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
This parameter identifies the Sync Point Manager (SPM) log file size in 4
KB 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 Installation and Configuration Supplement.
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.)