RRDtool 升級後CPU使用率過高解決
RRDTool 從 1.2x 升級到 1.3x 或 1.4x後
CPU使用率會過高(圖會hang住).
做了字型 erase all existing caches, then rescan就好了.
Oracle JInitiator 1.3.1.21 在 Win7 IE9 EBS異常關閉的處理方式
因JInitiator的版本是程式宣告控制的,我沒權限動它,
問題既然出在JVM,那就從JVM版本下手
問題既然出在JVM,那就從JVM版本下手
C:\Program Files\Oracle\JInitiator 1.3.1 .21\bin\hotspot
2.Win7會跳出
「色彩配置已變更為Windows 7 Basic」訊息,
請點選永遠忽略,再開一次就會正常。
3.一定要重開機才能完全正常使用。
ps:IE8登入OK但是使用時也會有類似的問題,也可用此方式解決.
根本解決之道還是請EBS系統負責人把JInitiator提升吧.
ps:IE8登入OK但是使用時也會有類似的問題,也可用此方式解決.
根本解決之道還是請EBS系統負責人把JInitiator提升吧.
Desire HD 2.3.5 root + ENG S-OFF 刷機教學
網路上各種方式 ,都無法找到一篇能真的從原廠2.3.5 HBOOT lock的狀態ENG S-OFF的案例,浪費不少時間在嘗試錯誤.不如自己寫.
ps:原廠DEV也不能用,所以請不用浪費時間試.
HTC鎖東鎖西,不如開放,我認為在電腦的世界..只要能碰的到硬體,就甚麼也鎖不了!
1.降ROM至1.32
請先下載下面4檔(原文http://forum.xda-developers.com/showthread.php?t=1424023)
tacoroot
misc_version NOTE: you need THAT version of misc_version. Earlier versions would not work.
flashgc for a goldcard
1.32 PD98IMG.zip
手機接USB,充電模式連結電腦
(1).在windows下
(2).以windows command mode進手機shell (你也可以用手Terminal軟體下command)
請同時按著音量(-)還有電源鍵,接著就會進入原廠的recovery了,
請以音量鍵選擇到reboot system now,並按下電源鍵。
(3).下面取得暫時root
(4).開機完建金卡
(5).這步做完會重開機至Boot Loader會自動運行SD卡內的PD98IMG檔案,並降ROM
2.降ROM完成,會以英文版開機
改充電模式連結電腦(menu>>setting>>application>>development>>usb debugging)
3.永久Unlock Root <--請點這
PS:Visionary 這個我試的結果...不管怎麼用都不能永久root但temp root是OK的,因為要先S-OFF才能永久Root,所以就別用這很老的軟體.
ps:重開機(-)加電源鍵確認S-OFF狀態.
4. S-OFF 這個動做我卡非常久,找不到可用的方法,別的方法shell都會卡住不動
下載自製的free-dhd-small.zip然後解壓縮
http://cjt74392.myweb.hinet.net/share/free-dhd-small.rar
5.內建為ClockworkMod Recovery,先裝另一種手機刷ROM軟體4EXT Recovery Updater v2.14
刷ROM Desire HD我首推,講解的很詳細,之後就參考路人甲的網站說明吧
(但root和S-OFF的部份就請略過,不能用的.)
http://walker-a.com/archives/1175 Android 2.3.4 與 HTC sense 3.0+Beats音效,很省電又穩定
http://walker-a.com/archives/1067 Android 2.3.5 與HTC sense 3.5+Beats音效,有些Bug
最後,我強調幾件事,
1.記得備份(ROM/軟體/電話簿....).除非你甚麼也不想留.
2.所有套件裝完一定要先reboot,再裝下一,個不然會變磚.
ps:原廠DEV也不能用,所以請不用浪費時間試.
HTC鎖東鎖西,不如開放,我認為在電腦的世界..只要能碰的到硬體,就甚麼也鎖不了!
1.降ROM至1.32
請先下載下面4檔(原文http://forum.xda-developers.com/showthread.php?t=1424023)
tacoroot
misc_version NOTE: you need THAT version of misc_version. Earlier versions would not work.
flashgc for a goldcard
1.32 PD98IMG.zip
手機接USB,充電模式連結電腦
(1).在windows下
adb push tacoroot.sh /data/local/tmp/tacoroot adb push misc_version /data/local/tmp/ adb push flashgc /data/local/tmp/ adb push PD98IMG.zip /sdcard/上面 PD98IMG檔案頗大,需要稍等
(2).以windows command mode進手機shell (你也可以用手Terminal軟體下command)
adb shell chmod 755 /data/local/tmp/* /data/local/tmp/tacoroot --setup手機會進入原廠的recovery,接著出現三角形加紅色驚嘆號,
請同時按著音量(-)還有電源鍵,接著就會進入原廠的recovery了,
請以音量鍵選擇到reboot system now,並按下電源鍵。
(3).下面取得暫時root
adb shell /data/local/tmp/tacoroot --root
(4).開機完建金卡
adb shell cd /data/local/tmp ./misc_version -s 1.00.000.0 ./flashgc ./tacoroot --undo回到adb殼層,會發現旁邊的符號由$變成#,即表示取得root。
(5).這步做完會重開機至Boot Loader會自動運行SD卡內的PD98IMG檔案,並降ROM
adb reboot bootloader
2.降ROM完成,會以英文版開機
改充電模式連結電腦(menu>>setting>>application>>development>>usb debugging)
3.永久Unlock Root <--請點這
PS:Visionary 這個我試的結果...不管怎麼用都不能永久root但temp root是OK的,因為要先S-OFF才能永久Root,所以就別用這很老的軟體.
ps:重開機(-)加電源鍵確認S-OFF狀態.
4. S-OFF 這個動做我卡非常久,找不到可用的方法,別的方法shell都會卡住不動
下載自製的free-dhd-small.zip然後解壓縮
http://cjt74392.myweb.hinet.net/share/free-dhd-small.rar
adb shell
su
busybox sh /sdcard/free-dhd/hboot 真正ENG S-OFF
5.內建為ClockworkMod Recovery,先裝另一種手機刷ROM軟體4EXT Recovery Updater v2.14
刷ROM Desire HD我首推,講解的很詳細,之後就參考路人甲的網站說明吧
(但root和S-OFF的部份就請略過,不能用的.)
http://walker-a.com/archives/1175 Android 2.3.4 與 HTC sense 3.0+Beats音效,很省電又穩定
http://walker-a.com/archives/1067 Android 2.3.5 與HTC sense 3.5+Beats音效,有些Bug
最後,我強調幾件事,
1.記得備份(ROM/軟體/電話簿....).除非你甚麼也不想留.
2.所有套件裝完一定要先reboot,再裝下一,個不然會變磚.
在Linux玩Diablo 3 (CentOS)
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
4.Download msxml3.msi
5.install D3
sudo umount /dev/sr0
sudo mkdir /media/Diablo3
sudo mount /dev/sr0 /media/Diablo3 -o unhide,unhide,uid=$(id -g)
6,Play D3
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
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 -auroraaddressthe -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
我所遇到Win 7 顯示方面的問題整理
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解決了.
重開機後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解決了.
System i - SQL COALESCE function in views has a deficiency
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%'
我們踩到 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%'

