The db2look tool command generates the data definition language statements for a specific object type. This can be used to reproduce the database objects into another database, for example copying a production database schema into a test system. The basic command syntax is this:
db2look -d [DBName] [-e] [-z SchemaName] [-t TableNames] [-v ViewNames]
If you want to extract a definition of a database, you can run the following command:
db2look -d sample -createdb
-- No userid was specified, db2look tries to use Environment variable USER
-- USER is: DB2INST1
-- This CLP file was created using DB2LOOK Version "11.1"
-- Timestamp: Wed 23 May 2018 04:38:15 AM EDT
-- Database Name: SAMPLE
-- Database Manager Version: DB2/LINUXX8664 Version 11.1.3.3
-- Database Codepage: 1208
-- Database Collating Sequence...