sysadmin cdb

Administers the net-change database in real-time loading (RTL) replication to Sybase IQ and high volume adaptive replication (HVAR) into Adaptive Server.

Syntax

To hold, inspect, and release a net-change database,use:

To inspect and release net-change database instances, use:

sysadmin cdb, q_number, q_type,{hold | hold_next | unhold} 
Note: You must execute sysadmin cdb with hold or hold next before you can use sysadmin cdb to display net-change database information if the Data Server Interface Executor (DSI/E) thread is actively processing transactions.

To display information on the net-change database, use:

To display all information on the net-change database, or only information on specific tracking tables, use:

sysadmin cdb,
       [q_number[,q_type][list[,[“table_owner.]table_name”] |
       [[dump_i | dump_d | dump_u | dump_nc],table_name] |dump_nc]]

Parameters

Examples

Usage

You can list detailed information on a specific in-memory table in the net-change database by including one of these SQL commands in your query. The in-memory tables are for internal processing and the contents are not disk-resident.

You must execute sysadmin net_change_db hold or sysadmin net_change_db hold next before you can use sysadmin net_change_db list to display net-change database information.

Permissions

sysadmin net_change_db requires “sa” permission.

Related reference
admin who
admin config