DSXchange

How was the actual migration performed?

You and lots of others. As a general rule 8.0 was marketed under the WebSphere brand while 8.1 is marketed under the InfoSphere brand.

What is the status of instance DFB_UPD_CE_FEEDBACK.PBV ?

Option -param=parametersetname=valuesfilename will work. The individual parameter values, in this case, have been pre-stored in the values file.

If you want to override one of these "default" values, the proper syntax is then -param parametersetname.parametername=value

That's a DB2 thing. You should be able to use a regular CAST.

Interpose a Transformer stage with appropriate data type conversion function.

Where are you trying to do this - interactively or in a server routine? There are some neat tricks in the latter case.

From the operating system command line you can use redirection operator.

From TCL you can use COMO or DIVERT.OUT commands to capture output.

Why? Spaces is not valid as COMP-3. Read again the advice above. It can only work if you re-define the field as something that will take spaces, typically PIC X(n).

You can specify the location of log and bad files in the stage's properties. Since you haven't, they have probably been written on the scratchdisk of the first-named node on which Oracle software is accessible.

Assuming that you are dsadmin when (not) creating the project, verify that dsadmin has all privileges to the XMETA database and all tables therein (at least all those that relate to DataStage).

The error has occurred within Oracle bulk loader (sqlldr). You need to inspect its log file (and, possibly, its "bad" file) to see what the actual problem is. Pathnames for these should be mentioned in the job log.

What you are describing makes perfect sense, assuming that VAR2 has datatype Decimal(18,2) - you left out the word "Decimal". You are dividing by 100, to produce a decimal number with a scale of 4, but then loading it into a decimal data type with a scale of only 2. Therefore the two least...

Before you do or worry about anything else, define "performance" in an ETL context. To my mind, the metric of performance is unlikely to be any kind of rate (particularly not rows per second). The main driver of ETL effort should - nay, must - be the ability to perform extraction and load ...

DSXchange is an all volunteer site whose participants post as and when they can. We don't do "urgent" and find demands for immediate response offensive. DSXchange exists to share knowledge; it is not a substitute for official support. If you need sub-one-hour response from official suppor...

The file system on which /xxx/yyy is mounted is full. All of that information is in the error message.

There is only one cure for full file systems.