DB2 hiring questions

[login to unmask email]

DB2 hiring questions
One I always liked was, "You unload and delete a table, then recreate the
table and all relative previous objects, then reload, and performance is
terrible. Why?" Of course there are a lot of reasons depending on God
only knows what (like RUNSTATS or not, rebinds, objects allocated to
extremely high activity volumes, newly created objects go into default
bufferpools which are too small or contentious or both, etc.), but the
dummy interviewing you thinks there is only ONE answer.

George



Bill Johnson

Re: DB2 hiring questions
(in response to truman.g.brown@VERIZON.COM)
That's especially true with DB2 since there are a number of factors in
almost every problem. I've been asked questions in interviews that the
interviewee was looking for a specific answer where many existed. Or
sometimes the question was not worded correctly for the answer they were
expecting. Happens all the time.

Bill Johnson
Parker Hannifin
Cleveland, Ohio



[login to unmask email]
IZON.COM To: [login to unmask email]
Sent by: DB2 Data cc:
Base Discussion Subject: Re: DB2 hiring questions
List
<[login to unmask email]
ASSOC.COM>


01/09/2003 05:29
PM
Please respond to
DB2 Data Base
Discussion List






One I always liked was, "You unload and delete a table, then recreate the
table and all relative previous objects, then reload, and performance is
terrible. Why?" Of course there are a lot of reasons depending on God
only knows what (like RUNSTATS or not, rebinds, objects allocated to
extremely high activity volumes, newly created objects go into default
bufferpools which are too small or contentious or both, etc.), but the
dummy interviewing you thinks there is only ONE answer.

George



the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can