ASE 12.0.0.0 / SWR 8775 UPGRADE TO ASE 12.0.0.6/EBF 10628 PERFORMANCE PROBLEMHi All,
We recently upgraded ASE 12.0.0.0/SWR 8775 to ASE 12.0.0.6/EBF 10628.
Some queries stopped returning resultsets. Recompiled the stored procs which
fixed the issue.
But the queries are running slower now. The overall performance of the app
has become sluggish.
The CPU is generally running higher as well!
Have also set LD_LIBRARY_PATH_64 to include the new Solaris 8 threads
library.
Anybody any insights into this? How can we get back to the pre-upgrade
performance levels short of rolling back the EBF.
Regards
Perry
Perry,
I guess 12.0.0.6 requires some Solaris ...
Upgrade from ASE 12.5.0.3 to ASE 12.5.1This is a multi-part message in MIME format.
---=_forums-2-dub3ff97039
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Hi,
I've just upgraded from ASE 12.5.0.3 to ASE 12.5.1. I tried
to start the server, but it won't startup.
Here is the message:
sybase(ASE1250)328 /app/sybase/ASE-12_5/install -->
startserver -f RUN_AMXDB
sybase(ASE1250)329 /app/sybase/ASE-12_5/install -->
00:00000:00000:2004/01/05 21:37:44.10 kernel Use license
file /app/sybase/SYSAM-1_0/licenses/license.dat.
00:00000:00000:2004/01/05 21:37:44.10 ker...
A Possible fix for Suse 8.0 and ASE 12.5.0.2 (upgrade from 12.5.0.1)Hi All, I had a similar problem to what a lot of you were experiencing...
with regards to glibc issues with ASE and Suse 8.0, and the server not
starting.
After a lot of reading up, and running stack traces, and various other
things to try and get my ASE 12.5.0.1 esd#2 upgraded to 12.5.0.2 esd#1 (and
of course ready for when 12.5.0.3 comes out),
I came to the conclusion that the 2.2.5-55 and 2.2.5-158 were both not
suitable for running 12.5.0.2 (my 12.5.0.1 worked well tho).
I found the following article from SuSe...
ftp://ftp.is.co.za/linux/distributions/suse/8.0/unsorted...
Upgrading from ASE (32-bit) 12.0.0.7 on Solaris 2.8 64-bit to ASE(64-bit) 12.5.1 on Solaris 64-bitHello all,
We are planning to upgrade our ASE servers from a 32-bit ASE 12.0.0.7 to
64-bit ASE 12.5.1 on Solaris 8. Could you please give what are the steps to
be taken care and how do I start with ( Do I have to first upgrade to
32-bit12.5.1 and then upgrade to 64-bit ASE 12.5.1, or directly upgrade from
32-bit 12.0.0.7 to 64-bit 12.5.1 ?).
Could you also please point to some documentation (about upgrading 32-bit
12.0.0.7 to 64-bit 12.5.1).
Thanks
RK
...
Upgrading from ASE 12.0 to ASE 12.5.2Hi everyone,
I am basically thinking of upgrading ASE 12.0.x to ASE 12.5.2.
How would the migration process be. Is it straight dump and load or
otherwise ??
regards
Paresh.
Paresh wrote:
> Hi everyone,
>
> I am basically thinking of upgrading ASE 12.0.x to ASE 12.5.2.
>
> How would the migration process be. Is it straight dump and load or
> otherwise ??
>
> regards
>
> Paresh.
>
>
see the upgrade/installation guide
joop
--
Senior Consultant Sybase Professional Services
New address per 21 November 2005:
Zo...
ASE 12.5.0.3 to ASE 12.5.4 upgrade pathI would like to know if the migration from ASE 12.5.0.3 to
12.5.4 a direct migration or is there an intermediate
upgrade to be performed in between?
Take a look at the release bulletins and installation guides for your
platform. These are the first steps to any upgrade.
http://sybooks.sybase.com/nav/detail.do?docset=1287
<passerby> wrote in message news:484e9ca8.3f0d.1681692777@sybase.com...
>I would like to know if the migration from ASE 12.5.0.3 to
> 12.5.4 a direct migration or is there an intermediate
> upgrade to be performed in between?
...
Can't construct query plan in ASE 12.0Error 325 is being returned when trying to execute a stored procedure on
version :
Adaptive Server Enterprise/12.0/P/SWR 8773 ESD 1/RS6000/AIX
4.3.2/1580/64bit/FBO/Tue Dec 7 03:29:32 1999 ...
this is the code causing the error when running on version listed above...
it's a sub-query within a stored proc
AND SBSB.HIST_ROW_ID = (select
MAX(SBSB2.HIST_ROW_ID)
FROM
Massive_db.audit.CMC_SBSB_SUBSC SBSB2
WHERE
SBSB2.SBSB_CK = SBSB.SBSB_CK
AND CONVERT(CHAR(10),SBEL.SBEL_INSQ_DT,101) = CONVERT(CHAR
10),SBSB2.HIST_CREATE_DTM,101))
When executing same stored procedure on AS...
Performance Degradation after ASE 12.0 upgrade to ASE 12.5Hello,
There was a issue posted on 08/06/2002 by 'Bob' related to performance
degradation after upgrade of ASE 11.9.2 to ASE 12.5. I would like to know
whether anyone has found any solution/workaround
to resolve those issues without making any changes in the application code.
We are also facing the same problems here after upgrade of ASE 12.0 to ASE
12.5. The program which takes 10 mins. on ASE 12.0 is taking more than 3
hrs to finish on ASE 12.5 despite of using the same indexes and the program
which takes 3 hrs on ASE 12.0 is taking more than 24 hours on ASE 12.5. ...
Migration from ASE-64 bits 12.5.0.2 to ASE 64 bits 12.5.3 for AIX 5.3Here there someone to indicate me the road tasks in order to
migrate an ASE 12.5.0.2 to ASE 12.5.3 on unix 5.3 ? (64
bits)
Thank you
kamel wrote:
> Here there someone to indicate me the road tasks in order to
> migrate an ASE 12.5.0.2 to ASE 12.5.3 on unix 5.3 ? (64
> bits)
>
> Thank you
Apply 12.5.2 IR then 12.5.3 esd 5.
--
Jason L. Froebe
http://jfroebe.livejournal.com
http://www.propsmart.com
Team Sybase
On Tue, 31 Jan 2006 07:18:22 -0800, kamel wrote:
> Here there someone to indicate me the road tasks in order to migrate an
> ASE 12.5.0.2 ...
Migrating from ASE 12.0 32-bit to ASE 12.0 64-bitHas anyone run into any problems migrating from 32-bit to 64-bit?
...
Migrating from ASE 12.0 32-bit to ASE 12.0 64-bitHas anyone run into any problems migrating from 32-bit to 64-bit?
...
Migration from ASE 12.0 ( HPUX ) to ASE 12.5 ( Solaris 8 )Hi,
I'd like to migrate an ASE 12.0.0.3 (roman8) on HPUX 11 with many DBs
to an ASE 12.5.0.3 (*roman8*) on Solaris 8. I know it's not the default charset on solaris.
I've made dump on HPUX, copy it on Sun box and load it. I know it's not supported by Sybase ( cross plateform dump ).
However, it seems to be OK, the upgrade works well, the dbcc (check table, alloc) did not reveal error. I think it's not
supported only because the charset deffers ( by default ) on the plateform.
What do you think of this ? is there others checks to do ?
What kind of corruption or...
SQLRemote Problem with 7.0.2-1 and 6.0.2-1 on Linux [ASE 11.9.2-3 and ASE 12.5 eval]Hi all
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 -
glibc-2.2.4
sybase-ase-12.5-3.i386.rpm
sybase-common-12.5-3.i386.rpm
sybase-openclient-12.5-3.i386.rpm
sybase-sqlremote-7.0.2-1.i386.rpm
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
/etc/ld.so.conf.
There'...
ASE 12.5.2 to ASE 12.5.0.3Hello,
I have to return to ASE 12.5.0.3 from ASE 12.5.2.
I created a new server and did a dump/load of a user database and
that seems to be fine.
Is this a safe way to downgrade ?
Is it necessary to create a new server (master database) or should it
also be possible to shutdown the 12.5.2 server and start it again with
the 12.5.0.3 binary ?
Thanks,
Luc.
...