Connect to the database
Connect to the database as the database creator.
Inorder to create a new connection, following are the steps.
- In connection manager, on right click New. It pops up a connection form.
- In the connection form page, enter
- database name: security
- hostname: IP address of your system.
- port number: port number where DB2 is listening. Use "get dbm cfg" and see the parameter value of SVCENAME to get the port number.
- user name: enter database creator name
- password: enter password for database creator.
- Click on connect button.
If the connection is already authenticated (check mark in the "Authenticated" column) but not active (no arrow in the "Active column"),
simply double click on the connection with database creator's userid to make it active.