Hi All,
I did the
echo "`hostname` has `kstat cpu_info | grep core_id | uniq | wc -l` cores"
on DEV ,QA and PRD and the results are below
dev - 64
qa - 64
prd - 8
Thanks,
Naren
Search found 230 matches
- Thu Jan 26, 2012 11:55 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Performance DEV Vs QA Vs PRD
- Replies: 11
- Views: 5904
- Wed Jan 18, 2012 4:27 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Performance DEV Vs QA Vs PRD
- Replies: 11
- Views: 5904
- Mon Jan 16, 2012 1:07 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Performance DEV Vs QA Vs PRD
- Replies: 11
- Views: 5904
Performance DEV Vs QA Vs PRD
Hi All,
My jobs are running pretty good in DEV and QA, but not in PRD.
One of my job is running under 15 min in DEV and QA and the same job is taking 90 min in Production.
Please let me know , what could be the main reason?. Please shed some light on it.
Thanks,
Naren.
My jobs are running pretty good in DEV and QA, but not in PRD.
One of my job is running under 15 min in DEV and QA and the same job is taking 90 min in Production.
Please let me know , what could be the main reason?. Please shed some light on it.
Thanks,
Naren.
- Wed Aug 03, 2011 10:19 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: SEQ File
- Replies: 3
- Views: 2402
SEQ File
Hi All,
How can we read a sequential file data based on Column Header as i am interested in only few columns.
Any input would be highly appreciated.
Thanks in advance.
How can we read a sequential file data based on Column Header as i am interested in only few columns.
Any input would be highly appreciated.
Thanks in advance.
- Sun Jul 31, 2011 5:26 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Delimiter
- Replies: 3
- Views: 2329
Delimiter
Hi All,
How can we use 3 characters(@#$) as field delimiter while reading a text file using Sequential file stage either in server or parallel.
But, I checked the documentation and it says it will allow only one ASCII character.
Please shed some light on this.
Thanks in advance.
How can we use 3 characters(@#$) as field delimiter while reading a text file using Sequential file stage either in server or parallel.
But, I checked the documentation and it says it will allow only one ASCII character.
Please shed some light on this.
Thanks in advance.
- Mon Dec 13, 2010 10:13 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: CSV file with column value with double quote
- Replies: 4
- Views: 3645
CSV file with column value with double quote
Hi,
I am trying to read a csv file which has data like..
abc,bcd,hh"k"lmn
How can i remove the double quotes around "k" and read the file?
any input would be hoghly appreciated.
my current settings are
seqfile stage with comma delim and quote=double.
Thanks,
I am trying to read a csv file which has data like..
abc,bcd,hh"k"lmn
How can i remove the double quotes around "k" and read the file?
any input would be hoghly appreciated.
my current settings are
seqfile stage with comma delim and quote=double.
Thanks,
- Mon Nov 15, 2010 7:03 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Environment variable
- Replies: 2
- Views: 2424
Recently, my jobs got aborted with /tmp space issue where i sorted the two huge files. so we changed the UVTEMP to different directory as per the suggestion. So, in that case changing the /tmp directory means changing the UVTEMP variable or setting up the TEMP in dsenv?. I am confused. Please clarif...
- Mon Nov 15, 2010 6:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Environment variable
- Replies: 2
- Views: 2424
Environment variable
Hi, I have a Variable TEMP defined in dsenv file. The question is, My job(IPC/LC stage) is using TEMP variable defined in dsenv instead of UVTEMP in UVCONFIG file. Is server jobs supposed to use UVTEMP variable value for temporary purpose or does it override with TEMP in dsenv file?. Please clarify....
- Fri Nov 05, 2010 11:43 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Unable to open the operating system file "/tmp/select04
- Replies: 2
- Views: 1918
Unable to open the operating system file "/tmp/select04
Hi All,
The job was running fine and suddenly it got aborted with the following error.
Unable to open the operating system file "/tmp/select04292aa".
Aborting!
[ENOENT] No such file or directory.
Any clues please.
Thanks,
Naren
The job was running fine and suddenly it got aborted with the following error.
Unable to open the operating system file "/tmp/select04292aa".
Aborting!
[ENOENT] No such file or directory.
Any clues please.
Thanks,
Naren
- Tue Nov 02, 2010 6:04 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: keyMgtGetNextValue
- Replies: 3
- Views: 3048
Yes, but with the 'multiple jobs, same table, same time' requirement, make sure you use the 'Concurrent' version. ... Thanks for the reply Craig. I need to generate multiple sequence numbers for multiple tables withing the same job. And the above mentioned sdk has argument called 'SequenceName'. co...
- Tue Nov 02, 2010 5:41 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: keyMgtGetNextValue
- Replies: 3
- Views: 3048
keyMgtGetNextValue
Hi All, I am loading the same tables from different jobs at the same time.right now, i am using the database sequence and which is executing millions of times and that is overhead to the process now. So, can i use the keyMgtGetNextValue sdk routine/transform to generate the surrogate key? Please adv...
- Mon Sep 06, 2010 9:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hashed File Stage
- Replies: 1
- Views: 1853
Hashed File Stage
Hi All,
I have a question on using Hashed File Stage.
Is it a better idea to use single Hashed File Stage with multiple links or Multiple Hashed File Stages for look up purpose? And what is the impact on performance?
Please suggest me.
Thanks in advance.
I have a question on using Hashed File Stage.
Is it a better idea to use single Hashed File Stage with multiple links or Multiple Hashed File Stages for look up purpose? And what is the impact on performance?
Please suggest me.
Thanks in advance.
- Mon Apr 19, 2010 9:05 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Running multi instance job from sequence job
- Replies: 10
- Views: 5882
- Mon Apr 19, 2010 7:58 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Running multi instance job from sequence job
- Replies: 10
- Views: 5882
Thanks but nothing is helping so I'll just post the same error again? :? SH: dsjob: not found The SHell cannot find the 'dsjob' command. This is because, as Ray noted, its home directory is not in your PATH environment variable. One option to 'fix' that is to fully path the command, as I noted. Thi...
- Mon Apr 19, 2010 6:34 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Running multi instance job from sequence job
- Replies: 10
- Views: 5882