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

AWS Big Data Specialist. Oracle Certified Professional (OCP) for EBS R12, Oracle 10g and 11g. Co-author of "Expert Oracle Enterprise Manager 12c" book published by Apress. Awarded as Oracle ACE (in 2011) and Oracle ACE Director (in 2016) for the continuous contributions to the Oracle users community. Founding member, and vice president of Turkish Oracle User Group (TROUG). Presented at various international conferences including Oracle Open World.

Leave Comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.