The following table
provides a list of the parameters within the vacuum.cfg file.
Parameter |
Description |
Default Setting |
Type
|
Vacuum_Type
|
Specifies the type of
vacuum to perform as one of the following:
-
VACUUM ANALYZE: Performs
the vacuum function as described previously in this chapter but
also collects statistics about the proportions of duplicate values
within a column and the min/max value.
-
VACUUM: Performs
only the vacuum function.
-
VACUUM FULL: Physically
reorders the tables. This requires an exclusive lock on each table
while it is being processed.
|
VACUUM ANALYZE
|
Database Name* |
ConfigDB
|
Sets vacuuming parameters
for the Configuration database which contains tables pertaining
to the system and WEM configuration.
|
00,00
|
TrapDB
|
Sets vacuuming parameters
for the Trap database which contains tables pertaining to traps
and alarms generated by managed systems.
|
00,00
|
AuditDB
|
Sets vacuuming parameters
for the Audit Trail database which contains tables pertaining to
WEM audit trail information.
|
00,00
|
BulkDB
|
Sets vacuuming parameters
for the Bulk Statistics database which contains tables pertaining
to bulk statistics generated by managed systems.
|
00,00
|
P2PDB
|
Sets vacuuming parameters
for the P2P database which contains tables pertaining to protocol
and threshold statistics generated by managed systems.
|
00,00
|
Table Name |
ConfigDB |
CompleteDB
|
This parameter dictates
whether or not vacuuming will be performed on only the database
or each table in the database individually.
A value of 0 indicates
that vacuuming is to be performed on each table. A value of 1 indicates
that vacuuming is to be performed only on the database.
|
1
|
boxer
|
Sets vacuuming parameters
for the table that contains configuration information pertaining
to the system.
|
00,00
|
portmontable
|
Sets vacuuming parameters
for the table that contains configuration information pertaining
to port monitoring.
|
00,00
|
boxeruserinfo
|
Sets vacuuming parameters
for the table that contains configuration information pertaining
to administrative users configured on the system.
|
00,00
|
userpreference
|
Sets vacuuming parameters
for the table that contains configuration information pertaining
to preferences configured for WEM administrative users.
|
00,00
|
processthreshold
|
Sets vacuuming parameters
for the table that contains configuration information pertaining
to WEM process thresholds.
|
00,00
|
ippooldefaults
|
Sets vacuuming parameters
for the table that contains configuration information pertaining
to IP address pool default values.
|
00,00
|
scbrdefaults
|
Sets vacuuming parameters
for the table that contains information about subscriber default
parameters.
|
00,00
|
csmsessioninfo
|
Sets vacuuming parameters
for the table that contains information on the session id between
client and server, client IOR, login time, and address.
|
00,00
|
bkinfo
|
Sets vacuuming parameters
for the table that contains information required for configbackup.
|
00,00
|
graphscreeninfo
|
Sets vacuuming parameters
for the table that contains configuration information pertaining
to graph displays.
|
00,00
|
batchjobcleanup
|
Sets vacuuming parameters
for the table that contains information required for cleanup of
batch jobs.
|
00,00
|
batchjobinfo
|
Sets vacuuming parameters
for the table that contains information required for batch jobs.
|
00,00
|
boxeronmap
|
Sets vacuuming parameters
for the table that contains configuration information pertaining
to administrative user maps configured on the system.
|
00,00
|
dbbackupinfo
|
Sets vacuuming parameters
for the table that contains configuration information pertaining
to database backup.
|
00,00
|
maptable
|
Sets vacuuming parameters
for the table that contains configuration information pertaining
to the map table.
|
00,00
|
p2pinfo
|
Sets vacuuming parameters
for the table that contains configuration information pertaining
to P2P database.
|
00,00
|
updateinfo
|
Sets vacuuming parameters
for the table that contains configuration information pertaining
to updates.
|
00,00
|
userinfo
|
Sets vacuuming parameters
for the table that contains configuration information pertaining
to WEM administrative users.
|
00,00
|
dbcurrent
|
Sets vacuuming parameters
for the table that contains configuration information pertaining
to the current database.
|
00,00
|
hostname
|
Sets vacuuming parameters
for the table that contains configuration information pertaining
to host names.
|
00,00
|
syslog keyword list
|
Sets vacuuming parameters
for the table that contains configuration information pertaining
to the keyword log list configured on the system.
|
00,00
|
syslogmsgfileinfo
|
Sets vacuuming parameters
for the table that contains configuration information pertaining
to the message log list configured on the system.
|
00,00
|
cdpreportinfo
|
Sets vacuuming parameters
for the table that contains configuration information pertaining
to CDP reports.
|
00,00
|
filefetchinfo
|
Sets vacuuming parameters
for the table that contains configuration information pertaining
to fetching of files from the database.
|
00,00
|
ongoingsftpinfo
|
Sets vacuuming parameters
for the table that contains configuration information pertaining
to the ongoing SFTP.
|
00,00
|
TrapDB |
CompleteDB
|
This parameter dictates
whether or not vacuuming will be performed on only the database
or each table in the database individually.
A value of 0 indicates
that vacuuming is to be performed on each table. A value of 1 indicates
that vacuuming is to be performed only on the database.
|
1
|
trap
|
Sets vacuuming parameters
for the table that contains information pertaining to SNMP traps
received.
|
00,00
|
deletedtrap
|
Sets vacuuming parameters
for the table that contains information pertaining to deleted SNMP
traps.
|
00,00
|
forwardinginfo
|
Sets vacuuming parameters
for the table that stores the information for forwarding the received
SNMP traps in real time.
|
00,00
|
forwardpurgeinfo
|
Sets vacuuming parameters
for the table that is used to get information about whether or not
to purge the forwarded trap.
|
00,00
|
mailinfo
|
Sets vacuuming parameters
for the table that stores trap e-mail address, e-mail type (TO,
CC, or BCC), trap type and trap specific number.
|
00,00
|
mailmessage
|
Sets vacuuming parameters
for the table that stores trap e-mail subject, trap message, trap
type and trap specific number.
|
00,00
|
configure
|
Sets vacuuming parameters
for the table that contains information pertaining to SNMP trap
configuration.
|
00,00
|
schedule
|
Sets vacuuming parameters
for the table that stores the trap severity, Audio start time, audio
stop time.
|
00,00
|
forwardaddress
|
Sets vacuuming parameters
for the table that contains information pertaining to the forward
address.
|
00,00
|
pendingtrap
|
Sets vacuuming parameters
for the table that contains information pertaining to the pending
SNMP traps.
|
00,00
|
trap_current
|
Sets vacuuming parameters
for the table that contains information pertaining to the current
SNMP trap.
|
00,00
|
trapoperdetails
|
Sets vacuuming parameters
for the table that contains information pertaining to trap operation.
|
00,00
|
AuditDB |
CompleteDB
|
This parameter dictates
whether or not vacuuming will be performed on only the database
or each table in the database individually.
A value of 0 indicates
that vacuuming is to be performed on each table. A value of 1 indicates
that vacuuming is to be performed only on the database.
|
1
|
auditlog
|
Sets vacuuming parameters
for the table that contains information pertaining to the WEM’s
Audit Trail function.
|
00,00
|
chassisinfo
|
Sets vacuuming parameters
for the table that contains information pertaining to the chassis.
|
00,00
|
cpuinfo
|
Sets vacuuming parameters
for the table that contains information pertaining to the CPU.
|
00,00
|
daughtercardinfo
|
Sets vacuuming parameters
for the table that contains information pertaining to the daughter
card.
|
00,00
|
hardwareactivity
|
Sets vacuuming parameters
for the table that contains information pertaining to the hardware
activity.
|
00,00
|
hardwareinfo
|
Sets vacuuming parameters
for the table that contains information pertaining to the hardware.
|
00,00
|
lcrccspioinfo
|
Sets vacuuming parameters
for the table that contains information pertaining to Line Cards
(LC), Redundant Crossbar Cards (RCC), and Switch Processor Input/Output
(SPIO) cards.
|
00,00
|
pactacinfo
|
Sets vacuuming parameters
for the table that contains information pertaining to the Packet
Accelerator Card (PAC) and Telephony Accelerator Card (TAC).
|
00,00
|
smcinfo
|
Sets vacuuming parameters
for the table that contains information pertaining to the System
Management Card (SMC).
|
00,00
|
spccardinfo
|
Sets vacuuming parameters
for the table that contains information pertaining to the Switch
Processor Card (SPC).
|
00,00
|
imglastevtgentime
|
Sets vacuuming parameters
for the table that contains information pertaining to the last event
generation time of the system.
|
00,00
|
BulkDB |
CompleteDB
|
This parameter dictates
whether or not vacuuming will be performed on only the database
or each table in the database individually.
A value of 0 indicates
that vacuuming is to be performed on each table. A value of 1 indicates
that vacuuming is to be performed only on the database.
|
1
|
card
|
Sets vacuuming parameters
for the table that contains information pertaining to the card-level
schema.
|
00,00
|
port
|
Sets vacuuming parameters
for the table that contains information pertaining to the port-level
schema.
|
00,00
|
system |
Sets vacuuming parameters
for the table that contains information pertaining to the system-level
schema.
|
00,00
|
ggsnsystem
|
Sets vacuuming parameters
for the table that contains information pertaining to the system-level
schema for GGSN-based systems.
|
00,00
|
ppp
|
Sets vacuuming parameters
for the table that contains information pertaining to the PPP-level
schema.
|
00,00
|
mipfa
|
Sets vacuuming parameters
for the table that contains information pertaining to the Mobile
IP FA-level schema.
|
00,00
|
mipha
|
Sets vacuuming parameters
for the table that contains information pertaining to the Mobile
IP HA-level schema.
|
00,00
|
rp
|
Sets vacuuming parameters
for the table that contains information pertaining to the PDSN-level
schema.
|
00,00
|
gtpc
|
Sets vacuuming parameters
for the table that contains information pertaining to the GGSN-level
schema.
|
00,00
|
gtpp
|
Sets vacuuming parameters
for the table that contains information pertaining to the GTPP-level
schema.
|
00,00
|
ippool
|
Sets vacuuming parameters
for the table that contains information pertaining to the IP Address
Pool-level schema.
|
00,00
|
apn
|
Sets vacuuming parameters
for the table that contains information pertaining to the APN-level
schema.
|
00,00
|
lac
|
Sets vacuuming parameters
for the table that contains information pertaining to the LAC-level
schema.
|
00,00
|
radius
|
Sets vacuuming parameters
for the table that contains information pertaining to the RADIUS-level
schema.
|
00,00
|
imgaccess
|
Sets vacuuming parameters
for the table that contains information on the XML files generated
by the Bulk Statistics Server.
|
00,00
|
ecs
|
Sets vacuuming parameters
for the table that contains information pertaining to the ECS-level
schema.
|
00,00
|
misc
|
Sets vacuuming parameters
for the table that contains information pertaining to the miscellaneous
schema.
|
00,00
|
ipsg
|
Sets vacuuming parameters
for the table that contains information pertaining to the IPSG-level
schema.
|
00,00
|
asngw
|
Sets vacuuming parameters
for the table that contains information pertaining to the ASNGW-level
schema.
|
00,00
|
sgsn
|
Sets vacuuming parameters
for the table that contains information pertaining to the SGSN-level
schema.
|
00,00
|
sgtp
|
Sets vacuuming parameters
for the table that contains information pertaining to the SGTP-level
schema.
|
00,00
|
sccp
|
Sets vacuuming parameters
for the table that contains information pertaining to the SCCP-level
schema.
|
00,00
|
ss7rd
|
Sets vacuuming parameters
for the table that contains information pertaining to the SS7RD-level
schema.
|
00,00
|
mipv6ha
|
Sets vacuuming parameters
for the table that contains information pertaining to the MIPv6
HA-level schema.
|
00,00
|
context
|
Sets vacuuming parameters
for the table that contains information pertaining to the context-level
schema.
|
00,00
|
cscf
|
Sets vacuuming parameters
for the table that contains information pertaining to the CSCF-level
schema.
|
00,00
|
ss7link
|
Sets vacuuming parameters
for the table that contains information pertaining to the SS7 Link-level
schema.
|
00,00
|
gprs
|
Sets vacuuming parameters
for the table that contains information pertaining to the GPRS-level
schema.
|
00,00
|
pdif
|
Sets vacuuming parameters
for the table that contains information pertaining to the PDIF-level
schema.
|
00,00
|
schemastatus
|
Sets vacuuming parameters
for the table that contains information pertaining to the schema
status.
|
00,00
|
P2PDB |
CompleteDB
|
This parameter dictates
whether or not vacuuming will be performed on only the database
or each table in the database individually.
A value of 0 indicates
that vacuuming is to be performed on each table. A value of 1 indicates
that vacuuming is to be performed only on the database.
|
1
|
bwstat
|
Sets vacuuming parameters
for the table that contains information pertaining to data traffic
bandwidth statistics.
|
00,00
|
dailystat
|
Sets vacuuming parameters
for the table that contains information pertaining to daily statistics.
|
00,00
|
hourlystat
|
Sets vacuuming parameters
for the table that contains information pertaining to hourly statistics.
|
00,00
|
protocolstat
|
Sets vacuuming parameters
for the table that contains information pertaining to protocol statistics.
|
00,00
|
scbrdailystats
|
Sets vacuuming parameters
for the table that contains information pertaining to subscriber
daily statistics.
|
00,00
|
scbrhourlystats
|
Sets vacuuming parameters
for the table that contains information pertaining to subscriber
hourly statistics.
|
00,00
|
scbrstats
|
Sets vacuuming parameters
for the table that contains information pertaining to subscriber
statistics.
|
00,00
|
tempp2p
|
Sets vacuuming parameters
for the table that contains information pertaining to P2P statistics.
|
00,00
|
thresholdstats
|
Sets vacuuming parameters
for the table that contains information pertaining to threshold
statistics.
|
00,00
|
* Any non-zero
number specified for a database in the Database Name section supersedes
the CompleteDB parameter setting for the database. For example,
if the start value for the Configuration database is 13 and the
databases corresponding CompleteDB parameter is set to 0, then vacuuming
is to be done for the entire database and all of the tables. However,
if there is a conflict between the start times specified for any
of the tables within the database and that specified for the database
itself, vacuuming will not be started for that table.
|