DSXchange

Was the message suppressed on the old system and you did not migrate the message handler(s)?

... except where the year number is divisible by 400.

Further, the recent earthquake in Chile may have changed the earth's rotation slightly - the year may be marginally shorter. Do you need to worry about that?

Re-compile the routine in production.

This is the SDK routine KeyMgtGetNextValueConcurrent.

You are on the wrong track entirely.

Open Web Console for IBM Information Server then choose the Administration tab. Open Domain Management menu and choose DataStage Credentials from that.

There - possibly with the aid of the on-line help - you will learn about DataStage credentials.

1) Yes, but it would be easier once you build NLADDR and NLAREA (and maybe NLPREP) rule sets. 2) Typically identify potential duplicates through matching on phonetic equivalent and as much other information as you have available, and specify that the reference table is the accurate one. 3) This is y...

Yes you can get the stage to populate a column with the File Name (and another with the line number). How it reads (parses) the files is up to you and the metadata (table definition or schema file) that you provide.

Simple economics: supply and demand. Did 6 nodes make an improvement in elapsed time? Maybe you can schedule this job when there are no developers? Anyway in a production environment there should not be any developers, so you would throw as many resources at the job as the system can deliver comfort...

Sequential File stage.

Method 1: File Pattern of *

Method 2: Filter command of something like type *

Method 3: Filter command to run script that outputs contents of all files in directory onto stdout.

Have you undertaken a Search of DSXchange for this issue? If so, what did you find?

The field in question must be marked Nullable on the output link. No Transformer function can be supplied with NULL as an argument (this requirement is relaxed, we are informed, in the next version of DataStage). Therefore any incoming NULL must be intercepted and not passed to the function. If IsNu...

The sure way is to use $DSHOME/bin/list_readu | grep DS.ADMIN

I don't know whether information about sessions is kept in XMETA - look for a table with SESSION in its name.

If that's not working, precede each job activity with a Routine activity that determines the job's status and makes the decision about starting it. The decision could also include the value of a job sequence parameter to determine whether this is a "run all" or "run aborted only"...

Then don't bother. Use a Filter command and a single File property.

I don't remember and can not determine at the moment. The log does, however, also record any time that dsdlockd is invoked manually in "probe" mode, and records any auto "fix" of a deadlock situation in the local repository.

How do you propose to access the table? DB2 stage? Then import the table definition through that plug-in.