| Thread | Last Post | Replies |
|
| Advantages of "MERGE INTO" | 11 Aug 2005 20:10 GMT | 1 |
Is there any advantage of using "MERGE INTO" SQL instead of using
"EXISTS" AND "NOT EXISTS" in DB2?.
Thanks,
--Chandra
|
| passing parms to query in DB2 Unload | 11 Aug 2005 17:50 GMT | 2 |
Does anyone know if you can pass parms to the sysin when using
DB2UNLOAD?
|
| No future for DB2 | 11 Aug 2005 16:43 GMT | 371 |
This article is very bleak about future of DB2. How credible is the
author. http://www.eweek.com/article2/0,1895,1839681,00.asp
|
| one performance question... | 11 Aug 2005 14:31 GMT | 3 |
I have an performance questions...
is # of tables in one tablespaces matter for performance point of view?
why?
if yes, how many tables in one tablespace is good ?
|
| Help with "SQL30081N A communication error has been detected" | 11 Aug 2005 13:28 GMT | 3 |
I've just installed the DB2 Run-time client in a Solaris machine. Then
I finnish the installation configuring the connection:
1. machine catalog was OK:
==========================
|
| How switch db into read-only mode? | 11 Aug 2005 12:13 GMT | 5 |
without filling all disks :-)
Andy
|
| Making stored procedures resident in memory | 11 Aug 2005 04:06 GMT | 5 |
I am trying to determine the behaviour of stored procedures in DB2 V8.2.x in
Windows/Unix/Linux and how I can control that behaviour. Some documentation
in the manuals is confusing the issue somewhat.
First, am I right in understanding that the normal behaviour of a stored
|
| db2 8.2 fixpaks | 10 Aug 2005 23:55 GMT | 3 |
I downloaded FP9a_MI00117.tar as the 8.2 fixpak for 32 bit linux
but it got a tar error:
OD_14086/db2/linux26/IBM_db2dees81-8.1.2-89.i386.rpm
tar: Read 2536 bytes from /usr1/lcldsk/ibmdb2/FP9a_MI00117.tar
|
| access pseries DB2 from iseries using COBOL and RPG | 10 Aug 2005 21:55 GMT | 1 |
Please point me in the right direction for being able to do this.
Thanks
|
| migration toolkit (from oracle 9.x to udb 8.2.2) | 10 Aug 2005 19:08 GMT | 2 |
Does IBM publish a complete list of features
(of Oracle) which the IBM migration toolkit
does *not* convert? The docs seem rather vague.
For example:
|
| reading DB2 with isolation CS - why is the lock blocking? | 10 Aug 2005 11:54 GMT | 4 |
Dealing with the Oracle / DB2 XA (2-phase commit) drivers, I found a
locking situation in DB2 I do not understand. It is actually a pretty
simple scenario to which I can drill it down.
Let say I have a table with one column. This table contains 2 rows:
|
| Long Varchar - when will it no longer be supported? | 10 Aug 2005 10:06 GMT | 1 |
Helpful folks,
I recently applied fixpacks to our test server to bring it from V8.1.3
up to V8.2.2. Everything seemed to work fine except a DCOM component
that deals with Long Varchar column on one of our tables. I was
|
| V8 FP 8 : Restore error messages. | 10 Aug 2005 03:49 GMT | 6 |
I am trying to restore my database in V8 FP8. The first restore attempt
failed(because of an incorrect parameter I defined), so I issued the
command again(after correction!!). In version 7 this used to work fine,
but in version 8 it has showed me this error message in the
|
| one performance question... | 09 Aug 2005 22:55 GMT | 1 |
I have one performance questions...
is # of tables in one tablespaces matter for performance point of view?
why?
if yes, how many tables in one tablespace is good ?
|
| equivalent of oracle's dbms_output.put_line in db2 | 09 Aug 2005 17:20 GMT | 5 |
Is there any equivalent of oracle's dbms_output.put_line in db2?
Pl. let me know if any..
regards,
nsd
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread