IBM United States
Software Announcement 200-451
December 19, 2000
More Database Tools for DB Administration
At a Glance
High Performance System Generation Tools
Command Control Facility
MFS Reversal Utilities
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).
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:
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.
The following products are designed to operate with IMS Version 5, 6, or 7:
Planned Availability Date
The following products have an availability date of January 19, 2001:
IMS High Performance Sysgen Tools
IMS High Performance Sysgen Tools consists of the following utilities:
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.
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:
The Command Control Facility provides several different methods for error handling. The available options include:
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:
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
These programs are not impacted by euro currency.
Product information will be available on day of announcement through Offering Information (OITOOL) at:
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
Specified Operating Environment
The following products are designed to operate on any hardware supporting IMS Version 5, 6, or 7:
The following products operate with IMS Version 5, 6, or 7. These products require SMP/E Version 1 for installation.
The User's Guides for the products listed in this announcement are available on the Internet at:
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.
The following are products that have one charge unit: MSUs.
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.
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)
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
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.
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
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.
Use Priority/Reference Code: LE001 Phone: 800-IBM-CALL Fax: 800-2IBM-FAX Internet: firstname.lastname@example.org 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.