IBM Support

JR45443: PL/SQL ORACLE CONNECTOR JOB ABORTED WITH ORA-01460 WHEN USING THE 9.1 BIG BUFFER ENHANCEMENT.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Job aborted with ORA-01460 when running on IS 9.1. That job was
    running without any error on IS 8.7 before. When the 9.1 Big
    Buffer enhancement is disabled. it works well on IS 9.1 as well
    as IS 8.7. It may cause this abortion.
    

Local fix

  • Work Around: Disable the big buffer APIs in V9.1.
    

Problem summary

  • Existing job aborted with ORA-01460 when running on IS 9.1.
    Disabling Big Buffer (new to 9.1) resolved the issue.
    

Problem conclusion

  • There were internal data structures for Big Buffer that were not
    being initialized correctly. Issue was unique to PL/SQL in
    source context.
    

Temporary fix

  • Disable Big Buffer API by adding and setting environment
    variable CC_DISABLE_BIG_BUFFER_API=TRUE
    

Comments

APAR Information

  • APAR number

    JR45443

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-01-17

  • Closed date

    2013-01-31

  • Last modified date

    2013-01-31

  • 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

  • R910 PSY

       UP

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

Document Information

Modified date:
07 October 2021