Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 10274
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: 10274
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: 10274
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: 10274
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 Could we identify the called modules ... elixir1986 COBOL Programming 5 Fri Jul 14, 2017 1:53 am
No new posts Identify top 30 big tables or indexes... ashek15 DB2 0 Fri Jun 16, 2017 10:01 am
No new posts Need to write record of PS File in ex... Chandan1993 JCL & VSAM 1 Wed Jun 07, 2017 1:35 am
No new posts Job failing with USER = 4093 REASON C... Pradeepa S ABENDS & Debugging 1 Wed May 17, 2017 3:35 pm
No new posts Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us