Rajesh S NairMay 23, 20181 min readRunning Mongo Deamon and Starting DatabaseTo start working on the mongo database, we would first want the installed mongo package to run as a service .These deamons will serve as...
Rajesh S NairMay 23, 20182 min readInstalling Mongo Database Installing mongo database is comparatively simpler and hassle free as compared to traditional databases.The main idea of mongo database...
Rajesh S NairMay 23, 20181 min readIntroduction To Mongo DatabaseMongoDB was initially created in 2008 as part of a hosted application stack • The companywas originally called 10gen. • As part of their...
Rajesh S NairMay 15, 20182 min readFeatures in OpenEdgeE11 and Above1.OpenEdge Transparent Data Encryption (TDE) By providing application transparent data encryption, TDE provides both security and...
Rajesh S NairMay 15, 20183 min readShell Scripting for Progress DBA Now that we are familiar with the basic unix commands which would be required by a Progress DBA at various troubleshooting and day to day...
Rajesh S NairMay 15, 20186 min readBasic Unix commands for Progress DBA Since the most used operating system for a progress database product is linux/unix/solaris as compared to windows OS, a Progress DBA is...
Rajesh S NairMay 15, 20182 min readRestricting blank user id login to progress database Security is a major aspect for any database,it is required to have a user/pass credential validation for every connection made to the...
Rajesh S NairMay 15, 20181 min readNameServer,AppServer,AdminServer,Webspeed Configuration and CommandsSince we are done with the theoritical part of the various entities , lets see how we use them in a real work scenario for a progress DB...
Rajesh S NairMay 15, 20183 min readOpenedge Appserver, Webspeeds, NameServer and Admin ServersAppserver Environment provides a foundation for a flexible and extensible application infrastructure. OpenEdge Application Server...
Rajesh S NairMay 15, 20183 min readOpenEdge Database AuditingAuditing goal can be achieved through below steps: 1. Enabling Audit in a DB. 2. Implementing policies. 3. Generating reports. ENABLING...
Rajesh S NairMay 15, 20182 min readOpenedge Replication Monitoring and commands The replication process is a real time syncing of the master and slave database. Any discrepancies or issues can lead to huge lag...
Rajesh S NairMay 15, 20182 min readSteps for OpenEdge Replication Below steps for OS Copy Replication 1.Copy the source.repl.properties file from dlc/properties path and copy the the  DB path ,giving it...
Rajesh S NairMay 15, 20181 min readOpenEdge Database ReplicationOpenedge Replication is a feature/product from Progress that provides real-time synchronization between two or more databases. Â There is...
Rajesh S NairMay 15, 20182 min readDatabase Structure Description File (.st )The most basic procedure to create a database is using the prostrct utility. To create a database using prostrct, we would require a...
Rajesh S NairMay 15, 20183 min readOpenEdge Schema TablesWhat are schema tables?  Schema tables are metadata:  i.e data about data  These are real tables, stored in the database.  It describe...
Rajesh S NairMay 15, 20189 min readOpenedge Database ReportsOpenEdge provides us a variety of utilities to pull out reports related to the database and which we can use to analyse and plan how the...
Rajesh S NairMay 15, 20183 min readOpenEdge Indexes and Index UtilitiesWhat is an index ? Database index works like a book index. To look up a topic, you scan the book index, locate the topic, and turn to the...
Rajesh S NairMay 15, 20183 min readOpenEdge Dump and LoadThe Openendge RDBMS database, as we know ,would comprise mainly of tables and the data contained it. These table structures and the data...
Rajesh S NairMay 15, 20182 min readOpenedge Storage AreasStorage areas are identified by their name. Each Progress database must contain three specific storage areas, and may contain several...
Rajesh S NairMay 15, 20183 min readDatabase BlocksWe have now covered the Database architecture for an Openedge database and its various components such extents , storage areas etc. Now...
