Resources

Article

High Availability Fail Tales (and How to Avoid Them)

By Kurt Thomas on Thu, 08/25/2016
Chasing a high availability state is a common goal for IBM i administrators and one that can be thwarted by a single issue left unattended. By sharing some of the most frequent tales of what went wrong from real-world environments, you’ll be able to avoid these same scenarios.
Monitoring
Article

Monitoring the Demands of Fast Disk

By Kurt Thomas on Wed, 08/24/2016
The IT industry is decisively moving away from traditional hard disk drives (“platters”) in favor of Flash-based solid-state drives (SSDs). It’s a welcome change; it makes much more sense to circulate only electrons instead of disks of metal with electrons on them.
Monitoring
Article

Small but MIGHTY: Controlling the *CLS Object Type

By Kurt Thomas on Wed, 08/24/2016
While the instinct for administrators and IT managers is to always hunt down a culprit – a rogue job, an inactive journal receiver, or something else – sometimes the very building blocks of a common process, or rather the specifics that define processes, can be where the trouble at hand resides.
Monitoring
Article

Database 101: Why You Can Rely on IBM i

Fri, 08/19/2016
IBM i is the perfect environment for data access and reporting. Read this article to learn how you can better utilize your Power Systems databases.
IBM i Business Intelligence
Article

How Banks Leverage Big Data for Big Value

Fri, 08/19/2016
Technology professionals in the banking industry face a wide range of concerns due to the nature of the data stored within their systems. The potential reward in stealing or compromising financial data makes these organizations a prime target for cybercrime, while stringent industry regulations require security to be extremely tight at all times. Is it possible to strike a balance between defensive, regulatory, and data access needs and still provide access to data for analytics without compromising the security of the entire system? The truth is that many organizations in the financial sector have deployed analytics technology while being able to keep their security tight, and are benefiting from it.
IBM i Business Intelligence
Article

Top 10 Ways Sequel Makes Your Life Easier

Fri, 08/19/2016
Text No matter what industry you’re in, accessing and presenting your data is incredibly important. Your business users’ ability to make informed decisions shouldn’t be limited by your data access tool or their...
IBM i Business Intelligence
Article

Add Power to SEQUEL Scripts with Logic

Mon, 08/01/2016
SEQUEL Scripting is a process that allows users to run multiple SEQUEL and system commands together. Scripts allow for much of the same capability of Command Language Programs (CLP) without the need for programming knowledge or a compiling of the objects.
IBM i Business Intelligence
Article

The Partitioning Paradox Solved

Mon, 06/27/2016
There is rarely a dull moment for IBM i administrators, as their operating environments continuously absorb and distribute new data. While this trend certainly keeps teams engaged, it also triggers fears that current protocols may not be enough to meet the challenges of tomorrow. First and foremost, there is often some doubt as to whether storage plans will be able to scale to manage the sheer...
IBM i Business Intelligence
Article

Easily Accessing Data on Remote Databases with SEQUEL

Mon, 06/27/2016
With SEQUEL you can retrieve information not just from your local IBM i, but also on other IBM i’s, SQL servers, Oracle, MySQL, and other remote databases. Once you have the remote host definition defined you are ready to convert data on other platforms into meaningful information right from your local IBM i. The ability to design views with SEQUEL SQL and translate them on the fly to native SQL...
IBM i Business Intelligence
Article

Get Started with Remote Database Access

By Heath Kath on Mon, 06/27/2016
Many organizations are expanding to use multiple platforms in their IT environments. There are many reasons for this: it can be due to company acquisitions or application vendor platform shifts, or when a department requires a certain software package with features that require a different platform. For example, many Customer Relationship Management (CRM) tools employed by sales teams reside on a...
IBM i Business Intelligence
Article

How-To: Slice and Dice Your Data with Client Tables

Mon, 06/27/2016
In the era of big data users need to view their data in a way that makes sense and lets them dive deeper. SEQUEL’s Client Tables are an interactive solution, much like pivot tables, which allow users to reorganize and summarize columns and rows of data in a spreadsheet-like format both on a PC and on a mobile device or tablet. With Client Tables on the go, you can access data from your office, in...
IBM i Business Intelligence
Article

HANDS OFF! Saying Goodbye to Manual Data Access

Mon, 06/27/2016
Organizations today face an ever-expanding volume of information that must be analyzed and delivered to the right people. While the resulting business intelligence offers us insight into processes and customers, many companies still rely on practices and technology that aren’t suited for managing data on a large scale. As a December 2012 Financial Director article highlighted, 60 percent of those...
IBM i Business Intelligence
Article

Working with Variables Part II: Taking SEQUEL Runtime Prompts to the Next Level

Mon, 06/27/2016
In an earlier article, we introduced prompted views as a way to enable end users by allowing them to retrieve data without the need for code. We discussed how this approach meets the needs of users while freeing time that database administrators might otherwise spend running countless similar queries. Finally, we showed you how to configure default values for your prompts and explained how to use ...
IBM i Business Intelligence