solidDB Help : solidDB reference : SQL: Statements : DESCRIBE REPLICATION
  
DESCRIBE REPLICATION
DESCRIBE REPLICATION {CONNECTION connection‑name | PARTITION partition-name |
   SUBSCRIPTION subscription-name | STATUS subscription-name
Access requirements
Database user
Usage
Use the DESCRIBE REPLICATION statement to print the description of a specified replication connection, replication partition, replication subscription, or status of a replication subscription.
▪ CONNECTION: Prints a description of the specified replication connection.
▪ PARTITION: Prints a description of the specified replication partition.
▪ SUBSCRIPTION: Prints a description of the specified replication subscription and show its running parameters. This statement is not transactional; the running subscription status changes asynchronously.
▪ STATUS: Prints a description of the replication status of the specified subscription, see Checking replicator status.
Return values
 
Error code
Description
13420
Logreader syntax error near [...]
23004
Syntax error
Examples
solsql> DESCRIBE REPLICATION CONNECTION conn1;
RESULT
------
Connection: CONN1
 Connect string: tcp 1323
 UUID: ec9d2779-182f-4117-afdc-4a5bbcfdee0f
 User name: DBA
 Connect timeout: 0

1 rows fetched.
solsql> DESCRIBE REPLICATION PARTITION share2;
RESULT
------
Partition: SHARE2 Table: DBA.DBA.TAB1 (COL_A, COL_B)
Partition: SHARE2 Table: DBA.DBA.TAB2 ID > 10
solsql> DESCRIBE REPLICATION SUBSCRIPTION sub1;
RESULT
------
Subscription: SUB1
   Connect to: CONN1
   Partition: SHARE1
   Load method: TRUNCATE FROM SOURCE
   On conflict: ABORT SUBSCRIPTION
   Last connected:
   Status: INIT

1 rows fetched.
Go up to
SQL: Statements