Upgrade 11.0.3.3 to ASE 11.9.2 with RepServer 11.5 and LTMs
I am preparing to upgrade our production servers (11.0.3.3) using RepServer 11.5 with LTMs. My understanding is that the ASE 11.9.2 has RepAgents build in as Open Server applications. Are there any issues with upgrading that I need to be aware of? Where would I look? I would assume that I don't need to run LTMs anymore, but I need to ensure no loss of replication to the warm standby. Any advice? Take care. JCS ASE 11.5+ has RepAgent built in as internal server threads (which has nothing to do with OpenServer). When upgrading, keep the LTM's and upgrade to RS 11.5 / ...

Replication Server 11.5
Simply, can I replicate from 11.9.3 to 11.0.3.3 using Replication Server 11.5, warm standby solution with replication definitions? We are in the process of upgrading our production systems to 11.9.3 from 11.0.3.3. Our current scenerio looks like this: Server A : 11.0.3.3 Production ASE/11.5 RepServer Server B: 11.0.3.3 ASE Server C: 11.0.3.3 ASE 1. Currently replicating Server A --> Server C 2. Upgrade Server B to 11.9.3. 3. Replicate Server A --> Server B ** This is where my question fits in--if a "switch" is needed, can 11.9.3 --> 11.0.3.3? 4. Sto...

Error after upgrade from 11.0.3.3 to 11.9.2.3
We have upgraded our production Sybase servers to 11.9.2 from 11.0.3.3 last weekend and we applied ebf9160 All went well except for an error in the errorlog as follows NT operating system error 2 in module 'e:\rel1192\porttree\svr\sql\generic\ksource\strmio\n_winsock.c' at line 3481: The system cannot find the file specified. kernel nl__connect: Could not connect to site 'VUA_S2002_XP', socket 1. This error did not occur when we tested the upgrade on our test servers. There appears to be no problems with the overall install, everything works fine - except for t...

RFI
Hi, Is it worth going to 11.5.1 considering 11.9.2 is out? I'm looking for information about upgrading 11.0.3 to 11.5.1 or 11.9.2 on HP-UX. Looking for advice, tips & tricks, pitfalls, etc I'm also interested in other peoples exeriances with 11.5.1 and 11.9.2 with regaurds to performance, stability, bugs & problems. thanks in advance Andrew. -- The views expressed are those of the author, not necessarily of Innovus Limited. Andrew, When I took the "Powering-up for ASE 11.5" class from Syba...

Replication between SQL Server 11.0.2 and SQL Anywhere 5.5.0.3
Does anyone know if exists some document with the details on Replication between Sybase SQL Server 11.0.2 and SQL Anywhere 5.5.0.3 using Replication Server 11.0.3. I�m having some troubles with this configuration and I�m wondering if I�m doing something wrong. Thanks in advance. ...

PB with ODBC during migration SQL*Server 11.0.3 -> 11.9.2
An application is using ODBC v 3.01.00.00 (sybase inc.) to communicate with SQL*server v11.0.3.3. Everything is working properly. We are testing this same application and the same version of ODBC with ASE v11.9.2. Then, the application is not working correctly. In fact, ASE is not able to interpret, understand input and output parameters correctly. Apparently, ASE does no longer understand "rdTypeNumeric" datatype parameters, and it associates them to a "rdTypeBinary" datatype parameters. Error 40043 is generated. Thanks a lot for your help LM ...

PB with ODBC during migration SQL*Server 11.0.3 -> 11.9.2
An application is using ODBC v 3.01.00.00 (sybase inc.) to communicate with SQL*server v11.0.3.3. Everything is working properly. We are testing this same application and the same version of ODBC with ASE v11.9.2. Then, the application is not working correctly. In fact, ASE is not able to interpret, understand input and output parameters correctly. Apparently, ASE does no longer understand "rdTypeNumeric" datatype parameters, and it associates them to a "rdTypeBinary" datatype parameters. Error 40043 is generated. Thanks a lot for your help LM...

Dumps compatability between 11.0.3 and 11.0.2.x of SQL Server
Dear all, Is there any compatibilty problem with the dumps on Sco Openserver for SQL Server 11.0.3 and 11.0.2 I wish to load a dump from 11.0.3 to 11.0.2.x . I cannot install 11.0.3.2 now due to some reasons. Will dbcc fixvers allow me to load a 11.0.3 dump to 11.0.2.x Any information is welcome. Thanks in advance. Manojit Paul This is a multi-part message in MIME format. --------------31015174C369A52017E56DF4 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit SPG-TECH-CALCUTTA wrote: > > Dear a...

upgrade from 11.0.3.3 to 11.9.2 on NT
We have currently upgraded several servers on HP/SUN platforms successfully from 11.0.3.3 to 11.9.2. In 12 sybase splits open client and ASE to have their own variables. We did this with our upgrade to 11.9.2, but opposite the way sybase handles this in version 12. We have set our SYBASE variable to the path of open client (/appl/sybase/oc/1111) and SYB_SRV to the path of ASE(/appl/sybase/ase/1192). We need to upgrade our servers on NT but the change to our variables has caused a snag. We would like to be consistant across all platforms. Any suggestions would be greatly appreci...

Upgrading from 11.0.3.3 to 11.9.2 on Linux
Hi, I've downloaded the 11.9.2 Linux versino of Sybase and want to upgrade an existing installation from 11.0.3.3 to this more up to date version. The documentation refers to an executable on the cd called sybsetup, however, I've downloaded the rpm files off the web and don't have a sybsetup executable. When I try to install the rpm for 11.9.2 it tells me that there is already an earlier version of Sybase installed. Can anyone tell me how to get around this! >rpm -ivh sybase-ase-11.9.2-3.i386.rpm error: failed dependencies: sybase-ase < 11.9.2 conflicts ...

Upgrade 11.0.3.3 to 11.9.2.1
Hello ASE guru, We just did a ASE upgrade to 11.9.2.1 from 11.0.3.3 and noticed that the sybsystemprocs database was extended by 2 MB on master device. (before upgrade size was 120 MB and after upgrade the size is 122MB) Is this a normal behavior of upgrade? any harm in leaving 2 MB on master device? Will upgrade fail if there is no room for this 2 MB on master device? Thanks for your help. kp wrote: > We just did a ASE upgrade to 11.9.2.1 from 11.0.3.3 and noticed that the You'd want to get the latest EBF and get it up to 11.9.2.3. > sybsystemprocs da...

11.0.3.3 to 11.9.2 upgrade on NT
We have currently upgraded several servers on HP/SUN platforms successfully from 11.0.3.3 to 11.9.2. In 12 sybase splits open client and ASE to have their own variables. We did this with our upgrade to 11.9.2, but opposite the way sybase handles this in version 12. We have set our SYBASE variable to the path of open client (/appl/sybase/oc/1111) and SYB_SRV to the path of ASE(/appl/sybase/ase/1192). We need to upgrade our servers on NT but the change to our variables has caused a snag. We would like to be consistant across all platforms. Any suggestions would be greatly appreci...

SQL monitor 11.5.1 on sql server 11.0.3 installation problem
Hello I have sql server 11.0.3.3 swr 8296 running on sun solaris 2.6 I asked for a monitor server and received a sybase 11.5.1 cdrom. I installed monitor server over the existing /usr/sybase 11.0.3 directory. Now I �m missing a detailed startup configation instruction or the run_monserver file. The interfaces file contains three servers 1. SYBASE .... 2. ehd 3. SYB_BACKUP any help is welcome. Matthias Rabast wrote: > I have sql server 11.0.3.3 swr 8296 running on sun solaris 2.6 > I asked for a monitor server and received a sybase 11.5.1 cdrom. > I instal...

Performance degrades: 11.0.3.3 upgraded to 11.9.2
We recently upgraded a test server from ASE 11.0.3 on HP-UX 10.20 to ASE 11.9.2 on HP-UX 11.0. We have a query that runs in 15 min in production (11.0.3) an 60 minutes in test (11.9.2). Another query runs for 20 min in production and has yet to finish in test (11.9.2). We did update all statistics on the tables and have recompiled the stored procedures. Any help, advice or comments would be greatly appreciated. Georgette M. Geotsi DaimlerChrysler Capital Services GGeotsi@DCXCapital.com GGeotsi@dcxcapital.com wrote: > > We recently upgraded a test server from ASE ...