• 1 reply
  • Latest Post - ‏2006-01-06T01:20:39Z by SystemAdmin
332 Posts

Pinned topic Problem with DB2 lookup

‏2006-01-05T15:06:37Z |

Iam working on Datastage 7.5.1.A and my database is DB2 7.1. I have server jobs and I want some jobs to design in Parallel
My Ascential and Database are on different servers. When Iam doing lookup with db2 it is asking for dbinstance name. I gave instance name in db2/udb enterprise stage --- output page --- properties ---- connection/server. But it gives an error
Error Executing View data command:

EE TNDB 00027 12:40:16(000) <DB2_UDB_ Enterprise_1> The getpwnam() function failed for the DB2INSTANCE environment variable.
How to Set this DB2INSTANCE environment Variable. Do I need to give DB2 installation home directory (APT_DB2INSTANCE_HOME) in administrator which is in different server .

Updated on 2006-01-06T01:20:39Z at 2006-01-06T01:20:39Z by SystemAdmin
  • SystemAdmin
    332 Posts

    Re: Problem with DB2 lookup

    Assuming you're on a UNIX platform, the best place to set DB2INSTANCE is in the $DSHOME/dsenv script.