(DB2 Doc)Data organization

http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.db2.luw.admin.perf.doc%2Fdoc%2Ft0024848.html


ref:
Performance overview

E5300 & RHEL6 (CentOS 6)

E5300(Core 2系列)有EM64T（Intel採用的x86-64）


E5300規格:
http://ark.intel.com/products/35300/Intel-Pentium-Processor-E5300-(2M-Cache-2_60-GHz-800-MHz-FSB)

RHEL硬體限制:
http://www.redhat.com/rhel/compare/#note_4
http://support.bull.com/ols/product/system/linux/redhat/help/kbf/g/inst/PrKB11417

ESX Server不支援Red Hat Hugemem Kernel :
http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=8964517

ref(PAE):
kernel-PAE
http://en.wikipedia.org/wiki/Physical_Address_Extension
http://pacoup.com/2009/05/27/pae-vs-64-bit-what-manufacturers-dont-want-you-to-know/comment-page-1/
http://communities.intel.com/message/132864
http://msdn.microsoft.com/en-us/library/aa366796%28VS.85%29.aspx

ref:
http://www.zimbra.com/forums/installation/4885-rhel4-64-bit-rhel4-32-bit.html

Virtualbox的Guest OS使用PPPOE撥號

Virtualbox的Network設定成Bridge Adapter

階段作業逾時值

階段作業逾時值： 欄位應該在 2 至 2147483647 的範圍內。

單位:分鐘
default timeout:30 minutes

ref:
http://www.redbooks.ibm.com/redpapers/pdfs/redp4580.pdf

Reading DB2 Execution Plans

http://etutorials.org/SQL/Sql+tuning/Chapter+3.+Viewing+and+Interpreting+Execution+Plans/3.2+Reading+DB2+Execution+Plans/

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2.doc.sqlref%2Frexpl.htm

類別載入器檢視器

 

如果classes和jar有相同套件

由此可知會執行classes的程式
不會執行jar檔的程式
實測也是如此

同理,jar檔有相同套件類別,要看誰先載入
另外有載入war那一層(WEB-INF的上一層)<載入順序為最後>
所以jar和class檔放在war那層也可以運作??
有空無聊時再來測看看

DB21061E

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/r0002036.htm

reorgchk

reorgchk update statistics on table all

Calls the RUNSTATS routine to update table and index statistics, and then uses the updated statistics to determine if table or index reorganization is required.

http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.db2.luw.admin.cmd.doc%2Fdoc%2Fr0001971.html



http://publib.boulder.ibm.com/infocenter/tivihelp/v2r1/index.jsp?topic=%2Fcom.ibm.itame3.doc_5.1%2Fam51_perftune66.htm

Win7 PPPoE網路閒置不斷線設置

http://alexjean1031.wordpress.com/2010/11/25/win7-%E7%B6%B2%E8%B7%AF%E9%96%92%E7%BD%AE%E6%96%B7%E7%B7%9A%E8%99%95%E7%90%86%E6%96%B9%E6%B3%95/

http://www.pczone.com.tw/vbb3/thread/3/150799/

因為某些理由只能用H牌的
H牌又用pppoe~~~=.=
唉

列出Schema所有表格

select TABNAME from syscat.tables where DEFINER = 'XXXXX' and TYPE = 'T' and TABSCHEMA = 'YYYYYY'


TYPE = 'V'
=>列出所有View

預設public群組有select系統表格權限
如果公司有安控疑慮拿掉public群組select系統表格權限就沒辦法查

db2look

http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=%2Fcom.ibm.db2.udb.admin.doc%2Fdoc%2Fr0002051.htm

ex:

db2look -d 資料庫名稱 -e -c -z 綱目(Schema)名稱 -o 匯出檔名.sql

模擬的遠端桌面系統： XRDP 伺服器

http://linux.vbird.org/linux_server/0310telnetssh.php#ps9

很可惜的是，我們的 CentOS 6.x 預設並沒有提供 XRDP 的伺服器，如果你有興趣的話，可以自行編譯 xrdp 軟體， 但鳥哥有找到 Fedora 基金會提供的 RHEL 額外軟體計畫 (註9)，你可以到底下的連結去找到你對應的版本：

• http://download.fedora.redhat.com/pub/epel/
  
  (以上引自鳥哥網站)

http://download.fedora.redhat.com/pub/epel/6/i386/xrdp-0.5.0-0.13.el6.i686.rpm
http://download.fedora.redhat.com/pub/epel/6/x86_64/xrdp-0.5.0-0.13.el6.x86_64.rpm



2012/10/4更新:
以上載點失效
可至Hinet載點
http://mirror01.idc.hinet.net/EPEL/6/i386/xrdp-0.5.0-0.13.el6.i686.rpm
http://mirror01.idc.hinet.net/EPEL/6/x86_64/xrootd-3.0.5-1.el6.x86_64.rpm

jar檔可以用壓縮軟體壓縮

http://download.oracle.com/javase/1.4.2/docs/guide/extensions/spec.html

Each optional package or application consists of at least one JAR file containing an optional manifest, code and assorted resources. As described below, this primary JAR file can also include additional information in its manifest to describe dependencies on other JAR files. The jar command line tool included with the Java 2 SDK provides a convenient means of packaging optional packages, although any ZIP-compatible archiving tool should work as well.

由官方規格即知jar檔只要是ZIP相容即可,基本上我都用7-zip壓
只是jar工具程式壓的可能包含了一些相依資訊
另外放在$/JAVA_HOME/jre/lib/ext的套件也是可以壓成jar或zip檔

WebSphere設定jndi (DB2)

http://www.ibm.com/developerworks/cn/data/library/techarticles/dm-0512zhanghzh/

http://publib.boulder.ibm.com/infocenter/wasinfo/v6r0/index.jsp?topic=%2Fcom.ibm.websphere.express.doc%2Finfo%2Fexp%2Fae%2Fudat_minreq.html

使用in的欄位要有index

如果使用in的欄位沒有建index
就會TBSCAN

ex.
good.status in ('a','b','c')
gooddetail.status in ('a','b','c')


good.status沒有建index =>TBSCAN
gooddetail.status 有建index =>IXSCAN
good.status也可以調成or or的形式避免執行太久dead lock