Paradyne SLM 5.5 manual OLCmd dbage

Page 79

A. OLCmd Reference

OLCmd dbage

The dbage command removes older records from the performance statistics database.

Format:

OLCmd dbage [-n instance ] [[ -d -a ] [[ -raw days ] [ -rpt days ]] -dd]

Where:

 

-ninstance

Specifies the database name. If -n is omitted, the default

 

database is used.

-d

Removes records from the database by device according to

 

the parameters selected when each device was added.

-a

Removes records from the database using the number of

 

days in the system-wide preferences (preferences.dat).

-raw days

Optionally specifies the age in days of the oldest Raw

 

(quarter-hourly user history) data record to be retained. This

 

overrides the Save Raw Data For value entered when each

 

device was added to the database. If 0 is specified, all Raw

 

data records in the database are deleted.

-rpt days

Optionally specifies the age in days of the oldest Report

 

(hourly user history) data record to be retained. This

 

overrides the Save Report Data For value entered when

 

each device was added to the database. If 0 is specified, all

 

Report data records in the database are deleted.

-dd

Optionally deletes data for connections which no longer

 

exist. The -dd parameter may not be specified with the -d,

 

-a, -raw, or -rpt parameters.

 

A connection is determined to be nonexistent when an

 

interface appears in the user history database but not in the

 

LDAP database. If the -dd option is never used, user history

 

records for nonexistent connections are eventually deleted

 

like other records, according to age.

Example:

To delete Report data records older than 90 days and Raw data records older than

7 days, enter the command:

OLCmd dbage -n OracleStatsDB -raw 7 -rpt 90

To delete all records for nonexistent connections, then delete Report and Raw data records according to individual device definitions, enter the commands:

OLCmd dbage -n OracleStatsDB -dd

OLCmd dbage -n OracleStatsDB -d

7800-A2-GB32-00

January 2002

A-9

Image 79
Contents OpenLane SLM Copyright 2002 Paradyne Corporation All rights reserved Contents Configuring Distributed Components Installing OpenLane on WindowsApache User Access Authentication Building and Using a Firmware Library OpenLane MaintenanceAdding Devices and Customer Profiles OLCmd Reference Using XML to Produce ReportsIndex Document Purpose and Intended Audience About This GuideDocument Summary Library → Technical Manuals Product-Related DocumentsNetwork Monitoring Easy InstallationIntroduction to OpenLane SLM OpenLane SLMOpenLane Features Planning the Installation Installing OpenLane on SolarisAbout These Instructions Minimum Hardware Requirements Installation RequirementsSoftware Requirements Checking the Java Runtime Environment Version ProcedureCd /opt/OV/pdn/PerfWiz UnInstallToOV Uninstalling DCE ManagerUninstalling Performance Wizard DCEinstallOpt/apache OpenLane Installation ProgramOpt/pdn/OpenLane Setup.sh Obtaining a License Key Installing from Paradyne’s Web SiteUser = nobody Group = nobody Installing from FTP Files Installing from CD-ROMSetenv Display localhostname0.0 Installing Remotely UsingInstalling the Permanent License Key Export DISPLAY=localhostname0.0OLCmd key Locating the License Key On an Installed SystemMigration to Current Release for Oracle Displaying the License Key Expiration DateStopping OpenLane Web and Database Services Starting OpenLane Web and Database ServicesConfiguring Apache to Use a Different Port Installing OpenLane on Solaris January Installing OpenLane on Windows MHz Processor Web Client Software Requirements Cd \opt\OV\pdn\PerfWiz uninstalltoov \opt\apache \Program Files\Apache Group\Apache\opt\pdn\OpenLane Procedure Cd \opt\pdn\OpenLane Migration to Current Release for Oracle Starting OpenLane Web and Database Services Stopping OpenLane Web and Database Services Http//olserver.com8080/openlane Installing OpenLane on Windows January OpenLane Distributed Components Configuring Distributed ComponentsOpenLane in /opt/pdn/OpenLane Setting Up Web Server DistributionSolaris Http//172.20.1.10/OpenLane Operational NotesCd /opt/pdn/OpenLane/uhpoller mkdir pollerpoller1 Setting Up the Distributed Poller and ReaderDistributed Poller/Reader Management Server Setup Cd /opt/pdn/OpenLane OLControl stopOLCmd logsvc OLCmd Dbconfig ‘-m 172.20.1.10’OLCmd Dbconfig ‘-m 172.20.1.101521’ Cd /opt/pdn/OpenLane OLControl startDOMAIN=default Distributed Poller/Reader Poller/Reader SetupREADERDOMAIN=default OLControl stop User Access Authentication Apache User Access AuthenticationCd /opt/apache Solaris cd \opt\apache Windows Configuring Http Challenge/ResponseChange to the /opt/apache/bin Solaris or c\opt\apache\bin OLCmd confauth off Removing a User’s Access\opt\pdn\OpenLane Windows OLCmd confauth onApache User Access Authentication January Adding Devices and Customer Profiles Accessing the OpenLane Web ApplicationsAdding a Device AdminNew Device Field Names Field Description Adding a Customer Profile 7800-A2-GB32-00 January Adding Devices and Customer Profiles Task Importance Ideal Frequency OpenLane MaintenanceOracle Database Backing Up OpenLane FilesOpt/pdn/OpenLane/data Gzip -d /backupdir/backup.tar.gz tar xvf backup.tarBacking Up OpenLane Under Solaris Restoring OpenLane Under SolarisRestoring OpenLane Under Windows Backing Up OpenLane Under WindowsFrequency Deleting Older Records from the DatabaseCd /opt/pdn/OpenLane OLCmd processreports Using Cron Under Solaris to Automate ReportsGenerating Scheduled Reports Automating the Generation of Scheduled ReportsCd \opt\pdn\OpenLane OLCmd processreports Using AT under Windows to Automate ReportsRebuilding Oracle Database Indexes Apache Log Files Monitoring Log FilesSQL Database Log File Archiving and Deleting Log Files OLCmd clean logs .logLegacy Logger Log Files Click on Click here to schedule the tasks Uploading ConfigurationsOpenLane Maintenance January 01.02.01=R010201.ocd Building and Using a Firmware LibraryBuilding a Firmware Library Version=filenameModel=directory New Device Models Not Supported by OpenLane9880=fw9880 Dslasn Model=devicetypeDbm DslaanDownloading and Activating Firmware Building and Using a Firmware Library Building and Using a Firmware Library January OLCmd Reference Cd \opt\pdn\openlane olcmd confauth on OLCmd HelpsOlcmd viewlog -h OLCmd addcust Rent-a-Phone.com Rent-a-PhoneGmbH Rent-a-PhoneUSA OLCmd addcust -a realtime -c ExactCorporationOLCmd assigndev -c ExactCorporation -a OLCmd assigndevOLCmd assigndev -c ExactCorporation -l exactdevices.txt OLCmd chgrawfileext -o raw -e ftp OLCmd chgrawfileextOLCmd chgrawfileext -d dallas -o bad -e raw OLCmd clean \opt\apache\logs .log 21 admin OLCmd cleanOLCmd confauth on off OLCmd confauthOLCmd dbage OLCmd dbconfig -d c o -a instance -l -h OLCmd dbconfigUrl OLCmd dbcopy d OracleStatsDB OLCmd dbcopyOLCmd dbip address OLCmd dbipOLCmd dbip OLCmd dbroll -e 20010101000000 -r OLCmd dbrollDatabaseinstance IpaddressOLCmd delcust -ccustomer -lcustomer-list OLCmd delcustOLCmd delcust -l ex-customers.txt OLCmd deldev ipaddress OLCmd deldevOLCmd deldev OLCmd dumpldap host OLCmd dumpldapOLCmd importldif -h host ldiffile OLCmd importldifLdiffile OLCmd key licensekey OLCmd keyOLCmd key WZBCK-AAM6E-U898Q-MX5HK OLCmd ldapmodify OLCmd ldapmodify -D c=US -w admin -a -c data/new.ldifOLCmd OLCmd ldapsearch OLCmd ldapsearch -n-D bindDN -w password -h host -p portDebuglevel OLCmd logsvc ipaddress OLCmd logsvcOLCmd processreports -date 05/13/2001 -customer ExactCorp OLCmd processreportsDate date Enddate enddateOLCmd snmpget 135.26.10.37 OLCmd snmpgetOLCmd snmpget communityname ipaddress objectid ObjectidOLCmd snmptest 135.26.10.37 nmswrite Ipaddress Is the address of the device to be accessedOLCmd snmptest OLCmd snmptest ipaddress communitynameOLCmd sync OLCmd sync Poller-name OLCmd uhread -ccommand -npoller-nameCommand OLCmd uhreadOLCmd unassigndev -c ExactCorporation -a OLCmd unassigndevOLCmd unassigndev -c ExactCorporation -l exactdevices.txt OLCmd viewlog OLCmd viewlog -f fi -sd 05/07/2000 -ed 05/13/2000 UHReader Firmware/Configuration/Feature MaintenanceUHLister Poller Controller UHReader Database ReaderXsltransformfile OLCmd xmlreportXmlrequestfile XmloutputfileOLCmd Reference January Command Line Interface OLCmd xmlreport Using XML to Produce ReportsXML Reports Opt/pdn/OpenLane/samples/xml/reports/xmlentry.html. You can Servlet Interface SlvXmlServletWriting an Interface to the Servlet Opt/pdn/OpenLane/OLServlets/pdn.webcgi.SlvXmlServletOpt/pdn/OpenLane/samples/xml/reports/DeviceReports/Reports XML and XSL ExamplesAdditional Resources Opt/pdn/OpenLane/samples/xml/reports/DeviceReports/RequestsUsing XML to Produce Reports January IN-1 IndexIN-2 IN-3 IN-4