Topic
1 reply Latest Post - ‏2012-10-09T04:47:56Z by eslee80
eslee80
eslee80
2 Posts
ACCEPTED ANSWER

Pinned topic Syntax error in the control file

‏2012-09-28T00:24:26Z |
Hello,

When I tested the HPU function that unload all tables data in tablespace from backup file, the following syntax error occurred.

  1. db2hpu -f EMSC54TB_TEST_BK.CTL
INZI445W WARNING: You are still using a temporary license.
You need to enroll Optim High Performance Unload for DB2 for Linux, UNI
INZM031I Optim High Performance Unload for DB2 for Linux, UNIX and Windows 04.02
INZI473I Memory limitations: 'unlimited' for virtual memory and 'unlimited' for
----+----1----+----2----+----3----+----4----+----5----+----6----+----7---
000001 GLOBAL CONNECT TO TEST;
000002 UNLOAD TABLESPACE
000003 QUIESCE NO
000004 LOCK NO
000005 FROM "/db2hpu/BACK";
000006 OUTPUT("/db2hpu/USERSPACE1")
000007 FORMAT DEL
000008 USING BACKUP DATABASE TEST TABLESPACE ("USERSPACE1") ;
000009

INZU010I Item starting at (5,1) ending at (5,4)
INZU022E Invalid lexeme.
INZM029E Syntax error in the control file
INZU366I HPU return code 8 (reason code 0x124a002)

But I don't know what is wrong.
If the syntax is wrong, Please let me know how to edit syntax.

Thanks.

OS : AIX 6100-06
DB2 : DB2 v9.7.0.6
HPU : INZM030I Optim High Performance Unload for DB2 for Linux, UNIX and Windows version 64 bits 04.02.100(120412)
Updated on 2012-10-09T04:47:56Z at 2012-10-09T04:47:56Z by eslee80
  • eslee80
    eslee80
    2 Posts
    ACCEPTED ANSWER

    Re: Syntax error in the control file

    ‏2012-10-09T04:47:56Z  in response to eslee80
    I found the answer.

    1. Using DB2 + Backup File

    GLOBAL CONNECT TO TEST ;

    UNLOAD TABLESPACE TABLESP1
    OUTFILE(" /HPU/DATA")
    LOADFILE(" /HPU/LOAD")
    FORMAT IXF

    USING BACKUP DATABASE TEST from " /BACK" TAKEN AT 20120926092710;
    ;
    2. Using Backup File
    GLOBAL USING BACKUP CATALOG TEST from " /BACK" TAKEN AT 20120926092710;
    ;

    UNLOAD TABLESPACE TABLESP1
    OUTFILE("/HPU/DATA")
    LOADFILE("/HPU/LOAD")
    FORMAT IXF

    USING BACKUP DATABASE TEST from " /BACK" TAKEN AT 20120926092710;
    ;