DBA Cockpit Options

[Former Member]

Hi All

I want to know more about the DBA Cockpit options, We are using Netweaver 2004's with DB2 UDB on AIX. We are on SP14 - SAPKB70014 to be exact.

I'm particularly interested in Automatic Reorg, Nickname Statistics and Reorgchk for all Tables options. How to use them and what they signify.

Thanks in Advance

Regards

Kaleem

[Former Member · Accepted solution]

Hi Kaleem,

here is some info for these DB13 jobs

REORGCHK for all Tables

This job calculates the REORGCHK formula results for all tables of your SAP schema and stores these results into special SAP tables. For this, the stored procedures REORGCHK_TB_STATS and REORGCHK_IX_STATS are used. In addition, size and table status information is retrieved for each table via stored procedure ADMIN_GET_TAB_INFO and also written to these tables.

You should schedule the job regularly once a week. If you do not, you won't be able to use the 'Space->Tables and Indexes' action in the DBA Cockpit. Further, the results of this job are the basis for historization of table and indexes size growth.

If you schedule the job, there is an option to check tables for compression. This should normally not be switched on as it is very time consuming. But you can schedule it from time to time, so that you can find candidates for compression by also using the 'Space->Tables and indexes' screen.

AutoReorg

This job can reorganize tables and/or indexes automatically based on the results gathered by the 'REORGCHK for all tables' job. If behaves very similar to DB2 AUTOREORG. Starting with version 9 of DB2, DB2 AUTOREORG should be used instead as it is more efficient when reorganizing indexes.

Whenever you arae using some AUTOREORG feature, be aware, that you limit the size of the tables to be reorganized and the runtime. That's very important!

Scheduling is optional, it depends on your application.

Nickname Statistics

This is a job, which simply updates nickname statistics for nicknames within your schema. It uses the DB2 procedure NNSTAT. Scheduling is optional, normally you do not need it in an SAP environment

For further information on jobs see also SAP notes 434495 and 431430.

Best regards

Ralf

[Former Member · Accepted solution]

Limit Size and Runtime automatically picked while scheduling AUTOREORG in DB13.

Rgds

DK