Skip to Content

RSBKCHECKBUFFER job scheduled twice and both canceling suddenly with two er

Hello,

This job RSBKCHECKBUFFER is scheduled to run two times in production system starting at same time 12:00 pm and it was running fine till 12.04.11 but both the jobs started failing suddenly since 12.05.11 with two different sql errors at times

DBIF_RSQL_SQL_ERROR

CX_SY_OPEN_SQL_DB

1. Database error text........: "SQL1224N The database manager is not able to

accept new requests, has terminated all requests in progress, or has

terminated the specified request because of an error or a forced interrupt.

SQLSTATE=55032 row=1"

2. Database error text........: "SQL0911N The current transaction has been rolled

back because of a deadlock or timeout. Reason code "2". SQLSTATE=40001 row=1"

Also both the job is scheduled to run with two different parameters

Parameters

&0000000000001

&0000000000000

Can anyone let me know what could be the reason of sudden failure since 12.05.11.

Also if I schedule the job to run only once in the system will it solve the problem ?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 09, 2011 at 06:19 AM

    Hello Shradha,

    1. Database error text........: "SQL1224N The database manager is not able to accept new requests, has terminated all requests in progress, or has terminated the specified request because of an error or a forced interrupt.

    SQLSTATE=55032 row=1"

    - As far as I know this is serious problem in production environment. Looks like your DB was being restarted at that time. Please have your DBA team to review db2diag.log for error details.

    2. Database error text........: "SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "2". SQLSTATE=40001 row=1" .

    - Looks like second job was overlapped with first one. Please try to run the job once in a day or change of schedule of both jobs to ensure no overlap.

    Thanks,

    Siva Kumar

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 09, 2011 at 03:29 PM

    What is happening here is that you are running the same exact job at the same exact time. The log is saying that in order to do that you need to change the parameters in the second job if you are going to run them at the same time. Without having all of the details, I don't know why they ran successfully before but if you need to run both jobs you should chain the second job to run immediately after the first job completes.

    Good day to you

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.