Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2009
    Location
    Pennsylvania
    Posts
    22

    Unanswered: load utility to z/os fails with SQL1325N

    I'm on a Linux box and I need to load/import/export files to/from a Z server running 9.1 My import/load/export tests fail with:
    "SQL1325N The remote database environment does not support the command or one of the command options."

    I have found indications that this might be a limitation of connecting to the Z and that this will never work. can anyone confirm this?
    Server/Version = DB2 OS/390 9.1.5 "LINUX390X64"

    Here is a sample command:
    db2 load from testfile.dat of del insert into someschema.test_table

    I've tried this from a Windows box and a Unix box with the same error. Any ideas?

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    I assume testfile.dat sits on your Linux client machine. If that's the case, you have to specify LOAD CLIENT FROM ...
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Try import using IXF format. Please take a look here:
    DB2 Database for Linux, UNIX, and Windows

  4. #4
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    An other option would be to load into a replica (temp) table on the Linux DB2 in step 1, then replicate that table into the z/OS DB2 table (with plain SQL).
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

  5. #5
    Join Date
    Jun 2009
    Location
    Pennsylvania
    Posts
    22
    Quote Originally Posted by n_i
    I assume testfile.dat sits on your Linux client machine. If that's the case, you have to specify LOAD CLIENT FROM ...
    I had already tried the "load client" option with the same error.

    I'm trying to load text/dat/csv files downloaded from various sources. They are not in ixf format.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •