Here is an easier way. (OS/390 VERSION 7.1).

SELECT * FROM SYSIBM.SYSTABLES WHERE CREATOR = 'SYSIBM' ORDER BY NAME;


-----Original Message-----
From: gsturkenboom
[mailto:db2udbdba-ezmlmshield-x62403240.[Email address protected]
Sent: Monday, September 27, 2004 5:19 PM
To: LazyDBA Discussion
Subject: Re: system catalog tables in OS/390 & AS/400???



Computer Associates (ca.com) put out a poster labelled 'DB2 for z/OS and
OS/390 System Catalog V7'

This contains all the DB2 System tables and relationships for DB2 V7. I
don't know about AS400.This might be useful for you.


|---------+--------------------------------------------------------->
| | "Jayakumar " |
| | <db2udbdba-ezmlmshield-x85116577.[Email Address Removed] | azydba.com> |
| | |
| | 28/09/2004 02:43 |
| | |
|---------+--------------------------------------------------------->

>---------------------------------------------------------------------------
-------------------|
|
|
| To: "LazyDBA Discussion" <[Email address protected]
|
| cc:
|
| Subject: system catalog tables in OS/390 & AS/400???
|

>---------------------------------------------------------------------------
-------------------|




I am new to DB2 on OS/390 & AS/400 systems.... I like to extract table
schema, views, sequences, stored procedures from the DB2 database on OS/390
& AS/400...
I like to know the system catalog table names for OS/390 & AS/400...
Please point to me some doc where I can get all these information...

Thank you & hope to hear your feedback...
regards,
Jayakumar


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html








---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page