IBM Support

[Db2] MustGather: Collecting data for Db2 Text Search issue

Question & Answer


Question

We would like to contact Db2 technical support for a Db2 Text Search issue.  Could you let us know what data need to collect for better communication, further investigation?

Answer

Could you collect below diagnostic information for further investigation?
1. Copy of db2support.zip file which was taken after the problem
2. Copy of db2diag.log file which records the problem timestamp
For more information about it, see below technote:
[Db2] output path of db2diag.log and administration notification log file
 
3. Copy of Text Search log directory
For Unix/Linux:
Copy $INSTHOME/sqllib/db2tss/log directory
* $INSTHOME is the instance home directory
* Example: /home/db2inst1/sqllib/db2tss/log
* Similar as below files will be saved.
  default0.log
  default1.log
  monitor0.csv
  monitor1.csv
  trace0.log
  trace1.log
 
For Windows:
Copy <INSTPROFDIR>\<INSTANCENAME>\db2tss\log directory
* <INSTPROFDIR> is the instance profile directory and <INSTANCENAME> is the db2instance name
* Example: C:\ProgramData\IBM\DB2\DB2COPY\DB2\db2tss\log
* See above Unix/Linux case about files.
 
4. Copy of Text Search config directory
For Unix/Linux:
Copy $INSTHOME/sqllib/db2tss/config directory
* $INSTHOME is the instance home directory
* Example: /home/db2inst1/sqllib/db2tss/config
* Similar as below files and directories will be saved.
  authentication.xml
  build_info.properties
  collections  <- dir
  configuration.xml
  constructors.xml
  constructors.xsd
  defaults  <- dir
  dictionaries  <- dir
  ecmts_config_logging.properties
  ecmts_logging.properties
  key.txt
  mimetypes.xml
  releaseinfo  <- dir
  samples  <- dir
For Windows:
Copy <INSTPROFDIR>\<INSTANCENAME>\db2tss\config directory
* <INSTPROFDIR> is the instance profile directory and <INSTANCENAME> is the db2instance name
* Example: C:\ProgramData\IBM\DB2\DB2COPY\DB2\db2tss\config
* See above Unix/Linux case about files.
 
5. Output of admintool status and configtool configuration
For Unix/Linux, run below and save the output:
$INSTHOME/sqllib/db2tss/bin/adminTool status -configPath $INSTHOME/sqllib/db2tss/config
$INSTHOME/sqllib/db2tss/bin/configTool printAll -configPath $INSTHOME/sqllib/db2tss/config
* Example: /home/db2inst1/sqllib/db2tss/bin/adminTool status -configPath /home/db2inst1/sqllib/db2tss/config 
           /home/db2inst1/sqllib/db2tss/bin/configTool printAll -configPath /home/db2inst1/sqllib/db2tss/config

For Windows, run below and save the output:
<DB2PATH>\sqllib\db2tss\bin\adminTool.bat status -configPath <INSTPROFDIR>\<INSTANCENAME>\sqllib\db2tss\config
<DB2PATH>\sqllib\db2tss\bin\configTool.bat printAll -configPath <INSTPROFDIR>\<INSTANCENAME>\sqllib\db2tss\config
* Example: C:\"Program Files"\IBM\SQLLIB\db2tss\bin\adminTool.bat status -configPath C:\ProgramData\IBM\DB2\DB2COPY1\DB2\db2tss\config
           C:\"Program Files"\IBM\SQLLIB\db2tss\bin\configTool.bat printAll -configPath C:\ProgramData\IBM\DB2\DB2COPY1\DB2\db2tss\config
6. If the issue happens at a specific index or etc., follow below:
Run below SQL and save output as tsindexes.out:
db2 'select TABNAME, COLNAME, UPDATEMINIMUM, EVENTVIEWNAME, STAGINGVIEWNAME FROM sysibmts.tsindexes'
For the corresponding entry (i.e. column being indexed or etc.), capture EVENTVIEWNAME and STAGINGVIEWNAME.
Then run below SQLs and save outputs as eventname.out and stagingviewname.out
db2 'select * from sysibmts.<EVENTVIEWNAME>
db2 'select * from sysibmts.<STAGINGVIEWNAME>
7.  About the issue and business impact
- Name of Db2 product, version, edition, FixPack level
- Name of Operating System, OS
- What is the problem? 
- When it happen?  Exact date and time of the problem.
- When the problem start?  Any known trigger of the problem?
- How/why notice the problem happening? (If an error, cut & paste it)
- What is current status of the service?  (If you recovered service already, how to recover it?)- 
- Can the problem be reproducible? (if you have reproducible steps, let us know detail at command line level)
- How often happen the problem?
- Did change anything?  Number of data changed?
- What impact to your service at your company/business by the problem?
- Are there any deadline to solve the problem?  What impact if miss the deadline?
- How many users impact by this problem?
- If javacore and/or heapdump file generate, please share with us.
* Plain text file would be better.
How to upload data, please refer below technote.
* Please use ascii characters only for directory and file names.

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m500000008PlsAAE","label":"Extenders->Text Search"}],"ARM Case Number":"TS004146798","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"All Version(s)"}]

Document Information

Modified date:
06 January 2021

UID

ibm16367155

Page Feedback