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
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.