DB2 FOR LUW / DB2FORLUW / A50 - DB2

With DB2 V10.5 GA release you can not create a  column-organized 
table (BLU) if there is a Terabyte License installed. 
 
When creating such a table you will receive SQL8029N error: 
 
CREATE TABLE JTNISBET.STAFF ( ID SMALLINT NOT NULL, NAME 
VARCHAR(9), DEPT SMALLINT, JOB CHAR(5), YEARS SMALLINT, SALARY 
DECIMAL(7,2), COMM DECIMAL(7,2) ) ORGANIZE BY COLUMN 
DB21034E  The command was processed as an SQL statement because 
it was not a valid Command Line Processor command.  During SQL 
processing it 
returned: 
SQL8029N  A valid license key was not found for the requested 
function. 
The current license key for this product does not allow the 
requested functionality. 
Purchase the license key for this function from your IBM 
representative or authorized 
dealer and update your license using the db2licm command. 
 
However, BLU functionality should be allowed with Terrabyte 
licenses. 
 
A "Terrabyte" license file can be either: 
 
db2awse_tb.lic - DB2 Advanced Workgroup Server Edition (Terabyte 
option) 
db2aese_tb.lic - DB2 Advanced Enterprise Server Edition 
(Terabyte option) 
 
and is shown with db2licm -l like the following output: 
 
Product name:                     "DB2 Advanced Enterprise 
Server Edition" 
License type:                     "Terabyte" 
Expiry date:                      "Permanent" 
Product identifier:               "db2aese" 
Version information:              "10.5" 
Enforcement policy:               "Soft Stop"

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fixpack 1                        * 
****************************************************************

A interim fix is available through the trial image site 
http://www.ibm.com/developerworks/downloads/im/db2/index.html 
Once you install the trial data server image, you can register 
the Terabyte license key.

DB2 Version 10.5 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

Problem was first fixed in DB2 Version 10.5 Fixpack 1

keiner bekannt / siehe Local-Fix

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

09.07.2013
23.09.2013
23.09.2013