How to reduce the size of a BALDAT table

[former_member454648]

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.

[Sandra_Rossi]

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).

[iftah_peretz]

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?