SYBASE DATABASE PERFORMANCE GUIDE 15.7

SYBASE Performance Guide by on Scribd

LAW 2.0_Steps by on Scribd

How to apply patches to SYBASE Database

Major steps:

step 1: Download the patch files for  SAP SUPPORT PORTAL.
step 2: prepare the upgrade.
step 3: update the ASE  software.
step 4: perform post-upgrade tasks.
step 5: update the  ODBC and JDBC drivers.
step 6: Restart the SAP system.

Recommendation: perform a file system backup of the ASE software directory (<drive>:\sybase\SID) before you update the software.


process: 

step 1: Download the patch files for  SAP SUPPORT PORTAL.


                                                         support.sap.com
                                                           
                                                                     ↓

                                                   Download software section

                                                                    ↓
                                                          By Category
                                                                     ↓
                                                          Sybase products
                                                                     ↓
                                                      syabse ASE for bussiness suite.

                                                                  ↓

                                                   choose platform  --> download
                                                                  ↓

File ASE157SPxx_x.SAR contains the ASE server software (xx is a two or three-digit number and refers to the current ASE patch level).

                                                               
                                                                  ↓

                       File DBCLNT157SPxx_x.SAR contains the ODBC and JDBC drivers.

                                                               

                                                                   ↓

create one folder -->uncar   ASE157SPxx_x.SAR   only. don't uncar DBCLNT157SPXX_X.SAR

                                                                    ↓

cmd  for uncar the file:                     sapcar    -xvf    ASE157SPxx_x.SAR 

step 2: prepare the upgrade:

•  Perform a file system backup for the software installation directory %SYBASE% (<drive>:\sybase\<SID>).
• check the database version before the update.

make a note, the compare the version after upgrade.

Recommendation: Unlock the 'sa' account in ASE before you start the ASE upgrade. Log in to ASE using the account 'sapsso' with isql and execute the command:

                   sp_locklogin 'sa','unlock'

•        Stop the SAP system and the ASE server; use user <sid>adm.

sybase backup issue

HANA DB backup using HANA studio

what is contained in the backup file?

The data backup includes not only data, but also data structure that are required for restore of DB.

why to take backup on regular basis?

To save data during disk failures

Pre-requsites:

DB user with roles: Backup Admin
                                Backup Operator

                                Catalog read

Note: same roles are enough for performing the recovery of HDB also.

SQL query for check the backup size:

select sum (allocated_page_size) from M_converter_Stastistics

select volume id, sum (allocated_page_size) from M_Converter_Stasticstics) group by volume id,

based on the out put of the above query --> make space arrangements.

Process:

Method1

• Open HANA studio.
• select the correct system for backup amomgs all systems.
• Right click
• choose backup
• choose type as full / differential /incremental 
• specify the location and prefix for the backup file.
• conform 

Method 2

• Open HANA studio.
• login to system
• open hdbsql
• execute the query:

BACKU DATA USING FILE ('/usr/sap/<SID>/HDBXX/backup/data')