Search found 182 matches
- Mon Feb 09, 2015 2:38 pm
- Forum: General
- Topic: Need to run a sequence job infinetely
- Replies: 1
- Views: 990
Need to run a sequence job infinetely
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...
- Tue Feb 03, 2015 9:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: odbc connector stage performance issue on Oracle 12 C
- Replies: 2
- Views: 1728
odbc connector stage performance issue on Oracle 12 C
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.
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.
- Wed Feb 26, 2014 4:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: manipulation of date between two dates
- Replies: 5
- Views: 2554
- Wed Feb 26, 2014 4:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: manipulation of date between two dates
- Replies: 5
- Views: 2554
manipulation of date between two dates
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...
- Wed Feb 26, 2014 4:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: date manipulation using start and enddates
- Replies: 0
- Views: 1003
date manipulation using start and enddates
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...
- Tue Oct 22, 2013 6:05 am
- Forum: General
- Topic: MGET return code
- Replies: 2
- Views: 1225
MGET return code
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...
- Tue Jun 25, 2013 5:39 am
- Forum: General
- Topic: WARNING: Logon attempts are audited
- Replies: 12
- Views: 3548
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...
- Mon Jun 24, 2013 5:59 am
- Forum: General
- Topic: WARNING: Logon attempts are audited
- Replies: 12
- Views: 3548
- Mon Jun 24, 2013 4:40 am
- Forum: General
- Topic: WARNING: Logon attempts are audited
- Replies: 12
- Views: 3548
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. | |-----------------------------------------------------------------...
- Fri Jun 21, 2013 7:02 am
- Forum: General
- Topic: WARNING: Logon attempts are audited
- Replies: 12
- Views: 3548
WARNING: Logon attempts are audited
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...
- Mon Sep 03, 2012 9:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Update performing very slow/hung
- Replies: 1
- Views: 1162
Update performing very slow/hung
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...
- Wed May 02, 2012 5:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timeline splitup logic
- Replies: 1
- Views: 1238
Timeline splitup logic
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...
- Fri Nov 04, 2011 2:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sort Performance issue
- Replies: 1
- Views: 937
Sort Performance issue
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...
- Wed Aug 03, 2011 2:57 am
- Forum: General
- Topic: Extract Staus informatiom for DataStageJob Log for Audit
- Replies: 1
- Views: 1289
Extract Staus informatiom for DataStageJob Log for Audit
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...
- Tue Jun 21, 2011 11:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SQL3508N Error in accessing a file or path of type "TEM
- Replies: 2
- Views: 4526
SQL3508N Error in accessing a file or path of type "TEM
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...