on 09-02-20174:42 PM - last edited on 02-04-20242:30 AM by postmig_api_4
0
Kudos
Hi we have done a mock migration of our productive ERP system from Aix/DB2 9.7 to Suze 12/ ASE16 02 05. We have followed the best practice guide and configured the system as recommended. After migration we are noticing that in the migrated system , transaction FBL5n which uses the logical database DDF is doing a very slow sequential read on BSID . The SQL statement has no where clause and the time taken is almost 4 times that of the system running on DB2. Is there any specific step which needs to be executed to handle this ? The client refuses to go live on the new platform unless there is a solution to this . Any clue will be highly appreciated .
We are also noticing that BSAD performance is poor. We noticed that it is choosing two different plans . The plan with BSAD~0 appears to be faster, but when it chooses BSAD~4 (with only bukrs, kunnr and budat in where clause) may be bad.
Assuming you are also seeing sequential reads on BSID while running FBL5N, can you please check whether updating stats on BSID/BSAD helps? Also are you specifying the "Posting Date" (value for field: BUDAT) -- when selecting the option "All Items"? If yes, then please see if creating a new index to include BSID.BUDAT helps - as documented in SAP Note:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.