DSXchange

Hi All,
Thank You for your valuable inputs. Currently we have improved the performance by changing our source queries and shifting the load on to database rather then doing everything in Datastage. I will keep you posted about the developments. Thank You.

Punar Deep Singh

Hi All, We are using Server jobs in our project and we got a requirement in which we need to process large amounts of data. The jobs need to run on the monthly basis and the data files are received on daily basis. We are loading the data files into our Source tables (Oracle 10g) on daily basis and a...

Hi ArndW,
Our UNIX admin was not able to provide any other workaround for this issue. So, we will be going for creation of new projects as we can not delete any of the existing jobs. Thank you for the help that you have extended.

With Regards,
Punar Deep Singh

Hi ArndW,
Our UNIX admin was not able to provide any other workaround for this issue. So, we will be going for creation of new projects as we can not delete any of the existing jobs. Thank you for the help that you have extended.

With Regards,
Punar Deep Singh

Hi ArndW,
Thank you for the help. I agree that we have hit the OS limitation.
Our Unix admin is trying to resolve this issue by taking some other steps. I will update you once he is done with the same and if the issue gets resolved.
Thank you once again.
Punar Deep Singh

Hi ArndW, Thank You for the response. I tried to create a dummy directory in the project directory and got the below mentioned message: mkdir: 0653-358 Cannot create dummy. dummy: There are too many links to a file. We are using AIX version 5. Unfortunately i was not able to run your below command a...

Hi all, i am doing a server Job.The job design is as below. Oracle OCI as source.there are 8 lookups in the job.For each lookup i am using OCI stage then hash file then all hash files are connected to Transformer.Out of eight lookup one table is having 3.5 millon records where as other 7 has less th...

Hi Craig,

Thank you for all the help. The issue got resolved. It was some permission problem on the plug in stage directory in the Unix box.

Thank you once agian.

Regards,
Punar Deep Singh

Hi Craig, Thank you for the reply. I do agree that when we use some plug-in stage in a job while development, we need have that stage in the production environment also. Please let me know if i take the executable of the job which is using the Plug-in stage will the code of the Plug-in stage also mo...

Hi All, I am having one job in my development box in which i am using a SORT stage. The job is running fine in the Dev box and i moved the job from the Dev server to the Production server. I moved only the Job executable. Now the job is failing in the Production server with the below mentioned messa...

Hi All,
Can anybody please let me know what exactly "DataTypePicComp3Unsigned " function does.


Thanks in Advance
Ashik Mirza

Two options are either output to a CFF stage and make DataStage do the conversion for you or use the sdk builtin routine "DataTypePicComp3Unsigned" to explicitly convert that value to the binary representation. i am trying to use the routine "DataTypePicComp3Unsigned" But the pr...

Hi Everyone,
I am trying to convert decimal of 5,2 and 4,0 to packed decimal.
If anybody has the solution ,Can you please shere with me.
Thank in advance
Ashik

Hi All, I am having 2 projects out of which one is development and the other one is for ST purpose.I worked on one job say 'Job1' and tried to move the job from dev to ST, the job design was already present in ST. But when i tried to import the same job in ST i am getting the following error: Cannot...

Hi Ray/Craig, We have been getting lots of posting regarding the Timeout issue. What i feel is that when we give a command to run the job all the connection with the database are established. Now in the above stated problem in the job he is reading data from the source file and then doing the aggreg...