Version 8.1.6



In Task Center: The procedure call returns failure but the task is
coming up successful?!?!?! Any advice?



Here is the DB2 command script entries:

>>>>>>>>>>>>>>>>>>>>>>



CONNECT TO DCLMUS1;



CALL PMI_DB.RUNSTATS_ALL (?);

FLUSH PACKAGE CACHE DYNAMIC;




TERMINATE;



>>>>>>>>>>>>>>>>>>>>>>





I have purposely locked a table so the runstats fails



Here is the output:

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>



CONNECT TO DCLMUS1



Database Connection Information



Database server = DB2/SUN 8.1.6

SQL authorization ID = DCLMUS1I

Local database alias = DCLMUS1





CALL PMI_DB.RUNSTATS_ALL (?)



Value of output parameters

--------------------------

Parameter Name : P_MESSAGE

Parameter Value : Error occurred while processing
"PMICNTRL_CLAIMS"."ADDRESS".



Return Status = -1





FLUSH PACKAGE CACHE DYNAMIC

DB20000I The SQL command completed successfully.



TERMINATE

DB20000I The TERMINATE command completed successfully.





>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>








DB2 & UDB email list listserv db2-l LazyDBA home page