Example 1

This example re-creates a plug-in index (INDEX1) defined for a table (TABLE1) with columns of abstract data type (SGMLTEXT). The abstract data type (SGMLTEXT) is provided by the HiRDB Text Search Plug-in.

The example assumes that the following table and index have been defined:

• Table definition:

CREATE TABLE TABLE1(C1 INT,C2 SGMLTEXT
         ALLOCATE (SGMLTEXT IN LOBUSER01)
         PLUGIN'<DTD>sgml.dtd</DTD>' ) IN PDBUSER01

• Plug-in index definition:

CREATE INDEX INDEX1 USING TYPE NGRAM ON TABLE1(C2)
         IN LOBUSER02

Overview

Relationship between input/output files and RDAREAs

Explanation of the command

This example creates a plug-in index (INDEX1) defined for a table (TABLE1).

-k ixrc: Specification for index re-creation

-t TABLE1: Name of the table subject to index re-creation

c:\hirdb\pdrorg\control_file: Name of the control information file

Contents of the control information file (c:\hirdb\pdrorg\control_file)

index INDEX1 LOBUSER02 c:\hirdb\pdrorg\index_file 1

Explanation:

1. Specifies the index information file to which plug-in index information is to be output:
   INDEX1: Identifier of the plug-in index to be created
   LOBUSER02: Name of the RDAREA storing the plug-in index to be created
   c:\hirdb\pdrorg\index_file: Name of the index information file to which index information is output
   

Example 2

This example re-creates an index (INDEX1) in units of RDAREAs (PDBUSER03).

The example assumes that the following table and indexes have been defined:

• Table definition:

CREATE TABLE TABLE1(C1 INT NOT NULL,C2 CHAR(8),C3 INT)
               IN ((PDBUSER01) C1 > 10,(PDBUSER02))

• Index definition (partitioning key index):

CREATE INDEX INDEX1 ON TABLE1(C1)
               IN ((PDBUSER03),(PDBUSER05))

• Index definition (non-partitioning key index):

CREATE INDEX INDEX2 ON TABLE1(C2,C1)
               IN ((PDBUSER04),(PDBUSER06))

Overview

Relationship between input/output files and RDAREAs

Explanation of the command

This example re-creates indexes (INDEX1 and INDEX2).

-k ixrc: Specification for index re-creation

-t TABLE1: Name of the table subject to index re-creation

c:\hirdb\pdrorg\control_file: Name of the control information file

Contents of the control information file (c:\hirdb\pdrorg\control_file)

index INDEX1 PDBUSER03 c:\hirdb\pdrorg\index_inf1 1 sort bes1 c:\hirdb\pdrorg\sortwork,8192 2

Explanation:

1. Specifies the index information file:
   INDEX1: Index identifier
   PDBUSER03: Name of the index storage RDAREA
   c:\hirdb\pdrorg\index_inf1: Name of the index information file
   
2. Specifies the work directory for sorting:
   bes1: Name of the server used to create the sort work file
   c:\hirdb\pdrorg\sortwork: Name of the directory in which the sort work file is created
   8192: Size of buffer for sorting (in KB)
   

Example 3

This example re-creates indexes (INDEX1 and INDEX2) defined for a row-partitioned table (TABLE1).

The example assumes that the following table and indexes have been defined:

• Table definition:

CREATE TABLE TABLE1(C1 INT,C2 INT NOT NULL)
     IN ((PDBUSER01) C2<200,(PDBUSER02) C2<400,(PDBUSER03))

• Index definition:

CREATE INDEX INDEX1 ON TABLE1(C2) IN ((IDX01),(IDX02),(IDX03))
CREATE INDEX INDEX2 ON TABLE1(C1) IN ((IDX04),(IDX05))

Overview

(a) Re-creating all indexes defined for the table

Relationship between input/output files and RDAREAs

Explanation of the command

This example re-creates indexes (INDEX1 and INDEX2).

-k ixrc: Specification for index re-creation

-t TABLE1: Name of the table subject to index re-creation

c:\hirdb\pdrorg\control_file: Name of the control information file

Contents of the control information file (c:\hirdb\pdrorg\control_file)

idxname name=* 1 idxwork bes1 c:\hirdb\pdrorg\workdir01 2 idxwork bes2 c:\hirdb\pdrorg\workdir02 2 sort bes1 c:\hirdb\pdrorg\sortwork,8192 3 sort bes2 c:\hirdb\pdrorg\sortwork,8192 3

Explanation:

1. Specifies index re-creation in units of indexes:
   *: Specification for re-creating all indexes defined for the table (TABLE1)
   
2. Specifies the directory in which index information files are to be created:
   bes1, bes2: Names of the servers used to create index information
   c:\hirdb\pdrorg\workdir01, c:\hirdb\pdrorg\workdir02: Names of the directories in which index information files are created
   
3. Specifies the work directory for sorting:
   bes1, bes2: Names of the servers used to create the sort work file
   c:\hirdb\pdrorg\sortwork: Name of the directory in which the sort work file is created
   8192: Size of buffer for sorting (in KB)
   

(b) Re-creating one of the indexes defined for a table

Relationship between input/output files and RDAREAs

Explanation of the command

This example re-creates an index (INDEX1).

-k ixrc: Specification for index re-creation

-t TABLE1: Name of the table subject to index re-creation

c:\hirdb\pdrorg\control_file: Name of the control information file

Contents of the control information file (c:\hirdb\pdrorg\control_file)

idxname name=INDEX1 1 idxwork bes1 c:\hirdb\pdrorg\workdir01 2 idxwork bes2 c:\hirdb\pdrorg\workdir02 2 sort bes1 c:\hirdb\pdrorg\sortwork,8192 3 sort bes2 c:\hirdb\pdrorg\sortwork,8192 3

Explanation:

1. Specifies index re-creation in units of indexes:
   INDEX1: Name of the index to be re-created
   
2. Specifies the directory in which index information files are to be created:
   bes1, bes2: Names of the servers used to create index information
   c:\hirdb\pdrorg\workdir01, c:\hirdb\pdrorg\workdir02: Names of the directories in which index information files are created
   
3. Specifies the work directory for sorting:
   bes1, bes2: Names of the servers used to create the sort work file
   c:\hirdb\pdrorg\sortwork: Name of the directory in which the sort work file is created
   8192: Size of buffer for sorting (in KB)