If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > SQL error urgent!!

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-05-04, 07:50
shedb shedb is offline
Registered User
 
Join Date: Dec 2003
Posts: 78
SQL error urgent!!

Hello all,
We've been getitng erros today.SQL1224 errors today
the application gives the below error:
273850#TBL L E 05/05 13:15:56:285 orts : 1 TID=???? at com.serv1.server.services.jdbc.JDBCTable.isConnect ed(JDBCTable.java(Compiled Code) ==> DSEException when trying to request connection information.SQLException while connecting to database: [IBM][CLI Driver] 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


the error in the corresponding part of db2diag.log is shown below:

2004-05-05-13.15.56.288761 Instance:db2dsub0 Node:000
PID:64336(java) Appid:
oper_system_services sqlocshr2 Probe:200

0000 0018 ....


2004-05-05-13.15.56.368282 Instance:db2dsub0 Node:000
PID:64336(java) Appid:
oper_system_services sqlocshr2 Probe:200

pSetHdl 4000 0000 4000 0000 0001 0000 0568 0025 @...@........h.%
0004 0000 ....


Data TitleQLCA PID:64336 Node:000
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1224 sqlerrml: 0
sqlerrmc:
sqlerrp : sqlearcn
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x000000FF (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:


Data TitleB2RA PID:64336 Node:000
5351 4c44 4232 5241 0000 0164 0105 0001 SQLDB2RA...d....
0003 001c 0000 0088 0000 0009 585c 9c74 ............X\.t
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 000e 0000 0004 ................
585c 9160 0000 0000 0000 0001 0000 0000 X\.`............
0000 0006 0000 0001 585c 9440 0000 0000 ........X\.@....
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0004 0000 0002 585c 915c 0000 0000 ........X\.\....
0000 0001 0000 0000 0000 0004 0000 0004 ................
585c 9158 0000 0000 0000 0001 0000 0000 X\.X............
0000 0008 0000 0001 585c 9180 0000 0000 ........X\......
0000 0000 0000 0000 0000 00a8 4000 000c ...........¨@...
585c 91bc 0000 0401 8000 0001 58eb 7a3c X\.¼........Xëz<
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0001 0000 0000 0000 0002 ................
0000 0003 585c 914c 0000 0000 0000 0000 ....X\.L........
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0001 0000 0000 0000 0004 0000 0007 ................
585c 9304 X\..


can anybody guess what may be going on??
thanks all
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On