Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
rahulbank wrote:
Hi Peter, I totally agree with you this new environment has sas but for some reaons does not have DCDDSNAM or anything like that...I have worked on sas and I agree with you....That is why I am tying this through dcollect which is totally an unknown monster to me...
Huh? I dont understand. DCDDSNAM is a fieldname used in the
IBM DCOLLECT output description.
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
expat wrote:
Oh well, old dogs, new tricks .....................................
Im also an old dog, but i dont think its a new trick.
Right now im looking at a MXG SAS macro from 1994 for
DCOLLECT data processing.
Looking at that year im feeling very old indeed.
Sorry Peter for my negligence you are right. I ran this program just as a sample:
//JS10 EXEC SAS
//SASLIST DD SYSOUT=*
//PDB DD DSN=CDPS1C.DCOLLECT.DATA4,DISP=SHR
//SYSIN DD *
PROC SORT DATA=PDB.DCOLDSET OUT=TEMP;
BY DCDDSNAM;
DATA TEMP1;
SET TEMP;
DSN=SUBSTR(DCDDSNAM,1,3);
IF(DSN NE 'LMX')
THEN DELETE;
RUN;
PROC PRINT DATA=TEMP1;
Here CDPS1C.DCOLLECT.DATA4 is the o/p of dcollect job
It says:
ERROR: Library PDB is not in a valid format for access method SASE7.
ERROR: Library PDB is not in a valid format for access method SASE7.
ERROR: Library PDB is not in a valid format for access method SASE7.
2 BY DCDDSNAM;
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
You need to run MXG against the DCOLLECT input data set to create the PDB before you attempt to reference the PDB data fields. Check the MXG.??.SOURCLIB members ADOCDCOL and TYPEDCOL for details.
And was able to generate the report showing DSN's and their mgmtclass perfectly.
I read the appendix F in IDCAMs book and realized 5 needs to be added to every para(I mean DSN was 24(29 in JCL) and mgmtclass was 112(19 in jcl as u can see))..
Then I tried the same with ref date it gives some symbols...Can anyone please guide on how to get date their in o/p is ther some para which needs to be added as it a date..
If you have FDR this will give you a formatted report of what your require:
NOTE: If you run the same JCL with just XHELP ALL in the sysin it will print the full manual for FDREPORT.
//FDREPORT EXEC PGM=FDREPORT,REGION=32M
//SYSPRINT DD SYSOUT=0
//SYSOUT DD SYSOUT=0
//SYSUDUMP DD SYSOUT=0
//ABRMAP DD SYSOUT=*
//ABRSUM DD SYSOUT=0
//SORTLIB DD DSN=SYS1.SORTLIB,DISP=SHR
//SYSIN DD *
TITLE LINE='REPORT DATASETS BY HLQ THEN SIZE DESCENDING **'
REPORT FIELD=(NAME, * DATASET OR CLUSTER NAME
SIZE, * SIZE ALLOCATED IN TRKS
SIZEUSED, * SIZE USED IN TRKS
CAPBYTES, * SIZE ALLOC BYTES (OR KB,MB,TB)
DSORG) * DSORG
XS XDSN=HLQ.**
SORT FIELD=(NAME,SIZE),SEQ=(A,D,D)
SUMM FIELD=(SIZE,SIZEUSED,CAPBYTES)
PRINT SORT=COMBINE,SUM=YES, * SORT AND GIVE SUMMARY TOTAL
RPTYPE=TABLE, * CREATE TABULAR REPORT
DATATYPE=CATVTOC, * SOURCE FROM CATLG THEN VTOC
RECORDSUMMARY=CLUSTER, * COMBINE MULTI-VOL FILES RPT
ENABLE=(FASTPATH,AIXCLUSTER), * REPORT AIX'S SEPARATELY
BYTEFORMAT=MEGA, * RPT CAPBYTES IN MB
SUMBYTEFORMAT=MEGA * SUMMARY RPT IN MB
