How do you generate the DDL that created a DB2 LUW database?

Question

There are various options for db2look you can use to see the DDL for just about every object in the database except the command that created the database itself. Is there any way with db2look, or perhaps with some other system command, where you can see the exact command structure that created a database?

score 2 · Answer 1 · edited May 05 '16 at 19:25

2

The minimum requirement is to have DB2 10.1.4 or DB2 10.5 installed.

-createdb: Generate the CREATE DATABASE command that was used to create the source database

db2look -d sample -createdb

edited May 05 '16 at 19:25

mustaccio

28,207
24
60
76

answered May 05 '16 at 15:47

DBplatz

31
3

How do you generate the DDL that created a DB2 LUW database?

1 Answers1