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

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