error encountered while connecting to db2 database from ds

[arvind_ds]

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.
>

[ray.wurlod]

The error message is
/home1/dsadm/Ascential/DataStage/PXEngine/etc/standalone.sh: not found.

Please verify that this file exists and is executable.

[arvind_ds]

Ray,

I have double checked the /home1/dsadm/Ascential/DataStage/PXEngine/etc/standalone.sh file and it exists and is executable.

Thanks

[crystal_pup]

Hi Arvind,

I guess ur account doesnot have the rights /access to 'rsh' to the 'PNBDWH01' server.Please try the following command at your command prompt --> rsh PNBDWH01

If you are able to connect to the server then the error could be because of some other reasons.However if you are unable to rsh the server then in that case you can ask administrator to set up access for you.

Hope this helps.

Regards,
Kunal

[Sourav]

The error message is
/home1/dsadm/Ascential/DataStage/PXEngine/etc/standalone.sh: not found.

Please verify that this file exists and is executable. ...

Hi Friend ,

As far your concerned , I will suggest you that kindly cross check the Database Installation Directory and verify and executed DB node with particular filesystems have to be marked .

Thanks