Oracle Connector, Oracle Enterprise Stage, Oracle OCI Plugin, DRS Plugin
Oracle Enterprise Stage information
- If a segmentation fault occurs before the job aborts, set environment variable APT_NO_PM_SIGNAL_HANDLERS equal to 1 and re-run the job. The core file will now be produced and can be found in the project directory. Obtain the stack trace from the core file after sourcing dsenv and send stack trace to IBM Support.
- To enable Oracle Enterprise trace, define environment variable APT_DEBUG_MODULE_NAMES and set it equal to one or more of the following values: oraread, orawrite, orautils, oralookup. For example, to debug an upstream (reading) Oracle Enterprise stage, define APT_DEBUG_MODULE_NAMES='orautils oraread'
AIX, Solarix, Linux, or HP-UX
Commands
|
Description
|
ls -l <IS_HOME>/Server/DSComponents/bin > <TEMP>/dscomplist.txt
|
List of libraries used. Send dscomplist.txt generated.
|
. <IS_HOME>/Server/DSEngine/dsenv
Linux:
gdb `which osh` <IS_HOME>/Server/Projects/<project name>/<core_file_name>
gdb> where
AIX: Same as Linux but use dbx command instead of gdb.
|
Core files produced by jobs will be found in the project folder.
Define environment variable APT_NO_PM_SIGNAL_HANDLERS to allow core file generation. To get the stack trace from the core file, use dbx on AIX, or gdb on Linux. Run the where command after runningdbx or gdb to obtain the stack trace. Copy the stack trace shown and send to IBM Support for analysis. |
Commands
|
Description
|
dir /S <IS_HOME>\Server\DSComponents\bin > <TEMP>\dscomplist.txt
|
List of libraries used. Send dscomplist.txt generated.
|
Oracle OCI Plugin
AIX, Solarix, Linux, or HP-UX
Commands
|
Description
|
ls -l <IS_HOME>/Server/DSComponents/bin > <TEMP>/dscomp_ocilist.txt
|
List of libraries used. Send dscomp_ocilist.txt generated.
|
. <IS_HOME>/Server/DSEngine/dsenv ldd <IS_HOME>/Server/DSComponents/bin/oraoci* |
Library dependency check. Source dsenv, and then run ldd against each Oracle oci library.
|
Commands
|
Description
|
dir /S <IS_HOME>\Server\DSComponents\bin\oraoci*dll > <TEMP>\dscomp_ocilist.txt
|
List of libraries used. Send dscomp_ocilist.txt generated.
|
set PATH=<Path value from job log>
<PATH_TO_DEPENDS.EXE>\depends.exe <IS_HOME>\Server\DSComponents\bin\oraoci*dll
|
Library link check. Set environment variable PATH equal to the value of PATH from the DataStage job log and then run Dependency Walker on the library to check dependencies. Save the Dependency Walker image as a dwifile and send to IBM Support.
|
DRS Plugin
AIX, Solarix, Linux, or HP-UX
Commands
|
Description
|
ls -l <IS_HOME>/Server/DSComponents/bin/drs* > <TEMP>/dscomp_drslist.txt |
List of libraries used. Send dscomp_drslist.txt generated.
|
. <IS_HOME>/Server/DSEngine/dsenv ldd <IS_HOME>/Server/DSComponents/bin/drs* |
Library dependency check. Source dsenv, and then run ldd against each Oracle oci library.
|
Commands
|
Description
|
dir /S <IS_HOME>\Server\DSComponents\bin\drs*dll > <TEMP>\dscomp_drslist.txt
|
List of libraries used. Send dscomp_drslist.txt generated.
|
set PATH=<Path value from job log> <PATH_TO_DEPENDS.EXE>\depends.exe <IS_HOME>\Server\DSComponents\bin\drs*dll |
Library link check. Set environment variable PATH equal to the value of PATH from the DataStage job log and then run Dependency Walker on the library to check dependencies. Save the Dependency Walker image as a dwi file and send to IBM Support.
|
Oracle Connector
AIX, Solarix, Linux, or HP-UX
Commands
|
Description
|
ls -l <IS_HOME>/Server/DSComponents/bin/ccora* > <TEMP>/dscomp_ccoralist.txt |
List of libraries used. Send dscomp_ccoralist.txt generated.
|
. <IS_HOME>/Server/DSEngine/dsenv ldd <IS_HOME>/Server/DSComponents/bin/ccora* |
Library dependency check. Source dsenv, and then run ldd against each Oracle oci library.
|
Commands
|
Description
|
dir /S <IS_HOME>\Server\DSComponents\bin\ccora*dll > <TEMP>\dscomp_ccoralist.txt
|
List of libraries used. Send dscomp_ccoralist.txt generated.
|
set PATH=<Path value from job log> <PATH_TO_DEPENDS.EXE>\depends.exe <IS_HOME>\Server\DSComponents\bin\ccora*dll |
Library link check. Set environment variable PATH equal to the value of PATH from the DataStage job log and then run Dependency Walker on the library to check dependencies. Save the Dependency Walker image as a dwi file and send to IBM Support.
|