error encountered while connecting to db2 database from ds
Posted: Tue Sep 18, 2007 12:51 am
I am trying to connect to db2 database using DB2/UDB stage on AIX platform. Getting the below error while trying to view data from the properties of DB2/UDB stage. Please help.
##I TFCN 000001 01:43:57(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.2
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TUTL 000031 01:43:57(001) <main_program> The open files limit is 2000; raising to 2147483647.
##I TOSH 000002 01:43:57(002) <main_program> orchgeneral: loaded
##I TOSH 000002 01:43:57(003) <main_program> orchsort: loaded
##I TOSH 000002 01:43:57(004) <main_program> orchstats: loaded
##I TFSC 000001 01:43:57(005) <main_program> APT configuration file: /home1/dsadm/Ascential/DataStage/Configurations/default.apt
ksh: /home1/dsadm/Ascential/DataStage/PXEngine/etc/standalone.sh: not found.
##W TFPM 000152 01:44:27(000) <main_program> Accept timed out retries = 12
>##E TFPM 000153 01:44:27(001) <main_program> The section leader on PNBDWH01 died
>##E TFPM 000356 01:44:27(002) <main_program>
>
>**** Parallel startup failed ****
>
>This is usually due to a configuration error, such as
>not having the Orchestrate install directory properly
>mounted on all nodes, rsh permissions not correctly
>set (via /etc/hosts.equiv or .rhosts), or running from
>a directory that is not mounted on all nodes. Look for
>error messages in the preceding output.
>
>
##I TFPM 000177 01:44:27(003) <main_program> Step started on node PNBDWH04; it uses 3 nodes.
The program running the step is /home1/dsadm/Ascential/DataStage/PXEngine/bin/osh.
##I TFPM 000178 01:44:27(004) <main_program> The ORCHESTRATE startup program in /home1/dsadm/Ascential/DataStage/PXEngine/etc/standalone.sh is being used.
##I TFPM 000181 01:44:27(005) <main_program> A startup script is not being used.
##I TFPM 000183 01:44:27(006) <main_program> The TCP port being used for startup is 10,002; the associated socket number is 5.
##I TFPM 000184 01:44:27(007) <main_program>
Node status:
##I TFPM 000185 01:44:27(008) <main_program> PNBDWH04 -
##I TFPM 000186 01:44:27(009) <main_program> OK
##I TFPM 000185 01:44:27(010) <main_program> PNBDWH04 -
##I TFPM 000186 01:44:27(011) <main_program> OK
##I TFPM 000185 01:44:27(012) <main_program> PNBDWH01 -
##I TFPM 000187 01:44:27(013) <main_program> rsh issued, no response received
>##E TFPM 000247 01:44:27(014) <main_program> Unable to contact one or more Section Leaders.
>Probable configuration problem; contact Orchestrate system administrator.
>
>##E TFSR 000011 01:44:27(015) <main_program> Step execution finished with status = FAILED.
>
##I TFCN 000001 01:43:57(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.2
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TUTL 000031 01:43:57(001) <main_program> The open files limit is 2000; raising to 2147483647.
##I TOSH 000002 01:43:57(002) <main_program> orchgeneral: loaded
##I TOSH 000002 01:43:57(003) <main_program> orchsort: loaded
##I TOSH 000002 01:43:57(004) <main_program> orchstats: loaded
##I TFSC 000001 01:43:57(005) <main_program> APT configuration file: /home1/dsadm/Ascential/DataStage/Configurations/default.apt
ksh: /home1/dsadm/Ascential/DataStage/PXEngine/etc/standalone.sh: not found.
##W TFPM 000152 01:44:27(000) <main_program> Accept timed out retries = 12
>##E TFPM 000153 01:44:27(001) <main_program> The section leader on PNBDWH01 died
>##E TFPM 000356 01:44:27(002) <main_program>
>
>**** Parallel startup failed ****
>
>This is usually due to a configuration error, such as
>not having the Orchestrate install directory properly
>mounted on all nodes, rsh permissions not correctly
>set (via /etc/hosts.equiv or .rhosts), or running from
>a directory that is not mounted on all nodes. Look for
>error messages in the preceding output.
>
>
##I TFPM 000177 01:44:27(003) <main_program> Step started on node PNBDWH04; it uses 3 nodes.
The program running the step is /home1/dsadm/Ascential/DataStage/PXEngine/bin/osh.
##I TFPM 000178 01:44:27(004) <main_program> The ORCHESTRATE startup program in /home1/dsadm/Ascential/DataStage/PXEngine/etc/standalone.sh is being used.
##I TFPM 000181 01:44:27(005) <main_program> A startup script is not being used.
##I TFPM 000183 01:44:27(006) <main_program> The TCP port being used for startup is 10,002; the associated socket number is 5.
##I TFPM 000184 01:44:27(007) <main_program>
Node status:
##I TFPM 000185 01:44:27(008) <main_program> PNBDWH04 -
##I TFPM 000186 01:44:27(009) <main_program> OK
##I TFPM 000185 01:44:27(010) <main_program> PNBDWH04 -
##I TFPM 000186 01:44:27(011) <main_program> OK
##I TFPM 000185 01:44:27(012) <main_program> PNBDWH01 -
##I TFPM 000187 01:44:27(013) <main_program> rsh issued, no response received
>##E TFPM 000247 01:44:27(014) <main_program> Unable to contact one or more Section Leaders.
>Probable configuration problem; contact Orchestrate system administrator.
>
>##E TFSR 000011 01:44:27(015) <main_program> Step execution finished with status = FAILED.
>