DSXchange

regal wrote:...After that we import a modified version of jobs from a .dsx file. It gives us an error, so we have to drop the project...

If you would be so kind as to post the error then someone might be able to guess as to the cause.

You need to refine your rules. Let us say you want to calculate from the 15th of one month to the 15th of next. What is the result if month 1 has 28 days and month 2 has 31, or if both have 30? The simplest method is to take the delta in days; if that really cannot be done then you would need to com...

The ICONV for a date function will only use the date portion, so you should truncate the timestamp, i.e.

They do have a per-cpu with no concurrent limit licensing option, but in this case they probably do not have that license.

SQL Server Licensing

I am now worried that now that I've published secret information I will be placed on double secret probation...

Could you restate your rule in words, I am not certain what you are trying to group by or retrieve from your example.

do a "ps -ef | grep Server1" - do you have a process? (If not, then perhaps you used my sample userid/password for was..)
do a "ps -ef | grep rpcd" - do you have a process? Then, finally, check for "ps -ef | grep ASBNode" - you should have 2 processes.

This should be part of your boot sequence somewhere. The 3 commands required, if done manually, are: 1. /opt/IBM/IIS/WebSphere/AppServer/bin/startServer.sh server1 -username WasAdministratorUserId -password DoubleSecretProbation 2. /opt/IBM/IIS/InformationServer/ASBNode/bin/NodeAgents.sh start 3. cd...

Could it be the name of the project - or do you get the same error regardless of project name and path?

Arnd, I'm a little lost on the first ... My fault for being unclear - Yes, I meant "OVER.30" file. The overflow file doesn't get resized downwards, even when hashed file contents get deleted. Simple enough to check by creating a file, filling it with lots of data and keys that don't hash ...

stop datastage again then do a "netstat -a | grep dsrpc". There should be no processes visible. You can also search the forum for additional information, as this error is not uncommon.

Again, the big DATA.30 is usually due to the file growing, then being deleted again. In my current project I have a job that runs daily to shrink down those bloated files and scavenges over 10Gb daily from these files alone.

If you tell us what you've tried so far and what has or hasn't worked for you (i.e. convince someone that this is not an interview question) then I'm sure you will get quick assistance. Since someone is going to ask anyway, I will - why must you use only a transform stage? Unless there is a very goo...

Does "/home/apps/ds/xxxxxxxxxx/tmp/APTcs34816348276acd5" exist? Does the path ""/home/apps/ds/xxxxxxxxxx/tmp" exist? If both are true, trying creating a file there with the same userid as you use in DataStage.

How about taking this step-by-step. Modify your job to put an output link from your Oracle stage directly to a flat file and in the Oracle stage options mark "Output reject records" as "true". After the run do a "cat -v YourRejectFileName.txt" to get both the SQL error ...