Search found 15 matches

by louis
Tue Aug 17, 2010 8:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data capture in sql
Replies: 5
Views: 3405

Re: Data capture in sql

Hi guys, We have come up to add some audit cols in target & source tables one of them is the update date (Timestamp) which makes easy/simple, we will only pool and load date above that update date in target tables. Thanks for your valuable approaches, makes me proud to be @ dsxchange.com. Thanks...
by louis
Mon Aug 16, 2010 10:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data capture in sql
Replies: 5
Views: 3405

Data capture in sql

Hi guys, Need best way for following seniaro: Need to replicate data in sql server 2005 db (25 tables) (max record volume in a table is 1 million), job needs to run daily and need to load data only if they have changed/updated or inserted. server A Server B Table A Table A first day rec count 100 lo...
by louis
Thu Feb 19, 2009 2:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DsEngine startup error
Replies: 5
Views: 2922

Yes , we have instructed to run those command with root previliges , but not sure they (unix team) ran it with admin. so do you think the command is not ran with root previliges??
thanks for your reply.
by louis
Thu Feb 19, 2009 12:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DsEngine startup error
Replies: 5
Views: 2922

DsEngine startup error

Hi All, we are getting below errors when issuing the uv start command. can anybody please, have face or know the reason for this? # /opt/IBM/Ascential/DataStage/DSEngine/bin/uv -admin -start sh: /opt/IBM/Ascential/DataStage/DSEngine/dstmp.090219.105222A: cannot create chmod: WARNING: can't access /o...
by louis
Thu Jan 29, 2009 8:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: JobControl (SQLState): S1000
Replies: 2
Views: 1506

JobControl (SQLState): S1000

Hi all,

can anybody know what is this warning and S1000 sqlstate:

Type: Warning
Message: DMS_Archive..JobControl (SQLState): S1000

Thanks
by louis
Thu Jan 29, 2009 6:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: What is DSUBINARY in a DSX export?
Replies: 3
Views: 2464

Hi, I exported the routine, and there apprears to be differences in DSUBINARY does it means that the code in both environment is different? below is the comparing of two dsx using diff cmd. $ diff PROD_ProcArchDel.dsx DEVL_ProcArchDel.dsx 5,6c5,6 < ServerName "x82" < ToolInstanceID "D...
by louis
Thu Jan 29, 2009 2:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Debug a Job log
Replies: 2
Views: 1607

Debug a Job log

Hi ALL,

Can anybody/everybody post the TIPS to debug printed detail Job log ?

I know everybody got there ways to catch the bug.

Thanks
by louis
Wed Jan 28, 2009 3:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: .o file
Replies: 1
Views: 1024

.o file

Hi all,

How to edit an .o file which is used as an operator while creating custom stage?
by louis
Wed Jan 28, 2009 1:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: custom operator
Replies: 8
Views: 2612

can anybody telll me the list of operators that can be used in Custom Stage?
Is there a pskgOp operator where to see its code?
by louis
Tue Jan 27, 2009 1:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: custom operator
Replies: 8
Views: 2612

Yes srinivas, you are right when you create the stage only that time you can view that code/logic tab but here I want to modify that code how can i do that?That tab is not there after building the stage. please help
by louis
Tue Jan 27, 2009 8:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: custom operator
Replies: 8
Views: 2612

Yes, I can see the custom Stage but the code tab is not there!
by louis
Mon Jan 26, 2009 5:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: custom operator
Replies: 8
Views: 2612

I think the custom stage designed is in-house. How I can view/Edit the logic/code of the custom stage operator? please comment.
by louis
Mon Jan 26, 2009 4:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: custom operator
Replies: 8
Views: 2612

Thanks for info. so if somebody has coded the custom stage with operator we are not able to see its logic/code. I am in a situation to find the underlying code any comment will be a great help.
by louis
Mon Jan 26, 2009 12:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: custom operator
Replies: 8
Views: 2612

custom operator

Hi ALL,
My question:

Is there a way to view the custom operator's code which is used by a custom stage?

Thanks for the help in advance.