X
db2Gdba97 for IBM DB2 LUW logo

db2Gdba97 for IBM DB2 LUW

Developer's Description

db2Gdba is a windows user interface, designed and developed by production database administrators to manage, control, and monitor DB2 large and small database implementations. This lightweight utility presents both real time monitoring, and database metadata information in a window tab based interface, giving dba's and developers quick detailed overviews of what their systems are running, which users are connected, what statements are running, buffer pool performance, log utilization, locking applications, temporary tables, and other useful monitoring data. This utility finds and illustrates the properties of any database object quickly. Its tab base design makes any database object visibility at a glance, and makes the search of its properties a matter of one or two mouse clicks. By just selecting one or several objects, and clicking a button, this program displays the real time status corresponding to the type of the selected database object. For instance, after displaying a list of tablespaces (tab Tablespaces) searched under certain name criteria, the user can see their status, or see the disk-space metrics, or the size or tablespaces to include in the next full tablespace backup, or modify the user privileges on them. Likewise, having a list of tables displayed in the tab Tables, the user can choose to get the DDL for one or several tables at the same time, or modify user access, see the overall disk size utilization, display the range partition definitions, and other table characteristics. This application was designed for multi partitioned databases. For this reason, it's great when managing large db2 LUW data warehouse implementations. The user can search and investigate the behavior of the database objects at the database partition level. It includes functionality to detect data skew at the table level. Also, it has a tab to display a report illustrating potential disk space skew at the tablespace level, which in turn could be related to table data skew or other type of disk space usage irregularity. Using db2Gdba, any search regardless it's related to monitoring data or metadata information, is performed fast and easy. Senior db2 dba's love it because it speeds up their search and researches. Junior db2 dba's love it because it helps them to understand how the database is structured. Developers love it because they get DDL's quick and see how their statements performs after tuning their queries.

Full Specifications

What's new in version 3.1

General

Release April 25, 2014
Date Added April 25, 2014
Version 3.1

Operating Systems

Operating Systems Windows 2003, Windows Vista, Windows, Windows 2000, Windows 8, Windows Server 2008, Windows 7, Windows XP
Additional Requirements Requires IBM DB2 runtime client v. 9.7

Popularity

Total Downloads 135
Downloads Last Week 0
Report Software

Related Software

Microsoft Office Access 2010 logo

Microsoft Office Access 2010

Free to try
Microsoft Office Access 2010
CSV Viewer logo

CSV Viewer

Free
CSV Viewer
Inventory Management System for Small Business in Access Templates logo

Inventory Management System for Small Business in Access Templates

Free
Inventory Management System for Small Business in Access Templates
FileMaker Pro logo

FileMaker Pro

Free to try
FileMaker Pro

User Reviews

5/5
1 User Votes
5 Star
4 Star
3 Star
2 Star
1 Star
Promo image for CNET Shopping

Get the best price on everything

Shop your favorite products and we’ll find the best deal with a single click. Designed to make shopping easier.