Hi,
Anyone know if/where I could download II 8.2 for evaluation?
Specifically, we need to evaluate NSE and relational Wrappers on DB2 v8.2
Also, if anybody has installed this on DB2 8.2 I'd be interested to know

Summary:
----------
Updates against UNION ALL view does't do branch elimination, but
rather reads all the branches (partitions).

Hey all,
does anyone know if it is in any way harmful to use a lot of sequences in
a database? Does it have any disadvantages? I already noticed that
sequences are hard to use with export/import. But are there any other

         I am a bit confused about what I'm seeing on my systems.  I am
trying to develop a script that will determine what percentage of the
total log space is being used.  If it is too high (80%) the on-call DBA
will be paged.  First some system information:

We ran into some very strange deadlocks this AM, and I was hoping to
get some insight.  We were running a REORGCHK on a database, and
started getting deadlocks.  What is curious is that according to the
deadlock event monitor, the deadlock was between the REORGCHK process

  I am wondering if there is a way to
create a UDF with exception handler.
I've been trying to find an example in the
doc and online without any lucks. What

I upgraded to stinger and got stung. Not all my code compiles. Most of
the problems are stinger seems to be more stringent on casting
varchars to vargraphics. This I am working out, however, one procedure
fails to compile and gives the following message.

My new client is running DB2 6.1 on IBM mainframe (z/OS).
They are running DB2 Connect ver. 7.2 to connect to database. (If you
cannot already tell, I'm new to DB2.) I'm not sure what DB2 Connect
does for them, as I have not yet interviewed mainframe development

Does DB2 support inline views, or subqueries in the FROM clause? If so
what is the syntax?

I am trying to run the ddl statements to create a stored procedure on a db2
server machine (W2K, DB2 Universal Database, version 7, 5648-B91 through
5648-B99, 5648-C34). The stored procedure was written and debugged on db2
udb version 8.1 on my laptop.

I have a tablespace striped across three drives, call them 1,2,3, just to
be clever.  :)   I allocated a lot more space (DMS) than I should have,
since I didn't know a way to estimate the space required (long story, but
the original space was in one huge tablespace for all tables ...

Has the promise of stored procedures written in VB6 been fulfilled in 8.2?
If there special syntax, and where do I find it, and where are samples?
Would it be as efficient as, say, SQL?

My understanding is that GRAPHIC and VARGRAPHIC data types can store
text encoded in UCS-2 in a Unicode database (ie when it is created so
that CHAR is encoded in UTF-8).
What is the encoding of GRAPHIC in a non Unicode database ? I have not

I'd like to copy structure only from first table to second?
What can I do?
Paul

We have a setup with a v7 client accessing a v8 UDB server running on
AIX. When I call SQLCancel from a second thread on a long running query,
SQLCancel itself simply waits for statement completion too. That was not
the idea, no? Does anyone know how to fix this? Or is it not ...