DB2

using List Tablespaces Show Detail to free pages
Hello, I have some machines at V8.2 (on AIX) that are showing large amounts of "Pending Delete" extents. I have used "list tablespaces show detail" to free these up on a couple of machine. However, I have some questions about how we can avoid getting into this situation and whether it is safe to free these up in... 2 Feb 2010 14:37

Collating seq of a table - copied from serverfault website
Hi Arun, SELECT * FROM table ORDER BY col1 COLLATE Latin1_General_CI_AS Is this possible in DB2? How? Try this: SELECT * FROM table ORDER BY collation_key_bit(col1, 'UCA500R1_S2') note that you can adjust the 2-nd parameter of this function according to your needs. For more info please read this: ... 11 Jan 2010 03:14

db2cli.ini
Hello, I need to add patch2=6 in db2cli.ini do disable scrollable cursor. Should I put this entry in all client machines accessing DB2 server via ODBC or just in the db2cli.ini of the server machine only ? Thanks, Max ... 11 Jan 2010 04:18

Communications problems
Running Express-C V9.7 on Linux, I've got one machine that (probably from my own messing around) has lost TCPIP communications. Note that it did work after installation. The problem I'm having is that I cannot re-configure the communications to TCPIP on that instance now. Using the "setup communications" action... 14 Jan 2010 14:38

logbufsz sizing
Hello, I've recently upgraded a number of DB2 (AIX) instances from v. 9.5.4 to v. 9.7.1, and I've set CUR_COMMIT to ON (yeah!). However, I have feeling that some DB configuration parameters might have to be adjusted because of this. Right now, I'm looking at the logbufsz parameter in a rather large datab... 11 Jan 2010 04:18

SQL code 437 in DB2 V9.5
Hi and happy NY2010 to all, after upgrading from DB2 V9.1 to V9.5.4 (AIX), we started having a problem with some SQL statements: certain (small) portion of (same) SQL statement executions end up with SQL0437 errcode (or rather: a warning code), while the rest (majority) of executions end normally. All state... 7 Jan 2010 09:02

if any - sql
If you have a index for name column, try select DISTINCT batch_id from tab1 t1 where exists (select 1 from tab1 t2 where name LIKE 'A%' and t1.batch_id = t2.batch_id) ; or select DISTINCT batch_id from tab1 where name LIKE 'A%' ; ... 6 Jan 2010 08:27

ALTER BUFFERPOOL in a Stored Procedure
DB2 ESE V9.5 on AIX Is there a way to perform the alter bufferpools command in a stored procedure...I seemed to remember running into something that said it was allowed but cannot find any information on how to now. As always thanks for the help. ... 6 Jan 2010 11:52

International Journal of Electronics, Information and Systems (IJEIS) Call for Paper
International Journal of Electronics, Information and Systems (IJEIS) Call for Paper The International Journal of Electronics, Information and Systems (IJEIS) publish original papers on all subjects relevant to electronics, computer science, communication network, and information systems. The highest priority will... 31 Dec 2009 08:46

Removing XML Extender
Hello, I'm trying to upgrade a DB2 v. 9.5.4 (AIX 64 bit) to version 9.7.1. However, db2ckupgrade complains: ADM4104E One or more databases are enabled for XML Extender. You must remove the XML Extender functionality from the instance and databases before upgrading. Please refer to the DB2 Information Center for ... 29 Dec 2009 17:29