PK71101: SQL ACTIVITY AND CRD STEP YIELDS MESSAGE FPEV6814I IN ENVIRONMENTS USING RACF FOR DB2 PRIVILEGE AND AUTHORITY MANAGEMENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When starting SQL ACTIVITY tracing or PWH processes containing
  CRD steps, message FPEV6814I is displayed indicating that
  requesting user is missing MONITOR1 and MONITOR2 privileges.
  
  Customer has defined DB2 PRIVILEGES and AUTHORITIES using RACF
  profiles.
  An issue concerning RC checking at logon
  time is also fixed by this APAR.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   PE Server subtask                        *
  *                 -   Performance Expert Client                *
  *                 -   Performance Warehouse users              *
  ****************************************************************
  * PROBLEM DESCRIPTION: IN ENVIRONMENTS USING RACF FOR DB2      *
  *                      PRIVILEGE AND AUTHORITY MANAGEMENT      *
  *                      STARTING SQL ACTIVITY IN PE CLIENT OR   *
  *                      EXECUTING PWH PROCESSES CONTAINING CRD  *
  *                      STEPS LEADS TO MESSAGE FPEV6814I BEING  *
  *                      DISPLAYED.                              *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  PROBLEM SUMMARY:
  1. WRONG ACEE USED WHEN RRSAF AUTHORIZED SIGNON IS PERFORMED.
  2. WRONG ACEE USED TO RETRIEVE NAMES OF SECONDARY RACF IDS
  DURING START OF CRD STEPS.
  3. WRONG RC CHECK IN CASE OF FAILING AUTHORIZED SIGNON DURING
  LOGON PROCESSING INITATED BY PE CLIENT
  
  PROBLEM CONCLUSION:
  PROBLEMS SOLVED.
  

Problem conclusion

• PROBLEMS SOLVED.
  
  KEYWORDS : PE CLIENT, FPEV6814I, CRD STEP, PWH CLIENT, PASSWORD,
             LOGON
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UK40823

Modules/Macros

•    DGO@BTCH DGO@CHKB DGO@CONV DGO@CRDP DGO@DB
  DGO@DB2I DGO@DB2S DGO@DTA1 DGO@DTA3 DGO@DTA5 DGO@DTA6 DGO@DTA7
  DGO@LLOG DGO@LOAD DGO@MIG1 DGO@MIG2 DGO@MT1  DGO@MT2  DGO@MT3
  DGO@MT4  DGO@MT5  DGO@PC1  DGO@PC2  DGO@PC3  DGO@PC4  DGO@PRV1
  DGO@PRV2 DGO@SCRD DGO@SDOB DGO@SIDS DGO@SP   DGO@SQPA DGO@TBL
  DGO@VW1  DGO@VW2  DGO@WRPA DGO@WRP2 DGO@WR2C DGO@WSTE DGOVBMG
  DGOVCCP  DGOVCINI DGOVCRDB DGOVDB2C DGOVDB2F DGOVDB2I DGOVDB2M
  DGOVDB2S DGOVDMSG DGOVDS   DGOVDSIN DGOVDSRC DGOVDSS  DGOVEEDI
  DGOVEEDR DGOVEEDS DGOVEEDT DGOVEE00 DGOVEE01 DGOVGIFC DGOVHMCD
  DGOVHMDR DGOVHMM0 DGOVHMM1 DGOVHMM2 DGOVHMM3 DGOVHMSD DGOVHMS1
  DGOVHMTC DGOVHMTM DGOVHMTX DGOVHM00 DGOVISIT DGOVMB   DGOVMDI
  DGOVMDSP DGOVMIDI DGOVMMXM DGOVMRAP DGOVMSTR DGOVMUAE DGOVM001
  DGOVM002 DGOVPCON DGOVPDSC DGOVPIG0 DGOVPIG1 DGOVPMOV DGOVPOPT
  DGOVPP1  DGOVPP2  DGOVPP3  DGOVPP4  DGOVPUPD DGOVRGM1 DGOVRG01
  DGOVRG02 DGOVRG03 DGOVRG04 DGOVRG10 DGOVRG11 DGOVRG12 DGOVRG13
  DGOVRG20 DGOVRG21 DGOVRG22 DGOVRG23 DGOVRG24 DGOVRG25 DGOVRG26
  DGOVRG27 DGOVRG28 DGOVRG4B DGOVRG4C DGOVRG4X DGOVRPRM DGOVRSFI
  DGOVRSFL DGOVRTG0 DGOVRTG1 DGOVSADJ DGOVSADK DGOVSCLO DGOVSCLR
  DGOVSCNI DGOVSCNT DGOVSCON DGOVSCPI DGOVSCS1 DGOVSCS2 DGOVSCS3
  DGOVSCT1 DGOVSCT2 DGOVSDDF DGOVSDOB DGOVSDOC DGOVSDSC DGOVSDTS
  DGOVSDTT DGOVSERI DGOVSFLR DGOVSGET DGOVSGFT DGOVSGSA DGOVSLOC
  DGOVSORT DGOVSQRY DGOVSQSM DGOVSQTR DGOVSSEN DGOVSSP1 DGOVSSP2
  DGOVSTAG DGOVSUBS DGOVS100 DGOVS140 DGOVS150 DGOVS700 DGOVTAC
  DGOVTBI  DGOVTCL  DGOVTCPD DGOVTCPL DGOVTCPS DGOVTCPT DGOVTDI0
  DGOVTGC  DGOVTGS  DGOVTIA  DGOVTLI  DGOVTSCL DGOVTSD  DGOVTSEX
  DGOVTSIA DGOVTSO  DGOVTSOI DGOVTSSD DGOVTSSO DGOVTSTA DGOVTSTS
  DGOVTSX  DGOVTTA  DGOVTWR  DGOVUAS0 DGOVUINI DGOVUM00 DGOVUM01
  DGOVUM02 DGOVUSS0 DGOVWDOG DGOVWRPA DGOVWRP2 DGOVWR2C DGOVXMSG
  DGOVZAP  DGOVZRAC DGOVZTCC DGOVZTRC DGOZBIND DGOZBTCH DGOZBTC2
  DGOZCAF  DGOZCHDR DGOZCHKB DGOZCMD  DGOZCONV DGOZCOPY DGOZCRDC
  DGOZCRDP DGOZCRDS DGOZCRDW DGOZDB   DGOZDMDB DGOZDTA1 DGOZDTA3
  DGOZDTA5 DGOZDTA6 DGOZDTA7 DGOZECB  DGOZFL1  DGOZFL2  DGOZFL3
  DGOZJEND DGOZLLOG DGOZLOAD DGOZMB   DGOZMIG1 DGOZMIG2 DGOZMT1
  DGOZMT2  DGOZMT3  DGOZMT4  DGOZMT5  DGOZPC1  DGOZPC2  DGOZPC3
  DGOZPC4  DGOZPRSE DGOZPRV1 DGOZPRV2 DGOZRSDS DGOZSCRD DGOZSIDS
  DGOZSP   DGOZSQPA DGOZSUB1 DGOZSUB2 DGOZTBL  DGOZUAUT DGOZVW1
  DGOZVW2  DGOZWDIV DGOZWFE  DGOZWIE  DGOZWJE  DGOZWSE  DGOZWSTE
  FPE@DB2I FPE@DB2S FPE@WRPA FPE@WRP2 FPE@WR2C FPEMDSUB FPEVDB2I
  FPEVDB2S FPEVDB22 FPEVM000 FPEVRACF FPEVSERV FPEVWRPA FPEVWRP2
  FPEVWR2C FPEVZMAI FPEVZRAC FPEZCRD  FPEZPMS  HKDB410J KDB410J
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R410 PSY UK40823

     UP08/10/22 P F810 Ž

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.