View previous topic :: View next topic
|
Author |
Message |
Victor Niu
New User
Joined: 11 Mar 2010 Posts: 59 Location: China,Shanghai
|
|
|
|
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 |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
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 |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
Expat,
calling sort doesnt mean sort is not looking for its own dd statements. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
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 |
|
|
Victor Niu
New User
Joined: 11 Mar 2010 Posts: 59 Location: China,Shanghai
|
|
|
|
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 |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
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 |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
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 |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
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 |
|
|
Dave Betten
New User
Joined: 24 Jan 2006 Posts: 26
|
|
|
|
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 |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
Thanks Dave, its clear to me now. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
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 |
|
|
Victor Niu
New User
Joined: 11 Mar 2010 Posts: 59 Location: China,Shanghai
|
|
|
|
Thanks Dave, |
|
Back to top |
|
|
|