Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

"admin who" replication server command

4 posts in General Discussion Last posting was on 2011-08-19 03:20:27.0Z
ravikn76 Posted on 2011-08-09 09:47:25.0Z
Sender: 58fe.4e410158.1804289383@sybase.com
From: ravikn76
Newsgroups: sybase.public.rep-server
Subject: "admin who" replication server command
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e41022d.5946.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Aug 2011 02:47:25 -0700
X-Trace: forums-1-dub 1312883245 10.22.241.41 (9 Aug 2011 02:47:25 -0700)
X-Original-Trace: 9 Aug 2011 02:47:25 -0700, 10.22.241.41
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9014
Article PK: 870180

hi,

if a Sybase replication sever a running on "Host D" and
replicating 3 ASE servers say A, B and C; then can i find
the status of the 3 ASE servers by running "admin who" on
the replication server? If i can find then which thread
should i look for?
Can you help me to understand whether there will separate
threads running for replicating each of the ASE? if ASE is
down then will that thread also be terminate?
What is the thread name DIST or DSI corresponding to?

Thanks
Ravi.


sybanva Posted on 2011-08-09 14:01:08.0Z
Sender: 6ba4.4e41398b.1804289383@sybase.com
From: sybanva
Newsgroups: sybase.public.rep-server
Subject: Re: "admin who" replication server command
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e413da4.6d2f.1681692777@sybase.com>
References: <4e41022d.5946.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Aug 2011 07:01:08 -0700
X-Trace: forums-1-dub 1312898468 10.22.241.41 (9 Aug 2011 07:01:08 -0700)
X-Original-Trace: 9 Aug 2011 07:01:08 -0700, 10.22.241.41
Lines: 30
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9017
Article PK: 870182

You must have connection from Rep server which is running on
host D, to ASE server to view all associated threads.

You can check status of the all threds which are responsible
for replication from A,B,C ASE Databases.
There must be seprate set of thread for each and every ASE
database.

If the ASE server which is hosting the databases is down,
you will get thread down for the same.

DIST - Distributor

DSI - Dataserver Interface

> hi,
>
> if a Sybase replication sever a running on "Host D" and
> replicating 3 ASE servers say A, B and C; then can i find
> the status of the 3 ASE servers by running "admin who" on
> the replication server? If i can find then which thread
> should i look for?
> Can you help me to understand whether there will separate
> threads running for replicating each of the ASE? if ASE is
> down then will that thread also be terminate?
> What is the thread name DIST or DSI corresponding to?
>
> Thanks
> Ravi.


ravikn76 Posted on 2011-08-10 05:23:43.0Z
Sender: 58fe.4e410158.1804289383@sybase.com
From: ravikn76
Newsgroups: sybase.public.rep-server
Subject: Re: "admin who" replication server command
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e4215de.3f0f.1681692777@sybase.com>
References: <4e413da4.6d2f.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Aug 2011 22:23:43 -0700
X-Trace: forums-1-dub 1312953823 10.22.241.41 (9 Aug 2011 22:23:43 -0700)
X-Original-Trace: 9 Aug 2011 22:23:43 -0700, 10.22.241.41
Lines: 76
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9023
Article PK: 870189

Thanks a lot for the reply.

Can you also help what set of threads will be created for
each ASE? Is it only one thread named DIST or DSI or any
other name. for example consider the below "admin who"
output, which are the threads corresponding to ASE?

Spid Name State Info
---- ---------- ------------------
--------------------------
97 DIST Active 103 LDS.pubs2
98 SQT Awaiting Wakeup 103:1 DIST LDS.pubs2
68 SQM Awaiting Message 103:0 LDS.pubs2
89 DSI EXEC Awaiting Message 106(1)
SYDNEY_DS.pubs2sb
91 DSI Awaiting Command 106 SYDNEY_DS.pubs2sb
21 DSI EXEC Awaiting Message 101(1)
TOKYO_DS.TOKYO_RSSD
10 DSI Awaiting Command 101
TOKYO_DS.TOKYO_RSSD
16 DIST Active 101
TOKYO_DS.TOKYO_RSSD
17 SQT Awaiting Wakeup 101:1 DIST
TOKYO_DS.TOKYO_RSSD
15 SQM Awaiting Message 101:1
TOKYO_DS.TOKYO_RSSD
14 SQM Awaiting Message 101:0
TOKYO_DS.TOKYO_RSSD
30 REP AGENT Awaiting Command TOKYO_DS.TOKYO_RSS
USER
4 DSI EXEC Awaiting Message 104(1) TOKYO_DS.pubs2
0 DSI Awaiting Command 104 TOKYO_DS.pubs2
8 REP AGENT Awaiting Command TOKYO_DS.pubs2
USER
53 RSI Awaiting Wakeup SYDNEY_RS
52 SQM Awaiting Message 16777318:0 SYDNEY_RS
RSI USER Inactive TOKYO_RS
11 dSUB Active
6 dCM Awaiting Message
9 dAIO Awaiting Message
12 dREC Active dREC
71 USER Active sa
5 dALARM Awaiting Wakeup
13 dSYSAM Sleeping

> You must have connection from Rep server which is running
> on host D, to ASE server to view all associated threads.
>
> You can check status of the all threds which are
> responsible for replication from A,B,C ASE Databases.
> There must be seprate set of thread for each and every ASE
> database.
>
> If the ASE server which is hosting the databases is down,
> you will get thread down for the same.
>
> DIST - Distributor
>
> DSI - Dataserver Interface
>
>
> > hi,
> >
> > if a Sybase replication sever a running on "Host D" and
> > replicating 3 ASE servers say A, B and C; then can i
> > find the status of the 3 ASE servers by running "admin
> > who" on the replication server? If i can find then which
> > thread should i look for?
> > Can you help me to understand whether there will
> > separate threads running for replicating each of the
> > ASE? if ASE is down then will that thread also be
> > terminate? What is the thread name DIST or DSI
> corresponding to? >
> > Thanks
> > Ravi.


sybanva Posted on 2011-08-19 03:20:27.0Z
Sender: 6669.4e4dd353.1804289383@sybase.com
From: sybanva
Newsgroups: sybase.public.rep-server
Subject: Re: "admin who" replication server command
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e4dd67b.680d.1681692777@sybase.com>
References: <4e4215de.3f0f.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 18 Aug 2011 20:20:27 -0700
X-Trace: forums-1-dub 1313724027 10.22.241.41 (18 Aug 2011 20:20:27 -0700)
X-Original-Trace: 18 Aug 2011 20:20:27 -0700, 10.22.241.41
Lines: 104
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9034
Article PK: 870200

You can see all the thread as below, its basically depends
upon your connection setup.

If log transfer is on over the connection , you will also
have rep agent connection manager thread inside rep server.

See, whenever we add a primary/replicate database, we need a
connection. A connection always represents a replicate
database (means connection must be having DSI thread).


21 DSI EXEC Awaiting Message 101(1)
TOKYO_DS.TOKYO_RSSD
10 DSI Awaiting Command 101
TOKYO_DS.TOKYO_RSSD
16 DIST Active 101
TOKYO_DS.TOKYO_RSSD
17 SQT Awaiting Wakeup 101:1 DIST
TOKYO_DS.TOKYO_RSSD
15 SQM Awaiting Message 101:1
TOKYO_DS.TOKYO_RSSD
14 SQM Awaiting Message 101:0
TOKYO_DS.TOKYO_RSSD

> Thanks a lot for the reply.
>
> Can you also help what set of threads will be created for
> each ASE? Is it only one thread named DIST or DSI or any
> other name. for example consider the below "admin who"
> output, which are the threads corresponding to ASE?
>
> Spid Name State Info
> ---- ---------- ------------------
> --------------------------
> 97 DIST Active 103 LDS.pubs2
> 98 SQT Awaiting Wakeup 103:1 DIST
> LDS.pubs2
> 68 SQM Awaiting Message 103:0 LDS.pubs2
> 89 DSI EXEC Awaiting Message 106(1)
> SYDNEY_DS.pubs2sb
> 91 DSI Awaiting Command 106
> SYDNEY_DS.pubs2sb
> 21 DSI EXEC Awaiting Message 101(1)
> TOKYO_DS.TOKYO_RSSD
> 10 DSI Awaiting Command 101
> TOKYO_DS.TOKYO_RSSD
> 16 DIST Active 101
> TOKYO_DS.TOKYO_RSSD
> 17 SQT Awaiting Wakeup 101:1 DIST
> TOKYO_DS.TOKYO_RSSD
> 15 SQM Awaiting Message 101:1
> TOKYO_DS.TOKYO_RSSD
> 14 SQM Awaiting Message 101:0
> TOKYO_DS.TOKYO_RSSD
> 30 REP AGENT Awaiting Command TOKYO_DS.TOKYO_RSS
> USER
> 4 DSI EXEC Awaiting Message 104(1)
> TOKYO_DS.pubs2
> 0 DSI Awaiting Command 104 TOKYO_DS.pubs2
> 8 REP AGENT Awaiting Command TOKYO_DS.pubs2
> USER
> 53 RSI Awaiting Wakeup SYDNEY_RS
> 52 SQM Awaiting Message 16777318:0 SYDNEY_RS
> RSI USER Inactive TOKYO_RS
> 11 dSUB Active
> 6 dCM Awaiting Message
> 9 dAIO Awaiting Message
> 12 dREC Active dREC
> 71 USER Active sa
> 5 dALARM Awaiting Wakeup
> 13 dSYSAM Sleeping
>
>
> > You must have connection from Rep server which is
> > running on host D, to ASE server to view all associated
> threads. >
> > You can check status of the all threds which are
> > responsible for replication from A,B,C ASE Databases.
> > There must be seprate set of thread for each and every
> > ASE database.
> >
> > If the ASE server which is hosting the databases is down
> > , you will get thread down for the same.
> >
> > DIST - Distributor
> >
> > DSI - Dataserver Interface
> >
> >
> > > hi,
> > >
> > > if a Sybase replication sever a running on "Host D"
> > > and replicating 3 ASE servers say A, B and C; then can
> > > i find the status of the 3 ASE servers by running
> > > "admin who" on the replication server? If i can find
> > > then which thread should i look for?
> > > Can you help me to understand whether there will
> > > separate threads running for replicating each of the
> > > ASE? if ASE is down then will that thread also be
> > > terminate? What is the thread name DIST or DSI
> > corresponding to? >
> > > Thanks
> > > Ravi.