Hi, I executed the following db2look statement but got an 'Execute'
privilege error.
What privileges do I need to execute the 'db2look' utility?
/home# db2look -d dbname -e -o sql.txt

When I right click on a database in Control Center and choose 'Applications'
I get listed alle the applications connected at the moment, and among other
things I get to know the 'Client login ID'. For some reason I want to have
this information written to a file, but this is not ...

How do I load "varchar for bit" data in hexadecimal format into a DB2
table ?
Table definition
===========

Let me preface this by saying that I'm used to working with Access,
which is not real SQL but can be useful in a jiffy.  Keeping this in
mind, be gentle.
Does DB2 support passing a subquery parameters from the global query?

Is there any way to suppress SQL0100W message?
SQL0100W  No row was found for FETCH, UPDATE or DELETE; or the result
of a
query is an empty table.  SQLSTATE=02000

We have a system requirement where a large amount of data needs to be
transferred between two systems. The main system is a DB2 8.x running
on a pSeries (AIX) and the archive database resides on an iSeries
(AS/400).

i have a query which fetches the sum of amounts from a table .the
column is 19 bytes
but the query returns only the actual amount..for example ..it returns
..

specifying the minpctused on the create index statement may have the
most negative performance impact on what operation,
insert/delete/update/select? Thanks for the response.

i am using the follwing code to connect to db2  :
java.sql.Connection connection = null;
                java.sql.ResultSet rs = null;
                ExperimentJDBCHelperBean jdbchelper =

can anyone explain what should be given for Nodename entry in the
'catalog TCPIP" command  ...... pls let me what exactly is NODE
..........
Gladiator

I am creating a database trigger to write details real time from tables
on one AS400 to another over our WAN. Is there such a concept as ODBC
connections on the AS400 to
perform this task and if so can anyone explain how I would configure

Thanks in advance.. I need to write a Java program that will connect to
a DB2 instance and will display the DBs in that instance and its
current status..
if anyone knows how to do this, or if they have any sample program for

Suppose a running database (DB2 UDB) with all containers being SMS
based (file system as JFS or JFS2 on AIX).
How to make a backup (online) by doing a file system backup and not a
database backup?

is there any commandline option to see if there are uncommitted
statements and which statements aren't comitted? Or at least a hint that
there are uncommitted pages in the transaction log.
Bernd

i was working on DB2 and came across an issue. i.e. can a tablespace be
rollforwarded to POINT-IN-TIME?
the scenario is as follows:
i created a data base and a tablespace in it.