When the new column is added, an additional toolbar for the change plan is automatically added to the Object List area as shown on Figure The timestamp of that which the plan is created is attached to the plan name on the toolbar by default. Objects that have pending changes are highlighted by an icon resembling the Greek letter delta. A pending change plan can be compared with the original object's definition from the context menu.
This feature is useful in many cases, such as deploying or synchronizing schemas across different databases. Additional options when comparing objects include generating difference report, impact analysis, filter configuration, etc. Figure After all object changes are completed, you can review and deploy these changes by clicking Review and Deploy Changes. A set of automatically generated commands will be listed. Users can edit these commands, run them immediately, or schedule as a job for later execution Figure To manage privileges, users can select Manage Privileges from the context menu of a database object.
As when altering an object definition, privileges can be directly edited using the Properties tab, which would be open by default. In Data Studio, we use the SQL Script Editor, which also offers development and debugging capabilities for database routines user-defined functions, triggers, and stored procedures. Better than Command Editor, the SQL Script Editor provides syntax highlighting, content assist, and several other well-integrated tools to facilitate database application development.
You can see that as the query is typed, the content assistant can be invoked to display a list of valid options to complete your SQL statement. In the SQL Script Editor, an integrated toolbar on the top provides convenient links to tools, such as:. There are four tabs at the upper half of the editor to allow users to configure how the SQL statements should be executed:.
Execution time, execution results, and past execution history are also available in the SQL Results tab Figure In addition, Data Studio provides a few more options to allow users to continue working on SQL results, such as display results in graphical Figure 23 or text mode Figure 24 , export results into different formats, filter the results, etc. Some useful keyboard shortcuts to use inside the SQL editor:. SQL scripts can be further refined using the options on the integrated toolbar Figure It can be invoked with the Start Tuning icon in the toolbar.
IBM Query Tuner provides a set of tuning tools for better understanding queries visually, and it can generate detailed statistics reports. Figure 26 shows a sample analysis of an SQL statement. Figure 27 shows a sample Query Tuner report that provides detailed information on the analyzed SQL statement and options for tuning its execution.
You can save your SQL scripts and graphs for later use by saving them into projects. Control Center provides users with Health Center, Task Center, and Journal to monitor database health and availability, and to manage jobs on DB2 databases. Data Studio offers the same functionality through the Data Studio web console component, which is a separate component of Data Studio, also free to download and use.
You can access the web console interface from inside Data Studio by right-clicking on a database connection in the Administration Explorer and selecting one of the Monitor options available. There are two main components in the Data Studio web console: the job manager and the health monitor. Figure 29 shows the job manager interface where four tabs are available:. With the Health Monitor, you can view database health information at several levels of detail: from a summary view of the overall health and availability of all your databases to the details of a particular problem on a specific database.
This article introduced Data Studio's capabilities and also related them to their counterpart in Control Center. This approach makes it easier for Control Center users to transition to Data Studio, as the article points out how to use Data Studio to perform the same functions users can find in Control Center. Moreover, the article explores the areas where Data Studio provides extra capabilities over Control Center.
The Data Studio V3. Visit the Data Studio V3. Learn more about Administering databases with task assistants. The DB2 V9. Explore Data Studio V3. Find technical documentation, how-to articles, education, downloads, product information, and more. Stay current with developerWorks technical events and webcasts.
Follow developerWorks on Twitter. Get products and technologies Build your next development project with IBM trial software , available for download directly from developerWorks. Now you can use DB2 for free. Discuss Participate in the discussion forum. Check out the developerWorks blogs and get involved in the developerWorks community. Etiquetas: database , db2. No hay comentarios:. Suscribirse a: Enviar comentarios Atom. Blogger Widgets.
IBM Data Studio. Task Center. Health Center. Optim Performance Manager. Object Tree. Administration Explorer view. Connect to databases and navigate through different database object types. Data Studio includes support for DB2 pureScale hosts. Content pane. Object List area. Lists database objects. In Data Studio, several tabs can be open simultaneously for different purposes. Content Details pane. Properties view. After selecting an object, its properties can be seen in this area. Again, Data Studio can have multiple tabs in this area for different purposes.
Backup Wizard. Restore Data Wizard. Configuration Advisor. Even though this personality suits the needs of many users, there will always be environments in which a user's particular needs cannot be fulfilled by this personality. In fact, even experienced DBAs might want a way to remove objects that are not used for example, the Nicknames folder is only needed if you are leveraging the DB2 federated capabilities.
In such cases, you need to be able to modify either the Basic or the Advanced pre-defined views and create your own customized views. The Custom option contains a checklist of the objects and pop-up actions that you can select from the Advanced personality. You can prune objects or actions that you do not need and, of course, you can always add them back in later.
To customize which objects will appear, and the actions that you can perform on them, select the Custom radio button, and click Modify. In the future, if you want to start the Control Center with your customized personality, you simply select the Custom radio button and click OK , or simply deselect the Show this window at startup time check box. Using a Custom personality, you can configure two levels of personalization.
You can customize actions on a selected object perhaps hiding some pop-up actions and displaying others , and folders again, hiding some, and showing others. When you select an object, the actions that you can perform on that object are listed in the right-hand side of the Customize Control Center View window, as shown in the next figure.
Note that there are usually two levels to a database object. For example, selecting the Tables folder gives you the opportunity to configure what actions would be surfaced in the Control Center for that folder; however, to configure the operations that a DBA could perform on individual tables, you would have to drill down through the Tables folder and select Table Objects as shown below :.
For example, in the previous figure, we configured the Control Center so that whenever it starts with a Custom personality, and you select a table object, you will only be able to open, query or copy that table through the Control Center:. The following figure compares the actions that you can perform on a table in the ACCPAC database, under each of the three personalities remember, the Basic personality does not show system tables : i. As you can see, Control Center personalities can be quite useful: They help novice users to interact with only the database objects that they know and understand, and they allow experienced users to prune out folders and actions that "get in the way.
In the last couple of months, we have been introducing you to many of the new features that are coming in DB2 UDB "Stinger. This window displays information about the selected object and the most common activities that can be performed on it.
The best way to learn a new technology is to work with it. Paul C. Paul has written numerous magazine articles and books about DB2. Roman B. Roman has written numerous DB2 books, articles, and other related materials.
The contents of this article represent those features that may or may not be available in the technology preview or beta. IBM reserves the right to include or exclude any functionality mentioned in this article for the "Stinger", or a subsequent release. As well, any performance claims made in this article are not official communications by IBM; rather the result observed by the authors is un-audited testing.
The views expressed in this article are those of the authors and not necessarily those of IBM Canada Ltd. Go to page: Prev 1 2. Search Search. Featured Database Articles DB2. Zikopoulos and Roman B. Melnyk Control Center Personalities In the previous section, we showed you how to start the Control Center with the personality that you want to use. Acceptable Use Policy.
0コメント