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

Subscribe

You can track all active APARs for this component.

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 number

    LO59508

  • Reported component name

    ENTERPRISE INTE

  • Reported component ID

    5724L7600

  • Reported release

    851

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-03-24

  • Closed date

    2012-09-11

  • Last modified date

    2012-09-11

  • 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



Rate this page:

(0 users)Average rating

Document information


More support for:

IBM Enterprise Integrator for Domino

Software version:

8.5.1

Reference #:

LO59508

Modified date:

2012-09-11

Translate my page

Machine Translation

Content navigation