View previous topic :: View next topic
|
Author |
Message |
mpawan Warnings : 2 New User
Joined: 03 Nov 2008 Posts: 42 Location: Pune
|
|
|
|
I have coded a JCL to Bind my programs. Following is the code.
//SM0019A JOB (XT00),'DB2BINDA',SCHENV=BSYS,
// MSGLEVEL=(1,1),MSGCLASS=H,NOTIFY=&SYSUID
/*ROUTE PRINT LOCAL
//BIND EXEC PGM=IKJEFT01
//STEPLIB DD DSN=SYS2.TOLLMTC.PRODLOAD,DISP=SHR
// DD DSN=DB24.REF.SDSNLOAD,DISP=SHR
// DD DSN=DB24.REF.SDSNEXIT,DISP=SHR
// DD DSN=SYS1.SCEERUN,DISP=SHR
//DBRMLIB DD DSN=CMN.TOLE.STGR.#000246.DBR,DISP=SHR
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTSIN DD DUMMY
//SYSIN DD DSN=TOLLNA.T.TEST.DB2(SUBRAT),DISP=SHR
TOLLNA.T.TEST.DB2(SUBRAT)
DSN SYSTEM(DB22)
BIND PLAN(SUBRATDB) -
MEMBER(DB2TABLE) -
OWNER(DB2C202) -
QUALIFIER(DB2C202) -
ACTION(ADD) -
ISOLATION(CS) -
RETAIN -
ACQUIRE(USE) -
EXPLAIN(YES) -
VALIDATE(BIND) -
FLAG(I) -
RELEASE(COMMIT)
when i execute my JCL it gives a RC=0
But when i am chekin in my DB2 for the plan name SUBRATDB through DB2 system catalog i am not able to see my plan name?
Can you tell where i am getting wrong?? |
|
Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
|
|
It would help if we could see ALL of your output (SYSTSPRT is the important one I think). |
|
Back to top |
|
|
mpawan Warnings : 2 New User
Joined: 03 Nov 2008 Posts: 42 Location: Pune
|
|
|
|
READY
BIND PLAN(PAWAN) OWNER(DB2C202) MEMBER(DB2TABLE) LIBRARY('CMN.TOLE.STGR.
IND) ISOLATION(CS) RETAIN ACQUIRE(USE)
RELEASE(COMMIT)
COMMAND BIND NOT FOUND
READY
DSN SYSTEM(DB24) RETRY(3)
DSN
END
READY
END |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8697 Location: Dubuque, Iowa, USA
|
|
|
|
Quote: |
COMMAND BIND NOT FOUND |
I would have thought this error pretty self evident. You need to contact your site support group and have them give you the JCL to use. You've obviously coded up something wrong and since this is site specific data, you're probably not going to be able to resolve this here -- only by contacting your site support group. |
|
Back to top |
|
|
wanderer
Active User
Joined: 05 Feb 2007 Posts: 199 Location: Sri Lanka
|
|
|
|
DB2 commands like BIND that run through TSO go to DD SYSTSIN, not SYSIN. Try that.
I am surprised with the output you have shown. The way u have run it SYSTSPRT shouldn't have anything. The output u gave is not for the JCL you gave earlier.
In JCL you have,
DSN SYSTEM(DB22)
In output u showed,
DSN SYSTEM(DB24) RETRY(3)
Besides as per output, you are executing BIND before DSN interface.
It is a good idea to read up DB2 manual on bind, Command Reference before trying randomly. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
I have coded a JCL to Bind my programs. |
Well, i strongly suggest you discard this. . .
Compile &/or link &/or bind jcl should not be created by the developer(s). There is standard jcl already installed and it should be used. |
|
Back to top |
|
|
|