Disable Automatic Storage

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

myjish18@gmail.com - 15 Jan 2008 16:38 GMT

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.

Reply to this Message

Ian - 16 Jan 2008 19:31 GMT

> Hello,
>
[quoted text clipped - 3 lines]
> 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.

Reply to this Message

tojigneshshah@gmail.com - 17 Jan 2008 20:11 GMT

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.

> myjis...@gmail.com wrote:
> > Hello,
[quoted text clipped - 20 lines]
> with automatic storage to standard DMS/SMS tablespaces using
> LOAD FROM CURSOR, INSERT INTO ... SELECT, etc.

Reply to this Message

Jean-Marc Blaise - 19 Jan 2008 11:28 GMT

Hi Myjish,

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

Regards,

JM

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.com> wrote:

> myjis...@gmail.com wrote:
> > Hello,
[quoted text clipped - 20 lines]
> with automatic storage to standard DMS/SMS tablespaces using
> LOAD FROM CURSOR, INSERT INTO ... SELECT, etc.

Reply to this Message