How to Run DB2 SPUFI in Batch JCL

SPUFI using DB2I online utility is popular. I am sharing a sample JCL to run DB2 SPUFI in batch mode.


Photo by Matt Hardy on Pexels.com

How to Work with SPUFI DB2I Utility

The alternative way to run SPUFI in online method.

Sample JCL to Execute DB2 SPUFI in Batch Job

Source IBM: Refer here for more.

//RUNTEP2 EXEC PGM=IKJEFT01,DYNAMNBR=20
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
 DSN SYSTEM(DSN)
 RUN PROGRAM(DSNTEP2) PLAN(DSNTEP81) -
 LIB ('***.RUNLIB.LOAD') 
//SYSPRINT DD SYSOUT=
//SYSUDUMP DD SYSOUT=*
//SYSIN DD *
 SELECT * FROM SYSIBM.SYSTABLESPACE
/*

Related Posts

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.