|
|
|
When you click an object in the Object Tree pane, the Detail Information Pane displays labeled tabs that provide attribute information. Additional tabs correspond to the child objects for the highlighted object in the Object Tree pane. Each tab provides a specific type of information about the object. Some tabs allow you to execute a CA IDMS utility on a selected database object. The different categories of information are listed as follows:
Displays information about Statistics objects, including Statistics Segments, Statistics Files, Statistics Areas, and Statistics Buffers. You can select any part of the bar diagram to display more detailed information.
Displays the instances of the selected child object class. The label of the tab always consists of an icon followed by the child object class (also called static object) name. The icon is the same used in the label of the object class in the tree and which is visible in front of the object names in the Detail Information Pane.
Note: For this type of tab, it is possible to double-click any instance of the child object in the Detail Information Pane. The tree automatically expands and the selected instance—which is now the current selected object—becomes visible in the tree window. These instances can also be selected for further Alter, Create, Drop, or drag-and-drop operations.
Displays a table where each rows represent a column of an SQL table and contains the name, the datatype, the nullability, and the default specification of the column.
Displays grantees, registrees, or responsibles for a privilege. The information is presented in table format with check marks for privilege types. The table can be sorted by column. Simply double-click the column to reorder the table. The tab is labeled either Grantee for, Registree for, or Responsible for followed by the privilege or privilege object. For example, Grantee for Table.
Displays a dialog with Update and Reset buttons, an input pane for editing a dictionary module, and a result pane to hold the status of the last Update execution.
Displays a table where each row represents a parameter of an SQL table procedure, procedure or function and contains the name, the type, the size, the default specification, and a test value for the parameter.
Displays information for Active Program or Active Storage object types. The pie chart relates the active usage to the available pool. When you click the pie slice representing actual usage, CA IDMS Visual DBA displays detailed statistics.
Displays privilege information granted for the Central User, Group, and Dictionary User object instances. The information is presented in table format with check marks for privilege types. The table can be sorted by column. You need to double-click the column to reorder the table.
Displays attribute information in the same format as the Alter dialog for the object type. If the Alter dialog has one or more subdialogs, then a separate property tab is displayed for each subdialog, with a tab name that is the same as the subdialog name.
Displays a table with Property and Value columns. The Property column displays the names of the attributes that exist for the object. The Value column displays the value of the attribute. You cannot alter the object values in the Raw Prop tab.
Displays a table with a column for each attribute. Each row displays the values for all attributes of one object instance.
Displays information for table-like objects. CA IDMS Visual DBA retrieves rows of information based on the Rows in Cache value that you have defined in the Command Console Dialog. When you scroll to the bottom row, CA IDMS Visual DBA moves the bottom half of the table rows (resulting from the last retrieval) to the top of the table, performs another retrieval, and displays half of the newly retrieved rows at the bottom of the table.
Allows you to view messages in the CA IDMS log that relate to selected CV objects. You can search within a specific time period and specify a filter so that only the messages you want are retrieved.
Displays a dialog with Update and Reset buttons, an input pane for editing the body of an SQL routine, and a result pane to hold the status of the last Update execution.
Displays the result of invoking an SQL-invoked function or procedure.
Instructs CA IDMS to walk an index and tune the index using the parameters specified in the dialog. One of the optimizations is the adoption of orphaned indexed records. By eliminating orphans, runtime database performance is improved when traversing from an indexed record to its associated index entry.
Allows you to view the structure of system-owned indexes and indexed sets. You can query the index based on a number of criteria, such as the segment, output, level, and so on.
Allows you to view the contents of database pages in decimal format, hexadecimal format, or both. You can request information for a specific CALC key, subarea, or page range.
| Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |