ASE pre-check commands:
sudo -i;
df -kh;
cat /etc/*release* ;
virtualip list;
su - [sybSID]
showserver;
dataserver -v;
isql -v;
cd /sapmnt/[sid]/global/syb/linuxx86_64/[sybSID]/
dba ;
runssa [sid] ;
select @@servername,@@version (after every select command we have to give 'go')
exec sp_version
select @@servername,getdate(),DBName,BackupStartTime from master..monOpenDatabases
select @@hadr_mode
exec sp_config_rep_agent
sudo -i;
df -kh // To know the SID
cat /etc/*release* ; // There should be minimum OS VERSION(12.4).
virtualip list; // To check Existence of virtual Ip's
su - sidadm // Enter into Super user control of DATABASE.
HDB version; // {To Customer}Will check the current DB version and we
need to compare with requested version.
hdbsql -v; // {To Customer}To check the client version.
cdexe; // Enter execuitable path.
cd plugins; ll; // If plugins are availabe then we need to go for "LL".
cdpy; // To switch to python directory.
python systemReplicationStatus.py; // To check if system has Primary, Hr, Dr.
python landscapeHostConfiguration.py; // To find single or multinode.
cdcoc ; // To go to Custom config.
cat global.ini;
cdpro ; // To go to profile.
cat DEFAULT.PFL;
sapcontrol -nr 06 -function GetProcessList; // {To Customer}To check if all DB are green and
runing fine.
sapcontrol -nr 06 -function GetSystemInstanceList; // {To Customer}Instance running fine.
sapcontrol -nr 01 -function GetProcessList; // Also in Application.
sapcontrol -nr 00 -function GetSystemInstanceList;
hdbnsutil -printSystemInformation; // tenant DB and System DB.
hdbsql -U NAGIOS -jA // To go inside backup monitoring path.
##Tenant## - hdbsql -U WSID -jA // To login into Tenant DB path.
select distinct(plugin_name) from M_PLUGIN_MANIFESTS; //to check
plugins
select
SYSTEM_ID,PRODUCT_LIMIT,PRODUCT_USAGE,EXPIRATION_DATE,PERMANENT,VALID
from m_license; //to check License
select * from m_licenses; //to check License
SELECT * from M_DATABASE_HISTORY;
select top 6 ENTRY_ID, UTC_START_TIME, UTC_END_TIME, ENTRY_TYPE_NAME,
BACKUP_ID, STATE_NAME,SYS_START_TIME,SYS_END_TIME from M_BACKUP_CATALOG
where ENTRY_TYPE_NAME = 'complete data backup' and STATE_NAME= 'successful' ORDER
BY UTC_START_TIME DESC; //to check the backup
select round(sum(allocated_page_size/1024/1024/1024),2) as "backup size in GB" from
M_CONVERTER_STATISTICS; // to check the backup space
Below are commands to check host during pre-checks:
---------------------------------------------
sudo -i
df -kh
cat /etc/os-release
virtualip list
sudo su - sidadm
HDB version
hdbsql -v
cdexe
cd plugins ll;
cdpy
python systemReplicationStatus.py
python landscapeHostConfiguration.py
cdcoc
cat global.ini
cdpro
cat DEFAULT.PFL
hdbnsutil -printSystemInformation
sapcontrol -nr 04 -function GetProcessList
sapcontrol -nr 04 -function GetSystemInstanceList
hdbsql -U bkpmon -jA
select distinct(plugin_name) from M_PLUGIN_MANIFESTS
select
SYSTEM_ID,PRODUCT_LIMIT,PRODUCT_USAGE,EXPIRATION_DATE,PERMANENT,VALID
from m_license
select * from m_licenses
SELECT * from M_DATABASE_HISTORY
select top 6 ENTRY_ID, UTC_START_TIME, UTC_END_TIME, ENTRY_TYPE_NAME,
BACKUP_ID, STATE_NAME,SYS_START_TIME,SYS_END_TIME from M_BACKUP_CATALOG
where ENTRY_TYPE_NAME = 'complete data backup' and STATE_NAME= 'successful' ORDER
BY UTC_START_TIME DESC
select round(sum(allocated_page_size/1024/1024/1024),2) as "backup size in GB" from
M_CONVERTER_STATISTICS
=========================================================================
========================================================
HANA Post check commands:
-------------------------
POST CHECK:
APP HOST:
su - sidadm
hdbsql -v
sapcontrol -nr 00 -function GetSystemInstanceList
sapcontrol -nr 00 -function GetProcessList
sapcontrol -nr 01 -function GetProcessList
ABAP: R3trans -d
JAVA: R3trans -x
date
DB HOST:
su - sidadm
HDB version
cd /hana/shared/HED/hdbclient
./hdbsql -v
cdexe
cd plugins
ls -ltr
sapcontrol -nr 06 -function GetProcessList
sapcontrol -nr 06 -function GetSystemInstanceList
=========================================================================
===========================================================
To check the running file in HANA Host below are the commands:
--------------------------------------------------------------
df -kh
sudo su - SIDadm
cd /var/tmp
ls -ltr
tail -f log.file
