četrtek, 31. januar 2008

Total size of a table in DB2

If you wonder how to get the total size of a table in DB2 you can use following SQL statement which gives you 30 largest tables:
SELECT TABSCHEMA, TABNAME, DATA_OBJECT_P_SIZE + INDEX_OBJECT_P_SIZE + LONG_OBJECT_P_SIZE + LOB_OBJECT_P_SIZE + XML_OBJECT_P_SIZE AS TOTAL_SIZE FROM SYSIBMADM.ADMINTABINFO ORDER BY TOTAL_SIZE DESC FETCH FIRST 30 ROWS ONLY WITH UR

Total size here means size of data + size of indexes + size of long objects + size of LOB objects + size of XML objects.
More about this can be found at IBM DB2 InfoCenter or directly here.

New ATI drivers and hibernate

As you might remember I didn't have ATI drivers enabled since hibernate did not function correctly. Couple of days ago I installed ATI driver version 8.452.1 and hibernate does work.

ponedeljek, 21. januar 2008

GNUCash

For the past 18 days (yes, New Years' resolution) I've been using GnuCash for managing my finances. The biggest problem I've seen with it it that you cannot protect the file where transactions are written.
Today I came across a Wiki entry how to encrypt that file using GnuPG.
This script can be also used for other applications, not only GnuCash.

petek, 18. januar 2008

Software development process

Colleague pointed me to this post. Does it sound familiar ? :))

sobota, 12. januar 2008

Changing the CVS keywork substitution mode

If you want to change the CVS keywork substitution mode, you unfortunately cannot do it with NetBeans, but you can use this few steps:
- let's say the new keyword substitution mode should be -kkv
- cvs admin -kkv File.java
- cvs update -kkv File.java
- edit the File.java to change it a bit
- cvs commit -fm "Change substitution mode" File.java

I've used this on number of files, so it does work.

History of CVS changes

If you want to know what you and your colleagues changed in a period of time in the whole CVS managed project, just right click the root directory of the CVS managed project and use Search history command. There you can search by revision or date. Great. :)
You can for example see how much work did you do in year.