Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Is there a difference in how data is stored in APL/Data rows/Data pages locking scheme

2 posts in General Discussion Last posting was on 2011-07-18 14:06:44.0Z
Satsun Posted on 2011-07-18 13:19:42.0Z
Sender: 6e55.4e2431c6.1804289383@sybase.com
From: Satsun
Newsgroups: sybase.public.ase.general
Subject: Is there a difference in how data is stored in APL/Data rows/Data pages locking scheme
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e2432ee.6e7e.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 18 Jul 2011 06:19:42 -0700
X-Trace: forums-1-dub 1310995182 10.22.241.41 (18 Jul 2011 06:19:42 -0700)
X-Original-Trace: 18 Jul 2011 06:19:42 -0700, 10.22.241.41
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30355
Article PK: 72533

Hi All,

Is there a difference in how data is stored in APL/Data
rows/Data pages locking scheme. If so what is the difference
among these and why reorg is not allowed against APL?


Thanks,
Satsun.


Rob V [ Sybase ] Posted on 2011-07-18 14:06:44.0Z
From: "Rob V [ Sybase ]" <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV / TeamSybase / Sybase
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110616 Lightning/1.0b2 Thunderbird/3.1.11
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Is there a difference in how data is stored in APL/Data rows/Data pages locking scheme
References: <4e2432ee.6e7e.1681692777@sybase.com>
In-Reply-To: <4e2432ee.6e7e.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4e243df4@forums-1-dub>
Date: 18 Jul 2011 07:06:44 -0700
X-Trace: forums-1-dub 1310998004 10.22.241.152 (18 Jul 2011 07:06:44 -0700)
X-Original-Trace: 18 Jul 2011 07:06:44 -0700, vip152.sybase.com
Lines: 44
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30356
Article PK: 72534


On 18-Jul-2011 15:19, Satsun wrote:
> Hi All,
>
> Is there a difference in how data is stored in APL/Data
> rows/Data pages locking scheme. If so what is the difference
> among these and why reorg is not allowed against APL?
>
>
> Thanks,
> Satsun.

The data row format for datarows/datapages locking is slightly different
than for APL; one reason is that datarows/datapages can have forwarded
rows and APL cannot. Another difference is that APL data pages are
always in a double linked list,but for datarows/datapages tables, this
is (usually) not the case (for a table scan, the data pages are accessed
via the OAM page).
There are also some differences in some aspects of the index rows, and
the structure in the index tree.
The ASE Performance & Tuning Guide has more details on storage internals.

As for reorg: "reorg rebuild <tablename>" is supported on APL tables in
ASE 15. The other reorg flavours work only on datarows/datapages tables;
this is related to the fact that the internal storage format is
different in a number of ways (see above).

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------