Skip to Content
0
Jan 17, 2012 at 12:02 AM

Can not see a explain

167 Views

Dear experts,

We faced performance problem with t-code FAGLL03.

So, I implemented a note 1464365.

This note add DB6 hint statement in Fucntion Module FAGL_GET_ITEMS_BSIS and FAGL_GET_ITEMS_BSAS source code.

OPEN CURSOR WITH HOLD I_CURSOR FOR

select (lT_FLDLIST_S)

from (ld_dbtab_syntax) CLIENT SPECIFIED

where (lt_where_tab)

%_HINTS DB6 '+[%FROM BSIS % INNER JOIN FAGLFLEXA]' <<<<<<

DB6 '<REOPT VALUE=''ONCE'' />' .

After implementing it, I can not see access plan about a specific SQL statement with t-code ST04.

Things like this happen in joining two tables, BSIS(BSAS) and FAGLFLEXA in Fucntion Module FAGL_GET_ITEMS_BSIS(BSAS).

We use a DB2 v9.5.

I don't see why this happen.

Do you know anyone who can explain this issue?

Thanks.

Lee

Edited by: Ki-Uk Lee on Jan 17, 2012 1:03 AM