IBM Support

JR30428: DATASTAGE PATCH E129322_LINUX_DS752 FOR SINGLEROW OPTION WITH ORACLE 8 PARTITIONING DOES NOT WORK WITH OTHER OPTIONS.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DataStage Patch e129322_linux_DS752 for SINGLEROW option with
    Oracle 8 partitioning does not work with other options.
    The application team states:
    1) The patch works fine when SINGLEROW is the only option used.
    2) The patch does not work when multiple options are used. The
    control file generated by DataStage has incorrect syntax. When
    you remove the SINGLEROW option from the parameter level the
    process works and that is how they determined the two options
    are creating a conflict in the control file syntactically.
    

Local fix

  • This fix is included in 8.0.1 fix pack 3
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    7.5.2 and above.
    ****************************************************************
    PROBLEM DESCRIPTION:
    The SQL*Loader control file option SINGLEROW option does not
    work when loading a table partition.
    You get a syntax error if you try to use this option that way.
    ****************************************************************
    RECOMMENDATION:
    Apply patch.
    This change is included in 8.1 Fix Pack 1.
    ****************************************************************
    

Problem conclusion

  • A limitation of SQL*Loader.
    We check the condition in the program and ignore the hint to
    inser thet SINGLEROW option in the control file.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR30428

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-09-08

  • Closed date

    2008-09-17

  • Last modified date

    2010-12-09

  • 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

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

Document Information

Modified date:
09 December 2010