JR40869: ALTER INDEX statement is not fully qualified.

IBM InfoSphere Information Server, Version 8.7 Fix Pack 1
IBM InfoSphere Information Server, Version 8.5 Fix Pack 3

APAR status

• Closed as program error.

Error description

• Oracle Connector - ALTER INDEX statement not fully qualified.
  This is causing the index to not be found by the Oracle
  Connector if it was created with a different user than the one
  that is logging in.
  
  Resulting in this error message:
  The OCI function OCIStmtExecute returned status -1. Error code:
  1,418, Error message: ORA-01418: specified index does not exist.
  
  Also note this in the 11g and 10g Oracle docs:
  http://download.oracle.com/docs/cd/E11882_01/server.112/e26088/s
  tatements_1010.htm#SQLRF00805
  "The index must be in your own schema or you must have the ALTER
  ANY INDEX system privilege."
  

Local fix

Problem summary

• Oracle Connector needs to fully qualify the index for its
  generated ALTER INDEX statement because sometimes the schema is
  not the current user.
  

Problem conclusion

• Oracle Connector now fully qualifying the index in the ALTER
  INDEX statement.
  

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

• R850 PSY

     UP