IC80382: "DB2FODC -PERF FULL" ON WINDOWS WITH A NON-ENGLISH LANGUAGE ENVIRONMENT MAY FAIL TO COLLECT SNAPSHOT DATA

DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• Diagnostic data collection with 'db2fodc -perf full' on Windows
  OS may fail to collect snapshot data.
  
  You will notice errors in the snapshot output file like,
  dbsnap.<dbname>.<iteration>.<timestamp>:
  
  get monitor switches ,72.out
  SQL0104N  An unexpected token "," was found following
  "SWITCHES".  Expected
  tokens may include:  "GLOBAL".  SQLSTATE=42601
  
  get snapshot for all on SAMPLE ,72.out
  SQL0104N  An unexpected token "," was found following
  "<identifier>".
  Expected tokens may include:  "GLOBAL".  SQLSTATE=42601
  
  This happens only on Windows platform when the regional settings
  are set to a non-english locale for which the TIME decimal
  delimiter for the sub seconds is set to a comma "," instead of a
  decimal point ".", for example on German environment.
  
  You can check your reginal settings from Windows (start ->
  control panel -> Reginal and Language Options -> Customize ->
  Decimal Symbol)
  
  You can also verify if you are affected, by running "echo
  %TIME%", in a command windows:
  
  C:\SQLLIB95\BIN>echo %TIME%
  10:38:15,42
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL USERS ON WINDOWS PLATFORM                                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Problem Description above.                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 Version 9.7 Fix Pack 6.                       *
  ****************************************************************
  

Problem conclusion

• First fixed in Version 9.7 Fix Pack 6.
  

Temporary fix

Comments

APAR Information

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

  IC78413

• 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

• R970 PSN

     UP