JR29532: USING THE DRS STAGE WITH DBMSTYPE = ORACLE, IF THE SQL "FROM" CLAUSE EXCEEDS 64 CHARACTERS, A VIEWDATA OR JOB RUN WILL SIGSEGV

APAR status

• Closed as program error.

Error description

• ENVIRONMENT:
  Infomation Server 8.0.1 Fixpak 1a
  AIX 5.3
  Oracle 10G R2 and Oracle 9i
  
  DESCRIPTION:
  Using using DRS Stage with DBMS Type = ORACLE, and the number of
  characters in the generated SQL FROM clause exceeds 64, running
  the job or performing a viewdata causes the uvsh and dsapi_slave
  to produce a core dump,  with a SIGSEGV.
  
  FURTHER INFORMATION:
  If  View Data is tried from the Designer client , this causes a
  core dump to occur (SIGSEGV) in the dsapi_slave process, causing
  the connection to end.
  

Local fix

• The problem does not occur when using the ODBC DBMS Type to
  connect to Oracle.
  
  This may be used instead.
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  DRS Stage
  ****************************************************************
  PROBLEM DESCRIPTION:
  User using DRS Stage with DBMS Type = ORACLE, and the number of
  characters in the generated SQL FROM clause exceeds 62, running
        the job or performing a
  viewdata cause the uvsh and dsapi_slave to core dump, with a
  SIGSEGV.
  ****************************************************************
  RECOMMENDATION:
  Install patch:
  
  patch_JR29532_server_aix.tar
  ****************************************************************
  

Problem conclusion

• Problem is fixed in the patch for 8.0.1 fp1
  

Temporary fix

Comments

• This change is included in 8.0.1 Fix Pack 2.
  

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

• R801 PSN

     UP