Browse Prior Art Database

One pass tool builder for DBMS objects

IP.com Disclosure Number: IPCOM000031037D
Original Publication Date: 2004-Sep-07
Included in the Prior Art Database: 2004-Sep-07
Document File: 1 page(s) / 28K

Publishing Venue

IBM

Abstract

When customers want to build Job Control Language (JCL) jobstreams for batch tools to support all the database objects in their shop they do not have a comprehensive tool to assist them. Similarly, if they are converting from an OEM to IBM tool jobstreams, then they face a similar dilemma. Jobstreams have to be built manually, so this would be very time consuming and susceptible to human error. Database registration with the DBMS is also a time consuming process, even if semi-automated processes exist, substantial data entry would be required.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 98% of the total text.

Page 1 of 1

One pass tool builder for DBMS objects

A single pass of a DBMS's object library, by a special batch job, would group the objects by relationships, register these groups in the DBMS and build batch jobstreams to support these groups.

The following pseudo code shows an implementation of the invention that was was used in the IMS DataBase Control Suite 3.1 Batch Collect function.

Define basic JCL and tool parameters via ISPF panels and store them in an ISPF table. Then a batch job is launched to perform the following: Allocate the JCL and tool parameters ISPF table
Allocate the IMS data base definition (DBDLIB) library Allocate the IMS dynamic allocation (DYNLIB) library Allocate the IMS database recovery and control (DBRC) RECON data sets Allocate an empty JCL jobstream partitioned data set Get the first DBD from the DBDLIB
Do while DBDs in the DBDLIB Reverse DBD code to identify related indexes and logically related databases

Create a DBRC DBDSGRP for the DBD, and the DBDs for indexes/logically related databases

Use the RECON data set or DYNLIB and the TSO LISTC command to retrieve database data set information.

Register the DBDs and database data sets in the RECON data set if needed.

Allocate Generation Dataset Groups (GDGs) for output data sets if defined via the ISPF panels.

Build database image copy, pointer checker, reorganization, simple recovery and space monitor jobstreams for this DBDSGRP and put them in the output JCL jobstream partitioned data set.

Get th...