Tips for Using the IBM DB2 Information Center Part 1: Navigating

You may also like...

8 Responses

  1. Ember, great article, thanks! Appreciate the links to the IBM Information Center for each release of DB2 – this is so helpful that we’ve added the links to the bottom of http://www.DB2NightShow.com. Cheers, Scott Hayes

  2. Paul Dorwin says:

    Hi Ember,

    I enjoyed this article and picked up some tips on using the IBM Information Center. I asked around regarding
    The next button with two arrows going in two different directions is titled “Link with Contents”, but I couldn’t get it to do anything in any of my browsers. I’d welcome reader comments on its intended uses.

    This is the description of that button.. in the documentation in the Information Center itself:

    Information center – Navigating in the information center
    http://pic.dhe.ibm.com/infocenter/db2luw/v10r5/topic/com.ibm.db2.luw.common.doc/doc/navigating.html

    To keep the navigation tree and the topic pane synchronized at all times, click Link with Contents () on the toolbar of the Contents view. Click the button again to disable this function.

  3. Paul Dorwin says:

    Hi Ember,

    Here is how that double arrow icon works.

    When the background is white for that icon. Search for a term in the index. Click on link to that topic. When you go back to the TOC or “Contents” tab , whatever topic is on the right will synch to it’s location in TOC. When the background is grey, nothing happens.

    Same thing happens when you do a search. Click on a results from a search. With a white backrgound, when you head back to the “Contents” tab, the topic is synched with it location in the TOC. Grey background nothing happens.

  4. Shivraj says:

    Hi Ember

    I am avid follower of your blog. I would like to know how do you use IBM support site. Also, what recommendations do you give to a DBA who has a host of DB2 databases to tune .

    Look forward to your reply !

    • Ember Crooks says:

      I think that first would be a good blog topic to complement the Info Center series I’m working on.

      My number one choice for having a “number” of databases to tune – especially if that number is more than 10 production databases – would be to get a tool such as DBI Software’s tools (http://www.dbisoftware.com/). That said, I’ve rarely had actual paid tools myself. If you have to do it with no tools, you’ll want to script some stuff. I love this methodology: http://www.ibm.com/developerworks/data/library/techarticle/dm-1009db2monitoring1/index.html?ca=drs-. I like to extend that to include history tables that I write data off to every hour or two. It’s so important to have historical data, even if you can only keep a few days’ worth. Pulling the data into Excel and graphing it or using some other way of graphing it can really help you see trends and things that are related. The one-shot view that you get with just looking at one snapshot that covers everything since db restart can be good but can really hide issues. If it’s a single database to a single server environment, STMM can be your friend, though I always exclude the package cache from STMM.

      I could go on and on – it’s a big question. Take it one database at a time, and keep historical data would be my #1 tips.

      Ember

  1. July 30, 2013

    […] Check out Part 1 in this series: Tips for Using the IBM DB2 Information Center Part 1: Navigating […]

Leave a Reply

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