Is there a way to attach a partition to an existing table that already
has partitions (without loading data)?  For example, the syntax of the
attach partition is documented below:
alter table <tablename> attach partition P_data_2009Q1 STARTING FROM

I am using a query into db2advis for index recommendation. this query
is having a CTE (with clause). when I run db2advis it returned some
error like
Database is reporting the following error:

we have a perfectly working recursive CTE which gives us SLQ0347 (The
recursive common table expression "<name>" may contain an infinite
loop.)
The CTE parses a string ("This,is,a,string"), removes word by word and

I need to do an update by taking data from another table. Can I do
that in some nice way or do I have to make a number of selects into
variables and then do the update?
Thanks,

is there a way to see the actual (not just estimated) cost and
cardinality at each plan operator?  SQL Server and Oracle has such
feature but I failed to find a way in DB2 yet  (up to V9.5)

I am interested in capturing snapshot information using SQL functions
or views but i can not reset monitor switches when i use following
command.
db2 "reset monitor for database <database name>"

I have another complicated query I could use help on.  Here is what
the tables look like:
Table1
col1       col2

I am on db2 (64 bit) v8.1.1.112 FixPak "12" 0n AIX. Is there any
limitation for bufferpool size. what should be the RAM size and for a
given RAM size how much we can allocate to bufferpools if it is a
dedicated server.

my runstat runs too slow. Moreover, it is not using lots of available
resources (cpu is 94% idle, iostat shows really small intermittened
IO)
is there a way to speed up runstat?  or is there a way to query

Environment: Solaris (client + server)
db2 version 7.2 latest fixpak (DB2 v7.1.0.111", "s050516" and
"U803330")
Compiler: gcc

- Federation Server (DB2)
- Solaris 10 Fed Server
db2 "create user mapping for USER123  server SRV1 options
(remote_authid  ‘AAA_USER’, remote_password  ‘PWD’)"

If i have HADR setup with data synch setting of NEAR-SYNC and i have
congestion on the line. Do my transactions block until the my
HADR_STATE goes to PEER.
In the instances that sometimes i have congestion,i have not noticed

I’m trying to set up DDF on DB2 9.1 and am getting the following error
–
DSNL013I  -DB9G VTAM OPEN ACB FAILED
ERROR='24'X

I know that we can use import or load to truncate tables without
filling up trans log in DB2.  Is it possible to do this in a stored
procedure?  How about in CLI/C++?   My impression is that import/load
are not SQL statements, hence may not be included in stored procs or

How to Give Operating System Security in db2 if the check box is not
checked during
installation but planned for later.
Thx in advance