DSXchange

Hi Kumar, ##W TFCP 000000 05:38:11(001) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1". In the transformer when reject conditions are specified and no reject file is present then this error will ...

The location of the hosts file is "C:\WINDOWS\system32\drivers\etc\hosts" for a windows system.

And in a AIX system the location is just "\etc\hosts" I guess.

--Tony

Tony, I did not get you, etc\hosts?............... why we add this and where we add this because we never did that in any of our project...we just add database in .odbc.ini and uvodbd.config as per my knowledge.... Thanks Kumar Kumar, We had a similar issue like you are facing when moving from One ...

Raj,

Check your ".odbc.ini" and also with your Mainframe DBA if the ID you are using has appropriate previleges.

--Tony

Could you tell in which phase your project is in?

If it is in production already and you have a lots jobs then upgrade is better. If in development phase fresh install wouldn't make any difference.

And one more thing. What exactly is the "X" in 7.5.X?

--Tony

Arvind,

Is the issue resolved now?

--Tony

Since Ray has confirmed about the 64 bit and since the PATH is getting replaced everytime dsenv is invoked, Can we a have shell script or something like that which'll could be scheduled & will restore the PATH variable to its original value? :idea: This can be a temporary solution till we have t...

Magesh,

Magesh_bala wrote: I know that in a 32 bit we cant write more than 2GB to a file, I want to know what is the 64 bit file size limit?

We can write more than 2 GB in 32 bit also. Infact 32 or 64 bit doesn't decide the maximum file size, but an Environment variable does.

--Tony

Is the IP address and hostname of the SQL server added to "etc\hosts" file of the client system?

--Tony

Kelvin,

Post the configuration file entries.

--Tony

Though the Server and DB2 may be 64 bit, I guess that Datastage is a 32 bit application.

Try adding the "lib32" path to the LIBPATH in dsenv.
--Tony

Murali,

The special characters will be created due to incorrect mode of data transfer across platforms. Try toggling the transfer mode to ASCII or Binary. See if this resolves the issue.

--Tony

Arvind, 1 GB of Max Heap Size is more than enough for any JVM, but Sun recommends 2 GB for complex applications and/or 64 bit servers. In addition to setting ulimit -d to unlimited, set also ulimit for coredump to unlimited. If still the problem persists then we need to take a close look into the Jo...

Arvind, The reason for this log out is that One or more of your jobs is increasing the server memory's heap size (Utilizing all available free memory). This mainly happens because of the Java Virtual Machine (JVM) which Infosphere uses. Try either to increase the memory size in the server or set &qu...

Hi Arulan,

The "orchdb2op.o" file is not present in the version 8. Instead "orchdb2op8.o" will be present.

The confusing bit is why datastage is searching for a non existent file

--Tony