ASE 18.104.22.168 / SWR 8775 UPGRADE TO ASE 22.214.171.124/EBF 10628 PERFORMANCE PROBLEM
We recently upgraded ASE 126.96.36.199/SWR 8775 to ASE 188.8.131.52/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
Anybody any insights into this? How can we get back to the pre-upgrade
performance levels short of rolling back the EBF.
I guess 184.108.40.206 requires some Solaris ...ASE 220.127.116.11 to ASE 12.5 and Rep Server 12.1
We are planning the upgrade of our ASE 18.104.22.168 64bit on AIX
4.3.3 to ASE 12.5 64bit on AIX 4.3.3. We are also using Rep
Server 12.1 with these two servers. My question is do I
need to upgrade Rep Server as well, or will 12.1 Rep Server
Work with ASE 12.5.
Also, we will be upgrading AIX to 5.1 as well.
Any advice is appreciated.
It will work, however you wont be able to use any of the 12.5 new datatypes,
and the rep_agents will spit out annoying error/warning messages everytime
they are restarted. Our production system has been running that way for
about ye...Can't construct query plan in ASE 12.0
Error 325 is being returned when trying to execute a stored procedure on
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
SBSB2.SBSB_CK = SBSB.SBSB_CK
AND CONVERT(CHAR(10),SBEL.SBEL_INSQ_DT,101) = CONVERT(CHAR
When executing same stored procedure on AS...Migrating from ASE 12.0 32-bit to ASE 12.0 64-bit
Has anyone run into any problems migrating from 32-bit to 64-bit?
...Migrating from ASE 12.0 32-bit to ASE 12.0 64-bit
Has anyone run into any problems migrating from 32-bit to 64-bit?
...any issues to restore dump file of ASE 12.0 (32bit) to a ASE 12.0 (64bit) system ?
Does anyone know whether there is an issue that we restore
the dump file (not master and system db) of ASE 12.0 (32bit)
to a ASE 12.0 (64bit) system ? Assume that both system DBs
are the same.
> Does anyone know whether there is an issue that we restore
> the dump file (not master and system db) of ASE 12.0
> (32bit) to a ASE 12.0 (64bit) system ? Assume that both
> system DBs are the same.
If you have a recent ebf of ASE 12.0 (say 22.214.171.124 or later)
than no problem. Earlier ebfs had a few problems....ASE ODBC Driver 15.x backward compatible with ASE 12.5.x
Can anyone point me to a statement by Sybase that ASE ODBC Driver 15 will
work with ASE 12.5.x databases? I'm under the impression that it is backward
compatible but I will need to install the 15.x cataloging stored procedures
in the 12.5.x servers to allow MS Access / Excel / Query type users to work.
--- Quote of the Minute ---
Dilbert's Words of Wisdom: Tell me what you need, and I'll tell you how to
get along without it.
Scott Kellish, Owner
SoftSystem Solutions, LLC.
18 Ridge Road...Upgrading from ASE 12.0 to ASE 12.5.2
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
> 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 ??
see the upgrade/installation guide
Senior Consultant Sybase Professional Services
New address per 21 November 2005:
Zo...ASE 12.0 and ASE 12.5 optional features
Can anyone knows what are the optional features of ASE 12.0 and ASE 12.5??
ASE 12.0 :
* DTM (distribute transaction management)
* HA (High availability)
* JAVA (Java support in the database)
* Security services.
* EJB support in the database.
* XFS (extended file system support)
* Directory services
* Extended full text search
* Java option now includes xml support in ASE.
<email@example.com> wrote in message
...Cannot start ASE 12.5 in Suse 8.0 after installing 126.96.36.199 ESD1.
I have a customer that was running ASE 188.8.131.52 in SUSE 8.0 with no
he is not able to start the server after installing 184.108.40.206 ESD 1 (EBF
10980). In the
certification page I have seen that the version certified for SUSE 8 is
ESD 1 is required, this is strange because the only version we are able
to make work is
one that is not certified.
We have also tried with the latest 220.127.116.11 patch, that is EBF
10753, and the same
This is the error that appears in the terminal where he tries to start:
0...ASE 12.5 ODBC drivers for NT 4.0/win2K
Where can I get the latest copy of the 12.5 ASE ODBC drivers? The only
thing that I can find are some related EBF's, I need the full driver
install. - Thanks
If you are licensed with Sybase ASE or Software Developer Kit then you
the CDRom for the PC CLient that contains the ODBC driver installation.
The 12.5 ODBC driver is not available for download.
> Where can I get the latest copy of the 12.5 ASE ODBC drivers? The only
> thing that I can find are some related EBF's, I need the full driver
> install. - Thanks
You...Upgrade ASE 18.104.22.168 to 22.214.171.124
I upgraded my ASE to version 126.96.36.199. Now one of the application get
a permanent error: "Not enough procedure cache". I increased the proc
cache to 40% (total memory: 1 GB) - no success. When I rolled back to
188.8.131.52 everything works fine (with less procedure cache).
The ASE is running on Solaris 7. The application connects thru the
Merant ODBC driver. I gave the application already back to development
Any help how this can be avoided by a change on the host/server is
I always recommend dropping/recreating all of the stored...ASE 12.5.2 to ASE 184.108.40.206
I have to return to ASE 220.127.116.11 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 18.104.22.168 binary ?
...Performance Degradation after ASE 12.0 upgrade to ASE 12.5
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. ...