DSXchange

In your routine ("modify") you need a DEFFUN declaration to declare the catalog name and number of arguments of the KeyMgtGetNextValue routine.

Welcome aboard :D The data browser (View Data) is not able to communicate with the DataStage client, and/or vice versa. Error code 81002 indicates that the connection (via DataStage RPC) is broken. Check that you haven't triggered an inactivity timeout, check that the DataStage RPC daemon (dsrpcd) i...

A good start point would be to buy the DBA a beer and monitor the database to see if locks are causing these hangs. If they are, then re-design the jobs so that they don't generate deadlocks or self-deadlocks. Running out of space doesn't cause hangs; it cause crashes (aborts). (You did say you need...

Only the ones you have, such as the Server Job Developer's Guide in the standard manuals.

The @INROWNUM system variable gives you this count as each row is processed. Therefore in the last row it has the total number of rows in the source file. Pass this through an Aggregator stage with either Last or Max as the aggregation function (Last is more efficient) to get just that number output...

The number of bytes in a file is returned by the STATUS statement applied to the file variable associated with an opened file. In your case, since it's an operating system file in which you are interested, you would have opened it with OPENSEQ, and will close it with CLOSESEQ. This has been describe...

Iconv() and Oconv(). But first you need a guaranteed mechanism for standardising your date format, adding a leading zero to the month where necessary. For example If Len(TheDate) = 7 Then Left(TheDate,4) : "0" : Right(TheDate,3) Else TheDate Apply an Iconv() functio...

Technically no, but they may be thwarted from doing anything DataStage/SQL while the utilities have UV_USERS locked. Further, since it's a dynamic hashed file, the bad information might be loaded in memory, and overwrite our fix when the file is closed. Therefore it's better to have no DataStage cli...

Not a particularly useful subject line for future Search users! Make sure that Field 'UDF_057' from input dataset is nullable everywhere it is used - including downstream operator(s) that might be combined with the one that generated the warning. Set APT_DISABLE_COMBINATION to True to find out exact...

The db2 node 'uhqt3cdb01.rei.com' does not exist in the apt configuration file.

Put it in the configuration file!

The user-defined SQL is not discarded even though you switch back to generated SQL. It's "remembered" in case you switch back to it. That may explain why the unused table name continues to appear in the export file. Don't worry about it if that is the only location where it appears. If you really wa...

Anything over about 1000 rows is likely to benefit. It may be possible to get even better speed, by not using the "bulk load" stage at all but, rather, using a Sequential File stage to write the data file(s), and invoking the bulk loader (using a pre-written, tuned, control file) either in an after-...

At some sites where they won't give you root access (understandably) they are happy that you instruct the person who does have root access through the required steps. At least that's been my experience.

Good luck.

Maybe, maybe not. It depends on whether the child process of the killed job sequence notices that its parent has died. Why do they get so many hangs? Is there some problem with the manner in which database tables are accessed (for example trying to update the same table from which a SELECT is still ...

You (or someone) does have to be superuser to use the FIX option on UVFIXFILE. You may have better success with fixtool (which, being more recent, may recognize dsadm). But no guarantees. DBA privilege is unrelated to these tools. You need to have O/S admin access. That DATA.30 is 4096 bytes long im...