IBM Db2 database setup checklist
Use this checklist to verify your IBM® DB2® setup before installing IBM Product Master.
You can also run the perl $TOP/bin/perllib/db_checklist.pl script to check the
Db2 parameters and configuration. Run the perl
$TOP/bin/perllib/db_checklist.pl script to verify that the Db2 settings are correctly set for Product Master.
| Setting | Description |
|---|---|
| Check the IBM Db2 server release |
The version of the Db2 server can be the version that is identified in the system requirements depending on your product version. |
| Check the database code set |
The character set and national character set should be UTF8. On the database server that is
logged in as instance owner:
This should have |
| Check the parameter file entries |
Follow the Db2 configuration sections provided to make sure that you have made required parameter changes for the Db2 registry variables, database manager, and the database. |
| Check the table spaces setup |
Make sure that the required table spaces are set up in the database. |
| Check the transaction logs setup |
Make sure that the transaction logs are created on a separate partition. |
| Check the database user setup |
View the database user name and password in the $TOP/bin/conf/env_settings.ini file and make sure that the database user is created and all required privileges are granted to the user. |
| Check the connectivity to the database server |
The database server and the database server node must be cataloged on the application server and the database must be accessible from the application server. Check the database connectivity with the following
script:
|