欢迎来到天天文库
浏览记录
ID:39910308
大小:247.50 KB
页数:29页
时间:2019-07-14
《Being a Teradata DBA - Best Practices》由会员上传分享,免费在线阅读,更多相关内容在学术论文-天天文库。
1、BeingaTeradataDBA:BestPractices,TipsandToolsoftheTradePhilBentonTeradataBeingaTeradataDBA•Knowingyourjobresponsibilities…•PlatformDBA•ApplicationDBA•Systemadministrator…soyoucanexceedexpectations•Knowingyourextendedenvironment…•Processingschedules•Systemtopology•Personnelinvolved•BARsolu
2、tion…soyoucangetaquickhandleonanyissuethattouchesthedatawarehouseInsightsintoAction2007TeradataPARTNERSTheBasics•UnderstandTeradata•Node/Vproc/Bynetarchitecture•DBCtables•Tablestructure•Systemfeatures•Databaseutilities•Clientutilities•Knowyoursystemconfiguration•VPROCMANAGER(memory&Vproc
3、counts)•“ChoosingCalculator”outputforyoursystem•Database&OStunables•BARstrategy•Public&BARNetworkconfigurationsettings•Applicationdatabases&namingconventionsInsightsintoAction2007TeradataPARTNERSHousekeeping•Databasemaintenance•Scandisk,checktable,defrag,packdisk.•Cleanupaccessrightsando
4、ldobjects•Rotatinglogs(rss,dbql,acctg,etc)outofdbc•ReviewingdatabaseandOSlogs•streams,osm,messagesandsw_eventlogs.•Keepingupwithdatabase&clientpatches•Trytogetonaregularscheduleforupdates•WatchforTechAlertsInsightsintoAction2007TeradataPARTNERSMonitoring•CCL/TVIwillalertformostsystemaler
5、ts,butnoteverything•However,itcanbecustomizedtosomedegreeforyourenvironment•Ifaspecificalertisn’tavailable,openanincident.•UseTDManagerorcustomscripts•Blocking,resourceutilization,toomanyloadjobs•TDManagercanbepluggedintomostenterprisemonitoringsoftwareviaSNMPtraps,emailorwindowsexecutab
6、les.•Usecanaryqueryfrombothapplicationservers&theTDnodesthemselves•CanhelpisolatethecauseofproblemsInsightsintoAction2007TeradataPARTNERSMonitoring–usingPerl#usingodbcuseWin32::ODBC;my$DSN="DSN=td_odbc_connection";my$connection=newWin32::ODBC($DSN);$SQL="sel*fromdb.table;";if($connection
7、->Sql($SQL));if($connection->FetchRow()){@columns=$connection->FieldNames();@dataRow=$connection->Data();if($dataRow[0]=~/hello/){#thendothis....}}InsightsintoAction2007TeradataPARTNERSMonitoring–usingPerl#usingDBIuseDBI;$dbh=DBI->connect("DBI:Teradata:$HOST","$USER","$PA
此文档下载收益归作者所有