IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Help needed on PARASORT


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
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
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: 8797
Location: Welsh Wales

PostPosted: Tue Aug 24, 2010 4:15 pm
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
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: 8797
Location: Welsh Wales

PostPosted: Tue Aug 24, 2010 4:37 pm
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
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: 8797
Location: Welsh Wales

PostPosted: Tue Aug 24, 2010 6:06 pm
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
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
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
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: 577
Location: USA

PostPosted: Tue Aug 24, 2010 7:48 pm
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

Moderator Emeritus


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

PostPosted: Tue Aug 24, 2010 9:47 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Mainframe Programmer with CICS Skill... Mainframe Jobs 0
No new posts Help needed to assemble IMS sample co... ABENDS & Debugging 4
No new posts RABBIT HOLE NEEDED - "Live"... All Other Mainframe Topics 0
No new posts Mainframe profiles needed @ Cognizant Mainframe Jobs 0
No new posts COBOL Student learning COBOL File Han... COBOL Programming 3
Search our Forums:

Back to Top