How to Upgrade Sybase IQ 16 to 16.0.10 (SP10)

Sybase-IQ-Box-300x314Yesterday, I did my first Sybase IQ upgrade. I upgraded our main datawarehouse from Sybase IQ 16 to 16 SP10. The process was easy: Stop the database instance, install the new software, start the instance (from new software home), run an SQL to upgrade the metadata. Although the process was easy, I had some unexpected problems so I wanted to my notes in case you may need to upgrade your Sybase IQ.

You have probably heard it a thousand times but here I’ll say it again: Read the manual! Then open a ticket (or call) to Sybase support and ask questions about upgrading process. The process is very easy but it’s not documented well. Maybe I feel like this because I’m used to read Oracle’s word-class manuals. I’m serious. Oracle provides best manuals compared to the other Database vendors.

Second mandatory warning: Before you start to upgrade operation, make sure you have a valid backup of database.

Make sure that your license file is compatible with the software version you’ll install. You may need to generate an uptodate SySAM License! You can also contact Sybase suport and ask them to send you a compatible license file.

Sybase support send me a file named IQSERV160010P_2-20011180.zip. I have unzipped it and see that setup.bin (the installer) is not marked as executable. I made it executable and run it. That doesn’t sound like a big deal but later I figured out that while installing, the setup utility tries to execute other setup.bin files (located in subfolders), and none of them are marked as executable 🙂 You may use such a one-line to mark them executable:

After updating software, check the version by running “start_iq -v2”. It will not start the instance, it will just show the software version. If you see the correct version (a higher version number than your previous one), start your instance, connect it using your favorite Sybase client, and run the following command:

It will take only for a few seconds to modify metadata and your database is ready to go!

After upgrading software, somehow “Interactive SQL (dbisql)” tool started to not to work:

To fix this problem, I re-registered IQ plugins to dbisql:

Please share
  •  
  •  
  •  
  •  
  •  
  •  
  •  

Gokhan Atil is a database administrator who has hands-on experience with both RDBMS and noSQL databases, and strong background on software development. He is certified as Oracle Certified Professional (OCP) and is awarded as Oracle ACE (in 2011) and Oracle ACE Director (in 2016) for his continuous contributions to the Oracle users community.

Leave Comment

Your email address will not be published. Required fields are marked *