Sybase IQ 16 SP08 UPGRADE

 

 

 

 

Sybase IQ 16 SP08 UPGRADE

（版本号  V1.1）

 

 

 

 

 

 

 

   

 

 

 

   

 

北京宝利信通科技有限公司

付志强

目  录

1                UPGRADE 简介... 1

2                卸载Sybase IQ 16. 1

3                安装Sybase IQ 16 SPO8PL27. 2

1   UPGRADE简介

SAP于2015年3月2日发布了全新的完整安装升级包Sybase IQ 16 SPO8 PL27.Sybase IQ 16 标准安装包（16.0.0.429）可以一步到位升级到最新的Sybase IQ 16 SPO8 PL27.因此，此次升级执行下述步骤：

l  卸载Sybase IQ 16 标准安装包（16.0.0.429）

l  安装Sybase IQ 16 SPO8 PL27安装包

l  执行ALTER DATABASE UPGRADE

 

2   卸载SybaseIQ 16

 

l  备份数据库

完整备份IQ数据库：BACKUP DATABASE TO '/sybiq_backup/sgmsiq.bak'

(DBA)> BACKUP DATABASE TO '/sybiq_backup/sgmsiq.bak'

Snapshot created.

100% (3900904 of 3900904 pages) completeafter 00:02:17

Execution time: 137.587 seconds

 

l  停止IQ服务

Multiplex模式的环境，需先停止所有辅助节点的IQ服务、SCC服务。在IQ账号下执行stop_iq命令停止IQ服务

[sybiq@jcsjdw1 ~]$ stop_iq

Checking system ...

The following 1 server(s) are owned by'sybiq'

## Owner          PID  Started  CPU Time  Additional Information

-- --------- -------  --------  -------- ------------------------------------

1: sybiq         2853     Feb26 19:04:47  SVR:sgmsiq_zh DB:sgmsiqPORT:2640

             /sybiq/IQ-16_0/bin64/iqsrv16 @/sybiq/data/sgmsiq.cfg/sybiq/data/sgmsiq.db -o /sybiq/IQ-16_0/logfiles/sgmsiq_zh.0030.srvlog -hn 5

--

    Pleasenote that 'stop_iq' will shut down a server completely

    withoutregard for users, connections, or load process status.

    Formore control, use the 'dbstop' utility, which has options

    thatcontrol stopping servers based on active connections.

Do you want to stop the server displayedabove <Y/N>? Y

Shutting down server (2853) ...

Checkpointing server (2853)....................................

Server shutdown.

执行scc.sh–stop 命令停止SCC服务

[sybiq@jcsjdw1 ~]$ /sybiq/SCC-3_2/bin/scc.sh-stop

 

l  备份安装目录及数据库文件

备份Sybase IQ 16标准安装包的安装目录及*.db文件所在的目录。切忌移动*.db文件所在目录。

[sybiq@jcsjdw1 ~]$ cp -R /sybiq/sybiq_backup/

 

l  卸载IQ

执行uninstall命令卸载IQ。

[sybiq@jcsjdw1 ~]$ cd /sybiq/sybuninstall/IQSuite/

[sybiq@jcsjdw1 IQSuite]$ ./uninstall

 

3   安装SybaseIQ 16 SPO8 PL27

 

l  通过FTP工具上传SybaseIQ 16 SPO8 PL27安装包,修改解压后的安装包属性

 

[root@jcsjdw1 ~]# chown -R sybiq:sybase/home/sybiq/IQ16SP08PL27_Linux

[root@jcsjdw1 ~]# chown -R sybiq:sybase/home/sybiq/IQ16SP08PL27_Linux

 

l  安装Sybase IQ 16 SPO8 PL27

 

[sybiq@jcsjdw1 ~]$ cd IQ16SP08PL27_Linux/ebf23760/

[sybiq@jcsjdw1 ebf23760]$ ./setup.bin

Preparing to install...

Extracting the JRE from the installerarchive...

Unpacking the JRE...

Extracting the installation resources fromthe installer archive...

Configuring the installer for this system'senvironment...

 

Launching installer...

 

    说明：安装过程中涉及的图片是Sybase IQ 16 SPO8 PL20安装过程中的截图。Sybase IQ 16 SPO8 PL27安装步骤与图片一致。已验证。

 

 选择安装目录

 

选择安装类型

 

选择安装组件

 

 

 

 

选择License类型

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

l  验证安装包正常安装

 

[sybiq@jcsjdw1 ~]$ start_iq -v2

16.0.0.808

SAPIQ/16.0.0.808/150224/P/sp08.27/Enterprise Linux64 - x86_64 -2.6.18-194.el5/64bit/2015-02-24 13:37:12

 

l  执行ALTER DATABASE UPGRADE

以单节点模式启动IQ数据库服务

 

[sybiq@jcsjdw1~]$ start_iq @/sybiq/data/sgmsiq.cfg /sybiq/data/sgmsiq.db -iqmpx_sn 1

    执行ALTER DATABASE UPGRADE;命令之前，请先执行SET OPTION PUBLIC.RESERVED_KEYWORDS = '';

(DBA)> SET OPTIONPUBLIC.RESERVED_KEYWORDS = ''

Execution time: 0.007 seconds

 

(DBA)> 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

29 row(s) affected

Execution time: 17.836 seconds

 

       升级完成之后完整备份数据库

 

[sybiq@jcsjdw1 ~]$  dbisql -c"uid=DBA;pwd=sql;eng=sgmsiq_zh" -nogui

(DBA)> BACKUP DATABASE TO'/sybiq_backup/sgmsiq_upgrade.bak'

Snapshot created.

100% (3900833 of 3900833 pages) completeafter 00:02:09

Execution time: 129.852 seconds

l  正常模式重启IQ服务

 

[sybiq@jcsjdw1 /]$ start_iq@/sybiq/data/sgmsiq.cfg /sybiq/data/sgmsiq.db