Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2015

    Unanswered: How to find the line of code and the size of SPs and UDF

    Hi All,

    I am a newbie to DB2. Could someone tell me on which catalog tables holds the size of all the procedure/function in db2.


  2. #2
    Join Date
    Apr 2012
    Provided Answers: 17
    You need to study the on-line Knowledge centre for your version of DB2 , because that can be faster than waiting for someone to reply to your question, and it can also help you to phrase your question more precisely.

    Not sure what you mean by "size" - do you mean lines of code, or package-size at run time, or something else?

    In DB2, procedures can be written in various programming languages such ash SQL PL or PL/SQL or C or C++ or java etc.

    procedures written in SQL PL or PL/SQL are stored in the database and syscat.routines and syscat.procedures are helpful starting places, as is syscat.packages.

    procedures written in other languages are not stored in the database, but instead are files on some file system, so their size is based on the file size.

    Same for functcions, they can be written in SQL, see syscat.routines and syscat.packages, or the functions can be external (files in some file system).

Posting Permissions

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