Page 1 of 1
db2: view date error
Posted: Wed Apr 15, 2009 7:14 pm
by jakey2415
Database: DB2 9.4
Datastage Server: Ascential 7.5.2 hp_ux
Datastage client: on windows XP
Connectivity: DB2 connect
db2 stage view data:
Error executing View Data command:
##E TNDB 000227 10:39:42(000) <DBA_b_scard> The getpwnam() function failed for the DB2INSTANCE environment variable
Posted: Mon Mar 22, 2010 7:34 pm
by Sreedhar
I have the same problem.
did any one of you found the solution for this?
Job Description. accessing the DB2 which is on a remote server.
The getpwnam() function failed for the DB2INSTANCE environment variable
value of `hq-exxxxxx-x' due to Unix error `No such process'; this most probably means that `hq-exxxxxx-x'
is not a valid login name on the current machine and hence getpwnam() cannot
be used to find the home directory of the db2instance; setting the environment
variable APT_DB2INSTANCE_HOME to point to the appropriate db2instance home
directory should solve the problem.
Regards,
Posted: Mon Mar 22, 2010 9:28 pm
by ray.wurlod
Is the host name to IP address mapping available (can you ping the hostname)? If not, make it available in the hosts file.
Posted: Mon Mar 22, 2010 11:05 pm
by Sreedhar
Yes I can ping the Host from my UNIX box.
Posted: Tue Mar 23, 2010 4:05 pm
by Sreedhar
Hi
To that matter I am also able to import the metadata from the data Base.
Regards,
Posted: Fri Mar 26, 2010 4:07 pm
by Sreedhar
Now once I have set up the rsh between the two servers I am getting the following error
">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 am able to successfully test the rsh between the Db2 server and ETL Server (Where Data Stage is installed.)