Guides you through the process of using the Manage Connections HCOSS tool to create a connection to your DB2 database so you
can access its SYSIBM tables.
- From the HCO for SQL Server interface, click
Manage Connections. This takes you to the
Connection List tab.
- Click
New DB2 Connection. This takes you to the
DB2 Connection tab.
- In the
Data Source Name field, type
mainframeDB2 to provide a name for the connection.
- Provide values for all remaining fields on this tab. Valid entries for all fields are required to ensure a valid connection.
If you do not know the correct values required, contact your DB2 administrator.
- Click
Test.
A prompt appears showing the name of the schema that contains your mainframe system catalogs. By default, this is
SYSIBM. If the schema name provided is incorrect, type the name of the correct schema.
- Click
OK.
- If the test fails, review your field entries, make corrections accordingly, and try again. When you have a successful connection,
click
OK.
- Click
Save to create the connection. This takes you back to the
Connection List tab where you should now see your DB2 connection listed.