What is DB2 Administration Solution Pack?

DB2® Administration Solution Pack is a set of functionally compatible components that help you to perform change management tasks, to work with DB2 tables and table spaces, to efficiently configure DB2 databases and clients, and to generally manage your DB2 for z/OS® environment.

IBM® DB2 Administration Tool for z/OS
DB2 Administration Tool helps you with the day-to-day tasks that are associated with managing DB2 environments efficiently and effectively. DB2 Administration Tool simplifies the complex tasks that are associated with safely managing DB2 objects and schema throughout the application lifecycle and does so with the least possible impact to availability. DB2 Administration Tool provides the following capabilities:
  • Navigate the DB2 catalog quickly and easily
  • Builds and runs dynamic SQL statements without requiring you to know the exact SQL syntax
  • Manages and tracks changes that are made to DB2 object definitions, resolving any potential conflicts before execution
  • Helps build DB2 commands to run against databases and tables
  • Builds and runs utility jobs, which allows you to take advantage of LISTDEFs and TEMPLATEs for increased productivity
  • Create, alter, migrate, drop, and reverse engineer DB2 objects
  • Manage accelerator objects
IBM DB2 Object Comparison Tool for z/OS
DB2 Object Comparison Tool enables you to identify the structural differences that exist between two DB2 catalogs, DDL, or version files. Identifying these differences is key for effective change management. DB2 Object Comparison Tool also generates the jobs that are required to apply the changes to align the catalogs.
Because DB2 Object Comparison Tool simplifies the process of synchronizing source and target objects, you can more easily keep your production database in step with your test and development databases. DB2 Object Comparison Tool also enables you to do the following tasks:
  • Build a compare operation by using the walk-through option, which provides an end-to-end framework for specifying job options.
  • Generate target changes to a work statement list (WSL) for propagation to remote sites.
  • Report differences by using various reports.
  • Account for intentional differences and naming discrepancies between two sets of objects.

Start of changeAdditionally, RESTful APIs have been instrumented in DB2 Administration Tool and DB2 Object Comparison Tool to facilitate the implementation of an automated process for rapid deployment of applications and database schema changes using DB2 for z/OS.End of change

IBM DB2 Table Editor for z/OS
DB2 Table Editor makes it easy to view and modify your DB2 tables. The primary function of DB2 Table Editor is to modify data that is stored in one of the DB2 family of databases. DB2 Table Editor consists of five different components that serve the following purposes.
  • The DB2 Table Editor Console allows you to configure your connection to DB2 and Informix® databases.
  • The DB2 Table Editor User allows you to edit DB2 tables by using custom forms. You create these forms by using DB2 Table Editor Developer or manually as needed.
  • The DB2 Table Editor Developer allows you to create custom forms to be used to edit DB2 tables.
  • The DB2 Table Editor ISPF allows you to view and edit DB2 tables.
DB2 Table Editor can also be incorporated into the DB2 Control Center as an add-in so that you can start DB2 Table Editor directly from the table that you want to edit.
Start of changeIBM DB2 Cloning Tool for z/OSEnd of change
Start of changeDB2 Cloning Tool makes it easy to quickly clone a DB2 subsystem or a DB2 table space. You can also use DB2 Cloning Tool to clone non-DB2 volumes.
For DB2 subsystem cloning:
DB2 Cloning Tool uses IBM FlashCopy, STK SnapShot, or EMC TimeFinder/Clone Mainframe Snap Facility's volume level support, and uses any volume fast replication or onsite mirror tool. Cloned DB2 subsystems can be accessed from the same z/OS system.
For DB2 table space cloning:
DB2 Cloning Tool uses IBM FlashCopy, STK SnapShot, or EMC TimeFinder/Clone Mainframe Snap Facility's data set level support, and can use any data set copy, fast or slow. Cloned DB2 table spaces can be cloned within the same or different z/OS system.
End of change
IBM DB2 Configuration Manager for z/OS
DB2 Configuration Manager offers centralized management of database and client configurations. The solution is based on IBM DB2 technology and is designed to manage data more effectively and efficiently. Greater availability is delivered through DB2 enhancements such as online, automated database reorganization. In addition, the increased scalability and the ability of DB2 to use the latest in server technology helps deliver increased performance of backup and recovery processes. Database administrators can track configuration changes to the application’s data clients or servers that to help proactively identify the root cause of a sudden performance degradation or outage of a production application.
DB2 Configuration Manager provides the following capabilities:
  • Shows enterprise data assets by using information that is obtained from database application clients and scheduled server discovery tasks
  • Modifies properties of deployed database clients to improve database transaction performance and to enforce security and privacy controls between data clients and data
  • Enforces properties of deployed database clients so that they conform to the established policies of z/OS Workload Management Service Classes
  • Routes data clients within z/OS data sharing groups or across z/OS data servers so that performance and availability objectives are met and sustained
  • Allocates data clients among data servers to achieve optimal workload balancing in the database
Parent topic: DB2 Administration Solution Pack overview