SQL/QRY Monitor contain Hex data for UPDATE and DELETE operations (NETIQKB72191)

  • 7772191
  • 06-Apr-2010
  • 22-Apr-2014

Environment

NetIQ Security Solutions for iSeries
PSAUDIT
SQL/QRY
STRSQL

Situation

SQL/QRY Monitor contain Hex data for UPDATE and DELETE operations

Resolution

Change CCSID to be 37 for the data to displayed in English format
1. You can change the QCCSID system value (WRKSYSVAL QCCSID) or
2. Change the individual profiles CCSID to be 37 (CHGUSRPRF USRPRF(PROFILE)  CCSID(37))

Cause

The CCSID of job is 65535

Additional Information

Formerly known as NETIQKB72191