I would like to alter a table's column from null to not null.  Is this
possible or can you only do the reverse?
If I can do it, what's the syntax, the .pdf doesn't describe it.
TIA,

This is my TABLE:
CREATE TABLE test(
 data BLOB
)

When I try to drop a database or list the applications, I get the following
error:
SQL1092N: dbsys does not have the authority to perform this command.
I checked:

I have created several aliases to members using the CREATE ALIAS
command, but I lost track of them.
Now I want to see a catalog of all the aliases mapped to all members in
a FILE.

I created a Stored Procedure like this:
CREATE PROCEDURE myProcedure(IN a_tabschema VARCHAR(20))
 DYNAMIC RESULT SETS 1
 LANGUAGE SQL

How do I check whether a user have sysadm privilege on DB2 UDB v8.1
database?

Transitive closure (TC) of a graph is
with TransClosedEdges (tail, head) as
( select tail, head from Edges
 union all

How can I make Case expression not to execute ADDID() when it does not
satisfy requirements? Right now it executes function even if
requirments are not met.
SELECT ADDID(), CASE WHEN 'A' IS NULL THEN  ADDID() END, ADDID() FROM

In the snapshot for database I have a high value for the line:
Agents stolen from another application
Can someone explain what is actually meant by the statement (how is an
agent stolen) and what type of impact a high value for this has on a

  I would like to know whether there is a way to estimate/calculate
the view table size in DB2. As what I understand, view is just a
logical table and we cannot simply calculate the size based on the
physical table(s) that made up the view. Any ideas?

can you please tell me, in which way we can modify the diaglevel of a
runtime client?
Til yesterday I did not know, that the runtime client also has a
db2diag.log.

I want to migrate  RS/6000 on AIX 4.3 to AIX L. I want know if DB2 for
AIX Version 2.1.2 run on AIX 5L without a problem.
Thank you

We are pre binding to a test database, and we want to bind to another
database. We are using DB2 version 8.
We are using a user called MCJ100D to prebind.
We are using MIJ100D to bind; i.e. DB2 BIND testfile.bnd COLLECTION

Is there a way I can drop and recreate the toolsdb?
I already have a toolsdb in our server but somehow it is kind of messed up.
Whenever I try to drop the following message:
SQL1035N The database is currently in use

The problem is that when AddID is used multiple times in the same
select statement, it returns the same value in all places. How could I
force function AddID to increment OBJECTID sequence?
Here is a basic sample of usage: