DSXchange

Hi All, My requirement is the jobsequencer run for ever and it would check for a file on every 5 minutes. If file is available, we would need to process and continue to run and checks for the next file and so on... If the file is not available..it would skip the load process and waits for 5 mins and...

Hi All,

We are using Datastage 9.1 parallel jobs. Database is Oracle 12C. When we try to read and write the recods by using odbc connector stage , we could see the performance of the job is very less.

Kindly through me some inputs by increasing the performane or re-design the job as well.

Yes..we do have Oracle10g.



Thanks,
Satheesh.R

Hi All, I have startdate and enddate as an incoming columns, based on which i would like to get everymonths between the given dates. StartDate:10/18/2014 EndDate:03/22/2015 Expected output: 1-10-2014 1-11-2014 1-12-2014 1-01-2015 1-02-2015 1-03-2015 Kindly let me know your thoughts on the same. Than...

Hi All, I have startdate and enddate as an incoming columns, based on which i would like to get everymonths between the given dates. StartDate:10/18/2014 EndDate:03/22/2015 Expected output: 1-10-2014 1-11-2014 1-12-2014 1-01-2015 1-02-2015 1-03-2015 Kindly let me know your thoughts on the same. Than...

Hi, I am finding difficulty to capture return code of MGET(ftp) command. We are using the unix script to ftp multiple files from remote server to DS server and process it. Scenario1: If there were files, we check the below status and continue processing Status Check:(index(Cmd_Ftp_Master.$CommandOut...

Hi Ray, My Bad. Now i could see all of my jobs which has been completed with warnings or finished(without warnings) contains the warning message throughout the project. I suspect DS admin has truned-on something to audit, but when i questioned the same, he hasn't done that. Only particular project(P...

Hi ArndW,

Yes, i did check it with motd file. It doesnt have the above mentioned message.
It contains generic access policy message.

Thanks,
Satheesh.R

Hi Ray, CopyStage:when we try to load |-----------------------------------------------------------------| | WARNING: Logon attempts are audited. Access and use allowed | | for authorized purposes only. Violators will be prosecuted. | |-----------------------------------------------------------------...

Hi, I have come across a strange warning message in my production environment. We have setup if the job completed with warnings, it should abort. But the jobs has been completed(Extraction and load). Sequencer is aborted due to the below warning message: WARNING: Logon attempts are audited. Access a...

Hi, We have a sequencer which first(1st job) inserts x records and then it updates(2nd job) x records. Update happens thru shellscript and called by an execute command stage. Table: DB2 Table Volume:125 million Table is not partitioned Table has index and the update column where clause cols are also...

Hi, I will need to splitup the dates as there are overlapping Type Start Stop --------------------------------------------- C 01/01/2011 01/31/2011 B 02/01/2011 05/31/2011 C 03/01/2011 08/31/2011 D 05/01/2011 10/31/2011 B 09/01/2011 12/31/2011 Since there are overlaps, the timeline needs to be split...

Hi All, We have a job which read records(14488888) from the dataset and sort the records and fileter the outcoming records and to join the records. Until this pahse the job took only few minutes(30000 rec/sec). Again we are sorting the records with the different keys to concatenate the no.of occuren...

Hi All, I have created the log files in Unix for each cycle run.Now, the requirement is used to extract the below information Sequence_name,Start_Time,End_Time,Elasped_Time(This we can get it easily), but for the below information SourcetableReadCount(SourceLinkName) TargetTableWriteCount(UpdateLink...

Hi All, When i try to load records from sequential file to DB2Bulk stage it gives me a wired issue. Warning : lodbld_lf_ben_set_det,0: Warning: Unload_L2Load_lf_ben_set_det.lodbld_lf_ben_set_det: ERROR occurred : loading table, SQLCODE -3508 lodbld_lf_ben_set_det,0: Warning: Unload_L2Load_lf_ben_set...