DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 5192 matches
Author Message
 Topic: Sequential(CSV) file structure validation?
kumar_s

Replies: 5
Views: 415

PostForum: General   Posted: Sun Jun 30, 2019 3:59 pm   Subject: Sequential(CSV) file structure validation?
I have done the Craig's suggestion in my past. Especially the top 2.
Compare the header of the incoming file against the predefined list. And.. thats it.
Assumption is that, header would promptly r ...
 Topic: Heap growth during runLocally()and production run time debug
kumar_s

Replies: 12
Views: 2354

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Apr 09, 2019 9:09 pm   Subject: Heap growth during runLocally()and production run time debug
With more partition, you startup time and production time is increasing.

Are you still running with the Auto partition as you mentioned in your original job design (the first post)? Or using specif ...
 Topic: Factors to decide the run mode of Oracle connector
kumar_s

Replies: 5
Views: 545

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Apr 09, 2019 12:05 am   Subject: Factors to decide the run mode of Oracle connector
Perhaps Datastage undergoing overhead based on Partition read method.
Partitioned read works well for the Partitioned data.
Have you tried the Rowid round robin method?
Ideally this should do a s ...
 Topic: ODBC Connector issue
kumar_s

Replies: 7
Views: 1611

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Mar 13, 2018 5:14 pm   Subject: ODBC Connector issue
If the duplicates are getting loaded only one (only during the second run), did you check for any whitespace or PADCHAR on the key field?
 Topic: double quotes in data
kumar_s

Replies: 3
Views: 1018

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Mar 12, 2018 11:52 am   Subject: double quotes in data
You do not have double qoute in all fields.
Have the quote character as None and import the data.
 Topic: Fallen Premium Poster: Kim Duke
kumar_s

Replies: 33
Views: 14658

PostForum: General   Posted: Wed Jul 27, 2016 3:56 pm   Subject: Fallen Premium Poster: Kim Duke
Sad Cant believe that Kim is no more with us. May his soul RIP!
 Topic: Data Type Conversion - Ora to NZ - Using RCP
kumar_s

Replies: 3
Views: 3693

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Dec 23, 2015 3:02 pm   Subject: Data Type Conversion - Ora to NZ - Using RCP
One options, that strikes my mind is to create the table prior to loading. And just 'Insert' the record.
While creating the table, convert those Numeric fields to integer.
 Topic: DSX export progress intermittently very slow to start
kumar_s

Replies: 14
Views: 5073

PostForum: General   Posted: Wed Dec 23, 2015 2:47 pm   Subject: DSX export progress intermittently very slow to start
If this happens from various client machine, Could be possible that the temp folders are full or almost full.
Try clearing those, and along with it, do the clean up of COMO and PH folders.
Its also ...
Workaround Reported
 Topic: Failed to distribute component
kumar_s

Replies: 3
Views: 2143

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Nov 08, 2015 9:13 pm   Subject: Failed to distribute component
Thanks for the Hits.

Looks like IBM has workaround for any thing!!

QualityStage has introduced an environment variable QSM_DISABLE_DISTRIBUTE_COMPONENT to turn off the distribute-component
cal ...
Workaround Reported
 Topic: Failed to distribute component
kumar_s

Replies: 3
Views: 2143

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sat Nov 07, 2015 11:20 pm   Subject: Failed to distribute component
DataStage® Release: 9x
Job Type: Parallel
OS: Unix
Its just couple of years short to meet a decade with Failed to distribute component "/Project/USADDR.SET" to node "Node1"
Failed to distribute component "/Project/USADDR.DCT" to node "Node1"
Failed ...
Workaround Reported
 Topic: Leading Zero in RCP Job
kumar_s

Replies: 15
Views: 10372

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Nov 18, 2014 5:32 pm   Subject: Leading Zero in RCP Job
Why is the interger read as Numeric?
Integer in Oracle could be Numeric in Datastage.
But covert it to interger in Datastage to get rid of padded zeros.
Resolved
 Topic: TIME CONVERSION
kumar_s

Replies: 12
Views: 5323

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Nov 18, 2014 5:28 pm   Subject: TIME CONVERSION
You can use StringToTime as well. With just %nn:%ss to map it to a time field.
But you ll need a padding of zero anyway.
 Topic: Starting a job from PC
kumar_s

Replies: 6
Views: 2312

PostForum: General   Posted: Wed Feb 08, 2012 4:07 pm   Subject: Starting a job from PC
Probably yes.
What is the full error message?
 Topic: How Do I Find a DataStage Program Within A Project?
kumar_s

Replies: 1
Views: 1263

PostForum: General   Posted: Wed Feb 08, 2012 4:02 pm   Subject: How Do I Find a DataStage Program Within A Project?
In Director, you have option to remove the Category view.
i.e., all job in one page. Find works perfectly then.

Or just issue "LIST DS_JOBS {jobname}" in TCL prompt.
Resolved
 Topic: Lookup value 0
kumar_s

Replies: 9
Views: 3437

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Feb 08, 2012 4:00 pm   Subject: Lookup value 0
Is there any auto conversion into Integer?
Try to make sime dataytpe at both input and reference. Try converting the Char into Varchar.
 

 Jump to:   



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