IBM United States
Software Announcement 200-451
December 19, 2000

More Database Tools for DB Administration

 ENUS200-451.PDF (36KB)


At a Glance

High Performance System Generation Tools

  • Perform IMS sysgens for application resource changes (transactions, programs, databases, and route codes) in a single job step — or online
  • Reduce IMS sysgen CPU time dramatically
  • Maintain/create IMS-plex sysgen configurations

Command Control Facility

  • Issue commands for DB/CTL, DC/CTL, or DB/DC regions
  • Execute IMS commands from a batch utility or from a TSO session via an ISPF interface
  • Ensure successful processing of database START, STOP, DBR, and DBD commands
  • Process IMS commands across all regions in a sysplex using the batch command processor
  • Synchronize Online Change and database commands across all regions in a sysplex using the batch command processor

MFS Reversal Utilities

  • Decode MFS MID/MOD/DIF/DOF control blocks back into MFS utility control statements
  • Compare MFS source libraries

These tools include a wealth of features and functions at a modest price. They can help you better manage your database environment and can help improve overall performance.

For ordering, contact:

Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: LE001).

Overview

IBM's Database Administration Tools address the most common tasks required to service and support database operations. These tasks include unloading, reloading, reorganizing, copying, and catalog management. The performance of many of these are critical in meeting your company's availability commitments.

The following products are added to the already robust array of products available for Database administration:

  • IBM IMS™ High Performance Sysgen Tools for z/OS
  • IBM IMS Command Control Facility for z/OS
  • IBM IMS Message Format Services Reversal Utilities for z/OS

All of these products can be a tremendous aid to the administration and management of your database environment. Try these new products today and see the benefits.

Key Prerequisites

The following products are designed to operate with IMS Version 5, 6, or 7:

  • IMS High Performance Sysgen Tools
  • IMS Command Control Facility
  • IMS Message Format Services Reversal Utilities

Planned Availability Date

The following products have an availability date of January 19, 2001:

  • IBM IMS High Performance Sysgen Tools for z/OS
  • IBM IMS Command Control Facility for z/OS
  • IBM IMS Message Format Services Reversal Utilities for z/OS

Description

IMS High Performance Sysgen Tools

IMS High Performance Sysgen Tools consists of the following utilities:

  • Fast Sysgen
  • Merge Clone
  • Sysgen Compare

The Fast IMS System Generation Utility operates either online or as a single step batch job to perform IMS MODBLKS type sysgens. Fast Sysgen reduces the time needed to perform IMS sysgens for application resource changes (transactions, programs, databases, and route codes) and consumes far less CPU time.

Since the Fast Sysgen Utility quickly builds updated MODBLKS and MATRIX data sets, you can easily process a sysgen to include updated application resources by simply updating the existing IMS sysgen and security source, and entering the IMS command "/MODIFY PREPARE MODBLKS FASTGEN".

The utility can also be executed in batch mode. In batch mode, the updated definitions can be implemented via an IMS online change or in a cold start of the IMS subsystem. When executed in online mode, the Fast Sysgen uses the IMS online change functionally to implement the updated resource definitions.

The Merge Clone Utility process creates IMS APPLCTN, TRANSACT, and DATABASE IMS sysgen macros. It reads the IMS MODBLKS data sets and combines the definitions of up to 64 connected IMS systems. The Merge Clone utility ensures that each application resource is defined with compatible values across each copy of IMS. For example, transactions are compared across each IMS system definition; any differences are identified, reported, and/or corrected for consistency.

The Merge Clone utility automatically coordinates database ACCESS= specifications and MSC SYSID= values. It determines, based on PSB PROCOPT values and DATABASE ACCESS= specifications, which transactions can run on which IMS systems. When a transaction can run locally based on its PROCOPT specifications and the allowed database access for that IMS system, the transaction is set as a local transaction. Otherwise, it is routed (via MSC) to an IMS system that meets the required database access requirements.

You can force transaction routing by providing control cards to the Merge Clone program. Through the control cards, you can specify on which system a transaction must run. You can specify the same transaction on any or all IMS regions.

Because the Merge Clone utility reads the IMS MODBLKS data set and generates IMS sysgen macros, you can recreate IMS sysgen macro source.

The Sysgen Compare Utility is included to compare two sets of MODBLKS and MATRIX data sets, and determine whether any differences exist and the resource definitions that differ.

IMS Command Control Facility

IMS Command Control Facility batch processor can run as an IMS BMP, IMS DL/I batch, or standard MVS™ batch job. It can execute commands across as many as 64 IMS regions on any number of MVS images. IMS commands are read from an input data set and processed one at a time across all requested regions.

IMS Command Control Facility can analyze command responses for database /STA, /STO, /DBD, and /DBR commands. It performs analysis by interrogating the DFS0488I message and checking for acceptable return codes. Command Control Facility can perform further analysis on database /DBD and /DBR commands by checking DBRC and verifying the database is not open to any subsystem with Update or Exclusive access. Failed commands will be retried a user-specified number of times with a user-specified time interval between each retry.

When sharing databases among multiple IMS systems, oftentimes they are defined with a different access. Command Control Facility can use one of two techniques to set the appropriate access on /STA DB dbdname ACCESS= commands. You can tailor it to determine the access by using the setting from the IMS System definition (MODBLKS Data Set), or use the Database definition in DBRC (Sharelvl 3 means ACCESS=UP on all systems).

The Command Control Facility provides several canned procedures, processes that might be performed manually by an MTO. Examples of Command Control Facility canned procedures include:

  • Coordinated Online Change. A Command Control Facility Online Change can be performed across multiple systems by supplying a single command to the Command Control Facility batch command processor. This process will coordinate the Online Change across multiple systems and minimize the potential out of sync conditions that might occur when the Online Change was performed manually.
  • Dead Letter Queue cleanup. Command Control Facility can clean up any Dead Letter Queue entries by supplying a single command to the Command Control Facility batch command processor.

The Command Control Facility provides several different methods for error handling. The available options include:

  • Abend the job with a user-specified abend code
  • Terminate the job step with a user-specified return code
  • Issue a WTOR to allow the operator to determine a course of action

The IMS Command Coordinator Facility also provides an ISPF interface that you can use to issue commands to an IMS subsystem interactively. Commands to any IMS region type (DB/DC, DC/CTL, or DB/CTL) running in any MVS system can be issued and command responses are returned to the ISPF session.

The IMS Command Coordinator Facility can easily be customized to route commands to all IMS systems in a Data Sharing environment, a single IMS region, or any combination of systems. The Command Control Facility maintains routing information in a user-customized VSAM Options data set.

Lastly, the Command Control Facility provides a seamless conversion from installation-written command processors. To simplify migration, the Command Control Facility has incorporated several customization options that should eliminate the need for JCL changes in most installations.

IMS Message Format Services Reversal Utilities

IMS Message Format Services (MFS) Reversal Utilities consists of the following utilities:

  • MFS Reversal
  • MFS Compare

The MFS Reversal is designed to convert MFS MID/MOD/DIF/DOF control blocks back into IMS MFS utility control statements. If you have lost your MFS source library or suspect a difference between the generated control blocks and source, this tool can help you recover the source and compare deltas. In addition to decoding MFS control blocks, the utility provides useful summary reports of IMS FORMAT library. These report the relationships among members.

The MFS Compare is designed to compare two sets of MFS source libraries to quickly highlight differences between the libraries. This can be very useful in validating what actually is operating in a particular IMS environment.

Euro Currency

These programs are not impacted by euro currency.

Trademarks

 
z/OS, IMS, and MVS are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Other company, product, and service names may be trademarks or service marks of others.

Offering Information

Product information will be available on day of announcement through Offering Information (OITOOL) at:

Publications

One copy of the following publications are supplied automatically with the basic machine-readable material:

                                             Order
Title                                        Number
 
IMS(TM) High Performance                     GC27-1169
 Sysgen Tools
 License Information
 
IMS Command Control                          GC27-1167
 Facility License
 Information
 
IMS Message Format                           GC27-0822
 Services Reversal
 Utilities V1 License
 Information

The following publications are available on the Internet at:

or via the IBM home page.

                                             Order
Title                                        Number
 
IMS High Performance                         SC27-1170
 Sysgen Tools User's Guide
 
IMS Command Control                          SC27-1168
 Facility User's Guide
 
IMS Message Format                           SC27-0823
 Services Reversal
 Utilities V1
 User's Guide

Technical Information

Specified Operating Environment

Hardware Requirements

The following products are designed to operate on any hardware supporting IMS Version 5, 6, or 7:

  • IMS High Performance Sysgen Tools
  • IMS Command Control Facility
  • IMS MFS Reversal Utilities

Software Requirements

The following products operate with IMS Version 5, 6, or 7. These products require SMP/E Version 1 for installation.

  • IMS High Performance Sysgen Tools
  • IMS Command Control Facility
  • IMS MFS Reversal Utilities

Planning Information

Packaging: The products listed in this announcement are distributed with the following content:

  • Basic machine-readable material on the customer-selected distribution medium (either 3480 tape cartridge or 4-mm DAT cartridge)
  • Program Directory
  • Proof of Entitlement (PoE)
  • IBM International Program License Agreement (IPLA)
  • License Information

The User's Guides for the products listed in this announcement are available on the Internet at:

or via the IBM home page.

Security, Auditability, and Control

The announced programs use the security and auditability features of the host operating system software.

The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.

Ordering Information

The following are products that have one charge unit: MSUs.

  • IMS High Performance Sysgen Tools V1
  • Subscription and Support for IMS High Performance Sysgen Tools V1
  • IMS Command Control Facility V1
  • Subscription and Support for IMS Command Control Facility V1
  • IMS Message Format Services Reversal Utilities V1
  • Subscription and Support for IBM IMS Message Format Services Reversal Utilities V1

Basic License

To order a basic license, specify the program number and feature number 9001 for asset registration, the appropriate charge feature numbers and quantities, and the feature number of the desired distribution medium.

New Customers

Specify the appropriate one-time charge (OTC) feature numbers with the desired quantity represented by the sum of Service Units in Millions (MSUs) ratings of the designated machines.

                                                   OTC
                              Program              Feature
Description                   Number               Number
 
IMS High Performance          5655-F43
 Sysgen Tools
 
 1 -- 45 MSUs                                      0005
 46 -- 175 MSUs                                    0006
 176 -- 315 MSUs                                   0007
 316+ MSUs                                         0008
 176 -- 315 MSUs                                   0011
  (quantity 250)
 316+ MSUs                                         0012
  (quantity 250)
 
IMS Command Control           5655-F40
 Facility
 
 1 -- 45 MSUs                                      0005
 46 -- 175 MSUs                                    0006
 176 -- 315 MSUs                                   0007
 316+ MSUs                                         0008
 176 -- 315 MSUs                                   0009
  (quantity 250)
 316+ MSUs                                         0010
  (quantity 250)
 
IMS MFS Reversal              5655-F45
 Utilities
 
 1 -- 45 MSUs                                      0001
 46 -- 175 MSUs                                    0002
 176 -- 315 MSUs                                   0003
 316+ MSUs                                         0004
 176 -- 315 MSUs                                   0009
  (quantity 250)
 316+ MSUs                                         0010
  (quantity 250)

Example: For IMS Sysgen Tools, on machines with 200 MSUs, you would order feature 0007.

Subsequent orders for additional MSUs are considered independent transactions. MSU quantities previously ordered are not accumulated to determine an ordering tier.

Trade-In Customers

These products are available at a one-time upgrade price for those customers currently licensed for similar competitive products such as BMC Unload Plus and BMC Load Plus. Customers must provide an original proof of purchase (front of user manual, front of cartridge insert, or copy of purchase invoice/bill of sale). Specify the appropriate OTC trade-in feature numbers with the desired quantity represented by the sum of MSUs of the designated machines.

                                                   OTC
                              Program              Feature
Description                   Number               Number
 
IMS High Performance          5655-F43
 Sysgen Trade-In
 
 1 -- 45 MSUs                                      0001
 46 -- 175 MSUs                                    0002
 176 -- 315 MSUs                                   0003
 316+ MSUs                                         0004
 176 -- 315 MSUs                                   0009
  (quantity 250)
 316+ MSUs                                         0010
  (quantity 250)
 
IMS Command Control           5655-F40
 Facility Trade-In
 
 1 -- 45 MSUs                                      0001
 46 -- 175 MSUs                                    0002
 176 -- 315 MSUs                                   0003
 316+ MSUs                                         0004
 176 -- 315 MSUs                                   0011
  (quantity 250)
 316+ MSUs                                         0012
  (quantity 250)
 
IMS MFS Reversal              5655-F45
 Utilities Trade-In
 
 1 -- 45 MSUs                                      0005
 46 -- 175 MSUs                                    0006
 176 -- 315 MSUs                                   0007
 316+ MSUs                                         0008
 176 -- 315 MSUs                                   0011
  (quantity 250)
 316+ MSUs                                         0012
  (quantity 250)

Subscription and Support

To receive voice technical support via telephone (voice support for defects during normal business hours) and future versions and releases at no additional charge, subscription and support must be ordered.

To order, specify the support program number and feature number 9001 for asset registration. Specify the annual support charge feature number with the desired quantity represented by the sum of MSUs of the designated machines.

Once subscription and support is ordered, the charges will automatically renew annually unless cancelled by the customer.

                                                   Annual
                                                   Support
                                                   Charge
                              Program              Feature
Description                   Number               Number
 
IMS High Performance          5655-F42
 Sysgen Subscription
 and Support
 
 1 -- 45 MSUs                                      0001
 46 -- 175 MSUs                                    0004
 176 -- 315 MSUs                                   0002
 316+ MSUs                                         0005
 176 -- 315 MSUs                                   0003
  (quantity 250)
 316+ MSUs                                         0006
  (quantity 250)
 
                                                   Annual
                                                   Support
                                                   Charge
                              Program              Feature
Description                   Number               Number
 
IMS Command Control           5655-F41
 Facility Pointer
 Checker Subscription
 and Support
 
 1 -- 45 MSUs                                      0002
 46 -- 175 MSUs                                    0001
 176 -- 315 MSUs                                   0003
 316+ MSUs                                         0005
 176 -- 315 MSUs                                   0004
  (quantity 250)
 316+ MSUs                                         0006
  (quantity 250)
 
IMS MFS Reversal              5655-F44
 Utilities Prefix
 Resolution Subscription
 and Support
 
 1 -- 45 MSUs                                      0004
 46 -- 175 MSUs                                    0001
 176 -- 315 MSUs                                   0002
 316+ MSUs                                         0005
 176 -- 315 MSUs                                   0003
  (quantity 250)
 316+ MSUs                                         0006
  (quantity 250)

Basic Machine-Readable Material

                        Feature
Environment             Number       Distribution Medium
 
IMS High Performance Sysgen Tools
 
OS/390(R)               5802         3480 tape cartridge
OS/390                  6241         4-mm DAT cartridge
 
IMS Command Control Facility
 
OS/390                  5802         3480 tape cartridge
OS/390                  6233         4-mm DAT cartridge
 
IMS Message Format Services Reversal Utilities
 
OS/390                  5802         3480 tape cartridge
OS/390                  6243         4-mm DAT cartridge

Basic License: To order, specify the program number, feature number 9001 for asset registration, and the OTC feature number. Also specify the feature number of the desired distribution medium.

Customization Options: Select the appropriate feature numbers to customize your order with delivery options desired. These features can be specified on the initial or MES orders.

Example: If publications are not desired for the initial order, specify feature number 3470 to ship media only. For future updates, specify feature number 3480 to ship media updates only. If, in the future, publication updates are required, order an MES to remove feature number 3480; then, the publications will ship with the next release of the program.

                                                    Feature
Description                                         Number
 
Initial Shipments
 
Serial Number Only (suppresses shipment             3444
 of media and documentation)
 
Ship Media Only (suppresses initial                 3470
 shipment of documentation)
 
Ship Documentation Only (suppresses                 3471
 initial shipment of media)
 
Update Shipments
 
Ship Media Updates Only (suppresses                 3480
 update shipment of documentation)
 
Ship Documentation Only (suppresses                 3481
 update shipment of media)
 
Suppress Updates (suppresses update                 3482
 shipment of media and documentation)
 
Expedite Shipments
 
Local IBM Office Expedite                           3445
 (for IBM use only)
 
Customer Expedite Process Charge                    3446
 ($30 charge for each product)

Expedite shipments will be processed to receive 72-hour delivery from the time IBM Software Delivery and Fulfillment (SDF) receives the order. SDF will then ship the order via overnight air transportation.

Customized Offerings

Most product media is shipped only via customized offerings (that is, CBPDO, ServerPac, SystemPac). Noncustomized items (CDs, diskettes, source media, media kits) will continue to be shipped via the stand-alone product.

Terms and Conditions

Licensing: IBM International Program License Agreement. PoEs are required for all authorized use.

These products are licensed under the IPLA, and the associated Agreement for Acquisition of Support, and the Addendum for Support, which provides for support with ongoing access to releases and versions of the program. These programs have a one-time license charge for use of the program and an ongoing recurring charge for the enhanced support that includes telephone assistance (voice support for defects during normal business hours) as well as access to updates, releases, and versions of the program as long as support is in effect. S/390® SupportLine is an option for those customers who desire added services.

Limited Warranty Applies: Yes

Program Services: Available until March 31, 2004

Money-Back Guarantee: Two-month, money-back guarantee

Copy and Use on Home/Portable Computer: No

Volume Orders (IVO): No

Passport Advantage Applies: No

Passport Advantage Subscription Applies: No

Support Line: Yes

AIX®/UNIX® Upgrade Protection Applies: No

Entitled Upgrade for Current AIX/UNIX Upgrade Protection Licensees: No

AS/400® Software Subscription Applies: No

Variable Charges Apply: No

Educational Allowance Available: Yes, 15% education allowance applies to qualified education institution customers.

Prices

Contact your IBM representative for charges information for this announcement.

Order Now

 Use Priority/Reference Code: LE001
 
 Phone:     800-IBM-CALL
 Fax:       800-2IBM-FAX
 Internet:  ibm_direct@us.ibm.com
 Mail:      IBM Atlanta Sales Center
            Dept. LE001
            P.O. Box 2690
            Atlanta, GA  30301-2690

You can also contact your local IBM Business Partner or IBM representative. To identify them, call 800-IBM-4YOU.

Note: Shipments will begin after the planned availability date.

Trademarks

 
IMS is a trademark of International Business Machines Corporation in the United States or other countries or both.
 
OS/390, S/390, AIX, and AS/400 are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
UNIX is a registered trademark in the United States and other countries exclusively through X/Open Company Limited.
 
Other company, product, and service names may be trademarks or service marks of others.