UDB V8 FP4
AIX 5.1
I am receiving the following error message while using the autoloader
to load a pipe delimited file into a partitioned table:
SQL3004N The filetype parameter is not valid.
Config file:
RELEASE=V7.2
db2 "load from /tmp/dly_account.dat .pipe.67794 of del modified by
coldel| remote file /u001/local/heids/load/tmp/HEIDS.DLY_ACCOU NT
replace into HEIDS.DLY_ACCOU NT nonrecoverable
using /u001/local/heids/load/tmp"
DATABASE=uatdb
LOGFILE=/u001/ldshr/heids/HEIDS.DLY_ACCOU NT
MODE=split_and_ load
NOTNFS_DIR=/tmp
CHECK_LEVEL=CHE CK
TRACE=1
This is an old autoloader config file our application DBAs use on our
V7.2 systems. This load works fine in our V7 databases but won't work
in our V8 databases.
However, this load will work in V8 if I use the following load
command:
db2 "LOAD FROM /u001/data/rwh/dly_account.dat of DEL modified by
coldel| REPLACE INTO heids.dly_accou nt PARTITIONED DB CONFIG
PARTITIONING_DB PARTNUMS (1)"
------------------------------------------------------------------------------
Has anyone else experienced similiar behavior? Is there an issue in V8
with loading pipe delimited files via the autoloader?
I'm fine with using the new funcationality in the V8 load command but
my App DBAs don't like change. :)
Thanks in advance.
AIX 5.1
I am receiving the following error message while using the autoloader
to load a pipe delimited file into a partitioned table:
SQL3004N The filetype parameter is not valid.
Config file:
RELEASE=V7.2
db2 "load from /tmp/dly_account.dat .pipe.67794 of del modified by
coldel| remote file /u001/local/heids/load/tmp/HEIDS.DLY_ACCOU NT
replace into HEIDS.DLY_ACCOU NT nonrecoverable
using /u001/local/heids/load/tmp"
DATABASE=uatdb
LOGFILE=/u001/ldshr/heids/HEIDS.DLY_ACCOU NT
MODE=split_and_ load
NOTNFS_DIR=/tmp
CHECK_LEVEL=CHE CK
TRACE=1
This is an old autoloader config file our application DBAs use on our
V7.2 systems. This load works fine in our V7 databases but won't work
in our V8 databases.
However, this load will work in V8 if I use the following load
command:
db2 "LOAD FROM /u001/data/rwh/dly_account.dat of DEL modified by
coldel| REPLACE INTO heids.dly_accou nt PARTITIONED DB CONFIG
PARTITIONING_DB PARTNUMS (1)"
------------------------------------------------------------------------------
Has anyone else experienced similiar behavior? Is there an issue in V8
with loading pipe delimited files via the autoloader?
I'm fine with using the new funcationality in the V8 load command but
my App DBAs don't like change. :)
Thanks in advance.