Feel free to contact me directly with any follow up. I've used WC 8.1 extensively in converting from SQLServer to UDB and struggled through most of...

Pete H

08-19-2003 09:00 PM
Dave

Greetings. I am trying to restore a copy of our production database onto a development server. I have been backing up my database using the...

Benjamin Stewart

08-19-2003 08:57 PM
Fan Ruo Xin

In DB2 on OS/390, before dropping a database using 'DROP DATABASE' statement, do we need to stop the database using DB2 command '-STOP DATABASE'?

R T

08-19-2003 01:30 PM
R T

You have pulled out a large gun and shot yourself. ;) Your connection was killed by the "force applications all". Regards, V-

Uma

08-19-2003 01:13 PM
vespy

ak_tiredofspam (AT) yahoo (DOT) com (AK) wrote in message news:<46e627da.0308150613.707d2318 (AT) posting (DOT) google.com>... What's the capacity...

Ollie

08-19-2003 12:20 PM
Bill Littman

Is it possible this installation? Thanks for all

Emanuele

08-19-2003 11:05 AM
Darin McBride

I downloaded DB2 personal developer's edition for Win32 platform. How do I install the software on Windows XP? When I run the downloaded EXE, it...

Arun Marathe [MSFT]

08-19-2003 09:46 AM
spufidoo

Hi all, As part of setting up a database we have, I am writing some scripts to load core data. Because I need to generate values throughout these...

Derek Clarkson

08-19-2003 09:42 AM
Serge Rielau

Hello, We are having problems trying to drop a SP. When I try to drop it via the java based CC, it all looks OK, but a refresh still shows it...

DT

08-19-2003 08:59 AM
Sean McKeough

Hello, We are trying to use MDC tables in our DataWareHouse, but the tests shows that MDC use a lot of space in a relation 1/10 or 1/100. (1 byte of...

Carlos

08-18-2003 11:45 PM
Carlos

Use the -td§ option . Details are in the section titled Command Line Processor Options in the Command Reference. "Derek Clarkson" <dclarkson (AT)...

Mark Yudkin

08-18-2003 10:26 PM
Derek Clarkson

Not a good idea to hide the real predicates to us. It's just like going to the garage and giving car-a for repair when it's actually car-b that's...

Mike L. Bell

08-18-2003 09:00 PM
PM \(pm3iinc-nospam\)

I've seen a number of postings on this issue but no resolution that worked for me. No amount of playing around with with the Tomcat classpath or...

Bob Bishop

08-18-2003 08:47 PM
Fan Ruo Xin

I am looking at a V7.2 FP10 sqllib (for Windows) and it definitely does have a "sqllib\java12" directory. I don't know why you don't have...

Chris Graham [WarpSpeed]

08-18-2003 04:50 PM
Larry Menard

I'm accessing a db2/400 system via Perl DBI and the DBD::DB2 module, but when I go to pull data out of any table that's not codepage 37 I get...

Dana Cordes

08-18-2003 01:39 PM
Sherman Lau

I think it's more dependent on the ODBC driver than the database.

Caroline Miller

08-18-2003 01:26 PM
programmer

Hello, I know from the documentation that at least part of the new DAS scheduler is written in Java, and I'm worried that the Java classes it uses...

Fred

08-18-2003 12:56 PM
Fred

The GRAPHIC datatypes may be new in the non-Asia Pacific market. Indeed, we support Unicode GRAPHIC column in EUC database in DB2 v2, 8 years ago. ...

Hemant Shah

08-18-2003 12:42 PM
Sherman Lau

Hello everybody I used SQLConnect() in my linux cli application to connect to a datasource. But I get this Error SQL1031N The database directory...

Almund Sebi

08-18-2003 06:20 AM
Almund Sebi

We have to maintain the same collating sequence between an oracle database on NT and a db2 on z/OS. FOr this, we are planning to use an ascii...

Tilmann

08-18-2003 03:48 AM
Tilmann

But surely you don't change every single byte in each fixpak? Also, aren't you still bundling all of the languages into a single fixpak? Can't you...

Darin McBride

08-18-2003 03:07 AM
Mark Yudkin

We have created the INSIGHT tables to dump the SMF data into them. The # of rows per day for some of the tables is as much as 8 million. Has anyone...

Carol

08-18-2003 01:22 AM
Carol

DB2 stored procedure compile error DB2 Version 7.2 + FixPak 6, Solaris 8 + Workshop CC compiler When I compile a simplest store procedure ( in...

Guyang

08-17-2003 10:34 PM
Guyang

Hi there folks. I've been given the task of looking at the disk format (on Windows) for DB2 backups. We need this format to write a porting tool...

Peter Nunn

08-17-2003 10:11 PM
Matthew Emmerton

Thanks, it seems we are only at fix pack 1 here (linux). ;-) cio Derek. PM (pm3iinc-nospam) wrote:

Derek Clarkson

08-17-2003 09:40 PM
Derek Clarkson

Larry <lsedels (AT) us (DOT) ibm.com> wrote Have you look into the DTS tool that comes with SQLServer?

Jep

08-16-2003 09:34 PM
Blair Adamache

Check Appendix A (Incompatibilities) of the Admin Guide: Planning (ftp://ftp.software.ibm.com/ps/products/db2/info/vr8/pdf/letter/db2d1e80.pdf). I...

Blair Adamache

08-16-2003 09:33 PM
Blair Adamache

On 14 Aug 2003 21:05:15 -0700, chrisg (AT) warpspeed (DOT) com.au (Chris Graham ) wrote: .... from FixPack 3 - as I remember. /Jep

Jep

08-16-2003 09:28 PM
Blair Adamache

Question about documentation to DB2 UDB 8.1 FixPack for the DB2 UDB server 8.1 and FixPack for documentation for 8.1 quit in a parallel way (that...

Tolik Gusin

08-16-2003 08:59 PM
Blair Adamache

Does DB2/2 (ie for OS/2) V7.1/7.2 have/support JDBC 2.0? V6.1 and V7 support JDBC V1. But does V7.x support JDBC V2.0? If not why not? Does the...

Chris Graham [WarpSpeed]

08-16-2003 03:06 PM
Larry Menard

Hi, I can't manage to install DB2 v7 on SLES 8 (Suse Linux Enterprise Server v8). Creating an instance always aborts with the same...

ChrisA

08-16-2003 11:31 AM
nntp

hi, i keep getting this error when i have only one application connect to the remote server (it is db2 udb v8.1 on windows 2003). After i increase...

xixi

08-15-2003 05:42 PM
xixi

Hi Group, Does anyone know how to connect a Windows 95 client to an IBM DB2 UDB Express 8.1 running on top of Linux. I need to connect an MS...

john doe

08-15-2003 01:49 PM
Alexandre H. Guerra

Specific...

PM \(pm3iinc-nospam\)

08-15-2003 11:52 AM
PM \(pm3iinc-nospam\)

We got a database that didn't react for minutes. How can I find out what it is waiting for. Connection monitor shows several Connections in...

Klemens

08-15-2003 10:08 AM
Klemens

Hello, I've deleted some data i need urgently : - ( The only thing i've got is a full backup of my harddisc. So, what i have is the node directory...

news_account

08-15-2003 07:55 AM
zeb

Hi, Could you please post your hardware & software configuration? For example, 32/64 bits OS or 32/64 bits DB2 are in use. How do you resubmit the...

Steven

08-15-2003 07:14 AM
Frédéric KAP¨P

Toralf Kirsten wrote: The not logged behaviour needs to be activated per transaction. Issue ALTER TABLE ... ACTIVATE NOT LOGGED INITIALLY, then...

miro flasza

08-15-2003 03:58 AM
Toralf Kirsten

Does anyone know whether a user who does not have administrative privileges on a Windows 2000 computer can successfully manage and administer a DB2...

sea

08-15-2003 02:28 AM
Mark Yudkin

Hi all, I'm trying to work out how I am going to develope some procs and functions within DB2. Usually what I do when playing with code and testing...

Derek Clarkson

08-15-2003 02:16 AM
Derek Clarkson

Hello, Matt, I load about 120,000,000 records into the table. My DDL is like the following: CREATE TABLE xxx.xxx ( ... t_date ...

Fan Ruo Xin

08-14-2003 08:31 PM
Fan Ruo Xin

Which operating system and which release of DB2? Jen Kelly wrote:

Blair Adamache

08-14-2003 02:07 PM
Dmitri Liakh

I am running DB2 version 7.2, when I execute ASNCMD dbname STOP. 8 out of ten times Capture will bring itself down. I need this to work 100% of the...

Paolo

08-14-2003 01:08 PM
Paolo

We were about to place an order for Workgroup Server Edition, when Express arrived. So far, I have not been able to find out a side-by-side features...

N. Shamsundar

08-14-2003 12:28 PM
Blair Adamache

Hi all We plan to write large application (sales, purchase, accounting) in C/C++. It will work with DB2 and other databases (MS SQL and Oracle)....

Tomasz

08-14-2003 12:27 PM
Wolfgang Riedel

hallo! i have the following questing: is it possible to reference the trigger transition tables (OLD_TABLE, NEW_TABLE) inside a procedure which is...

alederer

08-14-2003 11:30 AM
Serge Rielau

Hi, I'm dealing with migrating Oracle PL/SQL procedures to DB2 UDB 8.1. Oracle uses %TYPE attribute to dynamically get column type. Is there a db2...

Vladimir Cholak

08-14-2003 11:18 AM
Serge Rielau

I'd be interested in the current status / release date estimates for the GA version of DB2 for Linux on the AMD64 (Opteron). I have a client who is...

Philip Nelson

08-14-2003 10:56 AM
Blair Adamache

create database in UTF-8 and set codepage 1208 in client enviroment db2set db2codepage=1208 Andy

andreyp#Antispam@mapsitnA#e-vision-group.com

08-14-2003 02:43 AM
andreyp#Antispam@mapsitnA#e-vision-group.com

Can anybody tell me how to improve the performance of this query? SELECT NID, LEVEL, VALUE FROM DATA WHERE DID=2 AND STATUS=0 The value of STATUS...

Erwin

08-13-2003 11:07 PM
Erwin