Search found 92 matches

by Klaus Schaefer
Fri Apr 04, 2008 5:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: lookup warning
Replies: 4
Views: 3559

Re: lookup warning

Since you seem not to want duplicate matches, you should deduplicate your reference data with the remove duplicates stage.

Klaus
by Klaus Schaefer
Wed Sep 13, 2006 8:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel lookup stage in V 7.5.1
Replies: 4
Views: 1661

Re: Parallel lookup stage in V 7.5.1

Hello Nagesh, nice way you found out ;-) I'm pretty sure no transformations are allowed in Lookup. Must be a bug of the gui that allows you this handling! To have this functions working they must be generated to and compiled with c++, which only happens to the transformer... You should report this t...
by Klaus Schaefer
Fri Aug 25, 2006 2:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: BASCI Transformer in PX Jobs, not recommended or what ?
Replies: 7
Views: 2392

From my experiences at several customer sites: Don't use it! Yes, it may cause instability for the whole system. Yes, it may even crash your system. If you're not coming from a previous server site and want to use it just for a migration period: NEVER EVER think about using the BASIC transformer in ...
by Klaus Schaefer
Wed Aug 23, 2006 7:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSR.ADMIN error
Replies: 3
Views: 1442

Re: DSR.ADMIN error

Well, help is a bit difficult from remote ;-) but - did the install run properly? - did you get a project installed - check the UNIX rights of the project files, they must a least be r/w/e for the group dsadm has as primary group. I'd really think about a new install, maybe bes a root. root will onl...
by Klaus Schaefer
Wed Aug 23, 2006 6:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSR.ADMIN error
Replies: 3
Views: 1442

Re: DSR.ADMIN error

Have you read the install manual, chapter "Non root installtion"? Several advices are given there that must be followed to have a non root installation function properly.

Klaus
by Klaus Schaefer
Wed Aug 23, 2006 5:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Control Language Reference?
Replies: 4
Views: 1677

Re: Job Control Language Reference?

Job Control is actually DS Server functionality. You find a detailed description partly in online help and full description in the "Server Job Developer's Guide", chapter "BASIC Programming". This guide is part of your standard DS docu automatically installed when you install DS ...
by Klaus Schaefer
Thu Jul 27, 2006 2:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Using Schema file
Replies: 4
Views: 1794

Even with RCP off you can work with a dataset and a partial schema definition. You can treat it like a relational table...

Once the dataset has been written, for reading it you can specify just the columns you need.

Klaus
by Klaus Schaefer
Wed Jul 26, 2006 9:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dynamic Buildop
Replies: 1
Views: 1286

Re: Dynamic Buildop

What do you want to do with "any column" to process it..... ;-) Well, a bit can be done with RCP activated. But, since you don't know what "any column" is, usually you can only pass them through the buildop without any specific processing. For whatever you plan to "really&qu...
by Klaus Schaefer
Wed Jul 26, 2006 9:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 Interaction
Replies: 3
Views: 1373

Well, that's all nicely described in the installation guide ;-).... For your DB2 connect software you have a client profile, usually called "db2profile". You need a statement in your dsenv like . /home/db2/sqllib/db2profile to let DS source the DB2 environment. You don't need to do anythin...
by Klaus Schaefer
Wed Jul 26, 2006 6:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 Interaction
Replies: 3
Views: 1373

Re: DB2 Interaction

For communicating with the AS400 DB2 from DSEE you need to utilize the DB2API-stage, not the DB2EE-stage. That means you'll talk via DB2connect, which must be installed and configured on your UNIX-server where DSEE is running. Get the DB2 profile and put it into dsenv. Stop/restart the DS services a...
by Klaus Schaefer
Wed Jul 26, 2006 5:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: executing cobal programs from DS
Replies: 2
Views: 1893

Re: executing cobal programs from DS

Wrapped Stage would be one option to do this, depending on the specific requirement you have.

Klaus
by Klaus Schaefer
Wed Jul 26, 2006 4:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom Warnings ODBC
Replies: 10
Views: 4161

Re: Phantom Warnings ODBC

Identify the entries in the project phantom directory &PH& (timestamp) and see if you can get some more information from there.

Klaus
by Klaus Schaefer
Wed Jul 26, 2006 4:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Installation on Solaris 2.10
Replies: 3
Views: 2113

As per my last info you should have these messages as warnings only but be able to continue the installation. This messages are due to the zone configuration, where these files no longer exist. Make sure the global zone kernel setttings and all resources in the zone where you install are appropriate...
by Klaus Schaefer
Tue Jul 25, 2006 4:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: not able to use load method
Replies: 9
Views: 5434

It may sound silly due to the error message, but for loading you need dbadmin rights on your user and the db2user you're specifying. Please check that theses rights are given to you and retry the load.

Klaus
by Klaus Schaefer
Thu Jul 13, 2006 6:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Backwards job compatibility
Replies: 5
Views: 3129

Re: Backwards job compatibility

Well, backward compatibility normally is never garanteed..... ;-) I would not recommend to rely on this. What you could do is provide a separate "test" environment for 7.1 to check if it works, and then do the final import. However, I would recommend to upgrade your target server to 7.51A ...