I need to query a table for events that happen on third shift ( 11 PM
to 7 AM ) in a date range.  In the past, I've only needed to query for
one night, but I now need to query for 14 days.  Normally, I would say
WHEN Col BETWEEN TimeStamp1 And TimeStamp2, but obviously that won't

Can I know how can I get the last backup status for a db2 database from
the system tables..? Any SQl statement to get that details??
Regards
Santhosh

How can i retreive agent id in return when i connect to database and
run some sql?
can i do something like
db2 connect to database1

Every time during development we had to make table changes, we use Control
Center. Most of the time, Control Center fails. If you try to "undo all", it
doesn't, and you end up losing your identity seed, or your constraints, or
your triggers, or your table. Talking to developers ...

Hi Group
Are there any DB2 UDB ESE DPF V8.2  users exploiting "buffered inserts"
(BIND parm INSERT BUF) *and* "multi-row INSERTS" (many rows associated
with the VALUES clause of the INSERT to minimize number of calls to the

We are on Db2 v 8.2 for Linux
If we need to use TSM for backup of DB2, do we need to have TSM client
installed on the database server.
if yes, do we need to purcahse it separately or is it freely

I have been developing some queries which will list the dependencies of
Stored Procedures (this is with DB2/UDB v8). In doing so, I have
noticed that dependencies are ignored if they occur in an insert into a
temporary table. For instance, if you have the following procedure:

 I am new to DB2  for windows and I have a question about generating unique
numbers for a primary key. I have decided to use the generate_unique()
statement in a trigger to create this number. I have written the trigger like
this:

mir ist die Update Syntax im SQL bekannt aber für das was ich möchte,
reicht mein wissen leider nicht aus.
Habe 2 Tabellen mit folgenden Feldern
1. Tabelle: LaufendeNr, Datum

hai everyone....
                             can anyone tell me how to work with
db2gov......... i tried this.......
   db2gov start <dbname> C:\Program Files\IBM\SQLLIB

Environment: DB2 UDB LUW 8.2
Following problem was submitted.
create table t1 (c1 char(10) not null)
insert into t1 values(default)

I could't able to connect to Db2 DB using the java program [type 4
driver.] I received the following error:
Error is No suitable driver
java.sql.SQLException: No suitable driver

I started a thread back in late May.  Shortly after posting I got
caught up in another project and didn't get back to the "trigger" work
until today.  I tried to reply to the original thread but it won't
allow replies to threads older than 30 days.  Here's a link to the

I have a table (ORDERS) with this kind structure (this is not the
really table):
OrderId   Product   Amount  Agent1  Agent2  Agent3
________  _______   ______  ______  ______  ______

Quoted from the: "Application Development Guide: Programming Server
Applications Version 8.2": (DB2 for LUW).
"Stored procedures cannot issue COMMIT or ROLLBACK statements if the stored
procedure was invoked from an application that established a type 2