DSXchange

Hi Craig,

Sorry for late reply, Admin level setting for auto purge logs is previuos 2 runs. How to handle this scenario without changing this setting.

Hi All,

I have a multi instance job which creates around 67 Instances, after sequence is completed, all the instances are vanished? what setting i need to do at Admin level. Can anybody help on this please.

Hi Craig,

Moving to latest version of datastage depends on client. :D

Its working fine in 9.1

Thanks for all your suggestions

Yes Agreed, But i need to find root cause because it might happen to other module if we have source as text file.

Hi Craig,

We are migrating to 9.1 and i ran this job in 9.1 and its working fine with exact count what is expected. But not able to find the root cause in 8.1

There are no warnings in the log for that job.

A) You take the same file and read it several times and it reads a different number of records from the file each run?

This is what happening for each run. Take same file, read it several times and it provide different number of records

Hi Mike,

That is not the issue here, I am in testing phase fixing one of the prod issue, and other team has sent file on 0508, For same file for each run counts are not matching. In Prod other team sends file morning 6 AM and my jobs are scheduled at 10.30 PM.

Hi Craig, You might feel this might be silly question, even i felt before posting the question. I have incorporated all the points which you have mentioned like partitioning, sorting selecting hash in remove duplicate stage etc... Issue is while reading data from source file and log does not show an...

Can anybody please help with above request

Hi, Job design as follows Sequential file---remove dupes----dataset Have filter to remove header and trailer record in sequential file stage File has 430k records and I have run this job many times and has not provided correct record count (430k) when I see performance stats in designer, same is the...

Hi Ray,

Job design is simple, seqeunce has 10 jobs and this is second job in seqeunce. No hard code values for any parameter. No issues in the file as well.

Hi All, I have sequential file which has around 400K records which is pipe delimeter with double quotes, when i am running the job through seqeunce the count in datastage design is not showing as expected. For each run count varies. If i run that particluar job, designer is showing the record count ...

Sorry i wrote the question in wrong way, Can i call Env variable in value file name which is inside the parameter set. Eg:-- I have value file name xyz and parameters are source column, table names, where condition. Can i call the env variable (which is Schema name) in parameter table names which is...

Hi ,

I have a schema name defined as environment variable, Is it possible to call this variable or parameter in the parameter set.