Search found 9 matches

by RekhaMallam1
Tue Mar 18, 2008 12:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: scheduling 2parall jobs wit surogatekey 2 run at same time
Replies: 5
Views: 1966

Looks like you lack privilege to use the schema name SYSTEM. Try using a more appropriate schema (owner) name. ... If i lack privilege then when i run only one job at once its not throwing error... :?: It has got excuted successfully..Why is that its throwing error whn i try to run both the jobs at...
by RekhaMallam1
Mon Mar 17, 2008 5:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: scheduling 2parall jobs wit surogatekey 2 run at same time
Replies: 5
Views: 1966

This was the error in both jobs when run at same time

What (exact) error message is logged? ... This was the warning main_program: Failed to initialize job monitoring. Monitor information will not be generated. ------------------------------------------------------------------------------------- And ths was error: Surrogate_Key_Generator_6,0: Error Id...
by RekhaMallam1
Wed Mar 12, 2008 1:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: scheduling 2parall jobs wit surogatekey 2 run at same time
Replies: 5
Views: 1966

scheduling 2parall jobs wit surogatekey 2 run at same time

Iam scheduling 2 parallel jobs to run at sametime and both are using same surrogate key source which is already created.Iam trying with Db sequence and of type DB2 database ...But when i run both of them at same time its throwing error and if i try same jobs individually they are working fine.. Plz ...
by RekhaMallam1
Tue Mar 11, 2008 7:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate key stage with source type as DB Sequence
Replies: 6
Views: 4277

I cant see the whole solution...

ArndW wrote:Rekha - you don't need to completely repeat your first post. When I declare the stage with no inputs or outputs I do get that option, but that stage is only used to create the key, not to use it (if I ...
I cant see the whole solution sent by you...I could see just 2 line...
by RekhaMallam1
Tue Mar 11, 2008 3:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate key stage with source type as DB Sequence
Replies: 6
Views: 4277

Re: Surrogate key stage with source type as DB Sequence

This is my job structure.... Iam using surrogate key with no input and output In Key source options "Source Action property =Create " "source type=DB Sequence" "database= DB2 In options "sequence block size = userdefined" Its throwing fatal error and job is aborted...
by RekhaMallam1
Tue Mar 11, 2008 1:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate key stage with source type as DB Sequence
Replies: 6
Views: 4277

Surrogate key stage with source type as DB Sequence

Hi Iam using surrogate key stage in my job surrogate stage as source Trgt is seq file and In surrogate key i specified key type as "source type=DB Sequence" database DB2 In options i specified " Block Type= User Defined " Its throwing fatal error and job is aborted..The following...
by RekhaMallam1
Mon Mar 03, 2008 7:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can a single DB Connectn be used by multiple users?
Replies: 1
Views: 724

Can a single DB Connectn be used by multiple users?

Hi, Iam using a a DB2API stage in my job. I have created a DB Connection for DB2API stage in Parallel job. Can that same connection be used by multiple user simultaniously? When other person logs in through his id and is tring to load the db connection createed by me it is not geting loaded ??why?? ...
by RekhaMallam1
Mon Mar 03, 2008 6:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can a single DB Connectn be used in multiple parallel jobs?
Replies: 8
Views: 2763

Re: Can a single DB Connectn be used in multiple parallel jo

RekhaMallam1 wrote:Hi,
Iam using a a DB2API stage in my job.
I have created a DB Connection for DB2API stage in Parallel job.
Can the same DB Connection be used in multiple parallel jobs?

Thnk U.
can multiple users use same db connection??
Can i expect the answer with an example....
by RekhaMallam1
Fri Feb 29, 2008 5:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can a single DB Connectn be used in multiple parallel jobs?
Replies: 8
Views: 2763

Can a single DB Connectn be used in multiple parallel jobs?

Hi, Iam using a a DB2API stage in my job. I have created a DB Connection for DB2API stage in Parallel job. Can the same DB Connection be used in multiple parallel jobs? Thnk U. When other person logs in through his id and is tring to load the db connection created by me it is not geting loaded !!why...