Results 1 to 3 of 3
  1. #1
    Join Date
    May 2011
    Posts
    1

    Unanswered: HADR ConnectionFailover(-4498) happening frequently on Production

    In our production environment we are using following:

    DB2 UDB for Windows 9.7
    Setupis HADR Cluster with ACR

    The client is written in Java and using JCC Driver type 4 (v 9.7)

    We are using the cluster hostname and port to connect.

    Weare getting -4498 error frequently and our application aborts. Manual intervention needed to restart the application almost everyday.

    We could not find anything in db2 serverside logs.

    Here is the output of our application (showing -4498 errors):

    <16-05-2011 07:54:16>
    ErrorCode: -4498; Text: com.ibm.db2.jcc.b.ClientRerouteException: [jcc][t4][2027][11212][3.53.95] A connection failed but has been re-established. The host name or IP address is "POPMMCLUSDB201" and the service name or port number is 50,000.
    Special registers may or may not be re-attempted (Reason code = 1). ERRORCODE=-4498, SQLSTATE=08506

    <15-05-2011 11:16:03>
    com.ibm.db2.jcc.b.ClientRerouteException: [jcc][t4][2027][11212][3.53.95] A connection failed but has been re-established. The host name or IP address is "POPMMCLUSDB201" and the service name or port number is 50,000.
    Special registers may or may not be re-attempted (Reason code = 1). ERRORCODE=-4498, SQLSTATE=08506


    <13-05-2011 06:07:19> at com.tcs.bfsarch.process.notifications.WorkerThread ****n(WorkerThread.java:130)
    com.ibm.db2.jcc.b.ClientRerouteException: [jcc][t4][2027][11212][3.53.95] A connection failed but has been re-established. The host name or IP address is "POPMMCLUSDB201" and the service name or port number is 50,000.
    Special registers may or may not be re-attempted (Reason code = 1). ERRORCODE=-4498, SQLSTATE=08506


    [12 May, 2011 05:42] Error : 1825361215 -> [jcc][t4][2027][11212][3.53.95] A connection failed but has been re-established. The host name or IP address is "POPMMCLUSDB201" and the service name or port number is 50,000.
    Special registers may or may not be re-attempted (Reason code = 1). ERRORCODE=-4498, SQLSTATE=0850
    Last edited by tuhinsengupta; 05-18-11 at 12:47. Reason: spelling

  2. #2
    Join Date
    Apr 2013
    Posts
    1
    hi

    we are facing the same issue on over production server, can you please provide details how you have solved it.

    it would be very helpfull.

    thanks and regards
    Brijesh

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Your application must be modified to handle ClientRerouteException and retry the transaction instead of aborting.
    ---
    "It does not work" is not a valid problem statement.

Tags for this Thread

Posting Permissions

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