Operating system | Method for remote commands and utilities |
---|---|
Windows | When connecting to a local database on Windows, DAS is used. When
connecting to remote databases, SSH is first attempted. If SSH is
unavailable or is not set up properly, then DAS is attempted, with
these exceptions:
|
Linux or UNIX | SSH is used. |
When you browse and access remote file systems, the SFTP protocol is always used. When you browse for files remotely on a Windows system from within the workbench product, you must look in the default directory (/cygdrive/c) to find the Windows drives and the associated file systems paths. No other Windows file system directory paths are valid when you use the workbench product to run commands.
To use DAS, a connection to a locally installed DB2 database or connection to a DB2 UDB Administration Client (DAC) is required. If you do not have a locally installed DB2 database, DAC is required to communicate with the IBM® Data Server Client and the DB2 Administration Server (DAS).
In either case, make sure the bin directory is in the path before you start the workbench. (In Linux, this is handled by sourcing $INST_HOME/sqllib/db2profile.) The DB2 UDB Administration Client is available from developerWorks® at http://www.ibm.com/developerworks.
To use the SSH and SFTP protocols, no additional configuration is required on the client. The workbench product comes pre-configured with an SSH and SFTP client.
To use DAS on a Windows system, the DB2 Administration Server (DAS) must be started, and port 523 must be open.
To use the SSH and SFTP protocols on Linux or UNIX system, the SSH and SFTP daemons must be started. If they are not running, start them or ask your system administrator to start them. SSH requires that port 22 be open.
To use the SSH and SFTP protocols on a Windows system, an OpenSSH environment must be set up. The workbench supports SSH communication to DB2 for Linux, UNIX, and Windows servers that run in a Cygwin emulation environment through Portable Operating System Interface for UNIX (POSIX). In its Open Source distribution, the Cygwin environment includes the OpenSSH server implementation of the SSH and SFTP protocol (Cygwin Net packages openssl, openssh). The workbench uses the Secure File Transfer protocol (SFTP) for all file system browsing and remote file transfer. Therefore, SFTP must be enabled.
Setting up the OpenSSH environment on a target server that runs on a Windows system requires installing Cygwin, configuring the daemon to run as an automatic service, and synchronizing the Cygwin environment user accounts and groups with the Operating System user repository to allow remote log in to the remote Windows system. You can download and install Cygwin from http://cygwin.com. For information about installing and configuring Cygwin on a Windows server, see Installing Cygwin on a Windows server and Configuring Cygwin on a Windows server.