decor
 

planetDB2 logo

Planet DB2 is an aggregator of blogs about the IBM DB2 database server. We combine and republish posts by bloggers around the world. Email us to have your blog included.

 

May 25, 2017

Jack Vamvas

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

Mongo

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" } ]
  }
)

 

 

Start the MongoDB service

sudo service mongod start

 

Start at the next system reboot

sudo chkconfig mongod on

 

To allow remote connections

Step1 : how to create a user in a db

db.createUser({

    user: 'robert',

    pwd: 'myM0ng0_pw',

    roles: [{ role: 'readWrite', db:'testdb'}]

})

Step 2 : Get the private address

/sbin/ifconfig | grep "inet addr" | awk -F: '{print $2}' | awk '{print $1}'

 

Step 3:edit mongo configuration file

--get private address from step 2 and add to bindip

vim /etc/mongod.conf

--change #security to:

security:

   authorization: enabled

 

Step 4: Then from the terminal you can run:

First you must have the mongo cli installed in your system (https://docs.mongodb.org/manual/installation/).

mongo someurl.mongodomain.com:45475/database_name -u username -p password

List all databases on a Mongo Server

show dbs

Show current Mongo db

db

db.getname()


Robert Catterall

DB2 for z/OS and Data-as-a-Service and Database-as-a-Service

______-as-a-service is all the rage in IT these days, and understandably so -- the "service-ization" of information technology capabilities and interfaces will be transformational; indeed, transformations have already occurred or are underway at many organizations and within many application development and deployment environments. In this blog entry I want to highlight a couple of ______-as-a-service concepts, data-as-a-service (aka DaaS) and database-as-a-service (aka DBaaS), and examine...

(Read more)
 

May 24, 2017


Craig Mullins

The DB2 12 for z/OS Blog Series - Part 10: Improved EDM Memory Management

EDM pool management is improved in DB2 12 for z/OS, which is especially beneficial to organizations running many concurrent threads with with large EDM pools specified. Prior to DB2 12, the EDMDBDC, EDMSTMTC and EDM_SKELETON_POOL DSNZPARM values were used to allocate DBD cache, dynamic statement cache and EDM skeleton pool memory and the values could not be lowered past the specified...

(Read more)

Henrik Loeser

Updates to Chatbot API and Tooling

Build Chatbots with IBM Bluemix If you have been coding up your own chatbot using the IBM Watson Conversation service on IBM Bluemix, then you might be aware of the new features in Conversation API....

(Read more)
 

May 23, 2017

Jack Vamvas

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 -db MYDB -dbcfg

Another thing you may want to check if the database is active. Essentially you’re checking if there are any connections. Use:

Db2 list active databases

 

If you'd like to read more about using db2pd , here are some posts which will assist in explaining db2pd option

db2pd troubleshooting guide (DBA DB2)

DB2 performance monitoring with db2pd (DBA DB2)

 

 

 


Henrik Loeser

Chatbots: Manage Your Watson Conversations from the Command Line or App

Manage Watson Conversation Workspaces I am a big fan of using the command line as most of you know by now. This applies to interacting with IBM Bluemix cloud and its services and for database...

(Read more)
Big Data University

This Week in Data Science (May 23, 2017)

Here’s this week’s news in Data Science and Big Data.

Don’t forget to subscribe if you find this useful!

Interesting Data Science Articles and News

Upcoming Data Science Events

Featured Courses From Cognitive Class

The post This Week in Data Science (May 23, 2017) appeared first on BDU.


DB2utor

Parameter Places Retry Claims on Stopped Objects

This should be obvious to anyone who reads this blog, but each DB2 release has literally dozens of new features and enhancements. I write about them on a weekly basis, but occasionally even I miss something. For instance, I recently learned about a new parameter introduced in DB2 10 that's designed to improve productivity (and reduce frustration) in your test and development environment.
 

May 20, 2017


DB2Night Replays

The DB2Night Show #Z77: DB2 12 Update

Presented by: Jeff Josten Distinguished Engineer, IBM SVL "The DB2Night Show Z77: DB2 12 Update" Replays available in WMV and M4V formats! 100% of our studio audience learned something!Jeff did a great of describing the highlights in DB2 12 and beyond. Watch the replay...

(Read more)
 

May 16, 2017


Frank Fillmore

Oracle Renewal Looming? Consider DB2! @IBMAnalytics

Thanks to my colleague, Kim May, for another wonderful job leading customers and IBMers through the rewards and challenges of converting Oracle databases to DB2. The recording of the latest webinar...

(Read more)
Big Data University

This Week in Data Science (May 16, 2017)

Here’s this week’s news in Data Science and Big Data.watermission_embed

Don’t forget to subscribe if you find this useful!

Interesting Data Science Articles and News

 

Featured Courses From BDU

The post This Week in Data Science (May 16, 2017) appeared first on BDU.


DB2utor

DB2 12 Session Token Support

If you have a client application using Parallel Sysplex workload balancing (WLB), you'll want to take advantage of session token support in DB2 12. But before I get into this new feature, some quick background.
 

May 12, 2017


DB2Night Replays

The DB2Night Show #193: DB2 LUW V11 Certification Training - Part 3

Follow @mohankumarsp Follow @rcollins963 Special Guests: Mohan Saraswatipura and Kent Collins, Authors DB2 LUW V11 Certification Training - Part 3 92% of our audience learned something! If you want to earn DB2 LUW V11 IBM Certifications, there are no better teachers than the professionals that are writing the exams and Certification Study Guides! Watch this replay and learn about DB2 LUW V11, RCAC, Security, Trusted Contexts, utilities,...

(Read more)

DB2 Guys

Revolutionizing analytics with IBM DB2 for SAP

by Sajan Kuttappa, Content Marketing Manager In-memory computing has gained a lot of traction as a great option to address the demands of use cases like real-time analytics. According to estimates, close to 75% of the use cases for in-memory computing are for real-time analytics. I want to share this example where Knorr-Bremse – a leading […]

Henrik Loeser

Chatbot Hackathon: Lessons Learned and Tips

Recently, I was a coach at a hackathon in Germany. Students were tasked to build solutions for a given topic and the solution had to include a chatbot based on the IBM Watson Conversation service....

(Read more)
 

May 11, 2017

Use the Index, Luke

Big News In Databases — Spring 2017

Here is the most noteworthy news since my last “Big News In Databases” post from November 2016.

A new SQL standard was released (SQL:2016)

In December 2016, ISO released a new version of the SQL standard. It introduces new features such as row pattern matching, listagg, date and time formatting, and JSON support. I've already written about listagg and made a presentation about row pattern matching.

Subscribe the modern-sql.com blog for further updates on the new standard.

Oracle Database 12.2 on premises, cloud prices double for AWS and Azure

Oracle’s cloud strategy was already topic in my previous post: Although the latest database release 12.2 was in November 2016, it was not available for download at that time—it was only available as a service in the Oracle cloud.

In January 2017, Oracle effectively doubled the license cost for the Oracle databases in Amazon’s and Microsoft’s cloud environments. And how does Microsoft react? On May 10, Microsoft announced the availability of MySQL and PostgreSQL as managed services in the Azure cloud.

Begun the cloud war has. One party opens up, another isolates itself. The marked leader watches.

In light of these developments, the release of the Oracle database 12.2 download in March is just a side note.

Database of the year

In January, DB-Engines.com (“TIOBE of databases”) published their database of the year 2016. According to their ranking method, SQL Server had the greatest gains in 2016 and is thus the database of the year 2016. Second and third place went to MySQL and PostgreSQL.

An interesting side note from their announcement: “It is the first time we see three RDBMS winning that competition, in the past we had at least two NoSQL systems among the winners.”

ACIDRain: Study highlights security risk of wrong transaction use

One of the consequences of database normalization is that transactions are needed to work safely. SQL has had transactions for a long time. The latest change in this area was the introduction of transaction isolation levels—25 years ago.

A new study recently analyzed how transactions are used in “12 popular self-hosted eCommerce applications written in four languages and deployed on over 2M websites.” The study found that 11 of them make incorrect use of transactions and “allow attackers to corrupt store inventory, over-spend gift cards, and steal inventory.”

The relevance of this thread (coined ACIDRain attack) is on the rise as more and more applications expose functionality via APIs that can be used to programmatically exploit concurrency related vulnerabilities.

From my Twitter timeline

Big News In Databases — Spring 2017” by Markus Winand was originally published at Use The Index, Luke!.

 

May 10, 2017


Kim May

IBM Announces Extended Support for DB2 for LUW V9.7 and 10.1

I’ve been pondering what this announcement means all day…is IBM trying to become the most altruistic database software vendor?  They are offering amazing software license discounts to...

(Read more)
 

May 09, 2017


Dave Beulke

IDUG DB2 Trip Report

Here is my trip report from the annual International DB2 User Group (IDUG) conference held last week. The event was great because of the technical, real world, pragmatic, and easy-to-understand content, especially from the user speakers. The IBMers, consultants, and vendors also provided great...

(Read more)
Big Data University

This Week in Data Science (May 9, 2017)

Here’s this week’s news in Data Science and Big Data.

Don’t forget to subscribe if you find this useful!

Interesting Data Science Articles and News

 

Featured Courses From BDU

 

Upcoming Data Science Events

The post This Week in Data Science (May 9, 2017) appeared first on BDU.


DB2utor

DB2 12 Debuts Advanced Triggers

A trigger defines a set of actions that represent the business logic that should occur when INSERT, UPDATE or DELETE operations are performed on a given table or view. Triggers can be used to update tables or generate or transform values to be used to insert or update rows. They can also invoke functions that operate within and outside of DB2.
 

May 02, 2017


Kim May

Another Oracle Attack Webinar? You Bet!

With IBM’s announcement this week of super-aggressive discounting being offered to current Oracle customers considering a move to DB2, and with the deadline looming for many Oracle customers...

(Read more)
Big Data University

This Week in Data Science (May 2, 2017)

Here’s this week’s news in Data Science and Big Data.machinelearning

Don’t forget to subscribe if you find this useful!

Interesting Data Science Articles and News

 

Featured Courses From BDU

 

Upcoming Data Science Events

Cool Data Science Videos

The post This Week in Data Science (May 2, 2017) appeared first on BDU.


DB2utor

A Welcome Alternative to Object Ownership Change

Most DBAs dread changing the ownership of an object. You have to take the database offline, sometimes for an extensive period, to unload, drop, recreate and reload the data, run runstats and--finally--rebind all the application packages. I’m sure many of you have at least a horror story or two about this experience.
 

April 30, 2017


Robert Catterall

DB2 for z/OS: Something You Might Not Know About Large Page Frames in a Post-DB2 10 Environment

I well remember the first time I saw it. August, 2016. I was looking at output from the DB2 for z/OS command -DISPLAY BUFFERPOOL(ACTIVE) DETAIL, issued on a DB2 11 system, that a client had sent to me for review. I appreciated the fact that I could see in this command output information about DB2's use of large real storage page frames for page-fixed buffer pools (in a DB2 10 environment, one had to issue -DISPLAY BUFFERPOOL -- for an individual pool, versus for all active pools -- with an odd...

(Read more)
 

April 28, 2017


Triton Consulting

Database Performance Management – The Solution

With each new DB2 LUW or DB2 z/OS release IBM rightly continues to develop and improve the features and capabilities. At Triton we have found that many of our customers are finding it increasingly difficult to remain up to date … Continue reading →

(Read more)
 

April 27, 2017

Jack Vamvas

How to use db2diag command line option for time

Question: A vendor has requested a snippet from db2diag log. The file needs to include all the db2diag log entries between 00:00:00 and 01:10  from 1 week ago.   I checked the file and the timeframe is available – but there are thousands of entries around that time , and so it is time consuming to extract the details.

Is there a way with db2diag command line option to extract between a start and finis time?

Answer: db2diag command line options offers a wider range of methods to interrogate and extract details. 

There is a command line option –time , which will satisfy your requirements. Let’s check an example.

db2diag -time 2016-04-16-00.00:2016-04-16-01.10

This example will extract all entries between midnight and 01:10 for the date 2016-04-16.

The IBM DB2 documentation has a full comprehensive details for  db2diag - db2diag logs analysis tool command

 

 

April 26, 2017


Adam Gartenberg

Now Available - IBM and Cisco Integration

Yesterday marked the general availability for the integrated solutions combining IBM's collaboration offerings with Cisco's communication capabilities. These solutions, which were first announced...

(Read more)
 

April 25, 2017

Big Data University

This Week in Data Science (April 25, 2017)

Here’s this week’s news in Data Science and Big Data. analytic-maturity

Don’t forget to subscribe if you find this useful!

Interesting Data Science Articles and News

 

Featured Courses From BDU

 

Upcoming Data Science Events

 

Cool Data Science Videos

The post This Week in Data Science (April 25, 2017) appeared first on BDU.


DB2utor

DB2 12 Catalog Availability Improvements

During the early releases of DB2, enterprises (specifically DBAs) would restrict dynamic SQL from running in their production OLTP environments. This choice stemmed primarily from the likelihood of ad hoc OLAP queries adversely impacting the performance of OLTP applications. Of course, over the next 20-plus years, this issue has been largely mitigated by the widespread adoption of dynamic SQL. Dynamic SQL continues to be a focus of DB2 development, and DB2 12 features an important enhancement in the area of catalog availability.
 

April 24, 2017


ChannelDB2 Videos

DB2 Tips n Tricks Part 113 - Roll Forward Phases - Is BACKWARD Phase aware of FORWARD?


Thumbnail

Demystify Roll Forward Phases - Is BACKWARD Phase aware of FORWARD Phase? Happy Learning & Sharing http://db2luwacademy.blogspot.in

Subscribe by email

 

About

planetDB2 is an aggregator of blogs about the IBM DB2 database server. We combine and republish posts by bloggers around the world. Email us to have your blog included.
 

Bloggers

decor