DB2 SQLSTATE=57049 处理过程
错误代码57049
db2 connect to 数据库 后报 SQLSTATE=57049 错误
`SQL1225N The request failed because an operating system process,
thread, or swap space limit was reached. SQLSTATE=57049`
本以为是swap 空间不足,增加了swap分区后问题依旧,删除实例后发现了问题 原来是在设置
db2 svcename时出现问题了。
修改/etc/services
vi /etc/services
DB2_db2inst1 50000/tcp
DB2_db2inst1_1 50001/tcp
DB2_db2inst1_2 50002/tcp
DB2_db2inst1_END 50003/tcp
修改实例参数db2inst1参数
db2 update dbm cfg using svcename DB2_db2inst1