环境: redhat 5, DB2 V9.7
今天在导tpch的数据时 db2 “import from ‘customer.tbl’ of del modified by coldel| insert into customer”
发现无法导入数据并报错:SQL0964C The transaction log for the database is full
查询错误db2 ? SQL0964C提示交易日志过小
对这种场景有两种方式来处理:
1. 调整LOGFILSIZ, LOGPRIMARY, LOGSECOND这三个参数
2.绕过缓存使用load来导入db2 “load from ‘customer.tbl’ of del modified by coldel| codepage=1208 insert into customer”