• Journaling on i5 when updating from .net

    We need to update some i5 files (under v6r1) from SQL in a .NET environment. Can I control this process via SQL or will I need to call CL commands from .NET to start/stop journaling & commitment control?

    ZIS5 pointsBadges:
  • Journal Receiver Deletion and CPF7024

    Receiver is detached and saved.  Cannot delete.  Error code CPF7024  tells me fo force the changes to auxiliary storage before deletion.  I don't have a clue.  I don't see any problem with the setup. Had to get an exclusive lock on the objects in order to stop journalling and delete the...

    Modiyooch540 pointsBadges:
  • How to know if AS/400 data is journaling properly?

    How we can know that Data is Journaling proparly or not?

    Sms121185 pointsBadges:
  • Auditing User Access in AS/400

    I am trying to figure out how to audit user access at the record level. In the Audit Journal the entry types ZC and ZR tell me at the file level who has opened a file for Change or Read. In the Journal, the Journal code of R along with the type code will give me information on who has added,...

    wpoulin2,480 pointsBadges:
  • How do I retrieve data from an AS/400 journaled file?

    I need to retrieve the after data from a file that was hournaled and I am not sure how to do that.

    AS400X35 pointsBadges:
  • AS/400 Journal entry type IZ

    Hi, I have a journal entry of type IZ and I was wondering what causes this to be generated? The documentation says it is from an INZPFM command but the program specified on the journal entry does not execute this command.

    Ianjda30 pointsBadges:
  • 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:
  • Retrieve Journal Receiver Attributes

    We have different Environments on our Productions system with separate Journals and their corresponding Journal Receivers. Using a CL Program i want to retrieve the Journal Receiver Attributes of all the curently attached Journal Receiver in the system.

    Haaiderali215 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,160 pointsBadges:
  • AS/400 journaling

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

    ten20081,150 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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