Invalid routines in DB2 system schemas

rajaraja_cholan · #1 (**permalink**) 06-07-11, 12:15

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.

tonkuma · #2 (**permalink**) 06-07-11, 12:38

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:

Quote:

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

rajaraja_cholan · #3 (**permalink**) 06-07-11, 13:12

I have blank as value for Valid column. So, they are indeed valid routines. Thanks Tonkuma for pointing it out.

Internet Services

Web Development

Digital Marketing

Consumer Tech