DSXchange

You can issue user defined query ' delete from tablename with nologging" that will do couple of things 1. It will not make log 2. It is very fast compared to normal delete. Rgds, Chakradhar. Hi when I try executing this stmt(with nologging) in oracle..it is giving me an error that "statem...

Yes, but only because it is a fixed width file. Simply define them that way in the sequential file's metadata. Since there are no field delimiters, you can "chop up" the record any way you like when reading as long as it all still adds up to the proper record length.

You need to look wherever the client is installed, not the server.

Why, you search the forums for "vertical pivot" of course!

Yes, "reset" and "run" are two different executions of dsjob. And yes, "-jobinfo" will only give you the most recent status but that's all you need in this case.

ps. No parameters needed for the reset.

True, but Grid isn't generally what people are looking for when they ask about "High Availability". Or at least not in my experience.

Yup, that was the solution, or at least it sure seems like it. No clue why this one install (all were allegedly identical "root" installs) had "IMPERSONATION 0" in the uvconfig file but it did. Had the "enable impersonation" script run by root and that seems to have don...

Ah. Thought perhaps this was one of your many clients.

Flashlight and latex gloves, I hope.

I hadn't stumbled across "DSLogToController" before but it makes sense, just looked it up: This routine may be used to put an info message in the log file of the job controlling this job, if any. If there isn't one, the call is just ignored. I especially liked the "is just ignored&quo...

Where did you get that number from, Ray?

One method - write that value to a flat file. Then an Execute Command stage can "type" that file and the output from the stage can be passed as a Job Parameter to any downstream activity. Or if a stage variable will work (rather than a job parameter) then do the same "type" of th...

Do it all with dsjob. First dsjob with the -jobinfo option to check what you are about to run, does it exist and what is its current status - running, aborted, etc. If you find the job needs to be reset, do that with dsjob and the -run -mode RESET option. After all that, run the job like normal.

You can't automate secure anything to take a password, that's just not how it works. Google for "passwordless sftp". Basicaly, you need to create an RSA Key file and install it on the target server so it knows you are ok to let in the door.

Best to check with your official support provider. The "official" answer is no as the plug-in supports versions 7 & 8 but that's not to say it won't work with 9. Have you tried it? Had any issues?

Not much in the way of detail.

You need to determine your bottlenecks, where the "performance issues" lie. Source query too slow? Updates take too long? Deletes? Inserts? Etc. Split jobs up to test each aspect of the problem.