JR27572: IMPROVE PERFORMANCE OF RUNNING 32-BIT ROUTINES IN 64-BIT INSTANCE

APAR status

• Closed as program error.

Error description

• Currently, when a 32-bit routine is executed in a 64-bit
  instance, it is first attempted as 64-bit and will fail with an
  error such as the following:
  
  2007-10-08-15.14.06.990362-420 E92195A606         LEVEL: Error
  (OS)
  PID     : 12330                TID  : 1           PROC : db2fmp
  (11917) 0
  INSTANCE: db2inst2             NODE : 000
  FUNCTION: DB2 UDB, oper system services, sqloLoadModule,
  probe:190
  CALLED  : OS, -, dlopen
  OSERR   : ENOENT (2) "No such file or directory"
  DATA #1 : Library name or path, 46 bytes
  /export/home/db2inst2/sqllib/function/ICMNLSSP
  DATA #2 : shared library load flags, PD_TYPE_LOAD_FLAGS, 4 bytes
  0
  DATA #3 : String, 99 bytes
  ld.so.1: db2fmp: fatal:
  /export/home/db2inst2/sqllib/function/ICMNLSSP: wrong EL
  F class: ELFCLASS32
  
  After this failed attempt, it will the retry in 32-bit mode and
  execute correctly.
  
  This APAR improves the retry logic so that the error above will
  only be thrown once per 32-bit library per instance.  The
  library name will
  be remembered so that it will be executed directly as 32-bit on
  all other subsequent calls in the same instance.
  

Local fix

Problem summary

• Currently, when a 32-bit routine is executed in a 64-bit
  instance, it is first attempted as 64-bit and will fail with an
  error such as the following:
  
  2007-10-08-15.14.06.990362-420 E92195A606         LEVEL: Error
  (OS)
  PID     : 12330                TID  : 1           PROC : db2fmp
  (11917) 0
  INSTANCE: db2inst2             NODE : 000
  FUNCTION: DB2 UDB, oper system services, sqloLoadModule,
  probe:190
  CALLED  : OS, -, dlopen
  OSERR   : ENOENT (2) "No such file or directory"
  DATA #1 : Library name or path, 46 bytes
  /export/home/db2inst2/sqllib/function/ICMNLSSP
  DATA #2 : shared library load flags, PD_TYPE_LOAD_FLAGS, 4 byte
  0
  DATA #3 : String, 99 bytes
  ld.so.1: db2fmp: fatal:
  /export/home/db2inst2/sqllib/function/ICMNLSSP: wrong EL
  F class: ELFCLASS32
  
  After this failed attempt, it will the retry in 32-bit mode and
  execute correctly.
  
  This APAR improves the retry logic so that the error above will
  only be thrown once per 32-bit library per instance.  The
  library name will
  be remembered so that it will be executed directly as 32-bit on
  all other subsequent calls in the same instance.
  

Problem conclusion

• First fixed in DB2 UDB Version 8, FixPak 17
  

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:

  JR30034

Fix information

• Fixed component name

  DB2 CUE WINDOWS

• Fixed component ID

  5724B6201

Applicable component levels

• R810 PSN

     UP

• R820 PSN

     UP