Fixing User Database Upgrades with sysadmin upgrade, "database"

Apply upgrades to Adaptive Server or Sybase® IQ, primary, replicate, or standby databases in the replication system that failed to upgrade during the automatic upgrade process, or to databases that you excluded from the automatic upgrade process.

1. Enter admin version, “connection” at the upgraded Replication Server to identify the user databases that you must upgrade.
   You see a list of the user databases and data servers, the database IDs, the corresponding Replication Server, and the status of the database. For example:

   dbid    Name        Controller RS   Status
   ------  ----------  --------------  ------------------
   101     pds.pdb01   rs_12           Database needs upgrade
   102     pds.pdb02   rs_12           Database is not accessible
   103     rds.rdb01   rs_12           Database has been upgraded

   The “Not accessible” status means that Replication Server cannot connect to this user database because the database is unavailable, or because the maintenance user ID that Replication Server uses to connect to the database has insufficient privileges to connect.
2. Enter sysadmin upgrade, "database" at the upgraded Replication Server to upgrade the user databases served by the Replication Server:

   sysadmin upgrade, "database" {,data_server, database | all}

   where:

   • dataserver_name, database_name – specifies a database to upgrade. You must enter a separate command for each database.
   • all – upgrades all databases served by the Replication Server. Replication Server displays error messages if a database does not meet the conditions for upgrade.
   For example, to upgrade the pdb01 database in the pds data server, enter:

   sysadmin upgrade, database, pds, pdb01

   If any of the databases fail to upgrade, see the Replication Server error log for the reasons such as:

   Database data_server.database is not accessible.
   Fail to upgrade data_server.database.