Sybase IQ database status DOWN and lower LTL version error reported

Symptom

After you set up your replication environment and try to insert rows of data into ASE, you should be able to see the replicated data within the IQ tables. Connect to the IQ database, issue a COMMIT, and run a SELECT statement to see the data. You may get an error from the Sybase Central session, which puts the DSI on the IQ database status as DOWN with the following error in your ASE log file:

"00:00000:00027:2006/09/18 15:46:19.60 server
Started Rep Agent on database, 'rapt' (dbid = 5).
00:00000:00027:2006/09/18 15:46:19.72 server
RepAgent(5): Connecting to a Replication Server that
supports a lower LTL version. Features that are not
supported by the lower LTL version may cause the
RepAgent to shutdown.
Set the 'skip unsupported features' configuration
option to prevent shutdown.
00:00000:00027:2006/09/18 15:46:19.72 server
RepAgent(5): The Replication Server LTL version should
be at least 700 for full support of features.
(Replication server LTL version 600, Rep Agent LTL
version 700)."

Solution

Connect to ASE using isql and run the following stored procedure to disable unsupported features:

use database
go
sp_config_rep_agent <database>,
'skip unsupported features','true'
go