The Library Analysis by Library iSeries report in VM shows jumbled text as column names. (NETIQKB55531)

fact
NetIQ Security Solutions for iSeries 8.0

fact
NetIQ Vulnerability Manager 5.x

fact
NetIQ Secure Configuration Manager 5.6

symptom
The "Library Analysis by Library" iSeries report in Secure Configuration Manager (SCM), formerly NetIQ Vulnerability Manager (NVM), shows jumbled text as column names.

symptom
I am having trouble reading the "Library Analysis by Library report" report due to the column names being cryptic.

fix

To have the column names displayed correctly, you will have to modify a file on the iSeries system where the iSeries agent
resides.

Please backup the PSEMETA file in library PSCOMMON prior to make the proposed changes using the following command:

• CPYF FROMFILE(PSCOMMON/PSEMETA)  TOFILE(QGPL/PSEMETAx)  CRTFILE(*YES)            

Then, issue command STRSQL from a command line and run the following statement in the interactive SQL environment:

• UPDATE pscommon/psemeta SET MCSELECT =                             
  'SELECT AAASPNM as ASPGroup,AA20LB as Library_Name,AA20#O as       
  Number_of_objects,AA20SZ as Size,AA20STG as Storage_Percentage,    
  AA20PO as Previous_number_of_objects,AA20PZ as Previous_Size,AA20DT
  as Audit_Date,MBMTXT as Library_Text FROM QTEMP/PSAUDIT'           
  WHERE MCMETA ='AACL31LL'                                           

This fixes the column names.

If you are not familiar with command STRSQL, please use the following commands:

• ADDLIBLE PSCOMMON
• PSRUNSQL REQUEST('UPDATE pscommon/psemeta SET MCSELECT = ''SELECT AAASPNM as ASPGroup,AA20LB as Library_Name,AA20#O as Number_of_objects,AA20SZ as Size,AA20STG as Storage_Percentage, AA20PO as Previous_number_of_objects, AA20PZ as Previous_Size,AA20DT as Audit_Date,MBMTXT as Library_Text FROM QTEMP/PSAUDIT'' WHERE MCMETA = ''AACL31LL''')         

After these changes are applied, please rerun the "Library Analysis by Library" report using VM/SCM.

Formerly known as NETIQKB55531