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 > Unable to updates to the db2 server

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-21-11, 07:20
pkumar210 pkumar210 is offline
Registered User
 
Join Date: Jul 2011
Posts: 9
Unable to updates to the db2 server

Hello Everyone,

Whenever I run the updateDB comand in my db2 environment it gives me folowing error:
com.ibm.db2.jcc.b.un: [jcc][t4][2055][11259][3.53.70] The database manager is no
t able to accept new requests, has terminated all requests in progress,
or has terminated this particular request due to unexpected error conditions det
ected at the target system. ERRORCODE=-4499, SQLSTATE=58009
at com.ibm.db2.jcc.b.bd.a(bd.java:321)
at com.ibm.db2.jcc.b.bd.a(bd.java:382)
at com.ibm.db2.jcc.t4.bb.T(bb.java:1237)
at com.ibm.db2.jcc.t4.bb.A(bb.java:610)
at com.ibm.db2.jcc.t4.bb.n(bb.java:527)
at com.ibm.db2.jcc.t4.bb.a(bb.java:328)
at com.ibm.db2.jcc.t4.bb.a(bb.java:111)
at com.ibm.db2.jcc.t4.b.l(b.java:1280)
at com.ibm.db2.jcc.t4.b.b(b.java:1153)
at com.ibm.db2.jcc.t4.b.c(b.java:740)
at com.ibm.db2.jcc.t4.b.b(b.java:726)
at com.ibm.db2.jcc.t4.b.a(b.java:409)
at com.ibm.db2.jcc.t4.b.<init>(b.java:345)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:1 97)
at java.sql.DriverManager.getConnection(DriverManager .java:562)
at java.sql.DriverManager.getConnection(DriverManager .java:155)
at psdi.util.DBConnect.getConnection(DBConnect.java:7 0)
at psdi.tools.UpdateDB.getConnection(Unknown Source)
at psdi.tools.UpdateDB.main(Unknown Source)
Error getting connection from the database.

Any idea how to resolve this error. My database server is in RedHat linux and admin server from where I am issuing this command is a windows server.

Regards
Piyush
Reply With Quote
  #2 (permalink)  
Old 12-21-11, 07:39
przytula_guy przytula_guy is offline
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 1,159
maybe some msg in diaglog at server ?
can you connect / select
create a sample prog with connect - select from sysibm.sysdummy1...
or are all operation failing ?
__________________
Best Regards, Guy Przytula
Database Software Consultant
DB2 UDB LUW Certified V7-V8-V9-V9.7 DB Admin - Dprop..
Information Server Datastage Certified
http://www.infocura.be
Reply With Quote
  #3 (permalink)  
Old 12-21-11, 07:48
wolaos123 wolaos123 is offline
Registered User
 
Join Date: Nov 2011
Location: Shen Zhen,China
Posts: 37
some process like db2stop or full backup is in progress
Reply With Quote
  #4 (permalink)  
Old 12-21-11, 08:09
pkumar210 pkumar210 is offline
Registered User
 
Join Date: Jul 2011
Posts: 9
Thanks for the quick response to this.
No nothing is in progress in the database server. I have even tried restarting the vm box and also restarting the db2 via db2 start/stop, but same problem.


Also I am unable to do anything. All Operations are failing.
Reply With Quote
  #5 (permalink)  
Old 12-21-11, 08:23
przytula_guy przytula_guy is offline
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 1,159
there is a problem with setup
have you configured db2 for tcpip ? svcename ? db2comm ?
see doc at infocenter for all details about db2 server and tcpip
__________________
Best Regards, Guy Przytula
Database Software Consultant
DB2 UDB LUW Certified V7-V8-V9-V9.7 DB Admin - Dprop..
Information Server Datastage Certified
http://www.infocura.be
Reply With Quote
  #6 (permalink)  
Old 12-21-11, 09:25
wolaos123 wolaos123 is offline
Registered User
 
Join Date: Nov 2011
Location: Shen Zhen,China
Posts: 37
can you connect to the DB from local by the same id?
Reply With Quote
  #7 (permalink)  
Old 12-21-11, 09:31
pkumar210 pkumar210 is offline
Registered User
 
Join Date: Jul 2011
Posts: 9
I just verified that these settings are configured properly for db2.
Reply With Quote
  #8 (permalink)  
Old 12-21-11, 09:41
pkumar210 pkumar210 is offline
Registered User
 
Join Date: Jul 2011
Posts: 9
Yes, I can connect to db2 locally with the same id.
Reply With Quote
  #9 (permalink)  
Old 12-21-11, 09:43
przytula_guy przytula_guy is offline
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 1,159
"I just verified that these settings are configured properly for db2."
if the settings are correct , why is there a problem while connecting ?
according to your opinion, the settings are correct
if you don't publish any details about these, we can not judge..
are you the only, having a problem or is it general
pd/psi is good for you..
__________________
Best Regards, Guy Przytula
Database Software Consultant
DB2 UDB LUW Certified V7-V8-V9-V9.7 DB Admin - Dprop..
Information Server Datastage Certified
http://www.infocura.be
Reply With Quote
  #10 (permalink)  
Old 12-21-11, 10:22
wolaos123 wolaos123 is offline
Registered User
 
Join Date: Nov 2011
Location: Shen Zhen,China
Posts: 37
can you connect to the remote DB hosting on redhat from window CLP?

if yes,might be something wrong with the JDBC drive
Reply With Quote
  #11 (permalink)  
Old 12-21-11, 11:24
pkumar210 pkumar210 is offline
Registered User
 
Join Date: Jul 2011
Posts: 9
Hello Everyone,

Thanks for all your responses. Much appreciated.
The issue was resolved now and I am able to do updateDB successfully.

Since I am not very good in DB2 so I with the help of one of my colleague cleared DB2 ipcs and restarted the DB2 server.
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