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
------------------------------
#Db2