JR34217: USERNAME LOST DURING RUNTIME WHEN USING INFORMIX EE STAGE IN IS 8.1

Download Fix Pack 2 for InfoSphere Information Server Version 8.1

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 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