News - Built on Power

2021-09-07

Logicmate’s partnership with Profound Logic

Here at Logicmate we understand the challenges of running what’s referred to as a legacy system on an IBM i due to the retiring workforce of RPG developers increasing as time goes on. This is one of the reasons we have partnered with profound logic, to eliminate those challenges, and to use your IBM i as a truly modern and digital platform. These revolutionary products will empower your teams to build new IBM i business systems, integrate applications, and most importantly make IBM i development simpler and faster so you can confidently navigate the future. For more information on these products or for an in depth demo please get in touch with Louise, Business development manager at Logicmate Ltd https://www.linkedin.com/in/louise-ea… ****************************** LETS CONNECT! Twitter – https://twitter.com/LogicmateL Linkedin – https://www.linkedin.com/company/logi… Youtube – https://www.youtube.com/channel/UC6sP… Website – https://www.logicmate.co.uk/

From: Logicmate

2021-09-07

TLAForms – SQL to use data from IBM i files

Create SQL statements within the designer to retrieve data from your IBM I files using our SQL tool, or use your own custom SQL Select statement. Check out the video to see just how easy it is to use SQL in TLAForms.

From: TLAshford

2021-09-07

Barcode400 and TLAForms in conjunction with Friedman Corporation

Barcode400 and TLAForms integrate easily with the Friedman Corporation Frontier ERP Software for IBM i. Learn how TL Ashford Software for forms and labels generates directly from your Friedman ERP System.

From: TLAshford

2021-09-07

ncdu – IFS Disk Space Analyzer

If we want to check the disk space occupied by IFS files and directories, we have the possibility to install a great utility, NCDU, which allows us to quickly navigate inside IFS (but also inside QSYS.LIB) in search of the largest directories and therefore of the bigger files

The operation is very simple … just install ncdu with yum from an SSH session (putty or ACS SSH Terminal)

yum install ncdu

then go to the main directory ‘/’, always in the SSH environment and type the following command (where I exclude the directories that I do not want to scan with ncdu)

ncdu -x / –exclude /QSYS.LIB –exclude /QOpenSys –exclude /QIBM –exclude /QNTC –exclude /mount

The result is a screen like the one below where you can immediately see the largest directories at a glance and go down with the arrows inside them to navigate in the sub-directories up to the files, always in order of size:

Warning: from ncdu it is also possible to delete files or folders with the ‘d’ option … pay attention …

For example, I discovered very large dump files in the / home directories of developer users … and the ‘d’ option was very useful!

—
Roberto De Pedrini
Faq400.com

2021-09-05

How to Query the MSF Journal to Find Specific Entries

This document describes how to use SQL to query the QZMF journal.