DSXchange

Thank you very much ArndW We are using Sun solaris 5.10(is this the UNIX flavor ?) , normally i do verify prstat, vmstat which i think more of CPU related, i shall understand & verify iostat and get back :) Thank you very much once again!!! (I'm depressed, I wrote a long post and it has disappea...

If the %CPU use on the DataStage system during job run is not above 80% then your job is not CPU bound, but most likely I/O bound. ... Hello, That was a wonderful piece of information i found after long search. "Thanks ArndW!!!" I would like dig further to know the execution process of Se...

suchitta_b wrote:Please provide a solution to my problem..

Hi Suchitta,

Did this issue get resolved ?
We are facing similar problem, it would be of great help if you could provide assistance.

Thank you very much in advance.

regards

Hello there,

yes i noted it, I am verifying witihin IBMs website,
Thank you very much for your reponse!!!

ArndW wrote:If you look at the dates you would see that this problem is over 3 years old. Patches are generally available for download once you login to IBM's website . ...

Hello there,

Could you let me know from where the patch can be downloaded?

Thank you very much for your help

ArndW wrote:The "patch" is an Ascential one and the tip did not come from me (I was the one looking for help) but from Klaus Schaefer. Click here for the link

Hello Klaus is the patch available for download from IBM/ASCENTIAL website? Thank you very much for your help in advance!!! regards Murugan Ramachandran Hi Arnd, I still have that patch. Here's what the readme says: Brief description of problem (ecase 70788) =========================================...

Hello Klaus is the patch available for download from IBM/ASCENTIAL website? Thank you very much for your help in advance!!! regards Murugan Ramachandran Hi Arnd, I still have that patch. Here's what the readme says: Brief description of problem (ecase 70788) =========================================...

Hi all, When I try to export a job or project, I'm getting the error message as below. unexpected error;quitting Then once I click the Ok button, I'm getting the below message. MyCreateObject: Internal error - Could not create object with OLEType=VMDatastage.CDSRProgress After clicking OK button, I...

Hi friends, May i have some info. on Aggregator.I have a job in which there are all together 10 stages. 3 lookups | | | source drs---->aggr---->trsfrmr----->trsfrmr----->target drs | | 2 more targets My source have app. 10 lakh records.I have given derivation for one of the columns in the agg. stag...

Hello Robin, Thank you for details. Actually i have not faced any problems, Since there isnt any bad hash file definition or coz of arraysize. My question was a general one to understand whether there will be impact, well ahead before i set the array size for the each OCI stage. Anyways i got info, ...

Hi All, What are the steps to be followed to export jobs from one project to another project? Thanks Hi Shreya, You need to make sure that all dependant jobs are available, as well as routines, transforms whichever used if any and make sure that the new project has the same configuration similar to...

Hi, With regard to tuning, i saw in forums that we can increase the Array size of OCI stage for better performance. Scenario is as mentioned. I have a job in which am retrieving data from many individual tables and writnig into hash files for further processing as per the business rules. Number of s...

I have just created a text file with 100 lines and contents like "2007-01-01", "2008-02-02" then wrote a job to read, sort and write it to another text file. Regardless of whether I define it as DATE(10) or VarChar(10) it works correctly. Hi ArndW, Kindly excuse, i could not vie...

I given the DATE column as key also but still the output is same. I think in sequential file stage the key has no significance. I'll explain the job in detail say:My job has one Input and Ouput sequentail file stage in between one sort stage is present which is sorting the DATE column. I have three...

Hi.. we can convert A-data type to iconv and do the same for B also.after that we can subtarct the things.then finaly we can convert to oconv.i think it will solve your problem.kindly put your commands. Regards kimbal Hi Kimbal, Sound the same as Ray, it is how we handle, Iconv(DATE1[1, 8], "D...