IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

how to identify user id that has edited a record in IMS DB


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Nagendran

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Thu Feb 14, 2008 7:47 pm
Reply with quote

Hi,

Is there any way to identify the person who deleted or edited a record in
IMS DB?

Thanks,
Nagendran.R
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Thu Feb 14, 2008 7:49 pm
Reply with quote

how big is the need to know ?
Back to top
View user's profile Send private message
Nagendran

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Thu Feb 14, 2008 7:55 pm
Reply with quote

A record was got deleted from the test database in which i have loaded.

I am just researching is there any way to identify the userid or the program id which was used for deleting.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Thu Feb 14, 2008 8:03 pm
Reply with quote

the only way which comes to my mind is to process the logs ,
you should be able to identify the program who did it and the racf userid
for mpp if I remember correctly You should be able to find the tranid and the terminal where the transaction originated
long time since I had the need to do it
the longest time was to find out the right log,
and if somebody run a change accum and got rid of the older logs You might be out of luck

not worth the hassle for test environment
Back to top
View user's profile Send private message
Nagendran

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Thu Feb 14, 2008 8:13 pm
Reply with quote

Hi,

Thanks for your speedy response..

Could you please tell me how to identify the log dataset for MPP? Actually the claim got deleted two days before via online. Our online region will goes down every day for minimum 30 minutes. Will the log dataset still persist in the system?

Thanks,
Nagu
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Thu Feb 14, 2008 8:20 pm
Reply with quote

it depends on the procedures and practices used for the test environment
the log might still be there, but the IMS management procedures in the test environments
are usualy more relaxed than in the production environment,

You might be better off speaking to the support group about Your need,
they will certainly tell You everything... good luck
Back to top
View user's profile Send private message
Nagendran

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Thu Feb 14, 2008 8:24 pm
Reply with quote

Thank you very much :)
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Thu Feb 14, 2008 8:29 pm
Reply with quote

I forgot to tell You,
investigate with your support group, what tools they have available for IMS log analysis,
the might have something related to your need

a google search on "IMS LOG ANALYSIS" might also give You more hints on how to proceed

( my suggestion was a BRUTE FORCE approach )
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1104
Location: The Netherlands at Hole 19

PostPosted: Fri Feb 15, 2008 5:37 pm
Reply with quote

Like enrico said it depends on your organisation. From the first link in the sticky where to find info about IMS after searching for 'message log' you migt have found a lot of info like this
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 8
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts FINDREP - Only first record from give... DFSORT/ICETOOL 3
No new posts To find whether record count are true... DFSORT/ICETOOL 6
No new posts PuTTY - "User is not a surrogate... IBM Tools 5
Search our Forums:

Back to Top