Solved

DB2: Export DB2's Data Dictionary

Posted on 2011-09-20
10
822 Views
Last Modified: 2012-05-12
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.  
0
Comment
Question by:ditallop
  • 5
  • 3
  • 2
10 Comments
 
LVL 45

Accepted Solution

by:
Kdo earned 500 total points
Comment Utility
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
 
LVL 37

Expert Comment

by:momi_sabag
Comment Utility
you can also use the control center tool to see all tables, their columns etc
0
 

Author Comment

by:ditallop
Comment Utility
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
 

Author Comment

by:ditallop
Comment Utility

I am using Eclipse with an the IBM Data Studio plugin pointing to a development box--no control center here!;-)
0
 
LVL 45

Assisted Solution

by:Kdo
Kdo earned 500 total points
Comment Utility

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
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
LVL 37

Expert Comment

by:momi_sabag
Comment Utility
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
 

Author Comment

by:ditallop
Comment Utility

 Well, for a brief moment I was hopeful.


syscat.columns-def.PNG
0
 

Author Comment

by:ditallop
Comment Utility
clearly my problems today are greater than which catalogs to review!:-)
0
 

Author Closing Comment

by:ditallop
Comment Utility
Kent, thanks for your help!
0
 
LVL 45

Expert Comment

by:Kdo
Comment Utility

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

0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now