db2: view date error

jakey2415 · Post by **jakey2415** » Wed Apr 15, 2009 7:14 pm

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

Sreedhar · Post by **Sreedhar** » Mon Mar 22, 2010 7:34 pm

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,

ray.wurlod · Post by **ray.wurlod** » Mon Mar 22, 2010 9:28 pm

Is the host name to IP address mapping available (can you ping the hostname)? If not, make it available in the hosts file.

Sreedhar · Post by **Sreedhar** » Mon Mar 22, 2010 11:05 pm

Yes I can ping the Host from my UNIX box.

Sreedhar · Post by **Sreedhar** » Tue Mar 23, 2010 4:05 pm

Hi

To that matter I am also able to import the metadata from the data Base.

Regards,

Sreedhar · Post by **Sreedhar** » Fri Mar 26, 2010 4:07 pm

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