Database Forum - DB2 Topics

Thread preview

Thread	Last Post	Replies

Backup database vs. Backup database at TS-level time differences	20 Feb 2007 19:35 GMT	1
Folks - DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08022" with level identifier "03030106".
DST and DB2 V9 Fixpak2	20 Feb 2007 19:32 GMT	2
Can anyone give us an ETA on fixpak 2 for V9? It has the recommended fixes for the DST change. Hey IBM, if you expect us to use this fixpak, it needs to be on our test systems ASAP. We are running out of weekends.
Need help with SQL query	20 Feb 2007 15:32 GMT	4
I need a help with the following problem: There's 2 tables tbla(primary, foreign, data) and tblb(primary, order) with data like this: tbla
Back Terminated to TSM - Media controller -- problem writing to vendor device. rc = -2025	20 Feb 2007 15:15 GMT	5
Hi Group, I'm running DB2 UDB Enterprise Edition V7.1 in AIX 4.3.3.0. And database backups goes to the TSM server. We have the following TSM Client API installed in the server:
Tablespace rollforward condition	19 Feb 2007 21:56 GMT	6
I have an oddity on a production database. I get the following from the DB CFG : Backup pending = NO Database is consistent = NO
db2 8.2 server install	19 Feb 2007 21:29 GMT	1
I have a server (win2k3) with the db2 8.2 runtime client already installed on it accessing another server on the network (running db2-8.2 with win2k). Would it brake anything on the win2k3 machine if I installed the db2-8.2 server to it?
GROUP BY problem in conjunction with a SUM()	19 Feb 2007 18:04 GMT	10
Perhaps some kind soul could help me out with an SQL I have been trying all day to get to work, where one colum is just not summing up the way I want it to. I have the following data
Db2 on AS400 SQL loggin	19 Feb 2007 14:50 GMT	1
Hello people, I am new to this platform and database. I need to analyze an application on the AS400 and therefore need to know the operation it does on the database.
Function on IBM web page not thread-safe?	18 Feb 2007 20:05 GMT	4
On the following page: http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0407zhang/index.html IBM discusses a surrogate key generation function, along with a listing in Java (Appendix A at the end of the web page). However it
query browser and administrator for DB2?	18 Feb 2007 00:46 GMT	3
I am new to DB2. I was wondering whether DB2 has a visual client that enables creating, executing, and optimizing SQL queries. Just like the Query Browser for MySQL. Also whether DB2 has a visual administration console that enables you
MQTs: Similar timeron costs, vastly different execution times	16 Feb 2007 18:12 GMT	2
Friends: I've been working on tuning a fairly complex--and certainly vexing-- query. Several days ago I created an MQT which aided the query and dropped its cost from 3.4 million timerons to around 650,000, enabling
DST Compliance	16 Feb 2007 17:55 GMT	3
Will someone (Serge wink-wink) weigh in on a DST question? I understand completely that DB2 relies on the operating system to retrieve the date. That said, DB2 will allow me to add time to a timestamp to the extent that DB2 will return an invalid time:
SQL Question	16 Feb 2007 17:03 GMT	4
DB2 V8 LUW. I have a simple table A with fields ID and SESSION_NUMBER (integer). One ID can have multiple session numbers. For a given ID, I can find the last two sessions with a simple SQL:
select distinct() with XML query functions.	16 Feb 2007 07:54 GMT	3
I'm really stuck with getting the right output from a XML query. Given this structure: create table GENCMP.SCRIPTS (
Is there a way to drop DB2 database buffer pool without connecting to database?	16 Feb 2007 06:29 GMT	6
We are having a situation here whereby one of our staff created a very huge 32K buffer pool in a production database and caused the database to go down. When we try to reconnect to the database using "db2 connect to <dbname>", its giving the following error: