Search found 7201 matches

by admin
Thu Jun 06, 2002 3:12 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Job locked
Replies: 8
Views: 1345

ddd -----Original Message----- From: BKS_Prasad [mailto:BKS_Prasad@satyam.com] Sent: Thursday, June 06, 2002 8:36 AM To: datastage-users@oliver.com Subject: RE: Job locked eee -----Original Message----- From: Kenneth Bland [mailto:kcbland_2000@yahoo.com] Sent: Thursday, June 06, 2002 3:42 AM To: dat...
by admin
Thu Jun 06, 2002 3:05 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Job locked
Replies: 8
Views: 1345

eee -----Original Message----- From: Kenneth Bland [mailto:kcbland_2000@yahoo.com] Sent: Thursday, June 06, 2002 3:42 AM To: datastage-users@oliver.com Subject: RE: Job locked Unlocking jobs 101 (Argghhh) NT: Invoke the Administrator client, login in as Administrator to that server, go to the Comman...
by admin
Thu Jun 06, 2002 12:08 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Error with OCI8 stage.....
Replies: 3
Views: 999

Error with OCI8 stage.....

Hi, I suddently cannot view data from OCI8 stage, also cannot import plugin metadata. the error message is: DSBrowser1: Error while trying to retrieve text for error ORA-12154 DSBrowser1.DSLink1: DSP.Open GCI $DSP.Open error -2. I asked my oracle DBA, however they didnt make any change with database...
by admin
Wed Jun 05, 2002 11:23 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: abort after 1 warning with Option Limit to 50 warning
Replies: 2
Views: 580

Check whether you have a limit set on a Transformer stage output link, particular one that captures rejected rows. If this is set to 1 your job aborts as soon as the first reject row is processed. "Cristiano Micarelli" cc: Subject: abort after 1 warning with Option Limit to 50 warning 05/06/2002 20:...
by admin
Wed Jun 05, 2002 10:25 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Job locked
Replies: 8
Views: 1345

as Rachel said, stopping and restarting the services on NT will unlock the jobs and resources, as will using the job administration within the director (if you have it enabled) to log out the processes in question. both require you to either make sure everyone is off, or you know exactly which job/p...
by admin
Wed Jun 05, 2002 10:14 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: How to use parallel execution?
Replies: 3
Views: 799

as others have said there are many many things that could effect the performance, especially if your running multiple jobs at once. you have to keep in mind that youve gone from running a single job that has access to all of the machine, to a few jobs all fighting for the same resources (disk, cpu, ...
by admin
Wed Jun 05, 2002 10:12 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Job locked
Replies: 8
Views: 1345

Unlocking jobs 101 (Argghhh) NT: Invoke the Administrator client, login in as Administrator to that server, go to the Command button option and enter for the command: LIST.READU Find the job locked under column Item-ID then look to the left for the USERNO column and and get that value. Use the Comma...
by admin
Wed Jun 05, 2002 8:35 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Job locked
Replies: 8
Views: 1345

I ran into this this week, and the only way I could unloack it was by stopping and restarting the DataStage service (On NT). >>> Himanshu.Patel@globalknowledge.com 06/05/02 08:58AM >>> In NT -- find the port holding the lock and logout the port -----Original Message----- From: umascett@libero.it [ma...
by admin
Wed Jun 05, 2002 7:26 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: MONTHLY POSTING - DataStage Users List
Replies: 0
Views: 421

MONTHLY POSTING - DataStage Users List

MONTHLY POSTING - DataStage Users List As of 5 June 2002 the DataStage Users discussion list had 642 subscriber addresses. A few of the addresses are to organizations who then redistribute the postings to more than one reader. ================== Posting Guidelines ================== 1) Non-moderated...
by admin
Wed Jun 05, 2002 5:02 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: _How_to_use_parallel_execution?
Replies: 2
Views: 796

Tony is correct it could be disk, however it may also be CPU, memory the source or destination servers (where applicable). E.g. if you are loading into a relational database are you getting locking issues. Or is all the source data being extracted from the from same database server. If all the IO is...
by admin
Wed Jun 05, 2002 4:26 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: _How_to_use_parallel_execution?
Replies: 2
Views: 796

You are most likely being constrained by the disk. If each of these three jobs are reading and/or writing to the same disk, then your bottleneck is most likely there. "umascett@libero.it" wrote: Dear Andrew, Thanks for your answer. My DS version is 5.1 (and the check box of multiple instance is not ...
by admin
Wed Jun 05, 2002 4:26 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: _How_to_use_parallel_execution?
Replies: 2
Views: 796

_How_to_use_parallel_execution?

This is a topic for an orphaned message.
by admin
Wed Jun 05, 2002 3:40 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: How to use parallel execution?
Replies: 3
Views: 799

Dear Andrew, Thanks for your answer. My DS version is 5.1 (and the check box of multiple instance is not checkable). However my jobs are different jobs, so they should run at the same time, but I noticed this behaviour: the jobs launched alone and in sequence (they are logically indipendent) have so...
by admin
Wed Jun 05, 2002 3:13 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: How to use parallel execution?
Replies: 3
Views: 799

ugo, which version of datastage are you running ? you needed a licence key to enable the multiple job instances (what was called the axcel pack) with 5.2 onwards the licence key is not needed. So I would double check that you dont have the ability to run multiple instances of the jobs anyhow. I dont...
by admin
Wed Jun 05, 2002 2:58 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Job locked
Replies: 8
Views: 1345

In NT -- find the port holding the lock and logout the port -----Original Message----- From: umascett@libero.it [mailto:umascett@libero.it] Sent: Wednesday, June 05, 2002 10:55 AM To: datastage-users@oliver.com Subject: Job locked Dear all, I was compiling a job and during this operation i had a fau...