DB2: Export DB2's Data Dictionary

Techies,
I'm a DB2 newbie. I'm not quite used to the esoteric table names!;-) How do I get a data dictionary export from our dev instance--which-- I hope will provide a more verbose description of what these tables and attributes are trying to be.  
Paula DiTalloIntegration developerAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Kent OlsenConnect With a Mentor Data Warehouse Architect / DBACommented:
Hi ditallop,

I'm not sure what you're trying to get to, but I'd start with a query of the sysibm.tables and/or sysibm.columns views.  They pull most of the table/column definitions into easy to use views.


Kent
0
 
momi_sabagCommented:
you can also use the control center tool to see all tables, their columns etc
0
 
Paula DiTalloIntegration developerAuthor Commented:
Kent,

Thanks for pointing me to the system catalogs. What I had in mind was more of a description of the purpose of the column. For example:

ENO               Employee Number
BDLOI            Building Location Identifier

rather than:

ENO             CHARACTER 20
BDLOI          NUMERIC

0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Paula DiTalloIntegration developerAuthor Commented:

I am using Eclipse with an the IBM Data Studio plugin pointing to a development box--no control center here!;-)
0
 
Kent OlsenConnect With a Mentor Data Warehouse Architect / DBACommented:

Ok.  :)

The view syscat.columns has a column named 'remarks'.  If a descriptive comment was generated for your column, it would be there.


Kent
0
 
momi_sabagCommented:
one thing to note
it will only show remarks that people took the time to create using the comment on statement
you are not guaranteed to see something in the remarks column
0
 
Paula DiTalloIntegration developerAuthor Commented:

 Well, for a brief moment I was hopeful.


syscat.columns-def.PNG
0
 
Paula DiTalloIntegration developerAuthor Commented:
clearly my problems today are greater than which catalogs to review!:-)
0
 
Paula DiTalloIntegration developerAuthor Commented:
Kent, thanks for your help!
0
 
Kent OlsenData Warehouse Architect / DBACommented:

Which version of DB2 are you using?  (What O/S is on the server?)

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.