SAP HANA - Versionsgeschichte

Hendrik am 5. Mai 2026 um 10:48 Uhr

2026-05-05T10:48:50Z

← Nächstältere Version		Version vom 5. Mai 2026, 12:48 Uhr
Zeile 174:		Zeile 174:
	</syntaxhighlight>		</syntaxhighlight>

			=== Backup abbrechen ===
			<syntaxhighlight lang="sql">
			BACKUP CANCEL FOR <SYSTEMDB/TENANT> <ID>
			</syntaxhighlight>
	===Störungen===		===Störungen===
			==== * 447: backup could not be completed: [110164] Encryption root keys backup password doesn't exist. It must be either set in the database or must be given with the backup/recover SQL statement SQLSTATE: HY000 ====
			Die Datenbank wurde mit aktivierten Encryption root keys backup password installiert, aber sind noch nicht in der Datenbank gesetzt. Dazu auf der SYSTEMDB und TENANT ausführen:
			<syntaxhighlight lang="sql">
			ALTER SYSTEM SET ENCRYPTION ROOT KEYS BACKUP PASSWORD "<PW>";
			</syntaxhighlight>
	====Tabelle BALDAT====		====Tabelle BALDAT====
	in der SLG2 je Mandant alles löschen und den Job SBAL_DELETE einplanen		in der SLG2 je Mandant alles löschen und den Job SBAL_DELETE einplanen

Hendrik: /* SAP HANA Update */

2026-03-31T16:22:35Z

SAP HANA Update

← Nächstältere Version		Version vom 31. März 2026, 18:22 Uhr
Zeile 27:		Zeile 27:
	chmod +x SAPCAR && ./SAPCAR -xvf IMDB_CLIENT*		chmod +x SAPCAR && ./SAPCAR -xvf IMDB_CLIENT*
	chmod +x SAPCAR && ./SAPCAR -xvf IMDB_SERVER*		chmod +x SAPCAR && ./SAPCAR -xvf IMDB_SERVER*
	cd /hana/shared/*/hdblcm		cd /hana/shared/*/hdblcm && ./hdblcm --action=update --ignore=check_signature_file --verify_signature=off --lss_trust_unsigned_components
	./hdblcm --action=update --ignore=check_signature_file --verify_signature=off --lss_trust_unsigned_components
	Enter directory root to search for components: /usr/sap/SUM/		Enter directory root to search for components: /usr/sap/SUM/
	</syntaxhighlight>		</syntaxhighlight>

Hendrik: /* Passwort Hash eines einzelnen Users kopieren */

2026-02-19T13:17:42Z

Passwort Hash eines einzelnen Users kopieren

← Nächstältere Version		Version vom 19. Februar 2026, 15:17 Uhr
Zeile 142:		Zeile 142:
	UPDATE SAPABAP1.USR02		UPDATE SAPABAP1.USR02
	SET		SET
	BCODE = (SELECT BCODE FROM SAPABAP1.USR02 WHERE MANDT = '000' AND BNAME = '~~BTC-SUPPORT~~'),		BCODE = (SELECT BCODE FROM SAPABAP1.USR02 WHERE MANDT = '000' AND BNAME = '<NAME>'),
	PASSCODE = (SELECT PASSCODE FROM SAPABAP1.USR02 WHERE MANDT = '000' AND BNAME = '~~BTC-SUPPORT~~'),		PASSCODE = (SELECT PASSCODE FROM SAPABAP1.USR02 WHERE MANDT = '000' AND BNAME = '<NAME>'),
	PWDSALTEDHASH = (SELECT PWDSALTEDHASH FROM SAPABAP1.USR02 WHERE MANDT = '000' AND BNAME = '~~BTC-SUPPORT~~'),		PWDSALTEDHASH = (SELECT PWDSALTEDHASH FROM SAPABAP1.USR02 WHERE MANDT = '000' AND BNAME = '<NAME>'),
	CODVN = (SELECT CODVN FROM SAPABAP1.USR02 WHERE MANDT = '000' AND BNAME = '~~BTC-SUPPORT~~'),		CODVN = (SELECT CODVN FROM SAPABAP1.USR02 WHERE MANDT = '000' AND BNAME = '<NAME>'),
	PWDINITIAL = 0,		PWDINITIAL = 0,
	UFLAG = 0,		UFLAG = 0,
	GLTGB = '99991231'		GLTGB = '99991231'
	WHERE MANDT = '321'		WHERE MANDT = '321'
	AND BNAME = '~~BTC-SUPPORT~~';		AND BNAME = '<NAME>';
	COMMIT;		COMMIT;

Hendrik: /* Passwort Hash eines einzelnen Users kopieren */

2026-02-19T13:17:17Z

Passwort Hash eines einzelnen Users kopieren

← Nächstältere Version		Version vom 19. Februar 2026, 15:17 Uhr
Zeile 141:		Zeile 141:
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	UPDATE SAPABAP1.USR02		UPDATE SAPABAP1.USR02
	SET ~~PWDSALTEDHASH~~ = (SELECT ~~PWDSALTEDHASH~~ FROM SAPABAP1.USR02 WHERE MANDT = '~~330~~' AND BNAME = '~~NAME~~'),		SET
	PASSCODE = (SELECT PASSCODE FROM SAPABAP1.USR02 WHERE MANDT = '~~330~~' AND BNAME = '~~NAME~~')		BCODE = (SELECT BCODE FROM SAPABAP1.USR02 WHERE MANDT = '000' AND BNAME = 'BTC-SUPPORT'),
	WHERE MANDT = '~~331~~'		PASSCODE = (SELECT PASSCODE FROM SAPABAP1.USR02 WHERE MANDT = '000' AND BNAME = 'BTC-SUPPORT'),
	AND BNAME = '~~NAME~~';		PWDSALTEDHASH = (SELECT PWDSALTEDHASH FROM SAPABAP1.USR02 WHERE MANDT = '000' AND BNAME = 'BTC-SUPPORT'),
			CODVN = (SELECT CODVN FROM SAPABAP1.USR02 WHERE MANDT = '000' AND BNAME = 'BTC-SUPPORT'),
			PWDINITIAL = 0,
			UFLAG = 0,
			GLTGB = '99991231'
			WHERE MANDT = '321'
			AND BNAME = 'BTC-SUPPORT';
	COMMIT;		COMMIT;


	</syntaxhighlight>		</syntaxhighlight>

Hendrik am 12. Februar 2026 um 21:49 Uhr

2026-02-12T21:49:20Z

@@ Zeile 136: / Zeile 136: @@
 <syntaxhighlight lang="sql">
 hdbsql -n localhost:30013 -d <SID>-u SAPABAP1 -p '<PW>' "DELETE FROM SAPABAP1.USR02 WHERE MANDT = '210' AND BNAME = '<USER>'"; INSERT INTO SAPABAP1.USR02 (MANDT, BNAME, BCODE, GLTGV, GLTGB, USTYP, CLASS, LOCNT, UFLAG, ACCNT, ANAME, ERDAT, TRDAT, LTIME, OCOD1, BCDA1, CODV1, OCOD2, BCDA2, CODV2, OCOD3, BCDA3, CODV3, OCOD4, BCDA4, CODV4, OCOD5, BCDA5, CODV5, VERSN, CODVN, TZONE, ZBVMASTER, PASSCODE, PWDCHGDATE, PWDSTATE, RESERVED, PWDHISTORY, PWDLGNDATE, PWDSETDATE, PWDINITIAL, PWDLOCKDATE, PWDSALTEDHASH, SECURITY_POLICY ) SELECT '210', BNAME, BCODE, GLTGV, GLTGB, USTYP, CLASS, LOCNT, UFLAG, ACCNT, ANAME, ERDAT, TRDAT, LTIME, OCOD1, BCDA1, CODV1, OCOD2, BCDA2, CODV2, OCOD3, BCDA3, CODV3, OCOD4, BCDA4, CODV4, OCOD5, BCDA5, CODV5, VERSN, CODVN, TZONE, ZBVMASTER, PASSCODE, PWDCHGDATE, PWDSTATE, RESERVED, PWDHISTORY, PWDLGNDATE, PWDSETDATE, PWDINITIAL, PWDLOCKDATE, PWDSALTEDHASH, SECURITY_POLICY FROM SAPABAP1.USR02 WHERE MANDT = '000' AND BNAME = '<USER>';"
 </syntaxhighlight>

Hendrik: /* SAP User kopieren */

2026-02-05T16:05:03Z

SAP User kopieren

← Nächstältere Version		Version vom 5. Februar 2026, 18:05 Uhr
Zeile 135:		Zeile 135:
	Dieser Befehl kopiert den User von 000 nach 210		Dieser Befehl kopiert den User von 000 nach 210
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	hdbsql -n localhost:30013 -d <SID>-u SAPABAP1 -p '<PW>' "DELETE FROM SAPABAP1.USR02 WHERE MANDT = '210' AND BNAME = '<USER>'; INSERT INTO SAPABAP1.USR02 (MANDT, BNAME, BCODE, GLTGV, GLTGB, USTYP, CLASS, LOCNT, UFLAG, ACCNT, ANAME, ERDAT, TRDAT, LTIME, OCOD1, BCDA1, CODV1, OCOD2, BCDA2, CODV2, OCOD3, BCDA3, CODV3, OCOD4, BCDA4, CODV4, OCOD5, BCDA5, CODV5, VERSN, CODVN, TZONE, ZBVMASTER, PASSCODE, PWDCHGDATE, PWDSTATE, RESERVED, PWDHISTORY, PWDLGNDATE, PWDSETDATE, PWDINITIAL, PWDLOCKDATE, PWDSALTEDHASH, SECURITY_POLICY ) SELECT '210', BNAME, BCODE, GLTGV, GLTGB, USTYP, CLASS, LOCNT, UFLAG, ACCNT, ANAME, ERDAT, TRDAT, LTIME, OCOD1, BCDA1, CODV1, OCOD2, BCDA2, CODV2, OCOD3, BCDA3, CODV3, OCOD4, BCDA4, CODV4, OCOD5, BCDA5, CODV5, VERSN, CODVN, TZONE, ZBVMASTER, PASSCODE, PWDCHGDATE, PWDSTATE, RESERVED, PWDHISTORY, PWDLGNDATE, PWDSETDATE, PWDINITIAL, PWDLOCKDATE, PWDSALTEDHASH, SECURITY_POLICY FROM SAPABAP1.USR02 WHERE MANDT = '000' AND BNAME = '<USER>';"		hdbsql -n localhost:30013 -d <SID>-u SAPABAP1 -p '<PW>' "DELETE FROM SAPABAP1.USR02 WHERE MANDT = '210' AND BNAME = '<USER>'"; INSERT INTO SAPABAP1.USR02 (MANDT, BNAME, BCODE, GLTGV, GLTGB, USTYP, CLASS, LOCNT, UFLAG, ACCNT, ANAME, ERDAT, TRDAT, LTIME, OCOD1, BCDA1, CODV1, OCOD2, BCDA2, CODV2, OCOD3, BCDA3, CODV3, OCOD4, BCDA4, CODV4, OCOD5, BCDA5, CODV5, VERSN, CODVN, TZONE, ZBVMASTER, PASSCODE, PWDCHGDATE, PWDSTATE, RESERVED, PWDHISTORY, PWDLGNDATE, PWDSETDATE, PWDINITIAL, PWDLOCKDATE, PWDSALTEDHASH, SECURITY_POLICY ) SELECT '210', BNAME, BCODE, GLTGV, GLTGB, USTYP, CLASS, LOCNT, UFLAG, ACCNT, ANAME, ERDAT, TRDAT, LTIME, OCOD1, BCDA1, CODV1, OCOD2, BCDA2, CODV2, OCOD3, BCDA3, CODV3, OCOD4, BCDA4, CODV4, OCOD5, BCDA5, CODV5, VERSN, CODVN, TZONE, ZBVMASTER, PASSCODE, PWDCHGDATE, PWDSTATE, RESERVED, PWDHISTORY, PWDLGNDATE, PWDSETDATE, PWDINITIAL, PWDLOCKDATE, PWDSALTEDHASH, SECURITY_POLICY FROM SAPABAP1.USR02 WHERE MANDT = '000' AND BNAME = '<USER>';"
	</syntaxhighlight>		</syntaxhighlight>


	===Störungen===		===Störungen===

Hendrik: /* SAP HANA Update */

2026-02-04T18:54:44Z

SAP HANA Update

← Nächstältere Version		Version vom 4. Februar 2026, 20:54 Uhr
Zeile 25:		Zeile 25:
	sudo su - root		sudo su - root
	cd /usr/sap/SUM		cd /usr/sap/SUM
	SAPCAR -xvf IMDB_CLIENT*		chmod +x SAPCAR && ./SAPCAR -xvf IMDB_CLIENT*
	./SAPCAR -xvf IMDB_SERVER*		chmod +x SAPCAR && ./SAPCAR -xvf IMDB_SERVER*
	cd /hana/shared/*/hdblcm		cd /hana/shared/*/hdblcm
	./hdblcm --action=update --ignore=check_signature_file --verify_signature=off --lss_trust_unsigned_components		./hdblcm --action=update --ignore=check_signature_file --verify_signature=off --lss_trust_unsigned_components

Hendrik am 21. Januar 2026 um 09:29 Uhr

2026-01-21T09:29:24Z

← Nächstältere Version		Version vom 21. Januar 2026, 11:29 Uhr
Zeile 131:		Zeile 131:
	hdbsql -n localhost:30013 -d <SID>-u SAPABAP1 -p '<PW>' "SELECT BNAME, USTYP FROM SAPABAP1.USR02 WHERE MANDT = '000'"		hdbsql -n localhost:30013 -d <SID>-u SAPABAP1 -p '<PW>' "SELECT BNAME, USTYP FROM SAPABAP1.USR02 WHERE MANDT = '000'"
	</syntaxhighlight>		</syntaxhighlight>

			=== SAP User kopieren ===
			Dieser Befehl kopiert den User von 000 nach 210
			<syntaxhighlight lang="sql">
			hdbsql -n localhost:30013 -d <SID>-u SAPABAP1 -p '<PW>' "DELETE FROM SAPABAP1.USR02 WHERE MANDT = '210' AND BNAME = '<USER>'; INSERT INTO SAPABAP1.USR02 (MANDT, BNAME, BCODE, GLTGV, GLTGB, USTYP, CLASS, LOCNT, UFLAG, ACCNT, ANAME, ERDAT, TRDAT, LTIME, OCOD1, BCDA1, CODV1, OCOD2, BCDA2, CODV2, OCOD3, BCDA3, CODV3, OCOD4, BCDA4, CODV4, OCOD5, BCDA5, CODV5, VERSN, CODVN, TZONE, ZBVMASTER, PASSCODE, PWDCHGDATE, PWDSTATE, RESERVED, PWDHISTORY, PWDLGNDATE, PWDSETDATE, PWDINITIAL, PWDLOCKDATE, PWDSALTEDHASH, SECURITY_POLICY ) SELECT '210', BNAME, BCODE, GLTGV, GLTGB, USTYP, CLASS, LOCNT, UFLAG, ACCNT, ANAME, ERDAT, TRDAT, LTIME, OCOD1, BCDA1, CODV1, OCOD2, BCDA2, CODV2, OCOD3, BCDA3, CODV3, OCOD4, BCDA4, CODV4, OCOD5, BCDA5, CODV5, VERSN, CODVN, TZONE, ZBVMASTER, PASSCODE, PWDCHGDATE, PWDSTATE, RESERVED, PWDHISTORY, PWDLGNDATE, PWDSETDATE, PWDINITIAL, PWDLOCKDATE, PWDSALTEDHASH, SECURITY_POLICY FROM SAPABAP1.USR02 WHERE MANDT = '000' AND BNAME = '<USER>';"
			</syntaxhighlight>


	===Störungen===		===Störungen===

Hendrik: /* SAP User anzeigen lassen */

2026-01-21T08:46:40Z

SAP User anzeigen lassen

← Nächstältere Version		Version vom 21. Januar 2026, 10:46 Uhr
Zeile 129:		Zeile 129:
	=== SAP User anzeigen lassen ===		=== SAP User anzeigen lassen ===
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	hdbsql -n localhost:30013 -d ~~IMP~~ -u SAPABAP1 -p '<PW>' "SELECT BNAME, USTYP FROM SAPABAP1.USR02 WHERE MANDT = '000'"		hdbsql -n localhost:30013 -d <SID>-u SAPABAP1 -p '<PW>' "SELECT BNAME, USTYP FROM SAPABAP1.USR02 WHERE MANDT = '000'"
	</syntaxhighlight>		</syntaxhighlight>

Hendrik am 21. Januar 2026 um 08:46 Uhr

2026-01-21T08:46:22Z

← Nächstältere Version		Version vom 21. Januar 2026, 10:46 Uhr
Zeile 125:		Zeile 125:
	HDB info		HDB info
	HDB version		HDB version
			</syntaxhighlight>

			=== SAP User anzeigen lassen ===
			<syntaxhighlight lang="sql">
			hdbsql -n localhost:30013 -d IMP -u SAPABAP1 -p '<PW>' "SELECT BNAME, USTYP FROM SAPABAP1.USR02 WHERE MANDT = '000'"
	</syntaxhighlight>		</syntaxhighlight>