Maintaining CA CSM › CA CSM Backup and Disaster Recovery › How You Back Up CA CSM › JCL for Executing SQL Statements

JCL for Executing SQL Statements

The following sample is an example of JCL that you can submit to run the SQL statement that discovers the content of the mountpoint table:

//*****************************************************************************
//*****************************************************************************
//*                                                                           *
//*JOBLIB DD DSN=HLQ.CUSLIB replace HLQ with HLQ of your CA CSM installation  *
//*          DSN=HLQ.CAAXLOAD replace HLQ with HLQ of your CA CSM installation*
//*                                                                           *
//*****************************************************************************
//*****************************************************************************
//B2UP     OUTPUT DEST=LOCAL,JESDS=ALL,DEFAULT=Y,
//         PAGEDEF=32D3,CHARS=GT20,FORMDEF=P2B111
//JOBLIB   DD DSN=HLQ.CUSLIB,
//         DISP=SHR
//         DD DSN=HLQ.CAAXLOAD,
//         DISP=SHR
//         DD DSN=SYSDEV.CCS.LINKLIB,
//         DISP=SHR
//         DD DSN=CEE.SCEERUN,DISP=SHR
//         DD DSN=CEE.AIGZMOD1,DISP=SHR
//*
//SQLEXEC  EXEC PGM=DBSQLPR,
//       PARM='prtWidth=1500,inputWidth=80'
//SYSUDUMP DD  SYSOUT=*
//SYSPRINT DD  SYSOUT=*
//STDERR   DD  SYSOUT=*
//STDOUT   DD  SYSOUT=*
//OPTIONS  DD  *
AUTHID=CASWMGT
/*
//SYSIN    DD  *
   SELECT MP_DATASET
   FROM MOUNTPOINT WHERE NOT MP_TYPE='PRODUCT' OR MP_TYPE IS NULL;
/*

The following sample is a fragment of output that you receive after submitting the JCL for discovering the content of the mountpoint table:

Command Line Options
____________________
INPUTWIDTH=80
PRTWIDTH=1500
Option File Options
___________________
AUTHID=CASWMGT
INPUT STATEMENT:
SELECT MP_DATASET
   FROM MOUNTPOINT WHERE NOT MP_TYPE='PRODUCT' OR MP_TYPE IS NULL;
MP_DATASET
VARCHAR(45)
______________________________________________
OMVSUSR.CAMSM.APLROOT
OMVSUSR.CAMSM.LJWK
OMVSUSR.CAMSM.MSMT1
OMVSUSR.CAMSM.MSMT3
...

The data sets that are returned after the input statement are the data sets that you have to back up:

OMVSUSR.CAMSM.APLROOT
OMVSUSR.CAMSM.LJWK
OMVSUSR.CAMSM.MSMT1
OMVSUSR.CAMSM.MSMT3