JR27772: SYSIBM.SQLTABLES failed to return synonym

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

• Customer tried to call the stored procedure directly against
  database on the server (table T1 and SYNONYM T1N91 on the db),
  and got following result.
  
  If calling this way:  call SYSIBM.SQLTABLES(null,'%ERIC','%',
  null,'DATATYPE="JDBC";DYNAMIC=0;REPORTPUBLICPRIVILEGES=1;'),
  which maps to jdbc calling getTables(null, "%ERIC", "%", null),
  T1 and T1N91 will be returned as following format:
  TABLE_NAME
  TABLE_SCHEMTABLE_TYPE
  
   T1N91  ERIC   SYNONYM
   T1     ERIC   TABLE
  
  But if calling this way: call
  SYSIBM.SQLTABLES(null,'%ERIC','%','SYNONYM','DATATYPE="JDBC";DYN
  AMIC=0;REPORTPUBLICPRIVILEGES=1;'),
  which maps to jdbc calling getTables(null, "%ERIC", "SYNONYM",
  null), T1N91 will not be returned.
  TABLE_NAME
  TABLE_SCHEMTABLE_TYPE
  
   T1  ERIC        TABLE
  

Local fix

• N/A
  

Problem summary

• User's affected: All that rely on the CLI layer
  Problem description:  SQLTables() API does not return synonims
  

Problem conclusion

• First fixed in v9fp5 - introduced in v9fp3
  

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:

Fix information

• Fixed component name

  DB2 UDB ESE WIN

• Fixed component ID

  5765F4101

Applicable component levels

• R910 PSY

     UP