韌館-LearnHouse

Archive for 18 10 月, 2012

DB2 SQL0964C The transaction log for the database is full. SQLSTATE=57011

紀錄一下,作量測很容易會讓資料庫塞太多東西,塞爆後會出現很多奇怪的問題

做DB2的插入操作報錯

db2 => insert into atmjobsts values ('20090805','2')
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0964C The transaction log for the database is full. SQLSTATE=57011

原因:

緩衝池擴展失敗,由於可用的虛擬內存的大小不足

Read more...

2012年10 月 posted by admin in 文獻參考 and have No Comments