Hello world!

I'm preparing for the 730 and 731 tests and even though I spent quite a while with DB2 I feel like I don't know anything. And I hope I can get a few answers here.

There are the slides from the classes I attended which state that entire databases can be locked exclusively. On the other hand, there is http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db29.doc.perf/db2z_sizeoflock.htm where it says "A table space lock (the largest size) controls ...". So what should I believe?

But there are more problems than simple contradictions. I'm also having difficulties understanding the text. When promoting a lock, say from S to U, am I releasing the S lock?

When I don't understand parts of the text I set up 1-2 testing tables to play around a little. What's the deal with the group PUBLIC? I can grant whatever privileges I want to PUBLIC and thus granting privileges to users I don't know (yet). If I don't explicitly grant privileges, PUBLIC will only be able to connect to databases and nothing more, or am I missing something? The group PUBLIC is mentioned quite often even though it hasn't got any rights, has it?

Thanks in advance, for any reply.

Cheers

Martin


DB2 & UDB email list listserv db2-l LazyDBA home page