cancel
Showing results for 
Search instead for 
Did you mean: 

SAP DB13 issue for Linux/DB2 platform

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

manumohandas82
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Saurabh,

What command you are trying to execute from OS level ? BR*Tools are not supported for DB2 environment.

Thanks

Former Member
0 Kudos

Hello Sharma,

Thanks for details you shared , I managed to clarify and rectify many index related issue on DB6 with notes you shared above ..

Thank you,

Shanaka.