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
 

 

Help needed on PARASORT

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

New User


Joined: 13 Jan 2006
Posts: 4
Location: Mumbai

PostPosted: Tue Aug 24, 2010 3:51 pm    Post subject: Help needed on PARASORT
Reply with quote

Hi,

I am currently extracting some data from a TAPE file, but the file contains huge number of records. The normal SORT job takes very large time to extract the required data. Hence I decided to use PARASORT feature of SYNCSORT. But my extract job is currently failing with following error message:

MESSAGE FROM THRUPUT MANAGER:
JOB REQUESTED 0 PHYSICAL TAPE DRIVES.
JOB REQUESTED 64 VIRTUAL DRIVES.
THE LIMIT IS 10 PHYSICAL AND 12 VIRTUAL PER JOB STEP.
YOU MAY BE ABLE TO REDUCE THE NUMBER OF DRIVES REQUIRED
BY USING UNIT=AFF IN CONCATENATED DD STATEMENTS OR WITH
OTHER NON-CONCURRENTLY-OPEN TAPE FILE DD STATEMENTS.

Below is my JCL:


Code:
//STEP010  EXEC PGM=SORT,                                               
// PARM='PARASORT,NOEQUALS,DYNALLOC=(SYSDA,120,RETRY=(5,3))'
//SORTIN DD DSN=FILE.G0063V00,           
//          DISP=(OLD,KEEP),                                           
//       UNIT=(,,DEFER)                                                 
//SORTPAR1 DD DSN=*.SORTIN,DISP=OLD,               
//       UNIT=AFF=SORTIN                           
//SORTPAR2 DD DSN=*.SORTIN,DISP=(,KEEP,KEEP),   
//            VOL=PRIVATE,UNIT=(TAPE,,DEFER)       
//SORTPAR3 DD DSN=*.SORTIN,DISP=(,KEEP,KEEP),   
//            VOL=PRIVATE,UNIT=(TAPE,,DEFER)       
//SORTPAR4 DD DSN=*.SORTIN,DISP=(,KEEP,KEEP),   
//            VOL=PRIVATE,UNIT=(TAPE,,DEFER)       
//SORTOUT DD DSN=OUTPUT.DT0823,         
//            DISP=(NEW,CATLG,DELETE),                                 
//            SPACE=(CYL,(200,50),RLSE),                             
//            DCB=(SYS1.DSCB,RECFM=VB,LRECL=2457)                       
//SYSOUT   DD SYSOUT=* 


Please help me understand the above issue and how to fix the same.
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 Aug 24, 2010 4:15 pm    Post subject:
Reply with quote

How many volumes are associated with the dataset.
Shouldn't you have specified a number of units to allocate in here
Code:
//       UNIT=(,,DEFER)             
Back to top
View user's profile Send private message
kiran_nikam

New User


Joined: 13 Jan 2006
Posts: 4
Location: Mumbai

PostPosted: Tue Aug 24, 2010 4:26 pm    Post subject:
Reply with quote

I had specified the number of units previously. But it got abended with the similar message.

Below is the JCL:

Code:
//STEP010  EXEC PGM=SORT,                                             
// PARM='PARASORT,NOEQUALS,DYNALLOC=(SYSDA,120,RETRY=(5,3)),ELAP'     
//SORTIN DD DSN=FILE.G0063V00,         
//          DISP=(OLD,KEEP),                                           
//       UNIT=(TAPE,10,DEFER)                                         
//SORTPAR1 DD DSN=*.SORTIN,DISP=OLD,                                   
//       UNIT=AFF=SORTIN                                               
//SORTPAR2 DD DSN=*.SORTIN,DISP=(,KEEP,KEEP),                         
//            VOL=PRIVATE,UNIT=(TAPE,1,DEFER)                         
//SORTPAR3 DD DSN=*.SORTIN,DISP=(,KEEP,KEEP),                         
//            VOL=PRIVATE,UNIT=(TAPE,1,DEFER)                         
//SORTPAR4 DD DSN=*.SORTIN,DISP=(,KEEP,KEEP),                         
//            VOL=PRIVATE,UNIT=(TAPE,1,DEFER)                         
//SORTOUT DD DSN=OUTPUT.DT0823,         
//            DISP=(NEW,CATLG,DELETE),                                 
//            SPACE=(CYL,(200,50),RLSE),                           
//            DCB=(SYS1.DSCB,RECFM=VB,LRECL=2457)
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 Aug 24, 2010 4:37 pm    Post subject:
Reply with quote

Then you need to post the full output from an abend for us to see exactly what is happening.
Back to top
View user's profile Send private message
kiran_nikam

New User


Joined: 13 Jan 2006
Posts: 4
Location: Mumbai

PostPosted: Tue Aug 24, 2010 5:54 pm    Post subject:
Reply with quote

Below is the only message in Spool:

DTM1455I 2010.236 03:51:30 JOB JSLATSE1 FAILED, JOB ACTION LANGUAGE

03.50.16 JOB52298 ---- TUESDAY, 24 AUG 2010 ----
############################################################
# #
# MESSAGE FROM THRUPUT MANAGER: #
# JOB REQUESTED 0 PHYSICAL TAPE DRIVES. #
# JOB REQUESTED 64 VIRTUAL DRIVES. #
# THE LIMIT IS 10 PHYSICAL AND 12 VIRTUAL PER JOB STEP. #
# YOU MAY BE ABLE TO REDUCE THE NUMBER OF DRIVES REQUIRED #
# BY USING UNIT=AFF IN CONCATENATED DD STATEMENTS OR WITH #
# OTHER NON-CONCURRENTLY-OPEN TAPE FILE DD STATEMENTS. #
# #
############################################################
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 Aug 24, 2010 6:06 pm    Post subject:
Reply with quote

I take it you mean that the job produced no output, and may have been terminated before being actually submitted to JES by THRUPUT MANAGER.

If so, you will need to speak to your site support people to investigate the problem further as only they will know how the product has been set up.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Tue Aug 24, 2010 6:07 pm    Post subject:
Reply with quote

**Sigh** (that's kolusuese for Idiot)

Quote:
Below is the only message in Spool:


The above is untrue. expat wanted to see the mount messages,
the allocation messages,
but you have just given him BS.

How do you expect anyone to help when you head is so far up your butt,
that you can not bother to do what someone asks?
Back to top
View user's profile Send private message
kiran_nikam

New User


Joined: 13 Jan 2006
Posts: 4
Location: Mumbai

PostPosted: Tue Aug 24, 2010 6:26 pm    Post subject:
Reply with quote

Well, I thought I made a mistake by asking for help in this forum which is so popular.

Why do you think that I am not giving the complete info here??

As mentioned correctly by Expat " job was terminated before being actually submitted to JES by THRUPUT MANAGER. "

The job didnt even come into execution. There were no allocation messages l!!!

I suggest you to better look into the other facts before commenting anything or better don't comment.

I have seen many times in this forum that most users try to show how fool the person is who is asking for help without actually understanding the issue. This is the perfect example.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Tue Aug 24, 2010 6:32 pm    Post subject:
Reply with quote

I am chastened.

but, why did you not bother to ask you site support?
as they are the only ones who know your sytem.
Back to top
View user's profile Send private message
sqlcode1

Active Member


Joined: 08 Apr 2010
Posts: 578
Location: USA

PostPosted: Tue Aug 24, 2010 7:48 pm    Post subject:
Reply with quote

kiran_nikam,
I don't have Syncsort at our shop but I have had similar issue while testing one of the high data volume jobs. Below is what I have found and since this was system specific, it may or may not work for you.

In my case, storage management had placed a rule that none of the test jobs be able to allocate more than certain number of TAPES. As it correctly points out try to code UNIT=AFF=SORTIN for all your input files. You have correctly coded the same for SORTPAR1. Try to use the same for all the input files and see if it works.

Other option for you would be to speak to Storage Management and request them to temporary add your test jobid in the exception rule to grant you access to allocate more number of TAPES than the defined limit.

Please, let us know if it works or not.

Thanks,
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Aug 24, 2010 9:47 pm    Post subject:
Reply with quote

Hello,

Why might you believe it appropriate to submit a job that requires 10 tape drives. . . icon_confused.gif

There might be 10 volumes for a file, but i've not been on a system that would permit allocating 10 tape drives for one step, let alone for one DD statement. . .
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 Help Needed with View Direct shailesh_do CA Products 2 Wed Jul 13, 2016 10:39 am
No new posts Information needed on using the COBAN... venugopal.dondla COBOL Programming 5 Thu Oct 08, 2015 3:34 pm
No new posts Help needed in Conditional statement ... vinu78 DB2 5 Tue Sep 15, 2015 10:14 am
No new posts Help needed to locate the changes wh... thesumitk TSO/ISPF 6 Fri Jun 12, 2015 6:21 pm
No new posts Sort help needed guptae DFSORT/ICETOOL 5 Tue Jul 01, 2014 11:34 am


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