Search results for query: *

Hi Dima, the problem with referential integrity is, it's not turned on in a lot of databases, and it's often not an option. Same thing with triggers and stored procedures -- a lot of databases don't have any, and defining them will often break existing applications. And how do you address the...

How do you check the integrity of the data in a database? Say you have a database with a bunch of data. Assume you have inherited that data, and therefore do not know how good (or bad) it is. The question is: are there tools out there that allow you to define the logical "rules" that...

I finally stumbled across the DB2_RR_TO_RS registry setting. We turned it on and voila ! Almost all our deadlocks are gone. Oy ve. -- Max

Hi Val, there is indeed. The best way to get started is to use the Command Center. Connect to your database, then enter a query and select Script->Create Access Plan. If the explain tables have not been created before, you'll need DBA access to do that. There are entire books written about...

Another possibility might be a permission problem on the port that is used to connect to the remote server. Are you by any chance using a port number less than 1024 ? Also, can your client connect successfully to other DB2 servers ? -- Max

A quick lookup at the Message Reference manual for DB2 reveals : ETIMEDOUT (10060): The establishment of a connection timed out before a connection was made. My guess is that your DB2 instance was not up, or it was locked for backup, or something like that. -- Max

If you're using DB2 7.2, you should probably know that the identity feature can lead to some serious concurrency problems. You may want to look at sequences instead -- they are much more conducive to high numbers of concurrent users. -- Max

We seem to get an awful lot of deadlocks using DB2 7.2 on AIX or Win2K. Here's a scenario to reproduce a simple deadlock. First create a table : create table t1 (a int not null primary key) insert into t1 (a) values (1) insert into t1 (a) values (2) insert into t1 (a) values (3) commit Now...