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

在用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博客 ” ，链接：http://blog.itpub.net/60088/viewspace-995386/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/60088/viewspace-995386/