GP简明使用手册
- 格式:docx
- 大小:23.10 KB
- 文档页数:7
GP无线WIFI打印机安装使用手册GP无线WIFI打印机参数功能介绍:可用Web 浏览器进行参数设定。
支持点对点(TCP、UDP) 和broadcast (仅UDP)。
支持WLAN 基础网(Infra)、自组网(Ad-Hoc)。
支持WLAN 安全(WEP64、WEP128、WPA-Personal、WPA2-Personal、TKIP、AES)。
内置AP、Ad-Hoc 搜索功能(site survey 功能)。
支持2.4G 无线网络(1-13信道可选)IEEE802.11b(11Mbps),IEEE802.11g(54Mbps),IEEE802.11n(72Mbps)。
接收信号强度大于-35db(72Mbps)。
支持AP(Access Point)路由和STA(Station)两种模式,用户可以通过网页选择不同模式。
AP模式:笔记本,手机,平板等无线终端可以直接搜索并连接到打印机。
STA模式:此模式打印机可以直接连接到路由器(可实现无线打印机共享打印功能)GP无线WIFI打印机使用设置步骤:一.AP(Access Point)模式设置方法1.请将纸卷放置打印机内部并开启打印机电源,使用可以接收无线WIFI的笔记本电脑设置电脑IP为自动获取状态。
2.搜索当前无线网络,查找到“Printer”打印机设备,点击“连接”连接到打印机。
3.我的电脑-》控制面板-》打印机和传真,找到已经安装好GP-80160II打印机驱动程序,右击选择“属性”。
4.选择“端口”,然后点击“添加端口”。
5. 选择“Standard TCP/IP Port”,并点击“新端口”。
6. 输入打印机默认IP地址,并点击下一步。
7.点击“常规”,然后点击“打印测试页”完成打印机安装,如果打印机能打印出测试页,表示已经可以正常使用。
二.STA(Station)模式设置方法1. 在AP模式下使用笔记本连接到打印机,如下图:2. 在IE浏览器输入:http://192.168.0.1,进入后输入用户名:admin,用户密码:admin 登陆到设置页面。
前言感谢您使用新一代画面和逻辑编程软件GP-Pro EX V2.21简体中文版。
在使用这些产品之前,请认真阅读本手册,并妥善保管以备将来参考。
注意(1)“GP-Pro EX”软件包(以下简称为“本产品”)中包含的所有程序和手册的版权均为Digital Electronics Corporation所有。
Digital Electronics Corporation按照本产品CD-ROM中包含的“软件许可协议”授予用户使用本产品的权利。
任何违反上述条款的行为均为日本及国际法规所禁止。
(2)本手册的内容已经经过彻底的审查,但是,如果您在本手册中发现了任何错误或疏漏,请告知您当地的GP代理商。
(3)对因使用本产品而造成的损坏或第三方索赔,Digital Electronics Corporation不承担任何责任。
(4)本手册中的描述与本产品的实际功能之间可能存在差异。
有关本产品的最新信息将在数据文件(如Readme.txt文件等)和其他文档中另行提供。
在使用产品之前,请参考这些资料及本手册。
(5)本手册为Digital Electronics Corporation发布的英文手册的简体中文版。
(6)尽管本产品包含和显示的信息可能涉及Digital Electronics Corporation或第三方的无形产权或知识产权,但Digital Electronics Corporation不向任何用户和/或其他第三方担保或授权上述产权的使用。
Digital Electronics Corporation不承担与第三方知识产权有关的任何责任,也不承担与使用本产品所包含或显示信息有关的任何责任。
© 2008 Digital Electronics Corporation版权所有,保留所有权利。
Digital Electronics Corporation,2008年8月 有关商标和商标名称权利的信息,请参阅“商标权利”。
索引数字16384色 ..........................................................8-39 16级 ................................................................8-39 256色 ..............................................................8-39 2维码阅读器 .........................................16-4, 16-11 3速闪烁 ...........................................................8-39 4096色 ............................................................8-39 65536色 ..........................................................8-39 AAPI通讯 .......................................................37-159 AUX输出 .......................................................10-50安全 .............................................................28-134安全级别列表 .................................................21-23安全设置 ........................................................21-19按键 ...............................................................15-27 BBMP/JPEG,粘贴 ............................................8-76包注册 ............................................................8-104本地窗口 .................................................12-4, 12-7保持/非保持区的数量 ...................................28-16保持传输 ........................................................28-83保持区 ............................................................28-16保存CSV格式 ................................................19-55报警历史 .................................................19-55保存到存储设备的注意事项 .........................23-143保存至CF卡 ......................................................19-59 CF卡,注意 ...........................................19-61 CF卡或USB存储器 ...............................19-58 USB存储器,注意 ..................................19-61保存至CF卡 ..................................................11-18保护对象 ..........................................................8-38报警 .................................................................19-1位监控 .....................................................19-22文本 ......................................................19-159显示,脚本 .............................................20-17备份历史 .................................................19-76部件 ......................................................19-103打印历史 ...............................................19-155冻结模式 ...............................................19-132功能列表 ...............................................19-160历史 .............................................19-21, 19-31历史数据的存储空间要求 ........................19-80列表视图 .................................................19-15设置 ........................................................19-70摘要 ...........................................19-79, 19-136直接选择 ...............................................19-118字监控 .....................................................19-26组 ............................................................19-79报警文件位置 ........................................................19-60名称 ........................................................19-60报警消息显示位置 ..........................................19-10报警历史数据 .................................................24-31报警语言,切换 ..............................................17-66背光灯颜色切换设置 ......................................5-175备份 ................................................................5-165备份SRAM ....................................................19-80备份SRAM容量 ..............................................5-93备份数据,创建 ..............................................32-37比较,条件 ...................................................20-140比较存储器 .....................................................20-75比较工程 ........................................................32-25笔记录 ............................................................18-47编号,自动 ...................................................24-105变量 ................................................................28-13变量格式 ........................................................28-19标记限制 ........................................................8-104标记,显示图像 ................................................8-82标记注册 .............................................8-101, 8-102标签 ................................................................28-62标签,查找和更换 ............................................5-73标准字体 ............................................................6-3播放列表创建文件 .................................................26-26使用 ........................................................26-26步数 ..................................................................28-5部件,编辑 .......................................................8-49部件,查找和替换地址 .....................................5-73部件工具箱 .......................................................5-86部件名称,逻辑画面 ........................................28-5 CCF卡 .............................................................5-189保存注意事项 .............................5-187, 23-143初始化 ..........................................32-37, 32-42传输工程文件 ..........................................32-36复制到 .....................................................32-29目标文件夹 ................................................5-94设置文件夹 ................................................5-45使用注意事项 ......5-187, 11-27, 19-61, 23-144 CF卡文件操作 .............................................20-102 CF卡,保存至控制字地址 ..............................................19-59注意事项 .................................................19-61 CF卡,操作注意事项 ..................................24-116 CF卡工具 ......................................................32-28 CSV文件,读取 ..........................................20-118 CSV格式 .......................................................24-31 CSV数据显示 .................................24-31, 24-37, 24-81编辑 ........................................................24-41传输 .................................24-57, 24-62, 24-89打印 ........................................................24-42流 ..............................................................24-4采样CSV格式 ................................................23-20概述 ..........................................................23-2将数据保存至CF卡 ................................23-20结构 ......................................................23-108如果不能进行数据采样时 ......................23-126数据 ........................................................23-14数据显示器 ...........................................23-122数据,时间 ...........................................23-113数据存储方法 ........................................23-119数据的显示格式 ......................................23-30数据使用容量 ........................................23-110组列表 .....................................................23-37采样设置 ........................................................18-11采样数据 ........................................................24-31采样数据显示器 ...........................................23-102操作时间表 .......................................................22-1操作数 .......................................5-170, 28-5, 28-65操作数设置 .....................................................28-65插入逻辑指令 .................................................28-50查找 ...............................................................5-119查找和更换 .......................................................5-73重叠图片 ...................................................9-8, 9-11初始化存储器 ......................................20-88, 20-89触发操作 .........................................................A-57触发条件 ........................................................20-43触摸,两次 .....................................................10-28处理中 ............................................................14-74传输配方 .............................................24-47, 24-53传输工具 ........................................................32-56安装 ........................................................32-68安装要求 .....................................................3-5传输工程文件 ...................................................32-6传输设置 ........................................................32-59串口操作 ........................................................20-92串口端口操作 .................................................20-57窗口显示 ..........................................................12-7创建 ..........................................................12-4切换 ........................................................12-11在一个画面上显示多个 ...........................12-30窗口边框 ......................................................37-160窗口部件 ........................................................12-21窗口画面 ......................................................19-149从CF卡到U盘 ..............................................A-83从U盘到CF卡 ..............................................A-83从多个GP的执行外部操作 ..........................19-157从模板中选择画面 ............................................8-72从其他工程复制 .............................................5-104从外部存储器上下载 ......................................32-36存储器循环 ........................................................20-82操作 ........................................................20-73存储器限制 ...................................................28-123存储设备上的可用空间 ...................................11-26错误检查 .............................................5-106, 5-173 DDirect Access法 ......................7-7, 7-8, 11-25, A-4Direct Access法 + Memory Link法 ............7-8, 7-9 Direct Access和Memory Link一起使用 ........A-39 DRAM ..........................................................23-110 D脚本 ..............................................................20-2 D脚本编程 .......................................................20-2打印布局 ..........................................................33-8当前画面 .................................................33-20工程设置 .................................................33-40简介 ..........................................................33-4批打印 .....................................................19-73取消 ........................................................33-30实时打印 .................................................19-73打印格式 ........................................................19-74打印功能 ........................................................33-12打印机连接 ........................................................33-12配置 .............................................33-14, 33-18打印机操作 ...................................................20-126打印机类型 .....................................................33-11单色16级 .........................................................8-39 LCD ..........................................................8-39地址转换多个 ...................................................5-40地址操作 ........................................................24-94地址格式 ........................................................28-31地址监控 ......................................................28-104地址块显示 .....................................................18-24地址块转换 .....................................................5-100地址列表显示 ..........................................................5-32确认 ..........................................................5-31地址设置 ........................................................5-110地址刷新 ......................................................28-131地址转换图案,更改设备类型 ..........................7-21调用函数 ........................................................20-55调用和显示图片 ...............................9-4, 9-10, 9-15调用画面 .................................................8-62, 8-63读取文件 ......................................................20-121读取区,内部寄存器 ......................................18-72对象编辑 ..........................................................8-26对齐 ..........................................................8-34翻转 ..........................................................8-36放大/缩小 ................................................8-28复制 ..........................................................8-29取消组合 ...................................................8-32移动 ..........................................................8-28组合 ..........................................................8-32旋转 ..........................................................8-35对齐行 .....................................17-62, 17-63, 17-65居中 .............................................17-63, 17-64固定位置 .................................................17-62对齐到网格 .......................................................8-99多功能 .................................................10-36, 10-75多语言 .................................................17-15, 17-24FFTP服务器 ....................................................5-189发送数据 ........................................................32-66反映在控制器/PLC中 ....................................11-16放置包中注册的图片 ........................................8-65分辨率,转换 ......................................5-104, 5-128分层画面切换 .................................................11-21分支 ...............................................................28-48分支,插入 .....................................................28-41蜂鸣器 ..............................10-50, 25-1, 25-7, 25-10符号 ......................................................5-51, 28-13符号变量 ...............................5-177, 28-13, 28-123符号变量,导入/导出 ...................................28-27复制存储器 ..........................................20-78, 20-81复制工具 ......................................................37-169富文本文件 .......................................................33-4 GGP-Pro EX .........................................................1-2 GP-PRO/PBIII for Windows ...............................2-2 GP到PC接收工程文件 .................................32-9, 32-18 GP开机时的默认画面显示,选择 ....................11-7工具栏,自定义 ...............................................28-6工程文件备份 ..........................................................5-23创建 ............................................................5-9设置 ............................................................5-9工程信息查看 ..........................................................5-43工程转换器 .......................................................2-12工作区 ............................................................5-108固定别针 ...............................................5-117, 8-38观察列表 ......................................................28-157光标形状 ......................................................19-134归档 .................................................................33-4滚动报警显示 .................................................19-79滚动报警消息 ...................................................19-8 HHMI系统变量(#H系统变量) ........................A-109行,插入 ........................................................28-41函数名 ............................................................20-61互锁 ...............................................................10-19互锁触摸操作控制 ..........................................14-24互锁设置 ........................................................21-24画面保存显示的画面 ......................................11-18复制 ..........................................................5-69画面显示正在关闭 ...................................34-7, 34-9画面,切换 .....................11-4, 11-10, 11-13, 11-21画面捕捉 .................................5-190, 11-18, 11-26画面捕捉,JPEG文件 ..................................11-18画面各部分的名称 ............................................5-84画面列表 ........................................................5-115画面信息 ........................................................5-180画面属性更改 ...................................................5-67画面数据列表窗口 ..........................................5-118画面颜色,更改 ................................................5-66绘图 ....................................................................8-1绘制矩形 ..........................................................8-10按像素 .........................................................8-7标尺 ..........................................................8-18表格 ..........................................................8-20多边形 .......................................................8-16弧/饼形 ....................................................8-14圆/椭圆 ....................................................8-12直线/折线 ..................................................8-8 IIPC设置 .......................................................37-152 JJPEG文件,画面捕捉 ...................................11-18基本操作 ............................................................5-1监控步 ............................................................5-171兼容性 ................................................................2-2键盘系统 ........................................................15-20弹出式 ............................................15-3, 15-37设置 .................................................15-3, 15-6用户 ........................................................15-22用户创建的 ................................................15-9注册 ........................................................15-23交叉参考 ...............................................5-32, 5-103脚本 ................................................................5-166编程 ........................................................20-55创建 ........................................................20-23创建全局 .................................................20-39错误代码列表 ..........................................20-63打印自 .....................................................20-21函数摘要 .................................................20-27扩展,结构 ..............................................20-22全局D脚本 .............................................20-50运算 ..........................................................20-5主函数 .....................................................20-27脚本设置 ........................................................5-163接收数据 ........................................................32-67 KKanji转换 ............................................15-28, 15-40开关 ..................................................................10-1位 ............................................................10-45选择 ........................................................10-72标签 ........................................................10-55单选 ........................................................10-38切换画面 .................................................10-62特殊 ........................................................10-63颜色更改 .................................................10-31字 ............................................................10-59开关指示灯 .....................................................10-42开始操作的工作流程 ...................................4-2, 4-3可用地址 ....................................................A-4, A-7控制器/PLC ...................................................5-160控制器/PLC系列的设置 ..................................5-89控制器/PLC系统数据区分配 ..........................A-23控制器/PLC,更改 .................................7-16, 7-26控制字地址,保存至CF卡 ............................19-59 LLS区 .................................................................A-8蓝色LCD .........................................................8-39历史数据 ........................................................18-15连接多台PLC ....................................................7-7两次触摸 ........................................................10-28逻辑系统变量(#L系统变量) .......................A-90逻辑程序,纠正错误 ......................................28-85逻辑程序数量限制 ........................................28-123逻辑存储器 ...................................................28-121逻辑存储器的验证方法 .................................28-121逻辑监控 ......................................................28-101逻辑监控,启动和停止 ...................................28-99逻辑图监控 ......................................................A-45逻辑运算示例 ...............................................20-162逻辑指令 ......................................................28-114逻辑指令图标列表 ............................................28-8 MMemory Link法 ......................................11-25, A-6 Memory Loader ..................................32-36, 32-63脉冲 ...............................................................28-70每画面的功能数 .............................................5-184每画面的数据容量 ..........................................5-184密码......................5-27, 5-95, 5-96, 28-134, 32-31编辑 ..........................................................5-28删除/更改 ..............................................32-34命令和状态 .....................................................19-59模板注册 ........................................................5-182 N内部寄存器到数据缓冲器 .............................20-151内部设备地址 .............................................A-5, A-7 PPC到GP发送工程文件 .................................32-6, 32-13使用调制解调器传输画面数据 .................32-48 PC工程模拟 ....................................................31-1 PC上的工程模拟 .............................................31-1 PID监控 .......................................................28-153 PLC与多台控制器通讯 .......................................7-1配方CSV格式 ................................................24-10 CSV数据 .........................24-10, 24-18, 24-26保存至CF卡 ..........................................24-11传输 .................................24-47, 24-53, 24-68传输CSV数据 ..........................................24-3传输配方数据 ............................................24-3概述 ..........................................................24-2配方数据 .................................................24-43设置 ........................................................24-57数据 ........................................................24-31数据,传输 ..............................................24-64配方数据传输 ...............................24-47, 24-53, 24-107流 ..............................................................24-5容量 ......................................................24-108偏移地址计算示例 ........................................20-165屏幕保护程序 ..........................................34-1, 34-7 Q启用系统区 ..........11-12, 11-17, 12-20, 25-9, 25-12切换显示 ........................................................12-17切换画面 .............................................11-10, 11-13切换基本画面 .................................................19-36切换视图 ........................................................5-181强制画面切换 ...............................A-12, A-14, A-29清除区 .................................................15-26, 15-39全局窗口 ...............................................12-4, 12-14全局互锁 .............................................21-10, 21-25 R日期/时间显示 ..............................................14-92日语FEP ........................................................15-40软件包内容 .........................................................3-2 SSRAM ............................................................19-80 SRAM,注意事项 ..........................................5-190 SRAM备份 ..................................................23-109 SRAM备份,关于 .......................................24-108 STN伪彩LCD .................................................8-39扫描时间 ...........................28-124, 28-127, 28-158删除文件 ......................................................20-125上传到外部存储器 ...............................32-36, 32-42闪烁,设置 .......................................................8-46设备访问API .....................................37-88, 37-168设备监控 .........................................................A-43设备支持的功能列表 ..........................................1-5声音选项 ........................................................10-50时间,调节 ..............................................34-1, 34-3时间表 ...................................................22-1, 22-10实时视频 ..........................................................26-8矢量字体 ............................................................6-3使用逻辑 ..........................................................28-3使用其他语言绘制 ...........................................A-72事件记录器 ..........................................26-22, 26-86视频 ..................................................................26-1故障前后 .................................................26-20录制 ..........................................................26-1视频控制区,使用示例 .................................26-133首选设置 ........................................................5-165输出文件列表 ...............................................20-123输入启用 .................................14-52, 14-55, 14-82顺序 ........................................................14-31许可 ........................................................14-85输入代码表 .......................................................8-93输入设备设置 .................................................16-24输入顺序功能 ...............................................14-105属性 ...............................................................5-117属性,更改 .......................................................8-31数据显示 ..........................................................14-1保存模式 ...............................................20-110比较 ........................................................10-16写 ............................................................10-10范围,防止输入超出允许范围的数据 ......14-28更改值 .....................................................14-34缓冲器到内部寄存器 .............................20-153加 ............................................................10-13减 ............................................................10-13输入 ..........................................................14-1数据显示器 .....................................................14-38数据采样 ..........................................................23-1数据块显示显示/清除图表 .......................................18-27数据块显示图结构 ..........................................18-71数据块,复制 .................................................20-12数字显示 ........................................................14-40搜索存储器 .....................................................20-84缩放框 ..............................................................5-86索引文件 ......................................................24-100 TTFT真彩LCD ..................................................8-39 Time-Base .....................................................14-65特殊继电器 .............................................A-20, A-35特殊数据显示器 .............................................24-72替换 .................................................................5-73条形码阅读器 ................................16-2, 16-4, 16-5条件表达式 ...................................................20-136分支计算示例 ........................................20-164条件表达式 .....................................................20-45条件操作 ........................................................24-91条件名称查找功能 ..........................................24-99调色板 ..............................................................8-42调试 .................................................................33-4调试函数 ......................................................20-131停止通讯 ..........................................................7-11通讯错误代码 ..................................................A-22概述 ...........................................................A-2周期时间 ..................................................A-22通讯状态,确认 ...............................................7-13通过USB电缆传输 ..........................................32-5通过以太网(LAN)传输 ..................................32-12通用设置 .............................................5-112, 5-174统计数据显示器 .............................................14-95透明部件 .................................10-43, 14-39, 18-29图形 ...................................................................8-6图像字体 ..........................................................6-14图案,设置 .......................................................8-48图表部件设置 .................................................18-29历史趋势 .................................................18-45普通 ........................................................18-30数据块显示 ..............................................18-67统计 ........................................................18-39仪表 ........................................................18-41图片显示器 ..........................................9-22, 19-147图片注册 ..........................................................9-20退出WinGP ...................................................37-26 UUltra VNC服务器,RPA .................................35-7 USB存储器 .........................................5-188, 5-189保存注意事项 ........................................23-143 USB存储器,保存至注意事项 .................................................19-61 USB存储器操作说明 ...................................23-144 V 2003 程序 .........................................37-57 VNC服务器,RPA ..........................................35-7 WWindows XP Embedded ................................37-11 WinGP .............................................................37-2 API ..........................................................37-34 SDK ........................................................37-13 2003程序示例 ............................37-39 VB6程序示例 .........................................37-65读取VB中的文本 .................................37-119读取或写入数据 ......................................37-38禁止两次调用API .................................37-118启动 ........................................................37-26软件使用授权密钥码 .................................37-2运行应用 .................................................37-71专用API ..................................................37-56 WinGP,退出 ...............................................20-135外围控制器列表 ..............................................5-157网格,设置 .......................................................8-69位逻辑系统变量 ...............................................A-90位运算示例 ...................................................20-163位置点,显示 ...................................................9-48位状态16 ............................................................13-135 ................................................................13-8文本显示区 ..............................17-62, 17-63, 17-64表设置 .....................................................17-51操作 ......................................................20-146运算错误状态 ........................................20-154注册 ........................................................17-49文本显示器 .....................................................14-77文本报警 ......................................................19-140文本列表 ......................17-15, 17-24, 17-31, 17-36文本设置 ..........................................................8-94文本数据模式 .................................................5-161文件管理器简介 ........................................................24-86文件名,更改 ...............................................20-116。
数据穿越功能指南1简介 (2)2安装 (6)3设置 (15)4错误消息 (19)5附录 (20)1简介1.1什么是数据穿越功能?当使用梯形图软件等Windows应用程序通过串行接口与外接控制器进行通讯时,需要将梯形图软件和外接控制器进行串行连接。
示例)1. 装有梯形图软件的PC2. 准备与之通讯的外接控制器3.串行接口在GP-Pro EX上,使用数据穿越功能可允许通过一台显示设备来实现梯形图软件和外接控制器之间的通讯。
示例)1. 装有梯形图软件的PC2. 准备设置的外接控制器3. 连接串口的显示设备4. USB传输电缆或以太网(UDP)连接5. 外接控制器连接电缆使用数据穿越功能,无需连接电缆即可用梯形图软件更改外接控制器的设置。
使用WinGP 时,在一台PC 上安装WinGP 和梯形图软件,可按以下配置使用数据穿越功能。
示例)1. 装有WinGP 和梯形图软件的PC 。
2. 准备设置的外接控制器3. 外接控制器连接电缆)"3.1.2 使用数据穿越功能设置工具进行设置" (第17页)1.2数据穿越功能的原理数据穿越功能是实现PC上的虚拟端口与外接控制器上的串口进行通讯的一种机制。
下文中将PC上的虚拟端口称为“虚拟串口”。
示例)通过在梯形图软件的通讯设置中设置虚拟串口“端口1'”,可使系统在运行时就好像连接了外接控制器的“端口1”一样。
要完成这一操作,需要用到数据穿越功能设置工具、虚拟串口总线驱动程序和虚拟串口驱动程序。
1. 外接控制器上的串口:端口1。
2. 下文中将PC上的虚拟端口称为“虚拟串口”。
数据穿越功能设置工具和虚拟串口总线驱动程序、虚拟串口驱动程序提供以下功能。
•在PC上建立端口1':虚拟串口驱动程序•关联端口1'与端口1:数据穿越功能设置工具•在端口1'与端口1之间交换数据:虚拟串口总线驱动程序数据穿越功能可允许您使用已建立的虚拟串口与外接控制器进行通讯。
GP1/GP2 INSTALLATION & MAINTENANCE INSTRUCTIONSDESCRIPTION / IDENTIFICATIONThe GP series control valve is an electronic pressure regu-lator designed to precisely control the pressure of gaseous media proportional to an electronic signal.The GP1 operates using two normally closed solenoid valves, a pressure sensor, and a control circuit. One valve is actuated to allow unregulated supply media into the sys-tem. The second valve is actuated to allow working media to vent to atmosphere. The pressure sensor provides feed-back to the control circuit. The control circuit comparesthe pressure sensor feedback to the user supplied electronic command signal and actuates the appropriate valve until the two signals match.The GP series can be teamed with a variety of one-to-one ratio high pressure volume boosters for even greater flow. When using a volume booster, the GP2 can be used toachieve accuracy similar to the GP1 alone with higher flow capacity.GP series product comes with a monitor output signal. This output is an electrical signal originating from the inter-nal sensor used in the control circuit of the GP1 valve. On GP2 units this signal originates from the external trans-ducer. This allows the system parameters to be monitored and provides a signal for data acquisition needs.The output of this signal can be configured to either 0-10Vdc or 4-20mA.The GP2 is similar to the GP1 but uses a double loop con-trol scheme. In addition to the internal pressure transducer, the GP2 also receives a 0-10Vdc feedback signal from an external sensing device. The external signal functions as the primary feedback and is compared to the command sig-nal. A difference between the two comparisons causes one of the two solenoid valves to open allowing flow in or out of the system.A Proportion-Air DSY or DSTY will work as a second loop feedback to the GP2 (See ordering information).The GP series has several other beneficial features. An on board split power supply allows true zero for command and monitor even though the GP is powered by a conventional single ended power supply. The GP utilizes advanced on board power management hardware to minimize current draw and heat build up. The GP also features status indi-cating LEDs for power and TTL. The TTL signal is a con-ditional on/off signal to use for diagnostic purposes. This signal is LOW when the pressure is within 1% of final set-ting.• Description & identification • General specifications • Connection procedure • Re-calibration procedure • Repair procedure•Dimensions, ordering and accessoriesBefore you get started, please read these warnings:♦ Examine the product. Ensure that you received what you ordered. ♦ Read this guide first before you start and save it for later use.♦ You must have a good understanding of what the adjustments are on this product before using them.♦All compressed air and power should be shut off before installing, removing or performing maintenance on this prod-uct.♦ Installation and use of this product should be under the supervision and control of properly qualified personnel inorder to avoid the risk of injury or death.e s y of C M A /F l o d y n e /H y d r a d y n e ▪ M o t i o n C o n t r o l ▪ H y d r a u l i c ▪ P n e u m a t i c ▪ E l e c t r i c a l ▪ M e c h a n i c a l ▪ (800) 426-5480 ▪ w w w .c m a f h .c o mGENERAL SPECIFICATIONS & PERFORMANCE CHARACTERISTICSELECTRICALMINIMUM TYPICAL MAXIMUM Supply Voltage Supply Current Command Signal VoltageCurrent Command Signal Impedance Voltage Current Analog Monitor Output Voltage Current (Sourcing) TTLSatisfied Not-Satisfied 2nd Loop Input 15VDC100mADC (standbystate) 0VDC 4mADC- - 0VDC 4mADC- - 0VDC - - - - 10K Ω 100Ω - - 0VDC 5VDC - 24VDC985mADC (operating)10VDC 20mADC- - 10VDC 20mADC- - 10VDCPNEUMATIC MINIMUM TYPICAL MAXIMUM Input PressurePressure Range Flow RateFiltration Required Accuracy (Pressure) Accuracy (Monitor) Hysteresis/Linearity Repeatability Port Size (all) Critical Volume VacuumVacuum 0 SCFM (0 m³/hr)40 micron ±0.1%F.S.- 0%F.S. - - - 110% of full scalecalibration-5 SCFM (8.5 m³/hr)20 micron ±0.25%F.S. ±0.3%F.S. ±0.2%F.S. ±0.05%F.S. 1/8 inch NPT female3 in³1100 psig (75.84 bar)1000 psi (68.95 bar) 10 SCFM (17 m³/hr)- ±0.5%F.S. ±0.5%F.S. ±0.5%F.S.Depends on Hysteresis- -(Note 1)(Note 2)(Note 3)(Note 4)PHYSICALMINIMUM TYPICALMAXIMUM Operating Temperature Environment Protection WeightElectrical Connector32ºF (0ºC)- - -- -3.75 lbs (1.75 kg)6 pin molded 16 gauge wire158ºF (70ºC) NEMA 4/IP65- -(Note 5) (Note 6)(Note 1) Pressure ranges are customer specified.(Note 2) Pressure range up to 250 PSI (17.24 BAR) may be ordered as PSIG or PSIA. Pressure range above 251 PSI (17.3 BAR) may be ordered as PSIS or PSIA.(Note 3) User adjustable(Note 4) The minimum downstream closed volume is determined by the pressure range, orifice size, hysteresis window, plumbing, aswell as other factors. Consult factory for small volume applications. (Note 5) CE approval pending(Note 6) Depends on density of manifold materialLINEARITY12345678910Command [Volts]0102030405060708090100P r e s s u r e [% o f s c a l e ]Fig 1Times for GP to fill/exhaust a closed chamber. Step command signal Fig 2% o f S c a l eTime (seconds)Volume = 5 cu.in. [82mL]e s y of C M A /F l o d y n e /H y d r a d y n e ▪ M o t i o n C o n t r o l ▪ H y d r a u l i c ▪ P n e u m a t i c ▪ E l e c t r i c a l ▪ M e c h a n i c a l ▪ (800) 426-5480 ▪ w w w .c m a f h .c o mGP CONNECTION PROCEDURE Electrical connections:1. Ensure all power is off before making any electricalconnections. 2. Figure 2 shows the location of the GP electrical con-nector and figure 3 shows the connector. Table 2 iden-tifies the color codes Note: Both current and voltage command units require that both the command (+) and command (–) pins be connected.3. See figure 4 and 5 for second loop connections.Pneumatic Connections:1. A typical 20 micron (minimum 40 micron) in-linefilter is recommended on the inlet of the GP. 2. Connect supply pressure to the “I” inlet port (figure 1)not to exceed rated supply pressure. (Table 1) 3. Connect one of the “O” outlet port (figure 1) to thedevice being controlled and plug the unused one. 4. Proceed with electrical connection.MAX calibrated pressure of:Max inlet pressure is:Vacuum up to 15 psig (Vac. to 1.03 bar) 30 psig (2.07 bar) 16 up to 30 psig (1.1 to 2.07 bar) 60 psig (4.14 bar) 31 up to 50 psig (2.14 to 2.45 bar) 100 psig (6.89 bar) 51 up to 100 psig (3.52 to 6.89 bar) 200 psig (13.79 bar) 101 up to 250 psig (6.96 to 17.24 bar) 500 psig (34.47 bar) 251 up to 500 psig (17.31 to 34.47 bar)600 psig (41.37 bar)501 up to 1000 psig (34.54 to 68.95 bar) 1100 psig (75.84 bar)TABLE 1RATED PRESSURE FOR GP VALVESTABLE 2WIRE COLOR*FUNCTION WHITE COMMAND (+) RED ANALOG OUTPUT GREEN DC COMMON ORANGE TTL OUT BLACK 15-24 VDC POWER BLUECOMMAND (-)e s y of C M A /F l o d y n e /H y d r a d y n e ▪ M o t i o n C o n t r o l ▪ H y d r a u l i c ▪ P n e u m a t i c ▪ E l e c t r i c a l ▪ M e c h a n i c a l ▪ (800) 426-5480 ▪ w w w .c m a f h .c o me s y of C M A /F l o d y n e /H y d r a d y n e ▪ M o t i o n C o n t r o l ▪ H y d r a u l i c ▪ P n e u m a t i c ▪ E l e c t r i c a l ▪ M e c h a n i c a l ▪ (800) 426-5480 ▪ w w w .c m a f h .c o mREPAIR PROCEDURE:1.) Disassemble GP unit:A. Remove the two 8-32 flat head screws and o’rings on the GP lid. Figure 7B. Unplug main connector wires and LED wires from the board. Figure 8C. Remove lid, lid o’ring and can assembly from manifold . Figure 9D. Unplug valve and sensor wires from board. Figure 8E. Remove the two 8-32 SHCS screws and o’rings from manifold to remove both the regular tall standoff and the boardstandoff. Figure 10F. Of each valve assembly, remove hex nuts and disassemble valve tube from coil and valve housing. (Keep coil washer,valve housing and hex nut because they are not included in the repair kit and can be reused) Figure 14G. Using span wrench (figure 11) , remove valve tube from manifold cavity.H. Remove poppet and o’ring spacer from manifold. See figure 12 for o’ring spacer location and figure 14 for valve ori-entationI. If sensor needs to be replaced, unthread sensor from manifold. See figure 13 for sensor locationFIGURE 10FIGURE 8LEDesyofCMA/Flodyne/Hydradyne▪MotionControl▪Hydraulic▪Pneumatic▪Electrical▪Mechanical▪(8)426-548▪www.cmafh.comFIGURE 14e s y of C M A /F l o d y n e /H y d r a d y n e ▪ M o t i o n C o n t r o l ▪ H y d r a u l i c ▪ P n e u m a t i c ▪ E l e c t r i c a l ▪ M e c h a n i c a l ▪ (800) 426-5480 ▪ w w w .c m a f h .c o mPROPORTION-AIR, INC. BOX 218 MCCORDSVILLE, IN USA 46055PHONE: (317)335-2602 FAX: (317)335-3853Proportion-Air products are warranted to the original purchaser only against defects in material or workmanship for one (1) year from the date of manufac-ture. The extent of Proportion-Air's liability under this warranty is limited to repair or replacement of the defective unit at Proportion-Air's option. Pro-portion-Air shall have no liability under this warranty where improper installation or filtration occurred.All specifications are subject to change without notice. THIS WARRANTY IS GIVEN IN LIEU OF, AND BUYER HEREBY EXPRESSLYWAIVES, WARRANTIES OR LIABILITIES, EXPRESS, IMPLIED OR STATUTORY, INCLUDING WITHOUT LIMITATION ANY OBLI-GATION OF PROPORTION-AIR WITH REGARD TO CONSEQUENTIAL DAMAGES, WARRANTIES OF MERCHANTABILITY, DE-SCRIPTION, AND FITNESS FOR A PARTICULAR PURPOSE.............................................................................................................................................................................................................WARNING: Installation and use of this product should be under the supervision and control of properly qualified personnel in order to avoid the risk of injury or death.e s y of C M A /F l o d y n e /H y d r a d y n e ▪ M o t i o n C o n t r o l ▪ H y d r a u l i c ▪ P n e u m a t i c ▪ E l e c t r i c a l ▪ M e c h a n i c a l ▪ (800) 426-5480 ▪ w w w .c m a f h .c o m。
GP常用命令整理Greenplum日常简明维护手册1.数据库启动:gptart常用参数:-a:直接启动,不提示终端用户输入确认-m:只启动mater实例,主要在故障处理时使用访问单个数据实例:PGOPTIONS='-cgp_eion_role=utility'pqltemplate1-p5432启动某个egmentintance:pg_ctltop/tart-D/datadir/取端口号:elect某fromgp_egment_configuration启动以后会在/tmp/下生成一个.lock隐藏文件,记录主进程号。
2.数据库停止:gptop:常用可选参数:-a:直接停止,不提示终端用户输入确认-m:只停止mater实例,与gptart–m对应使用-f:停止数据库,中断所有数据库连接,回滚正在运行的事务-u:不停止数据库,只加载pg_hba.conf和potgreql.conf中运行时参数,当改动参数配置时候使用。
连接数,重启3.查看实例配置和状态elect某fromgp_egment_configurationorderbycontent;elect某frompg_filepace_entry;主要字段说明:Content:该字段相等的两个实例,是一对P(primaryintance)和M(mirrorIntance)Iprimary:实例是否作为primaryintance运行Valid:实例是否有效,如处于fale状态,则说明该实例已经down 掉。
Port:实例运行的端口Datadir:实例对应的数据目录1.gptate:显示Greenplum数据库运行状态,详细配置等信息常用可选参数:-c:primaryintance和mirrorintance的对应关系-m:只列出mirror实例的状态和配置信息-f:显示tandbymater的详细信息该命令默认列出数据库运行状态汇总信息,常用于日常巡检。
GP系列操作指南一、GP系列测温系统的连接1 系统组成A GP表B 可连接的探头:CI3、GPR、GPS、GPM、MI、TX系列2 连接参照操作手册的接线表连接各种类型的探头和输入类型二、设置参数1A 在显示温度数值时按住 I 键,再按住△键,然后同时放开此时显示内容:H00X ;X—1、2、3、4、5、6B 选择探头类型(或输入类型)按△键选择H001=GPR(GPS)探头H002=GPM探头(MI探头)H003=CI3探头H004=0-5V输入H005=4-20m A输入(TX探头)H006=热偶输入C 不同类型探头的进一步设置H001按I 键设置小数点位此时显示d--x ;X— 0,1按△或▼键关闭(0)或使能(1)小数点位(例如888.8),按一下I键回到温度显示;H002按I 键设置小数点位此时显示d--x ;X— 0,1按△或▼键关闭(0)或使能(1)小数点位(例如888.8),按一下I键输入探头的D值,再按一下I键输入探头的R值,再按一下I键回到温度显示;H003没有该项设置,按一下I键回到温度显示;H004/H005按I 键设置小数点位此时显示d--x ;X— 0,1,2,3,4按△或▼键选择小数点位d=0 关闭小数点位;d=1 小数点在个位位置(例如8888.);d=2小数点在十位位置(例如888.8);d=3小数点在百位位置(例如88.88);d=4小数点在千位位置(例如8.888);另外:对H004按一下I键,设置0V输入时对应的温度值,再按一下I键,设置5V输入时对应的温度值,再按一下I键回到温度显示;对H005按一下I键,设置4mA输入时对应的温度值,再按一下I键,设置20mA输入时对应的温度值,再按一下I键回到温度显示;H006按I 键设置小数点位此时显示d--x ;X— 0,1按△或▼键关闭(0)或使能(1)小数点位(例如888.8),按一下I键设置热偶的输入类型此时显示TC-x ;X— 1,2,3,4,5,6,7按△或▼键选择TC=1 J型热偶;TC=2 K型热偶;TC=3 E型热偶;TC=4 N型热偶;TC=5 R型热偶;TC=6 S型热偶;TC=7 T型热偶;按一下I键回到温度显示;2 设置发射率按I 键到显示EX.XX ; X.XX:0.10-1.09按△或▼键输入发射率值,按I键到其它参数设置项或回到温度显示;3 1和2A 使能或关闭报警功能按I 键到显示S1-X 或S2-X ; X— 0,1按△或▼键关闭(0)或使能(1)报警功能;B 输入报警温度值按一下I键,按△或▼键输入温度值;C 设置温度触发方式和输出方式按一下I 键到显示b--X ; X— 0,1,2,3再按△或▼键选择b=0 温度低于设定值时输出高电平,平时输出低电平;b=1温度高于设定值时输出高电平,平时输出低电平;b=2温度低于设定值时输出低电平,平时输出高电平;b=3温度高于设定值时输出低电平,平时输出高电平;注:面板指示灯“O”、“N”、“L”显示当前的温度状态(高于、正常或低于设定的温度点);D 设置死区温度值按一下I 键到显示d00X ; X≥1按△或▼键输入相应数值;4 设置4-20mAA按I 键直到显示“Lo”,再按I 键到4mA对应的温度值,按△或▼键输入需要的温度数值;B 设置20mA模拟输出对应的温度值按I 键直到显示“Hi”,再按I 键到20mA对应的温度值,按△或▼键输入需要的温度数值;设定完毕后,按I 键直到温度显示模式;5 设置温度单位A按I 键直到显示“C 1”,按△或▼键击活“1”或撤消“0”℃温度单位;B 设置℉温度单位按I 键直到显示“F 1”,按△或▼键击活“1”或撤消“0”℉温度单位;设定完毕后,按I 键直到温度显示模式;6 设置峰值保持/谷值保持/平均值时间A 设置峰值保持按住▼键,再按 I 键,然后同时放开,显示“PH”;再按 I 键显示当前的峰值保持时间(秒);按△和▼键输入要设定的时间值;注:000值时关闭峰值保持。
Greenplum 日常简明维护手册1. 数据库启动:gpstart 提示选择Y…常用参数: -a : 直接启动,不提示终端用户输入确认-q : 不希望屏幕输出-m:只启动master 实例,主要在故障处理时使用-R:只启动数据库在受限模式,禁止非超级用户登陆.-y:启动数据,但不启动standby启动完毕可使用gpstate查看数据库状态2. 数据库停止:gpstop 提示选择Y…常用参数:-a:直接停止,不提示终端用户输入确认-m:只停止master 实例,与gpstart –m 对应使用-f(-m faster):停止数据库,中断所有数据库连接,回滚正在运行的事务-u:不停止数据库,只加载pg_hba.conf 和postgresql.conf中运行时参数,当改动参数配置时候使用。
关闭完毕后可使用gpssh控制所有服务器查看postgres进程是否已经都不存在,下面命令显示为1则表明数据库所有进程已经关闭完毕.gpadmin@dsszbyz-dw6-mst01:~> gpssh -f host_all=> ps -ef|grep postgres |wc -l[ sdw1] 1[sdw2] 1[ mdw] 1[ sdw3] 1[ smdw] 1[ sdw4] 1[ ftp1] 1=>exit3. 登陆数据库:psql登录数据库方式:psql –d 数据库名–u 用户名可以先使用psql -d template1登陆默认实例,然后使用select * from pg_database;查看已经安装的数据库名,然后登陆相应数据库。
退出psql 使用\q.使用应用模式访问单个数据实例():PGOPTIONS='-c gp_session_role=utility' psql template1 -p 54324. 查看实例配置和状态:gpstate常用参数:-c:显示primary instance和mirror instance的对应关系-m:显示mirror的状态-f:显示standby的状态(是否配置,是否同步)-e:显示错误节点的详细信息。
2使用GP-Pro EX本章包括兼容性、工程转换以及如何找到软件和文档更新。
兼容性和工程转换适用于从GP-Pro/PBIII转换到GP-Pro EX的工程。
2.1与其它Pro-face软件的兼容性........................................................................2-22.2如何更新软件.................................................................................................2-222.1与其它Pro-face 软件的兼容性本节描述如何操作Project Converter ,其功能是将由Pro-face 的GP-PRO/PBIII for Windows 应用程序创建的工程文件(*.prw)转换为GP-Pro EX 工程文件(*.prx)。
本节还强调了有关兼容性的重要信息。
2.1.1兼容的软件版本Project Converter 可转换由GP-PRO/PBIII for Windows 软件1.0版至7.0版所创建的工程文件(*.prw)的数据。
2.1.2转换前后的型号名称转换完成后,在GP-PRO/PBIII for Windows 工程文件(*.prw)中表示型号的[GP 机型]在GP-Pro EX 中显示为[人机界面类型]。
型号名也可能更改。
兼容的型号包括GP70/77R/2000、GLC 系列、LT 系列和ST400系列。
•有关GP-PRO/PBIII for Windows 和GP-Pro EX 之间的兼容性及限制的信息,请参阅Pro-face 支持网站“Otasuke Pro!”。
•转换由GP-PRO/PBIII for Windows软件7.1和7.2版所创建的工程文件(*.prw)时将不包括每个软件版本上的新增功能。
目录EX370GP可编程文本显示器 (1)第一章产品概述 (1)1.1功能 (1)1.2一般规格 (1)1.3各部分名称 (2)1.4外型尺寸及安装方法 (4)第二章编辑软件EX20 (5)2.1 EX370GP基本概述 (5)2.2编辑用户画面 (5)2.3保存工程 (32)2.4下载画面 (33)2.5 导入旧工程 (33)第三章操作方法 (35)3.1联机通讯 (35)3.2切换画面 (35)3.3系统口令 (35)3.4修改数据 (36)3.5开关量控制 (37)第四章与PLC的连接方法 (38)4.1三菱FX系列 (38)4.2西门子S7-200系列 (39)4.3欧姆龙C系列 (39)4.4施耐德NEZA/TWIDO系列 (40)4.5 台达DVP系列 (41)4.6松下FP系列 (42)4.7 LG Master-K CNet系列 (43)4.8 LG系列Modbus 协议 (43)4.9 LG Master-K 120S 编程口通讯 (44)4.10 FACON永宏系列 (45)4. 11 光洋S系列 (46)4.12 ECOSTEP 系列 (47)4.13 AB Micrologix系列 (48)4.14 MODBUS RTU/ASCII/EMERSON/RTU EXTEND (49)4.15 MODBUS SERVER (50)4.16 自由协议 (51)4.17 SAIA PCD S-BUS协议 (52)4.18 丰炜VIGOR PLC (53)4.19 EMERSON EC20系列PLC (53)4.20 KEYENCE KV系列PLC (55)4.21 Haiwell PLC系列PLC (55)4.21 和泉IDEC PLC (57)EX20 V4.8.0 组态软件Release Note (58)附录1:自由协议文档 (63)附录2:其它注意事项 (65)第一章产品概述1.1功能EX370GP是一个小型的人机界面,主要与各类PLC(或带通信口的智能控制器)配合使用,以文字或指示灯等形式监视、修改PLC内部寄存器或继电器的数值及状态,从而使操作人员能够自如地控制机器设备。
GP管理手册GP管理手册1:公司概述1.1 公司背景1.2 公司使命和价值观1.3 组织结构1.4 公司目标和策略2:组织管理2.1 高层管理团队2.2 决策流程2.3 职责和权限分配2.4 职位描述和绩效评估2.5 内部沟通和协作3:人力资源管理3.1 招聘和录用3.2 培训和发展3.3 绩效管理3.4 薪酬和福利3.5 员工关系和离职管理4:运营管理4.1 产品开发4.2 供应链管理4.3 生产管理4.4 质量控制4.5 仓储与物流5:财务管理5.1 预算编制和执行5.2 资金管理5.3 财务报告和分析5.4 税务合规6:销售与市场营销6.1 销售策略6.2 市场定位和竞争分析6.3 产品定价6.4 销售渠道和分销6.5 客户关系管理7:信息技术管理7.1 IT基础设施7.2 系统开发和运维7.3 数据安全和网络保护 7.4 技术支持和用户培训 7.5 信息系统规划和战略8:企业风险管理8.1 风险识别和评估8.2 风险控制和监测8.3 应急预案和灾难恢复 8.4 合规要求和法规遵循 8.5 保险和风险转移9:维护和更新9.1 文件管理和版本控制9.2 定期审查和更新9.3 培训和沟通附件:1:组织结构图3:薪酬福利政策4:产品开发流程图5:销售报告样本6: IT系统架构图7:企业风险评估表格法律名词及注释:1:合规要求 - 法律、法规、政策等对企业经营活动提出的规范要求2:法规遵循 - 企业必须遵守的法律规定的行为准则3:保险和风险转移 - 通过购买保险来转移经营风险的方式4:风险控制和监测 - 采取措施管理和监督潜在风险的过程。
GP服务启停su - gpadmingpstart #正常启动gpstop #正常关闭gpstop -M fast #快速关闭gpstop –r #重启gpstop –u #重新加载配置文件登陆与退出Greenplum#正常登陆psql gpdbpsql -d gpdb -h gphostm -p 5432 -U gpadmin#使用utility方式PGOPTIONS="-c gp_session_role=utility" psql -h -d dbname hostname -p port#退出在psql命令行执行\q参数查询psql -c 'SHOW ALL;' -d gpdbgpconfig --show max_connections创建数据库createdb -h localhost -p 5432 dhdw创建GP文件系统# 文件系统名gpfsdw# 子节点,视segment数创建目录mkdir -p /gpfsdw/seg1mkdir -p /gpfsdw/seg2chown -R gpadmin:gpadmin /gpfsdw# 主节点mkdir -p /gpfsdw/masterchown -R gpadmin:gpadmin /gpfsdwgpfilespace -o gpfilespace_configgpfilespace -c gpfilespace_config创建GP表空间psql gpdbcreate tablespace TBS_DW_DATA filespace gpfsdw;SET default_tablespace = TBS_DW_DATA;删除GP数据库gpdeletesystem -d /gpmaster/gpseg-1 -f查看segment配置select * from gp_segment_configuration;文件系统select * from pg_filespace_entry;磁盘、数据库空间SELECT * FROM gp_toolkit.gp_disk_free ORDER BY dfsegment;SELECT * FROM gp_toolkit.gp_size_of_database ORDER BY sodddatname;日志SELECT * FROM gp_toolkit.__gp_log_master_ext;SELECT * FROM gp_toolkit.__gp_log_segment_ext;表描述/d+ <tablename>表分析VACUUM ANALYZE tablename;表数据分布SELECT gp_segment_id, count(*) FROM <table_name> GROUP BYgp_segment_id;表占用空间SELECT relname as name, sotdsize/1024/1024 as size_MB, sotdtoastsize as toast, sotdadditionalsize as otherFROM gp_toolkit.gp_size_of_table_disk as sotd, pg_classWHERE sotd.sotdoid = pg_class.oid ORDER BY relname;索引占用空间SELECT soisize/1024/1024 as size_MB, relname as indexnameFROM pg_class, gp_toolkit.gp_size_of_indexWHERE pg_class.oid = gp_size_of_index.soioidAND pg_class.relkind='i';OBJECT的操作统计SELECT schemaname as schema, objname as table, usename as role, actionname as action, subtype as type, statime as timeFROM pg_stat_operationsWHERE objname = '<name>';锁SELECT locktype, database, c.relname, l.relation, l.transactionid, l.transaction, l.pid, l.mode, l.granted, a.current_queryFROM pg_locks l, pg_class c, pg_stat_activity aWHERE l.relation=c.oidAND l.pid=a.procpidORDER BY c.relname;队列SELECT * FROM pg_resqueue_status;加载(LOAD)数据到Greenplum数据库gpfdist外部表# 启动服务gpfdist -d /share/txt -p 8081 –l /share/txt/gpfdist.log &# 创建外部表,分隔符为’/t’drop EXTERNAL TABLE TD_APP_LOG_BUYER;CREATE EXTERNAL TABLE TD_APP_LOG_BUYER (IP text,ACCESSTIME text,REQMETHOD text,URL text,STATUSCODE int,REF text,name text,VID text)LOCATION ('gpfdist://gphostm:8081/xxx.txt')FORMAT 'TEXT' (DELIMITER E'/t'FILL MISSING FIELDS) SEGMENT REJECT LIMIT 1 percent;# 创建普通表create table test select * from TD_APP_LOG_BUYER;# 索引# CREATE INDEX idx_test ON test USING bitmap (ip);# 查询数据select ip , count(*) from test group by ip order by count(*); gpload# 创建控制文件# 加载数据gpload -f my_load.ymlcopyCOPY country FROM '/data/gpdb/country_data'WITH DELIMITER '|' LOG ERRORS INTO err_countrySEGMENT REJECT LIMIT 10 ROWS;从Greenplum数据库卸载(UNLOAD)数据gpfdist外部表# 创建可写外部表CREATE WRITABLE EXTERNAL TABLE unload_expenses( LIKE expenses )LOCATION ('gpfdist://etlhost-1:8081/expenses1.out','gpfdist://etlhost-2:8081/expenses2.out')FORMAT 'TEXT' (DELIMITER ',')DISTRIBUTED BY (exp_id);# 写权限GRANT INSERT ON writable_ext_table TO <name>;# 写数据INSERT INTO writable_ext_table SELECT * FROM regular_table;copyCOPY (SELECT * FROM country WHERE country_name LIKE 'A%') TO'/home/gpadmin/a_list_countries.out';执行sql文件psql gpdbname –f yoursqlfile.sql或者psql登陆后执行\i yoursqlfile.sql如何杀掉greenplum、postgresql的会话进程在linux命令行执行kill -s SIGTERM <procid>杀掉该会话的进程用函数杀sql对于查询SQLselect pg_cancel_backend(procpid);其他SQLselect pg_terminate_backend(procpid);调整Greenplum的SQL查询计划在oracle中使用hint可以调整SQL的执行计划,在postgresql可以使用如下的方法进行调整使用set<option> to off/on;调整查询计划,参数如下:enable_seqscan是否走全表扫描enable_hashjoin是否允许走hash连接enable_nestloop是否允许走nestloop连接enable_mergejoin是否允许走合并连接enable_tidscan是否允许走tid扫描(类似oracle中的按rowid访问)enable_bitmapscan是否允许走bitmap扫描enable_hashagg是否允许走hash聚集(也就是做group by时)enable_indexscan是否允许走索引enable_sort是否允许走排序constraint_exclusion是否允许走分区Greenplum参数配置优化# 查询参数psql -c'SHOW ALL;' -d gpdbgpconfig--show max_connections# 修改参数配置命令gpconfig-c <parameter name> -v <parameter value>比如:gpconfig-c log_statement -v DDL# 使参数生效gpstop –r# 修改默认搜索路径# 默认dbtestALTERDATABASE dhgp SET search_path TO dbtest;# 设置work_mem 64MBALTERDATABASE dhgp SET work_mem TO 65536;另一种写法:SETwork_mem TO '64MB'# 设置maintenance_work_mem 128MBALTER DATABASEdhgp SET maintenance_work_mem TO 131072; # 设置max_work_mem 4GALTERDATABASE dhgp SET max_work_mem TO 4194304;# 设置statement_memALTERDATABASE dhgp SET statement_mem TO '256MB';# 12G,需要配合修改/etc/sysctl.conf kernel.shmmaxALTERDATABASE dhgp SET effective_cache_size TO 1572864;# 在各个节点的postgres.conf文件中配置,master和每个segment的可以使用的cpu 个数Master:gp_resqueue_priority_cpucores_per_segment 8Segment:2# checkpoint_segments32-256(512MB-4GB)查看数据库表清单(包括临时表)PG_TABLES主表与分区表pg_partitions字段清单i nformation_schema.columns视图 pg_views字典schema : information_schema。