CA TPX Batch - example - How can I report with the TPXBATCH utility on all users using sessiondata?

Document ID : KB000003957
Last Modified Date : 26/04/2018
Show Technical Document Details
Issue:

I'm attempting to run a TPX batch job that will report on any user using sessiondata. I'm able to report on most all other parameter except sessiondata.

Environment:
CA TPX for z/OS
Cause:
  1. Cannot use masking on an extract for session data.  The variable value masking capability designed into the batch extract was intended to only be used with values of 8 bytes or less.  In other words, it was designed for the values of such fields as userids, sessionids, etc.
  2. When extracting on session data values, enclose the value within single quotes if there are any spaces or special characters such as &.
Resolution:

Since the session data field is longer than 8 characters, masking cannot be used for it.

The only way to specify a value for that field is to use the entire literal string(s) in the criteria.  

  • Enclose the value within single quotes when the value contains spaces or a special characters, for example '&userid/&pswd'.

Examples:

EXTRACT GIVING(EXTFIL4) USER AND MATCHING SESSIONS 
                        ( UENTDATA('&userid' '&userid/&pswd' )  )       
SET RTITLE1                                                           
' USERID   SessionID APPLID   Session Data                       '    
SET RTITLE2                                                           
' UIDXNAME UENTUSER  UENTAPPL UENTDATA                           '    
SET RTITLE3                                                           
' ======== ========= ======== ======================================' 
REPORT GIVING(RPTFIL4) USING(EXTFIL4)                                 
  ((' &UIDXNAME'                                                      
    '&UENTUSER'                                                       
    '&UENTAPPL'                                                       
    '&UENTDATA                                                     '))


This example with masking will not extract any records:

EXTRACT GIVING(EXTFIL2) USER AND MATCHING SESSIONS                    
                        ( UENTDATA(--------))       
SET RTITLE1                                                           
' USERID   SessionID APPLID   Session Data                       '    
SET RTITLE2                                                           
' UIDXNAME UENTUSER  UENTAPPL UENTDATA                           '    
SET RTITLE3                                                           
' ======== ========= ======== ======================================' 
REPORT GIVING(RPTFIL2) USING(EXTFIL2)                                 
  ((' &UIDXNAME'                                                      
    '&UENTUSER'                                                       
    '&UENTAPPL'                                                       
    '&UENTDATA                                                     '))
Additional Information: