DB2 8.2.3
is there a sql equivalent to get the information provided by
db2 list node directory
db2 list db directory.

we had this error while running the applicaiton on db2 v8.2 EE on
windows, jcc driver is what we use
SQL error 805
com.ibm.db2.jcc.b.SQLException: NULLID.SYSLH203 0X5359534C564C3031,

I want to thank all of you that have answered my earlier questions, thanks.
New problems though. The database doesn't start with the operating system
and I can't find out how it does that on the other server. Can't find
anything in the rc-files that seems to apply so I figure that ...

hey everyone. im looking for some sort of daemon or other type o
program that can run on/with db2 that will periodically wake up an
query a table, and depending on what it sees, it may delete from th
table. does db2 have some sort of built-in configurable daemon? or wil

I was advised to divide a DB2 server cost according to instances usage
monthly. Does any one have idea on what matrix/method/tool could be
used? Ideally, the statistic could be collected once from the DB2
instance once a month to save effort...

Can a partitioned database full backup image be restored into a non
partitioned database?
The database objects in both the databases are exactly the same.
Cheers,

I have a ASCII file that I need to import with METHOD L, since columns are
fixed length. The problem is that I have more columns in a table that I'm
importing to that there are columns in the file. Is it possible to specify
some default values for columns that are not part of ASCII ...

I have a table with a column of BIGINT and I want to change the type to
SMALLINT.
Command ALTER TABLE TABLE1 ALTER COLUMN COL1 SET DATA TYPE SMALLINT
does not work since I cannot specify SMALLINT in set data type clause

We have just upgraded a test enviroment to db2 9, and have set both the
notifylevel and diaglevel to 3. But even so I get a lot of these
messages in my db2diag.log:
2006-11-02-00.10.11.951000+060 I326548H465        LEVEL: Info

I have this kind of information on a db table
COMPANY    USER     MYDATA
______________________________
                   AA

I'm using DB2 V9.1.0 on SUSE Linux with kernel version 2.6.5.
In the system I'm working on, there are several stored procedures which
perform simple selects through different views.
Those views are redefined (drop/create) periodically. DB2 rebinds the

Colleagues:
Can anyone tell me what the number to the right of "Index Prefetch:
Eligible" designates in the output from db2expln, e.g., "Index
Prefetch: Eligible 14409"?

Hi - I'm having some federation difficulties and am looking for some
help.  On AIX 5.3, I'm running DB2 ESE 8.2 FP12 with Federation
enabled.  Oracle client 10.2.0.2.  I can connect to a remote oracle
instance using sqlplus, so I'm pretty confident the Oracle client is

I have the following scenario...
I am using HP DataProtector. I have added one client to the cell for
the first time both backup of database & archive log happens but after
removing the client from the cell adding it again this time only

The ETL application loaded around 3000 rows in 14 seconds in a Development
database while it took 2 hours to load in a UAT database.
UAT db is partitioned.
Dev db is not partitioned.