Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from db2dba_admin on Jun 20 at 4:47 AM Thanks for the replies
I did offline reorg and Runstats on the table, but the table size remains the same.
Database- 10.1
| | | ---------------Original Message---------------
From: db2dba_admin
Sent: Thursday, June 19, 2014 3:54 AM
Subject: Deleting BALDAT Table
Application Log table is of 28 GB in our environment.
I deleted Log files using - SGL2 After that I did reorg on the table but the table size remains same.
Before deleting - I calculated no.of logs we can delete by choosing
. only calculate how many option
o/p - 10063 deletable logs are there
After deleting - I calculated no.of logs we can delete by choosing
. only calculate how many option
o/p - 76 deletable logs are there
Then I performed Reorg followed by Runstats but size of the table remains same.
When I run the tcode - SGL2 . Its fetching data from BALHDR not from BALDAT.
Please suggest me how to delete the log data from BALDAT. |
| Reply to this email to post your response. __.____._ |   _.____.__ |
