db2look returns wrong DDL for Hadoop MQTs

The db2look utility extracts the Data Definition Language (DDL) statements that are required to reproduce the database objects of a production database on a test database.


When you use the db2look utility to generate DDL for Hadoop MQTs, incorrect results are returned.

Resolving the problem

Do not use the db2look utility with Hadoop MQTs.