12.8. Generating Data Definition Language

So far this chapter has introduced tools and utilities that you can use to extract data and table definitions using export. In cases when you just want to extract the definition of a table, the db2look command comes very handy.

db2look extracts the Data Definition Language (DDL) of database objects. Besides that, the tool can also generate the following:

  • UPDATE statistics statements

  • Authorization statements such as GRANT statements (also known as the Data Control Language (DCL)

  • update commands for the following Database Manager Configuration parameters:

    - cpuspeed

    - intra_parallel

    - comm_bandwidth

    - nodetype

    - federated

    - fed_noauth

  • update commands for the following database configuration parameters:

    - locklist ...

Get Understanding DB2®: Learning Visually with Examples now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial