GEM Documentation Navigation Page. Documentation is also available at The GEM Home Page. Documentation and Code are both Copyright © 1995-2006 by Sql Technologies. All Rights are Reserved.

The Complete GEM Documentation	Slide Show: What Is GEM	Download GEM
An Introduction To GEM	How To Install	Getting Started Guide
Batch Jobs Overview	GEM Screenshots	Server Backup and Maintenance
Utilities Guide	The GEM Console	New System Stored Procedures
FAQ and Change Log	Common Perl Libraries	Pricing & Right To Use

Document purpose

This document will give screen shots of GEM.

Installing dbi & dbd libs on win32

Osql / Isql / Ping not in your path Not having any of these commands will cause an error on configure.pl startup. This is a non fatal error, but only if you are intentionally not using these features (ie. you are on win32 but do not want sql server support).

Initial Run of troubleshoot.pl

Initial Run of configure.pl

Normal configure.pl Startup

Configure.pl is the main program for installing the G.E.M.  It allows you to register your servers and provides a full interface to configuring the system.

$ perl configure.pl Generic Enterprise Manager Setup Driver

        Use 'perl configure.pl --DEBUG' to see diagnostic messages.
        Messages will be logged to configure.log

 Generic Enterprise Manager Configuration Utility
 Copyright (c) 1995-2005 by SQL Technologies
 Root Directory: W:/dev
 Installation Log File: W:/dev/logs/gamecomp_configure.log
 >> [configure] | Reading GEM Function Library
 >> [func]      | Reading Configuration Files - FULL
 >> [func]      | Reading XML Data - gem.xml
 >> [func]      | Parsing Key Values from xml
 >> [configure] | Application Version: Build 634 (Apr 10 2006)
 >> [configure] | Start Time: Mon Apr 10 22:29:34 2006
 >> [configure] | Configuration Files Loaded - initializing
 >> [connectmgr]| Initializing Connection Manager
 >> [connectmgr]| Loading DBI Drivers
 >> [connectmgr]| Done Initializing Connection Manager
 >> Initialization Completed - Starting Main TK Loop

Eventviewer.pl

The event viewer allows you to see the state of your systems all at once.  In normal operation, it provides you with timely information about problems in your environment.  It allows you to review errors and state that they are ok (for 24 hours – if the alarm is found after 24 hours, the message will reappear) or delete the message.  You can also filter the messages by source monitoring program, server, and severity.  You can set up groups of servers (like all your databases or all your windows boxes) and see messages just from them.

The examples on the following pagges show recent messages from a single production system.  Note that there are numerous messages but the system has filtered them down to a manageable number of alerst.

This information above is a subset of the messages stored for that system, which are more numerous and include a variety of event logs and monitoring messages. Here are two sample screens showing All the events and heartbeats for a production sql server.

Monitor.pl is your system monitor.  It provides easy navigation between databases and allows you to see a variety of performance reports at your fingertips.  The main power here is to see exactly what is going on in your servers.  Monitor.pl is a G.E.M. plugin and will be included in the final G.E.M. release.  

In addition