cancel
Showing results for 
Search instead for 
Did you mean: 

DB2 10.5 Converting table spaces to use automatic storage

0 Kudos
594

Hi

I will be upgrading to db2 v10.5 from v9.5 . The upgrade path will be v9.5 to v9.7 and to v10.5

I need to convert the DMS tablespaces to use automatic storage.

As per the documentation , I need to do the following steps

1> enable the database to use automatic storage with the 'ALTER DATABASE' statement

2> For each tablespace:

     Issue the ALTER TABLESPACE statement, specifying the MANAGED BY AUTOMATIC STORAGE clause

3> Issue the ALTER TABLESPACE statement again, this time specifying the REBALANCE option

My database is 4TB. The 2-hop upgrade needs to be done in minimal time

There will not be sufficient time to rebalance every tablespace in the database.

my questions :

> Can the upgraded database be released for use while rebalance is running ?

> Do I need to convert all the tablespaces at once ? or can the database operate with a mix of DMS + autostorage tablespaces

> Is it necessary to have seperate storage paths for data and index tablespaces ?

Regards

Warren

View Entire Topic
maria_shen
Contributor
0 Kudos

Hello Warren,

1. You may not able to do the UDIs while the rebalance is still in progress.
(Tablespace state 0x10000000) 

2. Technically it could be possible to have the mix.

3. Not necessarily.

The mentioned steps are OK. But you may also consider to try following steps on a test server, where the database is already on 10.5.

- Create automatic managed tablespaces (via dbacockpit)
- Do online table movement using latest version of DB6CONV. (SAP note#1513862 )
* A guide is attached in the note.

Kind regards
Maria

0 Kudos

Hi Maria

Thanks for your advice

What do you mean by UDI ?

The online table movement using DB6CONV is a helpful option, but is it really practical to move a huge table online without having a performance degradation ?

This is something that I may not be able to simulate on a test box, without online users.

Anyone has run DB6CONV on a fully loaded production system with minimum performance disruption ? Appreciate any advise on how to perform table move with least impact

Any pros & cons for table move v/s table rebalance

Thanks & regards

Warren

Former Member
0 Kudos

Hi Warren,

We ran DB6CONV with minimal downtime on our two large tables.

Follow below steps:

Implement Note 1513862 (DB6CONV)

DB6CONV report to compress table

Switch phase (During which table would be inaccessible) - Downtime (Hardly 5 mins)

DB6conv is suggestible.

Br, Vaibhav

0 Kudos

Hi Vaibhav

How large were the tables and how long did it take to complete ?

My largest table is about 900GB

Was there any performance impact during running the db6conv ?

Thanks

Warren

Former Member
0 Kudos

Hi Warren,

Out table size was ~ 400GB . As such no performance impact . But would suggest to start activity during weekend time or may be after business hour time frames.

Br, Vaibhav