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

    Unanswered: Environment issue in DB2.

    I am inserting data into tables using ESQL coding.
    But in one broker and DB2 in a system it is working fine for around 30000 rows and more upto 1 lack rows.
    But the same flow in other broker and DB2 is only able to insert upto 30000 rows, above which it is throwing exception-
    Recoverable Exception, Retry processing failed message.
    Is this some Environment issue in DB2 or in the Message flow.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    can you at least post the complete error message (sqlcode-sqlstate)
    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
    Jul 2011
    Posts
    16
    The SQL states and codes are not there.
    It is just Retry,processing failed message.

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    please try to debug and add as much info/error as possible
    without errorcode nobody knows what is going wrong and how to correct if you don't know what is the error..
    I could say.. drop the db and all problems will be resolved..
    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

  5. #5
    Join Date
    Jul 2011
    Posts
    16
    If a heavy message file is sent it is not going into debug mode also.
    Only for small files it is going in debug mode and inserting properly.
    The problem comes in Heavy file and that to in one DB and broker it is working fine and giving the exceptions in other DB and broker with the same flows and inputs.
    drop the db ???

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    If you do not have db2 specific information, posting on this forum is of little help.

    Post in the broker support forums. You may find someone who has experienced this.


    -
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  7. #7
    Join Date
    Jul 2011
    Posts
    16
    ok thank you, but the only thing that this issue is not the DB issue, I wanted to confirm that thing only.
    Do we need to do some settings or changes so that 1 lac rows can be inserted into two inter-related tables.As it is working in one DB but in other DB is is giving exception.

  8. #8
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    how do you want us to give a hint/answer if we don't know what is the problem
    otherwise it would be driving in the dark without any lights.. and see what we are hitting..
    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

  9. #9
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    I don't think this is a DB2 error

    Message Broker Help Home Documentation

    You are getting a Recoverable error and not a database error.

    As Guy says, it is not possible to provide any guidance without knowing anything about the error.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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