468,272 Members | 2,007 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

enable automatic storage management or not?

Hi folks,

DB2 UDB supports automatic storage management in v8.2.2 and v9. The
question is how do I know the databases and/or tablespaces are enable
"automatic storage management" or not after created for a period of
time?
Thanks in advance,

Laurence

Apr 9 '07 #1
3 5990
Ian
Laurence wrote:
Hi folks,

DB2 UDB supports automatic storage management in v8.2.2 and v9. The
question is how do I know the databases and/or tablespaces are enable
"automatic storage management" or not after created for a period of
time?
Take a tablespace snapshot for your database, and look for the 'Using
automatic storage' entry for each tablespace:

db2 get snapshot for tablespaces on SAMPLE | \
egrep 'Tablespace name|automatic storage'

Apr 9 '07 #2
Thanks for the reply.

Yes, it can check the automatic storage management is enabled or not,
but it does not show the detail setup attribute. Have any possible way
to show the detail setup attribute?

Apr 12 '07 #3
Ian
Laurence wrote:
Thanks for the reply.

Yes, it can check the automatic storage management is enabled or not,
but it does not show the detail setup attribute. Have any possible way
to show the detail setup attribute?
OK, you can see this information from db2pd -tablespaces, in the
Tablespace Autoresize Statistics.
Apr 12 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Rasmus Fogh | last post: by
9 posts views Thread by Bryan Bullard | last post: by
4 posts views Thread by Philip Nelson | last post: by
14 posts views Thread by Richard Harter | last post: by
58 posts views Thread by Jorge Peixoto de Morais Neto | last post: by
3 posts views Thread by myjish18 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.