Skip to Content
0

How to reduce the size of a BALDAT table

Dec 02, 2017 at 08:06 PM

86

avatar image
Former Member

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.

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

2 Answers

Sandra Rossi Dec 02, 2017 at 08:27 PM
1

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

Share
10 |10000 characters needed characters left characters exceeded
Iftah Peretz
Dec 10, 2017 at 11:36 AM
0

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?

Share
10 |10000 characters needed characters left characters exceeded