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
 

 

Need ICETOOL JOB to collect SMF records and generate report

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

New User


Joined: 26 Mar 2008
Posts: 35
Location: Chennai

PostPosted: Thu Nov 13, 2008 1:14 am    Post subject: Need ICETOOL JOB to collect SMF records and generate report
Reply with quote

Hi,
I need ICETOOL job which collects SMF 30,80,81,82 and 83 record types and generate RACF report.

For example, Report should contains the information about "Commands issued by SPECIAL users" or "Resources access by SPECIAL users" .

Kindly help me in this.
Back to top
View user's profile Send private message

Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Thu Nov 13, 2008 1:26 am    Post subject:
Reply with quote

Siva S,

Check the smart DFSORT trick "RACF "SPECIAL" report with and without DFSORT symbols" here

http://www.ibm.com/systems/support/storage/software/sort/mvs/tricks/index.html

Hope this helps...

Cheers
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Thu Nov 13, 2008 1:57 am    Post subject:
Reply with quote

Here are some other sources for RACF reports using DFSORT's ICETOOL:

RACFICE:

http://www.ibm.com/servers/eserver/zseries/zos/racf/downloads/racfice.html

Nigel Pentland's utilities:

http://www.nigelpentland.co.uk/racf/
Back to top
View user's profile Send private message
Siva S

New User


Joined: 26 Mar 2008
Posts: 35
Location: Chennai

PostPosted: Thu Nov 13, 2008 3:58 am    Post subject: Reply to: Need ICETOOL JOB to collect SMF records and genera
Reply with quote

Dear Skolusu, Frank and Dick,
Thank you for your replies.

Now I am facing errors while using the ICETOOL job. So, hereby I am attaching the TOOLMSG and DFSMSG,

TOOLMSG:

Code:

           COPY    FROM(ADUDATA) USING(RACF)                                   
ICE606I 0 DFSORT CALL 0001 FOR COPY FROM ADUDATA  TO OUTFIL   USING RACFCNTL TERMINATED
ICE602I 0 OPERATION RETURN CODE:  16             

ICE643I 0 WIDTH OF REPORT IS 0129 BYTES                       
ICE612I 0 NO ERRORS FOUND IN STATEMENT                         
                                                               
ICE601I 0 DFSORT ICETOOL UTILITY RUN ENDED - RETURN CODE:16


DFSMSG:

Code:

           SORT FIELDS=(63,8,CH,A)                                             
           INCLUDE COND=(5,8,CH,EQ,C'ACCESS',AND,                               
                         86,3,CH,EQ,C'YES')                                     
           OPTION VLSHRT                                                       
ICE146I J END OF STATEMENTS FROM RACFCNTL - PARAMETER LIST STATEMENTS FOLLOW   
          DEBUG NOABEND,ESTAE                                                   
          OPTION MSGDDN=DFSMSG,LIST,MSGPRT=ALL,RESINV=0,SORTDD=RACF,SORTIN=ADUDA
                         A,DYNALLOC                                             
          SORT FIELDS=COPY                                                     
ICE201I J RECORD TYPE IS V - DATA STARTS IN POSITION 5                         
ICE056A N RACFOUT  NOT DEFINED                                                 
ICE052I J END OF DFSORT


In the DFSMSG, It is showing that RACFOUT not defined. Is that error? what it means?

Please help me out in this.
Thanks in advance.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Thu Nov 13, 2008 4:04 am    Post subject:
Reply with quote

It means you haven't specified the ddname for your output data set. You didn't show your JCL, so I don't know what it looks like or what if anything you have for the output DD.

I don't know where you got that particular ICETOOL job but it appears you didn't copy it correctly. Did it by any chance have an OUTFIL statement that you didn't copy? If so, you need to include that OUTFIL statement. If there was no OUTFIL statement, then:

You should have a TO(ddname) parameter:

COPY FROM(ADUDATA) TO(todd) USING(RACF)

and a

//todd DD DSN=...

for the output data set. todd can be any valid ddname, e.g.

TO(RPT)

//RPT DD SYSOUT=*
Back to top
View user's profile Send private message
Siva S

New User


Joined: 26 Mar 2008
Posts: 35
Location: Chennai

PostPosted: Thu Nov 13, 2008 6:20 am    Post subject: Reply to: Need ICETOOL JOB to collect SMF records and genera
Reply with quote

Hi Frank,
Thank for your input. I coded the JCL with TO parameter, Now Jobs works fine, but the it generates nothing in the output.

JCL is the following,

Code:

//REPORT   EXEC PGM=ICETOOL                                       
//SMFDATA  DD DISP=SHR,DSN=A202191.SMF.UNLOAD,RECFM=VB,           
//            LRECL=8192,BLKSIZE=27998                           
//TEMP0001 DD DISP=(NEW,DELETE,DELETE),SPACE=(0,(1000,350)),     
//            LRECL=8192,RECFM=VB                                 
//TEMP0002 DD DISP=(NEW,DELETE,DELETE),SPACE=(0,(1000,350)),     
//            LRECL=8192,RECFM=VB                                 
//TEMP0003 DD DISP=(NEW,DELETE,DELETE),SPACE=(0,(1000,350)),     
//            LRECL=8192,RECFM=VB                                 
//TOOLMSG  DD SYSOUT=*                                           
//PRINT    DD SYSOUT=(A,,STD),HOLD=YES  ,DEST=U0022               
//DFSMSG   DD SYSOUT=*                                           
//SYSPRINT DD SYSOUT=*                                           
//SYSMSG   DD SYSOUT=*                                           
//SYSOUT   DD SYSOUT=*                                           
//TOOLIN   DD *                                                       
 COPY    FROM(SMFDATA) TO(TEMP0001) USING(RACF)                     
 DISPLAY FROM(TEMP0001) LIST(PRINT) -                               
        PAGE -                                                     
         TITLE('ACCESSES ALLOWED BECAUSE THE USER HAS "SPECIAL"') -
         DATE(YMD/) -                                               
         TIME(12:) -                                               
         BLANK -                                                   
         ON(VLEN) HEADER('VLEN')               -                   
         ON(23,8,CH)   HEADER('TIME')          -                   
         ON(32,10,CH)  HEADER('DATE')          -                   
         ON(63,8,CH)   HEADER('USERID')        -                   
         ON(286,36,CH) HEADER('RESOURCE NAME') -                   
         ON(564,6,CH)  HEADER('VOLUME')        -                   
         ON(605,36,CH) HEADER('PROFILE')                           
*                                                                   
/*------------------------------------------------------------------
//RACFCNTL DD *                       
 SORT FIELDS=(63,8,CH,A)               
 INCLUDE COND=(5,8,CH,EQ,C'ACCESS',AND,
               86,3,CH,EQ,C'YES')     
 OPTION VLSHRT VLLONG VLTRIM=C''       
/*     


and the output of the same is,

********************************* TOP OF DATA **********************************
- 1 - ACCESSES ALLOWED BECAUSE THE USER HAS "SPECIAL" 08/11/13

VLEN TIME DATE USERID RESOURCE NAME
------ -------- ---------- -------- ------------------------------------
******************************** BOTTOM OF DATA ********************************

Kindly help me.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Thu Nov 13, 2008 6:56 am    Post subject:
Reply with quote

Quote:
but the it generates nothing in the output


Then I suspect your INCLUDE statement is eliminating all of the records.

Make sure you counted the RDW when determining the starting positions of the fields (the first data bytes starts in position 5 after the RDW) and
try using VLSCMP instead of VLSHRT.

If that doesn't do it, show your complete //DFSMSG output.

Can you tell me where exactly you got this job? I see some problems with it and I'd like to contact the owner about that.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Nov 13, 2008 7:13 am    Post subject:
Reply with quote

Hello,

Quote:
Then I suspect your INCLUDE statement is eliminating all of the records
.
Possibly because of this? 5,8,CH,EQ,C'ACCESS'
The length specifies 8, but the literal is only 6. I'm not sure about sort, but this type compare generates an unequal in some languages/situations.
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Thu Nov 13, 2008 11:29 am    Post subject:
Reply with quote

Hi Dick,

my tests reveal that SORT pads the string out with blanks.



Gerry
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Thu Nov 13, 2008 10:46 pm    Post subject:
Reply with quote

Yes, the constant would be padded on the right with blanks to the length of the field.
Back to top
View user's profile Send private message
Siva S

New User


Joined: 26 Mar 2008
Posts: 35
Location: Chennai

PostPosted: Fri Nov 14, 2008 2:20 am    Post subject: Reply to: Need ICETOOL JOB to collect SMF records and genera
Reply with quote

Hi All,

Now my job is working fine and able to generate the desired output.

Really thank Dick, Frank, Skolusu and gcicchet for all your support.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Nov 14, 2008 2:56 am    Post subject: Reply to: Need ICETOOL JOB to collect SMF records and genera
Reply with quote

Hello,

Quote:
Now my job is working fine and able to generate the desired output.
Good to hear this icon_smile.gif

What was changed to make it work?

d
Back to top
View user's profile Send private message
Siva S

New User


Joined: 26 Mar 2008
Posts: 35
Location: Chennai

PostPosted: Fri Nov 14, 2008 3:09 am    Post subject: Reply to: Need ICETOOL JOB to collect SMF records and genera
Reply with quote

Hi Dick,
The problem is with SORT column numbers. Actually I have copied that JOB from the net, in that I have modified the column numbers accordingly, so it is working fine.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Nov 14, 2008 3:12 am    Post subject: Reply to: Need ICETOOL JOB to collect SMF records and genera
Reply with quote

Thank you icon_smile.gif

d
Back to top
View user's profile Send private message
Siva S

New User


Joined: 26 Mar 2008
Posts: 35
Location: Chennai

PostPosted: Sat Nov 15, 2008 4:15 am    Post subject: Reply to: Need ICETOOL JOB to collect SMF records and genera
Reply with quote

Hi,
I need another clarification. From the SMF Unload utility, I have the data instantly looks like the following(without any header information),

ACCESS SUCCESS 12:34:43 2008-11-12 ADS1 NO NO NO
ACCESS SUCCESS 12:34:48 2008-11-12 ADS1 NO NO NO
ACCESS SUCCESS 12:34:49 2008-11-12 ADS1 NO NO NO

Can you please let me know, Is there any possiblities to know each column description?

Example: In my analysis,
First Colunm: Access or Commands issued.
Second Column: Gives status of the resource access either SUCCESS or TERM or UNDFUSER or INSAUTH.
Third Column: Represents the TIME of resource access.
Fourth Column: Date.
Fifth Column: LPAR Name.

I can identify the various columns like the above. But I am not able to identify YES or NO of various columns.

Kindly help me in this. Thanks in advance.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Nov 15, 2008 4:39 am    Post subject:
Reply with quote

Hello,

You might look here:
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/IEA2G261/CCONTENTS?
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 Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts How to split the records using the am... vnktrrd DFSORT/ICETOOL 24 Fri Oct 28, 2016 7:33 pm
No new posts Sort records based on numeric field. Alks SYNCSORT 2 Wed Oct 19, 2016 10:14 pm
No new posts How to delete second instance from Fl... Gunapala CN DFSORT/ICETOOL 6 Tue Oct 18, 2016 11:42 pm
No new posts Detailed Transaction History report f... Kyle Carroll CICS 5 Tue Oct 18, 2016 12:42 am


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