Learn querying DB2 system catalog tables -basics

[awesomeweb...@gmail.com]

Learn DB2 system catalog tables
http://db2examples.googlepages.com/systemcatalogtables

[The Boss]

dcrun...@aim.com wrote:
> In article
> <d831e7b1-3942-4c5f...@c19g2000prf.googlegroups.com>,
> awesomeweb...@gmail.com says...

>>
>> Learn DB2 system catalog tables
>> http://db2examples.googlepages.com/systemcatalogtables
>

> Is this for mainframe only or even LUW users can use this.

It is definitely "mainframe only" (i.e. DB2 for z/OS; it isn't clear for
which release).
And (imho) it doesn't offer much added value over the catalog info in the
official documentation.

Check out this site from Quest Software:
http://www.toadworld.com/Downloads/ExclusiveToadWorldSoftware/tabid/78/Default.aspx
which offers (free) downloads for DB2 System Catalog reference tool for:
- DB2 LUW 8.2
- DB2 LUW 9.1
- DB2 z/OS v8
(and, for those also working with Oracle, a Data Dictionary tool and a
number of PL/SQL related tools)

HTH

--
Jeroen