Q and A

Asked and Answered

We want to move a few small domain tables that are heavily referenced by online programs to CICS. You wrote about making use of CICS tables for such purposes, but no one seems to know about using CICS tables for application data. Were you using it as a synonym for TSQ/TDQ?

Robert Catterall responds:

We used CICS shared data tables (the CICS-maintained type). What happens is that the data from the DB2 table is loaded into a VSAM KSDS. The CICS SDT is then loaded from the VSAM file. As I recall, DB2 table updates are also applied to the VSAM KSDS, and updates to the VSAM KSDS will automatically be applied to the corresponding SDT because it is CICS-maintained. Here is a link to a browser-viewable edition of the CICS TS 1.3 Shared Data Tables Guide:

http://publibfp.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/DFHCAF10/CCONTENTS?DT=19970731104339

We have four such tables in production now. Access to data in these tables is very CPU-efficient.

See a complete archive of reader/author Q&As .