Note: this post refers to an obsolete version of the IBM DB2 Knowledge center, and therefore many of the links are broken. For details on the current version, see The New IBM DB2 Knowledge Center
The IBM DB2 Information Center is a wonderful resource if you know what you’re looking for. Unfortunately, sometimes you do not know exactly what you are looking for. A bit of knowledge about what is there, how it is organized, and how to most efficiently use the IBM DB2 Information Center can go a long way. Experienced DBAs tend to respond to some questions with “It is in the Info Center”, while new DBAs are thinking “Yes, but WHERE?”.
I started as a DBA before the DB2 Info Center was mainstream. Everyone on my team in IBM Global Services had their own shelf of DB2 reference manuals, and some of us got extra or old copies of some of the more important ones for home as well. Don’t get me wrong, the documentation was online and we started using it more and more over time. I still have my shelf of Version 8 manuals at home.
I actually cracked one last year before I had installed a local version of the DB2 Information Center, and desperately needed a bit of syntax help that wouldn’t have changed much by versions.
The manuals did not have a search feature or even a global index. In some ways, this actually helped us to know how they are organized and how to find what we really needed. Don’t get me wrong, I’m a huge fan of search, and use it constantly, but there is sometimes some information that is hard to get a relevant search on. It can be useful to really understand the structure of the IBM DB2 Information Center and how to use it.
If you’re a new DBA, don’t think you will ever get a chance to get away from the Information Center. You will simply never know every detail and all syntax. Even without blogging, I visit it every single day that I work, and I have a significant amount of DB2 experience.
Also, I’m not saying that the IBM DB2 Information Center should be your only source of information – there are many good forums and blogs that, along with developerWorks and the support portal, provide a much more complete view. But the IBM DB2 Information Center should still be one of your sources of information.
While I’m covering this from a very beginner standpoint, there are some more advanced tips here as well.
How to Pull Up the IBM DB2 Information Center
The IBM DB2 Information Center is available online. There is a different Information Center for each version of DB2. If you come up with an IBM DB2 Information Center link when googling, make sure it looks like these – the ones for Z/OS may also come up in searches, and DB2 is fairly significantly different between the platform groups. The LUW IBM DB2 Information Centers are:
- DB2 8.2: http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp
- DB2 9: http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp
- DB2 9.5: http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp
- DB2 9.7: http://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.kc.doc/welcome.html
- DB2 10.1: http://pic.dhe.ibm.com/infocenter/db2luw/v10r1/index.jsp
- DB2 10.5: http://pic.dhe.ibm.com/infocenter/db2luw/v10r5/index.jsp
I keep the two or three IBM DB2 Information Centers for the versions my clients are currently using bookmarked so I can easily get to them.
Some IBM Information Centers won’t always come up in my browser of choice (Chrome). If you get a blank page, try with Internet Explorer, and it will likely work. It looks to me like they fixed it with the IBM DB2 10.5 Information Center, but for DB2 9, the issue still exists. This is true for Information Centers for other IBM Products, too.
Also, like any web resource, the IBM DB2 Information Centers are sometimes offline. To mitigate against this, I recommend downloading your own copy of the DB2 Information Center that you work with most often. You can install it and run it on your local computer, so it is never offline. My blog entry on how to do that is here: How to Install a Local Copy of the DB2 Info Center on a Windows Machine
I’m going to focus on the IBM DB2 9.7 Information center in the rest of this post and the other posts in this series – the other versions of the IBM DB2 Information Center are similar.
Overview and Buttons
By far the most used and useful place to start is the search box at the upper left. Put in any relevant string or error message and you’ll likely get back some decent search results. But there are other things to look at here. Let’s focus on the left pane first:
In this case, I’ve entered a basic search term, and you can see the results of that search in this left pane. You can click on any of the results in blue to pull up that page in the right pane.
This may be useful if you really are looking only for one type of information, or if you get frustrated with some of the superfluous results that the info center sometimes comes up with. Changing this will eliminate some results, so be careful that you’re aware of what you’ve set this to if you’ve changed it.
When you’ve done a search the right one will be the active one – it is for search results. The middle one is the “index” and the left one is the table of contents. The table of contents is what is in the left tab when you first pull up the IBM DB2 Information Center. The Index is somewhat like searching the info center, but think of it a little more like the index to a book – there are only certain topics listed there and your search results are limited to what someone thought you might need.
This is what it looks like for the Search tab. These buttons can change how search results appear. The left one will cause results to be displayed by category. Categories that show up for this particular search include things like:
- Data warehousing and analytics
- Database administration
- Database application development
- Database fundamentals
- Product overviews
- Replication and event publishing
This view can be useful if you’re having trouble finding what you are looking for. In this case, if I was simply looking for the syntax of the command, it’s in the “Database administration” section. But more general information might be in the “Database fundamentals” section.
The middle of these three icons toggles descriptions on or off – in the view above, descriptions are on. The description is the black text associated with each link. Turning them off can get a more compact view and may be more useful when you already know what you’re looking for.
The final icon on the right will allow you to maximize this left pane to take up your whole screen – which might be useful if you want to see more of the descriptions. However, to see any link you click on, you’ll have to minimize it again so that the right pane is visible again.
When using the Contents bottom tab, these buttons will instead look like this:
The left button is clearly a print button. Not exactly sure why you would want to print the contents, but then I rarely print anything at all any more. The next icon that looks like a flashlight allows you to perform a search only in the topic you’ve selected – much like setting the scope with the search box above.
The next icon with a minus simply allows you to quickly minimize all topics. 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.
The left two are pretty obvious – forward and back buttons. Though generally forward and back in your browser works just fine. The home button simply gets you back to the starting page for the info center, which can be occasionally useful if you don’t want to reload the whole thing.
The next button is the most interesting thing here. It looks like a short hierarchy with some arrows. This is to locate a page you happen to be looking at in the table of contents. This will show you where in the categories and so forth at the left that whatever page you are on fits. This is great for getting to know the IBM DB2 Information Center, and can be helpful for certain kinds of research.
The printer button helps you print what is in the right pane without all the other web stuff. And at the far right is the maximize button, which can make the right pane take up the full screen.
Generally, the right pane is the content pane. There is in some of the later IBM DB2 Information Centers a community section at the bottom. I’m not a fan, but I’m used to using developerWorks or Stack Exchange or whatever for that sort of thing.
One very disappointing thing is that I’ve found the IBM DB2 Information Center to be near unusable on a smart phone and hardly much better on a tablet. You simply can’t scroll and resize things like you might need to on these devices to use the IBM DB2 Information Center. I sure hope they fix this at some point. Maybe I’m just an uber-geek, but working on multiple screens when out and about and having this access would really help me.
How to Link to Pages in the IBM DB2 Information Center
You may notice that as you click around or go to different pages, the address up in your address bar does not change. This makes it a bit difficult to send a link to a specific page to someone else – for reference or education. But at the bottom of every page, you’ll find a link:
It is different for each page, and is not actually a link, but is an address you can copy and paste into the address bar of a browser to get to that specific page. That’s what I copy to share IBM DB2 Information Center pages on the blog and elsewhere.
Notice in that image too, there’s a “Feedback” button. That appears on every page. I’ve actually had a good response using that to report errors I’ve found with the IBM DB2 Information Centers, and been instructed a few times on how I’m looking at something wrong – so IBM does pay attention.
There ended up being a lot of information to share here, so I’m splitting this entry up into multiple parts. Keep your eyes open for future entries covering the structure of information within the IBM DB2 Information Center and things like how to read syntax diagrams.