A fix is available
APAR status
Closed as program error.
Error description
Customer is getting error when calling stored procedure from Pre-insert Command in Sybase IQ BulkLoad Stage. "Error: cs_ctx_drop: cslib user api layer: external error: The context structure cannot be dropped because the application has not exited from ct."
Local fix
Problem summary
**************************************************************** USERS AFFECTED: All platforms, jobs using stored procedure in IQBulk12 pre-insert command **************************************************************** PROBLEM DESCRIPTION: Can not call a stored procedure in pre-insert command from the sybase bulk stage in a parallel job. **************************************************************** RECOMMENDATION: Install patch for JR35375 ****************************************************************
Problem conclusion
Store procedure in pre-insert command gives an error because its not properly cancelled on completion. Cancel the before command correctly for stored procedure else subsequent commands give an error.
Temporary fix
Comments
APAR Information
APAR number
JR35375
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
801
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-01-15
Closed date
2010-01-21
Last modified date
2010-01-21
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
IQBULK12
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":"InfoSphere DataStage"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
11 October 2021