Db2 On Premise and Cloud

Optim high performance unload

  • 1.  Optim high performance unload

    Posted Mon April 29, 2019 04:34 AM
    Hi Gurus,

    System Specs:
    1. DB2 10.5.0.8 is running on Linux 5.8.
    2. DB2 LUW HPU v6 is installed.
    3. My task is to unload a table from running database and load it to a different DB2 DB.

    I have created the control file with the following lines.

    **GLOBAL CONNECT TO SAMPLE DB2 NO
    QUIESCE YES
    LOCK YES
    ;
    UNLOAD TABLESPACE
    SELECT * FROM "DB2INST1"."CUSTOMER";
    OUTFILE ("/home/db2inst1/customer.out" REPLACE)
    LOADFILE ("/home/db2inst1/customer.load")
    FORMAT DELIMITED**

    while i try to excute this file like: db2hpu -f filename

    i receive the below error:

    **[db2inst1@db2 ~]$ db2hpu -f unload.sh
    INZM031I Optim High Performance Unload for DB2 for Linux, UNIX and Windows 05.01.00.001(140816) 64 bits 04/29/2019 (Linux db2.gbm.com 2.6.32-100.26.2.el5 #1 SMP Tue Jan 18 20:11:49 EST 2011 x86_64)
    INZI473I Memory limitations: 'unlimited' for virtual memory and 'unlimited' for data segment
    ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----10---+----11---+----12---+----13-
    000001 GLOBAL CONNECT TO SAMPLE DB2 NO
    000002 QUIESCE YES
    000003 LOCK YES
    000004 ;
    000005 UNLOAD TABLESPACE
    000006 SELECT * FROM "DB2INST1"."CUSTOMER";
    000007 OUTFILE ("/home/db2inst1/customer.out" REPLACE)
    000008 LOADFILE ("/home/db2inst1/customer.load")
    000009 FORMAT DELIMITED
    000010 DATE DATE_E
    000011 ;
    INZU462I HPU control step start: 12:05:53.713.
    INZU463I HPU control step end : 12:05:54.535.
    INZU464I HPU run step start : 12:05:54.541.
    INZU527E XMLFILE statement is mandatory to unload XML data if the OUTFILE statement is specified.
    INZU465I HPU run step end : 12:05:54.617.
    INZU366I HPU return code 8 (reason code 0x12da7d8)**

    This Cutomer table is not an XML data table though.

    I am stuck here. please help me get this though ASAP.
    Also, please help me how can i fetch the same table from an offline/online backup?

    Thanks in Advance.

    Best Regards,
    Rizwan




    ------------------------------
    Rizwan Joo
    ------------------------------