DB2 - Problem description
Problem IT36311 | Status: Closed |
WHEN RUNNING NLJN against COLUMNAR TABLES IT IS POSSIBLE TO GET SQL0901N ERROR | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
WHEN RUNNING NLJN against COLUMNAR TABLES, and NLJN is executed in Columnar portion of the plan, and some or more NLJN payload columns are variable-length data type (varchar, varbinary, etc.) it is possible to get SQL0901N error with the following message reported in db2diag.log: AssertionFailedException: An assertion 'varlen | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Db2 user who runs NLJN queries against column-organized * * tables * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to the latest fix pack * **************************************************************** | |
Local Fix: | |
Add the optimize guideline (in the query level): /* */ or set this registry variable for entire instance: db2set DB2_COL_RUNPROF_CBS="ON VARLEN_KEY_HT OFF" | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Db2 user who runs NLJN queries against column-organized * * tables * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to the latest fix pack * **************************************************************** | |
Comment | |
Problem was first fixed in DB2 v11.5.6.0 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 22.03.2021 14.06.2021 14.06.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |