replicate ASE 11.0.3 via R.S. 11.5 to ASE 11.9.2
Has any one successfully replicated from 11.0.3 using Rep Server 11.5 to
ASE 11.9.2 using ltm's? We are running on solaris 2.6 using veritas
filesystem and keep getting stack traces (this shuts down the
I would like to know if anyone else has replicated using these versions
or something similar. Thanks.
Yes, I have done this. No specific problems.
Certified Sybase ASE 11.5 Administrator (Professional)
Certified DBA/Performance...Replication from ASE 11.92 and Rep 11.5 on AIX 4.2.1 to Linux ASE 11.92 possible?
We are trying to work this out and so far have hit a few snags. Here is the
Our Linux server is named tlaas_linux1 and our AIX server is ZYDVAX01. The
ASE servers are named tlaas_linux1_sy and ZYDVAX01_SY respectively.
-isql -Usa -Ppassword -SZYDVAX01_SY (works)
-exec ZYDVAX01_SY.master..sp_who (works)
-isql -Umaintuser -Pmaintpass -Stlaas_linux1_sy (works)
-isql -Usa -Ppassword -Stlaas_linux1_sy (works)
-exec tlaas_linux1_sy.master..sp_who (works when logged into
ZYDVAX01_SY.mzypd using isql)
-stored procs in the replicate database...SQLRemote Problem with 7.0.2-1 and 6.0.2-1 on Linux [ASE 11.9.2-3 and ASE 12.5 eval]
I got the following problems using sql-remote.
on ASE 12.5 eval:
I got the following RPMs installed on RedHat Linux 7.2 - Kernel 2.4.17 -
After the execution of ssxtract or ssremote I got an error like:
../ssxtract: /opt/sybase-12.5/SQLRemote/lib/libsstasks7_r.so: version
`libdbtasks7_r.so' not found (required by ./ssxtract)
The file libsstasks7_r.so exists and the path is correctly specified in
There'...Transferring database ASE 11.9.2 -> ASE 11.5
I need to transfer a database from a ASE 11.9.2 server to a ASE 11.5
server. (Servers have the same specs and run Windows NT 4.0). The
database doesn't have many objects such as tables, users, Views, SP's
etc. etc. It has a 400 MB device for data and 100 MB Device for the log,
with standard segmentation. It's relatively small.
I understand from this newsgroup that dumping on a newer release and
loading on an older release is not an option. Now I figure I have to do
- Create a data and a log device with similar names and sizes on the ASE
11.5 se...ASE 12 running with ASE 11.9.2 and RS 11.5
I have a customer that asks the following question:
"Are there any issues running Sybase 32 and 64 bit applications on the
same box? What about replication? Is it possible for us to upgrade
to 12 repserver and dataserver on our central complex and continue to
run 11.5 repserver/11.9.2 dataserver at remotes?"
I would think that this configuration would be ok, but I thought
I'd better verify it.
Pat Proft wrote:
> I have a customer that asks the following question:...Upgrade 22.214.171.124 to ASE 11.9.2 with RepServer 11.5 and LTMs
I am preparing to upgrade our production servers (126.96.36.199) 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
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 / ...Download Database from ASE 11.9.2 to ASE 11.0.2 ?
We have a Sybase ASE11.9.2 on Window NT, and we already run some
application on it about 6 months. Since the third party software we use
cann't support ASE11.9.2, we must use ASE 11.0.2. Can we just backup the
database of ASE11.9.2 then restore the backup database to ASE11.0.2 ?
Has it any problem ? Or, We must do following procedure.
1) bcp out the data from ASE11.9.2
2) create the database on ASE11.0.2
3) bcp in the 1) data to ASE11.0.2
Can anyone tell me??
The problem with dump and load is that the log format in 11.9.2 is much
diff...Problems in upgrading ASE 11.5 to 11.9.2
Currently, we use ASE 11.5 and then install 11.9.2 to upgrade the
server. After installing all components of ASE, I can't open the
databases in Sybase Central, it prompts :
"Changed database context to 'master'. Invalid system table given for
status update, this is an internal error"
And then we tried to upgrade the server by selecting the option of
server configure. In the upgrade progress, it asks whether to back up
the database or not, we select Ok to continue. After a moment, it
"Server "OPR" fail preupgrade eligibility tes. See ...Upgrade of ASE from 11.5.1 to 11.9.2
We have replication running against 50 SQL Anywhere v 5.4 sites. It has
been running for approx 1 1/2 years. We are upgrading our ASE (the
consolidated db) from 11.5.1 to 11.9.2. Has anyone experienced any
problems when upgrading the consolidated db with ongoing replication?
Shouldn't be an issue.
We created some tech docs on Upgrading ASE's that are involved with SQL
Remote. I highly suggest you look for those to follow. You don't want to
make any mistakes.
Let us know if you can't find one that seems appropriate.
Sybase - iAnywhere Sol...ASE Certification 11.9.2 and 11.5.1
I need to know, if 11.9.2 and 11.5.1 run over dg-ux R.4.20MU05
Thanks in advance
Hi Pablo, looks like both 11.5 and 11.9.x are certified. Note "later
MUOx OS levels are covered":
The patches needed are
...Connection between IQ 11.5 and ASE 11.9.2
I have customer who tries from IQ 11.5 (on Windows NT4) to load datas
from ASE 11.9.2 (on Unix platform) but nothing happens,no errors in the
errorlog of ASE 11.9.2 or in the errorlog of IQ ...!!!From isql it works
It used to work before .
Thank you for your help .
...11.9.2 -> 188.8.131.52: errors from installdbccdb and instcomm
I recently upgraded from 11.9.2 to 184.108.40.206 using EBF9620. I unzipped the
downloaded upgrade file and overwrote the files in the $SYBASE tree. I
then proceeded to run the upgrade scripts as directed in the cover letter
(scripts located in $SYBASE\scripts).
The "instmstr.sql" and "instmsgs.ebf" scripts ran just fine, but the
"installdbccdb" and "instcomm" scripts produced some errors about objects
not being found. The server appears to be operating just fine, but I
wanted to know if I should be concerned about these errors.
"ins...Problem in Installating Monitor Server 11.9.2 on ASE 11.9.2.
I was tryint to install SQL monitor server 11.9.2 on ASE 11.9.2 on HP-UX
11.0 9000/800. It gives the following error
Nov 14 12:28:18 2000: DB-Library Version:
Nov 14 12:28:18 2000: Sybase DB-Library/11.1.1/P-EBF8022/hp800/HP-UX
10.01/1/OPT/Fri Jun 26 15:04:39 1998
Nov 14 12:28:18 2000: Open Server Version:
Nov 14 12:28:18 2000: Sybase Server-Library/11.1.1/P-EBF8022/hp800/HP-UX
10.01/1/OPT/Fri Jun 26 13:53:53 1998
Nov 14 12:2...convert float to char (ASE 11.9.2 , ASE 11.9.3)
declare @n float
select @n = 12.001
select convert(varchar(20), @n)
Why? MS SQL 6.5 returns
This is a multi-part message in MIME format.
Content-Type: text/plain; charset=us-ascii
First, when converting from an imprecise numeric (FLOAT, REAL) you
should be using
the str() function, rather than convert.
The floating point datatype cannot store 12.001 exactly.
The convert is displaying the value that is ...