PH63015: ABSTRACT: NOCLASSDEFFOUNDERROR WHEN IMPORTING CERTIFICATES

202408301043.CQMCAE
202410031312.CQMCAE

APAR status

• Closed as program error.

Error description

• User encounters a NoClassDefFoundError when running the
  cqm_import_certs.bat (Windows) or CQMICERT (USS) scripts
  to import certificates into the CAE Server
  

Local fix

• User can invoke Java's keytool utility to perform the steps
  manually.
  1. Import the cert into defaultKeystore.jks
  a. keytool -importcert -file certificate.cer -keystore
     keystore.jks -alias "Alias"
  2. Set the certificate's password to "password"
   a. keytool -keypasswd -alias "website.com" -keypass xxxxxx -new
      password
  -storetype JKS -keystore "C:\Program Files\IBM\DB2 Query Monitor
  v3.4\defaultKeystore.jks"
  -storepass password
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Query Monitor               *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  *                 LOCAL FIX:                                   *
  *                 User can invoke Java's keytool utility to    *
  *                 perform the steps manually.                  *
  *                 1. Import the cert into defaultKeystore.jks  *
  *                 a. keytool -importcert -file certificate.cer *
  *                  -keystore keystore.jks -alias "Alias"       *
  *                 2. Set the certificate's password to         *
  *                 "password"                                   *
  *                 a. keytool -keypasswd -alias "website.com"   *
  *                 -keypass xxxxxx -new password -storetype     *
  *                 JKS -keystore "C:\Program Files\IBM\         *
  *                 DB2 Query Monitor v3.4\defaultKeystore.jks"  *
  *                 -storepass password                          *
  ****************************************************************
  User encounters a NoClassDefFoundError when running the
  cqm_import_certs.bat (Windows) or CQMICERT (USS) scripts
  to import certificates into the CAE Server.
  

Problem conclusion

• The paths in the scripts were updated for Java 17
  

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:

  UI98883

Modules/Macros

• CQM      CQM#DRVX CQM#QAPI CQM#QAPX CQM#QSQL CQM$$PRM CQM$ACTV
  CQM$ADM1 CQM$ADMN CQM$CALL CQM$FLTU CQM$LC01 CQM$LC02 CQM$LC05
  CQM$LC21 CQM$LINK CQM$LNCD CQM$MAIN CQM$OPTN CQM$SLIP CQM$SM01
  CQM$SQC6 CQM$SQC7 CQM$SQC8 CQM$SQC9 CQM$SQCE CQM$SQCL CQM$SQLT
  CQM$TEXT CQM$XQVE CQM07    CQM077E  CQM079E  CQM10    CQM14
  CQM17    CQM172E  CQM26    CQM27    CQM29    CQM292E  CQM86
  CQM862E  CQM863E  CQM@FTXT CQMBIND  CQMBLOB  CQMC2LST CQMCFPAX
  CQMCLIST CQMCLST1 CQMCPXPT CQMHACTA CQMHCALL CQMHEXCA CQMHLCXX
  CQMHOPTN CQMHSUCT CQMHSUMB CQMHSUMC CQMHSUMJ CQMHSUMK CQMHSUML
  CQMHSUMP CQMHSUMT CQMHSUSP CQMJAR   CQMPIKEY CQMPRKEY
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R340 PSY UI98883

     UP24/10/31 P F410

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.