Am trying to create the DDL statements of a database using
$ db2look -d TESTDB -e -z db2tar  -i testiii -w test123 -m -o
db2look.sql
I get all the useful information except that of the Bufferpools and

Can I have an insert-select in DB2 UDB as below ?
First select count(*) test_count from t_op T
and then
INSERT INTO tablea (select count(*) test_count from t_op T ) values

I need to export some tables to an excel file inside a REXX unattented
script that run periodically.
I've tried the command :
DB2 EXPORT TO MYFILE.WSF OF WSF SELECT * FROM MY_TABLE

Hi, is there any way to call a JAVA stored procedure from a SQL Trigger?
We are having difficulties with this and cannot verify whether DB2 even
*has* this capability?
Thank you very much....

I had accidentally removed an active transaction log file.
After doing so, my database cannot be started (db2start).
Is there a way to make my database start again?
Please advise.