DSXchange

Thanks Eric.

Thanks Craig!!

Good afternoon DSXchangers, Is it a red flag if I use 1 lookup stage to do multiple different lookups in terms of performance? I am essentially using one lookup stage instead of many lookup stages to do lookups against different tables. The algorithm is simplified as below. Stream ----Only LookUp St...

This is definitely a challenge for me to learn it..

Hi All, I have a sequencer which is already in place. We have realised that the job was runnig for tomorrow if accidentally ran by the support team. This job gets its date from a table which holds run date for the job. For instance : if the job ran for today and when accidentally some one runs it ag...

Good evening, The commit level was set to 1. The table had HASH partition enabled while in Parallel mode of execution. The job basically does a select from a source table, a lookup with 5 other tables and finally does an insert into the target table abcd(this table was getting geadlocked due to conc...

Hi all,

I am not sure if this can be called a resolution. However, the solution came by changing the process flow of the active stages from parallel to sequential.

Thanks,
Mukthi

Ray, the table abcd(the one that is getting locked) does not have a select in this job other than an insert(which is failing).There are 5 other Oracle tables that have a select performed on them.

Thank you,
Mukthi

Yes Ray, the job has select in itself which occurs when it looks up with 5 Oracle tables then the output from the lkp gets inserted into the table abcd(Table that is getting locked).

Thank you,
Mukthi

I did not find any concurrent process running on that table and hence was I intended to check for the transaction commits.

-Mukthi

Thank you Sir,

The error log goes as below.

insert is: INSERT
INTO
abcd
(a,b,c.d...)
VALUES ( 1,2,3,4...) sqlcode is: -60 esql complaint: ORA-00060: deadlock detected while waiting for resource.

I am glad to know more about the env vars.

Thanks again,
Mukti

I came to know about the deadlock from the job log in production.

Hi everyone, I have a parallel job that has failed due to a deadlock on one of the Oracle tables into which the job does inserts. The approach I adapted was to see if there was any concurrent process that does any modification to the table and found out to be none. But, I am not sure about the trans...

Thank you DSGuru and Ray.We have had the issue resolved as we have not had enough permissions in our new environment.

-Mukti

Hi All, I am running the datastage jobs using the job sequencers and by scheduling them as per the requirement. Somehow the scheduled jobs are not running as per the schedule. However,if I schedule the job to run for just today then it goes on fine.But,not when I want to run them on a daily/weekly b...