DB2 - Problem description
Problem IT35691 | Status: Closed |
NO ROWCOMPESTIMATE FROM DB2INSPF OUTPUT WITH -TSI OPTION | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
db2inspf does not output ROWCOMPESTIMATE when using -tsi (tablespace option) $ db2inspf inspect.out inspect_ts2.txt -tsi 2 DATABASE: SAMPLE1 VERSION : SQL11014 2021-01-08-16.52.31.673128 Action: ROWCOMPESTIMATE TABLE Schema name: DB2INST1 Table name: TEST Tablespace ID: 2 Object ID: 6 Result file name: inspect.out The expected output should be: DATABASE: SAMPLE1 VERSION : SQL11014 2021-01-08-16.52.31.673128 Action: ROWCOMPESTIMATE TABLE Schema name: DB2INST1 Table name: TEST Tablespace ID: 2 Object ID: 6 Result file name: inspect.out Table phase start (ID Signed: 6, Unsigned: 6; Tablespace ID: 2) : DB2INST1.TEST Data phase start. Object: 6 Tablespace: 2 Row compression estimate results: Percentage of pages saved from compression: 46 Percentage of bytes saved from compression: 46 Compression dictionary size: 5120 bytes. Expansion dictionary size: 3016 bytes. Data phase end. Table phase end. Processing has completed. 2021-01-08-16.52.31.869460 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * db2inspf * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Apply v11.5 Mod 6 Fixpack 0 to DB2 database server * **************************************************************** | |
Local Fix: | |
Do not use the -tsi option | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * db2inspf * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Apply v11.5 Mod 6 Fixpack 0 to DB2 database server * **************************************************************** | |
Comment | |
First fixed in v11.5 Mod 6 Fixpack 0 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 25.01.2021 05.11.2021 05.11.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |