Database market share 2004


    Sponsored Links


  • 1. Deadlock in Database Procedure
    I need some help in explaining why a certain deadlock has occurred within a database procedure. The Ingres error log shows the following message: E_DM9045_TABLE_DEADLOCK Deadlock encountered locking table (owner).(table) in database (database) with mode 5. My understanding is that when the system calls a database procedure, it takes out Intended Locks on all the tables it might require. Once it gets these locks, the DBP is executed. Hence, it is possible that a DBP can suffer deadlock at the point of taking out the intended locks, but by implication, it can't deadlock during execution, since it has already taken out the locks it needs. But the error message says "with mode 5" (Exclusive) rather than mode 2 (intended exclusive). Also, the way the system responded to the deadlock implies that an error occurred in the middle of the DBP, rather than at the beginning. Does anyone know why this would have happened? Thanks - Paul Hutchinson
  • 2. none
    -- Erratic News-Swervers R us! Ingres, yeah baby, yeah!!! Oh, behave!! ________________________________________________________________ Sent via the PAXemail system at

Re: Database market share 2004

Postby Johel de Souza Filho » Sun, 05 Jun 2005 04:54:43 GMT


"Computer Associates International Inc. recently showered some hard-earned
cash on the winners of its Ingres Million Dollar Challenge, the goal of
which was to motivate developers to cook up migration toolkits from Oracle,
SQL Server, DB2, Sybase and MySQL databases to CA's Ingres r3 open-source
database. The resulting winners are now available and downloadable from "

No, not true. Try to download the files and you'll have a bad surprise. They
are not ready or even do not exist!


Similar Threads:

1.Database market share 2004

2.OT: database market share 2003

OTC wrote:
> Who shit in your Wheaties?

I've missed you!   :-)  You are well?

3.database market share 2003

4.(ad nauseam) database market share 2003


Fun though it has been to watch you each throw the other's toys out of the 
sandpit, any chance you could take it offline?

Enough is enough already!!!



sending to informix-list

5.Off Topic: Was database market share 2003

"scottishpoet" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...

> But as everyone gets ADSL, and can "tunnel" into their companies
> internal network from the house, people can use their PC at home as if
> it was on their desk in the office. So again this perhaps start to
> change. I now have a PDA running a web browser, which has a desk top
> on it, and all my files are stored in my Informix database. Can access
> them all on my PC at work, at home ...

You don't have NTL at home then?!

6. Off Topic: database market share 2003

7. IBM's market share in databases on unix

8. Washington Area Informix Users Group Forum 2004 - April 21, 2004

Return to DATABASE


Who is online

Users browsing this forum: No registered users and 72 guest