IBM Support

Collecting data for InfoSphere Optim™ Solution

Question & Answer


Question

To clarify a problem with IBM® Optim™ solution and save time, what information should I collect before contacting IBM Optim support ?

Answer


Situation
Questions that you should consider, depending on the circumstances of your issue.

  • What version of Optim are you running?
  • What operating system and version is the Optim server running on, if applicable?
  • What database and version hosts the Optim directory?
  • Is the database for the Optim directory 64-bit or 32-bit?
  • Is the client for the Optim directory database 64-bit or 32-bit?
  • What connections to databases using Optim database aliases are involved?

Information to Collect
The following is required for all issues with IBM® Optim™ solution.
  • Text of any error or errors that you receive
  • The Optim process that caused the error
    (Extract, Archive, Insert, Convert, Load, etc.)
  • The process report, depending on the process that caused the error
  • The trace files (See below on where these are located);
    • If the error occurs on an Optim server gather PR0SVCE, PR0SVER and potentially PR0CMND files
    • If the process is run on Windows, PR0TOOL file
    • If the error occurs during the configuration of Optim (Windows only), PR0CNFG file

Extract issues, if possible to collect:
Please note that a license for Test Data Management (TDM) solution is required to gather the following.
  • An extract file containing 100 rows of data
  • The Access Definition used to specify the extract

Load Issues:
Send an Export of the load request, and provide what database this is running against

Column Map or Table Map Issues:
Send an export of their related definitions

Locating Optim's trace files:

Windows:

From the main Optim window choose Options -> Personal. Under the General tab, the trace files will reside in the path defined to the Temporary Work Directory.

Unix:

The Temporary Work Directory is defined under the tempdir keyword within the pstserv.cfg file - located in <Optim install dir>/rt/etc. Conversely, when running a PR0CMND job, the PR0CMND trace files will reside in the tempdir defined within the pstlocal.cfg file, which is also located in <Optim install dir>/rt/etc.

What to do next


Once you have gathered the above data, use the ECuRep Upload Service to send your data to IBM.

For a listing of all technotes, downloads, and educational materials specific to the InfoSphere Optim, search the InfoSphere Optim Support Portal.

[{"Product":{"code":"SSGMCR","label":"Optim"},"Business Unit":{"code":"BU001","label":"Analytics Private Cloud"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.1;7.3.1;7.3;7.2.2;7.2.1;7.2.0;7.2;7.1.2;7.1.1;7.1.0;6.5.1;6.5.0;6.4.1;6.4.0;6.3.3;6.3.2","Edition":""}]

Document Information

Modified date:
03 June 2019

UID

swg21409349