on 10-03-2011 12:42 PM
Hello Experts,
We have installed the ECC EHP5 system on Red Hat Linux wth DB2 9.7 FP4 and now when we are scheduling the Job from DB13 it is showing successfully but the log says that it is missing some parameters. Below is the log for REORG for All Tables-
01.10.2011 13:04:49 Job started
01.10.2011 13:04:49 Step 001 started (program RSDBAJOB, variant &0000000000001, user ID SAURABH)
01.10.2011 13:04:50 Reorgck_All:REORGCHK for all Tables
01.10.2011 13:04:50 Reorgck_All:started by CL_DB6_JOB_REORGCHK on server sapecdci1
01.10.2011 13:04:50 Reorgck_All:Database connection +++DB6ADM established successfully
01.10.2011 13:04:51 Reorgck_All:Parameter TESTMODE has not been set
01.10.2011 13:04:51 Reorgck_All:Parameter RUNTIME has been set to " 0"
01.10.2011 13:04:51 Reorgck_All:Parameter PARALLELISM has not been set
01.10.2011 13:04:51 Reorgck_All:Parameter COMPRESSION_CHECK has been set to ""
01.10.2011 13:04:51 Reorgck_All:Parameter THRESHOLD_SIZE has not been set
01.10.2011 13:17:41 Reorgck_All:finished
01.10.2011 13:17:41 Job finished
and same for Runstats as well. I amm new to DB2 and don't know how can I execute the check DB and update stats (like in oracle) on OS directly as I doubt the brconnect and all br* tools are not suported by DB6.
Kindly suggest if any parameter settings are required like we have in init<SID>.ora and .sap file ?
Regards
Saurabh
Hi Saurabh ,
You are having no issues as per your Reorg check Job logs and is running as expected .
If you have checked the compression while scheduling the job would have checked whether the tables are candidates for compression ( this is not required )
Thanks ,
Manu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
First of all check if DB2 auto stats is ON or not and check with some of the helpful notes.
Note 860724 - DB6: Configuration of the planning calendar for AutoRunstats
Note 1502194 - DB6: Automatic Statistics Collection (Automatic RUNSTATS)
This checkDB run is OK, and finally it suggests it's recommendations (it's not that 'checkDB is in error') - those parameters.
Please check with this DB2 9.7 parameter note if you can find out something.
Note 1329179 - DB6: DB2 V9.7 Standard Parameter Settings
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Database,
But unfortunately I am getting the same error and as we are on Netweaver 7 so as per note 860724 the DB2 AutoRunstats is activated by default.
Job REORGCHK FOR ALL TABLES showing the status finished but gives the above error. Also like in Oracle we can schedule the statistics update from BRCONNECT at os level when I am scheduling the update statistics from OS level by below command server get hang and no one able to login to system until this finishes and it is running for almost 8 hours.
Do I need to optimize some parameters or how can I identify that if table needs reorg or am I missing some more parameters.
Regards
Saurabh Mishra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.