is it possible to have certain user create all table and objects in
specific tablespace?
i mean , when they create table without specifying any tablespace,
their tables should go into say ABC tablespace instead USERSPACE1.

it is a common question,not for db2,thank u very much

Hi All;
On a DB2 v9.1 (DPF) - RH Linux server, we have a local userid EXECMSTR
that has dbadm privileges and executes all batch processing to load
and maintain a large data warehouse application. The database server

I have an easy question. I have a table with names, for example
name
--------
José

Can somebody tell me what is the procedure for converting
nonpartitioned table to a partitioned one?
Thanks,
Gile!!!

Is DB2 Personal Edition still a free download from somewhere on the IBM
website? If yes, can you remind me where to find it? For several versions,
it was a free download with no time limit on the licence; if that's still
available, I'd like to direct a few people there so that ...

Environment: DB2 Personal Editon V8 on Windows XP
I was doing some experiments with authorities and discovered some unexpected
behaviour. I had not yet touched the SYSADM_GROUP, SYSCTRL_GROUP, or
SYSMAINT_GROUP settings on a new instance, i.e. all three were blank when I

Db2 Linux LUW FP 15.
Consider table A (ID varchar, EXECUTION_DATE date).
a) I want to first retrieve all IDs that have not executed during the
last 90 days:

I need to drop a tablespace, I am unable to drop because it says the
containers it uses is inaccessible, because a process deleted the
container. the tablespace went into pending state. I just want to drop
the table in it and the tablespace. i dont need that. but i need the

When could be the possible reasons that could make a database
inconsistent?
I was told by somebody that it could become inconsistent if you "
force all the applications to a close on that database and

I have installed DB2 9.5 Enterprise Edition and Data Studio 1.1 on my laptop
in order to investigate the new features in the new version(s). But
shouldn't there be an Administration Console in the new Data Studio? In the
Release Notes in says I have to install the Data Studio ...

When doing "DELETE FROM tablename" on a large table, it may take a while
if the table is large.
On the other hand, the "IMPORT FROM /dev/null OF DEL REPLACE INTO
tablename" table runs rather quickly.

I am having a difficult situation in here...
Seems there is a query to create an index on a table and has just got
stuck.....
It is showing that it is in UOW executing status (in DB2 monitor) for

I have installed DB2Express-C (free version) and would like to connect
to DB2 on mainframe. Do I need to install connect separately ? if so,
DB2 Connect v8.1 fix fack 15 would work ? OR are there any free
connect available which works with DB2Express-C so that I can connect