Resources
Article

If It Has Moving Parts, Someday It's Going to Fail.

Sat, 11/03/2018
Check out IBM's new READ INTENSIVE SSDs. This is a note to highlight some of the pros and cons - and dig a little deeper into one of the cons - of IBM's recently announced new class of solid state disk drives, "read intensive" (RI) SSDs. The new RI-SSD comes in one flavor, a 1.86 TB drive. The new concept to wrap your head around is that the drive will "wear out" if you write too much over the...
Powertech Compliance Monitor for IBM i
Article

Managing Your IBM i Audit Data

By Robin Tatam on Wed, 08/01/2018
Let’s face it; system administration remains a largely thankless task. From scheduling jobs to balancing workloads to answering messages in QSYSOPR, administrators and operators work diligently behind the scenes to ensure that IBM i servers are available to run mission-critical applications.
Compliance
Article

How to Download an ODBC Driver

Wed, 07/25/2018
Performance Navigator® requires an ODBC connection to connect to your IBM i system, but it does not come with your PC’s operating system. IBM has a downloadable they’ve titled Access Client Solutions, which we recommend our customers use to get that ODBC connection.
Article

FAQs about Performance Navigator

Thu, 07/12/2018
Will this product hurt the performance of my IBM i®? You will not even notice that the product is working. The data gathering software is already part of the OS. I currently have a subscription to IBM's PM for Power service. How is Performance Navigator compared to PM? Glad you asked... Performance Navigator uses exactly the same input as PM for Power, Collection Services. Performance Navigator...
Article

Use Conditional Logic in Sequel Data Access to Convert Data into Meaningful Information

By Mike Stegeman on Thu, 03/30/2017
Let’s face it, the amount of data that we have is only continuing to grow, which will become harder to manage and understand. Per IDC Research, 90 percent of data in the world today was created in the last two years, and in 2016, we entered the zettabyte era. A huge challenge for everyone is finding the best way to convert all their data into meaningful information. But that can be tricky. If...
IBM i Business Intelligence
Data Integrity Monitoring graphic
Article

How To Maintain Your Data Integrity

By Robin Tatam on Tue, 03/21/2017
File Integrity Monitoring (FIM) helps ensure that your critical and sensitive data is viewed and changed only by authorized personnel through approved channels. Candidates for FIM include application files containing sensitive data, such as personnel or financial data, and server configuration files.
Infrastructure and Data Protection
Article

Enhance Your Reporting with Sequel Date Functions

By Heath Kath on Fri, 01/06/2017
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.
IBM i Business Intelligence
Article

Anydate: Go Back to the Future

Fri, 01/06/2017
Take time into your own hands. Discover the benefits of testing future dates, rerunning past reports, and more with date simulation software.
IBM i Business Intelligence
Article

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

By Heath Kath on Thu, 12/01/2016
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...
IBM i Business Intelligence