Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433

    Unanswered: db2expln for procedure

    Using db2expln first time for packages.
    It works fine when there are tables however it fails whenever it has reference to GTT....
    How are access plans created in case of GTT's ......
    Didn't get what Incremental Bind is ?

    -------------------- SECTION ---------------------------------------

    Section = 15





    Statement:

    VALUES(

    (Select Count(*)

    from SESSION.TEMP_PUPILDETAILS))INTO :HV00025 :HI00025

    Incremental Bind Section
    Error revalidating section:
    SQL0727N An error occurred during implicit system action type "5".


    Information returned for the error includes SQLCODE "-204", SQLSTATE


    "42704" and message tokens "SESSION.TEMP_PUPILDETAILS". SQLSTATE=00000




    -------------------- SECTION ---------------------------------------
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    SQLCODE -204 is for an undefined name. The system does not know what the GTT is. Try defining it first.

    Andy

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    The problem is that db2batch establishes a new connection to DB2. Thus, it cannot know anything about the GTT you may have defined in another connection.
    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
  •