db_table_restruct

The db_table_restruct command reduces table size and optimizes synopsis tables after migrating to an IAS machine.

You can use the db_table_restruct command to reduce the size of tables and create better synopsis tables.

With the command, you can reduce table size. db_table_restruct randomly samples the source table to improve the dictionary built for the compression of data. Table size reduction depends on the type of data that is stored in the table. The size won't be changed considerably if you used the db_build_dictionary utility before you migrated the table.

Also, db_table_restruct loads data into the target table in order. The data from the source table is stored with the help of select columns. The columns are specified with the -orderby parameter.

The db_table_restruct command creates an optimized copy of the source table. Both source table and target table reside on a single IAS machine.

Note: The difference between the db_table_restruct and db_build_dictionary commands is that db_table_restruct performs insertion locally, which results in faster data transfer, and loads data in order, which optimizes synopsis tables.

Usage

db_table_restruct [-h | --help] -u | -user name -pw | -pass pass -stable name 
-orderby clause [-ttable name] [-overwrite] [-d | -db name] [-sample float%] 
[clusteron column] [-schema name] [-summary] [-verbose] [-v | --version | -rev]

Basic parameters

-h | --help: Displays help for the command.
-v | --version | -rev: Displays program's version number.
-verbose: Displays additional information.

Required parameters

-u|-user name: Specifies the user.
-pw | -pass password: Specifies the password.
-stable name: Specifies case-sensitive source table name.
-orderby clause: Specifies the ORDER BY clause. Using numbers instead of column names is undefined.

Optional parameters

-ttable name: Specifies case-sensitive target table name. ttable and -overwrite are mutually exclusive.
-overwrite: Specifies whether to overwrite existing table. -overwrite and -ttable are mutually exclusive.
-d|-db name: Specifies database name. The default is BLUDB.
-sample float%: Specifies the Bernoulli sampling percentage from 0 to 100. The default is adaptive to row count.
-clusteron column: Specifies the column to cluster on. Use with large volumes of data to improve the sorting performance.
-schema name: Specifies case-sensitive schema name. The default is source user in uppercase.
-sschema: Specifies source schema name. Mutually exclusive to -schema. The default is source user in uppercase.
-tschema: Specifies target schema name. Mutually exclusive to -schema. The default is source user in uppercase.
-summary: Displays synopsis data summary.

-ts, -tablespace <tablespace>: Specifies table space for new target tables.

-ts: Displays synopsis data summary.