databaseEZ | Built-in specialized database tools | Ytria

Built-in specialized database tools

On its own, the data scanning and display engine behind databaseEZ, the flexYgrid, lets you work with your IBM Notes data through a perspective that just isn't possible with the native toolkit.

But beyond the numerous advantages working with your data in this way presents, databaseEZ also gives you access to a range of powerful built-in tools that take the guesswork and puzzling out of time-consuming, complex tasks.

Even beyond the advanced mechanics of the flexYgrid, databaseEZ offers plenty of task-specific tools.

Build a solid audit trail with user activity

Build a solid audit trail with user activity

Audit an entire server's usage activity for a detailed, multi-angle portrait of database usage trends.

Work with Replica and Database IDs

Work with Replica and Database IDs

Handle Replica IDs and Database IDs in all-new ways not possible in the traditional Notes toolkit.

Solve storage and performance problems

Solve storage and performance problems

Get to the bottom of difficult-to-spot storage and server performance problems through a powerful view and folder index tool.

Troubleshoot databases

Troubleshoot databases

Diagnose common, dangerous database problems across an entire server in only a few clicks.

Work with console commands

Work with console commands

Launch console commands, foolproof command line instructions, and more through a dedicated console command interface.

User Activity as a Thorough Audit Trail

Build a solid audit trail with user activity

Traditionally, exploring recorded database user activity data requires a "one-at-a-time" approach. This can bring some clarity when it comes to individual databases, but overall trends remain in the dark due to the time factor and the lack of practical reporting capabilities.

databaseEZ includes a special built-in tool—the User Activity Analyzer—that lets you parse and display detailed recorded user activity information for multiple databases on a server all in one central interface.

Display detailed user activity data for all databases across an entire server.

Target usage times to see who did what

Identify users who have accessed given databases during a specific time frame, and see what types of actions they took.

Make detailed usage reports

Easily create detailed usage activity reports based on a summary or average of read, write, update or delete actions per database or user.

Rank databases based on usage

Find the most and least frequently used databases on a server using a special usage grading system.

Isolate only usage that matters

Track the usage of the users that matter: easily weed out server, agent signer, or administrator usage to focus on what’s important.

Set user activity recording en-masse

Enable/disable user activity, or mark it as confidential across multiple—even all—databases on a server.

Put recorded user activity to work for you thanks to a powerful usage analysis tool

databaseEZ's User Activity Analyzer tool
Use #16

Quickly identify your most and least frequently used applications across an entire server.

databaseEZ lets you access and analyze recorded database usage activity across multiple databases on a server. But how do you translate this data into application usage frequency? Because recorded usage activity is strictly limited to 1400 entries, there 3 hours for some heavily used apps, while it might even be years for others. And thanks to versatile analysis capabilities, it's easy to get a handle on usage frequency patterns for all of your databases.

Use #37

Put recorded database usage activity to work for the full story about global usage patterns.

Recorded database usage activity is a very rich source of data—if you can get to it. databaseEZ's User Activity Analyzer gives you access to more than what you see in your native clients, allowing you to get specific counts for reads, writes, updates, and deletes. What's more, your results are further separated into Data (documents) and Non-Data (designs, ACLs, etc.) counts so you can easily create a variety of usage reports, such as average reads per application or user, to better understand your global usage patterns.

databaseEZ's User Activity panel showing the various types of recorded user activity for multiple users on multiple databases
Easy Replica ID and Database ID Management

Work with Replica and Database IDs

Traditionally, Database IDs and Replica IDs have been a read-only attribute as far as the Notes Administrator client is concerned. If you've ever wanted to modify these IDs, you've undoubtedly come up against this blockage before.

databaseEZ lets you put these attributes to work for you in ways that were once impossible, by letting you modify their values either individually, or across several databases at the same time.

Handle Replica IDs and Database IDs through dedicated features, as well as an array of properties and settings that affect replication.

View and copy/paste any Replica ID or assign a Replica ID of your choice.

Create new random Replica IDs for multiple databases at once.

Generate multiple Database IDs simultaneously (when working locally).

Manage Database IDs and ReplicaIDs easily

databaseEZ's main grid with multiple databases selected and ready to use the 'Generate Replica ID' feature
Use #25

Quickly assign new Replica IDs to all standard IBM templates.

Changing the default Replica ID for IBM-shipped standard templates is considered a security best practice as it mitigates vulnerabilities from web crawlers using those Replica IDs. With databaseEZ you can isolate these templates on a sever and assign new Replica IDs to all of them in merely two clicks..

Use #12

Break or make replication connections between individual databases.

Whether you want to disconnect two replicas, or link up replication between database copies, databaseEZ makes it a breeze to work with these relationships.

databaseEZ's main grid with one database selected and ready to use the edit replica ID feature
Server-Wide Audits for View and Folder Indexes

Solve storage and performance problems

Server performance and storage space are closely interknit. With up to 95% of your allocated space possibly occupied by oversized view and folder indexes, not knowing the whole story can present major storage and performance problems. If your only analysis tool is the native Administrator client, an overall assessment is out of reach.

databaseEZ lets you get a thorough overview of the entire situation thanks to the ability to harness this data across multiple databases into one central interface—eliminating guess work and providing the starting point for analysis that just isn't possible in the native toolkit.

Obtain and analyze view and folder index information such as size and Discard/Refresh settings for multiple databases across an entire server, all at once.

Audit view indexes across entire servers

Quickly find the views and folders whose indexes take up the most storage space.

Purge indexes in only clicks

Purge multiple view indexes simultaneously in only a few clicks—even across multiple databases.

Audit refresh and discard settings

Establish a complete server-wide overview of index Refresh and Discard settings

Get a clearer picture of your views, at the server level

databaseEZ's View and Folder index size calculation grid showing view index sizes sorted by size
Use #31

Sort your databases by their overall index size information to find the heaviest databases.

Thanks to databaseEZ’s ability to parse view and folder index sizes from as many databases as you want on a server and the flexible data manipulation features, getting a clear, server-wide understanding of summarized index sizes is just a few clicks away.

Use #48

Locate unused views in just a couple of clicks.

Although ‘last used’ information isn’t available for views, databaseEZ gives you an easy workaround. In only a few quick steps, you can not only isolate views with discarded indexes, but also identify views not used in the past 45, 60 or 90 days.

databaseEZ's View and Folder index size grid showing databases categorized by their title and discard settings
Built-In Property Analyzer for Fast Database Diagnosis

Troubleshoot databases fast

It's one thing to analyze properties and settings on their own, but certain problems arise only when a combination of conditions exist. What's more, this type of analysis often requires multiple steps in order to confirm each point, as well as the foresight to determine where to start.

databaseEZ's Property Analyzer let's you scan an entire server and display databases that match tried and true property value combinations that present cause for investigation.

You can even configure the Property Analyzer to automatically scan any server you load.

Databases that have reached a user defined size

Databases with duplicate Replica IDs

Databases set to inherit from nonexistent templates

Databases with a given percentage of their size quota remaining

Templates with the same name

Databases where no documents have been modified since a given number of days

Databases where the design has not changed within a given number of days



Perform quick diagnostics on all databases across an entire server

databaseEZ's Property Analyzer tool
Use #9

Instantly spot common administration issues such as databases with low quota left, duplicate Replica IDs, and more.

Thanks to the built-in Property Analyzer, you can scan databases for a variety of common issues. What's more, the settings are configurable to let you scan servers on load by default; set it, forget it, and get full analysis results faster without the need to load your databases.

Direct Console Commands

Work with console commands directly

Thorough application of all the analysis options available in databaseEZ can uncover some deep-seated problems. But don't worry. Even if the issues you find require corrective actions on the server side, forget the long process of opening your console through the Administrator client; you can push commands to the console directly from within databaseEZ*.

*Proper console rights are required.

Invoke console commands to process multiple database, on the fly, directly from databaseEZ.

Send console commands directly

Send pre-set commands (such as Compact, Fixup, Updall, or DBMT) or create your own custom commands, along with any required switches, directly in the context of your analysis results.

Eliminate command flag guesswork

Build accurate commands fast with help from the inline Command Line Options Helper tool—no more time lost searching for switches!

Generate Domino Indirect (IND) files easily

Quickly generate Domino IND files to process multiple databases at once, in only a few clicks.

Work with console commands easily and directly from databaseEZ

databaseEZ's Console Command tool along with the Command Line Options Helper
Use #10

Quickly identify and fix all corrupted databases.

When loading full database information, databaseEZ automatically identifies any errors encountered when trying to open databases (such as "Consistency check is needed"). Thanks to the contextual console commands feature, you can simply select these databases and send the appropriate Fixup server console command to your server, all without needing to remember the database path or researching the needed switches.

Use #23

Identify and compact all databases with less than 95% space used.

Using databaseEZ’s unique ability to calculate Space Used percentages on the fly, you can quickly identify multiple databases in need of a compact. If a large number of databases are found, no problem. databaseEZ let's you export the databases into an IND file so you can process them all using a single Compact or DBMT console command thread.