DB2 SQLCODE=-101, SQLSTATE=54001
The statement was not processed because a limit such as a memory limit, an SQL limit, or a database limit was reached.. SQLCODE=-101, SQLSTATE=54001, DRIVER=3.61.75
同一段sql,一个测试库运行成功,到生产环境就报错了,百度了很多,都说是改参数,但是我这边的相关参数是这样的
测试库:
Package cache size (4KB) (PCKCACHESZ) = AUTOMATIC(81947)
SQL statement heap (4KB) (STMTHEAP) = AUTOMATIC(8192)
Default application heap (4KB) (APPLHEAPSZ) = 10240
正式库:
Package cache size (4KB) (PCKCACHESZ) = AUTOMATIC(12629)
SQL statement heap (4KB) (STMTHEAP) = 40960
Default application heap (4KB) (APPLHEAPSZ) = 10240