Z/OS Basics 4

Running headRUNNING HEAD : Tools in DB2

Different Types of Tools Available in DB2

Name

Course

College

Tutor

Date

The tools available in DB2 can be classified into six main categories These include : command line tools , development tools , General administrative tools , information , monitoring tools and set up tools Below is a detailed of each

Command Line Tools

Using these tools , a user can give DB2 commands as well as SQL statements using the command line interface . This interface may be

Command Line Processor (CLP )-This can be

found on all platforms . It is not specific

Command Window-This is found on windows operating system . Other operating systems like Linux do not support it

Command editor tool whose functions are similar to those of text-based tools

Development Tools

These are used by developers when dealing with procedures as well as the user defined functions . Using these tools , they can test the previously stored procedures . This is done by use of the development center tool Developers can also move their projects to a different database using the project deployment tool Raul Chong (undated

General Administrative Tools

These are used for the centralized management of servers and databases They include

Control Center-These tool controls operations such as creation , making changes and also deletion of database objects . It is supported by almost all platforms

Journal-It is used as a tracking tool in the system . All problems are detected using this tool . It is also its role to detect error messages and any executed tasks

Replication...