如果是报
SQL0955C Sort memory cannot be allocated to process the statement. Reason
code = "3". SQLSTATE=57011的错。 应该修改哪个参数,具体修改到多大,有什么规则吗?
当时生产环境DB 出现这个报错之后, Datastage job abort, 后来没有做任何操作,重新跑就好了。是内存自动释放了?
这是现在DB 里面的信息~~
db2 get db cfg | grep -i SHEAPTHRES_SHR
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = 18997568
db2 get dbm cfg | grep -i SHEAPTHRES
Sort heap threshold (4KB) (SHEAPTHRES) = 0
db2 get db cfg | grep -i SORTHEAP
Sort list heap (4KB) (SORTHEAP) = 949878
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
SQL0955C Sort memory cannot be allocated to process the statement.
Reason code = "
Explanation:
Insufficient virtual memory is available to the database agent for sort
processing, as indicated by the reason code:
1
Insufficient private process memory.
2
Insufficient shared memory in the database-wide shared memory
area designated for sort processing.
3
Insufficient shared memory for queries on column-organized
tables.
The statement cannot be processed but other SQL statements might be
processed.
User response:
Respond to this message by performing the corresponding action for each
reason code:
1
Increase the memory resources available at the instance or
system level. Alternatively, reduce configured memory
requirements. For example, reduce the value of the SORTHEAP
database configuration parameter.
2
Increase the memory resources available at the database,
instance, or system level. Alternatively, reduce configured
memory requirements. For example, reduce the value of the
SORTHEAP database configuration parameter.
3
Increase the value of the SORTHEAP database configuration
parameter. You might need to increase the setting of
higher-level database configuration parameters such as
SHEAPTHRES_SHR.
sqlcode: -955
sqlstate: 57011