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: 10457
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: 10457
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: 10457
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: 10457
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 VSAM - Accessing beyond record size Benchwarmer JCL & VSAM 6 Wed Apr 11, 2018 9:20 pm
No new posts Need to identify top 10 costly or tim... ashek15 DB2 4 Wed Feb 14, 2018 3:20 am
No new posts Copying only first and last word from... chandan.inst SYNCSORT 4 Wed Jan 31, 2018 4:19 pm
No new posts How to select record x+7 or x+2 based... JoAnn Kulcyk SYNCSORT 6 Tue Jan 16, 2018 10:49 pm
No new posts query to fetch record which has only ... maxsubrat DB2 12 Mon Dec 11, 2017 5:03 pm

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