I have a questionabout reorging very large tables. Running DB2 8.1
Fixpack 6 on AIX 5.2 supporting Siebel. I've read through the docs I
could find and the postings in this newsgroup on the challenges in

In a DB2 LUW v. 8.1.1.96, I have a hard time giving users access to the
db2expln utility.
Let's say that user FOOBAR needs to be able to run the db2expln utility. I
do:

I use db2 v8.1 AIX 5.2
Today we recieved an error at the use machine (db2 client) while
loggin into one of the applications.
The details of the error message are:

 I have received a database online backup that was taken using the
command
db2 "backup database prdDB01 online  to /udb/db2inst1/backups INCLUDE
LOGS"

Is there a way to set a default schema name by setting environment
variable, so that it is set for CLP before connect to the database?
Thank you.

I m trying to move only stored procedures from one database to another
and also onto a  database on another server, I tried
db2 -x "select text from syscat.procedures where procschema =
'MYSCHEMA'" | tee /esa/home/sasha/MY_SCHEMA_SP.txt, how ever all the

In the DBMS I know best, PostgreSQL, there is no real performance
difference between CHAR and VARCHAR. And since CHAR pads with spaces, I
generally dislike CHAR (with CHAR, it's not possible to see if the input
value had trailing spaces or not, for example).

I am trying to determine which tables in my database are being joined
and by what columns.  I then came up with a query against
EXPLAIN_PREDICATE that returns rows similar to the following:
(Q1.PERIOD_KEY = Q2.PERIOD_KEY)

I want to uninstall DB2 client v7 & v8 on a Solaris box and I can't
find any documents in IBM website on it. Could anyone help me out
please?
Thanks a lot.

I use db2 v8.1 on AIX 5.2
I recieve the following message in my DIAGLOG after evry instance
restart.
2007-02-09-03.39.17.201881   Instance:db2inst1   Node:000

If I increase LOGSECOND on a database, will the change become active
immediately, or does the DB2 instance need to be restarted before the
change is in effect?

I have the following in my procedure:
CREATE PROCEDURE x_proc ( IN from_date timestamp
                                             , IN to_date timestamp
                                             , IN data_center char(1)

I'm just getting the hang (slightly!) of column functions.  Take the
following table:
CREATE TABLE "FILM    "."FILM_TRANSACTIONS"  (
         "BRCH_NBR" DECIMAL(3,0) NOT NULL ,

I am seeing different hang/deadlock behavior with 2 different JDBC
connection methods.
METHOD A
-------------------

I know variuos way to enumerate sql server in VB and VBA but is
possible to have the same for DB2 server????