\u7d00\u9304\u4e00\u4e0b\uff0c\u4f5c\u91cf\u6e2c\u5f88\u5bb9\u6613\u6703\u8b93\u8cc7\u6599\u5eab\u585e\u592a\u591a\u6771\u897f\uff0c\u585e\u7206\u5f8c\u6703\u51fa\u73fe\u5f88\u591a\u5947\u602a\u7684\u554f\u984c<\/p>\n
\u505aDB2\u7684\u63d2\u5165\u64cd\u4f5c\u5831\u932f<\/p>\n
db2 => insert into atmjobsts values (‘20090805′,’2’)
\nDB21034E The command was processed as an SQL statement because it was not a
\nvalid Command Line Processor command. During SQL processing it returned:
\nSQL0964C The transaction log for the database is full. SQLSTATE=57011<\/p>\n
\u539f\u56e0\uff1a<\/p>\n
\u7de9\u885d\u6c60\u64f4\u5c55\u5931\u6557\uff0c\u7531\u65bc\u53ef\u7528\u7684\u865b\u64ec\u5167\u5b58\u7684\u5927\u5c0f\u4e0d\u8db3<\/p>\n
———————————————————————————————–<\/p>\n
\u89e3\u6c7a\uff1a<\/p>\n
1. \u67e5\u770b<\/p>\n
db2 => get db cfg<\/p>\n
Database Configuration for Database<\/p>\n
…<\/p>\n
Log file size (4KB) (LOGFILSIZ) = 10240
\nNumber of primary log files (LOGPRIMARY) = 13
\nNumber of secondary log files (LOGSECOND) = 4
\nChanged path to log files (NEWLOGPATH) =
\nPath to log files = \/db2data\/db2shjh\/db2inst1\/NODE0000\/SQL00001\/SQLOGDIR\/
\nOverflow log path (OVERFLOWLOGPATH) =
\nMirror log path (MIRRORLOGPATH) =
\nFirst active log file =
\nBlock log on disk full (BLK_LOG_DSK_FUL) = NO
\nPercent max primary log space by transaction (MAX_LOG) = 0
\nNum. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0<\/p>\n
…<\/p>\n
2. \u4fee\u6539<\/p>\n
\u5f8c\u4f86\u628a\u9019\u500b\u53c3\u6578\u7684\u5927\u5c0f\u76f8\u61c9\u8abf\u6574\u4e86\u4e00\u4e0b\uff0c\u8abf\u6574\u5f8c\u5982\u4e0b\uff1a<\/p>\n
Log file size (4KB) (LOGFILSIZ) = 61440<\/p>\n
\u8abf\u6574\u65b9\u6cd5\u70ba<\/p>\n
update db cfg using LOGFILSIZ 61440<\/p>\n
3. \u8abf\u6574\u5f8c\u91cd\u555f\u6578\u64da\u5eab<\/p>\n
\u57f7\u884c db2stop \u4f86\u505c\u6b62DB2\u670d\u52d9\uff0c\u5982\u679c\u505c\u6b62\u4e0d\u6389\u53ef\u4ee5\u8003\u616e\u57f7\u884c db2stop force \u5f37\u5236\u505c\u6b62\u3002
\n\u57f7\u884c db2start \u555f\u52d5DB2\u670d\u52d9\u3002<\/p>\n
4. \u67e5\u770b<\/p>\n
Log file size (4KB) (LOGFILSIZ) = 61440
\nNumber of primary log files (LOGPRIMARY) = 13
\nNumber of secondary log files (LOGSECOND) = 4
\nChanged path to log files (NEWLOGPATH) =
\nPath to log files = \/db2data\/db2shjh\/db2inst1\/NODE0000\/SQL00001\/SQLOGDIR\/
\nOverflow log path (OVERFLOWLOGPATH) =
\nMirror log path (MIRRORLOGPATH) =
\nFirst active log file =
\nBlock log on disk full (BLK_LOG_DSK_FUL) = NO
\nPercent max primary log space by transaction (MAX_LOG) = 0
\nNum. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0<\/p>\n
5. \u518d\u57f7\u884c \u63d2\u5165\u64cd\u4f5c OK \u89e3\u6c7a<\/p>\n
db2 => insert into atmjobsts values(‘20090805′,’3’)
\nDB20000I The SQL command completed successfully.<\/p>\n
\u8cc7\u6599\u4f86\u6e90\uff1ahttp:\/\/www.db2china.net\/home\/space.php?uid=7190&do=blog&id=9009<\/p>\n","protected":false},"excerpt":{"rendered":"
\u7d00\u9304\u4e00\u4e0b\uff0c\u4f5c\u91cf\u6e2c\u5f88\u5bb9\u6613\u6703\u8b93\u8cc7\u6599\u5eab\u585e\u592a\u591a\u6771\u897f\uff0c\u585e\u7206\u5f8c\u6703\u51fa\u73fe\u5f88\u591a\u5947\u602a\u7684\u554f\u984c \u505aDB2\u7684\u63d2\u5165\u64cd\u4f5c\u5831\u932f db2 =&g…<\/span><\/p>\n