First, I included the output of my HPU run (1 of them).
So, given your comment, I'll be more explicit: I'm looking for a
SYSIN to run the HPU I need.
Second, yes, of course, that was the first thing I did.
INZU039E FATAL SYNTAX ERROR BEFORE LINE
nnnn COLUMN nnnn
Explanation: A fatal syntax error was detected. The
syntax analysis stops and the program ends.
User response: The message contains the end of the
last lexeme that was read from the syntax. This is not
necessarily the cause for the failure. Check the syntax
before that point.
I couldn't see the light the error message is trying to shed.q
Sometimes reading the whole message can shed some light.
As I said, HPU 5.1 and Db2 11 (for z/OS, of course).
What else do you need to know?
From: Lizette Koehler <[login to unmask email]>
To: [login to unmask email]
Date: 24/09/2019 15:46
Subject: [EXTERNAL] [DB2-L] - RE: Do you have a JCL example?
First, those look like Control Cards you would include in JCL. Not
Second did you look up the INZU039E
Sometimes the error messages ? when they are looked up ? can shed
What level of software are you using?
From: Horacio Villa <[login to unmask email]>
Sent: Tuesday, September 24, 2019 11:12 AM
To: [login to unmask email]
Subject: [DB2-L] - Do you have a JCL example?
I've tried hard to Unload from a Copy from a dropped table with HPU
The user's guide is not clear to me, English is not my mother
Anybody has a JCL example? Do I have to recreate the table, or
DDL in DDLDDN is enough? (I tried recreating the table and got the
It seems that there's an error in the UNLOAD TABLESPACE block,
exactly the same as I see in the User's Guide (HPU 5.1, Db2 11)
Here's the JCL I'm using (I've tried many variations, no
INZU224I IBM DB2 HIGH PERFORMANCE UNLOAD V5.1
INZI175I PROCESSING SYSIN AS EBCDIC.
000001 TEMPLATE COPY1 DSN('myCopyFile')
000003 TEMPLATE DDL1 DSN('myDDLFile') -- includes Create DB, TS,TB
000005 TEMPLATE OUT1 DSN('myOuputFile')
000006 DATACLAS MULTICOM
000007 STORCLAS STRIP0
000008 UNIT SYSDA SPACE(254,254) CYL
000010 TEMPLATE LOAD1 DSN('myOutputPunch')
000011 DATACLAS MULTICOM
000012 STORCLAS STRIP0
000013 UNIT SYSDA SPACE(1,1) CYL
000015 UNLOAD TABLESPACE db.ts
000016 COPYDDN COPY1 DDLDDN DDL1;
000018 SELECT *
000019 ORIGINOBID 0
000020 FROM creator.table
000021 OUTDDN OUT1
000022 LOADDN LOAD1
000023 FORMAT VARIABLE ALL
INZU039E FATAL SYNTAX ERROR BEFORE LINE 18 COLUMN 7
INZU366I UTILITY RETURN CODE 8 (REASON CODE 0x107a002)
-----End Original Message-----
Site Links: View post online View mailing list online Start new
via email Unsubscribe from this mailing list Manage your
This email has been sent to: [login to unmask email]
Discover the best cloning tool on the market. Try BCV5 & the
ESAi also has powerful solutions for Buffer Pool Tuning, Log
TDM, & more.
Use of this email content is governed by the terms of service