Source: projects/identity-management/oim-kb-update/runs/2026-04-27-31.md
> Source: projects/identity-management/oim-kb-update/runs/2026-04-27-31.md
OIM Wiki Object Documentation Sweep - DBQueue Table Metadata Batch
Scope
This heartbeat run started the table-aware documentation work requested for the automation. The batch focused on DBQueue working tables that were already next candidates from the prior procedure runs:
DialogDBQueueQBMDBQueueCurrentQBMDBQueueTaskMetricQBMDBQueuePond
Evidence Used
- Live read-only sandbox query through
scripts/sandbox/Invoke-SandboxSql.ps1 -Database OIM -Json DialogTablerows for display names, usage type, primary key names, row counts, table type, and custom remarksDialogColumnrows for captions, commentary, data type, PK/UID/FK flags, and column descriptionssys.triggersfor trigger presencesys.indexes,sys.index_columns, andsys.columnsfor index coverage- Existing generated source pages and source-index evidence for procedure/table relations
No DML was executed.
Verified Tables Documented
DialogDBQueue
- DialogTable:
- DisplayName:
DBQueue - UsageType:
WORK - PKName1:
UID_DialogDBQueue - CountRows:
0at query time - DialogColumn descriptions:
UID_DialogDBQueue: DBQueue entry identifier; PK and UIDUID_Task: DBQueue Processor task; UID and foreign keyObject: Object from DBQueueSubObject: child object / sort criterion for objects to be processedPathLength: calculated weighting used to determine jobs to processGeneration: reset countXTouched: processing status- Trigger metadata:
- enabled trigger
QBM_TIDialogDBQueue - Index metadata:
- PK on
UID_DialogDBQueue QBM_XC5DialogDBQueue,QBM_XC7DialogDBQueue, andQBM_XC8DialogDBQueue- Verified relations:
QBM_PDBQueueInsert_Intinserts intoDialogDBQueueQBM_FTDBQCSOverviewLoadreadsDialogDBQueueQBM_PDBQueueInsert_WaitForCompreaches it through the insert wrapper chain
QBMDBQueueCurrent
- DialogTable:
- DisplayName:
DBQueue (current) - UsageType:
WORK - PKName1:
UID_DialogDBQueue - CountRows:
0at query time - DialogColumn descriptions:
UID_Task: DBQueue Processor taskUID_Parameter: first task parameterUID_SubParameter: second task parameterSlotNumber: executing slot numberStartedAt: start time of task processingGeneration: reset countGenProcID: process ID- Index metadata:
- PK on
UID_DialogDBQueue QBM_XC1QBMDBQueueCurrent,QBM_XC2QBMDBQueueCurrent, andQBM_XC3QBMDBQueueCurrent- Verified relations:
QBM_PDBQCS_CurrentRestorereads/restores current entriesQBM_PDBQCS_SlotRunnerreads current slot entries
QBMDBQueueTaskMetric
- DialogTable:
- DisplayName:
Database Agent Service snapshot - CustomRemarks:
Snapshot of the task processing of the Database Agent Service. - UsageType:
WORK - PKName1:
UID_Task - CountRows:
337at query time - DialogColumn descriptions:
ProcedureName: procedure that executes the taskCountInDBQueue: number of entries inDialogDBQueueper requestCountProcessing: number in execution statusPROCESSINGCurrentBulk: current number of jobs processed in one slotIsBulkEnabled: whether the procedure is suitable for bulk processingMaxInstanceEffective: maximum slots that can be filled with this job in parallelPathLength: calculated processing weightingSlotInformation: assigned slot detailsUID_TaskAutomatedFollower,UID_TaskAutomatedPredecessor,UID_TaskParent: task relationship columns- Index metadata:
- clustered PK on
UID_Task - Verified relations:
QBM_PDBQueueInsert_Bulkvalidates tasks against this tableQBM_PDBQueueInsert_Intreads task metadata from itQBM_FTDBQCSOverviewLoadreadsMaxInstanceEffective
QBMDBQueuePond
- DialogTable:
- DisplayName:
DBQueue (buffer) - CustomRemarks:
Buffer the DBQueue Processor tasks of synchronizations before takeover in DBQueue. - UsageType:
WORK - CountRows:
0at query time - DialogColumn descriptions:
UID_Task: DBQueue Processor taskObject: first parameterSubObject: second parameterGenProcID: process IDPondGroup: groupInsertDate: creation date- Index metadata:
QBM_XCQBMDBQueuePondonInsertDate, UID_Task, PondGroup- Verified relations:
QBM_PDBQueueInsert_Bulkwrites here when session contextQBMDBQueuePondis set- the same source path sets
INSERTEDINTODBQUEUE=1
Wiki Usability Changes
- Added the four DBQueue working tables to generated table profiles.
- Added a verified DialogTable/DialogColumn metadata section to each of those table pages.
- Added column-description tables, index lists, trigger lists, and verified table relation bullets.
- Table cards now mark pages that include Dialog metadata.
- Table count increased from 18 to 22.
Gaps / Next Batch Candidates
- Add a full table coverage dashboard for all
DialogTablerows, not just the current curated table list. - Continue with
DialogDatabase,QBMDBQueueTask,JobQueue, andQBMDBQueueSlot/slot-related tables if present. - Add automated evidence export for table metadata so future runs do not require manual transcription into generator notes.