APAR status
Closed as program error.
Error description
When 2 jobs using Ifmx HPL starting to run in the same time, there is a chance that 1 job failed with error: An Informix call failed: sqlcode = -239, sqlstate = 23000 message: Could not insert new row - duplicate value in a UNIQUE INDEX colum While other hang with error: Job specified by jobname 'orchssn-2005143597' is not found, SQL error -284, ISAM error 0 Informix engineer on customer site found identical formid was inserted into formid in query table when this situation ocurred: insert into query VALUES(-2005143597,1,'orchqry-2005143597', 'cbs',NULL, 'N',NULL) Since the formid is unique index, if a duplicated formid was inserted into the query table, the "-239" error was generated.
Local fix
Problem summary
**************************************************************** USERS AFFECTED: DS753 on HP-UX 11.11 **************************************************************** PROBLEM DESCRIPTION: When 2 jobs using Ifmx HPL start running in the same time, 1 job might failed with "-239" Ifmx error and the other one might hang with error "jobname 'orchssn-2005143597' is not found" error. **************************************************************** RECOMMENDATION: Install the patch ****************************************************************
Problem conclusion
Fixed the code,
Temporary fix
Comments
APAR Information
APAR number
JR30199
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
752
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-08-18
Closed date
2008-10-30
Last modified date
2008-10-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
R752 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":"7.5.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
30 October 2008