DSXchange

8.0.1 or 8.1? Was there a problem that caused you to need to restart DataStage? And when you say that, was it just DataStage or was it all of the services- IIS, WAS, ASBNodes?

Tell us, have you been able to do this in the past and it no longer works or is this your first try? Can you use the DB2 stages in jobs without issue?

That's not part of the core 'repository' per se but is in the RT_LOGnnnn table under the project where 'nnn' is the internal job number. Trying to actually 'query' that would be the long way 'round to this, instead I believe that you should be using the API functions that are available. From the com...

The uvconfig file is in your $DSHOME directory, the one called DSEngine. Can you double-check the metadata? It has to match, not just the order of columns but which ones are marked as keys is critical. The other thing that might be happening is another job is writing to what it thinks is a different...

1) Any mention of a T30FILE issue in these errors? What value is yours set to in uvconfig? Having it too low can cause the issue you are seeing under load. 2) Typically means the metadata you are using doesn't match what was used to create it. These aren't like database tables where you can pick and...

Have you tried googling for "ORA-12571", there's all kinds of resources out there for this error and the things you can try to trouble-shoot it.

But... verify for us the data type in the target (is it CHAR now?) and if you removed your previous derivation or not.

Please explain to us exactly what you did, what changes you made and what "didn't work for me" means.

Assuming you imported everything from the dsx file they sent you, it sounds like all they sent you was executables without any 'source' or design time information. Whether that was on purpose or an accidental thing, you'd have to ask them. And you can confirm that by either looking at the dsx file w...

I wouldn't touch the current default value in the Administrator, but instead insert it into you job and then change the default value there. Unless you understood what the ramifications of a global change that like could mean.

Data type of the column? Could you not just declare it a CHAR and ensure your $APT_PADCHAR is set to a space (0x20)?

I guess it depends on what you consider 'useful'. You should at least have found out what it means and how you typically get there - it can either be a purposeful thing because you've only promoted released jobs or just the executables. If they were 'fine' before and suddenly started giving you this...

The 'report' you can get after running the Usage Analysis tool (beaker icon) from the manager on an object and then clicking on the Save button? I don't believe there's any command line option for that, nor any way to do a whole project at a time. Could be wrong, though, but don't think so.

That's pretty common Oracle behaviour in that situation and as Arnd notes, you can use that $APT variable to override it.

Right, or just a stage variable based on row and partition number if it should always start over at one. The stage is meant to begin where you left off last time.