DSXchange

Do you get any error messages at all?

Try running the job using the command line (dsjob command).

Just to be pedantic, log purge is initiated only if the job completes with no errors. That is, if the job aborts or is stopped, no automatic purge of log events occurs. That means that you can compare the current run's log with the previous.

Every project I create has a sub-directory created in which its Data Set, File Set and Lookup File Set descriptor files are placed. No problem finding them when the need arises. I don't go to the extreme of making the resource disk hidden directories, but can understand Paul's motivation. Most of my...

If the dsprcd process is running, then perhaps you need to provide minimum credentials on the dsjob command line.

The easiest way to determine whether the daemon is running is to see whether its process (dsrpcd) exists. Another way is to use the uv command to pose the question.

Search DSXchange for the phrase "DSX cutter". You should be able to adapt one of the scripts that your search uncovers.

Did you perform the installation? If so, you should know where the XMETA database is. Otherwise look at the install.log file for the services tier.

Note, however, that the passwords are not available in the log files.

What Arnd said.

Why not use YearfromDate() function?

Note that there are two "administrator" roles for Information Analyzer: project administrator and data administrator. They have different allowed activities.

That solution does not cover the possibility that colb might not be in {1,2,3}. This information was not provided in your original "specification".

Specify the correct schema name.

Welcome aboard.
You can load the SQL into a file or into a job parameter.
You will need to use Runtime Column Propagation.

Tech note on handling defunct processes on AIX. Note that, in IBM-speak (on AIX), defunct can actually mean zombie.

http://www-01.ibm.com/support/docview.w ... g3T1010692