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?
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