How to know who has updated the CICS / VSAM record

ykishore · New User Joined: 12 Aug 2005 Posts: 53 Location: USA

Hi

Here is my requirement!!!

we have some cics online screens....which provides the facility to add,update,delete the records.assume that i've updated the record in VSAM-KSDS file tru that online screen(mentioned above)..is it possible to know who has updated the record. can you guys give me thought on this!!!

radhakrishnan82 · Posted: Thu Sep 15, 2005 6:29 pm

kishore,

In our shop,we update database thru online.In such case we capture timestamp,screen id,user id in the db2 table while there is screen updation.Hence we can find which is the latest record,who updates,which program does that.

Similarly you can check in the layout whether you have such fields in the file.

hope this suggestion helps.

ykishore · New User Joined: 12 Aug 2005 Posts: 53 Location: USA

Hi

actually in our case, we have some scheduled jobs which produces reports based on the data updated tru online. the VSAM-KSDS has only one column .that is DATE(itz not the date on which user update).so we dont have cols like u mentioned. so is there anyother way to find out !!!!

mallikiran · New User Joined: 07 Sep 2005 Posts: 49

It would not possible to find out who has updated a record/records unless it has been captured and stored when the update is being made.

ykishore · New User Joined: 12 Aug 2005 Posts: 53 Location: USA

Hi

though we dont use those fields in our application , I believe system must be tracking all those details rite!!! so is there anyway to get those details from system!! is there any possibility or commands that cics has!!!!

happyend · Posted: Mon Sep 19, 2005 5:58 pm

In our shop we used to enter "AFCT" command in the CICS region which used to display the user who had accessed the dataset for the last time.

Regards,
Deepa

ykishore · New User Joined: 12 Aug 2005 Posts: 53 Location: USA

Hi

Thanx for ur information!!but small doubt , can you provide me how to use that!!! is AFCT is CICS-supplied transaction???

happyend · Posted: Mon Sep 19, 2005 6:31 pm

. I dont think it is CICS supplied. It used to extract all the details of the Record from the FCT and provide the info. I guess if you are not able to use AFCT then you have to verify the log files. But if someone had edited the file (Not thru online) then it will not be present in your log files.

Regards,
Deepa

happyend · Posted: Mon Sep 19, 2005 6:32 pm

For using AFCT just go to the CICS region and Type AFCT and press Enter key.

ykishore · New User Joined: 12 Aug 2005 Posts: 53 Location: USA

Hi Deepa!!

im not authorised to use AFCT command!!! so as u mentioned abt Logfiles!!! can u give an idea how to get that!!!

happyend · Posted: Tue Sep 20, 2005 8:43 am

I think you should check the pgm which does the online updates. Most probably after maintenance the pgm will be using some log files to log the details when a particular field has been changed. and I guess this file might be used in the batch to generate reports.