JR34705: JOB HANGS WHEN USING OC STAGE WITH MORE THAN 8 KEYS AND UPDATE ACTION AS TRUNCATE THEN INSERT.

APAR status

• Closed as program error.

Error description

• DS 7.5.3 on RHAS 4.0
  Sybase OC 12.5.4.0.13924
  Sybase ASE 12.5.3/EBF 12331 ESD#1 on Solaris 5.8 64-bit
  
  Job hangs when using OC stage with more than 8 keys and update
  action as truncate then insert.
  
  When keys defines in OC stage less or equal than 8, the job
  finished successfully.
  
  Same job with 9 keys defined ran successfully in DS751a on
  Solaris with Sybase OC 12.5.3.0.12143.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Sybase OC jobs with more than 8 key cols in the table schema
  which it is accessing.
  ****************************************************************
  PROBLEM DESCRIPTION:
  Sybase OC jobs in which more than 8 cols are defined as primary
  key aborts or hangs.
  ****************************************************************
  RECOMMENDATION:
  Install this patch patch_JR34705 to obtain a fix for this
  problem.
  ****************************************************************
  

Problem conclusion

• Buffer where the column information is stored is made
  independent of the number of the key columns defined in the
  schema.
  

Temporary fix

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 PSN

     UP