Scalable Database Server, HiRDB Version 8 Command Reference

[Contents][Index][Back][Next]

8.3.2 Cross-reference by purpose

Required options and control statements depend on the type of unload operation executed by the user.

The options listed in (1) and the control statements are mandatory. The items in (2) through (4) are related to the options and control statements presented in the Reference column. For details about the options, see Section 8.9.2.

Organization of this subsection
(1) Required items
(2) Information to be specified depending on the attribute of the table being unloaded
(3) Information to be specified depending on the type of unload data file or LOB data unload file
(4) Information to be specified depending on the unloading method

(1) Required items

Item Reference
Option Control statement
Type of pdrorg processing -k unld (1) [Figure] [Figure]
Reorganization of a user-defined table (can be omitted because the default is -c user) -c user (2) [Figure] [Figure]
Name of the table to be unloaded -t (3) [Figure] [Figure]
File containing the control statements control-information-filename (18) [Figure] [Figure]
Information about an unload data file [Figure] [Figure] unload statement 8.9.3

[Figure]: Not applicable

(2) Information to be specified depending on the attribute of the table being unloaded

Item Reference location
Option Control statement
There are LOB columns -j (9) lobunld statement 8.9.8
There are columns of abstract data type provided by a plug-in (LOB attribute) -j (9) unld_func statement 8.9.12
There are repetition columns -W (7) array statement 8.9.11
Consecutive trailing spaces are to be removed from a table with suppress option specified* -S (14) [Figure] [Figure]

[Figure]: Not applicable

* This option helps you reduce the processing time and the size of the unload data file.

(3) Information to be specified depending on the type of unload data file or LOB data unload file

Item Reference location
Option Control statement
Using unload data as pdload's input data file or with a UAP -W (7) fixtext_option statement 8.9.18
Integrating data into a single file -g (8) [Figure] [Figure]
Using HiRDB files -f (12) [Figure] [Figure]
Specifying the unload data storage sequence (in order of cluster key, index, or data storage) -b (13) [Figure] [Figure]

[Figure]: Not applicable

(4) Information to be specified depending on the unloading method

Item Reference location
Option Control statement
Unloading only some of the RDAREAs for a row-partitioned table -r (4) [Figure] [Figure]
Changing the pdrorg executor's user authorization identifier to a value other than the value of environment variable PDUSER1 -u (10) [Figure] [Figure]
Unloading in batch input/output mode using local buffer instead of global buffer2 -n (11) [Figure] [Figure]
Changing an unloading status message output interval to a value other than 100,000 lines -m (16) [Figure] [Figure]
Monitoring the response time for server-to-server communication -X (17) [Figure] [Figure]
Monitoring the execution time of pdrorg [Figure] [Figure] option statement 8.9.15
Using the same space character in the entire table data [Figure] [Figure] option statement 8.9.15
Obtaining tuning information during the execution of pdrorg [Figure] [Figure] report statement 8.9.16
Unloading a column of abstract data type with BLOB attribute as VARCHAR type [Figure] [Figure] blobtovarchar statement 8.9.17
Executing one of the following:
  • Deleting unneeded data and then outputting the unload data file
  • Updating data to use as pdload's input data file
  • Outputting data in a desired format for applications
[Figure] [Figure] unlduoc statement 8.9.9

[Figure]: Not applicable

1 If omitted, the system assumes the value of the PDUSER environment variable. If the PDUSER environment variable has not been specified, the system assumes the user name in the login window.

2 By specifying the number of batch input/output pages, you can reduce the number of I/O operations, because data is input/output in units of specified pages in batch mode.