Hi,
DB2/400 seems not able to auto-rollback one of transactions while
dead-
lock occurred.
I called the procecure QSYS.CREATE_SQL _SAMPLE for creating sample
database, and used ISQL (STRSQL) & Navigator (Run SQL Scripts) to
evaluate it:
Session A (Isolation Level = CS):
1) insert into sampledb/staff values(1,'Ofer' ,1,'Mgr',0,0,0)
3) select deptname from sampledb/department
Session B (Isolation Level = CS):
2) insert into sampledb/department values('1','Sys tem
Monitor','00001 0','A00',NULL)
4) select name from sampledb/staff
The conclusion is:
In ISQL, it shown CPF5027 (error code is 2) and QRY5050 (2 times); In
Navigator, it shown CPF5027 (error code is 2, 2 times) and SQL0913.
But, no rollback occurred on any transactions automatically.
This behavior is not the same as the "open" db2 does.
Is it possible to "enable" auto-rollback functionality while dead-lock
occurred?
Thanks in advance~ 1 3248
Supplementary:
The session A and B both shown the error message without rolling back
on one of transactions.
As I re-did the step 3) and 4) the error message was threw again. I
had to run SQL 'rollback' or 'commit' explicitly then the query just
could done.
Conversely, it will rollback one of transactions between session A, B
in DB2 for LUW. That is why I said DB2/400 seems not able to auto-
rollback one of transactions while dead-lock occurred.
So, is DB2/400 possible to "enable" auto-rollback functionality while
dead-lock occurred?
Thanks in advance~ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: John Dalberg |
last post by:
How can I enable "list folder contents" ntfs permission only
programmatically?
The docs for cacls and xcalcs do not have an example to set this up without
setting up the other read permissions.
John Dalberg
|
by: Berthold Hoellmann |
last post by:
Hello,
When I use
./configure --with-thread --with-fpectl --with-signal-module \
--with-pymalloc --enable-shared --with-cxx=g++
make test
on 2.3.3 I get
|
by: Steve Barker |
last post by:
Hi guys!
In Visual Studio .NET, I like to enable auto-generation of XML documentation
on the project properties screen, by adding an XML file name under
"Configuration Properties" --> "Build" --> "XML Documentation File". This
way, I get warnings in the task list about public methods I have written that
do not have XML comments (launched by...
|
by: bingfeng |
last post by:
I have some codes generated by perl, in which initialize some huge
struct,such as
PARA TOS_network_spantree_set_0_para_0 = { "vlan", emNUM, NULL, "",
"configuration on a designated vlan", PRO_REQUIRED };
const char* TOS_network_spantree_set_0_para_1_emvalue = { "disable",
"enable", NULL };
PARA TOS_network_spantree_set_0_para_1 = { "",...
|
by: Marlon Brown |
last post by:
Hello,
I am able to "edit" and "update" records using Gridview and Data Sources.
However I don't see an option to "insert" records.
Can someone tell me what's the procedure to "insert" records from ASP.NET -
SQL db using Gridview ?
| |
by: Catherine |
last post by:
Hello,
On Visual Studio .NET 2003 when i try to attach the Outlook process for
debugging I receive systematically this error “Enable to attach to the
process” I try on the computer of my partners and everything was ok I don’t
understand it’s exactly the same machine (rights, service pack and
applications).
Anybody have a idea...
|
by: morangolds |
last post by:
Hi,
I've been having a problem with C++ Windows Forms apps not "ending"
when you close the form window. I've searched about this problem all
over the place and most searches have lead me to believe that this has
to do with unreleased form component events or event handlers.
I'm comparatively new to .net and windows forms, in the sense that...
|
by: laredotornado |
last post by:
Hi,
I'm using PHP 4.4.4 on Apache 2 on Fedora Core 5. PHP was installed
using Apache's apxs and the php library was installed to
/usr/local/php. However, when I set my "error_reporting" setting to be
"E_ALL", notices are still not getting reported. The perms on my file
are 664, with owner root and group root. The php.ini file is located...
|
by: Miro |
last post by:
My form suddenly wouldnt compile. It had an error - main form must be
specified.
So i went to my Solution and went to properties.
In the Application Tab I reset my opening form, but my "Enable Application
Framework" checkbox is missing and
everything under it is missing.
If I create a new solution I have the options.
Is my only choice...
|
by: sudhivns |
last post by:
Any APIs(C# code) that can be used to set the "Enable Distributed COM on this computer" in dcomcnfg.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, well explore What is ONU, What Is Router, ONU & Routers main...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development projectplanning, coding, testing, and deploymentwithout human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupr who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |