Actian产品运维培训.pptxVIP

Actian产品运维培训 Vortex运维培训 Vortex目录结构 Vortex服务停止与启动 Vortex数据库配置 Vortex命令行 Vortex监控 备份与恢复 Vortex增加节点 其他功能 SQL执行计划 数据库用户及权限 常用SQL功能及函数 Vortex目录结构 系统目录（主节点和子节点） II_SYSTEM/ingres/ 软件目录（包括系统数据库数据） HDFS目录 /Actian/VortexVH/ingres 用户数据库数据文件 Actian用户变量配置 Vortex服务停止与启动 启动Vortex服务 ingstart 停止Vortex服务 Ingstop / ingstop –immediate Vortex数据库配置 vectorwise.conf II_SYSTEM/ingres/data/vectorwise/vectorwise.conf II_SYSTEM/ingres/data/vectorwise/vectorwise.dbname.conf ingsetenv/ingprenv cbf(不建议修改） 修改后的配置信息写入$II_SYSTEM/ingres/files/config.dat文件 Vortex命令行 $ sql dbname $ vwinfo $ infodb $ vwload $ copydb/unloaddb $optimizedb Vortex监控 系统表及视图 登陆到imadb系统数据库 SELECT server, session_id, real_user, db_name, session_terminal, VARCHAR(_DATE(query_start_secs)) + ‘ ’ + VARCHAR(_TIME(query_start_secs)) + VARCHAR(‘:’) + VARCHAR(MOD(query_START_secs,60))FROM ima_server_sessionsWHERE db_name NOT IN (‘’, ‘imadb’)\g SELECT server, db_name, session_query, (BIGINT((CURRENT_TIMESTAMP - TIMESTAMP_WITH_TZ(‘1970-01-01 00:00:00+00:00’))/INTERVAL ‘1’ second) - query_start_secs) AS elapsedsecsFROM ima_server_sessionsWHERE db_name NOT IN (‘’, ‘imadb’)\g SELECT db_name, session_query, (BIGINT((CURRENT_TIMESTAMP - TIMESTAMP_WITH_TZ(‘1970-01-01 00:00:00+00:00’))/INTERVAL ‘1’ second) - query_start_secs) AS elapsedsecsFROM ima_server_sessions s,ima_server_sessions_extra eWHERE s.session_id = e.session_id and s.effective_user != ’’AND (e.session_state != ‘CS_EVENT_WAIT’ OR e.session_wait_reason != ‘BIOR’) AND db_name NOT IN (‘’, ‘imadb’)\g Vortex监控 其他表及视图  iivwprof_query iivwprof_op iivwprof_io iivwprof_stage iivwprof_expr iivwprof_parse_tree Vortex监控 移除数据库活动进程 Start the iinamu utility: iinamu At the IINAMEU prompt, enter this command to display the server number (GCF address) of your Vector Server: show ingres The running servers and their associated server numbers are shown. Start iimonitor using the Vector Server number shown in Step 2: iimonitor server_number At the IIMONITOR prompt, lis