int ctMemphisGetArchivedReplPlans( pRCESJson request, ppRCESJson result )
Description:
Retrieve all the archived Replication Plans from the Replication Manager Database.
Notes:
"normal": when subscriptions are going only from sourceDBEngine to targetDBEngine
"reverse": when subscriptions are going only from targetDBEngine to source DBEngine
"none": there is no subscription between sourceDBEngine and targetDBEngine
"both": there are subscriptions in both ways between sourceDBEngine and targetDBEngine. It can be a "bidirectional" subscription or distinct subscriptions in both ways
HTTP URL: <baseURL>/ctMemphisGetArchivedReplPlans/
HTTP Verb: POST
Parameters:
{
"id": 1, // optional, if provided, search replication plan by ID
"name": "PLAN1", // optional, if provided search replication plan by name
"partial": true, // optional, if provided with "name", the search by name
will look for like "<name>%"
"paging": true, // optional, see Note 1 - Paging Parameters
"limit": 100, // optional, see Note 1 - Paging Parameters
"start": 200 // optional, see Note 1 - Paging Parameters
}
{
"replPlanList": [
{
"id": 0,
"name": "PLAN1",
"description": "Plan 1 description",
"sourceDBEngine": 0,
"targetDBEngine": 1,
"direction": "normal", // see "Direction" note above
"synchronous": false,
"warningThreshold": 30, // how many seconds behind to
show a warning message
"errorThreshold": 300, // how many seconds behind to
show an error
"latency": 22, // how many seconds behind the
Replication Plan is at this moment
"latencyTime": "Thu Aug 23 14:55:02 2001", // when latency was last checked
"latencyRev": 22, // how many seconds behind the
Replication Plan reverse
direction is at this moment
"latencyRevTime": "Thu Aug 23 14:55:02 2001", // when reverse direction
latency was last checked
"batchSize": 8192,
"debugMinLog": 0,
"exceptionMode": 0,
"lockRetryCount": 5,
"lockRetrySleep": 1000,
"logChangeDetails": "",
"readTimeOut": 5000,
"rememberLogPos": 1,
"parallelApply": true,
"checkDependencies": true,
"syncLogWrites": false,
"analyzerThreadsCount": 1,
"applyThreadsCount": 8,
"fileMask": "",
"isBiDirectional": 1,
"isDeployed": false,
"isPulling": true,
"ignorePartition": false,
"extensionLibrary": "ctrepluser.dll",
"status": "archived", // see "Status" note above
"statusCode": 1, // see "StatusCd" note above
"statusTime": "Thu Aug 23 14:55:02 2001",
"statusMsg": "",
"statusActionID": 132,
"sourceLogPos": "1 9383963 1 9383963",
"targetLogPos": "1 9383963 1 9383963",
"isMonitorActive": true,
"monitorTime": "Thu Aug 23 14:55:02 2001", // Since when the monitor is
active or not,
"refreshRate": 5,
"isExcepLogActive": true,
"excepLogTime": "Thu Aug 23 14:55:02 2001", // Since when the exception
logging is active or not
"isFuncTimingActive": true,
"funcTimingTime": "Thu Aug 23 14:55:02 2001", // Since when the exception
logging is active or not,
"conflictDetection": true,
"hasNonAckException": true // Flag indicating that the
Plan has at least one not
acknowledge exception
}]
"success": true,
"error":
{
"errorCode": 0,
"message": "Success"
},
"total": 500 // total number of replication plan for the query -
see Note 1 - Paging Parameters
}
Return:
Error code