主页 > 云市场 > > 正文

香港服务器_数据库的体系结构_评分榜

来源:胜利云 发布时间:2021-05-05 04:27 标签:服务器数据库香港评分体系结构
浏览:

香港服务器_数据库的体系结构_评分榜

If you are looking for some automated house cleaning tasks for Hana DB-HANACLEANER is the best tool to perform the same .

We have implemented the same in our system and it has helped us to prevent many issues

"The SAP HANA cleaner is a house keeping script for SAP HANA. It can be used to clean the backup catalog, diagnostic files, alerts, to compress the backup logs, and much more. It should be executed by adm or, in case you use a CRON job, with the same environment as the adm. See SAP Note [2399996](https://launchpad.support.sap.com/#/notes/=2399996) and SAP Note [2400024](https://launchpad.support.sap.com/#/notes/=2400024). For a list of all input flags execute with

`python hanacleaner.py –help` "

You can download HANA Cleaner and as of how to configure it using the below link.

https://github.com/chriselswede/hanacleaner

Though there is a proper document in the above location, I just wish to illustrate the steps and configuration I have set up in our landscape for HANA 1.0 environment. If you are looking for HANA 2.0, it will be almost same with minor changes.So please refer the document that comes with the installation in the above link in that case.

Step 1: User creation :

create user HANACLEANER1 password NO FORCE_FIRST_PASSWORD_CHANGE;

ALTER USER HANACLEANER1 DISABLE PASSWORD LIFETIME;

Step 2: Adding the required authorization:

grant AUDIT ADMIN, AUDIT OPERATOR,BACKUP ADMIN,CATALOG READ,LOG ADMIN,MONITOR ADMIN,RESOURCE ADMIN,TRACE ADMIN to HANACLEANER1;

Object role: (Assign this in studio by right clicking the user created-HANACleaner1)

HOST_OBJECT_LOCK_STATISTICS_BASE           -select and delete

OBJECT_HISTORY – select and delete

STATISTICS_ALERTs_BASE  – select and delete

Step 3: Saving the password of HANACleaner1 in hana db user store in master node

hdbuserstore -i SET SYSTEMKEY :3nn15,:3nn15,:3nn15,……………………,:3nn15 HANACLEANER1

Step 4: Create a folder and place the hanacleaner.py that we have downloaded from the github

From the github link copy the file hanacleaner.py and transfer it to the target server.

In the target server, create a folder /usr/sap//HDB/HANACleaner/ and place this python script inside this folder.

Also create a empty folder inside this in the name log, which we will use it in last step to write the output = > /usr/sap//HDB/HANACleaner/log

Step5: Create configuration files: *.sh and *.cfg like shown below

Here I have displayed the configuration files that I had created for our purpose. We can create similar configuration as required and adjust the configuration file value as per our requirement

Below are *.sh files which has reference to a .cfg file which will also be created by us

A.CREATING *.sh files

==========================

sidadm@:/usr/sap//HDB> more /usr/sap//HDB/HANACleaner/rtedumpcleaner.sh

source $HOME/.bashrc

python /usr/sap//HDB/HANACleaner/hanacleaner.py -ff /usr/sap//HDB/HANACleaner/rtedumpcleaner.cfg -op /usr/sap//HDB/HANACleaner/log

=========================

sidadm@:/usr/sap//HDB> more /usr/sap//HDB/HANACleaner/alertscleaner.sh

source $HOME/.bashrc

python /usr/sap//HDB/HANACleaner/hanacleaner.py -ff /usr/sap//HDB/HANACleaner/alertscleaner.cfg -op /usr/sap//HDB/HANACleaner/log

=========================

sidadm@:/usr/sap//HDB> more /usr/sap//HDB/HANACleaner/logsegmentcleaner.sh

source $HOME/.bashrc

python /usr/sap//HDB/HANACleaner/hanacleaner.py -ff /usr/sap//HDB/HANACleaner/logsegmentcleaner.cfg -op /usr/sap//HDB/HANACleaner/log

=========================

sidadm@:/usr/sap//HDB> more /usr/sap//HDB/HANACleaner/objectlockcleaner.sh

source $HOME/.bashrc

python /usr/sap//HDB/HANACleaner/hanacleaner.py -ff /usr/sap//HDB/HANACleaner/objectlockcleaner.cfg -op /usr/sap//HDB/HANACleaner/log

=========================

sidadm@:/usr/sap//HDB> more /usr/sap//HDB/HANACleaner/objectlockcleaner.sh

source $HOME/.bashrc

python /usr/sap//HDB/HANACleaner/hanacleaner.py -ff /usr/sap//HDB/HANACleaner/objectlockcleaner.cfg -op /usr/sap//HDB/HANACleaner/log

=========================

sidadm@:/usr/sap//HDB> more /usr/sap//HDB/HANACleaner/ObjectHistoryTableCleaner.sh

source $HOME/.bashrc

python /usr/sap//HDB/HANACleaner/hanacleaner.py -ff /usr/sap//HDB/HANACleaner/ObjectHistoryTableCleaner.cfg -op /usr/sap//HDB/HANACleaner/log

=========================

sidadm@:/usr/sap//HDB> more /usr/sap//HDB/HANACleaner/diskfragmentation.sh

source $HOME/.bashrc

python /usr/sap//HDB/HANACleaner/hanacleaner.py -ff /usr/sap//HDB/HANACleaner/diskfragmentation.cfg -op /usr/sap//HDB/HANACleaner/log

=========================

sidadm@:/usr/sap//HDB> more /usr/sap//HDB/HANACleaner/eventscleaner.sh

source $HOME/.bashrc

python /usr/sap//HDB/HANACleaner/hanacleaner.py -ff /usr/sap//HDB/HANACleaner/eventscleaner.cfg -op /usr/sap//HDB/HANACleaner/log

=========================

sidadm@:/usr/sap//HDB> more /usr/sap//HDB/HANACleaner/Generalfilcleaner.sh

source $HOME/.bashrc

python /usr/sap//HDB/HANACleaner/hanacleaner.py -ff /usr/sap//HDB/HANACleaner/Generalfilcleaner.cfg -op /usr/sap//HDB/HANACleaner/log

=========================

sidadm@:/usr/sap//HDB> more /usr/sap//HDB/HANACleaner/backupcleaner.sh

source $HOME/.bashrc

python /usr/sap//HDB/HANACleaner/hanacleaner.py -ff /usr/sap//HDB/HANACleaner/backupcleaner.cfg -op /usr/sap//HDB/HANACleaner/log

=========================

sidadm@:/usr/sap//HDB> more /usr/sap//HDB/HANACleaner/Generalfilcleaner1.sh

source $HOME/.bashrc

python /usr/sap//HDB/HANACleaner/hanacleaner.py -ff /usr/sap//HDB/HANACleaner/Generalfilcleaner1.cfg -op /usr/sap//HDB/HANACleaner/log

=================================================

B.Creating all the *.cfg files that we referred above

This is where we actually specify the arguments that we have decided and it can vary from landscape to landscape.

=========================

sidadm@:/usr/sap//HDB/HANACleaner> more alertscleaner.cfg

#HANA Alert cleaner

#minimum number retained days of the alerts=ar,output alerts=ao,output deleted alerts=ad

-ar 15

-ao true

-ad true

=========================

sidadm@:/usr/sap//HDB/HANACleaner> more columncompression.cfg

#Table compression re-optimization of column store tables can be automated

#cc-Max allowed raw main records,-ce Max allowed estimated size,cr-Max allowed rows,-cs #(mb)-Max allowed size,-cd Min allowed distinct count,-cq-Max allowed UDIV quota,-cu Max #allowed UDIVs

-cc 20000000

-ce 1

-cr 20000000

-cs 1000

-cd 10

-cq 30

-cu 20000000

-cb 200000

-cp true

-cm true

-co true

=========================

sidadm@:/usr/sap//HDB/HANACleaner> more diskfragmentation.cfg

#Disk fragmantation -fl fragmentation limit%,-fo output fragmentation

-fl 20

-fo true

=========================

sidadm@:/usr/sap//HDB/HANACleaner> more eventscleaner.cfg

#Event Cleaner,-eh minimum retained days for handled events days,-eu-minimum retained #days for unhandled events days

-eh 5

-eu 30

=========================

sidadm@:/usr/sap//HDB/HANACleaner> more Generalfilcleaner.cfg

#General file cleaner eg:hanacleaner logs;retention days beyond which files can be cleaned #5days,gd-directories,-gw-filename parts

-gr 5

-gd /usr/sap//HDB/HANACleaner/log

-gw hanacleanerlog

=========================

sidadm@:/usr/sap//HDB/HANACleaner> more inihistorycleaner.cfg

#ini file cleaner -ir inifile content history retention in days

-ir 366

=========================

sidadm@:/usr/sap//HDB/HANACleaner> more logsegmentcleaner.cfg

#Log Segment Cleaner -lr-maximum number of free log segments per #service

-lr 1

=========================

sidadm@:/usr/sap//HDB/HANACleaner> more objectcleaner.cfg

#Unknown object lock entries cleanup -kr min retained unknown object lock days

-kr 1

=========================

#object histor cleanup -om object history table max size in mb,-oo-output cleaned memory #from object table

-om 1

-oo true

=========================

sidadm@:/usr/sap//HDB/HANACleaner> more ObjectHistoryTableCleaner.cfg

#Object history cleanup -om object history table max size in mb,-oo-output cleaned memory #from object table

-om 50

-oo true

=========================

sidadm@:/usr/sap//HDB/HANACleaner> more objectlockcleaner.cfg

#object lock cleaner for UNNNOWN -kr-min retained unknown object lock days

-kr 1

=========================

sidadm@:/usr/sap//HDB/HANACleaner> more rtedumpcleaner.cfg

#dump cleaner with 15 days of retention period

-dr 15

=========================

sidadm@:/usr/sap//HDB/HANACleaner> more tracecleaner.cfg

#Trace files delete min retain for 30 days,output trace file, output the deleted trace file entry

-tc 30

-tf 30

-to true

-td true

=========================

sidadm@:/usr/sap//HDB/HANACleaner> more auditcleaner.cfg

#audit cleaner -ur retention time [days] of the audit log table

-ur 200

=========================

sidadm@:/usr/sap//HDB/HANACleaner> more backupcleaner.cfg

#backup catalog cleanup older than 40 days and print the deleted entries

-be -1

-bd 40

-bb false

-bo false

-br false

#backuplog compress -zb backup logs compression size limit,-zp-zip path,-zl keep zip files

#-zb 1000

#-zp /usr/sap//HDB

#-zl true

=========================

sidadm@:/usr/sap//HDB/HANACleaner> more Generalfilcleaner1.cfg

#General file cleaner eg:hanacleaner logs -gr-etention days for #any general file,-gw-filename parts

-gr 8

发表评论
验证码: 点击我更换图片

注:网友评论仅供其表达个人看法,并不代表本站立场。

热门文章

  • 移动大数据_云服务器一般要多少钱
    <strong>移动大数据_云服务器一般要多少钱</strong>

    移动大数据_云服务器一般要多少钱

    高速互联网和功能强大的应用程序使得几乎所有有办公桌工作的人都可以在家工作。然而今天,大多数公司仍然坚持要求员工忍受有时令人心碎的上下班路...

  • 华为服务器_便宜的_大带宽服务器租用
    <strong>华为服务器_便宜的_大带宽服务器租用</strong>

    华为服务器_便宜的_大带宽服务器租用

    作者:马库斯·瓦纳关于2017年趋势的讨论正在迅速而激烈地展开,职场也不例外。随着新的一年即将到来,职场趋势专家们正在为2017年列出自己的预测清单...

  • 云计算企业_物联网应用领域
    <strong>云计算企业_物联网应用领域</strong>

    云计算企业_物联网应用领域

    正如Facebook和Twitter首席运营官(COO)上周在美国国会作证时所说,出现的一个突出主题是,这些公司在保护其平台免受网络攻击方面所扮演的角色。这些公...

  • 大数据库_怎么购买_云计算信息安全
    <strong>大数据库_怎么购买_云计算信息安全</strong>

    大数据库_怎么购买_云计算信息安全

    类别工作日新闻与文化财务人力资源规划技术创新分析与见解客户和社区行业金融服务政府保健高等教育款待媒体和娱乐专业和商业服务零售技术更多播客...

  • 大淘客网-2024年巴西可回收运输包装市场
    <strong>大淘客网-2024年巴西可回收运输包装市场</strong>

    大淘客网-2024年巴西可回收运输包装市场

    下载Technavio公布了其最新的市场研究报告,题为《2020-2024年巴西可回收运输包装市场》(图片:商业通讯)Technavio公布了其最新的市场研究报告,题为《...

云储存

更多 >
  • 企业网站_泛域名解析_免费申请
    企业网站_泛域名解析_免费申请

    你们中的一些人可能不知道SAP TechEd之前我们的Devtoberfest活动的所有细节,但现在是我喜欢谈论的一个话题Kyma的时候了。具体来说,我们如何让您能够使用...

  • 美国服务器_数据库调用_优惠
    美国服务器_数据库调用_优惠

    SAP Business Application Studio最近在Azure、AWS、阿里巴巴云上向客户发布。 了解更多有关SAP Business Application Studio的信息:一个中心博客,提供有用信息或博客文...

云储存轻量服务器_云虚拟主机怎么用_超低折扣
云储存腾讯云_市网站建设_价格
云储存云存储_分布式图片存储_评分榜
云储存分布式存储_cdn啥意思_稳定性好
云储存亚马逊云_企业邮箱在哪里登陆_便宜的