|
|
"如果说DB2可能会有LOG FULL的情况 => 整个系统挂了"
not really, you can configure to let system idle when log is full or rollback transactions by using BLK_LOG_DSK_FUL db cfg, usually it will not crash the system
blk_log_dsk_ful - Block on log disk full configuration parameter
Configuration Type
Database
Parameter Type
Configurable Online
Propagation Class
Immediate
Default [Range]
No [ Yes; No ]
This configuration parameter can be set to prevent disk full errors from being generated when DB2 cannot create a new log file in the active log path. Instead, DB2 will attempt to create the log file every five minutes until it succeeds. After each attempt, DB2 writes a message to the Administration Notification log. The only way that you can confirm that your application is hanging because of a log disk full condition is to monitor the Administration Notification log. Until the log file is successfully created, any user application that attempts to update table data will not be able to commit transactions. Read-only queries might not be directly affected; however, if a query needs to access data that is locked by an update request, or a data page that is fixed in the buffer pool by the updating application, read-only queries will also appear to hang.
Setting blk_log_dsk_ful to yes causes applications to hang when DB2 encounters a log disk full error, thus allowing you to resolve the error and allowing the transaction to complete. You can resolve a disk full situation by moving old log files to another file system or by enlarging the file system, so that hanging applications can complete.
If blk_log_dsk_ful is set to no, then a transaction that receives a log disk full error will fail and will be rolled back. In some situations, the database will come down if a transaction causes a log disk full error.
[ 本帖最后由 wangzhonnew 于 2011-8-12 20:55 编辑 ] |
|
楼主: jiangzx
IP卡
狗仔卡
发表于 2011-8-12 19:52
显身卡
发表于 2011-8-19 16:10
