(AST) Automatic Storage – Tips and Tricks

You may also like...

7 Responses

  1. rajesh pandhare says:

    Very useful information Michael, last 2 db2pd usages are like icing on cake, thank you for all info and Best of luck for DB2GotTalent, I will sure vote for you guys.

  2. Isaac Munoz says:

    Hi Michael, thanks for the article

    Another nice trick using ASM (or AST) is that you can setup HADR and the standby does not necessarily needs to have the same db storage paths and it works!!. Just for cases where you need to test anything in particular and have enough space available to contain your database on the standby server but don’t have the time for Unix admins to allocate and create the original filesystems/paths.

    Regards

  3. Nice article, confusing abbreviation. Every time I think “Ah, you are going to write about the new taks scheduler” http://www.ibm.com/developerworks/data/library/techarticle/dm-0809see/. But that is ATS and you talk about AST…

    b.t.w. I found out that new storage paths do not need to be “altered” to the database 1st. You can add a new path to a stogroup directly. I that is a “bug or a ferature” I do not know 🙂

    • Ember Crooks says:

      I believe data is not rebalanced when you add a path. I think it is only available for new containers, and you still have to be careful about having differing container sizes.

  1. March 24, 2014

    […] (AST) Automatic Storage – Tips and Tricks […]

  2. July 22, 2014

    […] these blog entries for more detailed information on Automatic Storage Tablespaces: (AST) Automatic Storage – Tips and Tricks Automatic Storage Tablespaces (AST): Compare and Contrast to […]

Leave a Reply

Your email address will not be published. Required fields are marked *