Browse Prior Art Database

SQL MASTER/VM - a SQL/DS Data Base Master Controller

IP.com Disclosure Number: IPCOM000120306D
Original Publication Date: 1991-Apr-01
Included in the Prior Art Database: 2005-Apr-02
Document File: 4 page(s) / 209K

Publishing Venue

IBM

Related People

Masemore, TL: AUTHOR [+2]

Abstract

Disclosed is a program (SQLMSTR) that acts as a master controller for IBM Structured Query Language/Data System (SQL/DS) data base machines, which will automate many of the manual Data Base Administrator (DBA) functions required to support the data base in the VM/SP or VM/XA environments.

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 30% of the total text.

SQL MASTER/VM - a SQL/DS Data Base Master Controller

      Disclosed is a program (SQLMSTR) that acts as a master
controller for IBM Structured Query Language/Data System (SQL/DS)
data base machines, which will automate many of the manual Data Base
Administrator  (DBA) functions required to support the data base in
the VM/SP or VM/XA environments.

      SQLMSTR serves as a console interface to the data base
machine(s), examining each data base message and initiating any
appropriate action.  SQLMSTR also accepts commands from authorized
users and passes them to the data base machine for execution, e.g.,
SQL/DS Operator commands.

      Major data base functions which are automated by SQLMSTR
include archiving, recovery, adding dbextents, adding dbspaces,
startup, shutdown, startup parameter changing, reorganizing catalog
indexes, logmode switching, cold logging, and monitoring.

      SQLMSTR operates as a disconnected virtual machine that
communicates with one or more SQL/DS data base machines through the
Secondary Console Interface Facility (SCIF) component of VM.  The
SCIF facility allows a virtual machine (data  base) to operate
without a connected terminal (disconnected mode), and  directs all
terminal output to another virtual machine, which is executing the
SQLMSTR program.  The second  virtual machine  (SQLMSTR) may also
send commands to the first virtual machine (data base), simulating
the function normally provided by a terminal keyboard.

      The essential purpose of the SCIF facility is to allow a
virtual machine to operate without human intervention. SQLMSTR
utilizes this capability and provides the human intelligence that
enables many data base activities to be performed without direct
interaction by a DBA.  A common example of this is the data base
archiving function.  This activity normally requires that a DBA log
onto the data base virtual machine, issue the archive command, and
then follow the instructions of the SQL/DS Planning and
Administration guide to complete the archive.  This will involve
issuing tape mount requests, answering various questions from the
SQL/DS archiving function, detaching tapes, and bringing the data
base down and up as required.  An additional responsibility for the
DBA is to record which tapes were used for this archive, in case a
later data base recovery is required.

      All SCIF messages that are recognized by SQLMSTR are included
in a file which is provided with the SQLMSTR program.  Each message
identifier (first blank delimited word in the message) is listed in
this file with a corresponding executable module that will be
performed whenever that message is received from a data base.

      These modules provide the intelligence that enables SQLMSTR to
perform data base activities without human intervention.  This
message control file contains all entries necessary to perform the
archiving, recovery, startup, coldlog, and other functions
supporte...