buffer table pool performance with return code 64 in ST05

[Former Member]

Hey guys,I had been meeting an issue causing poor Performance in my SAP system.For a full buffered table,I did trace it with ST12 and ST05,I found it's perfectly buffered in AS(as blue background entries in ST05 tracelist),but there were entries with high 'duration' and return code '64'(I know that's mean no records found),instead,the return code '0' entries worked fine,the duration  was pretty low.I had learned from documents of IBM/SAP(we're running with DB2 on AIX) that if you are just checking the exists of some records of certain table(access frequently),you may buffer them in AS,for now it seems to be going into opposite direction,that does  make sense with long time 'duration'.Detailed information seen the attachments.

[Former Member]

Hi Yunze,

this performance issue can be resolved by adding 2 more steps in the code

step 1 is required so that we will not loose any data else you can go ahead with yourcode by adding the field TZONE for both sort and delete adjacent duplicates and step 2.

1. Pass the data from table IT_TZONE into a dummy table

    SORT dummy table using TZONE  and DELETE ADJACENT DUPLICATES from dummy table           using the field TZONE.

2. Check the dummy table is initial or not before the select query on ZTMT102.

    If this is not empty then process the select query else skip the select query.

you did not mention whether the field ZTRZONE is key field in the table ZTMY102 or not.

if it is not a key field, if huge amount of data has to be fetched then create an index.

the index will create a load on the database but it will improve the performance of the select query.

Hope this will help you to resolve your issue and let me know in case of any questions.

Regards,

Phani

[Former Member]

Hey Suryanarayana,

Thank you for you reply.Maybe you don't realize what I'm truly confused,the table ZTMT102 is a full buffered table.It doesn't matter whether the filed ZTRZONE is a key filed(Anyway it's one of the primary key,but it's not the leader).As you can see from my attachment 'ST05-RETURN CODE',my SQL Statement meet the buffer mechanism,which is full buffered with blue background.Its Cardinality is 81000 with data object of  11136KB.