Extract DB2 create database ddl using db2look and -createdb switch

Question: How can I extract the ddl for CREATE DATABASE ? It seems like you can extract the full range of database object DDLs, but I can’t extract the database ddl

Answer: You can extract the CREATE DATABASE ddl. The minimum requirement is to have DB2 10.1.4 or DB2 10.5 installed

You’re probably familiar with the dblook utility, used for extracting database object DDLs. The DDLs are used to duplicate the objects into a fresh database , source control or to Compare DDL of 2 databases in DB2

A new parameter was added called –createdb.

An example of using the db2look –createdb parameter

db2look -d MYDB -createdb -o /tmp/mydb.sql

 Read More on db2look and DDL

Create a DDL on an existing DB2 table

DB2 How To get View definition - DBA DB2

List DB2 table columns and unique constraints - DBA DB2