Functions and Views for All Products > apt_v_datacoll_exec_tracking
  
Version 10.0.01
apt_v_datacoll_exec_tracking
The apt_v_datacoll_exec_tracking view contains raw logging details for a persistence related database Stored Procedure/Query processing.
 
Table 3 apt_v_datacoll_exec_tracking
Column Name
Data Type
Description
component
STRING
Abbreviation of the subsystem for which logging details are captured. Possible values:
BASE - Base, common to all backup collection
NBU - NetBackup
BUE - Backup Exec
LEG - Legato/NetWorker
TSM - Tivoli Storage Manager
HPD - HP Data Protector
AVM - Avamar
GEN - Generic Backup
CMV - Commvault Simpana
SRM - Base, common to all capacity collection
SRM HDS - Hitachi Data Systems
SRM HDS HNAS - HDS H-NAS
SRM EMC - EMC common
SRM EMC CLA - EMC CLARiiON
SRM EMC SYM - EMC Symmetrix
SRM EMC VNX - EMC Celerra
SRM EMC ISI - EMC Isilon
SRM EMC VPL - EMC Vplex
SRM NAP - NetApp common
SRM NAP NTC - NetApp Cluster-Mode
SRM HP - Hewlett-Packard
SRM HP 3PAR - HP 3PAR
SRM IBM - IBM common
SRM IBM SVC - IBM SVC
SRM IBM XIV - IBM XIV
SRM DLL CPL - Dell Compellent
SRM EVA - HP EVA
SRM OSS - OpenStack Swift
SRM SDK - Generic Storage Array
SRM HOST - Host
SRM BROCADE LT - Brocade Zone Alias
SRM CISCO LT - Cisco Zone Alias
DATA DOMAIN - Data Domain
VMM - Virtualization base
VMM VMW - VMware
VMM VIO - IBM VIO
VMM SOL - Oracle Container/Zone
SNAPMIRROR - NetApp SnapMirror
SNAPVAULT - NetApp SnapVault
SDK - SDK Generic Storage Array
SWI - Switch base
AFA - File Analytics
package_name
STRING
Name of database package for which logging details are captured.
procedure_name
STRING
Name of database procedure for which logging details are captured.
query_name
STRING
Name of SQL Query for which logging details are captured.
nbr_of_records
NUMBER
Number of records processed for this database procedure call.
db_elapsed_time_sec
NUMBER
Time spent for processing this database procedure call.
last_updated
DATE
Date/Time when the data was captured for this procedure.