Resources

Blog

What’s New in IBM i 7.2?

May 2, 2014 marked another milestone for the IBM i OS. IBM continues to expand its technology support with its latest release, IBM i 7.2. Take a closer look at the new features you’ll want to know about.
Article

Where to Start with IBM i Operations

Have you recently adopted an IBM server running IBM i and don’t know where to begin with system operations? You are not alone.
Blog

Is Your Team A Little Rusty on IBM i Operations?

Let’s be honest. Finding good training for your staff and instructors who really know IBM i can be an issue. Luckily, Fortra offers essential training on IBM i operations from experts with over 20 years of experience.
Article

Add Power to SEQUEL Scripts with Logic

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.
Press Release

H.I.G. Capital to Acquire HelpSystems, LLC (now Fortra, LLC)

H.I.G. Capital, LLC ("H.I.G."), a leading global private equity investment firm with $19 billion under management, has entered into a definitive agreement to acquire Fortra, LLC (“HelpSystems”, or the “Company”). The completion of the transaction is subject to regulatory and anti-trust approval.
Guide

The Query Decision-Making Kit

Is Query/400 still cutting it? Probably not. You’ve most likely heard that there are other data access tools out there, but you might not be sure which one is right for you—or even if it’s the right time to upgrade. The Query Decision-Making Kit can help. For starters, you want data access to be simple, no matter your skill level. You want the option to view visual data in real-time, access data...
Article

The Partitioning Paradox Solved

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

Easily Accessing Data on Remote Databases with SEQUEL

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

Get Started with Remote Database Access

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

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

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

Staying on IBM i Sounds Like Money in the Bank

As the end of 2013 draws near, many businesses have budgets on their minds. Most companies will run year-end numbers to determine the full scope of their investments, and analyze what sort of changes can be made to cut costs and increase profit margins. As the number crunching begins, it’s time to consider numerous variables, including those that fall under the IT department. Decisions made within...
Article

SEQUEL Works with your Growing (BIG) Data

As you collect more information, your relational database files continue to grow and you’re faced with a challenging issue: how to handle all of that information efficiently and accurately, and how to overcome the obstacle of mining and delivering useful information without bogging down the system. Partition files are the solution to BIG DATA on IBM i because of: Improved manageability for...