|
|
 |
|
Mainframe software directory - DB2 |
|
|
|
|
|
|
|
DB2 Software |
|
|
|
|
|
|
|
|
SQL-ADMIN
Company: XTSoft
Managing the DB2 server is not an easy task. Only the SHOW commands indicate the real status of the server ( SQL-ACTIVITY and Database configuration). Incidents like DBSPACE FULL, STORPOOL FULL, LOG FULL... ...) may be avoided if proper monitoring of the base is carried out. SQL-ADMIN displays a synthetic screen of the percentage occupancy for each sensitive parameter of the server. A major problem of relational data administrators is the control of LOCK situations.SQL-ADMIN, thanks to the display of contention LOCK, identifies quickly users waiting to access resources, users blocking the resources and the resources concerned.
SQL-EDITOR
Company: XTSoft
The SQL-EDITOR software allows you to edit, ON-LINE, the contents of a table, by keying in only its name (no command is necessary).
SQL-MANAGER
Company: XTSoft
Modify the structure of an SQL database.After its creation, a database will increase its data volume and applications, thus risking deterioration in performance level (due to a lack of disk space, poor distribution of disk drives...). Therefore it becomes necessary to modify the database design.This modification can be partial (modification of tables, dbspace, pools, addition or deletion of columns...) or global. In this case, it is necessary to carry out a long and fastidious inventory.SQL-MANAGER will perform the following tasks : :In the case of a partial modification, SQL-MANAGER proposes an editor which will make the ON-LINE modifications easily and quickly. The MODIFY function of the SQL-MANAGER enables the modifications to be recorded in BATCH.In the case of global reorganization of database, SQL-MANAGER puts at your disposal an interactive draw tool and an ON LINE editor. It is possible to manage the location of the disks and tables using the draw tool.Using the ON-LINE editor, it is possible to prepare the dbspaces and tables for BATCH processing which re-design the base.
SQL-QUERY
Company: XTSoft
Enable the user to carry out queries himself.
SQL-REORG
Company: XTSoft
An efficient reorganization should contain the following stages :UNLOAD DBSPACE, Inventory of the whole environment (long and tedious), DROP DBSPACE, ACQUIRE DBSPACE PCTFREE=xx, Reload the tables, Re-create the environment. This procedure must be repeated for each dbspace. It provides high quality performance but it is, nevertheless a very tedious operation.SQL-REORG performs all the above steps automatically.
SQL-TRANSPARENCY
Company: XTSoft
SQL-TRANSPARENCY facilitates migration to DB2 by ensuring VSAM passage to Relational without modifying the existing application program.
SQL-TUNE
Company: XTSoft
Optimize the response time. Performance problems, which are relatively frequent in the environment of relational databases, are mostly due to the actual writing of the SQL orders.In order to optimize response time, it is important almost systematically to modify the input.
System Performance for DB2
Company: BMC
Lets you tune your DB2 system so that applications run more quickly and efficiently, allowing you to reduce customer wait times and increase customer satisfaction levels. This product also lets you dynamically tune your DB2 system as workloads change, delivering more consistent performance and staff productivity, even while you are planning for future growth and capacity.
TestBase
Company: SoftBase
Test critical DB2 applications faster, better, and safer with TestBase. This completely integrated DB2 testing workbench allows you to quickly extract realistic test data in convenient quantities and to then provide "Self Service" data to all application testors. TestBase also will secure ALL sensitive or confidential data in your DB2 testing environment.
Toad™ for IBM DB2®
Company: QUEST Software
Toad™ for DB2 simplifies database development and allows database developers to be more productive by providing an intuitive graphical user interface to DB2 for Linux, Unix, Windows and z/OS. With Toad, developers can use a single, industry-proven tool for both development and DB2 object management.
TUC4DB2 - Total Utility Control for DB2 z/OS
Company: UBS Hainer
TUC4DB2 - Total Utility Control for DB2 z/OS RTS & Policy driven Automation of DB2 maintenance: COPY, REORG, CHECK ...
VS/2
Company: Circle Computer Group
VS/2 is a data migration and application transparency solution that enables the rapid migration of data from VSAM to DB2® without application changes. VS/2 helps customers overcome the limitations imposed by VSAM and benefit from the rich features provided by DB2.
VSAM2DB2
Company: XTSoft
VSAM2DB2 converts VSAM files to DB2 tables
XM4DB2
Company: UBS Hainer
A Health Checker for DB2. XM4DB2 offers ongoing inspection for mission critical DB2 subsystems. Working in the background the tool permanently checks for availability of DB2 objects and operational readiness of utilities, plans and packages. It anticipatory detects and signals impending space shortage of tablespaces and indexspaces. The tool maintains and displays a table of current 'exceptions' and alerts database and system administrators about urgent matters by email. It offers a function to automatically repair standard situations.
|
|
|
|
|
|
|
|
|
|
|
|
