hello, i am just getting started as a dba. ny current task is to set up notification for health alerts. so, we have the health monitor running, and...

nycjay@yahoo.com

10-24-2005 01:46 PM
nycjay@yahoo.com

We have several identically defined databases that support a common set of programs. Any program can run against any database. Is there a function...

WalterR

10-24-2005 10:23 AM
juliane26

Hi We're using an iSeries running v5r3. I am trying to add a generated column to a table, using the statement below. The card_status column is a...

Ben.Combrink@gmail.com

10-24-2005 06:10 AM
Gert van der Kooij

Hello all I have quite well working network connection. It's about 4 Mbit/s. When I do transfer files I have the transfer like 400Kb/s. The problem...

pawel

10-24-2005 12:59 AM
Marc Schoechlin

Hi, Can anyone tell me how to calculate the ctual disk space needed for a table? The record length and number of records are known. A rough estimate...

sandip

10-24-2005 12:37 AM
Bohne

We have several identically defined databases that support a common set of programs. Any program can run against any database. Is there a function...

WalterR

10-23-2005 10:31 PM
WalterR

In my application,I use SQLBindCol to retrive the information, however I found that in one table there is a varchar(10) column, if the buffer size...

jackyshi3333@yahoo.com.cn

10-23-2005 10:01 PM
Jan M. Nelken

One of my customers have a sql statement totaled more than 400 lines, about 40KB. when excuted, error arrised saying "SQL0101N The statement is too...

Hardy

10-23-2005 09:07 PM
Hardy

<usenet (AT) kikobu (DOT) com> wrote Not necessarily. It depends on how may rows will be returned. If the number of rows returned is relatively...

Bernd Hohmann

10-23-2005 02:37 PM
Mark A

We are having some problems administering HADR on a new installation. Specifically, we are seeing that the connection status of the pair...

Brian

10-23-2005 01:40 PM
Steve Pearson (news only)

I could swear we just lately had a discussion on this but I can't find it. I have a (simplified) table: subj_id, date_checked, status and I want...

Bob Stearns

10-22-2005 08:00 PM
Tonkuma

I set up a few statement event monitors from CLP. How can I list all the statement event monitors and remove them. They do not show up in...

mumtaz

10-22-2005 01:30 PM
mumtaz

We are doing data-migration from Oracle To DB2. Can anyone tell me the best way to work with lob data? Any help will be greatly appreciated. TIA

pankaj_wolfhunter@yahoo.co.in

10-22-2005 05:32 AM
pankaj_wolfhunter@yahoo.co.in

Hi - I would be grateful for any advice on the following. Within DB2 for OS/390, the STRIP Scaler Function is available. Its function is, for...

alex.mcshane@btinternet.com

10-22-2005 12:27 AM
Tonkuma

We have a DataMart (Approx 10GB) that is updated in batch at night. Is there a way that the database can be configured to be in a "Read Only" mode...

Rob K.

10-21-2005 06:51 PM
Artur

Can someone set me straight I know indexing is a "try & see" art. However I am at a loss if it's better to use the INCLUDE switch on a unique index...

Kent.Brooke@gmail.com

10-21-2005 06:44 PM
Pierre Saint-Jacques

I have DB2 backed up to TSM from the production system. How can I use db2adutl to view the backup info from other server instead of production.

shenanwei@gmail.com

10-21-2005 01:40 PM
Philip Nelson

When a backup is taken from server a and then redirected restore is done on server b, the tables and data is fine however db2advis says "explain &...

Kent.Brooke@gmail.com

10-21-2005 11:02 AM
Keith

hi when trying to connect to a db2 personal edition running on windows2000 from linux i get the following erromsg. schnick@devschello:~/sqllib/cfg>...

bernhard schelling

10-21-2005 09:01 AM
bernhard schelling

Hello, I'm looking for a way to make some of my insert templates more readable by placing comments in between the values. I cannot seem to find a...

73blazer

10-21-2005 04:27 AM
Serge Rielau

The following situation turns into an error: SP1 { Savepoint Create record in table 1 Call SP2 { Create sub-records in table 2 referring to table...

Twan Kennis

10-21-2005 03:52 AM
Twan Kennis

Hi, can someone please help me out with the following problem: I run a simple Korn shell script: ---- db2 connect to $EZERSQLDB user $FCWDBUSER...

proba

10-20-2005 10:17 PM
Mark A

I'm unloading a Table that has two columns that allow nulls. One column is null, the other is not. I have the following questions on the output...

TomD

10-20-2005 10:11 PM
Mark A

Hello, we are monitoring our db2 databases with the the Tivoli software (ITM4DB2). The last 2 days we often received the event that the DMS space is...

matthias.lau@bkm.de

10-20-2005 09:07 PM
Pierre Saint-Jacques

Visit the IDUG Europe Conference Blog for Daily Updates and Conference Information IDUG 2005 - Europe Blog New for this year's conference, IDUG...

Marcel - IDUG Europe 2005

10-20-2005 10:02 AM
Marcel - IDUG Europe 2005

Hi all!! Do you can help me Why this command do not accept I have create the database OK but, when i hability for db2image, sho show this message

robertoqueiroz

10-20-2005 09:33 AM
robertoqueiroz

Hi all!!! Do you can help me? Why this command do not accept? I have create the database OK but, when i hability for db2image, show show this...

robertoqueiroz

10-20-2005 09:33 AM
robertoqueiroz

Being new on z/OS for some time I do have some problems with Explain. I tried the Visual Explain for z/OS, but since we use Version 7 database I...

juliane26

10-20-2005 05:54 AM
juliane26

Hi, Which approach is better for performance : DB2 Call Level Interface (DB2 CLI) or using ADO. I will be developing my application in C++. Also do...

Tejas

10-20-2005 03:38 AM
Tejas

Hi.. I have working on Windows XP Operating System.Installed J2sdk 1.4.07 and installed IBM DB2 UDB version 8.1 Then i got the following...

Sanju

10-20-2005 03:09 AM
Adrian

When the "new" data IS NOT NULL or whenever the row is stored? In particular is the first clause needed in: ALTER TABLE IS3.FLUSHES ADD CONSTRAINT...

Bob Stearns

10-19-2005 11:56 AM
Knut Stolze

DB2ers, I am a newbie to DB2 world. I just built a test DB2 server and installed the "SAMPLE" database. It turns out the database was created under...

Pradeep

10-19-2005 11:35 AM
Knut Stolze

row_count - is it total inserted,updated or deleted by merge statement? Any way get different counts? Andy

bughunter@ru

10-19-2005 10:52 AM
Serge Rielau

I have 2 insert statements within a procedure which are as follows: INSERT INTO temp table (column1, col2 ) SELECT 'abc, 'b' FROM tab1 AS...

chettiar

10-19-2005 10:38 AM
Serge Rielau

DB2ers, In my setup, DB2 server is installed on a Windows box "test16" and "SAMPLE" database has been loaded. Now, on a clean Windows machine...

Pradeep

10-19-2005 09:13 AM
Pradeep

DB2ers, I am a newbie to DB2 but have enough experience with other database servers. Many database servers such as SQLServer offer a...

Pradeep

10-19-2005 09:11 AM
Pradeep

Did you check the explanation of the error message? Reason code "5" is caused by insufficient memory or an unresolved reference. Check the FP10...

Phil Sherman

10-19-2005 08:20 AM
Phil Sherman

All. We have a Client/Server environment on with PB/Sybase and we are looking at moving to PB/DB2. What are the things we need to consider for 1....

db2sysc@yahoo.com

10-19-2005 07:58 AM
aj

Hi All: I am attemting to write some Visual Basic Scripts that will call a DB2 stored procedure and get the return value. The test scripts are...

ronloxton@rogers.com

10-19-2005 07:29 AM
ronloxton@rogers.com

Hi, I am creating a temp table within a procedure and inserting some records based on some conditions. Is there a way I can query the temp table to...

chettiar

10-19-2005 06:20 AM
Serge Rielau

Hello group, I have to care about a large replication setup (64 server, 150 laptops). On one of my servers I have a honest problem: Capture in WARMNS...

wolfram.wagner@web.de

10-19-2005 02:12 AM
wolfram.wagner@web.de

I have a laptop with windows xp 1 gig ram 2.0 pentium M. When I run the db2 personal edition version 8.2 the install gets to the first screen and...

brent

10-18-2005 09:55 PM
brent

DB2 WSE LUW 8.1 FP5 Red Hat AS 2.1 I would like to grant a new database user the same privileges (across many tables and views) that a current user...

aj

10-18-2005 02:23 PM
Ian

Hi, I have a Table which contains 1 million rows. I want to do an unload of the table and do some massaging (tranforming) of data and do a load to a...

razheev

10-18-2005 02:01 PM
razheev

I've got a set of redundant marts that I'm trying to catalog on the client side to allow us to do two things: 1. manually recatalog to point at...

kenfar

10-18-2005 01:26 PM
kenfar

Running DB2 8.2 on AIX 5.2. If you have more than one instance on a box is there a way that can be used to determine which is the name for the...

datapro01@yahoo.com

10-18-2005 01:07 PM
datapro01@yahoo.com

Hi, I try to run the WMI samples supplied with DB2 8.2 PE FP10 but according to the manual I need to register the DB2 WMI provider. The command...

Gert van der Kooij

10-18-2005 12:53 PM
Gert van der Kooij

Hi, I'm pretty sure the tasks that are in the task center are in a table somewhere, but I'm not finding them. Any ideas?

jcolino@yahoo.com

10-18-2005 12:35 PM
jcolino@yahoo.com

Hi all, I am facing a problem while migrating a Sybase SQL query to DB2 UDB. The query involves left outer joins. The Sybase query syntax is as...

sandip

10-18-2005 05:54 AM
Serge Rielau

After updating to FP10, everytime i want to execute a stored procedure it gives me an error "Java or .NET interpreter startup or...

Janick Bernet

10-18-2005 04:37 AM
Janick Bernet