|
Problem IC92571
|
Status: Closed |
GRAPH GENERATED WITH 'DB2EXPLN -G' DOES NOT CONTAIN STATISTICS |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
When an explain plan is generated using 'db2expln -g' command,
it does not contain the cost and the cardinality estimate for
its operators. This can be demonstrated with a simple example as
seen below:
db2expln -d sample -t -g -q "values current timestamp"
******************** DYNAMIC
***************************************
==================== STATEMENT
==========================================
Isolation Level = Cursor Stability
Blocking = Block Unambiguous Cursors
Query Optimization Class = 5
Partition Parallel = No
Intra-Partition Parallel = No
SQL Path = "SYSIBM", "SYSFUN",
"SYSPROC", "SYSIBMADM"
Statement:
values current timestamp
Section Code Page = 1208
Estimated Cost = 0.004800
Estimated Cardinality = 1.000000
Table Constructor
| 1-Row(s)
Return Data to Application
| #Columns = 1
End of section
Optimizer Plan:
Operator
(ID)
RETURN
( 1)
|
TBSCAN
( 2)
|
TFunc:
SYSIBM
GENROW |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users on V10.1 fp1 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V10.1fp3 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
|
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC95356
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 24.05.2013
01.10.2013
01.10.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
