Different Ways to Start/Stop OpenEdge Database

-

Different ways of Starting OpenEdge Database
         
       OpenEdge database can be Start Up by the four ways:
  1. PROSERVE command
  2. DBMAN utility
  3. OpenEdge Management
  4. OpenEdge Explorer
   PROSERVE command:

§  PROSERVE command starts the Broker or Server which coordinates all the database requests from all the users to the specified OpenEdge database.
§  PROSERVE command starts the main database server i.e. Broker which manages all the shared resources and starts the servers as needed for the remote users.
§  By default PROSERVE starts the default brokers that can launch both 4GL and SQL servers. The 4GL server supports only remote OpenEdge ABL clients and SQL server supports only OpenEdge SQL clients.

    DBMAN utility:
§  DBMAN utility can only start the database when the database has already been configured and store in conmgr.properties file, and AdminServer is running.
§  Don’t modify the conmgr.properties file directly. You always use OpenEdge Management or OpenEdge Explorer to create or manage the database configuration and store in the conmgr.properties file.

          OpenEdge Management:
§  OpenEdge Management is a management tool which is based on browser that can be used to configure, monitor, diagnose, and manage the databases in an OpenEdge environment.
§  OpenEdge Management can only start the database when AdminServer is running and the database has already been configured by OpenEdge Management or OpenEdge Explorer.

          OpenEdge Explorer:
§  OpenEdge Explorer is a configuration tool which is based on browser that allows you to configure the databases, as well as to start or stop them, view their status and log files.

§  OpenEdge Explorer can only start the database when AdminServer is running and the database has already been configured by OpenEdge Explorer or OpenEdge Management. 

     Different ways of Stopping OpenEdge Database
      OpenEdge database can be Shutting Down by the five ways: 
  1.       PROSHUT command
  2.       DBMAN utility
  3.       PROMON utility
  4.       OpenEdge Management
  5.       OpenEdge Explorer


       PROSHUT command:
§  PROSHUT command shuts down OpenEdge database server and all individual processes of an OpenEdge database.
§  PROSHUT command disconnects all the users from the OpenEdge database before shutting down the broker.
§  PROSHUT command performs conditional, unconditional and emergency shutdown.

      DBMAN utility:
§  DBMAN utility can only stop the OpenEdge database when AdminServer is running and the database has already been configured and store in conmgr.properties file.

      PROMON utility:
§  PROMON utility is an OpenEdge database monitoring utility which can be only used when the server or broker is running for the database. 
§  PROMON utility is used to shut down the OpenEdge database or disconnect any subset of users from the OpenEdge database.
§  PROMON utility perform unconditional and emergency shutdown.

        OpenEdge Management:
                  §  OpenEdge Management can only stop the database when AdminServer is running and the   database has already been configured by OpenEdge Management or OpenEdge Explorer.

     
           OpenEdge Explorer:
                  §  OpenEdge Explorer can only stop the database when the database has already been configured by OpenEdge Explorer or OpenEdge Management and AdminServer is running.


Comments

Post a Comment

Popular posts from this blog

Progress OpenEdge Database Architecture

-
Image
                          OpenEdge Database: •         Database management system is system software for creating and managing databases. •        OpenEdge database is a Relational Database Management System (RDBMS). •        OpenEdge database is a collection of logical storage structures and operating system files that contains permanent data on the disk. •        OpenEdge database is organized into a Logical Database and a Physical Database .   Logical Database: •        Logical database objects described in the database schema and include tables, indexes  and sequences .       Application developers works with logical databases & responsible for creating and maintaining logical database objects . Physical Database : •   ...
Read more

Progress OpenEdge Database Connection Modes

-
We can connect to the OpenEdge Database in Single user mode or Multi user user mode.In single user mode database can be accessed by one user at a time. Multi user mode database can be accessed in different ways and multiple user can access the database at a time or simultaneously. Different Connection Mode:- Single-user Mode Multi-user Mode Batch Mode Interactive Mode Single-user Mode: Running an OpenEdge database in Single-user mode allows only one user to access specified database at a time. Database cannot permit to connect a user form a different Progress session if another user is already accessing the database. Database engine maintain a lock file (.lk) to lock out other users from making connecting to the database Multi-user Mode: Running an OpenEdge database in Multi-user mode allows simultaneous access of the database to more than one user. All the database connection requests are coordinated by the broker, and servers retrieve and store data on beh...
Read more