• How to get the output of journal data like a physical file data to use in STRSQL?

    HI All, Normally DSPJRN is used to display the Journal, but however its not in a understandable way. Can any one suggest how to get the output of journal data like a pfhysical file data to use in STRSQL.

    Kar425 pointsBadges:
  • How do I restore without starting journaling?

    all of the documentation talks about starting the journaling process. I want to actually restore a production library without invoking journaling on the restored library.

    Timk195920 pointsBadges:
  • File update

    Hi, Is there any way to know whihc program updated a specific record of a file without the journals IN as400?

    Rockleadme385 pointsBadges:
  • Recovery of PF data from journal

    Hi All, Consider the case, some one has accidentally deleted all records in a PF and that file is Journaled, Is it possible to recovery the records from receiver attached. if so, how can we do it?

    Kar425 pointsBadges:
  • VB updates to DB2 table.

    Why does as DB2 table need journaling when doing updats from VB SQL? Our setup is SQL, link server, local DSN to AS400.

    SittingBull25 pointsBadges:
  • Clearing the Joural Entries attached for a receiver

    Ex: Run DSPJRN JRN01, and you can see the list of entries of changes. Can someone explain me, how to clear the above list without deleting receiver?

    Kar425 pointsBadges:


    Veena5 pointsBadges:
  • Journalling Physical file

    Hi, Can i use a ovrdbf command to a physical file which is not journaled?

    Siddharth90245 pointsBadges:
  • qmqry error – Help!

    Can anyone help? I have a clp application that calls a qmqry which reads a large sales transaction file and selects and creats a small summary file of certain transactions for a certain typpe of part and date range. This sales transaction file is journaled and the file it creates becomes journaled?...

    Lnspgm15 pointsBadges:

    A friend of mine has an issue on hand: One of his team mates accidentally deleted a User Profile & its associated objects on the system. As a result the entire application has gone down now & is inaccessible. A complete backup (ref-A)was taken at this point. He has restored the database back from...

    Roydcunha10 pointsBadges:
  • Journaling-does it reflect a record change when iSeries file has been updated outside of this environment?

    First of all I want to note that we journal all our files on the iSeries where I work at now.  I want to mention that long ago where I worked at before, we had to get into the journals to discover what was causing records to be deleted randomly and no one could find out what program was causing...

    Dabuckley515 pointsBadges:
  • Can we track if max active thread number in AS/400 has been changed by a user via journal receiver

    Can we track if max active thread number has been changed by a user via journal receiver using dspaudjrne

    JohnsonMumbai1,480 pointsBadges:
  • AS/400 journaling

    Does journalling process have an impact on the overall system performance?

    ten20081,150 pointsBadges:
  • Journalling PF in AS400

    Hi, I would like to know when a PF is added with some new entries, or the existing entries been modified.  I require a report to be printed with the users and time of update.  How this could be achieved easily?

    Rajgoaj280 pointsBadges:
  • How to list Journaled files to an Outfile

    Hi.  Is there an easy way to get a list that will provide information on which physical files are being journaled within a library?  For some reason, I can not find it, but thought it would be available through one of the DSPFD outfiles, but I haven't found it, nor have I been able to find it...

    jamesm33330 pointsBadges:
  • Journaling a file

    Hi,   I recieve the following error when i journal a file Damage prevents object  from being journaled.    Cause . . . . . :   A damaged object previously journaled to this journal       prevents journaling from being started for object in library   type *QDDS.  If the object is an...

    Knowledgeseekerone30 pointsBadges:
  • How to clean up AS/400 receivers when those are in online status?

    Hello All, The situation – There was a user's job which was gone into the loop and caused in huge number of journal receivers which was gone up to more than 2045 (Approx 3000). We have killed the job which was causing this and the situation was under control.Nit400

    Nit40030 pointsBadges:
  • Journaling and Commitment Control

    If I have journaled a file with After Update parameter, how will the commit/rollback work??

    Reenasudarshan65 pointsBadges:

    Our AS400 has been having jounal entries show up in QGPL. They are taking alot of disk space. How can I identify what is creating this journals and how do I stop them from being generated. I tried a DSPJRN command and did not get much info Thanks Donn

    Donn20 pointsBadges:
  • Seeing where a member is deleted in a journal

    I have a situation where a member is being created in a physical file and is later being deleted by some process, human or automated. I'm trying to find what is removing the member and set up a journal to find the answer. I am able to readily see where the member is created, where records are added...

    Tsettimo35 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.