Results 1 to 11 of 11
  1. #1
    Join Date
    Jul 2011
    Posts
    9

    Unanswered: 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

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    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
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Nov 2011
    Location
    Shen Zhen,China
    Posts
    37
    some process like db2stop or full backup is in progress

  4. #4
    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.

  5. #5
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    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
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  6. #6
    Join Date
    Nov 2011
    Location
    Shen Zhen,China
    Posts
    37
    can you connect to the DB from local by the same id?

  7. #7
    Join Date
    Jul 2011
    Posts
    9
    I just verified that these settings are configured properly for db2.

  8. #8
    Join Date
    Jul 2011
    Posts
    9
    Yes, I can connect to db2 locally with the same id.

  9. #9
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    "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
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  10. #10
    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

  11. #11
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •