负责某数据处理调度平台。发现周末报错。登录日志发现报错:2018-02-26 08:28:55,581 [pool-203-thread-1] ERROR com.ksoft.etlite.command.support.ImpTabRunnable$1 - DB2 SQL Error: SQLCODE=-1225, SQLSTATE=57049, SQLERRMC=null, DRIVER=3.59.81。
涉及的操作是delete一个表。
本人直接select count(*) 发现也报错。
[2018-02-26 10:02:54] 57049 The request failed because an operating system process, thread, or swap space limit was reached.. SQLCODE=-1225, SQLSTATE=57049, DRIVER=4.23.42
再次尝试其他大表,也报此错误。小表查询等操作都可以。
百度只得到结果: 57049 已达到操作系统进程界限。
从描述来看,应该是swap space不足导致的,可以考虑调整一下。具体确切的信息可以看看db2diag.log。也可以把db2diag.log的有关信息贴出来,大家一起分析。
收起这个报错一般是操作系统资源不足导致的,包括进程数、信号量数、swap空间,具体是那些资源可以检查一下数据库的diag.log里面报什么错,这里会有说明是哪些资源不足导致的,然后再去调整相应的资源参数。
收起SQL1225N The request failed because an operating system process,
thread, or swap space limit was reached.
Explanation:
An operating system process, thread, or swap space limit was reached.
You can find more information about the problem in the administration
notification log. On AIX systems, the maxuproc value might be too low.
User response:
Check the administration notification log to determine which limit was
reached and increase that limit.
sqlcode: -1225
sqlstate: 57049
maxuproc值可能太低。
收起