DSXchange

Sounds like the problem is something else entirely, if objects get skipped the repository indexes may be corrupted. The ones that were skipped, can you export them individually, by component?

While you can use GetEnvironment() in PX, for BASIC you'll just need to DSExecute an "echo" of the variable.

Add OLETYPE to the select list and cut the "LIKE" back to just "%DB2%" and see what turns up.

Datatype of what is varchar? There's no scale for strings.

It's been discussed here before and a search should turn them up, did you see if any of those other posts helped?

Not the project but asking if any of the jobs were locked when you exported. If you can open them in Designer, then they're not locked. Also, there's a "log" file that should be generated during the export that lists any issues, do you ever see that file afterwards?

Yes, depending on the trigger you use between jobs. Stick with an 'OK' trigger, enable that option and let us know.

:? Some server jobs? Because they're read-only or because they're locked? Are any other read-only jobs exported? All my projects outside of dev are read-only and export just fine. How are your jobs made read only - via Version Control or some other mechanism? You need to do a little research here.

The Sequence job itself ran just fine, it doesn't really care that the jobs you ran had issues, hence the status. You'll need to log a warning in the Sequence itself if you want the Sequence to have a 'non-OK' status, either via a routine or the 'Automatically handle' compilation option.

Then it seems like time to involve your official support provider.

Ping support.

Post your complete, unedited errors from the log.

There's several ways, including "test -s" and "wc -l".

That istool is only available in 8.1.1 with that 'comprehensive' patch installed.

aaryabhatta wrote:DBA is not of much help as they say the DATE_CHACHE has to be increased when sqlldr is used. I guess DataStage is using it by default.

Ask them how one would do that taking DataStage out of the picture.