12.2 Examples

This section presents five examples of pdpgbfon.

Organization of this section
(1) HiRDB/Single Server
(2) HiRDB/Parallel Server

(1) HiRDB/Single Server

Example 1
This example reads data pages of a table (TBL1) into the global buffer. The example assumes that the table and indexes are defined as follows:
  • Table definition

 CREATE FIX TABLE TBL1(C1 INTEGER,C2 CHAR(10),C3 DEC(15))
     IN ((USER01) C1>0,(USER02))

  • Index definitions
CREATE INDEX IDX01 ON TBL1(C1) IN ((USER01),(USER02))
CREATE INDEX IDX02 ON TBL1(C3) IN USER03
Overview
[Figure]
[Figure]pdpgbfon command

pdpgbfon -k table -t TBL1

Explanation
-k table: Specifies that a table's data pages are to be read.
-t TBL1: Specifies the table to be read.
Example 2
This example reads index pages of a table (TBL1) into the global buffer. The example assumes that the table and indexes are defined as follows:
  • Table definition

 CREATE FIX TABLE TBL1(C1 INTEGER,C2 CHAR(10),C3 DEC(15))
     IN ((USER01) C1>0,(USER02))

  • Index definitions
CREATE INDEX IDX01 ON TBL1(C1) IN ((USER01),(USER02))
CREATE INDEX IDX02 ON TBL1(C3) IN USER03
Overview
[Figure]
[Figure]pdpgbfon command

pdpgbfon -k index -t TBL1

Explanation
-k index: Specifies that a table's index pages are to be read.
-t TBL1: Specifies the table whose index pages are to be read.

(2) HiRDB/Parallel Server

Example 3
This example reads data pages of a table (TBL1) into the global buffer. The example assumes that the table and indexes are defined as follows:
  • Table definition

 CREATE FIX TABLE TBL1(C1 INTEGER,C2 CHAR(10),C3 DEC(15))
     IN ((USER11) C1>0,(USER21))

  • Index definitions
CREATE INDEX IDX01 ON TBL1(C1) IN ((USER12),(USER22))
CREATE INDEX IDX02 ON TBL1(C3) IN ((USER13),(USER23))
Overview
[Figure]
[Figure]pdpgbfon command

pdpgbfon -k table -t TBL1

Explanation
-k table: Specifies that a table's data pages are to be read.
-t TBL1: Specifies the table to be read.
Example 4
This example reads index pages of a table (TBL1) into the global buffer in units of indexes. The example assumes that the table and indexes are defined as follows:
  • Table definition

 CREATE FIX TABLE TBL1(C1 INTEGER,C2 CHAR(10),C3 DEC(15))
     IN ((USER11) C1>0,(USER21))

  • Index definitions
CREATE INDEX IDX01 ON TBL1(C1) IN ((USER12),(USER22))
CREATE INDEX IDX02 ON TBL1(C3) IN ((USER13),(USER23))
Overview
[Figure]
[Figure]pdpgbfon command

pdpgbfon -k index -t TBL1 control_file

Explanation
-k index: Specifies that a table's index pages are to be read.
-t TBL1: Specifies the table whose index pages are to be read.
control_file: Specifies the control information file.
[Figure]Contents of the control information file (control_file)

idxname name=IDX01    [1]

Explanation
  1. Specifies the name of the index that is to be read into the global buffer.
Example 5
This example reads index pages of a table (TBL1) into the global buffer in units of RDAREAs. The example assumes that the table and indexes are defined as follows:
  • Table definition

 CREATE FIX TABLE TBL1(C1 INTEGER,C2 CHAR(10),C3 DEC(15))
     IN ((USER11) C1>0,(USER21))

  • Index definitions
CREATE INDEX IDX01 ON TBL1(C1) IN ((USER12),(USER22))
CREATE INDEX IDX02 ON TBL1(C3) IN ((USER13),(USER23))
Overview
[Figure]
[Figure]pdpgbfon command

pdpgbfon -k index -t TBL1 control_file

Explanation
-k index: Specifies that a table's index pages are to be read.
-t TBL1: Specifies the table whose index pages are to be read.
control_file: Specifies the control information file.
[Figure]Contents of the control information file (control_file)

idxname name=IDX01 rdarea=USER12    [1]

Explanation
  1. Specifies the names of the index and RDAREA that are to be read into the global buffer.