Anyone using DSNUTILS Stored Procedure

Scott Goodell

Anyone using DSNUTILS Stored Procedure
I have been attempting to use the DSNUTILS stored procedure to run a RUNSTATS
utility on DB2 V6 for OS390. The documentation is rather limited on this and
the WLM address space received an S0C1 abend with an error indicating no SYSIN
was allocated. According to the doc this is supposed to be allocated by the
DSNUTILS procedure. There is another small paragraph of doc that mentions
needing SYSUT1 and SYSPRINT DDs in the WLM JCL but does not explain how to
allocate them. Has anyone done this and if so can you supply your WLM DD
definitions for these DDs?

Thanks
Scott



David Booher

Re: Anyone using DSNUTILS Stored Procedure
(in response to Scott Goodell)
I would be interested also. Scott is right, the IBM manuals do not show any
examples of what additions should be made to the WLM started task.

Dave Booher
Systems Programmer
Quest Software


-----Original Message-----
From: Scott Goodell [mailto:[login to unmask email]
Sent: Thursday, December 21, 2000 3:22 PM
To: [login to unmask email]
Subject: Anyone using DSNUTILS Stored Procedure


I have been attempting to use the DSNUTILS stored procedure to run a
RUNSTATS
utility on DB2 V6 for OS390. The documentation is rather limited on this
and
the WLM address space received an S0C1 abend with an error indicating no
SYSIN
was allocated. According to the doc this is supposed to be allocated by the
DSNUTILS procedure. There is another small paragraph of doc that mentions
needing SYSUT1 and SYSPRINT DDs in the WLM JCL but does not explain how to
allocate them. Has anyone done this and if so can you supply your WLM DD
definitions for these DDs?

Thanks
Scott





Jeff Faughn

Re: Anyone using DSNUTILS Stored Procedure
(in response to David Booher)
This PROC works for us:

//SSIDWLM PROC RGN=0K,APPLENV=WLMyours,DB2SSN=your SSID,NUMTCB=1
//IEFPROC EXEC PGM=DSNX9WLM,REGION=&RGN,TIME=NOLIMIT,
// PARM='&DB2SSN,&NUMTCB,&APPLENV'
//STEPLIB DD DISP=SHR,DSN=your.LOAD
//SYSIN DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)
//SYSPRINT DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)
//UTPRINT DD SYSOUT=*
//CEEDUMP DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSMDUMP DD SYSOUT=*




Scott Goodell
<scott.goodell To: [login to unmask email]
@WCOM.COM> cc:
Sent by: DB2 Subject: Anyone using DSNUTILS Stored
Data Base Procedure
Discussion
List
<[login to unmask email]
M>


12/21/00 03:21
PM
Please respond
to DB2 Data
Base
Discussion
List






I have been attempting to use the DSNUTILS stored procedure to run a
RUNSTATS
utility on DB2 V6 for OS390. The documentation is rather limited on this
and
the WLM address space received an S0C1 abend with an error indicating no
SYSIN
was allocated. According to the doc this is supposed to be allocated by
the
DSNUTILS procedure. There is another small paragraph of doc that mentions
needing SYSUT1 and SYSPRINT DDs in the WLM JCL but does not explain how to
allocate them. Has anyone done this and if so can you supply your WLM DD
definitions for these DDs?

Thanks
Scott