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.

Assign more than one temp dbspace

2 posts in General Discussion Last posting was on 2011-04-28 09:51:58.0Z
kennedyc Posted on 2011-04-27 07:45:32.0Z
Sender: 306d.4db7c954.1804289383@sybase.com
From: kennedyc
Newsgroups: sybase.public.iq
Subject: Assign more than one temp dbspace
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4db7c99c.3075.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 27 Apr 2011 00:45:32 -0700
X-Trace: forums-1-dub 1303890332 10.22.241.41 (27 Apr 2011 00:45:32 -0700)
X-Original-Trace: 27 Apr 2011 00:45:32 -0700, 10.22.241.41
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4352
Article PK: 246492

Hello,

Is it possible to assign more than one temp dbspace when
create a IQ DB? any help is appreciated. thanks.

e.g.
create database '/opt/sybase/IQ-15_2/DB/DB.db'
log on '/opt/sybase/IQ-15_2/DB/DB.log'
collation 'ISO1LATIN1'
iq path '/opt/sybase/IQ-15_2/DB/sys_main_1'
iq size 8000
iq reserve 5000
iq page size 131072
message path '/opt/sybase/IQ-15_2/OI/OI.iqmsg'
temporary path '/opt/sybase/IQ-15_2/OI/temp_1'
temporary path '/opt/sybase/IQ-15_2/OI/temp_2'
temporary path '/opt/sybase/IQ-15_2/OI/temp_3'
temporary size 4800
temporary reserve 1000


Leonid Gvirtz Posted on 2011-04-28 09:51:58.0Z
From: Leonid Gvirtz <lgvirtz@yahoo.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.15) Gecko/20110303 Thunderbird/3.1.9
MIME-Version: 1.0
Newsgroups: sybase.public.iq
Subject: Re: Assign more than one temp dbspace
References: <4db7c99c.3075.1681692777@sybase.com>
In-Reply-To: <4db7c99c.3075.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: <4db938be$1@forums-1-dub>
Date: 28 Apr 2011 02:51:58 -0700
X-Trace: forums-1-dub 1303984318 10.22.241.152 (28 Apr 2011 02:51:58 -0700)
X-Original-Trace: 28 Apr 2011 02:51:58 -0700, vip152.sybase.com
Lines: 30
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4353
Article PK: 246496

Hi

While you can't create dbspaces for IQ temporary store in IQ 15.2, you can add as many dbfiles to IQ_SYSTEM_TEMP as you
like. IQ Sizing Guide provides some recommendations about the number of dbfiles required.

Hope it helps
Leonid Gvirtz
http://www.gvirtz-consulting.com

On 4/27/2011 10:45 AM, kennedyc wrote:
> Hello,
>
> Is it possible to assign more than one temp dbspace when
> create a IQ DB? any help is appreciated. thanks.
>
> e.g.
> create database '/opt/sybase/IQ-15_2/DB/DB.db'
> log on '/opt/sybase/IQ-15_2/DB/DB.log'
> collation 'ISO1LATIN1'
> iq path '/opt/sybase/IQ-15_2/DB/sys_main_1'
> iq size 8000
> iq reserve 5000
> iq page size 131072
> message path '/opt/sybase/IQ-15_2/OI/OI.iqmsg'
> temporary path '/opt/sybase/IQ-15_2/OI/temp_1'
> temporary path '/opt/sybase/IQ-15_2/OI/temp_2'
> temporary path '/opt/sybase/IQ-15_2/OI/temp_3'
> temporary size 4800
> temporary reserve 1000