紀錄一下,作量測很容易會讓資料庫塞太多東西,塞爆後會出現很多奇怪的問題
做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
原因:
緩衝池擴展失敗,由於可用的虛擬內存的大小不足