Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2012
    Posts
    3

    Red face Unanswered: Db2 z/os Bind error

    We are getting the below error when we do BIND PLAN with the application DBRMs in the our production system.

    DSNT208I -DSNP PROGRAM CTM10TRN PRECOMPILED WITH INCORRECT LEVEL FOR
    THIS RELEASE

    The DBRMs for this BIND were generated in a system which is in CM Mode of DB2 v10 version and copied here.

    The same BIND ran fine in other two test systems ( which also has DB2 v9 ) with the same program.We have cross checked everything from our application side in Programming point of view and we don't see anything different from the code which we implemented in our test and prod. But it worked for other prod systems related to our application as they both have DB2 v9 installed and not upgraded to v10.

    Could you please help us with some justification of area which we need to look into and also on what basis we can get this issue resolved or do we need to concentrate on system related parameter ?

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    You did read in which Forum you posted this? This (sub-)forum is for PostgreSQL which does not have anything in common with IBM's DB2 database.
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    With a thread relocation from your friendly neighborhood DBForums Administrator!

    -patP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  4. #4
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    Please refer to the reply to your other topic with the same question.

Posting Permissions

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