Disable Automatic Storage

[myjish18]

Hello,

We have a DB2 UDB database v8.2.7 (db2 v8.2 fixpak 14) on AIX 5.3
which has Automatic Storage (AS) enabled. We want to disable
automatic storage on entire database and/or disable automatic storage
on all tablespaces. DB2 Manual says it once AS is enabled, it cant be
changed. Is there any way to disable the AS or any other alternative?

Please advice.

Thanks in advance.

Myjish.

[Ian]

my******@gmail.com wrote:

Hello,

We have a DB2 UDB database v8.2.7 (db2 v8.2 fixpak 14) on AIX 5.3
which has Automatic Storage (AS) enabled. We want to disable
automatic storage on entire database and/or disable automatic storage
on all tablespaces. DB2 Manual says it once AS is enabled, it cant be
changed. Is there any way to disable the AS or any other alternative?

There is no direct migration path for tablespaces that are currently
managed by automatic storage. However, you don't have to use automatic
storage in a database that has been been configured to use automatic
storage.

There are 2 things you can do:

1) You can always alter the existing tablespaces that are managed by
automatic storage to disable autoextend.

2) You can create new tablespaces that are MANAGED BY SYSTEM and/or
MANAGED BY DATABASE, using whatever container definitions you
want. This could allow you to migrate tables from tablespaces
with automatic storage to standard DMS/SMS tablespaces using
LOAD FROM CURSOR, INSERT INTO ... SELECT, etc.

[tojigneshshah]

There are 2 things with AUTOMATIC SPACE MANAGEMENT,
1. AUTOMATIC STORAGE and
2. AUTORESIZE.

I believe, DB2 allows to ENABLE/DISABLE AUTORESIZE for a Tablespace
but not for AUTOMATIC STORAGE.

Infact, i do not see any db2 syntax which DISABLES Automatic Storage.

I have system tablespaces which are defined as AUTOMATIC STORAGE. ie:
SYSCATSPACE, SYSTOOLSPACE etc. Is it possible or safe to export/import
from these tables?

Please advice.

Thanks,
Myjish.

On Jan 16, 2:31*pm, Ian <[e-mail]:

[e-mail] wrote:

Hello,

We have a DB2 UDB database v8.2.7 (db2 v8.2 fixpak 14) on AIX 5.3
which has Automatic Storage (AS) enabled. We want todisable
automatic storage on entire database and/ordisableautomatic storage
on all tablespaces. DB2 Manual says it once AS is enabled, it cant be
changed. Is there any way todisablethe AS or any other alternative?

There is no direct migration path for tablespaces that are currently
managed by automatic storage. *However, you don't have to use automatic
storage in a database that has been been configured to use automatic
storage.

There are 2 things you can do:

1) *You can always alter the existing tablespaces that are managed by
* * *automatic storage todisableautoextend.

2) *You can create new tablespaces that are MANAGED BY SYSTEM and/or
* * *MANAGED BY DATABASE, using whatever container definitions you
* * *want. *This could allow you to migrate tables from tablespaces
* * *with automatic storage to standard DMS/SMS tablespaces using
* * *LOAD FROM CURSOR, INSERT INTO ... SELECT, etc.

[Jean-Marc Blaise]

Hi Myjish,

Just for curiosity, why are you interested in disabling automatic storage ?
Do you have any problems with it ?

Regards,

JM
<to***********@gmail.comwrote in message
news:56**********************************@l32g2000 hse.googlegroups.com...
There are 2 things with AUTOMATIC SPACE MANAGEMENT,
1. AUTOMATIC STORAGE and
2. AUTORESIZE.

I believe, DB2 allows to ENABLE/DISABLE AUTORESIZE for a Tablespace
but not for AUTOMATIC STORAGE.

Infact, i do not see any db2 syntax which DISABLES Automatic Storage.

I have system tablespaces which are defined as AUTOMATIC STORAGE. ie:
SYSCATSPACE, SYSTOOLSPACE etc. Is it possible or safe to export/import
from these tables?

Please advice.

Thanks,
Myjish.


On Jan 16, 2:31 pm, Ian <[e-mail]:

[e-mail] wrote:

Hello,

We have a DB2 UDB database v8.2.7 (db2 v8.2 fixpak 14) on AIX 5.3
which has Automatic Storage (AS) enabled. We want todisable
automatic storage on entire database and/ordisableautomatic storage
on all tablespaces. DB2 Manual says it once AS is enabled, it cant be
changed. Is there any way todisablethe AS or any other alternative?

There is no direct migration path for tablespaces that are currently
managed by automatic storage. However, you don't have to use automatic
storage in a database that has been been configured to use automatic
storage.

There are 2 things you can do:

1) You can always alter the existing tablespaces that are managed by
automatic storage todisableautoextend.

2) You can create new tablespaces that are MANAGED BY SYSTEM and/or
MANAGED BY DATABASE, using whatever container definitions you
want. This could allow you to migrate tables from tablespaces
with automatic storage to standard DMS/SMS tablespaces using
LOAD FROM CURSOR, INSERT INTO ... SELECT, etc.