Here's wishing you MERRY CHRISTMAS and Festive seasons's greeting!!
Now this has been bugging me for quite a while and I seek your help in
setting my mind to peace.
As part of DB2 Instance creation on Unix, I issue this command (from

(V8.2 LUW)
I'd like a Stored Procedure to self discover the Instance Name in which
it is executing?
any ideas?

I am developing the application (VBA&ODBC, to be exact) which
periodically calls the stored procedures in the IBM DB2.  A few of the
procedures require executing with isolation level RR ( ANSI
"SERIALIZABLE" ), not the default; default is CS (ANSI "Read

We are downgrading from DB2 8.2 ESE on Linux to WSE. Is there a simple way
to perform this or how should it be done?
Thanks

On Window 2000 Professional Server
DB2 UDB
Level:
DB2 code release "SQL07029" with level identifie

Can someone please tell me if Fixpack 11 for DB2 V8.1 will be released:
   a) somewhat soon
   b) soon
   c) very soon

Wenn mein User (BS und Datenbankanmeldung) nicht in der Gruppe
Administratoren ist, schmiert mir die Steuerzentrale und auch der
Jave-Editor ab. Der User ist in nder Gruppe DBAMINS. Was muss ich
umstellen, damit dieser User mit dem Java/Programm arbeiten kann?

There is a date field in JSP form where user will enter date in
dd-mm-yyyy format. Now before saving into DB2, I want to validate the
date format against dd-mm-yyyy format and then save into DB2.
I've tried reading SimpeDateFormat and other date format classes, but

I'm going to setup a testing environment with FP4 U488486 but the FP4
U488486 is withdrawn from the support page. Do anyone still have V8 FixPak 4
(U488486, not 4a) for AIX5 to share? Thanks!
Ben

How can validation testing on DBMSs such as DB2 and Oracle be performed?
Is there a quick commonly used publicly available DBMS test that can be
used?
Could TPC-C be used?  If so, where can TPC-C be obtained?  (Is is publicly

Could I get some information , on how to handle flat files throught DB2
Stored Procedures.
Functionalities such as ( Reading / Writing to a file ). Basically I
want to achieve a Logging Mechanism which would enable me to write a

I have a developer working with me.  He is new to db2 8.2.
I remember that when I applied fixpak10 I had to bind something to
something, but I can't find what.  Win 32; WSE.  It involved a bind
file in \Windows\system32\drivers\etc.  But I can't remember exactly

Hi folks. I need unique sequence object generated for each row returned
form select statement. Here is my ADDID() UDF:
CREATE FUNCTION DB2ADMIN.ADDID()
 RETURNS CHAR(6)

to help to Replace the stupid Coding like
SUBSTR('0000',LENGTH('22'),4-LENGTH('22'))||'22'
changing string '22' to '0022' ???

I am querying a DB2 database via Sequelink and I want to manually add a
row to my recordset.  In SQL Server, I would use a UNION clause like
this:
SELECT