Red Hat NETSCAPE ENTREPRISE SERVER 6.0 - INSTALLATION AND MIGRATION GUIDE Guida di Installazione Pagina 111

  • Scaricare
  • Aggiungi ai miei manuali
  • Stampa
Vedere la pagina 110
3.
Perform the upgrade steps as prompted.
See also
Upgrade to Adaptive Server 15.7 ESD #2
on page 83
Upgrading Databases Using Dump and Load
When you upgrade Adaptive Server, you can also upgrade databases and transaction logs from
versions of Adaptive Server as early as 12.5 using the dump and load commands.
Some issues of which you should be aware:
The upgrade process requires space for copying data and logging changes to the system
tables. If the source database in the dump was full, the upgrade process might fail. You can
use alter database to extend the free space in the event of insufficient-space errors.
After reloading an older dump, run sp_checkreswords from the new installation on the
loaded database to check for reserved words.
How Compiled Objects Are Handled When Upgrading Adaptive Server
Adaptive Server upgrades compiled objects based on their source text.
Compiled objects include:
Check constraints
Defaults
Rules
Stored procedures (including extended stored procedures)
Triggers
Views
The source text for each compiled object is stored in the syscomments table, unless it has
been manually deleted. The upgrade process verifies the existence of the source text in
syscomments. However, compiled objects are not actually upgraded until they are invoked.
For example, if you have a user-defined stored procedure named list_proc, the presence of its
source text is verified when you upgrade. The first time list_proc is invoked after the upgrade,
Adaptive Server detects that the list_proc compiled object has not been upgraded. Adaptive
Server recompiles list_proc, based on the source text in syscomments. The newly compiled
object is then executed.
Upgraded objects retain the same object ID and permissions.
You do not receive any notification if the compiled objects in your database dump are missing
source text. After loading a database dump, run sp_checksource to verify the existence of the
source text for all compiled objects in the database. Then, you can allow the compiled objects
to be upgraded as they are executed, or you can run dbcc upgrade_object to find potential
problems and upgrade objects manually.
CHAPTER 10: Adaptive Server Upgrades
Installation Guide 101
Vedere la pagina 110
1 2 ... 106 107 108 109 110 111 112 113 114 115 116 ... 157 158

Commenti su questo manuale

Nessun commento

Gembird MHP-EP-001-W manuali

Manuali dei proprietari e guide per l'utente per Cuffie Gembird MHP-EP-001-W.
We fornisce 1 manuali pdf Gembird MHP-EP-001-W per scaricare gratuitamente in base al tipo di documento: Scheda Tecnica


Gembird MHP-EP-001-W Scheda Tecnica (1 pagine)


Marchio: Gembird | Categoria: Headphones | Dimensione: 0.16 MB |

 

Indice





Più prodotti e manuali per Cuffie Gembird

Modelli Tipo di Documento
A4-GHCR-170R Scheda Tecnica   Gembird A4-GHCR-170R headphone, 1 pagine
BHP-001 Manuale Utente   Gembird BHP-001 User Manual, 13 pagine
AP-880-5.1 Manuale Utente    Gembird AP-880-5.1 Manuel d'utilisation, 10 pagine
BHP-002 Manuale Utente   Gembird BHP-002 User Manual, 14 pagine
AP-830 Manuale Utente    Gembird AP-830 Manuel d'utilisation, 9 pagine
AP-860 Manuale Utente    Gembird AP-860 Manuel d'utilisation, 9 pagine
BHP-KBP-B Manuale Utente      Gembird BHP-KBP-B User Manual, 14 pagine
BHP-BER-BK Manuale Utente      Gembird BHP-BER-BK User Manual, 12 pagine
MHS-123 Manuale Utente      Gembird MHS-123 User Manual, 8 pagine
MHS-108 Manuale Utente    Gembird MHS-108 Manuel d'utilisation, 9 pagine
WHS-104 Manuale Utente    Gembird WHS-104 Benutzerhandbuch, 12 pagine