1.Install Proprietary drivers for your graphics card
2.Install wine
Download wine source
http://sourceforge.net/projects/wine/files/Source/

Download wine 1.5.4 D3 fix path 
wget http://source.winehq.org/patches/data/86102
wget http://source.winehq.org/patches/data/86103
wget http://source.winehq.org/patches/data/86104
wget http://source.winehq.org/patches/data/86105
Download wine 1.5.4 D3D error on game video setting change/restart path
http://bugs.winehq.org/attachment.cgi?id=39565

Install wine
cd wine-1.5.4
patch -p1 < ../86102
patch -p1 < ../86103
patch -p1 < ../86104
patch -p1 < ../86105
patch -p1 < ../reset.patch
./tools/make_requests

./configure
Download wine dependent program like: flex and bison ...... install it
http://prdownloads.sourceforge.net/flex/flex-2.5.35.tar.gz?download

......

make -j 4
make install
 

3.Install winetricks

• rm -f winetricks

• wget http://winetricks.org/winetricks

• sudo cp winetricks /usr/bin

• sudo chmod +x /usr/bin/winetricks

4.Download  msxml3.msi

• http://download.cnet.com/Microsoft-XML-Parser-MSXML-3-0-Service-Pack-7-SP7/3000-7241_4-10731613.html

• cp msxml3.msi /root/.cache/winetricks/msxml3

• winetricks vcrun2008 (or winetricks vcrun2010)

5.install D3
sudo umount /dev/sr0
sudo mkdir /media/Diablo3
sudo mount /dev/sr0 /media/Diablo3 -o unhide,unhide,uid=$(id -g)

wine /media/Diablo3/Diablo\ III\ Setup.exe -launch

6,Play D3

wine Diablo\ III.exe -w -launch -auroraaddress

the -w parameter is not necessary and you can avoid it. It loads your game into free-transform window mode instead of fullscreen. If you want fullscreen gameplay remove this command ( -w ).

or 

wine explorer /desktop=Diablo,1820x1024 ./Diablo\ III.exe -launch

If you are having issues logging in, try the following magic:
echo 0|sudo tee /proc/sys/kernel/yama/ptrace_scope

other note:
http://appdb.winehq.org/objectManager.php?sClass=version&iId=25953

1.Geforce顯示卡新的Driver安裝完畢後,畫面一片黑(註:GeForce 296.10 WHQL,導致黑屏)
重開機後Windows旗幟飄揚,進到登入畫面一片漆黑,電腦並未當機,就是沒影像訊號.
解法:
雖然進安全模式移除新的驅動程式重開機會好,但這不是我要的結果,
查遍資料,試過多種網路方法,無效.
還是靠自己的智慧解決了,就是....換成HDMI輸出(DVI靠轉接頭接HDMI也行),
Geforce and Win 7很沒趣,我的顯卡有支持三種輸出,DVI/SUB/HDMI,
裝完新Driver進入WIN7後硬是強迫我用最好畫質的HDMI輸出,但開機確允許讓我可以用DVI輸出?

2.Win7進入(渾合)睡眠模式後,喚醒後硬體都醒了,就是沒有畫面.
解法: 1不行才做2,再不行才做3
(1).先確定BIOS power選項,看看ACPI是否正確的選了S3,win7 命令提示輸入powercfg -a可查詢.
(2).控制台\網路和網際網路\網路連線,開啟區域網路連線內容,選設定\電源管理,將允許這個裝置喚醒電腦選項 取消,確定後離開.
(3).還有問題就要靠顯示卡Driver解決了.

I was upgrade V5R3 --> V6R1 in last month,
我們踩到 IBM SQE 的 Bug, 開PMR弄了一個月,才由公司同事找到問題.



There isn't a problem specifically with the COALESCE function,
 But use COALESCE on columns in Views  then used to join to a table in a query, will cause SQL performance proble.

This SQE  deficiency should be fixed,
rewritting those views can resolve the performance problem . 

Query the SYSVIEWS table to determine if they have other views which use COALESCE,
i.e.:

select system_view_schema,
system_view_name , view_definition
from qsys2/sysviews
where upper(view_definition) like '%COALESCE%'