IBM Support

IT21308: WRONG ERROR MESSAGE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • 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.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 3 Fix Pack 3 or higher               *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 3 Fix Pack 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT21308

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-07-05

  • Closed date

    2018-03-19

  • Last modified date

    2018-03-19

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
19 March 2018