cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
455
Views
0
Helpful
5
Replies

How to properly shutdown VM subs * publisher

AdamG73545
Level 1
Level 1

I do have two of each as virtual machines. My guess is first I shut down the subs and then pubs for Unity and CCUM ???

5 Replies 5

b.winter
VIP
VIP

IMHO: As long as the database replication is in a good state, it doesn't matter.

thanks, how can I check the data replication? I did that long time ago and forget how to check.

 

on Pub: utils dbreplication runtimestate

admin:utils dbreplication runtimestate

Server Time: Thu Aug 31 08:00:15 CDT 2023

Cluster Replication State: BROADCAST SYNC ended at: 2021-11-23-09-21
Sync Result: SYNC COMPLETED on 743 tables out of 743
Sync Status: All Tables are in sync
Use CLI to see detail: 'file view activelog cm/trace/dbl/20211123_091844_dbl_repl_output_Broadcast.log'

DB Version: ccm12_5_1_15900_66

Repltimeout set to: 300s
PROCESS option set to: 1


Cluster Detailed View from CCM1 (2 Servers):

PING DB/RPC/ REPL. Replication REPLICATION SETUP
SERVER-NAME IP ADDRESS (msec) DbMon? QUEUE Group ID (RTMT) & Details
----------- ---------- ------ ------- ----- ----------- ------------------
CCM1 192.168.10.15 0.019 Y/Y/Y 0 (g_2) (2) Setup Completed
ccm2 192.168.16 0.124 Y/Y/Y 0 (g_4) (2) Setup Completed

and:

admin:utils dbreplication status


Replication status check is now running in background.
Use command 'utils dbreplication runtimestate' to check its progress

The final output will be in file cm/trace/dbl/sdi/ReplicationStatus.2023_08_31_08_02_32.out

Please use "file view activelog cm/trace/dbl/sdi/ReplicationStatus.2023_08_31_08_02_32.out " command to see the output
admin:file view activelog cm/trace/dbl/sdi/ReplicationStatus.2023_08_31_08_02_32.out

Thu Aug 31 08:02:32 2023 main() DEBUG: -->
Thu Aug 31 08:02:37 2023 main() DEBUG: Replication cluster summary:
SERVER ID STATE STATUS QUEUE CONNECTION CHANGED
-----------------------------------------------------------------------
g_2_ccm12_5_1_15900_66 2 Active Local 0
g_4_ccm12_5_1_15900_66 4 Active Connected 0 Nov 24 10:33:42
Thu Aug 31 08:02:40 2023 main() DEBUG: <--

admin:file view activelog cm/trace/dbl/20211123_091844_dbl_repl_output_Broadcast.log

[11/23/2021 09:18:44] Executing su - informix -c "source /usr/local/cm/db/informix/local/ids.env; cdr err --zap"
[11/23/2021 09:18:45] Start Broadcasting server in RTList...(g_4_ccm12_5_1_15900_66 )
[11/23/2021 09:18:45] Executing su - informix -c "source /usr/local/cm/db/informix/local/ids.env; cdr realize template ccmdbtemplate g_4_ccm12_5_1_15900_66 >> /var/log/active/cm/trace/dbl/20211123_091844_dbl_repl_cdr_Broadcast.log 2>&1"
[11/23/2021 09:19:01] Realize Template Successfully.
[11/23/2021 09:19:01] Time taken to do realize template [16.9186000824]
[11/23/2021 09:19:01]
[11/23/2021 09:19:01] Executing su - informix -c "source /usr/local/cm/db/informix/local/ids.env; cdr err -a 2>&1 > /usr/local/cm/db/cdr_err.out"
[11/23/2021 09:19:02] Executing su - informix -c "source /usr/local/cm/db/informix/local/ids.env; cdr err --zap"
[11/23/2021 09:19:04] Executing su - informix -c "source /usr/local/cm/db/informix/local/ids.env; ulimit -c 0; cdr check replicateset -m g_2_ccm12_5_1_15900_66 -s ccmdbtemplate g_4_ccm12_5_1_15900_66 --repair --name=chkreplicateset --verbose >> /var/log/active/cm/trace/dbl/20211123_091844_dbl_repl_cdr_Broadcast.log 2>&1"
[11/23/2021 09:20:47] Cdr check completed successfully.
[11/23/2021 09:20:47] Time taken to do cdr check repair [102.180881977]
[11/23/2021 09:20:47]
[11/23/2021 09:20:47] Time taken for first cdr check repair + subsequent repair attempt(s) [104.830208063]
[11/23/2021 09:20:47] Executing su - informix -c "source /usr/local/cm/db/informix/local/ids.env; cdr err -a 2>&1 > /usr/local/cm/db/cdr_err.out"
[11/23/2021 09:20:47] Replication Setup Complete Successfully

similar output for Unity so my guess is all is ok  ?

You have status equals 2, that means all is good.



Response Signature