JR27498: INSERT CONTAINING A SELECT WITH EXISTS ON A NICKNAME INSERTS INCORRECT ROWS

DB2 UDB Version 8.1 FixPak 16 (also known as Version 8.2 FixPak 9 )

APAR status

• Closed as program error.

Error description

• The following insert with select inserts incorrect rows.
  INSERT INTO dttmp.errors  (ValidationRunId , ID, DESCRIPTION )
  SELECT 12 , 20, 'unknown'
  FROM sysibm sysdummy1
  WHERE ( EXISTS (SELECT 1 FROM dttmp.org_nk WHERE
     OrganizationId != 0))
  

Local fix

• 1. rewrite the select with out the EXISTS
  2. run server in fenced mode
  

Problem summary

• Users affected:
     Users of the DB2 for LUW Homogeneous Federation Feature or
  InfoSphere Federation Server
  Problem description and summary:
     See error description.
  

Problem conclusion

• Problem was first fixed in Version 8.2, FixPak 16 (s080111).
  This fix should be applied on the federation server.
  

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:

  JR27965

Fix information

• Fixed component name

  WS INFO INTEGRA

• Fixed component ID

  5724C7400

Applicable component levels