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.

online reorgs

2 posts in General Discussion Last posting was on 2011-03-07 16:05:57.0Z
Venki Posted on 2011-03-07 13:00:42.0Z
From: "Venki" <venkitachalam.s@gmail.com>
Newsgroups: sybase.public.ase.general
Subject: online reorgs
Lines: 8
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5931
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4d74d6fa$1@forums-1-dub>
Date: 7 Mar 2011 05:00:42 -0800
X-Trace: forums-1-dub 1299502842 10.22.241.152 (7 Mar 2011 05:00:42 -0800)
X-Original-Trace: 7 Mar 2011 05:00:42 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30022
Article PK: 79251

Hi,

Do we have online reorgs in ASE 15.5? which does not lock pages?

regards
Venki


Bret Halford Posted on 2011-03-07 16:05:57.0Z
From: Bret Halford <bret@sybase.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.14) Gecko/20110221 Thunderbird/3.1.8
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: online reorgs
References: <4d74d6fa$1@forums-1-dub>
In-Reply-To: <4d74d6fa$1@forums-1-dub>
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: <4d750265$1@forums-1-dub>
Date: 7 Mar 2011 08:05:57 -0800
X-Trace: forums-1-dub 1299513957 10.22.241.152 (7 Mar 2011 08:05:57 -0800)
X-Original-Trace: 7 Mar 2011 08:05:57 -0800, vip152.sybase.com
Lines: 15
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30023
Article PK: 79253


On 3/7/2011 6:00 AM, Venki wrote:
> Hi,
>
> Do we have online reorgs in ASE 15.5? which does not lock pages?
>
> regards
> Venki

No. The COMPACT, FORWARDED_ROWS, and RECLAIM_SPACE options use
locks for very short durations, but they still use locks.
REORG REBUILD has to lock the entire table.

-bret