A fix is available
APAR status
Closed as program error.
Error description
When using Informix EE stage in IS 8.1 for new created jobs, job failed with error even the username and password are entered correctly in design time. ====== An Informix call failed: sqlcode = -951, sqlstate = IX000 message: Incorrect password or user dsadm@10.112.15.63 is not known on the database server. . [infxutils.C:2034] ======
Local fix
Set "Remote server" to "False", and set it back to "True", recompiled the job.
Problem summary
**************************************************************** USERS AFFECTED: Those customers using the Informix EE stage in parallel jobs **************************************************************** PROBLEM DESCRIPTION: On initially creating an Informix EE stage on the canvas, filling in properties including setting Remote Server to Yes, and then setting a user name and password, then compiling results in the user name and password not being compiled correctly **************************************************************** RECOMMENDATION: Install patch_JR34217_client_windows_8100 or use workaround described below ****************************************************************
Problem conclusion
This was an issue with how the stage was initialized. Closing, re-opening the job and re-compiling would cause the stage to fix itself. This issue has been fixed and a patch made available
Temporary fix
Close, re-open job and re-compile
Comments
APAR Information
APAR number
JR34217
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-09-08
Closed date
2009-12-07
Last modified date
2009-12-07
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
CLIENT
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R810 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.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
07 December 2009