I want to delete journal receivers in a library that have the the status of SAVED. Can anyone offer some CL code to do this in a program? Each receiver begins with AMQA and followed by 6 numerics. I guess I would write out to an outfile then read the outfile to delete the receivers.
Answer Question | April 30, 2013 7:11 PM
AS/400, AS/400 journaling, CL Program
Hi experts, Does Hibernate require AFTER and BOTH the Images of Journalling (Journalled files). Please let us know. Or After image alone is enough for Hibernate? AFTER or BOTH images is better to use for database? Thanks , Amutha
Answer Question | February 13, 2013 10:12 AM
AS/400, AS/400 journaling
Sir Tom: I somehow perceived that it’s kinda related to restoring journal receivers so i decided to just attached my concern to Leah Rosin’s “Restoring journal receivers”. Well, going back to the issue, my question was ” i’m able to restore previous journal receivers to the library but after a short time, the restored journal [...]
Answer Question | March 31, 2012 11:52 AM
AS/400 journaling, iSeries Journalling, Journal receiver management, Journal Receivers
How to end all user journals at the same time?
Answer Question | March 31, 2012 10:34 AM
AS/400 journaling, AS/400 user sessions, ENDJRNPF, JRNRCVR
how can we see that what are all the programs that uses a single PF? is that possible to see it?
Answer Question | March 31, 2012 6:25 AM
AS/400 journaling, AS400 physical file, PF, Physical File
we are using RCVJRNE with *TYPE2 for comparing the UB and UP entries to report the changed fields. We are using sequence number to match the the UB and UP entries. Now we are facing a problem Journal sequance number for entry Crossed length of 10 and we are getting journal entry number as ”-1″ [...]
Answer Question | March 31, 2012 5:10 PM
AS/400 journaling, Journaling, RCVJRNE
Should journaling be stopped before a very large file is reorganized?
Answer Question | March 31, 2012 4:14 PM
AS/400 administration, AS/400 File Sharing, AS/400 journaling, Journaling (AS/400)
how to delete jrnl and jrnl rcvr
Answer Question | March 31, 2012 9:05 AM
AS/400 journaling, Journal receiver, Journal receiver management, JRNRCV Attributes
why we can add only 50PF in a jrnl?i need to create a jrnl for usr who has 65PF in his lib?Plz help me
Answer Question | March 31, 2012 10:03 AM
AS/400 journaling, Journal Receivers, Physical Files
Hi, My file has Journaling enabled. we noticed that every once a year few records are getting deleted from file and it is causing us major problems. If I check the journal entries on that date, I am not finding entries for that delation. I have to manually add records and run jobs again. How [...]
Answer Question | July 7, 2011 10:39 PM
AS/400, AS/400 journaling, V5R4
I would need help to write a CL program that accepts fields: a) From Time b) To Time c) From Date (This should be able to be *CURRENT) d) To Date (This should be able to be *CURRENT) I want to only select updates/deletes/changes to files (i.e. no I/O type access etc) Please suggest. [...]
Answer Question | June 23, 2011 3:42 PM
AS/400 journaling, CL programming, CL programs, Journal Program
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?
Answer Question | May 2, 2011 3:41 PM
.NET, AS/400 journaling, CL Commands, i5, iSeries V6R1, SQL Server
hi, please help. can someone tell me how to journal my PF file?
Answer Question | May 19, 2011 10:25 AM
AS/400 journaling, AS400 physical file, Physical Files
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 receiver. I need to [...]
Answer Question | February 14, 2011 9:10 PM
AS/400 journaling, Journal Receivers
How we can know that Data is Journaling proparly or not?
Answer Question | February 5, 2011 5:50 AM
AS/400, AS/400 Data Reports, AS/400 database administration, AS/400 journaling
I need to retrieve the after data from a file that was hournaled and I am not sure how to do that.
Answer Question | November 3, 2010 11:15 AM
AS/400 Data File, AS/400 journaling, Journaling
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.
Answer Question | October 30, 2010 1:24 PM
AS/400 commands, AS/400 journaling, iSeries Journalling, Journaling
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.
Answer Question | October 18, 2010 1:26 AM
AS/400, AS/400 journaling, AS400 physical file, DSPJRN, iSeries, STRSQL
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.
Answer Question | October 16, 2010 9:27 AM
AS/400 administration, AS/400 journaling, CL Program, Journal receiver management, Journal Receivers
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.
Answer Question | October 1, 2010 6:28 PM
AS/400 journaling, AS/400 Library, Backup and restore, Journaling, RSTLIB