IY99095: SELECTING FROM ORACLE NICKNAME WITH TIMESTAMP COLUMN SPECIFIED WHERE CLAUSE RETURNS NO ROW EVEN THOUGH THE CONDITION IS MET.

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

APAR status

• Closed as program error.

Error description

• Selecting from Oracle nickname with timestamp column results in
  unexpected result.
  For example:
  db2 "insert into fh1time value ('a', current timestamp)"
  
  db2 "select * from fh1time"
  C1         C2
  ---------- --------------------------
  a          2007-04-18-13.11.06.887778
    1 record(s) selected.
  
  Now if you try to select the nickname specifying the above
  timestamp value, no row is returned though the value for C2
  column exists:
  
  db2 "select * from fh1time
  where c2='2007-04-18-13.11.06.887778'"
  
  C1         C2
  ---------- --------------------------
    0 record(s) selected.
  

Local fix

• Alter the server specifying Oracle client version 9 intead of
  version 10.
  

Problem summary

• Users affected:
     Users of the Oracle wrapper in InfoSphere Federation Server
  Problem description and summary:
     See error description.
  

Problem conclusion

• Problem was first fixed in Version 8.2, FixPak 15 (s070720).
  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:

  JR27764

Fix information

• Fixed component name

  WS II ORACLE WR

• Fixed component ID

  5724C7408

Applicable component levels

• R820 PSN

     UP