Do you have a JCL example?

Horacio Villa

Do you have a JCL example?
Hi list,

I've tried hard to Unload from a Copy from a dropped table with HPU with
no success.
The user's guide is not clear to me, English is not my mother tong.
Anybody has a JCL example? Do I have to recreate the table, or giving the
DDL in DDLDDN is enough? (I tried recreating the table and got the same
error)
It seems that there's an error in the UNLOAD TABLESPACE block, which is
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 success).

INZU224I IBM DB2 HIGH PERFORMANCE UNLOAD V5.1
...
INZI175I PROCESSING SYSIN AS EBCDIC.
----+----1----+----2----+----3----+----4----+----5----+----6----+----7---

000001 TEMPLATE COPY1 DSN('myCopyFile')
000002
000003 TEMPLATE DDL1 DSN('myDDLFile') -- includes Create DB, TS,TB and
IX
000004
000005 TEMPLATE OUT1 DSN('myOuputFile')
000006 DATACLAS MULTICOM
000007 STORCLAS STRIP0
000008 UNIT SYSDA SPACE(254,254) CYL
000009
000010 TEMPLATE LOAD1 DSN('myOutputPunch')
000011 DATACLAS MULTICOM
000012 STORCLAS STRIP0
000013 UNIT SYSDA SPACE(1,1) CYL
000014
000015 UNLOAD TABLESPACE db.ts
000016 COPYDDN COPY1 DDLDDN DDL1;
000017
000018 SELECT *
000019 ORIGINOBID 0
000020 FROM creator.table
000021 OUTDDN OUT1
000022 LOADDN LOAD1
000023 FORMAT VARIABLE ALL
000024 ;
........
INZU039E FATAL SYNTAX ERROR BEFORE LINE 18 COLUMN 7
INZU366I UTILITY RETURN CODE 8 (REASON CODE 0x107a002)

Thanks,
Horacio



Lizette Koehler

Do you have a JCL example?
(in response to Horacio Villa)
First, those look like Control Cards you would include in JCL. Not JCL.



Second did you look up the INZU039E



Sometimes the error messages - when they are looked up - can shed light on the
issue.



What level of software are you using?



Lizette





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?



Hi list,

I've tried hard to Unload from a Copy from a dropped table with HPU with no
success.
The user's guide is not clear to me, English is not my mother tong.
Anybody has a JCL example? Do I have to recreate the table, or giving the DDL in
DDLDDN is enough? (I tried recreating the table and got the same error)
It seems that there's an error in the UNLOAD TABLESPACE block, which is 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 success).

INZU224I IBM DB2 HIGH PERFORMANCE UNLOAD V5.1

...
INZI175I PROCESSING SYSIN AS EBCDIC.

----+----1----+----2----+----3----+----4----+----5----+----6----+----7---

000001 TEMPLATE COPY1 DSN('myCopyFile')
000002

000003 TEMPLATE DDL1 DSN('myDDLFile') -- includes Create DB, TS,TB and IX

000004

000005 TEMPLATE OUT1 DSN('myOuputFile')
000006 DATACLAS MULTICOM

000007 STORCLAS STRIP0

000008 UNIT SYSDA SPACE(254,254) CYL

000009

000010 TEMPLATE LOAD1 DSN('myOutputPunch')
000011 DATACLAS MULTICOM

000012 STORCLAS STRIP0

000013 UNIT SYSDA SPACE(1,1) CYL

000014

000015 UNLOAD TABLESPACE db.ts
000016 COPYDDN COPY1 DDLDDN DDL1;

000017
000018 SELECT *
000019 ORIGINOBID 0
000020 FROM creator.table
000021 OUTDDN OUT1
000022 LOADDN LOAD1
000023 FORMAT VARIABLE ALL
000024 ;
........
INZU039E FATAL SYNTAX ERROR BEFORE LINE 18 COLUMN 7
INZU366I UTILITY RETURN CODE 8 (REASON CODE 0x107a002)

Thanks,
Horacio




-----End Original Message-----

Horacio Villa

Do you have a JCL example?
(in response to Lizette Koehler)
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 working
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

Software level?
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 JCL.

Second did you look up the INZU039E

Sometimes the error messages ? when they are looked up ? can shed light on
the issue.

What level of software are you using?

Lizette


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?

Hi list,

I've tried hard to Unload from a Copy from a dropped table with HPU with
no success.
The user's guide is not clear to me, English is not my mother tong.
Anybody has a JCL example? Do I have to recreate the table, or giving the
DDL in DDLDDN is enough? (I tried recreating the table and got the same
error)
It seems that there's an error in the UNLOAD TABLESPACE block, which is
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 success).

INZU224I IBM DB2 HIGH PERFORMANCE UNLOAD V5.1
...
INZI175I PROCESSING SYSIN AS EBCDIC.
----+----1----+----2----+----3----+----4----+----5----+----6----+----7---

000001 TEMPLATE COPY1 DSN('myCopyFile')
000002
000003 TEMPLATE DDL1 DSN('myDDLFile') -- includes Create DB, TS,TB and
IX
000004
000005 TEMPLATE OUT1 DSN('myOuputFile')
000006 DATACLAS MULTICOM
000007 STORCLAS STRIP0
000008 UNIT SYSDA SPACE(254,254) CYL
000009
000010 TEMPLATE LOAD1 DSN('myOutputPunch')
000011 DATACLAS MULTICOM
000012 STORCLAS STRIP0
000013 UNIT SYSDA SPACE(1,1) CYL
000014
000015 UNLOAD TABLESPACE db.ts
000016 COPYDDN COPY1 DDLDDN DDL1;
000017
000018 SELECT *
000019 ORIGINOBID 0
000020 FROM creator.table
000021 OUTDDN OUT1
000022 LOADDN LOAD1
000023 FORMAT VARIABLE ALL
000024 ;
........
INZU039E FATAL SYNTAX ERROR BEFORE LINE 18 COLUMN 7
INZU366I UTILITY RETURN CODE 8 (REASON CODE 0x107a002)

Thanks,
Horacio


-----End Original Message-----


Site Links: View post online View mailing list online Start new thread
via email Unsubscribe from this mailing list Manage your subscription


This email has been sent to: [login to unmask email]
Discover the best cloning tool on the market. Try BCV5 & the new BCV5
Masking Tool.
ESAi also has powerful solutions for Buffer Pool Tuning, Log Analysis,
TDM, & more.
http://www.ESAIGroup.com/idug

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2




Larry Jardine

Do you have a JCL example?
(in response to Horacio Villa)
Did you try moving ORIGINOBID 0 to the line after the FROM creator.table?

Larry Jardine | Database Advisor, Middleware and Data Engineering
p 860-273-5321
WAH, Connecticut
[CVS]




From: Horacio Villa <[login to unmask email]>
Sent: Tuesday, September 24, 2019 2:12 PM
To: [login to unmask email] ([login to unmask email]) <[login to unmask email]>
Subject: [EXTERNAL] [DB2-L] - Do you have a JCL example?

**** External Email - Use Caution ****
Hi list,

I've tried hard to Unload from a Copy from a dropped table with HPU with no success.
The user's guide is not clear to me, English is not my mother tong.
Anybody has a JCL example? Do I have to recreate the table, or giving the DDL in DDLDDN is enough? (I tried recreating the table and got the same error)
It seems that there's an error in the UNLOAD TABLESPACE block, which is 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 success).

INZU224I IBM DB2 HIGH PERFORMANCE UNLOAD V5.1
...
INZI175I PROCESSING SYSIN AS EBCDIC.
----+----1----+----2----+----3----+----4----+----5----+----6----+----7---
000001 TEMPLATE COPY1 DSN('myCopyFile')
000002
000003 TEMPLATE DDL1 DSN('myDDLFile') -- includes Create DB, TS,TB and IX
000004
000005 TEMPLATE OUT1 DSN('myOuputFile')
000006 DATACLAS MULTICOM
000007 STORCLAS STRIP0
000008 UNIT SYSDA SPACE(254,254) CYL
000009
000010 TEMPLATE LOAD1 DSN('myOutputPunch')
000011 DATACLAS MULTICOM
000012 STORCLAS STRIP0
000013 UNIT SYSDA SPACE(1,1) CYL
000014
000015 UNLOAD TABLESPACE db.ts
000016 COPYDDN COPY1 DDLDDN DDL1;
000017
000018 SELECT *
000019 ORIGINOBID 0
000020 FROM creator.table
000021 OUTDDN OUT1
000022 LOADDN LOAD1
000023 FORMAT VARIABLE ALL
000024 ;
........
INZU039E FATAL SYNTAX ERROR BEFORE LINE 18 COLUMN 7
INZU366I UTILITY RETURN CODE 8 (REASON CODE 0x107a002)

Thanks,
Horacio

-----End Original Message-----

NOTICE TO RECIPIENT OF INFORMATION:
This e-mail may contain confidential or privileged information. If you think you have received this e-mail in error, please advise the sender by reply e-mail and then delete this e-mail immediately.
This e-mail may also contain protected health information (PHI) with information about sensitive medical conditions, including, but not limited to, treatment for substance use disorders, behavioral health, HIV/AIDS, or pregnancy. This type of information may be protected by various federal and/or state laws which prohibit any further disclosure without the express written consent of the person to whom it pertains or as otherwise permitted by law. Any unauthorized further disclosure may be considered a violation of federal and/or state law. A general authorization for the release of medical or other information may NOT be sufficient consent for release of this type of information.
Thank you. Aetna
Attachments

  • image003.png (3.9k)

Horacio Villa

Do you have a JCL example?
(in response to Larry Jardine)
Yes, thanks, I did.
I'm looking for a working example.
The error message points to an error BEFORE the SELECT statement.

Larry said:
Did you try moving ORIGINOBID 0 to the line after the FROM creator.table?





Horacio Villa

Do you have a JCL example?
(in response to Horacio Villa)
You're right about the location of ORIGINOBID, don't know when I
missplaced it.
But putting it in the correct place gives me the same error.











Russell Peters

RE: Do you have a JCL example?
(in response to Horacio Villa)

We don't have IBM's unload/load, we use BMC's so I may be wrong here. It looks to me like you have defined the input copy that you want to unload from in a template statement and have done the same for the DDL file. Noramlly a template is for the output file. When we unload from an image copy using BMC's unload, we specify a DD statement for the image copy and the DDL file (if needed). Something like this:

//COPY1DD    DD DISP=SHR,DSN=your-image-copy-to-unload-from

//DDLIN           DD DISP=SHR,DSN=your-ddl-file

Then in your control cards you would reference these two DD identifiers. I don't know if this helps since this is for BMC Unload Plus but usually jcl is similar.

Chris Tee

Do you have a JCL example?
(in response to Horacio Villa)
Horacio

Isn't the problem caused by the extraneous ; at the end of COPYDDN COPY1 DDLDDN DDL1; ?

regards

Chris

________________________________
From: Horacio Villa <[login to unmask email]>
Sent: 24 September 2019 19:12
To: [login to unmask email] ([login to unmask email]) <[login to unmask email]>
Subject: [DB2-L] - Do you have a JCL example?

Hi list,

I've tried hard to Unload from a Copy from a dropped table with HPU with no success.
The user's guide is not clear to me, English is not my mother tong.
Anybody has a JCL example? Do I have to recreate the table, or giving the DDL in DDLDDN is enough? (I tried recreating the table and got the same error)
It seems that there's an error in the UNLOAD TABLESPACE block, which is 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 success).

INZU224I IBM DB2 HIGH PERFORMANCE UNLOAD V5.1
...
INZI175I PROCESSING SYSIN AS EBCDIC.
----+----1----+----2----+----3----+----4----+----5----+----6----+----7---
000001 TEMPLATE COPY1 DSN('myCopyFile')
000002
000003 TEMPLATE DDL1 DSN('myDDLFile') -- includes Create DB, TS,TB and IX
000004
000005 TEMPLATE OUT1 DSN('myOuputFile')
000006 DATACLAS MULTICOM
000007 STORCLAS STRIP0
000008 UNIT SYSDA SPACE(254,254) CYL
000009
000010 TEMPLATE LOAD1 DSN('myOutputPunch')
000011 DATACLAS MULTICOM
000012 STORCLAS STRIP0
000013 UNIT SYSDA SPACE(1,1) CYL
000014
000015 UNLOAD TABLESPACE db.ts
000016 COPYDDN COPY1 DDLDDN DDL1;
000017
000018 SELECT *
000019 ORIGINOBID 0
000020 FROM creator.table
000021 OUTDDN OUT1
000022 LOADDN LOAD1
000023 FORMAT VARIABLE ALL
000024 ;
........
INZU039E FATAL SYNTAX ERROR BEFORE LINE 18 COLUMN 7
INZU366I UTILITY RETURN CODE 8 (REASON CODE 0x107a002)

Thanks,
Horacio



-----End Original Message-----

Horacio Villa

Do you have a JCL example?
(in response to Horacio Villa)
Chris said:
Isn't the problem caused by the extraneous ; at the end of COPYDDN COPY1
DDLDDN DDL1; ?


Hi Chris,

no, without the extraneous ; I get 2 error messages instead of 1.
INZU015E UNLOAD TABLESPACE STATEMENT : UNEXPECTED KEYWORD ----> (without
the ;)
INZU039E FATAL SYNTAX ERROR BEFORE LINE 22 COLUMN 8

Anybody who has done this can share the control statements?
Thanks,


Horacio Villa

Do you have a JCL example?
(in response to Horacio Villa)
Thanks Robert!
It was what you said.
I incorrectly typed LOADDN instead of LOADDDN.
The error message could be clearer.


Horacio Villa
DB2 z/OS DBA Support, Database Administration
IBM Certified DataBase Administrator ? DB2 9 DBA for z/OS
IBM Corporation
( 5070-3443 / tl 840-3443 cell 15 6178-8908
* [login to unmask email]






From: Horacio Villa <[login to unmask email]>
To: [login to unmask email]
Date: 24/09/2019 21:33
Subject: [EXTERNAL] [DB2-L] - RE: Do you have a JCL example?



You're right about the location of ORIGINOBID, don't know when I
missplaced it.
But putting it in the correct place gives me the same error.












Site Links: View post online View mailing list online Start new thread
via email Unsubscribe from this mailing list Manage your subscription


This email has been sent to: [login to unmask email]
Discover the best cloning tool on the market. Try BCV5 & the new BCV5
Masking Tool.
ESAi also has powerful solutions for Buffer Pool Tuning, Log Analysis,
TDM, & more.
http://www.ESAIGroup.com/idug

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2