|
|
 |
|
Mainframe software directory - XTSoft |
|
|
|
|
|
|
|
XTSoft Mainframe Software |
|
|
|
|
|
|
|
|
BACKSTORE
Category: DB2
BACKSTORE is usually used to archive databases in the event of an incident on one of these bases which requires restoring. The BACKUP function enables the whole database to be archived on a tape, disk or both supports simultaneously. A report giving a list of all the tables to be reloaded is also edited.
SQL REPORTER
Category: DB2
SQL REPORTER is a non-procedure - oriented tool enabling the creation or the quick modification of all sorts of reports from data in SQL tables.
SQL-ADMIN
Category: DB2
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
Category: DB2
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
Category: DB2
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
Category: DB2
Enable the user to carry out queries himself.
SQL-REORG
Category: DB2
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
Category: DB2
SQL-TRANSPARENCY facilitates migration to DB2 by ensuring VSAM passage to Relational without modifying the existing application program.
SQL-TUNE
Category: DB2
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.
VSAM2DB2
Category: DB2
VSAM2DB2 converts VSAM files to DB2 tables
|
|
|
|
|
|
|
|
|
|
|
|
