Contents of DB2 packages

[iliev]

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

 

[sathyarams]

If you have the bind files, you can use db2bfd command ..

If you do not have the bind files, SYSCAT.STATEMENTS should have a list of all statements.

SYSCAT.PACKAGEDEP (and other DEP views) may also give information on the dependencies

HTH
Sathyaram


For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8

&

http://www.idug.org/user/UserLogin.asp