What are all the common problems or major issues a DBA can
face?
        what are all the catagories in which problems arise in db2..
that can help to log a call to DB2 admin...

When backing up a group of DB2 WSE v8.2 databases, I am getting the
following error on one or two backups out of 38 being performed.
"SQL2025N An I/O error "200" occurred on media <target directory
path>".  The backups run every night.  This error appears about two

For anyone that is interested in this, this has been fixed by IBM as a
result of the PMR we raised. It should be present in the fixpak due
out in December.

I am connecting to a DB2 v7.1 server from windows using JDBC type 2 (I
figured out that type 4 is only for 8 and upwards).
I used DB2 Connect to create a system DSN and seem to be able to
connect fine using db2connect and run queries etc.

Consider the following...
- A customer table with a customer number column as the primary key, and
also a column called SHORTNAME.
- An account table with an account number column as the primary key, a

  I'm familiar with the restore of  single partition online backup
taken with INCLUDE LOGS.
Also familiar with the restore of multipartition using offline
backup...

It seems IBM will offer DB2 on Solaris X86, does anybody know when it
will be avalible.

I was trying to find the information about when and where should I use
cursors in DB2, no luck. Maybe you can point me to some article that
describes just that (or tell me which page is it in DB2 SQL reference
book, if it's there)? Or maybe you can post a short answer here, if