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 ...
ASE 12.0.0.6 to ASE 12.5 and Rep Server 12.1We are planning the upgrade of our ASE 12.0.0.6 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.
Thanks,
Troy
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.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...
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?
...
ASE 12.5 32bit to ASE 15.0 64bit upgradeWhat are the steps to upgrade from 12.5 32bit to 15.0 64bit
on AIX 5.3? The 15.0.1 Installation Guide describes the
normal 15.0 upgrade process but then has a terse section
towards the end, "Migrating from 32-bit to 64-bit version",
that describes other steps. Are these steps in addition to
the normal upgrade process (sqlupgrade) or are they in place
of sqlupgrade? Do I really have to drop and re-create all
compiled objects (step 12 under Method #3: Replacing the
binary)?
Keith Wonderly wrote:
>
> What are the steps to upgrade from 12.5 32bit to 15.0 64bit
>...
Upgrade ASE 12.0.0.4 to 12.0.0.8I upgraded my ASE to version 12.0.0.8. 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
12.0.0.4 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
to check.
Any help how this can be avoided by a change on the host/server is
appreciated.
Bernd
I always recommend dropping/recreating all of the stored...
dump with compress issue in ASE 12.0.0.7greetings,
we are trying to use the compress option of dump to compress
our tape backups, but have run into an issue. when we run
the following command:
dump database query_db to 'compress::1::/dev/rmt/4mn'
with capacity=70000000,
init
we get the following error in the backup server log:
"Option CAPACITY is not valid for device
'compression::1::/dev/rmt/4mn::00'"
but this command works fine:
dump database archive_db to 'compress::1::/dev/rmt/4mn'
with init
i found this issue in a solved case that seems to be
related:
"Problem Descri...
ASE 12.0 and ASE 12.5 optional featuresDear all,
Can anyone knows what are the optional features of ASE 12.0 and ASE 12.5??
Thanks
~Riverwind
ASE 12.0 :
* DTM (distribute transaction management)
* HA (High availability)
* JAVA (Java support in the database)
* Security services.
ASE 12.5
* EJB support in the database.
* XFS (extended file system support)
* Directory services
* Extended full text search
* Java option now includes xml support in ASE.
HTH
-girish
Thanks...
~Riverwind
<girish@sybase.com> wrote in message
news:43D8F27AA65DE95800085C1785256C0C.00123C3785256C0A@webforums...
...
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...
Dump/Load (from ASE 12.5.4 to ASE 15.x) - VS.Hi All,
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?
Potential options:
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 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
...
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.
...
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. ...