developerWorks: Message List - DB2 for Linux, UNIX, and Windows http://www.ibm.com/developerworks/forums&ca=drs-fo RSS of en Thu, 26 Nov 2009 01:34:45 -0500 Re: Simulating MySQL/Postgres LIMIT OFFSET feature in DB2 http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14411067&tstart=0#14411067 with DB2 9.5 setting the DB2_COMPATIBILITY_VECTOR=3 (db2set DB2_COMPATIBILITY_VECTOR=3), you can use

WHERE ROWNUM BETWEEN n AND m ORDER BY ID

Regards
Massimo]]> Wed, 25 Nov 2009 09:44:28 -0500 Wed, 25 Nov 2009 09:44:28 -0500 Wed, 25 Nov 2009 09:44:28 -0500 Nov 25, 2009 mmontecchi 0 Re: ADM7518C : <dbName> marked bad in v9.7 http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14410981&tstart=0#14410981
The error seems to be similar, but if IBM has fixed it in v8.2 fixpack 8 , I am not sure why does it happen in v9.7]]> Wed, 25 Nov 2009 06:28:25 -0500 Wed, 25 Nov 2009 06:28:25 -0500 Wed, 25 Nov 2009 06:28:25 -0500 Nov 25, 2009 Sreejith 0 DB Connectivity Issue http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14410544&tstart=0#14410544 ...]]> Tue, 24 Nov 2009 08:02:02 -0500 Tue, 24 Nov 2009 08:02:02 -0500 Tue, 24 Nov 2009 08:02:02 -0500 Nov 24, 2009 R.K.Nair 0 NEED YOUR HELP PLEASE http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14410530&tstart=0#14410530 ...]]> Tue, 24 Nov 2009 06:34:37 -0500 Tue, 24 Nov 2009 06:34:37 -0500 Tue, 24 Nov 2009 06:34:37 -0500 Nov 24, 2009 gtakusi 0 Re: DIA8309C Log file was full? http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14410505&tstart=0#14410505 Tue, 24 Nov 2009 05:35:23 -0500 Tue, 24 Nov 2009 05:35:23 -0500 Tue, 24 Nov 2009 05:35:23 -0500 Nov 24, 2009 sakumar9 0 Re: how to set time on db2instance http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14410502&tstart=0#14410502 Tue, 24 Nov 2009 05:24:02 -0500 Tue, 24 Nov 2009 05:24:02 -0500 Tue, 24 Nov 2009 05:24:02 -0500 Nov 24, 2009 sakumar9 0 how to set time on db2instance http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14410421&tstart=0#14410421 would like to seek your advice. How to set time for db2 instance? our db2 is running on AIX. is the db2 time will automatically sync up to server time? Hope to hear from you. Many thanks in advance]]> Mon, 23 Nov 2009 22:19:22 -0500 Mon, 23 Nov 2009 22:19:22 -0500 Mon, 23 Nov 2009 22:19:22 -0500 Nov 23, 2009 apple08 1 Re: AIX & DB2 http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14410298&tstart=0#14410298
DB2 v9 can also be uninstalled by using the program db2_deinstall located under /opt/IBM/db2/v9x/install path.
Another way is use SMIT tool.

Regards,
Wiliam]]> Mon, 23 Nov 2009 12:45:17 -0500 Mon, 23 Nov 2009 12:45:17 -0500 Mon, 23 Nov 2009 12:45:17 -0500 Nov 23, 2009 wiliam 0 Re: Why must a HADR-pair have two different HADR-port's? http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14410210&tstart=0#14410210 ...]]> Mon, 23 Nov 2009 09:36:15 -0500 Mon, 23 Nov 2009 09:36:15 -0500 Mon, 23 Nov 2009 09:36:15 -0500 Nov 23, 2009 Ulli_Z 0 Re: Data in Batches http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14410084&tstart=0#14410084 http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.apdv.porting.doc/doc/c0052882.html

ROWNUM is the function.]]> Mon, 23 Nov 2009 03:13:16 -0500 Mon, 23 Nov 2009 03:13:16 -0500 Mon, 23 Nov 2009 03:13:16 -0500 Nov 23, 2009 Saurabh.Jain 0