Search found 653 matches
- Fri Jul 04, 2008 5:25 am
- Forum: General
- Topic: How to export one job from command line
- Replies: 3
- Views: 2226
- Fri May 30, 2008 7:03 am
- Forum: General
- Topic: number of datastage licenses
- Replies: 0
- Views: 1355
number of datastage licenses
Maybe a little off-topic... did anyone ever find out how many companies are using DataStage worldwide. It would be interesting to know, I anyway would be interested in it.
Regards,
Ogmios
Regards,
Ogmios
- Thu Dec 06, 2007 8:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Table Space access is not allowed.
- Replies: 2
- Views: 2202
- Thu Dec 06, 2007 8:25 am
- Forum: General
- Topic: Bouncing DataStage Server Edition - frequency and releasing
- Replies: 11
- Views: 5919
In practice we reboot... Considering your response and sig, what do you do in theory. :D LOL :D in theory it remains up for ever. In practice you see in DataStage v7.5.1 on a Solaris server that after 3 a 4 months sometimes jobs won't start properly anymore (you get the starting lines in the log fi...
- Thu Dec 06, 2007 4:07 am
- Forum: General
- Topic: Bouncing DataStage Server Edition - frequency and releasing
- Replies: 11
- Views: 5919
- Tue Nov 27, 2007 7:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error running RUNSTATS from DB2 API stage
- Replies: 5
- Views: 4400
It's supposed to behave like that... runstats is not SQL. It's similar to Oracle and SQL*Plus, you can execute things in SQL*Plus which will throw errors at you in the Oracle Stage.koolnitz wrote:Thanks stefanfrost1 for your response.
Is it a limitation of DB2 API stage or it is supposed to behave this way?
- Fri Nov 23, 2007 1:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: performance difference of same job on 2 environments
- Replies: 5
- Views: 2844
- Wed Nov 21, 2007 7:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: performance difference of same job on 2 environments
- Replies: 5
- Views: 2844
- Fri Nov 09, 2007 5:49 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Run and Reset if Required
- Replies: 13
- Views: 16790
Easiest way out... schedule your job the normal way via the DataStage gui's. Then look at what DataStage puts into the scheduler, if you put that in TWS it will work. On Unix it works the same with crontab. If you even want to go a step further you can make sure that DataStage first sees your own &q...
- Thu Nov 08, 2007 5:10 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DRSStage ORA-03113 or Transaction size out of bounds errors
- Replies: 5
- Views: 4215
3113 is the dreaded Oracle error message... it means the oracle server process killed itself prematurely. Raise an incident log with Oracle, if you look in the alert.log of your database you may find some other clues. 3113 basically means the Oracle process ended in an abnormal way and usually requi...
- Thu Nov 08, 2007 4:19 pm
- Forum: General
- Topic: ETL Synopsis
- Replies: 7
- Views: 4778
And while you're at it :D try out Talend ( http://www.talend.com ) and Kettle ( http://kettle.pentaho.org ), open source ETL tools. They're going to get away with a big chunk of DataStage/Informatica/OWB market share in a year to a couple of years. The bigger bucks are going to be in the architectur...
- Wed Nov 07, 2007 2:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Row Locking
- Replies: 3
- Views: 2241
Re: Oracle Row Locking
It's not a DataStage problem, it's Oracle and it's not a problem. In Oracle when you update the same row at the same time from different sessions you block each other. In order to use parallellism the right way you have to make sure that you divide up rows and that no 2 sessions try to update the sa...
- Tue Nov 06, 2007 1:47 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage command line
- Replies: 17
- Views: 13125
my mistake... the passwords are not encrypted. They are all unencrypted in a file which can only be accessed by 2 people because of OS permissions. They are also unencrypted written to a small temp file which is then used by dsjob so that the password doesn't appear on the command line (via ps -ef) ...
- Tue Nov 06, 2007 10:48 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage command line
- Replies: 17
- Views: 13125
- Wed Oct 31, 2007 5:45 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error calling subroutine:DSR_SCHEDULE (Action=3);
- Replies: 6
- Views: 4268
Re: Error calling subroutine:DSR_SCHEDULE (Action=3);
my hunch would be that you have access rights problems in your project directory. Are you using the same userid now as you were using before? In any case, a schedule for a job (when done from the GUI and not with dsjob) consists of 2 pieces: some small piece in your project itself and the part in th...