How to Dynamically Update Teleview Databases.

Products

• Teleview
• TELEVIEW- PACKAGE

Issue/Introduction

The batch VSAM reload program is a facility that allows a new Teleview VSAM configuration file in REPRO unloaded SEQUENTIAL format to be rolled into production through submission of a batch job. It is not necessary to bring down the Teleview region.

 

 

Resolution

1. Using the CONFIG application, a COPY of the VSAM file currently in production is edited and changes are made.
   
   
2. The VSAM file is converted to sequential format with IDCAMS.
   
   
3. JCL for the VSWAPDB BATCH VSAM RELOAD PROGRAM is submitted. The CONFIG unload is to a flat file with record format of fixed block and logic record length of 180.
   
   
4. When VSWAPDB starts executing, it will determine which VSAM file is not in use for logons to Teleview and proceed to RELOAD IT. If Teleview is not
   active, VSWAPDB will always reload the VFIGTEST file.
   
   
5. After the sequential VSAM input file is copied to VFIGTEST or VFIGPROD, the VSAM file is optionally put into production for logons to Teleview. VSWAPDB
   does this by issuing commands to the running Teleview region to cause it to switch logon processing to the inactive VSAM file (which VSWAPDB just finished
   reloading). VSWAPDB puts the new file into production when a PROMOTE command is found in the VINPUT DD statement.
   
   
6. Finally, VSWAPDB optionally updates the Teleview startup JCL by setting the CONFIG keyword equal to the file that was just reloaded. VSWAPDB will only do
   this when a PROCUPD command is found in the VINPUT DD statement. This step ensures that the new file will be used for logons to Teleview the next time it
   is restarted.