IBM Support

JR57999: DB2 Connector Load operation fails with error SQL27906N when database DFT_TABLE_ORG is set to "COLUMN".

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • DB2 Load operation fails with error SQL27906N when database
    default table organization (DFT_TABLE_ORG) is set to "COLUMN"
    
    Item #: 404
    Event ID: 748
    Timestamp: 2017-05-24 09:42:01
    Type: Warning
    User Name: gprasad1
    Message Id: IIS-CONN-DB2-00314
    Message: DB2_WRT_USUSERDB_PROFILE_DATA,3: The DB2 Load API call
    failed
    with SQLCODE -27906.
    
    Load messages are stored in message
    file:/etrade/dit/dsadm/batch/uscrm/
    common/db2_rejects/gprasad1/DW_DM_TMP.USUSERDB_PROFILE_DATA_S/US
    USERDB_
    PROFILE_DATA_S.msg.
    
    Item #: 405
    Event ID: 749
    Timestamp: 2017-05-24 09:42:01
    Type: Fatal
    User Name: gprasad1
    Message Id: IIS-CONN-DB2-00315
    Message: DB2_WRT_USUSERDB_PROFILE_DATA,3: An error occurred
    while loading the table.
    (CC_DB2APILoadRecordDataSetConsumer::complete, file
    CC_DB2APILoadRecordDataSetConsumer.cpp, line 2010)
    
    SQL27906N
    
    The load operation was not performed because the specified
    parameters  are not supported with the type of the target
    table.
    
    If you manually modify the clp file to remove the following
    lines:
    PARTITIONED DB CONFIG
    
      OUTPUT_DBPARTNUMS (3);
    
    Then the job run successful.
    

Local fix

  • NA
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    Users performing LOAD operation with REPLACE action into DB2
    that has column-organized table.
    ****************************************************************
    PROBLEM DESCRIPTION:
    During data load operation into column-organized tables with
    bulk load mode set to LOAD REPLACE, connector reports SQL27906N
    error and load fails.
    ****************************************************************
    RECOMMENDATION:
    Install patch JR57999.
    ****************************************************************
    

Problem conclusion

  • When connector detects column-organized table and bulk load
    operation is configured with LOAD REPLACE action, connector will
     automatically switch into 'sequential' execution mode.
    

Temporary fix

  • n/a
    

Comments

APAR Information

  • APAR number

    JR57999

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    B50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-06-07

  • Closed date

    2017-11-16

  • Last modified date

    2017-11-16

  • 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

    WIS DATASTAGE

  • Fixed component ID

    5724Q36DS

Applicable component levels

  • RB50 PSY

       UP

  • RB70 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 November 2017