Examples

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

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

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.

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

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

pdpgbfon command

 
 pdpgbfon -k index -t TBL1 c:\hirdb\pdpgbfon\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.; c:\hirdb\pdpgbfon\control_file: Specifies the control information file.

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

 
 idxname name=IDX01    [1]

Explanation

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

pdpgbfon command

 
 pdpgbfon -k index -t TBL1 c:\hirdb\pdpgbfon\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.; c:\hirdb\pdpgbfon\control_file: Specifies the control information file.

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

 
 idxname name=IDX01 rdarea=USER12    [1]

Explanation

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

12.2 Examples

(1) HiRDB/Single Server

(2) HiRDB/Parallel Server