DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 1296 matches
Author Message
 Topic: Datastage on Azure
PaulVL

Replies: 6
Views: 595

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Aug 24, 2020 6:01 am   Subject: Datastage on Azure
Those are all questions that you need to be asking IBM via a Case ticket (formerly PMR ticket).
 Topic: IBM Datastage / db2 connection Issue
PaulVL

Replies: 2
Views: 1194

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Jul 21, 2020 11:19 am   Subject: IBM Datastage / db2 connection Issue
Welcome to DSXchange Jinaanoo, just to be clear, nobody here is your official support team. We HELP however we can.

You should reach out to your local DataStage admin team.
You should reach out t ...
 Topic: DS created database connections
PaulVL

Replies: 1
Views: 281

PostForum: General   Posted: Sun Jul 19, 2020 3:17 pm   Subject: DS created database connections
are you doing a read or a write action?

Partitioned Read?

Anything in your SQL statement to pump up the connections?

Nodes in the config file will not matter. You can drop the Oracle Connect ...
 Topic: DataStage Cloud Pak
PaulVL

Replies: 0
Views: 203

PostForum: General   Posted: Sun Jul 19, 2020 3:11 pm   Subject: DataStage Cloud Pak
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Is anyone using Information Server (DataStage) Cloud Pak module?

Would like to get your opinion on it. Please msg me privately.

Thanks
 Topic: Export/Import environment variables from the command line
PaulVL

Replies: 2
Views: 474

PostForum: General   Posted: Mon Jul 13, 2020 8:07 am   Subject: Export/Import environment variables from the command line
I would NOT recommend copying the dsparms file from one project to another. You do not know if the difference in release level of datastage also constitutes new or removed entries in the dsparms file ...
 Topic: Server Jobs Deprecated
PaulVL

Replies: 3
Views: 1143

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Jun 02, 2020 9:16 am   Subject: Server Jobs Deprecated
Is there an official link to an IBM statement on this? Need to forward to some internal customers.
 Topic: View Data from a DB2 Connector
PaulVL

Replies: 1
Views: 844

PostForum: General   Posted: Thu Apr 16, 2020 4:31 pm   Subject: View Data from a DB2 Connector
Well, that does not give us a lot to go on.

Here is what happens (roughly) under the covers.

The datastage engine submits a dummy job to connect to that data repository. it also dumps a temp f ...
 Topic: job is throwing error: Unexpected exit status -1
PaulVL

Replies: 2
Views: 1845

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Feb 26, 2020 8:21 am   Subject: job is throwing error: Unexpected exit status -1
It's also not the error itself, it's just reporting that you took an exit.

paste more of the log.
 Topic: DS generating 25+GB of log files
PaulVL

Replies: 1
Views: 847

PostForum: General   Posted: Wed Feb 26, 2020 8:19 am   Subject: DS generating 25+GB of log files
Have you checked what is in your log file?

Warning messages perhaps?

if the gui is to slow because of the size of the log, look via command line.

$DSHOME/bin/dsjob -logdetail <project> ...
Resolved
 Topic: Sorting and sending to Entire Partition
PaulVL

Replies: 5
Views: 1821

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jan 08, 2020 12:10 pm   Subject: Sorting and sending to Entire Partition
Couldn't you just do a join with it being set to sequential rather than parallel?
 Topic: Connector Oracle Error
PaulVL

Replies: 8
Views: 2401

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Dec 18, 2019 7:54 am   Subject: Connector Oracle Error
Did you use the schema from the table definition as found on that Oracle box or did you hand code it? I doubt any properly defined date column on Oracle would reflect a 00 month/day value.
 Topic: Querying the log of a multi-instance job
PaulVL

Replies: 6
Views: 1483

PostForum: General   Posted: Sun Nov 24, 2019 8:05 am   Subject: Querying the log of a multi-instance job
Did you source your dsenv settings?


$DSHOME/bin/dsjob -logdetail proj jobname.invocation
 Topic: Engine Credentialled User
PaulVL

Replies: 1
Views: 980

PostForum: General   Posted: Tue Nov 12, 2019 9:04 am   Subject: Engine Credentialled User
You'll save yourself a TON of headaches if you make it login.

You will find that you will sometimes need to SSH into that ID from your admin id. (Assuming that you are talking about a PROJECT spec ...
 Topic: Datastage Housekeeping Activities tasks
PaulVL

Replies: 4
Views: 1297

PostForum: General   Posted: Wed Oct 23, 2019 9:31 am   Subject: Datastage Housekeeping Activities tasks
Are you an admin for your DataStage setup?

There are a bunch of standard maintenance activities to be proactive.
There are things unique to your company that need to be identified.
There are tech ...
 Topic: Job aborting with Return Code :255
PaulVL

Replies: 4
Views: 2005

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Sep 05, 2019 1:51 pm   Subject: Job aborting with Return Code :255
Your admin will make a recommendation after he talks to your application team and understands their log needs.

IF this is the issue of course.
 

 Jump to:   



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