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

book

Article ID: 3957

calendar_today

Updated On:

Products

CA TPX - Session Management TPX- PACKAGE CA Vman Session Management for z/OS TPX SESSION MANAGEMENT

Issue/Introduction

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.

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 &.

Environment

CA TPX for z/OS

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

TPX 5.4 Batch Administration - Specify Extraction Criteria