Friends:
Consider the plan fragment below:
                                           NLJOIN
                                           (  17)

Witam
Mam zero doswiadczenia w bazach db2 (instalacja pod Windows 2003 serwer).
Prosze o pomoc. Jak usunac zawartosc logów w bazie za pomoca okna komend (bo
tylko to mam udostepnione).

Gday
I want to change to use Windows AD-integrated Kerberos authentication,
and have changed a server to KRB_SERVER_ENCRYPT for trial.  Recataloged
the database at a client machine.

I wanted to post this for anyone else who has been in -30081 hell like
me.  Our web servers run on the Windows platform and use DB2 Connect to
query our DB2 for z/OS systems.  For the last 4 years I have been
getting between 20 and 100 SQL30081N errors a day from our web servers.

I have a backup image with name
DADOSADV.0.DB2.NODE0000.CATN0000.20060812230006.001 and I want to
restore it on Windows (in another server).
In Windows Server I created this folder structure:

I've got a Java stored procedure that I use to "register" systems on
our network. In the middle of it is a function that returns the 1st
free ip address in a class C network  which is used in the registration
process.

I have date stored in table as following example:
115514 Equates to March 14, 1996
it is stored from the date of 1900-01-01 to 1996-03-14
Month/Year = 1155 and day = 14

A crazy thought just popped up into my head.
Supposing your site didnt have SPUFI / QMF / Candle / Platinum or any
tool that would let u create and run your SQLs, which would be the best
way to get your data?

I can turn off autocommit within the command window but I cannot figure
out how to turn it off when you are in the IBM DB2 Command Line
Processor.  Does anybody knows how?  By the way I mean when you are
logged on and the prompt is: db2 =>

Does anyone know what this error message means?
S1000-3216048579 [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2
for Windows, UNIX, and Linux]Unknown error: SQLCODE -1078918717
Appreciate your help in advance.

I am using DB2 v 8.2 Enterprise Server Edition. We can replicate only a
single table at once. Now, how to replicate multiple tables in a single
shot.
Any suggestions would be highly appreciated.

What is a good tool to administer a couple of hundred DB2 databases,
each running on its own Linux server, over a WAN? Ideally the tool
would run on Windows.
In SQL Server, Enterprise Manager is able to do it. I was wondering if

How can I test my full image backup??
Thanks
Abel

(DB2 LUW 8.2)
Is the DB2 optimiser able to use check constraints ?
e.g
table1

Hai everyone...
Can anyone tell me how do i find the size of the database...
call get_dbsize_info(?,?,?,0) is giving an error
" Call command failed"