By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,919 Members | 1,047 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,919 IT Pros & Developers. It's quick & easy.

Disable Automatic Storage

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.