• Add a Comment
  • Edit
  • More Actions v
  • Quarantine this Entry

Comments (4)

1 Wannes Rams commented Permalink

Thx for the tips Paul,

 
Here's one from me. IBM delivers some scripts to defragment your DB2 database data.
I have found them very usefull to improve performance in bigger environments.
You can find the wiki article here:
 
http://www-10.lotus.com/ldd/lcwiki.nsf/xpDocViewer.xsp?lookupName=IBM+Connections+4.5+Documentation#action=openDocument&res_title=Improving_access_performance_and_defragmenting_DB2_database_data_ic45&content=pdcontent&sa=true
 
You will use reorg that requires the Database to be down except when using transactional logging as Paul suggested already (that would also be my recomendation)

2 Paul Band commented Permalink

Thanks for your comment, Wannes. What do you reckon the best way to schedule a regular reorg would be? I'm guessing you could a) Use crontab to call the db2 script... db2 -tvf <reorgscriptname>.sql; b) Windows service to do the same; c) A DB2 scheduled maintenance job.</reorgscriptname>

3 Wannes Rams commented Permalink

I have used a and c in the past and both work fine. Depends on how the environment is managed. I would rather not rely on Windows services.

4 Gourishankar Menon commented Permalink

Nice article

Add a Comment Add a Comment