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 know who has updated the CICS / VSAM record

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
View previous topic :: :: View next topic  
Author Message
ykishore

New User


Joined: 12 Aug 2005
Posts: 53
Location: USA

PostPosted: Thu Sep 15, 2005 6:00 pm    Post subject: How to know who has updated the CICS / VSAM record
Reply with quote

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!!!
Back to top
View user's profile Send private message

radhakrishnan82

Active User


Joined: 31 Mar 2005
Posts: 436
Location: chennai, India

PostPosted: Thu Sep 15, 2005 6:29 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
ykishore

New User


Joined: 12 Aug 2005
Posts: 53
Location: USA

PostPosted: Thu Sep 15, 2005 6:38 pm    Post subject: Re: CICS-Updates
Reply with quote

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 !!!!
Back to top
View user's profile Send private message
mallikiran

New User


Joined: 07 Sep 2005
Posts: 49

PostPosted: Fri Sep 16, 2005 8:56 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
ykishore

New User


Joined: 12 Aug 2005
Posts: 53
Location: USA

PostPosted: Sat Sep 17, 2005 5:01 pm    Post subject: Re: How to know who has updated the CICS / VSAM record
Reply with quote

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!!!!
Back to top
View user's profile Send private message
happyend

New User


Joined: 18 Aug 2005
Posts: 10
Location: Bangalore,India

PostPosted: Mon Sep 19, 2005 5:58 pm    Post subject: Re: How to know who has updated the CICS / VSAM record
Reply with quote

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
Back to top
View user's profile Send private message
ykishore

New User


Joined: 12 Aug 2005
Posts: 53
Location: USA

PostPosted: Mon Sep 19, 2005 6:26 pm    Post subject: Re: How to know who has updated the CICS / VSAM record
Reply with quote

Hi

Thanx for ur information!!but small doubt , can you provide me how to use that!!! is AFCT is CICS-supplied transaction???
Back to top
View user's profile Send private message
happyend

New User


Joined: 18 Aug 2005
Posts: 10
Location: Bangalore,India

PostPosted: Mon Sep 19, 2005 6:31 pm    Post subject: Re: How to know who has updated the CICS / VSAM record
Reply with quote

icon_sad.gif . 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
Back to top
View user's profile Send private message
happyend

New User


Joined: 18 Aug 2005
Posts: 10
Location: Bangalore,India

PostPosted: Mon Sep 19, 2005 6:32 pm    Post subject: Re: How to know who has updated the CICS / VSAM record
Reply with quote

For using AFCT just go to the CICS region and Type AFCT and press Enter key.
Back to top
View user's profile Send private message
ykishore

New User


Joined: 12 Aug 2005
Posts: 53
Location: USA

PostPosted: Mon Sep 19, 2005 6:42 pm    Post subject: Re: How to know who has updated the CICS / VSAM record
Reply with quote

Hi Deepa!!

im not authorised to use AFCT command!!! so as u mentioned abt Logfiles!!! can u give an idea how to get that!!!
Back to top
View user's profile Send private message
happyend

New User


Joined: 18 Aug 2005
Posts: 10
Location: Bangalore,India

PostPosted: Tue Sep 20, 2005 8:43 am    Post subject: Re: How to know who has updated the CICS / VSAM record
Reply with quote

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.
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 -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Record Not found in AlX but record re... mukun264 COBOL Programming 7 Fri Mar 24, 2017 9:28 am
No new posts Count the length of the record & ... sreekusr DFSORT/ICETOOL 4 Thu Mar 23, 2017 7:52 pm
No new posts Date and time format in CICS Chandru3183 CICS 2 Sat Mar 18, 2017 12:46 pm
No new posts Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm


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