BMC Database Automation 20.19

This space contains information about the BMC Database Automation 20.19 product.

Use BMC Database Automation, a comprehensive software solution, to efficiently manage the complete database life cycle by automating recurring operational tasks such as provisioning, patching, and configuration management. BMC Database Automation eases transitions between database vendors and software upgrades, providing greater predictability and consistency across all database operations.

BMC Database Automation is designed to streamline the process of building, patching, and maintaining database environments.

Release notes Updated 22 Jan 2020

This section provides information about what is new or changed in this space, including urgent issues, documentation updates, and product updates.

Tip

To stay informed of changes to this space,place a watch on this page.

Date	Title	Summary
December 20, 2019	20-19-03-2019-Release-03	IBM DB2 11.5 (Enterprise Server Edition) is now supported REST API updates Updates to SQL Server patch package Updates to Oracle 19c media path PHP is upgraded to version 7.2.24 DISA compliances upgrades Security updates and fixes
August 21, 2019	20-19-02-2019-Release-02	Oracle 19c, Enterprise edition is now fully supported A new feature is added for scheduled Agent upgrade for all nodes REST API added for Node activities and Database provisioning functions Patching job improvements Show Patch List for Oracle databases Support for PostgreSQL version 11.2 PHP is upgraded to version 7.2.20 Updated CIS Compliances for MSSQL Security updates and fixes
April 18, 2019	20-19-01-2019-Release-01	BDA prerequisite updated to use Java OpenJDK 11 Support for Microsoft Windows Server 2019 Support for IBM DB2 11.1 (Enterprise Server Edition, Advanced Enterprise Server Edition and Advanced Workgroup Server Edition) Support for Windows Server Failover Clusters using PowerShell rather than cluster.exe Parallel patching job improvements for Oracle to start the related database even if patching fails Addressed security fixes for Third party software vulnerabilities Added security updates to gridapp.conf file Product versioning changed to use **year Release releaseNumber** convention

Tip

Ready-made PDFs are available on the PDFs-and-videos page. You can also create a custom PDF.

Click here to see the steps.

Some content is unavailable due to permissions.

Creating a custom PDF

Important

We are working to improve the PDF export experience. We are currently working on the following issues:

Page order—If you export more than one page to PDF, they might be displayed in alphabetical order instead of the order in the interface.
Interface update—The export interface options are changing, so these instructions might not match them exactly.
Known limitations—PDF exports are not always completed successfully.
Thank you for your patience.

If you are not logged in, click the head icon at the top-right of the window, select Log in, and follow the instructions:
Navigate to the page that you want to export to PDF. To create a PDF of the whole space, navigate to the space home page.
Next to the page title, click Export .
In the Export dialog box, click PDF:
In the Export as PDF dialog box, perform one of these steps:
- To create a PDF of that page only, proceed to step 6.
- To create a PDF of that page and its child pages, click select all.
- To create a PDF of that page and a selection of its child pages, select the checkboxes next to the pages that you want to include your PDF.
Click Export.
In the PDF Export Options dialog box, select the checkboxes for the features that you want to include in your PDF.
Tip
If you are creating a PDF of a single page, clear the Table of Contents checkbox.
Click Export.
The PDF is created.
Save the PDF locally.

Videos

The following topics contain videos that supplement or replace the text-based documentation:

FAQs and additional resources

This topic answers common questions and explains how to access additional resources, including BMC Support.

Frequently asked questions

This section answers frequently asked questions (FAQs) about the documentation portal.

How can I get a PDF of selected content in a space?

From the Tools menu in the upper-right, select Export to PDF.
Select the type of PDF that you want:

- Only this page for a PDF of the current page
- This page and its children for a PDF of the current page and all of its child topics

Depending on the number of topics included in the export, it might take several minutes to create the PDF. After the export is complete, you can download the PDF.

How do I upgrade BDA agents using the Command Line Interface?

Large BDA implementations might require the ability to upgrade multiple agents using the command line, rather than updating them one at a time using the Management Console. BDA enables you to upgrade agents via the command line while providing bulk upgrade capability.

Upgrading the Agent software using the command line

This section describes how to upgrade the BDA Agent software running on nodes using the command line on a node by node basis. The procedure can then be scripted to perform bulk upgrades.

For a summary view of agent version(s) running on nodes throughout your BDA environment, run the command below on the target manager to obtain detailed information about the agent(s): Parent, Node ID, Node IP, Host Name, Agent Version, and the agent's OS.

As the root user, run the following commands on the Manager (or, for a Multi-Manager environment, the Satellite Manager):
export LD_LIBRARY_PATH=/app/clarity/lib
/app/clarity/manager_scripts/bin/get_nodes.pl
An example of the information that is returned is shown in the screen capture below.
Still as root, place the version of the Agent media package that you want to install in the following location on the BDA Manager or Satellite Manager:
/app/clarity/var/agentupdates
Still as root, run the following manager script:
/app/clarity/manager_scripts/bin/update_node.pl <Node IP from get_nodes.pl command> /app/clarity/var/agentupdates/<agent_package_name>

A BDA Agent bulk update ZipKit for AIX, Linux, Sparc and Windows is available at https://communities.bmc.com/docs/DOC-36503.

Additional resources

The following BMC sites are external to this portal and provide information that you might find helpful:

Support information

This topic contains information about contacting BMC Support and determining support status for specific product versions.

How can I contact BMC Support?

If you have problems with or questions about a BMC product, or for the latest support policies, go to Support Central. You can search the Knowledge Base for help with an issue or download products and maintenance.

If you do not have access to the web and you are in the United States or Canada, contact BMC Support at 800 537 1813. Outside the United States or Canada, select your country at Contact BMC to view local Support Contacts.

How can I check a product version's support status?

You can find the support status for specific product versions on Support Central. Selecting a product from the “A–Z Supported Product List” shows:

All versions of the product and their current support levels (full or limited)
Dates on which support ends

You can also find information about the latest support policies on Support Central.

Getting started See more	Planning Deployment planning and system requirements See more Installing Installation, configuration, and maintenance See more Upgrading Upgrade paths and migration See more Configuring after installation Post-installation product configuration See more
Administering Security and system administration See more	Using Working with the product See more Developing Extending and customizing See more
Troubleshooting Common issues See more	Integrating Integrations with other product See more