Windows UDB Question

[Gerrit Groenendaal]

Hallo,

At the moment we have a Data warehouse on Windows with UDB 8.1. Now the
warehouse will expand to 1Tb for the 7 fact tables (that is the data only,
without the indexes).

The questions are:

§ Is Windows the right platform, or must we go for UNIX
or Linux? The load for the 7 tables is 11 GB average, to a maximum of 40 GB
a day before it is transferred to a star schema. The record size is 1K

§ What is the maximum size for a Windows environment?

Regards

Gerrit

[Serge Rielau]

I can't comment on the best platform (certainly there is no MUST go away
from Windows though) but make suer you size your fact table. DB2 can
support 512GB of data in a single table with 32KB pagesize.
If you use 4KB page size only that shrinks to 64GB.
You don't want to be caught late in the game because you chose too small
a pagesize.

Cheers
Serge

[Larry]

You need to look at whether you need the DPF (if you don't have it
already). You can always cluster servers together under Windows if you
wish. The analysis that needs to be done is whether your company feels
that the availability and reliability of Windows and the Intel platform
is sufficient to meet your requirements.

Larry Edelstein

Gerrit Groenendaal wrote:

Hallo,

At the moment we have a Data warehouse on Windows with UDB 8.1. Now the
warehouse will expand to 1Tb for the 7 fact tables (that is the data only,
without the indexes).

The questions are:

§ Is Windows the right platform, or must we go for UNIX
or Linux? The load for the 7 tables is 11 GB average, to a maximum of 40 GB
a day before it is transferred to a star schema. The record size is 1K

§ What is the maximum size for a Windows environment?

Regards

Gerrit

[Mark Yudkin]

Are there any plans to raise the per table / partition limit?

Would it help if I open a requirement that the 64GB per "4K" tablespace
partition limit be relaxed?

"Serge Rielau" <sr*****@ca.ibm.com> wrote in message
news:34*************@individual.net...

I can't comment on the best platform (certainly there is no MUST go away
from Windows though) but make suer you size your fact table. DB2 can
support 512GB of data in a single table with 32KB pagesize.
If you use 4KB page size only that shrinks to 64GB.
You don't want to be caught late in the game because you chose too small a
pagesize.

Cheers
Serge

[Mark Yudkin]

Moving to Linux will gain you nothing over Windows as far as your question
is concerned: DB2 is compatible over all supported platforms. meaning the
limit is independent of the OS.

Serge has addressed the DB2 limits.

"Gerrit Groenendaal" <gr*****@worldonline.nl> wrote in message
news:41**********************@dreader2.news.tiscal i.nl...

Hallo,

At the moment we have a Data warehouse on Windows with UDB 8.1. Now the
warehouse will expand to 1Tb for the 7 fact tables (that is the data only,
without the indexes).

The questions are:

§ Is Windows the right platform, or must we go for
UNIX or Linux? The load for the 7 tables is 11 GB average, to a maximum of
40 GB a day before it is transferred to a star schema. The record size is
1K

§ What is the maximum size for a Windows environment?

Regards

Gerrit

[PaulR]

Gerrit,

What do you/administrators/developers have the best skills in,
and what is your existing infrastructure?

These are probably more important given DB2 doesn't really care
what the platform is.

Paul.

[Gerrit Groenendaal]

Hallo,

Thanks for the answers,

We are a mainframe shop, but due the stringent WLC policy, there are no
cycles left or they are too expensive. So we started with Windows. We will
go for the DPF or the union all view.

Gerrit
"PaulR" <pa**@abacus.co.uk> schreef in bericht
news:11**********************@z14g2000cwz.googlegr oups.com...

Gerrit,

What do you/administrators/developers have the best skills in,
and what is your existing infrastructure?

These are probably more important given DB2 doesn't really care
what the platform is.

Paul.

[phu]

I think the original poster commented that the row sized is
approximately 1 KByte in size. With a 32-KB pagesize, there
shouldn't be much wasted space on a page. DB2 supports a maximum
of ~250 rows per page.

The 32 KByte pagesize should be sufficient, given the few details
that the user has provided.
Mark Yudkin <my***********************@boing.org> wrote:

Are there any plans to raise the per table / partition limit? Would it help if I open a requirement that the 64GB per "4K" tablespace
partition limit be relaxed? "Serge Rielau" <sr*****@ca.ibm.com> wrote in message
news:34*************@individual.net...

I can't comment on the best platform (certainly there is no MUST go away
from Windows though) but make suer you size your fact table. DB2 can
support 512GB of data in a single table with 32KB pagesize.
If you use 4KB page size only that shrinks to 64GB.
You don't want to be caught late in the game because you chose too small a
pagesize.

Cheers
Serge

--
Bill Phu -- Dalhousie University (phu at cs dal ca)
"Three grand essentials to happiness in this life are something to do,
something to love, and something to hope for."
- Joseph Addison

[Mark Yudkin]

I was actually for our own reasons, rather than that of original poster - we
have a case where we will soon need substantially more room than we get on
UDB. I hoped that Serge would respond, but he didn't.

<ph*@cs.dal.ca> wrote in message news:cr**********@News.Dal.Ca...

I think the original poster commented that the row sized is
approximately 1 KByte in size. With a 32-KB pagesize, there
shouldn't be much wasted space on a page. DB2 supports a maximum
of ~250 rows per page.

The 32 KByte pagesize should be sufficient, given the few details
that the user has provided.
Mark Yudkin <my***********************@boing.org> wrote:

Are there any plans to raise the per table / partition limit?

Would it help if I open a requirement that the 64GB per "4K" tablespace
partition limit be relaxed?

"Serge Rielau" <sr*****@ca.ibm.com> wrote in message
news:34*************@individual.net...

I can't comment on the best platform (certainly there is no MUST go away
from Windows though) but make suer you size your fact table. DB2 can
support 512GB of data in a single table with 32KB pagesize.
If you use 4KB page size only that shrinks to 64GB.
You don't want to be caught late in the game because you chose too small
a
pagesize.

Cheers
Serge

--
Bill Phu -- Dalhousie University (phu at cs dal ca)
"Three grand essentials to happiness in this life are something to do,
something to love, and something to hope for."
- Joseph Addison

[Gerrit Groenendaal]

Hi,

The rows size of the fact Table will be about 100 bytes, the orignal load
file is 1kb.

Gerrit
<ph*@cs.dal.ca> schreef in bericht news:cr**********@News.Dal.Ca...

I think the original poster commented that the row sized is
approximately 1 KByte in size. With a 32-KB pagesize, there
shouldn't be much wasted space on a page. DB2 supports a maximum
of ~250 rows per page.

The 32 KByte pagesize should be sufficient, given the few details
that the user has provided.
Mark Yudkin <my***********************@boing.org> wrote:

Are there any plans to raise the per table / partition limit?

Would it help if I open a requirement that the 64GB per "4K" tablespace
partition limit be relaxed?

"Serge Rielau" <sr*****@ca.ibm.com> wrote in message
news:34*************@individual.net...

I can't comment on the best platform (certainly there is no MUST go away
from Windows though) but make suer you size your fact table. DB2 can
support 512GB of data in a single table with 32KB pagesize.
If you use 4KB page size only that shrinks to 64GB.
You don't want to be caught late in the game because you chose too small
a
pagesize.

Cheers
Serge

--
Bill Phu -- Dalhousie University (phu at cs dal ca)
"Three grand essentials to happiness in this life are something to do,
something to love, and something to hope for."
- Joseph Addison