The Complete GEM Documentation
INTRODUCTION
Document Navigation
IntroductionToGem
What Is the Generic Enterprise Manager
TheBenefitsOfGem
ThePowerOfGem
Component Packages
Architecture Overview
GemPrerequisites
Usage License
Pricing
Customization
GETTING STARTED
Getting Started Guide
Gem Directory Structure
Gem User Interfaces Directory
The Admin Scripts Directory
The Data Directory Layout
The Conf Directory
Gemrpt Scheduled Tasks Directories
Backup And Maintenance Plans
Gemrpt Enterprise Manager
Gemrpt Enterprise Manager
Gemrpt Documentation
Documentation And Diagnostics
GEM INSTALLATION GUIDE
InstallationGuide
Pre-install check list
Suggestions on your first implementation
Download & initial setup
configure.pl
Important notes
How to run configure.pl
The welcome tab
The paths tab
The servers tab
The files tab
The backups tab
The console tab
The alarms tab
The install software tab
The post install tasks tab
The scheduler tab
PostInstallationSteps
Other things to do
Install web server scripts
Scheduling the batch jobs
Your own scheduled tasks
Directory security
HowToUpgradeGem
GEM BATCH JOBS
GuideToGemBatchJobs
SummaryOfBatchJobs
Survey Scripts
MaintenancePlanJobs
ConsoleBatchJobs
ConsoleBatchReports
NormalJobs
Log File Monitors
TheWin32BackupCrosscheckProcess
GEM SCREEN SHOTS
GemScreenshots
Document purpose
Eventviewer.pl
Monitor.pl
GEM FAQ
FrequentlyAskedQuestions
ProcessNotes
GEM USER INTERFACE
gem.pl
configure.pl
Important notes
How to run configure.pl
The welcome tab
The paths tab
The servers tab
The files tab
The backups tab
The console tab
The alarms tab
The install software tab
The post install tasks tab
The scheduler tab
troubleshoot.pl
monitor.pl
eventviewer.pl
WEB USER INTERFACE
mimi.pl
webgem.pl
SERVER MAINTENANCE OVERVIEW
Server maintenance scripts
Package overview
Features
How it works
Installation
Where to install
Restrictions
Disaster recovery
Source directory layout
Target directory layout
Rights and redistribution
Security
The password files
Configure.cfg
Plan variables
Remote purging and compression
Setting up your crontab
Error handling
Frequently asked questions
Integration with gem
Menu.pl / cgi.pl
Sample configuration directives
SERVER MAINTENANCE SCRIPTS
backup.pl
config report.pl
dbcc checktable.pl
dbcc db.pl
dump database.pl
fix logship.pl
get latest filedate.pl
kill users db.pl
load all tranlogs.pl
load database.pl
rebuild.pl
rebuild index.pl
reorg sybase.pl
set dboption.pl
show configvars.pl
Stop Sybase.pl
update stats.pl
SYSTEM MONITORS
CheckServer.pl
CheckServerDaily.pl
CleanupFiles.pl
MlpEvent.pl
Heartbeat.pl
Mlpalarmcleanupdb.pl
MlpAlarmRoutingAgent.pl
RunMimiReport.pl
SybRepMonitor.pl
check sybase num users.pl
CheckSybaseReplication.pl
cisco logmon.pl
dfstats.pl
cisco logmon.pl
port monitor.pl
tracert.pl
unix monitor.pl
GEM Console Overview
TheGemConsoleGuide
ConsoleArchitecture
CustomizingReports
ExternallyAssembledReports
AListOfConsoleReports
ConsoleAssembledReports
The gem.xml Database
Information Collected
Cron
PreBuiltMonitoringSystemReports
StandardReportsProvdiedWithGem
GemAlarmContainers
The GEM Console
OneQueryPerServerReport.pl
console build and ftp.pl
console hourly.pl
console nightly.pl
console weekly.pl
console hourly.pl
console nightly.pl
console weekly.pl
core dump checker.pl
discover.pl
document all.pl
findid.pl
ftp to website.pl
gem file manager.pl
interfaces file rpt.pl
space errors.pl
space monitor.pl
space report.pl
unix space monitor via rsh.pl
Extended Proc Overview
Stored procedure library
Installation
Special thanks
Right to use, resale and copyright
Uninstall
Warranty
List of procedures
New System Procedures
Auditing error codes
sp auditdb
sp auditsecurity
sp badindex
sp bcp
sp block
sp checkkey
sp colconflict
sp collist
sp colnull
sp configure
sp date
sp datediff
sp dbspace
sp dbuse
sp depends
sp diskdevice
sp dumpdevice
sp find missing index
sp flowchart
sp grep
sp groupprotect
sp help
sp helpcolumn
sp helpdb
sp helpdbdev
sp helpdefault
sp helpdevice
sp helpgroup
sp helpindex
sp helplogin
sp helpmirror
sp helpobject
sp helpproc
sp helprotect
sp helprule
sp helpsegment
sp helptable
sp helptext
sp helptrigger
sp helptype
sp helpuser
sp helpview
sp id
sp indexspace
sp iostat
sp isactive
sp lock
sp lockt
sp ls
sp noindex
sp objprotect
sp proclib version
sp qspace
sp quickstats
sp read write
sp revalias
sp revbindings
sp revdb
sp revdevice
sp revgroup
sp revindex
sp revkey
sp revlogin
sp revmirror
sp revrole
sp revrule
sp revsegment
sp revtable
sp revtype
sp revuser
sp segment
sp server
sp size
sp stat
sp syntax
sp trigger
sp uptime
sp vdevno
sp who
sp whoactive
sp whodo
sp whoe
MDA Procedures
sp monbackup
sp moncache
sp mondump
sp monengine
sp monio
sp monlock
sp monlocksql
sp monnet
sp monobj
sp monopenobj
sp monpwaits
sp monrunning
sp monserver
sp monspid
sp monsql
sp montableusage
sp montopn
sp monunusedindex
sp monusedtables
sp monwaits
NAVIGATION
Document Navigation
GEM UTILITIES INTRO
DatabaseUtilitiesToolkit
Description
On line documentation
Supported systems
System requirements
Html
Notes
GEM UTILITIES
Backup Crosscheck Report.pl
Backup crosscheck procedures
monitor tables.pl
ConsoleArchiver.pl
Getsybmdasqltext.pl
HistServerMonitor.pl
Logship Server Checkup.pl
Mssql Backup Crosscheck.pl
Mssql Backup Crosscheck.pl
runquery.pl
UpdateBackupStateStaticInfo.pl
Updatebackupstatestaticinfo.pl
adduser.pl
alldb.pl
allsrv.pl
allsrv query.pl
allsrv query long.pl
Synopsis
audit fetch.pl
bcp out.pl
bcp in.pl
bcp out.pl
bcp out.pl
check app cksum.pl
clean ctrl char.pl
clean ctrl M.pl
brdcst interfaces.pl
copy db.pl
copy statistics.pl
copy syslogins.pl
crdate report.pl
create dflt groups.pl
create ins script.pl
crosstab.pl
custom rpt.pl
cvt table to view.pl
data mine.pl
data mover.pl
datacompare.pl
dbcompare.pl
dbschema
Readme
Description
Prerequisites
Corequisites
debug one server.pl
delete db.pl
depends analyze.pl
depends get.pl
do release.pl
document db.pl
drop all objects.pl
dump sybase mon tables.pl
dump sybase rep server.pl
extract ddl.pl
file loader.pl
fix db.pl
full analysis.pl
get comments.pl
get interfaces.pl
kill pid.pl
log file filter.pl
monitor a table.pl
monitor errors.pl
monitor user.pl
mssql attachscript.pl
mssql cycle eventlog.pl
mssql datapath report.pl
mssql gem setup report.pl
mssql jobstatus rpt.pl
mssql logmaintplan.pl
mssql scheduled job rpt.pl
mssql shrinklogs.pl
optdiag analyze.pl
parse a file.pl
parse hosts.pl
passwd rpt.pl
ping server.pl
process statistics.pl
purge unix files.pl
purge old win32 files.pl
query compare.pl
rebuild.pl
readate.pl
reperl.pl
replicator.pl
rev db.pl
sample db script.pl
setup.pl
showplan analyze.pl
size monitor.pl
sysmon analysis.pl
ThresholdManager.pl
trunctate db.pl
win32 backupreport.pl
win32 diskspace.pl
win32 eventlog.pl
win32 get file.pl
win32 ipconfig report.pl
win32 service.pl
win32 shutdown.pl
win32 system report.pl
GEM LIBRARIES
CommonFunc.pm
CommonHeader.pm
ConnectionManager.pm
Dbifunc.pm
Do Time.pm
Doc.pm
GemData.pm
Gem.xml data format
LogFunc.pm
Logger.pm
MlpAlarm.pm
Monitoring api
Monitoring reporting
Monitoring coding
Monitoring notes
==> Index
Name
Usage
Synopsis
Top Of File
Bottom Of File
Other Functions
Plugin Builtin Functions
Item New 2d Called By Pluginmanager
Item Initialize 2d Called By Pluginmanager
Plugin Utility Functions
Item Refresh Tree
Item Messagebox
Item Dialogbox
Item Make Button
Item 2dwidget 3d 3e 24frame
Item 2dtext 3d 3e 24bstr
Item 2dhelp 3d 3e 24help String
Item 2dcommand 3d 3e 24func
Item Clear Tab
Item Global Data
Item Show Html
Item Unimplemented
Item Write Xmldata
Item Get Last Event Info
Item Ignore Events
Item Browse
Item Get Config
Print Functions
Item Statusmsg
Item Notifymsg
Item Debugmsg
Plugin Callbacks
Item Init
Item Event Handler
Item Getmenuitems
Item Getpluginpanes
Item Menuclick
Item Gettreecolorfunc
Item Gettreeitems
Item Getbitmaps
Item Bitmapclick
Item Gettreertclk
Item Rtclick
Plugin Documentation
Event Functions
Fixed Reactions
Plugin.pm
PluginManager.pm
Repository.pm
RosettaStone.pm
RunCommand.pm
UpdFunc.pm
Win32Scheduler.pm
Doc.pm
eventviewer.pl
GEM ALARM ERRORS
ConsoleErrorGuide
What to do whith console errors