SQL8029N returned when using BLU Acceleration with a Terabyte license registered with DB2 V10.5 Advanced Workgroup Server Edition (AWSE) or Advanced Enterprise Server Edition (AESE).

Flash (Alert)


Abstract

The BLU Acceleration feature in the GA release of IBM® DB2® Version 10.5 for Linux, UNIX, and Windows, will fail with an error SQL8029N when a Terabyte license is registered. This is caused by an incorrect hard enforcement in the product.

Content

Symptom:
SQL8029N is returned when creating a column organized table (BLU Acceleration) with Terabyte License registered as shown below:

    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.

Cause:
The cause of the symptom is APAR: IC93983 which was discovered in the initial release of DB2 V10.5 GA dated June 14, 2013

Diagnosing the Problem:
To identify if you are hitting the issue:
  1. Verify the DB2 fix pack level by running the db2level command to check if you are using the initial image of DB2 V10.5 GA; Informational tokens are "DB2 v10.5.0.0", "s130528"
  2. A "Terabyte" 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:

DB2 10.5 Advanced Enterprise Server Edition and Advanced Workgroup Server Edition - Terabyte option customers using BLU Acceleration functionality if the DB2 V10.5 GA was downloaded from Passport Advantage. xLinux-64 and AIX are the only platforms affected, as they are the only platforms that support BLU Acceleration functionality

Workaround:
There is no local fix for this issue.

Resolution:
If you have already downloaded DB2 V10.5 GA and are encountering the symptoms as described in this technote and APAR IC93983, then you could do the following:
  1. Download the updated trial data server image for DB2 Version 10.5 GA that contains the APAR fix from trial image site
  2. Download the applicable DB2 V10.5 AWSE or AESE Terabyte Activation DVD from Passport Advantage. Refer to http://www-01.ibm.com/support/docview.wss?uid=swg21641360 to find specific part number as required.
  3. Register the license file

See the related information section for download link and APAR details

Related information

APAR IC93983
Trial Image Site
Passport Advantage
Register the license - db2licm
SQL8029N

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

10.5

Operating system(s):

AIX, Linux

Software edition:

Advanced Enterprise Server, Workgroup Server

Reference #:

1643805

Modified date:

2013-07-15

Translate my page

Machine Translation

Content navigation