Skip to Content
avatar image
Former Member

How to reduce the size of a BALDAT table

We followed the note 195157 and reduced the application log entries of a table by running the program sbal_delete. But the size of the table is not reduced and it is constant in size.

Note: we have a DB2 database.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 02, 2017 at 08:27 PM

    How many logs (in BALHDR) do you have, and how many have been deleted?

    Are you estimating the size of BALDAT by the size occupied in the database (on the disk), or by counting its number of lines?

    The DELETE SQL statement (what does sbal_delete or SLG2) only deletes the lines logically. The database space occupied by the table does not change.

    For instance, in ORACLE, it's possible to "empty" a table with TRUNCATE (the table then contains 0 line), but the space is not freed ; with TRUNCATE DROP STORAGE, the space is freed.

    Ask your database administrator to reorganize the table (to delete physically the records).

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 10, 2017 at 11:36 AM

    Hey,

    In most organizations there's an archiving module (like this). Did you check for that in your system? If so (assuming you have it) why not use it?

    Add comment
    10|10000 characters needed characters exceeded