Ansicht
Dokumentation
13007 - Cost Based Optimizer for DB2/400
CPI1466 during Backup Addresses (Business Address Services)This documentation is copyright by SAP AG.
Cost Based Optimizer for DB2/400
Using ST04 --> Detail Analysis Menu --> Index Advice, try to see if thereare very high counts on "Index Advice Count" column (after sorting this
column in descending order). If so, drill down to see the SQL
statement with the highest index advice count and start creating
indexes as advised in the detailed information (the bottommost
information field) to see if there is any run-time improvement. It will be=
good if U can recognise whether the table name with the highest index
advice count is related to any particular query that appears to have run-
time performance issue.
Satid S.
IBM Thailand
--- In DoNotReply@consolut.eu, sumanjit_chowdhuryZi...
wrote:
> Hi Group,
> We are on Kernel patch 1604 and at the Latest PTF level, in SM50
> almost all the programs are seen as performing Sequential Reads
which is
> affecting performance very badly i want to know how does the
Optimizer
> works for DB2/400 if it also uses CBO then it should also access the
Table
> Access Statistics , i want to know how to check whether table access
> statistics are getting generated or not is there any job scheduled to
> update the statistics ..etc..
>
>
> Any help on this...
>
> Thnks nd Regds,
>
> Sumanjit
>
>
>
>
>
> __
> IMPORTANT NOTICE:
> This email may be confidential, may be legally privileged, and is for
the intended recipient only.
> Unauthorised access, disclosure, copying, distribution, or reliance on
any of it by anyone else is prohibited and may be a criminal offence.
> Please delete if obtained in error and email confirmation to the
sender.
Durban Tours - Südafrika Safari
BAL_S_LOG - Application Log: Log header data Fill RESBD Structure from EBP Component Structure
This documentation is copyright by SAP AG.
Length: 2326 Date: 20240420 Time: 031031 sap01-206 ( 3 ms )
