IV22060: KRARLOFF UTILITY CONVERTS UNNECESSARY COLUMNS

IBM Tivoli Monitoring 6.2.3 Fix Pack 5 (6.2.3-TIV-ITM-FP0005)
IBM Tivoli Monitoring 6.2.3 Fix Pack 2 (6.2.3-TIV-ITM-FP0002)
IBM Tivoli Monitoring 6.2.3 Fix Pack 4 (6.2.3-TIV-ITM-FP0004)

APAR status

• Closed as program error.

Error description

• The krarloff utility program fails to skip over hidden columns
  (KHD_EXPORT_HIDDEN), and the SAMPLES and INTERVAL columns.
  

Local fix

• N/A
  

Problem summary

• The krarloff utility converts unnecessary columns (SAMPLES and
  INTERVAL).
  
  
  The krarloff utility converts unnecessary columns (SAMPLES and
  INTERVAL).  The SAMPLES and INTERVAL columns are not needed when
  importing data into the warehouse database. Thus, users have to
  remove these columns prior to insertion into the database from
  the flat text file.
  
  In order for this APAR to be properly implemented in your
  environment, a new option "-x" has been added to the kraloff
  utility and the "itmcmd history" command to exclude the SAMPLES
  and INTERVAL attribute in the output. See the "Install Actions"
  section of the APAR conclusion for more details.
  

Problem conclusion

• Code was updated to provide a "-x" option to exclude the SAMPLES
  and INTERVAL column.
  
  Install Actions
  
  The krarloff program has been updated to include a new "-x"
  option flag.  This is the usage:
  
  USAGE : krarloff [-h] [-g] [-x] [-d delimiter] [-m meta-file]
  [-r rename-source-file-to] [-o output-file] {-s source-file |
  source-file}
          -h : include header file in output file.
          -g : include product group_name in output file.
          -x : exclude SAMPLES and INTERVAL attribute in output
  file.
  
  The "itmcmd history" command has also been updated to include a
  new "-x" option.  Here is the usage for this command:
  
  itmcmd history -C
   [-h [install_dir]]
   [-L nnn[K|Kb|M|Mb]]
   [-t masks ...]
   [-D delim]
   [-H|+H ]
   [-N n]
   [-i instance|-p cms_name]
   [-x]
   pc
  
  itmcmd history -A [n|0|?ms_name]
   [-h [install_dir]]
   [-W days]
   [-L nnn[K|Kb|M|Mb]]
   [-t masks*,etc ]
   [-D delim]
   [-H|+H ]
   [-N n]
   [-i instance|-p cms_name]
   [-x]
   pc
  
  where:
   -x
   Exclude SAMPLES and INTERVAL attributes in output file.
  
  
  
  
  The fix for this APAR is contained in the following maintenance
  packages:
  | fix pack | 6.2.3-TIV-ITM-FP0002
  

Temporary fix

• Manually remove the columns from the flat text file.
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  TEMA

• Fixed component ID

  5724C04TE

Applicable component levels

• R622 PSY

     UP