Post of the day
DataStage

DataStage DB2 Connector error while changing the instance na...

One of the recent error I faced with DB2 Connector in V9.1.2 DB2 Connector stage was created originally with a particular DB2 instance name (eg. Instance 1 DB) and then one goes back into the DB2 Connector to change the DB2 Instance name to a different Instance name (eg. Instance 2 DB), and test the…

DataStage

DataStage Errors while trying to write records to DB2 Connec...

One more annoying error that I faced yesterday when I tried to Load data on to a DB2 database It took lot of hours to find the root cause of the problem even though every thing looks fine in Job [alert-warning]DB2 function SQLFetch failed:  SQLSTATE = HY000: Native Error Code = -1,042: Msg = [IBM][CLI…

BI & DW

DataStage Errors while viewing data using View Data on Oracl...

Most of the times the following error occurs for “view data” and “test connection” actions in Connector stage properties, even though the job itself runs successfully without any warnings [alert-warning]An Exception occurred while trying to receive the response form the handler: An exception was received from the handler: Error loading connector library libccora10g.so. libcIntsh.so.10.1: cannot…

Information Server

How to Enable Connector Debugging levels in DataStage

I have recently faced couple of errors and I tried to debug with Standard errors and I am not able to debug much and fix the errors while developing the jobs Here are the some steps to enable Debugging in Connector Stages in DataStage Designer (However these variables cannot be used in PROD without a…

DataStage

Compiling and using Parallel routines in DataStage

A parallel routine provides you feature to use external functionality written in C code to use in DataStage. E.g.  DataStage does not provide regular expression functionality. So we can created shared object of regular expression functionality in C and used it in DataStage. Before we start writing routines: -Some compilers require that the source code…

DataStage

Puzzled !! Maximum DataStage jobs can be created in a Projec...

Have you ever puzzled about number of Jobs that can fit in a DataStage project – Here is the answer on How much space is required to accommodate as well DataStage runs on a Host Operating System and runs a file system Said that, Filesystems have a hard limit on number of sub directories that…