Sybase ASE Upgradation from 12.5.X to 15.X - Dump Load

• Install ASE 15 instance on the same box at the different partition/directory exactly Same as ASE 12.5.X instance (this includes devices, databases, logins, loginroles etc). (NOTE: System db's Size will differ)
•  Install backup server for ASE 15.0
•  ASE 15.0 RUN_server/Backupserver file and ASE 12.5.X RUN_server/Backupserver file should have same share memory, Trace Flags, other backup server parameters like -P, -N, -m etc. Please confirm. 
• Copy 12.5.X cfg file to ASE 15.0 cfg file
• Recycle server 15
• Run sp_countmetadata "number of open partitions" and set whatever value it provides with sp_configure.
• BCP out master..syslogins, master..sysloginroles from ASE 12.5.X and BCP in ASE 15.0 master.
• Block all the users on Current Production server
• In 12.5 server, For "default data cache" set large 16k pool with APF=90%  and Set 2k pool also bigger around 150% of current size with APF=50% for running dbcc checkstorage. (can be done from sp_poolconfig)
• BCP out all important master..system tables (sysdevices,sysdatabase,syslogins,sysloginroles,sysusages,sysconfigures
• Run DBCC Checkstorage on all User databases on 12.5.x server
• Unpartition all the partition tables (if any).
• Put Database in "dbo use" mode (sp_dboption DBNAME, "dbu use", true).
• Run sp_flushstats (stats are flushed to disk from cache)
• - Wait for 10 to 30 seconds, depending on the database size and activity.
• run checkpoint against the database to flush updated pages.
• Dump 12.5.X all databases (user databases)
• Load user Database (on traget i.e. ASE 15 db) 
• Online database.
• Run sp_checkreswords (in each user database without any parameters) for all user databases. If there are any reservewords fix it.
• Run sp_checksource (in each user database without any parameters) to verify we have all source text for compiled objects. Then you can run dbcc upgrade_object (in each user database without any parameters) for to find potential problems and upgrade objects manually.
• Partition all those unpartition tables from ASE 12.5.X
• Increase default datacache 3 folds and procedure cache 4-6 folds.
• Increase default value of “number of lava Operators”
• Increase default value of “stack size”
• Increase number of histogram steps and histogram tuning factor.
• Run update stats on new databases.

Ardent DBA