IBM Support

MustGather - troubleshooting data for DB2 SQL errors seen in WPG system

Troubleshooting


Problem

Collecting data for DB2 SQL error problems with IBM WebSphere Partner Gateway (WPG). Gathering this MustGather information before calling IBM support will help expedite problem analysis.

Resolving The Problem

This section instructs the items of documentation required by the IBM WPG support team to diagnose the problem.

  • Firstly, gather the following required information and input as PMR description:

    • Operating system, version and patch level:
    • WPG version and fixpack level:
    • Database, version and fixpack level:
    • WAS (or WAS ND) fixpack level:
    • WPG Topology (Simple/Simple Distributed/Full Distributed?):
      (For instructions on how to get above information, refer to WPG ReadFirst Technote. )
    • Is DB2 server located on a remote machine than WPG Hub?
    • A clear, specific problem scenario.

  • Secondly, please collect the required data and upload them to PMR:


    • 1. Enable debug trace for the WPG server which is causing the error.
    1. Start the WAS administrative console.
    2. Click Troubleshooting > Logs and Trace
    3. Select server name where you observed the error.
      (e.g. Simple mode: 'server1'; Simple distributed: 'bcgmas' or 'bcgserver'; Full distributed: such as 'bcgconsole', depends on component)
    4. Click Change Log Level Details.
    5. Select the Configuration tab.
    6. Enable the components logging by entering the below trace string:
      *=info:com.ibm.bcg.*=finest
    7. Click Apply.
    8. Save the changes, restart the affected server(s).


    2. Perform the problematic scenario.


    3. Collect DB2 Support data:

      In DB2 Command Line Processor, run the 'db2support' command (by a user with SYSADM authority, such as an instance owner) to collect DB2 and system diagnostic information required to debug a problem. (Note that the -c option is used the db2support utility will establish a connection to the database):
        db2support <output_path> -d <database_name> -c

      The output is collected and stored in a compressed ZIP archive, db2support.zip. See this link for more information on the db2support command.


    4. Compress and collect the WPG logs from the following directory:

      WPG_HUB_HOME/wasND/Profiles/<bcgprofile>/logs/<server_name>


    5. Follow the instruction to send data to IBM Technical Support.



    Related information

    [{"Product":{"code":"SSDKJ8","label":"WebSphere Partner Gateway Enterprise Edition"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"6.2.1;6.2;6.1.1;6.1","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSDKKW","label":"WebSphere Partner Gateway Advanced Edition"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":null,"Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"6.2.1;6.2;6.1.1;6.1","Edition":"","Line of Business":{"code":"LOB02","label":"AI Applications"}}]

    Product Synonym

    WPG;WebSphere Partner Gateway

    Document Information

    Modified date:
    16 June 2018

    UID

    swg21454371

    Page Feedback