|
FREE CODE DOWNLOADS FOR THE DB2 UDB DATABASE (Linux, Unix, Windoze)
It took me a long time to figure some of this stuff out! All software provided through these pages has been tested on DB2
systems up to DB2 UDB V8.2 Fix Pack 11. Most of it is my own work, but sometimes the original germ
of a creative idea came from elsewhere, and sometimes colleagues and I have been through an iterative process of improvement
and refinement. I would like to thank especially Enzo 'Nonsenzo' Siri and Dan 'The Man' Day. You're very welcome to use and
share all code here, in the hope that the time it saves you will allow you to do something more worthwhile!
All software provided here is 'copyleft' - that is, you are positively encouraged to download it, modify it as you see fit and
distribute it free of charge, in the best traditions of Open Software and worldwide collaboration.
There are only 3 conditions:
- You keep comment lines specifying the original author and purpose in place
- You comment any amendments to the original, particularly in an amendment history.
- You do not sell or charge for it.
Usual disclaimers: we accept no responsibility, give no warranty, no guarantees express or implied, at your own risk blaa blaa etc.
Periodically I'll add a fresh snippet of reusable application or administration code:
All files (except tars and gzips) have DOS carriage return line feeds to ease viewing through a Window$ browser.
In Linux and Unix, CR-LFs will display as ^M characters, but are easily removed by: cat filename | tr -d '\015' > newfile .
Mar 2006 | best_pagesize.sql | Calculates a 'best fit' pagesize for application tables. See comments for further detail. |
Mar 2006 | db2cols (ksh) | Is it reasonable of DB2 to expect you to type out a long list of column names, when it already knows what they are! This utility adds a DB2 column list at the edit insertion point. |
Apr 2006 | online_reorgs (tar.gz) | DB2 UDB Special! Complete online REORG suite for V8.2 including RUNSTATS and best index selection algorithm, fully commented. |
Apr 2006 | type1_index (ksh) | Discover and convert any type-1 indexes left over since migrations from earlier releases. |
May 2006 | BO DB2 Harmony.doc | Analysis and suggested configuration for Business Objects reporting over DB2 UDB databases. |
May 2006 | test_indoubt (ksh) | Simple background or foreground continuous check for indoubt transactions in distributed environments. |
Jun 2006 | find_invalid_procedures (sql) | Identify any invalidated, compiled stored procedures still hanging around after upgrade to V8.2; a db2rbind will generally take care of these. |
Jun 2006 | 5NF.sql | A table is in fifth normal formal form if all columns form part of the key. 5NF tables need special treatment in SQL Replication, since an update needs to be treated as a paired insert/delete. Find all database tables in fifth normal form, and update the SQL Replication REGISTER table. |
Jul 2006 | snapshot (ksh) | Prototype snapshot script in response to reports of a generalised performance malaise at a client site. This one focuses on database global memory on a single partition instance, gathering bufferpool and sort activity over a 48 hour period, but can easily be adapted to wherever you feel the problem lies. The stats gathered, allied with db2mtrk, vmstat, iostat etc. then allow subsequent drilldown to the root causes. |
Jul 2006 | pension (ksh) | A little light-hearted fun: use DB2 to calculate how long you wait until you can draw a pension and display the results in a highlighted box. |
Aug 2006 | distribution checker (ksh) | Checks your DPF table data is evenly distributed across the partitions for its tablespace. |
Aug 2006 | strip repeat blanks (sql)Recursive SQL to remove surplus spaces from text strings, leaving just one space between words. Useful for name and address cleanup. | |
Feedback
Was this useful? Please tell us of your experience with the download software. We will not use your personal details for anything other than
responding to comments where you request a reply. Please reply to feedback@sustainablesoftware.net
|