Procédure de migration ASE 12.5.x vers ASE 15.0.2 avec sqlupgraderes


1- Introduction

L'industrialisation des migrations des serveurs Sybase Adaptive Server Enterprise 12.x vers la version 15.0.2 est possible grâce au binaire sqlupgraderes fourni dans la distribution de Sybase 15.0.

Cet article s'attarde sur un exemple concret de migration d'un serveur ASE 12.5.3 ESD#7 vers la version 15.0.2 ESD#2 via le binaire sqlupgraderes en ligne de commande avec un fichier de ressources. La composante graphique d'une migration avec le binaire sqlupgrade n'est pas abordée.

La migration vers la version 15.0.2 avec sqlupgrade/sqlupgraderes peut être réalisée depuis les versions suivantes :

sqlupgrade/sqlupgradres peuvent prendre en charge la migration d'une version 32 bits vers une version 64 bits, mais l'inverse est impossible. sybmigrate demeure en revanche l'utilitaire incontournable lors d'un changement de taille des pages pour une migration, sqlupgrade/sqlupgraderes ne prennent pas en charge cette fonctionnalité.

Le système d'exploitation supportant les serveurs ASE dans les exemples est un environnement Sun Solaris SPARC v9.

2- Contexte technique

Dans le contexte de cette migration, les distributions Sybase ASE sont installées dans les répertoires ci-dessous :

Distribution ASE 12.5.3 ESD#7 /Software/sybase/sybase-12.5.3-ESD7
Distribution ASE 15.0.2 ESD#2 /Software/sybase/sybase-15.0.2-ESD2

Des liens sont créés pour simplifier la nomenclature :

ls
/Software/sybase/sybase-12.5 → /Software/sybase/sybase-12.5.3-ESD7
/Software/sybase/sybase-15.0 → /Software/sybase/sybase-15.0.2-ESD2

Le fichier interfaces est installé à la racine /Software/sybase. Chacune des distributions pointe vers le fichier interfaces via un lien :

sybase > pwd
/Software/sybase/sybase-12.5
sybase > ls -lrt | grep 'interfaces'
lrwxrwxrwx 1 sybase dba 13 Feb 19 11:48 interfaces -> ../interfaces

Dans le contexte technique de l'article :

Pour ces trois points spécifiques, se référer à la documentation en ligne de Sybase.

3- Le binaire sqlupgraderes

Le binaire sqlupgraderes de la version 15.0 est localisé dans le répertoire $SYBASE/ASE-15_0/bin, $SYBASE étant le répertoire d'installation de la version 15.0 (dans le contexte de cette documentation : /Software/sybase/sybase-15.0). Le binaire sqlupgrade est installé dans ce même répertoire et correspond à la version graphique qui n'est pas évoquée dans cette article.

3-1- Syntaxe et structure du fichier de ressources

La syntaxe du binaire sqlupgraderes est la suivante :

sybase > sqlupgraderes -r <resource_file>

Le fichier de ressources pour sqlupgraderes comporte les entrées ci-dessous (un exemple est fourni dans le répertoire $SYBASE/ASE-15_0/init/sample_resources_files) :

sybinit.release_directory: <directory old distribution>
sybinit.product: sqlsrv
sqlsrv.server_name: <servername>
sqlsrv.new_config: no
sqlsrv.sa_login: USE_DEFAULT
sqlsrv.sa_password: <sa password>
sqlsrv.do_reserved_word_check: <yes|no>
sqlsrv.do_upgrade: <yes|no>

Le paramètre sybinit.release_directory correspond au répertoire d'installation de l'ancienne version pré-15.0.

Pour bien analyser l'éligibilité de la migration vers la version 15.0, un pré test est d'abord réalisé en positionnant respectivement les paramètres do_reserved_word_check et do_upgrade à yes et no.

Le paramètre do_reserved_word_check à yes permet de vérifier la non utilisation de mots réservés ASE 15.0 dans les procédures stockées, triggers, vues, nomenclature des tables et colonnes etc...

3-2- Guide d'utilisation du binaire sqlupgraderes (variables d'environnement)

Le binaire sqlupgraderes est invoqué impérativement avec l'environnement ASE 15 ($SYBASE, $SYBASE_ASE, $SYBASE_OCS etc...), environnement qui peut être pris en sourçant le fichier SYBASE.sh dans le répertoire $SYBASE de la distribution ASE 15 (/Software/sybase/sybase-15.0).

Outre l'environnement ASE 15, sqlupgraderes a besoin de 2 variables d'environnement essentielles OLDSYBASE et OLDSYBASE_ASE si la version antérieure est une version 12.0 ou 12.5.x (pour les versions 11.9, ces variables ne sont pas nécessaires, se reporter à la documentation pour migrer une version 11.9 vers une version 15.0.x):

Variable Répertoire
OLDSYBASE

Répertoire d'installation de l'ancienne distribution pré 15.0.

OLDSYBASE=/Software/sybase/sybase-12.5 (pour une version 12.5)
OLDSYBASE=/Software/sybase/sybase-12.0 (pour une version 12.0)
OLDSYBASE_ASE

Répertoire d'installation de l'ancienne version pré 15.0 du composant ASE.

OLDSYBASE_ASE=ASE-12_5 (pour une version 12.5)
OLDSYBASE_ASE=ASE-12_0 (pour une version 12.0)

En résumé, voici les opérations à titre d'exemple à réaliser avant de solliciter sqlupgraderes :

SYBASE=/Software/sybase/sybase-15.0
export SYBASE
. $SYBASE/SYBASE.sh
OLDSYBASE=/Software/sybase/sybase-12.5
OLDSYBASE_ASE=ASE-12_5
export OLDSYBASE
export OLDSYBASE_ASE

3-3- Cinématique du binaire sqlupgraderes

Les fichiers de logs sontgénérés dans le répertoire $SYBASE/ASE-15_0/init/logs.

Pour les tests d'éligibilité de migration vers la version 15.0, sqlupgraderes déclenche le binaire preupgrade :

$SYBASE/ASE-15_0/upgrade/preupgrade -S <ServerName> -P ****** -N

Pour la vérification des mots réservés et l'installation des composants nécessaires à la migration, sqlupgraderes exécute les fichiers SQL ci-dessous :

$SYBASE/ASE-15_0/scripts/installupgrade
$SYBASE/ASE-15_0/upgrade/usage.sql

Pour la migration effective vers la version 15.0, une fois les tests d'éligibilité réussis, sqlupgraderes déclenche le binaire upgrade :

$SYBASE/ASE-15_0/upgrade/upgrade -S <ServerName> -P ******

4- Cas concret de la migration d'une version 12.5.3 ESD#7 vers la version 15.0.2 ESD#2

4-1- Opérations pré-migration (audit, mirroring, sybsystemdb, dbccdb)

Outre les opérations classiques mais essentielles de sauvegardes des bases de données, de vérification de l'intégrité, de non connexion des utilisateurs etc... Le mirroring et l'audit doivent être désactivés.

SMA_D1_ASE.master.1> sp_configure 'disable disk mirroring',1
SMA_D1_ASE.master.2> go
SMA_D1_ASE.master.1> sp_configure 'auditing',0
SMA_D1_ASE.master.2> go

Le paramètre "disable disk mirroring" étant statique, un redémarrage est nécessaire.

Pour ce qui concerne l'audit, sauvegarder la configuration courante de l'audit avec la procédure sp_displayaudit et il est préférable de désactiver toutes les options d'audit avec sp_audit, les tables sysaudits% sont en effet altérées lors de la migration vers la version 15.0.2 (voir opérations Post migration).

Si la base système sybsystemdb n'existe toujours pas, créer celle-ci sur le device master avec une taille de 3 Mb.

Pour éviter tout problème supplémentaire lié à la migration, il est éventuellement préférable de supprimer la base de données dbccdb avant la migration ASE 15.0. Celle-ci sera recréée et reconfigurée à l'issue de la migration.

4-2- Vérifications pré-migration avec sqlupgraderes

Dans une première phase, il est conseillé de lancer le binaire sqlupgraderes avec l'option sqlsrv.do_upgrade positionné à no dans le fichier de ressources, la probabilité de détecter des incompatibilités d'une version 12.5.x vers une version 15.0.2 est importante (bases systèmes sous dimensionnées, paramètres de configuration statiques et dynamiques à augmenter ...).

Voici un exemple de fichier de ressources utilisé juste pour les tests d'éligibilité :

sybase > cat SMA_D1_ASE.rs
sybinit.release_directory: /Software/sybase/sybase-12.5
sybinit.product: sqlsrv
sqlsrv.server_name: SMA_D1_ASE
sqlsrv.new_config: no
sqlsrv.sa_login: USE_DEFAULT
sqlsrv.sa_password: ****************
sqlsrv.do_reserved_word_check: yes
sqlsrv.do_upgrade: no
sybase > sqlupgraderes -r SMA_D1_ASE.rs

Lors d'une migration de la version 12.5.3 vers la version 15.0.2, sqlupgraderes renvoie généralement deux types d'incompatibilités :

Voici les incompatibilités détectées et renvoyées par sqlupgraderes dans le cas pratique de cet article, le message "This Adaptive Server is not ready for upgrade yet" est affiché lorsque les tests d'éligibilité ne sont pas concluants :

Copying interfaces file entry to new directory...
The interfaces file entry has been copied to the new directory.
Running preupgrade program...
Preupgrade Binary Version: Pre-Upgrade/15.0.2/EBF 14327/P/Sun_svr4/OS 5.8/ase1502/2486/32-bit/OPT/Thu May 24 04:40:54 2007.
        Preupgrade Version: 15.0.
        Starting preupgrade of Adaptive Server.
        Checking the server's configuration against new requirements.
        ***ERROR: the current value (2) of configuration parameter 'default database size' is below the minimum (3). (The default is 3, maximum is 10000.)
        ***ERROR: configuration parameter 'number of aux scan descriptors' is too low for upgrade. It is 200, but must be at least 256.
        ***ERROR: configuration parameter 'stack size' is too low for upgrade. It is 46080, but must be at least 71680.
        Note: the current value (512) of configuration parameter 'default network packet size' is below the default (2048). (The minimum is 512, maximum is 65024.)
        Note: the current value (512) of configuration parameter 'max network packet size' is below the default (2048). (The minimum is 512, maximum is 65024.)
        Note: the current value (0) of configuration parameter 'dtm detach timeout period' is below the default (300). (The minimum is 0, maximum is 2147483647.)
        ...Checked 131 configuration parameters; found 3 errors, 3 warnings.
        Checking number of locks for stored procedure upgrade in all databases.
        Database 'master' is online.
        Database 'tempdb' is online.
        Database 'model' is online.
        Database 'smartco' is online.
        Database 'sybsystemdb' is online.
        Database 'sybsystemprocs' is online.
        Database 'dbccdb' is online.
        Database 'sybsecurity' is online.
        Checking database status in all databases.
        Checking existence of source text for compiled objects in all databases.
         ... Checking database 'master'.
                Database 'master' has all its source available for
                upgrading compiled objects
         ... Checking database 'tempdb'.
                Database 'tempdb' has all its source available for
                upgrading compiled objects
         ... Checking database 'model'.
                Database 'model' has all its source available for
                upgrading compiled objects
         ... Checking database 'smartco'.
                Database 'smartco' has all its source available for
                upgrading compiled objects
         ... Checking database 'sybsystemdb'.
                Database 'sybsystemdb' has all its source available for
                upgrading compiled objects
         ... Checking database 'sybsystemprocs'.
                Database 'sybsystemprocs' has all its source available for
                upgrading compiled objects
         ... Checking database 'dbccdb'.
                Database 'dbccdb' has all its source available for
                upgrading compiled objects
         ... Checking database 'sybsecurity'.
                Database 'sybsecurity' has all its source available for
                upgrading compiled objects
        Checking for duplicate rows in sysstatistics in all databases.
        Checking sysstatistics rows for uniqueness in database 'master'.
                Database 'master' has no rows in sysstatistics
        Checking sysstatistics rows for uniqueness in database 'tempdb'.
                Database 'tempdb' has no rows in sysstatistics
        Checking sysstatistics rows for uniqueness in database 'model'.
                Database 'model' has no rows in sysstatistics
        Checking sysstatistics rows for uniqueness in database 'smartco'.
        Checking sysstatistics rows for uniqueness in database 'sybsystemdb'.
                Database 'sybsystemdb' has no rows in sysstatistics
        Checking sysstatistics rows for uniqueness in database 'sybsystemprocs'.
                Database 'sybsystemprocs' has no rows in sysstatistics
        Checking sysstatistics rows for uniqueness in database 'dbccdb'.
        Checking sysstatistics rows for uniqueness in database 'sybsecurity'.
                Database 'sybsecurity' has no rows in sysstatistics
        Checking space in all databases.
                Database master has enough space for upgrade.
                Database tempdb has enough space for upgrade.
                ***ERROR: alter database model to add at least 2 MB of data space.
                Database smartco has enough space for upgrade.
                ***ERROR: alter database sybsystemdb to add at least 2 MB of data space.
                ***ERROR: alter database sybsystemprocs to add at least 28 MB of data space.
                Database dbccdb has enough space for upgrade.
                Database sybsecurity has enough space for upgrade.
        ***ERROR: There is insufficient space in 3 databases for upgrade to
        15.0.  This can be fixed by altering the databases listed
        above and restarting the upgrade.
        ***ERROR: Upgrade of Adaptive Server to 15.0 aborted.
The preupgrade program reported failure.
Checking reserved words in each database...
No reserved word conflicts were found.
This Adaptive Server is not ready for upgrade yet.  Try again when the above
situations are resolved.
The preupgrade program reported failure.

En résumé, les incompatibilités sont les suivantes :

Extensions des bases de données systèmes

Base Taille supplémentaire nécessaire
model 2 Mb
sybsystemdb 2 Mb
sybsystemprocs 28 Mb

Paramètre de configuration à modifier

Paramètre Ancienne valeur Nouvelle valeur
default database size 2 3
number of aux scan descriptors 200 256
stack size (*) 46080 71680
default network packet size (*) 512 2048
max network packet size (*) 512 2048
dtm detach timeout period 0 300

(*) : paramètres statiques. Le paramètre "max network packet size" doit être modifié avant le paramètre "default network packet size", ces deux paramètres étant interdépendants.

Dans le contexte de cette migration, les modifications ci-dessous sont apportées afin que les tests d'éligibilité vers la version 15.0 deviennent positifs :

use master
go
disk resize name='sysprocsdev',size='50M'
go
alter database sybsystemprocs on sysprocsdev=50
go
alter database model on master=2
go
alter database sybsystemdb on master=2
go
sp_configure 'default database size',3
go
sp_configure 'number of aux scan descriptors',256
go
sp_configure 'stack size',71680
go
sp_configure 'max network packet size',2048
go
sp_configure 'default network packet size',2048
go
sp_configure 'dtm detach timeout period',300
go
sp_configure 'disable disk mirroring',1
go

Un bon nombre de paramètres statiques étant modifiés, un redémarrage est impératif en vérifiant dans le ficher de log lors du redémarrage qu'il ne se produit pas de problèmes de peréquation entre les paramètres modifiés.

Pour ce cas concret de migration, aucun mot réservé n'a été détecté lors de la deuxième étape des tests d'éligibilité (No reserved word conflicts were found.) : dans la pratique, sqlupgraderes exécute le script installupgrade dans le répertoire $SYBASE/ASE-15_0/scripts. installupgrade vide la table spt_values dans la base master pour les mots clés (type="W"), et réinsère les valeurs pour ASE 15, la procédure sp_checkreswords est ensuite recompilée.

sp_checkreswords est appelée dans chaque base de données pour les tests d'éligibilité.

4-3- Préparation de l'environnement pour la migration

Dans le cas de figure où le fichier de configuration du serveur <servername>.cfg n'est pas installé dans le répertoire standard d'une installation par défaut Sybase, une fois toutes les corrections effectuées, il est impératif de copier le fichier de configuration mis à jour dans le répertoire $OLDSYBASE/$OLDSYBASE_ASE.

A titre d'exemple, dans l'environnement normalisé de cet article, le fichier de configuration est installé dans le répertoire $CFG (/Software/sybase/dba/<servername>/cfg) et il est très important de copier ce fichier de configuration dans le répertoire $OLDSYBASE/$OLDSYBASE_ASE (/Software/sybase/sybase-12.5/ASE-12_5) :

      SMA_D1_ASE > cp -f $CFG/SMA_D1_ASE.cfg $OLDSYBASE/$OLDSYBASE_ASE

sqlupgraderes copie en effet le fichier de configuration depuis le répertoire $OLDSYBASE/$OLDSYBASE_ASE vers le répertoire de la distribution ASE 15 ($SYBASE/ASE-15_0). sqlupgraderes se base exclusivement sur une installation réalisée par défaut d'un serveur ASE.

Le fichier de démarrage RUN_<servername> qui sera construit dans le répertoire $SYBASE/ASE-15_0/install par sqlupgraderes lors de la migration conservera également lui aussi la configuration d'une installation par défaut d'un serveur ASE (localisation du fichier de log, du fichier de configuration etc...), voici un exemple de fichier de démarrage construit pour la migration avec sqlupgraderes :

/Software/sybase/sybase-15.0.2-ESD2/ASE-15_0/bin/dataserver \
        -sSMA_D1_ASE \
        -d/smartco/sybase/SMA_D1_ASE/master.dat \
        -e/Software/sybase/sybase-15.0.2-ESD2/ASE-15_0/install/SMA_D1_ASE.log \
        -c/Software/sybase/sybase-15.0.2-ESD2/ASE-15_0/SMA_D1_ASE.cfg \
        -M/Software/sybase/sybase-15.0.2-ESD2/ASE-15_0 \
        -i/Software/sybase/sybase-15.0.2-ESD2 \

Toujours s'assurer à chaque exécution du binaire sqlupgraderes que le fichier RUN_<SERVERNAME> n'existe déjà pas dans le répertoire $SYBASE/ASE-15_0/install. Quelques cas sont ouverts sur des coredumps du binaire sqlupgrade pour les versions 15.0.2 antérieures à la version ESD2 (431125 Using existing RUN file with garbadge content to do upgrade, sqlupgrade core dump).

4-4- Migration avec sqlupgraderes

sqlupgraderes renvoie les informations ci-dessous lorsque la migration est réussie. Le fichier de log complet est donné pour information pour les plus curieux à l'annexe 1, fichier de log dans lequel les étapes sont nettement plus détaillées.

SMA_D1_ASE > sqlupgraderes -r sqlupgrade.SMA_D1_ASE.rs
      Copying interfaces file entry to new directory...
      The interfaces file entry has been copied to the new directory.
      Running preupgrade program...
      The preupgrade program has completed successfully.
      Checking reserved words in each database...
      No reserved word conflicts were found.
      Checkpointing all databases...
      All databases have been checkpointed.
      Copying configuration file to new directory...
      The configuration file has been copied to the new directory.
      Updating RUN_SERVER file...
      The RUN_SERVER file has been updated.
      Doing pre-upgrade modifications...
      Pre-upgrade modifications succeeded.
      Restarting Adaptive Server....
      Adaptive Server has been restarted.
      Running upgrade program...
      The upgrade program has completed successfully.
      Restarting Adaptive Server....
      Adaptive Server has been restarted.
      Running installmaster script...
      installmaster: 10% complete.
      installmaster: 20% complete.
      installmaster: 30% complete.
      installmaster: 40% complete.
      installmaster: 50% complete.
      installmaster: 60% complete.
      installmaster: 70% complete.
      installmaster: 80% complete.
      installmaster: 90% complete.
      installmaster: 100% complete.
      The installmaster script has been successfully installed.
      Running installsecurity script...
      The installsecurity script has been successfully installed.
      Running installcommit script...
      The installcommit script has been successfully installed.
      Installing common character sets (Code Page 437, Code Page 850, ISO Latin-1,
      Macintosh and HP Roman-8)...
      Character sets installed.
      Restarting Adaptive Server....
      Adaptive Server has been restarted.

sqlupgraderes effectue successivement les opérations ci-dessous :

4-5- Opérations Post migration

4-5-1- instmsgs.ebf

Exécuter le scripts $SYBASE/$SYBASE_ASE/scripts/instmsgs.ebf, la migration ne prend pas en charge cette phase.

isql -Usa -P<sa password> -S<server name> -n- i $SYBASE/$SYBASE_ASE/scripts/instmsgs.ebf

4-5-2- Remise aux normes

La procédure de migration copie le fichier interfaces physiquement dans le répertoire $SYBASE (/Software/sybase/sybase-15.0). Si ce fichier interfaces est habituellement un lien vers une autre localisation, repositionner ce lien.

Si le fichier de configuration du serveur n'est pas habituellement installé dans le répertoire $SYBASE/$SYBASE_ASE (localisation par défaut), veiller à copier le fichier de configuration du serveur dans son répertoire habituel.

Effectuer alors un test de redémarrage du serveur avec la normalisation en vigueur (bascule vers l'environnement ASE 15.0, fichier de configuration etc...).

Par défaut, une licence d'1 mois SYSAM est octroyée pour le serveur. Installer si possible dès maintenant la licence SYSAM 2.0 pour éviter de l'oublier.

4-5-3- Audit et mirroring

Réactiver à cette étape l'option de mirroring si cette option était active avant la migration et utiliser la commande disk remirror pour remettre en miroir les devices qui l'étaient (un redémarrage est nécessaire pour le paramètre statique 'disable disk mirroring').

SMA_D1_ASE.master.1> sp_configure 'disable disk mirroring',0
SMA_D1_ASE.master.2> go

Réactiver l'audit et les options d'audit en place avant la migration, options sauvegardées avant la migration avec la commande sp_displayaudit.

SMA_D1_ASE.master.1> sp_configure 'auditing',1
SMA_D1_ASE.master.2> go

Si une procédure stockée de seuil est mise en place pour l'audit (transvasement des données d'audit dans une table d'historique), toutes les tables d'historique d'audit existantes avant la migration ASE 15.0.2 doivent être altérées pour ajouter la colonne nodeid de type tinyint :

alter table MyPre15SysAuditHistoryTable add nodeid tinyint NULL

4-5-4- ASE 15.0.2 et RTDS

Si la fonctionnalité RTDS est activée dans le serveur, le script installmsgsvss dans le répertoire $SYBASE/ASE-15_0/scripts/installmsgsvss doit être réexécuté

isql -Usa -P<sa password> -S<server name> -n- i $SYBASE/$SYBASE_ASE/scripts/installmsgsvss

4-5-6- Statistiques

Il n'est pas nécessaire d'effectuer une mise à jour des statistiques avec la commande update statistics à l'issue de la migration vers la version 15.0.2. La procédure de migration ne touche pas aux statistiques.

4-5-7- dbccdb

Il est préférable de supprimer la base de données dbccdb durant la migration, aussi à la fin de la migration, recréer la base de données dbccdb, puis exécuter le script $SYBASE/$SYBASE_ASE/scripts/installdbccdb.

Il reste à reconfigurer les bases de données utilisateur.


Annexe

Fichier de log complet sqlupgraderes

Tue Feb 19 11:38:23 2008: sqlupgrade/15.0.2/32bit/P/Sun_svr4/SunOS 5.8/EBF 14327/OPT/Thu May 24 07:48:18 PDT 2007
Tue Feb 19 11:38:23 2008: Getting attribute values from sybinit resource file `sqlupgrade.SMA_D1_ASE.rs'.
Tue Feb 19 11:38:24 2008: (Shell command) /Software/sybase/sybase-15.0.2-ESD2/ASE-15_0/upgrade/preupgrade -S SMA_D1_ASE -P ****** -N > /tmp/sbBAAXJai_k 2>&1
Preupgrade Binary Version: Pre-Upgrade/15.0.2/EBF 14327/P/Sun_svr4/OS 5.8/ase1502/2486/32-bit/OPT/Thu May 24 04:40:54 2007.
Preupgrade Version: 15.0.
Starting preupgrade of Adaptive Server.
Checking the server's configuration against new requirements.
...Checked 131 configuration parameters; found no errors, no warnings.
Checking number of locks for stored procedure upgrade in all databases.
Database 'master' is online.
Database 'tempdb' is online.
Database 'model' is online.
Database 'smartco' is online.
Database 'sybsystemdb' is online.
Database 'sybsystemprocs' is online.
Database 'dbccdb' is online.
Database 'sybsecurity' is online.
Checking database status in all databases.
Checking existence of source text for compiled objects in all databases.
... Checking database 'master'.
Database 'master' has all its source available for
upgrading compiled objects
... Checking database 'tempdb'.
Database 'tempdb' has all its source available for
upgrading compiled objects
... Checking database 'model'.
Database 'model' has all its source available for
upgrading compiled objects
... Checking database 'smartco'.
Database 'smartco' has all its source available for
upgrading compiled objects
... Checking database 'sybsystemdb'.
Database 'sybsystemdb' has all its source available for
upgrading compiled objects
... Checking database 'sybsystemprocs'.
Database 'sybsystemprocs' has all its source available for
upgrading compiled objects
... Checking database 'dbccdb'.
Database 'dbccdb' has all its source available for
upgrading compiled objects
... Checking database 'sybsecurity'.
Database 'sybsecurity' has all its source available for
upgrading compiled objects
Checking for duplicate rows in sysstatistics in all databases.
Checking sysstatistics rows for uniqueness in database 'master'.
Database 'master' has no rows in sysstatistics
Checking sysstatistics rows for uniqueness in database 'tempdb'.
Database 'tempdb' has no rows in sysstatistics
Checking sysstatistics rows for uniqueness in database 'model'.
Database 'model' has no rows in sysstatistics
Checking sysstatistics rows for uniqueness in database 'smartco'.
Checking sysstatistics rows for uniqueness in database 'sybsystemdb'.
Database 'sybsystemdb' has no rows in sysstatistics
Checking sysstatistics rows for uniqueness in database 'sybsystemprocs'.
Database 'sybsystemprocs' has no rows in sysstatistics
Checking sysstatistics rows for uniqueness in database 'dbccdb'.
Checking sysstatistics rows for uniqueness in database 'sybsecurity'.
Database 'sybsecurity' has no rows in sysstatistics
Checking space in all databases.
Database master has enough space for upgrade.
Database tempdb has enough space for upgrade.
Database model has enough space for upgrade.
Database smartco has enough space for upgrade.
Database sybsystemdb has enough space for upgrade.
Database sybsystemprocs has enough space for upgrade.
Database dbccdb has enough space for upgrade.
Database sybsecurity has enough space for upgrade.
Checking system-defined datatype definitions in all databases.
Checking unused or obsolete columns that must be cleared in all databases.
Checking for required config file changes for cache 'default data cache'
Preupgrade of Adaptive Server to 15.0 is complete.
Upgrade eligibility test succeeded.
Tue Feb 19 11:38:29 2008: Executing SQL script '/Software/sybase/sybase-15.0.2-ESD2/ASE-15_0/scripts/installupgrade'
Tue Feb 19 11:38:36 2008: Executing SQL script '/Software/sybase/sybase-15.0.2-ESD2/ASE-15_0/upgrade/usage.sql'
Tue Feb 19 11:38:36 2008: (SQL command) use master
Tue Feb 19 11:38:36 2008: (SQL command) use dbccdb
Tue Feb 19 11:38:37 2008: (SQL command) use master
Tue Feb 19 11:38:37 2008: (SQL command) use master
Tue Feb 19 11:38:37 2008: (SQL command) use master
Tue Feb 19 11:38:37 2008: (SQL command) use model
Tue Feb 19 11:38:37 2008: (SQL command) use master
Tue Feb 19 11:38:37 2008: (SQL command) use smartco
Tue Feb 19 11:38:39 2008: (SQL command) use master
Tue Feb 19 11:38:39 2008: (SQL command) use sybsecurity
Tue Feb 19 11:38:39 2008: (SQL command) use master
Tue Feb 19 11:38:39 2008: (SQL command) use sybsystemdb
Tue Feb 19 11:38:39 2008: (SQL command) use master
Tue Feb 19 11:38:39 2008: (SQL command) use sybsystemprocs
Tue Feb 19 11:38:40 2008: (SQL command) use master
Tue Feb 19 11:38:40 2008: (SQL command) use tempdb
Reserved Words Used as Database Object Names for Database,dbccdb.

Upgrade renames sysobjects.schema to sysobjects.schemacnt.

Database-wide Objects
--------------------------------------------------------------------------------

Found no reserved words used as database object names.
(return status = 0)
Reserved Words Used as Database Object Names for Database,master.

Upgrade renames sysobjects.schema to sysobjects.schemacnt.

Database-wide Objects
--------------------------------------------------------------------------------

Found no reserved words used as database object names.
(return status = 0)
Reserved Words Used as Database Object Names for Database,model.

Upgrade renames sysobjects.schema to sysobjects.schemacnt.

Database-wide Objects
--------------------------------------------------------------------------------

Found no reserved words used as database object names.
(return status = 0)
Reserved Words Used as Database Object Names for Database,smartco.

Upgrade renames sysobjects.schema to sysobjects.schemacnt.

Database-wide Objects
--------------------------------------------------------------------------------

Found no reserved words used as database object names.
(return status = 0)
Reserved Words Used as Database Object Names for Database,sybsecurity.

Upgrade renames sysobjects.schema to sysobjects.schemacnt.

Database-wide Objects
--------------------------------------------------------------------------------

Found no reserved words used as database object names.
(return status = 0)
Reserved Words Used as Database Object Names for Database,sybsystemdb.

Upgrade renames sysobjects.schema to sysobjects.schemacnt.

Database-wide Objects
--------------------------------------------------------------------------------

Found no reserved words used as database object names.
(return status = 0)
Reserved Words Used as Database Object Names for Database,sybsystemprocs.

Upgrade renames sysobjects.schema to sysobjects.schemacnt.

Database-wide Objects
--------------------------------------------------------------------------------

Found no reserved words used as database object names.
(return status = 0)
Reserved Words Used as Database Object Names for Database,tempdb.

Upgrade renames sysobjects.schema to sysobjects.schemacnt.

Database-wide Objects
--------------------------------------------------------------------------------

Found no reserved words used as database object names.
(return status = 0)
Tue Feb 19 11:38:40 2008: (SQL command) use master
Tue Feb 19 11:38:40 2008: (SQL command) use master
Tue Feb 19 11:38:40 2008: (SQL command) use dbccdb
Tue Feb 19 11:38:40 2008: (SQL command) checkpoint
Tue Feb 19 11:38:40 2008: (SQL command) use master
Tue Feb 19 11:38:40 2008: (SQL command) use master
Tue Feb 19 11:38:40 2008: (SQL command) checkpoint
Tue Feb 19 11:38:40 2008: (SQL command) use master
Tue Feb 19 11:38:40 2008: (SQL command) use model
Tue Feb 19 11:38:40 2008: (SQL command) checkpoint
Tue Feb 19 11:38:40 2008: (SQL command) use master
Tue Feb 19 11:38:40 2008: (SQL command) use smartco
Tue Feb 19 11:38:40 2008: (SQL command) checkpoint
Tue Feb 19 11:38:40 2008: (SQL command) use master
Tue Feb 19 11:38:40 2008: (SQL command) use sybsecurity
Tue Feb 19 11:38:40 2008: (SQL command) checkpoint
Tue Feb 19 11:38:40 2008: (SQL command) use master
Tue Feb 19 11:38:40 2008: (SQL command) use sybsystemdb
Tue Feb 19 11:38:40 2008: (SQL command) checkpoint
Tue Feb 19 11:38:40 2008: (SQL command) use master
Tue Feb 19 11:38:40 2008: (SQL command) use sybsystemprocs
Tue Feb 19 11:38:40 2008: (SQL command) checkpoint
Tue Feb 19 11:38:40 2008: (SQL command) use master
Tue Feb 19 11:38:40 2008: (SQL command) use tempdb
Tue Feb 19 11:38:40 2008: (SQL command) checkpoint
Tue Feb 19 11:38:40 2008: (SQL command) use master
Tue Feb 19 11:38:40 2008: (SQL command) use master
Tue Feb 19 11:38:40 2008: (SQL command) use dbccdb
Tue Feb 19 11:38:40 2008: (SQL command) use master
Tue Feb 19 11:38:40 2008: (SQL command) use master
Tue Feb 19 11:38:40 2008: (SQL command) use master
Tue Feb 19 11:38:40 2008: (SQL command) use model
Tue Feb 19 11:38:40 2008: (SQL command) use master
Tue Feb 19 11:38:40 2008: (SQL command) use smartco
Tue Feb 19 11:38:40 2008: (SQL command) use master
Tue Feb 19 11:38:40 2008: (SQL command) use sybsecurity
Tue Feb 19 11:38:40 2008: (SQL command) use master
Tue Feb 19 11:38:40 2008: (SQL command) use sybsystemdb
Tue Feb 19 11:38:40 2008: (SQL command) use master
Tue Feb 19 11:38:40 2008: (SQL command) use sybsystemprocs
Tue Feb 19 11:38:40 2008: (SQL command) use master
Tue Feb 19 11:38:40 2008: (SQL command) use tempdb
Tue Feb 19 11:38:40 2008: (SQL command) shutdown
Tue Feb 19 11:38:41 2008: (Shell command) /Software/sybase/sybase-15.0.2-ESD2/ASE-15_0/bin/dataserver -sSMA_D1_ASE -d/smartco/sybase/SMA_D1_ASE/master.dat -e/Software/sybase/sybase-15.0.2-ESD2/ASE-15_0/install/SMA_D1_ASE.log -c/Software/sybase/sybase-15.0.2-ESD2/ASE-15_0/SMA_D1_ASE.cfg -M/Software/sybase/sybase-15.0.2-ESD2/ASE-15_0 -i/Software/sybase/sybase-15.0.2-ESD2 > /dev/null 2>&1
Tue Feb 19 11:39:01 2008: (Shell command) /Software/sybase/sybase-15.0.2-ESD2/ASE-15_0/upgrade/upgrade -S SMA_D1_ASE -P ****** > /tmp/sbGAA2Jai_k 2>&1
Setting DB-Lib version used by upgrade to 10.0
Starting upgrade to Adaptive Server 15.0.0.0.
Database 'master' is is online.
Database 'tempdb' is is online.
Database 'model' is is online.
Database 'smartco' is is online.
Database 'sybsystemdb' is is online.
Database 'sybsystemprocs' is is online.
Database 'dbccdb' is is online.
Database 'sybsecurity' is is online.
Checking freespace for database 'master'.
Checking freespace for database 'tempdb'.
Checking freespace for database 'model'.
Checking freespace for database 'smartco'.
Checking freespace for database 'sybsystemdb'.
Checking freespace for database 'sybsystemprocs'.
Checking freespace for database 'dbccdb'.
Checking freespace for database 'sybsecurity'.
Setting upgrade version to 15.0.0.0
Upgrading the master database
  Database 'master' appears to be at an older revision than the present installation; ASE will assess it, and upgrade it as required.
  Database 'master': beginning upgrade step [ID  1421]: executing SQL statement ("update master.dbo.syslogins set sta...")
  Database 'master': beginning upgrade step [ID  1422]: executing SQL statement ("if not exists (select 1 from master...")
  Database 'master': beginning upgrade step [ID  1423]: executing SQL statement ("delete sysattributes where class=0...")
  Database 'master': beginning upgrade step [ID   247]: Upgrade colidarray in sysstatistics to 2-byte column IDs.
  Database 'master': beginning upgrade step [ID     2]: validate basic system type data
  Database 'master': beginning upgrade step [ID     3]: alter table (table sysindexes)
  Database 'master': beginning upgrade step [ID     4]: creating table (table sysanchors)
  Database 'master': beginning upgrade step [ID     5]: changing name of system table (table syspartitions, new name: sysslices)
  Database 'master': beginning upgrade step [ID     6]: creating table (table syspartitions)
  Database 'master': beginning upgrade step [ID     7]: insert rows into syspartitions for each system table and index
  Database 'master': beginning upgrade step [ID     8]: alter table (table systypes)
  Database 'master': beginning upgrade step [ID     9]: alter table (table sysobjects)
  Database 'master': beginning upgrade step [ID   997]: executing SQL statement ("if exists (select 1 from syscolumns...")
  Database 'master': beginning upgrade step [ID   998]: executing SQL statement ("update syscolumns set colid = colid...")
  Database 'master': beginning upgrade step [ID    10]: alter table (table syscolumns)
  Database 'master': beginning upgrade step [ID    11]: insert basic data into bootstrap system tables (table sysobjects)
  Database 'master': beginning upgrade step [ID    69]: executing SQL statement ("if 2 = (select count(name) from sys...")
  Database 'master': beginning upgrade step [ID    12]: alter table (table systabstats)
  Database 'master': beginning upgrade step [ID    20]: alter table (table sysusages)
  Database 'master': beginning upgrade step [ID    21]: alter table (table sysdatabases)
  Database 'master': beginning upgrade step [ID    22]: alter table (table sysdevices)
  Database 'master': beginning upgrade step [ID    24]: alter table (table sysconfigures)
  Database 'master': beginning upgrade step [ID    25]: alter table (table syscharsets)
  Database 'master': beginning upgrade step [ID    26]: alter table (table sysprocedures)
  Database 'master': beginning upgrade step [ID    27]: alter table (table syscomments)
  Database 'master': beginning upgrade step [ID    28]: alter table (table syssegments)
  Database 'master': beginning upgrade step [ID    29]: alter table (table sysprotects)
  Database 'master': beginning upgrade step [ID    30]: alter table (table sysusers)
  Database 'master': beginning upgrade step [ID    31]: alter table (table sysalternates)
  Database 'master': beginning upgrade step [ID    32]: alter table (table sysdepends)
  Database 'master': beginning upgrade step [ID    33]: alter table (table syskeys)
  Database 'master': beginning upgrade step [ID    35]: alter table (table sysprocesses)
  Database 'master': beginning upgrade step [ID    36]: alter table (table syslogins)
  Database 'master': beginning upgrade step [ID    37]: alter table (table syslocks)
  Database 'master': beginning upgrade step [ID    38]: alter table (table syscurconfigs)
  Database 'master': beginning upgrade step [ID    39]: alter table (table sysservers)
  Database 'master': beginning upgrade step [ID    40]: alter table (table sysremotelogins)
  Database 'master': beginning upgrade step [ID    41]: alter table (table sysmonitors)
  Database 'master': beginning upgrade step [ID    42]: alter table (table sysengines)
  Database 'master': beginning upgrade step [ID    43]: alter table (table syslanguages)
  Database 'master': beginning upgrade step [ID    44]: alter table (table systestlog)
  Database 'master': beginning upgrade step [ID    45]: alter table (table syssrvroles)
  Database 'master': beginning upgrade step [ID    46]: alter table (table sysloginroles)
  Database 'master': beginning upgrade step [ID    47]: creating table (table syspartitionkeys)
  Database 'master': beginning upgrade step [ID    49]: alter table (table syslisteners)
  Database 'master': beginning upgrade step [ID    51]: alter table (table sysreferences)
  Database 'master': beginning upgrade step [ID    52]: alter table (table sysconstraints)
  Database 'master': beginning upgrade step [ID    54]: alter table (table systhresholds)
  Database 'master': beginning upgrade step [ID    55]: alter table (table sysroles)
  Database 'master': beginning upgrade step [ID    57]: alter table (table systimeranges)
  Database 'master': beginning upgrade step [ID    58]: alter table (table sysresourcelimits)
  Database 'master': beginning upgrade step [ID    60]: alter table (table sysstatistics)
  Database 'master': beginning upgrade step [ID    62]: alter table (table sysjars)
  Database 'master': beginning upgrade step [ID    63]: alter table (table systransactions)
  Database 'master': beginning upgrade step [ID    66]: alter table (table syssessions)
  Database 'master': beginning upgrade step [ID    68]: creating table (table sysencryptkeys)
  Database 'master': beginning upgrade step [ID    71]: creating table (table sysoptions)
  Database 'master': beginning upgrade step [ID    80]: alter table (table sysattributes)
  Database 'master': beginning upgrade step [ID    91]: executing SQL statement ("update systypes set length=@@maxpag...")
  Database 'master': beginning upgrade step [ID   245]: Update system roles in system tables.
  Database 'master': beginning upgrade step [ID   246]: clear unused columns (table sysindexes)
  Database 'master': beginning upgrade step [ID   248]: update system catalog protection data
  Database 'master': beginning upgrade step [ID  1501]: executing SQL statement ("if not exists (select 1 from syscon...")
  Database 'master': beginning upgrade step [ID  1502]: executing SQL statement ("if exists (select 1 from sysobjects...")
  Database 'master': beginning upgrade step [ID  1503]: executing SQL statement ("create view sysquerymetrics (uid, g...")
  Database 'master': beginning upgrade step [ID  1505]: executing SQL statement ("update sysattributes set char_value...")
  Database 'master': beginning upgrade step [ID  1506]: executing SQL statement ("update sysattributes set int_value...")
  Database 'master': beginning upgrade step [ID  1105]: noting the present database upgrade level
  Database 'master': beginning upgrade step [ID  1123]: executing SQL statement ("update sysindexes set fill_factor=0...")
  Database 'master': beginning upgrade step [ID  1132]: noting the present database upgrade level
  Database 'master': beginning upgrade step [ID  1134]: executing SQL statement ("if exists (select 1 from syskeys wh...")
  Database 'master': beginning upgrade step [ID  1135]: executing SQL statement ("update syscolumns set usertype = 6...")
  Database 'master': beginning upgrade step [ID   999]: executing SQL statement ("update sysdevices set phyname = 'd_...")
  Database 'master': beginning upgrade step [ID  1000]: executing SQL statement ("delete from sysdevices where name =...")
  Database 'master': beginning upgrade step [ID  1220]: executing SQL statement ("update sysusers set suid = -2 where...")
  Database 'master': beginning upgrade step [ID  1225]: executing SQL statement ("update syssrvroles set pwdate = get...")
  Database 'master': beginning upgrade step [ID  1252]: executing SQL statement ("update sysdatabases set status3 = 0...")
  Database 'master': beginning upgrade step [ID  1272]: executing SQL statement ("delete from syskeys where spare1 !=...")
  Database 'master': beginning upgrade step [ID  1273]: executing SQL statement ("update sysobjects set sysstat2 = sy...")
  Database 'master': beginning upgrade step [ID  1299]: noting the present database upgrade level
  Database 'master': beginning upgrade step [ID  1331]: Reconcile (delete obsolete, add new) messages in SYSMESSAGES. (table sysmessages)
  Database 'master': beginning upgrade step [ID  1333]: executing SQL statement ("update sysservers set srvcost = 0 w...")
  Database 'master': beginning upgrade step [ID  1400]: noting the present database upgrade level
  Database 'master': beginning upgrade step [ID  1088]: Verifying page header information (table syscharsets, index tsyscharsets)
  Database 'master': beginning upgrade step [ID  1401]: Update syscharsets with Unicode sort orders.
  Database 'master': beginning upgrade step [ID  1551]: executing SQL statement ("if not exists (select 1 from syssrv...")
  Database 'master': beginning upgrade step [ID  1553]: executing SQL statement ("if not exists (select 1 from master...")
  Database 'master': beginning upgrade step [ID  1560]: executing SQL statement ("delete from sysconfigures where con...")
  Database 'master': beginning upgrade step [ID  1550]: noting the present database upgrade level
  Database 'master': beginning upgrade step [ID  1554]: upgrade simulated statistics
  Database 'master': beginning upgrade step [ID  1557]: executing SQL statement ("if not exists (select 1 from sysatt...")
  Database 'master': beginning upgrade step [ID  1558]: executing SQL statement ("if not exists (select 1 from sysatt...")
  Database 'master': beginning upgrade step [ID  1559]: executing SQL statement ("update sysservers set srvstatus = s...")
  Upgrade has finished in database 'master'. ASE is now updating table level statistics for its system tables. Please be patient.
  Database 'master' is now online.
Upgrading active databases
  Database 'tempdb' appears to be at an older revision than the present installation; ASE will assess it, and upgrade it as required.
  Database 'tempdb': beginning upgrade step [ID   247]: verifying sysstatistics row format
  Database 'tempdb': beginning upgrade step [ID     2]: validate basic system type data
  Database 'tempdb': beginning upgrade step [ID     3]: alter table (table sysindexes)
  Database 'tempdb': beginning upgrade step [ID     4]: creating table (table sysanchors)
  Database 'tempdb': beginning upgrade step [ID     5]: changing name of system table (table syspartitions, new name: sysslices)
  Database 'tempdb': beginning upgrade step [ID     6]: creating table (table syspartitions)
  Database 'tempdb': beginning upgrade step [ID     7]: insert rows into syspartitions for each system table and index
  Database 'tempdb': beginning upgrade step [ID     8]: alter table (table systypes)
  Database 'tempdb': beginning upgrade step [ID     9]: alter table (table sysobjects)
  Database 'tempdb': beginning upgrade step [ID   997]: executing SQL statement ("if exists (select 1 from syscolumns...")
  Database 'tempdb': beginning upgrade step [ID   998]: executing SQL statement ("update syscolumns set colid = colid...")
  Database 'tempdb': beginning upgrade step [ID    10]: alter table (table syscolumns)
  Database 'tempdb': beginning upgrade step [ID    11]: insert basic data into bootstrap system tables (table sysobjects)
  Database 'tempdb': beginning upgrade step [ID    69]: executing SQL statement ("if 2 = (select count(name) from sys...")
  Database 'tempdb': beginning upgrade step [ID    12]: alter table (table systabstats)
  Database 'tempdb': beginning upgrade step [ID    26]: alter table (table sysprocedures)
  Database 'tempdb': beginning upgrade step [ID    27]: alter table (table syscomments)
  Database 'tempdb': beginning upgrade step [ID    28]: alter table (table syssegments)
  Database 'tempdb': beginning upgrade step [ID    29]: alter table (table sysprotects)
  Database 'tempdb': beginning upgrade step [ID    30]: alter table (table sysusers)
  Database 'tempdb': beginning upgrade step [ID    31]: alter table (table sysalternates)
  Database 'tempdb': beginning upgrade step [ID    32]: alter table (table sysdepends)
  Database 'tempdb': beginning upgrade step [ID    33]: alter table (table syskeys)
  Database 'tempdb': beginning upgrade step [ID    47]: creating table (table syspartitionkeys)
  Database 'tempdb': beginning upgrade step [ID    51]: alter table (table sysreferences)
  Database 'tempdb': beginning upgrade step [ID    52]: alter table (table sysconstraints)
  Database 'tempdb': beginning upgrade step [ID    54]: alter table (table systhresholds)
  Database 'tempdb': beginning upgrade step [ID    55]: alter table (table sysroles)
  Database 'tempdb': beginning upgrade step [ID    60]: alter table (table sysstatistics)
  Database 'tempdb': beginning upgrade step [ID    62]: alter table (table sysjars)
  Database 'tempdb': beginning upgrade step [ID    68]: creating table (table sysencryptkeys)
  Database 'tempdb': beginning upgrade step [ID    80]: alter table (table sysattributes)
  Database 'tempdb': beginning upgrade step [ID    91]: executing SQL statement ("update systypes set length=@@maxpag...")
  Database 'tempdb': beginning upgrade step [ID   245]: Update system roles in system tables.
  Database 'tempdb': beginning upgrade step [ID   246]: clear unused columns (table sysindexes)
  Database 'tempdb': beginning upgrade step [ID   248]: update system catalog protection data
  Database 'tempdb': beginning upgrade step [ID  1502]: executing SQL statement ("if exists (select 1 from sysobjects...")
  Database 'tempdb': beginning upgrade step [ID  1503]: executing SQL statement ("create view sysquerymetrics (uid, g...")
  Database 'tempdb': beginning upgrade step [ID  1505]: executing SQL statement ("update sysattributes set char_value...")
  Database 'tempdb': beginning upgrade step [ID  1105]: noting the present database upgrade level
  Database 'tempdb': beginning upgrade step [ID  1123]: executing SQL statement ("update sysindexes set fill_factor=0...")
  Database 'tempdb': beginning upgrade step [ID  1132]: noting the present database upgrade level
  Database 'tempdb': beginning upgrade step [ID  1134]: executing SQL statement ("if exists (select 1 from syskeys wh...")
  Database 'tempdb': beginning upgrade step [ID  1135]: executing SQL statement ("update syscolumns set usertype = 6...")
  Database 'tempdb': beginning upgrade step [ID  1220]: executing SQL statement ("update sysusers set suid = -2 where...")
  Database 'tempdb': beginning upgrade step [ID  1272]: executing SQL statement ("delete from syskeys where spare1 !=...")
  Database 'tempdb': beginning upgrade step [ID  1273]: executing SQL statement ("update sysobjects set sysstat2 = sy...")
  Database 'tempdb': beginning upgrade step [ID  1299]: noting the present database upgrade level
  Database 'tempdb': beginning upgrade step [ID  1400]: noting the present database upgrade level
  Database 'tempdb': beginning upgrade step [ID  1550]: noting the present database upgrade level
  Database 'tempdb': beginning upgrade step [ID  1554]: upgrade simulated statistics
  Upgrade has finished in database 'tempdb'. ASE is now updating table level statistics for its system tables. Please be patient.
  Database 'tempdb' is now online.
  Database 'model' appears to be at an older revision than the present installation; ASE will assess it, and upgrade it as required.
  Database 'model': beginning upgrade step [ID   247]: verifying sysstatistics row format
  Database 'model': beginning upgrade step [ID     2]: validate basic system type data
  Database 'model': beginning upgrade step [ID     3]: alter table (table sysindexes)
  Database 'model': beginning upgrade step [ID     4]: creating table (table sysanchors)
  Database 'model': beginning upgrade step [ID     5]: changing name of system table (table syspartitions, new name: sysslices)
  Database 'model': beginning upgrade step [ID     6]: creating table (table syspartitions)
  Database 'model': beginning upgrade step [ID     7]: insert rows into syspartitions for each system table and index
  Database 'model': beginning upgrade step [ID     8]: alter table (table systypes)
  Database 'model': beginning upgrade step [ID     9]: alter table (table sysobjects)
  Database 'model': beginning upgrade step [ID   997]: executing SQL statement ("if exists (select 1 from syscolumns...")
  Database 'model': beginning upgrade step [ID   998]: executing SQL statement ("update syscolumns set colid = colid...")
  Database 'model': beginning upgrade step [ID    10]: alter table (table syscolumns)
  Database 'model': beginning upgrade step [ID    11]: insert basic data into bootstrap system tables (table sysobjects)
  Database 'model': beginning upgrade step [ID    69]: executing SQL statement ("if 2 = (select count(name) from sys...")
  Database 'model': beginning upgrade step [ID    12]: alter table (table systabstats)
  Database 'model': beginning upgrade step [ID    26]: alter table (table sysprocedures)
  Database 'model': beginning upgrade step [ID    27]: alter table (table syscomments)
  Database 'model': beginning upgrade step [ID    28]: alter table (table syssegments)
  Database 'model': beginning upgrade step [ID    29]: alter table (table sysprotects)
  Database 'model': beginning upgrade step [ID    30]: alter table (table sysusers)
  Database 'model': beginning upgrade step [ID    31]: alter table (table sysalternates)
  Database 'model': beginning upgrade step [ID    32]: alter table (table sysdepends)
  Database 'model': beginning upgrade step [ID    33]: alter table (table syskeys)
  Database 'model': beginning upgrade step [ID    47]: creating table (table syspartitionkeys)
  Database 'model': beginning upgrade step [ID    51]: alter table (table sysreferences)
  Database 'model': beginning upgrade step [ID    52]: alter table (table sysconstraints)
  Database 'model': beginning upgrade step [ID    54]: alter table (table systhresholds)
  Database 'model': beginning upgrade step [ID    55]: alter table (table sysroles)
  Database 'model': beginning upgrade step [ID    60]: alter table (table sysstatistics)
  Database 'model': beginning upgrade step [ID    62]: alter table (table sysjars)
  Database 'model': beginning upgrade step [ID    68]: creating table (table sysencryptkeys)
  Database 'model': beginning upgrade step [ID    80]: alter table (table sysattributes)
  Database 'model': beginning upgrade step [ID    91]: executing SQL statement ("update systypes set length=@@maxpag...")
  Database 'model': beginning upgrade step [ID   245]: Update system roles in system tables.
  Database 'model': beginning upgrade step [ID   246]: clear unused columns (table sysindexes)
  Database 'model': beginning upgrade step [ID   248]: update system catalog protection data
  Database 'model': beginning upgrade step [ID  1502]: executing SQL statement ("if exists (select 1 from sysobjects...")
  Database 'model': beginning upgrade step [ID  1503]: executing SQL statement ("create view sysquerymetrics (uid, g...")
  Database 'model': beginning upgrade step [ID  1505]: executing SQL statement ("update sysattributes set char_value...")
  Database 'model': beginning upgrade step [ID  1105]: noting the present database upgrade level
  Database 'model': beginning upgrade step [ID  1123]: executing SQL statement ("update sysindexes set fill_factor=0...")
  Database 'model': beginning upgrade step [ID  1132]: noting the present database upgrade level
  Database 'model': beginning upgrade step [ID  1134]: executing SQL statement ("if exists (select 1 from syskeys wh...")
  Database 'model': beginning upgrade step [ID  1135]: executing SQL statement ("update syscolumns set usertype = 6...")
  Database 'model': beginning upgrade step [ID  1220]: executing SQL statement ("update sysusers set suid = -2 where...")
  Database 'model': beginning upgrade step [ID  1272]: executing SQL statement ("delete from syskeys where spare1 !=...")
  Database 'model': beginning upgrade step [ID  1273]: executing SQL statement ("update sysobjects set sysstat2 = sy...")
  Database 'model': beginning upgrade step [ID  1299]: noting the present database upgrade level
  Database 'model': beginning upgrade step [ID  1400]: noting the present database upgrade level
  Database 'model': beginning upgrade step [ID  1550]: noting the present database upgrade level
  Database 'model': beginning upgrade step [ID  1554]: upgrade simulated statistics
  Upgrade has finished in database 'model'. ASE is now updating table level statistics for its system tables. Please be patient.
  Database 'model' is now online.
  Database 'smartco' appears to be at an older revision than the present installation; ASE will assess it, and upgrade it as required.
  Database 'smartco': beginning upgrade step [ID   247]: verifying sysstatistics row format
  Database 'smartco': beginning upgrade step [ID     2]: validate basic system type data
  Database 'smartco': beginning upgrade step [ID     3]: alter table (table sysindexes)
  Database 'smartco': beginning upgrade step [ID     4]: creating table (table sysanchors)
  Database 'smartco': beginning upgrade step [ID     5]: changing name of system table (table syspartitions, new name: sysslices)
  Database 'smartco': beginning upgrade step [ID     6]: creating table (table syspartitions)
  Database 'smartco': beginning upgrade step [ID     7]: insert rows into syspartitions for each system table and index
  Database 'smartco': beginning upgrade step [ID     8]: alter table (table systypes)
  Database 'smartco': beginning upgrade step [ID     9]: alter table (table sysobjects)
  Database 'smartco': beginning upgrade step [ID   997]: executing SQL statement ("if exists (select 1 from syscolumns...")
  Database 'smartco': beginning upgrade step [ID   998]: executing SQL statement ("update syscolumns set colid = colid...")
  Database 'smartco': beginning upgrade step [ID    10]: alter table (table syscolumns)
  Database 'smartco': beginning upgrade step [ID    11]: insert basic data into bootstrap system tables (table sysobjects)
  Database 'smartco': beginning upgrade step [ID    69]: executing SQL statement ("if 2 = (select count(name) from sys...")
  Database 'smartco': beginning upgrade step [ID    12]: alter table (table systabstats)
  Database 'smartco': beginning upgrade step [ID    26]: alter table (table sysprocedures)
  Database 'smartco': beginning upgrade step [ID    27]: alter table (table syscomments)
  Database 'smartco': beginning upgrade step [ID    28]: alter table (table syssegments)
  Database 'smartco': beginning upgrade step [ID    29]: alter table (table sysprotects)
  Database 'smartco': beginning upgrade step [ID    30]: alter table (table sysusers)
  Database 'smartco': beginning upgrade step [ID    31]: alter table (table sysalternates)
  Database 'smartco': beginning upgrade step [ID    32]: alter table (table sysdepends)
  Database 'smartco': beginning upgrade step [ID    33]: alter table (table syskeys)
  Database 'smartco': beginning upgrade step [ID    47]: creating table (table syspartitionkeys)
  Database 'smartco': beginning upgrade step [ID    51]: alter table (table sysreferences)
  Database 'smartco': beginning upgrade step [ID    52]: alter table (table sysconstraints)
  Database 'smartco': beginning upgrade step [ID    54]: alter table (table systhresholds)
  Database 'smartco': beginning upgrade step [ID    55]: alter table (table sysroles)
  Database 'smartco': beginning upgrade step [ID    60]: alter table (table sysstatistics)
  Database 'smartco': beginning upgrade step [ID    62]: alter table (table sysjars)
  Database 'smartco': beginning upgrade step [ID    68]: creating table (table sysencryptkeys)
  Database 'smartco': beginning upgrade step [ID    80]: alter table (table sysattributes)
  Database 'smartco': beginning upgrade step [ID    91]: executing SQL statement ("update systypes set length=@@maxpag...")
  Database 'smartco': beginning upgrade step [ID   245]: Update system roles in system tables.
  Database 'smartco': beginning upgrade step [ID   246]: clear unused columns (table sysindexes)
  Database 'smartco': beginning upgrade step [ID   248]: update system catalog protection data
  Database 'smartco': beginning upgrade step [ID  1502]: executing SQL statement ("if exists (select 1 from sysobjects...")
  Database 'smartco': beginning upgrade step [ID  1503]: executing SQL statement ("create view sysquerymetrics (uid, g...")
  Database 'smartco': beginning upgrade step [ID  1505]: executing SQL statement ("update sysattributes set char_value...")
  Database 'smartco': beginning upgrade step [ID  1105]: noting the present database upgrade level
  Database 'smartco': beginning upgrade step [ID  1123]: executing SQL statement ("update sysindexes set fill_factor=0...")
  Database 'smartco': beginning upgrade step [ID  1132]: noting the present database upgrade level
  Database 'smartco': beginning upgrade step [ID  1134]: executing SQL statement ("if exists (select 1 from syskeys wh...")
  Database 'smartco': beginning upgrade step [ID  1135]: executing SQL statement ("update syscolumns set usertype = 6...")
  Database 'smartco': beginning upgrade step [ID  1220]: executing SQL statement ("update sysusers set suid = -2 where...")
  Database 'smartco': beginning upgrade step [ID  1272]: executing SQL statement ("delete from syskeys where spare1 !=...")
  Database 'smartco': beginning upgrade step [ID  1273]: executing SQL statement ("update sysobjects set sysstat2 = sy...")
  Database 'smartco': beginning upgrade step [ID  1299]: noting the present database upgrade level
  Database 'smartco': beginning upgrade step [ID  1400]: noting the present database upgrade level
  Database 'smartco': beginning upgrade step [ID  1550]: noting the present database upgrade level
  Database 'smartco': beginning upgrade step [ID  1554]: upgrade simulated statistics
  Upgrade has finished in database 'smartco'. ASE is now updating table level statistics for its system tables. Please be patient.
  Database 'smartco' is now online.
  Database 'sybsystemdb' appears to be at an older revision than the present installation; ASE will assess it, and upgrade it as required.
  Database 'sybsystemdb': beginning upgrade step [ID   247]: verifying sysstatistics row format
  Database 'sybsystemdb': beginning upgrade step [ID     2]: validate basic system type data
  Database 'sybsystemdb': beginning upgrade step [ID     3]: alter table (table sysindexes)
  Database 'sybsystemdb': beginning upgrade step [ID     4]: creating table (table sysanchors)
  Database 'sybsystemdb': beginning upgrade step [ID     5]: changing name of system table (table syspartitions, new name: sysslices)
  Database 'sybsystemdb': beginning upgrade step [ID     6]: creating table (table syspartitions)
  Database 'sybsystemdb': beginning upgrade step [ID     7]: insert rows into syspartitions for each system table and index
  Database 'sybsystemdb': beginning upgrade step [ID     8]: alter table (table systypes)
  Database 'sybsystemdb': beginning upgrade step [ID     9]: alter table (table sysobjects)
  Database 'sybsystemdb': beginning upgrade step [ID   997]: executing SQL statement ("if exists (select 1 from syscolumns...")
  Database 'sybsystemdb': beginning upgrade step [ID   998]: executing SQL statement ("update syscolumns set colid = colid...")
  Database 'sybsystemdb': beginning upgrade step [ID    10]: alter table (table syscolumns)
  Database 'sybsystemdb': beginning upgrade step [ID    11]: insert basic data into bootstrap system tables (table sysobjects)
  Database 'sybsystemdb': beginning upgrade step [ID    69]: executing SQL statement ("if 2 = (select count(name) from sys...")
  Database 'sybsystemdb': beginning upgrade step [ID    12]: alter table (table systabstats)
  Database 'sybsystemdb': beginning upgrade step [ID    26]: alter table (table sysprocedures)
  Database 'sybsystemdb': beginning upgrade step [ID    27]: alter table (table syscomments)
  Database 'sybsystemdb': beginning upgrade step [ID    28]: alter table (table syssegments)
  Database 'sybsystemdb': beginning upgrade step [ID    29]: alter table (table sysprotects)
  Database 'sybsystemdb': beginning upgrade step [ID    30]: alter table (table sysusers)
  Database 'sybsystemdb': beginning upgrade step [ID    31]: alter table (table sysalternates)
  Database 'sybsystemdb': beginning upgrade step [ID    32]: alter table (table sysdepends)
  Database 'sybsystemdb': beginning upgrade step [ID    33]: alter table (table syskeys)
  Database 'sybsystemdb': beginning upgrade step [ID    47]: creating table (table syspartitionkeys)
  Database 'sybsystemdb': beginning upgrade step [ID    51]: alter table (table sysreferences)
  Database 'sybsystemdb': beginning upgrade step [ID    52]: alter table (table sysconstraints)
  Database 'sybsystemdb': beginning upgrade step [ID    54]: alter table (table systhresholds)
  Database 'sybsystemdb': beginning upgrade step [ID    55]: alter table (table sysroles)
  Database 'sybsystemdb': beginning upgrade step [ID    60]: alter table (table sysstatistics)
  Database 'sybsystemdb': beginning upgrade step [ID    62]: alter table (table sysjars)
  Database 'sybsystemdb': beginning upgrade step [ID    64]: alter table (table syscoordinations)
  Database 'sybsystemdb': beginning upgrade step [ID    68]: creating table (table sysencryptkeys)
  Database 'sybsystemdb': beginning upgrade step [ID    80]: alter table (table sysattributes)
  Database 'sybsystemdb': beginning upgrade step [ID    91]: executing SQL statement ("update systypes set length=@@maxpag...")
  Database 'sybsystemdb': beginning upgrade step [ID   245]: Update system roles in system tables.
  Database 'sybsystemdb': beginning upgrade step [ID   246]: clear unused columns (table sysindexes)
  Database 'sybsystemdb': beginning upgrade step [ID   248]: update system catalog protection data
  Database 'sybsystemdb': beginning upgrade step [ID  1502]: executing SQL statement ("if exists (select 1 from sysobjects...")
  Database 'sybsystemdb': beginning upgrade step [ID  1503]: executing SQL statement ("create view sysquerymetrics (uid, g...")
  Database 'sybsystemdb': beginning upgrade step [ID  1505]: executing SQL statement ("update sysattributes set char_value...")
  Database 'sybsystemdb': beginning upgrade step [ID  1105]: noting the present database upgrade level
  Database 'sybsystemdb': beginning upgrade step [ID  1123]: executing SQL statement ("update sysindexes set fill_factor=0...")
  Database 'sybsystemdb': beginning upgrade step [ID  1132]: noting the present database upgrade level
  Database 'sybsystemdb': beginning upgrade step [ID  1134]: executing SQL statement ("if exists (select 1 from syskeys wh...")
  Database 'sybsystemdb': beginning upgrade step [ID  1135]: executing SQL statement ("update syscolumns set usertype = 6...")
  Database 'sybsystemdb': beginning upgrade step [ID  1220]: executing SQL statement ("update sysusers set suid = -2 where...")
  Database 'sybsystemdb': beginning upgrade step [ID  1272]: executing SQL statement ("delete from syskeys where spare1 !=...")
  Database 'sybsystemdb': beginning upgrade step [ID  1273]: executing SQL statement ("update sysobjects set sysstat2 = sy...")
  Database 'sybsystemdb': beginning upgrade step [ID  1299]: noting the present database upgrade level
  Database 'sybsystemdb': beginning upgrade step [ID  1400]: noting the present database upgrade level
  Database 'sybsystemdb': beginning upgrade step [ID  1550]: noting the present database upgrade level
  Database 'sybsystemdb': beginning upgrade step [ID  1554]: upgrade simulated statistics
  Upgrade has finished in database 'sybsystemdb'. ASE is now updating table level statistics for its system tables. Please be patient.
  Database 'sybsystemdb' is now online.
  Database 'sybsystemprocs' appears to be at an older revision than the present installation; ASE will assess it, and upgrade it as required.
  Database 'sybsystemprocs': beginning upgrade step [ID   247]: verifying sysstatistics row format
  Database 'sybsystemprocs': beginning upgrade step [ID     2]: validate basic system type data
  Database 'sybsystemprocs': beginning upgrade step [ID     3]: alter table (table sysindexes)
  Database 'sybsystemprocs': beginning upgrade step [ID     4]: creating table (table sysanchors)
  Database 'sybsystemprocs': beginning upgrade step [ID     5]: changing name of system table (table syspartitions, new name: sysslices)
  Database 'sybsystemprocs': beginning upgrade step [ID     6]: creating table (table syspartitions)
  Database 'sybsystemprocs': beginning upgrade step [ID     7]: insert rows into syspartitions for each system table and index
  Database 'sybsystemprocs': beginning upgrade step [ID     8]: alter table (table systypes)
  Database 'sybsystemprocs': beginning upgrade step [ID     9]: alter table (table sysobjects)
  Database 'sybsystemprocs': beginning upgrade step [ID   997]: executing SQL statement ("if exists (select 1 from syscolumns...")
  Database 'sybsystemprocs': beginning upgrade step [ID   998]: executing SQL statement ("update syscolumns set colid = colid...")
  Database 'sybsystemprocs': beginning upgrade step [ID    10]: alter table (table syscolumns)
  Database 'sybsystemprocs': beginning upgrade step [ID    11]: insert basic data into bootstrap system tables (table sysobjects)
  Database 'sybsystemprocs': beginning upgrade step [ID    69]: executing SQL statement ("if 2 = (select count(name) from sys...")
  Database 'sybsystemprocs': beginning upgrade step [ID    12]: alter table (table systabstats)
  Database 'sybsystemprocs': beginning upgrade step [ID    26]: alter table (table sysprocedures)
  Database 'sybsystemprocs': beginning upgrade step [ID    27]: alter table (table syscomments)
  Database 'sybsystemprocs': beginning upgrade step [ID    28]: alter table (table syssegments)
  Database 'sybsystemprocs': beginning upgrade step [ID    29]: alter table (table sysprotects)
  Database 'sybsystemprocs': beginning upgrade step [ID    30]: alter table (table sysusers)
  Database 'sybsystemprocs': beginning upgrade step [ID    31]: alter table (table sysalternates)
  Database 'sybsystemprocs': beginning upgrade step [ID    32]: alter table (table sysdepends)
  Database 'sybsystemprocs': beginning upgrade step [ID    33]: alter table (table syskeys)
  Database 'sybsystemprocs': beginning upgrade step [ID    47]: creating table (table syspartitionkeys)
  Database 'sybsystemprocs': beginning upgrade step [ID    51]: alter table (table sysreferences)
  Database 'sybsystemprocs': beginning upgrade step [ID    52]: alter table (table sysconstraints)
  Database 'sybsystemprocs': beginning upgrade step [ID    54]: alter table (table systhresholds)
  Database 'sybsystemprocs': beginning upgrade step [ID    55]: alter table (table sysroles)
  Database 'sybsystemprocs': beginning upgrade step [ID    60]: alter table (table sysstatistics)
  Database 'sybsystemprocs': beginning upgrade step [ID    62]: alter table (table sysjars)
  Database 'sybsystemprocs': beginning upgrade step [ID    68]: creating table (table sysencryptkeys)
  Database 'sybsystemprocs': beginning upgrade step [ID    80]: alter table (table sysattributes)
  Database 'sybsystemprocs': beginning upgrade step [ID    91]: executing SQL statement ("update systypes set length=@@maxpag...")
  Database 'sybsystemprocs': beginning upgrade step [ID   245]: Update system roles in system tables.
  Database 'sybsystemprocs': beginning upgrade step [ID   246]: clear unused columns (table sysindexes)
  Database 'sybsystemprocs': beginning upgrade step [ID   248]: update system catalog protection data
  Database 'sybsystemprocs': beginning upgrade step [ID  1502]: executing SQL statement ("if exists (select 1 from sysobjects...")
  Database 'sybsystemprocs': beginning upgrade step [ID  1503]: executing SQL statement ("create view sysquerymetrics (uid, g...")
  Database 'sybsystemprocs': beginning upgrade step [ID  1505]: executing SQL statement ("update sysattributes set char_value...")
  Database 'sybsystemprocs': beginning upgrade step [ID  1105]: noting the present database upgrade level
  Database 'sybsystemprocs': beginning upgrade step [ID  1123]: executing SQL statement ("update sysindexes set fill_factor=0...")
  Database 'sybsystemprocs': beginning upgrade step [ID  1132]: noting the present database upgrade level
  Database 'sybsystemprocs': beginning upgrade step [ID  1134]: executing SQL statement ("if exists (select 1 from syskeys wh...")
  Database 'sybsystemprocs': beginning upgrade step [ID  1135]: executing SQL statement ("update syscolumns set usertype = 6...")
  Database 'sybsystemprocs': beginning upgrade step [ID  1220]: executing SQL statement ("update sysusers set suid = -2 where...")
  Database 'sybsystemprocs': beginning upgrade step [ID  1272]: executing SQL statement ("delete from syskeys where spare1 !=...")
  Database 'sybsystemprocs': beginning upgrade step [ID  1273]: executing SQL statement ("update sysobjects set sysstat2 = sy...")
  Database 'sybsystemprocs': beginning upgrade step [ID  1299]: noting the present database upgrade level
  Database 'sybsystemprocs': beginning upgrade step [ID  1400]: noting the present database upgrade level
  Database 'sybsystemprocs': beginning upgrade step [ID  1550]: noting the present database upgrade level
  Database 'sybsystemprocs': beginning upgrade step [ID  1554]: upgrade simulated statistics
  Upgrade has finished in database 'sybsystemprocs'. ASE is now updating table level statistics for its system tables. Please be patient.
  Database 'sybsystemprocs' is now online.
  Database 'dbccdb' appears to be at an older revision than the present installation; ASE will assess it, and upgrade it as required.
  Database 'dbccdb': beginning upgrade step [ID   247]: verifying sysstatistics row format
  Database 'dbccdb': beginning upgrade step [ID     2]: validate basic system type data
  Database 'dbccdb': beginning upgrade step [ID     3]: alter table (table sysindexes)
  Database 'dbccdb': beginning upgrade step [ID     4]: creating table (table sysanchors)
  Database 'dbccdb': beginning upgrade step [ID     5]: changing name of system table (table syspartitions, new name: sysslices)
  Database 'dbccdb': beginning upgrade step [ID     6]: creating table (table syspartitions)
  Database 'dbccdb': beginning upgrade step [ID     7]: insert rows into syspartitions for each system table and index
  Database 'dbccdb': beginning upgrade step [ID     8]: alter table (table systypes)
  Database 'dbccdb': beginning upgrade step [ID     9]: alter table (table sysobjects)
  Database 'dbccdb': beginning upgrade step [ID   997]: executing SQL statement ("if exists (select 1 from syscolumns...")
  Database 'dbccdb': beginning upgrade step [ID   998]: executing SQL statement ("update syscolumns set colid = colid...")
  Database 'dbccdb': beginning upgrade step [ID    10]: alter table (table syscolumns)
  Database 'dbccdb': beginning upgrade step [ID    11]: insert basic data into bootstrap system tables (table sysobjects)
  Database 'dbccdb': beginning upgrade step [ID    69]: executing SQL statement ("if 2 = (select count(name) from sys...")
  Database 'dbccdb': beginning upgrade step [ID    12]: alter table (table systabstats)
  Database 'dbccdb': beginning upgrade step [ID    26]: alter table (table sysprocedures)
  Database 'dbccdb': beginning upgrade step [ID    27]: alter table (table syscomments)
  Database 'dbccdb': beginning upgrade step [ID    28]: alter table (table syssegments)
  Database 'dbccdb': beginning upgrade step [ID    29]: alter table (table sysprotects)
  Database 'dbccdb': beginning upgrade step [ID    30]: alter table (table sysusers)
  Database 'dbccdb': beginning upgrade step [ID    31]: alter table (table sysalternates)
  Database 'dbccdb': beginning upgrade step [ID    32]: alter table (table sysdepends)
  Database 'dbccdb': beginning upgrade step [ID    33]: alter table (table syskeys)
  Database 'dbccdb': beginning upgrade step [ID    47]: creating table (table syspartitionkeys)
  Database 'dbccdb': beginning upgrade step [ID    51]: alter table (table sysreferences)
  Database 'dbccdb': beginning upgrade step [ID    52]: alter table (table sysconstraints)
  Database 'dbccdb': beginning upgrade step [ID    54]: alter table (table systhresholds)
  Database 'dbccdb': beginning upgrade step [ID    55]: alter table (table sysroles)
  Database 'dbccdb': beginning upgrade step [ID    60]: alter table (table sysstatistics)
  Database 'dbccdb': beginning upgrade step [ID    62]: alter table (table sysjars)
  Database 'dbccdb': beginning upgrade step [ID    68]: creating table (table sysencryptkeys)
  Database 'dbccdb': beginning upgrade step [ID    80]: alter table (table sysattributes)
  Database 'dbccdb': beginning upgrade step [ID    91]: executing SQL statement ("update systypes set length=@@maxpag...")
  Database 'dbccdb': beginning upgrade step [ID   245]: Update system roles in system tables.
  Database 'dbccdb': beginning upgrade step [ID   246]: clear unused columns (table sysindexes)
  Database 'dbccdb': beginning upgrade step [ID   248]: update system catalog protection data
  Database 'dbccdb': beginning upgrade step [ID  1502]: executing SQL statement ("if exists (select 1 from sysobjects...")
  Database 'dbccdb': beginning upgrade step [ID  1503]: executing SQL statement ("create view sysquerymetrics (uid, g...")
  Database 'dbccdb': beginning upgrade step [ID  1505]: executing SQL statement ("update sysattributes set char_value...")
  Database 'dbccdb': beginning upgrade step [ID  1105]: noting the present database upgrade level
  Database 'dbccdb': beginning upgrade step [ID  1123]: executing SQL statement ("update sysindexes set fill_factor=0...")
  Database 'dbccdb': beginning upgrade step [ID  1132]: noting the present database upgrade level
  Database 'dbccdb': beginning upgrade step [ID  1134]: executing SQL statement ("if exists (select 1 from syskeys wh...")
  Database 'dbccdb': beginning upgrade step [ID  1135]: executing SQL statement ("update syscolumns set usertype = 6...")
  Database 'dbccdb': beginning upgrade step [ID  1220]: executing SQL statement ("update sysusers set suid = -2 where...")
  Database 'dbccdb': beginning upgrade step [ID  1272]: executing SQL statement ("delete from syskeys where spare1 !=...")
  Database 'dbccdb': beginning upgrade step [ID  1273]: executing SQL statement ("update sysobjects set sysstat2 = sy...")
  Database 'dbccdb': beginning upgrade step [ID  1299]: noting the present database upgrade level
  Database 'dbccdb': beginning upgrade step [ID  1400]: noting the present database upgrade level
  Database 'dbccdb': beginning upgrade step [ID  1550]: noting the present database upgrade level
  Database 'dbccdb': beginning upgrade step [ID  1554]: upgrade simulated statistics
  Upgrade has finished in database 'dbccdb'. ASE is now updating table level statistics for its system tables. Please be patient.
  Database 'dbccdb' is now online.
  Database 'sybsecurity' appears to be at an older revision than the present installation; ASE will assess it, and upgrade it as required.
  Database 'sybsecurity': beginning upgrade step [ID   247]: verifying sysstatistics row format
  Database 'sybsecurity': beginning upgrade step [ID     2]: validate basic system type data
  Database 'sybsecurity': beginning upgrade step [ID     3]: alter table (table sysindexes)
  Database 'sybsecurity': beginning upgrade step [ID     4]: creating table (table sysanchors)
  Database 'sybsecurity': beginning upgrade step [ID     5]: changing name of system table (table syspartitions, new name: sysslices)
  Database 'sybsecurity': beginning upgrade step [ID     6]: creating table (table syspartitions)
  Database 'sybsecurity': beginning upgrade step [ID     7]: insert rows into syspartitions for each system table and index
  Database 'sybsecurity': beginning upgrade step [ID     8]: alter table (table systypes)
  Database 'sybsecurity': beginning upgrade step [ID     9]: alter table (table sysobjects)
  Database 'sybsecurity': beginning upgrade step [ID   997]: executing SQL statement ("if exists (select 1 from syscolumns...")
  Database 'sybsecurity': beginning upgrade step [ID   998]: executing SQL statement ("update syscolumns set colid = colid...")
  Database 'sybsecurity': beginning upgrade step [ID    10]: alter table (table syscolumns)
  Database 'sybsecurity': beginning upgrade step [ID    11]: insert basic data into bootstrap system tables (table sysobjects)
  Database 'sybsecurity': beginning upgrade step [ID    69]: executing SQL statement ("if 2 = (select count(name) from sys...")
  Database 'sybsecurity': beginning upgrade step [ID    12]: alter table (table systabstats)
  Database 'sybsecurity': beginning upgrade step [ID    26]: alter table (table sysprocedures)
  Database 'sybsecurity': beginning upgrade step [ID    27]: alter table (table syscomments)
  Database 'sybsecurity': beginning upgrade step [ID    28]: alter table (table syssegments)
  Database 'sybsecurity': beginning upgrade step [ID    29]: alter table (table sysprotects)
  Database 'sybsecurity': beginning upgrade step [ID    30]: alter table (table sysusers)
  Database 'sybsecurity': beginning upgrade step [ID    31]: alter table (table sysalternates)
  Database 'sybsecurity': beginning upgrade step [ID    32]: alter table (table sysdepends)
  Database 'sybsecurity': beginning upgrade step [ID    33]: alter table (table syskeys)
  Database 'sybsecurity': beginning upgrade step [ID    47]: creating table (table syspartitionkeys)
  Database 'sybsecurity': beginning upgrade step [ID    51]: alter table (table sysreferences)
  Database 'sybsecurity': beginning upgrade step [ID    52]: alter table (table sysconstraints)
  Database 'sybsecurity': beginning upgrade step [ID    54]: alter table (table systhresholds)
  Database 'sybsecurity': beginning upgrade step [ID    55]: alter table (table sysroles)
  Database 'sybsecurity': beginning upgrade step [ID    60]: alter table (table sysstatistics)
  Database 'sybsecurity': beginning upgrade step [ID    62]: alter table (table sysjars)
  Database 'sybsecurity': beginning upgrade step [ID    68]: creating table (table sysencryptkeys)
  Database 'sybsecurity': beginning upgrade step [ID    80]: alter table (table sysattributes)
  Database 'sybsecurity': beginning upgrade step [ID    91]: executing SQL statement ("update systypes set length=@@maxpag...")
  Database 'sybsecurity': beginning upgrade step [ID   244]: alter table (table sysaudits_01)
  Database 'sybsecurity': beginning upgrade step [ID   244]: alter table (table sysaudits_02)
  Database 'sybsecurity': beginning upgrade step [ID   244]: alter table (table sysaudits_03)
  Database 'sybsecurity': beginning upgrade step [ID   245]: Update system roles in system tables.
  Database 'sybsecurity': beginning upgrade step [ID   246]: clear unused columns (table sysindexes)
  Database 'sybsecurity': beginning upgrade step [ID   248]: update system catalog protection data
  Database 'sybsecurity': beginning upgrade step [ID  1502]: executing SQL statement ("if exists (select 1 from sysobjects...")
  Database 'sybsecurity': beginning upgrade step [ID  1503]: executing SQL statement ("create view sysquerymetrics (uid, g...")
  Database 'sybsecurity': beginning upgrade step [ID  1505]: executing SQL statement ("update sysattributes set char_value...")
  Database 'sybsecurity': beginning upgrade step [ID  1105]: noting the present database upgrade level
  Database 'sybsecurity': beginning upgrade step [ID  1123]: executing SQL statement ("update sysindexes set fill_factor=0...")
  Database 'sybsecurity': beginning upgrade step [ID  1132]: noting the present database upgrade level
  Database 'sybsecurity': beginning upgrade step [ID  1134]: executing SQL statement ("if exists (select 1 from syskeys wh...")
  Database 'sybsecurity': beginning upgrade step [ID  1135]: executing SQL statement ("update syscolumns set usertype = 6...")
  Database 'sybsecurity': beginning upgrade step [ID  1215]: executing SQL statement ("if not exists (select num from sysa...")
  Database 'sybsecurity': beginning upgrade step [ID  1220]: executing SQL statement ("update sysusers set suid = -2 where...")
  Database 'sybsecurity': beginning upgrade step [ID  1272]: executing SQL statement ("delete from syskeys where spare1 !=...")
  Database 'sybsecurity': beginning upgrade step [ID  1246]: executing SQL statement ("if not exists (select num from sysa...")
  Database 'sybsecurity': beginning upgrade step [ID  1273]: executing SQL statement ("update sysobjects set sysstat2 = sy...")
  Database 'sybsecurity': beginning upgrade step [ID  1299]: noting the present database upgrade level
  Database 'sybsecurity': beginning upgrade step [ID  1400]: noting the present database upgrade level
  Database 'sybsecurity': beginning upgrade step [ID  1410]: executing SQL statement ("if not exists (select num from sysa...")
  Database 'sybsecurity': beginning upgrade step [ID  1552]: executing SQL statement ("if not exists (select num from sysa...")
  Database 'sybsecurity': beginning upgrade step [ID  1550]: noting the present database upgrade level
  Database 'sybsecurity': beginning upgrade step [ID  1554]: upgrade simulated statistics
  Upgrade has finished in database 'sybsecurity'. ASE is now updating table level statistics for its system tables. Please be patient.
  Database 'sybsecurity' is now online.
Adding check table sysanchors attribute to sysattributes
Adding rename sysslices attribute to sysattributes
Adding check table syspartitions attribute to sysattributes
Adding fill syspartitions attribute to sysattributes
Adding check table systypes attribute to sysattributes
Adding check table sysobjects attribute to sysattributes
Adding check table syscolumns attribute to sysattributes
Adding instantiate sysobjects columns attribute to sysattributes
Adding check table sysusages attribute to sysattributes
Adding check table syspartitionkeys attribute to sysattributes
Adding split table systabstats columns attribute to sysattributes
Adding check table sysoptions attribute to sysattributes
Adding check table sysauditoptions attribute to sysattributes
Adding check table syaudits_* attribute to sysattributes
Adding check system roles in sysroles/sysusers attribute to sysattributes
Adding clear obsolete sysindexes cols attribute to sysattributes
Adding Sysstatistics Galaxy columns attribute to sysattributes
Adding grant/revoke for system tables attribute to sysattributes
Adding validate system tables attribute to sysattributes
Adding delete syscolumns encrypt col stats attribute to sysattributes
Adding modify syscolumns encrypt col IDs attribute to sysattributes
Adding add metrics config param attribute to sysattributes
Adding drop metrics view attribute to sysattributes
Adding add metrics view attribute to sysattributes
Adding unslice tables attribute to sysattributes
Adding remove upgrade SQL text attribute to sysattributes
Adding update obsolete cluster IDs attribute to sysattributes
Adding checkpoint version 15.0 attribute to sysattributes
Adding add key custodian role attribute to sysattributes
Adding add key custodian audit option attribute to sysattributes
Adding add key custodian attribute attribute to sysattributes
Adding update sysstats fmt_table attribute to sysattributes
Adding Add password downgrade class to sysattributes attribute to sysattributes
Adding Add login policy class to sysattributes attribute to sysattributes
Adding set option network password encryption to true attribute to sysattributes
Adding remove unused configuration parameters attribute to sysattributes
Adding startup delay attribute to sysattributes
Adding net password encryption attribute to sysattributes
Adding wsudws attribute to sysattributes
Adding wsalias attribute to sysattributes
Adding registered js class to sysattributes
Adding job scheduler info attribute to sysattributes
Adding scripts-version class to sysattributes
Adding versioning install scripts attribute to sysattributes
Adding unsliced tables attribute to sysattributes
Adding password downgrade class class to sysattributes
Adding allow password downgrade attribute to sysattributes
Adding login policy class class to sysattributes
Adding enable last login updates attribute to sysattributes
Adding new configuration variables to sysconfigures.
Updating configuration variables in sysconfigures.
Adding configuration variables to sysattributes.
Updating sysconfigures and creating new file.
Upgrade to Adaptive Server 15.0.0.0 is complete.
Upgrade completed with no errors.
Tue Feb 19 11:43:13 2008: (SQL command) shutdown
Tue Feb 19 11:43:14 2008: (Shell command) /Software/sybase/sybase-15.0.2-ESD2/ASE-15_0/bin/dataserver -sSMA_D1_ASE -d/smartco/sybase/SMA_D1_ASE/master.dat -e/Software/sybase/sybase-15.0.2-ESD2/ASE-15_0/install/SMA_D1_ASE.log -c/Software/sybase/sybase-15.0.2-ESD2/ASE-15_0/SMA_D1_ASE.cfg -M/Software/sybase/sybase-15.0.2-ESD2/ASE-15_0 -i/Software/sybase/sybase-15.0.2-ESD2 -T1623 > /dev/null 2>&1
Tue Feb 19 11:43:24 2008: (SQL command) use master
Tue Feb 19 11:43:25 2008: (SQL command) update sysdatabases set status = status | 8 where dbid = db_id('sybsystemprocs')
Tue Feb 19 11:43:25 2008: (SQL command) use sybsystemprocs
Tue Feb 19 11:43:25 2008: (SQL command) checkpoint
Tue Feb 19 11:43:25 2008: Executing SQL script '/Software/sybase/sybase-15.0.2-ESD2/ASE-15_0/scripts/installmaster'
Tue Feb 19 11:43:59 2008: (SQL command) use master
Tue Feb 19 11:43:59 2008: Executing SQL script '/Software/sybase/sybase-15.0.2-ESD2/ASE-15_0/scripts/installsecurity'
Tue Feb 19 11:44:00 2008: Executing SQL script '/Software/sybase/sybase-15.0.2-ESD2/ASE-15_0/scripts/installcommit'
Tue Feb 19 11:44:00 2008: (SQL command) shutdown
Tue Feb 19 11:44:00 2008: (Shell command) /Software/sybase/sybase-15.0.2-ESD2/ASE-15_0/bin/dataserver -sSMA_D1_ASE -d/smartco/sybase/SMA_D1_ASE/master.dat -e/Software/sybase/sybase-15.0.2-ESD2/ASE-15_0/install/SMA_D1_ASE.log -c/Software/sybase/sybase-15.0.2-ESD2/ASE-15_0/SMA_D1_ASE.cfg -M/Software/sybase/sybase-15.0.2-ESD2/ASE-15_0 -i/Software/sybase/sybase-15.0.2-ESD2 > /dev/null 2>&1

Historique

Version Date Commentaires
1.0 03/2008 Version initiale

Liens

Sybase Books Online : Upgrading to Adaptive Server 15.0.2
Sybase Books Online 15.0