MustGather: Massload Utilities Issues in WebSphere Commerce V7.0

Technote (troubleshooting)


Problem(Abstract)

MustGather: Massload Utilities Issues in WebSphere Commerce V7.0

Resolving the problem


Gathering this MustGather information before calling IBM Support will help familiarize you with the troubleshooting process and save you time.

To improve the accuracy of complete data collection, IBM recommends you use the automated data collectors within IBM Support Assistant. Not only will the automated collector gather the equivalent of the manual process, it will also provide a secure file transfer of the collection to IBM.

IBM Support Assistant Lite IBM Support Assistant Lite (ISA Lite)
A special offering that contains just the data collector component of the IBM Support Assistant Workbench
Download  |  Demo  |  Screenshot  |  Learn more
IBM Support Assistant Workbench IBM Support Assistant Workbench (ISA Workbench)
For a full range of problem solving features, the workbench contains all the data collection capability of ISA Lite plus much more!
Download  |  Demo  |  Screenshot  |  Learn more

Collecting data using IBM Support Assistant

ISA Lite

  1. Download ISA Lite and extract it to a directory in your file system.

  2. Start ISA Lite by running runISALite.[sh|bat] .

  3. Select the following collector:
    WebSphere Commerce V7.0 > Utilities > Massload Utilities

  4. Follow the prompts to automatically submit the collected data to IBM Support.

ISA Workbench

  1. Download and install the ISA Workbench.

  2. Install the product add-on for WebSphere Commerce V7.0.

  3. Open the Workbench and navigate to the Collect and Send Data page.

  4. Select the following collector:
    WebSphere Commerce V7.0 > Utilities > Massload Utilities

  5. Follow the prompts to automatically submit the collected data to IBM Support.

Collecting data manually


Considerations before collecting data
Take note of the following before collecting the information described below:

    Related WebSphere Commerce MustGather's
    This document is specific to the massload loader utilities. If the Dataload utility is being used, refer to the Dataload MustGather.
    MustGather: Data Load Utility


I. Configure environment

Follow the instructions below to configure your environment to capture the required diagnostic information:

  1. Additional configuration steps
    1. In addition to the individual logs for some of the loading utilities, you can configure an additional message log file, messages.txt, and a trace file, traces.txt, for the loading utilities. This can be helpful in getting more information to help determine any problems you may encounter. You can configure the contents and location of these files by editing the WCALoggerConfig.xml file. Follow the link below to enable tracing for the loader utilities before reproducing the problem.
      http://publib.boulder.ibm.com/infocenter/wchelp/v7r0m0/index.jsp?topic=/com.ibm.commerce.data.doc/tasks/tml_config_tracing_logging.htm


II. Reproduce problem

  1. Provide the exact usage of the utility that was used , including all parameters provided.
  2. Provide any input and output files that were used and created from the loader utilities.


III. Collect data

Collecting general product information
Include the general information requested in MustGather: General Issues in WebSphere Commerce V7.0 alongside the component-specific information requested below.

  1. Collect the following files from the system:
    1. WC_installdir/logs/messages.txt1
    2. WC_installdir/logs/trace.txt2
  2. Collect the contents of the following directories from the system:
    1. WC_installdir/logs3
  3. *Naming conventions can be found here.


    • -What are these files?
      1 Loader utility log
      2 Loader utility trace
      3 May contain other log outputs used by loader utilities

  4. Run the following database queries to collect the necessary information from your database (output results in CSV format):
    Query Output file name
    SELECT * FROM KEYS KEYS.csv
    DB2 SELECT * FROM SYSCAT.TABLES SYSCAT_TABLES.csv
    DB2 SELECT * FROM SYSCAT.INDEXES SYSCAT_INDEXES.csv
    DB2 SELECT * FROM SYSCAT.REFERENCES SYSCAT_REFERENCES.csv
    Oracle SELECT * FROM ALL_CONS_COLUMNS A JOIN ALL_CONSTRAINTS C ON A.CONSTRAINT_NAME = C.CONSTRAINT_NAME WHERE C.CONSTRAINT_TYPE = 'R' SYS_ALL_CONSTRAINTS .csv



Submitting data to IBM Support

To diagnose or identify a problem, it is sometimes necessary to provide Technical Support with data and information from your system. In addition, Technical Support might also need to provide you with tools or utilities to be used in problem determination. You can submit files using one of following methods to help speed problem diagnosis:


Rate this page:

(0 users)Average rating

Document information


More support for:

WebSphere Commerce Enterprise
Utilities/Tools

Software version:

7.0

Operating system(s):

AIX, Linux, Solaris, Windows, i5/OS

Software edition:

All Editions

Reference #:

1454426

Modified date:

2013-05-21

Translate my page

Machine Translation

Content navigation