Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: Question on applying Storage Optimization

    DB2 LUW version 9.7 running on Red Hat Linux.

    I want to activate the Storage Optimization feature via the db2so.lic license.
    I apply the license via db2licm.

    Is it mandatory that I bounce the instance to activate that feature?


  2. #2
    Join Date
    May 2003
    My recollection is that the SO Feature is available even if you don't apply the license, although they will catch up with you when IBM does an audit. One reason for that may be because it would be too difficult to remove the license if any tables and indexes are already compressed (if the license were enforced real-time). Considering that typical CPU utilization will skyrocket with compression, and most people pay for DB2 based on CPU cores installed on the database server (PVU's), IBM should be giving SO Feature away for free.

    You could easily test this by creating a test table with compression, even before you apply the license.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts