Hi all - Not sure if this question has been asked before (I searched but couldn't find anything) but is there a way to directly execute a stored...

Kevin

11-27-2007 12:41 PM
Kevin

Hi, Requirement, Position DB2 DBA Location ; Lewiston,maine

Jay_Lgx

11-27-2007 10:41 AM
Jay_Lgx

Hi, Is there any way to find the SQL that is causing the Locks. I am using SYSPROC.SNAPSHOT_LOCK to find out the locks on the table, but i am...

Rahul Babbar

11-27-2007 10:30 AM
Otto Carl Marte

Can anyone answer this question with certainty? I'm playing with Discovery. I have a very simple network with two PCs connected to a router via...

rhino

11-27-2007 01:55 AM
rhino

I am trying to create a second instance on a Windows XP machine that has DB2 Personal Edition installed. It's not going awfully well so I thought I'd...

rhino

11-27-2007 01:36 AM
rhino

Running DB2 8.2.5 and 9 with fix pack 2. Is there any way to update a table space level health indicator command line or do you have to use the...

datapro01

11-26-2007 10:40 PM
Serge Rielau

I am working on a few queries that require comparing data from several tables. I was curious if anyone had any suggestions on ways to get the best...

shorti

11-26-2007 06:59 PM
shorti

hello, I need to use commands mentioned in title in my c# application, I know about REXX and SQLDB2 API, but I want create independent...

Sebastian Ciesielski

11-26-2007 02:44 AM
Sebastian Ciesielski

Hello My server has crushed, and all i could recover was database dirs/files. Can i somehow recover the database from these? It's...

Piotr 'Zenobius' Baranowski

11-25-2007 08:07 PM
Serge Rielau

Sirs, We are using DB2 UDB 8.2.5 for AIX 5.3. Everytime when we perform a online incremental backup to Tivoli, the system will hang for about...

James Yang

11-25-2007 07:10 PM
James Yang

Does anyone know where I could get my hands on one or more old DB2 certification exams? I'm especially interested in Exams 700 and 701 but would like...

rhino

11-25-2007 12:18 PM
rhino

Hi, What are the possible ways to change the data type of a column from BigInt to Integer? the normal command Alter table <tabname> alter column...

Rahul Babbar

11-24-2007 09:39 AM
Serge Rielau

"The Boss" <usenet (AT) No (DOT) Spam.Please.invalid> wrote THAT is the mistake I made! I didn't see anything about DB2 and I couldn't click on any...

rhino

11-24-2007 03:01 AM
Mark A

ID CODE ------------- 1 XD23414 2 LKJ454678 4 0023821 5 076994 6 AG00086904 7 834292 8 PERTM98 9 M7521315

annecarterfredi@gmail.com

11-23-2007 08:18 PM
DougDB

Hey, all. I have an Oracle background, and am looking to accomplish a certain goal in db2. Version 8.2 on Windows. Basically, I want to initiate a...

BD

11-23-2007 04:40 PM
BD

Can you have muliple DB2 instances that are at different code levels on the same computer? For example, can I have an instance of DB2 V8 and an...

rhino

11-23-2007 04:20 PM
Darin McBride

I have some scripts that drop columns in DB2 9. This leaves the table in a REORG PENDING state: SQL0668N Operation not allowed for reason code "7"...

deangc

11-23-2007 12:09 PM
deangc

Hi, I have installed DB2 9 Express C on Win XP on two systems (By right clicking on setup.exe and running setup as administrator on both...

g.deogirikar@gmail.com

11-21-2007 11:40 PM
g.deogirikar@gmail.com

Hi, I am facing an issue here. I had to drop a number of columns (around 20) from a table, which I tried to do all at the same time using the...

Rahul Babbar

11-21-2007 04:30 PM
Colin Booth

Quick question in the hopes of getting a quick response... : ) When you take a snapshot after activating a monitor switch counters such as rows...

josee_sthilaire@videotron.ca

11-21-2007 11:29 AM
josee_sthilaire@videotron.ca

Is there any way to do the following pattern match in db2? LIKE 'arsn' searches for Carsen, Karsen, Carson, and Karson (Carson). In other words,...

jrhoad@hotmail.com

11-21-2007 08:59 AM
Lennart

Hello, recently we migrated on our zOS-System the DB2 from V7 to V8, after the migration we should be able to use the JDBC type 4 driver but we get...

joerg.sailer@weltbild.com

11-21-2007 02:53 AM
Bernd Hohmann

hello, I'm having a performance issue with a Windows CLI/ODBC application that connects to a DB2 rel 7.1 on a mainframe of a bank. I have to say I'm...

luca.devoti@gmail.com

11-20-2007 08:08 PM
Norm

From the basics of Supply Chain Management planning ,to implementing and controlling the operations of the supply chain as efficiently as possible....

John Stapleton

11-20-2007 05:10 PM
John Stapleton

Hello all, We are seeing strange behaviour for queries on a table we need to convert data from. We try to find out whether table...

frederikengelen@gmail.com

11-20-2007 03:07 PM
Knut Stolze

Has anyone deployed 9.5 in a production environment? If so, how is it going? I am a little leary about jumping on board so soon when this...

jdokos

11-20-2007 02:22 PM
jdokos

Hi, all. I'm trying to identify data type mismatches between child and parent values in my database. The reason for this is that constraints...

BD

11-20-2007 12:14 PM
BD

I'm having a lot of severe errors in my db2diag.log, (DB2 v9.1.0.0). Googling I don't fin any information :( What can I do? I attach the first...

Nokao

11-20-2007 08:35 AM
Nokao

I have installed the Run Time Client Lite on a WIn XP computer for the ODBC driver and it works fine, I get an connection. When I installed the...

pablo007

11-20-2007 07:18 AM
pablo007 via DBMonster.com

I have problem where a ETL team is trying to update a column in a very large table. They are trying to do this in single query. Also each time...

doug.partch@db2helpdesk.com

11-20-2007 06:25 AM
Serge Rielau

I use db2 9 express-c Hi... I'm having that problem... .....every less-than-10-seconds, a entry like that (I displayed that entry with the command...

Nokao

11-20-2007 02:49 AM
Nokao

Hi guys.. apart from the day-to-day monitoring, administring and perf tuning activities, what are all the value added things than can be done by...

kavin

11-19-2007 03:17 PM
Ian

I need some help with a problem I've encountered. I am a zLinux, WAS, and DB2 noob so please bear with me. I am helping to support two WebSphere...

SysProg

11-19-2007 06:37 AM
SysProg via DBMonster.com

After I installed FP3 to an exiting DB2 V9 copy on windows 2003(32- bit), issued db2updv9 to update ER1 database to current version, but got the...

James

11-19-2007 05:36 AM
Knut Stolze

I am using AIX DB2 v8 we have tables so huge...when I do query...like the following: db2 "select * from table fetch the first 10 rows with ur" all...

d.k.chung

11-18-2007 01:50 PM
Colin Booth

Our Mainframe DBA insists that the IDTHTOIN parameter be set to 600 so that all idle threads timeout after 10 minutes. This is causing a particular...

Spencer

11-17-2007 06:03 AM
Spencer

I heard a rumor that compress is only availible in Enterprise Edition in 9.5, can anyone confirm/reject this rumor? /Lennart

Lennart

11-16-2007 04:40 PM
Jean-Marc Blaise

I tired to run the following statement, but it does not work inside a BEGIN ATOMIC. I assume this is a known limitation, but I could not find...

Mark A

11-16-2007 03:46 PM
Mark A

We had a load that failed. Now we have a pending load. When executing load terminate, we receive the following error: db2 load terminate SQL0104N ...

Justin

11-16-2007 02:43 PM
tnj.guy07@gmail.com

Excuted the statement through a SSH connection: db2 import from <filename.ixf> of ixf messages /database/stage/ acct_news_asc.txt insert into...

Justin

11-16-2007 12:31 PM
Justin

It seems that I must pass a "SET ENCRYPTION PASSWORD =" to each stored procedure that puts an encrypted value into a column. Also seems that I don't...

2803stan@gmail.com

11-16-2007 05:40 AM
Serge Rielau

Hi, I want to update dbm cfg parameters DFT_MON_BUFPOOL and DFT_MON_STMT from C program. I am using db2 version 9.1.2 on Linux platform When I...

Lekh Raj

11-16-2007 03:33 AM
Lekh Raj

Hi, I want to update dbm cfg parameters DFT_MON_BUFPOOL and DFT_MON_STMT from C program. I am using db2 version 9.1.2 on Linux platform When I...

Lekh Raj

11-16-2007 03:33 AM
Lekh Raj

Hi all, I wrote a small guide to setting up both the Ruby and Python drivers for DB2 on Linux (32 and 64 bits). The instructions are largely...

Antonio Cangiano

11-15-2007 01:49 PM
Antonio Cangiano

Hi, We were trying to run the following set of commands Alter table----successfull reorg table---successfull Alter table---successfull Reorg...

Rahul Babbar

11-15-2007 10:34 AM
Rahul Babbar

Database level is: DB2 v9.1.300.257 Operating system is windows 2003(32bit) Account er1adm is instance owner, but when issued the following command,...

James

11-15-2007 10:07 AM
Serge Rielau

(AP) Increasingly application developers are required to include flexible and extensible reporting options within their core product sets. This is...

test

11-15-2007 06:16 AM
test

I am using column-level encryption (ENCRYPT_CHAR, DECRYPT_CHAR) to protect selected columns in DB2 LUW v.9.1 and v.9.5 on Linux. The ultimate goal...

olafinsbraaten@hotmail.com

11-15-2007 12:23 AM
olafinsbraaten@hotmail.com

I have a siebel crm application thats cutting and archiving logs every minute. Here is the db cfg Log buffer size (4KB) ...

Roger

11-14-2007 03:13 PM
kschlamb@ca.ibm.com

Running DB2 for Linux 8.2.8 (FP15) on IBM PPC. OS is Red Hat Enterprise Linux 5 for PPC. We have a script that does a SET WRITE SUSPEND just prior...

Mark A

11-14-2007 02:41 PM
kschlamb@ca.ibm.com