JR33095: DB2Z STAGE JOB FAILS WITH 'RUNTIME_PID?SQLASTRT_TRUSTED' ERROR WHEN USER IS USING DB2 V9.1.

APAR status

• Closed as program error.

Error description

• DB2Z Stage job fails with 'runtime_pid?sqlastrt_trusted' error
  when user is using DB2 V9.1.
  The job will not have a problem when user is using DB2 V9.5.
  Package need to be re-created using V9.1 client since some
  parameter length has been changed from V9.1 to V9.5.
  

Local fix

• Recreated bind package using DB2 V9.1 client. There is a
  difference between bind file created
  on V9.5 and V9.1.
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  DB2Z Stage user using DB2 V9.1 on HPPA V8.1 GA
  ****************************************************************
  PROBLEM DESCRIPTION:
  DB2Z Stage job fails with 'runtime_pid?sqlastrt_trusted' error
  when user is using DB2 V9.1 on HPPA V8.1 GA.
  The job will not have a problem when user is using DB2 V9.5.
  
  ****************************************************************
  RECOMMENDATION:
  Install patch for JR33095
  https://asc-eng-patch-01.swg.usma.ibm.com/Patches/InformationSer
  ver/8.1/JR33095/patch_JR33095_server_hppa_81.tar
  ****************************************************************
  

Problem conclusion

• Package is re-created on V9.1.
  Some parameter length has been changed from V9.1 to V9.5.
  We needed to re-create package on V9.1 in order to make it
  consistent with V9.1 application.
  

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

• PXDB2Z
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R810 PSN

     UP