Release Notes

22.8 Control Center for DB2 for OS/390

The DB2 UDB Control Center for OS/390 allows you to manage the use of your licensed IBM DB2 utilities. Utility functions that are elements of separately orderable features of DB2 UDB for OS/390 must be licensed and installed in your environment before being managed by the DB2 Control Center.

The "CC390" database, defined with the Control Center when you configure a DB2 for OS/390 subsystem, is used for internal support of the Control Center. Do not modify this database.

Although DB2 for OS/390 Version 7.1 is not mentioned specifically in the Control Center table of contents, or the Information Center Task information, the documentation does support the DB2 for OS/390 Version 7.1 functions. Many of the DB2 for OS/390 Version 6-specific functions also relate to DB2 for OS/390 Version 7.1, and some functions that are DB2 for OS/390 Version 7.1-specific in the table of contents have no version designation. If you have configured a DB2 for OS/390 Version 7.1 subsystem on your Control Center, you have access to all the documentation for that version.

To access and use the Generate DDL function from the Control Center for DB2 for OS/390, you must have the Generate DDL function installed:

• For Version 5, install DB2Admin 2.0 with DB2 for OS/390 Version 5.
• For Version 6, install the small programming enhancement that will be available as a PTF for the DB2 Admin feature of DB2 for OS/390 Version 6.
• For Version 7.1, the Generate DDL function is part of the separately priced DB2 Admin feature of DB2 for OS/390 Version 7.1.

You can access Stored Procedure Builder from the Control Center, but you must have already installed it by the time you start the DB2 UDB Control Center. It is part of the DB2 Application Development Client.

To catalog a DB2 for OS/390 subsystem directly on the workstation, select to use the Client Configuration Assistant tool.

1. On the Source page, specify the Manually configure a connection to a database radio button.
2. On the Protocol page, complete the appropriate communications information.
3. On the Database page, specify the subsystem name in the Database name field.
4. On the Node Options page, select the Configure node options (Optional) check box.
5. Select MVS/ESA, OS/390 from the list in the Operating system field.
6. Click Finish to complete the configuration.

To catalog a DB2 for OS/390 subsystem via a gateway machine, follow steps 1-6 above on the gateway machine, and then:

1. On the client machine, start the Control Center.
2. Right click on the Systems folder and select Add.
3. In the Add System dialog, type the gateway machine name in the System name field.
4. Type DB2DAS00 in the Remote instance field.
5. For the TCP/IP protocol, in the Protocol parameters, specify the gateway machine's host name in the Host name field.
6. Type 523 in the Service name field.
7. Click OK to add the system. You should now see the gateway machine added under the Systems folder.
8. Expand the gateway machine name.
9. Right click on the Instances folder and select Add.
10. In the Add Instance dialog, click Refresh to list the instances available on the gateway machine. If the gateway machine is a Windows NT system, the DB2 for OS/390 subsystem was probably cataloged under the instance DB2.
11. Select the instance. The protocol parameters are filled in automatically for this instance.
12. Click OK to add the instance.
13. Open the Instances folder to see the instance you just added.
14. Expand the instance.
15. Right click on the Databases folder and select Add.
16. Click Refresh to display the local databases on the gateway machine. If you are adding a DB2 subsystem in the Add Database dialog, type the subsystem name in the Database name field. Option: Type a local alias name for the subsystem (or the database).
17. Click OK.

You have now successfully added the subsystem in the Control Center. When you open the database, you should see the DB2 for OS/390 subsystem displayed.

The first paragraph in the section "Control Center 390" states:

The DB2 UDB Control Center for OS/390 allows you to manage the use of your licensed IBM DB2 utilities. Utility functions that are elements of separately orderable features of DB2 UDB for OS/390 must be licensed and installed in your environment before being managed by the DB2 Control Center.

This section should now read:

The DB2 Control Center for OS/390 allows you to manage the use of your licensed IBM DB2 utilities. Utility functions that are elements of separately orderable products must be licensed and installed in your environment in order to be managed by DB2 Control Center.