• 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