Hilario Garcia wrote:
>I need to extract some data from SMF type 30. The info are:
>Userid
>Jobname
>Count (by Jobname on an expecific month)
>I had tried using IBM Dfsort, but I can't get the number of a specific jobname
>on a user and on one month. I need this information:
Try this fun ICETOOL job, (it does not exactly give you the output with the
USERID and your intended format), but you can try this out and modify it:
//***************************************************************
//** EXTRACT SMF RECORDS type 30 subtype 5
//***************************************************************
//SMF30 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//VLSHCNTL DD *
OPTION COPY,VLSHRT
INCLUDE COND=(6,1,CH,EQ,X'1E',AND,
178,1,CH,EQ,X'05')
/*
//RAWSMF DD DISP=SHR,DSN=?
//SORTSMF DD DISP=(NEW,DELETE,DELETE),SPACE=(CYL,(50,50,0))
//VREPT DD SYSOUT=*
//PRINT DD SYSOUT=*
//TOOLIN DD * CONTROL STATEMENTS
SORT FROM(RAWSMF) TO(SORTSMF) USING(VLSH)
DISPLAY FROM(SORTSMF) LIST(VREPT) -
HEADER('SMFTYP') ON(6,1,BI) -
HEADER('DATE') ON(11,4,DT1,E'9999/99/99') -
HEADER('TIME') ON(7,4,TM1,E'99:99:99') -
HEADER('SYSTEM') ON(15,4,CH) -
HEADER('JOBNAME') ON(215,8,CH)
OCCURS FROM(SORTSMF) LIST(PRINT) -
PAGE -
TITLE('TEST ')-
DATE(4MD/) -
TIME(24:) -
BLANK -
ON(15,4,CH) HEADER('SYS') -
ON(215,8,CH) HEADER('JOBNAME') -
ON(VALCNT) HEADER('COUNT')
Output for the count part:
- 1 - TEST 2016/02/04
SYS JOBNAME COUNT
---- -------- ---------------
???? ABCDE 1
???? ABCDEFG 4
I will see if I can get a sample with the userid... (but you could change the
SYSID with USERID in above example)
HTH!
Groete / Greetings
Elardus Engelbrecht
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
