Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Posts
    4

    Unanswered: IBM interested in your feedback on DB2 autonomic features

    I'm soliciting feedback from our users about our autonomic computing features. If you have used any of the following features, and would like to share positive or negative experiences, please contact me in confidence. We are interested in both your success stories, and constructive feedback.

    Please contact me directly at "light@ca.ibm.com", and entitle your e-mail "Autonomic Feedback".

    If you have a positive experience to share and would like us to use your experience in our marketing material (i.e. free advertising for you and your company) please indicate that we have your permission to do so. Otherwise, I will assume that whatever you send me is shared in confidence.

    Features:
    1. Deasign Advisor (db2advis, for indexes, MQT, MDC, partitioning)
    2. Configuration Advisor (AUTOCONFIGURE)
    3. Health Monitor
    4. Utility Throttling
    5. Self tuning BACKUP (enabled by default since v8.2)
    6. Self tuning LOAD (enabled by default since v5.0)
    7. Automatic Maintenance (automatic statistics, backup etc)

    Sam Lightstone
    DB2 Autonomic Computing Development
    DB2 Universal Database
    IBM Canada

  2. #2
    Join Date
    Nov 2005
    Posts
    4

    IBM interested in your experiences with Autonomic features in DB2 UDB

    IBM is interested in getting feedback on its autonomic computing features in DB2 UDB. If you have used any of the following features, and would like to share positive or negative experiences, please contact me in confidence. We are interested in both your success stories, and constructive feedback.

    Please contact me directly at light at ca.ibm.com, and entitle your e-mail "Autonomic Feedback".

    If you have a positive experience to share and would like us to use your experience in our marketing material (i.e. free advertising for you and your company) please indicate that we have your permission to do so. Otherwise, I will assume that whatever you send me is shared in confidence.

    Features:
    1. Deasign Advisor (db2advis, for indexes, MQT, MDC, partitioning)
    2. Configuration Advisor (AUTOCONFIGURE)
    3. Health Monitor
    4. Utility Throttling
    5. Self tuning BACKUP (enabled by default since v8.2)
    6. Self tuning LOAD (enabled by default since v5.0)
    7. Automatic Maintenance (automatic statistics, backup etc)

    Sam Lightstone
    DB2 Autonomic Computing Development
    DB2 Universal Database
    IBM Canada

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    1. Design Advisor (db2advis, for indexes, MQT, MDC, partitioning)

    The indexes recommended are often not necessary, and for some inexplicable reason, they all came out with DESC specified, even though there were no ORDER BY's in descending sequence in the queries. Not all Foreign keys should be indexed. Overall, too many indexes are recommended, and this hurts performance. Indexes are not free. This feature is worthless IMO, unless the DBA is a complete novice or does not understand DB2 indexing and performance. Actually, it is much worse than worthless because I have to argue with people who have used it and take it as gospel.

    2. Configuration Advisor (AUTOCONFIGURE)

    This needs to be much more sophisticated, and take into account things like complex java applications, use of lots of SP's, use of lots of LOB's, connection concentrator (ESE), and many other configuration parms that are left out. Needs much more work. In short, Every Single Configuration Parm needs to included based on interview questions or automatic querying of the catalog for objects (for both db and dbm level).

    Here is the recommendation in the manual for configuring app_ctl_heap_sz:

    "Recommendation: Initially, start with the default value. You might have to set the value higher if you are running complex applications, if you have a system that contains a large number of database partitions, or if you use declared temporary tables. The amount of memory needed increases with the number of concurrently active declared temporary tables. A declared temporary table with many columns has a larger table descriptor size than a table with few columns, so having a large number of columns in an application’s declared temporary tables also increases the demand on the application control heap."
    All of the above conditions should be programmed into the configuration advisor.

    3. Health Monitor

    I shut this off on every system so I can't really say. Interface is a bit complex and klunky (like Control Center).

    4. Utility Throttling

    Good idea and probably works fine, but have not had to use it yet.

    5. Self tuning BACKUP (enabled by default since v8.2)

    Seems to work OK, but how would I know for sure?

    6. Self tuning LOAD (enabled by default since v5.0)

    Seems to work OK, but how would I know for sure?

    7. Automatic Maintenance (automatic statistics, backup etc)

    Is this a virus or is it just spam? Generates so many messages in db2diag.log at level 3 (even when no errors), that I shut it off.
    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
  •