Skip to Content
avatar image
Former Member

Performance issue in SAPDBDDF after migration to SYBASE ASE16 02 05

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 04, 2017 at 04:31 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

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

    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

    Add comment
    10|10000 characters needed 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