SAP HANA Notes

Change System User's Password

ALTER DATABASE <DB> SYSTEM USER PASSWORD <new password>

Log Into HANA Database

hdbsql -i <instance> -n <server> -d <DB> -u <user> -p <password>

Use wildcard in select statement

select * from "schema"."table" where "field" like '%value%'

List Tenants in HANA Database

select * from "sys"."m_databases"

List HANA User

hdbuserstore list

DATA FILE       : /home/<sid>adm/.hdb/<server>/SSFS_HDB.DAT
KEY FILE        : /home/<sid>adm/.hdb/<server>/SSFS_HDB.KEY

KEY DEFAULT
  ENV : <server>:<port>
  USER: <user>
  DATABASE: <db>

Update HANA User Store

hdbuserstore SET DEFAULT "<server>:<port>@<db>" <user> <password>

SAP Help Pages

http://help.sap.com/hana_platform

SAP HANA Studio

http://help.sap.com/saphelp_hanaplatform/helpdata/en/c8/aa369bbb57101497c4e0f9c1028266/frameset.htm

HANA SQL Reference

help.sap.com/hana/SAP_HANA_SQL_Script_Reference_en.pdf

Free HANA Trial Database

hanatrial.ondemand.com

The SAP HANA Reference for SAP Basis Administrators

http://scn.sap.com/community/hana-in-memory/blog/2013/05/27/andy-silvey--sap-hana-command-line-tools-and-sql-reference-examples-for-netweaver-basis-administrators

Find Text Code for Icon in SAP

To display all the available standard icons

1. Transaction ICON
2. Note the icon's name (e.g. ICON_POSITIVE)

To find the allocated 2-character code for the icon

1. Transaction SE11
2. Choose Type Group and enter ICON
3. Click Display
4. Search for the text code (e.g. ICON_POSITIVE)
5. Code is @04

Unicode conversion notes

SAP SCN Pages
http://scn.sap.com/docs/DOC-8616

Transaction
SPUMG - Unicode Preconversion

1051576 - Conversion of Single Code Page Systems to Unicode

1096903 - Tutorial: "Table splitting in SPUMG or SPUM4"

551344 - Unicode Conversion Documentation

1319517 - Unicode Collection Note

765475 - Unicode Conversion: Troubleshooting

Browse roles and users without PFCG access

Browse table AGR_1251 to see roles in the system
Browse table AGR_USERS to see users assigned to roles

R3load, export and migration notes

R3load

455195 - R3load: Use of TSK files
1970577 - (TSK) ERROR //.TSK.bck already seems to exist

Approve Download Basket Without Solution Manager

Add items to download basked on SAP net.
Login to Solution Manager system
Run SE37
Enter: /TMWFLOW/MO_UI_BASKET_AUTHORIZ
Press F8
Leave the default values
Press Execute
Select the items in the basket to approve
Click Confirm Download

Items can now be downloaded directly from the download basket on SAP's website

Clean memory on Unix and Linux

Assuming the SAP system is shut down!

To list semaphores and event flags
cleanipc

To remove leftover semaphores and event flags
cleanipc remove


To list shared memory
ipcs -m

To remove entry
ipcrm -M or
ipcrm -m


To list semaphores
ipcs -s

To remove semaphore entry
ipcs - S or
ipcs -s

Details from:
http://www.ibm.com/support/knowledgecenter/ssw_aix_53/com.ibm.aix.cmds/doc/aixcmds3/ipcs.htm
http://www.ibm.com/support/knowledgecenter/ssw_aix_53/com.ibm.aix.cmds/doc/aixcmds3/ipcrm.htm