Running 8.2.8 on aix.
Any reason why the dynamic cache snapshot function would return no
records?
db2 "SELECT * FROM TABLE (SQLCACHE_SNAPSHOT()) as SQLCACHE_SNAPSHOT"

Is there a difference between:
SELECT * FROM mytable WHERE somecolumn='Y' FOR UPDATE WITH RS
and
SELECT * FROM mytable WHERE somecolumn='Y'  FOR UPDATE WITH RS USE AND

I wrore a query for based on OLAP it is working perfect fproducing follwing
report:
crime events                        REPORTED                    REPORTED
SERVICE_SUB_MODE      DATE_TIME_START          DATE_TIME_END

I'm looking for a DB2 runtime client for gentoo linux without X, that
is, command line only. All I want to do is regularly run a few simple
queries against DB2 on another server.
I see RTCL downloads for v8 but they all require a base install of DB2

We have a small problem in one of our database hosts in which the
db2ckpwd daemon process runs under the instance owner id instead of
"root".
Due to this, no other id except the instance owner is able to start

On Vista 64-bit, I am in the administrators'group + DB2ADMNS.
FP2 was applied on FP1 and went fine, except that I got a message that
DB2COPY1 cannot be updated (right access denied ???).  I don't get it. After
that, I cancelled, and setup was successful.

I found this example in MYSQL:
create table events
( id  integer  not null primary key
, datetime_start  datetime not null

At first glance it seems like a good idea to use the new RESTRICTIVE option
when creating a database to remove public access otherwise granted by
default. Then one could grant the required access to specific users.
But what about things like these which are normally granted by ...

I have installed DB2 9.5 directly from FP1 on Windows in custom mode with
COMP=CONNECT_SUPPORT. I then added my DB2 Server license.
I am surprise that db2licm refers to a DB2 Connect Server. Is there a way to
remove the product I have never installed ?

Is there any way to generate the ddl for recreating a database (with
codeset, automatic storage clause...).
I've ran db2look but can only get the ddl fort the tables, proc ...
thx

I generated a table with an identity field like this:
ID INTEGER GENERATED ALWAYS AS IDENTITY (
START WITH 1 INCREMENT BY 1
NO MINVALUE NO MAXVALUE

Are there any procedure or commands
moving one table into new tablespace from old tablespace , where it
has multiple tables in one tablespace ?
Here's my scenario for moving sample_table into tablespace_new

CREATE FUNCTION dates(start DATE, end DATE)
RETURNS TABLE(dt DATE)
RETURN
WITH REC (DT)