Performance issues after upgrate ASE 11.5 to ASE 12.5
How can we improve performance?
We're moving a database that was operating fairly well on a HP-UX 10.20 with
Adaptive Server Enterprise v. 11.5 (32 bits) to a HP-UX 11.0 with Adaptive
Server Enterprise v. 12.5 (32 bits)
Our problem is the slower performance of the database on the new, more
powerful and faster machine with newer software (in both operative system
and sybase version)
We've noted that it starts really fast but slows down gradually.
We�ve tried many ways to improve the performance:
-Increase the max memory.
-Increase the number of engines at startup...ASE 12.5 vs ASE 11.5 performance issues
Again my question is about performance of ASE 12.5 against 11.5.01
We have a huge production client-server application running on W2K server
with ASE 220.127.116.11 database (more than 400 tables, 2000 stored procedures).
The database was placed on raw disk partitions (no RAID) and split between
different physical drives as follows: data, log, tempdb and master database
are located on different drives.
We have two PIII, 1GHz, 1 GB of memory and give 800MB for ASE. We create
separate tempdb cache and bind tempdb to it. Database was bind to default
Then we want to switc...Dump/Load (from ASE 12.5.4 to ASE 15.x) - VS.
We are in the process of planning the upgrade of our ASE
12.5.4 dataservers to ASE 15.x. What is the most
recommended way to upgrade ASE dataservers from ASE 12.5.4
to ASE 15.x?
1) Install new instances of ASE 15.x and load database
dumps from our ASE 12.5.4 dataservers to the newly installed
ASE 15.x dataservers.
- OR -
2) Use the ASE upgrade utility (sqlupgrade) to upgrade our
existing ASE 12.5.4 dataservers to ASE 15.x.
What are the Pros vs. Cons for loading a 12.5.4 database
into a 15.x ASE dataserver versus performing an ASE
dataserv...Upgrading ASE 11.9.2 to ASE 12.5 on Solaris 5.6
Does anyone have problems upgrading ASE 11.9.2 to ASE 12.0 on
Solaris 5.6. I know that are issues with upgrading on Solaris
2.5, but what about Solaris 5.6?
...Migration from ASE 11.5 to ASE 12.5
I am planning the migration from Sybase 11.5 to 12.5. Can someone point
me to some documentation on the subject?
I am particularly interested in documents that explain the best way to
migrate database objects (tables, indexes, etc...) and data.
Thanks in advance.
Canoas - RS - Brasil
> I am planning the migration from Sybase 11.5 to 12.5. Can someone point
> me to some documentation on the subject?
> I am particularly interested in documents that explain the b...Migration from ASE-64 bits 18.104.22.168 to ASE 64 bits 12.5.3 for AIX 5.3
Here there someone to indicate me the road tasks in order to
migrate an ASE 22.214.171.124 to ASE 12.5.3 on unix 5.3 ? (64
> Here there someone to indicate me the road tasks in order to
> migrate an ASE 126.96.36.199 to ASE 12.5.3 on unix 5.3 ? (64
> Thank you
Apply 12.5.2 IR then 12.5.3 esd 5.
Jason L. Froebe
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 188.8.131.52 ...ASE 11.9.2 to ASE 184.108.40.206, inplace upgrade issues
We have migrated one of the Sun boxes running ASE 11.9.2 on
Solaris 2.8 to ASE 220.127.116.11 ESD#3 .
We did a inplace upgrade. The "sqlupgrade" utility did all
pre-checks and came out clean and did the migration and it
came out with a "Done" message.But it gave a message saying
the server couldnt be brought up, and seeing the error log
we have seen the shared memory was a problem and we chaged
value and the server came up fine when we brought it up
manually using the 18.104.22.168 binaries.
Few issues which are stopping us to proceed further..
T...Upgrade from ASE 11.9.2 to ASE 12.5
we are on solaris 8 and would like to upgrade from 11.9 to 12.5.
our dba is left and i need to do this. i very novice in dba skill.
can someone give me exact stepps how to do this? i read other post but dont
under stand where to start. also what is meaning of inplace upgrade?thanks
> we are on solaris 8 and would like to upgrade from 11.9 to 12.5.
> our dba is left and i need to do this. i very novice in dba skill.
> can someone give me exact stepps how to do this? i read other post but dont
> under stand where to start. also what is meaning of i...Migrate ASE 11.5 to ASE 12.5 causes pc-client problem!!
I migrated ASE 11.5/P/Sun_svr4/OS 5.5.1 to ASE 12.5/SWR 9609
GA/P/Sun_svr4/OS 5.8 on Sun box. I face problem on win 98 client
application, written by VB 4, when it use recordset (DAO 3.0) to update
table in ASE 12.5. The problem occure when use ODBC sybase system 10. Error
in application is
[INTERSOLV][ODBC SQL Server driver][SQL Server]Variable is not allowed in
If I use passthru mode to run the same SQL on ASE 12.5, it is not such an
error. Then I try to install 12.5 pc client on that machine but I can not do
that because when during the installation proc...ASE Migration From ASE 11.5.1 (NT) to ASE 12.9 on Win2003.
Need help to find Sybase's upgrade and migration docs on
ASE 12.9? Currently, no released versions of ASE are certified on Win 2003.
ASE 12.5.1 will be certified when it is released later this year.
<Lily Maria> wrote in message news:firstname.lastname@example.org...
> Need help to find Sybase's upgrade and migration docs on
> above subject?
> Thank you.
Thanks for the info.
I would like to know if there's any online documentation on
migration and upgrade plan of the ASE 11.5.1 to ASE 12.5.1?
Do applica...ASE 12.5.2 to ASE 22.214.171.124
I have to return to ASE 126.96.36.199 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 188.8.131.52 binary ?
...Migration from ASE 11.5 NCR to ASE 11.5 SUN
I have a question about the migration from ASE 11.5 on NCR to ASE 11.5 on
SUN Solaris 2.6.
My question is, how can I do the data migration without the use of bcps and
DBArtisan? Exists another tool that leave me migrate the data more easy?
> Hi everybody.
> I have a question about the migration from ASE 11.5 on NCR to ASE 11.5 on
> SUN Solaris 2.6.
> My question is, how can I do the data migration without the use of bcps and
> DBArtisan? Exists another tool that leave me migrate the data ...Upgrade ASE 12.0/64 bit on AIX 4.3.3 to ASE 12.5.x/64 bit on AIX 5.2
Trying to find what is the supported upgrade path for the above. Going from
12.0/64bit on AIX 4.3.3 to 12.5 (or 12.5.x) 64bit on AIX 5.2.
If I put AIX 5.2 , the dataserver binary of 12.0 will not work which is used
during the upgrade.
If I put 12.5.x on 4.3.3, the dataserver binary will not work beacuse it is
new binary for 5.2.
Other than backup the databases and load them to the new server, is there a
supported how to upgrade?
...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: