Skip to Content
0

Performance issue in SAPDBDDF after migration to SYBASE ASE16 02 05

Sep 02, 2017 at 03:42 PM

121

avatar image
Former Member

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 .

Regards

Sid

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Madhvi Pai
Dec 04, 2017 at 04:31 AM
0

Hi Siddhartha,

It has been a while since you posted the question on the

FBL5N performance on SAP ASE. Were you able to resolve this? Was an UPDATE STATS and REORG tried on this table?

Thanks,

Madhvi Pai

SAP Product Support

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Siddhartha,

To add Madhvi reply, check if you can take the optdiag on the table ?

Here is the syntax for you:

optdiag statistics SID.SAPSR3.Tab_name -Usapsa -P*** -SSID -o Tab_Name.opt

Regards

Kiran K Adharapuram

0
avatar image
Former Member Jan 04 at 12:40 PM
0

Hello,

we also face some issues after migrating to ASE16. Could you please give us feedback, were you able to solve your problem? How did you solve it?

Thank you very much,

Manfred Forstinger

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Manfred,

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:

1135916 - Line items: Help for analysis for long runtimes

Thanks and Regards,

Madhvi Pai

SAP Product Support

0