Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
how to identify user id that has edited a record in IMS DB

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
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    Post subject: how to identify user id that has edited a record in IMS DB
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10326
Location: italy

PostPosted: Thu Feb 14, 2008 7:49 pm    Post subject: Reply to: how to identify user id that has edited a record i
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    Post subject: Reply to: how to identify user id that has edited a record i
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10326
Location: italy

PostPosted: Thu Feb 14, 2008 8:03 pm    Post subject: Reply to: how to identify user id that has edited a record i
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    Post subject: Reply to: how to identify user id that has edited a record i
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10326
Location: italy

PostPosted: Thu Feb 14, 2008 8:20 pm    Post subject: Reply to: how to identify user id that has edited a record i
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    Post subject: Reply to: how to identify user id that has edited a record i
Reply with quote

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

Global Moderator


Joined: 14 Mar 2007
Posts: 10326
Location: italy

PostPosted: Thu Feb 14, 2008 8:29 pm    Post subject: Reply to: how to identify user id that has edited a record i
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: 1105
Location: The Netherlands at Hole 19

PostPosted: Fri Feb 15, 2008 5:37 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Copy 4 byte of data from the last rec... arunsoods DFSORT/ICETOOL 9 Fri Oct 06, 2017 12:15 pm
No new posts User access certification In Mainfram... Virendra Shambharkar All Other Mainframe Topics 4 Tue Oct 03, 2017 12:32 pm
No new posts Updating the Trailer count in variabl... satheshbabur DFSORT/ICETOOL 6 Wed Aug 30, 2017 9:49 pm
No new posts Repeat part of record multiple times Learncoholic DFSORT/ICETOOL 4 Tue Aug 29, 2017 11:33 am
No new posts Move from Comp3 variable to Edited Va... sreekusr COBOL Programming 8 Thu Aug 10, 2017 4:20 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us