Using program SASSXTRK to extract records from the CA 7 log data
Article ID: 22451
Updated On:
Products
Issue/Introduction
Environment
Component: 7
Resolution
You may be asked to run program SASSXTRK in order for CA Support to view your log data for problem solving. SASSXTRK is a program used to extract records from the log/history/archive file. A control statement edit report is produced by this program as well as an output file that contains the extracted log records. This output file can be used by other reporting jobs to produce specific reports. Depending on the SYSIN, records can be extracted based on date and time and/or job name. Here are the three steps necessary to complete this process:
1. The following sample JCL is used to execute the SASSXTRK program. Run it with an * in column 1 of the control card in order to produce ALL data for the time frame and not just the lines with the job name in them.
//jobname JOB ...
//EXTRACT EXEC PGM=SASSXTRK
//STEPLIB DD DISP=SHR,DSN=ca7.loadlib
//LOGIN DD DISP=SHR,DSN=ca7.logtape
//LOGOUT DD DISP=(NEW,CATLG,DELETE),DSN=extracted.file,
// UNIT=SYSDA,SPACE=(CYL,(10,5),RLSE),
// DCB=(RECFM=VB,LRECL=2100,BLKSIZE=21004)
//SYSOUT DD SYSOUT=*
//SYSIN DD *
* yydddhhmm yydddhhmm
/*
//LOGIN: (Required) This file can be the history LOGTAPE or the DASD LOGP or LOGS file. The LRECL can only be 1400 or 2100.
//LOGOUT: (Required) This file can be DASD or tape. The LRECL is copied from the LOGIN DD statement. This file contains a copy of the log records that were selected.
//SYSOUT: (Required) This file contains information from the control statement edit routine and possibly some error messages.
//SYSIN: (Required) The selection criteria is taken from this DD statement. Currently only one control statement per execution is supported:
CONTROL STATEMENT DESCRIPTION: * yydddhhmm yydddhhmm:
Use of the asterisk (*) in column one. Do not specify jobname
From Date: Positions 10-14, yyddd format, Default: 00000.
From Time: Positions 15-18, hhmm format, Default: 0000.
To Date: Positions 20-24, yyddd format, Default: Highest date in log file.
To Time: Positions 25-28, hhmm format, Default: 2400.
2. Once this program runs successfully, you will need to TERSE the output file in order to FTP the file to our site. To TERSE the file, use the following JCL:
//jobname JOB ..... REGION=0M
//*
//STEP1 EXEC PGM=TRSMAIN,PARM=PACK
//SYSPRINT DD SYSOUT=*
//INFILE DD DISP=SHR,BUFNO=90, DSN=file-to-terse
//OUTFILE DD DISP=(,CATLG),UNIT=SYSDA,VOL=SER=VOL111, DSN=output-tersed-file,
// SPACE=(TRK,(1500,0700),RLSE), DCB=(BUFNO=90,RECFM=FB,LRECL=1024,BLKSIZE=6144)
/*
3. Next FTP the SASSXTRK raw log data BINARY mode to:
//FTP EXEC PGM=SFTP,REGION=0K
//SYSPRINT DD SYSOUT=*
//SYSTCPD DD DISP=SHR,DSN=VTAM.TCPIP.TCPIP.DATA
//OUTPUT DD SYSOUT=*
//INPUT DD *
supportftp.broadcom.com
your-support.broadcom-userid <= change (see note below)
your-support.broadcom.com-password <= change
cd /nnnnnnn/nnnnnnnn/files_from_customer <= change (example here, note below)
bin
put 'tersedfilename' ftpfilename <= change file names
quit
/*
---------------------------------------------------------------------
Note:
Site = always use supportftp.broadcom.com
Name = change to your userid used to log onto support.broadcom.com
Pswrd = change to your password used to log onto support.broadcom.com
Directory = cd /nnnnnnn/nnnnnnnn/files_from_customer
(first nnnnnnn will be your site id proceeded by a zero (if needed to fill 7 characters) and the last nnnnnnnn will be the case # plus leading zeros to make 8 characters)
File names: tersedfilename = name of OUTPUT file created in Step 2 above
ftpfilename = name used to send (ftp) file to Broadcom
Feedback
