DSXchange

dsguyok wrote:I've got it working on DS 7.5 running on UNIX.

How were you able to get this working on 7.5?

DB2DIR, DB2INSTANCE and INSTHOME should be set in your dsenv

also, are you able to successfully issue a DB2 command from the user on AIX and get a db2 prompt? ex. db2 =>

Also, don't forget to stop and start the engine whenever editing the dsenv.

You most likely need to update your dsenv file to point to the database.

Check out this link:

http://www.ibm.com/developerworks/data/ ... #dseestep1

Is this an API stage or EE?

I am running DataStage 7.5 on AIX 5.3 and want to connect to an Oracle database on another server. Does an Oracle client need to be installed on the AIX (ETL) server prior to getting DataStage to connect or does DataStage not need a client to make that connection? Are the DataStage oracle drivers en...

I believe it may be an instance issue as well, just not sure what.

The UID that i am using is set up on all servers with the same UID. The UID has access to the databases on both servers and it is the same user that I sign in to DataStage with so I don't think it's a User issue.

After making some modifications, inlcuding creating the DPF instance owner user id on the ETL server and placing the DPF nodes.cfg file in the home directory of the created user I know get a different message when trying to connect to the DPF server. Below is the error that I receive when trying to ...

Yes, rpsts1ii is the instance of the DPF server. The permissions are correct and can be read by the DataStage user directly on the DPF server and using rsh from the ETL server. If I were to add the APT_DB2INSTANCE_HOME variable to my job, then I limit the number of DPF servers that my job can connec...

I am configuring EE but having issues when trying to connect to another database on a different server than the one where datastage is installed. I am following the document to configure for EE. I am able to rsh to the server without password. .rhosts is setup correctly. /datastage is mounted on all...

dganeshm wrote:Mostly it is metric calculation done on a weekly basis used as a planning tool.. so its gonna read from and write to the same database.

Performace wise it will probably be the same or close to it but from a documentation and maintenance standpoint you will be better off having it in DataStage.

Hi , I have been given a new assignment to convert stored procedures to jobs. Do you guys really think its advisable to convert a MS SQL Procedure to a DataStage Job ? It depends on the stored procedure, Without knowing what the stored procedure does it's hard to determine if it should be converted...

That "operator" role is severely nerfed / broken in any pre-8.x version and only allows people in that role to see released jobs, something virtually no-one does any longer. The only good news is if you upgraded it would work as expected. Otherwise, you'll need some other mechanism to del...