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.

ddl in tran

2 posts in General Discussion Last posting was on 2010-09-08 15:29:20.0Z
RGS Posted on 2010-09-07 17:08:42.0Z
Sender: 6059.4c866d11.1804289383@sybase.com
From: RGS
Newsgroups: sybase.public.ase.general
Subject: ddl in tran
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4c86719a.60a0.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Sep 2010 10:08:42 -0700
X-Trace: forums-1-dub 1283879322 10.22.241.41 (7 Sep 2010 10:08:42 -0700)
X-Original-Trace: 7 Sep 2010 10:08:42 -0700, 10.22.241.41
Lines: 13
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29542
Article PK: 78771

I know that I always have to avoid turn on the flag:

ddl in tran

(This command allow to execute ddl sentences inside a
transaction "begin tran" - "commit tran")

Turn on this flag in a particular database is critically for
the perfomance? In wich situations I must avoid to turn on
this flag? What happens if a turn on forever this flag in
all of my databases?

Thanks!


Bret Halford Posted on 2010-09-08 15:29:20.0Z
From: Bret Halford <bret@sybase.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.8) Gecko/20100802 Thunderbird/3.1.2
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: ddl in tran
References: <4c86719a.60a0.1681692777@sybase.com>
In-Reply-To: <4c86719a.60a0.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: <4c87abd0$1@forums-1-dub>
Date: 8 Sep 2010 08:29:20 -0700
X-Trace: forums-1-dub 1283959760 10.22.241.152 (8 Sep 2010 08:29:20 -0700)
X-Original-Trace: 8 Sep 2010 08:29:20 -0700, vip152.sybase.com
Lines: 22
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29551
Article PK: 78783


On 9/7/2010 11:08 AM, RGS wrote:
> I know that I always have to avoid turn on the flag:
>
> ddl in tran
>
> (This command allow to execute ddl sentences inside a
> transaction "begin tran" - "commit tran")
>
> Turn on this flag in a particular database is critically for
> the perfomance? In wich situations I must avoid to turn on
> this flag? What happens if a turn on forever this flag in
> all of my databases?
>
> Thanks!

If the flag is turned on, then users will be able to perform
DDL within transactions. When they do that, exclusive locks
on system tables will be held until they close the transaction.
Any other sessions wishing to access the system tables may
be blocked by those locks.