DSXchange

@chullet,
I believe rsh would work on remote Windows machine if MKS toolkit is installed and rsh is configured.

@lstsaur
Not sure if my Windows admin would let me install a Cygwin's server. I'll try Ray's advice first and if it doesn't work then I'll go with Cygwin approach.

@all
Thanks guys.

Hello, I have a requirement to read files present on remote Windows shared drive and process it further. Once processing is complete the ETL code should be able to delete remote files. To read remote file on Windows shared drive I use FTP stage but I'm unable to figure out how to delete that file fr...

Hello, DataStage Engine is installed on Machine A. DB2 is installed on Machine C. In order to enable DB2 Enterprise stage should the user ID and group ID on Machine C be the same as that on Machine A? I've got a document from IBM which is almost same as http://www.ibm.com/developerworks/data/library...

Kim,

Please correct me if I'm wrong. Do you mean to say that dscmdexport.exe doesn't return exit value to ERRORLEVEL?

Thanks.

Hi, I'm unable to capture the correct exit status of dscmdexport.exe in a Windows batch file. I searched this forum and found a lot of posts but it wasn't helpful. Below is my code. Irrespective of failure or success ERRORLEVEL value is set to 0 and both "Success" and "Fail" line...

Currently I'm working on DataStage 8.0.1 and using dscmdexport.exe at the client end to export project(s). I was wondering if there is "-export" option for dsjob UNIX command in DataStage 8.1 version. Please clarify.

Thanks for your time. I appreciate it.

Thanks Craig & Ray.

If there is no IBM documentation for UniVerse then how do I learn more about it?

Thanks

Hello,

Can anyone please point out the differences between UniVerse database and XMETA? What do they contain and how they are related to each other? Is there DataStage documentation for both?

Thanks for your time.

Craig, When I test the config file I see the following error ##F IIS-DSEE-TFPM-00347 13:55:22(000) <main_program> Fatal Error: Service table transmission failed for db2node1 (hq1.subsidiary.com:Broken pipe. This may indicate a network problem. Setting APT_PM_CONDUCTOR_TIMEOUT to a larger value (when...

UNIX admins added a SEARCH string to /etc/resolv.conf file.

Craig,
Even though rsh is working fine using PUTTY why am I facing this error? Any guesses?

Thanks.

We got the rsh issue resolved. However we still face the below error. ##I IIS-DSEE-TFCN-00001 13:55:21(000) <main_program> IBM WebSphere DataStage Enterprise Edition 8.0.1.5183 Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved ##I IIS-DSEE-TUTL-00031 13:55:21(001) <main_program> The...

Can this be the problem? Let DSEngine server be hq1 and server having DB2 be hq2.subsidiary.com. I'm able to rsh from hq2.subsidiary.com to hq1 just by issuing $ rsh hq1 but when I try the same from hq1 to hq2.subsidiary.com by issuing $ rsh hq2 It doesn't work. But $rsh hq2.subsidiary.com works. Sh...

This is strange! Now I get the following error: ##I IIS-DSEE-TFCN-00001 13:55:21(000) <main_program> IBM WebSphere DataStage Enterprise Edition 8.0.1.5183 Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved ##I IIS-DSEE-TUTL-00031 13:55:21(001) <main_program> The open files limit is 2...

Since I didn't get any replies from DS Gurus I went ahead and did the following: 1) Setup ${HOME}/.rhosts file in both hq1.subsidiary.com and hq1 server. I am able to rsh successfully from hq1.subsidiary.com to hq1 and vice-versa. Note 1: hq1 server contains DS engine and hq1.subsidiary.com is the s...

Hi, Can we configure DB2 Enterprise Stage to work in the below scenario? DataStage engine and repository are installed on, say, host1. abc .com. We have DB2 database installed on a different host but with same domain i.e., abc.com and DB2 Enterprise stage works fine. There is DB2 database installed ...