Post of the day
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. Notes: -Some compilers require that the source code extension be “C” not…

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…

BI & DW

DS Job Corrupted : Errors when writing record OshExecuter.os...

When you are trying to move jobs or import into Higher regions such as Quality control, User Testing and Integration regions and you receive the following error: Error writing record OshExecuter.sh to file RT_SC<job number> – error number is 40019 Below are the possible items that might corrupt the jobs Full disk space in the…

DataStage

DataStage job doesn’t terminate/ slowness while termin...

If your DataStage takes time to terminate/ you experience delays in the termination of an a job when it is run – you need to clear out &PH& directory This happens when you don’t clean &PH& periodically. The &PH& directory contains information about active stages that is used for diagnostic purposes To clear the directory:…