DSXchange

Requirement : Try to find out the Running DS job , which is consuming more CPU On the DS Server. Method adopted to achive the Requirement: STEP-1: Try to get the CPU stats using VMSTATS command. If the cpu usage is grater than the Threshold limit(say 85%) based on the ouput from VMSTAT then STEP-2:...

Hi, We have a project requirement where we have to find out all the processes forked by a Datastage job and to check if any of those processes are utilizing excessive CPU or IO. This will be done with a shell script. Please help me out in finding a way in which we can - 1. List all the processes cre...

Hi..

My column datatype is decimal. so can you please let me know how to populate null for that coumn. If i use setnull() then , all the 0 values are also populating as null.

Please reply


Thanks

You'll probably spend more writing and testing your own data masking routines, test data management systems (you need to preserve relationships between tables) and control systems than you would to purchase Optim. Thanks Ray For your valuable time on this post. I will definatly work on this and wil...

dr.murthy wrote:Hi,

can you just tel me if any one aware of the mean of datastage is down

When you say Datastage is dowm means dsrpc is not running.
Please run below command on Unix.

ps -ef |grep dsrpc

It would be great if you can send complete information on your issue.There is no point to confuse people.

dssubhani wrote:can we do some parallel jobs & some sequence jobs in a project?

can you please elaborate your requirement more?

ray.wurlod wrote:My initial thought is that the Optim product from IBM does all this and more.

Thanks Ray for quick Turn Around !!!

I am in a process to Get Optim tool but thats my last option.
If there is anyway same thing i can do with Datastage then i don;t see to invest lot of Dollars on tool.

Please respond on this post!!! We must have our questions answered. Thanks Ray for eagerly waiting fo my answers !!! i thought that some one might have came across this requirement and they can understand my requirement but it was my mistake that i should give more information so people can underst...

hi,

Did you go through the manual of Datastage for Looup file stage.
while doing a Lookup with lookup File stage it is very Important to define the Key Columns and if you won;t specify the key columns in other than filestage it will not give you output.

Please advice on this post !!!

HI Everyone, I am Looking to create a automated process where i want to bring real time Production data to QA environment after doing a data scrubbing on PII information. The main reason to perform above task will help Testing team to setup test data on QA env. Any idea on any function which i can u...

What Database you are using as target?

Shamshad, Thanks for great input. We just removed the password file and recreated the file and there you go....Jobs in production ran exactly as in QA. Thank You All once again. I have faced the same problem, could you please explain me what is the password file? since i have to ask my administrato...

No. You need to profile each record type separately. If there are fields that are common to different record types and you want to profile all of those, you need to assemble them into a single place, such as a temporary table. Thanks Ray for quick Reply!! Let say if i Maintain the reationship betwe...

Hi What is the difference between Sparse Lookup and Normal Lookup? When you have large amount of data comming from source its better to use normal lookup and if you are having incremental comming better go for sparse so that the performance will be good and when you use sparse look up use ORCHESTRA...