公司的产品数据库环境,用shareplex做复制。 最近检查数据时,发现有些数据丢失了。都是在同一个时间段。找到具体丢失的数据和时间点之后,找产品DBA问问情况。(其实我们自己也有定时的检测程序,只是时间段比较宽。)回复说是因为某种原因,shareplex忽略了一小段redo log。现在他们已经把参数 SP_OCT_SKIP_BAD_BLOCK 改回默认值(0)。
看了一下参考文档,居然没有这个参数的说明。到quest的网站上找一下,发现这个:
https://support.quest.com/search/SolutionDetail.aspx?id=SOL20598
Solution SOL20598
Title
Capture cannot start Warning: A portion of the redo log could not be parsed/Notice: Begin record skip at seqno= offset= rc=
Problem Description
event_log errors:
08/24/08 22:11 Notice: (Read) Queue write recovery started, sqrw_srcseq= msg.mpseq=<xxxxxxx> [sp_ordr(que)/<pid#>]
08/24/08 22:12 Notice: Queue write recovery complete, <xxxx> duplicate messages skipped , <xxxxxxx> bytes total [sp_ordr(que)/<pid#>]
08/24/08 22:12 Warning: A portion of the redo log could not be parsed [sp_ocap/<pid#>]
08/24/08 22:12 Notice: Begin record skip at seqno=<xxxxxxx> offset=-<xxxxxxx> rc=1<xx> [sp_ocap/<pid#>]
capture log errors:
08-08-24 22:11:59.127653 11462 4 Archive filename=<archive log destination path>/LOGxxxx_x.ARC doesn't exist for file dest_id <x>
08-08-24 22:11:59.127714 11462 4 Archive filename=<archive log destination path>/LOGxxxx_x.ARC doesn't exist and retried with
08-08-24 22:11:59.127714 11462 4 dest_id of 1 thru <x>
08-08-24 22:11:59.127783 11462 4 stat(<archive log destination path>/LOGxxxx_x.ARC, sbuf) failed
08-08-24 22:11:59.133165 11462 4 Try to find file contains string "xxxxx" under <
08-08-24 22:11:59.134353 11462 4 about to stat <archive log destination path>/LOGxxxx_x.ARC
08-08-24 22:11:59.141007 11462 4 Found file with seqno=xxxxx "<archive log destination path>/LOGxxxx_x.ARC"
08-08-24 22:11:59.141135 11462 4 Found archive log with seqno=xxxxx, thread=x under <archive log destination path>
08-08-24 22:12:21.658840 11462 4 Invalid block number -xxxxxxx requested, should be [x,xxxxxxx]
08-08-24 22:12:21.665297 11462 4 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
08-08-24 22:12:21.665358 11462 4 Log parser error x
Cause
This is generally caused when capture cannot read the archive log for the following reason:
1.A corrupt redo/archive log file .
2.Unable to read the archive logs .
Resolution
Resolution 1:
If it is determined that the redo/archive log is corrupted then use the following workaround :
sp_ctrl (<source host>:<port#>)> stop capture
sp_ctrl (<source host>:<port#>)> set param SP_OCT_SKIP_BAD_BLOCK 1
sp_ctrl (<source host>:<port#>)> start capture
Resolution 2:
If capture is unable to read the archive log then please ensure that the archive log is readable. Check that the archive logs are in archive log destination, uncompressed and readable to the splex user.
Additional Information
These messages in the problem description get repeated in the logs several times, identifying one log file and particular offset.
Environment
-
Product:
Shareplex for Oracle~5.0
-
Attachments:
-
Client OS:
All - N/A
-
Server OS:
All - N/A
-
Database:
Oracle
-
Application
All - N/A
顺便把现在用的参数记下来,以后好留存。(SharePlex Version = 7.0.2)
sp_ctrl (xxxx:11111)> list param all
Activation Database parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_ACT_DEBUG 0x00000000 bitflag Live
User Initiated Process parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_ANY_DEBUG 0x00000000 bitflag Live
CFG parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_CFG_DEBUG 0x00000000 bitflag Live
Command and Control parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_CNC_COMM_TIMEOUT 0 minutes Live
SP_CNC_DEBUG 0x00000000 bitflag Live
SP_CNC_LOG 0 number Live
Control Process parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_COP_DEBUG 0x00000000 bitflag Live
SP_COP_EXPORT_LIMIT 0 Restart Cop
SP_COP_IDLETIME 60 seconds Live
SP_COP_SCAN_TIMEOUT 300 seconds Live
SP_COP_SO_RCVBUF 0 bytes Restart Cop
SP_COP_TPORT 19009 Restart Cop
Default Value: 2100
SP_COP_UPORT 19009 Restart Cop
Default Value: 2100
Compare/Repair parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_DEQ_AUTO_REPAIR1 1 boolean Live
SP_DEQ_BATCHSIZE 10000 rows Live
SP_DEQ_CHARACTERSET Live
SP_DEQ_CLIENT_MEM_TEST 0 boolean Live
SP_DEQ_COMPARE_DEBUG 0x00000000 bitflag Live
SP_DEQ_COMPARE_TESTING_FLAG 0 boolean Live
SP_DEQ_CONFIG_LINE_SIZE 2048 number Live
SP_DEQ_DEBUG 0x00000000 bitflag Live
SP_DEQ_IGNORE_ORACLE_ERROR_NUM 0 number Live
SP_DEQ_IP_MAPPING Live
SP_DEQ_IP_MAPPING_OPTION 1 number Live
SP_DEQ_LOCK_WAIT 300 seconds Live
SP_DEQ_LOG_ROWID 1 boolean Live
SP_DEQ_NCHAR_CHARACTERSET Live
SP_DEQ_NLS_LANG Live
SP_DEQ_NLS_LANG_SELECTOR 0 number Live
SP_DEQ_ORACLE_LOGOFF 1 boolean Live
SP_DEQ_PADDER 0 number Live
SP_DEQ_PART_TABLE_UPDATE 0 number Live
SP_DEQ_READ_BUFFER_SIZE 1 mbytes Live
SP_DEQ_RESULTS_RETENTION 90 days Live
SP_DEQ_REUSE_CONFIG 1 boolean Live
SP_DEQ_ROW_LOCK_THRESHOLD 1000 number Live
SP_DEQ_SERVER_MEM_TEST 0 boolean Live
SP_DEQ_SKIP_LOB 0 boolean Live
SP_DEQ_SLEEP 0 seconds Live
SP_DEQ_SOURCE_EMBEDDED_SOURCE_ Live
SP_DEQ_SOURCE_EMBEDDED_TARGET_ Live
SP_DEQ_SWAP_BYTE 0 number Live
SP_DEQ_THREAD_STACK_SIZE 4096 kbytes Live
SP_DEQ_THREADS 2 threads Live
SP_DEQ_TIMEOUT 1800 seconds Live
Horizontal Partitioning parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_HPP_DEBUG 0x00000000 bitflag Live
Import parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_IMP_DEBUG 0x00000000 bitflag Live
SP_IMP_TIMEOUT 0 seconds Live
SP_IMP_WCMT_MSGCNT 10000 message Live
SP_IMP_WCMT_TIMEOUT 30 seconds Live
License parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_LIC_DEBUG 0x00000000 bitflag Live
Debug Logging parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_LOG_DEBUG 0x00000000 bitflag Live
Configuration Management parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_OCF_DEBUG 0x00000000 bitflag Live
SP_OCF_LOCK_WAIT_TIME 5 minutes Live
SP_OCF_THREAD_COUNT 3 threads Live
Capture parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_OCT_ANALYZE 0x00000000 bitflag Live
SP_OCT_APPL_PARSE_FLAG 1 Restart Process
SP_OCT_ARCH_LOC /home Live
SP_OCT_ASM_CONNECT_DESC Restart Process
SP_OCT_ASM_DEBUG 0x00000000 bitflag Live
SP_OCT_ASM_ECACHE_SIZE 20 count Restart Process
SP_OCT_ASM_FLIST_SIZE 10 count Restart Process
SP_OCT_ASM_SID +ASM1 Restart Process
Default Value:
SP_OCT_ASM_SLIST_SIZE 10 count Restart Process
SP_OCT_ASM_SUPPORT 1 flag Restart Process
Default Value: 0
SP_OCT_AUDIT_DEBUG 0x00000000 bitflag Live
SP_OCT_BIO_DEBUG 0x00000000 bitflag Live
SP_OCT_CACHE_DEBUG 0x00000000 bitflag Live
SP_OCT_CHECKPOINT_FREQ 40000 message Live
SP_OCT_CHECKPOINT_LOG 2 logs Live
SP_OCT_CHECKPOINT_TIME 120 seconds Live
SP_OCT_CK_LOC_FIRST 0 flag Restart Process
SP_OCT_DATA_OBJ_CACHE_SIZE 50 values Live
SP_OCT_DATE_MSG 0 Live
SP_OCT_DDL_DEBUG 0x00000000 bitflag Live
SP_OCT_DDL_LOGGING 2 Live
SP_OCT_DEBUG 0x00000000 bitflag Live
SP_OCT_DEF_DAY 1 Live
SP_OCT_DEF_HOUR 0 Live
SP_OCT_DEF_MIN 0 Live
SP_OCT_DEF_MONTH 1 Live
SP_OCT_DEF_SEC 0 Live
SP_OCT_DEF_YEAR 1999 Live
SP_OCT_DENIED_USERID 91 number Live
Default Value: 0x00000000
SP_OCT_ERROR_THRESHOLD 3 Live
SP_OCT_FIO_DEBUG 0x00000000 bitflag Live
SP_OCT_GEN_DEBUG 0x00000000 bitflag Live
SP_OCT_GEN_DEBUG_OBJID -1 number Live
SP_OCT_GEN_STOP 0x00000000 bitflag Live
SP_OCT_IDLE_LOGIN 60 seconds Restart Process
SP_OCT_IOT_RB_BATCH_SIZE 5000 Live
SP_OCT_LOB_BUFFER_SIZE 5242880 Restart Process
SP_OCT_LOG_FILESIZE 50000000 bytes Restart Process
SP_OCT_LOG_MEMBER % Restart Process
SP_OCT_LOG_NUMFILES 3 number Restart Process
SP_OCT_LOG_READ_SIZE 64 Restart Process
SP_OCT_LOGWRAP_RESTART 300 seconds Live
SP_OCT_MAX_SESSIONS 4000 Restart Process
SP_OCT_OCAP_CONFIG 0 Live
SP_OCT_OCAP_DEBUG 0x00000000 bitflag Live
SP_OCT_OCM_DEBUG 0x00000000 bitflag Live
SP_OCT_OLOG_DEBUG 0x00000000 bitflag Live
SP_OCT_OLOG_DELAY 10000 microse Live
SP_OCT_OLOG_DIRECT 0 # Enabl Restart Process
SP_OCT_OLOG_LOGPAR_QSIZE 5000 Restart Process
SP_OCT_OLOG_NO_DATA_DELAY 100000 microse Unknown
SP_OCT_OLOG_QUEUE_SIZE 1000 # Queue Restart Process
SP_OCT_OLOG_REOPEN 1 # Flag Restart Process
SP_OCT_OLOG_THREAD_SINGLE 1 Restart Process
SP_OCT_OLP_DEBUG 0x00000000 bitflag Live
SP_OCT_OPC_DEBUG 0x00000000 bitflag Live
SP_OCT_OPP_DEBUG 0x00000000 bitflag Live
SP_OCT_OPS_LOGREADER_DEBUG 0x00000000 bitflag Live
SP_OCT_OPS_LOGREADER_DELAY 500000 microse Unknown
SP_OCT_OPS_LOGREADER_RETRY 3 retries Unknown
SP_OCT_OPS_NO_DATA_DELAY 5 decisec Unknown
SP_OCT_OPS_OPSLOG_DEBUG 0x00000000 bitflag Live
SP_OCT_OPS_QUEUE_SIZE 10000 Restart Process
SP_OCT_OPS_SEQ_DEBUG 0x00000000 bitflag Live
SP_OCT_REBUILD_LOBCACHE 0 Restart Process
SP_OCT_REDO_RAW_OFFSET -1 bytes Restart Process
SP_OCT_REDOLOG_ENSURE 2 seconds Live
SP_OCT_REDUCED_KEY 1 Live
SP_OCT_REPLICATE_ALL_DDL 0 Live
SP_OCT_REPLICATE_DDL 0 Live
Default Value: 3
SP_OCT_REPLICATE_DLOAD 1 Live
SP_OCT_REPLICATE_POSTER 0 Restart Process
SP_OCT_REQUIRED_DATA_IS_LOGGED 1 Restart Process
SP_OCT_RESTART_THRESHOLD 0 retries Live
SP_OCT_SKIP_BAD_BLOCK 0 Restart Process
SP_OCT_TARGET_COMPATIBILITY 6.0 Live
Default Value: 7.0
SP_OCT_TIME_LIMIT 300 seconds Live
SP_OCT_TIME_SEQUENCER 0 Live
SP_OCT_TRP_DEBUG 0x00000000 bitflag Live
SP_OCT_UTILIZATION_TIMERS 0 Live
Object Id parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_OID_DEBUG 0x00000000 bitflag Live
Post parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_OPO_BATCH_REEXECUTE 1 Live
SP_OPO_BLOCK_QUERY 1 Live
SP_OPO_CHARACTERSET Restart Process
SP_OPO_CHECK_INACTIVE_SESSION 0 Live
SP_OPO_CONT_ON_ERR 0 Live
SP_OPO_CONTINUE_ON_MISMATCH 0 Live
SP_OPO_DEBUG 0x00000000 bitflag Live
SP_OPO_DEBUG_CR 0x00000000 bitflag Live
SP_OPO_DEBUG_FLAG 0x00000000 bitflag Live
SP_OPO_DEBUG_KCA 0x00000000 bitflag Live
SP_OPO_DELAY_TIME 5 seconds Live
SP_OPO_DELAY_TIME_MAX 10 seconds Live
SP_OPO_DISABLE_OBJECT_NUM Live
SP_OPO_ERR_ROWID 1 Live
SP_OPO_GENERIC_CR 1 Restart Process
Default Value: 0
SP_OPO_HINTS_LIMIT 100 hints Restart Process
SP_OPO_IDLE_LOGIN 60 seconds Live
SP_OPO_IDLE_LOGOUT 300 seconds Live
SP_OPO_KCA_REHASHRATIO 60 Restart Process
SP_OPO_LCACHE_DEBUG 0x00000000 bitflag Live
SP_OPO_LOG_FILESIZE 50000000 bytes Restart Process
SP_OPO_LOG_NUMFILES 3 number Restart Process
SP_OPO_MAX_CDA 50 Restart Process
SP_OPO_MAX_OEXN_TIME 1800 seconds Restart Process
Default Value: 180
SP_OPO_MAX_ROLLBACK_MESSAGES 10000 Restart Process
SP_OPO_MAX_SESSIONS 4000 Live
SP_OPO_NCHAR_CHARACTERSET Restart Process
SP_OPO_NERR_MAX 100 Live
SP_OPO_NLS_LANG Restart Process
SP_OPO_OBJID_DEBUG 0 number Live
SP_OPO_OBREAK_DELAY_TIME 5 seconds Live
SP_OPO_OBREAK_NOT_USED 0 Restart Process
SP_OPO_OPST_DEBUG 0x00000000 bitflag Live
SP_OPO_OUT_OF_SYNC_SUSPEND 0 Live
SP_OPO_PARSE_TIMEOUT 100 msec Live
SP_OPO_POSTER_DELAY 0 minutes Live
SP_OPO_PR_STAT_ON 0 Live
SP_OPO_PRB_MISMATCH_SUSPEND 0 Live
SP_OPO_QUE_REREAD_INTERVAL 1 seconds Live
SP_OPO_READRELEASE_INTERVAL 10000 Live
Default Value: 100
SP_OPO_RETRIES_MAX 10 retries Live
SP_OPO_RETRY_DELAY_TIME 0 seconds Live
SP_OPO_SAVEPOINT_SIZE 1000 Restart Process
SP_OPO_SQL_CACHE_DISABLE 1 Restart Process
Default Value: 0
SP_OPO_SQL_DEBUG 0x00000000 bitflag Live
SP_OPO_SQL_LCACHE_DEBUG 0x00000000 bitflag Live
SP_OPO_SQL_TRACE_ON 0 Restart Process
SP_OPO_STOP_ON_DDL_ERR 1 Live
SP_OPO_THREADS_MAX 64 Restart Process
SP_OPO_USE_VARNUM 0 Restart Process
SP_OPO_UTILIZATION_TIMER_THREA 64 Live
SP_OPO_UTILIZATION_TIMERS 0 Live
SP_OPO_WAIT_MSG_DELAY 300 seconds Restart Process
SP_OPO_XFORM_EXCLUDE_ROWID 0 Restart Process
Read parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_ORD_BATCH_ENABLE 1 Live
SP_ORD_BATCH_MATCH_MIN 2 operati Restart Process
SP_ORD_BATCH_MAX 50 batches Restart Process
SP_ORD_CDA_LIMIT 5 cdas Restart Process
SP_ORD_DATE_MSG 0 Live
SP_ORD_DEBUG 0x00000000 bitflag Live
SP_ORD_DEBUG_FLAG 0x00000000 bitflag Live
SP_ORD_DEBUG_OBJECT 0 objecti Live
SP_ORD_DELAY_RECORDS 200 records Live
SP_ORD_FIRST_FIND 1 Restart Process
SP_ORD_HP_HASH 16 slots Restart Process
SP_ORD_HP_IN_SYNC 0 Restart Process
SP_ORD_LDA_ARRAY_SIZE 5 logins Restart Process
SP_ORD_LOG_FILESIZE 50000000 bytes Restart Process
SP_ORD_LOG_NUMFILES 3 number Restart Process
SP_ORD_LOGIN_O xxx=========xxxxx Set Up
Default Value:
SP_ORD_MSGS_CK_FREQ 10000 number Restart Process
SP_ORD_NLS_LANG Restart Process
SP_ORD_OWNER_O xxx========xxxx Set Up
Default Value:
SP_ORD_RCM_SKIP_RATIO 2 ratio Restart Process
SP_ORD_RESTART_THRESHOLD 0 retries Live
SP_ORD_RMSG_LIMIT 20000 readrel Live
SP_ORD_SEND_DDL_TO_FIRST 0 Live
SP_ORD_SKIP_OBJECT 0 objecti Live
SP_ORD_UTILIZATION_TIMERS 0 Live
Support Library parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_OSP_DEBUG 0x00000000 bitflag Live
Sync parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_OSY_COMPRESSION 6 Live
SP_OSY_DEBUG 0x00000000 bitflag Live
SP_OSY_EXP_BUFFER_SIZE 1024 kbytes Live
SP_OSY_IMP_BUFFER_SIZE 1024 kbytes Live
SP_OSY_LOCK_TIMEOUT 2 Seconds Live
SP_OSY_PORT 2501 Live
SP_OSY_POST_TIMEOUT 1800 Seconds Live
SP_OSY_TCP_TIMEOUT 60 Seconds Live
SP_OSY_THREADS 5 Thread Live
Parameter Database parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_PDB_DEBUG 0x00000000 bitflag Live
SharePlex Queues parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_QUE_DEBUG 0x00000000 bitflag Live
SP_QUE_DFILSIZ 8388608 bytes Restart Cop
SP_QUE_MAX_QUEUES 25 queues Restart Cop
SP_QUE_POST_SHMSIZE 33554432 bytes Restart Cop
SP_QUE_Q_SHMSIZE 8388608 bytes Restart Cop
SP_QUE_SAVE_DATA 0 Restart Cop
SP_QUE_SAVE_DISCARDED_MSG 0 Restart Cop
SP_QUE_SHMDBUF 32768 bytes Restart Cop
SP_QUE_SHMSIZE 33554432 bytes Restart Cop
SP_QUE_SUBQUEUE_TOO_OLD 300 seconds Live
SP_QUE_SYNC 2 Restart Cop
SP_QUE_USE_OVF 0 Restart Cop
Reconcile parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_RCL_DEBUG 0x00000000 bitflag Live
SP_RCL_IDLE_LOGIN 60 seconds Live
SP_RCL_LOG_FILESIZE 50000000 bytes Restart Process
SP_RCL_LOG_NUMFILES 3 number Restart Process
Routing Interface Module parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_RIM_DEBUG 0x00000000 bitflag Live
Reliable Message Protocol parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_RMP_DEBUG 0x00000000 bitflag Live
Response Module parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_RSP_DEBUG 0x00000000 bitflag Live
SharePlex Statistics parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_SHS_DEBUG 0x00000000 bitflag Live
SP_SHS_MAXLOCK 12 writers Restart Cop
SP_SHS_MAXWRITERS 2000 writers Restart Cop
SP_SHS_SHMSIZE 8388608 bytes Restart Cop
Event Logging parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_SLG_DEBUG 0x00000000 bitflag Live
SP_SLG_LOG_MAXSIZE 500 mbytes Restart Cop
SP_SLG_SNMP_ACTIVE 0 Restart Cop
SP_SLG_SNMP_COMMUNITY Restart Cop
SP_SLG_SNMP_ERROR 0 Restart Cop
SP_SLG_SNMP_EXIT 0 Restart Cop
SP_SLG_SNMP_HOST Restart Cop
SP_SLG_SNMP_INT_ERROR 0 Restart Cop
SP_SLG_SNMP_LAUNCH 0 Restart Cop
SP_SLG_SNMP_MJR_ERRNUM 0 Restart Cop
SP_SLG_SNMP_MNR_ERRNUM 0 Restart Cop
SP_SLG_SNMP_OUT_OF_SYNC 0 Restart Cop
SP_SLG_SNMP_SHUTDOWN 0 Restart Cop
SP_SLG_SNMP_STARTUP 0 Restart Cop
SP_SLG_SNMP_SYS_ERROR 0 Restart Cop
Services Database parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_SRV_DEBUG 0x00000000 bitflag Live
Status Database parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_STT_DEBUG 0x00000000 bitflag Live
System parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_SYS_DEBUG 0x00000000 bitflag Live
SP_SYS_HOST_NAME Restart Cop
SP_SYS_IN_SYNC 0 Restart Process
SP_SYS_JOB_HISTORY_RETENTION 90 days Live
SP_SYS_LIC_11111 xxx===============xxx Install
Default Value:
SP_SYS_LOG_INTERVAL 30 seconds Live
SP_SYS_QUE_FULL 20000000 bytes Live
SP_SYS_QUE_OK 10000000 bytes Live
SP_SYS_SUSPEND_ON_ERROR 1 Live
SP_SYS_VAR_FULL 30 mbytes Live
SP_SYS_VAR_OK 50 mbytes Live
Utility parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_UTL_DEBUG 0x00000000 bitflag Live
Export parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_XPT_ALTERNATE_HOST Restart Process
SP_XPT_DEBUG 0x00000000 bitflag Live
SP_XPT_KEEPALIVE 1 Restart Process
Default Value: 0
SP_XPT_PORT_OVERRIDE 0 Restart Process
SP_XPT_SO_SNDBUF 0 bytes Restart Process
SP_XPT_TIMEOUT 0 seconds Live
SP_XPT_USE_LOCALHOST 0 Restart Process
sp_ctrl (xxxx:11111)>
sp_ctrl (xxxx:11111)> version
SharePlex Version = 7.0.2
sp_ctrl (xxxx:11111)>