PH60910: AUTHENTICATION FAILURE, CAE USERNAMES THAT INCLUDE SPECIAL/NATIONAL CHARACTERS

202407251932.CQMCAE
202406031113.CQMCAE

APAR status

• Closed as program error.

Error description

• CAE usernames that include special/national characters can have
  authentication failures requesting data in the CAE.
  
  nm.qm.agent.QmSAFAuthenticationAgentImpl.checkUseridPasswordVa
  lid>
  
  WARNING: Exception checking user @USERID for cqmSsid=null,
  accessType=null java.lang.NullPointerException
  

Local fix

• Use a USERID without a special character
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Query Monitor CAE           *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  *                 Workaround: Use a USERID without a special   *
  *                 character                                    *
  ****************************************************************
  CAE usernames that include special/national characters can have
  authentication failures requesting data in the CAE.
  
  nm.qm.agent.QmSAFAuthenticationAgentImpl.checkUseridPasswordVa
  lid>
  WARNING: Exception checking user @USERID for cqmSsid=null,
  accessType=null java.lang.NullPointerException
  

Problem conclusion

• The code was fixed to allow usernames that include special/
  national characters
  

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:

Modules/Macros

• CQM#QAPI CQM#QAPX CQM#QSQL CQM#RDSC CQM#RDSE CQM#RDSG CQM#RSSC
  CQM#RSSE CQM#RSSG CQM#RSSO CQM#SWTX CQM#UINX CQM$$PRM CQM$SM01
  CQM$SQCM CQMBLOB  CQMCFPAX CQMCPXPT CQMDSC   CQMDSE   CQMDSG
  CQMJAR   CQMMECCX CQMMECPX CQMMECRX CQMMECSX CQMMEDCX CQMMEDPX
  CQMMEDRX CQMMEDSX CQMMEMTX CQMMQAPX CQMMZIIP CQMPIKEY CQMPRKEY
  CQMPRMCR CQMPROC  CQMSSC   CQMSSE   CQMSSG   CQMSSO   CQMSSV
  CQMSTGOB CQMSTGRL CQMZCALC CQMZEMTR CQMZEXCP CQMZEXCS
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R340 PSY UI97342

     UP24/06/22 P F406

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.