Log Analyzer job finished with an error message LAE0006E

Products

• Log Analyzer for DB2 for z/OS

Issue/Introduction

Log Analyzer job to run a SMF Audit report with the following statements. 

SSID     = (DB2A)                              
START    = (DATE(YYYY-MM-DD),TIME(00:00:00.00))
END      = (DATE(YYYY-MM-DD),TIME(HH:MM:SS.mm))
SMFREPT  = (GRANTS DDL AAD FAA FCH QID UTIL)   
EXTRACT  = (ALL)                                 

Got an error message: 

LAE0006E DB2 SSID      is not defined in the CA-DB2 PARMLIB. 

Note the DB2 SSID is blank instead of the actual DB2 SSID DB2A. 

Resolution

The LAE0006E error message was caused by the THREADS parameter in the HLQ.CDBAPARM(BATPROC) member, there was THREADS     (1) and for a Log Analyzer job it has to be updated to THREADS     (2). The default for THREADS parameter is 2.

A Log Analyzer jobs needs to create more than one thread for the SQL and SELECT select statements in the Batch Processor commands, if only one thread is created then the Log Analyzer job failed to connect with the blank DB2 SSID when the second thread has to be created.      
  
Additionally in the HLQ.CDBAPARM(SETUPxx) member update the LOCATION and LOCSSID parameters in Db2 SSID DB2A definition to be sure it is local and not remote. 

...
SSREMOTE (NO)
LOCATION (LOCAL)
LOCSSID  (DB2A)                  
LOADLIBS (                    
          HLQ.DB2.DB2A.SDSNEXIT
          HLQ.DB2.DB2A.SDSNLOAD
         )                      
...