Fixes are available
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 number
JR40869
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
850
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-10-13
Closed date
2011-11-08
Last modified date
2012-05-10
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"InfoSphere DataStage"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 October 2021