By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,334 Members | 1,290 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,334 IT Pros & Developers. It's quick & easy.

DB2 Connect Problem

P: n/a
Hi! Running DB2 Connect EE 8.1 on Windows 2000. When we execute a web
app with a small amount of data returned, we do not have a problem.
But, when we widen the criteria, we get errors...

web app shows:
Exception caught in TFBDB, DoDB2Dataset - DotNet Provider. Exception
Message - SQL1224N A database agent could not be started to service a
request, or was terminated as a result of a database system shutdown or
a force command. SQLSTATE=55032 Stack Trace - at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(Int32
hr) at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orMultpleResults(tagDBPARAMS
dbParams, Object& executeResult) at
System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object&
executeResult) at
System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior,
Object& executeResult) at
System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior
behavior, String method) at
System.Data.OleDb.OleDbCommand.ExecuteReader(Comma ndBehavior behavior)
at
System.Data.OleDb.OleDbCommand.System.Data.IDbComm and.ExecuteReader(CommandBehavior
behavior) at System.Data.Common.DbDataAdapter.FillFromCommand(O bject
data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand
command, CommandBehavior behavior) at
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) at
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at
TFB.Core.TFBDB.DoDB2Dataset(String Query)
db2diag.log on Connect Server shows:

2005-06-24-10.33.27.687000 Instance:DB2 Node:000
PID:1220(db2syscs.exe) TID:1004 Appid:GAC00ABA.LA1B.011784153232
DRDA Application Server sqljsTermAgentReply Probe:10

DIA5000C A DRDA AS token "AGENT TERMINATING" was detected. The
diagnostic data returned is (SRVDGN): "SQLERRP:SQLJCMN
SQLCODE:-30081".

PID:1220 TID:1004 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30081 sqlerrml: 41
sqlerrmc: 10053 * * TCP/IP SOCKETS 12.12.1.12 recv
sqlerrp : SQLJCMN
sqlerrd : (1) 0x81360012 (2) 0x00000012 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

2005-06-24-10.33.27.765000 Instance:DB2 Node:000
PID:1220(db2syscs.exe) TID:1004 Appid:GAC00ABA.LA1B.011784153232
DRDA Communication Manager sqljcSend Probe:10

CCI Error:
0x0376D6CC : 0x00000037 7...

2005-06-24-10.33.27.859000 Instance:DB2 Node:000
PID:1220(db2syscs.exe) TID:1004 Appid:GAC00ABA.LA1B.011784153232
DRDA Communication Manager sqljcSend Probe:10

DIA0001E An internal error occured. Report the following error code:
"ZRC=0x8136001C".

Please help!! Thanks!
JenU

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.