JR45954: ORACLE EE STAGE INDEX RELATED ERRORS/WARNINGS ON BULK LOAD

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

  • After applying JR45929 patch, new warning/error message occurs.
    
    
    =====
       Item #: 9
       Event ID: 8
       TimeStamp: 2013-03-07 18:13:27
       Type: Fatal
       User name: takuk
       Message: Oracle_Enterprise_1: Indexes on table
    'DATATYPE_DATE_K' preclude direct parallel loading unless an
    index option is included. Add an index option or drop indexes
    and rerun step.
    =====
    
    =====
       Item #: 38
       Event ID: 37
       TimeStamp: 2013-03-07 18:05:06
       Type: Warning
       User name: takuk
       Message: Oracle_Enterprise_1: When checking operator: There
    are no indexes on table `COMMON01_K', and an index option was
    included;
     the index option will be ignored.
    =====
    

Local fix

Problem summary

  • There were incorrect errors or warnings at job startup for bulk
    load jobs.
    

Problem conclusion

  • Certain index checks were being performed too early (prior to
    constraints being disabled or tables being created).
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR45954

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    753

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-03-07

  • Closed date

    2013-03-18

  • Last modified date

    2013-03-18

  • 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

  • R753 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

InfoSphere DataStage

Software version:

7.5.3

Reference #:

JR45954

Modified date:

2013-03-18

Translate my page

Machine Translation

Content navigation