Maximun number of schema per Db

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

situ - 23 May 2007 15:35 GMT

Hello all,

What is the limitation for the number of schema per database, how many
schema we can have for a database.

Thanks
situ

Reply to this Message

Serge Rielau - 23 May 2007 15:49 GMT

> Hello all,
>
> What is the limitation for the number of schema per database, how many
> schema we can have for a database.

The only limit I can think of involves the size of the namespace.
I have tested DB2 myself with 1000 schemas...

There is a limit in the length of PATH though which you may or may not
care about.

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

situ - 23 May 2007 17:05 GMT

> > Hello all,
>
[quoted text clipped - 13 lines]
> DB2 Solutions Development
> IBM Toronto Lab

thanks a lot..

Reply to this Message