DSXchange

Does anyone know where I can find the list of legitimate (engine?)commands that can be entered in the Administrator's Command Interface? The documentation very blithly tells you that you can enter commands ... but then cleverly neglects to inform you what the set of those commands are ... or at any ...

Thanks very much.

It is necessary to have a C++ compiler on the system to which one is deploying a Datastage parallel job that contains a Transformer stage? I understand the compiler is necessary in the development environment to compile the C++ code generated by DS into OS executables, but once the executable image ...

Thanks we get rid of the warning by using a double datatype for the Datastage column (SAME_DAY) concerned.

Thanks.

Here is the error I am receiving from a Column Generator stage in a parallel job. Oracle 10g used for both source and target stages. SAME_DAY: When checking operator: When binding output interface field "AMOUNT" to field "AMOUNT": Implicit conversion from source type "decima...

Gregg - Thanks for the info. It should be very useful going forward.

Interesting. Looks like DS is optimized for DB2 ... not surprising. I guess if the Oracle result set is from a join then the input is sequential. Even with DB2 I guess only a single table (or view?) per SELECT is supported in parallel.

Thanks.

When a parallel job is configured to use more than one data partition (say 4) does DS create a seperate connection to the DB server (Oracle, DB2, etc) for each partition? Or is there only one connection between DS and the DB, and the data is not partitioned until it arrives on the DS server? If the ...

In general (don't you hate it when someone begins like that?) ... is it better to include as much logic as possible into one big job ... or ... to break up the logic into as many simple jobs as possible? We have an ETL application with over 20 simple jobs, each not much more than one extract stage, ...

Thanks Stuart. Is this the process name of the server engine or the parallel engine? Or both?

I have just gotten access to some HP-UX systems that I have been told have DataStage 8.1 running on them. I have command line access ($) to the HP-UX systems so I can run ps or other shell commands. Can someone tell me what I should look for to tell if any of the DS executables are running there? Th...

Thanks guys. Once created can a routine be manipulated similarily to a stage type and be instantiated as a step in the flow of a job? Do you know if any of the 30+ pdfs in the doc set explain routines?

Could someone give me a brief description of what a DS Routine is and when, why & where I might want to use one?

Thanks in advance.

Gotcha ... thanks.

Yes, and no. The Information Server installer will install WebSphere Application Server if your environment is 32-bit. If your environment is 64-bit you will need to pre-install WebSphere Application Server 6.0.2 then upgrade it to 6.0.2.27 (a single fix pack) to handle the 64-bit environment. OK t...