Returns LOB column replication status; enables or disables replication for LOB columns within marked tables.
To return replication status of all LOB columns in all tables or all LOB columns in a specific table, or to enable or disable all LOB columns in a table:
pdb_setrepcol [tablename [enable|disable]]
To return replication status of a specific LOB column in a specific table:
pdb_setrepcol tablename, colname
To enable or disable all LOB columns in all marked tables:
pdb_setrepcol all [,{enable|disable [, force]}]
To enable or disable replication for a specified LOB column:
pdb_setrepcol tablename, colname [,{enable|disable [, force]}]
The name of the user table in the primary database that contains the column specified in the colname option.
The tablename option can be owner-qualified (include the owner name), with each element separated by a period. For example:
owner.table
The tablename option can be delimited with quote characters to specify the character case.
If mixed case (uppercase and lowercase) is required, the name must be delimited. For example:
"Owner".table
"Owner"."Table"
Each mixed-case element of the tablename option must be delimited separately, as shown in the previous example.
If you must use an object name case that does not match
the value of the ltl_character_case parameter,
the object name must be delimited.
If an object name contains any non-alphanumeric characters, such as spaces or periods, it must be delimited with quote characters. For example:
"table name"
owner."table name"
If an object name contains a period, it must be both owner-qualified and delimited with quote characters. For example:
owner."table.name"
"table.owner"."table.name"
The name of a LOB column in the user table specified in the tablename option.
The colname option can be delimited with quote characters to specify the character case.
If mixed character case (both uppercase and lowercase) is required, the name must be delimited. For example:
"Colname"
"COLname"
If you must use a column name case that does not match
the value of the ltl_character_case parameter,
the column name must be delimited. See “ltl_character_case” for more information.
A keyword that refers to all LOB columns in marked tables in the primary database. By using the all keyword, you can apply an enable or disable operation to all LOB columns in marked tables.
A keyword that refers to enabling replication for LOB columns.
A keyword that refers to disabling replication for LOB columns.
A keyword that refers to forcing replication to be disabled for LOB columns.
When the force keyword follows the disable keyword, the pdb_setrepcol command immediately disables replication for the specified LOB column, without first checking for pending operations in the transaction log. When the force keyword follows the disable keyword and the all keyword, the pdb_setrepcol command immediately disables replication for all marked LOB columns in marked tables in the primary database, regardless of any pending operations in the transaction log.
pdb_setrepcol
This command returns replication information for all enabled LOB columns in marked tables in the primary database.
pdb_setrepcol authors
This command returns replication information for all LOB columns defined for the table authors in the primary database.
pdb_setrepcol authors, picture
This command returns replication information for the column called “picture” in the table authors in the primary database.
pdb_setrepcol authors, picture, enable
This command enables replication for the column “picture” in the table “authors” in the primary database.
pdb_setrepcol all, disable
This command disables replication for all LOB columns in all marked tables in the primary database.
If a column is renamed or dropped and a new column with the original name is created, you must explicitly enable or disable replication from this new column because the new column has no replication status related information from the original column. The marking information is maintained internally based on column number, not column name.
When pdb_setrepcol is invoked, its function is determined by the keywords and options you specify.
When multiple keywords or options are specified, each must be separated by a comma. Blank space before or after a comma is optional. For example:
pdb_setrepcol all, disable
When you specify a column name in the pdb_setrepcol command, you must use the name of a valid LOB column.
You cannot specify the following items as a table name in the pdb_setrepcol command:
Primary database system tables
Aliases or synonyms
Views
Replication Agent transaction log objects
If a column name in the primary database is the same as a keyword, it can be identified by adding the string col= to the beginning of the column name. For example:
pdb_setrepcol tablename, col=enable, disable
If you enable LOB column replication with the pdb_setrepcol command do not configure the Replication Agent to convert date or time datatypes in the primary database. See “pdb_convert_datetime” for more information.
When pdb_setrepcol is invoked with either no option or a single option, it returns information about the enabled status of LOB columns in the primary database.
If pdb_setrepcol is invoked with no option, it returns a list of all LOB columns for which replication is enabled in the primary database.
Invoking the pdb_setrepcol command
with no option produces the same result as invoking the pdb_setrepcol command
with the enable keyword.
If pdb_setrepcol is invoked with a table name, it returns information about the enabled status of all the LOB columns in the specified primary table.
If pdb_setrepcol is invoked with the enable keyword, it returns a list of all LOB columns for which replication is enabled in the primary database.
If pdb_setrepcol is invoked with the disable keyword, it returns a list of all LOB columns for which replication is disabled in the primary database.
For LOB columns listed as disabled, transactions are not captured for replication.
When pdb_setrepcol is invoked with a valid primary table name and valid LOB column name, with no keywords, it returns information about the enabled status of the specified LOB column in the specified table in the primary database.
When pdb_setrepcol is invoked with the all keyword, the operation specified by the following keyword (enable or disable) is applied to all LOB columns in marked tables in the primary database.
If pdb_setrepcol is invoked with the all keyword and the enable keyword, it enables replication for all LOB columns in marked tables in the primary database.
If pdb_setrepcol is invoked with the all keyword and the disable keyword, it disables replication for all LOB columns in marked tables in the primary database.
When pdb_setrepcol is invoked with a valid primary table name and valid LOB column name followed by one or more keywords, the operation specified by the keyword (enable or disable) is applied to the specified LOB column in the specified primary table.
If pdb_setrepcol is invoked with a table name and LOB column name and the enable keyword, it enables replication for the specified LOB column in the primary database.
If pdb_setrepcol is invoked with a table name and LOB column name and the disable keyword, it disables replication for the specified LOB column in the primary database.
If the table name and LOB column name combination you specify does not exist in the primary database, the pdb_setrepcol command returns an error.
If the Replication Agent transaction log does not exist in the primary database (DB2 UDB) or the RASD is not initialized (Oracle or Microsoft SQL Server), the pdb_setrepcol command returns an error.
If pdb_setrepcol is invoked with a table containing a “DATE” column, the primary key in the primary table must not include the “DATE” column. This is true for Replication Agent for UDB but not for Replication Agent for Oracle or Microsoft SQL Server.
