• 4 replies
  • Latest Post - ‏2012-11-20T23:45:35Z by SystemAdmin
17917 Posts

Pinned topic Tablspaces after upgrade

‏2012-11-15T16:02:17Z |
Hi all,

I have recently advised a customer to distribute their tables more evenly over tablespaces to help with backup performance in their SAP EWM system.

They had no problem doing so, but are soon upgrading from version 9.7 to 10.1. Their question was whether the tablespace layout, if they changed it now, would have to be redone after upgrade.

I told them that I saw not reason why this would be the case, but as I'm more performance-oriented, I was wondering if somebody would be kind enough to confirm it for me.

Thanks in advance.
  • SystemAdmin
    17917 Posts

    Re: Tablspaces after upgrade


    One of the new features in DB2 10 is multi-temperature data, which means that a given table space is spread over different kind/speed of disks.

    A tablespace created over just one disk will not use this feature. However, if you configure it for multiple types of disks, the data will the classified in different sets (hot, warn, cold for example).

    If all data is currently in just one tablespace (or just a few) this feature will not improve any performance at all, because not all data has "multiple temperature".

    Your client should group data with similar characteristic, in order to configure tablespace according to these characteristics. After this grouping, one or some of them will use Multi-temperature, but not all tablespaces.

    I think this is the only new feature related to table space in DB2 10. So, I advise to distribute data across multiple tablespaces.
  • jmueller
    71 Posts

    Re: Tablspaces after upgrade


    for further Information "What's new" you will find more Information in SAP-Note 1700631:

    Overview of new functions and their use with SAP applications:
    Automatic reclamation of index space
    Insert time clustering (ITC) tables with automatic space reclamation
    Automatic sampling for automatic runstats
    Enhanced Automatic Table Maintenance
    HADR multiple standby servers with delay
    Integration of the DB2 pureScale feature
    Enhanced monitoring
    Multi-temperature storage
    Enhanced multi-core parallelism
    Adaptive compression
    Log archive compression
    Smart prefetching
    Performance improvements

    Best regards
  • SystemAdmin
    17917 Posts

    Re: Tablspaces after upgrade

    Thanks very much for the information.


  • SystemAdmin
    17917 Posts

    Re: Tablspaces after upgrade

    Hi there,

    The information in the DB2 IC is at:
    Data management using multi-temperature storage

    There is also a best practice article:
    Multi-temperature data management

    Hope this helps,