IBM Db2 Big SQL

Supported versions

IBM Db2 Big SQL 10.5

Supported schema elements and metadata

Dataedo reads the following metadata from IBM Db2 Big SQL:

• Tables

  • Columns

    • Data type with length

    • Nullable

    • Default value

  • Primary keys

    • Columns

  • Unique indexes

    • Columns

  • Foreign keys

    • Columns

  • Triggers

    • When triggered

    • Script

• Views

  • Columns (see tables)

  • Script

• Materialized views

  • Columns (see tables)

  • Script

• Procedures

  • Script (for SQL procedures)

  • Parameters

• Functions

  • Script (for SQL procedures)

  • Parameters

  • Returned value

Data profiling

Dataedo supports the following data profiling in IBM Db2 Big SQL:

• Tables

  • Rows count

• Column distribution

  • Distinct values

  • Non-distinct values

  • Empty

  • NULL

• Numeric columns profile

  • Minimum value

  • Maximum value

  • Average of values

  • Variance of values

  • Standard deviation

  • Span as difference between min and max value

  • Number of distinct values

• String columns profile

  • Min value as first string in alphabetical order

  • Max value as last string in alphabetical order

  • Number of distinct values

• Date columns profile

  • Min value as earliest date

  • Max value as latest date

  • Span as difference between min and max dates

  • Number of distinct dates

• Top N values

  • Top 10/100/1000 popular values

  • All values if less than 1000 distinct

  • 10 Random values

Read more about profiling in the Data Profiling documentation.