DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 172 matches
Author Message
Resolved
 Topic: database table deadlock
abyss

Replies: 8
Views: 1728

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Feb 09, 2018 12:38 am   Subject: database table deadlock
haha awesome.

then i can mark it as resolved then Very Happy Very Happy Very Happy
Resolved
 Topic: database table deadlock
abyss

Replies: 8
Views: 1728

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Feb 08, 2018 9:17 pm   Subject: database table deadlock
this is my job, populate type 6 table
https://i.imgur.com/5ZJPcZf.png

those 2 SE stages update same table, one is type 1 change another is type 2 change.
I had a kind of illegitimate work around ...
Resolved
 Topic: database table deadlock
abyss

Replies: 8
Views: 1728

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Feb 08, 2018 7:28 am   Subject: database table deadlock
DataStage® Release: 11x
Job Type: Parallel
OS: Windows
hi all
i think this is more like a database question rather than a ds question but someone may can help me on here.

i have a job has two sql server stages that update same table and they may updat ...
 Topic: automatically turn off RCP for every stages
abyss

Replies: 5
Views: 1609

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Dec 27, 2017 8:51 pm   Subject: automatically turn off RCP for every stages
h double checked on admin console, i didn't NOT tick on that box.
Resolved
 Topic: if statement problem
abyss

Replies: 14
Views: 2114

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 21, 2017 12:03 am   Subject: if statement problem
Hi all:
I think I find the problem:
i didn't put the full code out. the full code is like:

if IsNotNull(LkTfProdDetial.Hospital_ProductTypeID) and IsNotNull(LkTfProdDetial.Ancillary_ ...
Resolved
 Topic: if statement problem
abyss

Replies: 14
Views: 2114

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Dec 20, 2017 7:24 pm   Subject: if statement problem
i will run some test and let you guys know later today...
Resolved
 Topic: if statement problem
abyss

Replies: 14
Views: 2114

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Dec 18, 2017 5:52 pm   Subject: if statement problem
i put the trim() function out side the if statement and it returns right value, problem solved but i am not happy of how ds behaves.
i mark it as work around ...

thanks all
Resolved
 Topic: if statement problem
abyss

Replies: 14
Views: 2114

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Dec 18, 2017 5:22 pm   Subject: if statement problem
stage variable type is varchar(255)
Resolved
 Topic: if statement problem
abyss

Replies: 14
Views: 2114

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Dec 18, 2017 4:29 pm   Subject: if statement problem
if (LkTfProdDetial.Hospital_ProductTypeID = 3 and LkTfProdDetial.Ancillary_ProductTypeID = 2) or
LkTfProdDetial.Hospital_ProductTypeID = 1 then
'HA'
else if (LkTfProdDetial.Hospita ...
Resolved
 Topic: if statement problem
abyss

Replies: 14
Views: 2114

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Dec 18, 2017 1:04 am   Subject: if statement problem
hmmmmm...........
update:
i double checked the variable svCoverTypeCode's value
when value set to 'A' or 'H' DS put 2 blanks at the end Sad
does anyone know why? i set this variable type to varchar ...
Resolved
 Topic: if statement problem
abyss

Replies: 14
Views: 2114

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Dec 18, 2017 12:42 am   Subject: if statement problem
DataStage® Release: 11x
Job Type: Parallel
OS: Windows
hi
i am having a weird problem in transformer stage:
i created a stage variable: svCoverTypeCode the value can be : 'HA', 'H', 'A' and in the output link's derivation, i create the following if sta ...
 Topic: automatically turn off RCP for every stages
abyss

Replies: 5
Views: 1609

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Dec 13, 2017 7:04 pm   Subject: automatically turn off RCP for every stages
not yet, i will do it Smile
 Topic: automatically turn off RCP for every stages
abyss

Replies: 5
Views: 1609

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Dec 13, 2017 5:31 pm   Subject: automatically turn off RCP for every stages
no one know? Sad Sad Sad
 Topic: automatically turn off RCP for every stages
abyss

Replies: 5
Views: 1609

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Dec 12, 2017 5:21 pm   Subject: automatically turn off RCP for every stages
DataStage® Release: 11x
Job Type: Parallel
OS: Windows
Hi
I just turned on RCP on one of our project, current problem is we only want use rcp for some of the stages for our new jobs. but once you turn it on some existing stages from old jobs were autom ...
 Topic: tuning a massive checksum job
abyss

Replies: 3
Views: 1212

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Nov 16, 2017 6:01 pm   Subject: tuning a massive checksum job
DataStage® Release: 11x
Job Type: Parallel
OS: Windows
Hi all
this topic may be a little more than only datastage

I am trying to tune a job that calculate check sum on one of our table. The table is massive, it has over 120 million rows in it and more ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours