467,923 Members | 1,800 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,923 developers. It's quick & easy.

common problems found in db2

Hi all,

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...

Jul 3 '07 #1
  • viewed: 1983
Share:
3 Replies
On Jul 3, 7:11 am, kavin <kavinilammur...@gmail.comwrote:
Hi all,

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...
Getting staff to read manuals and go on training courses.

For a general flavour, you could try reviewing the archives of this
newsgroup

Jul 3 '07 #2
On Mon, 02 Jul 2007 23:11:02 -0700, kavin wrote:
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...
- Dealing with show-stopper lock situations.

- Fixing tablespaces which are in various sub-optimal
states after more or less failed LOAD operations.

- Helping users getting the EXPLAIN facility to work.
Why does this have to be so involved (setting up
special tables, and - it seems - giving them
rather broad permissions before the EXPLAIN
facility works properly)?

- Helping users install DB2 client software on their
PCs.
Adding databases/nodes to catalogs (why is this
annoying task needed - why can't db2cc be asked
to perform connections to databases which haven't
been catalogued?).

- Performance-related tweaks (bufferpools, etc).

- Fixing tablespaces which turn out to be of the
wrong type (e.g. with an unsuitable page size, thus
not allowing for large tables; this problem is
supposed to be less of a problem with DB2 v. 9).

- User additions/deletions/permission-adjustments.

- Helping users restoring data which have been
lost by accident.

- Regularly checking db2's error-log, and regularly
checking that backups really went well.

- Storage planning/re-organizations/additions.

--
Regards,
Troels Arvin <tr****@arvin.dk>
http://troels.arvin.dk/
Jul 3 '07 #3
Thanks a lot

Jul 4 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Klaatu | last post: by
12 posts views Thread by Helmut Jarausch | last post: by
6 posts views Thread by Peter | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.