Re: Configuration and usage of high performance loader in SAP
Posted in 2004
Torsten,
Not sure about SAP but I used onpladm before (Probably with IDS 9.21 &
IDS 9.30). Have a look at example/syntax below which I used:
--------------------------------------------------------------------------
onpladm create project <project_name>
onpladm create job <jobname> -n -p <project_name> -d <device_name> -D
<database_name> -t <tabel_name>
Example:
onpladm create project hari
onpladm create job table1 -n -p hari -d table1.hpl -D db1 -t
owner.table1
Also check the syntax below:
usage: onpladm create job <jobname> [-p <project>] -d <device> -D
<database>
-t <table> [-f[luadpcN]] [-z <formattype> | -n] [-T
<targetserver>]
[-S <onploadserver>] [-M <devicesize>] [-B <blocksize>]
where,
-p project name
-d device name, further qualified by flags
-D database name
-t table name
-f flags,
l means load job, default will be both load and
unload
u means unload job
a means device is a device array, default will
be file
d means device is a tape
p means device is a pipe command
c means runmode DELUXE with replication, default
will be
EXPRESS runmode
N means runmode DELUXE without replication,
default will
be EXPRESS runmode
-z type of format to be used, default is Delimited type
D means DELIMITED_FORMAT
FI means FAST_FORMAT
FA means FIXED_ASCII_FORMAT
FB means FIXED_BINARY_FORMAT
C means COBOL_FORMAT
CB means COBOL_BYTE_FORMAT
-n no-conversion fast-job
-T Target server, where load/unload is to be done
-S Onpload server containing the onpload database
-M device size, if device is a tape
-B block size, if device is a tape
--------------------------------------------------------------------------