1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l June 2008, week 5 2 140 29_Re: DB2 Cloning Tool for z/OS12_Myron Miller22_myronwmiller@YAHOO.COM31_Sat, 28 Jun 2008 20:34:48 -0700423_iso-8859-1 We create two copies of production, one in production for reporting and another in test for production like testing (read-only) daily with DSN1COPY. We do several hundred tables (over a thousand) and about 20-30 databases with minimal issues using jobs that have been fully automated.

There's even a process semi-automated for programmers to copy a production image copy into their test environment. [...] 143 1611 27_Re: Spam Quarantine Summary13_Bill Callahan27_bcallahan@ITCONVERGENCE.COM31_Sun, 29 Jun 2008 15:56:07 -0700833_us-ascii Hmm...





I will ask the guys.





Bill Callahan

Hosting Services Practice Manager - ISS

IT Convergence









________________________________

From: Postmasters Sent: Sunday, June 29, 2008 6:00 AM To: db2-l@www.idugdb2-l.org Subject: Spam Quarantine Summary







Account: db2-l@idug-365-lstsrv01.itciss.com

This is your quarantine summary from the Barracuda Spam Firewall.

You have 5 messages in your spam quarantine inbox.

* Click on the Deliver link to have a message delivered to your mailbox. * Click on the Whitelist link to have a message delivered to your mailbox and whitelist the sender so that his/her messages will no longer be quarantined. * Click the Delete link to [...] 1755 511 52_Re: [fluff] RE: [DB2-L] RID Pool Storage Calculation10_Max Scarpa28_Massimo.Scarpa@PHOENIXSPA.IT31_Mon, 30 Jun 2008 08:26:09 +02006_UTF-8 2267 199 29_Re: DB2 Cloning Tool for z/OS16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Mon, 30 Jun 2008 07:31:25 -0400469_iso-8859-1 Gee (can't you see I am blushing)

Thanks but there was no need to apologies

As for the thread, a simple question can lead to a complex answer. Since 'SURPOSSEDLY' I have some experience and certification recognition within this subject area, I thought it would be wise to highlight some of the more common issues/questions/areas to explore when one starts down the road of Data Privacy. It is a complex arena and with a lot of road bumps. [...] 2467 131 20_Re: Last Update Date14_Grainger, Phil20_Phil.Grainger@CA.COM31_Mon, 30 Jun 2008 13:50:35 +0100297_us-ascii "DB2 generates a value for the column for each row as the row is inserted, and for any row in which any column is updated."

Actually, DB2 generates a new value for this column whenever an UPDATE is issued against the row - EVEN if that update does not change any of the data. [...] 2599 154 29_Re: DB2 Cloning Tool for z/OS10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Mon, 30 Jun 2008 13:25:06 +0000475_utf-8 Hi Myron,

What size of production data are you copying? Is it TB? If any of test objects are dropped/re-created don't you need to update the DBID/OBID translation?

I've tried to test this out once before based on the steps in the manual, but was missing something. And since the whole obid/dbid translation process hasn't suck into my brain well enough where I actually understand it I'm hesitent to go down this road just going through the motions. [...] 2754 47 20_Re: Last Update Date10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Mon, 30 Jun 2008 13:28:25 +0000714_utf-8 For fact tables that need to get replicated across an enterprise knowing the add date, rather than replicating the whole database each day, would provide some benefit.

On Sat, 28 Jun 2008 18:18:32 -0400, Don Leahy wrote: > > For transactional data, an update timestamp is an excellent >idea. Among other benefits, it helps the programmer reconstruct what >happened when a transaction isn't processed exactly as expected. For >'fact tables' (by that I mean historical data in a data warehouse), >the date/time that the row was loaded into the warehouse is not as >significant. > > >_________________________________________________________________ _____ > [...] 2802 30 20_Re: Last Update Date10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Mon, 30 Jun 2008 13:30:48 +0000490_utf-8 You can always read the row frst to make sure something is changing beforing issuing an update :-D

On Mon, 30 Jun 2008 13:50:35 +0100, Grainger, Phil wrote:

>"DB2 generates a value for the column for each row as the row is >inserted, and for any row in which any column is updated." > >Actually, DB2 generates a new value for this column whenever an UPDATE >is issued against the row - EVEN if that update does not change any of >the data. > [...] 2833 61 52_Re: [fluff] RE: [DB2-L] RID Pool Storage Calculation14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Mon, 30 Jun 2008 09:52:01 -0400449_us-ascii Hah. Leave it to that lot to use _anything_ as grist for a laugh. Why haven't they gotten together again and made something new? Or at least John Cleese?

--Phil Sevetson

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ted MacNEIL Sent: Friday, June 27, 2008 6:14 PM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] [fluff] RE: [DB2-L] RID Pool Storage Calculation [...] 2895 197 48_DB2 Connect Version 9 and DB2 for Z/OS Version 815_Schade, Jeffrey15_JSchade@ISO.COM31_Mon, 30 Jun 2008 09:55:43 -0400306_us-ascii We are running DB2 Z/OS Version 8 in NFM and we would like to install DB2 Connect Version 9 on all our servers now to be ready for the V9 upgrade on the mainframe. Is anyone running DB2 Connect Version 9 on servers connecting to DB2 Z/OS V8 on the mainframe? Is this configuration supported? [...] 3093 76 28_FREE IDUG Webcast - July 9th0_21_leyba0224@COMCAST.NET31_Mon, 30 Jun 2008 15:36:57 +0000590_-



What's New in DB2 9 Part 3 - New Options Wednesday, July 9, 11 a.m. ET The International DB2 Users Group (IDUG) is pleased to partner with CA to deliver a free Webcast by renowned presenter Phil Grainger, Sr. Principal Product Manager. This live event will run approximately 60 minutes and participants will have the opportunity to pose questions to the presenter. Capacity is limited, so register early. About the Webcast: Already we are on the fifth in the DB2 9 for z/OS series of webcasts from CA (and there are still more to follow). Today Phil Grainger will be [...] 3170 164 52_Re: DB2 Connect Version 9 and DB2 for Z/OS Version 812_Myron Miller22_myronwmiller@YAHOO.COM31_Mon, 30 Jun 2008 08:59:50 -0700699_iso-8859-1 I've been doing that for a few months now.

Myron

--- On Mon, 6/30/08, Schade, Jeffrey wrote: From: Schade, Jeffrey Subject: [DB2-L] DB2 Connect Version 9 and DB2 for Z/OS Version 8 To: DB2-L@www.idugdb2-l.org Date: Monday, June 30, 2008, 9:55 AM























We are running DB2 Z/OS Version 8 in NFM and we would like to install DB2 Connect Version 9 on all our servers now to be ready for the V9 upgrade on the mainframe. Is anyone running DB2 Connect Version 9 on servers connecting to DB2 Z/OS V8 on the mainframe? Is this configuration supported? [...] 3335 223 29_Re: DB2 Cloning Tool for z/OS12_Myron Miller22_myronwmiller@YAHOO.COM31_Mon, 30 Jun 2008 09:01:16 -0700412_iso-8859-1 It's about 300-400meg for each environment. We do automatic OBID, DBID lookups as part of the process. So we always have the correct OBID/DBID translation.

Myron

--- On Mon, 6/30/08, Jorg Lueke wrote: From: Jorg Lueke Subject: Re: [DB2-L] DB2 Cloning Tool for z/OS To: DB2-L@www.idugdb2-l.org Date: Monday, June 30, 2008, 9:25 AM [...] 3559 23 26_Indexes and psuedo deletes15_Steve Schuering31_steven.schuering@EXELONCORP.COM31_Mon, 30 Jun 2008 16:50:08 +0000372_utf-8 We are currently run DB2 v7. We are in the process of setting up jobs that will automatically reorg Tablespaces and Indexes. We are intending to exclude tables that are transactional, ie. - loaded during the day, emptied at night (or throughout the day) - with individual deletes.

How do the psuedo-deletes in the indexes get cleaned up without a reorg? [...] 3583 152 52_Re: DB2 Connect Version 9 and DB2 for Z/OS Version 810_Mark Stone17_mastone@GMAIL.COM31_Mon, 30 Jun 2008 10:49:50 -0700566_ISO-8859-1 I've been using DB2 Connect Personal v9 for a while now, connecting to a v8 backend. But be ready for a bunch of Control Center changes that will drive you nuts. The DB2 UI team really hosed up a number of things, including the fact that you now have to logon, over and over again when starting query windows, connecting to DB2 instances, etc. My systems guy, was really upset by the way the instances are now seperated into nodes and not collectively grouped under a specific server. Oh and another of my favorites, the buffer for each query window [...] 3736 35 36_DBM1 TCB Time - solution implemented14_Lisa Ouellette27_Lisa.Ouellette@WACHOVIA.COM31_Mon, 30 Jun 2008 18:16:13 +0000455_utf-8 Just sharing. The application creating the indexes on the DGTT in my previous post implemented a change to only create the index if more than x number of rows and accounts were inserted into the DGTT. This has really reduced the number of index creations and my DBM1 TCB time. I am attaching stats from a sample 'before' and 'after' day for the curious. CPU time accounted to the application has gone down too - with no response time problems. [...] 3772 109 52_Re: DB2 Connect Version 9 and DB2 for Z/OS Version 815_Schade, Jeffrey15_JSchade@ISO.COM31_Mon, 30 Jun 2008 14:53:48 -0400553_iso-8859-1 Thanks Myron. I appreciate the feedback.

Jeff _________________________________________ Jeffrey Schade Systems Consultant, Technology Engineering

ISO 545 Washington Boulevard Jersey City, NJ 07310 Voice: (201) 469-3738 FAX: (201) 748-1500 jschade@iso.com



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Myron Miller Sent: Monday, June 30, 2008 12:00 PM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] DB2 Connect Version 9 and DB2 for Z/OS Version 8 [...] 3882 72 40_Re: DBM1 TCB Time - solution implemented15_Joel Responsive26_joel@RESPONSIVESYSTEMS.COM31_Mon, 30 Jun 2008 18:16:06 -0400639_UTF-8 Hi Lisa,

We don't get attachments on the list.

Is there any other easy way for you share the data?

Thanks, Joel





Joel Goldstein Responsive Systems Buffer Pool Tool for DB2, the worldwide industry standard Performance software that works...... Predicts Group Buffer Pool performance too! www.responsivesystems.com tel. (732) 972-1261 fax.(732) 972-9416 ----- Original Message ----- From: "Lisa Ouellette" Newsgroups: bit.listserv.db2-l To: Sent: Monday, June 30, 2008 2:16 PM Subject: [DB2-L] DBM1 TCB Time - solution implemented [...] 3955 143 37_Can DB2 access CICS signed on userid?13_ARTHUR SANNEN32_ARTHUR.SANNEN@SYDNEYWATER.COM.AU30_Tue, 1 Jul 2008 09:24:55 +1000539_us-ascii Hi

When a DB2 call is made from our CICS system (CICS TS 3.2 on z/OS) DB2 sees the transaction Id as the 'user' information. In my triggers/stored procedures I would like to know who the 'real' user is that is logged on to CICS.

I had been hopeful that I could use the CLIENT_USERID that was introduced in DB2 V8 but that seems to be exclusively for 'off-host' systems. The other option I can think of is to set a system variable in the signon exit but my friendly sysprog seems uncertain how to go about that. [...] 4099 65 55_Job Posting- AUSTIN,TX DB2 Developer 12+ Month Contract12_Justin Bloom21_jbloom@TEKSYSTEMS.COM31_Mon, 30 Jun 2008 23:16:55 +0000528_utf-8 TEKsystems' client in Austin, TX has an immediate need for a DB2 Developer/DBA for a large migration from DB2 mainframe to DB2 open systems (AIX).

Description:

The Texas Driver License Reengineering (DLR) project will provide much needed updates to the current 30-year-old driver license system. The project’s focus is to improve efficiency of the issuance system and to strengthen homeland security by providing a more secure driver license and identification card. This project was started in 2004. [...]