做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
原因:
缓冲池扩展失败,由于可用的虚拟内存的大小不足
-----------------------------------------------------------------------------------------------
解决:
1. 查看
db2 => get db cfg
Database Configuration for Database
...
Log file size (4KB) (LOGFILSIZ) = 10240
Number of primary log files (LOGPRIMARY) &