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

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

//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

Srini

Data Engineer with deep AI and Generative AI expertise, crafting high-performance data pipelines in PySpark, Databricks, and SQL. Skilled in Python, AWS, and Linux—building scalable, cloud-native solutions for smart applications.