Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1319
  • Last Modified:

Track journaling pf on ibm iseries AS/400 machine for os user?

os/400 ibm iseries server to tack user changes on pf
0
SunshineVK
Asked:
SunshineVK
  • 2
  • 2
1 Solution
 
daveslaterCommented:
Hi
what is it you want? the heading is not very helpful!

You can create a journal receiver (CRTJRNRCV)
Then create a journal CRTJRN specifying the receiver.
Then attach the files to the journal STRJRNPF.

you then use the DSPJRNcommand to show what has changed.

if you want to show who has looked at records, added as well as changed them then you can use a database trigger and write your own audit.

Dave
0
 
SunshineVKAuthor Commented:
Hello Dave,
Thanks for your immediate response.
We already have a journaled environment on the iSeries. What we are looking out is for a method to read the Journal entries. I have generated a couple of reports with the command DSPJRN and CMPJRNIMG, but from the data displayed in  "√ČNTRY SPECIFIC DATA" column, we are not able to make out which particular field in the physical file is updated / deleted and also some of the data is in the formn
 of junk characters.
Is there a way to generate a report in a more readable format without using a third party tool as this is an audit requirement? Does using the command RTVJRNE in a CL prog help?  
0
 
daveslaterCommented:
What I have done in the past is.

Use the DSPJRN file to create an output file of the records you want in this example I am using "My_Jrn_File"

Use SQL to extract the data element of the file.
create table My_Jrn_Data as (select JOESD from My_Jrn_File)  with data  

then remove the field from the outfile
ALTER TABLE My_Jrn_File DROP COLUMN JOESD CASCADE

They create a copy of the database the records were created from, I use cpyf with the CRTFILE(*Yes) parm.
eg
Cpyf Jrn_Db tofile(Copy_Jrn_Db) mbropt(*replace) crtfile(*yes) torcd(1)


finally copy the myJRNdATA to the file created above
eg
Cpyf  My_Jrn_Data tofile(Copy_Jrn_Db) mbropt(*replace) Fmtopt(*Nochk)

you can then link the data to the in My_Jrn_File & Copy_Jrn_Db by RRN in sql
select * from My_Jrn_File A,  Copy_Jrn_Db B where rrn(a)=rrn(b).

Dave
0
 
tliottaCommented:
SunshineVK:

Also review this EE item closely:

http://www.experts-exchange.com/Q_21347686.html

It's a little more complex than Dave's example, but it might help illuminate what can be done. If the first couple of preparatory steps are done, you can create a general proc that will automate this for any journaled table.

Tom
0
 
SunshineVKAuthor Commented:
Thanks Tom & Dave.
Problem was resolved using Daves suggestion.
Thanks for inputs Tom.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now