My account
Book a demo
Search
product
product
Data Catalog
Data Community
Business Glossary
Data Profiling
Data Lineage
Reference Data Management
Report Catalog
Sensitive Data Discovery
Data Dictionary
Database Documentation
ER Diagrams
Schema Change Tracking
Supported
Technologies
See all features →
Solutions
Solutions
Metadata Management: Why Start Now?
By Use Case
Business Intelligence
Data Warehousing
Data Governance
Data Protection
Metadata Management
All Use Cases
By Industry
Financial Services
Healthcare
Public & Government
Education
Technology
All Industries
By Technology
SQL Server
Snowflake
Power BI
Azure
AWS
Supported Technologies
See all →
Pricing
Company
Why Dataedo?
About us
Careers
Our Customers
Case Studies
Testimonials
Contact Us
Resources
Resources
Dataedo Cartoons
General
Blog
Webinars
Videos
Library
Dataedo Cartoons
Dataedo
Documentation
Tutorials
Free trial
Download
Support
Contact support
Documentation
Tutorials
Free trial
Product tour
Database Data Dictionary Query Toolbox
IBM Db2 Data Dictionary Query Toolbox
Databases and schemas
List schemas in Db2 database
List user created schemas in Db2 database
Tables
List tables in Db2 database
List tables in Db2 database schema
List temporal tables in Db2 database
List materialized query tables in Db2 database
Find recently created tables in Db2 database
Find recently modified tables in Db2 database
Columns
List table columns in Db2 database
List all columns in specific table in Db2 database
List all computed columns in Db2 database
Views
List views in IBM Db2 database with their scripts
List views columns in Db2 database
List objects used by a view in Db2 database
Primary keys
List all primary keys (PKs) in Db2 database
List all primary keys (PKs) and their columns in Db2 database
List tables with their primary keys (PKs) in Db2 database
Find tables without primary keys (PKs) in Db2 database
How many tables don't have primary keys (with percentage) in Db2 database
Foreign keys
List foreign keys in Db2 database
List foreign keys with columns in Db2 database
List table columns with their foreign keys in Db2 database
List all tables refrenced by specific table (by FK) in Db2 database
List all tables refrencing specific table (by FK) in Db2 database
List tables with most foreign keys in Db2 database
List most referenced tables in Db2 database (by FK)
List tables with most relationships in Db2 database
Find tables without foreign keys in Db2 database
Find tables that are not referenced by the foreign keys in Db2 database
Find tables without relationships - Loner Tables - in Db2 database
Loner Ratio - how many tables have no relationships in Db2 database
Unique keys
List unique keys and indexes in DB2 database
Check constraints
List all check constraints in Db2 database
List table check constraints in Db2 database
Default values
List table default values in Db2 database
Constraints
Find required (non nullable) columns in Db2 database
Check if is column nullable in Db2 database
Indexes
List all indexes in the Db2 database
List table indexes in Db2 database
List unique indexes in the Db2 database
Data types
Find most used data type in IBM Db2 database
Find all numeric columns in Db2 database
Find all string columns in Db2 database
Find all date and time columns in Db2 database
Find all XML data columns in Db2 database
Find large object (LOB) data type columns in Db2 database
Find tables with large object (LOB) data type columns in Db2 database
Triggers
List triggers in Db2 database
List triggers by table name in Db2 database
Functions and stored procedures
List user defined routines in Db2 database
List stored procedures in Db2 database
List stored procedure parameters in Db2 database
Dependencies
Find tables and views used by specific view in Db2 database
Find objects used by specific function in Db2 database
Find objects used by specific stored procedure in Db2 database
List tables used by Materialized Query Tables (MQT dependencies) in Db2 database
Searching schema
Find a table by the name in Db2 database
Find tables with names with specific prefix in Db2 database
Find tables with names with specific suffix in Db2 database
Find tables with specific word in name in Db2 database
Find tables with digits in names in db2 database
Find tables with specific column name in Db2 database
Find table that DON'T have a column with specific name in Db2 database
Schema statistics
Find number of tables in Db2 database
Find number of columns in Db2 database
List tables with the largest number of columns in Db2 database
Average number of columns per table in Db2 database
Schema naming
Find most popular column names in Db2 database
Get column name length distribution in Db2 database
List columns by name length in Db2 database
Security and users
List users in Db2 database
Environment
How to check IBM Db2 edition
How to find operating system (OS) that IBM Db2 server runs on
Number of rows
List tables by the number of rows in Db2 database
Find empty tables in Db2 database
Number of tables by the number of rows in Db2 database
Data size
List tables by their size in Db2 database
List idexes by their size in Db2 database
List tables by the size of their indexes in Db2 database
Find database size allocated for LOB data in Db2 database
Data usage
Find the time when table was last accessed in Db2 database
Find tables not accessed for past n months in Db2 database
Schema compare
Compare tables and columns in two schemas in Db2 database
Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please
accept statistics cookies
.
0
There are no comments.
Click here
to write the first comment.
Please enable JavaScript to view the
comments powered by Disqus.
All Use Cases
