To run SQL statements, utilities, and commands, or to browse and
access files on remote servers from the IBM Data Studio client, you must ensure that the DB2® Administration Server (DAS) or Secure Shell (SSH) protocol and
Secure File Transfer (SFTP) protocol are properly configured.
Depending on the operating system of the target server on which you want to run commands or
utilities, the IBM Data Studio client uses the
DAS or the SSH protocol.
The following table shows which protocol the IBM Data Studio client uses.
Table 1. Protocol that is used to run commands and utilities on remote serversOperating system |
Method for remote commands and utilities |
Windows |
For connecting to a local database on Windows, SSH is used. For connecting to remote databases, SSH is first attempted. If the SSH
is unavailable, DAS is attempted.
|
Linux or UNIX |
SSH is used. |
- Browsing and accessing remote file systems
- The SFTP protocol is always used when you browse and access remote
file systems.
- For Windows operating
systems:
- The drives and associated file systems paths for the supported OpenSSH service implementation
from Cygwin are in the default directory cygdrive. No other Cygwin directory
paths to the file system are valid when you use the IBM Data Studio client to run commands.
- The IBM Secure Shell Server
for Windows is supported
by DB2 Server products Version
10.1 fix pack 3 and later, and by DB2 Server
products Version 10.5 and later.
Requirements for DAS or SSH and SFTP on the computer where you installed the IBM Data Studio client
- DB2 Administration Server
(DAS)
- The IBM Data Server Client is required to communicate with
the DB2 Administration Server (DAS).
The connectivity
libraries that are required for remote operations can be provided by installing either of the
following products:
- A local DB2 database server instance
- IBM Data Server Client
You must install IBM Data Server Client at
the same bit version as the IBM Data Studio client. For example, if you install a 64-bit version of the IBM Data Studio client, then you must install a
64-bit version of IBM Data Server Client.
- Secure Shell (SSH) and Secure File Transfer (SFTP) protocols
- To use the SSH and SFTP protocols, no additional configuration is required on the client because
the IBM Data Studio client is pre-configured
with an SSH and SFTP client.
Requirements for DAS, SSH, and SFTP on the remote
server
- DB2 Administration Server
(DAS)
- To use DAS on a Windows system,
the DB2 Administration Server
(DAS) must be started, and port 523 must be open.
- Secure Shell (SSH) and Secure File Transfer (SFTP) protocols
- 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
must be open. SSH requires that a port is open for communication. Depending on your configuration,
this can be either the default port 22 or a port that you configured when you installed IBM Data
Studio.
Important: If you specify a port number other than the default port 22, you must
update the Port value in the sshd_config file, and then
restart the IBM SSH Server for Windows. The file is typically in the
C:\ProgramData\IBM\ibmssh\etc\ssh\sshd_config directory on the database
server.
To use the SSH and SFTP protocols on a Windows system, an OpenSSH environment must be set up. The IBM Data Studio client 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 IBM Data Studio client 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 login to the remote Windows system. You can download and install Cygwin from http://cygwin.com.