commvault.com commvault.com
Solved

nFilterApplicationFiles additional setting

  • 14 January 2022
  • 4 replies
  • 311 views
L
Rank
Userlevel 1
Badge +5

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

Steven Robinson
Rank
Userlevel 3
Badge +5

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.

“I did then what I knew how to do. Now that I know better, I do better.” ― Maya Angelou
Sunil
Rank
Userlevel 5
Badge +12

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

 

L
Rank
Userlevel 1
Badge +5

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?

 

Sunil
Rank
Userlevel 5
Badge +12

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


Terms & ConditionsCookie settings