DSXchange

The only option would be to use either CITRIX or Remote Desktop to increase performance. Of course, another option would be to increase the bandwith between yourself and the client.


Regards,

Ray D

Hi Kim,

I've setup Oracle tns information in the dsenv file. This file is executed for all datastage jobs, and I'm pretty sure the client as well.

Ray D

And it used to be a limit on all unix systems. You could create multiple passwords but if the first 8 characters were the same, then the password itself would be the same.

Ray D

I've been teaching EE to a number of clients. I stress that in building lookups, there are a few rules to remember. Joins and Merges are less expensive memory-wise but lists need to be pre-sorted.... And remember that the sorts can be performed on the database server to speed up the sort......databa...

Why not use the dsenv file within the dsengine directory. You should be able to add some type of audit information at this level and then consolidate the information. The only downside would be if you use a single userid as a default user on the system, then the unix ID would be the same. Regards, R...

Use the web tool (dstage:9080). Login as the Administrator, go to the ADMIN tab. You will see user and groups. Click on users and if you are using WebSphere authentication, you can change your password here. If you are using PAM authentication you may change your password in the normal way for your ...

http://publib.boulder.ibm.com/infocente ... rplm04.htm

This link indicates that the max size of a message is 64k by default. You will need to increase the buffer.

Regards,

Ray Daignault

How many sites out there are using the SCD stage. How do you find performance of SCD compared to other options since it looks like the SCD loads data from the Dimension table as a Lookup stage would be loaded (increasing memory usage). On a side note, are you building Type1 Dimension tables (Replace...

The problem may be that you are running on 7.5 and Windows. Do you know if it is 7.5.2 or 7.5.3?

The Windows EE environment was quirky at 7.5.3.

Ray D

I'm at a client site here in Denver, Colorado and the client is using stage variables to handle some aggregation type functionality. Without rewriting a large number of jobs, I was wondering if there was any way to flush final totals when EOF is reached. With a SEQ file it's easy as they just append...

I have an 8.1 release of Datastage running on a Solaris environment. Using the Server engine, I am able to create a job that browses table definitions and extract data from an ODBC stage accessing Oracle. Using this same job design in the EE engine and the ODBC fails to connect. The job generates co...

You should check where your user login for your default user goes to when you login to the system (look in /etc/passwd) When you have a userid that does not have it's own home directory, it can default to a different directory. Also, ensure that the dsenv script in your $DSHOME directory does not do...

Between 8.0.1 of Datastage on Solaris to 8.1, the environment switched from 32bit to 64bit. Those of us upgrading need to ensure that your environment variables are updated for the compiler. Both the compiler and linker need the additional argument of -xarch=v9 This shifts the compiler into 64bit co...

It was installed with NLS disabled. That is what the older system was set for and I did not want to change that for the client.

Ray D

I am performing a new install of Datastage 8.1 on a Solaris system. From analysis of the old 8.0.1 PXEngine and the new 8.1 PXengine "lib" directories, it seems that I need to switch the compiler options from 32bit to 64bit. I've looked at the documentation which talks about Windows and Li...