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');