DB2 - Problem description
Problem IT25645 | Status: Closed |
DB2LOOK WITH -CT DOES NOT GENERATE SET SCHEMA DDL'S BEFORE CREATE MQT/SUMMARY TABLES WITH IMPLICIT SCHEMAS | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
When using db2look with -ct option the statements for MQTs or summary tables created with implicit schema will not have the set schema DDL needed before, which can result in failure when using the result output to recreate objects. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version DB2 Version 11.1 Mod4 and Fix Pack 5 * **************************************************************** | |
Local Fix: | |
Create MQT/ Summary tables with explicit schema | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 11.07.2018 01.07.2019 01.07.2019 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |