Sybase 11.9, Feb 1998 row-level locking
Bryan Althaus
According to InfoWorld, Sybase will release Adaptive Server Enterprise
11.9 database in Feb 1998 with main feature being the support for
row-level loocking. So what happened to the 11.5 update, 11.5.1?
And what does this mean to 11.5 users? Is it upgrade time again?
Does 11.9 support Java or will that come in 12.0???
Sybase answers critics, adds row-level locking to database
By Paul Krill InfoWorld Electric
Posted at 9:05 AM PT, Dec 15, 1997
Sybase in February plans to add a long-sought-after feature -- row-level
locking -- to its database, offering finer granularity in isolating rows
of data for use in applications.
Sybase's Adaptive Server Enterprise 11.9 database will offer this feature,
the lack of which has long been a sore spot for Sybase.
For example, enterprise resource planning software maker SAP has not
supported Sybase databases partly because of the lack of this function.
However, Sybase's announced plans to add row-level locking to the next
release of its database have not swayed SAP into the Sybase camp.
Currently, Sybase databases support page-level locking, in which an
instruction can lock a page of a database to prevent it from being altered
by another computer operation occurring at the same time. Row-level
locking offers finer granularity by locking specific rows of data.
"It solves a problem that has been plaguing Sybase for some time," said
Mitchell Kertzman, Sybase chairman and CEO .
A third-party publisher of software for Sybase, Oracle, and Microsoft
databases shared this position.
"Our application is heavy OLTP [online transaction processing], so we're
always going after a lot of single rows that can be on a single page of
data," said Brett Frerking, a senior systems analyst at DST Technologies,
in Kansas City, Mo., which sells a workflow-management tool. "So we've
had a lot of issues as far as page-level locking databases."
The lack of row-level locking prompted one customer to switch from Sybase
to an IBM AS/400 database, Frerking added.
Although page-level locking is fast in some transaction programs, batch or
mixed batch applications -- such as an overnight payroll application -- can
benefit from row-level locking, with demand increasing for access to
multiple rows on the same page, Kertzman said.
Applications from vendors such as PeopleSoft and Baan will benefit from
row-level locking and will no longer have to be rewritten in order to
support the function, Kertzman added.
<http://www.infoworld.com/cgi-bin/displayStory.pl?971215.esybase.htm>
br...@sybase.com
In article <676hvn$q...@news1.panix.com>,
Bryan Althaus <br...@panix.com> wrote:
>
>
> According to InfoWorld, Sybase will release Adaptive Server Enterprise
> 11.9 database in Feb 1998 with main feature being the support for
> row-level loocking. So what happened to the 11.5 update, 11.5.1?
>
> And what does this mean to 11.5 users? Is it upgrade time again?
> Does 11.9 support Java or will that come in 12.0???
>
The 11.5.1 Rollup is being released and is what most people will want
to apply.
11.9 is a kind of offshoot from the main codeline. At this time,
it is intended for use only with Peoplesoft and Baen applications.
It will not have all of the new features that 11.5 included (but has
some of them), or any of the new features from 11.5.1, but it does
have the new row-level locking features. 11.9 does not include any
additional support for Java.
Unless you are running Peoplesoft or Baen, you should plan on
following the upgrade path from pre-11.5 to 11.5 to 11.5.1 to
(eventually) 12.0, which should combine the 11.5.x features with
the row-level locking and additional new features.
--
Bret Halford Imagine my disappointment
Sybase Technical Support in learning the true nature
3665 Discovery Drive of rec.humor.oracle...
Boulder, CO 80303
-------------------==== Posted via Deja News ====-----------------------
http://www.dejanews.com/ Search, Read, Post to Usenet
Marc Zampetti
Sybase will be releasing 11.9, the first version with row-level locking support
in the near future, but it is a not a replacement for 11.5 or 11.5.1. I am not
the product manager, so I don't have dates for releases, but 11.9 is only going
to be available by partner applications, like PeopleSoft and Seibel Systems. It
will NOT be Generally Available. 11.5.1 will still be released in the near
future as well, as was originally announced. Again, don't quote me on dates, as
I don't have them. The next major release will have the 11.9 features rolled in
and will replace 11.5, as 11.5 replaced 11.0.
Marc Zampetti
Bryan Althaus wrote:
> According to InfoWorld, Sybase will release Adaptive Server Enterprise
> 11.9 database in Feb 1998 with main feature being the support for
> row-level loocking. So what happened to the 11.5 update, 11.5.1?
>
> And what does this mean to 11.5 users? Is it upgrade time again?
> Does 11.9 support Java or will that come in 12.0???
>