This section presents five examples of pdpgbfon.
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:
CREATE FIX TABLE TBL1(C1 INTEGER,C2 CHAR(10),C3 DEC(15))
CREATE INDEX IDX02 ON TBL1(C3) IN USER03 |
pdpgbfon -k table -t TBL1 |
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:
CREATE FIX TABLE TBL1(C1 INTEGER,C2 CHAR(10),C3 DEC(15))
CREATE INDEX IDX02 ON TBL1(C3) IN USER03 |
pdpgbfon -k index -t TBL1 |
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:
CREATE FIX TABLE TBL1(C1 INTEGER,C2 CHAR(10),C3 DEC(15))
CREATE INDEX IDX02 ON TBL1(C3) IN ((USER13),(USER23)) |
pdpgbfon -k table -t TBL1 |
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:
CREATE FIX TABLE TBL1(C1 INTEGER,C2 CHAR(10),C3 DEC(15))
CREATE INDEX IDX02 ON TBL1(C3) IN ((USER13),(USER23)) |
pdpgbfon -k index -t TBL1 control_file |
idxname name=IDX01 [1] |
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:
CREATE FIX TABLE TBL1(C1 INTEGER,C2 CHAR(10),C3 DEC(15))
CREATE INDEX IDX02 ON TBL1(C3) IN ((USER13),(USER23)) |
pdpgbfon -k index -t TBL1 control_file |
idxname name=IDX01 rdarea=USER12 [1] |