Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2010
    Posts
    33

    Question Unanswered: BIND plan for Collection ID error

    Hi,

    I am trying to bind a plan to a collection ID but I am ending up with error, but not sure where Exactly is the error.

    My JCL :
    //BINDPLAN JOB MSGCLASS=X,MSGLEVEL=(1,1),CLASS=T,
    // REGION=5M,NOTIFY=&SYSUID
    //STEP1 EXEC PGM=IKJEFT01
    //SYSTSPRT DD SYSOUT=*
    //SYSTSIN DD *
    DSN SYSTEM(DSN1)
    BIND PLAN(TKOPL012) -
    ACTION(REPLACE) -
    PKLIST(COTKOL01.*) -
    LIBRARY('A251806.PLAN.LOAD') -
    MEMBER(TKOPL012) -
    ISOLATION(CS) -
    RELEASE(COMMIT) -
    VALIDATE(BIND) -
    OWNER(IBMUSER) -
    QUALIFIER(A114715) -
    RETAIN
    END


    Error :

    //BINDPLAN JOB MSGCLASS=X,MSGLEVEL=(1,1),CLASS=T,
    // REGION=5M,NOTIFY=&SYSUID
    //STEP1 EXEC PGM=IKJEFT01
    //SYSTSPRT DD SYSOUT=*
    //SYSTSIN DD *
    DSN SYSTEM(DSN1)
    BIND PLAN(TKOPL012) -
    ACTION(REPLACE) -
    PKLIST(COTKOL01.*) -
    LIBRARY('A251806.PLAN.LOAD') -
    MEMBER(TKOPL012) -
    ISOLATION(CS) -
    RELEASE(COMMIT) -
    VALIDATE(BIND) -
    OWNER(IBMUSER) -
    QUALIFIER(A114715) -
    RETAIN
    END
    READY
    DSN SYSTEM(DSN1)
    DSN
    BIND PLAN(TKOPL012) ACTION(REPLACE) PKLI
    .LOAD') MEMBER(TKOPL012) ISOLATION(CS)
    ) QUALIFIER(A114715) OWNER(IBMUSER)
    DSNX200I -DSN1 BIND SQL ERROR
    USING IBMUSER AUTHORITY
    PLAN=TKOPL012
    DBRM=TKOPL012
    STATEMENT=45
    SQLCODE=-204
    SQLSTATE=42704
    TOKENS=A114715.PRODUCT
    CSECT NAME=DSNXOTL
    RDS CODE=-500
    DSNT201I -DSN1 BIND FOR PLAN TKOPL012 NOT SUCCESSFUL
    DSN
    END
    READY
    END

    Please guide me.

    Regards,
    Jags

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    You get an error -204: DB2 10 - Codes - SQLCODE -204

    One of the objects referred to in the statement does not exist. The TOKENS output tells you which object is missing. That's A114715.PRODUCT in your case, most probably a table. I guess you haven't created all the objects that are needed for the plan.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •