Being a Teradata DBA - Best Practices

《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