Something about DataStage, DataStage Administration, Job Designing,Developing, DataStage troubleshooting, DataStage Installation & Configuration, ETL, DataWareHousing, DB2, Teradata, Oracle and Scripting.
Tuesday, February 17, 2015
DataStage UNIX Commands
I've been asked so many times for Unix/Linux command which we usually used in DataStage. Here, I have tried to compile them together, please let me know if I missed something here. Njoy ....... :)
•Check the permissions
1.Log on to server as dsadm or root
2.cd $DSHOME/bin
3.ls -l | grep rws
The output should be (6) files owned by root with the setuid bit set -- especially the uv file.
Wednesday, February 11, 2015
"Current Informix Installation Detected" message during installation
I am sharing this IBM tip on Cognos here again as it helped my from a big trouble :-) , Thought for a worth sharing ......
Cause
1. A separate, standalone version of Informix is installed on the host (or leftovers are found in the Windows registry)
2. IBM Cognos Express has been installed and reinstalled and the Informix registry entries were not removed properly.
3. The Windows user "informix" is present on the host because Informix had been installed on the system in the past.
3. The Windows user "informix" is present on the host because Informix had been installed on the system in the past.
Friday, February 06, 2015
Order of temporary disk space uses by Sort stage
The Sort stage uses temporary disk space when performing a sort. It looks in the following locations, in the
following order, for this temporary space.
1. Scratch disks in the disk pool sort (you can create these pools in the configuration file).
2. Scratch disks in the default disk pool (scratch disks are included here by default).
Wednesday, February 04, 2015
Modify Stage - TRIM function
For trimming spaces or a char from a string can be done in modify stage. Below, I have shared the function syntax and some example, go Play ;-)
string_trim[character,direction,justify](string)
or
string_trim[character,direction](string)
or
string_trim[character](string)
or
string_trim(string)
Tuesday, February 03, 2015
Modify Stage - Handling NULLs
For handling the NULL value in columns we can use modify functions in DataStage instead of Transformer. Rather, I'll always prefer a transformer to avoid unnecessary effort which we put to setting up modify stage. But sometime to tune the job over performance we have to do that ;-)
The below Function Specification we have to use to Handle NULL --
The below Function Specification we have to use to Handle NULL --
Monday, February 02, 2015
Encrypt Password for DataStage Command Line
As datastage
user, we need lots of scripts help our daily jobs,
most of these scripts need authenticated by datastage engine, that means we
need to pass our Datastage user password in script or command line.
But there is a problem if we are using "Password" here, It can be view by checking the content of script or command history. To secure password, there is a way provided by datastage and that is ENCRYPT the password before using. Let's see how we can do that ---
But there is a problem if we are using "Password" here, It can be view by checking the content of script or command history. To secure password, there is a way provided by datastage and that is ENCRYPT the password before using. Let's see how we can do that ---
Labels:
Administration
,
DataStage
,
encrypt
,
Shell
,
shell scripting
,
tips
Subscribe to:
Posts
(
Atom
)