SQL/MX

A mere week ago (as I write this), Connect held its annual showcase NonStop user meeting. As I first sat down to write about it, I realized it’s the first time since 1995 that the annual ITUG or Connect NonStop meeting has been held outside of California

Native Large-Objects (LOBs) were introduced in NonStop SQL/MX release 3.8 and replace the previous implementation of LOBs for JDBC in which the driver manages the LOBs. That previous implementation is still available, however, migration to the native LOBs is recommended.

Reviewing the topics that were covered at the World Economic Forum (WEF) in January is a good way to get some highlights not only on what some of the current world challenges are but also to realize how those are so closely connected to the great challenges of our IT industry.

For the better part of the past two centuries, there is barely a time when modernization isn’t the subject of conversation. Attend any gallery opening, any new musical or any open house and very quickly the conversation turns to whether or not the item represents modernism. In other words, is it an indicator of things to come or is it just more of the same.

NonStop TBC 2022 kicked off a new round of modernization with a friendly competition to come up with a sustainable design to replace SCOBOL requesters with the latest and greatest tech available on and off NonStop.

How Striim can easily unlock the value of your data without disruption to existing applications and databases I recently had

Real-time data replication products, such as HPE Shadowbase software, are well known for their ability to facilitate IT service availability (Business Continuity) by replicating production data in real-time across multiple systems to create backup database copies. Should one system fail, current, consistent data is available on alternate systems which can take over processing, thereby maintaining service availability. But such products also provide another significant capability: a heterogeneous Data Distribution Fabric Backbone (DDFB), which facilitates data integration.

Most companies fail to recognize their operational data is their most valued asset simply because it doesn’t appear directly on any financial statements. Data holds valuable insight into organizational productivity, customer habits, and proactive decision making. Unfortunately, most businesses fall short of utilizing their data to its fullest potential.

Hello World! In this tutorial, I will show you how Python can execute queries on the HPE NonStop SQL/MX Database using pyodbc and the NonStop SQL/MX ODBC driver.

Before we begin to look at HPE NonStop platform updates becoming available in 2021 it’s probably a good idea to take a step back and look at exactly what constitutes a platform. Like with every opinion, everyone has their own take on what constitutes a platform. It was so much easier when we all understood what was a computer, an operating system or an application but of late, the lines have become less clear. Can we still draw meaningful lines or have they become lines in the sand, subject to change every time a breeze disturbs their presence.

On an HPE NonStop system, this transaction log is maintained by the HPE NonStop Transaction Management Facility (TMF) subsystem, and is known as the TMF Audit Trail (TMF AT). Data managed in this way by TMF are known as audited files, or audited data (conversely, non-audited-files and non-audited data).

Databases and servers operated by enterprises today are large and complex. Every business is transforming, and data is the lifeblood of every organization. The growth of data and its importance has been a top executive priority. Equally important: Grappling with top technology trends such as analytics, AI, IoT, containers, VR/AR, and cloud/edge computing—all of with the common denominator of being data-driven. Learn how HPE NonStop SQL Cloud Edition is up to the challenge.

Japan is located in the east of the Eurasian continent, consists of five main islands from north to south, Hokkaido, Honshu, Shikoku, Kyushu and Okinawa, 6,852 islands in all. The climate classification varies from subarctic in the north to subtropical in the south, and there are four seasons. It has an area of 377,975.21 km2 with a population of 126.16 million and a time zone of UTC +9. The capital is Tokyo, Japan, located on the mainland.

A year ago, none of us could have foreseen the type of year 2020 has turned into with most of the country sheltering at home or just starting to reopen businesses but when venturing out, wearing masks as we try to go about our lives during the worldwide COVID 19 pandemic.   I’m proud to say that HPE has been very good in moving all employees to work from home, checking in and keeping everyone informed as to the latest information from our governments and the company’s future plans within those guidelines.  And we expect HPE to very slowly begin reopening some of our business sites over the summer.   Before we start talking about the NonStop business and events, I’d like to take a moment to send all of you, our customers, partners and friends around the world our best wishes for your personal good health and the good health of your families during this time of social distancing and uncertainty.  As things start to reopen again, we hope you are continuing to take appropriate measures to keep yourselves healthy and safe.

In Japan, a lot of companies are working from home since the end of March when COVID-19 became more serious, and sales activities have been restricted. Under such circumstances, we held a Webinar on April 22nd promoting the NonStop database “SQL/ MX” so customers could participate from home. The Seminar title is “A recipe of system construction that never stops business”, and introduced how to build a system that cannot be stopped by using the NonStop Database.

There is something about having a long experience in this industry that is of high value to us because we get to witness how different technologies are born, going through a hype cycle, being adopted in very specific solutions or getting wider adoption or in some cases just being forgotten. For customers it may be a daunting task to decide where to invest. So many new technologies simply claim to solve world hunger. In general it is rare that a technology becomes universal across all vendors. TCP/IP can claim that, for languages C/C++ and Java have had success, for operating systems, is Linux the standard now? But what else? When it comes to programming for example, not long ago, multi-threading was the common way to scale an application. Then BigData proved that “scale out” may be a better way to address massive scale for data access. I think we knew this already in our NonStop world but the industry didn’t.

For application developers and architects then the development landscape is more complex and pressured today than ever before. On premise, off premise, public cloud, private cloud, agility, DevOps all add pressure to decisions whilst none take away the need to bring solutions to market quickly and, of course, minimise costs.