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.

set IQ_SYSTEM_MAIN to READONLY

2 posts in General Discussion Last posting was on 2011-07-03 20:44:11.0Z
Elvira L. Posted on 2011-06-28 18:18:50.0Z
From: "Elvira L." <elvira.lungu@1and1.ro>
Newsgroups: sybase.public.iq
Subject: set IQ_SYSTEM_MAIN to READONLY
Lines: 11
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.6109
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4e0a1b0a$1@forums-1-dub>
Date: 28 Jun 2011 11:18:50 -0700
X-Trace: forums-1-dub 1309285130 10.22.241.152 (28 Jun 2011 11:18:50 -0700)
X-Original-Trace: 28 Jun 2011 11:18:50 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4392
Article PK: 246534

BlankDear Gurus,

It seems from the Sybase documentation that you cannot set IQ_SYSTEM_MAIN to
READONLY using the ALTER DBSPACE command.

Is this true?
Any answer is highly appreciated,
Best Regards,
EL


Rob V [ Sybase ] Posted on 2011-07-03 20:44:11.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.iq
Subject: Re: set IQ_SYSTEM_MAIN to READONLY
References: <4e0a1b0a$1@forums-1-dub>
In-Reply-To: <4e0a1b0a$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: <4e10d49b$1@forums-1-dub>
Date: 3 Jul 2011 13:44:11 -0700
X-Trace: forums-1-dub 1309725851 10.22.241.152 (3 Jul 2011 13:44:11 -0700)
X-Original-Trace: 3 Jul 2011 13:44:11 -0700, vip152.sybase.com
Lines: 33
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4393
Article PK: 246531


On 28-Jun-2011 20:18, Elvira L. wrote:
> BlankDear Gurus,
>
> It seems from the Sybase documentation that you cannot set IQ_SYSTEM_MAIN to
> READONLY using the ALTER DBSPACE command.
>
> Is this true?
> Any answer is highly appreciated,
> Best Regards,
> EL
>
>

The documentation is correct on this point.

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
-----------------------------------------------------------------