HANA - Client

About

The client software package contains the following client:

  • SQLDBC,
  • ODBO,
  • Python DB API
  • and JDBC.

There is also native connection in:

Console

Monitoring

For SQL statement, see 1969700

Monitoring view Column / Key Description
M_ACTIVE_STATEMENTS
M_PREPARED_STATEMENTS
APPLICATION_SOURCE Application source (e.g. ABAP report)
M_CONNECTIONS CLIENT_DISTRIBUTION_MODE
CLIENT_HOST
CLIENT_IP
CLIENT_PID
Client distribution mode
Client host name
Client IP address
Client process ID
M_EXECUTED_STATEMENTS
M_EXPENSIVE_STATEMENTS
APPLICATION_NAME
APPLICATION_SOURCE
APP_USER
Application name
Application source (e.g. ABAP report)
Application user
M_SERVICE_THREADS CLIENT_IP
CLIENT_PID
Client IP address
Client process ID
M_SERVICE_THREAD_SAMPLES
HOST_SERVICE_THREAD_SAMPLES
CLIENT_IP
CLIENT_PID
Client IP address
Client process ID
M_SESSION_CONTEXT APPLICATION
APPLICATIONUSER
APPLICATIONVERSION
APPLICATIONSOURCE
Application identifier (e.g. “ABAP:<sid>” for ABAP clients)
Application user
Application version
Application source (e.g. report name for ABAP clients)
M_SQL_CLIENT_NETWORK_IO CLIENT_DURATION
CLIENT_HOST
Duration of database request from client perspective
Client host name

Installation

Example for Linux:

  • Go to the download center: https://support.sap.com/swdc
  • Get the files: the client. Go to SUPPORT PACKAGES AND PATCHES > H > SAP HANA PLATFORM EDITION > choose your edition > Hana Client

  • Get the files: sapcar. Go to SUPPORT PACKAGES AND PATCHES > S > SAP Car. Even if it's shown with an exe extension, it's a linux binary.

  • Get the archiver tool of SAP (SapCar) and rename it to sapcar
mv SAPCAR_816-80000935.EXE sapcar
  • Unarchive the client
sapcar -xvf IMDB_CLIENT100_120_63-10009663.SAR
SAPCAR: processing archive IMDB_CLIENT100_120_63-10009663.SAR (version 2.01)
x SAP_HANA_CLIENT
x SAP_HANA_CLIENT/filelist.clientinst
x SAP_HANA_CLIENT/hdbsetup
x SAP_HANA_CLIENT/client
x SAP_HANA_CLIENT/client/JDBC.TGZ
x SAP_HANA_CLIENT/client/SAPSYSMF.TGZ
x SAP_HANA_CLIENT/client/InstallParams.xml
x SAP_HANA_CLIENT/client/PYTHON.TGZ
x SAP_HANA_CLIENT/client/SQLDBC.TGZ
x SAP_HANA_CLIENT/client/HALMCLI.TGZ
x SAP_HANA_CLIENT/client/installcfg.dtd
x SAP_HANA_CLIENT/client/manifest
x SAP_HANA_CLIENT/client/REPOTOOLS.TGZ
x SAP_HANA_CLIENT/client/ODBC.TGZ
x SAP_HANA_CLIENT/client/PYDBAPI.TGZ
x SAP_HANA_CLIENT/client/CLIENTINST.TGZ
x SAP_HANA_CLIENT/LABEL.ASC
x SAP_HANA_CLIENT/hdbclientreg
x SAP_HANA_CLIENT/instruntime
x SAP_HANA_CLIENT/instruntime/Cwd.so
x SAP_HANA_CLIENT/instruntime/FCGI.so
x SAP_HANA_CLIENT/instruntime/lcm_pm_ext.tgz
x SAP_HANA_CLIENT/instruntime/Wx.so
x SAP_HANA_CLIENT/instruntime/version.pm
x SAP_HANA_CLIENT/instruntime/sdbrun
x SAP_HANA_CLIENT/instruntime/Carp.pm
x SAP_HANA_CLIENT/instruntime/libperl.so
x SAP_HANA_CLIENT/instruntime/SSLeay.so
x SAP_HANA_CLIENT/instruntime/libxml2.so
x SAP_HANA_CLIENT/instruntime/Getopt
x SAP_HANA_CLIENT/instruntime/Getopt/Long.pm
x SAP_HANA_CLIENT/instruntime/lcm_res.tgz
x SAP_HANA_CLIENT/instruntime/Socket.so
x SAP_HANA_CLIENT/instruntime/Encode.so
x SAP_HANA_CLIENT/instruntime/Dumper.so
x SAP_HANA_CLIENT/instruntime/version
x SAP_HANA_CLIENT/instruntime/version/regex.pm
x SAP_HANA_CLIENT/instruntime/constant.pm
x SAP_HANA_CLIENT/instruntime/IO.so
x SAP_HANA_CLIENT/instruntime/SSH2.so
x SAP_HANA_CLIENT/instruntime/strict.pm
x SAP_HANA_CLIENT/instruntime/SQLDBC.so
x SAP_HANA_CLIENT/instruntime/Grid.so
x SAP_HANA_CLIENT/instruntime/overloading.pm
x SAP_HANA_CLIENT/instruntime/Exporter.pm
x SAP_HANA_CLIENT/instruntime/warnings
x SAP_HANA_CLIENT/instruntime/warnings/register.pm
x SAP_HANA_CLIENT/instruntime/libwx_gtk2u-3.0.so.0
x SAP_HANA_CLIENT/instruntime/DND.so
x SAP_HANA_CLIENT/instruntime/LibXML.so
x SAP_HANA_CLIENT/instruntime/Exporter
x SAP_HANA_CLIENT/instruntime/Exporter/Heavy.pm
x SAP_HANA_CLIENT/instruntime/HiRes.so
x SAP_HANA_CLIENT/instruntime/vars.pm
x SAP_HANA_CLIENT/instruntime/Base64.so
x SAP_HANA_CLIENT/instruntime/overload.pm
x SAP_HANA_CLIENT/instruntime/lcm_pm.tgz
x SAP_HANA_CLIENT/instruntime/ssl10
x SAP_HANA_CLIENT/instruntime/ssl10/SSLeay.so
x SAP_HANA_CLIENT/instruntime/ssl10/SSH2.so
x SAP_HANA_CLIENT/instruntime/warnings.pm
x SAP_HANA_CLIENT/hdbuninst
x SAP_HANA_CLIENT/hdbinst
SAPCAR: 63 file(s) extracted
./hdbinst [-a client] [<option list>]

Example:

./hdbinst  --path=/u01/app/sap/hdbclient
SAP HANA Database Client installation kit detected.
SAP HANA Lifecycle Management - Client Installation 1.00.112.07.1477423516
**************************************************************************
Checking installation...
Preparing package 'Product Manifest'...
Preparing package 'SQLDBC'...
Preparing package 'ODBC'...
Preparing package 'JDBC'...
Preparing package 'Client Installer'...
Installing SAP HANA Database Client to /u01/app/sap/hdbclient...
Installing package 'Product Manifest'...
Installing package 'SQLDBC'...
Installing package 'ODBC'...
Installing package 'JDBC'...
Installing package 'Client Installer'...
Installation done
Log file written to '/var/tmp/hdb_client_2017-06-08_17.37.32_20262/hdbinst_client.log' on host 'hostname'.
  • Log: The SAP HANA client installation is logged by the system. There are two log files written during installation stored at /var/tmp/hdb_client_<timestamp>
*.log: can be read using a text editor
*.msg: XML format for the display in the installation tool with the graphical user interface

Documentation / Reference


Powered by ComboStrap