JR38237: TERADATA MULTILOAD JOB HANG WHICH CAUSE 32,000 + LOCKS ON THE SYS.MESSAGE FILE

IBM InfoSphere Information Server, Version 8.5 Fix Pack 2

APAR status

• Closed as program error.

Error description

• Teradata job hang which cause 32,000 + locks on the SYS.MESSAGE
  file
  

Local fix

Problem summary

• When user access the project thru DS client, it hangs.  Found
  out there are about 32,000 + locks on the SYS.MESSAGE file.
  If thejob was killed and the project was running thereafter
  smoothly.
  

Problem conclusion

• When there is no data to write to a pipe using load methods
  tpump or mload in opening and closing the FIFO's.
  i.e When there is no data FIFO which has got opened need to
  close the connection because of no data,
  which is causing some synchronisation issues on the pipe and
  resulting in hang.
  

Temporary fix

• Providing the latest patch JR38237.The job should now run with
  out any hang.
  

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

• SERVER
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R753 PSY

     UP