The server where my Datastage is installed has the hostname : kasitmisdb1, I have db2 installed in another server kasitmisdb3,
so I have created the following config to enable remote connectivity through Enterprise edition.
My config file has been designed as : -
Code: Select all
{
node "node1"
{
fastname "kasitmisdb1"
pools ""
resource disk "/opt/IBM/InformationServer/Server/Datasets" {pools ""}
resource scratchdisk "/opt/IBM/InformationServer/Server/Scratch" {pools ""}
}
node "node2"
{
fastname "kasitmisdb3"
pools "db2" ""
resource disk "/tmp" {pools "db2"}
resource scratchdisk "/tmp" {pools "db2"}
}
}
##I IIS-DSEE-TFCN-00001 12:00:20(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.5.0.5746
Copyright (c) 2001, 2005-2008 IBM Corporation. All rights reserved
##I IIS-DSEE-TFCN-00006 12:00:20(001) <main_program> conductor uname: -s=Linux; -r=2.6.18-164.el5; -v=#1 SMP Tue Aug 18 15:51:48 EDT 2009; -n=kasitmisdb1; -m=x86_64
##I IIS-DSEE-TCOA-00067 12:00:20(002) <main_program> OS charset: UTF-8.
##I IIS-DSEE-TCOA-00068 12:00:20(003) <main_program> Input charset: UTF-8.
##I IIS-DSEE-TFSC-00001 12:00:20(004) <main_program> APT configuration file: /opt/IBM/InformationServer/Server/Configurations/db2_ee.apt
##E IIS-DSEE-TFIO-00211 12:00:20(000) <APT_RealFileExportOperator in APT_FileExportOperator,0> APT_Communicator::connectTo: connect() failed due to Unix error = 111 (Connection refused) on node kasitmisdb1 using ConnectionInfo object 'TCP, connection Host: localhost (127.0.0.1), TCP port number: 11001', RETRYING connect()
##E IIS-DSEE-TFIO-00211 12:00:20(001) <APT_RealFileExportOperator in APT_FileExportOperator,0> APT_Communicator::connectTo: connect() failed due to Unix error = 111 (Connection refused) on node kasitmisdb1 using ConnectionInfo object 'TCP, connection Host: localhost (127.0.0.1), TCP port number: 11001', RETRYING connect()
##F IIS-DSEE-TFIO-00112 12:00:20(002) <APT_RealFileExportOperator in APT_FileExportOperator,0> Fatal Error: APT_Communicator::pmSendPartitionInfo() failed on node kasitmisdb1 for partition 0 of dataset 0 (write failed to handle 8) Bad file descriptor
##E IIS-DSEE-TFPM-00192 12:00:20(000) <node_node1> Player 2 terminated unexpectedly.
##E IIS-DSEE-TFPM-00338 12:00:20(005) <main_program> APT_PMsectionLeader(1, node1), player 2 - Unexpected exit status 1.
##E IIS-DSEE-TFSC-00011 12:00:25(000) <main_program> Step execution finished with status = FAILED.
##E IIS-DSEE-TCOA-00069 12:00:25(001) <main_program> ERROR: check configuration file failed.
I have enabled SSH between the two servers and I have made the required change in the remsh file.
I can do password less ssh between the two servers.
I have gone through the other posts in this forum, and even tried a few solution without any luck.
Please help and thanks in advance.