SAP HANA Database – Administration Guide (sps04)
正在加载中...
资料简介:
Contents
Introduction........................................................................................................................................5
SAP HANA and SAP HANA Database Guides ....................................................................................5
What is the SAP HANA Database? ...................................................................................................5
About the SAP HANA Studio ............................................................................................................7
Updating the SAP HANA Studio .......................................................................................................7
SAP HANA Studio Screen Areas .......................................................................................................7
Starting the Administration Console of the SAP HANA Studio ........................................................ 10
Managing Multiple SAP HANA Systems ............................................................................................. 10
Adding Systems ............................................................................................................................. 10
Creating Folder Structures ............................................................................................................ 11
Exporting Systems ......................................................................................................................... 11
Importing Systems ........................................................................................................................ 12
Finding Systems ............................................................................................................................ 12
Monitoring SAP HANA Systems with the System Monitor .............................................................. 12
Starting and Stopping Systems .......................................................................................................... 14
Starting a System .......................................................................................................................... 14
Stopping a System ......................................................................................................................... 14
Monitoring During System Startup and Stop ................................................................................. 15
Managing Licenses ............................................................................................................................ 15
Temporary License Keys ................................................................................................................ 15
Permanent License Keys ................................................................................................................ 15
Checking the Current License Key .................................................................................................. 16
Installing Permanent Licenses ....................................................................................................... 17
Deleting Existing Permanent License Keys ..................................................................................... 17
License Auditing ............................................................................................................................ 18
Managing Users ................................................................................................................................ 19
Database Users ............................................................................................................................. 19
Operating System User ................................................................................................................. 19
Authentication .............................................................................................................................. 19
Authorization ................................................................................................................................ 20
Privileges for Adminstration Tasks ................................................................................................. 20
Provisioning Users ......................................................................................................................... 21
SAP HANA Database – Administration Guide 4
Disabling Default User Filtering of Schemas ................................................................................... 23
Monitoring ....................................................................................................................................... 25
Monitoring Overall System State ................................................................................................... 25
Monitoring System Components ................................................................................................... 26
Monitoring Alerts .......................................................................................................................... 28
Monitoring Disk Space .................................................................................................................. 29
Monitoring Performance ............................................................................................................... 31
Monitoring Memory Usage ........................................................................................................... 32
Configuration .................................................................................................................................... 37
Changing Parameter Values .......................................................................................................... 37
Resetting Parameter Values .......................................................................................................... 37
Setting the Global Allocation Limit Parameter ............................................................................... 37
Changing the Default SLD Data Supplier Configuration .................................................................. 38
Configuring Alerts ......................................................................................................................... 40
Failover Concept ........................................................................................................................... 41
Customizing the Administration Console ....................................................................................... 43
Periodic Administration Tasks ........................................................................................................... 46
Backing Up Systems ...................................................................................................................... 46
Managing Tables ........................................................................................................................... 46
Troubleshooting ............................................................................................................................... 51
The SQL Editor .............................................................................................................................. 51
Resolving a Disk Full Event ............................................................................................................ 54
Diagnosis Files ............................................................................................................................... 55
Configuring Traces ........................................................................................................................ 55
Opening a Support Connection ..................................................................................................... 58
Collecting System Information for Support .................................................................................... 59
Displaying System Information ...................................................................................................... 62
Appendix A ....................................................................................................................................... 63
SAP HANA HDBSQL ....................................................................................................................... 63
Introduction........................................................................................................................................5
SAP HANA and SAP HANA Database Guides ....................................................................................5
What is the SAP HANA Database? ...................................................................................................5
About the SAP HANA Studio ............................................................................................................7
Updating the SAP HANA Studio .......................................................................................................7
SAP HANA Studio Screen Areas .......................................................................................................7
Starting the Administration Console of the SAP HANA Studio ........................................................ 10
Managing Multiple SAP HANA Systems ............................................................................................. 10
Adding Systems ............................................................................................................................. 10
Creating Folder Structures ............................................................................................................ 11
Exporting Systems ......................................................................................................................... 11
Importing Systems ........................................................................................................................ 12
Finding Systems ............................................................................................................................ 12
Monitoring SAP HANA Systems with the System Monitor .............................................................. 12
Starting and Stopping Systems .......................................................................................................... 14
Starting a System .......................................................................................................................... 14
Stopping a System ......................................................................................................................... 14
Monitoring During System Startup and Stop ................................................................................. 15
Managing Licenses ............................................................................................................................ 15
Temporary License Keys ................................................................................................................ 15
Permanent License Keys ................................................................................................................ 15
Checking the Current License Key .................................................................................................. 16
Installing Permanent Licenses ....................................................................................................... 17
Deleting Existing Permanent License Keys ..................................................................................... 17
License Auditing ............................................................................................................................ 18
Managing Users ................................................................................................................................ 19
Database Users ............................................................................................................................. 19
Operating System User ................................................................................................................. 19
Authentication .............................................................................................................................. 19
Authorization ................................................................................................................................ 20
Privileges for Adminstration Tasks ................................................................................................. 20
Provisioning Users ......................................................................................................................... 21
SAP HANA Database – Administration Guide 4
Disabling Default User Filtering of Schemas ................................................................................... 23
Monitoring ....................................................................................................................................... 25
Monitoring Overall System State ................................................................................................... 25
Monitoring System Components ................................................................................................... 26
Monitoring Alerts .......................................................................................................................... 28
Monitoring Disk Space .................................................................................................................. 29
Monitoring Performance ............................................................................................................... 31
Monitoring Memory Usage ........................................................................................................... 32
Configuration .................................................................................................................................... 37
Changing Parameter Values .......................................................................................................... 37
Resetting Parameter Values .......................................................................................................... 37
Setting the Global Allocation Limit Parameter ............................................................................... 37
Changing the Default SLD Data Supplier Configuration .................................................................. 38
Configuring Alerts ......................................................................................................................... 40
Failover Concept ........................................................................................................................... 41
Customizing the Administration Console ....................................................................................... 43
Periodic Administration Tasks ........................................................................................................... 46
Backing Up Systems ...................................................................................................................... 46
Managing Tables ........................................................................................................................... 46
Troubleshooting ............................................................................................................................... 51
The SQL Editor .............................................................................................................................. 51
Resolving a Disk Full Event ............................................................................................................ 54
Diagnosis Files ............................................................................................................................... 55
Configuring Traces ........................................................................................................................ 55
Opening a Support Connection ..................................................................................................... 58
Collecting System Information for Support .................................................................................... 59
Displaying System Information ...................................................................................................... 62
Appendix A ....................................................................................................................................... 63
SAP HANA HDBSQL ....................................................................................................................... 63
2013-08-15
浏览1447
下载15