Skip to Content
Author's profile photo Nicolaas Johannes Van Zyl

Sybase minor upgrade – service pack part2

Log on as SID<ADM> user stop the SAP system and the ASE Server using the management console. Disable the Sybase BCKServer_<SID>_BS and Sybase SQLServer_<SID> services. Also make sure that no process isql,sqlsrver.exe or bcksrvr.exe are running in task manager reboot the host as well.


Log on as SYB<SID> user , download the file dbsrvresp_update_win.txt from note 1607816 and copy it to the temporary location d:\droplocation where you extracted the patch file earlier. Open cmd in administration (elevated mode) Run the command syntax setupConsole.exe -f <TMPDRIVE>:\<PATH_TO_TMPDIR>\dbsrvresp_update.txt -i silent -DUSER_INSTALL_DIR=<SYBDRIVE>:\sybase\<DBSID> -DAGREE_TO_SAP_LICENSE=true

Replace DBSID with your SAP System ID, and replace Sybdrive with the drive where you ASE software is installed. Replace <TMPDRIVE> and <PATH_TO_TEMPDIR> as relevant

This is the longest phase and usually took me 10 – 15 minutes.


When the install process has finished check the ASEsuite.log which is located in %SYBASE%\log or in this case D:\sybase\<DBSID>\log and check for errors.



Perform the post upgrade tasks as user syb<sid> enable the services for Sybase Sybase BCKServer _<DBSID>_BS and Sybase SQLServer _<DBSID> only and not SAP.  Sybase SQLServer _<DBSID> service takes a long time to start after update, do not panic check the DBSID.log in my example it is updating statistics below. Can take up to 10  minutes maybe more to startup initially.



Check the database <SID>.log for errors of Job Scheduler as per the note, if you do see the below error you can ignore the error at this point.


Logon with user syb<sid>, Unlock user sa again by logging on as sapsso user. The user sa is locked by the installation script dbsrvresp_update_win.txt.


Execute the Sybase installation scripts  located in the directory D:\sybase\<DBSID>\ASE-16_0\scripts execute with command syntax Isql64  -Usa -S<SID> -X  -iinstmstr -o<output file> Always specify full path to input file (script) and output file (log file). Check the output log file for errors afterwards in detail.


Example of text command of instmaster.

isql64 -X -Usa -SSID -i D:\sybase\SID\ASE-16_0\scripts\instmstr -o D:\droplocation\instmstrlog.txt

Repeat these steps for the following scripts:

Instcomm, instmodl, instmsgs. ebf,installjsdb, installdbextend

instsecu (necessary only if database sybsecurity has been setup)

installdbccdb (optional, necessary only if you configured the dbcc database


Execute the script syb_update_db.TXT which is attached to this SAP note. Copy the script to a temporary directory (e.g. the temporary directory to which you copied the Sybase software package). Change to that directory and execute the script:

$>isql -X -Usa -S<SID> -e -i syb_update_db.TXT -o sybupd_out.txt

Take note command syntax changes here

Restart the job scheduler. Log in to ASE with isql with the account sapsa and execute the


sp_configure “enable job scheduler”, 1

exec sybmgmtdb..sp_sjobcontrol ” , ‘start_js’


Run the following command in the directory where you previously implemented this script , note you must use SA user and therefore it needs to be still unlocked. Substitute SID with your SID:

isql -SSID -Usa -DSID -X -e -i sp_thresholdaction_logfreespace.sql


Lock user “sa” again. Log in to ASE with isql with the account sapsso and execute the command as per below.


As user SYB<SID> stop Sybase and disable services again


Remove the newly installed sample client library applications according to SAP Note 1598817 (optional). Ensure that all physical devices created by the process have only write permission for the operating system user who installs, configures and runs SAP ASE. In a standard installation, that is the user ‘syb<sid>’ for /sybase/<DBSID>. On a Windows system, the file permission inheritance is already set up and the Adaptive Server services are running as the syb<sid> operating system user. As you can see the inheritance is running to Sybase subfolders and the services are running as per below image.


The Adaptive Server update includes folders containing sample client library applications.  Note: These sample programs are included for training purposes only and are not intended to be installed in a production environment.

!!!Be very careful not to delete any parent folders!!!








In our case here is nothing to delete as you can see above!

Log in as <sid>adm user. Copy the suitable <DBCLNT>.SAR file to the directory <drive>:\usr\sap\<SID>\SYS\global\syb\NTAMD64\. Copy the downloaded ASEBC1600001_2-20012478.SAR to the directory E:\usr\sap\SID\SYS\global\syb\NTAMD64 and extract it



Update the JDBC driver and reconfigure your Java stack to use this JDBC driver with the changed name, see SAP Note 867976.(This is for dual stack or Java only systems)


Log in as user<sid>adm and re-enable the services for Sybase and SAP and start the SAP system through the SAP Management Console.

Now check the version of the database after the upgrade as per above


Now after system is started access tcode DBACOCKPIT specify the password of user sapsa and select the option Use the standard connect user and do not ask again and click on logon.


Open DBACOCKPIT -> Click on Database <SID> -> Configuration -> Data Collection Framework -> Collector Configuration (check for any yellow or red collectors and repair them as required)



As per this example click on repair.


Now you can see it is displaying correctly. Always start with the Framework collector first.

Now you will have to check that your installed threshold script still exist by running below query in iqsl and switching to the master database. As you can see your threshold script is still installed in SID database.


Now you must check that your set thresholds are still active for the script. Switch to your <DBSID> should be the one identified by query above. Then run the command as per above. As you can see from above I had only installed the one threshold and the last chance threshold values with the script sp_thresholdaction_logfreespace. This configuration should still be intact.


Now switch to master database again and verify that you dump configuration still exists. As you can see the dump configuration is still existing and configuration is correct as per what I set it up. This configuration should still be intact.



1607816 – SYB: Installing Service Packs for SAP ASE (Windows)

2162735 – SYB Performing a major ASE upgrade (Windows)

2116143 – Use of sqlupgrade or sqlupgraderes utilities may fail to upgrade ASE with messages: “Unable to boot server” and “Adaptive Server failed to restart” –                SAP ASE

867976 – Changing JDBC driver on WEB AS Java 6.40 NW 7.0x 7.1x

1982469 – SYB Updating SAP ASE with saphostctrl  sapdbctrl

1598817 – SYB Removal of sample client library applications

1031096 – Installing Package SAPHOSTAGENT

2075653 – Targeted ASE 16.0 Release Schedule and CR list Information

1835880 – SYBHow to diagnose issues with Sybase ASE Job Scheduler, ATM, or Scheduled Jobs

2087323 – SYB Important solved problems for SAP Applications running on SAP ASE

1940536 – SYB Mandatory requirement to turn off ‘plan sharing’ feature in SAP ASE

1722359 – SYB Running SAP applications on SAP ASE – Best Practice

1539125 – SYB Configuration Guide for SAP ASE

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Pankaj K Pathak
      Pankaj K Pathak

      Hi ,


      I used this doc to upgrade my SAP ASE 15.7 SP101 to SP136 , which was successful and working fine on Windows box.



      Author's profile photo Nicolaas Johannes Van Zyl
      Nicolaas Johannes Van Zyl
      Blog Post Author

      Hi Pankaj,


      Glad it helped you, always good to hear feedback. Not a refined doc as far as aesthetics goes but it gets the job done. Unfortunately I am not on SCN a lot anymore this new platform is really unfriendly.

      Hope all goes well!

      Best Regards,


      Author's profile photo Former Member
      Former Member

      Hi All,


      i am planning to update the patch level from sybase 16.0 SP02 PL04 to 16.0 SP02 PL06

      Is there any document to update or steps from sybase 16.0 SP02 PL04 to 16.0 SP02 PL06.

      Please guide me.


      Author's profile photo Ahmed Mohammed
      Ahmed Mohammed

      Hi Ravi,

      Please follow either sapnotes :-

      I followed the first sapnote to upgrade from to and it went smooth.



      Ahmed Mohammed