Hi, I'm using Automatic Maintenance on a 9.1. database, offline backup is set to 'Optimize for database recoverability (more frequent backups)'...

Gunther.Schnitzel@test.com

03-18-2009 06:46 AM
Gunther.Schnitzel@test.com

I am working on the data design of a new version of a very popular web-facing application. The application deals with ~3 million new customer records...

Steve

03-07-2009 07:33 AM
Steve

Hi, We've used db2 udb 8 (on Windows) for a few years now and recently swapped to version 9. I've only just noticed that there is a big difference...

Roger

01-16-2009 01:43 PM
Roger

Hi all, I am trying to install db2 verin 9.5 in an AIX lpar 5300-08. The db2setup crashes my putty session, if I try exec ./db2setup. even though I...

David Evans

10-21-2008 12:30 PM
David Evans

I have a database that has considerable skew in the values of the columns in different tables and it is evident in reposnce times when i run the...

TMAG

05-05-2008 06:14 PM
TMAG

Hi All Gurus, I would like to know if any of FREE DB2 UDB edition comes with MDC ( multidimensional cluster index) feature included ? What DB2 UDB...

IGhipp

03-12-2008 06:56 PM
Blair Kenneth Adamache

If i do "db2 disconnect all" after an application finishes, does it mean that any application that connects after this will find the buffer pool...

TMAG

03-04-2008 12:24 AM
TMAG

Hi, We're using DB2 UDB 8.2 FP 4 (8.1 FP 11) on Windows 2000 Servers. I have a third party application whose code appends the OPTIMIZE FOR 1...

Julian Nesci

03-03-2008 08:52 PM
CRPence

Hi, I did a fresh install of DB2 8.1 with fixpack 16 on 64 Bit Linux for Intel (DB2/LINUXX8664 8.2.9). Install completed without any errors. Next I...

Louis Wevers

02-29-2008 04:47 AM
Louis Wevers

Has anyone noticed that DB2 will not install on FC8 and if you force an install that it does not run correctly?

G.S. Link

02-08-2008 03:16 PM
G.S. Link

When I use DB2 Command Editor to run query, the tool shows a windows with running time. However, when the query completes, the window is gone. How...

Luke Xu

02-06-2008 11:29 AM
Blair Kenneth Adamache

Hello, I would like to hear from anyone here who has converted their SAP Oracle database to IBM DB2 database? Did you realize greater disk saving...

Charles Davis

02-05-2008 07:54 PM
Charles Davis

LinkedData Planet will run June 17-18, 2008 at the Roosevelt Hotel in New York City. The call for speakers is open until February 15, 2008. To...

Ken North

01-28-2008 04:43 PM
Ken North

Hi all, without considering DMS in a device, normally, the simplest choices are SMS or DMS in files. Is there any performance improvement using a DMS...

netzorro

01-03-2008 05:14 AM
Knut Stolze

Hi, I've got the following table: $ db2 describe table li.organization Column Type Type name ...

Kenneth Stephen

12-11-2007 08:12 AM
Kenneth Stephen

I am trying to install DB2 v8.2 (the version we currently use in our shop) on a machine where we had previously tried to install DB2...

Dan Antion

11-29-2007 06:26 PM
Dan Antion

I would like to try the new DB2 9.5 version. Well, I tried to download the eval version but, once in the download page, I'm not able to find the...

dwforums@us.ibm.com

11-26-2007 08:54 AM
Blair Kenneth Adamache

Hi,<br /> <br /> I have installed DB2 V8 with FP 9.Now i need to upgrade it to fixpak 13. But when i run the installFixpak command ,its giving error...

elza

11-24-2007 04:25 PM
Larry

I want be able write some information from db2 inserts into Windows Application Log. I try use log4j's NTEventLogAppender within java stored...

dwforums@us.ibm.com

11-23-2007 02:30 PM
Knut Stolze

Hello,<br /> <br /> We want to migrate a (SAP) database from AIX DB2 V7 to SUSE 10 DB2 V9.<br /> We are thinking about using the db2move to do...

dwforums@us.ibm.com

11-23-2007 02:28 PM
Knut Stolze

Hi,<br /> <br /> sqlcode -811 means, that the result of your SELECT on the right side of the = operator returns more than one value, which cannot be...

Andreas Kannegiesser

11-23-2007 11:11 AM
Andreas Kannegiesser

Hello,<br /> <br /> We want to migrate a (SAP) database from AIX DB2 V7 to SUSE 10 DB2 V9.<br /> We are thinking about using the db2move to do...

dwforums@us.ibm.com

11-23-2007 07:08 AM
dwforums@us.ibm.com

hello kelly,<br /> <br /> thanks for support... i cleard the issue .....<br /> <br /> thanks & regards

Sreecharan Babu.C

11-23-2007 01:29 AM
Sreecharan Babu.C

hello friends,<br /> <br /> thanks for support ... its working with db2inst1 instance....... issue is cleard

Sreecharan Babu.C

11-23-2007 01:26 AM
Sreecharan Babu.C

Hi,<br /> <br /> As above.<br /> <br /> TIA !

dwforums@us.ibm.com

11-22-2007 10:02 AM
Doug Doole

Hi,<br /> <br /> If you are installing DB2 9.5 Express C on Vista, it is recommended to right click on the setup.exe and run as administrator.<br...

dwforums@us.ibm.com

11-22-2007 06:42 AM
dwforums@us.ibm.com

Hi,<br /> <br /> This info is not available even on the information centre. However, to configure many databases for HADR, you certainly need a very...

dwforums@us.ibm.com

11-22-2007 04:26 AM
dwforums@us.ibm.com

Hi,<br /> <br /> You need to do a trick with few OS Commands (if you are working on Linux). Issue following command on $ prompt for exporting a table...

dwforums@us.ibm.com

11-22-2007 04:20 AM
dwforums@us.ibm.com

Hi Rajesh,<br /> <br /> To obtain the DDL of this database, you can use db2look command.<br /> <br /> Deogirikar.

dwforums@us.ibm.com

11-22-2007 03:38 AM
dwforums@us.ibm.com

Hi, We have installed DB2 V9 on AIX with DPF enabled. But when we try to start the instance its giving this error. SQL6048N A communication error...

elza

11-05-2007 06:19 AM
Knut Stolze

Apparently someone decided VM and VSE systems weren't sufficiently important to include in the list of "Other Systems" that could be specified and...

11-03-2007 09:13 AM
Richard Lyko

Hello I am looking to set an automated task to run against the Resource Manager DB in order to migrate data from Content Managers LBOSdata directory...

11-03-2007 06:22 AM
Richard Lyko

Hi! I'm new to DB2 and here is my situation. I catalog a node called MVSC on an AIX machine with DB2 client v7. The connection is to remote...

11-02-2007 05:28 PM
Mark A

Hi, I cannot install DB2 8.2 server edition on Windows XP Home edition. I have already installed WBIMB 6.0 on my PC. Could any one suggest me what...

11-02-2007 12:53 PM
Larry

I am having some problems with the IBM DB2 client for Windows. When I first installed the IBM DB2 client, the Client Configuration Assistant had the...

re01992

11-02-2007 12:41 PM
re01992

I'm a developer, and I need this crucial information to support one of my customers. How does db2 rollforward log work? Is there a standard API or...

11-02-2007 04:13 AM
Knut Stolze

Hi All, I have DB2 v7.1 running on my linux machine. It try to export my data from my table using EXPORT function but fails. But the strange is...

11-02-2007 04:06 AM
Knut Stolze

Hi all, I have a perplexing DB2 Drop command situation. Environment I have tried severally to drop Foreign Key constraints on a set of tables and...

11-01-2007 09:40 PM
Ian

HI db gurus ; I am trying to implement replication process from db2 udb v8 to db2 udb v8 on my personal pc for which I am following the sample...

11-01-2007 06:46 PM
Larry

Hi, The IDENTITY_VAL_LOCAL function does not seem to return the last generated identity value when the INSERT code within a MERGE statement is...

Keith Eberle

10-31-2007 11:15 AM
Keith Eberle

Is there a document where I can get the instructions for Kerberos authentication on DB2 UDB for Windows with Active directory usage ? I have the 9.1...

10-31-2007 09:10 AM
Blair Kenneth Adamache

Hello all! I have i small problem that I need to get some answers to. I have searched the documentations on DB2LUW V8 but can't find the right...

10-31-2007 08:09 AM

Hi , I have installed alphablox Version 8.4.0 Build 118 and IBM WebSphere Application Server Version 6.0.2.0. It was working fine. But two days...

elza

10-31-2007 03:37 AM
elza

Hi , LEVEL: Severe (OS) PID : 389298 TID : 1 PROC : db2agent (test) 0 INSTANCE: db2inst1 NODE : 000 DB : TEST APPHDL : 0-998 APPID:...

elza

10-31-2007 03:34 AM
elza

I have one AIX box in that serveral applications are connected to the DB2 Database.The system performance is very slow now... How we can check...

elza

10-31-2007 03:31 AM
elza

hi, i am new db2 admin our database face lock problem many time i know locking is database function but because of that our application stop working...

10-31-2007 01:11 AM
Priyanka

I have db2 8.2 installed on LPARs with RHEL 4.3 on a IBM pSeries p570. I upgraded a LPAR from about 7,5GB to about 10,5GB. Before upgrade I had a...

10-30-2007 12:39 PM

Could you please brief about the status "Pending remote request" and "UOW waiting".

10-30-2007 08:52 AM

I checked these all out and it seems they are being sold....well, the domain is at least. Looks like the sites are optimized as...

Luis

10-29-2007 09:01 PM
Luis

Hello, I have several db2(8.2) databases cataloged on my machine. My machine is Windows 2000. Sometimes I run into problem that connection limit in...

10-29-2007 02:07 PM