By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,589 Members | 2,276 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,589 IT Pros & Developers. It's quick & easy.

common problems found in db2

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
Thanks a lot

Jul 4 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.