Resources

Article

Enhance Your Reporting with Sequel Date Functions

Sequel makes it easy to work with your date fields, from converting the numeric or character field into a true date data type field to performing date calculations. Continue reading to learn how to convert non-date data type fields.
Article

Anydate: Go Back to the Future

Take time into your own hands. Discover the benefits of testing future dates, rerunning past reports, and more with date simulation software.
Article

How-To: Analyze Year-End Data Quickly with Flexible Client Tables

Year-end reporting is coming… Are you ready? Do you know your options? Are you prepared to collect all of the data you need to see how your company fared for the year? You’re in luck, because Sequel Client Tables make year-end reporting a breeze. Drill down into the level of information you need for your reports. Compare data across multiple years to spot trends and add context. And highlight...
Article

The Commercial Power of SQL-Based Monitoring

The SQL-based monitoring feature in Robot Monitor means organizations can now apply the valuable insights, analysis, and real-time notifications that they use for system information to information from broader business applications.
Article

Astronauts Rely on Checklists (and So Should You)

What do astronauts and IBM i admins have in common? Checklists! These seemingly simple yet effective devices serve as our external memories and deliver process consistency, but they’re not without limitations.
Article

Increase Productivity with Sequel View Builder

Business success hinges on sharing relevant information with the people who need it. When members of your organization can make informed decisions, productivity increases and problems can be solved more creatively. With Sequel Data Access, more business users within your organization can see these benefits on an even greater scale. Not using Sequel yet? Learn more > Using Sequel? Keep...
Article

Disks Busy vs. ASP Busy in Robot Monitor

Did you know that the Disks Busy monitor reports the average percentage across all your ASPs, not just System ASP? You could be teetering near an I/O overload and not know it! If you have multiple ASPs, use the ASP Busy monitor instead. Here’s why.
Article

High Availability Fail Tales (and How to Avoid Them)

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.
Article

Monitoring the Demands of Fast Disk

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.
Article

Small but MIGHTY: Controlling the *CLS Object Type

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.
Article

Database 101: Why You Can Rely on IBM i

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.
Article

How Banks Leverage Big Data for Big Value

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.