JIANGSU WINSUN POWER CO., LTD
ADD ：NO.98,Jianghai Road, Economic Development Zone, Nantong, Jiangsu, China
TEL ：+86-513-85105915 51018337 FAX ：+86-513-85537397 Zip code ：226008
website ：www. https://www.doczj.com/doc/0a5095402.html,
www. https://www.doczj.com/doc/0a5095402.html,
E-mail ：sales@https://www.doczj.com/doc/0a5095402.html,
R2V/X Series Diesel Engine
Operation Manual
JIANGSU WINSUN POWER CO., LTD
CONTENTS
CHAPTER I: TO CUSTOMERS
1. Operation manual
2. Safety cautions
3. Service manual
CHAPTER II: DIESEL ENGINE OPERATION
1. Technique specifications and data
2. Operation for diesel engine
3. Maintenance of diesel engine
4. Storage of diesel engine
5. Engine troubleshooting
CHAPTER I: TO CUSTOMERS
Dear user, your name is recorded in our company’s user file. Following the precautions described in this manual will enable you to use this engine with compete satisfaction. Failure to observe any of the rules and precautions, however, may result in a scalding, injury, fire or engine damage and make the guarantee provided with engine become invalid. Read this manual carefully and be sure you fully understand it before beginning operation.
1. Diesel engine operation
1.1 A new engine must be properly broken in. For the first 20 hours, run the engine at low speed and low loads. Do not allow engine to run at high speed and high loads at se`1vere condition during the break in period.
1.2 After the break in period, please retighten the nuts and bolts of cylinder head cover; adjust the valve clearance before run the engine at normal speed.
1.3 Do operate and use the engine upon to the power and speed marked on name plate. Do not allow engine to run at overload, over speed or low load in long time.
1.4. After starting the engine, run the engine for 3-5 minutes at low speed, zero-load, then gradually increase the speed and add the load.
1.5. The worker should learn the engine well about the working principle and structure, check and maintain the engines regularly. Do troubleshoot the problem in time and not allow run the engine with problem or make the engine work without worker on duty for longtime.
1.6. Use the diesel oil and engine oil specified in this operation manual. Clean and filter the diesel oil and engine oil before use and keep the oiler clean, change the engine oil regularly.
1.7. Do maintain the air filter regularly, keep the sponge strainer clean and change the filter element when necessary.
1.8. To serve you with better technique support, please fill in the Receipt Form for Buyers after purchase the engine,
2. Safety precautions
2.1. Do not allow persons who have no capacity like children, elders, and sick enter into the work place of diesel engine.
2.2 Do not allow to operate the diesel engine when lose control on self like in bad heath or drink.
2.3Check the fastening including the condition of each installation, connection and the hold down bolts and fasten them in time
2.4 Exhaust precautions
2. Safety precautions
2.1. Do not allow persons who have no capacity like children, elders, and sick enter into the work place of diesel engine.
2.2 Do not allow to operate the diesel engine when lose control on self like in bad heath or drink.
2.3Check the fastening including the condition of each installation, connection and the hold down bolts and fasten them in time
2.4 Exhaust precautions
●Never inhale the exhaust gases; it contains carbon monoxides, a
colorless, odorless and extremely dangerous gas which can
cause unconsciousness or death.
●Never operate the engine indoors or in a poorly ventilated area,
such as tunnel or cave, etc.
Exercise extreme care when operating the engine near people or animals. Keep the exhaust pipe free of external objects.
2.5 Refueling precautions
●Be sure to stop the engine before refueling.
●Do not overfill the fuel tank
●If fuel is spilled, wipe ii away carefully and wait until the fuel has dried
before starting the engine again.
●Check the fuel the type specified before fill fuel. If add other fuel like
gasoline, it will make fire easily.
●Make sure that there is no fire before refueling and keep the diesel
engine from oil and other inflammable materials to avoid fire.
●When changing oil, make sure that the fuel cap is tightly secured
to prevent fuel leakage
2.6 Fire precautions
●Never operate the engine while smoking or near an open flame
●Never use the engine around dry brush, twigs, cloth-rags, or other
flammable materials
●Keep the engine at least 3 feet (1 meter) away from building or
other structures
●Keep the engine away from flammables and other hazardous
materials
2.7 Protective cover
●Always place the protective covers over the rotating parts. If
rotating parts such as the driving pulley, belts, and shafts are
exposed, serious injuries can be caused. To prevent injury, please
equip all rotating parts with protective covers.
●Be care of hot parts. The muffler and other engine parts can
become very hot while the engine running or after the engine has
been run. Always operate the engine in a safe area and keep
children away from running engines. 2.8 Check before operation
●Carefully check fuel pipe and fuel joints for fuel leakage. Leaked
fuel created a dangerous situation.
●Verify that all the nuts and bolts of the engine are tights. A loose
nut or bolts may cause serious engine failure and could lead to
serious injuries.
●Always check the engine oil and refill it if necessary.
●Check the diesel fuel and refill it if necessary. Do not overfill the
fuel.
●Wear suitable work cloth when operate diesel engine.
●Accident will happen for loosed apron, towel or leather belt may
be rolled by diesel engine
2.9 Surroundings
●Operate the engine on a table or level surface of small rocks and
loose gravel.
●Operate the engine on a level surface. If the engine is titled, fuel
may spill form the gas tank.
★ATTENTION：
Operating the engine at a steep incline may cause the engine to seize up due to improper lubrication even when the oil level is a maximum.
●Be careful of the fuel spillage when transporting the engine.
●Tighten the fuel cap can close the fuel strainer cock before
moving the engine around.
●Never move the engine while it is in operation.
●If the engine will be transported over a long distance, drain all the
fuel from the fuel tank to prevent fuel leakage.
3. Service guide
3.1 To serve users better with better technique support, please fill in the Receipt from Buyer carefully to send it back to Winsun to keep the information of buyers in record.
Read the operation manual carefully and keep the Document for Three Guarantees and present effective invoice and the Document for Three Guarantees.
The warranty period for diesel engine is one year or 1000 hours of accumulated running hour since the engine purchased.
3.2 If you have any questions for operate the diesel engine, please contact your local dealer or us.
3.3 Please note to place the warning mark in the conspicuous position and contact with local dealer to change new mark when the mark is off or unclear.
3.4. We state here that: Winsun will not afford any responsibility for the problems caused by the unreasonable modification or operation of user. CHAPTER TWO: DIESEL ENGINE OPERATION
MANUAL
1. Main technique data and specification for diesel engine
1-2 Overall engine dimension and installation
1-2.1 The diagram for diesel engine and installation dimension
FIG 1-1 Diagram for diesel engine X FIG 1-2 Dimensions for installation X FIG 1-3 Diagram for diesel engine (R2V820) FIG 1-2 Dimensions for installation (R2V820)
1-2.2 Installation
（1）there must be a tight stationary foundation for the diesel engine to avoid vibration or movement when the engine is running.
（2）Make sure that the centering position of the output shaft is properly aligned
（3）Verify that the dimension of the hole on the belt wheel and keyway shaft match or correspond with each other. Also make sure that the bolt of the engine shaft is tightened to the proper torque specification. （4）When the engine is matched with other belt driven machines, the total desired belt distance traveled by the driven wheel must equal the total distance traveled by the driven wheel. If this is not properly calculated and matched, the desired speed on the driven wheel will be incorrect. A formula used to calculate the necessary diameters of the various wheels is provided below.
The diameter of driving wheel (belt wheel) can be calculates as follows:
（5）The power output point allowable load
Maximum permissible radial load:
Maximum permissible axial force:
F2=1350N
Transmitted torque: A ：100%
（6）Make sure that the belt has a correct tension to it
If the belt is too tight, the engine bearing will wear at a high rate leading to
)
(91
)(520001N m m L F -=
engine failure. If the belt is to loose, the belt will slip at high speeds and high loads causing high pitch whistling noises.
1-2.3 Crankshaft driving angles must be less than 120 120°,( see Fig 1-3.)
1-2.4 Gradients
The gradient must be kept within the allowed value shown on Fig1-4 (vertical shaft engine excluded)
FIG. 1-3 FIG. 1-4
1.2.5 Please contact our dealers about electric circuits involved with this engine. We recommend the use of accumulator rates at 20 hours shown in table 1-1.
Table 1-1 unit：AH
1—3 Diesel engine connection dimension
1—3.1Diesel engine shaft specification
Select the suitable PTO shaft type when diesel engine is fitted with machines and equipments for reasonable matching.
Below four types of PTO shaft for users to select (see fig 1-5) .
We can design PTO shaft according to special applications to for users to match with machine better.
Fig 1-5 Diesel engine shaft dimension
1—3.2 Size of PTO flanges（shown in Fig1-6）
Fig 1-6 size of PTO flange 1—4 Name of Diesel engine parts
1-5 Port timing, fuel injection timing, valve clearance
1-5.1 Port timing (see table 1-2)
1—5.2 fuel supply advance angle （see table 1-3）
1-5.3 Valve clearance(cold state)(see table 1-4)
1-5) Table 1-5
1-7 Torque specification for main bolts and nuts (See table 1-6)
2. DIESEL ENGINE OPERATION
2—1 Please pay close attention for safe operation of the diesel engine
（1）The fuel used must be filtered by silk fabric or settle for 24 hours before it is used in the engine. Never add oil to the crankcase when the engine is running.
（2）Keep flammable and combustible goods away from engine while engine is running. The engine should be placed in a simple ventilated place. （3）Do not touch the muffler when the engine is running or just after it has stopped.
（4）The diesel engine should be operated at its rated power and rated speed. If abnormal operating conditions are detected, stop the engine immediately to check and fix the problem.
（5）A new engine must be properly broken in. For the first 20 hours, run the engine at low speed and low load. Do not allow engine to run at high speed and high loads during the break in period.
2—2 Fuel choice and Preparation for start diesel engine
2-3 Starting of the Diesel engine
2-3.1 Starting
A Set the fuel tank cock on the ―ON‖ position.
B. Set the speed governor lever to the ―start‖ position.
C. Turn the start switch clockwise to the ―Start‖ position.
D. If the engine is started, immediately remove your hand away from the key switch.
E. If the engine does not start after 10 seconds, wait for a while (about 15 S) before trying to start the engine again.
2-3.2 Battery
Element for Air filter(plastic square type air filter)：
Do not wash the element of air filter, because this part is dry type. When power of engine is not good or the color of exhaust is abnormal, change the element. Do not operate the engine without element.
Engine oil inlet ：
Place the
engine on level ground and fill the engine oil into the inlet. When checking the oil level, gently place the dipstick into the oil. Turn and tighten the oil dipstick. 1. Lube oil quality
The qualified lube oil should meet following condition: ACEA-B2/E2or higher-grade specification
API-CD/CE/CF-4/CG-4or higher-grade specification 2. Lube oil viscosity Select lube oil viscosity based on ambient temperature when starting at cold temperature
Fuel tank cock OFF
ON
A. Always check the liquid level of the battery every month, if the level is lower
than the low limit mark, refill the battery with distilled water till you reach the upper limit mark.
B. If the liquid level in the battery is too low, the electric starter will not function
to its best potential. Always keep the level of the liquid in the battery between the upper and lower limits.
C. If there is too much liquid, the liquid will splash onto the other nearby parts
thereby ruining the battery.
2-4. Operating and stopping of the diesel engine 2-4.1 Operating the engine
（1）Preheat the engine for three minutes at no load (2) Set the speed governor lever to the desired speed
Fuel controller
Speed control screw
2-4.2 Check on the engine while the engine running. (1) Check if there is abnormal noise or vibration.
(2) Check to make sure there is good combustion or over speed running.
（3）Check to see the color of the exhaust gases to see if it is too white or too black.
If any of these conditions are detected, stop the engine immediately and contact your nearest dealer for repair information.
2—4.3 Stopping the engine
（1）First, bring down the speed of the engine by using the speed governor. Let it run for 3 minutes at no load before stopping it. Speed governor
（3）Set the fuel tank cock T ―Stop‖ position.
（4）If the engine comes with an electric starter, turn the starting switch to the ―Off‖ pos ition.
When the engine need to stopped immediately for emergency situation like over speed, close the fuel tank cock and loosen the joint nut of high-pressure fuel pipe, then the engine will be stopped
immediately.(For engine with electric solenoid, turn the key switch to the Stop position)
2-5 Precaution for engine running and after stop
2-5.1 Precaution for engine running
(1) When the oil alarming red lamp is on, stop the engine and check the engine oil immediately
(2) Check the fuel level regularly and refill in the fuel when fuel is insufficient
(3) Clean the dirt in the opening of air induct and exhaust of diesel engine regularly
(4) The engine is not allowed to run when it exhaust black smoke. If the parts of engine are normal but there is black smoke in the opening of exhaust, the engine should be used overload. For this problem, reduce the load.
If the fault of engine, please stop the engine and examine and resolve the problem immediately.
(5) Check whether there is abnormal noise of engine regularly. Stop and
examine the engine immediately.
2-5.2 Precaution after stopping engine
on the
flywheel aimed at top dead center mark on air induct cover and valves of two cylinder closed to avoid dust enter into cylinder or corrode the potted line of valve.
(2) Close the fuel cock and check the element of fuel filter is in good condition.
(3) Make sure the fastening of engine base is stable and also the fastening of the bolts, nuts on engine and tighten them if they are loose.
(4) When the engine will stored for long time, seal the engine with waterless engine oil.
(5) Clean the dirt from the engine and put the engine in a nice dry noncorrosive place.
3. TECHNICAL MAINTENCE OF DIESEL ENGINE
3-1 Daily checks and maintenance
Check the oil level of the engine to see whether it is between the upper and lower limits.
Check to see whether there any oil leaks within the engine.
Keep the engine clean by cleaning up the dirt and other greasy deposit on the engine.
3—2 Regular checks and maintenance
Regular checks and maintenance are very important for normal operation and engine life. The following table indicates what is necessary to be performed at specific time intervals. The marks signify that a special tool or technique is needed for maintenance. Please
3—3 Maintenance for diesel engine
First period maintenance
After running for 150 hours, the diesel engine should be maintained for first period：
1、Clean the air filter, make sure the paper core is good and check each tuck.
2、Check and adjust the valve clearance
3、Check the engine oil, change or refill engine oil.
4、Check the engine oil quality. Change all the engine oil and clean the engine body and fuel pipeline after the engine running for 200 hours.
Second period maintenance:
It depends on the technique condition of diesel engine the second period maintenance.
Within the period of three guarantees, the second period maintenance should be conducted with the appointed for below items, excluding the first period guarantees.
1.Clean the pipeline of fuel tank, exhaust tube, muffler
2.Clean the carbon deposit on the injection nozzle, piston, cylinder,
cylinder head etc
3.Check and adjust the fuel injection pressure, clearance for piston
rings, fuel delivery beginning.
4.Check the tightness of valve and do grind the valve if leakage
occurs. 5.Check the fastening of connection rod, crankshaft, and flywheel etc.
6.Trail running check.
4. STROING THE DIESEL ENGINE
Please follow the instruction below if you plan on storing the engine for long periods of time to avoid corrosion and damage.
4.1 Remove the oil-drain screw, drain off the engine oil and retighten the oil-drain screw quickly before the engine oil becomes cool when the engine is stopped.
4.2. Drain off the diesel oil of fuel tank.
4.3 Take out and clean the lube oil filter
4.4 Remove the fuel injection pump and clean the inner side of cylinder body with clear diesel oil. Drain off the cleaning oil from the oil-drain screw.
4.5 Clean the air filter and inner side. Remove the dirt on the opening of air inlet and exhaust.
4.6 Dehydrate 1.8kg strained lubricating oil (Warm up it to 110-150℃till no bubbles). Fill 1kg dehydrated engine oil into the crankshaft case and turn the engine to make the lubrication system filled with engine oil.
4.7 Then fill 0.3kg dehydrated engine oil into the air intake pipe, turn the diesel engine to make the engine oil onto the piston, cylinder head cover, valve line. Finally turn the flywheel to the position that both cylinder valves are closed to make the engine cavity insulated.
4.8. Heat the left dehydrated engine oil with 0.2kg industrial Vaseline till they melt and mix together well.
4.10 Packed the air cleaner and opening of exhaust with oilpaper to
avoid dirt enter into engine. 4.11 Finally brush the mixed oil evenly on
the engine parts without paint like flywheel, fuel pipe etc.
4.12 Do not allow brush oil on the parts of rubber and plastic.
4.13 The engine should be stored in the well ventilated and dry place
and not allowed to store in the place with chemistry
The diesel engine can be well stored for six month by above methods.
When it exceeds six month, the engine can be stored again with the
instruction.
5. DIESEL ENGINE TROUBLE SHOOTING AND REMIDIES
5-5 Diesel engine exhausting blue smoke
5—7 Method and location of the inspection when diesel engine failure to stop running
RECEIPT FROM OUR CUSTOMERS
使用 db2pd 进行监视和故障诊断 因为 db2pd 工具可从 DB2? 内存集合迅速返回即时信息，所以该工具可用于故障诊断。 该工具不需要获得任何锁存器或使用任何引擎资源就可以收集信息。因此，在 db2pd 收集 信息时，有可能（并且预计）会检索到正在更改的信息；这样，数据可能不是十分准确。 如果遇到正在更改的内存指针，可使用信号处理程序来防止 db2pd 异常终止。这可能会导 致输出中出现诸如以下的消息：“正在更改的数据结构已强制终止命令”。虽然如此，该工 具对于故障诊断却非常有用。在不锁存的情况下收集信息有两个好处：检索速度更快并且 不会争用引擎资源。 如果要在出现特定 SQLCODE、ZRC 代码或 ECF 代码时捕获关于数据库管理系统的信息，那 么可以使用 db2pdcfg -catch 命令完成此操作。捕获到错误时，将启动 db2cos（调出脚本）。db2cos 文件可以自动改变，以便运行解决问题所需的任何 db2pd 命令、操作系统命令或任何其他命令。在 UNIX? 和Linux? 上，模板文件 db2cos 位于 sqllib/bin 中。在 Windows? 操 作系统上，db2cos 位于 $DB2PATH in 目录中。 以下是使用 db2pd 快速故障诊断的一组示例。 场景 1：诊断锁定等待 使用 db2pd -db
本文通过一个实例讲解了在DB2版本9以后，如何使用db2pd命令捕获死锁信息 死锁经常会存在于我们的应用系统中，如何捕获死锁信息并解决死锁问题，是一个比较复杂的问题。DB2提供了死锁事件监控器来获取死锁信息，可以非常方便地获取死锁信息。从DB2版本8.2.2开始，DB2也可以使用db2pd命令和db2cos脚本来获取死锁信息，提供了一种新的途径来获取死锁信息。 从DB2版本9开始，我们可以使用db2pd -catch 命令来捕获错误信息，然后调用一个sqllib/db2cos 的脚本收集出错时的现场信息。该命令的使用语法如下： Usage: -catch clear | status |
db2 force application all –断开所有链接数据库的应用 db2 list application-查看连接数据库的应用 db2 bakup db ksdbs 备份数据库 db2start db2stop启停数据库 db2 connect reset断开所有链接 scp get trans.ini -r back@10.10.9.160/home/back/bccbin \ scp local_file remote_username@remote_ip:remote_folder 或者 scp local_file remote_username@remote_ip:remote_file scp -r ip:/db/dbhome/dbguard 【1】 db2top –d ksdbs db2pd -d ksdbs -stat >stat.log 查看数据库状态（数据超大超详细） 【1】find -type f | xargs dos2unix 遍历格式转换 【1】 find . -name [A-Z]* -print 查找当前目录下以大写字母命名的文件 【1】 >db2ckbkp 检查数据库的完整性 >tee 命令 用途--显示程序的输出并将其复制到一个文件中。 【1】db2 connect reset db2 list directory db2 list active databases db2 get db cfg db2 get db cfg 【1】归档日志 db2 update db cfg for db_name using LOGRETAIN ON 更改归档目录: db2 update db cfg for db_name using LOGARCHMETH1 "disk:/archive/db_name_db_log" 在我重新连接数据库的时候提示： db2 connect to t_1 to mydb SQL1116N A connection to or activation of database "T_1" cannot be made because of BACKUP PENDING. SQLSTATE=57019 网上找了n多最后才知道 若修改数据库LOGRETAIN参数，从循环日志模式改为归档日志模式，则会导致数据库backup pending状态。
IBM DB2 Connect 简介: 内有乾坤 2005 年 4 月 对于那些脱离大型机的应用程序——分布式应用程序来说，IBM? DB2? Connect? 已成为向它们开放 DB2 for z/OS 数据库以及 zSeries 硬件平台传统公认的所有优点的首选方法。本文是一个由 5 部分组成的系列中的第一篇文章，这个系列将介绍 DB2 Connect 的一些主要特性，这些特性有助于提高交付随需应变解决方案的能力。 简介 1993 年，计算机界的专家们预测大型机（mainframe）将迅速退出历史舞台。他们宣称，未来的计算基础设施将会是一个高度分布的、松散连接的个人电脑和客户机-服务器系统的集合。作为该行业的相关参与者，IBM 几乎无立身之处。 我们都知道后来是怎么回事。IBM 设法在分布式市场重新占得先机，并成为大型机（mainframe）技术的“主要”支持力量。从价格的角度来看，IBM 大大缩减了大型机的价格。从技术的角度来看，IBM 放弃了为其大型机提供动力的双极技术（bi-polar technology），而将大量赌注放在 CMOS 芯片技术上，试图通过这种方式，以剧减的价格交付大型机级别的计算。更重要的是，对于所谓大型机是一种过时的技术，属于大型机的时代已经一去不复返这类荒诞的说法，这是一个直接有力的反击。 如今，企业比以前更多地使用大型机作为其计算基础设施的基础。与此同时，Linux?、UNIX?、Windows? 和其他客户机-服务器系统（在此处被称作分布式平台）并没有消失，因为大型机又重新为它们在企业中赢得了地位。 实际上，这些分布式计算基础设施经历了一个发展的过程。最终的结果是，客户希望将分布式平台的简单性和长处与大型机技术无可匹敌的强大性相结合。如果说信息技术（IT）中有一个领域能让这种结合产生立杆见影的效果，那么这个领域一定是数据库应用领域。 IBM DB2 Universal Database? for z/OS (DB2 for z/OS) 原本是一种大型机数据库，现在已转型为世界上第一种用于客户机-服务器应用程序的数据库服务器。在如今的数据中心里，当您使用运行在大型机上的 CICS 或 COBOL 应用程序时，很可能会遇到 DB2 for z/OS 被用作运行在 Windows、UNIX 和 Linux 上的应用程序的数据库服务器的情况。 正是在这种环境下，我发现 IBM DB2 Connect (DB2 Connect) 产品扮演着一个中心角色。如今，对于那些脱离大型机的应用程序——分布式应用程序来说，DB2 Connect 已成为向它们开放 DB2 for z/OS 数据库和 zSeries 硬件平台的所有传统公认优点的事实上的首选。 为什么当其他产品遭遇失败的时候，DB2 Connect 却能获得成功呢？这个关于DB2 Connect 的系列试图描述 DB2 Connect 的一些关键特性，我们相信正是这
株洲职业技术学院专业论文（设计）
题目： 关于Pages 的简介与使用方法 Pages on the history and method of use 学院株洲职业技术学院 年级专业苹果动漫1201班 学生姓名龙甜 学号201210330124 指导教师李思静 完 成 日 期 2012 年 12 月 株洲职业技术学院专业论文 诚信声明 本人郑重声明：所呈交的专业论文，题目《 关于Pages的简介与使用方法》 是本人在指导教师的指导下，进行研究工作所取得的成果。对本文的研究做出重要贡献的个人和集体，均已在文中以明确方式注明。除此之外，本论文不包含任何其他个人或集体已经发表或撰写过的作品成果。本人完全意识到本声明应承担的法律责任。
作者签名：龙甜 日期：2012年12月21日 关于P a g e s的简介与使用方法 龙甜 摘要 P a g e s是苹果公司多功能办公软件套装A p p l e W o r k s的继承者，是一个用于文字处理和页面排版的应用程序。它是由苹果公司所开发，包括在i W o r k软件套装中。P a g e s支持多栏排版，文本段落样式，脚注和其他高级文字处理功能，并为用户提供了强大的模板功能。创建的文档可以导出多种文件格式，同样也能导入A p p l e W o r k s和微软W o r d文件。文档中可直接绘制形状，并修改属性；可以环绕文本；可以插入图形，并设置阴影，多角度旋转等。并且，P a g e s可以制作各种宣传海报，新闻报道，贺卡，请柬，论文和教学材料等。并能从i T u n e s，i M o v i e和i P h o t o中接受数据，设置U R L链接。 关键词：P a g e s使用方法苹果 Abstract P a g e s i s a A p p l e C o r p m u l t i f u n c t i o n a l o f f i c e s o f t- w a r e s u i t e a s u c c e s s o r t o A p p l e W o r k s,i s o n e f o r w o r d p r o c e s s i n g a n d p a g e l a y o u t a p p l i c a t i o n.I t i s t h e A p p l e C o r p f o r t h e d e v e l o p m e n t,i n c l u d i n g i n t h e i Wo r k s o f t- w a r e s u i t e.P a g e s s u p p o r t s m u l t i p l e c o l u m n l a y o u t,t e x t p a r a g r a p h s t y l e s,f o o t n o t e s a n d o t h e r a d v a n c e d t e x t p r o c-
db2 使用db2pd 进行监视和故障诊断 因为db2pd工具可从DB2? 内存集合迅速返回即时信息，所以该工具可用于故障诊断。 该工具不需要获得任何锁存器或使用任何引擎资源就可以收集信息。因此，在db2pd收集信息时，有可能（并且预计）会检索到正在更改的信息；这样，数据可能不是十分准确。如果遇到正在更改的内存指针，可使用信号处理程序来防止db2pd异常终止。这可能会导致输出中出现诸如以下的消息：“正在更改的数据结构已强制终止命令”。虽然如此，该工具对于故障诊断却非常有用。在不锁存的情况下收集信息有两个好处：检索速度更快并且不会争用引擎资源。 如果要在出现特定SQLCODE、ZRC 代码或ECF 代码时捕获关于数据库管理系统的信息，那么可以使用db2pdcfg -catch命令完成此操作。捕获到错误时，将启动db2cos（调出脚本）。db2cos文件可以自动改变，以便运行解决问题所需的任何db2pd命令、操作系统命令或任何其他命令。在UNIX? 和Linux? 上，模板文件db2cos位于sqllib/bin中。在Windows? 操作系统上，db2cos位于$DB2PATH\bin目录中。 以下是使用db2pd快速故障诊断的一组示例。 场景1：诊断锁定等待 使用db2pd -db
题目： 1、熟练使用db2look工具导出数据库结构 2、使用db2pd监控表空间、锁的使用情况 3、使用db2mtrk 检查数据库内存的分配情况 4、练习使用db2top工具 5、使用db2batch测试SQL语句的性能 解答： 1、熟练使用db2look工具导出数据库结构 [myinst@ye ~]$ db2look -d mydb3 -l -e -o mydb3.dll -- No userid was specified, db2look tries to use Environment variable USER -- USER is: MYINST -- Creating DDL for table(s) -- Output is sent to file: mydb3.dll -- Binding package automatically ... -- Bind is successful -- Binding package automatically ... -- Bind is successful 2、使用db2pd监控表空间、锁的使用情况 #db2pd监控表空间 [myinst@ye ~]$ db2pd -db mydb3 -tablespace Database Member 0 -- Database MYDB3 -- Active -- Up 0 days 00:29:31 -- Date 2015-08-24-11.36.10.344000 Tablespace Configuration: Address Id Type Content PageSz ExtentSz Auto Prefetch BufID BufIDDisk FSC NumCntrs MaxStripe LastConsecPg RSE Name 0x00007F9AC71E0080 0 DMS Regular 32768 4 Yes 4 1 1 Off 1 0 3 Yes SYSCATSPACE 0x00007F9AC71ED220 1 SMS SysTmp 32768 32 Yes 32 1 1 On 1 0 31 No TEMPSPACE1 0x00007F9AC71FA3C0 2 DMS Large 32768 32 Yes 32 1 1 Off 1 0 31 Yes USERSPACE1 0x00007F9AC7207560 3 DMS Large 32768 4 Yes 4 1 1 Off 1 0 3 Yes SYSTOOLSPACE 0x00007F9AC7214700 4 DMS Large 32768 32 Yes 32 2 2 Off 1 0 31 Yes MYSPACE3 Tablespace Statistics:
传统工具简介及使用方法 我国幅员辽阔，各地都有一批手艺高超的匠人，他们使用的工具也是五花八门，但是有些工具是经常用到的，先简单介绍几种常用的工具 梆口：是刨子之中最大的也是最长的，专门用来长板料对缝，比如做箱子和板柜等。 长刨子：主要用来刮长料，用它刨出来的料能达到又平又直 二刨子：它的使用效率最高，所有木料初始工作都要靠它来完成净刨：是常用的刨子最小的，用做产品最后一道工序刨光，净面。 歪嘴子:一般的歪嘴子都能调节宽度，可用做裁口 板刨子：用来裁口后的收根 线刨子:线刨子的种类很多，主要做镜框和家具门边起的花线 勒刀：较软的木料裁口，效率很高 线勒子:固定尺寸划线用的 带溜子：裁口用的 槽刨子：厢板用的，有各种尺寸的
偏口：特殊用途的长刨子，专门用来长板料对缝，比如做箱子和板柜等 锛子:主要是盖房子锛屋的大梁，檩子等 锯：锯的种类太多了，主要有拐子锯，双面齿刀具，单面齿刀具等 *：传统锯的齿大致分三类，（一）左右（二）左中右（三）左右中。作用主要是截锯，顺锯，截顺锯等。另外伐锯齿时的角度也可以调整锯的用途。 *：做刨子时要根据它的用途调整角度，二刨子坡度稍大一些推进时省力，但是不拿炝茬。净刨坡度小一些净面效果好。这也要根据各地使用的木料来调整。总之活是死的，人是活的。各村都有各村的高招。 梆口：是刨子之中最大的也是最长的，专门用来长板料对缝，比如做箱子和板柜等 7.jpg(21.56 KB)
长刨子：主要用来刮长料，用它刨出来的料能达到又平又直16.jpg(52.12 KB)
净刨：是常用的刨子最小的，用做产品最后一道工序刨光，净面。 12.jpg(84.39 KB)
1.打开 db2pd – Monitor and Troubleshoot DB Command，如图 3 所示。 图 3. DB2 Information Center 中关于 db2pd 工具的信息
调用 db2pd 工具有两种方式。可以用交互模式调用 db2pd 工具，或者直接在操作系统命令提示符下运行。要是用交互模式执行该工具，可以在操作系统命令提示符下输入 db2pd –interactive 或者直接输入 db2pd，这样将看到 db2pd 命令提示符db2pd>，可以输入命令选项。使用–help 选项可以获得帮助信息。退出 db2pd 命令提示符只需要输入 quit 或者 q。图 4 中的例子说明了如何使用交互模式显示当前的代理。 图 4. 用交互模式调用 db2pd 在操作系统命令提示符下调用该工具可以输入带有命令选项的 db2pd 命令。下面的例子（图 5）使用 -agents 选项显示了所有的活动代理。 图 5. 在操作系统命令提示符下调用 db2pd
此外，还可以通过将选项保存在文件中或者在 DB2PDOPT 环境变量中设置选项来控制该命令。下面的例子（图 6）说明可以将 -agents 选项保存在一个（在该例中）名叫file.out的文件中，然后使用 db2pd –command file.out 执行选项。 图 6. 将 db2pd 选项保存在文件中 如果要使用 DB2PDOPT 环境变量，可以将 DB2PDOPT 设成需要的选项然后像下面这样调用 db2pd： 图 7. 在 DB2PDOPT 环境变量中设置 db2pd 选项
W A S快速入门手册 Prepared on 22 November 2020
WAS快速入门手册
编写原则 1.技术别人是教不会的，只有靠自己学会 2.以PD为主，系统学习为辅 3.给出开放问题，自己去找答案，总结经验日常维护 1.安装WAS a)安装, , b)创建profile c)安装htppServer和plugin d)配置集群 i.高级：配置共享域 e)发布程序 f)配置DB数据源 g)配置LDAP h)配置安全性 i.与的区别 ii.配置SSO i)高级：配置JMS 2.升级WAS a)静默安装 b)升级JDK和WAS
3.AIX命令 a)was本身命令 startServer －trace，，等 b)常用命令， ls –ltr , df –g ，tar等 c)topas，vmstat，netstat等监测命令 d)收集Crash，hang信息时的命令 e)ulimit，crontab等系统调整，监测命令 4.调优WAS a)WAS上线前，参数调整 i. JVM，日志等 b)压力测试过程中，调整WAS参数 c)WAS连接DB2，Oracle后，如何监测数据库，如果区分是WAS的问题，还是 数据库的问题 5.收集WAS数据 a)Mustgather b)其中难以收集数据： Crash，Hang 6.分析heapdump a)说明：本地安装 IBM Support Assistant v3 b)ecurep网站 7.分析Javacore a)参考Diagnostics Guide b)注意Current Thread等信息 8.编写测试代码 a)编写来测试页面问题
在DB2 UDB中有两种类型的监控器：快照监控器和事件监控器 一、建立IBM DB2事件监视器： 1. 创建一个SQL Event Monitor，写入文件： db2 create event monitor evmname for eventtype write to file 'directory' 例：db2 create event monitor mymonitor for deadlocks,statements write to file 'D:\db2tst\logs' maxfiles none maxfilesize 8192 在unix下不需要加db2，以下命令相同 2. 激活事件监视器（确保有充足的可用磁盘空间）： $> db2 "set event monitor mymonitor state = 1" （必须是""） 3. 让应用程序运行。 4. 取消激活事件监视器： $> db2 "set event monitor mymonitor state = 0" 5. 使用DB2 提供的db2evmon 工具来格式化SQL Event Monitor原始数据（根据SQL 吞吐率可能需要数百兆字节的可用磁盘空间）： $> db2evmon -db DBNAME -evm mymonitor > sqltrace.txt db2evmon -db zssmk -evm mymonitor > sqltrace.txt 6. 浏览整个已格式化的文件，寻找显著大的成本数（一个耗时的过程）： $> more sqltrace.txt 补充： 1.删除事件监视器 drop event monitor mymonitor 2.涉及到的系统表 select * from SYSCA T.EVENTMONITORS; select * from SYSCA T.EVENTS; select * from SYSCA T.EVENTTABLES 3.查看命令使用帮助 命令名？ db2evmon ? Usage: db2evmon [-db] 分析锁等待事件，找出锁表语句 1.找出锁等待情况 db2pd -db foticdb -locks wait showlocks// -file lockwait.txt导出结果到文件lockwait.txt 可以看到上图中有一个X锁，TranHdl=106，Sts=G（锁的授权者即持有者），事务TranHdl=91的锁类型为U，Sts=W，即处于锁等待状态，Owner=106，即91的事务等待106的事务释放锁事务91才能执行。如果需要找到事务106所执行的SQL，必须找到事务106对应的APPID。 2.找到事务对应的AppHandl db2pd -db fotest –transactions 以上返回结果中可以看到事务91对应的AppHandl=59574，事务106对应的AppHandl=59131。 3.找到应用程序对应的AnchID db2pd -db fotest -applications 可以看到上图中AppHandl=59131的应用L-AnchID=233,L-StmtUID=7 4.找到L-AnchID=233,L-StmtUID=7对应的SQL db2pd -db fotest -dynamic 上图中可以看到AnchID=233,StmtUID=7的应用执行的SQL为 Update locktest set suibian=33 where suibian=22 到此所有查询都结束。 5.总结 应为db2pd是数据库实时监测，正式执行查找，可一次导出以上所有信息，到文件中，再分析锁表情况。 执行语句： db2pd -db foticdb -locks wait showlocks -transactions -agents -applications -dynamic -file db2pd.out -repeat 15 40 //-repeat 15 40为没隔15s执行一次db2pd语句，总共执行40次 //-file 将结果导出到db2pd.out文件中。 DB2性能调节工作总结 近期负责了Metric项目的服务器性能维护，对DB2的性能调节做了些研究。整体感觉数据库调优的关键点应该还是在建库阶段，好的查询更能得到更好的性能。而后期对数据库参数等的调节结果并不是非常明显的。 网上数据库调节方面的资料也很多，但大多数都是转来转去的，在此只做下我个人的工作总结;（//表示对上诉解释##表示对下面解释） ############1,Monitoring################## db2 get database manager monitor switches //显示监视开关的情况 db2 update dbm cfg using DFT_MON_BUFPOOL ON DFT_MON_LOCK ON db2 update dbm cfg using DFT_MON_SORT ON DFT_MON_STMT ON db2 update dbm cfg using DFT_MON_TABLE ON DFT_MON_UOS ON db2 terminate db2stop db2start //在实例级打开监视开关，这样随着实例的重启，开关生效 db2 get database manager monitor switches db2 get monitor switches //发现实例级和下面的数据库监视开关都打开了 db2 deacivate database tp1 db2 activate database tp1 //重新激活数据库，刷新监视数据 select agent_id,rows_read,rows_written,rows_selected,rows_inserted from sysibmadm.snapappl //监视每个代理读写查询的情况，如果read的数量远高于select的数量，考虑是不是缺少索引 //在我的工作中，很少遇到写多的情况，所以对这方面也没深入 db2 get snapshot for tables on tp1 > sntab1.txt //接下来监视tp1数据库下所有表的读写啦 ##下一步，就是抓到那个有大量读大于写的表，然后提取该表上的查询SQL ##这里就要考虑两种情况了，是静态的还是动态的 ##@@@静态的，从包里提取 db2bfd -s sqltp1st.bnd ##@@@动态的，可以用snapshot SQL STATEMENT抓取,这里不写了db2pd抓取锁表语句
DB2性能调节工作总结
相关主题
文本预览