DB2

DB2 is an abbreviation for IBM Database 2 and was launched in June 1983 as a subsystem on MVS that allowed MVS users to build, access, and maintain relational databases using the well known Structured Query language (SQL).

Since then, DB2 has come a long way and provides facilities to exploit the latest hardware and software technologies, accommodating a majority of user requirements. The latest versions are available on almost all platforms, including Windows, HP-UX, Sun Solaris, Unix, AIX, NUMAQ, Linux, AS/400 and OS/390.

As the name suggests, DB2 "Universal Database" provides universal data types, universal integration, universal access from clients of all types, universal applicability (for all types of applications), universal scalability (across all types of platforms), universal reliability (for non-stop 24/7 processing) and universal manageability.

The ability to manage many concurrent users, very large databases, high transaction rates and deliver consistent rapid response is fundamental and delivered by DB2 through the wide range of platforms and the exploitation of platform-specific features. Beyond this, DB2 meets the requirements for high availability, low planned maintenance, wide connectivity, open standards and effective manageability.

Job Entry Subsystems:

Job Scheduler:

JES is an MVS component which keeps track of jobs that enter the system. The job entry subsystem also called as JES in short is used by MVS operating system. The JES is the component which presents jobs for MVS processing and sends the job’s spooled output back to the correct destination. A JOB is the execution of one or more related programs in sequence. Each program to be executed by a JOB is called a JOB STEP.

Types of JES:

There are two main types in this as given below:

HASP:

This is the acronym for Houston Automatic Spooling Program. It is otherwise called as JES2.

ASP:

This is the acronym for Asymmetric Multiprocessing system. It is otherwise called as JES3. This system is more suitable for shops with more than one processor.

It is vital that a user must know that each MVS system can use JES2 or JES3 but not both.

Job management of MVS:

The task of job management of MVS is taken care by two main resources:

JES and

Base control program of MVS.

Here the former job entry subsystem also called as JES in short takes up the task of managing jobs before and after running the program. The latter base control program takes the task of managing the job during processing.

General Phases in a Job:

The phases through which a job generally flows through starting from input stage till final stage are given below:

Input

Conversion

Processing

Output

Print

Purge

Input:

The HASP otherwise called as JES2 accepts jobs as input stream. The ability of JES2 is to accept multiple jobs at the same time. Before JES2 accept the jobs it is obvious that user has to submit the jobs. This process of submitting jobs can be done using programs and commands to JES2.We will see about commands in JES2 in detail in our coming sections. The jobs submitted is accepted as input stream by JES2 and a job identifier given to each JOB JCL statement with all jobs, JCL commands and statements being placed in spool data sets from which job is selected by JES2 for further processing.

Conversion:

In the process the jobs are processed and fine tuned for execution. That is to say in detail JES2 uses converter program which associates the JCL statements placed in JOB statement with JCL in procedure library. This merged JCL is then converted into a combined JCL as text by JES2. If there is no errors detected in JCL by JES2 the jobs are queued in spool date set for further processing and execution. If errors were detected by JES2 then appropriate messages are placed and the job is queued for processing and not for execution.

Processing:

In this the jobs that were placed in the previous phase in the jobs queue are taken by JES2 and sent to initiators and these are defined using JES2 initialization statements which we will see in detail in our JES2 commands section. The processing by initiators is based on various priorities of class assigned and the priority of queued jobs.

Output:

All the output produced in system by jobs also called as SYSOUT in short is controlled and monitored by JES2. In this phase the output activities like printing of datasets, output device handling, system messages to be outputted are all handled by JES2.The dataset which is to be outputted having same characteristics are grouped together by JES2 for printing.

Print:

In this phase the output dataset generated by earlier output phase are processed by JES2. Here the output is selected for processing by JES2 based on priority, output class mentioned on JCL. After JES2 process the output of job it places the job in purge queue for next phase to take over.

Tso Commands

ABCODE - DISPLAYS COMMON ABEND CODES AND POSSIBLE FIXES
ACCMCHK1 - DISPLAYS ACCOUNTING INFORMATION (INFO IN JOB CARD)
ACCTHELP - GIVES: GLSUM,COST CTR,CUST CODE,APPL ID'S,SYS CDDE,ACCESS CODE ACESHIST - BROWSE ACES INFORMATION FROM ORIGINAL ACES SYSTEM
ACF - DISPLAYS YOUR TSO LOGON RULES INFORMATION (AT ? ENTER L * )
ACFHELP - DEFINITIONS/EXAMPLES ARE GIVEN WHEN USING 'ACFRULE'
ACFRULE - USED TO DEFINE RULES ON WHAT OTHERS CAN DO TO YOUR DATASETS/PDS
BPRINT - USE TSO BPRINT TO PRINT THE DATASET YOU ARE CURRENTLY BROWSING BRCLIST - BROWSE ALL DATASETS THAT CONTAIN THIS CLIST (REXX)
BRLINK - BROWSE ALL LINK LIBRARY DATASETS THAT CONTAIN THIS MEMBER BRMLIB - BROWSE ALL ISPMLIBS THAT CONTAIN THIS MEMBER
BROBJLB - BROWSE ALL OBJECT LIBRARY DATASETS THAT CONTAIN THIS MEMBER BRPLIB - BROWSE ALL PANEL LIBRARY DATASETS THAT CONTAIN THIS MEMBER BRPROC - BROWSE ALL PROC LIBRARY DATASETS THAT CONTAIN THIS MEMBER BRPSBLIB - BROWSE TEST PSBLIB
BRSLIB - BROWSE ALL SKELETON LIBRARY DATASETS THAT CONTAIN THIS MEMBER CALCU - USED TO DO SIMPLE CALCULATIONS (ADD, SUB, MULT AND DIVIDE) CAWRITER - LIST OF CA-DISPATCH UNIVERSAL WRITER NAMES AND DEFINITIONS CA7 - INVOKE JOB SCHEDULE PRODUCT (CA-7 PRIMARY OPTION MENU)
CA7HIST - VIEW UP TO 14 MONTHS OF JOB EQUEST HISTORY
CA7LOOK - SHOWS ALL CONTROL-M RUN REQUESTS SUBMITTED FOR TODAY
CA7REQ - USED TO SCHEDULE HOST JOBS AT AUBRUN HILLS
CHAMPDOC - DOCUMENTATION OUTLINING CHAMP RELATED QUESTIONS CHAMPRPT - BROWSE CHAMP DAILY MOVE REPORT,UP TO LAST 5 DAYS OF INFORMATION CMI - CNTLM JOB SCHEDULES BY JOB
CMPOST - WILL HELP YOU CATALOG UP ROUND REEL TAPES
CMPOSTC - WILL HELP YOU CATALOG UP CARTRIDGE TAPES
CMR - CNTLM JOB PERFORMANCE REPORTING SYSTEM, STATS FOR EXECUTED JOBS COMPARE2 - USE ISPF OPTION 3.13 TO MAKE COMPARES
COUNT - EXECUTE THE LINES OF CODE COUNTER (SLOC COUNTER)
CSPACE - CALCULATES THE NEEDED ALLOCATIONS FOR DASD BASED ON INPUT INFO DBADOCSE - DBA DOCUMENTATION OF INTEREST TO AN INFORMATION ANALYST DBAPROC - DEFINITION OF "DBA'S" RESPONSIBILITIES AND SUPPORT PROCEDURES DBAREQ - USED TO REQUEST: INCLUDE MOVES, DVAN, PSB (NUCREQ) AND MISC DBASE - DISPLAYS DBA CONTACTS BY AREA THAT THEY SUPPORT
DBCHANGE - INITIAL DBA NOTIFICATION PANEL FOR DATABASE CHANGES
DBCREATE - USED TO CREATE A COPY OF A TEST DATABASE IN YOUR CATALOG DBMAP - DISPLAYS A "PSB" MAP OF A PROGRAM OR A "DBD" MAP OF A DATABASE DB2TIPS - TIPS ON SETUP,CODING,TESTING,CONVERTING TO DB2 DATA BASES DISASTER - UPDATES RECOVERY PRIORITIES FOR JOBS AND ONLINE IMS PGMS DISPDESC - DISPLAYS A DESCRIPTION AND OWNER FOR DATABASES
DPRINT - USE DPRINT TO PRINT A DATASET FROM A LISTING
DRARPTS - BROWSE DRA BACKUP REPORTS FOR CURRENT AND 4 WEEKS BACK DSNREST - BROWSE LETTER TO COMMUNITY ON HOW TO RESTORE FROM DRA BACKUPS DVANJCL - CREATES JCL TO RUN TEST DATAVANTAGE AS A BMP OR IN A DLI REGIONDVANREQ - CREATE A DATAVANTAGE REQUEST FOR THE DBA GROUP TO PROCESS DVBTS - ALLOWS DATAVANTAGE TO BE EXECUTED IN "BTS" FOR UP TO 3 DB'S EPRINT - USE EPRINT TO PRINT THE DATASET YOU ARE CURRENTLY EDITING FATIPS - FILE AID TIPS FOR REFRESH 97 VERSION GDG - BUILD OR DELETE GDG BASES GENPSB - WILL GEN A PSB FROM THE PROD PAN LIB TO VERSION 1 PSBLIB ONLY GSAMB37 - HOW TO PREVENT BLOCK ERRORS WHEN COPYING GSAM FILE FOR RESTART HOLDJCL - VIEW A JCL MEMBER IN ENDEVOR HOLD
HOLDSORC - VIEW A SOURCE CODE MEMBER IN ENDEVOR HOLD
IMFTS - INVOKE BOOLE AND BABBAGE
IMSCHKPT - ALLOWS INQUIRY/UPDATE OF CHECKPOINT LIMIT/NUMBER AND RUN NUMBERINCREQ - REQUESTS DATABASE INCLUDE MOVE TO PRODUCTION OR TEST INITIAL - SET YOUR "BIN" AND "ACCT CODE" FOR OTHER CLISTS TO USE
IPACT - DISPLAYS IPACS INFO FOR A GIVEN JOB, PGM OR ACCESS CODE
IPCABEND - BROWSE UPTO 6 DAYS OF THE DAILY AHIPC MORNING REP FOR PROB IPCPROB - BROWSE THE AHIPC PROBLEM TICKET FILE AND THE OPEN TICKET STATUSIPCUSER - BROWSE/PRINT IPC USER GUIDE(VOL5), STDS FOR OUR ACCT., ETC; ISPFTIPS - REFRESH 97 ISPF TIPS AND ENVIRONMENT SETTING CHANGES JCLFORM - FOR NEW JCL OR NEW STEPS: THIS WILL REFORMAT THE JCL TO STDS
JCLX - THIS SHOWS ALL DATASETS (IN SEQ) AND THE JOBS THAT USE THEM
JOBHIST - SHOWS WHEN A JOB WAS STARTED, COMPLETED, CPU/REAL TIME, ETC;
LA - DISPLAY THE NAMES OF LIBRARIES CURRENTLY ALLOC TO YOUR LOGON ID LIMITCHG - DISPLAYS CHECK POINT LIMIT CHANGES FOR THE LAST 7 DAYS LINKDATE - DISPLAY LINKDATE FOR A GIVEN MEMBER FROM A SPECIFIC LIB
LISTA - LISTA ST H - LISTS ALL ALLOC DATASETS AND THEIR HISTORY INFO
LISTA - USED TO DISPLAY THE NAMES OF CURR ALLOC DATASETS TO YOUR ID LISTBC - USED TO LIST MESSAGES SAVED IN THE BROADCAST DATASET
LISTC - LISTS ENTRIES FROM EITHER THE MASTER OR USER CATALOG
LISTC1 - EX. LISTC EN('F.F133152') ALL - WILL LIST MAX. ENTRIES ALLOWED
LISTC2 - EX. LISTC VOL - WILL LIST YOUR CATLG & VOLUMES DSN'S RESIDE ON
LISTD - DISPLAYS BASIC ATTRTIBUTES OF DATASET SPECIFIED
LISTD1 - LISTD 'SYS2.TESTLIB(B0450)' - WILL DISPLAY PROGRAM LINK INFO
LJOB - DISPLAY CA7 SCHEDULE INFO FOR THE JOB ENTERED
LOCKOUT - THIS CROSS-REF IS GIVEN IN: JOB, DATABASE, PROGRAM AND SEG SEQ LOGONID - BROWSE FILE FOR TSO LOGON ID'S(UID,FULL NAMES,LAST DATE USED) MFSTEST - USED TO LINK OUT MFS SCREENS FROM PROD, TEST OR YOUR CATALOG MFS3270 - USED TO CREATE/LINK NEW MFS SCREENS FROM YOUR CATALOG MISCREQ - MISCELLANEOUS DBA REQUEST PANEL
MSG - THIS COMMAND SENDS A MULTI LINE MESSAGE TO A TSO ID
MSGSEND - THIS COMMAND SENDS A MULTI LINE MESSAGE TO A TSO ID
NEWIPACS - SETS UP FILES FOR RUNNING IPACT CLIST
NOTCOMP - GENERATE A REPORT OF PROGRAMS NOT COMPILED FOR SPECIFIC SEG NOTIFY - ASSIGN PROGRAMMERS TO A PGM SO OPERATIONS CAN CALL ON ABENDS OQACCLOC - VIEW DATASET OF CHANGED SOURCE LINES OF CODE COUNTS
OQACDB2 - ID FOREIGN KEY TABLES FOR DB2 TABLE-CREATE FILE FOR ISEE MVSWB OQACDB2U - UNLOAD DB2 TABLE W/ DSNTIAUL UTIL.-CREATE FILE FOR ISEE MVSWB OQACEJCL - EDIT ACCOUNT SUPPORT GROUPS ENDEVOR JCL LIBRARY
OQACERPT - BROWSE ENDEVOR MASTER CONTROL FILE - ELEMENT CATALOG REPORT
OQACIMSQ - VIEW IMS DISPLAY Q INFORMATION
OQACJCL - EDIT ACCOUNT SUPPORT GROUPS JCL LIBRARY-EX: FILEAID SCAN JCL PANXREF - SHOWS "EVERY" INCLUDE (DB & PGM) AND "EVERY" PGM THAT USES IT PDSCMP - COMPRESS A PDS IN SHARE MODE PEEK - RUN PEEK EVALUATION SYSTEM - PL/I ONLY - COMPLEXITY EVALUATION
PGMTBLX - LIST ALL DB2 TABLES USED BY THE SPECIFIED PROGRAM
PRESTORE - COPIES AN UNCATLG PRODUCTION DATASET FROM DASD INTO YOUR CATLG
PRINTQIP - PRINT VARIOUS QIP GROUP RESULTS, INCLUDING THE ACES SYSTEM PRODDBIC - ALLOWS YOU TO VIEW DATABASE INCLUDES FROM PWDDB.COBOL.INCLUDES
PRODDBIP - ALLOWS YOU TO VIEW DATABASE INCLUDES FROM PWDDB.PLI.INCLUDES
PRODINCL - VIEW AN INCLUDE MEMBER IN ENDEVOR PRODUCTION
PRODJCL - VIEW A JCL MEMBER IN ENDEVOR PRODUCTION
PRODSORC - VIEW A SOURCE CODE MEMBER IN ENDEVOR PRODUCTION
PROGXREF - GENERATE A REPORT OF PGMS AFFECTED BY DATABASE SEGMENT CHANGES
PRTCUT - PRINT REQUEST TO CUT SHEET FORMS(LETTER) AT SPO C.O.
PRTDOC - PRINT INFO. ON MFS, DATAVANTAGE, IMS CMDS, CHKPT, DESIGN REV PRTFTD - PRINT REQUEST AT FLINT PRINT CENTER IN 1UP FORM
PRTJCL - PRINT REQUESTED "JCL" FROM PWDS1.SPOCH.JCLPAN
PRTLJOB - PRINT ON PC LPT1 PRINTER-CA7 SCHEDULE INFO FOR THE JOB ENTERED PRTMIN - PRINT REQUEST TO MINIMUM PRINT AT SPO C.O.
PRTTRD - PRINT REQUEST TO AT TROY OUTPUT CENTER
PRT2UP - PRINT REQUEST AT FLINT PRINT CENTER IN 2UP FORM
PSBREQ - REQUEST PSB GENERATION FOR PRODUCTION AND TEST
RECEIVE - RECEIVE A DATASET FROM ANOTHER TSO ID
RESET - USED TO LOAD NEW/CHANGED ACF RULES WITHOUT LOGGING OFF
RESTORE - RESTORES YOUR OWN ARCHIVED DATASET/PDS BACK INTO YOUR CATALOG RFSJCL - BUILDS CHECKPOINT RESTART JCL IN YOUR CATALOG FOR A PROGRAM SCAN - USED TO SUBMIT A SCAN AGAINST PROD, TEST OR JCL LIBRARIES SCANOUT - USED TO BROWSE THE DATASET CONTAINING THE RESULTS OF YOUR SCAN SCHEDULE - LIST THE AUBURN HILLS SPO SCHEDULING CONTACT NAMES AND NUMBERS SECINFO - VARIOUS DOCUMENTATION ON SECURITY ITEMS OF INTEREST TO SPO SETERMS - DISPLAYS DEFINITIONS OF TERMS AND ACRONYMS FOR SPO ACCOUNT SMR - SYSLOG MANAGEMENT AND RETRIEVAL
SPACE - CALCULATES SPACE REQUIRED FOR DATA BASES BASED ON BLOCK SIZE START - USED TO START UP A PROGRAM/TRANSACTION ON IMST THAT IS STOPPED TAPERECS - CALCULATES THE NUMBER OF RECORDS ON A TAPE
TBLPGMX - LIST PROGRAMS THAT USE THE SPECIFIED DB2 TABLE,VIEW,SYSTEM CODE
TCOMP2 - USED TO LINK OUT PROGRAMS FROM PROD, TEST OR YOUR CATALOG TESTINCL - VIEW AN INCLUDE MEMBER IN ENDEVOR TEST
TESTJCL - VIEW A JCL MEMBER IN ENDEVOR TEST
TESTSORC- VIEW A SOURCE CODE MEMBER IN ENDEVOR TEST
TIME - DISPLAY CURRENT SYSTEM DATE AND TIME
TLSINQ - VIEW THE TAPE LIBRARY LISTING IN DATASET OR VOLUME SERIAL SEQ TRACE - USED TO TRACE A JOB IN IMSTEST (BMP OR TRANSACTION)
TRANCNTS- SHOWS TRANS. PER MONTH (D8806=JUNE 88) AND # OF TIMES USED TRANSMIT- TRANSMIT A DATASET TO ANOTHER TSO ID
TRANSMI1- EX..TRANSMIT (IPCNODE.HIGHLEVEL) DATASET (DSN)
TRANSMI2- EX..TRANSMIT (PLIPC4B.PDSJBTD) DATASET ('USERID.PLI.STDS')
VSPACE - CALCULATES SPACE REQUIRED FOR DATA BASE INDEXES
WAAPLNKL- LIST DATASETS CONTAINED IN THE LINKLIST
WHEREIS - ISPSLIB MEMBER - FIND DATASET THAT CONTAINS SKELETON MEMBER WHEREIS - ISPPLIB MEMBER - FIND DATASET THAT CONTAINS PANEL MEMBER WHEREIS - SYSEXEC MEMBER - FIND DATASET THAT CONTAINS REXX MEMBER WHEREIS - SYSPROC MEMBER - FIND DATASET THAT CONTAINS CLIST MEMBER WHEREIS - LINKLIST MEMBER - FIND DATASET THAT CONTAINS LINKLIB MEMBER WHEREIS - ISPMLIB MEMBER - FIND DATASET THAT CONTAINS MESSAGE MEMBER WHEREPGM- MEMBER - LOCATES ALL PROGRAM LIBRARIES THAT CONTAIN MEMBER WHEREPSB- MEMBER - LOCATES ALL PSB LIBRARIES THAT CONTAIN MEMBER

IMS DL/I Codes

Dli-Function Code’s : 4 byte function code describing the type of requested service.
GU ----------à Get Unique
GN ----------à Get Next
GNP ----------à Get Next Within Parent
GHU ----------à Get Hold Unique
GHN ----------à Get Hold Next
GHNP ----------à Get Hold Next Within Parent
ISRT ----------à Insert
DLET ----------à Delete
REPL ----------à Replace
CHKP ----------à Check point
XRST ----------à Restart