On this page:

Summary: this page explains how to generate DDL for a DB2 database using the using the db2look tool tool for use with the SQL Analyzer extension.

Note that the db2look tool is only available with an installation of a DB2 UDB instance. If you are using a DB2 z/OS instance, CAST recommends the use of the RC/Migrator tool which is part of the CA Database Management Solution for DB2 for Z/OS, Version 19. There are no instructions provided for this.

Extraction example

The db2look tool provided by IBM generates the DDL statements by object type. See the full documentation for the tool here: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0002051.html.

For example:

DDL extraction of all objects from the TEST database

db2look -d TEST -a -e -o c:\temp\DB2_SQL\TEST_DDL.sql

DDL extraction for a specific schema using a specific user

db2look -d TEST -z CASTPUBS -i db2admin -w db2admin -e -o c:\temp\DB2_SQL\CASTPUBS_DDL.sql

Generating XXL tablesize statistics

See SQL Analyzer - working with XXL or XXS tables for a DB2 database.