How to check DB2 LUW database write suspend state with db2pd

DB2 LUW write suspend state is commonly checked during a splitting of mirrored database.I’d like the flexibility of checking via the db2pd monitoring tool, How can I get the output in db2pd to check if a DB2 database is in the write suspend state? Answer: There’s a couple of different things you can check in this situation. The db2pd tool will allow you to check and report on the database configuration and to identify if the database is in write suspend state. This command will return the relevant information. Check for the item “database is in write suspend state” db2pd... Read more →

MongoDB cheat sheet

MongoDB is an open-source NoSQL document-oriented database program. I’ve recently started supporting MongoDB . This is my quick notes to support MongoDB How to install MongoDB Enterprise on Red Hat Linux --create a repo file and insert the text below vi /etc/yum.repos.d/mongodb-enterprise.repo [mongodb-enterprise] name=MongoDB Enterprise Repository baseurl=https://repo.mongodb.com/yum/redhat/$releasever/mongodb-enterprise/3.4/$basearch/ gpgcheck=1 enabled=1 gpgkey=https://www.mongodb.org/static/pgp/server-3.4.asc --install the package sudo yum install -y mongodb-enterprise Create the user Administrator Note:Once you've created the admin Users, you'll need to disconnect from the Mongo Shell & restart the Mongo Server use admin db.createUser( { user: "myUserAdmin", pwd: "abc123", roles: [ { role: "userAdminAnyDatabase", db: "admin" } ] } )... Read more →