My account
Book a demo
Search
Product
Key Features
Data Catalog
Catalog all your data, reports, and collaborate with your data community.
Data Lineage
Create a map of your data flow with automated lineage on object and column level.
Data Quality & Profiling
Improve data quality and increase trust in your data with data profiling, lineage & more.
Dataedo AI
Create auto object descriptions and get help from AI chat in finding tables & writing queries.
Business Glossary
Build and share a universal glossary of business terms, policies and rules.
Data Classification
Find and tag sensitive data in your databases to comply with data protection regulation.
See all features →
More Features
Data Community
Domains
Reference Data Management
StewardHub
Schema Change Tracking
Workflows
Technologies
Connectors
SQL Server
Snowflake
Power Bi
Tableau
Qlik Sense
soon
Databricks
Microsoft Fabric
Azure
AWS
Oracle
All Connectors →
Learn More
Metadata Scanning
Solutions
By Use Case
Data Governance
Data Quality
Selft-Service Analytics
Data Protection
Business Intelligence
Data Warehousing
Metadata Management
All Use Cases →
By Industry
Financial Services
Healthcare
Public & Government
Education
Technology
Retail
Energy & Utilities
All Industries →
Pricing
Resources
Learn About Dataedo
Documentation
Roadmap
Tutorial Videos
Dataedo Bootcamp
Downloads
Learn About Data
Blog
Webinars
Tutorials
Knowledge Base
Data Events
After Hours
Data Cartoons
Cartoon Ebooks
About us
About us
Why Dataedo
Our Customers
Our Partners
Careers
Contact Us
Book a demo
Try Dataedo
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