Adhoc reporting for cicstran using SMF 110 CICS records and SAS on remote PC

Arju1 — Thu, 13 May 2021 07:36:31 GMT

I need to get an adhoc CICSTRAN report from SMF 110 data. We have moved SAS to a pc and are using FTP to transfer data. We have a PDB which is refreshed daily and contains only WLM/SMF30/TCPIP data due to space problems.

I have tried:

options source;
filename smf ftp
"'COMP.XXXX.WORK.ARJU3898.SMF110'"
debug
host='ftp390xxx.CH.XXXX.com'
S370VS rcmd='site rdw' lrecl=32760
USER='UFTPXXX'
PASS='@5KURXXX' ;
%UTILBLDP(OUTFILE=INSTREAM,BUILDPDB=NO,USERADD=CICS/110);
%BLDSMPDB(BUILDPDB=INSTREAM,WEEKSTRT=MON,
RUNDAY=YES,RUNWEEK=YES,RUNMNTH=YES,RUNTRND=WEEKLY,
BASEDIR=D:\Arju\MXG,BASECICS=D:\Arju\MXG\CICS,
BASEDB2=,AUTOALOC=YES);
%UTILCPLG(OUTDIR=D:\Arju\cics);

This results in:

NOTE: 41 records were written to the file INSTREAM.
The minimum record length was 3.
The maximum record length was 61.

SOURCE CODE CREATED BY UTILBLDP
/**********************************************************/
/* COPYRIGHT 2010,2018 MERRILL CONSULTANTS DALLAS TX USA */
/* THIS SYSIN WAS CREATED BY UTILBLDP AT CHANGE 36.229. */
%VMXGOPTR(OPTNAME=DKROCOND,NEWVALUE=NOWARN);
%LET MACKEEP=%QUOTE(
/* MXG STRONGLY RECOMMENDS PUTTING THE FOLLOWING*/
/* MACRO DEFINITIONS FOR THE ID MACROS IN YOUR */
/* USERID.SOURCLIB RATHER THAN INSTREAM. */
MACRO _IDCICS 110 %
);
/* USER SMF RECORD VMAC INCLUDES */
%INCLUDE SOURCLIB(VMACSMF
VMACCICS
IMACKEEP);
DATA
/* USER SMF RECORD _VAR MACROS */
5 The SAS System

_VARCICS
_SMF /*READ AN SMF RECORD */
/* USER SMF RECORD _CDE MACROS */
_CDECICS
RUN; /* FORCE EXECUTION OF DATA STEP*/
/* USER SMF RECORD SORT MACROS */
_SCICS
RUN;

MACRO _VARUSER _VARUSER %
MACRO _CDEUSER _CDEUSER %
%LET MACKEEP=;
%LET EPDBOUT=;
%LET EPDBINC=;
%LET EPDBCDE=;
%LET EPDBVAR=;
%LET MACDB2H=;
%LET MAC110H=;
%LET MACFILE=;
OPTIONS OBS=9223372036854775807;
%LET DONEANALID= ;
RUN;
/* USER SMF RECORD CLEAR _CDE _VAR MACROS */
MACRO _VARCICS _VARCICS %
MACRO _CDECICS _CDECICS %
MACRO _SCICS _SCICS %
NOTE: 41 records were read from the infile INSTREAM.

MXGNOTE: UTILBLDP ENDS
13 %BLDSMPDB(BUILDPDB=INSTREAM,WEEKSTRT=MON,
MXGNOTE: MEMBER BLDSMPDB, UPDATED DEC 15, 2018, CHANGE 36.242.
14 RUNDAY=YES,RUNWEEK=YES,RUNMNTH=YES,RUNTRND=WEEKLY,
15 BASEDIR=D:\Arju\MXG,BASECICS=D:\Arju\MXG\CICS,
16 BASEDB2=,AUTOALOC=YES);
NOTE: No rows were selected.
mxgerror: buildpdb input file INSTREAM does not exist.
mxgerror: Processing is aborted

Thank you.

Re: Adhoc reporting for cicstran using SMF 110 CICS records and SAS on remote PC

ChrisNZ — Fri, 09 Jul 2021 01:51:15 GMT

We have no view of your code.

INSTREAM seems to exist and then no longer exist. You need to examine what the code does by turning on option MPRINT.

topic Adhoc reporting for cicstran using SMF 110 CICS records and SAS on remote PC in SAS Programming

Adhoc reporting for cicstran using SMF 110 CICS records and SAS on remote PC

Re: Adhoc reporting for cicstran using SMF 110 CICS records and SAS on remote PC