Overwhelmed by all of the onstat options? Need to find which commands work with ER and which work with HDR? With generous help from Tech Support, the ID team has produced an onstat Quick Reference Card and an onstat portal that lists onstat utility commands by functional category. Categories include:

Archive Information Options

Cache Information Options

Debugging Options

Enterprise Replication Options

High-Availability Replication Options

I/O Options

Locks and Latches Options

Logs Options

Memory Options

Other useful onstat Utility Options

Network Options

Performance Checks (First Tier)

Performance Checks (Second Tier)

Table Options

Thread Options

User/Session Options

Virtual Processor Options

Waiting Options

Each category represents a different IDS feature for which onstat commands provide troubleshooting and performance information. Commands that appear in bold typeface are especially useful for providing troubleshooting information. Certain onstat commands are specific to one category while others provide general information and are listed in more than one category. The card is designed as a double-sided trifold brochure and looks best when printed in color.

Introducing a new plug-in for OAT: theSchema Manager. Use this plug-infor a dashboard-like of view databases and tables on your IDS databaseserver. For databases, see stored procedures, functions, sequences,UDTs, privileges, DataBlades, aggregetes, casts, and opclasses from onesingle view. For tables, views, and synonyms, the Schema Manager showsyou information about its columns, indexes, references, constraints,privileges, UDTs, fragments, and triggers. The Schema Manager alsoprovides you with ability to drill-down on any of its pods for moredetailed information.

A demo of the new Schema Manager funcationality isavailable here. More enhancements to this plug-in will be coming soon, so staytuned!

Enterprise Replication Plug-in version 2.2

The Enterprise Replication plug-in administrationcapability has been expanded to allow the modification ofobjects:

Modify a replicate set by adding or deleting replicates

Modify a replicate set by changing the replication frequency for the replicates in the set