cyseng10
asked on
Archive Log get full
i having problem start my database because archive log get full. how to solve this problem? is there statement to remove old archive log file?
ASKER
the reason database not able started cause archive log file get full. i can't remember error code. can i know how to clear archive log file when it get full
cyseng10... it is not that simple...
It depends on whether you are using archival logging or circular, and whether you have enough space on the disks or enough files defined on the database configuration.
Post the error code, and if possible the lines related to logs from the database configuration... on UNIX, you could get this in unix by typing, on the db2 command line
db2 get db cfg for DATABASENAME |grep og
It depends on whether you are using archival logging or circular, and whether you have enough space on the disks or enough files defined on the database configuration.
Post the error code, and if possible the lines related to logs from the database configuration... on UNIX, you could get this in unix by typing, on the db2 command line
db2 get db cfg for DATABASENAME |grep og
did you get this message when backing up or restoring the database?
ASKER
i using archive log ...
the error return that archive log is full ...
the error return that archive log is full ...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
There are a couple of reasons why this would happen, and the solutions depends basically on what's going on!