Hi! I was trying to setup a HADR for the sample database on two servers under the windows environment. I am using IBM DB2 9.5 FP "0" and windows...

rakeysh

08-12-2009 02:00 AM
rakesh

DB2 InfoSphere Warehouse 9.7 on Red Hat Linux (previously known as DB2 ESE with DPF feature). Is one supposed to create an instance on each physical...

Mark A

08-11-2009 04:39 PM
Mark A

I would like to use CC GUI to compare the data via SQL in two databases. It only seems to like one connection at a time.

JAW

08-11-2009 04:21 PM
Mark A

Helpful folks, Environment: Server - Win2003 Enterprise Edition - DB2 V8 FP16 - SRVCON_AUTH=CLIENT Client being installed - V9 FP6a - v9.1.601.768...

Scav

08-11-2009 09:11 AM
Scav

DB2 InfoSphere Warehouse 9.7 on Red Hat Linux (previously known as DB2 ESE with DPF feature). Has anyone used bash shell (default for Linux) on the...

Mark A

08-11-2009 02:13 AM
Ian

DB2 V9.5 on AIX, Is there a command/API that works like db2export but doesnt require all transactions on the table to be stopped? I just want to...

shorti

08-10-2009 09:02 AM
stefan.albert

The International DB2 Users Group (IDUG®) is accepting presentation abstracts for IDUG 2010 - North America, May 10-14 in Tampa, Florida. This is...

UDBDBA

08-09-2009 09:12 PM
UDBDBA

Just a question, I did a research, I just found this: IBM Said: "Hardware, operating system, and version of DB2 UDB must be identical to those...

ric

08-07-2009 05:08 PM
ric

Hi Is there any document describing the entries found in the snapshots Thanks Sivaswami

Sivaswami Jeganathan

08-07-2009 09:00 AM
The Boss

When I was going through a blog post - http://www.catterallconsulting.com/2009/07/outer-join-get-predicates-right.html I became amazed that the...

Arun Srinivasan

08-06-2009 09:18 PM
thatdbaCLK

When DB2 does a list prefetch (NOT range prefetch), does it fetch single pages into the buffer pool or whole extents?

Willem Fischer

08-06-2009 06:19 AM
Willem Fischer

Hello, How do you map CHAR FOR BIT DATA in Java; if I have a column F1 using this type, the db2dclgn tool generates a "java.lang.String f1;"...

Jean-Marc Blaise

08-03-2009 12:49 PM
Jean-Marc Blaise

Serge: Thanks for the prompt response. Our version is DB2 for z/OS, but I do agree that your points seem relevant, at lest in this case. The...

WalterR

08-01-2009 03:19 PM
Serge Rielau

Yellowfin, leading web-based Business Intelligence software providers, today announced the release of Yellowfin 4.1, the next generation of the...

JTP PR

07-31-2009 05:53 AM
JTP PR

I want to copy the data of all tables from database A to database B, which are already defined and are sitting on different aix servers. Basically,...

Puer_Apuliae

07-30-2009 04:58 PM
Willem Fischer

If I create one of these using DECLARE (not cataloged) and insert and then delete no more than 20 256-byte rows again and again, and if this would...

WalterR

07-30-2009 02:16 PM
Serge Rielau

Hi, I would like some opinions about declaring UUID as PK in a database, compared to identity or sequences: * portability issue, making db...

Jean-Marc Blaise

07-28-2009 10:25 PM
--CELKO--

I have a script that looks like this: I'm not getting the syntax for declaring a continue handler. I have: set path...

gimme_this_gimme_that@yahoo.com

07-27-2009 05:04 PM
Serge Rielau

Hello to everybody ! i've a big big problem ! i've a SSIS 2008 Project with as data source a AS/400 DB2 database, my destination is a SQLServer...

Joe ALVES

07-27-2009 01:36 PM
Joe ALVES

We are using db2 9.1 fixpak 6a and everey 30 seconds the following message appears in the db2diag.log: FUNCTION: DB2 UDB, Self tuning memory...

tg

07-27-2009 11:00 AM
Frederik

Hi there, were there changes to the handling of ssl in 9.7 express-c? i had a non-root installation of 9.5 data server runtime client in my...

Christian Welzel

07-25-2009 04:28 AM
Christian Welzel

From the manual: If blk_log_dsk_ful is set to no, then a transaction that receives a log disk full error will fail and will be rolled back. In...

Frederik

07-23-2009 08:36 AM
Frederik

DB2 Version 9.1 fixpack 7 (64-bit) on Windows 2003. A jdbc application (connecting from a 32bit client also v9.1 fp7) gets a database error when it...

mike

07-23-2009 05:52 AM
mike

Hi I have a need to bring some *ixf files over from mainframe to distributed AIX (to load into UDB databases) How do we ftp files from mainframe to...

brg

07-22-2009 12:24 AM
Mark A

With SQL Replication, is there a limit to the number of rows that asntdiff will compare between the source and target? I ran asntdiff in one...

L Jackson

07-16-2009 03:22 PM
L Jackson

Version: Command Line Processor for DB2 ADCL 9.1.7 I've turned on the UOW flag: db2 get dbm monitor switches DBM System Monitor Information...

Evie

07-16-2009 11:06 AM
Evie

Hello, Shortly I will be migrating an instance to a new hardware box. The instance I am moving has over 60 remote catalog entries in it. Is there a...

peter sands

07-15-2009 11:37 AM
Sawan

Hi Friends, DB2: v8/v9 OS: AIX/Win XP/2000 (In fact DB2 version & OS type/version doesn't matter much in this context) I have heard that disk space...

satish mullapudi

07-15-2009 03:19 AM
sandeep.iitk@gmail.com

Hi Guys, We are updating an old z/OS DB2 version 7 system to version 8 compatibility mode in the near future. We have discovered an application...

pmerrett

07-14-2009 10:31 PM
Larry

When creating a table, you can use generated columns such as ...GENERATED ALWAYS AS (UPPER(col_a)) However, when altering a table, you can't add in...

ChrisC

07-14-2009 01:18 PM
Lennart

I have a questions about health indicator "db.db_backup_req". I've got a clent who runs backup scripts every night at midnight (verified as...

Puer_Apuliae

07-13-2009 04:53 PM
Puer_Apuliae

Hallo:) Does anyone know of a way to put a byte array into a BLOB column with "normal"( not prepared) INSERT statement? I can convert a byte into a...

entinaia

07-13-2009 06:10 AM
David Adler

I was under the impression, after I took the IBM DB2 V9 transiton course, that there was a way to use hints to force db2 to use an index. I believe...

tg

07-10-2009 10:35 PM
tg

Hello I've run reorg on some tablspace - db2diag.log shows MESSAGE : Reorg table failed. DATA #1 : String, 72 bytes Table(24:4)=SAPPRD...

michalp

07-10-2009 05:07 PM
Ragu

Hi all, several presentations for DB2 9.7 announced that it will be possible to connect to a HADR standby database and run queries. It was said that...

Joachim Klassen

07-10-2009 04:05 PM
Steve Pearson (news only)

I received the following error: SQL1420N Too many concatenation operators. What is the hard limit on string concatentations on DB2 9.1? Or is this...

Otto Carl Marte

07-10-2009 05:37 AM
Otto Carl Marte

Hello, Does anyone know of a way to reset the Maximum total log space used (tot_log_used_top) monitor element? It can be found in the...

Frederik

07-09-2009 07:34 AM
Frederik

Yellowfin Business Intelligence scales to the heights of the cloud Business intelligence (BI) firm Yellowfin has launched a new version of its...

JTP PR

07-09-2009 06:42 AM
JTP PR

My head is spinning before setting up the DB2 instance for the first time (It was much easier when I did for the mySQL). I installed the DB2-Express...

qazmlp1209@rediffmail.com

07-08-2009 09:52 AM
Serge Rielau

Hi , I need to change UDB database name because of corporate name was changed. This database contains many replicated tables from different...

db2dba

07-08-2009 09:35 AM
Spider

Hi all, when I install DB2 9.5 on Windows using the C: drive for the installation path (eg. C:\program files\sqllib) the db2 setup routine always...

Joachim Klassen

07-08-2009 06:29 AM
Joachim Klassen

Hello We have stored procedure which iterate on required tables and makes REORG. It was working on DB2 8.2 Now we are moving to DB2 9.5 fp3 and...

J.Kubica

07-08-2009 03:14 AM
J.Kubica

Friends, Within a store procedure, I need to get the next value for a sequence, but I want the (schema) reference to the sequence to be inherited...

jefftyzzer

07-07-2009 01:11 PM
jefftyzzer

Hello, Is EXPORT with DECRYPT() of the data and re-LOAD & ENCRYPT() with new Encryption Key the only way to modify / change / alter the Encryption...

ekmunar@yahoo.com

07-07-2009 10:21 AM
Serge Rielau

Friends, Within a store procedure, I need to get the next value for a sequence, but I want the (schema) reference to the sequence to be inherited...

jefftyzzer

07-06-2009 03:11 PM
jefftyzzer

Colleagues, I'm trying to troubleshoot some performance issues pertaining to an SP. Despite setting/calling CALL...

jefftyzzer

07-06-2009 04:54 AM
Serge Rielau

I am noticing lot of data page reads during an insert ( ~ 50 - 100 records) to a mdc table ocationally, sometimes as high as 100k. There are no page...

span4d

07-03-2009 01:04 PM
rohan

Hello I'm trying to run simple stored procedure written in COBOL on DB2. However I have no idea how to force it to work... :) Procedure code is as...

melmack

07-02-2009 10:49 PM
Jan M. Nelken

I am executing db2 select * from <table> where something = something, and i only want the results to return matches - IE nothing where there are 0...

tntelle

07-01-2009 07:09 PM
Serge Rielau

CALL SYSPROC.ADMIN_CMD ('export to /home/db2/tst.del of del select * from db2.employeee where empno='1' ' ) SQL0104N An unexpected token "1" was...

SP

07-01-2009 03:40 PM
SP