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 ONE Support launchpad (Login required).

Search for additional results

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