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 number
JR29532
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
801
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-06-19
Closed date
2008-07-30
Last modified date
2012-03-30
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
30 March 2012