JR60482: INTRODUCE ENVIRONMENT VARIABLE CC_ORA_DISABLE_PLSQL_BATCH_ERRORS

Download the mod pack for IBM InfoSphere Information Server 11.7.1.0 In-Place Upgrade

APAR status

• Closed as program error.

Error description

• With the introduction of Oracle 12cR2, execution of PL/SQL using
  OCI_BATCH_ERRORS mode has been eliminated by Oracle when both
  Oracle Client and Server are version 12cR2 or later. This
  elimination causes Oracle Connector jobs using PL/SQL to abort
  with an error such as:
  The OCI function OCIStmtExecute returned status -1. Error code:
  3137, Error message: ORA-03137: malformed TTC packet from client
  rejected: [kpoal8Check-3] [32768] [0] [0x000000000] [789544] []
  [] []. (CC_OraStatement::executePlSql, file CC_OraStatement.cpp,
  line nnnn)
  
  The work around for that error is to set
  CC_ORA_DISABLE_BATCH_ERRORS=TRUE as a user defined job
  parameter. Unfortunately, this environment variable impacts the
  Oracle Connector's performance in other types of statement
  execution such as SELECT, INSERT, UPDATE because it limits the
  array size to 1. A new environment variable
  CC_ORA_DISABLE_PLSQL_BATCH_ERRORS is introduced that only
  changes the execution mode for PL/SQL statement execution.
  

Local fix

Problem summary

• This APAR introduces a new environment variable
  CC_ORA_DISABLE_PLSQL_BATCH_ERRORS that only changes the
  execution mode for PL/SQL statement execution.
  
  Whenever a new user defined environment variable is added to a
  job and set to a non-default value, it requires that the job be
  recompiled.
  

Problem conclusion

• Set CC_ORA_DISABLE_PLSQL_BATCH_ERRORS=TRUE as a user defined
  environment variable in a job that uses PL/SQL within an Oracle
  Connector where both Oracle Client and Server are 12cR2 or
  later.
  

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

• RB50 PSY

     UP

• RB70 PSY

     UP