Data Base Integrity Control Facility

Software Announcement
November 29, 1994
Announcement Letter Number: 294-757

Table of Contents:

In Brief . . .

Data Base Integrity Control Facility can improve the integrity of databases controlled by IMS/ESA Database Manager Version 4. 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.

In the day-to-day operation of an enterprise using databases (DBs) processed by IMS/ESA (R) with Data Base Recovery Control (DBRC), situations may occur that can affect DB integrity. Data Base Integrity Control Facility (DBICF), a program package written by Swiss Bank Corporation, has been developed to improve the integrity of DBs controlled by IMS/ESA Database Manager Version 4.

DBICF contains functions and facilities that allow the user to:

  • Organize and control databases more efficiently

  • Take preventive and corrective actions for protecting databases against operational errors

  • Simplify and speed up database repair-oriented actions
DBICF allows the use of DBRC under TSO/ISPF. DBICF provides the user with facilities, both under TSO/ISPF and batch, to generate jobs and reports required in normal and out-of-line situations. A component of DBICF, called Data Base Information Retrieval Facility (DBIRF), allows for the creation of additional reports.

Finally, DBICF allows the database administrator and the operator to make better use of DBRC. Together with DBRC, it is a user-friendly and fully transparent tool to enhance the integrity of IMS databases.

Planned Availability Date: December 9, 1994

 (R)  Registered trademark of International Business Machines


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:


DBICF consists of two parts:

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

  2. DBICF contains a lot of program functions that can be started as batch jobs, via procedures or, if applicable, under TSO foreground. All these functions work independently from each other. Thus, each user can choose those functions that best fit his or her 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 (ACB, GET, POINT, and so on).

  2. For updates, DBRC commands are generated, then DBRC is called, which executes the generated commands and updates the RECON. DBICF never updates a RECON directly.
The RECON may contain spanned records and does not have to be in basic position (RECON1 = COPY1, RECON2 = COPY2, RECON3 -- if defined -- = spare).

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 (BMPs) only, or an IMS batch job.

Benefits of Using DBICF


  • Allows 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.

  • Controls 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.

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

  • Generates, 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.

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

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

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

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

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

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

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

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

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

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

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

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

  • Provides 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.

  • Provides additional functions that allow the database administrator and the operator to make better use of DBRC (see Availability Notice, GB11-8950).


Specified Operating Environment

This product uses only existing attachment interfaces.

Hardware Requirements: The machine configuration required of Data Base Integrity Control Facility is the same as that of IMS/ESA Version 4.

Software Requirements: The following minimum versions/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/SP (TM)-JES2 Version 3 Release 1 (5685-001) or MVS/SP-JES3 Version 3 Release 1 (5685-002)

  • IMS/ESA Database Manager Version 4 Release 1 (5685-012)

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

  • ISPF Version 2 Release 3 (5665-319)

  • ISPF/PDF Version 2 Release 3 (5665-317)

  • Assembler H Version 2 Release 1 (5668-962)
Optional Software:
  • IMS/ESA Transaction Manager Version 4 Release 1 (5685-013)

  • CICS/MVS (R) Version 2 Release 1 (5665-403)

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

  • DB2 Version 2 Release 3 (5665-DB2)

  • QMF (TM)/MVS Version 2 Release 4 (5668-721)

  • OS PL/I Version 1 Release 5 (Optimizing Compiler 5734-PL1, Resident Library 5734-LM4, and Transient Library 5734-LM5, or composite package Optimizing Compiler and Libraries 5734-PL3) or 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 an IMS online, CICS with local DL/I or DBCTL, DBCTL used by BMPs, and IMS batch environment.

DBICF supports IMS/ESA Version 4, and will support subsequent releases unless otherwise identified by IBM.

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.


The following advance publications are available now. To order, contact your IBM representative.

Title                                             Number

Program Description and Operations Manual SB11-8951

Reference Summary GB11-8952

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

5787 LAR

Basic License: To order a basic license, specify the program number and feature number 9001 for asset registration. Specify feature number 0179 for a one-time charge. 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, the customer must notify and identify to IBM 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:

Environment          Number        Distribution Medium

DBI Control Facility 5862 3480 tape cartridge

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.

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 (ISMS) receives the order. ISMS will then ship the order via overnight air transportation.

Unlicensed Documentation: One copy of each of the following publications is supplied automatically with the basic machine-readable material:

Title                                             Number

Program Description and Operations Manual SB11-8951

Reference Summary GB11-8952

Additional copies of unlicensed publications will be 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.


Licensing: This program 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 15% educational allowance is applicable toward eligible license charges and is available to qualifying institutions in accordance with the Educational Allowance Attachment.

The educational allowance may not be added to any other discount or allowance.

Version Upgrades: Version-to-version upgrade credits apply.

Replaced Program(s)    Replacement Program(s) Version
Program      Program   Program   Program      Charging
Number       Name      Number    Name         Applies

5787-LAR DBICF To a follow-on, if any N/A

Warranted: No

Licensed Program Materials Availability: Restricted Materials -- Yes. This licensed program will be available with source licensed program material for some modules designated as RESTRICTED MATERIALS OF IBM. In addition, some modules will be available without source licensed program materials. These modules will be available in object code.

Please refer to publication SB11-8951 for the identity of those components with some or all modules available without source licensed programs materials.

Program Services: Central Service will be available until December 31, 1997.


Contact your IBM representative for charges information for this announcement.

 (TM) Trademark of International Business Machines Corporation.

Share this page

Digg Linked In

Contact IBM

Considering a purchase?