468,268 Members | 1,586 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,268 developers. It's quick & easy.

Disable Automatic Storage

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.
Jan 15 '08 #1
3 4144
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.
Jan 16 '08 #2
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 <ianb...@mobileaudio.comwrote:
myjis...@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 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.
Jan 17 '08 #3
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 <ianb...@mobileaudio.comwrote:
myjis...@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 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.

Jan 19 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Jurgen Haan | last post: by
4 posts views Thread by Philip Nelson | last post: by
3 posts views Thread by Laurence | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.