SAP Knowledge Base Article - Preview

2763951 - Full Backups using backint randomly fails - SAP HANA Dynamic Tiering

Symptom

  • SAP HANA Dynamic Tiering full backups randomly fails.
  • Backups are using backint solution from IBM Tivoli Data Protection for SAP HANA.

There is some description: https://www.ibm.com/support/knowledgecenter/en/SSER83_8.1.0/erp.hana/c_dperp_saphana_protection.html

  • Basically it is one process on the OS which is connecting to Tivoli Backup Servers.
  • This backup is triggered from DB OS using this command:

hdbsql -i 10 -n hostname:31015 -d SYSTEMDB -U user -I /hana/shared/HD1/scripts/backup_HD1.sql

  • In backup_SYSDB.sql is this command: backup data for HD1 using backint ('<directory>')

Excerpt of Esserver.trc

i esserver UNKNOWN(0) : ValidateBackup
i esserver UNKNOWN(0) : ValidateBackup
i esserver UNKNOWN(0) : IQ Checkpoint position: 0
i esserver UNKNOWN(0) : Chk
i esserver UNKNOWN(0) : ChkDone [NumTxnCP: 4611]
i esserver UNKNOWN(0) : IQ Checkpoint block: 335586
i esserver UNKNOWN(0) : PrepareForBackup
i esserver UNKNOWN(0) : PostChk
i esserver UNKNOWN(0) : DoBackup
i esserver UNKNOWN(0) : [20949]: Number of IQ blocks backed up: 1
...............
i esserver UNKNOWN(0) : Exception Thrown from dblib/db_backup.cxx:2339, Err# 4, tid 725 origtid 725
i esserver UNKNOWN(0) : O/S Err#: 0, ErrID: 4098 (db_sqlexception); SQLCode: -1012002, SQLState: 'QUA02', Severity: 14
i esserver UNKNOWN(0) : [20925]: Unable to write to archive. ('Failed to write pipe /usr/sap/HD1/SYS/global/hdb/backint/DB_HD1/databackup_1024_1_1549940580457_4 during BACKUP using BACKINT Broken pipe')
-- (dblib/db_backup.cxx 2339)

Tivoli errorlog excerpt

ANR4744W The server cannot acquire a sufficient number of mount points. (SESSION: 7190937)
ANR4734W The copy storage pool CASAPH was removed from the storage pool list because of a failure for session 7190937. (SESSION: 7190937)
ANR0403I Session 7190937 ended for node Hostname_SAP (TDP SAP Linux). (SESSION: 7190937)


Read more...

Environment

  • IBM Tivoli Data Protection for SAP HANA
  • SAP Dynamic Tiering 2.0
  • SAP HANA 2.0

Product

SAP HANA dynamic tiering 2.0 ; SAP HANA, platform edition 2.0

Keywords

"IBM Tivoli Data Protection for SAP HANA"; Tivoli; ANR4734W; "number of mount points"; -1012002 , KBA , HAN-DYT , SAP HANA Dynamic Tiering , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.