DB2 FOR LUW / DB2FORLUW / A10 - DB2

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

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users on V10.1 fp1                                           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to V10.1fp3                                          * 
****************************************************************

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
 

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC95356 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

24.05.2013
01.10.2013
01.10.2013