As you create and debug applications that use the DB2 extenders, it is useful to know which data objects are enabled for extender data. For example, if you can determine that a certain table is enabled for image data, your application can successfully store image files in that table.
It is also useful to understand the correlation between user tables and external media files, for example, which tables refer to a specific file or which files are referenced by a specific table. It is also useful to discover if your tables refer to files that no longer exist on the system.
You need appropriate privileges: You need to have access to a table in order to track data in the table. If you want to perform comprehensive tracking operations, such as find which entries in all user tables in the database refer to a file, you need SYSADM authority, DBADM authority, or SELECT privilege on enabled columns in all searched user tables and associated administrative support tables. If you do not have access to all the tables, the extenders will return tracking information only for those tables that you can access. They will also return a code indicating that you do not have access authority to some of the required tables.