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.

Packing tables and replication

3 posts in Replication Last posting was on 2009-09-16 08:12:03.0Z
mike grace Posted on 2009-09-15 15:17:26.0Z
Date: Tue, 15 Sep 2009 15:17:26 +0000 (UTC)
Message-ID: <b9f6cef88f508cc043726153580@devzone.advantagedatabase.com>
From: mike grace <mikeg@computastat-group.co.uk>
Subject: Packing tables and replication
Newsgroups: Advantage.Replication
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 1098.1
X-Antivirus: avast! (VPS 090914-0, 14/09/2009), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 217.24.129.66
X-Trace: 15 Sep 2009 09:16:06 -0700, 217.24.129.66
Lines: 10
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!217.24.129.66
Xref: solutions.advantagedatabase.com Advantage.Replication:373
Article PK: 1134226

Hi,

If I pack a table that has replication set up on it, will it start replicating?


Regards

Mike


Peter Funk (ADS) Posted on 2009-09-15 16:58:23.0Z
Date: Tue, 15 Sep 2009 16:58:23 +0000 (UTC)
Message-ID: <864d0bcb197a98cc040a9455d2e1@devzone.advantagedatabase.com>
From: Peter Funk (ADS) <pfunk@nospam.com>
Subject: Re: Packing tables and replication
Newsgroups: Advantage.Replication
References: <b9f6cef88f508cc043726153580@devzone.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Pro 1098.1
NNTP-Posting-Host: 10.24.38.185
X-Trace: 15 Sep 2009 10:57:02 -0700, 10.24.38.185
Lines: 12
X-Authenticated-User: upreview
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.185
Xref: solutions.advantagedatabase.com Advantage.Replication:374
Article PK: 1134228

Hello Mike,
I assume you're asking if a pack operation gets replicated to the target
table. The answer is no. The pack operation happens at a lower level than
where replication takes place so the effects of the pack are not seen in
the target table. If you want to remove the deleted records from the target
table you need to pack it directly on the target server.

Regards,
Peter Funk
Advantage R&D


mike grace Posted on 2009-09-16 08:12:03.0Z
Date: Wed, 16 Sep 2009 08:12:03 +0000 (UTC)
Message-ID: <b9f6cef88f7a8cc04c4e3e95c12@devzone.advantagedatabase.com>
From: mike grace <mikeg@computastat-group.co.uk>
Subject: Re: Packing tables and replication
Newsgroups: Advantage.Replication
References: <864d0bcb197a98cc040a9455d2e1@devzone.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 1098.1
X-Antivirus: avast! (VPS 090915-0, 15/09/2009), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 217.24.129.66
X-Trace: 16 Sep 2009 02:10:42 -0700, 217.24.129.66
Lines: 23
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!217.24.129.66
Xref: solutions.advantagedatabase.com Advantage.Replication:377
Article PK: 1134230

Hello Peter,

Thanks for the information.

Regards

Mike

> Hello Mike,
> I assume you're asking if a pack operation gets replicated to the
> target
> table. The answer is no. The pack operation happens at a lower level
> than
> where replication takes place so the effects of the pack are not seen
> in
> the target table. If you want to remove the deleted records from the
> target
> table you need to pack it directly on the target server.
> Regards,
> Peter Funk
> Advantage R&D