DSXchange

can you "ping" your server using the name from your PC? If not, use the IP address in the dsjob command line.

Can you write the output of the sort/aggregate to a sequential file and then link from the sequential file to your Database write? I think the database won't get opened (and therefore no timeout) until the write to the sequential file finishes. If you have the disk space just shove a sequential stag...

Wait a second - SQL Commit error? Looks like it is not a sort or aggregate problem but perhaps a timeout or transaction size issue. How long is this process taking?

I remember back in the day that we had to install Japanese server on a japanese version of the OS (which might in turn run in english-only mode). The README file is quite clear on this, so it would be best to look at that as the more accurate reference of what is supported on AIX. The Japanese clien...

Check your disk space yourself to see if this is the cause - I just stated that disk full is a common cause of file corruption issues, and it is likely the culprit as you are getting this when trying to write.

Did you execute the DS.TOOLS REINDEX?

Does this mean that you cannot delete the bad job? Something is corrupted. You should reindex (you can use the search facility for DS.TOOLS to get information about this) and see if you can delete this job afterwards. Normally this only happens when something has gone really wrong, such as a disk-fu...

The "not enough space" is happening on a "fork" so I would look at physical and virtual memory space, plus process memory.

If the transformer is a BASIC type transformer then DS will need to use the "entire" partitioning method. Is this the case?

For some reason the DataStage hashed file RT_CONFIG489 cannot be written to. The most likely causes are insufficient access rights, disk full or file corruption. First off, do a "save as" another name - does that work? If yes, the file might have become corrupted, so delete that job and then do a re...

Hello Javier, the <CR><LF> terminator is in fact 2 bytes, so that shouldn't throw off your column width at all. So if you define your columns with the appropriate fixed widths you will be able to read them into a DataStage job with no problem. You can then write a Transform stage derivation for the ...

The crc32 algorithm returns 4 bytes. The longer your input data string the more likely it will be that you will get an encoding collision. So there is no hard limit to adhere to, just a realization that you might be getting a duplicate shown in crc32 that represents different data.

See the other reply, as this is a bit of a double post. I don't know the INET mail server (neither does google), so I can't help you there; but as long as you have a command line interface you can use e-mail no matter what the protocol is.

Naveen, the mail call is just an interlude to the command line "mail" on unix. If your mail system uses the same command line syntax then the protocol actually used to encode/decode and transmit the mails is not important. If you have a different command then you will need to "fake" this call by cre...

Amos, might you redefine your table explicitly as {SchemaName}.dba_tab_subpartitions and try it again?

No, they are quite different. SMTP (simple mail transport protocol) is a golden oldie with which the original mails were exchanged. "inet" (as I know it) is just short for internet protocol or IP, which is at a completely different layer; usually the SMTP system will use IP packet to move data back ...