1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l November 2008, week 5
2 169 44_Re: Forward log recovery for a dropped table14_Wayne Driscoll18_wdrisco@US.IBM.COM31_Fri, 28 Nov 2008 22:11:54 -0600547_US-ASCII Peter, For a huge number of reasons, including integrity the OBID option of CREATE TABLE can only be used to assign an OBID that is not currently in use in the given database. A DROP TABLE is not enough to "free" an OBID from the DBD. In order to free an OBID, either the TABLESPACE must be dropped, or the TABLESPACE must be REORGED and then all SYSCOPY rows for the TABLESPACE containing the table must be removed via MODIFY RECOVERY. As long as an image copy exists in the catalog that could contain rows from that table, the OBD [...]
172 44 21_Thanks James Campbell13_Laila hosaini19_lshosaini@YAHOO.COM31_Sat, 29 Nov 2008 00:58:16 -0800795_us-ascii Dear James Campbell one of your old E-mails in the list archive was so helpful.I would like to thank. l.S.H<br><br><br><br><br><br><br><br><br><br>______________________________________________________________________<br><br>* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA * ______________________________________________________________________<br><br><br><br><br><br>The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in [...]
217 169 34_Re: DB2 zOS - Sequential Detection15_Douwe van Sluis21_d.b.van.sluis@HOME.NL31_Sat, 29 Nov 2008 16:21:34 +0100463_US-ASCII Hi Isaac,<br><br>Spot on. I should have typed "more than 4". And yesterday 5 was more than 4 ;-)) Thanks for the "minor" adjustment.<br><br>Vriendelijke groet, Douwe van Sluis<br><br><br><br><br><br><br><br>-----Oorspronkelijk bericht----- Van: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Namens Isaac Yassin Verzonden: vrijdag 28 november 2008 12:18 Aan: DB2-L@www.idugdb2-l.org Onderwerp: Re: [DB2-L] DB2 zOS - Sequential Detection [...]
387 97 27_How many partitions is big?13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Sat, 29 Nov 2008 11:23:04 -0600338_ISO-8859-1 Hi All,<br><br>I am looking for some assistance..<br><br>We are building a series of tables for benchmark testing and would like them to be as representative of the real world as possible. One area we would rather not guess at is how many partitions is realistic?<br><br>If you would, please drop me a private e-mail at * [...]
485 414 67_CDUG | Dec 11 - A day with John Campbell - Colorado DB2 Users Group52_Crane, Rob --- Sr Technical Manager Database --- CFS19_rob.crane@FEDEX.COM31_Sun, 30 Nov 2008 13:32:19 -0600493_us-ascii The Colorado DB2 Users Group for z/OS is hosting their winter meeting in Colorado Springs at FedEx Rocky Mountain Technology Center on Thursday, December 11, 2008. We have a full day of technical DB2 presentations.<br><br>Come spend the day with John Campbell and gain valuable insight into DB2. We also have IBM's DB2 technical update being given by our IBM liaison. This is an excellent opportunity to learn more about DB2 and network with other DB2 professionals in Colorado. [...]