IBM Support

IC91170: LOAD INVOLVING XML COLUMN MIGHT FAIL WITH SQL16275N ERROR IF INVALID QNAME ENCOUNTERED

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Load involving XML column might fail because of invalid QName
    with following error:
    
    SQL3306N  An SQL error "-16275" occurred while inserting a row
    into the table.
    SQL16275N  A name starting with "<name:>" is not a valid QName.
    It was
    intended as a QName for "element".  SQLSTATE=2200M
    
    Following errors would be logged in db2diag:
    
    Information
    2013-01-01-01.00.01.022010-240 I54850A672         LEVEL: Error
    PID     : 43647000             TID  : 8572        PROC : db2sysc
    INSTANCE: db2inst1               NODE : 000         DB   :
    SAMPLE
    APPHDL  : 0-47                 APPID:
    *LOCAL.db2inst1.130326092010
    AUTHID  : db2inst1
    EDUID   : 8572                 EDUNAME: db2lfrm0
    FUNCTION: DB2 UDB, database utilities, sqluCFormatter::iCleanUp,
    probe:1775
    MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
              "SQLCA has already been built"
    DATA #1 : LOADID, PD_TYPE_LOADID, 47 bytes
    LOADID: 1801.2013-03-26-05.20.31.727874.0 (3;5)
    DATA #2 : File name, 10 bytes
    sqluldat.C
    DATA #3 : ZRC, PD_TYPE_ZRC, 4 bytes
    0x8015006D
    
    2013-01-01-01.00.01.023464-240 I55523A624         LEVEL: Error
    PID     : 43647000             TID  : 8829        PROC : db2sysc
    INSTANCE: db2inst1               NODE : 000         DB   :
    SAMPLE
    APPHDL  : 0-47                 APPID:
    *LOCAL.db2inst1.130326092010
    AUTHID  : db2inst1
    EDUID   : 8829                 EDUNAME: db2lfrm1
    FUNCTION: DB2 UDB, database utilities, sqluLoadEDUDriver,
    probe:2698
    MESSAGE : ZRC=0x82150056=-2112552874=SQLU_TERM_DIE_NOW
              "Load EDU termination requested"
    DATA #1 : LOADID, PD_TYPE_LOADID, 47 bytes
    LOADID: 1801.2013-03-26-05.20.31.727874.0 (3;5)
    DATA #2 : File name, 10 bytes
    sqluedus.C
    
    [...]
    
    2013-01-01-01.00.01.130603-240 I60846A551         LEVEL: Error
    PID     : 43647000             TID  : 1801        PROC : db2sysc
    INSTANCE: db2inst1               NODE : 000         DB   :
    SAMPLE
    APPHDL  : 0-47                 APPID:
    *LOCAL.db2inst1.130326092010
    AUTHID  : db2inst1
    EDUID   : 1801                 EDUNAME: db2agent (SAMPLE)
    FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
    DATA #1 : String, 129 bytes
    LOADID: 1801.2013-03-26-05.20.31.727874.0 (3;5)
    Error loading partition. , -2146107283, 0, Detected in
    file:sqluvtld.C, Line:4106
    
    2013-01-01-01.00.01.131100-240 I61398A451         LEVEL: Severe
    PID     : 43647000             TID  : 1801        PROC : db2sysc
    INSTANCE: db2inst1               NODE : 000         DB   :
    SAMPLE
    APPHDL  : 0-47                 APPID:
    *LOCAL.db2inst1.130326092010
    AUTHID  : db2inst1
    EDUID   : 1801                 EDUNAME: db2agent (SAMPLE)
    FUNCTION: DB2 UDB, database utilities, sqluLoadPartition,
    probe:4101
    MESSAGE : Load Error: Error loading partition.
    
    2013-01-01-01.00.01.131630-240 I61850A551         LEVEL: Error
    PID     : 43647000             TID  : 1801        PROC : db2sysc
    INSTANCE: db2inst1               NODE : 000         DB   :
    SAMPLE
    APPHDL  : 0-47                 APPID:
    *LOCAL.db2inst1.130326092010
    AUTHID  : db2inst1
    EDUID   : 1801                 EDUNAME: db2agent (SAMPLE)
    FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
    DATA #1 : String, 129 bytes
    LOADID: 1801.2013-03-26-05.20.31.727874.0 (3;5)
    Error loading partition. , -2146107283, 0, Detected in
    file:sqluvtld.C, Line:1146
    

Local fix

  • No local fix available
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 LUW Version 9.7 Fix Pack 9 or higher levels.  *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 LUW Version 9.7 Fix Pack 9.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC91170

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-03-28

  • Closed date

    2013-12-17

  • Last modified date

    2013-12-17

  • 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

  • R970 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 December 2013