IKJEFT01 Run DB2 Program

IKJEFT01 utility is used to run the DB2 program. The program should have bound successfully to the DB2 plan in the system before executing the program.

Syntax -

...
//STEP01 EXEC PGM= IKJEFT01
//SYSTSIN DD *
DSN SYSTEM (db-system-name)  			 
  RUN PROGRAM   (db2-prog-name) - 		 
      PLAN      (db2-plan-name) -  	 
      LIBRARY   ('program-load-library') 	
END                                
/*
...

Practical Example -

Scenario - JCL to execute program (SELECT1) using IKJEFT01 utility.

RUN JCL -

----+----1----+---2---+---3---+----4---+---5---+
...                                           
//STEP01   EXEC PGM=IKJEFT01,
//             DYNAMNBR=20,REGION=4096K
//STEPLIB  DD  DISP=SHR,DSN=DSNA10.DBAG.SDSNEXIT
//         DD  DISP=SHR,DSN=DSNA10.SDSNLOAD
//SYSTSIN  DD  *
  DSN SYSTEM (DBAG)
  RUN PROGRAM   (SELECT1)  -
      PLAN      (MATEPKA ) -
      LIBRARY   ('MATEPK.COBDB2.LOADLIB')
END
/*
...