Connect to the database
Connect to the database as Joe.
Inorder to create a new connection for user Joe, 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 user name as Joe
- password: enter password for Joe.
- 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 Joe's userid to make it active.