Skip to Content
avatar image
Former Member

SLG2 BALDAT

Dear community,

Please guide me, now in my BW system BALDAT table have a size of at least 135 GB. After using slg2 according sap note 195157 - Application log: Deletion of logs and update db stat. the size of the table BALDAT did`t change. How can I clear the table?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Sep 10, 2014 at 06:16 AM

    Hi Albert,

    Follow below steps

    1) Using SLG2 delete the data based on time frame. Specify correct date inputs , client and user settings.

    2) Verify from database table using SE16, whether entries have got deleted for the input parameters mentioned in your execution

    3) Post deletion perform table reorg to shrink the table size.

    Hope this helps.

    Regards,

    Deepak Kori

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 12, 2014 at 11:26 AM

    Hi Albert,

    If your DB is Oracle, please use the BR Tools for table reorganization to shrink the table. you can do reorganization in online.

    Please refer the below link:

    http://help.sap.com/saphelp_nw73/helpdata/en/46/adf8c2c5b462d1e10000000a1553f7/content.htm

    If you are using SQL database,the space is still not released after the mass deletion of logs, you can try to shrink the database or data files.

    http://msdn.microsoft.com/en-IN/library/ms189035.aspx and http://msdn.microsoft.com/en-us/library/ms190757.aspx

    Note: Please take necessary precaution methods before you perform the activity for safer side. (taking backup of the db, performing the activity when no user logged in SAP etc.,)

    Thanks and regards,

    Pradeep

    Add comment
    10|10000 characters needed characters exceeded