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
 

 

why cannot you override DYNALLOC via DFSPARM?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
Victor Niu

New User


Joined: 11 Mar 2010
Posts: 59
Location: China,Shanghai

PostPosted: Fri Jun 04, 2010 2:18 pm    Post subject: why cannot you override DYNALLOC via DFSPARM?
Reply with quote

In DFSORT called by DB2 utility (DSNUTILB) abending ICE083A Dave Betten wrote:
Now how do we get DFSORT to use 32 work data sets? For a DB2 Utility, you cannot override DYNALLOC via DFSPARM. You need to pass SORTNUM 32 in the utility control statements and this will cause the utility to pass DYNALLOC=(,32) to DFSORT. This is documented in info APAR II14047 which provides a whole bunch of useful information on using DFSORT with DB2 Utilities.

hello Dave

why do u say 'you cannot override DYNALLOC via DFSPARM. '?

found an example from dfsort application programming guide v1.8


Code:
  //EXAMP    JOB A400,PROGRAMMER                                  01
  //S1       EXEC PGM=SORT                                        02
  //SYSOUT   DD SYSOUT=A                                          03
  //SORTIN   DD DSN=TEST.SORTIN.FILE,DISP=SHR                     04
  //SORTOUT  DD DSN=TEST.SORTOUT.FILE,DISP=SHR                    05
  //DFSPARM  DD *                                                 06
    RECORD TYPE=V                                                 07
    SORT FIELDS=(30,4,BI,A)                                       08
    OPTION HIPRMAX=10,DYNALLOC=3390,MAINSIZE=3M,                  09
      MSGPRT=CRITICAL,NOLIST                                      10
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: Fri Jun 04, 2010 2:31 pm    Post subject:
Reply with quote

Victor Niu wrote:
why do u say 'you cannot override DYNALLOC via DFSPARM. '?

The example that you have given is executing PGM=SORT.

The example given by the OP is executing a different program which invokes DFSORT internally.

Code:
//STEP02    EXEC PGM=DSNUTILB,PARM='DB2D,,RESTART',REGION=150M
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Fri Jun 04, 2010 2:35 pm    Post subject:
Reply with quote

Expat,

calling sort doesnt mean sort is not looking for its own 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: Fri Jun 04, 2010 2:40 pm    Post subject:
Reply with quote

Quote:
For a DB2 Utility, you cannot override DYNALLOC via DFSPARM.
Quoted source - Dave Betten IBM
Taken from a previous posting in this thread.
Back to top
View user's profile Send private message
Victor Niu

New User


Joined: 11 Mar 2010
Posts: 59
Location: China,Shanghai

PostPosted: Fri Jun 04, 2010 2:47 pm    Post subject:
Reply with quote

thanks.

but someone can explain the reason?
I mean what's the difference between dfsort and db2 internal sort in this issue
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Fri Jun 04, 2010 2:49 pm    Post subject:
Reply with quote

Yes, i found it. But he states that you can use SORTNUM xx instead via
DFSPARM.
That will generate a DYNALLOC=(,xx) to be passed to DFSORT.
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: Fri Jun 04, 2010 3:03 pm    Post subject:
Reply with quote

Peter,

I have split this from the main topic as I feel it was detracting from the topic in question.

PeterHolland wrote:
Yes, i found it. But he states that you can use SORTNUM xx instead via
DFSPARM.
That will generate a DYNALLOC=(,xx) to be passed to DFSORT.
I don't dispute that, however I merely pointed out to Victor that he had given an example of PGM=SORT where the original problem arose from PGM=DSNUTILB, and that the statement from Dave Betton showed that it could be done, but not by using DFSPARM

It was the use of DFSPARM that is in question, nothing else.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Fri Jun 04, 2010 3:09 pm    Post subject:
Reply with quote

Expat,

im not making it a issue. Dave talked about utility statements, but im
not sure if he was talking about DSNUTILB utility statements or DFSPARM
statements.
Back to top
View user's profile Send private message
Dave Betten

New User


Joined: 24 Jan 2006
Posts: 26

PostPosted: Fri Jun 04, 2010 4:36 pm    Post subject: Reply to: DFSORT called by DB2 utility - Side bar
Reply with quote

Normally you can use DYNALLOC statement in DFSPARM to override the numer o work data sets dynamically allocated by DFSORT. However, DB2 Utilities are a unique situation. The Utilities calculate the maximum number of tasks they can run in paralell and the number of work data sets allocated by each sort task is a factor in that calculation. So we only allow the number of work data sets for a DB2 Utility invoked sort to be changed by the utiliity's SORTNUM control statement. That way the utility knows exactly how many work data sets are going to be allocated.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Fri Jun 04, 2010 5:14 pm    Post subject:
Reply with quote

Thanks Dave, its clear to me now.
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: Fri Jun 04, 2010 5:27 pm    Post subject:
Reply with quote

Dave,

I split this from the original topic and the parent topic has disappeared. I have PM'd site admin to investigate.

Hopefully by clicking HERE we can still access the topic in question.
Back to top
View user's profile Send private message
Victor Niu

New User


Joined: 11 Mar 2010
Posts: 59
Location: China,Shanghai

PostPosted: Fri Jun 04, 2010 8:39 pm    Post subject:
Reply with quote

Thanks Dave, icon_razz.gif
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Compiler option for override the exte... muralikrishnan_new COBOL Programming 9 Fri Jul 08, 2016 12:09 pm
No new posts Symbolic OverRide within a 'Include' ... Sysaron JCL & VSAM 7 Thu Aug 27, 2015 10:51 pm
No new posts Help in File Tailoring services ( Ove... thesumitk TSO/ISPF 8 Wed Jun 17, 2015 12:04 pm
No new posts Override Condition code richards12388 JCL & VSAM 3 Sat May 16, 2015 9:47 am
No new posts DYNALLOC macro in Assember -Is there ... sudarshan.srivathsav PL/I & Assembler 2 Wed May 07, 2014 10:11 pm


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