HANA - Client
Table of Contents
About
The client software package contains the following client:
- SQLDBC,
- ODBO,
- Python DB API
- and JDBC.
There is also native connection in:
Articles Related
Console
- hdbcons - SAP HANA DB Management Client 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
- Install. See Command and call option
./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