Kbase 16564: Roundtable - Updating at Remote site
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Roundtable - Updating at Remote site
** Roundtable ***
4.1.1 Updating at a Remote Site
Roundtable provides a set of PROGRESS-specific utilities necessary
for installing the software at a remote site. These utilities do not
include a packaging utility to create install disks or utilities to
automate the installation from distribution media onto a computer.
There are a variety of Windows install utilities available that
perform these functions very well.
The utilities provided by Roundtable perform:
* Schema update processing
* Selective and full compile processing
When Roundtable creates a deployment directory, it also creates three
subdirectories to support the install utilities. These are the
rtb_inst, rtb_idat and rtb_dbup directories:
Directory Directory Description
********** *********************
rtb_inst Contains the generic utility programs and data files for
the installation and compilation of the changes copied
to the remote site. This directory should remain on the
remote site permanently to support future incremental
updates.
File Name File Description
--------- ----------------
compctrl Text file containing a list of compilable procedures with
their compile options.
schupd.p Schema update procedure, part 1.
schupd2.p Schema update procedure, subroutine for part 1.
schupdp2.p Schema update procedure, part 2.
Directory Directory Description
********** ********************
rtb_idat Contains temporary files that can be deleted from the
remote site after the update installation is complete.
File Name File Description
--------- ----------------
Objctrl A list of new or modified objects delivered in the
deployment. The _update.w procedure posts these changes
in the rtb_inst\compctrl file.
Delctrl A list of files to delete from a previously installed
configuration of the system. The _update.w procedure
performs this task.
Selcomp A list of selected objects to compile. The _update.w
procedure reads this list and marks corresponding objects
in the rtb_inst\compctrl file for compilation. Roundtable
creates this list of objects requiring compilation
automatically.
Objcopy The _update.w procedure allows you to designate an
alternate root directory for the R-code of compiled
object to be placed.The objcopy file contains a list of
additional files or directories that should be copied
into the root directory. This file is not created
automatically. You must create it and copy it
into the rtb_inst directory manually.
Directory Directory Description
********** *********************
rtb_dbup\dbver Contains the database schema update files required to
update the application databases at the site. During
the update schema process, the files in this directory
are copied into rtb_idat where they are processed.
The dbver subdirectory name is usually generated by
Roundtable.
File Name File Description
--------- ----------------
schctrl Schema update control file. This file contains a list
of each database table to be updated in each database
used by the application.
*.df Files for updating database schema.
*d.p Programs for pre-update file processing.
*f.p Programs for post-update file processing.
To provide install support for Roundtable deployments into your
application, take a copy of the _update.w procedure supplied within
the Roundtable democode directory and modify it to suite your needs.
The _update.w procedure should become part of your application and
be located in the root directory of your application.This will ensure
that the rtb_inst, rtb_idat and rtb_dbup directories will be
immediately below the directory where _update.w is stored.
The following files are created at the remote site by the installation
control procedure or manually by the user. These files are not
automatically created by the installation support procedures
supplied by Roundtable.
File Description
---- -----------
Schema.pf A PROGRESS parameters file that contains the database
connection parameters used during the remote site schema
update process. This file must connect all of the
databases to be updated at the remote site.
See the discussion of the _update.w procedure for more
information on how this parameter file is processed.
The _update.w procedure has support for creating and
maintaining the schema.pf file.
Compile.pf A PROGRESS parameters file that contains the database
connection parameters to be used during the compile
process. The _update.w procedure has support for
creating and maintaining the compile.pf file.
During execution of _update.w, various log and error files are
created in a directory called rtb_ilog. Normally, these files can
be ignored. The following log files are created in the rtb_ilog
directory when the schema update procedures are compiled:
File Description
---- -----------
Schcomp.srt Created by _update.w during the OS-COMMAND when
executing schcomp.p. From this file you can determine
if execution of schcomp.p began.
Schcomp.log Created by schcomp.p. Contains the names of the schema
update files being compiled.
Schcomp.err Created by schcomp.p. Contains any compile errors that
occur during the compile of the schema update programs.
This file is empty if no compile errors occur.
The following log files are created in the rtb_ilog directory during the
pre-schema and schema update:
File Description
---- -----------
Schupd.srt Created during the OS-COMMAND when executing schupd.p.
From this you can determine if schupd.p execution began.
Schupd.log Created by schupd.p. Contains information about what
table is being updated in the pre-schema and schema
update.
Schupd.err Created by schupd.p. Contains any errors that occur
during pre-schema and schema update.
Schema.log Created by schupd.p. Contains detailed log information
about the pre-schema and schema update.
The following log files are created in the rtb_ilog directory during the
post-schema update:
File Description
---- -----------
Schupdp2.srt Created during the OS-COMMAND when executing schupdp2.p.
From this you can determine if schupdp2.p execution
began.
Schupdp2.log Created by schupdp2.p. Contains information about what
table is being processed by the post-schema update.
Schupdp2.err Created by schupdp2.p. Contains any errors that occur
during post-schema update.
The following error file is created in the rtb_ilog directory when
updating the compctrl file:
File Description
---- -----------
objctrl.err Created by _update.w when updating the compctrl file.
If any errors occur during the creation of the compctrl
file, they appear here.
Progress Software Technical Support Note # 16564