JR27746: PUBLIC NOT GRANTED PERMISSION TO EXECUTE SYSIBM.SQLERRM_EXT INTERNAL FUNCTION

DB2 Version 9.1 Fix Pack 7  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 5   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

APAR status

• Closed as program error.

Error description

• Attempts to use the short form of the SQLERRM function will fail
  with -551, while the long form of the SQLERRM function works
  just fine. For example:
  
     VALUES (SYSPROC.SQLERRM (1042))
  
  fails with a -551. while
  
     VALUES (SYSPROC.SQLERRM ('SQL551',
     'AYYANG;UPDATE;SYSCAT.TABLES', ';', 'en_US', 1))
  
  works.
  

Local fix

• Local Fix:
  
  Grant execute on sqlerrm_ext to public.
  
  
  Work Around:
  
  Use the long form of the function, eg.
     SQLERRM ('SQL1042', '','','',1)
  instead of SQLERRM(1042).
  

Problem summary

• Users Affected:
  All users of the long form of the SYSPROC.SQLERRM function
  
  Problem Description:
  PUBLIC is not granted any permissions on SYSPROC.SQLERRM_EXT.
  This means that attempts to call the long form of
  SYSPROC.SQLERRM will fail with SQL0551
  
  Problem Summary:
  Calls to the long form of SYSPROC.SQLERRM fail with SQL0551,
  while using the short form is successful.
  

Problem conclusion

• Problem first fixed in DB2 v9.1 FP5
  

Temporary fix

• Manually grant PUBLIC execute privilege on SYSPROC.SQLERRM_EXT
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  JR27765

Fix information

• Fixed component name

  DB2 CEE WINDOWS

• Fixed component ID

  5765F3001

Applicable component levels

• R910 PSY

     UP