DB2 FOR LUW / DB2FORLUW / A50 - DB2

db2 connect to test 
db2 "CREATE DATABASE PARTITION GROUP "PG_01" ON DBPARTITIONNUMS 
(0)" 
db2 "CREATE DATABASE PARTITION GROUP "PG_02" ON DBPARTITIONNUMS 
(1)" 
CREATE TABLE dd  ( 
                  "DELIVERABLE_ID" BIGINT NOT NULL GENERATED BY 
DEFAULT AS IDENTITY ( 
                    START WITH +100 
                    INCREMENT BY +1 
                    MINVALUE +100 
                    MAXVALUE +9223372036854775807 
                    NO CYCLE 
                    CACHE 20000 
                    NO ORDER ) , 
                  "BATCH_ID" BIGINT , 
                  "STATE" CHAR(1) NOT NULL , 
                  "DESTINATION_DATA_TYPE_ID" VARCHAR(200) , 
                  "CHANNEL_TYPE" CHAR(1) NOT NULL , 
                  "DOMAIN" VARCHAR(8) NOT NULL , 
                  "OUTPUT_ID" BIGINT , 
                  "TRANSPORT_TYPE" CHAR(1) , 
                  "DPC" DATE NOT NULL , 
                  "NODE" SMALLINT NOT NULL WITH DEFAULT CURRENT 
NODE ) 
                 COMPRESS YES ADAPTIVE 
                 PARTITION BY RANGE("NODE", "DPC") 
                 (PART "PG_01" STARTING(0,'2017-04-02') 
ENDING(0,'2017-04-08') IN "USERSPACE1" INDEX IN "USERSPACE1", 
                 PART "PG_02" STARTING(0,'2017-04-09') 
ENDING(0,'2017-04-15') IN "USERSPACE1" INDEX IN "USERSPACE1"); 
 
db2 "INSERT INTO dd (batch_id, state, destination_data_type_id, 
channel_type, domain, output_id, 
transport_type, dpc, node) 
VALUES(NULL,4,'GEN0001','M','SPB02',NULL,'M',NULL, 0)" 
 
 
 
DB21034E  The command was processed as an SQL statement because 
it was not a valid Command Line Processor command.  During SQL 
processing it returned: 
SQL0407N  Assignment of a NULL value to a NOT NULL column 
"TBSPACEID=-6, TABLEID=-32768, COLNO=1" is not allowed. 
SQLSTATE=23502 
 
The expected column number should be 8 rather than 1. It only 
helps on partitioned table.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Db2 10.5 Fix Pack 9 or higher                     * 
****************************************************************

First fixed in Db2 10.5 Fix Pack 9

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

05.07.2017
29.09.2017
29.09.2017

9.0.