サポートと今すぐチャット
サポートとのチャット

Identity Manager 9.2.1 - Configuration Guide

About this guide One Identity Manager software architecture Customizing the One Identity Manager default configuration Customizing the One Identity Manager base configuration One Identity Manager schema basics
Overview of the One Identity Manager schema Table types and default columns in the One Identity Manager data model Notes on editing table definitions and column definitions Table definitions Column definitions Table relations Dynamic foreign key Supporting file groups
Editing the user interface
Object definitions for the user interface User interface navigation Forms for the user interface Statistics in One Identity Manager Extending the Launchpad Task definitions for the user interface Applications for configuring the user interface Icons and images for configuring the user interface Using predefined database queries
Localization in One Identity Manager Process orchestration in One Identity Manager
Mapping processes in One Identity Manager Setting up Job servers
The One Identity Manager Service functionality Tracking changes with process monitoring Conditional compilation using preprocessor conditions Scripts in One Identity Manager
Visual Basic .NET scripts usage Notes on message output Notes on using date values Tips for using PowerShell scripts Using dollar ($) notation Using base objects Calling functions Pre-scripts for use in processes and process steps Using session services Using #LD notation Script library Support for processing scripts in the Script Editor Creating and editing scripts in the Script Editor Copying scripts in the Script Editor Testing scripts in the Script Editor Testing script compilation in the Script Editor Overriding scripts Permissions for running scripts Editing and testing script code with the System Debugger Extended debugging in the Object Browser
One Identity Manager query language Reports in One Identity Manager Adding custom tables or columns to the One Identity Manager schema Web service integration One Identity Manager as SCIM 2.0 service provider Processing DBQueue tasks One Identity Manager Service configuration files

Reinitializing the DBQueue Processor

IMPORTANT: Select a user that you use for migrating the database to run the SQL queries.

  • You must run the QBM_PDBQueuePrepare procedure once manually when the server hardware has been extended and when custom DBQueue Processor tasks have been created.

  • You must run the QBM_PDBQueuePrepare and QBM_PWatchDogPrepare procedures once when you set up a reference database for test and development.

    Use a suitable program for running SQL queries to run the following procedures in the reference database just once.

    exec QBM_PWatchDogPrepare

    exec QBM_PDBQueuePrepare 0,1

Bulk processing in the DBQueue Processor

Table 186: Configuration parameter for bulk processing in the DBQueue Processor
Configuration parameter Meaning

QBM | DBQueue | DefaultRuntime

The configuration parameter species how the length of the DBQueue Processor run. The default value is 90 seconds.

QBM | DBQueue | ChangeLimitMin

The configuration parameter defines the lower limit for modifications (insert, change, or delete) within a single operation. The default value is 3000.

QBM | DBQueue | ChangeLimitMax

The configuration parameter defines the upper limit for modifications (insert, change, or delete) within a single operation. The default value is 50000.

Some DBQueue Processor procedures are marked for bulk processing to reduce the total time required for processing DBQueue tasks. If a lot of entries are marked for bulk processing in the DBQueue, the DBQueue Processor switches from single to bulk processing.

There is a mechanism implemented that is used to decide whether switching to bulk processing as opposed to single processing would result in time savings. To do this, 25 single task processes are run and the processing time is recorded. All other entries for the task are processed in bulk and the minimum and maximum load time required for advantageous bulk processing is defined. A self optimizing calculation procedure updates the load times. Use of this method means that the DBQueue Processor must first stabilize, especially after an initial schema installation or after system modifications such as memory expansion in the database server.

You can use the QBM | DBQueue | DefaultRuntime configuration parameter to specify the length of the DBQueue Processor run. The default value is 90 seconds. This corresponds to the time period that achieves the best load for the calculation procedure.

To prevent overloading when there is large amount of data, you can define limits for the result set. Control is realized using the QBM | DBQueue | ChangeLimitMin and QBM | DBQueue | ChangeLimitMax configuration parameters.

Processing DBQueue Processor tasks by the Database Agent Service

To process internal tasks by the Database Agent Service, ensure that the Database Agent Service is installed and configured. The Database Agent Service is deployed through the One Identity Manager Service plug-in. Alternatively, the Database Agent Service can be run from the DatabaseAgentServiceCmd.exe command line program. The plug-in should be configured on the Job server that performs the Update server server function. An administrative user must be used for the database connection in the Job provider.

The Database Agent Service carries out the following tasks:

  • Controls processing and distribution of the DBQueue tasks to the individual slots (central dispatcher))

  • Checks and starts scheduled tasks

  • Removes already processed DBQueue tasks

  • Starts maintenance work

  • Populates and updates the Job queue overview

  • Archives or deletes handled processes from the Job queue

  • Archives or deletes process handling logs

NOTE: If the Database Agent Service is not working, a message is displayed in the status bar in all the administration tools. To see this message, users must have at least the configuration user access level.

Related topics

Controlling processing of DBQueue Processor tasks

The central dispatcher assumes control of processing and distributes DBQueue tasks to individual slots.

First, it determines the number of currently available slots available for use. The more load there is on the database, the less slots there are to use. However, at least five slots are used.

The number of currently available slots results from:

The number of currently available slots = maximum number of available slots - sum of all own database processes - sum of processes of other databases on the server

NOTE: The number of available slots can still be influenced by the QBM | DBQueue | CountSlotsMax configuration parameter. If the number of available slots, according to calculation, is more than the value in the configuration parameter, the configuration parameter value is used. For more information, see DBQueue Processor configuration for test, development, or productive environments.

The central dispatcher starts the currently available slots just once. or each slot, a process is set up that runs tasks for exactly this slot.

Once tasks in the DBQueue are entered, the central dispatcher is notified. The central dispatcher distributes tasks to individual slots and notifies the slot processes that there are tasks are waiting to be processed. Each process processes the tasks queued for its slot. Once the task is complete, each process sends a message to the central dispatcher and waits for new tasks.

The central dispatcher checks at defined intervals whether the slots are still active and distributes new tasks to them. If there are no more tasks in the DBQueue, the central dispatcher goes into a wait state and waits for new task notifications.

Tasks on slots currently in use are still processed when the timeout expires. On completion, the slots are stopped. For more information, see How the central dispatcher communicates with individual slots.

関連ドキュメント

The document was helpful.

評価を選択

I easily found the information I needed.

評価を選択