Neoview Database Administrator's Guide (R2.2)

Table 8-7 Optional CONFIG_TASK_EXTRACT Arguments (continued)
DescriptionDefault
Value
Long
Name
Short
Name
Specifies the partitioning table to be used for a
parallel mode extract.
The partitioning table must be one of the tables
specified in the query you provided for the input
Item. For details, see “Partitioning Table
Restrictions” (page 124).
N.A.
partitioningTable-pt
Record delimiter. Valid values are:
LF
CRLF
LF
recordDelimiter-rd
Specifies whether trailing blanks are to be
removed from character fields with delimited
output. Valid values are:
Y (trim trailing blanks)
N (do not trim trailing blanks)
N
rightTrim-tm
Name of the Linux cmserver data source server;
maximum 32 characters. For example:
LINUX-CMSERVER
This will be picked up from the values provided
when the loader software was installed on the
Linux system.
LINUX_CMSERVER
targetServerName-tn
The size of the rowset to be used when fetching
data from SQL/MX. Allowable values are 1 -
50,000.
2500
transactionSize-ts
Task type. The only valid value is BATCH.
BATCH
taskType-tt
Extract Task Logs
As with load tasks, messages for commands are stored in the file gcmd.log, in the default
location /opt/tandem/genus/gel/log/gcmd.log.
The log directory has a load directory and an extract directory. For a standard Loader system
installation, the task instance logs for extract tasks are stored in the directory location
/opt/tandem/genus/gel/log/extract.
The name of the task instance log files on the Linux and Neoview systems is
task-name.task-instance-name.log.
If a task instance log file on either the Linux or the Neoview system remains from a previous
execution of that extract task with the same task instance name, it will be renamed by appending
the modification timestamp to the task instance log file name. For example, if the task instance
log file name was DAILY-EXTRACT.OCT01.log, it will be renamed to
DAILY-EXTRACT.OCT01.1og.2007613192033 where 2007613192033 is a modification
timestamp.
Example 8-4 is a sample extract log:
130 Using the Neoview Loader