08.Monitoring_eng英文学习材料

《08.Monitoring_eng英文学习材料》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Thingstocheckundernormalconditionsorwhenaproblemoccurs:TraceFilesFilesinwhichvariousinformationiswrittenwhileALTIBASEHDBisstartedupLocatedinthe$ALTIBASE_HOME/trcdirectoryMetaTablesTablesdefinedbythesystemforstoringinformationaboutalldatabaseobjectsOwnedbytheSYSTEM_userCh

2、angedbythesystemwhenDDLstatementsareexecutedPerformanceViewsProvideup-to-dateinformationaboutsystemmemory,thestateofprocesses,sessions,buffers,etc.Read-onlyC1C2C3altibase_boot.logaltibase_sm.logaltibase_qp.logaltibase_rp.logE/SQL

3、CLI

4、ODBC

5、JDBCIPC

6、UNIXDOMAIN

7、TCP/IPALTIBASERepl

8、icationQueryProcessorParsing/OptimizerExecutorvalidationStorageManagerTransactionRecoveryBufferManagerManagerManagerPhysicalMemoryMemoryTablesBufferCheckpointimagefilesDatafilesloganchorlogfilesFileNameMainDescriptionInformationaboutthecurrentstatusofALTIBASEHDBInformationaboutt

9、hestepstakenwhenstartingupandshuttingdownaltibase_boot.logUsefulfordiagnosingerrorsthatoccurduetolackofdiskspacewhilestartingupInformationaboutthecallstack(usefulwhenthesystemisterminatedabnormally)Warningsandtracemessagescreatedbythereplicationmodulealtibase_rp.logShowthecurren

10、tstatusofreplication,replicationconflicts,etc.FileNameMainDescriptionWarningsandtracemessagescreatedbythealtibase_sm.logStorageManagerModuleCheckpointing,backup,etc.WarningsandtracemessagescreatedbytheQueryProcessorModulealtibase_qp.logShowwhetherDDLstatementsexecutedsuccessfull

11、yThemostimportantmetatables:ItemRelatedMetaTablesSYS_USERS_UsersSYS_TBS_USERS_SYS_TABLES_SYS_COLUMNS_TablesSYS_CONSTRAINTS_SYS_CONSTRAINT_COLUMNS_SYS_INDICES_IndexesSYS_INDEX_COLUMNS_Themostimportantmetatables:ItemRelatedMetaTablesSYS_GRANT_OBJECT_PermissionsSYS_GRANT_SYSTEM_S

12、YS_PRIVILEGES_SYS_VIEWS_ViewsSYS_VIEW_PARSE_SYS_VIEW_RELATED_SYS_TRIGGERS_TriggersSYS_TRIGGER_DML_TABLES_SYS_TRIGGER_STRINGS_InformationaboutdatabaseusersColumnDescriptionUSER_IDTheuniqueusernumberUSER_NAMETheusernamePASSWORDThepassword(encrypted)Thetimeatwhichtheuser’sinformat

13、ionwasLAST_DDL_TIMElastmodifiedTheidentifieroft