Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006
    Posts
    2

    Unanswered: Contents of DB2 Packages

    Hi to all!

    I am new to DB2 UDB and I have some problems with invalid packages. I am working on a project that was started by other people before I joined them. Several packages fail to rebind with the REBIND PACKAGE statement or the db2rbind tool. I need a way to determine what procedures or triggers these packages contain because I often receive errors of this type: "SQL0101N The statement is too long or too complex. SQLSTATE=54001".
    Can anyone help me?

    Thanks

  2. #2
    Join Date
    Nov 2003
    Location
    Netherlands
    Posts
    96
    Hi,

    You can use the db2bfd tool to display these SQL statements.

    Regards, Gert

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11

    msg

    SQL0101N The statement is too long or too complex
    means a problem with applheapsz
    this parameter should probably be increased
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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