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.
