Data Base Integrity Control Facility Version 5

Software Announcement
November 21, 1995
Announcement Letter Number: 295-483


Table of Contents:



In Brief . . .

Data Base Integrity Control Facility can improve the integrity of databases controlled by IMS/ESA Database Manager Version 5. It allows users to:

  • Organize and control databases

  • Take preventive and corrective actions

  • Simplify database repair

  • Generate jobs and reports

  • Make better use of Data Base Recovery Control
Together with DBRC, DBICF is user friendly and fully transparent.

Data Base Integrity Control Facility (DBICF), a program package written by Swiss Bank Corporation, was developed to improve the integrity of databases controlled by IMS/ESA (R) and to simplify the use of IMS (TM) Data Base Recovery Control (DBRC). DBICF Version 5 provides support for the IMS/ESA Version 5 environment, including the Remote Site Recovery (RSR) feature.

DBICF runs in an IMS online environment, a CICS (TM) environment with local DL/I or DBCTL, a DBCTL environment used by batch message processing (BMP), and an IMS batch environment. It contains functions and facilities that allow the user to:

  • Organize and control the databases (DBs) more efficiently

  • Take preventive and corrective actions for protecting the DBs against operational errors

  • Simplify and speed up DB repair-oriented actions
DBICF allows the use of DBRC under TSO/ISPF. It provides the user with facilities, both under TSO/ISPF and batch, to generate jobs and reports required in normal and out-of-line situations. The Data Base Information Retrieval Facility (DBIRF), a DB2 (R)-based component of DBICF, provides additional reporting capabilities.

In summary, DBICF is a user-friendly tool that can help database administrators and operators make better use of DBRC and enhance the integrity of IMS/ESA databases.



Planned Availability Date: December 1, 1995

 (R)  Registered trademark of International Business Machines
      Corporation
 (TM) Trademark of International Business Machines Corporation

------------------------------

This announcement is provided for your information only. For additional information, contact your IBM representative, call 800-IBM-4YOU, or visit the IBM home page at: http://www.ibm.com



DESCRIPTION

DBICF consists of two parts:

  1. When running under TSO/ISPF, DBICF serves as a direct interface between the end user and DBRC. Over 300 panels and CLIST procedures help the user enter correct DBRC commands.

  2. DBICF contains many program functions that can be started as batch jobs, via procedures or in TSO foreground. These functions work independently from each other. Thus, each user can choose those functions that best fit the operating requirements.
DBICF accesses the RECON in two ways:
  1. For reads, the RECON (one or two data sets according to the DBICF function) is accessed directly via standard VSAM macros.

  2. For updates, DBICF formats DBRC commands. These format commands are processed by DBRC for RECON updating. DBICF never updates the RECON directly.
CICS users with DL/I databases can also benefit from DBICF. CICS with local DL/I or with DBCTL is treated by DBRC as an IMS subsystem equivalent to an IMS online system, a DBCTL system used for batch message processing (BMP) only, or an IMS batch job.



Benefits of Using DBICF

DBICF is designed to:

  • Allow the performance of all of the DBRC functions and of selected DBICF functions interactively under TSO/ISPF. The DBRC commands can be entered via appropriate DBICF menus (formatted input) or in the same format as required by the DBRC recovery control utility (unformatted input). All the output generated by DBRC is displayed on the user's terminal and can be printed.

  • Control the backing out of an IMS batch job that has not been successfully completed, by automatically assigning and checking the correct input and output resources. In case of a failure while backing out, the appropriate recovery jobs are automatically generated.

  • Enable the user to automatically set back the effects of one or several IMS online, CICS, and IMS batch test sessions with IMS production DBs.

  • Generate, by single commands, the job groups necessary for the image copy of:
    • All DBs

    • Only the DBs that have been updated since the last image copy, or that must be saved for other reasons (for example, if a DB has never been saved, if the latest IC is flagged as "invalid," and so on)

    • Individual DBs
    In addition, the user can define how the output data sets have to be organized, labelled, and stored.

  • Generate recovery jobs for one or several DB data sets to be run in single or parallel mode according to user requirements, by single commands.

  • Enable the creation of a set of IMS test DBs with the current or a previous DB content.

  • Optionally log all RECON updates performed directly by DBRC batch and/or via DBICF functions.

  • Enable comparison of the RECON with the Data Base Description (DBD) library, the MDA members, and the DBs specified in the IMS (online) generation.

  • Enable an automatic RECON cleanup after any "non-estae" situations (system loop/system wait) and reinstate the correct RECON combination in an error situation.

  • Reorganize and additionally set the RECON to basic position (RECON1 = COPY1, RECON2 = COPY2, RECON3 -- if defined -- = spare) even during IMS online and/or CICS.

  • Use the CA group or the DBDS group as an additional selection criterion.

  • Generate the MDA source statements necessary for the dynamic allocation of IMS DL/I DBs and Fast Path DEDBs.

  • Enable anticipated PSB authorization checking in a DB sharing environment.

  • Enable consistency checking for all DBs that are registered with DBRC.

  • Enable the running of any generated job as a started task.

  • Provide a function called Data Base Information Retrieval Facility (DBIRF), which enables loading of database-related information from the RECON, the VTOC, and the VSAM catalog to a DB2 table and creation of reports by using predefined SQL queries provided by DBIRF or by entering SQL SELECT statements.

  • Provide the user with additional reports and check lists such as IMS DB history, IMS DB overviews, PSB Processing Intent Attributes report, and predefined and ad hoc reports from a DBIRF DB2 table.

  • Provide additional functions that allow the database administrator and the operator to make better use of DBRC.



TECHNICAL INFORMATION



Specified Operating Environment

Hardware Requirements: The Data Base Integrity Control Facility will operate on any hardware supporting MVS/ESA (TM) Version 4.2 or higher.

Software Requirements: The following minimum versions and releases of programs are required for installing Data Base Integrity Control Facility. Follow-on versions or releases of these products can be used unless otherwise stated.

Required Software

  • MVS/ESA SP (JES2) Version 4 Release 2 (5695-047) or MVS/ESA SP (JES3) Version 4 Release 2 (5695-048)

  • IMS/ESA Version 5 Release 1 (5695-176) Database Manager

  • TSO/E Version 2 Release 3 (5685-025)

  • ISPF Version 3 Release 3 (5685-054)

  • ISPF/PDF Version 3 Release 4 (5665-402)

  • Assembler H Version 2 Release 1 (5668-962)
Optional Software
  • IMS/ESA Version 5 Release 1 (5695-176) Transaction Manager

  • IMS/ESA Version 5 Release 1 (5695-176) Remote Site Recovery

  • CICS/ESA (R) Version 3 Release 3 (5688-083)

  • DB2 Version 3 Release 1 (5685-DB2)

  • QMF (TM) (MVS) Version 3 Release 1 (5706-254)

  • OS PL/I Version 2 Release 1 (Compiler and Library, 5668-910, or Compiler, Library, and Interactive Test Facility, 5668-909)

  • RACF (TM) Version 1 Release 9 (5740-XXH, or equivalent product)
DBICF has been written in Assembler.

PL/I is required when using function DBIRF, which makes use of the DB2 program DSNTEPx written in PL/I.

DBICF runs in IMS online, CICS with DBCTL, DBCTL used by BMP, and IMS batch environments.

DBICF supports IMS/ESA Version 5 only.

User Group Requirements: This announcement satisfies or partially satisfies 18 requirements from one or more of the worldwide user group communities, which include Australasian SHARE/GUIDE (ASG), COMMON, COMMON Europe, GUIDE International, G.U.I.D.E. Europe, Japan GUIDE/SHARE (JGS), Guide Latin American (LAG), SHARE EUROPE, and SHARE Incorporated:

  • R00038655 -- IMS-DBRC Online Interface

  • R00037573 -- Need to Recover Multiple DBDS or DBD in Parallel under DBRC

  • R00026004* -- DBRC GENJCL.USER Should Cater for Multivolume DASD Logs (DBICF will back out jobs)

  • R00002699 -- IMS GENJCL Support for Batch Backout

  • R00002700 -- IMS DBRC Plus, an IBM WTC Product Needed in USA

  • R00002719 -- Using the IMS V2 Batch Backout Utility Cause Data Integrity

  • R00002968 -- LIST.IC New Function of DBRC

  • R00006513* -- IMS DBRC Skeletal JCL Improvements (DBICF lists status of each RECON)

  • R00006525* -- IMS DBRC Log Selection in Skeletal JCL (DBICF will back out online application)

  • R00020298* -- Require IC-NEEDED Flag Be Set After Timestamp Recovery (DBICF will report DBs not image copied after timestamp recovery)

  • R00021765 -- IMS DBRC Utility to Clean Up Abended Subsystems

  • R00037795 -- Batch Application Interface (DBRC)

  • R00029615* -- Greater Flexibility in DBRC for CA and Recovery (DBICF allows parallel recovery of DBs)

  • R00040170 -- DBRC/TSO Interface

  • R00039367 -- IMS MSG DFS047A-List Subsystems Preventing DB Auth.

  • R00037887 -- DBRC Generate JCL for Backout

  • R00029636 -- DBRC Generate Valid Recovery JCL After Program Load

  • R00040167 -- IMS User-Friendly Operator Interface
*     Partially addressed by DBICF



Security, Auditability, and Control

This program uses the security and auditability features of the supported IMS and/or MVS systems.

User management 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 advance publications are available now. To order, contact your IBM representative.

                                             Order
Title                                        Number

Program Description and Operations Manual SC26-8383

Reference Summary Card SC26-8384



New Licensees

Orders for new licenses will be accepted now. Shipment will begin on the planned availability date.

New users of Data Base Integrity Control Facility should specify:

         Type           Model

5697 073

Basic License: To order a basic license, specify the program number and feature number 9001 for asset registration. Specify feature number 4021 for a one-time charge or feature number 4020 for a monthly license charge. Also specify the feature number of the desired distribution medium shown below.

Version-to-Version Upgrade Credit: To upgrade from a prior program acquired for a one-time charge to a replacement program using a version-to-version upgrade credit, you must notify IBM and identify the applicable prior program and replacement program participating in the upgrade credit.

Basic Machine-Readable Material: To order, select the feature number of the desired distribution medium:

                   Feature
Environment        Number         Distribution Medium

DBICF V5 5892 3480 Tape Cartridge

DBICF V5 5891 6250 Magnetic Tape

Customization Options: Select the appropriate feature number(s) to customize your order to specify the delivery options desired. These features can be specified on the initial or MES orders.

Example: If publications are not desired for the initial order, and for future updates, specify feature numbers 3470 to ship media only, and 3480 to ship media updates only. In the future if publication updates are required, order an MES to remove feature number 3480, and the publications will ship with the next release for the program.

                                                    Feature
Description                                         Number

Initial Shipments

Serial Number Only (suppresses shipment of media and documentation) 3444

Ship Media Only (suppresses initial shipment of documentation) 3470

Ship Documentation Only (suppresses initial shipment of media) 3471

Update Shipments

Ship Media Updates Only (suppresses update shipment of documentation) 3480

Ship Documentation Only (suppresses update shipment of media) 3481

Suppress Updates (suppresses update shipment of media and documentation) 3482

Expedite Shipments

Local IBM Office Expedite (for IBM use only) 3445

Customer Expedite Process Charge ($30 charge for each product) 3446

Expedite shipments will be processed to receive 72-hour delivery from the time IBM Software Manufacturing Solutions (SMS) receives the order. SMS will then ship the order via overnight air transportation.

Unlicensed Documentation: A program directory and one copy of the following publications are supplied automatically with the basic machine-readable material:

                                                  Order
Title                                             Number

Program Description and Operations Manual SC26-8383

Reference Summary SC26-8384

Additional copies of unlicensed publications are available for a fee after product availability. These copies may be ordered from your IBM representative, through the System Library Subscription Service (SLSS), or by direct order.

Subsequent updates (technical newsletters or revisions between releases) to the publications shipped with the product will be distributed to the user of record for as long as a license for this software remains in effect. A separate publication order or subscription is not needed.



TERMS AND CONDITIONS

Licensing: The program described in this announcement is licensed under the terms of the IBM Customer Agreement.

Variable Charges Apply: No

Installation License or Location License Applies: No. A separate license is required for each machine on which the licensed program materials will be used.

Educational Allowance: A reduced charge is available to qualified education customers. The educational allowance may not be added to any other discount or allowance.

Volume Discount: Not applicable

Version-to-Version Upgrade Credits Apply: Yes

                                                      Single
Replaced Programs           Replacement Programs     Version
Program     Program         Program     Program      Charging
Number      Name            Number      Name         Applies

5697-073 DBICF V5 To a follow-on, if any NA*

5787-LAR DBICF V4 5697-073 DBICF V5 Yes

* NA = Not applicable

Warranted: No

Licensed Program Materials Availability: Restricted Materials -- No. All modules of this licensed program will be available with source licensed program materials.

Program Services: Central Service will be available until June 30, 1999.



CHARGES

Contact your IBM representative for charges information for this announcement.