var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Invalid routines in DB2 system schemas
When I do -
in my database, I am getting many routines from SQLJ, SYSCAT, SYSFUN, SYSIBM, SYSPROC schemas as Invalid.
db2 "SELECT ROUTINESCHEMA, ROUTINENAME FROM SYSCAT.ROUTINES WHERE VALID <> 'Y'"
What could have invalidated these routines & How can I make them valid? Thanks.
What were the values of VALID column?
DB2 9.7 for LUW SQL Reference, Volume 1
Appendix D. System catalog views
Column Name: VALID
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
I have blank as value for Valid column. So, they are indeed valid routines. Thanks Tonkuma for pointing it out.