To run SQL statements, utilities, and commands, or to browse
and access files on remote servers from IBM® Data Studio, 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,
IBM Data Studio uses
the DAS or the SSH protocol. The following table shows which protocol
IBM Data Studio uses.
Table 1. Protocol that is used to run commands and utilities on remote
servers| Operating 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 IBM Data Studio 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 IBM Data Studio
- 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 IBM Data Studio. For
example, if you install a 64-bit version of IBM Data Studio, 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. IBM Data Studio 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. IBM Data Studio 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). IBM Data Studio 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.