IBM Licensed Programs: Database Products
554 AS/400e System Handbook
Enterprise benefits:
QMF for Windows is built for the networked enterprise with the understanding of the need to
connect and protect your data sources. QMF for Windows is a unique Windows querying tool,
providing:
• Top performance
• Extensive control
• Features for optimizing access to large databases
Governor settings are controlled from the QMF for Windows Administrator, which is included
with the product. It is easy to add to the list of servers available to users, bind database
packages, grant authority, and administer resource limits by groups and schedules. This
gives you control over user actions and resource consumption that can automatically change
by day-of-week and by time-of-day.
In addition, QMF for Windows allows the specification of whether it will track usage and
execution of QMF for Windows objects.
Now the enterprise can:
• Centralize control over server resources
• Eliminate runaway queries
• Eliminate extended open cursors
• Track user access to queries
• Maintain full security, standard authorizations
• Exploit DB2 performance, system integrity
• Support a variety of DB2 database servers
Centralized installation options:
Administrators can centralize the installation, configuration, and day-to-day client operation of
QMF for Windows by opting to contain configuration settings (Server Definition Files (SDFs)),
pre-configured client installation packages, or the QMF for Windows product itself on a
networked Windows NT server. This allows each user to run the product from the server,
have their own SDF or you can create a single SDF that is shared by multiple users over a
file-sharing network.
The advantage to these approaches is that they dramatically reduce the installation and
configuration of individual client PCs, reduce the total cost of ownership, and allow for a “thin
client” installation at each Windows workstation wherever desired.
Connectivity:
QMF for Windows V7 implements distributed relational database architecture (DRDA) and
provides native support for TCP/IP connectivity to DB2 for AS/400 V4R3 (or later). For