system table map

ksexton · #1 (**permalink**) 02-20-04, 13:12

I want to query system objects to return info. about my user objects.
In SQL Server I use the system tables. I think you use views in Oracle.

I wrote this query: (but it is not a system TABLE)
SELECT tabname,colname
FROM SYSCAT.COLUMNS
WHERE TABSCHEMA ='my_user_schema' and
colname like '%_CD'

Is there a graphical ER diagram of these system objects on the web?

ARWinner · #2 (**permalink**) 02-20-04, 13:38

Try this site:

http://www.quest.com/requests/?RequestDefID=1387

It is to download a poster of the system catalogs.

Andy

ksexton · #3 (**permalink**) 02-20-04, 13:45

This is a useful tool to work with the system objects but I don't see a map.

Marcus_A · #4 (**permalink**) 02-20-04, 14:06

BMC publishes a ER diagram poster for the mainframe DB2 catalog, so you might check with them to see if they have on for DB2 LUW. You might have to contact a sales rep.

ARWinner · #5 (**permalink**) 02-20-04, 14:11

BMC does have one for UDB LUW, I have one on my wall.
I have not been able to find one yet on the web.

Andy

ARWinner · #6 (**permalink**) 02-20-04, 14:14

Here are some for OS/390:

http://ca.com/products/posters/download.htm

Andy

ksexton · #7 (**permalink**) 02-20-04, 19:02

Great maps. My only experience with Unix is Solaris. I take it from the different maps that these are different flavors of UNIX and DB2 has different system tables depending on the operating system?

Forgive my ignorance.

-K

sathyaram_s · #8 (**permalink**) 02-20-04, 19:22

The system tables are the same across all Unix platforms

Cheers
Sathyram

Quote:

Originally posted by ksexton
Great maps. My only experience with Unix is Solaris. I take it from the different maps that these are different flavors of UNIX and DB2 has different system tables depending on the operating system?

Forgive my ignorance.

-K

Internet Services

Web Development

Digital Marketing

Consumer Tech