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