DB2

CURSOR WITH RETURN AND UPDATE?
Within the confines of a stored procedure how do I declare a cursor to return a result set to the client application, and also update a non- returned attribute of each row? For example using pseudo-SQL, my non- functioning attempt: ================= declare curs1 cursor with return for select t_id, t_name ... 30 Sep 2009 10:06

Have you registered yet for Episodes 2 & 3 of The DB2Night Show on Oct 1 and 15th
Have you registered yet for Episodes 2 & 3 of The DB2Night Show on Oct 1 and 15th respectively? http://www.DB2NightShow.com His kickoff Episode on September 24th was a great success - if you missed it, a recorded replay is available. Episode 2 will be talking about Index Design for DB2 and Oracle and will also f... 27 Sep 2009 13:27

The database has been corrupted error in FileNet application.
im getting the below given error in FileNet application. Please tell me whether it is DB2 related or it is a non DB2 error. if it is other. can any one help me out in solving this. The Error is : com.filenet.api.exception.EngineRuntimeException;The database has been corrupted; the security id {2172A0E3-7CA9-446C... 25 Sep 2009 09:42

backup/restore from 32bit linux db2 9.1 to 64bit linux 9.7
Hi, I'm trying to migrate a database from a Linux-IA32 V9.1 server onto a Linux-x86-64 server running 9.7 What I get is SQL2570N An attempt to retore on target OS "Linux-x86-64" from a backup created on source OS "Linux-IA32" failed due to the incompatibility of operating systems or an incorrect specifcatino... 23 Sep 2009 14:25

CA IDUG Award for Outstanding Work in DB2
Submission date extended to Monday, September 28, 2009. See: http://www.ca.com/us/products/collateral.aspx?cid=201986 CA, in conjunction with IDUG and 4 renowned DB2 consultants, is proud to announce and solicit nominations for the CA IDUG Award for Outstanding Work in DB2®, which will be presented at IDUG Euro... 21 Sep 2009 12:16

New Event Type DLOCKWHISTAVAL in SYSCAT.EVENTS
Could someone notify IBM documentation that the event type DLOCKWHISTAVAL in table SYSCAT.EVENTS is not documented in either the 9,5 or 9.7 InfoCenter. This event type is created with the command: db2 "CREATE EVENT MONITOR evmondeadlock FOR DEADLOCKS WITH DETAILS HISTORY WRITE TO FILE 'path'" documented here... 21 Sep 2009 05:33

Database Migration
1) Is there any tool for v8 to v9/v9.5 migration 2) Can Migration just be done through backup and restore for v8 to v9.1 and v9.5 ? and config settings ? 3) is there any book or link that describes migration 4) Can we monitor progress of migration of large scale database ? would like to know more about database ... 20 Sep 2009 04:08

Info on HIPER APAR IZ50993
All, On this DB2 Fixpack 4a HIPER APAR page (http://www-01.ibm.com/support/ docview.wss?rs=71&uid=swg21396574), they mention this APAR: APAR IZ50993 (With AUTO_DEL_REC_OBJ = ON needed logs for retained backups may be deleted) The link to it, however, is broken and google didn't return any results either. Do... 17 Sep 2009 06:46

can't connect to database with client
Hello, I'm new to db2. I have Informix database on AIX and ODBC application on Windows. I'm trying to connect to Informix database using odbc client - I've downloaded and installed v9.5fp3_nt32_dsdriver_EN.exe (server side already configured). When adding new DSN with odbcad32 I'm executing following steps: selec... 14 Sep 2009 09:38

Another kind of join?
I'm thinking about a join that uses foreign keys to determine the on clause (contrary to the natural join which matches column names), let's call it relational join in lack of a better word. Does anyone know if such thing has been discussed in the sql community? In that case, any references? For example: 1) Wh... 8 Sep 2009 12:31