Data Base Integrity Control Facility Version 5
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
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
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
DBICF consists of two parts:
- 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.
- 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.
- For reads, the RECON (one or two data sets according to the DBICF
function) is accessed directly via standard VSAM macros.
- For updates, DBICF formats DBRC commands. These format commands are processed by DBRC for RECON updating. DBICF never updates the RECON directly.
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
- Enable the user to automatically set back the effects of one or
several IMS online, CICS, and IMS batch test sessions with IMS
- 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
- All DBs
- Generate recovery jobs for one or several DB data sets to be run
in single or parallel mode according to user requirements, by
- 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
- 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
- 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
- Enable consistency checking for all DBs that are registered with
- 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.
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.
- 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)
- 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)
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
- 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
- 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
- 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.
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
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 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
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 (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.
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
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.
Contact your IBM representative for charges information for this announcement.