Let me be the first
Not a technical support question but a discussion of a CRN article announcing the next IDS release, code-named "Cheetah", claiming it would add "record-level locking" carried over from DB2. Posters ridiculed this, noting IDS has had row-level locking since the early 1990s and that relational databases have rows, not records; searches of DB2 LUW docs turned up nothing (only iSeries uses the term). IBM's Madison Pruet clarified it was a miscommunication: the new feature is a form of row versioning letting a select read the last committed version instead of blocking on a locked row, with more details to come at the IOD conference. A side complaint about the scarcity and poor quality of Informix press coverage went unresolved.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Obnoxio The Clown wrote: > Mark Townsend said: > > http://www.crn.com/sections/software/software.jhtml?articleId=193004835 > > "The next release, code-named Cheetah, is due to beta this spring and will > feature *record-level locking*, technology carried over from the latest > release of IBM DB2, said Arvind Krishna, vice president of database > servers for IBM Software's Information Management Group, Somers, N.Y." > > I think I speak for us all when I say: "What the *fuck*???" > > First of all, it's row-level locking, as any good relational database user > knows. And secondly, IDS has had row-level locking since ... help me out > here... the early 90's? > > I think Arvind Krishna needs to find himself a nice rusty spade, I do. :o( > > -- > Bye now, > Obnoxio > > "... no bill is required as no value was provided." > -- Christine Normile > > -- > This message has been scanned for viruses and > dangerous content by OpenProtect(http://www.openprotect.com), and is > believed to be clean. the article does go on to say "The current IDS Version 10 Release Change 5-IDS uses its own release terminology-offers row-level and column-level locking." which suggests there is a difference between record and row level locking
Mark Townsend said: > http://www.crn.com/sections/software/software.jhtml?articleId=193004835 "The next release, code-named Cheetah, is due to beta this spring and will feature *record-level locking*, technology carried over from the latest release of IBM DB2, said Arvind Krishna, vice president of database servers for IBM Software's Information Management Group, Somers, N.Y." I think I speak for us all when I say: "What the *fuck*???" First of all, it's row-level locking, as any good relational database user knows. And secondly, IDS has had row-level locking since ... help me out here... the early 90's? I think Arvind Krishna needs to find himself a nice rusty spade, I do. :o( -- Bye now, Obnoxio "... no bill is required as no value was provided." -- Christine Normile -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.
Mark Townsend said: > http://www.crn.com/sections/software/software.jhtml?articleId=193004835 "IBM maintains that the IDS customer base may not be huge" ... unless, of course, you compare it to the DB2 customer base. -- Bye now, Obnoxio "... no bill is required as no value was provided." -- Christine Normile -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.
Obnoxio The Clown wrote: > Mark Townsend said: > > http://www.crn.com/sections/software/software.jhtml?articleId=193004835 > > "IBM maintains that the IDS customer base may not be huge" > > ... unless, of course, you compare it to the DB2 customer base. > maybe some of the customer base may not be huge but some of the support and service staff are!!
Obnoxio The Clown wrote: > scottishpoet said: > > > > "The current IDS Version 10 Release Change 5-IDS uses its own release > > terminology-offers row-level and column-level locking." > > > > which suggests there is a difference between record and row level > > locking > > The difference is that a relational database has no concept of a record. > And come on, how long has IDS had row-level locking? Since before some > Other databases, wasn't it? > > -- > Bye now, > Obnoxio > > "... no bill is required as no value was provided." > -- Christine Normile > > -- > This message has been scanned for viruses and > dangerous content by OpenProtect(http://www.openprotect.com), and is > believed to be clean. Maybe we should attend this Db2 session next week DB2's Little-Known Locking Parameters http://idugew.prod.web.sba.com/displaymod/detailevent.cfm?conference_id=60&event_id=1204
scottishpoet said: > > "The current IDS Version 10 Release Change 5-IDS uses its own release > terminology-offers row-level and column-level locking." > > which suggests there is a difference between record and row level > locking The difference is that a relational database has no concept of a record. And come on, how long has IDS had row-level locking? Since before some Other databases, wasn't it? -- Bye now, Obnoxio "... no bill is required as no value was provided." -- Christine Normile -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.
I searched through the DB2 V9 infocenter: http://publib.boulder.ibm.com/infocenter/db2luw/v9//index.jsp but can't find anything about record locking
scottishpoet said: > > Maybe we should attend this Db2 session next week You are welcome to go, I see no point in going on DB2 training. :o) I did read the blurb, it says NOTHING about "record-level" locking, either. -- Bye now, Obnoxio "... no bill is required as no value was provided." -- Christine Normile -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.
scottishpoet wrote: > I searched through the DB2 V9 infocenter: > > http://publib.boulder.ibm.com/infocenter/db2luw/v9//index.jsp > > but can't find anything about record locking > > See http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp (search for "record locking"). Lukas
Lukas Barton wrote: > scottishpoet wrote: > > I searched through the DB2 V9 infocenter: > > > > http://publib.boulder.ibm.com/infocenter/db2luw/v9//index.jsp > > > > but can't find anything about record locking > > > > > See http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp > (search for "record locking"). > > Lukas The requesting job will be active till one of the following events occurs: The record lock is released. The specified wait time ends. and this differs from row level locking and "set lock mode to wait xxx seconds"?
Obnoxio The Clown wrote: > Mark Townsend said: >> http://www.crn.com/sections/software/software.jhtml?articleId=193004835 > > "The next release, code-named Cheetah, is due to beta this spring and will > feature *record-level locking*, technology carried over from the latest > release of IBM DB2, said Arvind Krishna, vice president of database > servers for IBM Software's Information Management Group, Somers, N.Y." There is a bit of mis-communication with this. What we are doing is implementing a form of row versioning which will enable a select to view the currently committed row rather than blocking on the row when it is in the process of being updated and is locked. There's quite a few other really cool things that are being put into Cheetah. Can't talk about them just yet, but will be doing so at the conference in Aniheim. > > I think I speak for us all when I say: "What the *fuck*???" > > First of all, it's row-level locking, as any good relational database user > knows. And secondly, IDS has had row-level locking since ... help me out > here... the early 90's? > > I think Arvind Krishna needs to find himself a nice rusty spade, I do. :o( >
Curious that this poorly written article provides an "announcement", so where is the IBM presence for this on the IBM website or other trade rags? Madison Pruet wrote: > Obnoxio The Clown wrote: >> Mark Townsend said: >>> http://www.crn.com/sections/software/software.jhtml?articleId=193004835 >> >> "The next release, code-named Cheetah, is due to beta this spring and >> will >> feature *record-level locking*, technology carried over from the latest >> release of IBM DB2, said Arvind Krishna, vice president of database >> servers for IBM Software's Information Management Group, Somers, N.Y." > > There is a bit of mis-communication with this. What we are doing is > implementing a form of row versioning which will enable a select to view > the currently committed row rather than blocking on the row when it is > in the process of being updated and is locked. > > There's quite a few other really cool things that are being put into > Cheetah. Can't talk about them just yet, but will be doing so at the > conference in Aniheim. > > >> >> I think I speak for us all when I say: "What the *fuck*???" >> >> First of all, it's row-level locking, as any good relational database >> user >> knows. And secondly, IDS has had row-level locking since ... help me out >> here... the early 90's? >> >> I think Arvind Krishna needs to find himself a nice rusty spade, I do. >> :o( >>
Double Echo wrote: > > Curious that this poorly written article provides an "announcement", so > where is > the IBM presence for this on the IBM website or other trade rags? What Arvind discussed was a prelude to the IOD conference in Aniheim coming up in a few weeks. Other things will be described in the conference, and in several of the regional IIUG mini-conferences coming up. I wouldn't expect to see a whole lot of mention about the other new functionality until after then. M.P. > > > Madison Pruet wrote: >> Obnoxio The Clown wrote: >>> Mark Townsend said: >>>> http://www.crn.com/sections/software/software.jhtml?articleId=193004835 >>> >>> "The next release, code-named Cheetah, is due to beta this spring and >>> will >>> feature *record-level locking*, technology carried over from the latest >>> release of IBM DB2, said Arvind Krishna, vice president of database >>> servers for IBM Software's Information Management Group, Somers, N.Y." >> >> There is a bit of mis-communication with this. What we are doing is >> implementing a form of row versioning which will enable a select to >> view the currently committed row rather than blocking on the row when >> it is in the process of being updated and is locked. >> >> There's quite a few other really cool things that are being put into >> Cheetah. Can't talk about them just yet, but will be doing so at the >> conference in Aniheim. >>
You missed my point. This is apparently one of the first articles ( in years btw ) to even talk about Informix and new technology. It was poorly written, and so far a casual sweep to other news sites turns up nothing. If an article has come out on CRN, where else will we expect to see more news? These kinds of articles are important, they get saved, printed, and referenced to, in building street credibility about the product. And, as usual, a lot of people will not be in Anaheim, especially new customers outside the 20,000 customers mentioned in the article and the folks from Walmart who have apparently been responsible for keeping the product alive. So any articles that are written are incredibly important in their scope and content. Madison Pruet wrote: > Double Echo wrote: >> >> Curious that this poorly written article provides an "announcement", >> so where is >> the IBM presence for this on the IBM website or other trade rags? > > What Arvind discussed was a prelude to the IOD conference in Aniheim > coming up in a few weeks. Other things will be described in the > conference, and in several of the regional IIUG mini-conferences coming > up. I wouldn't expect to see a whole lot of mention about the other new > functionality until after then. > > M.P. > >> >> >> Madison Pruet wrote: >>> Obnoxio The Clown wrote: >>>> Mark Townsend said: >>>>> http://www.crn.com/sections/software/software.jhtml?articleId=193004835 >>>>> >>>> >>>> "The next release, code-named Cheetah, is due to beta this spring >>>> and will >>>> feature *record-level locking*, technology carried over from the latest >>>> release of IBM DB2, said Arvind Krishna, vice president of database >>>> servers for IBM Software's Information Management Group, Somers, N.Y." >>> >>> There is a bit of mis-communication with this. What we are doing is >>> implementing a form of row versioning which will enable a select to >>> view the currently committed row rather than blocking on the row >>> when it is in the process of being updated and is locked. >>> >>> There's quite a few other really cool things that are being put into >>> Cheetah. Can't talk about them just yet, but will be doing so at the >>> conference in Aniheim. >>>