|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.
|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 |
|Optionally collected |
|The following files make up the content of the HTML report:
|Collected under all conditions |
|Collected if '-s' is specified |
|Collected if DB2 has been started |
|Collected if -c has been specified and a connection |to the database can be made |
|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.
|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 version 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).
|To view the syntax for the DB2 Support Tool one page at a time, run the |following command:
|db2support | more