How to find CDC enabled tables

Hi iiug, Just want to ask how to find the cdc enabled tables? can't use the oncheck -pT, it uses locks which affects the application. Is there any table how to check which table is in Full Row logging and Snooped? IDC 11.7/12.10 Thanks, R

Ronald You have not mentioned platform, but if it is a *nix variant then call 'dmgetsubscriptionstatus -I "CDC_Server" -A' (found in the CDC bin directory) to list the subscriptions and their status. The actual tables involved in a subscription are best seen from the CDC Management Console (usually on a WinDoze Server). To/From what are you replicating as I have not found many people using CDC with Informix ? Keith On 12 October 2016 at 07:00, RONALD OLAVIDEZ <ronald.olavidez@gmail.com> wrote: > Hi iiug, > > Just want to ask how to find the cdc enabled tables? can't use the oncheck > -pT, it uses locks which affects the application. > > Is there any table how to check which table is in Full Row logging and > Snooped? > > IDC 11.7/12.10 > > Thanks, > R > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a114701e46ce513053ea7628b

How about onstat -g cdc [<sessid>] table [<full-table-name>] [long] Print Change Data Capture captured table information. Use dbname:owner.tabname format for <full-table-name> parameter. Omit <full-table-name> parameter to display information=20 about all captured tables. Or syscdcv1:syscdctabs ? S.a. $INFORMIXDIR/etc/syscdcv1.sql BR, Andreas From: "Keith Simmons" <smiley73@gmail.com> To: ids@iiug.org Date: 12.10.2016 11:12 Subject: Re: How to find CDC enabled tables [37968] Sent by: ids-bounces@iiug.org Ronald=20 You have not mentioned platform, but if it is a *nix variant then call=20 'dmgetsubscriptionstatus -I "CDC=5FServer" -A' (found in the CDC bin=20 directory) to list the subscriptions and their status.=20 The actual tables involved in a subscription are best seen from the CDC=20 Management Console (usually on a WinDoze Server).=20 To/From what are you replicating as I have not found many people using CDC = with Informix ?=20 Keith=20 On 12 October 2016 at 07:00, RONALD OLAVIDEZ <ronald.olavidez@gmail.com>=20 wrote:=20 > Hi iiug,=20 >=20 > Just want to ask how to find the cdc enabled tables? can't use the=20 oncheck=20 > -pT, it uses locks which affects the application.=20 >=20 > Is there any table how to check which table is in Full Row logging and=20 > Snooped?=20 >=20 > IDC 11.7/12.10=20 >=20 > Thanks,=20 > R=20 >=20 >=20 > ************************************************************=20 > *******************=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20 >=20 >=20 --001a114701e46ce513053ea7628b=20 ***************************************************************************= ****=20 Forum Note: Use "Reply" to post a response in the discussion forum.=20

Hi All, I'm using "onstat -g cdc" table already but if the cdc adapter is not running, you will not be able to see those tables which are in "Snopping mode". We have thousand of tables and i'm looking for a column/flag that identifies the table is being snooped. IDS 11.7/12.0 on AIX P7. Thanks, Ronaldo

Before further diving into this, what about syscdcv1:syscdctabs ? Would this also only be populated while really being snooped? Would it be=20 populated at all? In case the FULLROWLOGGING attribute would be sufficient for you, you=20 could query sysptnhdr SMI table for flags 0x04000000 (67108864). Andreas From: "RONALD OLAVIDEZ" <ronald.olavidez@gmail.com> To: ids@iiug.org Date: 13.10.2016 00:42 Subject: Re: How to find CDC enabled tables [37983] Sent by: ids-bounces@iiug.org Hi All,=20 I'm using "onstat -g cdc" table already but if the cdc adapter is not=20 running,=20 you will not be able to see those tables which are in "Snopping mode". We=20 have=20 thousand of tables and i'm looking for a column/flag that identifies the=20 table=20 is being snooped.=20 IDS 11.7/12.0 on AIX P7.=20 Thanks,=20 Ronaldo=20 ***************************************************************************= ****=20 Forum Note: Use "Reply" to post a response in the discussion forum.=20

that's what im looking for. a SMI table that will give me what table is in FULLROWLOGGING mode. i'll check it out. Thanks Andreas.