Redirected restore DMS -> SMS (or automatic storage) possible?

[Kofa]

Dear All,

I'd like to know whether it is possible to restore backups created on
a production machine, running DB2 9.1 on Windows, using DMS table
space containers, onto a developer's machine, also running DB2 9.1 or
9.5 on Windows in a way that does not require the use of DMS table
space containers.

The reason is that on the production machine, where we wanted to
obtain the highest possible performance, user and temp tablespaces
reside on unformatted partitions U and T, respectively. Of the two, U
is huge (it will accumulate sales data for possibly a decade).
Currently, we do not have more data that a few hundred megabytes in
the user table space at any installation. For troubleshooting and
testing purposes, we'd like to download a backup and restore it on a
developer PC without setting up the same partitions - in fact, without
setting up fixed-size DMS containers of any kind, if possible.

Your help is much appreciated.

TIA,
Istvan

[m]

Re: Redirected restore DMS -> SMS (or automatic storage) possible?

Kofa wrote:

Dear All,
>
I'd like to know whether it is possible to restore backups created on
a production machine, running DB2 9.1 on Windows, using DMS table
space containers, onto a developer's machine, also running DB2 9.1 or
9.5 on Windows in a way that does not require the use of DMS table
space containers.
>
The reason is that on the production machine, where we wanted to
obtain the highest possible performance, user and temp tablespaces
reside on unformatted partitions U and T, respectively. Of the two, U
is huge (it will accumulate sales data for possibly a decade).
Currently, we do not have more data that a few hundred megabytes in
the user table space at any installation. For troubleshooting and
testing purposes, we'd like to download a backup and restore it on a
developer PC without setting up the same partitions - in fact, without
setting up fixed-size DMS containers of any kind, if possible.
>
Your help is much appreciated.
>
TIA,
Istvan

From what I know - it is NOT possible to do a redirected restore from
one type of *MS to another - all a redirected retstore does is allows
for a change in tablespace containers - NOT a change in tablespace types.

[daiesy.ember@gmail.com]

Re: Redirected restore DMS -> SMS (or automatic storage) possible?

On Jun 12, 4:15 am, Kofa <kovacs...@gmai l.comwrote:

Dear All,
>
I'd like to know whether it is possible to restore backups created on
a production machine, running DB2 9.1 on Windows, using DMS table
space containers, onto a developer's machine, also running DB2 9.1 or
9.5 on Windows in a way that does not require the use of DMS table
space containers.
>
The reason is that on the production machine, where we wanted to
obtain the highest possible performance, user and temp tablespaces
reside on unformatted partitions U and T, respectively. Of the two, U
is huge (it will accumulate sales data for possibly a decade).
Currently, we do not have more data that a few hundred megabytes in
the user table space at any installation. For troubleshooting and
testing purposes, we'd like to download a backup and restore it on a
developer PC without setting up the same partitions - in fact, without
setting up fixed-size DMS containers of any kind, if possible.
>
Your help is much appreciated.
>
TIA,
Istvan

You cannot go from DMS to SMS. You can, however specify file rather
than device containers for your DMS tablespace - using a redirected
restore and the set tablespace containers command - that would get
around your device issue at least. So that doesn't resolve the whole
issue. Perhaps the db2move utility would be helpful to export and load
or import the data instead of doing a backup/restore.

Ember