FPEM748 No key column information was found for this column

Explanation

A FETCH from the OMEGAMON for Db2 PE copy or view of the Db2 system catalog SYSKEYS table (DGO_SYSKEYS) returned no rows.

The DGO_SYSKEYS table can be created using the installation member FPEYCV71, or it can be a shadow catalog table copied from SYSIBM.SYSKEYS. If it is a shadow catalog table, it must be refreshed regularly.

User response

Run a query against the DGO_SYSKEYS table, such as:
SELECT COLNAME,ORDERING,COLSEQ
FROM   hlq.DGO_SYSKEYS
WHERE  IXCREATOR = 'PEABPV'
  AND  IXNAME    = 'XPE2VMAN'
ORDER  BY COLSEQ;
and compare the result with a similar query against the SYSIBM.SYSKEYS table. If there are differences, use the sample job FPEYRSQL to refresh the DGO_SYSKEYS table.