JR36806: SELECTING FROM NICKNAME FAILED RETURN SQL1476N ERROR ON SUN64 PLATFORM

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 fixed if next.

Error description

• Reproduce steps:
  CREATE NICKNAME <your_nickname> (first_name VARCHAR(16)
  OPTIONS(XPATH './@first'), last_name VARCHAR(16) OPTIONS(XPATH
  './@last')) FOR SERVER DATASTORE2 OPTIONS(FILE_PATH
  '<non-exist_xml_file_path>', XPATH '/doc/name')
  DB20000I  The SQL command completed successfully.
  
  SELECT * FROM <your_nickname>
  SQL1476N  The current transaction was rolled back because of
  error "-1476".
  SQLSTATE=40506
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * XML wrapper on Sun64                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * SELECTING FROM NICKNAME FAILED RETURN SQL1476N ERROR ON      *
  * SUN64                                                        *
  * PLATFORM                                                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to v91fp10                                           *
  ****************************************************************
  

Problem conclusion

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:

  JR36807 IC69105 IC69106

Fix information

Applicable component levels

• R910 PSN

     UP

• R910 PSY

     UP