Re: filenumber for tablespaces?

From: Benny Derous <bderous_at_roularta.be>
Date: Mon, 21 Jun 1999 17:00:18 +0200
Message-ID: <7klkk8$3b3$1@news1.skynet.be>

Hi,

it is possible on IBM AIX to create large files > 2GB; therefore you need a large filesystem (FS created with the large option). But I would not recommend it; I myself never cross the 2 GB file size for a datafile.

So you will need at least 6 datafiles.

Kind regards,

Benny Derous

karsten reincke wrote in message
<376DEE7C.1B2C613E_at_cl-ki.uni-osnabrueck.de>...
>hello;
>
>we have to manage a table for 4000000 rows each containing more than 3K.
>therefore we must have a tablespace of more than 12 GB.
>
>(1) how many datafiles should we connect to the tablespace?
>(2) is it better to build up the tablespace by many smaller datafiles or
>by one or two very large datafiles?
>
>many thanks for your comments and/or your hints
>--
> salut d'Allemagne kr
>-----------------------------------
>les chats cont les vrais hédonistes
>et devraient être donc notre idéal.
>-----------------------------------
> karsten reincke [ 0541/9696223 ]
> kreincke_at_cl-ki.uni-osnabrueck.de
Received on Mon Jun 21 1999 - 10:00:18 CDT