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.

need transaction owner

2 posts in General Discussion Last posting was on 2012-08-21 14:54:55.0Z
rick_806 Posted on 2012-08-20 20:04:25.0Z
Sender: 119f.50329781.1804289383@sybase.com
From: rick_806
Newsgroups: sybase.public.rep-server
Subject: need transaction owner
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50329849.11d1.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 20 Aug 2012 13:04:25 -0700
X-Trace: forums-1-dub 1345493065 172.20.134.41 (20 Aug 2012 13:04:25 -0700)
X-Original-Trace: 20 Aug 2012 13:04:25 -0700, 172.20.134.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9237
Article PK: 870396

Rep Svr 15 I need to find out who submitted a huge update
that filled my stable queue? By the time I looked at the
PDS, the transaction was completed so I could not see who
submitted it. The RDS was busy running many thousands of
updates to a single table but maint_user owns those. Is
there a way to see who created a transaction in Rep SVR? I
do not have RSM.

thx,
rick_806


Manish Negandhi [TeamSybase] Posted on 2012-08-21 14:54:55.0Z
From: "Manish Negandhi [TeamSybase]" <negandhi.manish_nosmap@gmail.com>
Newsgroups: sybase.public.rep-server
References: <50329849.11d1.1681692777@sybase.com>
Subject: Re: need transaction owner
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <5033a13f@forums-1-dub>
Date: 21 Aug 2012 07:54:55 -0700
X-Trace: forums-1-dub 1345560895 172.20.134.152 (21 Aug 2012 07:54:55 -0700)
X-Original-Trace: 21 Aug 2012 07:54:55 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9241
Article PK: 870402


<rick_806> wrote in message news:50329849.11d1.1681692777@sybase.com...
> Rep Svr 15 I need to find out who submitted a huge update
> that filled my stable queue? By the time I looked at the
> PDS, the transaction was completed so I could not see who
> submitted it. The RDS was busy running many thousands of
> updates to a single table but maint_user owns those. Is
> there a way to see who created a transaction in Rep SVR? I
> do not have RSM.
>
> thx,
> rick_806

can think of couple of things...

(1) If update is still being applied at replicate, suspend dsi and use
sysadmin log_first_tran , go to rssd and use rs_helpexception
(2) sysadmin dump_queue

-HTH
Manish Negandhi
[TeamSybase]