LTMADMIN user ID permissions error

In data-sharing environments, if Replication Extract is unable to determine the high LRSN value, you can receive the following Replication Extract error messages:

LEX0073 DB2 Authorization Error rc=00000008 reason=00E60824. Check user privileges.
LEX00027 Sybase Log Extract unable to retrieve DB2 high written RBA.
LEX0059 Ftch for high LRSN failed.

This condition can indicate that the LTMADMIN user ID does not have the required permission to execute MONITOR2 commands on DB2.

StepsTo grant LTMADMIN permission to execute MONITOR2 commands

  1. Grant the LTMADMIN user permission to execute MONITOR2 commands on DB2 using the following syntax:

    GRANT MONITOR2 to LTMADMIN_user_ID
    

    where LTMADMIN_user_ID is the LTMADMIN user name you recorded in section 1a on the Replication Agent Installation Worksheet.