Mainframe Utility: DB2UTIL

Return to Mainframe Utilities Page

Module


/**********************************************************************/
/* UTILITY: DB2UTIL                                                   */
/* AUTHOR: DAVID LEIGH                                                */
/* FUNCTION: THIS UTILITY INVOKES PLATINUM'S RC/QUERY FOR A SPECIFIC  */
/*           DB2 SUBSYSTEM AND THEN TAKES THE USER DIRECTLY TO THE    */
/*           "SY" "UT" SCREEN TO SEE WHAT UTILITIES THAT DB2 KNOWS    */
/*           ABOUT FOR THAT SUBSYSTEM.                                */
/**********************************************************************/
PROC 1 DB2_SUBSYSTEM_ID
ISPEXEC SELECT CMD(%SETVAR SYS RC &STR(&DB2_SUBSYSTEM_ID))
        SET HIGHLVL = &STR(SYS3.PLATINUM.PROD)
        ALLOC FI(CTRANS) DA('&HIGHLVL..LOADLIB') SHR
        ALLOC FI(PTILIB) DA('&HIGHLVL..LOADLIB') SHR
        ALLOC FI(PTIXMSG) DA('&HIGHLVL..XMESSAGE') SHR
        ALLOC FI(PTIPARM) DA('&HIGHLVL..PARMLIB') SHR
        ISPEXEC LIBDEF ISPLLIB DATASET ID ('&HIGHLVL..LOADLIB')
        ISPEXEC LIBDEF ISPMLIB DATASET ID ('&HIGHLVL..SPFMLIB')
        ISPEXEC LIBDEF ISPPLIB DATASET ID ('&HIGHLVL..SPFPLIB')
        ISPEXEC LIBDEF ISPSLIB DATASET ID ('&HIGHLVL..SPFSLIB')
        ISPEXEC LIBDEF ISPTLIB DATASET ID ('&HIGHLVL..SPFTLIB')
        EXEC 'SYS2.ISPF.ISPCLIB(RSPINIT)'
        ISPEXEC SELECT PGM(PTLDRIVM) +
                       PARM(CI=PTLGLBL/RCQ SY UT) +
                       NEWAPPL(RC) PASSLIB
        ISPEXEC LIBDEF ISPLLIB
        ISPEXEC LIBDEF ISPMLIB
        ISPEXEC LIBDEF ISPPLIB
        ISPEXEC LIBDEF ISPSLIB
        ISPEXEC LIBDEF ISPTLIB
        ISPEXEC LIBDEF ISPTABL
        FREE FI(CTRANS PTILIB PTIPARM PTIXMSG)
            


Documentation


 Use the DB2UTIL utililty to view utility jobs that are running, or utility jobs
 that have stopped and need to be restarted or terminated.  Examples of utility
 jobs are loads, unloads, reorgs and image copies.

 Type "TSO DB2UTIL DSNT" on any command line to view a list of utilities running
 in the DSNT subsystem.

 Type "TSO DB2UTIL DSNP" on any command line to view a list of utilities running
 in the DSNP subsystem.

 Following is an example:

 COMMAND ===> tso db2util dsnt


 This utility takes you directly into Platinum's RC/Query facility.
 Alternatively, you can enter Platinum manually and get to the same place as
 follows:

   From the Platinum main menu, select option "1" for RC/Query.

   On the RC/Q Main Menu, enter "SY" for the "DB2 OBJECT ===>" Press ENTER.


 RQM    R03.03 ---------------- RC/Q Main Menu --------------- 02-16-96 14:01:18
 COMMAND ===>


  DB2 Object ===> sy                   Option ===>
   Item Name ===> *                   Creator ===> *        Where => N
   Qualifier ===> *                   Grantor ===> *
 ----------------------------------------------------------------- D@UJEF
 Location ===> LOCAL            DB2 SSID ===> DSNT      DB2 Version => V2R3M0


  DB2 OBJECTS:     T - Table           SG - Storage Group      P - Plan
                   V - View            DB - Data Base         CL - Collection
                   I - Index           TS - Table Space       PK - Package
                   C - Column          BP - Buffer Pool       DR - DBRM
                   S - Synonym
                   A - Alias            U - User
                  RI - Referential     SY - System
                       Integrity       VC - VSAM Catalog



   Enter ? in COMMAND field to display commands, like PROFILE and TUTORIAL.

  --- Copyright  1987,1994  PLATINUM technology inc.  All Rights Reserved ---



1
 On the next screen, type in "UT" for the "OPTION ===>" Press ENTER.


 RQSYM  R03.03 ------------ RC/Q System Main Menu ------------ 02-16-96 13:42:15
 COMMAND ===>
              _

  DB2 Object ===> SY                   Option ===>
   Item Name ===> *                   Creator ===> *        Where => N
   Qualifier ===> *                   Grantor ===> *
 Loc: LOCAL ------------------------------ SSID: DSNT ------------ P@UXXX
   System Options:

      IC = Image Copy Detail       CD = Communication Database (V2.2)

      L  = List DB2 Utilities      CS = Character Set Translation (V2.3)

      Z  = DSNZPARMS               RL = DB2 Resource Limit Table

      UT = Utility Display         Q  = QMF Resource Limit View






   --- Copyright  1987,1994 PLATINUM technology inc.  All Rights Reserved ---



 Regardless of how you got to this screen in Platinum (via "DB2UTIL" or manual
 menu navigation), to terminate a utility, find the jobname for your utility job
 under the UTILITY-ID column.  Type  "TERM" in the CMD column to the left of
 your job name.  NOTE:  Once a utility has been terminated, it cannot be
 restarted.  See the DB2 "COMMAND AND UTILITY REFERENCE" manual for more
 information on utilities, terminating them or restarting them.

 RQSYUT R03.03 --------- RC/Q System Utility Display --------- 02-16-96 13:39:57

 COMMAND ===>                                                  SCROLL ===> CSR
              _

  DB2 Object ===> SY                   Option ===> UT
  UTILITY-ID ===> *                   Creator ===> *        Where => N
   Qualifier ===> *                   Grantor ===> *
 Loc: LOCAL ------------------------------ SSID: DSNT ------------ D@UJEF
 CMD      UTILITY-ID        USERID   STMT  UTILITY  PHASE     COUNT    STATUS
 term____ P@UXXXUT          P@UXXX   1     LOAD     RELOAD    0        STOPPED
 ******************************** BOTTOM OF DATA *******************************






 Options: IC=Image Copy, L=List DB2 Utility, Z=DSNZPARM, UT=Utility Display,
          CD=Communication Database (V2.2), CS=Character Sets (V2.3),
          RL=DB2 Resource Limit, Q=QMF Resource Limit


            


Leave a Reply

Your email address will not be published. Required fields are marked *