As cyber threats become more sophisticated, strong encryption is essential. Attend this free POWERcast to learn how to quickly encrypt sensitive data on IBM i—and avert a data breach disaster.

As cyber threats become more sophisticated, strong encryption is essential. Attend this free POWERcast to learn how to quickly encrypt sensitive data on IBM i—and avert a data breach disaster. ow.ly/ingW50I69Uv pic.twitter.com/UA9Jd6ysBh

– COMMON (@COMMONug)08:02 – Mar 08, 2022

Media library information with SQL

A recent upgrade to a new virtual tape library, VTL, product introduced me to the concepts of a tape library and to a new command Work with Media Library Status, WRKMLBSTS. The system admins came to me asked if there was a way I could get to the same information as is displayed by WRKMLBSTS.

They had become frustrated with the command as it did not offer the ability to output its results to an outfile or a spool file, that they would then copy to a file.

“Is there something in SQL you can work your magic with?” they asked.

A quick search of IBM’s documentation portal gave me what was needed, a view called MEDIA_LIBRARY_INFO.

Read more »

Security Bulletin: Due to use of Apache Log4j, OmniFind Text Search Server for DB2 for i is vulnerable to arbitrary code execution (CVE-2021-4104)

There is a vulnerability in Apache Log4j (CVE-2021-4104) as described in the vulnerability details section. Apache Log4j v1 is used by OmniFind Text Search Server for DB2 for i for generating logs and diagnostic traces in some of its components. IBM has addressed the vulnerability in OmniFind Text Search Server for DB2 for i by removing Apache Log4j.

Verified by MonsterInsights