Verifying that you can Connect to IBM DB2 Universal Database

Verify the connection to the replicate IBM DB2 Universal Database.

1. Open a command window in the $SYBASE (UNIX or Linux) or %SYBASE% (Windows) directory of your ECDA installation.
2. Change to the $SYBASE/DC-15_0 (UNIX or Linux) or %SYBASE%\DC-15_0 (Windows) directory.
3. Set the environment variables by sourcing the $SYBASE/DC_SYBASE.csh file (UNIX or Linux) or by running the %SYBASE%\DC_SYBASE.bat file (Windows).
4. Log in to the IBM DB2 Universal 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 IBM DB2 Universal Database:

   select @@sqldbmsname

   go

   SQLDbmsName

   ---------------------

   DB2/SUN

   select @@sqldbmsver

   go

   SQLDbmsVer

   ---------------------

   09.01.0005

6. Exit the isql session with the quit command.