Data Base Integrity Control Facility
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
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
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 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
DBICF consists of two parts:
- 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.
- 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.
- 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).
- 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.
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
- 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
- All DBs
- Generates recovery jobs for one or several DB data sets to be run
in single or parallel mode according to user requirements, by
- 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
- 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
- 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
- Enables consistency checking for all DBs that are registered with
- 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.
- 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)
- 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)
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.
Order Title Number
Program Description and Operations Manual SB11-8951
Reference Summary GB11-8952
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:
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:
Feature 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.
Feature Description Number
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
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
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:
Order 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.
Single 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
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.