Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2006

    Unanswered: Extract DDL from IXF file

    I need to import/load an IXF file, but the table contains a column that is too long to be logged, which causes IMPORT to fail with

    "SQL3319N An SQL error "-355" occurred while creating the table"

    and I don't have the DDL for the target tablel, so I can't use the LOAD utility. Is there any way to extract the DDL from an IXF file?

    I've unsuccessfully tried the following approach suggested by another post from a couple of years ago.

    db2 "IMPORT FROM myfile.ixf OF IXF ROWCOUNT 1 CREATE INTO B" >> /dev/null
    db2look -d LISDEV -t B -e
    db2 "DROP TABLE B" >> /dev/null

    Any suggestions?

    DB2 V8.2 FixPak 10 on Windows 2003

  2. #2
    Join Date
    May 2003
    I am not sure if this will work, but you might try using the ROWCOUNT 1 option on the IMPORT to only import the first row. If the first row LOB data is not too large for logging, then you may be OK.

    edit: Sorry, I did not see that you already tried to import only the first row.

    You might try a where clause to import some other row other than the first row to find one with a LOB less than 1GB. However, I thought that if you do not have your LOBs in a separate file (outside the IXF), then the data will be truncated at 32K.
    Last edited by Marcus_A; 11-28-06 at 23:50.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jun 2006


    it is not easy, but the ddl can be extracted
    see infocenter and search for pc/ixf record types
    this describes the records for an ixf file and check also in same chapter pc/ixf data types
    a simple editor could help to display the records and recreate the ddl if really needed.
    sample : C009ATTEST_ID NNY02R496
    c=record type-- 9 column name length -- ATTEST_ID column name -- N null - 02 position in primary key - 496 data type=integer........
    Hope this will help
    Last edited by guyprzytula; 11-29-06 at 03:52.
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  4. #4
    Join Date
    Dec 2008
    Thanks Marcus A it your suggestion helped me a lot...

Posting Permissions

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