SQL Performance Analyzer JVMJZBL1038E exit code 125 JVMJZBL1042E return code 102

Products

• Datacom/DB
• Datacom/AD
• DATACOM - AD
• Datacom

Issue/Introduction

Starting job SQLPA to run JVMPRC86 for the Datacom SQL Performance Analyzer getting errors:

JVMJZBL10051 Output from DD:STDENV config shell script:
JVMJZBL1038E Child shell process exited with exit code: 125
JVMJZBL29991 JZOS batch launcher elapsed time=0 seconds, cpu time=0.450000 seconds
JVMJZBL1042E JZOS batch launcher failed, return code=102

Environment

Release : 15.1

Cause

Additional trace information messages will help to determine the cause of the error.

To get more trace messages change the log level to T.

Change :
//JAVA EXEC PROC=JVMPRC86,PARM='+D'
to:
//JAVA EXEC PROC=JVMPRC86,PARM='+T'

Also add set -x to the beginning of the STDENV DD:
//STDENV DD *
set -x

 

Resolution

To resolve the problem check the following:

• There are no line numbers in  the JCL you're submitting as it can cause shell script syntax errors. 
  
  
• The correct paths were specified here:
  JAVA_HOME={user.javaLoadlib}                                           
  DTCM_SQLPA_PATH={user.dtcmTargetDir}      
  
  
• Your userid has access to the temporary directory /tmp 
  
  
• Your userid has  access to /etc/profile and  it has a line TZ= ours has TZ=EST5EDT

Additional Information

See documentation section Configure the SQL Performance Analyzer and Start and Stop the SQL Performance Analyzer Service