Tuesday, June 22, 2010

Access Your DB2 Catalog "Poster" Online

If you're anything like me, you're constantly looking for DB2 Catalog table and column names. For writing catalog queries, for examining statistics, for looking at your table and tablespace parameters, for many, many things. But it is not very easy to keep reaching for the DB2 manuals (Which manual is it in? Which appendix was that? Why did they put it there? Did they move it?)...

So, many of us gladly tacked up those posters from Platinum Technology that graphically depicted the DB2 Catalog... and then later similar posters from CA, Inc, and BMC Software... but those posters have grown is size (as has the DB2 Catalog)... and the posters have become less useful over the years because they contain less information and the smaller type.

Well, here comes a solution from zSystems and SoftwareOnZ: a free and very easy to use online DB2 Catalog reference application.

If you can use a web browser and a mouse then you can find the DB2 Catalog information you desire. Simply point and click on the appropriate table and you'll get its definition along with a listing of its columns and their data type and length. And you'll also get information about which columns participate in any indexes and what type of index (primary, unique, duplicate index).

Not only that, there is both a V8 and V9 edition of the DB2 Catalog so you can easily toggle back and forth between the two versions. That is very handy for sites that have some V8 subsystems and some V9 subsystems!

So if you are looking for a better way to view your DB2 Catalog information, be sure to check out the online DB2 Catalog reference from zSystems.

7 comments:

  1. Anonymous4:08 PM

    This is great stuff. I will definitely bookmark
    that URL. Thanks very much!!

    Regards,
    Denise

    ReplyDelete
  2. Anonymous9:42 AM

    Thx a lot ! A helpful link, used on and on.

    Regards
    Dan

    ReplyDelete
  3. Poster is a good way to promote your business and with the help of Microsoft and other web tools we can easily design the posters for our company and firm

    ReplyDelete
  4. Thanx a lot ! A helpful link Gifts

    ReplyDelete
  5. After going over a few of the blog posts on your web page,
    I honestly like your way of writing a blog. I bookmarked it to my bookmark webpage list and will be checking back soon.
    print diary 2022
    Take a look at my website too and let me know how you feel.

    ReplyDelete
  6. Anonymous9:43 AM

    Unfortunately the links are not opening for me.. any ideas ?

    ReplyDelete
  7. Well, this post was first published over a decade ago, so unfortunately, the links are no longer active. BMC still publishes a Db2 Catalog poster though. Check it out at https://www.bmc.com/forms/db2-reference-guide.html

    ReplyDelete