NetBase for MPE Reference Guide

Chapter 4

4-60

Below is an example of some SQL shadowing using multiple export processes for one DBE:

D> SQLOUT GGDBE.PART1.PRODACT=GGDBE.DATAB.PRODACT,shadownode;HOME=1;EXECPRI=CS

D> SQLOUT GGDBE.PART4.PRODACT=GGDBE.DATAB.PRODACT,shadownode;HOME=4;EXECPRI=DS

D> SQLOUT CCDBE.DATAB.PRODACT,shadownode;HOME=1;EXECPRI=DS;EXCLUDE

D> TABLE CCDBE.DATAB.PRODACT,shadownode,TUPLEONE

D> TABLE CCDBE.DATAB.PRODACT,shadownode,TUPLETWO

D> TABLE CCDBE.DATAB.PRODACT,shadownode,TUPLETHREE

D> listsqlo @.@.@

Node: MASTER Directory: NBD.DATA.NETBASE E

------LOCAL DBE NAME------ -----REMOTE EQUIVALENT----- I # of

File Group Account File Group Account Node T Part Freq

GGDBE PART1 PRODACT -> GGDBE DATAB PRODACT SHADOW - 1 0

Exec Pri: CS Partitions: 1

GGDBE PART4 PRODACT -> GGDBE DATAB PRODACT SHADOW - 1 0

Exec Pri: DS Partitions: 4

CCDBE DATAB PRODACT -> --Same-- SHADOW - 1 0

Exec Pri: DS Partitions: 1

Don't Shadow: TUPLEONE

TUPLETHREE

TUPLETWO

To set up multiple export processes for one DBE:

D> SQLOUT fakedbe1=dbename,node;PART=part1,[part2[,...]][...]

D> SQLOUT fakedbe2=dbename,node;PART=...