DSXchange

I assume you ran XMETA scripts before the install.

You should not need to restart the OS after adding users.

You don't need to create any groups in the web console.

Your error message indicates USER1 vs. USER123. Double check that first.

Given that the error tells you incorrect user or password, it's probably not a network, hosts, or firewall type of issue. You can confirm that by disconnecting from your network. You should find a different error upon login.

Someone has probably changed a setting on the server or via the web console.

Find the sort/merge property and fix it. Sounds like it is set to sort on a key column that perhaps used to exist and no longer does.

Make sure no DBA is killing sessions.

Does it abort with that error the first time, every time/every day?

How much delay is there between starting the job and the abort?

Share the above info with support. Share what you find out.

Take the SQL from the job log if it is there, to your DBA. If still stuck, then contact support.

The engine tier cannot use the internal user registry. For an internal user registry, set User Registry to Not Shared and map credentials. For an external user registry, set User Registry to Shared or Not Shared, depending on your setup. Mine is like yours all on one box and I have it set to Shared....

It has been a long time, but the description reminds me of the slight mismatch between client version and server version. I'm recalling a similar problem that finally resolved by discarding the client server software that was off (i.e. 7.5.2 vs. 7.5.1A). Compiles are initiated on the client and comp...

Replace the -ft options of '-dsNamespace=server/project' with '-onNameConflict rename' then you will end up with a new FT project with "_New" appended on the end of the project name. Open it up in FT and go to the project properties. From there you can rename the project to any name you wa...

DB2 web site says... SQL3009NThe Action String parameter is not valid or too long. Explanation: The Action String (for example, "REPLACE into ..." for Load and Import or "SELECT c1 ..." for Export) parameter in the command is not valid or too long. The Action String pointer may b...

It partitions according to an algorithm. You can see which records land where by adding a Peek stage.

Looks like you're on 7.x and I'm not sure if it has a DataStage Programmer's Guide or not so this may not help... It has a section "Commands for checking and repairing projects" and a SyncProject command. If none of that works then hopefully you're still on a supported release of 7.x and y...

There used to be a Distributed Transaction stage you could use for some purpose like that within one job to insert/update/delete into multiple tables then commit.

Hopefully this help answer one question... When you execute DataStage jobs, they execute from the server (engine tier), so you don't need a database connection from your client tier (Windows) for jobs to execute. A database connection from your client will still be useful to check database results w...

To quote Craig...

chulett wrote:Not sure... you could always ask your official support provider and let us know what you find out.

I second that.

That is expected, correct behavior. If your data type is varchar and your string is all zero, then you would end up with '' which is an empty string (two single quotes). Should you need to change empty string to some other value, you can add an If Then Else statement to check for the condition and p...