DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 1738 matches
Author Message
Resolved
 Topic: Need help to build logic in Transformer / Server Routine
priyadarshikunal

Replies: 6
Views: 409

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 07, 2017 6:02 am   Subject: Need help to build logic in Transformer / Server Routine
left(string, index(field(trim(convert(convert('1234567890','',string),' ',string)),' ',1),string)+len(field(trim(convert(convert('123456 ...
Resolved
 Topic: Need help to build logic in Transformer / Server Routine
priyadarshikunal

Replies: 6
Views: 409

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 07, 2017 5:57 am   Subject: Need help to build logic in Transformer / Server Routine
1. replace all non numeric characters to space (you can do double convert),
2. do a default trim to remove leading, trailing, repeating spaces.
3. use field function to get the first set of digits ...
 Topic: Update issue on Index columns:Oracle connector stage
priyadarshikunal

Replies: 5
Views: 370

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 07, 2017 5:49 am   Subject: Update issue on Index columns:Oracle connector stage
you should have a surrogate key for updates in such cases where you can replace the nulls with some value you are not expecting in the data such as 0, -9999 or ~, and then do a lookup and send records ...
Resolved
 Topic: Balanced Optimizer missing / unavailable
priyadarshikunal

Replies: 11
Views: 693

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 07, 2017 5:45 am   Subject: Balanced Optimizer missing / unavailable
With such "basic transformation" you could optimize it yourself. Few years back that option wasn't there in datastage at all.
 Topic: Batch ID in Datastage
priyadarshikunal

Replies: 19
Views: 430

PostForum: General   Posted: Wed Dec 06, 2017 1:30 am   Subject: Batch ID in Datastage
A batch ID from what I have seen is an integer to track the records being inserted/updated during Job run. Mostly for audit purposes. And that needs to be generated before each job execution, a separa ...
Resolved
 Topic: Sequence number using Surrogate Key in transformer
priyadarshikunal

Replies: 6
Views: 989

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Aug 31, 2017 2:56 am   Subject: Sequence number using Surrogate Key in transformer
Seems system selected block size is taken as 1000 hence 1 to 400 and 1001 to 1401 has been generated.

You can change the block size to 1 to see it being generated in a compacted manner, However it ...
 Topic: Want to fix a particular warning with Funnel stage
priyadarshikunal

Replies: 5
Views: 839

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Aug 21, 2017 4:41 am   Subject: Want to fix a particular warning with Funnel stage
Do you get the same warnings when executed from director, but still it completes?
 Topic: TNS connection error
priyadarshikunal

Replies: 11
Views: 1173

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Aug 02, 2017 4:36 am   Subject: TNS connection error
Talk to your DBA to get the listener started or to get the TNS entry corrected.
Resolved
 Topic: Lengthy start up time for 90% of datastage jobs in 11.5.0.2
priyadarshikunal

Replies: 40
Views: 4800

PostForum: General   Posted: Mon Jul 31, 2017 3:19 am   Subject: Lengthy start up time for 90% of datastage jobs in 11.5.0.2
Since you are on LPARs, please run below commands when you experience slowness (please use -a if -A doesn't work).

sar -u 5 5
sar -r 5 5
sar -A 1 1

First 2 commands will give you CPU and memo ...
 Topic: Join the columns having HASH values
priyadarshikunal

Replies: 3
Views: 416

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jul 27, 2017 3:52 am   Subject: Join the columns having HASH values
It does not generate different checksum for the same value if the data type is identical as well including unicode.
 Topic: Join the columns having HASH values
priyadarshikunal

Replies: 3
Views: 416

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jul 27, 2017 1:55 am   Subject: Join the columns having HASH values
If the checksum value is different then it seems that the values are different or the data type is not identical or any padding is present while calculating the checksum. Also before join, you need to ...
 Topic: Unable to end the Process DSD.OshMonitor MSEVENTS.FALSE
priyadarshikunal

Replies: 3
Views: 460

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jul 27, 2017 1:38 am   Subject: Unable to end the Process DSD.OshMonitor MSEVENTS.FALSE
you can try setting APT_NO_JOB_MON = 'True' just to check if its the job monitor which is causing the problem.

Above enviornment variable changes will disable the monitoring and the statistics wil ...
Resolved
 Topic: Lengthy start up time for 90% of datastage jobs in 11.5.0.2
priyadarshikunal

Replies: 40
Views: 4800

PostForum: General   Posted: Thu Jul 27, 2017 1:32 am   Subject: Lengthy start up time for 90% of datastage jobs in 11.5.0.2
10 runs isn't bad, and should not be pushing the logs to GBs however You may need to check if these auto purge settings are actually executing.

However I would check if the shared memory parameters ...
 Topic: Unable to end the Process DSD.OshMonitor MSEVENTS.FALSE
priyadarshikunal

Replies: 3
Views: 460

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jul 25, 2017 6:16 am   Subject: Unable to end the Process DSD.OshMonitor MSEVENTS.FALSE
Did you check if you have any after job subroutine in that job?
Resolved
 Topic: Upgrading to 11.3 from 8.7
priyadarshikunal

Replies: 4
Views: 1417

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Fri Jun 02, 2017 1:28 am   Subject: Upgrading to 11.3 from 8.7
Reg 11.1 support, you can always use v10 client to connect to 11.1 server if you must. Things we have been doing since long.
 

 Jump to:   



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