dfsort with a big tape



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

dfsort with a big tape

Postby samb01 » Mon Oct 15, 2012 9:11 pm

Hello,

i try to sort a tape which is very big, but i have problems with the sortwork... :

I have to use these sortwork :


//SORTWK01 DD DSN=TRS.BVG.WK01,DISP=(NEW,CATLG,DELETE),
//  SPACE=(CYL,(3000,100)),STORCLAS=FDER,VOL=SER=GTR01
//SORTWK02 DD DSN=TRS.BVG.WK02,DISP=(NEW,CATLG,DELETE),
//  SPACE=(CYL,(3000,100)),STORCLAS=FDER,VOL=SER=GTR02
//SORTWK03 DD DSN=TRS.BVG.WK03,DISP=(NEW,CATLG,DELETE),
//  SPACE=(CYL,(3000,100)),STORCLAS=FDER,VOL=SER=GTR03
//SORTWK04 DD DSN=TRS.BVG.WK04,DISP=(NEW,CATLG,DELETE),
//  SPACE=(CYL,(3000,100)),STORCLAS=FDER,VOL=SER=GTR04
//SORTWK05 DD DSN=TRS.BVG.WK05,DISP=(NEW,CATLG,DELETE),
//  SPACE=(CYL,(3000,100)),STORCLAS=FDER,VOL=SER=GTR05
//SORTWK06 DD DSN=TRS.BVG.WK06,DISP=(NEW,CATLG,DELETE),
//  SPACE=(CYL,(3000,100)),STORCLAS=FDER,VOL=SER=GTR06
//SORTWK07 DD DSN=TRS.BVG.WK07,DISP=(NEW,CATLG,DELETE),
//  SPACE=(CYL,(3000,100)),STORCLAS=FDER,VOL=SER=GTR07
//SORTWK08 DD DSN=TRS.BVG.WK08,DISP=(NEW,CATLG,DELETE),
//  SPACE=(CYL,(3000,100)),STORCLAS=FDER,VOL=SER=GTR08
//SORTWK09 DD DSN=TRS.BVG.WK09,DISP=(NEW,CATLG,DELETE),
//  SPACE=(CYL,(3000,100)),STORCLAS=FDER,VOL=SER=GTR09
//SORTWK10 DD DSN=TRS.BVG.WK09,DISP=(NEW,CATLG,DELETE), 
//  SPACE=(CYL,(3000,100)),STORCLAS=FDER,VOL=SER=GTR10   




But it's not enought...I have the error : U0046...

Is there another way to do it...

thanks for your hlep
samb01
 
Posts: 239
Joined: Mon Nov 16, 2009 7:24 pm
Has thanked: 0 time
Been thanked: 0 time

Re: dfsort with a big tape

 

Re: dfsort with a big tape

Postby Akatsukami » Mon Oct 15, 2012 9:19 pm

Master of the Universe! Why are you allocating the SORTWKnn DDs to new permanent data sets?!
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1054
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: dfsort with a big tape

Postby BillyBoyo » Mon Oct 15, 2012 9:25 pm

In addition, please post the sysout with the full messages.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: dfsort with a big tape

Postby skolusu » Mon Oct 15, 2012 10:18 pm

samb01,

Please add the following to your job so we can see the diagnostic mesages

//SORTDIAG DD DUMMY


Then rerun the job and post the complete JES log including the complete //SYSOUT messages.
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times

Re: dfsort with a big tape

Postby samb01 » Tue Oct 16, 2012 8:16 pm

There is B37 because the file is too big :
You can see the sysout

16.18.06 JOB00956  ICH70001I OPC      LAST ACCESS AT 16:15:06 ON TUESDAY, OCTOBER 16, 2012
 16.18.06 JOB00956  $HASP373 BVGTAVLA STARTED - INIT 45   - CLASS O - SYS B011
 16.18.07 JOB00956  IEF403I BVGTAVLA - STARTED - TIME=16.18.07
 16.18.54 JOB00956  IEF233A M 0DC2,267615,,BVGTAVLA,TRISTD,BGHYMI.GHYTRYED.Q2861730.ENTURGE
 16.18.55 JOB00956  IEF233A M 0E53,PRIVAT,SL,BVGTAVLA,TRISTD,  331
    331                     BGHYOR.BTESTSB.Q2901701.ENTURGE.TRIE
 16.22.59 JOB00956  IEC502E K 0DC2,267615,SL,BVGTAVLA,TRISTD,BGHYMI.GHYTRYED.Q2861730.ENTURGE
 16.22.59 JOB00956  TMS014  IEC502E K 0DC2,267615,SL,BVGTAVLA,TRISTD,BGHYMI.GHYTRYED.Q2861730.ENTURGE
 16.22.59 JOB00956  IEC501A M 0DC2,249966,SL,COMP,BVGTAVLA,TRISTD,BGHYMI.GHYTRYED.Q2861730.ENTURGE
 16.26.48 JOB00956  V37027I PROGRAM USES EOV OR ABEND EXLST ON DCB
 16.26.48 JOB00956  V37027I ...SEE PIœ 601765 AND 601769 IN THE
 16.26.48 JOB00956  V37027I ...OPTIONAL MAINTENANCE APPENDIX IN USER'S GUIDE
 16.26.48 JOB00956  IEC030I B37-04,IFG0554A,BVGTAVLA,TRISTD,SORTWK01,A26E,VGTRT01,04210011,BGHY.GHYTRYED.WK01
 16.26.48 JOB00956  +ICE097I 1 BVGTAVLA.TRISTD   SORT RECOVERING FROM B37 ABEND ON SORTWK DATA SET
 16.26.50 JOB00956  V37027I PROGRAM USES EOV OR ABEND EXLST ON DCB
 16.26.50 JOB00956  V37027I ...SEE PIœ 601765 AND 601769 IN THE
 16.26.50 JOB00956  V37027I ...OPTIONAL MAINTENANCE APPENDIX IN USER'S GUIDE
 16.26.50 JOB00956  IEC030I B37-04,IFG0554A,BVGTAVLA,TRISTD,SORTWK02,A26F,VGTRT02,04210011,BGHY.GHYTRYED.WK02
 16.26.50 JOB00956  +ICE097I 1 BVGTAVLA.TRISTD   SORT RECOVERING FROM B37 ABEND ON SORTWK DATA SET
 16.26.50 JOB00956  V37027I PROGRAM USES EOV OR ABEND EXLST ON DCB
 16.26.50 JOB00956  V37027I ...SEE PIœ 601765 AND 601769 IN THE
 16.26.50 JOB00956  V37027I ...OPTIONAL MAINTENANCE APPENDIX IN USER'S GUIDE
 16.26.50 JOB00956  IEC030I B37-04,IFG0554A,BVGTAVLA,TRISTD,SORTWK03,A316,VGTRT03,04210011,BGHY.GHYTRYED.WK03
 16.26.50 JOB00956  +ICE097I 1 BVGTAVLA.TRISTD   SORT RECOVERING FROM B37 ABEND ON SORTWK DATA SET
 16.26.51 JOB00956  V37027I PROGRAM USES EOV OR ABEND EXLST ON DCB
 16.26.51 JOB00956  V37027I ...SEE PIœ 601765 AND 601769 IN THE
 16.26.51 JOB00956  V37027I ...OPTIONAL MAINTENANCE APPENDIX IN USER'S GUIDE
 16.26.51 JOB00956  IEC030I B37-04,IFG0554A,BVGTAVLA,TRISTD,SORTWK04,A317,VGTRT04,04210011,BGHY.GHYTRYED.WK04
 16.26.51 JOB00956  +ICE097I 1 BVGTAVLA.TRISTD   SORT RECOVERING FROM B37 ABEND ON SORTWK DATA SET
 16.26.56 JOB00956  IEA995I SYMPTOM DUMP OUTPUT  976
    976               USER COMPLETION CODE=0046
    976              TIME=16.26.56  SEQ=20081  CPU=0000  ASID=01A6
    976              PSW AT TIME OF ERROR  078D1000   8731C288  ILC 2  INTC 0D
    976                NO ACTIVE MODULE FOUND
    976                NAME=UNKNOWN
    976                DATA AT PSW  0731C282 - B2600BA0  0A0D9188  DB504780
    976                AR/GR 0: 00000000/000070B0   1: 00000000/8000002E
    976                      2: 00000000/2833E200   3: 00000000/2833279C
    976                      4: 00000000/00000000   5: 00000000/00000000
    976                      6: 00000000/00000005   7: 00000000/0001F800
    976                      8: 00000000/07265E40   9: 00000000/87269190
    976                      A: 00000000/8731C288   B: 00000000/8731C028
    976                      C: 00000000/07268080   D: 00000000/00007000
    976                      E: 00000000/0000DD4B   F: 01000002/00000010
    976              END OF SYMPTOM DUMP
 16.26.57 JOB00956  IEF450I BVGTAVLA TRISTD - ABEND=S000 U0046 REASON=00000000  977
    977                     TIME=16.26.57
 16.26.58 JOB00956  IEF234E K 0DC2,249966,PVT,BVGTAVLA,TRISTD
 16.26.58 JOB00956  TMS014  IEF234E K 0DC2,249966,PVT,BVGTAVLA,TRISTD
 16.26.58 JOB00956  -                                         --TIMINGS (MINS.)--            ----PAGING COUNTS---
 16.26.58 JOB00956  -JOBNAME  STEPNAME PROCSTEP    RC   EXCP    CPU    SRB  CLOCK   SERV  PG   PAGE   SWAP    VIO SWAPS STEPNO
 16.26.58 JOB00956  -IEFACTRT          TRISTD   U0046   104K    .34    .01   8.85  5402K   0      0      0      0     0     1
 16.26.58 JOB00956  IEF404I BVGTAVLA - ENDED - TIME=16.26.58
 16.26.58 JOB00956  -BVGTAVLA ENDED.  NAME-SAM                  TOTAL CPU TIME=   .34  TOTAL ELAPSED TIME=  8.85
 16.26.58 JOB00956  $HASP395 BVGTAVLA ENDED
0------ JES2 JOB STATISTICS ------
-  16 OCT 2012 JOB EXECUTION DATE
-           60 CARDS READ
-          286 SYSOUT PRINT RECORDS
-            0 SYSOUT PUNCH RECORDS
-           19 SYSOUT SPOOL KBYTES
-         8.86 MINUTES EXECUTION TIME
        1 //BVGTAVLA JOB ,'SAM',MSGCLASS=X,CLASS=O,NOTIFY=BVGTAVL                 JOB00956
          //*SICAP SETVAR
          //* Commandes SET ajout‚es par exit EQQUX001 (D‚but)
        2 //     INCLUDE MEMBER=VERSIONS
       57 //TRISTD   EXEC PGM=SORT
       58 //SYSPRINT DD SYSOUT=*
       59 //SYSOUT   DD SYSOUT=*
       60 //SORTDIAG DD DUMMY
          //*
       61 //SORTWK01 DD DSN=BGHY.GHYTRYED.WK01,DISP=(NEW,CATLG,CATLG),
          //  SPACE=(CYL,(3000,100)),STORCLAS=SCREOR,VOL=SER=VGTRT01
       62 //SORTWK02 DD DSN=BGHY.GHYTRYED.WK02,DISP=(NEW,CATLG,CATLG),
          //  SPACE=(CYL,(3000,100)),STORCLAS=SCREOR,VOL=SER=VGTRT02
       63 //SORTWK03 DD DSN=BGHY.GHYTRYED.WK03,DISP=(NEW,CATLG,CATLG),
          //  SPACE=(CYL,(3000,100)),STORCLAS=SCREOR,VOL=SER=VGTRT03
       64 //SORTWK04 DD DSN=BGHY.GHYTRYED.WK04,DISP=(NEW,CATLG,CATLG),
          //  SPACE=(CYL,(3000,100)),STORCLAS=SCREOR,VOL=SER=VGTRT04
          //*
       65 //SORTIN DD DSN=BGHYMI.GHYTRYED.Q2861730.ENTURGE,DISP=(OLD,KEEP)
          //*
       66 //SORTOUT  DD DISP=(,CATLG,KEEP),
          //      DSN=&VVENVIR.OR.&VVQUAL2..Q&VVODDD.&VVOHHMM..ENTURGE.TRIE,
          //      UNIT=VTS2,VOL=(,,,20),LABEL=RETPD=3,
          //      RECFM=VB,LRECL=626,BLKSIZE=27544
          IEFC653I SUBSTITUTION JCL - DISP=(,CATLG,KEEP),DSN=BGHYOR.BTESTSB.Q2901701.ENTURGE.TRIE,UNIT=VTS2,VOL=(,,,20),
          LABEL=RETPD=3,RECFM=VB,LRECL=626,BLKSIZE=27544
       67 //SYSIN    DD *
  STMT NO. MESSAGE
         2 IEFC002I INCLUDE GROUP VERSIONS WAS EXPANDED USING SYSTEM LIBRARY CAXB.PROCLIB
 ICH70001I OPC      LAST ACCESS AT 16:15:06 ON TUESDAY, OCTOBER 16, 2012
 IEF236I ALLOC. FOR BVGTAVLA TRISTD
 IEF237I JES2 ALLOCATED TO SYSPRINT
 IEF237I JES2 ALLOCATED TO SYSOUT
 IEF237I DMY  ALLOCATED TO SORTDIAG
 IGD101I SMS ALLOCATED TO DDNAME (SORTWK01)
         DSN (BGHY.GHYTRYED.WK01                          )
         STORCLAS (SCREOR) MGMTCLAS (MCREOR) DATACLAS (PRODSEQ)
         VOL SER NOS= VGTRT01
 IGD101I SMS ALLOCATED TO DDNAME (SORTWK02)
         DSN (BGHY.GHYTRYED.WK02                          )
         STORCLAS (SCREOR) MGMTCLAS (MCREOR) DATACLAS (PRODSEQ)
         VOL SER NOS= VGTRT02
 IGD101I SMS ALLOCATED TO DDNAME (SORTWK03)
         DSN (BGHY.GHYTRYED.WK03                          )
         STORCLAS (SCREOR) MGMTCLAS (MCREOR) DATACLAS (PRODSEQ)
         VOL SER NOS= VGTRT03
 IGD101I SMS ALLOCATED TO DDNAME (SORTWK04)
         DSN (BGHY.GHYTRYED.WK04                          )
         STORCLAS (SCREOR) MGMTCLAS (MCREOR) DATACLAS (PRODSEQ)
         VOL SER NOS= VGTRT04
 IGD100I 0DC2 ALLOCATED TO DDNAME SORTIN
 IGD100I 0E53 ALLOCATED TO DDNAME SORTOUT
         STORCLAS (SCTAPV2) MGMTCLAS (        ) DATACLAS (DCTAP05)
 IEF237I JES2 ALLOCATED TO SYSIN
 V37027I PROGRAM USES EOV OR ABEND EXLST ON DCB
 V37027I ...SEE PIœ 601765 AND 601769 IN THE
 V37027I ...OPTIONAL MAINTENANCE APPENDIX IN USER'S GUIDE
 IEC030I B37-04,IFG0554A,BVGTAVLA,TRISTD,SORTWK01,A26E,VGTRT01,04210011,BGHY.GHYTRYED.WK01
 V37027I PROGRAM USES EOV OR ABEND EXLST ON DCB
 V37027I ...SEE PIœ 601765 AND 601769 IN THE
 V37027I ...OPTIONAL MAINTENANCE APPENDIX IN USER'S GUIDE
 IEC030I B37-04,IFG0554A,BVGTAVLA,TRISTD,SORTWK02,A26F,VGTRT02,04210011,BGHY.GHYTRYED.WK02
 V37027I PROGRAM USES EOV OR ABEND EXLST ON DCB
 V37027I ...SEE PIœ 601765 AND 601769 IN THE
 V37027I ...OPTIONAL MAINTENANCE APPENDIX IN USER'S GUIDE
 IEC030I B37-04,IFG0554A,BVGTAVLA,TRISTD,SORTWK03,A316,VGTRT03,04210011,BGHY.GHYTRYED.WK03
 V37027I PROGRAM USES EOV OR ABEND EXLST ON DCB
 V37027I ...SEE PIœ 601765 AND 601769 IN THE
 V37027I ...OPTIONAL MAINTENANCE APPENDIX IN USER'S GUIDE
 IEC030I B37-04,IFG0554A,BVGTAVLA,TRISTD,SORTWK04,A317,VGTRT04,04210011,BGHY.GHYTRYED.WK04
 IEA995I SYMPTOM DUMP OUTPUT
   USER COMPLETION CODE=0046
  TIME=16.26.56  SEQ=20081  CPU=0000  ASID=01A6
  PSW AT TIME OF ERROR  078D1000   8731C288  ILC 2  INTC 0D
    NO ACTIVE MODULE FOUND
    NAME=UNKNOWN
    DATA AT PSW  0731C282 - B2600BA0  0A0D9188  DB504780
    AR/GR 0: 00000000/000070B0   1: 00000000/8000002E
          2: 00000000/2833E200   3: 00000000/2833279C
          4: 00000000/00000000   5: 00000000/00000000
          6: 00000000/00000005   7: 00000000/0001F800
          8: 00000000/07265E40   9: 00000000/87269190
          A: 00000000/8731C288   B: 00000000/8731C028
          C: 00000000/07268080   D: 00000000/00007000
          E: 00000000/0000DD4B   F: 01000002/00000010
  END OF SYMPTOM DUMP
 IEF472I BVGTAVLA TRISTD - COMPLETION CODE - SYSTEM=000 USER=0046 REASON=00000000
 IEF285I   OPC.BVGTAVLA.JOB00956.D0000102.?             SYSOUT
 IEF285I   OPC.BVGTAVLA.JOB00956.D0000103.?             SYSOUT
 IGD104I BGHY.GHYTRYED.WK01                           RETAINED,  DDNAME=SORTWK01
 IGD104I BGHY.GHYTRYED.WK02                           RETAINED,  DDNAME=SORTWK02
 IGD104I BGHY.GHYTRYED.WK03                           RETAINED,  DDNAME=SORTWK03
 IGD104I BGHY.GHYTRYED.WK04                           RETAINED,  DDNAME=SORTWK04
 IEF285I   BGHYMI.GHYTRYED.Q2861730.ENTURGE             KEPT
 IEF285I   VOL SER NOS= 267615,249966,276749.
 IEF285I   OPC.BVGTAVLA.JOB00956.D0000101.?             SYSIN
 ************************************************************************************************************************************
 ****                                                                            TRISTD                                          ****
 ************************************************************************************************************************************
 IEF373I STEP/TRISTD  /START 2012290.1618
 IEF032I STEP/TRISTD  /STOP  2012290.1626
         CPU:     0 HR  00 MIN  20.53 SEC    SRB:     0 HR  00 MIN  00.85 SEC
         VIRT:  1176K  SYS:   312K  EXT:    56532K  SYS:    10532K
 ************************************************************************************************************************************
 ****                                                                            TRISTD                                          ****
 ************************************************************************************************************************************
 ************************************************************************************************************************************
 ****                                                                             Õ   Íö                                        ****
 ************************************************************************************************************************************
 IEF375I  JOB/BVGTAVLA/START 2012290.1618
 IEF033I  JOB/BVGTAVLA/STOP  2012290.1626
         CPU:     0 HR  00 MIN  20.53 SEC    SRB:     0 HR  00 MIN  00.85 SEC
 ************************************************************************************************************************************
 ****                                                                             Õ   Íö                                        ****
 ************************************************************************************************************************************
1ICE805I 1 JOBNAME: BVGTAVLA , STEPNAME: TRISTD
 ICE802I 0 BLOCKSET     TECHNIQUE IN CONTROL
 ICE905I 0 I : RF=80,LR=626,BLK=27544,BCT=834459
 ICE201I H RECORD TYPE IS V - DATA STARTS IN POSITION 5
 ICE992I 0 RA 0 WR 0 TR 0
 ICE751I 0 C5-K62149 C6-K90026 C7-K58148 C8-K67572 E9-K60824 C9-BASE   E5-K72040 E7-K70685
 ICE143I 0 BLOCKSET     SORT  TECHNIQUE SELECTED
 ICE250I 0 VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPERS, EXAMPLES AND MORE
 ICE000I 1 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R12 - 16:18 ON TUE OCT 16, 2012 -
0           SORT FIELDS=(24,3,CH,A)
            RECORD TYPE=VB,LENGTH=(622)
 ICE905I 0 I : RF=80,LR=626,BLK=27544,BCT=834459
 ICE201I H RECORD TYPE IS V - DATA STARTS IN POSITION 5
 ICE992I 0 RA 0 WR 0 TR 0
 ICE751I 0 C5-K62149 C6-K90026 C7-K58148 C8-K67572 E9-K60824 C9-BASE   E5-K72040 E7-K70685
 ICE074I 0 RECORD LENGTH L1 OR L3 OVERRIDDEN
 ICE193I 0 ICEAM1 INVOCATION ENVIRONMENT IN EFFECT - ICEAM1 ENVIRONMENT SELECTED
 ICE252I 1 PARMLIB OPTIONS WERE MERGED WITH INSTALLATION MODULE DEFAULTS
 ICE088I 0 BVGTAVLA.TRISTD  .        , INPUT LRECL = 626, BLKSIZE = 27544, TYPE = VB
 ICE093I 0 MAIN STORAGE = (MAX,57741705,57741705)
 ICE156I 0 MAIN STORAGE ABOVE 16MB = (57815417,57684345)
 ICE127I 0 OPTIONS: OVFLO=RC0 ,PAD=RC0 ,TRUNC=RC0 ,SPANINC=RC16,VLSCMP=N,SZERO=Y,RESET=Y,VSAMEMT=Y,DYNSPC=256
 ICE128I 0 OPTIONS: SIZE=57741705,MAXLIM=1048576,MINLIM=450560,EQUALS=Y,LIST=Y,ERET=ABEND,MSGDDN=SYSOUT
 ICE129I 0 OPTIONS: VIO=Y,RESDNT=ALL ,SMF=NO   ,WRKSEC=Y,OUTSEC=Y,VERIFY=N,CHALT=N,DYNALOC=N             ,ABCODE=MSG
 ICE130I 0 OPTIONS: RESALL=131072,RESINV=0,SVC=109 ,CHECK=Y,WRKREL=N,OUTREL=Y,CKPT=N,COBEXIT=COB2
 ICE131I 0 OPTIONS: TMAXLIM=8388608,ARESALL=131072,ARESINV=0,OVERRGN=65536,CINV=Y,CFW=Y,DSA=64
 ICE132I 0 OPTIONS: VLSHRT=Y,ZDPRINT=Y,IEXIT=N,TEXIT=N,LISTX=N,EFS=NONE    ,EXITCK=S,PARMDDN=DFSPARM ,FSZEST=N
 ICE133I 0 OPTIONS: HIPRMAX=OPTIMAL,DSPSIZE=MAX ,ODMAXBF=0,SOLRF=Y,VLLONG=N,VSAMIO=N,MOSIZE=MAX
 ICE235I 0 OPTIONS: NULLOUT=RC0
 ICE236I 0 OPTIONS: DYNAPCT=10 ,MOWRK=Y
 ICE084I 0 EXCP ACCESS METHOD USED FOR SORTOUT
 ICE084I 0 EXCP ACCESS METHOD USED FOR SORTIN
 ICE750I 0 DC 0 TC 22984338696 CS DSVRR KSZ 7 VSZ 7
 ICE752I 0 FSZ=22984338696 BC  IGN=0 E  AVG=317 0  WSP=30234210 C  DYN=0 0
 ICE915I 0 MOFSZ=0,MOSZ=0,MOSYS=0(5),MOSTG=0,MEML=3889(1)
 ICE916I 0 MOFR=0702,MOVR=RR
 ICE996I 0 ESM=1020672,ESO=1020672,ESR=0,ESP=4096,ESS=16384,CES=1020672,HSZ=524288
 ICE997I 0 HWSP=14207805,HMAX=0,HES=0,ASV=0,EQ=N0,HN=0
 ICE898I 0 OMAX=0,NMAX=0,ENQT=0,CMAX=0,HU=0,BUN=0,MD=N1,N1,DU=0,DR=0,HN=0
 ICE889I 0 CT=MAX     , SB=8, L=0, D=0000, CCW=1MAM
 ICE901I 0 W 01PP13 02PP13 03PP13 04PP13
 ICE902I 0 O JZ11  I JZ11
 ICE046A 0 SORT CAPACITY EXCEEDED - RECORD COUNT 73008343
 ICE253I 0 RECORDS SORTED - PROCESSED: 73008343, EXPECTED: 73432392
 ICE098I 0 AVERAGE RECORD LENGTH - PROCESSED: 198, EXPECTED: 313
 ICE751I 1 D8-K58148 D4-K59452 E8-K70685
 ICE052I 0 END OF DFSORT


samb01
 
Posts: 239
Joined: Mon Nov 16, 2009 7:24 pm
Has thanked: 0 time
Been thanked: 0 time

Re: dfsort with a big tape

Postby dick scherrer » Tue Oct 16, 2012 8:29 pm

Hello,

Then you need to provide more space . . .

Possibly there is something i am missing?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: dfsort with a big tape

Postby Akatsukami » Tue Oct 16, 2012 8:38 pm

samb01 wrote:There is B37 because the file is too big :

Take all the SORTWKnn statements out of your JCL. Add an OPTION FILSZ=E80000000 statement to your control deck.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1054
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: dfsort with a big tape

Postby skolusu » Tue Oct 16, 2012 11:05 pm

Samb01,

You are using 4 JCl sortwks with space=(cyl,(3000,100)) so the primary of 3000 cyls is about 2.5GB times 4 equals 10GB. Looking at ICE253I and ICE098I we see that 73,008,343 records were processed with avg length of 198 which equals roughly about 13.5GB . When the sortwks ran out of primary, they probably tried to get addtl extents and got B37 because no room on the volumes.

You have the following choices.

1. Code another 3 Sortwk with the same allocation space=(cyl,(3000,100))
2. You are allocating a primary of 3000 which is hard to find on a single volume, unless your shop has tons of DASD available. I suggest coding 12 Sortwks with space=(cyl,(1500,100)), so that they have better chance of finding volumes with enough space and getting additional extents

3.Alternatively you can get rid off the sortwk and let DFSORT calculate the amount of workspace needed. Add the following line in your control cards and remove the sortwks

  OPTION DYNALLOC=(,15)
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times

Re: dfsort with a big tape

Postby samb01 » Wed Oct 17, 2012 12:08 pm

Heelo, i tryed the option dynalloc, beacause i found it intersting but it dosen't work...

1                       J E S 2  J O B  L O G  --  S Y S T E M  B 0 1 1  --  N O D E  C A X B
0
 08.32.30 JOB00379 ---- WEDNESDAY, 17 OCT 2012 ----
 08.32.30 JOB00379  IRR010I  USERID OPC      IS ASSIGNED TO THIS JOB.
 08.32.30 JOB00379  ICH70001I OPC      LAST ACCESS AT 08:32:20 ON WEDNESDAY, OCTOBER 17, 2012
 08.32.30 JOB00379  $HASP373 BVfbtcv0A STARTED - INIT 42  - CLASS O - SYS B011
 08.32.30 JOB00379  IEF403I BVfbtcv0A - STARTED - TIME=08.32.30
 08.32.33 JOB00379  IEF233A M 0DCF,267615,,BVfbtcv0A,TRISTD,BGTCMI.BHGYTRED.Q2861730.ENTURGE
 08.32.33 JOB00379  IEF233A M 0DA4,PRIVAT,SL,BVfbtcv0A,TRISTD, 955
    955                     BGTCOR.BTESTSB.Q2901701.ENTURGE.TRIE
 08.32.34 JOB00379  V37027I PROGRAM USES EOV OR ABEND EXLST ON DCB
 08.32.34 JOB00379  V37027I ...SEE PIœ 601765 AND 601769 IN THE
 08.32.34 JOB00379  V37027I ...OPTIONAL MAINTENANCE APPENDIX IN USER'S GUIDE
 08.32.34 JOB00379  IEC030I B37-04,IFG0554A,BVfbtcv0A,TRISTD,SORTWK05,A24D,BPUB01,0427041D,SYS12291.T083234.RA000.BVfbtcv0A.R0423779
 08.32.34 JOB00379  +ICE097I 2 BVfbtcv0A.TRISTD  SORT RECOVERING FROM B37 ABEND ON SORTWK DATA SET
 08.32.34 JOB00379  V37027I PROGRAM USES EOV OR ABEND EXLST ON DCB
 08.32.34 JOB00379  V37027I ...SEE PIœ 601765 AND 601769 IN THE
 08.32.34 JOB00379  V37027I ...OPTIONAL MAINTENANCE APPENDIX IN USER'S GUIDE
 08.32.34 JOB00379  IEC030I B37-04,IFG0554A,BVfbtcv0A,TRISTD,SORTWK05,A24D,BPUB01,0427041D,SYS12291.T083234.RA000.BVfbtcv0A.R0423779
 08.32.34 JOB00379  +ICE097I 2 BVfbtcv0A.TRISTD  SORT RECOVERING FROM B37 ABEND ON SORTWK DATA SET
 08.32.35 JOB00379  IEA995I SYMPTOM DUMP OUTPUT  000
    000               USER COMPLETION CODE=0083
    000              TIME=08.32.35  SEQ=20609  CPU=0000  ASID=01CD
    000              PSW AT TIME OF ERROR  078D1000   00DC584C  ILC 2  INTC 0D
    000                NO ACTIVE MODULE FOUND
    000                NAME=UNKNOWN
    000                DATA AT PSW  00DC5846 - 41A0C75C  0A0D9602  D3CD9180
    000                AR/GR 0: A477C47A/00000000   1: 00000000/80000053
    000                      2: 00000000/00000053   3: 00000000/00DC57F6
    000                      4: 00000000/00000050   5: 00000000/00006427
    000                      6: 00000000/0000879C   7: 00000000/40DC8D7C
    000                      8: 00000000/00DC6100   9: 00000000/40DC90FC
    000                      A: 00000000/00DC585C   B: 00000000/00DC4100
    000                      C: 00000000/00DC5100   D: 00000000/00007000
    000                      E: 00000000/00DC57F4   F: 00000000/00000010
    000              END OF SYMPTOM DUMP
 08.32.35 JOB00379  IEF450I BVfbtcv0A TRISTD - ABEND=S000 U0083 REASON=00000000 001
    001                     TIME=08.32.35
 08.32.37 JOB00379  IEF234E K 0DCF,267615,PVT,BVfbtcv0A,TRISTD
 08.32.37 JOB00379  TMS014  IEF234E K 0DCF,267615,PVT,BVfbtcv0A,TRISTD
 08.32.37 JOB00379  -                                         --TIMINGS (MINS.)--            ----PAGING COUNTS---
 08.32.37 JOB00379  -JOBNAME  STEPNAME PROCSTEP    RC   EXCP    CPU    SRB  CLOCK   SERV  PG   PAGE   SWAP    VIO SWAPS STEPNO
 08.32.37 JOB00379  -IEFACTRT          TRISTD   U0083    327    .00    .00    .10   6858   0      0      0      0     0     1
 08.32.37 JOB00379  IEF404I BVfbtcv0A - ENDED - TIME=08.32.37
 08.32.37 JOB00379  -BVfbtcv0A ENDED. NAME-SAM                  TOTAL CPU TIME=   .00  TOTAL ELAPSED TIME=   .10
 08.32.37 JOB00379  $HASP395 BVfbtcv0A ENDED
0------ JES2 JOB STATISTICS ------
-  17 OCT 2012 JOB EXECUTION DATE
-           52 CARDS READ
-          267 SYSOUT PRINT RECORDS
-            0 SYSOUT PUNCH RECORDS
-           17 SYSOUT SPOOL KBYTES
-         0.10 MINUTES EXECUTION TIME
        1 //BVfbtcv0A JOB ,'SAM',MSGCLASS=X,CLASS=O,NOTIFY=BVfbtcv0               JOB00379
          //*SICAP SETVAR
          //* Commandes SET ajout‚es par exit EQQUX001 (D‚but)
        2 //     INCLUDE MEMBER=VERSIONS
          //* Commandes SET ajout‚es par exit EQQUX001 (Fin)
       57 //TRISTD   EXEC PGM=SORT
       58 //SYSPRINT DD SYSOUT=*
       59 //SYSOUT   DD SYSOUT=*
       60 //SORTDIAG DD DUMMY
          //*
       61 //SORTIN DD DSN=BGTCMI.BHGYTRED.Q2861730.ENTURGE,DISP=(OLD,KEEP)
          //*
       62 //SORTOUT  DD DISP=(,CATLG,KEEP),
          //      DSN=&VVENVIR.OR.&VVQUAL2..Q&VVODDD.&VVOHHMM..ENTURGE.TRIE,
          //      UNIT=VTS2,VOL=(,,,20),LABEL=RETPD=3,
          //      RECFM=VB,LRECL=626,BLKSIZE=27544
          IEFC653I SUBSTITUTION JCL - DISP=(,CATLG,KEEP),DSN=BGTCOR.BTESTSB.Q2901701.ENTURGE.TRIE,UNIT=VTS2,VOL=(,,,20),
          LABEL=RETPD=3,RECFM=VB,LRECL=626,BLKSIZE=27544
       63 //SYSIN    DD *
  STMT NO. MESSAGE
         2 IEFC002I INCLUDE GROUP VERSIONS WAS EXPANDED USING SYSTEM LIBRARY CAXB.PROCLIB
 ICH70001I OPC      LAST ACCESS AT 08:32:20 ON WEDNESDAY, OCTOBER 17, 2012
 IEF236I ALLOC. FOR BVfbtcv0A TRISTD
 IEF237I JES2 ALLOCATED TO SYSPRINT
 IEF237I JES2 ALLOCATED TO SYSOUT
 IEF237I DMY  ALLOCATED TO SORTDIAG
 IGD100I 0DCF ALLOCATED TO DDNAME SORTIN
 IGD100I 0DA4 ALLOCATED TO DDNAME SORTOUT
         STORCLAS (SCTAPV2) MGMTCLAS (        ) DATACLAS (DCTAP05)
 IEF237I JES2 ALLOCATED TO SYSIN
 IGD100I A24D ALLOCATED TO DDNAME SORTWK01 DATACLAS (        )
 IGD100I A24D ALLOCATED TO DDNAME SORTWK02 DATACLAS (        )
 IGD100I A24D ALLOCATED TO DDNAME SORTWK03 DATACLAS (        )
 IGD100I A24D ALLOCATED TO DDNAME SORTWK04 DATACLAS (        )
 IGD100I A24D ALLOCATED TO DDNAME SORTWK05 DATACLAS (        )
 IGD100I A24D ALLOCATED TO DDNAME SORTWK06 DATACLAS (        )
 IGD100I A24D ALLOCATED TO DDNAME SORTWK07 DATACLAS (        )
 IGD100I A24D ALLOCATED TO DDNAME SORTWK08 DATACLAS (        )
 IGD100I A24D ALLOCATED TO DDNAME SORTWK09 DATACLAS (        )
 IGD100I A24D ALLOCATED TO DDNAME SORTWK0A DATACLAS (        )
 IGD100I A24D ALLOCATED TO DDNAME SORTWK0B DATACLAS (        )
 IGD100I A24D ALLOCATED TO DDNAME SORTWK0C DATACLAS (        )
 IGD100I A24D ALLOCATED TO DDNAME SORTWK0D DATACLAS (        )
 IGD100I A24D ALLOCATED TO DDNAME SORTWK0E DATACLAS (        )
 IGD100I A24D ALLOCATED TO DDNAME SORTWK0F DATACLAS (        )
 IGD100I A24D ALLOCATED TO DDNAME SORTWK10 DATACLAS (        )
 V37027I PROGRAM USES EOV OR ABEND EXLST ON DCB
 V37027I ...SEE PIœ 601765 AND 601769 IN THE
 V37027I ...OPTIONAL MAINTENANCE APPENDIX IN USER'S GUIDE
 IEC030I B37-04,IFG0554A,BVfbtcv0A,TRISTD,SORTWK05,A24D,BPUB01,0427041D,SYS12291.T083234.RA000.BVfbtcv0A.R0423779
 V37027I PROGRAM USES EOV OR ABEND EXLST ON DCB
 V37027I ...SEE PIœ 601765 AND 601769 IN THE
 V37027I ...OPTIONAL MAINTENANCE APPENDIX IN USER'S GUIDE
 IEC030I B37-04,IFG0554A,BVfbtcv0A,TRISTD,SORTWK05,A24D,BPUB01,0427041D,SYS12291.T083234.RA000.BVfbtcv0A.R0423779
 IEF285I   SYS12291.T083234.RA000.BVfbtcv0A.R0423779    DELETED
 IEF285I   VOL SER NOS= BPUB01.
 IEF285I   SYS12291.T083234.RA000.BVfbtcv0A.R0423780    DELETED
 IEF285I   VOL SER NOS= BPUB01.
 IEF285I   SYS12291.T083234.RA000.BVfbtcv0A.R0423781    DELETED
 IEF285I   VOL SER NOS= BPUB01.
 IEF285I   SYS12291.T083234.RA000.BVfbtcv0A.R0423782    DELETED
 IEF285I   VOL SER NOS= BPUB01.
 IEF285I   SYS12291.T083234.RA000.BVfbtcv0A.R0423783    DELETED
 IEF285I   VOL SER NOS= BPUB01.
 IEF285I   SYS12291.T083234.RA000.BVfbtcv0A.R0423784    DELETED
 IEF285I   VOL SER NOS= BPUB01.
 IEF285I   SYS12291.T083234.RA000.BVfbtcv0A.R0423785    DELETED
 IEF285I   VOL SER NOS= BPUB01.
 IEF285I   SYS12291.T083234.RA000.BVfbtcv0A.R0423786    DELETED
 IEF285I   VOL SER NOS= BPUB01.
 IEF285I   SYS12291.T083234.RA000.BVfbtcv0A.R0423787    DELETED
 IEF285I   VOL SER NOS= BPUB01.
 IEF285I   SYS12291.T083234.RA000.BVfbtcv0A.R0423788    DELETED
 IEF285I   VOL SER NOS= BPUB01.
 IEF285I   SYS12291.T083234.RA000.BVfbtcv0A.R0423789    DELETED
 IEF285I   VOL SER NOS= BPUB01.
 IGD100I A24E ALLOCATED TO DDNAME SORTWK05 DATACLAS (        )
 IEA995I SYMPTOM DUMP OUTPUT
   USER COMPLETION CODE=0083
  TIME=08.32.35  SEQ=20609  CPU=0000  ASID=01CD
  PSW AT TIME OF ERROR  078D1000   00DC584C  ILC 2  INTC 0D
    NO ACTIVE MODULE FOUND
    NAME=UNKNOWN
    DATA AT PSW  00DC5846 - 41A0C75C  0A0D9602  D3CD9180
    AR/GR 0: A477C47A/00000000   1: 00000000/80000053
          2: 00000000/00000053   3: 00000000/00DC57F6
          4: 00000000/00000050   5: 00000000/00006427
          6: 00000000/0000879C   7: 00000000/40DC8D7C
          8: 00000000/00DC6100   9: 00000000/40DC90FC
          A: 00000000/00DC585C   B: 00000000/00DC4100
          C: 00000000/00DC5100   D: 00000000/00007000
          E: 00000000/00DC57F4   F: 00000000/00000010
  END OF SYMPTOM DUMP
 IEF472I BVfbtcv0A TRISTD - COMPLETION CODE - SYSTEM=000 USER=0083 REASON=00000000
 IEF285I   OPC.BVfbtcv0A.JOB00379.D0000102.?            SYSOUT
 IEF285I   OPC.BVfbtcv0A.JOB00379.D0000103.?            SYSOUT
 IEF285I   BGTCMI.BHGYTRED.Q2861730.ENTURGE             KEPT
 IEF285I   VOL SER NOS= 267615,249966,276749.
 IEF285I   OPC.BVfbtcv0A.JOB00379.D0000101.?            SYSIN
 IEF285I   SYS12291.T083234.RA000.BVfbtcv0A.R0423775    DELETED
 IEF285I   VOL SER NOS= BPUB01.
 IEF285I   SYS12291.T083234.RA000.BVfbtcv0A.R0423776    DELETED
 IEF285I   VOL SER NOS= BPUB01.
 IEF285I   SYS12291.T083234.RA000.BVfbtcv0A.R0423777    DELETED
 IEF285I   VOL SER NOS= BPUB01.
 IEF285I   SYS12291.T083234.RA000.BVfbtcv0A.R0423778    DELETED
 IEF285I   VOL SER NOS= BPUB01.
 IEF285I   SYS12291.T083234.RA000.BVfbtcv0A.R0423790    DELETED
 IEF285I   VOL SER NOS= BPUB01.
 IEF285I   SYS12291.T083234.RA000.BVfbtcv0A.R0423791    DELETED
 IEF285I   VOL SER NOS= BSTG01.
 ************************************************************************************************************************************
 ****                                                                            TRISTD                                          ****
 ************************************************************************************************************************************
 IEF373I STEP/TRISTD  /START 2012291.0832
 IEF032I STEP/TRISTD  /STOP  2012291.0832
         CPU:     0 HR  00 MIN  00.10 SEC    SRB:     0 HR  00 MIN  00.00 SEC
         VIRT:  1180K  SYS:   376K  EXT:    56532K  SYS:    11204K
 ************************************************************************************************************************************
 ****                                                                            TRISTD                                          ****
 ************************************************************************************************************************************
 ************************************************************************************************************************************
 ****                                                                             Õ   Íö                                        ****
 ************************************************************************************************************************************
 IEF375I  JOB/BVfbtcv0A/START 2012291.0832
 IEF033I  JOB/BVfbtcv0A/STOP 2012291.0832
         CPU:     0 HR  00 MIN  00.10 SEC    SRB:     0 HR  00 MIN  00.00 SEC
 ************************************************************************************************************************************
 ****                                                                             Õ   Íö                                        ****
 ************************************************************************************************************************************
1ICE805I 1 JOBNAME: BVfbtcv0A , STEPNAME: TRISTD
 ICE802I 0 BLOCKSET     TECHNIQUE IN CONTROL
 ICE905I 0 I : RF=80,LR=626,BLK=27544,BCT=834459
 ICE201I H RECORD TYPE IS V - DATA STARTS IN POSITION 5
 ICE083A D RESOURCES WERE UNAVAILABLE FOR DYNAMIC ALLOCATION OF WORK DATA SETS (0218)
 ICE753I 0 FWK=(4,145704) SWK=(0,0) TWK=(1,36426) RWK=(0,0) TOTAL=(5,182130) BLK=56664
 ICE248I 0 ATTEMPTED TO ALLOCATE 29525MB OF DISK WORK SPACE ON 15 WORK DATA SETS
 ICE249I 0 SUCCESSFULLY ALLOCATED 9842MB OF DISK WORK SPACE ON 5 WORK DATA SETS
 ICE751I 0 C5-K62149 C6-K90026 C7-K58148 C8-K67572 E9-K60824 C9-BASE   E5-K72040 E6-K58148 C4-K58148 E7-K70685
 ICE750I 0 DC 0 TC 22984338696 CS DSVRR KSZ 7 VSZ 7
 ICE752I 0 FSZ=22984338696 BC  IGN=0 E  AVG=317 0  WSP=30234210 C  DYN=182130 56664
 ICE143I 0 BLOCKSET     SORT  TECHNIQUE SELECTED
 ICE250I 0 VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPERS, EXAMPLES AND MORE
 ICE000I 1 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R12 - 08:32 ON WED OCT 17, 2012 -
0           SORT FIELDS=(24,3,CH,A)
            RECORD TYPE=VB,LENGTH=(622)
            OPTION DYNALLOC=(,15)
 ICE905I 0 I : RF=80,LR=626,BLK=27544,BCT=834459
 ICE201I H RECORD TYPE IS V - DATA STARTS IN POSITION 5
 ICE083A D RESOURCES WERE UNAVAILABLE FOR DYNAMIC ALLOCATION OF WORK DATA SETS (0218)
 ICE753I 0 FWK=(4,145704) SWK=(0,0) TWK=(1,36426) RWK=(0,0) TOTAL=(5,182130) BLK=56664
 ICE248I 0 ATTEMPTED TO ALLOCATE 29525MB OF DISK WORK SPACE ON 15 WORK DATA SETS
 ICE249I 0 SUCCESSFULLY ALLOCATED 9842MB OF DISK WORK SPACE ON 5 WORK DATA SETS
 ICE751I 0 C5-K62149 C6-K90026 C7-K58148 C8-K67572 E9-K60824 C9-BASE   E5-K72040 E6-K58148 C4-K58148 E7-K70685
 ICE750I 0 DC 0 TC 22984338696 CS DSVRR KSZ 7 VSZ 7
 ICE752I 0 FSZ=22984338696 BC  IGN=0 E  AVG=317 0  WSP=30234210 C  DYN=182130 56664
 ICE052I 3 END OF DFSORT



I'm going to try the other solutions you proposed. Thank's skolusu for your help.
samb01
 
Posts: 239
Joined: Mon Nov 16, 2009 7:24 pm
Has thanked: 0 time
Been thanked: 0 time

Re: dfsort with a big tape

Postby BillyBoyo » Wed Oct 17, 2012 12:29 pm

 ICE083A D RESOURCES WERE UNAVAILABLE FOR DYNAMIC ALLOCATION OF WORK DATA SETS (0218)
 ICE753I 0 FWK=(4,145704) SWK=(0,0) TWK=(1,36426) RWK=(0,0) TOTAL=(5,182130) BLK=56664
 ICE248I 0 ATTEMPTED TO ALLOCATE 29525MB OF DISK WORK SPACE ON 15 WORK DATA SETS
 ICE249I 0 SUCCESSFULLY ALLOCATED 9842MB OF DISK WORK SPACE ON 5 WORK DATA SETS


It didn't "not work" as such. If you look back at Kolusu's calculation, it is trying to allocate far more than estimated to be needed. Why have you coded LENGTH=?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post