Delete old files through scripts

# To delete old files older then 90 days
find /home/scripts/    -mtime +90 -exec rm ( )\;

#To add .old extension to older files from more then 90 days
find /home/scripts/ -mtime +90 -exec mv {} {}.old ( ) \;

#To list all the files older then 90 days

find /home/scripts/ -mtime +90 -exec ls -l ( ) \;

SAP HANA COCKPIT NOTES 28: creating NEW tenant Database in HANA

Article About:

how to create new tenant database in HANA DB through HANA COCKPIT.

Content:

here are the steps to create new tenant database in HANA cockpit,

1.connect to system database --> navigate to overview page.

2. on the overview page, click the overall tenant statuses tile to open manage databases.

3.click on create tenant button.

3b. then click on create empty tenant option.

4. provide inputs 

• tenant database name: SID
• system user password: 
• conform system user password: 
• in Advanced settings:

                start Automatically  is enable by default.

Note: will have option to defined HOST and port details in case of distributive

          environment.

Have an option to add additional services based on tenant Database technical and business requirements.

5. Finally click on Create tenant database.

6.conformation screen is as below.                                                                                                             

7. the new tenant database need to add in resource groups by administrator through cockpit manager.      

open cockpit manager -->register resources-->register resource--> provide inputs like host name, instance name & number.

                                                                     OR 
create a tenant database using SQL query in HANA studio.with 3 steps.


step1:  open SQL cmd window from HANA studio.
step2:  Run the SQL query as shown in the below screenshot.
step3: finally execute it.

SAP HANA COCKPIT NOTES 6: Credentials required for HANA resources Access

Credentials required for HANA resources Access