LO59508: ODBC CONNECTOR DISPLAYS ? INSTEAD OF TIMESTAMP VALUE IN LEILOG

APAR status

• Closed as fixed if next.

Error description

• I created a TimeStamp Replication Activity to make the issue
  easy to reproduce,
  but this could be reproduced with any Activity using
  TimeStamps.
  I created a simple DB2 table with 4 fields: Customer # (key),
  First Name, Last
  Name, and TimeStamp.
  I then created a Notes Database with a Form and View for the 4
  fields, and then
  Created a TimeStamp Replication to move the data from DB2 to
  Notes.
  The Activity runs fine, the issue is if you use a DB2 Connector,
  the TimeStamp
  value is displayed in the LEILOG, but if you use a 5.3.3 ODBC
  DB2 Wire Protocol
  Driver instead of getting the TimeStamp value in the LEILOG you
  get ? where the
  TimeStamp Value should be displayed.  Here are examples from the
  LEILOG:
  
  If I run the Timestamp Replication Activity "TSRepPMR32404"
  which uses a DB2
  Connection Document, I will get the following information in the
  
  LEILOG.nsf:
  
  03/23/2011 09:36:21 AM Activity started
  
  03/23/2011 09:36:22 AM Trace Statement: <SELECT
  
  THEKEY,FIRSTNAME,LASTNAME,TMSTAMP FROM RWALSH.PMR32404 WHERE
  (TMSTAMP >
  TIMESTAMP ('2011-03-23-09.09.20.98')  AND TMSTAMP <=  TIMESTAMP
  
  ('2011-03-23-09.36.21.01') )  ORDER BY THEKEY>,  Connector
  
  'DB2PMR32404',  Method -Select-
  
  03/23/2011 09:36:22 AM Created temporary Notes view
  '(LEIIndexView0)'
  ** Supply a view name to create a more efficient permanent view,
  
  Connector 'NotesPMR32404',  Method -Select-
  
  03/23/2011 09:36:23 AM Activity finished
  
  
  
  If I run the Timestamp Replication Activity "TSRepODBCPMR32404"
  which uses a
  5.3.3 ODBC DB2 Wire Protocol Connection Document, I will get the
  
  following information in the LEILOG.nsf:
  
  03/23/2011 09:41:21 AM Activity started
  
  03/23/2011 09:41:22 AM Trace Statement: <SELECT TMSTAMP FROM
  
  RWALSH.PMR32404 WHERE 0=1>,  Connector 'ODBC PMR32404',  Method
  -Select-
  03/23/2011 09:41:22 AM Trace Statement: <SELECT THEKEY,
  FIRSTNAME,
  LASTNAME, TMSTAMP FROM RWALSH.PMR32404 WHERE TMSTAMP > ? AND
  TMSTAMP <=
  ? ORDER BY THEKEY>,  Connector 'ODBC PMR32404',  Method -Select-
  
  03/23/2011 09:41:22 AM Created temporary Notes view
  '(LEIIndexView0)'
  ** Supply a view name to create a more efficient permanent view,
  
  Connector 'NotesPMR32404',  Method -Select-
  
  03/23/2011 09:41:23 AM Activity finished
  

Local fix

• None, but could purchase and install the DB2 Client
  

Problem summary

• This APAR is closed as FIN. We have deferred the fix to a
   future release.
  

Problem conclusion

Temporary fix

Comments

• This APAR is associated with SPR# RWAH8F9MQ9.
  This APAR is closed as FIN. We have deferred the fix to a
   future release.
  

APAR Information

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

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

Fix information

Applicable component levels

• R851 PSN

     UP