468,251 Members | 1,491 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,251 developers. It's quick & easy.

DB2 Connect Problem

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
0 1306

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Ellen K. | last post: by
3 posts views Thread by Scott | last post: by
reply views Thread by christopher keller | last post: by
7 posts views Thread by Michi Henning | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.