Table qualifier in DB2 AS/400

[Trevor Davies]

We have databases on an RS/6000 which we would like to try moving to
AS/400.
On the AIX box we create a number of databases (Dev, Sys Test etc) and
within each database there are a number of tables qualified with
schema names (id's),
so we would end up with

Database DEV
TABLE data.name
TABLE data.address1
TABLE comms.table1

Database TEST
TABLE data.name
TABLE data.address1
TABLE comms.table1
And so on......

On the AS/400 we are having trouble creating this environment as there
only appears to be a single database then within this a number of
collections and within this a number of tables. We cannot find how to
get another level of qualifier to replicate our AIX environment. And
buying more AS/400's is not an option :)

Any help or advice would be much appreciated.

Many Thanks,
Trevor Davies.

[Karl Hanson]

Trevor Davies wrote:

We have databases on an RS/6000 which we would like to try moving to
AS/400.
On the AIX box we create a number of databases (Dev, Sys Test etc) and
within each database there are a number of tables qualified with
schema names (id's),
so we would end up with

Database DEV
TABLE data.name
TABLE data.address1
TABLE comms.table1

Database TEST
TABLE data.name
TABLE data.address1
TABLE comms.table1
And so on......

On the AS/400 we are having trouble creating this environment as there
only appears to be a single database then within this a number of
collections and within this a number of tables. We cannot find how to
get another level of qualifier to replicate our AIX environment. And
buying more AS/400's is not an option :)

Any help or advice would be much appreciated.

In your other post you mentioned V4R5. If you upgrade to V5R2 there is
a function called IASPs - Independent Auxilliary Storage Pools - that
supports multiple databases.
http://publib.boulder.ibm.com/iserie...rbafzmst10.htm

Fyi, V4R5 is no longer supported. If you cannot upgrade to V5R2 you
will probably need to change the naming scheme.

--
Karl Hanson

[Karl Hanson]

Trevor Davies wrote:

We have databases on an RS/6000 which we would like to try moving to
AS/400.
On the AIX box we create a number of databases (Dev, Sys Test etc) and
within each database there are a number of tables qualified with
schema names (id's),
so we would end up with

Database DEV
TABLE data.name
TABLE data.address1
TABLE comms.table1

Database TEST
TABLE data.name
TABLE data.address1
TABLE comms.table1
And so on......

On the AS/400 we are having trouble creating this environment as there
only appears to be a single database then within this a number of
collections and within this a number of tables. We cannot find how to
get another level of qualifier to replicate our AIX environment. And
buying more AS/400's is not an option :)

Any help or advice would be much appreciated.

In your other post you mentioned V4R5. If you upgrade to V5R2 there is
a function called IASPs - Independent Auxilliary Storage Pools - that
supports multiple databases.
http://publib.boulder.ibm.com/iserie...rbafzmst10.htm

Fyi, V4R5 is no longer supported. If you cannot upgrade to V5R2 you
will probably need to change the naming scheme.

--
Karl Hanson

[Trevor Davies]

Karl,
Many thanks for the advice, it sounds like v5r2 is our best bet !

Thanks,
Trevor Davies.

Karl Hanson <kc******@youess.ibm.com> wrote in message news:<c6**********@news.rchland.ibm.com>...

Trevor Davies wrote:

We have databases on an RS/6000 which we would like to try moving to
AS/400.
On the AIX box we create a number of databases (Dev, Sys Test etc) and
within each database there are a number of tables qualified with
schema names (id's),
so we would end up with

Database DEV
TABLE data.name
TABLE data.address1
TABLE comms.table1

Database TEST
TABLE data.name
TABLE data.address1
TABLE comms.table1
And so on......

On the AS/400 we are having trouble creating this environment as there
only appears to be a single database then within this a number of
collections and within this a number of tables. We cannot find how to
get another level of qualifier to replicate our AIX environment. And
buying more AS/400's is not an option :)

Any help or advice would be much appreciated.

In your other post you mentioned V4R5. If you upgrade to V5R2 there is
a function called IASPs - Independent Auxilliary Storage Pools - that
supports multiple databases.
http://publib.boulder.ibm.com/iserie...rbafzmst10.htm

Fyi, V4R5 is no longer supported. If you cannot upgrade to V5R2 you
will probably need to change the naming scheme.

[Trevor Davies]

Karl,
Many thanks for the advice, it sounds like v5r2 is our best bet !

Thanks,
Trevor Davies.

Karl Hanson <kc******@youess.ibm.com> wrote in message news:<c6**********@news.rchland.ibm.com>...

Trevor Davies wrote:

We have databases on an RS/6000 which we would like to try moving to
AS/400.
On the AIX box we create a number of databases (Dev, Sys Test etc) and
within each database there are a number of tables qualified with
schema names (id's),
so we would end up with

Database DEV
TABLE data.name
TABLE data.address1
TABLE comms.table1

Database TEST
TABLE data.name
TABLE data.address1
TABLE comms.table1
And so on......

On the AS/400 we are having trouble creating this environment as there
only appears to be a single database then within this a number of
collections and within this a number of tables. We cannot find how to
get another level of qualifier to replicate our AIX environment. And
buying more AS/400's is not an option :)

Any help or advice would be much appreciated.

In your other post you mentioned V4R5. If you upgrade to V5R2 there is
a function called IASPs - Independent Auxilliary Storage Pools - that
supports multiple databases.
http://publib.boulder.ibm.com/iserie...rbafzmst10.htm

Fyi, V4R5 is no longer supported. If you cannot upgrade to V5R2 you
will probably need to change the naming scheme.