Offline issue tracking system?

http://stackoverflow.com/questions/3657650/where-can-i-find-a-comparison-of-distributed-and-offline-issue-trackers
http://stackoverflow.com/questions/2186628/textbased-issue-tracker-todo-list-for-git

Since our company work on customer's sites,
the Redmine hosted by the company is terribly slow.
And yes, our PM actually uses a huge Excel file for issue tracking.

So, I am looking for a GUI based issue tracking system somehow like Redmine,
which works offline and is able to push change when online.

But there seems no product meet my need...

DB2 LOAD 資料列順序

維持來源資料檔案的資料列順序
需要設定參數

CPU_PARALLELISM 1

否則某些設定下，當列數大於某個數目時，會自動啟動多緒讀取。(v9r7?)

效能較好，但會使資料列匯入順序變得無法預期。

Picasa (G+ photo) vs flickr 2013更新版

更新：
我的Flickr帳號被刪除 我建議大家離開Flickr
除非你想冒著所有照片和yahoo帳號一起被刪的風險
http://misivic.blogspot.tw/2015/04/my-flickr-account-was-deleted-without.html


如果可以爲了上傳最高解析度，忍受flickr比較慢的速度
=用flickr免費

如果可以爲了上傳速度，忍受G+的解析度限制
=用Picasa免費

要用到超過1TB，而且不屑註冊新帳號
=flickr付費

要用到超過15G而且你是Google信徒
=Picasa付費

Version control of database schema

After a very painful merge process, I come up with these practice.
Maybe not THE best practice, but at least these will eliminate most problems.
And NO, these practice only applies to database WITHOUT foreign keys and other dependency between objects.
By the way, I only worked with DB2.

1. One file per main object. Match the name of file and the object within. The idea is to follow the java object law.
2. If migrating from files with many objects, eliminate all diff noise before you do teardown.
3. Keep only ddl's, the final state of an object creating script. You also need a one-fits-all script to submit them all at one push.
4. Keep schema alteration SQL's in another folder, only in release branch or trunk per release. Version the whole folder, which means keep only those for the migration from the last release.

For anyone needs foreign keys and other dependency between objects, try to hack the object naming and let them work through your deploy script.

I hope these will work. Please leave comments!

Go! Go! Destroy! PPCC!

BiS rules!

Nozoshyan is so cute.

One line command to restart IDENTITY in all tables

One single line command to restart all IDENTITY columns genrate by default in all tables in SCHEMA 'db2inst1':

db2 -x "select 'SELECT ''ALTER TABLE DB2WMS.'||T.TABNAME||' ALTER COLUMN ID RESTART WITH ''||TO_CHAR(CASE WHEN MAX(ID) >= 500 THEN MAX(ID) + 1 ELSE 500 END) FROM '||T.TABNAME FROM SYSCAT.TABLES T,SYSCAT.COLUMNS C WHERE T.TABNAME = C.TABNAME AND T.TABSCHEMA = C.TABSCHEMA AND T.TABSCHEMA = 'db2inst1' AND T.TYPE = 'T' AND C.GENERATED ='D'" | db2 -x +p | db2 -v +p