The processing of SQL statements in a Db2 column-organized (BLU acceleration) database requires intra-query parallelism to be enabled. If the intra-query parallelism is disabled for any reason, the following statement types against column-organized tables would fail with specific SQL errors.

  • The ALTER TABLE … ADD CONSTRAINT statement would return SQL1668N reason code 5
  • The RUNSTATS command would return SQL2310N error
  • All DML operations (INSERT, UPDATE and DELETE) and SELECT statements would return SQL1668N reason code 5

To fix this issue,  enable intra-query parallelism at database manager level, at database level or at SQL statement level.

Database Manager Level: 

ATTACH TO <instance>;

UPDATE DBM CFG USING INTRA_PARALLEL YES;

TERMINATE;

!db2stop

!db2start

Database Level:

CONNECT TO <database>;

UPDATE DB CFG USING DFT_DEGREE ANY;
UPDATE DB CFG USING MAX_QUERYDEGREE ANY;

TERMINATE;

Application Level:

CALL ADMIN_SET_INTRA_PARALLEL ('YES');