Derby Database

Overview

This document describes how to collect JMX metrics exposed by the Apache Derby Database for long-term retention and monitoring with Axibase Time Series Database.

Requirements

  • Derby database 9+

Installation Procedure

Enable JMX in Java application

Configure Java applications for JMX monitoring according to JMX Job Documentation.

Import Derby Job into Axibase Collector

  • On the Jobs page, click Import and upload the derby-job.xml file.

Configure Derby JMX Connection

  • Open the Jobs menu and click JMX, then select the jmx-derby job.

  • For each JMX Configuration:

    • Provide connection parameters to the target Derby as displayed below:

    • Click Test and make sure that the result is similar to the screenshot:

Schedule the Job

  • Open the JMX Job page and click Run.
  • Make sure that the job status is COMPLETED and Items Read and Sent commands are greater than 0.

  • If there are no errors, set job status to Enabled and save the job.

Verify Metrics in ATSD

  • Log in to ATSD.
  • Click on Metrics tab and filter metrics by name jmx.derby*.

Viewing Data in ATSD

Metrics

Properties

Entity group

  • Open Settings menu and click Entity Groups, click Import, and upload derby_entity_group.xml.
  • Select the imported apache-derby-databases group.
  • Verify that the group contains your Derby hosts.

Entity Views

  • Open Entity Views page, click Import and upload derby_entity_view.xml
  • Select the imported Apache Derby Databases view.
  • Select the Entity Group that you created earlier.
  • Click View and browse information about existing entities:

Portal

  • Open the Portals page from the menu along the top of the interface, click Import from the split button, and upload derby_portal.xml.
  • Click the Assign link and associate the portal with the entity group created earlier.
  • Open Entity tabs, find the java application by name, and click the Portal icon.

Derby Live Portal