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.

Symptoms

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.