Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2008
    Posts
    44

    Unanswered: Invalid routines in DB2 system schemas

    When I do -
    Code:
    db2 "SELECT ROUTINESCHEMA, ROUTINENAME FROM SYSCAT.ROUTINES WHERE VALID <> 'Y'"
    in my database, I am getting many routines from SQLJ, SYSCAT, SYSFUN, SYSIBM, SYSPROC schemas as Invalid.

    What could have invalidated these routines & How can I make them valid? Thanks.

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    What were the values of VALID column?

    DB2 9.7 for LUW SQL Reference, Volume 1
    Appendix D. System catalog views
    SYSCAT.ROUTINES
    Column Name: VALID
    Description:
    Applies to LANGUAGE = 'SQL' and routines
    having parameters with default; blank otherwise.
    v N = Routine needs rebinding
    v X = Routine is inoperative and must be recreated
    v Y = Routine is valid
    Last edited by tonkuma; 06-07-11 at 13:52. Reason: Add Description for N,X,Y

  3. #3
    Join Date
    Dec 2008
    Posts
    44
    I have blank as value for Valid column. So, they are indeed valid routines. Thanks Tonkuma for pointing it out.

Posting Permissions

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