银行Db2

DB2-报错SQLCODE=-1225, SQLSTATE=57049?

负责某数据处理调度平台。发现周末报错。登录日志发现报错: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。涉及的操作是delet...显示全部

负责某数据处理调度平台。发现周末报错。登录日志发现报错: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 已达到操作系统进程界限。

收起
参与15

查看其它 3 个回答JaneEyre的回答

JaneEyreJaneEyre软件开发工程师china

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值可能太低。

软件开发 · 2018-02-26
浏览7115

回答者

JaneEyre
软件开发工程师china
擅长领域: 存储灾备服务器

回答状态

  • 发布时间:2018-02-26
  • 关注会员:5 人
  • 回答浏览:7115
  • X社区推广