Administering local and remote instances and databases with the DB2 administration tools (available on Linux and Windows)
You can administer local or remote servers using the DB2® administration tools. The DB2 administration tools are used through the Control Center to perform administration tasks such as configuring DB2 instances and databases, backing up and recovering data, scheduling jobs, and managing media, all from a graphical interface. Note: In previous releases, the DB2 Administration Tools, found as part of the Control Center, were supported on all platforms. As of Version 9, the DB2 Administration Tools are supported only on Windows® x86, Windows x64 (AMD64/EM64T), Linux™ on x86, and Linux on AMD64/EM64T. For all platforms, you can use the DB2 command line processor (CLP) to administer instances and databases.
In addition to performing local administration tasks, the Control Center has support for the following remote products:
- DB2 Universal Database (UDB) for OS/390® and z/OS® Version 7
- DB2 UDB for z/OS Version 8
The remainder of this topic will refer collectively to these products as DB2 for z/OS, unless the content is version specific.
If you want to access DB2 for z/OS functions from the Control Center:
- Verify that:
- You have a DB2 for z/OS license
- You have a DB2 Connect™ product installed on the client workstation
- Distributed Data Facility (DDF) is started at the host
- The DB2 subsystem is cataloged on the client
- The DB2 Connect utilities and the DB2 CLI are bound to the host
- Apply the FMIDs for the DB2 Management Clients Package (a feature of DB2 for z/OS)
and DB2 Administration Server (DAS) for OS/390 and z/OS. DAS is an optional feature that is shipped with DB2 for OS/390 and z/OS server. Read the DB2 for z/OS, DB2 Management Clients Package, and DB2 Administration Server for OS/390 and z/OS program directories. The program directory identifies and describes the contents of FMIDs for each tape or cartridge. The program directory also provides the installation requirements and instructions.
- Apply any additional service to DB2 for z/OS as described in the program directories.
- The DB2 Control Center provides support to help you manage DB2 databases on multiple platforms. When managing DB2 for z/OS subsystems, you need to install a set of stored procedures, user defined functions, and batch programs for each DB2 subsystem:
- DB2 UDB for z/OS Version 8
- If you have DB2 UDB for z/OS Version 8 installed, you need to install the z/OS enablement feature (JDB881D).
- DB2 UDB for OS/390 and z/OS Version 7
- If you have DB2 UDB for OS/390 and z/OS Version 7 installed, you need to install the 390 enablement feature (JDB771D).
If you want to fully exploit all the DB2 Control Center functions for DB2 for z/OS, including Cloning and JCL building and creation, you need to install the DB2 Administration Server (DAS) for OS/390 and z/OS Version 8 (HDAS810) which ships as a feature of DB2 for z/OS.
Note:
- FMID JDB881D or JDB771D needs to be installed on every DB2 subsystem that you want to work with using the Control Center.
- FMID HDAS810 needs to be installed only once per image of the operating system or LPAR where you have DB2 subsystems that you want to work with using Control Center.
- Instructions for the various installations can be found in the Program Directory within the DB2 Management Clients Package of the appropriate product and version. For example, instructions for installing the DAS (HDAS810) are in the Program Directory for IBM® DB2 UDB for z/OS DB2 Management Clients Package Version 8.
- The DB2 Administration Server only needs to be installed once per system.
- Ensure that you enabled the stored procedures address space.
- Ensure that the DB2 Administration Server is started.
Detailed instructions for enabling the Control Center to work with DB2 for z/OS exists at:
Parent topic: DB2 Connect