Sybase – update to version 16.0 SP03 PL09

In my last post I wrote about bug in earlier Sybase version. Today shortly I show You how to update SYB database to newest version on SP03 level. I’ll be using saphostctrl command. The following steps are required.

Make and check a database backup

Login to Sybase Database

>isql64 -Usapsa -PXXX -SSID -X
>go
>use master
>go
>dump database  to "" with compress = 101
>go

2. Check update

# /usr/sap/hostctrl/exe/saphostctrl -user sapadm PASSWORD -function LiveDatabaseUpdate -dbname SID -dbtype syb -updatemethod Check -updateoption TASK=CHECK_UPDATE_ASE -updateoption DROP_LOCATION=/ase.upgrade/ASEBS16SP03PL09
 Webmethod returned successfully
 Operation ID: 00505691374B1EDBB0ECC7077F441DDF

 ----- Response data ----
 TASK_NAME=CHECK_UPDATE_ASE
 CHECK_DROP_LOCATION=OK
 CHECK_DB_IN_USE=OK
 CHECK_SAPSA_USER=OK
 CHECK_SAPSSO_USER=OK
 CHECK_SA_USER=OK
 CHECK_SYBSID_USER=OK
 CHECK_SAPSID_USER=OK
 CHECK_REPLICATION_SITE=OK
 CHECK_MU_PATCHSAR=OK
 CHECK_UPDATE_ASE=OK
 ----- Log messages ----
 Info: saphostcontrol: Executing LiveDatabaseUpdate
 Info: saphostcontrol: LiveDatabaseUpdate successfully executed

3. Credential

# /usr/sap/hostctrl/exe/saphostctrl -user sapadm PASSWORD -function SetDatabaseProperty -dbname SID -dbtype syb -dbuser sapsa -dbpass PASSWORD USER=SAPSA
 Webmethod returned successfully
 Operation ID: 00505691374B1EDBB0ECCE81E53F5DDF

 ----- Log messages ----
 Info: saphostcontrol: Executing SetDatabaseProperty
 Info: saphostcontrol: SetDatabaseProperty successfully executed

4. Disable Job Scheduler

>isql64 -Usapsa -PXXX -SSID -X -w250
 1> sp_configure "enable job scheduler", 0
 2> go
 (1 row affected)
  Parameter Name       Default     Memory Used   Config Value   Run Value    Unit   Type
 
 enable job scheduler           0           0              0              0 switch dynamic
 Configuration option changed. ASE need not be rebooted since the option is dynamic.
 Changing the value of 'enable job scheduler' does not increase the amount of memory Adaptive Server uses.
 (return status = 0)

 1> sybmgmtdb..sp_sjobcontrol @name=NULL, @option="stop_js"
 2> go
 (return status = 0)
 1> exit

5. Sybase update

# /usr/sap/hostctrl/exe/saphostctrl -user sapadm PASSWORD -function LiveDatabaseUpdate -dbname SID -dbtype syb -updatemethod Execute -updateoption TASK=UPDATE_ASE -updateoption DROP_LOCATION=/ase.upgrade/ASEBS16SP03PL09
 Webmethod returned successfully
 Operation ID: 00505691374B1EDBB0ED1DA0DC72DDDF

 ----- Response data ----
 UPDATE_ASE=update ASE software ok
...
 ----- Log messages ----
 Info: saphostcontrol: Executing LiveDatabaseUpdate
 Info: saphostcontrol: LiveDatabaseUpdate successfully executed

6. Enable Job Scheduler

>isql64 -Usapsa -PXXX -SSID -X -w250
 1> sp_configure "enable job scheduler", 1
 2> go
  Parameter Name       Default     Memory Used   Config Value   Run Value    Unit   Type
 
 enable job scheduler           0           0              1              1 switch dynamic
 (1 row affected)
 Resulting configuration value and memory use have not changed from previous values: new configuration value 1, previous value 1.
 (return status = 0)

 1> sybmgmtdb..sp_sjobcontrol @name=NULL, @option="start_js"
 2> go
 (return status = 0)
 1> exit

* Useful notes:

1982469 – SYB: Updating SAP ASE with saphostctrl

2800483 – SYB: Upgrade / Update SAP ASE with SAP Host Agent 7.21 PL43 and later

That’s all 😉

Cancel Reply