Because I couldn’t find references to this yet…
tsm: TSMPROD>show repl
Replication is enabled, reason=0
Server Guid: xx.xx.xx.xx.xx.xx.xx.xx.aa.aa.aa.aa.aa.aa.aa.aa, Server Name: TSMPROD
Server Guid: yy.yy.yy.yy.yy.yy.yy.yy.bb.bb.bb.bb.bb.bb.bb.bb, Server Name: TSMREMOTE
Replication Process 7
Entry 0
server: TSMREMOTE
pri: 8 state: Complete
nodeName: CORPMAINFS01 fsName: SYSTEM STATE
nodeId: 71 fsId: 1 replMode: 0
copyType: Backup lowIdx: 0 highIdx: 0
purge: No rc: 0 activeOnly: No
numBatches: 0 hasTape: No serverId: 1
tgtNodeId: 60 tgtFsId: 1 updCount: 0
Backup Stats, statsP at 1123f6378
file stats:
Current: 0 To repl: 0 Repld: 0
Repl errT: 0 Repl errS: 0
To upd: 0 Updated: 0 Upd err: 0
To del: 0 Deleted: 0 Del err: 0
byte stats:
To repl: 0 Repld: 0 Xferred: 0
Repl errT: 0 Repl errS: 0
Xfer time: 0 seconds
batchesQ: 0 batchesD: 0
Entry 1
server: TSMREMOTE
pri: 8 state: Complete
nodeName: CORPMAINFS01 fsName: SYSTEM SERVICES
nodeId: 71 fsId: 2 replMode: 0
copyType: Backup lowIdx: 0 highIdx: 0
purge: No rc: 0 activeOnly: No
numBatches: 0 hasTape: No serverId: 1
tgtNodeId: 60 tgtFsId: 2 updCount: 0
Backup Stats, statsP at 1145891d8
file stats:
Current: 0 To repl: 0 Repld: 0
Repl errT: 0 Repl errS: 0
To upd: 0 Updated: 0 Upd err: 0
To del: 0 Deleted: 0 Del err: 0
byte stats:
To repl: 0 Repld: 0 Xferred: 0
Repl errT: 0 Repl errS: 0
Xfer time: 0 seconds
batchesQ: 0 batchesD: 0
Entry 2
server: TSMREMOTE
pri: 8 state: Complete
nodeName: CORPMAINFS01 fsName: \CORPMAINfs01c$
nodeId: 71 fsId: 3 replMode: 0
copyType: Backup lowIdx: 0 highIdx: 0
purge: No rc: 0 activeOnly: No
numBatches: 11 hasTape: No serverId: 1
tgtNodeId: 60 tgtFsId: 3 updCount: 0
Backup Stats, statsP at 11523cdf8
file stats:
Current: 0 To repl: 44267 Repld: 44267
Repl errT: 0 Repl errS: 0
To upd: 0 Updated: 0 Upd err: 0
To del: 0 Deleted: 0 Del err: 0
byte stats:
To repl: 10218555392 Repld: 10218555392 Xferred: 8501242864
Repl errT: 0 Repl errS: 0
Xfer time: 4270 seconds
batchesQ: 11 batchesD: 11
Entry 3
server: TSMREMOTE
pri: 8 state: Complete
nodeName: CORPMAINFS01 fsName: ASR
nodeId: 71 fsId: 4 replMode: 0
copyType: Backup lowIdx: 0 highIdx: 0
purge: No rc: 0 activeOnly: No
numBatches: 1 hasTape: No serverId: 1
tgtNodeId: 60 tgtFsId: 4 updCount: 0
Backup Stats, statsP at 1157f0278
file stats:
Current: 0 To repl: 230 Repld: 230
Repl errT: 0 Repl errS: 0
To upd: 0 Updated: 0 Upd err: 0
To del: 0 Deleted: 0 Del err: 0
byte stats:
To repl: 2064384 Repld: 2064384 Xferred: 1301962
Repl errT: 0 Repl errS: 0
Xfer time: 17 seconds
batchesQ: 1 batchesD: 1
Entry 4
server: TSMREMOTE
pri: 8 state: Disk in progress
nodeName: CORPMAINFS01 fsName: \CORPMAINfs01e$
nodeId: 71 fsId: 5 replMode: 0
copyType: Backup lowIdx: 0 highIdx: 0
purge: No rc: 0 activeOnly: No
numBatches: 1246 hasTape: Yes serverId: 1
tgtNodeId: 60 tgtFsId: 5 updCount: 0
Backup Stats, statsP at 11580f6b8
file stats:
Current: 28095 To repl: 3545201 Repld: 0
Repl errT: 0 Repl errS: 0
To upd: 2998 Updated: 0 Upd err: 0
To del: 494 Deleted: 494 Del err: 0
byte stats:
To repl: 9108497604556 Repld: 0 Xferred: 0
Repl errT: 0 Repl errS: 0
Xfer time: 0 seconds
batchesQ: 1246 batchesD: 0
Entry 5
server: TSMREMOTE
pri: 8 state: Complete
nodeName: CORPMAINFS01 fsName: CORPMAINFS01SystemStateNULLSystem StateSystemState
nodeId: 71 fsId: 6 replMode: 0
copyType: Backup lowIdx: 0 highIdx: 0
purge: No rc: 0 activeOnly: No
numBatches: 4 hasTape: No serverId: 1
tgtNodeId: 60 tgtFsId: 6 updCount: 0
Backup Stats, statsP at 11582dbd8
file stats:
Current: 0 To repl: 12456 Repld: 12456
Repl errT: 0 Repl errS: 0
To upd: 0 Updated: 0 Upd err: 0
To del: 0 Deleted: 0 Del err: 0
byte stats:
To repl: 5873974272 Repld: 5873974272 Xferred: 4430085593
Repl errT: 0 Repl errS: 0
Xfer time: 1530 seconds
batchesQ: 4 batchesD: 4
Entry 6
server: TSMREMOTE
pri: 8 state: Complete
nodeName: CORPMAINFS01 fsName: \CORPMAINfs01g$
nodeId: 71 fsId: 7 replMode: 0
copyType: Backup lowIdx: 0 highIdx: 0
purge: No rc: 0 activeOnly: No
numBatches: 1 hasTape: No serverId: 1
tgtNodeId: 60 tgtFsId: 7 updCount: 0
Backup Stats, statsP at 11586aa78
file stats:
Current: 0 To repl: 150 Repld: 150
Repl errT: 0 Repl errS: 0
To upd: 0 Updated: 0 Upd err: 0
To del: 0 Deleted: 0 Del err: 0
byte stats:
To repl: 488736768 Repld: 488736768 Xferred: 480733059
Repl errT: 0 Repl errS: 0
Xfer time: 123 seconds
batchesQ: 1 batchesD: 1
Entry 7
server: TSMREMOTE
pri: 8 state: Disk in progress
nodeName: CORPMAINFS01 fsName: \CORPMAINfs01f$
nodeId: 71 fsId: 8 replMode: 0
copyType: Backup lowIdx: 0 highIdx: 0
purge: No rc: 0 activeOnly: No
numBatches: 410 hasTape: No serverId: 1
tgtNodeId: 60 tgtFsId: 8 updCount: 0
Backup Stats, statsP at 115a08fb8
file stats:
Current: 196703 To repl: 199006 Repld: 0
Repl errT: 0 Repl errS: 0
To upd: 1475 Updated: 0 Upd err: 0
To del: 39584 Deleted: 39584 Del err: 0
byte stats:
To repl: 2440724264058 Repld: 0 Xferred: 0
Repl errT: 0 Repl errS: 0
Xfer time: 0 seconds
batchesQ: 410 batchesD: 0
Entry 8
server: TSMREMOTE
pri: 8 state: Disk in progress
nodeName: CORPMAINFS01 fsName: \CORPMAINfs01h$
nodeId: 71 fsId: 9 replMode: 0
copyType: Backup lowIdx: 0 highIdx: 0
purge: No rc: 0 activeOnly: No
numBatches: 44 hasTape: No serverId: 1
tgtNodeId: 60 tgtFsId: 9 updCount: 0
Backup Stats, statsP at 115c3e078
file stats:
Current: 0 To repl: 133548 Repld: 64130
Repl errT: 0 Repl errS: 0
To upd: 0 Updated: 0 Upd err: 0
To del: 0 Deleted: 0 Del err: 0
byte stats:
To repl: 140650502144 Repld: 80651372544 Xferred: 69437535042
Repl errT: 0 Repl errS: 0
Xfer time: 119062 seconds
batchesQ: 44 batchesD: 20
Session list:
Index 0, session 0, tgtSession 0, inUse: False, server
Index 1, session 0, tgtSession 0, inUse: False, server
Index 2, session 0, tgtSession 0, inUse: False, server
Index 3, session 293, tgtSession 72, inUse: True, server TSMREMOTE
Index 4, session 0, tgtSession 0, inUse: False, server
Index 5, session 298, tgtSession 74, inUse: True, server TSMREMOTE
Index 6, session 302, tgtSession 75, inUse: True, server TSMREMOTE
Index 7, session 304, tgtSession 77, inUse: True, server TSMREMOTE
Index 8, session 0, tgtSession 0, inUse: False, server
Target Policy Information:
Domain: REPWINDOWS
Management Classes:
Name: DIRMC
default?: False
Mig dest: DEDUPE
isDedup?: True
Bkup dest: DEDUPE
isDedup?: True
Arch dest:
isDedup?: False
TOC dest: DEDUPE
isDedup?: True
Name: EXALTNGE
default?: False
Mig dest: DEDUPE
isDedup?: True
Bkup dest: DEDUPE
isDedup?: True
Arch dest:
isDedup?: False
TOC dest: DEDUPE
isDedup?: True
Name: FBDR
default?: False
Mig dest: DEDUPE
isDedup?: True
Bkup dest: DEDUPE
isDedup?: True
Arch dest: DEDUPE
isDedup?: True
TOC dest: DEDUPE
isDedup?: True
Name: FILES
default?: True
Mig dest: DEDUPE
isDedup?: True
Bkup dest: DEDUPE
isDedup?: True
Arch dest: DEDUPE
isDedup?: True
TOC dest: DEDUPE
isDedup?: True
Name: IMAGE
default?: False
Mig dest: DEDUPE
isDedup?: True
Bkup dest: DEDUPE
isDedup?: True
Arch dest:
isDedup?: True
TOC dest: DEDUPE
isDedup?: True
Name: BULK
default?: False
Mig dest: DEDUPE
isDedup?: True
Bkup dest: DEDUPE
isDedup?: True
Arch dest: â–’â–’â–’â–’Uâ–’
isDedup?: False
TOC dest: DEDUPE
isDedup?: True
Name: SQL_SERVERS
default?: False
Mig dest: DEDUPE
isDedup?: True
Bkup dest: DEDUPE
isDedup?: True
Arch dest: DEDUPE
isDedup?: True
TOC dest: DEDUPE
isDedup?: True
tsm: TSMPROD>
xaminmo July 28 2012, 07:48:36 Local
Unfortunately, I haven’t found how to map StatsP nor the object list into actual objects.
Also, notice near the end that the ArchDest is gobbledygook? That has no archive copy group, but for some reason didn’t show up blank.
SELECT * FROM SYSCAT.TABLES WHERE TABNAME LIKE ‘%REP%’
TABSCHEMA: TSMDB1
TABNAME: REPLICATIONVIEW
CREATE_TIME: 2012-07-27 17:52:34.625572
COLCOUNT: 82
INDEX_COLCOUNT: 0
UNIQUE_INDEX: FALSE
REMARKS:
Replicationview only shows the list of all filespaces, and what commands were last used to replicate them, and the status of those.
It doesn’t give a file list, or index, etc.
There are no COLNAME entries that match %REP%
