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.

dbfile size

2 posts in General Discussion Last posting was on 2013-01-31 14:49:47.0Z
sem Posted on 2013-01-17 12:30:52.0Z
Sender: 4754.50f7eee5.1804289383@sybase.com
From: sem
Newsgroups: sybase.public.iq
Subject: dbfile size
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50f7eefc.4759.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 17 Jan 2013 04:30:52 -0800
X-Trace: forums-1-dub 1358425852 172.20.134.41 (17 Jan 2013 04:30:52 -0800)
X-Original-Trace: 17 Jan 2013 04:30:52 -0800, 172.20.134.41
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4595
Article PK: 1159091

Hi all,

We use IQ 15.2 on AIX and have 26 cores on server and our DW
size is around 70TB. DW is growing around @ for each year. I
have 2 questions.

1- What is the best number of dbfiles and size of per each
dbfiles?

2- We have a disk striping solution that comes from hardware
and also use IQ striping options. Does it affect performance
negative? Should we turn of striping options on IQ?

Thx


Remi. Posted on 2013-01-31 14:49:47.0Z
Sender: 692f.510a83f9.1804289383@sybase.com
From: Remi.
Newsgroups: sybase.public.iq
Subject: Re: dbfile size
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <510a848b.6979.1681692777@sybase.com>
References: <50f7eefc.4759.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 31 Jan 2013 06:49:47 -0800
X-Trace: forums-1-dub 1359643787 172.20.134.41 (31 Jan 2013 06:49:47 -0800)
X-Original-Trace: 31 Jan 2013 06:49:47 -0800, 172.20.134.41
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4598
Article PK: 1307403

Hi,
maybe this whitepaper could help you.
http://www.sybase.com/detail?id=1093493

> Hi all,
>
> We use IQ 15.2 on AIX and have 26 cores on server and our
> DW size is around 70TB. DW is growing around @ for each
> year. I have 2 questions.
>
> 1- What is the best number of dbfiles and size of per each
> dbfiles?
>
> 2- We have a disk striping solution that comes from
> hardware and also use IQ striping options. Does it affect
> performance negative? Should we turn of striping options
> on IQ?
>
> Thx