What happens with SDI virtual tables and remote sources when DPAgent went offline?

[s-i-l]

Hello,

first of all I would like to describe the situation:

We have BW/4 Hana installed and with the help of SDI and DPAgent tables from MS SQL Server are present in SAP BW/4 schema (SAPHANADB). 

This is my question:

Because of security updates host os of DPAgent needs a reboot.

• What happens in case DPAgent is down with the created virtual tabels, remote sources and datasources build up of them?
• Do BW/4 processes still have access to the these tables, is there a kind of caching available? 
• What is best practice updating the DPAgent concerning the connected systems? Should BW/4 have a downtime also?
• What are your experiences?

I'm looking forward to your answers!

Best regards,

Sascha

[xiaoming_wu]

Hi Sascha,

DP agent is used to connect to MSSQL, in this case, if DP agent is down, then no access to the table content, there is no cache. 

The only impact is the datasource that use SDI connection, so during the downtime, if you have batch loading, it will fail(so if you have planned downtime or upgrade, do not run any batch loading),  if you have realtime replication(subscription), you can suspend the remote source before planned downtime.
https://help.sap.com/docs/HANA_SMART_DATA_INTEGRATION/7952ef28a6914997abc01745fef1b607/782844c3cc8e4...

use sql command to do remote source suspend capture and suspend distribute, after restart of DP agent, resume capture and distribute. Thanks.

Best regards
Helen