upgrade 11.5.1 (with replicate dbs) to 11.9.2 
Author Message
 upgrade 11.5.1 (with replicate dbs) to 11.9.2

Hello,

I'm going to upgrade a ASE 11.5.1 server which has replicated
databases to ASE 11.9.2. Repserver version is 11.5, all ltms
converted to RepAgents.

The only information I found is in Appendix A of the 11.9.2
Installation guide :

The process should be (I only have one RSSD and no routes) (I
abbriviated it a little bit) :

- drain transaction logs for PDBs to ensure that all transactions
  have been replicated.

- shutdown ltm
  execute dbcc settrunc('ltm', 'ignore')

after the upgrade:

- execute rs_zeroltm and dbcc settrunc(ltm,valid) in the PDBs.

- restart the ltms.

The descriptions doesn't say anyting about RepAgents, but I verified
with Sybase and they told me I should stop replication (with
sp_stop_rep_agent) and disable the RepAgent (with sp_config_rep_agent).

So I know what to do. Did anyone upgraded a similar configuration
and did you encounter any problem ?

Thanks,
Luc.

______________________________________________________________________
Luc Van der Veurst                                      ISUG President
Academic Hospital, VUB                             http://www.***.com/
Laarbeeklaan 101, 1090 Brussels, Belgium
32 - 2 477 69 80      



Tue, 26 Mar 2002 03:00:00 GMT
 upgrade 11.5.1 (with replicate dbs) to 11.9.2

Luc,

I upgraded several ASE's from 11.5.1 to 11.9.2 without problems.
I followed (nearly all) instructions in Appendix A.

   * I quiesced the RS
     (checked the timestamp value of last log page and
     ltm-trunc point)
   * shutdown RS (including RepAgents)
   * truncated trunsaction logs
   * upgraded ASE
   * restarted RS (include RepAgents)

I only reset the locater of  the RSSD database itself.
I didn't apply it to the User PDB's.

Karl Jost
RTL Television


Quote:
> Hello,

> I'm going to upgrade a ASE 11.5.1 server which has replicated
> databases to ASE 11.9.2. Repserver version is 11.5, all ltms
> converted to RepAgents.

> The only information I found is in Appendix A of the 11.9.2
> Installation guide :

> The process should be (I only have one RSSD and no routes) (I
> abbriviated it a little bit) :

> - drain transaction logs for PDBs to ensure that all transactions
>   have been replicated.

> - shutdown ltm
>   execute dbcc settrunc('ltm', 'ignore')

> after the upgrade:

> - execute rs_zeroltm and dbcc settrunc(ltm,valid) in the PDBs.

> - restart the ltms.

> The descriptions doesn't say anyting about RepAgents, but I verified
> with Sybase and they told me I should stop replication (with
> sp_stop_rep_agent) and disable the RepAgent (with sp_config_rep_agent).

> So I know what to do. Did anyone upgraded a similar configuration
> and did you encounter any problem ?

> Thanks,
> Luc.

> ______________________________________________________________________
> Luc Van der Veurst                                      ISUG President
> Academic Hospital, VUB                             http://www.isug.com
> Laarbeeklaan 101, 1090 Brussels, Belgium
> 32 - 2 477 69 80




Tue, 26 Mar 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Opinions needed for Upgrade 11.0.3.3 to 11.9.2

2. 11.0.3.3 to 11.5.1 upgrade (NT 4.0)

3. Cant Upgrade 11.0.2 to 11.5.1 ...sqlupgrade fails

4. Upgraded from 11.0.3 to 11.5.1

5. Error when upgrading Sybase 11.0.2 to 11.0.3

6. upgrading 11.5.1 --> 11.9.3

7. 11.0.3 to 11.9.2 upgrade

8. Dump and load upgrade: 11.0.3.3 to 11.9.2

9. Q: Upgrade 11.0.2.2 to 11.9.2 possible [HP-UX]

10. Upgrade from 11.0.2 to 11.5.1

11. 11.0.1 to 11.0.3 upgrade


 
Powered by phpBB® Forum Software