2.2.2 Development Toolsĭevelopment tools allow developers to easily write and test stored procedures and user-defined functions, as well as to deploy them to different databases. It also has the ability to invoke the Visual Explain tool, which shows the access path for the query.

The Command Editor is a graphical interface tool that provides the same functionality as the text-based tools-and more. The Command Window is available only on Windows, while the CLP is available on all other platforms. The two text-based interfaces are the Command Line Processor ( CLP) and the Command Window. The DB2 for LUW Audit Policy Editor closes.Figure 2.2 The IBM DB2 menus 2.2.1 Command Line ToolsĬommand line tools, as the name implies, allow you to issue DB2 commands and SQL statements from a command line interface.

(Optional) Click the Notes tab to view and edit user notes.(Optional) Click the UDP tab to work with user-defined properties for the object.(Optional) Click the Where Used tab to view where the object is used within the model.(Optional) Click the Comment tab and enter any comments that you want to associate with the object.Success - Only successful events are audited. None - No events in this category are audited. You can specify a status for each category as follows:īoth - Successful and failed events are audited.įailure - Only failed events are audited. Specify options for audit policy categories on the General tab.Specifies whether or not to generate DDL for this object during Forward Engineering. Normal - Errors generated by the audit are ignored and only SQLCODEs for the errors are returned.Īudit - All errors are returned. Specifies the error type: Normal or Audit. Use the Enter filter text text box to filter a large list of names to locate the one you want to work with. Note: Click New on the toolbar to create an audit policy. Select an audit policy and work with the following options:.The DB2 for LUW Audit Policy Editor opens. Right-click an Audit Policy in the Model Explorer and select Properties.Note: This topic applies to DB2 for LUW versions 9.5 and 9.7 only. You can create an audit policy to determine what categories you want to be audited you can apply the policy to other database objects monitor the use of those objects. Creating Models › Target Servers for Physical Models › Database Property Editors › DB2 LUW Property Editors › Support for Security Features in DB2 LUW › Define a DB2 LUW Audit Policy

Ca db2 tools manual