The database space came down to 42% from 97%, after truncating the table.So it appears although the table rows are deleted the physical file is unaffected, but on a truncate it wipes out everything.
The 2.5 gig file came down to 26 kb after the truncate.
why the physical file is never cleared eventhough the related table rows are deleted.
-rw------- 1 inst01 db2adm 262144 Apr 03 06:30 /inst01/NODE0000/SQL00005/SQLT0002.0/SQL00113.LB
-rw------- 1 inst01 db2adm 1583349760 Apr 03 06:30 inst01/NODE0000/SQL00007/SQLT0002.0/SQL00031.LB
Kinldy advice wht needs to be done so the physical file never grows up in size and occupy much memory
dBforums
>
Physical log files in DB2 growing up in size
04-16-09, 07:07
Linear Mode
