IC87839: DB2FODC -PERF GETS SYNTAX ERRORS DURING THE COLLECTION PROCESS,AND FAILS TO CAPTURE INFORMATION PROPERLY SUCH AS VMSTAT ON HP

DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• db2fodc -perf    gets syntax errors during the collection
  process, and fails to capture information properly such as
  vmstat  on the HP-UX platform.
  

Local fix

• Copy the file sqllib/bin/db2cos_perf to sqllib/adm/db2cos_perf ,
  and change the 'double
  equals'  ( == ) in the following lines to a single equals  ( = )
  :
  
       if [ $function == "run_snapshot" ]; then
  
   if [ $tool_to_run == "run_vmstat" ]; then
  
   elif [ $tool_to_run == "run_iostat" ]; then
  
      if [ $tool_to_run == "run_snapshot" ]; then
  
      if [ $function == "run_snapshot" ]; then
  
  ie text should appear as follows :
  
  
      if [ $function = "run_snapshot" ]; then
  
   if [ $tool_to_run = "run_vmstat" ]; then
  
   elif [ $tool_to_run = "run_iostat" ]; then
  
      if [ $tool_to_run = "run_snapshot" ]; then
  
      if [ $function = "run_snapshot" ]; then
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * DB2                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to db2_v101fp2                                       *
  ****************************************************************
  

Problem conclusion

• db2_v101fp2
  

Temporary fix

Comments

APAR Information

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

  IC82965

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

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RA10 PSN

     UP