Need info regarding DB FUll backup

[SAPSupport]

Dear SAP Team,

Kindly check below details and please provide us solution ASAP.

1) we are scheduling DB full backup on our resiliency server for ever alternative weeks, when DB backup scheduled, in IQMSG logs total number of IQ blocks to be backed up and total number of IQ blocks backed up records are matching, but same entry cannot be seen in sysiqbackuphistory table, where as we are daily refreshing resiliency DB through full virtual decoupled and incremental since full backup which are getting logged in the sysiqbackuphistory table and since the every alternative week post the resiliency DB refresh we are manually scheduling DB full backup in the database hence this would be the reason where it cannot be logged in sysiqbackuphistory table and kindly let us know is there a way that we can make it logged to this sysiqbackuphistory table?

2) Since in IQ it will not be written like explicitly backup started in backup completed, Is there any configuration or a statement or print statement which we can include in our script which will explicitly write into IQMSG or SRV logs where backup has started or backup has completed statements.

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1) we are scheduling DB full backup on our resiliency server for ever alternative weeks, when DB backup scheduled, in IQMSG logs total number of IQ blocks to be backed up and total number of IQ blocks backed up records are matching, but same entry cannot be seen in sysiqbackuphistory table, where as we are daily refreshing resiliency DB through full virtual decoupled and incremental since full backup which are getting logged in the sysiqbackuphistory table and since the every alternative week post the resiliency DB refresh we are manually scheduling DB full backup in the database hence this would be the reason where it cannot be logged in sysiqbackuphistory table and kindly let us know is there a way that we can make it logged to this sysiqbackuphistory table?
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
==>
"sysiqbackuphistory" does not have any information regarding "Total blocks to backup".
You may find "Total blocks to backup" from "sysiqbackuphistorydetail.num_blocks_backed_up".
However, please note that "sysiqbackuphistorydetail.num_blocks_backed_up" may show number of blocks backed up by IQ engine only.
If dbfiles for IQ Main Stores are backed up by O/S command in case of IQ virtual backup, then IQ cannot check the exact number of blocks backed up by the O/S command.

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2) Since in IQ it will not be written like explicitly backup started in backup completed, Is there any configuration or a statement or print statement which we can include in our script which will explicitly write into IQMSG or SRV logs where backup has started or backup has completed statements
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
==>
Please refer to KBA 2285840 for more detail information regarding start/complete information regarding IQ backups from .iqmsg file.

--2285840 - How To Determine Backup Progress in SAP IQ
https://me.sap.com/notes/2285840