Error using autoloader config file in V8

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • MrTulley

    Error using autoloader config file in V8

    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.
Working...