In Db2 How to view the values of special registers like
CURRENT SCHEMA
CURRENT PATH , etc ?

Do you know how to change kernel parameters on Solaris 10 for DB2?
I just installed DB2 ESE v8.2 on a new Solaris 10 box. But during the
installation, it asks for changing the kernel parameter like this:
DBI1030E Kernel parameter MSGMNB must be set to  65535.

Again, new to DB2.  Trying to do something I can do in Sybase ASE.
In any Sybase SQL script I can use /*  */   to comment out a block of
code.
In the DB2 9.0 SQL Reference Manual V1 it says:

I am interesting in this DB2 9.5 prep for new certification exam, but I get
this from DeveloperWorks:
The link which brought you here is invalid. Please reload the previous page
and try again.

I am doing an automated scan of a large number of UNIX machines which
can be Solaris, AIX or HPUX.
I want to find out for a machine via a script if:
1) DB2 is installed?

I have written a procedure which contains a LOCK TABLE followed by a
COMMIT, and it works perfectly when used by a user issuing a CALL
statement in AQUA DATA STUDIO.
I also have a WEB application which needs to do the same LOCK TABLE

Another of those "What's the DB2 equivalent to this Sybase syntax"
I use local variables in Sybase SQL scripts to hold values for use
later in the script.
For example:

I don't know if it's just me, but DB2 seems to have the worst syntatic
parser ever created!
Even after triple checking the documentation online, for the syntax of
the statements the CLP seems to be unable to parse the simplest of

I delete from large table over 50 million record, but snapshot monitor
show that the used pages not changed. Reorg take error "to small free
space in tablespace to complete reorg"

If I do a LOAD .... COPY YES TO C:\DIR then in directory c:\DIR a file
is created. When can I delete that file?
Best regards,
    Kovi

Performance-wise, is there a difference between these 2 clauses?
I assume a large database...
1) With the WHERE clause:
Select FLD1, FLD2, FLD3

How do I determine the current runtime client version on an AIX box?
What are the steps for upgrading a DB2 Client on an AIX box from 7 to
8 (or 9)?
  - do I need to uninstall 7 or just install 8 overtop of 7?

Do I have to set integrity or refresh the table in order to complete
the "detach of the partition"?

I have a resultset like this:
DATE         NUMBER_OF_TASKS_CLOSED     NUMBER_OF_TASKS_CREATED
PENDING_TASKS
----------

We have a table that is growing quickly and would like to partition it
by date.  However, the table does not have a date field.  With another
table, we are able to create a link to bring in the date.
Is it possible to create a table that is partitioned by date from a