Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

GDG merge

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
samimaktar

New User


Joined: 03 Aug 2009
Posts: 25
Location: Singapore

PostPosted: Tue Apr 26, 2011 5:51 pm    Post subject: GDG merge
Reply with quote

Hi All
Is it possible to merge all the generations of 3 GDG base if one of the base do not have any generation
eg
1. abc.xyz1 (it has two generation)
2. abc.xyz2 (it has one generation)
3. abc.xyz3 (it do not have generation)

While I was trying with SORT it was giving error message 'NO DATASETS ARE ASSOCIATED WITH BASE' abc.xyz3

Regards,
Samim
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue Apr 26, 2011 5:54 pm    Post subject:
Reply with quote

Did the job fail, or was the message informational.

Which sort product are you using.
Back to top
View user's profile Send private message
samimaktar

New User


Joined: 03 Aug 2009
Posts: 25
Location: Singapore

PostPosted: Tue Apr 26, 2011 7:07 pm    Post subject: Reply to: GDG merge
Reply with quote

Hi Expat
Job is failing with JCL error(SORT SORTIN +010 - DATA SET NOT FOUND), Product is SORT only(PGM=SORT).
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 645
Location: Pennsylvania

PostPosted: Tue Apr 26, 2011 7:14 pm    Post subject:
Reply with quote

You need to create an empty +1 generation to each gdg to ensure there is at least one generation.

A single IEFBR14 step will work before your 'merge' step.

As far as I know, there is no other option (I am sure you will ask anyway).
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Tue Apr 26, 2011 7:32 pm    Post subject:
Reply with quote

I second you Dave..
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Apr 26, 2011 7:42 pm    Post subject:
Reply with quote

I agree with Dave. For SORT products, when GDG does not have any member attached to it - it's similar to the situation wehre you have concatenated DSNs and one of them is not present, which will apprantely throw 'DATA SET NOT FOUND' message.

Just for experiment, I try:
Code:
//STEP001  EXEC PGM=SORT                 
//SORTIN DD DSN=HLQ.FIRST.GDG,DISP=SHR   
//       DD DSN=HLQ.SECOND.GDG,DISP=MOD   
//SORTOUT DD SYSOUT=*                     
//SYSIN DD *                             
  OPTION COPY                             
//SYSOUT DD SYSOUT=*                     
but this also does not work.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1713
Location: UK

PostPosted: Tue Apr 26, 2011 7:44 pm    Post subject:
Reply with quote

Product is NOT SORT - it is likely to be either DFSORT or SYNCSORT although other sort products are available. PGM=SORT is an alias for the real sort executable. Look at the sort messages - they will tell you.
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 645
Location: Pennsylvania

PostPosted: Tue Apr 26, 2011 7:46 pm    Post subject:
Reply with quote

Vegas Line : 3 to 1 we will not hear from this TS.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Apr 26, 2011 7:54 pm    Post subject:
Reply with quote

Quote:
Product is SORT only(PGM=SORT).

Quote:
Product is NOT SORT - it is likely to be either DFSORT or SYNCSORT although other sort products are available. PGM=SORT is an alias for the real sort executable. Look at the sort messages - they will tell you.
Ditto.

*POSE*

Sometimes I really wonder -- what is that very first word The SORT representatives have after seeing such comments from an OP, specially when we have kernal writers also around...icon_smile.gif
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue Apr 26, 2011 8:33 pm    Post subject:
Reply with quote

Anuj Dhawan wrote:
For SORT products, when GDG does not have any member attached to it

Anuj, you must be working too hard using terminology like this icon_lol.gif
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Apr 26, 2011 10:20 pm    Post subject:
Reply with quote

LOL, not really expat - my syntax-check tool gave me those words:

Code:
//STEP001  EXEC PGM=SORT                                               
//SORTIN DD DSN=HLQ.FIRST.GDG,DISP=SHR                             
//SORTIN DD DSN=HLQ.FIRST.GDG,DISP=SHR                             
CAY6099W GENERATION DATA GROUP "HLQ.FIRST.GDG" SPECIFIED WITHOUT A
         GENERATION NUMBER - ALL MEMBERS SELECTED                     
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Apr 26, 2011 11:36 pm    Post subject:
Reply with quote

Quote:
any member attached to it


maybe expat was referring to another of the poorly chosen technical terms?
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Wed Apr 27, 2011 5:01 am    Post subject:
Reply with quote

Hi,


Quote:
Is it possible to merge all the generations of 3 GDG base if one of the base do not have any generation
- the answer is NO

Quote:
You need to create an empty +1 generation to each gdg to ensure there is at least one generation.

as long as you don't roll off a needed generation

Quote:
Job is failing with JCL error(SORT SORTIN +010 - DATA SET NOT FOUND), Product is SORT only(PGM=SORT).

How do you get +010 when you are only concatenating 3 GDG base.

Also I'm sure you mean concatenating and NOT merging.


Gerry
Back to top
View user's profile Send private message
samimaktar

New User


Joined: 03 Aug 2009
Posts: 25
Location: Singapore

PostPosted: Wed Apr 27, 2011 9:38 am    Post subject: Reply to: GDG merge
Reply with quote

Hi All
Thanks for your discussion on the topic.
@gcicchet:
1. Is there any other way to merge all the generations of 3 GDG base if one of the base do not have any generation without using SORT ?
2. Yes,I was trying to do it using DD Concatenation.


Regards,
Samim
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Wed Apr 27, 2011 10:04 am    Post subject:
Reply with quote

Hi Samin,



Quote:
1. Is there any other way to merge all the generations of 3 GDG base if one of the base do not have any generation without using SORT ?
The answer is still no regardless of which program/utility you use.

In JES2, allocation of datasets required by a step are done prior to step executing.


Gerry
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1713
Location: UK

PostPosted: Wed Apr 27, 2011 10:07 am    Post subject:
Reply with quote

Why do you have an empty GDG base in the first place?

To by-pass the problem you can list the GDG bases using IDCAMS, process the output and set a return code based on what you find. You can then conditionally execute a) a step with all 3 GDG bases concatenated or b) another step with only those bases with associated datasets. I'll leave you to work out how many steps you would require - it is too early in the morning for me.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SQL Merge error -254 Robin Sulsona DB2 8 Wed Jun 01, 2016 8:28 pm
No new posts SAS MERGE to DFSORT Musab Ahmed DFSORT/ICETOOL 6 Mon Feb 01, 2016 5:44 pm
No new posts Merge two files having two trailer re... R.Manivannan DFSORT/ICETOOL 7 Wed Nov 25, 2015 9:18 pm
No new posts Merge two files with some replace/ove... dheeraj.ramchandani DFSORT/ICETOOL 10 Thu Sep 03, 2015 7:59 pm
No new posts Merge multiple records into single re... mkk157 DFSORT/ICETOOL 4 Wed May 27, 2015 5:43 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us