A Better Way to View IBM i Journal Contents?

December 9, 2014 Alex Woodie

IBM provides a fairly suitable command, DSPJRN, for retrieving journal information. It tells you why the data in a file changed, which program changed, and what user was responsible. The only thing it doesn’t do well is show you actual contents of the file. That’s where a new command from iData Development Limited comes in.

You can get to the journal data in DSPJRN, but only if you’re good at doing backflips, according to Mark Golden, the principle at iData, which is based in the UK. “You could display it on the screen and, by using various function keys from within DSPJRN, you can see the data,” Golden tells IT Jungle. “However, you still have to work out data positions, read hex data, and other things to see what you want.”

Golden thinks he has come up with a better solution with his new RTVJRN command. The command builds on top of DSPJRN to display the contents of the journal in, as Golden calls it, “a nice readable format.”

Viewing the contents of a file using the DSPJRN command is not easy.

The command starts with the DSPJRN command and uses various programs and SQL scripts to extract the file data and match it up with its journal data, thereby enabling users to see the journal data and the database file in the same record. The command also allows users to restore data.

The RTVJRN command will be handy for troubleshooting and fixing stuff that goes wrong in IBM i apps. For example, consider a program that suddenly stops after working fine for years. You, the programmer, aren’t aware of any changes that have been made, but it stopped working nonetheless. You could dive into using IBM’s DSPJRN command and hope that the data suitably lines up so you can diagnose what went wrong. Or you can use RTVJRN to see the contents of the journal without all the gymnastics.

Here’s the same content as displayed using Golden’s RTVJRN command.

Golden hopes to make the software available for download from his website at www.iexlsoftware.com soon, but for now interested parties can retrieve the command by sending an email to Golden at rtvjrn@gmail.com. The command will be free to try, and licenses will be available for $100.

IBM i Excel Spreadsheet Generator Now Unicode Compliant

                     Post this story to del.icio.us
               Post this story to Digg
    Post this story to Slashdot

Tags:

CYBER-ATTACKS ON THE RISE. PROTECT WITH THE TRIPLE PLAY.

COVID-19 has not only caused a global pandemic, but has sparked a “cyber pandemic” as well.

“Cybersecurity experts predict that in 2021, there will be a cyber-attack incident every 11 seconds. This is nearly twice what it was in 2019 (every 19 seconds), and four times the rate five years ago (every 40 seconds in 2016). It is expected that cybercrime will cost the global economy $6.1 trillion annually, making it the third-largest economy in the world, right behind those of the United States and China.”1

Protecting an organization’s data is not a single-faceted approach, and companies need to do everything they can to both proactively prevent an attempted attack and reactively respond to a successful attack.

UCG Technologies’ VAULT400 subscription defends IBM i and Intel systems against cyber-attacks through comprehensive protection with the Triple Play Protection – Cloud Backup, DRaaS, & Enterprise Cybersecurity Training.

Cyber-attacks become more sophisticated every day. The dramatic rise of the remote workforce has accelerated this trend as cyber criminals aggressively target company employees with online social engineering attacks. It is crucial that employees have proper training on what NOT to click on. Cyber threats and social engineering are constantly evolving and UCG’s Enterprise Cybersecurity Training (powered by KnowBe4) is designed to educate employees on the current cutting-edge cyber-attacks and how to reduce and eliminate them.

A company is only as strong as its weakest link and prevention is just part of the story. Organizations need to have a quick response and actionable plan to implement should their data become compromised. This is the role of cloud backup and disaster-recovery-as-a-service (DRaaS).

Data is a company’s most valuable asset. UCG’s VAULT400 Cloud Backup provides 256-bit encrypted backups to two (2) remote locations for safe retrieval should a cyber-attack occur. This is a necessary component of any protection strategy. Whether a single click on a malicious link brings down the Windows environment or an infected SQL server feeds the IBM i, once the data is compromised, there is no going back unless you have your data readily available.

Recovery is not a trivial task, especially when you factor in the time sensitive nature of restoring from an active attack. This leads to the third play of the Triple Play Protection – DRaaS. Companies have myriad concerns once an attack is realized and a managed service disaster recovery allows employees to keep focus on running the business in a crisis state.

The combination of training employees with secure backup and disaster recovery offers companies the best chance at avoiding financial disruption in an age of stronger, more frequent cyber-attacks.

Reach out to UCG Technologies to discuss your company’s security needs and develop a data protection plan that fits you best.

ucgtechnologies.com/triple-play

800.211.8798 | info@ucgtechnologies.com