2021 Virtual IBM i Security Event [12:00PM BST]

Please join us for an educational discussion about the topic that’s on all of our minds—cybersecurity.

About this Event

Join IBM i security expert Robin Tatam for a discussion that will provide insight and answers about cybersecurity, today’s top corporate initiative.

Security and compliance affect every facet of a business, making them two of today’s top corporate concerns. Robin is on a mission to provide clarity and guidance around cybersecurity and how it relates to Power Systems.

Without leaving your desk, you can join us for an abridged version of the event that draws 5-star ratings from audiences around the world.

Join this exclusive online gathering to learn:

• What working from home and Covid-19 mean for your IBM i server

• Cybersecurity trends and risks

• How compliance differs from security

• What we have learned from our annual State of IBM i Security Study

• What’s new in security for IBM i

• How to get started securing your server and your databases

To register for this event, please select the register button and fill out the form.

We hope to see you on the 13th July!

Open PGP for IBM i (iSeries)

GoAnywhere MFT for IBM i (iSeries) includes native commands for performing PGP encryption and decryption functions directly on the IBM i (formerly known as and often still called AS/400). These commands can be placed in CL programs, the job scheduler or run from IBM i menus.

With GoAnywhere MFT, files can additionally be digitally signed with a private key on the IBM i. In turn, you can verify your partner’s signature with their public key.

Achieve PGP encryption with the IBM i Open PGP Encryption Command

Have you tried our free PGP file encryption tool? Download Open PGP Studio today. Or, for full PGP automation, start a 30-day GoAnywhere trial and see what you can achieve with MFT for IBM i.

GoAnywhere MFT’s Open PGP encryption and decryption processes have been verified for interoperability with many other PGP products, including GPG (GnuPG).

Open PGP Key Management

A comprehensive Key Manager is provided in GoAnywhere MFT for IBM i to allow for the management of PGP public and private keys. The Key Manager in GoAnywhere can be used to create keys, change keys, view keys and import keys. These keys can be utilized within GoAnywhere MFT for automating Open PGP data encryption and decryption within your organization. This Key Manager can also be used to export public keys for sharing with your trading partners.

Request a quote to automate file encryption on the IBM i using GoAnywhere MFT’s PGP software.

IFS – Find files and directories in your IFS – BlogFaq400

I take advantage of a question asked on the Midrange.com discussion groups ( Is there an easy way to find a file in IFS? ) to summarize, in this post, some different ways to search for a file within one or more IFS directories. The specific question was … “is there something to look for in IFS objects like WRKOBJ command we use in IBM i environment in QSYS library?”

If we “navigate” in our IFS starting from QSH, remember that we are in a world very similar to Linux and therefore several Linux commands work very well here too!

Suppose we have one IFS directory “/ f4docs” where there are thousands of files and subfolders. Let’s see different types of research and the different possibilities we have from the IBM i environment or from QSH:

1 – FIND command from QSH or SSH: we see in this a search of all the files in the directory “/ f4docs” of type “.TXT” with the name containing “02342” … including any subdirectories

find /f4docs -name “*02432*.TXT”

2 – FIND + GREP command from QSH or SSH: the problem with FIND is that it is always case-sensitive in QSH environment … if we need to filter only certain files not taking into account the “case” character:

find /f4docs -type f -name “*02432*” | grep “.txt” -i

3 – Command FIND + GREP (to also search inside the contents of the fil es), from QH and SSH: by slightly modifying the syntax of the GREP part, it is also possible to search for files with a certain content (in this case the string “MOTO”

find /f4docs -name “*.TXT” -exec grep -l ‘MOTO’ {};

4 – With SQL and QSYS2.IFS_OBJECT_STATISTICS : an interesting alternative to search for IFS files and objects is SQL with IBM i Services … in particular QSYS2.IFS_OBJECT_STATISTICS

Select * from Table (QSYS2.IFS_Object_Statistics (Start_Path_Name => ‘/ f4docs’, Subtree_Directories => ‘YES’)) x Where Lower (Path_Name) like ‘% 02432%’;

5 – With RTVDIRINF and SQL on the created catalog tables:

// first, delete RTVDIRINF result tables

DLTF QSURSYS/QAEZD0001I
MONMSG MSGID(CPF0000)
DLTF QSURSYS/QAEZD0001D
MONMSG MSGID(CPF0000)
DLTF QSURSYS/QAEZD0001O
MONMSG MSGID(CPF0000)

// then collect data from your directoy

RTVDIRINF DIR(‘/f4docs’)

// and search your files

SELECT o.Qezalcsize
,SUBSTR(o.Qezobjnam, 1, 40)
,d.Qezdirnam1
FROM qusrsys.Qaezd0001o o
INNER JOIN qusrsys.Qaezd0001d d
ON o.Qezdiridx = d.Qezdiridx
WHERE 1=1
and qezobjtype=’*STMF’
and UPPER(o.Qezobjnam) LIKE ‘%02432%’
ORDER BY o.Qezalcsize DESC;

6 – With Powershell and Findstr if the IFS directory is shared – share: if we want to search inside the contents of the files from Windows, we can use the PowerShell and the Findstr command, pointing to a shared IFS directory … with a really interesting speed. If we want, for example, to search for files that contain the word “MOTO” …. as in example 3 above, but using FINDSR the syntax is as follows:

findstr /s /i /c:”MOTO” \myIBMif4docs*.TXT
/s search in al subdirectories
/i case insensitive
/c: search string

7 – Updatedb and Locate, open source utility from the Linux world … they allow a quick search using all the potential of regular expressions.

updatedb -l0 -U /f4docs -o /tmp/myindex
locate -d /tmp/myindex 02342


Roberto De Pedrini
Faq400.com

The Power of 10: Discover the Power10 experience

10:00 AM – 10:05 AM GMT +1 / 11:00 AM – 11:05 AM Your local time   (5 min)

10:05 AM – 10:10 AM GMT +1 / 11:05 AM – 11:10 AM Your local time   (5 min)

10:10 AM – 10:15 AM GMT +1 / 11:10 AM – 11:15 AM Your local time   (5 min)

10:15 AM – 10:25 AM GMT +1 / 11:15 AM – 11:25 AM Your local time   (10 min)

10:25 AM – 10:30 AM GMT +1 / 11:25 AM – 11:30 AM Your local time   (5 min)

10:30 AM – 10:40 AM GMT +1 / 11:30 AM – 11:40 AM Your local time   (10 min)

10:40 AM – 11:00 AM GMT +1 / 11:40 AM – 12:00 PM Your local time   (20 min)

Verified by MonsterInsights