Solved

Deleted Records

Posted on 2002-03-28
4
332 Views
Last Modified: 2008-03-10
This question is for PS Price.

You had answered a question about getting deleted records back by creating a save file, and then you stated that you programatically were able to restore the records by changing the delete indicator.

I have created the save file on the file that record were deleted.  What I really need to know is who (User or Program) deleted the records?  Will there be a field in the save file that would allow me to programatically get that information.  And after you create the save file, what are the steps inbetween to find the indicator?  Hence, what would that indicator's field name be?  Or, is it after I create the save file that I need to do a CL command such as DSPOBJD?

Thanks.





0
Comment
Question by:KimberlyMinarik
4 Comments
 
LVL 1

Expert Comment

by:jjjjjjj
Comment Utility
I'm not PS Price, but here is a tip:

You can see if the file was journaled by typing wrkjrn at the command line and prompting.  You will see *all come up in the journal field.  Press enter.  Hopefully you have a journal for the file in question.  If the person who created the journal uses an intelligent naming convention, you can find out if it exists rather easy by looking for a journal that has the same name as the file, something like itemjrn or demandjrn.

If it does, you can do DSPJRN.  This is a lengthy process, but it will get the data you are looking for.

Let me know what you find using the wrkjrn command.  If it the journal exists, your about 1/2 way there.

jjjjjjj
0
 

Author Comment

by:KimberlyMinarik
Comment Utility
There was no journaling on this file.
0
 
LVL 1

Accepted Solution

by:
jodo741309 earned 200 total points
Comment Utility
System wise, journalling is really the only way to see who deleted a record in a file.  Programatically, your software vendor may have implimented something like writing the deleted records to a history file, for example.
0
 

Expert Comment

by:ComTech
Comment Utility
jjjjjjj, I will leave a question for you in this same Topic Area, as I believe you have a very good answer.

ComTech
CS Admin @ EE
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
In this article, you will read about the trends across the human resources departments for the upcoming year. Some of them include improving employee experience, adopting new technologies, using HR software to its full extent, and integrating artifi…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now