ITPub博客

首页 > 应用开发 > IT综合 > 在用stms传输的时候提示: connection errror

在用stms传输的时候提示: connection errror

原创 IT综合 作者:passionwu 时间:2007-12-21 11:21:07 0 删除 编辑

在用stms传输的进行传输的时候,出现在transport control program tp ended with error code 0232,Connection error的错误提示.查看log发现出现:db6conn 错误码率,错误信息为: SQL1225N  no resources to create process or thread错误.

分析db2diag.log(/usr/DB/db2dump/db2diag.log),发现db2diag.log中记录的内容如下:

2007-12-21-09.57.17.819184+480 E40353018A423 LEVEL: Severe (OS)
PID : 1667432 TID : 1 PROC : db2ipccm 0
INSTANCE: db2prd NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloCreateEDU, probe:5
MESSAGE : ZRC=0x870F00F2=-2029059854=SQLO_NORES
"no resources to create process or thread"
CALLED : OS, -, fork
OSERR : EAGAIN (11) "Resource temporarily unavailable"

2007-12-21-09.57.17.819513+480 I40353442A343 LEVEL: Severe
PID : 1667432 TID : 1 PROC : db2ipccm 0
INSTANCE: db2prd NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleCreateNewAgent, probe:25
RETCODE : ZRC=0x870F00F2=-2029059854=SQLO_NORES
"no resources to create process or thread"

2007-12-21-09.57.17.819667+480 I40353786A340 LEVEL: Severe
PID : 1667432 TID : 1 PROC : db2ipccm 0
INSTANCE: db2prd NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleGetAgentFromPool, probe:30
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFF8330 : FFFF FB37 ...7

2007-12-21-09.57.17.819799+480 I40354127A282 LEVEL: Error
PID : 1667432 TID : 1 PROC : db2ipccm 0
INSTANCE: db2prd NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleGetAgent, probe:70
MESSAGE : Agent not allocated, sqlcode = -1225

2007-12-21-09.57.17.820171+480 I40354410A1192 LEVEL: Severe
PID : 1683826 TID : 1 PROC : tp
INSTANCE: db2prd NODE : 000
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcCommConnect, probe:10
MESSAGE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"
DATA #1 : String, 11 bytes
CCI Error:
DATA #2 : unsigned integer, 8 bytes
119
CALLSTCK:
[0] 0x0900000002A203DC sqljcLogCCIError__FP10sqljCmnMgrPCcP10sqlcc_condUclN35 + 0x1F8
[1] 0x0900000002A05C34 sqljcCommConnect__FP10sqljCmnMgr + 0x108
[2] 0x0900000002A05450 sqljcCmnMgrInit__FP10sqljCmnMgrP15sqlcc_comhandlePUcUlP11UCconHandleUc + 0xF0
[3] 0x0900000002A516D0 sqljrInternalConnect__FP11UCconHandlePb + 0xFC
[4] 0x0900000002A52564 sqljrLookupAddressAndConnect__FP13sqljrDrdaArCbP11UCconHandle + 0x58
[5] 0x0900000002A49A80 sqljrDrdaArAuthenticate__FP14db2UCinterfacelPUi + 0x318
[6] 0x0900000002B01C74 sqlexAppAuthenticate__FP14db2UCinterface + 0x18DC
[7] 0x09000000029C54D4 sqljrDrdaArConnect__FP14db2UCinterface + 0xFC
[8] 0x09000000028B8724 sqleUCdrdaARinit__FP11UCconHandle + 0xF0
[9] 0x09000000028B0404 sqleUCappConnect + 0x16BC

上网查资料,告诉我是maxuproc设定的值太低.

在AIX下执行如下命令将maxuproc的值改为4096(原值为20):

#chdev -l sys0 -a maxuproc=4096

重启服务器,传输正常,问题解决.

[@more@]

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/60088/viewspace-995386/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-09-08

  • 博文量
    19
  • 访问量
    633011