• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • 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.

    RELATED STORY

    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

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    Eradani

    API Enable Your IBM i Today

    Create & Manage Secure, High Speed, APIs for IBM i with Eradani Connect!

    o Automatically schedule and track shipments

    o Communicate with IoT devices

    o Connect to Amazon, Shopify and others

    o Automate order processing

    o Create mobile and web user interfaces

    o Generate Open API Swagger Documentation

    Eradani Mentors will ensure your success!

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    NGS:  Attend our FREE COMMON Virtual Session on integrated reporting & BI from your desk! Dec 16.
    Profound Logic Software:  Now On-Demand Webinar: "See What i Can Do with Mobile Applications"
    BCD:  Beat Your Q4 Numbers with Real-Time Analytics on IBM i. Watch video!

    More IT Jungle Resources:

    System i PTF Guide: Weekly PTF Updates
    IBM i Events Calendar: National Conferences, Local Events, and Webinars
    Breaking News: News Hot Off The Press
    TPM @ EnterpriseTech: High Performance Computing Industry News From ITJ EIC Timothy Prickett Morgan

    IBM Pulls The Plug On Old Peripherals End of Year Feedback

    Leave a Reply Cancel reply

Volume 14, Number 24 -- December 9, 2014
THIS ISSUE SPONSORED BY:

Maxava
Fresche Legacy
System i Developer
Computer Keyes
WorksRight Software

Table of Contents

  • Enforcive’s Cross-Platform Security Mandate
  • IBM Delivers Tech Preview for iAccess on Mobile Devices
  • IBM Issues More POODLE Patches, Warns Not to Use SSLv3
  • A Better Way to View IBM i Journal Contents?
  • Most Innovative IBM i Products: A FHS Year in Review
  • Jack Henry Sharpens Digital Marketing with ‘Kernel’
  • BCD Advances PHP-on-i Development in WebSmart
  • ManageEngine Bolsters Password Sync Tool
  • Simulated Role Swaps–Maxava’s Secret Weapon
  • IBM: CMOD for i ‘Alive and Well’

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • COMMON Set for First Annual Conference in Three Years
  • API Operations Management for Safe, Powerful, and High Performance APIs
  • What’s New in IBM i Services and Networking
  • Four Hundred Monitor, May 18
  • IBM i PTF Guide, Volume 24, Number 20
  • IBM i 7.3 TR12: The Non-TR Tech Refresh
  • IBM i Integration Elevates Operational Query and Analytics
  • Simplified IBM i Stack Bundling Ahead Of Subscription Pricing
  • More Price Hikes From IBM, Now For High End Storage
  • Big Blue Readies Power10 And IBM i 7.5 Training for Partners

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2022 IT Jungle

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.