SYSVIEW Performance Management

 View Only
  • 1.  Error from CSV utility

    Posted Apr 07, 2021 12:55 PM
      |   view attached
    i am running the Report Writer using the IMS Transaction Log as input.  The Report Writer runs okay and then I run the CSV utility, CSVGEN, and I receive the following error.   I have attached the RWO dataset output.

    READY
    CSVGEN CSVIN CSVOUT VS=; DS=,
    No reports found.
    Sorry, this report can't be parsed.

    READY
    END

    The JCL is as follows:
    //REPORT EXEC PGM=XPFRMAIN,REGION=4M
    //ERPTPRM DD DISP=SHR,DSN=SYSNZR.SYSVIEW.SAMPJCL
    //SYSUDUMP DD SYSOUT=*
    //SYSPRINT DD DSN=$64159.TEMP.EXPRPT,
    // DISP=(NEW,CATLG,DELETE),
    // DCB=(RECFM=FB,LRECL=1024),
    // SPACE=(CYL,(10,5))
    //TAPSMF DD DISP=SHR,DSN=SYSVIEW.IMSLOGR.IMTR.NASC,
    // SUBSYS=(LOGR,GSVXLGEX,
    // 'FROM=OLDEST,TO=YOUNGEST,LOCAL',
    // 'STATS,EXPAND,BACKWARD,NORDW'),
    // DCB=(DSORG=PS,RECFM=VB,LRECL=32756,BLKSIZE=32760)
    //SYSIN DD *
    OPTION(COPYRIGHT=NO,DATAONLY=NO,RPTSTAT=NO,RECSTAT=NO,MAXTO=NO,ECHO=NO)
    SELECT LTERM(*)
    FLASHBACK IMS
    FROM -1 DAYS
    TO -1 DAYS
    END
    RUN
    /*
    //PARSE EXEC PGM=IKJEFT01
    //SYSEXEC DD DISP=SHR,DSN=SYSNZR.SYSVIEW.CNM4RSAM
    //SYSTSPRT DD SYSOUT=*
    //RWO DD SYSOUT=*,DCB=(RECFM=FB,LRECL=1024)
    //CSVIN DD DISP=SHR,DSN=$64159.TEMP.EXPRPT
    //CSVOUT DD SYSOUT=*,DCB=(RECFM=FB,LRECL=1024)
    //SYSTSIN DD *
    CSVGEN CSVIN CSVOUT VS=; DS=,
    /*


    Attachment(s)

    txt
    RWO.txt   18.02 MB 1 version


  • 2.  RE: Error from CSV utility

    Broadcom Employee
    Posted Apr 08, 2021 04:12 AM

    Hi Patrick,
    I've checked and could you please remove the ECHO=NO from the OPTION statement and rerun the job..
    It seems there is an issue with this parameter when it's on the OPTION statement... 

    The CSVGEN utility scanning the Report Writer output for words that appear in a specific location. 
    It could be by using the ECHO=NO option it's missing these words...

    Best regards

    Hennie Hermans



    ------------------------------
    Principal Support Engineer
    CA Technologies, A Broadcom Company
    ------------------------------