Verifying Connectivity to DB2 UDB

Verify the connection to the replicate DB2 UDB database.

1. Open a command window in the %SYBASE% (Windows) or $SYBASE (UNIX or Linux) directory of your ECDA installation.
2. Change to the %SYBASE%\DC-15_0 (Windows) or $SYBASE/DC-15_0 (UNIX or Linux) directory.
3. Set the environment variables by running the %SYBASE%\DC_SYBASE.bat file (Windows) or by sourcing the $SYBASE/DC_SYBASE.csh file (UNIX or Linux).
4. Log in to the replicate database through the DirectConnect service:

   isql –Uvaliduser –Ppassword –SDCService

   where validuser and password are any valid user and password, and DCService is the DirectConnect service name.

5. Verify the connection to the replicate database:
   

   select @@sqldbmsname
   go
   SQLDbmsName
   ---------------------
   DB2/SUN
   
   select @@sqldbmsver
   go
   SQLDbmsVer
   ---------------------
   09.01.0005

6. Exit the isql session with the quit command.