JR45469: ORAEE ON IS91 PUTS THERE ARE NO INDEXES ON TABLE `T31113A', AND AN INDEX OPTION WAS INCLUDED ...

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • "There are no indexes on table `t31113a', and an index option
    was included; the index option will be ignored." is put from
    Oracle Enterprise stage on Information Server 9.1.
    

Local fix

Problem summary

  • Oracle Enterprise stage was checking the indexes of a table
    prior to doing a bulk load, before the user-defined create table
    statement in the stage was executed. This was resulting in
    warning messages because of missing indexes.
    

Problem conclusion

  • To fix this error, the code was adjusted so that indexes are
    checked only after the create table statement is executed.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR45469

  • 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-18

  • 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



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

InfoSphere DataStage

Software version:

9.1

Reference #:

JR45469

Modified date:

2013-01-31

Translate my page

Machine Translation

Content navigation