DSXchange

I was going to mention that patch but I didn't see you were getting any error message and didn't realize you were on 8.7. We had to install that client side patch onto 8.7 and it did fix our WSDL import errors.

The process command tells you if the engine is up and running and if so, it gives the startup date or time.

You can safely remove the QEWSD=39262 line. Those get added when testing DSNs from the command line. It will generate a warning about the license.

For the parallel job you may want to check the ulimit settings on your OS as those can limit available memory.

According to the link I posted above, "the connection to the database from the application has been lost and new connection should be established." Whatever is causing that is local to your environment. You should have local support like a DBA who can monitor it while it runs and see what'...

See if one stage can handle it and try setting it to update 1 row at a time with the stage settings do you don't deadlock/timeout yourself.

Your link is for FastTrack 8.0. You chose Server Edition forum. Here is a link to 8.7 BASIC CHAR function: http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r7/topic/com.ibm.swg.im.iis.ds.basic.doc/topics/r_dsbasic_CHAR_function.html You chose Parallel job type. Here is a link for the 8.7 Char fun...

It takes one column and the column must first be sorted. You could concat many columns into one column, sort on it, then use the function on it.

It looks similar to the parallel developer product manual examples of Transformer loop variables in 8.5 and higher.

root install is the way to go. You don't need to add root into any groups. It is normal for root to own many files under the install location. Did you try logging into any DataStage clients as isadmin and dsadm IDs (not into Web Console)?

We have noticed by default that a new tomcat6.exe process is running on 8.7 clients. I glanced through the "what's new" in 8.7 list and suspect it's related to IMAM web interface. Anyone want to confirm? It does not exist in 8.5 clients. Client path is \IBM\Info...\Clients\MetaBrokersAndBr...

1) when I open derivation fields double clicking on it, I'm able to see its content properly formatted, but If I don't open it I see not printable characters for "carriage return" and "line feed" Item 1 has always been in DataStage and I have never found it to cause any problem....

Revisit the guide...

Try the -domain NONE option or -domain domain:port where domain is a server name and default port is 9080.

Get it to work manually from the command line first before trying out the -file option.

I thought if you went non-DB2 (DB2 is default) on the repository that you first had to run the DDL to create the objects in the repository. Maybe not... Install guide for your version would say.

Also confirm an admin login works, like isadmin or dsadm, before setting up new IDs.

For Q1 it can matter depending on the size of the server, expected volume and frequency of processing, and licensing. You could possibly save a lot on license costs / maintenance by sizing that tier much smaller and putting heavy workload elsewhere. And that really depends on your pricing model.

Also before getting too far from default settings, try mapping the new internal user ID to a default OS ID such as dsadm. One change at a time.