I am running DB2 UDB v8.1 FP 14 on AIX 5.3
I have two servers ServerA and ServerB.
ServerA has instance InstA
ServerB has instance InstB

I had one delete statement, it was running for some time, caused
fragmentation on indexes. The delete performance is getting worse.
After  reorg the indexes, the performance is getting better.
My question is I got explain before the reorg/runstats and after reorg/

How can I check if a char/string is a digit/number in an SQL UDF?

I know how to create an instance by db2icrt command, such as

The -s option of the db2icrt command, which specifies the type of
instance to create. Valid values are CLIENT, ESE, and WSE. I always

Am I correct in assuming that it is NOT normal practice to repeat all the
certification exams for the new DB2 version when a new DB2 version comes
out?
Let's say I took exams 700 and 701 and passed, which give me Associate and

I want to know how to connect and execute a db2 query from inside a
UNIX shell script.
Details: We have a unix shell script. We need to execute multiple db2
sql queries from this shell script and export the result to a file.

I've installed a fresh DB2 V9.1 server (Express-C). Now I see, that the
number of applications (db2 list applications) is growing all the times
when a script is run which makes some database operations. This is on
Linux.

Probably a simple question :-)
I've got a few xml aware databases on a 9.1.2 db2 server running on
RHEL 4. As db2 V9.5 doesn't run on RHEL 4 I've set up a new server
running RHEL5.1 with db2 9.5 on it. ((64 bit version)

short history:
Power designer 12.5.0.2169 (newest one from Sybase site) version with
full functionality
I creare a new physical model. go to the menu "Database\Configure

I need to write some code that will validate data. I have a checksum,
that I need to calculate in a rather complicated way, so a simple
CHECK is not enough. Which is the best way to do that in DB2?
Ewa.

I have db2 9 installation and I think our application isn't handling
locking optimally.
I have Maxlocks(96) and locklist (104832) setup to be auto tuned. The
value of these parameters in the parenthesis are the auto tuned values

Helpful folks,
I have run into a glitch with a DB2 V8 single-partition install on a
new MSCS two-node hot standby cluster. After many stumbling blocks,
the instance and a test DB I have created on it can be successfully

If you are managing a partitioned UDB database, I would appreciate any
answer on this:
Lets say that I have a performance problem (query which runs slowly,
locks, etc.) and would like to tune a partitioned UDB installationI.

I have a successful app which is used in a variety of client/server
situations. (DB2 8.x.)
I need to update it to have XML capability to interface with several
other external programs.  Therefore, I was happy to see that DB2 is

we face some severe performance problems and identified at least major
problem. Our application is a localized Web application. Localized
texts are maintained in a database table. We defined views that return
unlocalized data, ie. texts to be localized are returned as an index