Reorgchk Stored Procedure.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

doug - 15 May 2006 22:57 GMT

Ok IBM techs.

Does the REORGCHK_TB_STAT and REORGCHK_IX_STAT Stored Procedures issue
a Runstats.

I have ran the old REORGCHK utility with stats and both SPs and it
appear that the SPs do not run a Runstats. I get two different
results. But if I first run a runstats prior to running the SPs I get
the same results. Can you please confirm this behavior of the SPs.

Reply to this Message

Kiran Nair - 16 May 2006 05:57 GMT

If you are using version equal to or higher than 8.2.2 (equivalent to
Version 8.1 FixPak 9) you can go for using admin_cmd stored procedure
for issuing runstats command fro mthe stored procedure
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.
udb.doc/admin/r0012547.htm
the SP REORGCHK_TB_STAT and REORGCHK_IX_STAT suggests if we need to do
runstats but it will not do it.

Regards,
Kiran Nair

> Ok IBM techs.
>
[quoted text clipped - 5 lines]
> results. But if I first run a runstats prior to running the SPs I get
> the same results. Can you please confirm this behavior of the SPs.

Reply to this Message