Icon of program: db2Gdba97 for IBM DB2 LUW

db2Gdba97 for IBM DB2 LUW for Windows

Download now

Used db2Gdba97 for IBM DB2 LUW for Windows?

Editors’ Review

Download.com staff
db2Gdba is a Windows utility for DB2 LUW management, offering real-time monitoring and metadata overviews in a tabbed interface for quick insights.

Top Recommended Alternative

Enlarged image for db2Gdba97 for IBM DB2 LUW
db2Gdba97 for IBM DB2 LUW 0/10

  • Pros

    • Tabbed interface for at-a-glance database object visibility
    • Quickly finds and illustrates properties of any database object
    • Displays real-time status for selected database objects
    • Supports multi-partitioned databases and data warehouses
    • Detects data skew at table and tablespace levels

  • Cons

    • Windows user interface only
    • No mention of cloud database support
    • Specific performance metrics not detailed
    • No built-in query tuning recommendations
Icon of program: db2Gdba97 for IBM DB2 LUW

db2Gdba97 for IBM DB2 LUW for Windows

Download now

Used db2Gdba97 for IBM DB2 LUW for Windows?

Explore More

Full Specifications

GENERAL
Release
Latest update
Version
3.1
OPERATING SYSTEMS
Platform
Windows
Operating System
  • Windows 8
  • Windows 7
  • Windows XP
  • Windows 10
  • Windows Vista
  • Windows 2003
  • Windows 2000
  • Windows Server
Additional Requirements
Requires IBM DB2 runtime client v. 9.7
POPULARITY
Total Downloads
157
Downloads Last Week
15
Report Software

Program available in other languages

Last Updated

User Reviews

5/5

1 User Votes

Developer’s Description

By Graphic Database Tools
Manage db2 LUW databases with all monitoring and metadata information at a glance.
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.
Download.com
Your review for db2Gdba97 for IBM DB2 LUW