Xlib: connection to ":0.0" refused by server
Xlib: No protocol specified
# xhost +local:username
Login to your account and open .bash_profile file$ vi ~/.bash_profile
Set JAVA_HOME as follows using syntax export JAVA_HOME=<path-to-java>. If your path is set to /usr/java/jdk1.5.0_07/bin/java, set it as follows:export JAVA_HOME=/usr/java/jdk1.5.0_07/bin/java
Set PATH as follows:export PATH=$PATH:/usr/java/jdk1.5.0_07/bin
Save and close the file. Just logout and login back to see new changes:$ echo $JAVA_HOME
$ echo $PATH
Tip: Use the following command to find out exact path to which java executable under UNIX / Linux:$ which java
Please note that the file ~/.bashrc is similar, with the exception that ~/.bash_profile runs only for Bash login shells and .bashrc runs for every new Bash shell.
You need to setup global config in /etc/profile OR /etc/bash.bashrc file for all users:# vi /etc/profile
Next setup PATH / JAVA_PATH variables as follows:export PATH=$PATH:/usr/java/jdk1.5.0_07/bin
export PATH=$PATH:/usr/java/jdk1.5.0_07/bin
Save and close the file.
< FilesMatch \.php$>
SetHandler application/x-httpd-php
< /FilesMatch>
< FilesMatch "\.ph(p[2-6]?|tml)$">
SetHandler application/x-httpd-php
< /FilesMatch>
< FilesMatch "\.phps$">
SetHandler application/x-httpd-php-source
< /FilesMatch>
When you load the VMware tools for Windows or Linux, you get a number of benefits. First off, you can now have SVGA resolution instead of just standard VGA. This also increases graphics performance on the virtual machine. Next, the mouse between the host and guest are now synchronized. No longer do you have to press Ctrl-Alt to ext the guest operating system. Mouse performance is also increased. Finally, you can cut and paste between operating systems. These tools are easy to install. Inside the VMware management interface, once the virtual machine is booted, go to
VM -> Install VMware Tools, like this:
Just like any other operating system, over time, a disk will become fragmented. Virtual machines are no different. The time that it takes for a disk to become fragmented depends on what data is being added to and removed from the virtual machine hard drive. Periodically, you should use a program like Diskkeeper, PerfectDisk, or Windows Disk Defragmenter. You can access Window Disk Defragmenter by going to
My Computer, right-clicking on C:, click on
Properties, click on the Tools tab, and click
Defragment now.
Remember, just about any maintenance that a real computer needs, a virtual computer also needs (hey, did you put Anti-virus protection on that virtual machine?).
In Windows, there are common visual effects that make it look “cooler”. However, these visual effects just cause a virtual machine to appear to run slower. This is because the visual effects take CPU/graphics resources to process. I recommend disabling these visual effects to get a slight performance increase. These visual effects settings can be found by right-clicking on in
Control Panel -> System -> Advanced Tab -> Performance Settings. Once there, click on
Adjust for best performance and click OK.
I also recommend disabling the screensaver in your virtual machine as you don’t have a real monitor that is going to get burnt in. By disabling the screensaver, you won’t have to wait for it to update when you come back to use it.
When you use your virtual machines, most people use them inside the VMware Management Interface window. This works fine but the performance would be better if you used that virtual machine in full screen mode. To change to full-screen mode (while you are in the virtual machine), press
Ctrl-Alt-Enter. You will notice a significant performance difference when using full-screen mode. To exit full-screen mode, press
Ctrl-Alt.
Hopefully you chose to disable autorun on your CDROM drive when installing VMware. This is because, when a CDROM with an autorun file on it is inserted, the host machine and all guest operating systems would try to take control of it and read it.
To further prevent your virtual machines from wasting their time with CDROMs being inserted, you should disable the CDROM for each virtual machine. To do this, after selecting the proper tab for that virtual machine, go to
VM -> Settings (or press Ctrl-D). Inside the settings window, click on the CDROM drive. On the right-hand side, uncheck
Connected and Connect at Power-On, like this:
When done, click OK to save changes.
Another way to increase performance on virtual machines is separate the swap files onto a separate host virtual and physical disks. In other words, currently, your swap file goes to the same virtual disk as all your other disk files. To increase performance, you would create a new virtual disk on a different host physical disk. You would then relocate your swap file to that new virtual disk. It won’t really be beneficial if you don’t relocate the new virtual disk to a new physical disk.
This is a more advanced topic and complex process so I won’t go into all the details in this article. However, to change the location of your swap file, you go to
Control Panel -> System -> Advanced Tab -> Performance Settings
-> Advanced Tab -> Virtual Memory Change.
Of course, you hope that you don’t have to do much swapping. To prevent swapping, you should increase the size of the memory allocated to the virtual machine (within the size of your physical RAM). Note, see “Upgrade your RAM”, below.
Anytime you can distribute data that is being utilized onto multiple disks, you will get greater performance. With VMware, this also applies. Say that you are running Microsoft SQL server or Exchange server. These applications have server programs, log files, and databases. Those three types of data could be split onto three separate virtual disks and those virtual disks could be placed on three separate physical disks.
Another way to distribute data across multiple disk spindles is to use a form of RAID. You could keep a single virtual disk a place it on a 5 disk RAID 5 stripe, for example. That would spread the data across multiple disk spindles, increasing performance for the virtual machine.
Upgrading your hard disk with a faster disk will always be a way to increase virtual machine performance. When you do this, your physical host disk is automatically defragmented because you had to backup and restore that data. Besides going with just a faster disk, you may be better going with multiple faster disks, if you can arrange that. Those disks could be put in a RAID array to provide redundancy and performance (depending on the type of RAID you select).
The power of your CPU to process all the data from the host operating system, as well as these multiple virtual operating systems will be seriously stressed. As with any application, a faster CPU speed will always provide faster processing.
In my opinion, you will get the most “bang for your buck” by upgrading your host system’s RAM. RAM is inexpensive these days (compared to CPU or disk) and these virtual machines are hungry for it. By upgrading your RAM, you can allocate more RAM to each virtual machine. This will prevent swapping on your host operating system and guest operating systems.
If you can’t afford additional RAM, another option is to reallocate RAM from one virtual machine to another. See how much RAM each machine is using. If one machine is doing more swapping and needs more RAM, perhaps it can be taken from another machine that isn’t doing much of anything. That is the beauty of virtual computing- sharing resources.
You have learned 10 different ways to increase the performances of your VMware workstation or server machines. There are software changes that can be made as well as hardware upgrades. Remember that your machine isn’t invincible and that running multiple computers inside one computer will quickly push your system, no matter how fast, to its limits. Use these 10 ways to increase performance to make your life (and your users’ lives) easier.>
Over the last year, we have made a big push to move our development/test environments to a virtualized environment using VMWare Server. While we have not really encountered serious performance issues with our test servers, my team was reporting very poor performance with running the development virtual machines on their laptops. Now, keep in mind that these are pretty powerful laptops with 3 or 4GB of RAM, a T9300 dual-core processor, and a 7200RPM SATA hard drive. So there was more than enough horsepower to run WebSphere Portal in a virtual machine. However, the facts did not bear it out and in fact my team was reporting that running the virtual machine was in fact slowing their laptops down to a crawl with the constant hard disk access - a build that ought to take 5-10 seconds was taking several minutes. Obviously an unacceptable situation and people had reverted to just using a local WebSphere Portal install on their native OS - the issue with the local installs was that these local installs were not configured with LDAP or all the customizations/configurations that our test VMs have. When I found out about the issue and workaround and the fact that my pet initiative had fallen by the wayside, I felt challenged to resolve this issue. I tried it out on my own laptop and was able to reproduce this issue, and 2-3 hours later, I had the issue resolved.
To reiterate, the root cause of our performance woes was the excessive disk I/O being done by VMWare. Even though, we had plenty of RAM on our laptops and had more than enough RAM allocated to the Virtual Machine, what I noticed was that while VMWare would start by using significant amount of host RAM, over time it would release that RAM back to the host O/S. Once I realized what was going on, I did some Google searches and looked up the VMWare settings help, and had a resolution to my issue.
Here are the changes that I made to my laptop and to the VMWare settings to improve performance -
VMware Server uses a memory trimming technique to return unused virtual machine memory to the host machine for other uses. Although trimming usually has little impact on performance and might be needed in low memory situations, the I/O caused by memory trimming can sometimes interfere with disk-oriented workload performance in a guest. To disable memory page trimming, check the Disable memory page trimming check box (Select: VM > Settings > Options > Advanced), and click OK.
Given that I have enough RAM on my laptop, my first step to improve performance was to disable memory trimming for guest VMs.
Given the size of the VMWare virtual disk files and given that they are continuously being written to, I figured that my real-time anti-virus protection (Symantec AV) was probably not helping any with my disk I/O performance. So, I went ahead and excluded the VMEM (Virtual Memory - .vmem extension) and VMDK (VMWare Virtual Disk - .vmdk extension) files from the real-time scan.
When the first two steps did not yield the results I wanted, I did some more searching and stumbled upon this default VMWare feature of page sharing that enables VMWare to save on memory usage if multiple virtual machines are running the same operating system or the same applications. I am not sure how this works in my scenario where I only have 1 virtual machine running at a time, but it certainly appeared to me that VMWare was scaling back its memory usage resulting in unnecessary disk I/O and this seemed like a possible culprit. I disabled memory sharing by adding a setting sched.mem.pshare.enable in my virtual machine configuration (.vmx) file like this:
sched.mem.pshare.enable = “FALSE”
Well, these 3 settings did the trick for me! No more VMWare performance woes - the guest VM performs adequately without affecting performance of other applications on my host OS! Keep in mind, that you should also look into defragmenting your host disks and also shrinking your virtual disks for the best performance. I had already done these steps before I spent the time to track down the performance issues. Now, my team can go back to adopting the VMWare development virtual machines!
solution: add this attribute to datasource
-> resultSetHoldability 1
------------------------------------------------------------
เห็นมะ ได้และ uid
จะดึงข้อมูลมา Test บนเครื่องเราซะหน่อย แต่ดันข้าม platform
อ่ะๆ วิธีนี้ใช้ได้ทั้ง Windows<->Unix นะ
Linux -> Windows
ฝั่ง Linux นะ
1. db2look -d dbname -a -e -l -x -c -o dbname.log
หรือถ้าจะเอาเฉพาะ Table ก็ได้
db2look -d dbname -t tablename -a -e -l -x -c -o dbname.log
1.1 edit this file *.log change DB name in Script
2. db2move dbname export -aw
หรือระบุ Schema หรือ Table
db2move dbname export -aw -tn ชื่อtable -sn ชื่อschema
ฝั่ง Windows นะ
3. db2 -tvf path of file in 1.
4. db2move newdbname load > dbname.log
