DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 2865 matches
Author Message
 Topic: Datastage - connector for Yellow bricks Database
qt_ky

Replies: 2
Views: 35

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jul 15, 2019 6:56 am   Subject: Datastage - connector for Yellow bricks Database
Never heard of it before. What does IBM Support tell you?
 Topic: Reading DBF file in UNix and convert to CSV
qt_ky

Replies: 2
Views: 266

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jun 20, 2019 8:24 am   Subject: Reading DBF file in UNix and convert to CSV
You could use a DataStage job with ODBC Connector stage to read the DBF file, assuming you setup the proper ODBC driver, and write to a CSV file. The only purpose a shell script could serve in this ca ...
 Topic: Datastage version 11.5 handle string with line terminator
qt_ky

Replies: 7
Views: 393

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jun 19, 2019 8:39 am   Subject: Datastage version 11.5 handle string with line terminator
Server jobs should compile successfully in any version.

Perhaps you have a local environmental problem with your setup. What error are you getting when compiling server jobs?

Is your project pro ...
 Topic: Check in datastage
qt_ky

Replies: 13
Views: 556

PostForum: General   Posted: Thu Jun 06, 2019 8:38 am   Subject: Check in datastage
Open Director and start a job monitor.
 Topic: Retiring, but never shy
qt_ky

Replies: 4
Views: 336

PostForum: General   Posted: Wed May 22, 2019 6:03 pm   Subject: Retiring, but never shy
Congratulations on your retirement, Franklin. We'll miss your words of wisdom around here...

- Eric
Resolved
 Topic: Oracle Connecter - Do Not Truncate on Failure
qt_ky

Replies: 3
Views: 278

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 22, 2019 6:01 pm   Subject: Oracle Connecter - Do Not Truncate on Failure
If you're saying that you cannot, for some reason, split the existing design into two jobs (which seems like the most logical thing to do...), then I suppose you could change the Oracle Connector targ ...
 Topic: DataStage Job Reports 403
qt_ky

Replies: 2
Views: 201

PostForum: General   Posted: Wed May 01, 2019 7:08 pm   Subject: DataStage Job Reports 403
Perhaps it has to do with Information Server security and browser sessions. It should display OK if it is clicked and opened in an existing session but it should fail if a new browser session is start ...
Resolved
 Topic: Keep old log after renaming job
qt_ky

Replies: 4
Views: 292

PostForum: General   Posted: Mon Apr 22, 2019 6:41 pm   Subject: Keep old log after renaming job
I would create a new project with a copy of all the old jobs and rename them all in the new project. Just leave the old project with old job names and job logs alone. Mark it as protected and change t ...
 Topic: data set compression
qt_ky

Replies: 1
Views: 340

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Mar 28, 2019 11:18 pm   Subject: data set compression
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: 11.7.0.2
I noticed a new IBM technote published recently. I don't have the link handy at the moment... Has anyone had a chance to test this to see how it affects job duration, CPU, and storage?

Problem:
Ad ...
Resolved
 Topic: DStageWrapper for extracting user/role/project
qt_ky

Replies: 2
Views: 298

PostForum: General   Posted: Thu Mar 14, 2019 1:02 am   Subject: DStageWrapper for extracting user/role/project
Even years ago I said this query syntax was the "least/worst-ever-documented, ever."

The DStageWrapper and the DirectoryCommand tool options are discussed in these topics.

http://www.dsxchange.c ...
 Topic: how much Ram, CPU and Disk Space we need
qt_ky

Replies: 4
Views: 374

PostForum: General   Posted: Mon Mar 11, 2019 12:17 am   Subject: how much Ram, CPU and Disk Space we need
I think you would be fine running a server based on the documented minimum system requirements, plus 4 GB additional RAM, and enough disk space to land all your data plus some extra free space.

You ...
Resolved
 Topic: Site responsiveness
qt_ky

Replies: 1
Views: 544

PostForum: Site/Forum   Posted: Fri Feb 22, 2019 12:40 am   Subject: Site responsiveness
Today DSXchange is quite responsive. I can't recall the last time it responded quickly upon clicking each link. Whatever you all did, please make a note of it and do it more often!! Very Happy
 Topic: DataStage on Cloud
qt_ky

Replies: 3
Views: 506

PostForum: General   Posted: Tue Feb 19, 2019 11:13 pm   Subject: DataStage on Cloud
We are not considering moving any part of our Information Server installations to the cloud. I'm in government. I would say the primary reason is financial. We are able to keep the software current by ...
 Topic: ODBC Stage Socket Error
qt_ky

Replies: 6
Views: 881

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Feb 19, 2019 1:00 am   Subject: ODBC Stage Socket Error
In my situation I did not have to change any settings on Information Server. I had to request the firewall team to change the "extended session timeout" firewall settings. But like Craig said, that us ...
 Topic: ODBC Stage Socket Error
qt_ky

Replies: 6
Views: 881

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Feb 15, 2019 12:42 am   Subject: ODBC Stage Socket Error
Along those lines, it could be a keep alive or connection timeout setting in a firewall. We ran into that before with a different type of database connection.
 

 Jump to:   



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