General Issues user may face while configuring Teradata Connector in IBM InformationServer & Resolutions

Issue # 1:
Teradata_Connector_1: Error loading connector library libcctera12.so. libtelapi.so: wrong ELF class: ELFCLASS32 (CC_LoadedConnector::loadLibrary, file CC_ConnectorFactory.cpp, line 1,525)

Probable Reason :

Normally this issue may arise due to Configuration issues/ improper Library files.

Resolution:

If Teradata client version 13.10 is being used on RH Linux64 bit server, then We should have below path
/opt/teradata/client/13.10/tbuild/lib64 also included in LD_LIBRARY_PATH


In case of 32-bit server, please assign this path /opt/teradata/client/13.10/tbuild/lib to LD_LIBRARY_PATH
 


Issue # 2:

Teradata_Connector_3,0: RDBMS code 21012: Could Not Find Message Catalog opermsgs.cat  SQL statement: INSERT INTO TDCC_TMSM_BLK(c1,c2) VALUES(:c1,:c2) (CC_TeraParallelTransporter::initiate, file CC_TeraParallelTransporter.cpp, line 1297)

Probable Reason:
This issue / error will appear in DS director when   environment variable LANG  &  NLSPATH  is not set.

Resolution:  
Please set  environment variables
       LANG=en_US
       NLSPATH=/opt/teradata/client/13.10/tbuild/msg/%N



Issue # 3:

The file "errmsg.cat" cannot be opened.

Add below env variables to resolve issue.

    COPLIB=/opt/teradata/client/13.10/lib64
    COPERR=/opt/teradata/client/13.10/lib64


Disclaimer: “The postings on this site are my own and don’t necessarily represent IBM’s positions, strategies or opinions.”

Usage of Orchadmin commands in DataStage

Some times  DataStage engineers would want to work with Orchestrate commands.Below is quick reference of 'orchadmin' commands

Enable Osh / orchestrate commands  to run 'orchadmin' commands

To enable 'orchadmin' command  from command line,  

please set APT_ORCHHOME variable with appropriate PXEngine folder

You can apply below commands to work with Datasets

A) To Copy the DataSet :

orchadmin copy  <source dataset name>   <target dataset name>

B)To Delete the DataSet:

      orchadmin delete  <dataset name>

                  (or)

      orchadmin rm  < dataset name >

C) To Truncate DataSet :

orchadmin truncate <dataset name>

 


Disclaimer: “The postings on this site are my own and don’t necessarily represent IBM’s positions, strategies or opinions.”

IBM Information Server Document link

Hello DataWarehouse Experts / Professionals,

I would start my blog with documentation  of IBM Information server.
 Below is the link  for IBM Information Server
http://www-01.ibm.com/support/docview.wss?uid=swg27008803
Thanks
Yoga


Disclaimer: “The postings on this site are my own and don’t necessarily represent IBM’s positions, strategies or opinions.”