Collecting MustGather data for catalog tool issues

Prepare the following MustGather information before you call IBM Support to help with catalog tool issues.

Procedure

1. Configure the following trace strings in the Transaction server Docker container.

   com.ibm.websphere.commerce.WC_CATALOG=all:ibm.commerce.foundation.*=all:com.ibm.websphere.commerce.WC_SERVER=all:com.ibm.commerce.foundation.client.lobtools.*=all:com.ibm.commerce.catalog.*=all 

   For information about how to set trace strings, see Configure logging for the Transaction Server.

2. Reproduce the problem.

   Record the specific steps that we used to reproduce the problem and any details that might be relevant.

3. Collect the following files.

   • From the Transaction server Docker container:

     • /opt/WebSphere/AppServer/profiles/default/logs/server1/SystemOut*.log

     • /opt/WebSphere/AppServer/profiles/default/logs/server1/trace*.log

4. Run the following database queries to collect the necessary information from the database (output results in CSV format).

   select * from CATALOG > CATALOG.csv
   select * from CATENTRY > CATENTRY.csv
   select * from CATGPENREL > CATGPENREL.csv
   select * from CATENTREL > CATENTREL.csv
   select * from CATGROUP > CATGROUP.csv
   select * from CATENTDESC > CATENTDESC.csv
   select * from STOREENT > STOREENT.csv
   select * from STORECENT > STORECENT.csv
   select * from STORECGRP > STORECGRP.csv
   select * from CATGRPREL > CATGRPREL.csv
   select * from DISPCGPREL > DISPCGPREL.csv
   select * from DISPENTREL > DISPENTREL.csv
   select * from CATTOGRP > CATTOGRP.csv
   select * from STORECAT > STORECAT.csv
   select * from STORE > STORE.csv