(a) Environment on the data source system (HOST1)

Table definition

• Definition of the table with authorization identifier user01
  

  CREATE TABLE T01(C01 CHAR(10),C02 CHAR(40),C03 INT)
  CREATE TABLE T02(C01 CHAR(10),C02 CHAR(40),C03 INT,C04 INT)
  CREATE FIX TABLE T03(C01 CHAR(10), C02 CHAR(40),C03 INT)
  CREATE TABLE T04
   (C01 INT,
    C02 MVARCHAR(32),
    C03 SGMLTEXT ALLOCATE (SGMLTEXT IN RDLOB01)
     PLUGIN '<TEXTTYPE>SGML</TEXTTYPE><DTD>DOCUMENT DEFINITIONS</DTD>',
    C04 DATE)
  CREATE INDEX TEXT_IDX USING TYPE NGRAM
    ON T04(C03) IN RDLOB02

Specification of environment variables

$PDDIR       /HiRDB1
$PDCONFPATH  /HiRDB1/conf
$PDUSER      "user01"/"user01"
$PDNAMEPORT  20000
$SHLIB_PATH  /HiRDB1/lib: /HiRDB1/client/lib
$PATH        /opt/HIRDBXT/bin
$LANG        ja_JP.SJIS
$XTHOST      HOST2
$XTPORTNO    20052

Specification in /etc/hosts at the importing host

        :
        :
160.16.150.120  HOST2
160.16.150.121  HOST3
        :
        :

(b) Environment on the data target system (HOST2)

• Definition of the table with authorization identifier user01
  

  CREATE TABLE T01(C01 CHAR(10),C02 CHAR(40),C03 INT)
  CREATE TABLE T02(C01 CHAR(10),C02 CHAR(40),C03 INT,C04 INT)
  CREATE TABLE T04
   (C01 INT,
    C02 MVARCHAR(32),
    C03 SGMLTEXT ALLOCATE (SGMLTEXT IN RDLOB01)
     PLUGIN '<TEXTTYPE>SGML</TEXTTYPE><DTD>DOCUMENT DEFINITIONS</DTD>',
    C04 DATE)
  CREATE INDEX TEXT_IDX USING TYPE NGRAM
    ON T04(C03) IN RDLOB02

• Definition of the table with authorization identifier user02
  

  CREATE FIX TABLE T03(C01 CHAR(10),C02 CHAR(40),C03 INT)

Definition of port in /etc/services

                      :
                      :
hirdbxt1 20052/tcp    # HiRDB Dataextractor
hirdbxt2 50000/tcp    # HiRDB Dataextractor
                      :
                      :

Definition for HiRDB Dataextractor startup in /etc/inetd.conf

                      :
                      :
hirdbxt1 stream tcp nowait user01
/opt/HIRDBXT/bin/pxtcntl pxtcntl /usr/home/user01/xtenv1
hirdbxt2 stream tcp nowait user02
/opt/HIRDBXT/bin/pxtcntl pxtcntl /usr/home/user02/xtenv2
                      :
                      :

Specification of environment variables in the environment variable information specification file

• Environment variable information specification file for service name hirdbxt1 and port number 20052 (/usr/home/user01/xtenv1)
  

  set PDDIR=/HiRDB2
  set PDCONFPATH=/HiRDB2/conf
  set PDUSER="user01"/"user01"
  set LANG=ja_JP.SJIS

• Environment variable information specification file for service name hirdbxt2 and port number 50000 (/usr/home/user02/xtenv2)
  

  set PDDIR=/HiRDB2
  set PDCONFPATH=/HiRDB2/conf
  set PDUSER="user02"/"user02"
  set LANG=ja_JP.SJIS

(c) Environment on the file creation system (HOST3)

Definition of port in /etc/services

                     :
                     :
hirdbxt 20052/tcp    # HiRDB Dataextractor
                     :
                     :

Definition for HiRDB Dataextractor startup in /etc/inetd.conf

                     :
                     :
hirdbxt stream tcp nowait user01
/opt/HIRDBXT/bin/pxtcntl pxtcntl /usr/home/user01/xtenv
                     :
                     :

Specification of environment variables in the environment variable information specification file

• Environment variable information specification file for service name hirdbxt and port number 20052 (/usr/home/user01/xtenv)
  

  set XTTMPDIR=/usr/home/user01/data
  set LANG=ja_JP.SJIS

Specify the xtrep command on the data source system.

(a) Example 1

Copy table user01.T01 into table T01 at HOST2. Specify the following options:

• Port number used by HiRDB Dataextractor on the target system is 20052.
• Add the data without deleting any existing data.
• Acquire a pre-update log.
• Number of batch output pages is 10.
• Output progress message every 10,000 lines.
• Lock the table subject to extraction.
• Do not change the default null value.

Command specification

xtrep T01

(b) Example 2

Copy table user01.T01 into table T02 at HOST2. Specify the following options:

• Port number used by HiRDB Dataextractor on the target system is 20052.
• Delete all existing data and then add the new data.
• Do not acquire a log.
• Number of batch output pages is 255.
• Output progress message every 100,000 lines.
• Do not lock the table subject to extraction.
• Extract rows with the value '0000010000' in column C01 and set the literal 0 in column C04.
• Set the default null value for column C01 to 'FFFFFFFFFF'.

Command specification

xtrep -r T02 -d -l n -n 255 -m 100 -g -s /usr/home/user01/clm
-v /usr/home/user01/null -w /usr/home/user01/whr T01

Contents of /usr/home/user01/clm

C01,C02,C03,0

Contents of /usr/home/user01/whr

WHERE C01<='0000010000'

Contents of /usr/home/user01/null

C01=('FFFFFFFFFF')

(c) Example 3

Copy table user01.T03 into table T03 at HOST2. Specify the following options:

• Port number used by HiRDB Dataextractor is 50000.
• Delete all existing data.
• Acquire a pre-update log.
• Number of batch output pages is 40.
• Obtain the execution results in /tmp/xtrep_log.
• Output progress message every 10,000 lines.
• Lock the table subject to extraction.
• Use a line-by-line interface for data extraction.
• Do not change the default null value.

Command specification

xtrep -d -n 40 -p 50000 -e /tmp/xtrep_log
      -s /usr/home/user01/clm T03

Contents of /usr/home/user01/clm

ROW

(d) Example 4

Copy table user01.T03 to a file at HOST3. Specify the following options:

• Create a DAT-format file.
• The name of the output file is /usr/home/user01/data/T03.

Command specification

xtrep -R dat -o T03 -h HOST3 T03

(e) Example 5

Copy table user01.T01 to a file at HOST3. Specify the following options:

• Create a DAT-format file.
• The name of the output file is /usr/home/user01/data/T01.
• Output progress message every 50,000 lines.
• Extract rows with the value '0000010000' in column C01 and set the literal 0 in the fourth column.

Command specification

xtrep -R dat -o T01 -h HOST3 -m 50 -s /usr/home/user01/clm
-w /usr/home/user01/whr T01

Contents of /usr/home/user01/clm

C01,C02,C03,0

Contents of /usr/home/user01/whr

WHERE C01<='0000010000'

(f) Example 6

Copy table user01.T04 containing SGMLTEXT-type columns into table T04 at HOST2. Create a shell to execute the xtrep command.

• Obtain the maximum length of the original text (real data) of the SGMLTEXT type. Specify the obtained value in the XTLOBBUFSIZE environment variable.
• Write up to 10 MB into file xt_file1 under /opt/HIRDBXT/spool at HOST2. If file xt_file1 becomes full, write the remaining data into file xt_file2.
• Delete all existing data and write the new data.

Example of shell creation

  #!/bin/csh -f
  #-------------------------------------------------------------
  #Obtain max size of SGMLTEXT column
 
1. echo 'max(length(extracts(C03)))' > xt_clm
2. xtrep -R dat -o size -s xt_clm -h `hostname` T04
  rm -f xt_clm
 
  #-------------------------------------------------------------
  #Create xtrep parameters and command 
 
3. echo 'C01,C02,extracts(C03),C04' > xt_clm
 
  echo '#! /bin/csh -f'                              > xt_exec
4. echo 'setenv XTERRLEVEL 1'                        >> xt_exec
  echo 'setenv XTHOST HOST2'                         >> xt_exec
  echo 'setenv XTFILESIZE 10000000'                  >> xt_exec
5. echo 'setenv XTLOBBUFSIZE \c'                     >> xt_exec
  cat  /opt/HIRDBXT/spool/size | cut -c2-11          >> xt_exec
  echo 'xtrep -d -o xt_file1,xt_file2 -s xt_clm T04' >> xt_exec
  chmod 777 xt_exec
 
  #-------------------------------------------------------------
  #Execute xtrep
 
6. xt_exec
 
  rm -f /opt/HIRDBXT/spool/size
  rm -f xt_clm
  rm -f xt_exec

Explanation

1. Creates column name specification file xt_clm to obtain the maximum length of the real data in the SGMLTEXT-type column (C03) in table user01.T04 that is subject to extraction.
2. Executes the xtrep command with the xt_clm column name specification file created in 1 above specified, and outputs the maximum length of the real data in the SGMLTEXT-type column (C03) in table user01.T04 to /opt/HIRDBXT/spool/size at HOST1.
3. Creates column name specification file xt_clm to extract data from table user01.T04.
4. Outputs the environment variables and command line used by the xtrep command to xt_exec.
5. Sets the maximum length of the real data output to /opt/HIRDBXT/spool/size in the XTLOBBUFSIZE environment variable.
6. Executes the xtrep command with the xt_clm column name specification file created in 3 above specified, and imports table user01.T04 into table T04.