by using the manage core device bar, that you could access a number of other graphical administration tools to support you manage and administer databases on your ambiance:
satellite Administration center — Used to control businesses of DB2 information servers through push/pull management scripts and more.
Command Editor — provides an interactive window that allows the building of SQL statements or DB2 instructions, the viewing of execution effects, and clarify information. This graphical command utility is regularly the favorite system for text instructions as it offers giant flexibility and performance.
task middle — Used to create, agenda, and manage scripts that may comprise SQL statements, DB2 commands, or operating techniques instructions.
Journal — continues a list of all script invocations, all DB2 messages, and the DB2 recovery history file for a database. it's used to demonstrate the results of a job, to display the contents of a script, and additionally to enable or disable scheduled jobs.
License middle — Used to manipulate licenses and examine how many connections are used.
DB2 net tools — makes it possible for the DBAs to use an HTTP customer to remotely execute SQL statements, DB2 commands, or working gadget instructions against a DB2 server. virtually, the health center and the Command Editor are uncovered during this tool set.
The DB2 health core (figure 1–19) is the significant point of information with appreciate to managing the health of your DB2 system. in case you install a DB2 9 statistics server, out of the field it immediately monitors 27 (and counting) health warning signs that proactively computer screen the fitness of your records server. The DB2 health middle implements a management-via-exception mannequin whereby signals are surfaced when Warning or Alarm thresholds are breached. however DB2 configures these thresholds for you out of the box, which you can configure them yourself as well as specify scripted actions to ensue in the adventure of an alert.
You do not need to make use of the DB2 fitness core to work with DB2's health suggestions or set prompted actions to turn up on threshold breaches. that you would be able to use a couple of SQL-based mostly consumer defined functions to work with the DB2 fitness facilities from the command line.
The DB2 health core can video display indications throughout the following health classes:
application concurrency (e.g., deadlock fee)
DBMS (e.g., instance operational state)
Database (e.g., Database operational state)
Logging (e.g., Log utilization)
reminiscence (e.g., computer screen heap utilization)
Sorting (e.g., percentage of sorts that overflowed)
desk area storage (e.g., desk space utilization)
Database preservation (e.g., Reorganization required)
high-Availability catastrophe healing (e.g., HADR log extend)
Federated (e.g., Nickname reputation)
equipment and catalog caches (e.g., package cache hit ratio)
figure 1–19The DB2 health center
The DB2 health center's graphical user interface enables DBAs to opt for database objects and drill down on its details, present indicators, and the informed moves. The DB2 fitness middle additionally contains the DB2 suggestion marketing consultant that can also be used to walk through potential fixes to alerts and alarms raised in this facility.DB2 Configuration Assistant
The DB2 Configuration Assistant (DB2 CA) means that you can maintain a listing of databases to which your applications can join, in addition to control and administer these connections. it is primarily used for customer connectivity configuration. you can start the DB2 CA via coming into the db2ca command out of your working equipment's command-line shell or from the DB2 folder within the delivery menu. one of the vital services available within the DB2 CA are proven in determine 1–20.
figure 1–20The DB2 Configuration Assistant
using the DB2 CA, which you can work with current databases, add new ones, bind functions, set customer configuration and registry parameters (additionally proven in figure 1–20), examine connectivity, and import and export configuration profiles.
The DB2 CA's graphical interface makes these complex projects easier by using potential of here:
Wizards that support you perform definite tasks
Dynamic fields which are activated in accordance with your enter selections
pointers that assist you make configuration decisions
the invention function, that may retrieve guidance it's well-known about databases that dwell to your community
The DB2 CA's Discovery feature is very valuable because it lets you add a database connection while not having to understand the syntax of DB2 CATALOG NODE and DB2 CATALOG DATABASE instructions, or even the vicinity suggestions of the faraway facts server.
As that you would be able to see in figure 1–20, the DB2 CA shows a listing of the databases to which your applications can join from the computer the place it changed into all started. every database is recognized first by means of its database alias, then by way of its name. that you may use the change Database Wizard to change the counsel associated with databases during this listing. The CA additionally has an superior view, which makes use of a notebook to organize connection information with the aid of here objects:Advisors and Wizards
DB2 comes with a set of Wizards and Advisors to aid you with day-to-day projects. Wizards may also be very advantageous to each novice and skilled DB2 clients. Wizards assist you complete selected tasks with the aid of taking you via each task one step at a time and recommending settings where applicable. Wizards can be found through both the handle center and the Configuration Assistant.
There are wizards for adding a database to your gadget, creating a database, backing up and restoring a database, developing tables, growing table areas, configuring two-section commit environments, configuring database logging, updating your documentation, constructing a high-Availability catastrophe restoration (HADR) pair, tuning your efficiency, and extra.
determine 1–21 indicates a portion of the Create Database wizard in DB2 9.
figure 1–21The Create Database wizard
Advisors are special kinds of wizards that do greater than deliver tips in completing a task. normal wizards take you step-by way of-step via a task, simplifying the journey via asking essential questions or generating the complex command syntax for the motion you wish to operate. When a wizard has extra intelligence than simply assignment completion and may offer advisory-category functions, DB2 calls them advisors. They operate just like wizards but are clever ample (having some pretty advanced algorithms) to generate advice based on input components similar to workload or data. Advisors support you with greater complicated activities, equivalent to tuning initiatives, by using gathering suggestions and recommending alternate options that you simply might also not have considered. which you could then accept or reject the advisor's counsel. you can call advisors from context menus in the DB2 administration equipment, from APIs, and the command-line interface.
Advisors are a part of the IBM autonomic computing effort, which aims to make application and hardware extra smart (self-managing and aid tuning). There are three main advisors in DB2 9: the DB2 Configuration consultant, the DB2 advice advisor, and the DB2 Design marketing consultant.
The DB2 Configuration marketing consultant is automatically run for you each time you create a new database in DB2 9. it can configure up to 35 illustration-stage and database-level parameters for you based on responses to excessive-stage questions that describe the information server ambiance and sort of software you propose to support.
The DB2 recommendation guide, as previously mentioned, is closely associated with the DB2 health middle and is used to present solutions to better alerts and alarm breeches in this facility.
The DB2 Design marketing consultant is used to establish objects equivalent to materialized query tables (MQTs), multidimensional clustering tables (MDCs), indexes, and partitioning keys that may optimize a given SQL workload. The DB2 Design advisor can additionally determine indexes that don't seem to be essential as well (shown in figure 1–22).
determine 1–22The DB2 Design marketing consultant
When the use of this guide or not it's vital to note that the advice it offers are according to a submitted workload. in case you've omitted giant portions of a workload, the answer will not reflect the influence of the lacking workload. moreover, the DB2 Design consultant gives you the potential to closely weight SQL statements in a submitted workload over others, providing you with extra control with admire to how the DB2 Design marketing consultant will suggest the advent of performance objects with respect to your real workload characteristics.