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?
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
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.
********************************* TOP OF DATA **********************************
- 1 - ACCESSES ALLOWED BECAUSE THE USER HAS "SPECIAL" 08/11/13
VLEN TIME DATE USERID RESOURCE NAME
------ -------- ---------- -------- ------------------------------------
******************************** BOTTOM OF DATA ********************************
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
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.
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
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.
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.
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.