ASE 11.0.3.3 to ASE 12 #2

We're planning to upgrade our existing environment from ASE 11.0.3.3 to ASE 
12. Are there any problems we should be aware of?
0
Anatoly_Reznik
5/31/2001 4:33:08 PM
sybase.ase.upgrades+migration 687 articles. 0 followers. Follow

2 Replies
611 Views

Similar Articles

[PageSpeed] 6

Anatoly,

Check for datatype mismatches - int -> smallint, datetime->smalldatetime, etc..
(the P&T Guide has a section on this).

Also make sure to run update statistics on all your user tables.

Hope this helps,

Eric Miner
Sr. Engineer
DST Engineering
Optimizer Group


Anatoly_Reznik wrote:

> We're planning to upgrade our existing environment from ASE 11.0.3.3 to ASE
> 12. Are there any problems we should be aware of?

0
Eric
6/4/2001 8:12:14 PM
1. string functions could have different results on handling trailing spaces
2. in some cases of outer joins could have different results
3. data skew might cause hiccup on new optimizer
4. old bcp format files might need -Q option
5. data type mismatch is major one for upgrades
6. it is good idea, upgrade hardware to a much powerful machine/more memory
7. do a pure upgrade in 1st phase, then add new feature later such as
row-level locking/parallel query

Rey Wang

<Anatoly_Reznik> wrote in message
news:C66BDA4D3B58EB42005AEC8985256A5D.005AEC9785256A5D@webforums...
> We're planning to upgrade our existing environment from ASE 11.0.3.3 to
ASE
> 12. Are there any problems we should be aware of?


0
Rey
6/5/2001 2:14:58 AM
Reply:

Similar Artilces:

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

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

Upgrading ASE 11.9.2 to ASE 12.5 on Aix 4.3.3
After migration from ASE 11.9.2 to ASE 12.5, the following error appears when I try to execute a strore procedure : Size of row in the worktable for grouped aggregate, 16542 bytes, exceeds the maximum row size (1962 bytes). Cannot run this query (return status = -6). Is it a bug on ASE 12.5? Why could I run correctly this procedure on the old version? Fabien DUBOIS Fabien DUBOIS wrote: > > After migration from ASE 11.9.2 to ASE 12.5, the following error appears > when I try to execute a strore procedure : > > Size of row in the worktable for grouped aggr...

ASE 11.0.3.3 to ASE 12
We're planning to upgrade our existing environment from ASE 11.0.3.3 to ASE 12. Are there any problems we should be aware of? ...

ASE 11.0.3.3 and ASE 11.9.2 on same box
Hi evereyone, I would like to install 2 ASE servers with different versions on same linux box. Is this possible? Here is what I tried to do: I have a working ASE 11.9.2 on linux box tried to install ASE 11.0.3.3 on same box in different directory and it gave me an error. Wondering if this ispossible at all. Appreciate any help. TIA ar The 11.0.3.3 rpm tries to uninstall the 11.9.2 package. I shutdown the 11.9.2 server before install 11.0.3.3 and I do not keep the both versions running. The variables SYBASE, LD_LIBRARY_PATH ,PATH must be correctly set to point the...

ASE 11.9.2 to ASE 12.5.0.3, inplace upgrade issues
Hi We have migrated one of the Sun boxes running ASE 11.9.2 on Solaris 2.8 to ASE 12.5.0.3 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 that the server couldnt be brought up, and seeing the error log we have seen the shared memory was a problem and we chaged the value and the server came up fine when we brought it up manually using the 12.5.0.3 binaries. Few issues which are stopping us to proceed further.. Issue 1) T...

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'...

Can we restore a database on ASE 11.0.3 which was on ASE 11.0.2 ?
Hi, I did a backup of a database which was on ASE 11.0.2. Can we restore it without any problems on ASE 11.0.3 ? Thanks very much. -- Have a nice day. Raphael Lignier Escalation Support Engineer ASCEND COMMUNICATIONS GIS - Sophia-Antipolis On Wed, 31 Mar 1999 15:02:30 -0800, Raphael Lignier <rlignier@ascend.com> wrote: >Hi, > >I did a backup of a database which was on ASE 11.0.2. > >Can we restore it without any problems on ASE 11.0.3 ? Yes, dumps are upward compatible (that is: you can load older dumps on newer servers). When conversion...

Upgrade 11.0.3.3 to ASE 11.9.2 with RepServer 11.5 and LTMs
I am preparing to upgrade our production servers (11.0.3.3) using RepServer 11.5 with LTMs. My understanding is that the ASE 11.9.2 has RepAgents build in as Open Server applications. Are there any issues with upgrading that I need to be aware of? Where would I look? I would assume that I don't need to run LTMs anymore, but I need to ensure no loss of replication to the warm standby. Any advice? Take care. JCS ASE 11.5+ has RepAgent built in as internal server threads (which has nothing to do with OpenServer). When upgrading, keep the LTM's and upgrade to RS 11.5 / ...

upgrade ASE from 11.0.3.3 to 11.9.2 on AIX
Hi, We are planning to upgrade our SQL Server 11.0.3.3 servers to ASE 11.9.2. We have 6 production servers on one UNIX box and (almost) corresponding test servers on another UNIX box. We have little new development, so we should have enough time to test things out first on the TEST platform. I am trying to decide between upgrading the servers in place or doing new installs and migrating the data over to the new servers. The upgrades in place would be a lot easier on me and the UNIX support people, but I am not sure how much more difficult fallback would be. If we needed to fall...

ASE 12.5.0.3 slow compared to ASE 11.9.2.
Hi, I am new to the list and apologise in advance if the question is incomplete or in the wrong newsgroup. We use a shopping cart called Intershop which uses sybase ASE 11.9.2 on a W2K server. We have upgraded the shopping cart to epages 4.5, and we now use Windows 2003 server. The ASE version has been upgraded to 12.5.0.3. The hardware has also been upgraded, approx four times as powerful, faster 15K scsi raid, dual xeon 3ghz. 3.5gb ram. The performance of the database seems to be an issue, I have created a test table, and inserted 1000 rows of data. CREATE TABLE Menu_Prod_R...

upgrade from ASE 12.5.3 to ASE 15.0.2 ESD#4
What are the correct steps to upgrade from ASE 12.5.3 to 15.0.2#4? 1. Upgrade ASE 12.5.3 to ASE 15.0, then from ASE 15.0 to ASE 15.0.2#4 or 2. Upgrade ASE 12.5.3 to ASE 15.0.2 ESD#4 Thanks, liyp liy wrote: > What are the correct steps to upgrade from ASE 12.5.3 to 15.0.2#4? > > 1. Upgrade ASE 12.5.3 to ASE 15.0, then from ASE 15.0 to ASE 15.0.2#4 > > or > > 2. Upgrade ASE 12.5.3 to ASE 15.0.2 ESD#4 > I did #2. At one point I considered upgrading to 15.0.2 GA and then to ESD#4, but the $SYBASE/ASE/upgrade/upgrade program looks to b...

Migration : ASE V12 (HP UX 11) to ASE V 12.5.3 (AIX 5.3)
Hi, I have to migrate a DB ASE 12.0.0.8 from HP (HP UX 11) to ASE 12.5.3 (IBM AIX 5.3) here are the characteristics: HP UX ------ The default Unix charset on the platform is Roman8. The ASE/db Charset is UTF8 AIX (5.3) --- The default Unix charset on the platform is Iso The ASE/db Charset will be UTF8 Someone told me Cross-platform DUMP/RELOAD is not possible. note that I didn't try it yet, but i will. Does anyone know about that ? If this is not possible i'll have to use 'bcp' IN/OUT i guess ? but i dont know exactly what syntax i should use w...

Migration : ASE V12 (HP UX 11) to ASE V 12.5.3 (AIX 5.3)
Hi, I have to migrate a DB ASE 12.0.0.8 from HP (HP UX 11) to ASE 12.5.3 (IBM AIX 5.3) here are the characteristics: HP UX ------ The default Unix charset on the platform is Roman8. The ASE/db Charset is UTF8 AIX (5.3) --- The default Unix charset on the platform is Iso The ASE/db Charset will be UTF8 Someone told me Cross-platform DUMP/RELOAD is not possible. note that I didn't try it yet, but i will. Does anyone know about that ? If this is not possible i'll have to use 'bcp' IN/OUT i guess ? but i dont know exactly what syntax i should use w...

Web resources about - ASE 11.0.3.3 to ASE 12 #2 - sybase.ase.upgrades+migration

Asse (river) - Wikipedia, the free encyclopedia
Durance 43°52′28″N 05°52′43″E  /  43.87444°N 5.87861°E  / 43.87444; 5.87861 Coordinates : 43°52′28″N 05°52′43″E  /  43.87444°N 5.87861°E ...

Facebook Runs Survey to Assess User Perceptions of Credits
This week, Facebook conducted a user survey to determine usage and perception of its virtual currency Facebook Credits. Hosted on SurveyMonkey ...

ASE Pocket Guidelines on the App Store on iTunes
Get ASE Pocket Guidelines on the App Store. See screenshots and ratings, and read customer reviews.

CEC14 / Assess, Test or Terminate: What Future for Climate Engineering Research? - YouTube
Climate Engineering Conference 2014 Panel discussion looking forward to the next decade of climate engineering research. Featuring Andy Parker ...

ASE IT moves into iseek’s Sydney data centre
Cloud services provider ASE IT has signed a contract with iseek Communications to move into the vendor’s data centre in Gore Hill, Sydney.

ASSÉ recommends postponing student protests
The executive committee of Quebec student union ASSÉ is recommending student protesters delay their actions until after the summer.

Beef Recall: CFIA To Assess XL Foods Alberta Plant In Detail
... on Sept. 27.The number of illnesses linked to beef products from the plant stands at 11 people from four provinces, with the latest case confirmed ...

Postgame Video: Loctite and Fallon Assess Their Super Bowl Debut
... loveable losers dancing to the joy of super glue, was not only the first Super Bowl ad for Loctite, but for its parent company, Germany-based ...

Now That the Core Matters for Yahoo, Here's the Charts and Numbers to Assess It
... piece about the Q3 debacle : “The honeymoon is over … 15 months after she took over, Ms. Mayer has failed to translate Yahoo’s user increase ...

Hard Drives and Hard Asses
In a thread a couple of days ago, some of y’all were parsing the ever-lovin’ shit out of Glenn Greenwald’s report on NSA surveillance of Muslim-Americans. ...

Resources last updated: 12/10/2015 1:32:15 AM