I want to do a db backup to tape. I looked thru the command reference
and it just says "to tape". I don't know how to reference the tape
drive on windows as it is not assigned a drive letter. Can someone
please give me the command? Should I be seeing the tape drive as a

I am trying to construct this query in a function:
SELECT CONCAT('SEQ=',CHAR(NEXTVAL FOR MYSCHEMA.LOAD_ID)) FROM
SYSIBM.SYSDUMMY1
Here is what I use to construct it but I am unable to get the single

I'm playing with the ICU library (slow weekend :-) and it's quite simple
to expose the regular expression functionality for Unicode databases.
Presuming that the majority is not on unicode, would a developerWorks
article which supports ASCII only for non unicode DBs be useful?

i have a process thats in  roll back state..i ts going on forever..i
need to kill it and would like to restart it with some changes....
if not atleast i need to know the status of the rollback to estimate
how longer it migt take...no use with this..but just for my info....

I have a file with data i'd like to import into my relational dbs.
The file looks like this:
Name     age       job
Tom         23       Programmer

   First of all very thanks to all of u for the valuable info.
   Here is a small question and im very much pleased if you give
reply.
" I want to install the new fix pak on my production system which is

What is the equivalent of Oracle's SPOOL in DB2 V8.2?
I would like to redirect the output of my sql query into a file.How is it
done in DB2?
Cheers,

I recently migrated a db2 v7 to db2 v8 and it worked perfect, all
stored procs etc are there and they are executable but ... I cant edit
(through Development Center) the java stored procedures because the
source is missing ! I have tried to find the source on the old server

Can anyone please provide some assistance with a trigger that I need to
develop.  Here is the situation:
Our program updates depend on database updates.  If a client receives
the program update and the database hasn't been updated then it's a

The force application command will terminate the connections specified,
but it does not stop new applications from connecting to the databases.
Is there anyway to stop new applicaitons from connecting to the
databases for database maintenance?

I have some question on DB2 SQL Statement Cache. In the Oracle world,
we allways use bind variables extensively, otherwise, Oracle does not
re-use the statement cache, and there by resulting in excessive parsing
of the SQL Statements.

we've recently changed our db2 server from using a single RAID array to
a SAN.  (machine is running 8.2.4 UDB on SLES 9, 2.6 kernel, 32 bit
Intel)
If we'd been using a RAID array, then we'd be tuning prefetch size

Windows XP connected via DSL over a VPN to an AIX server
DB2/6000 8.2.3
Using IBM DB2 ODBC Driver
I can connect fine to a specific DB via an AIX box and a person in the

When I ran the following SQL Statement from a non-SYSADM user, I
getting SQL0443N errors.
select table_name from table(snapshot_lock(' ', -1)) snapshot where
table_name is not null order by table_name

I have a script whcih creates a new db2diag.log file everyday. My
problem is the moment a new file gets created, there is too much data
being written into the db2diag.log
Is there any way where in we can restrict unnecessary items being