by XTIVIA | Jan 9, 2019 | Blog, Db2
While implementing HADR for multiple standbys, there could be potential issues if the HADR ports are not hard-coded on the HADR settings. Here’s what the issue looks like: The primary is dbpp.example.com The standbys are: 1st – dbps.example.com 2nd –...
by Tony Salerno | Oct 18, 2018 | Blog, Database
This series is designed to be a database reference guide, covering databases from the very beginning. We’re calling it Database 101. There will be eight sections in this series. Part 1: Database Glossary of Terms Let’s start with some background for people...
by XTIVIA | Apr 5, 2018 | Blog, Db2
My top metric for analyzing database performance is index read efficiency. This metric essentially shows how well indexed a database is for the workload that runs against it. Index read efficiency is calculated by taking the rows read and dividing them by the rows...
by XTIVIA | Mar 13, 2018 | Blog, Db2
What is Runstats? Runstats is a utility in Db2 that is used to collect statistics about the data in Db2 tables and indexes. This statistical information is critical to Db2 database performance. Runstats is executed on a table by table basis, so scripting it is quite...
by XTIVIA | Mar 7, 2017 | Blog, Db2
Most Db2 DBAs administer Db2 at the command line. The command line provides a rich and powerful interface with Db2, and has a lot of options. Many other users may wish to access Db2 at the command line as well. Developers and system administrators are just a few of...
