Java Procedure Objects

Replication Agent creates Java procedure objects in the DB2 primary database.

Replication Agent for UDB installs SYBRAUJAR.jar and SYBTRUNCJAR.jar into these directories.

  • On Windows, the files are installed in $DB2DIR/SQLLIB/FUNCTION/jar/ pds_username, where $DB2DIR is the path to the DB2 installation, and pds_username is the value of pds_username.

  • On UNIX, the files are installed in $HOME/sqllib/function/jar/ pds_username, where $HOME is the home directory of the DB2 instance owner, and pds_username is the value of pds_username.

Note: If more than one Replication Agent instance is configured for a DB2 server—one Replication Agent instance for each database—a unique primary database user name must be specified in the pds_username configuration parameter for each Replication Agent instance. This is required to install and uninstall these JAR files.

These JAR files implement several Java procedures in the UDB primary database and are created and used in log truncation.

Java Procedures for Truncation

Procedure

Database name

Retrieves the name of the log file that contains the current LSN

prefixget_log_name_

Retrieves the version of the get_log_name Java class

prefixget_version_str_

Truncates the database log file or files from the archive log directory

prefixtrunc_log_files_

Retrieves the version of the trunc_log_files Java class

prefixget_trunc_ver_str_
Parent topic: Replication Agent Objects in the DB2 Primary Database