IBM Support

JR36825: MQ CONNECTOR LOOPS IF FIELD IS VARCHAR WITH NO SIZE AND EOL AS ROW TERMINATOR IS YES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • MQ connector when reading a message in server mode, goes in
    infinite loop if the EOL as row terminator is set to YES and
    field is varchar without a size.
    

Local fix

  • specify a size for the varchar field.
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    MQ connector users specifying property "Treat EOL as row
    terminator"
    ****************************************************************
    PROBLEM DESCRIPTION:
    When users set the MQ connector stage property "Treat EOL as
    row terminator" to Yes for source stage and the payload column
    length is not set explicitly, the job looks frozen or producing
    too many output records.
    
    ****************************************************************
    RECOMMENDATION:
    Apply the patch.
    ****************************************************************
    

Problem conclusion

  • There is a program error with length handling when "Treat EOL
    as row terminator" is set. A patch is created to fix the code
    to handle the undefined length correctly.
    

Temporary fix

  • Specify length for the payload column when you use "Treat EOL
    as row terminator" property.
    

Comments

APAR Information

  • APAR number

    JR36825

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-06-15

  • Closed date

    2010-07-09

  • Last modified date

    2010-07-09

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

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

Modules/Macros

  • SERVER
    

Fix information

  • Fixed component name

    WIS DATASTAGE

  • Fixed component ID

    5724Q36DS

Applicable component levels

  • R810 PSN

       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":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
09 July 2010