Perry Whittle (4/5/2014)
what size did you shrink the file too?
Now I dont understand.
I read that more than 100rows can cause problem with INSERT, UPDATE, DELETE. I was suprised if I saw more than 1400rows.
The Log file was about 20GB, I could shrink just for 13GB..
If I executed DBBC LOGINFO, there were about 1400rows
After backup log directly with statements ( not with Tivoli manager program ) it was possible shrink less to 100MB and these files were removed.
After this I did same size for log, because during rebuild index I saw that log has about 20GB..
after this I executed DBBC LOGINFO again and there were 28rows