DSXchange

It depends where your attach point. look at the option, you will need to specify "-filepath {path}" if you are not attached to the directory where the DS_JOBOBJECTS reside.

I posted the command line options for fixtool for you a couple of posts back. cd to the project directory and enter "fixtool -file DS_JOBOBJECTS -logging". If it looks OK then add the "-fix" option and see if it helps. I don't think it will if UVFIXFILE wasn't successful, but it's worth a shot.

Is there any chance of removing this for users? perhaps a counter in our cookie once we've reached the magical 7 impressions to make it go away? I find it rather annoying and bothersome.

Can you not define your SS_NUM_8 as a nullable column in your DS job and then handle it explicitly?

Rob,

I'm not sure what you meant by your post, if I want the "first" row on a column such as an integer one called "AGE" and do a select with an "ORDER BY AGE" in my DataStage query the first row returned will have the lowest column value of "AGE".

Kommven,

are we dealing with PX or Server here - I'm confused about which product to discuss. rsh is used in PX but not in server...

Buffer size in interprocess communication is usually irrelevant, it only needs to be increased if the singe row sizes are very large. Leave it at it's default setting.

Which stage is "CopyOfJ_Stage_PS_PERSONAL_DATA"? The error is triggered from the IPC stage after that. Have you changed either the timeout or the buffer size in the IPC? If your system is very heavily loaded and slow, you might raise the default timeout from 10 (I think it is that value, but I'm not...

You can just move the files from one box to another when you use paths. This is assuming the boxes are on the same platform, when you move between a Windows and a UNIX machine you need to change the internal file byte oder (FNUXI) a tool exists to let you do that as well.

By posting "urgent" you have managed to get your post ignored by many here; Klaus was kind enought to respond. In the future you'll see that responses and discussion go a lot better when you don't try to push... A hashed file in a project has several components, only one of which are the UNIX entrie...

There is no date field embedded in the designtime information of a job, but you can look at the DS_AUDIT table in the project repository. That file will give you an audit trail of the change history for your jobs, among other information. The DS_AUDIT table is not described or documented and does co...

No real difference between the two in what they achieve. The interprocess does it automatically for active-active links, while with IPC you get to control where it is done.

Everything related to a DataStage project is stored in the project directory.

Since the file is corrupt, none of the DataStage internal saves/copies will work, you are limited to working with the file system objects in the project's DS_JOBOBJECTS directory. The DS_JOBOBJECTS hashed file contains most of the repository metadata about your jobs and it is particular to a project...

The larger the project is, the more difficult it is to backup but the more important it is to do so. One of those nasty laws of computing. UVFIXFILE is a TCL command, executed within DataStage. The options can be listed by doing a "HELP UVFIXFILE" (don't do this in the Administrator, the screen gets...