I'm experiencing some puzzling behaviour with some of my UDFs when
declaring them as ATOMIC..  Basically I'm invoking another UDF (which
uses some Java code) in one branch of a CASE statment, and if that UDF
is declared as ATOMIC then both branches get executed!

I have seen no activity since 2005-08-26-19:52. Is there some problem or
is everyone having a nice quiet weekend?

[DB2 8.2.1 Workgroup on Suse 8.1 on a dual Xeon with 2.5Gb of ram, 6
discs at RAID5]
One of the larger tables in our database is now 6.8 million rows (1 per
financial transaction since 2000).

I nees create a procedure that return a cursor for Crystal report. I
need use dynamic SQL.
what's wrong with the following procedure ? (that only part of the
sample)

This afternoon I installed Db2 FP10 on my Windows 2000 laptop.
Install ran without a problem and at 15.00 the install finished and
reported that DB2 was ready for use.
I started to run db2updv8 and bind the utilities against the

All,
We have listed out the INBUILT Function differences between Sybase and
DB2.
Kindly provide your feedback or corrections and for CHANGES - DO WE

I am trying to determine whether LOB's are replciated using HADR. The
following documentation from the on-line manuals
http://publib.boulder.ibm.com/infocenter/db2help/index.jsp suggest that
LOB's are not replicated on HADR:

I have this test version of DB2 Universal Database (DB2 UDB) Enterprise
server Edition Version 8.2 on Windows Server 2003 installed, the Sample-DB
created and i can access it via ODBC.
I would like to insert existing databasefiles now, whose version I don't

People, I have the following table [5m records] and I need to add a
column that uses a the listed UDF to count the number of days within
specific quarters by year.
CREATE TABLE HISTORY_MB (

I just stumbled on something odd but I'm not sure if it's a bug in DB2 or
something that is "working as designed."
I have a simple SQL PL stored procedure which is doing an "INSERT SELECT..."
(as opposed to an "INSERT... VALUES ...") and I'm doing a GET DIAGNOSTICS

In linux, I cannot connect using the db2cc.  It is an SAP demo
application running on db2/Linux.  How can I find out which users have
this authority, given that I have what appears to be a general UNIX
account?

New installation of DB2 ESE 8.1 and Fixpak 9a on
Solaris 8.2, on FUJITSU 450 server(sparc), 64 bit mode, and 64-bit
instance.
db2start fails (after approx 60 seconds) with SQL1042C (unexpected

Apparently the order for mixed case is a, A, b, B ... which is somewhat
more than a little surprising. How do I make it the ASCII sort order (A,
B, ... Z, a, b, ... Z)? Where is the sort order defined in the (huge)
manual set?

CALL SYSIBM.SQLTABLES('A','B','C','D','E');
SQL0443N  Routine "SYSIBM.SQLTABLES" (specific name "TABLES") has
returned an
error SQLSTATE with diagnostic text "SYSIBM:CLI:-805".  SQLSTATE=38553

On a AIX 5.2, DB2 UDB V8.2, the dbm snapshot is as below.
There are around 50 applications at any point of time, intra-parallel
turned on, oltp and reporting queries are run on the server. 8 Gigs of
RAM, what parameters are recommended for