Helo, Can anybody explain me-- Wha 1

[solanki123]

Helo,
Can anybody explain me-- What is the use of IKJEFT01(DB2 utility).How we use it.Please explain me all the steps in detail because I am quite new in DB2.I am in urgent need of it.Please help anybody.

 

[sathyarams]

IKJEFT01 as far as I remember is used to run TSO commands from JCL ... It has nothing to do with DB2 ..

Cheers

Sathyaram

More DB2 questions answered at

http://www.dbforums.com/f8

 

[solanki123]

Helo Sathyaram,
Can you please explain me how to use IKJEFT01,by giving example.

Regards

 

[gregsimpson]

solanki123,

DB2 batch programs are executed in the background under the control of the TSO terminal monitor program. A TSO session is therby created in batch. The DSN command is invoked by this session through input specified in the SYSTSIN dataset.

Below is an example of how to run your DB2 program. You will no doubt need to customise for your site.

//DB2JOBB JOB (BATCH), 'DB2 BATCH',MSGCLASS=X,CLASS=X
// NOTIFY=USER
//*
//*
//JOBLIB DD DSN=SYS1.DB2V510.DSNLOAD,DISP=SHR
//BATCHPRG EXEC PGM=IKJEFT01,DYNAMNBR=20
//SYSTPRT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB2P)
RUN PROGRAM(PROG0001) -
PLAN(PLAN0001) -
LIB('APPL.LOAD.LIBRARY')
END
/*
//

Cheers
Greg