Help link
is a context-sensitive link to this Help topic.
The
symbol appears in many locations, all of them links to various Help topics in this frame.
Help for Foxhound 1.3738b
Table of Contents [RisingRoad]
The main "Foxhound for SQL Anywhere" page is called the Foxhound Menu because it lets you choose which target database you want to work with.
Every page has a menu line, even the Foxhound Menu :)
The New Menu link opens the Foxhound Menu page in a new browser window or tab. This link appears on every Foxhound page to make it easy to look at multiple databases at the same time.
The Foxhound Options link opens the Foxhound Options page in a new browser window or tab.
The
Help link
is a context-sensitive link to this Help topic.
The
symbol appears in many locations, all of them links to various Help topics in this frame.
The About link opens the About Foxhound page in a new browser window or tab.
The button hides this Help frame from view, and brings it back.
Tip: To hide the Help for every new page, see the button on the Foxhound Options page.
The DSN tab lets you pick a target database by using an ODBC Data Source.
If you don't have a DSN, and you don't want to create one, try using the String tab instead.
The Choose a DSN: drop-down list lets you pick which DSN you want from all the User and System DSNs recorded in the Windows registry.
The User Id: and Password: fields are optional; you don't need to fill them in if values are stored in the DSN itself.
Check Include system tables if you want the Display Schema page to include the SQL Anywhere catalog tables and views; e.g., ISYSTAB and SYSTABLE.
The button connects to the target database and opens the Display Schema page in the current browser window or tab.
The button opens the Monitor Database page in the current browser window or tab. If a sampling session already exists for this DSN, sample data from that session will be displayed. If not, Foxhound will start a new sampling session and display that data.
The button tells Foxhound to include non-SQL Anywhere DSNs in the Choose a DSN: drop-down, and excludes them again.
The button starts the Windows ODBC Data Source Administrator program so you can edit and create DSNs. This button is disabled if the Foxhound engine is not running locally; Foxhound can only use the ODBC DSNs that are stored on the same machine that's running the Foxhound engine, so that's where you have to go to run the ODBC Administrator.
The String tab lets you pick a target database by specifying the SQL Anywhere connection string. Foxhound always uses ODBC to connect to the target database, but that doesn't mean you need to create a DSN, and this tab makes a DSN-less connection possible.
... but, if you always use DSNs to connect to your database, you probably don't need to use the String tab at all.
The Choose a connection string: drop-down list lets you pick which connection string you want to use. Connections strings are stored in the Foxhound database, and several samples are delivered in the initial setup.
The Enter or edit the connection string... box lets you create, edit and delete your connection strings.
The Name: field lets you specify a name to uniquely identify this connection string in the Foxhound database. Connection string names are separate from DSN names so you can use the same names if you want.
The String: field lets you fill in the connection parameters.
The Clear link clears the Name: and String: fields.
The Show Examples link displays several examples of connection parameters, and Hide Examples hides them again. Click on an example to paste it into the String: field.
The button saves the String: field in the Foxhound database with Name: as the identifier. This will do an update or insert depending on whether Name: already exists or not.
The button deletes the connection string identified by Name: from the Foxhound database.
Tip: To rename an existing connection string, type the new Name and Save the string, then Choose and Delete the string with the old name.
The Password: field is optional; you don't need to fill it in if your connection string includes a value.
Check Include system tables if you want the Display Schema page to include the SQL Anywhere catalog tables and views; e.g., ISYSTAB and SYSTABLE.
The button connects to the target database and opens the Display Schema page in the current browser window or tab.
The button saves the connection string and then opens the Monitor Database page in the current browser window or tab. If a sampling session already exists for this connection string, sample data from that session will be displayed. If not, Foxhound will start a new sampling session and display that data.
The Monitor tab lists all the sampling sessions that have been created. When this tab is displayed, it is refreshed every 10 seconds with the most recent data. It is also refreshed whenever you switch to it from the DSN or String tab.
The button immediately updates the information displayed on this tab without waiting for the regular refresh.
The (number) in parentheses after the Refresh button tells you how many times this tab has been refreshed.
The Show Monitor... column displays the DSN: and String: names used to identify the sampling sessions. You can click on one of these links to open the Monitor Database page in a new browser window or tab.
If the GlobalDBId property is set to a non-default value, that value will be shown in (parentheses) after the name in the Show Monitor... column. This makes it easier to tell different remote databases apart in a replicating or synchronizing environment.
Each History link in the Show... column lets you open the History page in a new browser window or tab.
The Sampling column tells you whether the sampling session is Running or Stopped.
The Status column tells you if everything is OK with the sampling session, or what kind of problem occurred. A dash "-" is displayed when the session was stopped with the Stop button.
The Heartbeat column shows the elapsed time for the most recent "heartbeat" or "canarian" query SELECT * FROM DUMMY. This number should be very small, and is often displayed as 0s.
The button lets you stop the sampling session. This doesn't delete the session, it just suspends the sampling process.
The button may appear instead of Stop. The Cancel button lets you stop further attempts to start or re-start the sampling session. If Foxhound can't connect to the target database, it will keep trying forever, unless you press Cancel or the connection timeout period is exceeded. See the Foxhound Options page for more information on connection timeouts.
The button tells Foxhound to try to start the sampling session.
The button will delete the sampling session. This takes effect immediately, and is permanent; the sample data is no longer available for display. Also see the Foxhound Options page for more information on purging old sample data.
Note: The phrase "is permanent" means there is no "cancel" or "undo" facility. It doesn't mean you can't ever gather samples for this database again; you just have click on the Monitor Database button to start another sample session.
Each sampling session will have a corresponding Recent History... list showing Alerts and All Clear messages in reverse order by date and time (most recent first). For each Alert number (#1, #2, etc.) at most two entries will be shown: most recent Alert and most recent All Clear for that number.
[Top]
[Top]