版本注意事項


|17.2 Chapter 1. Good Troubleshooting Practices

|17.2.1 Problem Analysis and Environment Collection Tool

|There is a utility that will help you identify some of the information |associated with your problem and will collect other relevant information to |assist DB2 Customer Support to understand your environment and your problem. |Much of what is collected using this utility is discussed in the rest of |this chapter. The utility is db2support.

|Details about the syntax and command line options is found in the Command Reference.

|The purpose of the utility is to collect environmental data about your |client or server machine that is running DB2; and then to collect and package |a large portion of the output as browsable XML, HTML, or a compressed file |archive. The utility also has an option that allows for the collection of |some data from you about the nature of your problem using an interactive |question and answer process. This process will help you clarify the problem |and also provide information to DB2 Customer Support when you finally contact |them regarding your problem.

|Note:
A thin or runtime client is not able to use this utility. |The utility requires that the client have the DB2 engine libraries installed. |

|17.2.1.1 Collection Outputs

|The utility produces a compressed collection (single file archive) of important |database system information. Included in this archive is an HTML report of |the most essential information, which you can use to view the information.

|By default, db2support will not collect table data, schema (DDL), or logs |in order to protect the security and sensitivity of customer data. With |some options, the user may elect to include aspects of their schema and data |(such as including archived logs). Options that expose database schema or |data should be used carefully. When db2support is invoked, a message indicating |how sensitive data is dealt with will be displayed.

|The following are the files to be collected and compressed into a single |archive:

|Collected under all conditions |

  1. |db2diag.log
  2. |All trap files
  3. |Lock list files (with -d)
  4. |Dump files
  5. |User exit (with -d)
  6. |Buffer pool and table space (SPCS) control files (with -d)
  7. |Various system related files
  8. |Output from various system commands
  9. |db config (with -d)
  10. |dbm config files
  11. |Log File Header file (with -d)
  12. |Recovery History File
  13. |db2cli.ini |

|Optionally collected |

  1. |Active log files
  2. |Contents of db2dump directory (i.e. what was not collected above)
  3. |Core files (-a for all core file, -r for only the most recent core file)
  4. |Extended system information (-s) |

|The following files make up the content of the HTML report:

|Collected under all conditions |

  1. |PMR number, if one exists. (if -n was specified)
  2. |Operating system and level. (e.g. AIX 4.2.1)
  3. |DB2 release information.
  4. |Engine library header information.
  5. |Detecting 32- or 64-bit
  6. |DB2 install path information.
  7. |For EEE report contents of db2nodes.cfg
  8. |How many CPUs, disks, and how much memory.
  9. |List of databases on this instance.
  10. |Registry information, environment, including path & libpath.
  11. |Disk freespace for current filesystem and inodes for Unix.
  12. |JDK level.
  13. |dbm config.
  14. |Listing of the database recovery history file.
  15. |'ls -lR' (or windows equivilant) of the sqllib directory.
  16. |LIST NODE DIRECTORY
  17. |LIST ADMIN NODE DIRECTORY
  18. |LIST DCS DIRECTORY
  19. |LIST DCS APPLICATIONS EXTENDED
  20. |List of all installed software. |

|Collected if '-s' is specified |

  1. |Detailed disk information (partition layout, type, LVM information, etc.)
  2. |Detailed network information
  3. |Kernel statistics
  4. |Firmware Conversions
  5. |Other platform specific commands |

|Collected if DB2 has been started |

  1. |Client connection state
  2. |db/dbm config (db cfg require -d option)
  3. |CLI config
  4. |Memory pool info (size and consumed). Complete data if -d option used.
  5. |LIST ACTIVE DATABASES
  6. |LIST DATALINKS MANAGERS
  7. |LIST DCS APPLICATIONS |

|Collected if -c has been specified and a connection |to the database can be made |

  1. |Number of user tables
  2. |Approximate size of DB data
  3. |Database snapshot
  4. |Application snapshot
  5. |Buffer pool information
  6. |LIST APPLICATIONS
  7. |LIST COMMAND OPTIONS
  8. |LIST DATABASE DIRECTORY
  9. |LIST INDOUBT TRANSACTIONS
  10. |LIST NODEGROUPS
  11. |LIST NODES
  12. |LIST ODBC DATA SOURCES
  13. |LIST PACKAGES/TABLES
  14. |LIST TABLESPACE CONTAINERS
  15. |LIST TABLESPACES
  16. |LIST DRDA IN DOUBT TRANSACTIONS |

|If '-q' is specified, collect the following

|The interactive question and answer mode is started. With the exception |of an optional "describe your problem" question and a small number of requests |for customer information, all of the questions will have multiple choice |answers from which to select. All of the questions, including follow up questions, |and the answers will be collected. In some cases, the utility will ask you |to carry out a task and place the results of that task in an additional directory. |A small decision tree is used during the interactive mode to determine the |questions to ask. These interactive questions assist in determining the |category of the problem and based on the category a few other relevant questions |may be asked and additional data collected. At the end of the questions, |any data that would have been collected in the automatic mode, will also |be collected. The answers to all questions are stored in preparation to be |sent to service along with any data collected in automatic mode.

|17.2.1.2 Viewing detailed_system_info.html

|If you are running db2support on a non-English installation and are experiencing |difficulties properly viewing detailed_system_info.html, you may need to use |Internet Explorer 版本 5 or later with DOS encoding. To change the encoding, |select View --> Encoding --> Central European (DOS). If you |do not already have the required encoding support, then Internet Explorer |prompts you to download the required files from the Microsoft Updates web |site. This information does not apply to double-byte languages (Simplified |Chinese, Traditional Chinese, Japanese and Korean).

|17.2.1.3 Viewing DB2 Support Tool Syntax One Page at a Time

|To view the syntax for the DB2 Support Tool one page at a time, run the |following command:

|db2support | more


[ 頁面頂端 | 前一頁 | 下一頁 | 目錄 | 索引 ]