Search found 9 matches
- 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...
- 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...
- 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 ...
- 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...
I cant see the whole solution sent by you...I could see just 2 line...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 ...
- 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...
- 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...
- 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?? ...
- 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
can multiple users use same db connection??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 i expect the answer with an example....
- 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...