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'
Use the following commands to gather and generate the files described above.




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.
Windows
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.
Windows
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.
Windows
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.
Windows
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.

 

Popular posts from this blog

Shrink you container size up to 95%.

alma linux: dnf Module yaml error: Unexpected key in data