Ok IBM techs.
Does the REORGCHK_TB_STAT and REORGCHK_IX_STAT Stored Procedures issue
a Runstats.
I have ran the old REORGCHK utility with stats and both SPs and it

I'm new to partitioning of DB2 databases and had a question.
Can I create a primary DB2 partition on lets say AIX 5.2 and then add
additional partitions on AIX 5.1 and AIX 5.3?

   I have a table where fields 1 and 2 make up the primary key.
Because of this, I have a unique composite index on fields 1 and 2 (as
required by DB2).  Now my question is:  Fields 1 and 2 are also
separate foreign keys to two other tables. I have read that it is

I downloaded a new copy of v9 to a virgin machine.
It does not respond to DB2START, indicating that "The database manager
is not started."
I don't know what local or system variables need to be set, and there

i have  a problem
i had one master  database a which connects to some remote server and
stores the transaction  data.
i have 2 more database of same stucture as the one above mentioned.

What is the query to obtain a list of all the tables having the maximum
number of rows in descending order?
Cheers,
Sandeep.

i directly copy the file compiled in another machine to sqllib/function
, and run the createfun.sql
but when i run it .. it throw sql0444n

Can I partition an existing table?
I have a table which has started growing at a very fast pace and would
like to partition it.
Thanks.

I have 3 systems with db2 running on AIX. We take online backup o
weekdays and offline on saturday. For the past two weeks the offlin
backup is getting terminated after exactly 2 hours 13 minutes on tw
systems. I am getting a timestamp in the backup history file. The thir

Do you know of a redbook for developing and debuging db2 stored
procedures?
PS: It doesn't have to be a redbook. Any reference would be fine.
cheers

What is the difference between DB2 Client and DB2 Connect?
Our databases are DB2 8 on AIX and z/OS.  Can we use DB2 Connect to
connect to DB2 server on AIX and DB2 on z/OS?
Thanks!

DB2 V8 FP 11.
Given two strings, I need an UDF to compare both and return the
percentage of matching characters.
For example:

db2 v8.1FP 7a on AIX 5.3.
My weekly overnight REORG job sometimes generates SQL2219N rc 9 errors
"START is not allowed as a prior paused table reorganization has not
been stopped".

In the excellent new IBM DB2 help center
  http://publib.boulder.ibm.com/infocenter/db2luw/v8//index.jsp
Searched under "organization of memory use", it talks about
"applications canbe assigned to application groups to share memory" in

the DB2 v. 7 resides on a Z/OS mainframe.
we want to support different languages with special local characters
for one kind of information.
if someone is using hungarian, the string may contain special hungarian