|
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) |
