Kbase 15545: DATASERVER SYBASE V80A on-line patch for Schemaholder corrup
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/07/1998 |
|
SUMMARY:
This solution describes how to apply the patch to correct the loss of user defined information in a schema holder when an update of the
schema holder is performed. This patch is for version 8.0A.
WHY YOU NEED TO KNOW THIS:
==========================
If the UPDATE/ADD Table Definitions or Verification Table
Defintion function (with update) under the DataServer
Utilites is executed the modifications made to the
schema holder may be lossed. This problem occurs
when a field in the foreign database is defined in
lowercase.
PROCEDURAL APPROACH:
====================
There are two files needed for this patch which can
be copied from our ftp site. Our ftp site is
pscgate.progress.com and IP address is 192.77.186.1.
1) ftp pscgate.progress.com
Username: anonymous
passwd: <email-address> (ex: mailaccount@site.com)
2) cd pub/gw (directory is where they should get file)
3) bin (set transfer mode to binary)
4) There is a pkzip file and a tar file
under this directory. Both the tar and
and zip file contain the files for
the patch ( _gat_cro.p and _gat_cro.r).
If you have pkzip on your PC and are
ftping from the PC use the zip file.
If you do not have pkzip and are copying
from a UNIX machine you can copy the tar
file.
Tar File -- v80229031.tar
Zip File -- v80A31.zip
for example:
get v80A31.zip v80A31.zip
5) quit (Command to exit FTP)
6a) If you are copying from a UNIX machine
you can extact the files by using
the following command.
tar xvf v80229031.tar
_gat_cro.p, 60458 bytes, 119 tape blocks
_gat_cro.r, 68063 bytes, 133 tape blocks
If you are on the PC and have the zip file
you can extract the files by using the
following command.
pkunzip v80A31.zip
7) Copy the files to your V8 $DLC/src/prodict/gate
subdirectory.
cp _gat_cro.* $DLC/src/prodict/gate/.
ONLINE PROCEDURES OR UTILITIES:
===============================
REFERENCES TO WRITTEN DOCUMENTATION:
====================================
V8 DataServer for SYBASE guide, section 5.2 Table 5-1 (Dataserver for
SYBASE-10 utilites) page 5-6.
EXCEPTIONS:
===========
This patch is not necessary for the following dataservers:
. ORACLE
. CISAM
. RDB
. RMS
. AS/400
NOTES:
======
If the customer does not have internet access a diskette with the zip file can be obtained from Progress Technical Support.
NOTE - AS OF NOVEMBER 1996 THIS PATCH IS NO LONGER AVAILABLE ON THE
FTP SITE. IT IS NOW PART OF 8.0A02 COMMERCIAL RELEASE.