Associating the DataPropagator Subscription Set with a DB2 Everyplace table subscription

Restrictions

• By default, DataPropagator will create the mirror tables in their own, non-system managed, tablespaces. If you want the DB2 Everyplace control tables associated with the mirror tables to be created in the same tablespaces, you will need to either override the tablespace creation to specify that the tablespace is system-managed, or increase the tablespace container size to accomodate these control tables (a general recommendation is to increase the container to 5 times the Data Propagator-generated size). If you do not specify a tablespace in the XML to generate the DB2 Everyplace Subscription, the default tablespace USERSPACE1 will be used for the DB2 Everyplace control tables.
• If "Replicate FALSE" is not specified as an attribute in the AddDProprSubscription tag, then the mirror database must be local to the machine on which the XML Scripting Tool is executing, and the source capture process must be running.

The following is an example of an XML Script that you can use to associate a DB2 Everyplace DataPropagator Table Subscription with the previously created Data Propagator Subscription Set using the DB2 Everyplace XML Scripting Tool.

Uwaga:

The tablespaces are being set explicitly to the same as those which were created for the target (mirror) table during the DataPropagator Subscription Set creation. Therefore, the tablespace creation must be modified.

In this example, the DB2 Everyplace Data Propagator Table Subscription is named DPSUB1 on the Visiting Nurse sample tables.

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE Root SYSTEM "mdas3.dtd">
 
<Root>
   <AddReplMaster>
      <System>SAD_LPT</System>
      <Instance>DB2</Instance>
      <Database>VNURSE</Database>
      <UserId>db2admin</UserId>
      <Password>db2admin</Password>
      <DatabaseAlias>VNURSE</DatabaseAlias>
   </AddReplMaster>
 
   <AddReplMirror>
      <Database>M_VNURSE</Database>
      <UserId>db2admin</UserId>
      <Password>db2admin</Password>
      <SyncWindow>0</SyncWindow>
   </AddReplMirror>
 
   <AddDproprSubscription Replicate="FALSE">      
      <Name>DPSUB1</Name>
      <SubAdapter>DSYDPROPR</SubAdapter>
      <EncryptionLevel>0</EncryptionLevel>
      <Block>N</Block>
      <MasterSystem>SAD_LPT</MasterSystem>
      <MasterInstance>DB2</MasterInstance>
      <MasterDb>VNURSE</MasterDb>
      <MirrorDb>M_VNURSE</MirrorDb>
      <ApplyQualifier>M_VNURSE</ApplyQualifier>
      <AddTable>
         <TargetSchema>DSYSAMPLE</TargetSchema>
         <TargetTable>VNCONTACT</TargetTable>
         <TableSpace>TSVNCONTACT</TableSpace>
         <SourceSchema>DSYSAMPLE</SourceSchema>
         <SourceTable>VNCONTACT</SourceTable>
         <DeleteAuth>Y</DeleteAuth>
         <InsertAuth>Y</InsertAuth>
         <UpdateAuth>Y</UpdateAuth>
         <SelectAuth>Y</SelectAuth>
         <WhereClauseMirrorToMobile></WhereClauseMirrorToMobile>
         <WhereClauseMasterToMirror></WhereClauseMasterToMirror>
         <JoinFilter>G</JoinFilter>
                  <Order>1</Order>
         <Encrypt>N</Encrypt>
         <AddColumn>
            <SourceColumn>PATIENTID</SourceColumn>
            <TargetColumn>PATIENTID</TargetColumn>
            <Subscribe>Y</Subscribe>
            <Replicate>Y</Replicate>
            <Key>Y</Key>
         </AddColumn>
         <AddColumn>
            <SourceColumn>CONTACTID</SourceColumn>
            <TargetColumn>CONTACTID</TargetColumn>
            <Subscribe>Y</Subscribe>
            <Replicate>Y</Replicate>
            <Key>Y</Key>
         </AddColumn>
         <AddColumn>
            <SourceColumn>RELATIONSHIP</SourceColumn>
            <TargetColumn>RELATIONSHIP</TargetColumn>
            <Subscribe>Y</Subscribe>
            <Replicate>Y</Replicate>
            <Key>N</Key>
         </AddColumn>
      </AddTable>
      <AddTable>
         <TargetSchema>DSYSAMPLE</TargetSchema>
         <TargetTable>VNMEDICALRECORD</TargetTable>
         <TableSpace>TSVNMEDICALRECORD</TableSpace>
         <SourceSchema>DSYSAMPLE</SourceSchema>
         <SourceTable>VNMEDICALRECORD</SourceTable>
         <DeleteAuth>Y</DeleteAuth>
         <InsertAuth>Y</InsertAuth>
         <UpdateAuth>Y</UpdateAuth>
         <SelectAuth>Y</SelectAuth>
         <WhereClauseMirrorToMobile></WhereClauseMirrorToMobile>
         <WhereClauseMasterToMirror></WhereClauseMasterToMirror>
         <JoinFilter>G</JoinFilter>
         <Order>2</Order>
         <Encrypt>N</Encrypt>
         <AddColumn>
            <SourceColumn>RECORDID</SourceColumn>
            <TargetColumn>RECORDID</TargetColumn>
            <Subscribe>Y</Subscribe>
            <Replicate>Y</Replicate>
            <Key>Y</Key>
         </AddColumn>
         <AddColumn>
            <SourceColumn>DATE_C</SourceColumn>
            <TargetColumn>DATE_C</TargetColumn>
            <Subscribe>Y</Subscribe>
            <Replicate>Y</Replicate>
            <Key>N</Key>
         </AddColumn>
         <AddColumn>
            <SourceColumn>TIME_C</SourceColumn>
            <TargetColumn>TIME_C</TargetColumn>
            <Subscribe>Y</Subscribe>
            <Replicate>Y</Replicate>
            <Key>N</Key>
         </AddColumn>
         <AddColumn>
            <SourceColumn>PATIENTID</SourceColumn>
            <TargetColumn>PATIENTID</TargetColumn>
            <Subscribe>Y</Subscribe>
            <Replicate>Y</Replicate>
            <Key>N</Key>
         </AddColumn>
         <AddColumn>
            <SourceColumn>BLOODPRESSURE</SourceColumn>
            <TargetColumn>BLOODPRESSURE</TargetColumn>
            <Subscribe>Y</Subscribe>
            <Replicate>Y</Replicate>
            <Key>N</Key>
         </AddColumn>
         <AddColumn>
            <SourceColumn>PULSERATE</SourceColumn>
            <TargetColumn>PULSERATE</TargetColumn>
            <Subscribe>Y</Subscribe>
            <Replicate>Y</Replicate>
            <Key>N</Key>
         </AddColumn>
         <AddColumn>
            <SourceColumn>TEMPERATURE</SourceColumn>
            <TargetColumn>TEMPERATURE</TargetColumn>
            <Subscribe>Y</Subscribe>
            <Replicate>Y</Replicate>
            <Key>N</Key>
         </AddColumn>
         <AddColumn>
            <SourceColumn>WEIGHT</SourceColumn>
            <TargetColumn>WEIGHT</TargetColumn>
            <Subscribe>Y</Subscribe>
            <Replicate>Y</Replicate>
            <Key>N</Key>
         </AddColumn>
         <AddColumn>
            <SourceColumn>COMMENT</SourceColumn>
            <TargetColumn>COMMENT</TargetColumn>
            <Subscribe>Y</Subscribe>
            <Replicate>Y</Replicate>
            <Key>N</Key>
         </AddColumn>
      </AddTable>
      <AddTable>
         <TargetSchema>DSYSAMPLE</TargetSchema>
         <TargetTable>VNPERSON</TargetTable>
         <TableSpace>TSVNPERSON</TableSpace>
         <SourceSchema>DSYSAMPLE</SourceSchema>
         <SourceTable>VNPERSON</SourceTable>
         <DeleteAuth>Y</DeleteAuth>
         <InsertAuth>Y</InsertAuth>
         <UpdateAuth>Y</UpdateAuth>
         <SelectAuth>Y</SelectAuth>
         <WhereClauseMirrorToMobile></WhereClauseMirrorToMobile>
         <WhereClauseMasterToMirror></WhereClauseMasterToMirror>
         <JoinFilter>G</JoinFilter>
         <Order>3</Order>
         <Encrypt>N</Encrypt>
         <AddColumn>
            <SourceColumn>ID</SourceColumn>
            <TargetColumn>ID</TargetColumn>
            <Subscribe>Y</Subscribe>
            <Replicate>Y</Replicate>
            <Key>Y</Key>
         </AddColumn>
         <AddColumn>
            <SourceColumn>NAME</SourceColumn>
            <TargetColumn>NAME</TargetColumn>
            <Subscribe>Y</Subscribe>
            <Replicate>Y</Replicate>
            <Key>N</Key>
         </AddColumn>
         <AddColumn>
            <SourceColumn>ADDRESS</SourceColumn>
            <TargetColumn>ADDRESS</TargetColumn>
            <Subscribe>Y</Subscribe>
            <Replicate>Y</Replicate>
            <Key>N</Key>
         </AddColumn>
         <AddColumn>
            <SourceColumn>CITY</SourceColumn>
            <TargetColumn>CITY</TargetColumn>
            <Subscribe>Y</Subscribe>
            <Replicate>Y</Replicate>
            <Key>N</Key>
         </AddColumn>
         <AddColumn>
            <SourceColumn>HOMEPHONE</SourceColumn>
            <TargetColumn>HOMEPHONE</TargetColumn>
            <Subscribe>Y</Subscribe>
            <Replicate>Y</Replicate>
            <Key>N</Key>
         </AddColumn>
         <AddColumn>
            <SourceColumn>WORKPHONE</SourceColumn>
            <TargetColumn>WORKPHONE</TargetColumn>
            <Subscribe>Y</Subscribe>
            <Replicate>Y</Replicate>
            <Key>N</Key>
         </AddColumn>
         <AddColumn>
            <SourceColumn>MOBILEPHONE</SourceColumn>
            <TargetColumn>MOBILEPHONE</TargetColumn>
            <Subscribe>Y</Subscribe>
            <Replicate>Y</Replicate>
            <Key>N</Key>
         </AddColumn>
      </AddTable>
      <AddTable>
         <TargetSchema>DSYSAMPLE</TargetSchema>
         <TargetTable>VNSCHEDULE</TargetTable>
         <TableSpace>TSVNSCHEDULE</TableSpace>
         <SourceSchema>DSYSAMPLE</SourceSchema>
         <SourceTable>VNSCHEDULE</SourceTable>
         <DeleteAuth>Y</DeleteAuth>
         <InsertAuth>Y</InsertAuth>
         <UpdateAuth>Y</UpdateAuth>
         <SelectAuth>Y</SelectAuth>
         <WhereClauseMirrorToMobile></WhereClauseMirrorToMobile>
         <WhereClauseMasterToMirror></WhereClauseMasterToMirror>
         <JoinFilter>G</JoinFilter>
         <Order>4</Order>
         <Encrypt>N</Encrypt>
         <AddColumn>
            <SourceColumn>PATIENTID</SourceColumn>
            <TargetColumn>PATIENTID</TargetColumn>
            <Subscribe>Y</Subscribe>
            <Replicate>Y</Replicate>
            <Key>N</Key>
         </AddColumn>
         <AddColumn>
            <SourceColumn>TIME_C</SourceColumn>
            <TargetColumn>TIME_C</TargetColumn>
            <Subscribe>Y</Subscribe>
            <Replicate>Y</Replicate>
            <Key>Y</Key>
         </AddColumn>
      </AddTable>
      <AddTable>
         <TargetSchema>DSYSAMPLE</TargetSchema>
         <TargetTable>VNSIGNATURE</TargetTable>
         <TableSpace>TSVNSIGNATURE</TableSpace>
         <SourceSchema>DSYSAMPLE</SourceSchema>
         <SourceTable>VNSIGNATURE</SourceTable>
         <DeleteAuth>Y</DeleteAuth>
         <InsertAuth>Y</InsertAuth>
         <UpdateAuth>Y</UpdateAuth>
         <SelectAuth>Y</SelectAuth>
         <WhereClauseMirrorToMobile></WhereClauseMirrorToMobile>
         <WhereClauseMasterToMirror></WhereClauseMasterToMirror>
         <JoinFilter>G</JoinFilter>
         <Order>5</Order>
         <Encrypt>N</Encrypt>
         <AddColumn>
            <SourceColumn>RECORDID</SourceColumn>
            <TargetColumn>RECORDID</TargetColumn>
            <Subscribe>Y</Subscribe>
            <Replicate>Y</Replicate>
            <Key>Y</Key>
         </AddColumn>
         <AddColumn>
            <SourceColumn>NURSENAME</SourceColumn>
            <TargetColumn>NURSENAME</TargetColumn>
            <Subscribe>Y</Subscribe>
            <Replicate>Y</Replicate>
            <Key>N</Key>
         </AddColumn>
         <AddColumn>
            <SourceColumn>SIGNATURE</SourceColumn>
            <TargetColumn>SIGNATURE</TargetColumn>
            <Subscribe>Y</Subscribe>
            <Replicate>Y</Replicate>
            <Key>N</Key>
         </AddColumn>
      </AddTable>
   </AddDproprSubscription>
</Root>

Zadania pokrewne

• Creating a DataPropagator table subscription
• Associating the DataPropagator Subscription Set with a DB2 Everyplace table subscription

Informacje pokrewne

• Data source restrictions for DataPropagator subscriptions