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-bit
Hello 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 ...

Migration from ASE 12.0 32 bit to ASE 12.x 64 bit
Pundits one and all, We are looking closely at migrating from ASE 12.0.0.4 ESD#2 32 bit on a Solaris platform to 64 bit ASE. Notwithstanding improvements in ASE 12.5 that may benefit us, the main driver is to take maximum advantage of the 16G physical memory on the host. Simplistically we could either ... a) convert to 64 bit ASE 12.0 (as phase 1), then convert to ASE 12.5 64 bit (as phase 2) at a later date, or b) convert to 32 bit ASE 12.5 (as phase 1), then convert at 64 bit after gaining confidence in the version change, c) convert to 64 bit ASE 12.5 in one fell swoop to m...

Migration from ASE-64 bits 12.5.0.2 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 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 ...

Differences between 12.5 64-bit and 12.0.0.7 32-bit ASE
Is there any documentation about the differences between 12.5 64-bit and 12.0.0.7 32-bit ASE version that will affect DEVELOPMENT group ( not the administation stuff, but mostly on T-SQL, RESERVED words, or some new procedures,...) Thanks RK Sure, for the differences between versions, see the "What's New" document at (for 12.5.1) http://sybooks.sybase.com/onlinebooks/group-as/asg1251e The difference between 32-bit and 64-bit comes down to how much shared memory you can access. 32-bit is generally limited to 2gb-4gb of memory (depending on platform), while 6...

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? Thanks! ...

Advantages of 64-bit ASE 12.5 over 32-bit ASE 12.5
What are the advantages of 64-bit Server over 32-bit server ? We are thinking of upgrading our servers from 32-bit ASE 12.0.0.7 to ASE 12.5, But we are stuck while taking a decision about 32-bit or 64-bit. Management wants to know why do we have to go 64-bit while the 32-bit works fine. Thanks RK This document is an FAQ on ASE 64-bit and may be of help: http://www/detail/1,6904,1012280,00.html The only real advantage is the ability to assign a larger amount of memory to ASE, thereby allowing for larger data caches and reduced physical io. HTH, Dave <rk> wrote ...

ASE 12.0.0.0 / SWR 8775 UPGRADE TO ASE 12.0.0.6/EBF 10628 PERFORMANCE PROBLEM
Hi 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 ...

Can I use ASE 12.5.2 64-bit license on an ASE 12.5.2 32-bit install
I want to install sybase ASE 12.5.2 on my machine (2GB of memory) but my license certificate has a 64 bit license only. Can I use the 64-bit license on my 32 bit ASE 12.5.2 installation? thanks Gemma No you cannot > I want to install sybase ASE 12.5.2 on my machine (2GB of > memory) but my license certificate has a 64 bit license > only. > > Can I use the 64-bit license on my 32 bit ASE 12.5.2 > installation? > > thanks > Gemma ...

Migration from ASE 12.5.3 (Win 32bit) to ASE 15.0.2 (Unix 64 bit) question
Hi, I would like to migrate an ASE 12.5.3 on a Microsoft 32-bit server to an ASE 15.0.2 on Linux (or Solaris) 64-bit server. What steps must I follow? Is it a good idea to use a Replication Server 15 as intermediate task (consultant advice)? Thanks, Lorenzo My current ASE has a total size of 350Gb , 2400 connections, 2.6 Gb of memory... With ASE 12.5.3 you're suppose to be able to perform cross platform dump-n-loads (XPDL), where 'cross platform' basically means different OS's and/or different endian hardware. This (obviously?) assumes you'll be using ...

ASE 12.0.0.6 to ASE 12.5 and Rep Server 12.1
We 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...

Migration ASE 15.0 from 32 bit to 64 bit
Hi, I need to migrate ASE 15.0 from 32 bit (on Solaris 10 SPARC) to 64 bit (on Solaris 10 x86 (64 bit)). Are there any problems? (dump, tempdb, stpred procedure, ect...) Thanks Mario Mario Ascione wrote: > > I need to migrate ASE 15.0 from 32 bit (on Solaris 10 SPARC) to 64 bit > (on Solaris 10 x86 (64 bit)). > Are there any problems? (dump, tempdb, stpred procedure, ect...) Are you planning to do cross-platform dumps and loads? -am � MMVIII Yes, I'm planning the migration task making a dump on SPARC and to load it to x86 machine (in order to p...

Migrating ASE 15.0 from 32 bit to 64 bit
Hi, I need to migrate ASE 15.0 from 32 bit (on Solaris 10 SPARC) to 64 bit (on Solaris 10 x86 (64 bit)). Are there any problems? (dump, tempdb, stpred procedure, ect...) Thansk Mario this is a "futures" newsgroup. You might have better luck asking this question on sybase.public.ase.upgrades+migration "Mario Ascione" <ascione.mario@gmail.com> wrote in message news:4805f9d0$1@forums-1-dub... > Hi, > I need to migrate ASE 15.0 from 32 bit (on Solaris 10 SPARC) to 64 bit > (on > Solaris 10 x86 (64 bit)). > Are there any problems...

Can't construct query plan in ASE 12.0
Error 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...