Making Compromise Obsolete with Oracle Gen 2 Cloud

This post was contributed by Senior Principal Product Marketing Director, Ron Craig.

There’s an old saying in the automotive world – “Cheap, fast, reliable – pick any two”. What’s interesting is as self-driving and automation in general progresses, the introduction of enabling technologies means those old trade-offs may no longer apply. Out of all of those advances, one that I find particularly intriguing (for as long as the concept of a multi-speed transmission remains relevant!) is the idea of the predictive transmission. A predictive transmission addresses the problem that a regular automatic transmission will typically only react to a steep hill or sharp bend by downshifting after encountering that change in road topology to match your slower engine speed, meaning there’s a period of time during which the car isn’t performing optimally.

With a predictive transmission, now available in many production cars, the transmission is linked to the car’s navigation system, giving it the intelligence to get into the appropriate gear in advance. Having knowledge of what is ahead allows the transmission to shift appropriately before a change in road conditions, avoiding that period of sluggishness we’ve all encountered where most automatic transmissions are still figuring out how to react. The end result is the best of both worlds – better fuel economy and better performance – two things that you typically would have had to choose between in the past. In short, compromise becomes obsolete.

In the same way, by being proactive rather than reactive, Oracle Generation 2 Cloud is anticipating and acting on your needs rather than always waiting for your guidance, meaning you don’t necessarily need to choose between cost, speed and reliability. Oracle Generation 2 Cloud goes beyond first generation cloud technology to offer organizations advanced capabilities that allow them to run their existing and future workloads better and faster. The Oracle Generation 2 Cloud also allows you to get the most out of your data, while also ensuring it’s available and secured.

On the database front, integrated machine learning (ML) capabilities in Oracle Autonomous Database allow you to extract more value from your data – moving algorithms to the data rather than the other way around. Oracle Autonomous Database provides options to extract value from the database using SQL analytics, or gain insights and make predictions via native ML. ML algorithms are available as native SQL functions – in effect we’ve taught the database how to do higher level math. Models that used to take weeks to build can now be built in minutes, and multiple data scientist user roles are supported (DBAs, app developers, data scientists etc.).

Oracle Machine Learning Notebook

Moving the analytics to the database opens up a new world of possibilities. For example, you can now dedicate more time to things like identifying which machines in your factory will soon require maintenance and only shut down what really needs to be shut down, rather than pausing production on all equipment for routine, perhaps unnecessary, maintenance.

Oracle Cloud technology is helping innovators disrupt a broad range of industries. We’re seeing financial services use AI for automatic forecasting without human intervention, to smart manufacturing utilizing real-time IoT data for equipment optimizations. In a particularly compelling example, a medical lab testing company is using Autonomous technologies to shorten results from weeks to minutes. This allows for faster time to diagnosis, which means fast time to treatment, which ultimately means the shortest time to recovery.

Cyber Security company FireEye expects to not only better protect their customers through the ability to analyze tens of millions of emails daily, but also reduce disaster recovery costs by 40-50% by moving to Oracle Cloud.

Oracle Cloud Blockchain Technology is helping logistics and shipping management company CargoSmart simplify the otherwise complex documentation process and deliver a single source of truth for trusted, real-time sharing of information, increasing trust and boosting the efficiency of ocean freight shipping.

OUTFRONT Media is using Oracle Analytics Cloud and Oracle Autonomous Data Warehouse to gain the insight that help their clients make the most effective use of their advertising budgets.

What do all of these companies have in common? That’s simple – none of them is a database or compute infrastructure management company. They leave that to Oracle and the Oracle Generation 2 Cloud, while they focus their efforts on growing their businesses by providing differentiated value to their customers.

Learn more at Oracle Open World 2019

To learn more about Oracle’s Generation 2 Cloud or to hear from our customers themselves, visit the sessions below at the 2019 Oracle OpenWorld event –

The Power of Insights: Better Business Decisions with Oracle Autonomous Data Warehouse, Monday September 16, 1:45 PM – 2:30 PM | Moscone West – Room 3007B

Oracle Cloud: A Path and Platform, Tuesday September 17, 11:15 AM – 12:00 PM | YBCA Theater

Solution Keynote: Oracle Cloud Infrastructure Strategy and Roadmap, Tuesday, September 17, 03:15 PM – 05:00 PM | Moscone South – Room 207/208

Customer Case Study Session: Oracle Cloud Infrastructure Enables Threat Detonation in World-Leading Security Products, Monday, September 16, 01:45 PM – 02:30 PM | Moscone South – Room 152A

Oracle Autonomous Data Warehouse: Customer Panel, Tuesday, September 17, 01:45 PM – 02:30 PM | Moscone South – Room 211


Re: Time to Time DB2 Backup Faliure


We have Networker 9.1 that deployed on a Win 2012 R2. We are schedule a DB2 full backup on every day 3 am. Past few months we are facing the backup failure in time to time. In the every time when the backup failed we got the below error.

Backing up the ‘PB_PROD’ database.

Unable to backup PB_PROD database due to backup request failure, SQLCODE : -2025, SQL2025N An I/O error occurred. Error code: “3”. Media on which this error

occurred: “VENDOR”.

NMDA backup failed.

64673:nsrdasv: Unable to backup PB_PROD database due to backup request failure, SQLCODE : -2025, SQL2025N An I/O error occurred. Error code: “3”. Media on which this error

occurred: “VENDOR”.

— Job Indications —

prdbsvr1:DB2:/PB_PROD/NODE0000: retried 1 times.”

But after we restart the NW services from next day onwards backup was run as normal. DB backup size is ~1.5 TB. We have open several SR‘s with DELL EMC NW support team. As per them in the very first time they advised to restart the NW services. As I previously said after restarting the services it was runnin fine. In the second time when we open the SR they asked to created a separate ddboost device to backup the data. That thing also we already did. Now we yesterday backup was again failed with the same error.

Is anyone can advised how to solve this issue permanently.


Analytics ecosystem, Part 1: Spatial Analytics with Db2 Warehouse

Db2 Warehouse, a massively parallel processing (MPP) architecture based
data warehouse solution also has geospatial capabilities to manage spatial
data. You can now store spatial data as geometries in database tables and
perform spatial analytics.


Encoded-vector index (EVI) only access in IBM DB2 for i

IBM® DB2® for i continues to enhance the SQL Query Engine (SQE) in many ways. One recent enhancement delivers a new way that SQE can use an encoded-vector index (EVI) to access the data needed by a query through an index implementation. This new capability is called EVI only access (EOA) where the data can be reached by only accessing an index. This article provides some of the foundational details you’ll need to use EOA.


IBM DB2 for i: JSON Store Technology Preview

The JavaScript Object Notation (JSON) Store Technology Preview for IBM i
allows the storage and retrieval of JSON documents in database tables. This article describes how to enable the JSON store on IBM DB2 for i. It also illustrates the use of the DB2 JSON command line and the DB2 JSON Java application programming interface (API) to store and retrieve JSON documents.