Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. maxtardiveau

    Data integrity

    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...
  2. maxtardiveau

    Data integrity

    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...
  3. maxtardiveau

    DB2 deadlocks - simple scenario

    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
  4. maxtardiveau

    Explain plan

    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...
  5. maxtardiveau

    db2 communication error

    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
  6. maxtardiveau

    db2 communication error

    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
  7. maxtardiveau

    how to get identity values after insert into a tbale with identity col

    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
  8. maxtardiveau

    DB2 deadlocks - simple scenario

    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...

Part and Inventory Search

Back
Top