This section presents examples of using the database reorganization utility (creating indexes in batch mode), listed as follows:
Example | Description | Classification |
---|---|---|
1 | Creating an index in batch mode
| S |
2 | Creating a plug-in index in delayed batch mode
| |
3 | Creating indexes in batch mode
| P |
S: HiRDB single server configuration
P: HiRDB parallel server configuration
CREATE TABLE TABLE1(C1 INT NOT NULL,C2 CHAR(8),C3 INT)
IN ((PDBUSER01) C1 > 10,(PDBUSER02))
CREATE INDEX INDEX1 ON TABLE1(C1)
IN ((PDBUSER03),(PDBUSER04))
CREATE INDEX INDEX2 ON TABLE1(C2,C1) IN (PDBUSER05)
index INDEX2 PDBUSER05 /usr/index_inf2 1 |
CREATE TABLE TABLE1(C1 INT,C2 SGMLTEXT
ALLOCATE (SGMLTEXT IN LOBUSER01)
PLUGIN'<DTD>sgml.dtd</DTD>' ) IN PDBUSER01
CREATE INDEX INDEX1 USING TYPE NGRAM ON TABLE1(C2)
IN LOBUSER02
set pd_plugin_ixmk_dir="/hd001/ixdir"
PDPLGIXMK YES
index INDEX1 LOBUSER02 /hd001/ixdir/INDEX1.LOBUSER02 1 |
CREATE TABLE TABLE1(C1 INT NOT NULL,C2 CHAR(8),C3 INT)
IN ((PDBUSER01) C1 > 10,(PDBUSER02))
CREATE INDEX INDEX1 ON TABLE1(C1)
IN ((PDBUSER03),(PDBUSER05))
CREATE INDEX INDEX2 ON TABLE1(C2,C1)
IN ((PDBUSER04),(PDBUSER06))
index INDEX1 PDBUSER03 /usr/index_inf1 1 |