Character Case of Database Object Names

Database object names must be delivered to the primary Replication Server in the same format as specified in replication definitions; otherwise, replication fails. For example, if a replication definition specifies a table name in all lowercase, then that table name must appear in all lowercase when it is sent to the primary Replication Server by the Replication Agent.

To control the way Replication Agent treats the character case of database object names sent to the primary Replication Server, set the ltl_character_case configuration parameter to one of these values:
  • asis – (the default) database object names are passed to Replication Server in the same format as stored in the primary data server.

  • lower – database object names are passed to Replication Server in all lowercase, regardless of how they are stored in the primary data server.

  • upper – database object names are passed to Replication Server in all uppercase, regardless of how they are stored in the primary data server.

In the DB2 server, database object names are stored in all uppercase.