The time has finally come.

[Former Member]

All
To upgrade from Sybase IQ/15.4.0.3027/130221/P/ESD 3 (or maybe 5) to IQ 16 SP08 PL32.

I've dbcc'd the 15.4 server nightly without any errors.

I've made a parallel copy of the existing binaries (there's a sym link /opt/sybase/IQ_15_ESD3 -> SYBASE) and installed the IQ 16 install over the top of them, updated the host license, just about ready to flip the sym link to temp check the licensing.

Is there a link to the final SAP approved set of pre / post installation tasks I'll need to do later in the week.

It's quite a small server, rebuilding all the indexes won't be an issue, in fact even reloading all the base tables isn't an issue.

[Former Member · Accepted solution]

Okay, maybe not that simple, I'm maybe thinking patching rather than upgrading.

So is the suggested upgrade path a dump load from existing 15.4 to a new 16.0 server, rather than an in place upgrade (drop some index types, shutdown IQ, restart pointing to new binaries, run some post startup stuff) ?

[c_baker · Accepted solution]

There are different paths if you are upgrading an existing 15.x to IQ 16 (migration) vs. a new installation and if you are upgrading a multiplex or simplex, but a migration is not really that different from a full install.

The 'SAP-approved' tasks are fully documented in the manuals at help.sap.com/iq:

http://help.sap.com/saphelp_iq1608_iqmig_lin/helpdata/en/46/0c15735607471d891d1ccbea150ddb/content.h...

Other than always taking a backup before upgrading, the upgrade is done 'in-place', but there are some steps you must take, as documented, before the upgrade.

After the upgrade, even though you will eventually run the 'alter database upgrade' command, the database will remain in 'IQ 15 compatibility mode', until you choose to move forward with the IQ 16 capabilities.  This is also documented in the 'Database Status Post Upgrade' section of the docs.

You will have to adjust memory settings in the .cfg file.  IQ 16 adds some new memory areas (-iqlm, -iqrlv) and once you decide to run fully as IQ 16 (e.g. turn off FP_NBIT_IQ15_COMPATIBILITY and REVERT_TO_V15_OPTIMIZER) you will have to run sp_iqrebuildindex to rebuild FP indexes to take advantage of the nbitFP indexes.

Chris

[Former Member · Accepted solution]

Thanks Chris, I had a little problem with:

Note 1977159:[SAP IQ] IQ16 failed to startup due to Unknown option "host" error. …

But have made progress, the advice above really helps, thanks.

Just need to do some backups and then go for it.

[Former Member]

So I used dbisql this time.

(sa)> alter database upgrade

Database upgrade started

Creating system views

Creation of system views completed

Creating DBO views

Creation of DBO views completed

Creating system procedures

Creation of system procedures completed

Creating system views

Creation of system views completed

Setting option values

Setting option values completed

Creating migration procedures

Creation of migration procedures completed

Creating jConnect procedures

Creation of jConnect procedures completed

Parsing stored statements

Error! The connection to the database was closed by the server.

  Connection was terminated

  SQLCODE=-308, ODBC 3 State="HY000"

  Line 1, column 1

  alter database upgrade

Press ENTER to continue...

And when I try to start up.

I. 07/06 10:42:01. Sybase IQ
I. 07/06 10:42:01. Version 15.4
I. 07/06 10:42:01. (64bit mode)
I. 07/06 10:42:01. Copyright 1992-2013 by Sybase, Inc. All rights reserved
I. 07/06 10:42:01. Copyright (c) 2001-2014, Sybase, Inc.
I. 07/06 10:42:01. Portions copyright (c) 1988-2014, iAnywhere Solutions, Inc. All rights reserved.
I. 07/06 10:42:01. Use of this software is governed by the Sybase License Agreement.
I. 07/06 10:42:01. Refer to http://www.sybase.com/softwarelicenses.
I. 07/06 10:42:01.
I. 07/06 10:42:01. Processors detected: 2 (containing 16 logical processors)
I. 07/06 10:42:01. Maximum number of physical processors the server will use: 2
I. 07/06 10:42:01. Running Linux 2.6.32-279.22.1.el6.x86_64 #1 SMP Sun Jan 13 09:21:40 EST 2013 on X86_64
I. 07/06 10:42:01. Server built for X86_64 processor architecture
I. 07/06 10:42:01. 49152K of memory used for caching
I. 07/06 10:42:01. Minimum cache size: 49152K, maximum cache size: 262144K
I. 07/06 10:42:01. Using a maximum page size of 4096 bytes
E. 07/06 10:42:01. Database cannot be started -- server must be upgraded to start "/opt/sybase/iq_server_test/db/IQ_TEST.db" (capability 82 missing).
I. 07/06 10:42:01. Database server shutdown due to startup error
I. 07/06 10:42:01. Database server stopped at Mon Jul 06 2015 10:42
DBSPAWN ERROR:  -934
Unable to start specified database: Server must be upgraded to start database

Database cannot be started -- server must be upgraded to start "/opt/sybase/iq_server_test/db/IQ_TEST.db" (capability 82 missing).
Server failed to start

Back to "restore database ....................."

[Former Member]

Restored to 15.4 ESD5, dropped all the user procs and views, then upgraded again fine this time.

Setting the new options, rebuilding the FP's, restoring the user objects, then lets test.

[Former Member]

So not so good at the first attempt.

1> alter database upgrade

2> go

Database upgrade started

Creating system views

Creation of system views completed

Creating DBO views

Creation of DBO views completed

Creating system procedures

Creation of system procedures completed

Creating system views

Creation of system views completed

Setting option values

Setting option values completed

Creating migration procedures

Creation of migration procedures completed

Creating jConnect procedures

Creation of jConnect procedures completed

Parsing stored statements

CT-LIBRARY error:

        ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect

Followed by now when I try to start the server.

I. 07/02 13:25:12. Running Linux 2.6.32-279.22.1.el6.x86_64 #1 SMP Sun Jan 13 09:21:40 EST 2013 on X86_64
I. 07/02 13:25:12. Server built for X86_64 processor architecture
I. 07/02 13:25:12. 49152K of memory used for caching
I. 07/02 13:25:12. Minimum cache size: 49152K, maximum cache size: 262144K
I. 07/02 13:25:12. Using a maximum page size of 4096 bytes
I. 07/02 13:25:12. Multiprogramming level: 150
I. 07/02 13:25:12. Automatic tuning of multiprogramming level is disabled

=============================================================
IQ server starting with:
    100 connections         (       -gm )
     26 cmd resources       ( -iqgovern )
    549 threads             (     -iqmt )
    512 Kb thread stack size   (   -iqtss  )
  281088 Kb thread memory size ( -iqmt * -iqtss )
      8 IQ number of cpus  ( -iqnumbercpus )
    200 MB maximum size of IQMSG file ( -iqmsgsz )
     20 copies of IQMSG file archives ( -iqmsgnum )
=============================================================

I. 07/02 13:25:12. Starting database "IQ_TEST" (/opt/sybase/iq_server_test/db/IQ_TEST.db) at Thu Jul 02 2015 13:25
I. 07/02 13:25:12. Database recovery in progress
I. 07/02 13:25:12.     Last checkpoint at Thu Jul 02 2015 13:22
I. 07/02 13:25:12.     Checkpoint log...

**************************************************
***   SAP IQ Abort:
***      From:  stcxtlib/st_server.cxx:1707
***      PID: 13631
***      Message: caught signal 11, program abort
***      Thread: 140728652936960  (TID: 13)
**************************************************

**************************************************
***   SAP IQ Abort:
***      From:  stcxtlib/st_server.cxx:1707
***      PID: 13631
***      Message: caught signal 11, program abort
***      Thread: 140728652936960  (TID: 13)
**************************************************

DBSPAWN ERROR:  -80
Unable to start database server

Server failed to start (Return Code 1)

[c_baker]

Use dbisql to perform 'ALTER DATABASE UPGRADE', not isql.

Chris

[Former Member]

From the manual

• Start Interactive SQL and connect to the database.
• Upgrade the database.  ALTER DATABASE UPGRADE instantiates all binaries and schema changes. To roll back to a previous version, you must restore from backup

I guess the DB is FUBAR now.

[c_baker]

Unfortunately, 'Interactive SQL' is the Start Menu title of dbisql, not isql.  (That probably needs a documentation change).

There may be a parameter to force the .db to recover after a failed 'isql' upgrade attempt.  I have asked engineering.

Chris

[Former Member]

I just found that command.

restore database '/opt/sybase/iq_server_test/db/IQ_TEST.db

Next try later this afternoon.

[Former Member]

Has anyone got a quick script to do this ?

"update DATE columns that contain a time portion."