Manual talk:IBM DB2

From MediaWiki.org
Jump to navigation Jump to search

DB2 Text Search[edit]

The following should be added once there is support for DB2 Text Search in MediaWiki:

Assuming DB2 Text Search is installed, enable the database for Full Text Search indexing. The following is a command line command.

db2text ENABLE DATABASE FOR TEXT CONNECT TO wikidb

leonsp 19:08, 29 October 2009 (UTC)

Debugging lock chain issues[edit]

This is a useful command for debugging deadlocks:

db2 get snapshot for locks on wikidb

Lpetrazickis 19:52, 12 April 2010 (UTC)

Free Db2-based IBM cloud instances?[edit]

IBM offers a Db2 cloud instance with 5 simultaneous connections and 100MB of data as part of its free "Lite" services tier. This might be useful for a small MediaWiki instance - or instances, even, seeing as you get four Cloud Foundry apps too; they apparently support PHP with 250MB RAM each.

Unfortunately there were issues with the new installer - just some of many. Proprietary database issues seem to have been low in priority and mostly noted with MSSQL but apparently impacting Db2 as well. Various fixes were deferred in 2011 and it seems these were never merged (perhaps overtaken by events). But it did work before; if anyone wants to get it going again, getting these installer fixes updated might be a good point to start. I imagine some of it would still be useful, even a decade on, at least from a perspective of "what does Db2 do differently". GreenReaper (talk) 20:14, 21 January 2020 (UTC)