Hi All: I use db2 v8 fp 14 on Aix. I am facing problems with a stored procedure that is causing a lot of locks and also goes in the lock wait state...

Racerx

07-07-2007 01:05 PM
Mark A

Hi to all, Can you make a (simple) example about logging table changes into a "log" table? It is possible using triggers? thank you JH

John Hopfield

07-06-2007 09:42 PM
Dave Hughes

Hi forum, I would like to save in a file all istance and mode parameters... howto ? I would like to store in a document all actual "good"...

Ganimede

07-06-2007 03:08 PM
Jan M. Nelken

I am running DB2 LUW 8.2.5 on AIX 5.3 I am being asked to rename an instance in Production which contains several databases. I am being told it...

datapro01

07-06-2007 12:09 PM
datapro01

Hi, I have executed a script of sql statements with a mix of sql and sql/xquery statements. To compare performance executions I have initiated a...

Robo

07-06-2007 10:06 AM
Robo

'IBM and AGS Ltd., a privately held purveyor of management solutions for data servers, announced that the new Server Studio and Sentinel R. 6.1 --...

ferdinandloius@gmail.com

07-06-2007 09:38 AM
ferdinandloius@gmail.com

I am getting a precompiler error which I don't understand. In my Cobol program I have the following code 01 TESTDB. 03 ADDR. EXEC SQL INCLUDE...

Steve Rainbird

07-06-2007 06:36 AM
Steve Rainbird

hi all! 2006-09-06-22.01.34.183570+540 I5679485A498 LEVEL: Error PID : 655366 TID : 1 PROC : db2agent (AMISDB)...

bea

07-06-2007 03:37 AM
bea

Does anyone know what db2dascln is and what it does?

Ross Mallett

07-05-2007 11:27 PM
Jan M. Nelken

Hi, I am writing a program to read database logs using db2Readlog/ db2ReadLogNoConn API. I am able to parse the data of "FIXED format data" and...

chandra.krothapalli@gmail.com

07-05-2007 06:13 PM
Bernard Dhooghe

I just finished one "quickie Email consult" for an old friend where we removed 70-75% of the lines of code and reduced the time from 98 minutes to 4...

--CELKO--

07-05-2007 12:25 PM
Brian Tkatch

Hi, We're looking at our options for purchasing or building an application inventory product to feed our Change Management and service...

mcewena

07-05-2007 08:56 AM
mcewena

the requirement that i have to meet is: (pseudocode): for each table in table_list loop: enable constraints on table to filter out all bad data...

amitabh.mehra@gmail.com

07-05-2007 07:20 AM
Serge Rielau

Hi all, we are adding a new tool for monitoring our DB2 UDB instances so any one help me to identify 1) what are all the possible parameter that...

kavin

07-05-2007 06:55 AM
kavin

I all I am trying to go into a loop to insert data into a new table, the loop is required because the select genearte to much data and...

cberthu@gmail.com

07-05-2007 03:02 AM
cberthu@gmail.com

Hi , Can anybody help me in taking up the database backup. I don't have any idea about db2 and know a bit in oracle. In oracle we can import and...

chinna

07-05-2007 12:52 AM
Jan M. Nelken

Hello all, what is the internal difference between the following two truncate table commands: db2 import from /dev/null of del replace into...

Stefan Mueller

07-04-2007 06:25 PM
Dave Hughes

Dear Gurus Please help. I have installed DB2 8.2 on AIX 5.3. No apparent errors while installing. I opted the defaults to create the instance...

LittleMaster

07-04-2007 03:32 PM
Arni

Hello, I'm having a big problem on one very important table in the system I'm developing. Everything started when I tried to insert some columns...

kruiz@tss.com.pe

07-04-2007 09:26 AM
kruiz@tss.com.pe

I have found an excellent resource on software quality assurance and software risk management. Worth...

martina.joseph27@gmail.com

07-04-2007 12:41 AM
martina.joseph27@gmail.com

When backing up a group of DB2 WSE v8.2 databases, I am getting the following error on one or two backups out of 38 being performed. "SQL2025N An I/O...

randi.clausen@illinois.gov

07-03-2007 03:47 PM
Lennart

Hi all, What are all the common problems or major issues a DBA can face? what are all the catagories in which problems arise in db2.. that can help...

kavin

07-03-2007 03:13 PM
Troels Arvin

Pessoal, Boa tarde!! A Stefanini Consultoria está com oportunidades com os seguintes skill: A escala larga da certificação da gerência do ciclo de...

Recrutamento_Stefanini

07-03-2007 11:53 AM
Recrutamento_Stefanini

3.2 is out! And it is awesome! The major theme of Release 3.2 is enhanced data visualisation and user interaction. We have not forgotten all the...

Yellowfin Public Relations

07-03-2007 08:33 AM
Yellowfin Public Relations

For anyone that is interested in this, this has been fixed by IBM as a result of the PMR we raised. It should be present in the fixpak due out in...

Weirdwoolly

07-02-2007 07:40 PM
db2start@gmail.com

Hi, I am connecting to a DB2 v7.1 server from windows using JDBC type 2 (I figured out that type 4 is only for 8 and upwards). I used DB2 Connect...

anokun7

07-02-2007 09:26 AM
anokun7

Consider the following... - A customer table with a customer number column as the primary key, and also a column called SHORTNAME. - An account table...

Frank Swarbrick

07-02-2007 08:07 AM
Brian Tkatch

Hi All, I'm familiar with the restore of single partition online backup taken with INCLUDE LOGS. Also familiar with the restore of multipartition...

beena

07-02-2007 02:49 AM
Ian

It seems IBM will offer DB2 on Solaris X86, does anybody know when it will be avalible.

Amber

07-02-2007 02:47 AM
hickeng@uk.ibm.com

Hello, I was trying to find the information about when and where should I use cursors in DB2, no luck. Maybe you can point me to some article...

Dima Kuchin

07-01-2007 08:18 PM
Mark A

Hi all, I have a strange (at least for me) things happening. I am save the result of an outer join into a file and I read this file and put...

cberthu@gmail.com

06-30-2007 08:44 AM
cberthu@gmail.com

Hi All, Can someone confirm if the daemon to start is db2jstrt (or db2jd) on an OS/390 DB2 host? I have read that this daemon is available on Unix &...

anokun7

06-29-2007 06:51 PM
anokun7

I have the following trigger that calls a DB2 stored procedure: DROP TRIGGER GGWU.TRI_A_MULTI_PROP@ CREATE TRIGGER GGWU.TRI_A_MULTI_PROP AFTER ...

yinzara@gmail.com

06-29-2007 03:13 PM
yinzara@gmail.com

Greetings, Now this query is making me crazy. Working on it for almost 2 hrs but no output Query: SELECT ACTIONEMAILTRANSID \ ,ITEMTRANSID...

pankaj_wolfhunter@yahoo.co.in

06-29-2007 12:38 PM
Dave Hughes

OK I'm trying to create a sql query on our as400. I have a main table like this: acct prf acct no. sku AAA 123 ...

Pythor

06-29-2007 11:19 AM
Tonkuma

it says that volatile tables (ALTER TABLE mytable VOLATILE CARDINALITY) do not use statistics. I would just like to clarify this statement. Does this...

Otto Carl Marte

06-29-2007 07:37 AM
Serge Rielau

Hello: We are trying to migrate DB2 Source: DB2 8.1 + Fixed Pack 5 on Sun Solaris -> Target: DB2 9.X on Red Hat Linux . using db2move command we are...

danths

06-29-2007 07:21 AM
Philip Nelson

I'm a UNIX person who is having difficulty understanding Windows security. I've got to install a DB2 server (initially Express-C) in a Windows...

Philip Nelson

06-29-2007 07:16 AM
Philip Nelson

Hi. I have created a table CREATE TABLE testschema.player ( country VARCHAR(80) NOT NULL, posn VARCHAR(2) not...

Rahul B

06-29-2007 05:13 AM
sandy

Hello, my tiny PHP5 test application cannot establish a connection to a database while I am able to connect to the same database using the...

michael.schmitz@tietoenator.com

06-29-2007 03:41 AM
Artur

Project monitoring, supplier agreement, measurement and analysis, quality assurance and a lot more to read and get benefit....

jimywillam@gmail.com

06-29-2007 12:18 AM
jimywillam@gmail.com

"Inspired" by the huge success of our first two automation fast track batches We are forced to start third fast track automation...

Sharath

06-28-2007 10:22 AM
Sharath

i am testing my DB for replication. Now 1 of the table AA is having large records and during its delete the corresponding CD table is just getting...

rahul

06-28-2007 06:30 AM
rahul

Hi, I receive the error code SQL0338N if I try to compile this statement (part of the statement): .... left outer join lateral (SELECT * FROM...

Sascha.Moellering@gmail.com

06-27-2007 07:56 PM
Tonkuma

Hi, I've a question concerning DB/2, dates and Java-binding-Variables: CASE WHEN MC.fixed_date_dat IS NULL THEN ? + MC.rel_shift_NR DAY ELSE...

Sascha.Moellering@gmail.com

06-27-2007 07:51 PM
Tonkuma

Hello, Help please, I use a Cobol program, that based on a DCLGEN input, creates a DDL file to create a test table. Typically my DCLGEN's are just a...

Graham Hobbs

06-27-2007 06:28 PM
Graham Hobbs

We are using DB2 v7 on OS/390. I have installed db2connect enterprise on my local windows XP box. Using db2connect I have created a dsn and could...

anokun7

06-27-2007 01:38 PM
anokun7

Hi, I'm trying to connect with db2 database using java and com.ibm.as400.access.AS400JDBCDriver, program is placed on AS/400. Everything is fine...

kabotnet@gmail.com

06-27-2007 02:11 AM
kabotnet@gmail.com

On Jun 25, 8:06 pm, Kiran Nair <kiranhariha... (AT) gmail (DOT) com> wrote: /sigh Thank you..I missed that in my haste!

shorti

06-26-2007 05:30 PM
Ian

Hi, i get the following error when running an embedded sql application on Suse (powerPC): SQL4903N The length of parameter "runtime_pid" of...

Vivek

06-26-2007 08:22 AM
Knut Stolze