A fix is available
APAR status
Closed as program error.
Error description
SybaseOC sometimes generates undesired select statements and commit statements after every record. Description: SybaseOC sometimes generates commit statements irrespective of the transaction size for every record leading to performance issues. It also sometimes generates undesired select statements even when the job is not designed to read from sybase databases.
Local fix
Problem summary
Due to garbage values present in a uninitialized variable being evaluated at run time the logic is affected and thus commit statements are happening for every record instead of looking for transaction size property. Similarly unnecessary select statements are also being generated leading to performance problems and logic problems.
Problem conclusion
After the installation of current fix the stage will not generate any unnecessary select or commit statements.
Temporary fix
Comments
APAR Information
APAR number
JR40064
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-08-01
Closed date
2011-09-20
Last modified date
2011-09-20
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
SERVER
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R850 PSY
UP
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"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"}]
Document Information
Modified date:
07 October 2021