Hi: This is a merge questions which has been posted and answered... in my case need more clairification when target table (tableB) matched multiple...

UDBDBA

04-07-2006 05:43 PM
UDBDBA

When I installed DB2 UDB 8.2 on AIX 5.3 it got installed in /home/db2inst1 (and I didn't care about it much then but now I would like to move the...

db2udbgirl

04-07-2006 04:31 PM
Gert van der Kooij

Hi all, After DB2 UDB V8 installation on Z/OS, we're having "SQLCODE = -107, ERROR: THE NAME TYPEREGIMEDOUANE IS TOO LONG. MAXIMUM ALLOWABLE...

GBO

04-07-2006 10:55 AM
GBO

can anyone help me writing a query that starts from the outer query selecting a few fields which are to be used in the nested subquery and the result...

mubashir.surury@gmail.com

04-07-2006 10:03 AM
Tonkuma

I'm driving Windows XP and could use a tip on installing a function written in Java. 1. I created the a Java jar file, named UdfUtils.jar, from the...

gimme_this_gimme_that@yahoo.com

04-07-2006 03:25 AM
Knut Stolze

Greetings, I recently being bugged by the following error on my DB2. SQL0902C SQLSTATE = 58005 Reason Code = 14 This error comes out everytime i...

jason.awlt@gmail.com

04-07-2006 02:48 AM
Knut Stolze

To reconfigure oracle9i from server to client operation, two files need to be modified: listener.ora (for the server IP address), and...

z

04-06-2006 10:09 PM
Mark A

Can anyone tell me why a EEE system might be created to have two separate tablespaces with the same 4k pagesize ? They both appear to be in use as I...

mike_dba

04-06-2006 06:29 PM
Mark A

Hi All Db2 v8.1.3 ,Windows I am seeing this message quite often in db2diag.log ADM5502W The escalation of "1205" locks on table "SYSIBM ...

Praveen_db2

04-06-2006 05:56 PM
Pierre Saint-Jacques

I am trying to laod 2 tables and set integrtiy on them, but the second tables fails ( both are related and SET INTEGRITY ion first table succeeds)...

technocrat

04-06-2006 05:50 PM
Pierre Saint-Jacques

People I am getting the following error in the db2diag.log file repeated over and over again with no apparent reason or...

p175

04-06-2006 05:03 PM
p175

We are moving from udb v7.2 to v8.2 (Unix) and have discovered a particular federated query runs 4 times as long with version 8. The migrate and...

Bob Long

04-06-2006 02:47 PM
Bob Long

Hi, now we have some troubles with restoring a db with the vendor apis of the backup and restore utility. We upgraded from db2 version 7 to version...

pukuri

04-06-2006 10:22 AM
pukuri

Have for some time tried to understand how parameter markers can be used in DB2 for z/OS (ver. 7) to avoid full prepare. Have tired with things like...

thomasb

04-06-2006 09:30 AM
thomasb

i have a batch file db.bat which will create the database and objects with in it. inside that batch file i'm trying to execute two more batch...

situ

04-06-2006 07:49 AM
situ

Hi All I am writing Import\Export routine in DB2 using stored procedure and front end as JAVA. For this I have two option 1) Writing five...

Suresh

04-06-2006 04:57 AM
Knut Stolze

Hi, This is probably a really dumb question but I have a table containing a varchar 4000 column. The app team is asking me to index this column...

mghale

04-06-2006 12:35 AM
Serge Rielau

Hi , I want to catalog a database and I have the follwoing information with me. Node name = abcdef Comment ...

bikkaran@in.ibm.com

04-05-2006 11:18 PM
bikkaran@in.ibm.com

Hi, I am trying to find a way to query for the (lock) blocking connection on my DB2 server. I am using DB2 for LUW 8.1 and 8.2. I have...

nielsgron@gmail.com

04-05-2006 08:31 PM
nielsgron@gmail.com

Hi DB2 8.1 FP 7a on AIX 5.2.0. Can anyone tell me how best to reduce high CPU (and subsequent high IO) associated with db2pfchr...

pike

04-05-2006 05:04 PM
Ian

Our company is now trying to make a "standard" of creating a base view for each user table. This initiative is suggested as a good practice by a data...

wxqun@hotmail.com

04-05-2006 04:58 PM
Phil Sherman

Hello, My question is a follow up on a recent thread (db2_evaluncommitted) If I have a table with say a million rows and a predicate of my...

Sumanth

04-05-2006 04:44 PM
Phil Sherman

Hi I am facing the problem while inserting the spanish characters in the DB2 UDB v8.2 database. We are pulling the data from SQL server...

pramod

04-05-2006 04:27 PM
Phil Sherman

I am creating a procedure A which is creating a global temporary table DECLARE GLOBAL TEMPORARY TABLE session.temp (Service...

chettiar

04-05-2006 04:15 PM
Serge Rielau

Hello, Linux RedHat AS4 running DB2 V8 FP11. I have followed the docs at http://tinyurl.com/qckrn and enabled automatic statistics collection. It...

Michel Esber

04-05-2006 12:03 PM
Pierre Saint-Jacques

Can anyone tell me why a EEE system might be created to have two separate tablespaces with the same 4k pagesize ? They both appear to be in use as I...

mike_dba

04-05-2006 11:38 AM
Bob [IBM]

HI All, I need some SQL help. I have a table that looks like this: Cat1 Cat2 Cat3 Subset ...

apattin

04-05-2006 10:55 AM
apattin

hi newsgroup, is there a way to pass a parameter (e.g. password) to a db2script? Example: db2cmd /c db2 -t...

Peter Postlbauer

04-05-2006 10:39 AM
situ

Hi all, I am using DB2 8.1.11.1 on NT with ASP.NET 1.1 When application make connection to database (via ADO.NET), it set "Connection timeout"...

ivb

04-05-2006 09:53 AM
ivb

Hi All, I am using IBM db2 version: 8.1.0.36. The following code: insert into t values (next value for s) gives me error saying "for" is an...

Ayusman

04-05-2006 02:21 AM
Ayusman

Does DB2 UDB Supports Exception Join? I think 'No'. Hence I used the following method to find out an functioanally equivalent exception join select...

db2udbgirl

04-05-2006 12:27 AM
Tonkuma

hi there i have a problem related to slow downloading speed.the situation is i have about 60 PC's in a domain.when i ping ISP Gateway from a LAN PC...

tsbgrp@gmail.com

04-04-2006 11:52 PM
Phil Sherman

Have found http://www-128.ibm.com/developerworks/db2/library/techarticle/lyle/0110lyle.html which is quite helpful, but doesn't quite tell me what I...

James Conrad StJohn Foreman

04-04-2006 04:45 PM
Serge Rielau

Hi all, We are using V8.1.9 (aka 8.2) and we are having an annoying issue with the Command Editor. It does not seem to remember, from session...

apattin

04-04-2006 02:57 PM
apattin

Hi all, I need some expert advice on a ROLLUP fine point. summary_table table has 4 columns: file_id primary_site morphology primary

apattin

04-04-2006 12:58 PM
Another DB2 DBA

Hi all: In the db2exfmt output, the following message appears: Extended Diagnostic Information: -------------------------------- Diagnostic...

UDBDBA

04-04-2006 11:04 AM
UDBDBA

When ever I start DB2, I get the message that APLD has been truncated and that I should add the param to the DB2 registry DB2NTMEMSIZE...

p175

04-04-2006 07:36 AM
Liam Finnie

I have restored a clients database using a redirected restore. However, it is in a roll forward pending state. When I try to to a roll forward to end...

darnold@carreker.com

04-04-2006 07:24 AM
DaveA

I am trying to load from a cursor which selects 124 million records...but while loading it completes the build phase and it stuck ...I think...at the...

technocrat

04-03-2006 04:20 PM
technocrat

Hi, We have the following scenario: 1) update table A by joining with a global temporary table B 2) There is a one to one correspondence between...

Sumanth

04-03-2006 03:25 PM
Ian

Hello, I'm somewhat new to DB programming and have a question. I am now taking over an application that a previous programmer had written and he...

Vaelek

04-03-2006 12:59 PM
Knut Stolze

Hi, I am using a DB2 table of size 100 thousand records in it, which does not have any relationship with other tables. When i tried to delete...

mike

04-03-2006 12:28 PM
Bernd Hohmann

Hi all, Does anyone know how to get the schema name given a JDBC Connection object? I see that I can do "toString" and pick the "User="...

apattin

04-03-2006 11:06 AM
apattin

I forgot to add that the isolation level was CS. Thanks, Sumanth "Sumanth" <Sumanth.Yamala (AT) sas (DOT) com> wrote

Sumanth

04-03-2006 09:50 AM
Sumanth

8.2. FP10 win32 I have a productive server and time to time have a trouble with: db2diag.log Insufficient memory available for IPC communication...

bughunter@ru

04-03-2006 09:39 AM
bughunter@ru

Eugene F wrote: Or Python or Ruby :-) (though, as I understand it, Perl is the only one with an "official" feature-replete driver from IBM; Ruby...

bikkaran@in.ibm.com

04-03-2006 05:11 AM
Anurag

My two ideas. 1) EXP(SUM(LOG(val))) But, this returns floating point number. So, exact value could not be received. 2) Use recursive query. (and...

Tonkuma

04-03-2006 03:55 AM
Knut Stolze

Hi, I had been campus recruited by IBM Global Services and after only one month training I am working as a DB2 DBA on client side for past...

Dibur

04-03-2006 03:46 AM
Knut Stolze

Gregor Kovač wrote: Have you opened a PMR to get let the developers know about it? -- Knut Stolze DB2 Information Integration Development IBM...

ianeruda@yahoo.com

04-03-2006 03:43 AM
Knut Stolze

Hi , During some bulk loading of data .. I am frequently encountering the "Transaction Log Full " error . I am using the " import " command...

bikkaran@in.ibm.com

04-03-2006 03:41 AM
Knut Stolze