As captioned question, i would like to how to alter the column from
null to not null?
Thanks

DB2 LUW v8.2 FP 14  RHAS 2.1
I have a DB2 online DB backup that was done w/ the INCLUDE LOGS
option.  I am interested in restoring that backup, and rolling
forward ONLY the logs contained in the backup and no more, then

I am trying to create dasusr1 (db2 admin user) by doing the following:
START--------------------------------
[root@plin-db2-stg01 instance]# ./dascrt dasusr1
DBI1088E Invalid access permission detected for directory

Is there a command that I can issue to create transaction logs prior to
connecting to the database? The connect itself can be a lengthy operation
if you have large transaction logs. :))
Best regards,

I have problem with registering multi XML Schemas
Based on:
http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.d
oc/doc/r0022716.htm
My commands are:

DB2 LUW v8.2 FP 14  RHAS 2.1
Regarding DST:
My OS and java were successfully patched for DST, but the DB2 instance
was never bounced.

Here are two tables
A.id,A,val
1,3
1,4

Folks,
 One of our clients is performing an audit, and the auditor(s) asked
 following question, and I am not sure how to answer it:
28.   Is there a control that prevents the corruption of databases (e.g. is

I'm getting SQLCODE: -805, SQLSTATE: 51002, SQLERRMC:
NULLID.SYSLH203.  I've seen this problem posted before and I thought
it might be a statement handle leak.  I'm using a pooled datasource,
then I issue sql statements.    I've cleaned up  all my sql calls

Hi, All,
We have a database on db2 udb aix.
The database has federated server to db2 mainframe.
Now We have already catalog database of db2/400 on the db2 UDB aix

We're encountering a situation where we're encountering a deadlock, and
someone's been made the deadlock victim. But after that, DB2 refuses to run
any SQL, and instead we get the error message:
   "Application must execute a rollback. The unit of work has already been

As I konw: database partition (aka data partition?), the database can
span multiple machines; table partition, the data within a table can
seperate by certain condition.
How about inter-partition and intra-partition? Is inter-partition

DB2 LUW v8.2 FP 14 RHAS 2.1
I'm confused about the NOTRUNCATE TABLE option of the REORG TABLE
INPLACE command.  In my mind, truncating the table means that you
delete all rows that it has - why would you not use this option

Here's the statement: delete from table a where id1=4;
Table a is a parent to table b,c,d,e,f,g,h,i,j,k,l
Table a key is id1,id2
table b,c,d,e,f,g,h,i,j,k,l key is id2,id3.

Good afternoon:
A little question about Exception table:
I want to create an excetion table for rows deleted but only want to
store few rows, 20 for example.