Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2014
    Posts
    2

    Unanswered: Query Source Code

    Silly question but I heard once that there was a way to query source code, is that possible? If so how?

  2. #2
    Join Date
    Feb 2012
    Posts
    23
    Could you explain what you mean by source code? Do you mean f.i. query the definition (source) of a trigger or stored procedure?

  3. #3
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    Do you perhaps think you may be referring to the different tables that get populated during explain? They contain all the info in regards to how you access tables, the DSN_PREDICAT_TABLE contains a ton of info, that you can mine looking for easy to fix performance issues.
    Dave

  4. #4
    Join Date
    Jul 2014
    Posts
    2

    Follow up

    Sorry for the delay, but I mean the source code of the programs themselves.

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by Syntastic View Post
    Sorry for the delay, but I mean the source code of the programs themselves.
    DB2 has the source code stored procedures, triggers, etc. It also has the SQL for other programs stored in statement cache (but not necessarily permanently).

    I don't know what you mean by "query" the source code of programs. If you load the source code into a DB2 table, you can use text searches.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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