Solved

nFilterApplicationFiles additional setting

  • 14 January 2022
  • 4 replies
  • 46 views

Userlevel 1
Badge +3

Hello,

I’ve found the setting called “nFilterApplicationFiles”

 

Create this additional setting and set its value as 1 to exclude the database application files from the file system backup. This applies to DB2, Oracle, SAP for Oracle and SAP HANA.

Additional Settings Description (commvault.com)

 

 

As for the DB2 it’s being covered under this link: Excluding Application Files from a UNIX File System Backup (commvault.com)

 

Excluded DB2 Files

The following files are excluded when you set the additional setting on a DB2 client:

  • The DB2 datafiles that the software displays in the CommCell Console DB2 browse pane.
  • The files that reside in the DB2 archive log path (Db2Agent\sDB2_ARCHIVE_PATH)
  • The files that reside in the DB2 audit error path (Db2Agent\sDB2_AUDIT_ERROR_PATH)
  • The files that reside in the DB2 retrieve error path (Db2Agent\sDB2_RETRIEVE_PATH)

 

But what does exactly that part means - “The DB2 datafiles that the software displays in the CommCell Console DB2 browse pane” ?

icon

Best answer by Sunil 17 January 2022, 06:11

View original

4 replies

Badge

One thing to understand with this additional setting is that it only applies to configured DB instances/databases that have at least one successfully completed DB agent backup in Commvault.  So if there is a DB datafile on the server that hasn’t been backed up using a DB agent it will not be skipped during filesystem backups.  Once you have a successful backup, it will then be filtered.

So what the line you referenced is trying to state is that the database needs to have been discovered in Commvault and will therefore be visible in the console. 

Hope that helps.

Userlevel 4
Badge +7

@Steven R is right. The idea behind this key is to avoid backing up the DB data backed up twice (once by the Database agent and once by File System agent). So, if the DB2 database is discovered and configured for backup in Commvault, then the data files details are collected and stored in Commvault’s catalog. Only such data files will be skipped by File System agent when this additional setting is set.

Any DB data of instances that are not being backed up by Commvault won’t be skipped.

 

Thanks,

Sunil-

 

Userlevel 1
Badge +3

Thank you guys for clarifying this, but are you aware how exactly it works? What files are being excluded? i.e. everything in the DB directory, some particular extensions (after proper DB backup) and so on?

 

Userlevel 4
Badge +7

As mentioned in the documentation page, the following paths will be skipped.

 

  • The files that reside in the DB2 archive log path (Db2Agent\sDB2_ARCHIVE_PATH)
  • The files that reside in the DB2 audit error path (Db2Agent\sDB2_AUDIT_ERROR_PATH)
  • The files that reside in the DB2 retrieve error path (Db2Agent\sDB2_RETRIEVE_PATH)

Along with these, all the data files under the data area will be skipped. These files can be of extensions .LRG, .CAT, .TMP, .dbf, .USR but not limited to. Basically any file that’s discovered as a datafile by Commvault will be skipped.

 

Thanks,

Sunil-

Reply