Database service object statuses
- Last Updated: September 2, 2024
- 2 minute read
- OpenEdge
- Version 12.8
- Documentation
The
_DbSvcMgrObj-Status field is part of the
_DbServiceManagerObjects virtual system table (VST). This field
indicates the operating status of a service object within the OpenEdge database
environment. Here are the possible values for _DbSvcMgrObj-Status,
along with their descriptions:PREREG—Indicates that the plugin manager has read the pmmgr.properties file and initialized all necessary internal plugin information to start the database service object.REG—Indicates that the database service object process has started, registered its process ID with the plugin manager, and acquired shared memory.Note: TheOpenEdge RDBMSdatabase service object retains itsREGstatus for the lifetime of the database broker. Following process initialization, the status of all other database service objects will change toRUN.RUN—Indicates that the database service object is running and in the normal mode of operation. This status implies that the service object process is running, has been properly initialized, and the status is notBUSY,BUSYNP, orDB_OBJ_CHG_WAIT.BUSY—Indicates that the database service object has explicitly enforced the restriction such that processes will be blocked when attempting to send it a plugin message. The sending process will be blocked until either:- The database service object status has changed.
- The database service object process has died.
- The database service object has been terminated gracefully.
- The database is being shutdown.
The database service object will receive the plugin message if its status changes fromBUSYtoRUN. In all other cases, the plugin message send action will be aborted.Note: The act of putting an AI buffer into the PICA queue requires a plugin message. Therefore, when the replication server has theBUSYstatus, database update activity will be blocked.BUSYNP—Indicates that the database service object has explicitly enforced the restriction such that processes that are to send it a plugin message will discard the message rather than sending it.DB_OBJ_CHG_WAIT—Indicates that the database service object is ending a transaction that involves updates to database schema objects and is currently waiting for no-lock readers to view the latest updates to the OM (storage object) cache.Note: This status applies only to the OpenEdge Replication Agent.