PK67506: OMPE V410: SQLPA JCL PROBLEMS IN NON-SMS ENVIRONMENTS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Cust env: z/OS V1.8, DB2 V8, OmPE V410, ITM V6.1
  Cust problem:
  I have customized the SQLPA for OMEGAMON XE for DB2.  But when
  I go into the classical Interface and select 'V' for the SQLPA
  Report it shows failure for not be able to show the report.
  I had noticed that we need to enable the Performance Warehouse
  in order for SQLPA to work. I have done that and seeing the
  message of below:
  PERFORMANCEWAREHOUSE=YES
    - PERFORMANCEWAREHOUSEADDRESSSPACENAME=DT11PWH
  and follows the message of
  FPEV5005I  DT11 DATABASE UPDATE COMPLETE
  In the classical Interface, the SQL PA Analysis: Available
  Reports shows failure:
  IEF210I DT11PWH ANLSTEP1 FPEZPWH ANLREP - UNIT FIELD SPECIFIES
  INCORRECT DEVICE NAME
  Please let me know if there is anything that I needed
  to be done in order to activate the report. By the way, the
  SQLPA works ok by itself if I used SPUFI interface
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component                           *
  *                 - PE Server                                  *
  *                 - Classic Interface                          *
  *                 - Performance Warehouse user                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: When SQLPA is requested from            *
  *                      Classic Interface in non-SMS            *
  *                      environment the execution of started    *
  *                      job created in the PWH for SQLPA        *
  *                      is failed.                              *
  *                      In the corresponding job output an      *
  *                      error is reported as UNIT FIELD         *
  *                      SPECIFIES INCORRECT DEVICE NAME.        *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  PROBLEM SUMMARY:
  There is no way to define a DSVOLUME and DSUNIT value
  required for non-SMS environment within OMPEMSTR because
  the corresponding JCL parameters for SQLPA are not generated.
  
  PROBLEM CONCLUSION:
  Change SQLPA jcl skeletons to support new common approach
  for handling DSVOLUME and DSUNIT values.
  
  KEYWORDS:
  PWH SQLPA DATASERVERVOLUME DATASERVERUNIT
  DSVOLUME DSUNIT UNIT VOLUME SMS NONSMS
  

Problem conclusion

• PROBLEM CONCLUSION:
  Change SQLPA jcl skeletons to support new common approach
  for handling DSVOLUME and DSUNIT values.
  
  KEYWORDS:
  PWH SQLPA DATASERVERVOLUME DATASERVERUNIT
  DSVOLUME DSUNIT UNIT VOLUME SMS NONSMS
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK38134

Modules/Macros

•    DGO@SQPA DGOVMSTR DGOZSQPA
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R410 PSY UK38134

     UP08/07/17 P F807

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.