DB2 crash: Agent not allocated, sqlcode -6043

qxz · #1 (**permalink**) 01-03-06, 11:04

Dear All,

My DB2 running in Windows NT platform crashed occasionally with
the following error. I need to reboot the machine to make it functioning
again. Any idea what could be going wrong? THANKS!

------------------------------------------------------------
2005-12-30-15.09.09.140000 Instance

B2 Node:000
PID:294(db2syscs.exe) TID:381 Appid:none
base_sys_utilities sqleGetAgent Probe:25

Agent not allocated, sqlcode = -6043

2005-12-30-15.23.39.796000 Instance

B2 Node:000
PID:304(db2syscs.exe) TID:423 Appid:*LOCAL.DB2.051230072338
base_sys_utilities sqledint Probe:0 Database

B12

Crash Recovery is needed.

n_i · #2 (**permalink**) 01-03-06, 11:15

Code:

>db2 ? sql6043


SQL6043C No FCM request blocks are available.

Explanation:

No FCM request block is available. FCM is unable to increase the
number of request blocks automatically because the maximum value
has been reached.

 The statement cannot be processed.

User Response:

Try the request again after other processes have freed up some of
this resource.

 sqlcode :  -6043

 sqlstate :  57011

qxz · #3 (**permalink**) 01-03-06, 11:27

and another error in the event viewer:

The description for Event ID ( 4 ) in Source ( Stacker Server ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: [EProgram::checkPwd] getPassword errorcode: -805

but this problem was resolved by itself later. we didn't do anything.

please help!

qxz · #4 (**permalink**) 01-03-06, 11:29

thanks. but how to prevent this? need to code the logic explicitly
in the programs?

Quote:

Originally Posted by n_i

Code:

>db2 ? sql6043


SQL6043C No FCM request blocks are available.

Explanation:

No FCM request block is available. FCM is unable to increase the
number of request blocks automatically because the maximum value
has been reached.

 The statement cannot be processed.

User Response:

Try the request again after other processes have freed up some of
this resource.

 sqlcode :  -6043

 sqlstate :  57011

J Petruk · #5 (**permalink**) 01-03-06, 11:33

What do you have set for the dbm configuration parameters FCM_NUM_BUFFERS and MAX_COORDAGENT?

n_i · #6 (**permalink**) 01-03-06, 11:35

Try increasing FCM_NUM_BUFFERS

qxz · #7 (**permalink**) 01-04-06, 00:23

FCM_NUM_BUFFERS is 2120, and maxagents 500.
that was not enough?

Meanwhile, there is "maximal connection per minutes" in
the "performance configuration". I changed the value
from 60 to 120. Does it help?

Quote:

Originally Posted by J Petruk

What do you have set for the dbm configuration parameters FCM_NUM_BUFFERS and MAX_COORDAGENT?