about SQL0911 reason code 68

[Jag]

can anyone tell me what is SQL0911 reason code 68

thanks jag

[Ian]

Re: about SQL0911 reason code 68

Jag wrote:
[color=blue]
> can anyone tell me what is SQL0911 reason code 68[/color]

This is a lock timeout:

----------------------------------------------------------------
$ db2 "? sql0911n"

SQL0911N The current transaction has been rolled back because of
a deadlock or timeout. Reason code "<reason-code>".

Explanation:

The current unit of work was involved in an unresolved contention
for use of an object and had to be rolled back.

The reason codes are as follows:


2 transaction rolled back due to deadlock.

68 transaction rolled back due to lock timeout.

72 transaction rolled back due to an error concerning a DB2 Data
Links Manager involved in the transaction.

Note: The changes associated with the unit of work must be
entered again.

The application is rolled back to the previous COMMIT.

User Response:

To help avoid deadlock or lock timeout, issue frequent COMMIT
operations, if possible, for a long-running application, or for
an application likely to encounter a deadlock.

Federated system users: the deadlock can occur at the federated
server or at the data source. There is no mechanism to detect
deadlocks that span data sources and potentially the federated
system. It is possible to identify the data source failing the
request (refer to the problem determination guide to determine
which data source is failing to process the SQL statement).

Deadlocks are often normal or expected while processing certain
combinations of SQL statements. It is recommended that you
design applications to avoid deadlocks to the extent possible.

sqlcode : -911

sqlstate : 40001

----------------------------------------------------------------


You can avoid this by setting an appropriate value for the
LOCKTIMEOUT database config param, and making sure that your
apps commit (to release locks).





-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

[Ian]

Re: about SQL0911 reason code 68

Jag wrote:
[color=blue]
> can anyone tell me what is SQL0911 reason code 68[/color]

This is a lock timeout:

----------------------------------------------------------------
$ db2 "? sql0911n"

SQL0911N The current transaction has been rolled back because of
a deadlock or timeout. Reason code "<reason-code>".

Explanation:

The current unit of work was involved in an unresolved contention
for use of an object and had to be rolled back.

The reason codes are as follows:


2 transaction rolled back due to deadlock.

68 transaction rolled back due to lock timeout.

72 transaction rolled back due to an error concerning a DB2 Data
Links Manager involved in the transaction.

Note: The changes associated with the unit of work must be
entered again.

The application is rolled back to the previous COMMIT.

User Response:

To help avoid deadlock or lock timeout, issue frequent COMMIT
operations, if possible, for a long-running application, or for
an application likely to encounter a deadlock.

Federated system users: the deadlock can occur at the federated
server or at the data source. There is no mechanism to detect
deadlocks that span data sources and potentially the federated
system. It is possible to identify the data source failing the
request (refer to the problem determination guide to determine
which data source is failing to process the SQL statement).

Deadlocks are often normal or expected while processing certain
combinations of SQL statements. It is recommended that you
design applications to avoid deadlocks to the extent possible.

sqlcode : -911

sqlstate : 40001

----------------------------------------------------------------


You can avoid this by setting an appropriate value for the
LOCKTIMEOUT database config param, and making sure that your
apps commit (to release locks).





-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

[Blair Adamache]

Re: about SQL0911 reason code 68

SQL0911N The current transaction has been rolled back because of
a deadlock or timeout. Reason code "<reason-code>".

Explanation:

The current unit of work was involved in an unresolved contention
for use of an object and had to be rolled back.

The reason codes are as follows:


2 transaction rolled back due to deadlock.

68 transaction rolled back due to lock timeout.

....

Jag wrote:
[color=blue]
> can anyone tell me what is SQL0911 reason code 68
>
> thanks jag
>
>[/color]

[Blair Adamache]

Re: about SQL0911 reason code 68

SQL0911N The current transaction has been rolled back because of
a deadlock or timeout. Reason code "<reason-code>".

Explanation:

The current unit of work was involved in an unresolved contention
for use of an object and had to be rolled back.

The reason codes are as follows:


2 transaction rolled back due to deadlock.

68 transaction rolled back due to lock timeout.

....

Jag wrote:
[color=blue]
> can anyone tell me what is SQL0911 reason code 68
>
> thanks jag
>
>[/color]

[Bruce M]

Re: about SQL0911 reason code 68

Jag, I seriously suggest that you get the manuals downloaded so you
can look these things up yourself.

-B

Blair Adamache <badamache@2muc hspam.yahoo.com > wrote in message news:<c63ab7$70 d$2@hanover.tor olab.ibm.com>.. .[color=blue]
> SQL0911N The current transaction has been rolled back because of
> a deadlock or timeout. Reason code "<reason-code>".
>
> Explanation:
>
> The current unit of work was involved in an unresolved contention
> for use of an object and had to be rolled back.
>
> The reason codes are as follows:
>
>
> 2 transaction rolled back due to deadlock.
>
> 68 transaction rolled back due to lock timeout.
>
> ...
>
> Jag wrote:
>[color=green]
> > can anyone tell me what is SQL0911 reason code 68
> >
> > thanks jag
> >
> >[/color][/color]

[Bruce M]

Re: about SQL0911 reason code 68

Jag, I seriously suggest that you get the manuals downloaded so you
can look these things up yourself.

-B

Blair Adamache <badamache@2muc hspam.yahoo.com > wrote in message news:<c63ab7$70 d$2@hanover.tor olab.ibm.com>.. .[color=blue]
> SQL0911N The current transaction has been rolled back because of
> a deadlock or timeout. Reason code "<reason-code>".
>
> Explanation:
>
> The current unit of work was involved in an unresolved contention
> for use of an object and had to be rolled back.
>
> The reason codes are as follows:
>
>
> 2 transaction rolled back due to deadlock.
>
> 68 transaction rolled back due to lock timeout.
>
> ...
>
> Jag wrote:
>[color=green]
> > can anyone tell me what is SQL0911 reason code 68
> >
> > thanks jag
> >
> >[/color][/color]

[Matt Emmerton]

Re: about SQL0911 reason code 68

Heck, no need to download -- just bookmark this site:

http://publib.boulder.ibm.com/infocenter/db2help/index.jsp

--
Matt Emmerton

"Bruce M" <bwmiller16@yah oo.com> wrote in message
news:184e6bd6.0 404200853.62202 5c0@posting.goo gle.com...[color=blue]
> Jag, I seriously suggest that you get the manuals downloaded so you
> can look these things up yourself.
>
> -B
>
> Blair Adamache <badamache@2muc hspam.yahoo.com > wrote in message[/color]
news:<c63ab7$70 d$2@hanover.tor olab.ibm.com>.. .[color=blue][color=green]
> > SQL0911N The current transaction has been rolled back because of
> > a deadlock or timeout. Reason code "<reason-code>".
> >
> > Explanation:
> >
> > The current unit of work was involved in an unresolved contention
> > for use of an object and had to be rolled back.
> >
> > The reason codes are as follows:
> >
> >
> > 2 transaction rolled back due to deadlock.
> >
> > 68 transaction rolled back due to lock timeout.
> >
> > ...
> >
> > Jag wrote:
> >[color=darkred]
> > > can anyone tell me what is SQL0911 reason code 68
> > >
> > > thanks jag
> > >
> > >[/color][/color][/color]

[Matt Emmerton]

Re: about SQL0911 reason code 68

Heck, no need to download -- just bookmark this site:

http://publib.boulder.ibm.com/infocenter/db2help/index.jsp

--
Matt Emmerton

"Bruce M" <bwmiller16@yah oo.com> wrote in message
news:184e6bd6.0 404200853.62202 5c0@posting.goo gle.com...[color=blue]
> Jag, I seriously suggest that you get the manuals downloaded so you
> can look these things up yourself.
>
> -B
>
> Blair Adamache <badamache@2muc hspam.yahoo.com > wrote in message[/color]
news:<c63ab7$70 d$2@hanover.tor olab.ibm.com>.. .[color=blue][color=green]
> > SQL0911N The current transaction has been rolled back because of
> > a deadlock or timeout. Reason code "<reason-code>".
> >
> > Explanation:
> >
> > The current unit of work was involved in an unresolved contention
> > for use of an object and had to be rolled back.
> >
> > The reason codes are as follows:
> >
> >
> > 2 transaction rolled back due to deadlock.
> >
> > 68 transaction rolled back due to lock timeout.
> >
> > ...
> >
> > Jag wrote:
> >[color=darkred]
> > > can anyone tell me what is SQL0911 reason code 68
> > >
> > > thanks jag
> > >
> > >[/color][/color][/color]

[Philip Nelson]

Re: about SQL0911 reason code 68

Matt Emmerton wrote:
[color=blue]
> Heck, no need to download -- just bookmark this site:
> http://publib.boulder.ibm.com/infoce...help/index.jsp
>
> --
> Matt Emmerton
>
> "Bruce M" <bwmiller16@yah oo.com> wrote in message
> news:184e6bd6.0 404200853.62202 5c0@posting.goo gle.com...[color=green]
>> Jag, I seriously suggest that you get the manuals downloaded so you
>> can look these things up yourself.
>>
>> -B
>>
>> Blair Adamache <badamache@2muc hspam.yahoo.com > wrote in message[/color]
> news:<c63ab7$70 d$2@hanover.tor olab.ibm.com>.. .[color=green][color=darkred]
>> > SQL0911N The current transaction has been rolled back because of
>> > a deadlock or timeout. Reason code "<reason-code>".
>> >
>> > Explanation:
>> >
>> > The current unit of work was involved in an unresolved contention
>> > for use of an object and had to be rolled back.
>> >
>> > The reason codes are as follows:
>> >
>> >
>> > 2 transaction rolled back due to deadlock.
>> >
>> > 68 transaction rolled back due to lock timeout.
>> >
>> > ...
>> >
>> > Jag wrote:
>> >
>> > > can anyone tell me what is SQL0911 reason code 68
>> > >
>> > > thanks jag
>> > >
>> > >[/color][/color][/color]


And in this case not even that is needed -

db2 "? SQL0911N"

will give you the answer.

Phil

[Philip Nelson]

Re: about SQL0911 reason code 68

Matt Emmerton wrote:
[color=blue]
> Heck, no need to download -- just bookmark this site:
> http://publib.boulder.ibm.com/infoce...help/index.jsp
>
> --
> Matt Emmerton
>
> "Bruce M" <bwmiller16@yah oo.com> wrote in message
> news:184e6bd6.0 404200853.62202 5c0@posting.goo gle.com...[color=green]
>> Jag, I seriously suggest that you get the manuals downloaded so you
>> can look these things up yourself.
>>
>> -B
>>
>> Blair Adamache <badamache@2muc hspam.yahoo.com > wrote in message[/color]
> news:<c63ab7$70 d$2@hanover.tor olab.ibm.com>.. .[color=green][color=darkred]
>> > SQL0911N The current transaction has been rolled back because of
>> > a deadlock or timeout. Reason code "<reason-code>".
>> >
>> > Explanation:
>> >
>> > The current unit of work was involved in an unresolved contention
>> > for use of an object and had to be rolled back.
>> >
>> > The reason codes are as follows:
>> >
>> >
>> > 2 transaction rolled back due to deadlock.
>> >
>> > 68 transaction rolled back due to lock timeout.
>> >
>> > ...
>> >
>> > Jag wrote:
>> >
>> > > can anyone tell me what is SQL0911 reason code 68
>> > >
>> > > thanks jag
>> > >
>> > >[/color][/color][/color]


And in this case not even that is needed -

db2 "? SQL0911N"

will give you the answer.

Phil