Setting up DB2®
About this task
To perform the database setup for DB2® complete the following steps. If you are using a Windows® operating system, begin from step 2. If you are using Linux® operating system or AIX® operating systems, begin from step 1:
Procedure
- To verify that DB2® and the instance are ready for remote connectivity
using TCP/IP complete the following steps:
The DB2® server is now ready for accessing over the network.
- Create the database that BigFix® Remote
Control will
use by running the following command as the instance owner:Note: Not necessary when the database is local.
db2 create db databasename using codeset UTF-8 territory requiredtrerritory
where databasename is the name required for the database. This database name must be the name that was referenced in any configuration settings. For example, TRCDB.
requiredtrerritory is the required territory. For example, GB for Great Britain.
- Verify the privileges that a specific user, for the database,
needs to have.Do not use the db2inst1 user as the user configured to access the BigFix® Remote Control database. Create a new specific user for DB2® that has the database owner privileges.
Results
With the blank database created and ready to use, the next step is to set up the WebSphere® server, see Setting up the application server. It is possible to verify that the database is set up properly by using a DB2® client to connect to the database from another host. For more details see the DB2® Infocenter.