1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l February 2010, week 1 2 384 27_Redbooks 2004-2010 and More10_DB2usa !!!19_db2usa3@HOTMAIL.COM30_Mon, 1 Feb 2010 04:33:46 -0500460_iso-8859-1

Hi DB2 user,

Here is a non-profit Blog about DB2 for z/OS (IBM mainframes): http://db2usa.blogspot.com

Last update on Monday, February 1st 2010



Here is a list of Redbooks and Redpapers about DB2 for z/OS published or updated between 2004 and 2010, available on IBM website:





Version 9 - DB2 9 for z/OS Technical Overview, SG24-7330-00 - DB2 9 for z/OS Performance Topics, SG24-7473-00 [...] 387 13 63_Tomas Vasko/IEA/EAGA/EAG/AT ist au=?ISO-8859-1?Q?=DFer_?= Haus.11_Tomas Vasko23_tomas.vasko@GENERALI.AT30_Mon, 1 Feb 2010 12:12:20 +0100221_ISO-8859-1

Ich bin ab 01.02.2010 außer Haus und ab 03.02.2010 wieder im Büro. I'm out of the office from 01.02.2010 and will be back on 03.02.2010.

Ich werde Ihre Nachricht nach meiner Rückkehr beantworten. 401 482 27_Re: Group Buffer Pools Size6_Leslie21_db2dba@BTINTERNET.COM30_Mon, 1 Feb 2010 11:51:25 -0000370_iso-8859-1 Hi Jose

it is important to size your GBPs so they reflect the workload (systems interest) in your system.

what is the point of making your GBPs big for the sake of it?

Remember this, all landscapes will be different based on business need, physical availability (available storage in the CF etc), and more importantly available $$$. [...] 884 933 27_Re: Group Buffer Pools Size12_Jose Antonio17_jamorcillo@CAM.ES30_Mon, 1 Feb 2010 13:45:41 +0100705_iso-8859-1 Thanks Leslie!





I'm agree with you, it's pointless making GBP bigger and bigger. We'll study our needs based on our bussiness.





It was just curiosity...





Thanks again!!





__________________________ José A Morcillo Valenciano Tfno.: +34 965 90 51 43 747-Producción Informática



__________________________









________________________________

De: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] En nombre de Leslie Enviado el: lunes, 01 de febrero de 2010 12:51 Para: DB2-L@WWW.IDUGDB2-L.ORG Asunto: Re: [DB2-L] Group Buffer Pools Size [...] 1818 39 83_Is there a standard way to determine which DB2 subsystem the program is talking to?15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM30_Mon, 1 Feb 2010 16:45:26 +0200164_us-ascii Assuming that a DB2 program calls my subroutine, is there a standard way to discover the name of the DB2 subsystem? Or must it be passed as a parm?

1858 70 87_Re: Is there a standard way to determine which DB2 subsystem the program is talking to?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Mon, 1 Feb 2010 10:00:14 -0500511_us-ascii SELECT CURRENT SERVER FROM SYSIBM.SYSDUMMY1 should work nicely. Note that the SERVER name is always unique but not always identical to the four-character subsystem name (it is defined at install time).

--Phil S.

-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Binyamin Dissen Sent: Monday, February 01, 2010 9:45 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Is there a standard way to determine which DB2 subsystem the program is talking to? [...] 1929 56 87_Re: Is there a standard way to determine which DB2 subsystem the program is talking to?15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM30_Mon, 1 Feb 2010 17:13:56 +0200694_us-ascii I saw that, but it does not allow me to determine the subsystem name. Also it can be blank.

On Mon, 1 Feb 2010 10:00:14 -0500 "Sevetson, Phil" wrote:

:>SELECT CURRENT SERVER FROM SYSIBM.SYSDUMMY1 should work nicely. Note that the SERVER name is always unique but not always identical to the four-character subsystem name (it is defined at install time). :> :>--Phil S. :> :>-----Original Message----- :>From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Binyamin Dissen :>Sent: Monday, February 01, 2010 9:45 AM :>To: DB2-L@WWW.IDUGDB2-L.ORG :>Subject: [DB2-L] Is there a standard way to determine which DB2 subsystem the program is [...] 1986 61 87_Re: Is there a standard way to determine which DB2 subsystem the program is talking to?10_Todd Burch17_toddburch@MAC.COM30_Mon, 1 Feb 2010 09:48:53 -0600692_US-ASCII Try loading DSNHDECP and get the SSID from there.

Todd



On Feb 1, 2010, at 9:13 AM, Binyamin Dissen wrote:

I saw that, but it does not allow me to determine the subsystem name. Also it can be blank.

On Mon, 1 Feb 2010 10:00:14 -0500 "Sevetson, Phil" wrote:

:>SELECT CURRENT SERVER FROM SYSIBM.SYSDUMMY1 should work nicely. Note that the SERVER name is always unique but not always identical to the four-character subsystem name (it is defined at install time). :> :>--Phil S. :> :>-----Original Message----- :>From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Binyamin Dissen :>Sent: Monday, February [...] 2048 113 87_Re: Is there a standard way to determine which DB2 subsystem the program is talking to?11_Mike Turner19_mike.turner@GMX.COM30_Mon, 1 Feb 2010 15:58:14 -0000785_iso-8859-1 Hi Binyamin

For V8 and later you can use session variables. For example, in COBOL:

DATA DIVISION. WORKING STORAGE SECTION. 01 WK-SSID. 49 WK-SSID-LEN PIC S9(4). 49 WK-SSID-DATA PIC X(10). . PROCEDURE DIVISION. . EXEC SQL SET :WK-SSID = GETVARIABLE('SYSIBM.SYSTEM_NAME') END-EXEC

Regards Mike Turner Email: mike.turner@gmx.com Tel: +44 (0)1565-873702 Web: www.michael-turner.ltd.uk Michael Turner Ltd. Registered in England & Wales No. 1433722. Registered Office: 131 King Street, Knutsford, Cheshire, WA16 6EJ. VAT No. GB 338 4159 44. ----- Original Message ----- From: "Binyamin Dissen" Newsgroups: bit.listserv.db2-l To: Sent: Monday, February 01, 2010 3:13 PM Subject: Re: [DB2-L] Is there [...] 2162 106 95_AW: [DB2-L] Is there a standard way to determine which DB2 subsystem the program is talking to?35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM30_Mon, 1 Feb 2010 17:11:32 +0100344_iso-8859-1 Hi

I am not sure, what you mean with subsystem name. ASAIK you can (must) specify the local subsystem name in the BSDS and that's, what you get, when you issue the CURRENT SERVER-statement. If you are in datasahring, there is also a special register called "current member".

Mit freundlichen Grüßen Walter Janißen [...] 2269 93 87_Re: Is there a standard way to determine which DB2 subsystem the program is talking to?13_Phil Grainger34_phil@GRAINGERDATABASESOLUTIONS.COM30_Mon, 1 Feb 2010 16:39:04 -0000436_us-ascii But that will only tell you the DEFAULT subsystem name, not necessarily the one currently connected to

Phil Grainger Grainger Database Solutions Ltd

-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Todd Burch Sent: 01 February 2010 15:49 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Is there a standard way to determine which DB2 subsystem the program is talking to? [...] 2363 57 44_DSNALI Interface consuming too much CPU time14_Bernd Oppolzer26_bernd.oppolzer@T-ONLINE.DE30_Mon, 1 Feb 2010 20:04:27 +0100360_ISO-8859-15 Hello DB2 list,

we observed the DB2 interface DSNALI consuming 5 percent CPU of a batch job involving MQ, IMS etc. (measured by Strobe).

Under similar circumstances the DB2 interface for IMS (called DFSLI000) had a CPU usage of 0,1 percent and below.

We are quite sure that the CPU is indeed used inside the DSNALI CSECT. [...] 2421 254 48_Re: DSNALI Interface consuming too much CPU time14_M. Khalid Khan24_Mohammad_Khan@BCBSIL.COM30_Mon, 1 Feb 2010 13:39:35 -0600291_us-ascii Do you get two phase commit between the resources involved (DB2, IMS, MQ) using DSNALI ? IIRC the answer is no in which case I'd be more concerned about data inegrity than about 4.9% extra cpu. Or this is some special case where you don't care about proper commits/rollbacks ? [...] 2676 200 77_Re: z/os db2 v8 to v9 conversion roadblock - what am I being so dense about ?15_Hagedorn, Linda24_Linda_Hagedorn@MEDCO.COM30_Mon, 1 Feb 2010 14:47:52 -0500451_us-ascii If this is still a problem,

Does your site have any search order intercept products? PDSMAN (as memory serves) can intercept calls to PDS's.

Does your started task JCL include a joblib or steplib? If not, can you add one pointing to the correct library and see if it comes up?

If the JCL is rolling up to linklist, is there a residual entry there? Can you supply the contents of the linklist entries? /d prog,lnklst [...] 2877 476 86_Re: z/os db2 v8 to v9 conversion roadblock - what am I being so dense about ? - SOLVED14_Bruce Lightsey25_Bruce.Lightsey@ITS.MS.GOV30_Mon, 1 Feb 2010 14:44:16 -0600529_US-ASCII It was, indeed, a case of the proper sdsnload not getting the maintenance applied. In this case, the lpar has a different catalog for the db2 datasets so, even though the sdsnload ( and all of the others ) exits - with the same name - it is cataloged to a different pack. Thus, my confusion - I verified all of the dataset names, etc but didn't compare the disk volume serials. We think that this was to allow a fix to be tested without affecting the other lpars a couple of years ago. Copied the members of all of [...] 3354 60 48_Re: DSNALI Interface consuming too much CPU time14_Bernd Oppolzer26_bernd.oppolzer@T-ONLINE.DE30_Mon, 1 Feb 2010 21:48:53 +0100562_ISO-8859-1 There are indeed plans to migrate to RRS interface. For the moment there is no problem, because this region is read-only. The DB update regions are IMS and DB2, without MQ.

In the meantime I found the reason for the high CPU consumption.

The interface DSNALI chases the CDE chain to find out, if the modules DSNACAB and DSNACAF are already loaded. This is done on every call to DSNHLI (that is, DSNALI). This may be ok, if there is one batch program and a very short CDE list. But our CDE list has thousands of modules. This is the [...] 3415 330 27_Ellison at it again DB2 LUW12_Phil Gunning19_pkgunning@GMAIL.COM30_Mon, 1 Feb 2010 17:08:44 -0500324_US-ASCII Though I'd share this with you. Could be Oracle is scared of what pureScale is doing and is going to do to them.





Oracle's Larry Ellison is at it again putting out a lot of trash on DB2 LUW. He was recently quoted as saying, "We blew the doors off of IBM. We crushed them." [Referring to [...] 3746 27 34_Mabel Blanco is out of the office.12_Mabel Blanco17_blanco@AR.IBM.COM30_Tue, 2 Feb 2010 04:05:13 -0300728_US-ASCII I will be out of the office starting 01/02/2010 and will not return until 15/02/2010.

I will respond to your message when I return. Por urgencias relacionadas con DB2 enviar mail a la casilla grupal. gracias.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions Journal Technical atricles from world famous authors in DB2's most prestigious, peer reviewed magazine now on-line! _____________________________________________________________________ [...] 3774 294 34_The Arcati Mainframe Yearbook 201017_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM30_Tue, 2 Feb 2010 11:41:09 -0000579_us-ascii Hope you will find this useful!







Thanks.



Aurora



Aurora Emanuela Dell'Anno CA Sr. Engineering Services Architect Tel: +44 (0)1753 577 733 Mobile: +44 (0)7768 235 339 Aurora.Dellanno@ca.com http://www.ca.com/



P please don't print this e-mail unless you really need to!









Dear Colleagues

The 2010 edition of the celebrated Arcati Mainframe Yearbook is now available to view or download (free of charge). It includes: [...] 4069 133 27_Is there anybody out there?17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM30_Tue, 2 Feb 2010 11:50:02 -0000721_iso-8859-1 I have not received any emails since last week and I am wondering if it's possible?



Thanks.



Aurora







Aurora Emanuela Dell'Anno CA Sr. Engineering Services Architect Tel: +44 (0)1753 577 733 Mobile: +44 (0)7768 235 339 Aurora.Dellanno@ca.com

http://www.ca.com/

<> P please don't print this e-mail unless you really need to!















_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________ [...] 4203 185 31_Re: Is there anybody out there?20_Cuneyt Goksu (Gmail)22_cuneyt.goksu@GMAIL.COM30_Tue, 2 Feb 2010 14:07:26 +0200436_US-ASCII There were some downtimes for DB2-L but the activity is carry on. If you're not receiving, most probably your firewall accepting DB2-L as spam. There were similar incidents.

Regards, Cuneyt

-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Dell'Anno, Aurora Sent: Tuesday, February 02, 2010 1:50 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Is there anybody out there? [...] 4389 284 46_AD: Webinars from Cogito and Helios & Matheson13_Phil Grainger34_phil@GRAINGERDATABASESOLUTIONS.COM30_Tue, 2 Feb 2010 12:30:06 -0000481_us-ascii



Just a quick reminder for this weeks webinars on the EZ-DB2 products from Cogito





On February 4th, starting at noon Eastern we have:





Reveal the 'Hidden' Impact of Dynamic SQL

See how EZ-Tracer/Cache reveal the 'hidden' SQL consuming the greatest DB2 resource. Understand SQL Consolidation and its unique ability to demystify Dynamic SQL workloads. Explain and Edit with EZ-DB2 to find cost savings. [...] 4674 73 35_[DB2 v8 ] Dynamic SQL locks with UR9_DB2DBAzOS21_bala.db2dba@GMAIL.COM30_Tue, 2 Feb 2010 20:05:31 +0530367_ISO-8859-1 Dear list,

We are having few dynamic SQLs accessing a view that is a join of 3 to 5 tables. These SQLs are coded "WITH UR" to avoid locks and let batch updates run w/o contention. But, what I noticed today was locks were still taken by these dynamic SQLs (we have caching ON). When I displayed tablespaces for locks, it shows NO locks however. [...] 4748 219 42_Re: DB2 v8 Identifying PTFs under each RSU9_DB2DBAzOS21_bala.db2dba@GMAIL.COM30_Tue, 2 Feb 2010 20:07:11 +0530727_ISO-8859-1 Hi Christian,

Thanks for the suggestion and sorry about the delay in response. I could see the DB2 APARs in the link below.





On Wed, Jan 13, 2010 at 5:09 PM, Christian Michel wrote:

> Yes, all DB2 PTFs are also listed in the following directory for the > available PUT and RSU levels: > ftp://service.boulder.ibm.com/s390/assigns > > Mit freundlichen Grüßen / Kind regards > Christian Michel > > *Christian Michel* E-mail: *cmichel@de.ibm.com* Phone *(49)-7031-16-4293* DB2 > for z/OS Utilities Development Information Management Development > Boeblingen, Germany > > *IBM Deutschland Research & Development GmbH* > Vorsitzender des Aufsichtsrats: Martin [...] 4968 193 48_Re: DSNALI Interface consuming too much CPU time14_M. Khalid Khan24_Mohammad_Khan@BCBSIL.COM30_Tue, 2 Feb 2010 09:06:32 -0600419_us-ascii I won't hold my breath for IBM providing a fix. They will probably catagorize it as Working As Designed. How about doing a static link rather than dynamic one and side stepping the problem ?

Khalid









Bernd Oppolzer Sent by: IDUG DB2-L 02/01/2010 03:22 PM Please respond to IDUG DB2-L [...] 5162 193 39_Re: [DB2 v8 ] Dynamic SQL locks with UR11_Mike Turner19_mike.turner@GMX.COM30_Tue, 2 Feb 2010 15:08:19 -0000484_iso-8859-1 The S mode locks you are seeing may be Mass Delete locks. Isolation UR always takes a Mass Delete S-lock on the tablespace to prevent another task doing a mass delete. I used to think this was only for Segmented tablespaces, but the recent locking Redbook (SG24-4725) seems to imply that it happens for all tablespace types. I can see that might be true for the new UTS in V9, but I am not yet convinced it is true for the old Simple and Partitioned tablespace types. [...] 5356 54 48_Re: DSNALI Interface consuming too much CPU time14_Bernd Oppolzer26_bernd.oppolzer@T-ONLINE.DE30_Tue, 2 Feb 2010 16:48:12 +0100411_ISO-8859-1 yes, but this is done inside DSNALI, and to fix it, I would have to change DSNALI, and I don't (yet) believe that management will allow me to do so.

In fact, once changed, DSNALI should not be subject of future changes during new DB2 releases, because it is supposed to be linked to every batch program, and normally batch programs are not required to be relinked on DB2 release changes. [...] 5411 65 4_TEST15_Gaston, Raymond17_GastonRay@ORU.COM30_Tue, 2 Feb 2010 16:20:40 -0500634_us-ascii



TEST

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions Journal Technical atricles from world famous authors in DB2's most prestigious, peer reviewed magazine now on-line! _____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L 5477 105 39_Re: [DB2 v8 ] Dynamic SQL locks with UR10_Dave Nance16_dav1mo@YAHOO.COM30_Tue, 2 Feb 2010 15:15:58 -0800553_iso-8859-1 There is no way to run an SQL statement with "no locks". ISO 'WITH UR' allows you to take minimal locks of the data you are accessing. You do not actually state what kind of problem you are having though. Are the locks being taken keeping your batch cycle from completing properly? If that is the case, what are you attempting to do with your batch cycle? As long as you are not trying to take an exclusive lock on an object and you are committing frequently enough, you can 'normally' run batch, online and dynamic reporting all at the [...] 5583 347 15_Re: DB2 and SMS11_Neil Duffee18_nduffee@UOTTAWA.CA30_Tue, 2 Feb 2010 18:36:59 -0500399_us-ascii Ford : I'm a recent lurker to the list but haven't seen a response yet so thought I'd add my local experience. I'm with the Storage Admin group and not a DBA. We're a very small shop compared to others. (150 3390-3s for *all* sub-system table/index spaces)

There is a Redbook "Storage Management with DB2..." SG24-5462 (1999) but you might search for something more up-to-date. [...] 5931 231 39_Re: [DB2 v8 ] Dynamic SQL locks with UR9_DB2DBAzOS21_bala.db2dba@GMAIL.COM30_Wed, 3 Feb 2010 09:15:53 +0530582_ISO-8859-1 Hi Mike,

Yes, they are Mass Delete locks. DB2 use them for WITH UR queries. And, the lock type is "S". I'm going to look at SG24-4725 today.

Thanks for your response.

On Tue, Feb 2, 2010 at 8:38 PM, Mike Turner wrote:

> The S mode locks you are seeing may be Mass Delete locks. Isolation UR > always takes a Mass Delete S-lock on the tablespace to prevent another task > doing a mass delete. I used to think this was only for Segmented > tablespaces, but the recent locking Redbook (SG24-4725) seems to imply that > [...] 6163 208 39_Re: [DB2 v8 ] Dynamic SQL locks with UR9_DB2DBAzOS21_bala.db2dba@GMAIL.COM30_Wed, 3 Feb 2010 09:26:48 +0530582_ISO-8859-1 Hi David,

Yes, the batch programs make several hundred updates/deletes. The batch job fails due to active threads that read with ISO(UR). MQTs are our permanent way out to solve this problem. But, the distributed SQLs hit the views (joins on tables) which I thought would work on files and not against base tables. Batch programs take top priority so, there is no way I can tell legacy programs to change the way they were written to allow some distributed queries. (In our shop, there was lot of hassle in allowing distributed SQLs ! But, I told them we are [...] 6372 254 15_Re: DB2 and SMS10_Max Scarpa16_mscarpa@CESVE.IT30_Wed, 3 Feb 2010 09:21:34 +0100580_US-ASCII Hi Ford

It's a wide topic, so don't think this post is an answer. I put only some hints from the trenches where I lived for some years, wearing my helmet and some other protections for other parts of my miserable body.

1) Some papers:

- Disk storage access with DB2 for z/OS by Paolo Bruni and John Iczkovits, 2006 (Redbookspaper) - DB2 and Storage Management, a Guide to Surviving a Perfect Marriage by John Iczkovits various SHARE proceedings 2007,2008 (highly recommended). - I/O performance and DB2 for z/OS by Cristian Molaro, IDUG EU 2007 [...] 6627 34 15_Re: DB2 and SMS11_Ted MacNEIL18_eamacneil@YAHOO.CA30_Wed, 3 Feb 2010 08:38:07 +0000474_Windows-1252 >In all shops I worked we had 2 DB2 pools, one for TSs one for IXs, but it's not mandatory of course. I prefere 2 pools so during reorgs TSs and IXs do not interfere, you can manage datasets better etc.



I think you are suffering from an old-style belief. Putting index and table space in the same pool (if SMS-Managed: Storage Group), with today's DASD, does not cause interference, nor does it make a bit of difference as to managing DASD. [...] 6662 32 93_AUTO: Norbert Jenninger/Germany/IBM is out of the office at Feb.3 2010 (returning 02/04/2010)17_Norbert Jenninger14_JEN@DE.IBM.COM30_Wed, 3 Feb 2010 10:06:41 +0100308_US-ASCII I am out of the office until 02/04/2010.

I am out of office, travelling at Feb 3., 2010 and will be back in the office at Thursday Feb 4, 2010



Note: This is an automated response to your message "DB2-L Digest - 2 Feb 2010 to 3 Feb 2010 (#2010-28)" sent on 3/2/10 2:00:01. [...] 6695 32 20_DB2 Estimator V8.0.117_Mukesh Sanghrajka37_Mukesh.D.Sanghrajka@BANKOFAMERICA.COM30_Wed, 3 Feb 2010 10:43:22 +0000327_utf-8 Using Version 8 of DB2 on Z/OS. Created Spufi file with attributes of record lenght 4092,blocksize 4096, record format VB, max numeric field 33, max char field 300 and column heading of NAMES, which was downloaded on to my PC and when trying to use import table defintions See attached for details of error message. [...] 6728 22 24_Re: DB2 Estimator V8.0.117_Mukesh Sanghrajka37_Mukesh.D.Sanghrajka@BANKOFAMERICA.COM30_Wed, 3 Feb 2010 11:07:48 +0000633_utf-8 See attachement

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups, there is probably one near you! Regional User Groups are your local connection to the Worldwide DB2 User Community _____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L 6751 37 24_Re: DB2 Estimator V8.0.117_Mukesh Sanghrajka37_Mukesh.D.Sanghrajka@BANKOFAMERICA.COM30_Wed, 3 Feb 2010 12:03:48 +0000563_utf-8 Thanks Phil for your prompt reply. Using Version 8 of DB2 on Z/OS. Created Spufi file with attributes of record lenght 4092,blocksize 4096, record format VB, max numeric field 33, max char field 300 and column heading of NAMES, which was downloaded on to my PC and when trying to use import table defintions. On using Import source file via SPUFI, I get error message :- Unable to read record in SPUFI File while looking for SPUFI column headings. Record: 491 File: C:|DB2\estimator\IRP_PROD\est1.doc Error Code: 62 Error test: Input past end of ffile [...] 6789 334 15_Re: DB2 and SMS18_B. L. "Tink" Tysor16_Tink@BLTYSOR.COM30_Wed, 3 Feb 2010 08:43:57 -0500588_UTF-8 Hi Neil,

Great advice. I worked with the Storage Admin group to set up a similar approach some ten years ago and it was fantastic. Us DBAs spent zero time worrying about adequate storage or placement.

One thing that I would like to suggest is to separate index spaces from table spaces. We initially made a mistake by putting that separation in the DFSMS rules based on our naming standards. Then we brought in a purchased system which had different naming rules. We then decided to have two STOGROUPS, and the DBAs the could specify one STOGROUP for indexes and [...] 7124 182 47_Fw: [DB2-L] [DB2 v8 ] Dynamic SQL locks with UR10_Dave Nance16_dav1mo@YAHOO.COM30_Wed, 3 Feb 2010 06:00:06 -0800620_iso-8859-1 Bala, What issue are the S locks causing to your batch process? What are these batch processes doing that they do not allow an S lock on the table? David Nance ----- Forwarded Message ---- From: DB2DBAzOS To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Tue, February 2, 2010 10:56:48 PM Subject: Re: [DB2-L] [DB2 v8 ] Dynamic SQL locks with UR Hi David, Yes, the batch programs make several hundred updates/deletes. The batch job fails due to active threads that read with ISO(UR). MQTs are our permanent way out to solve this problem. But, the distributed SQLs hit the views (joins on tables) [...] 7307 347 39_Re: [DB2 v8 ] Dynamic SQL locks with UR11_Mike Turner19_mike.turner@GMX.COM30_Wed, 3 Feb 2010 14:19:25 -0000655_iso-8859-1 Just to be clear - the Mass Delete S-lock should not block normal update activity by other users. It only blocks a Mass Delete operation (SQL DELETE with no WHERE clause).

Regards Mike Turner Email: mike.turner@gmx.com Tel: +44 (0)1565-873702 Web: www.michael-turner.ltd.uk Michael Turner Ltd. Registered in England & Wales No. 1433722. Registered Office: 131 King Street, Knutsford, Cheshire, WA16 6EJ. VAT No. GB 338 4159 44. ----- Original Message ----- From: DB2DBAzOS Newsgroups: bit.listserv.db2-l To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Wednesday, February 03, 2010 3:45 AM Subject: Re: [DB2-L] [DB2 v8 ] Dynamic SQL locks with UR [...] 7655 356 47_AW: [DB2-L] [DB2 v8 ] Dynamic SQL locks with UR35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM30_Wed, 3 Feb 2010 15:55:43 +0100563_iso-8859-1 Hi Bala

The one tablespace, where you have special problems with, do it differ from others in LOCKRULE and LOCKMAX?

regards Walter

ITERGO Informationstechnologie GmbH Anwendungsentwicklung Laufzeitarchitektur Victoriaplatz 2 40477 Düsseldorf mailto:walter.janissen@itergo.com

Vorsitzender des Aufsichtsrates: Jürgen Vetter Geschäftsführung: Dr. Bettina Anders (Vorsitzende), Ina Kirchhof, Dr. Christian Nymphius, Dr. Michael Regauer, Wolfgang Schön. Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf, HRB 37996 [...] 8012 285 15_Re: DB2 and SMS10_Max Scarpa16_mscarpa@CESVE.IT30_Wed, 3 Feb 2010 16:38:11 +0100435_US-ASCII As past DASD manager I knew since many years that dataset placement with modern DASD is 'trasparent' to z/OS even if there are some situations where it still matters (see for instance J. Goldstein, various papers; Steve Thomas, IDUG 2009) . And I noticed in the past there were problems even in modern DASD (see Beretvas' papers), but with WLM options and PAV (or equivalent) you could avoid many problematic situations. [...] 8298 29 15_Re: DB2 and SMS11_Ted MacNEIL18_eamacneil@YAHOO.CA30_Wed, 3 Feb 2010 16:53:27 +0000441_Windows-1252 >Us DBAs spent zero time worrying about adequate storage or placement.

>One thing that I would like to suggest is to separate index spaces from table spaces

If you are spending zero time worrying about adequate storage or placement, why are you concerned about separate index/table spaces?

I've mentioned this before: modern DASD does not require this, especially with the newer/faster FICON channels. [...] 8328 25 15_Re: DB2 and SMS11_Ted MacNEIL18_eamacneil@YAHOO.CA30_Wed, 3 Feb 2010 17:00:18 +0000415_Windows-1252 >Using 2 storage pools limits 'space interference' , increase what I call 'maximum bearing capacity' for reorgs in a given system (considering space,CPU available, batch window, etc) ,you can use less free space per SG, it's a better long-term guarantee (it's a somewhat a implicit 'safety'),

I disagree. If you 'collapse' the storage groups without removing any DASD, it's the same thing. [...] 8354 230 29_Re: ADMIN listserv is working17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM30_Wed, 3 Feb 2010 17:53:30 -0000467_iso-8859-1 it's back! this email has just arrived followed by another 80+ and suddenly WOW I can stop harassing my IT guys! :-D





Thanks.



Aurora



Aurora Emanuela Dell'Anno CA Sr. Engineering Services Architect Tel: +44 (0)1753 577 733 Mobile: +44 (0)7768 235 339 Aurora.Dellanno@ca.com http://www.ca.com/



P please don't print this e-mail unless you really need to! [...] 8585 409 51_Re: AW: [DB2-L] [DB2 v8 ] Dynamic SQL locks with UR9_DB2DBAzOS21_bala.db2dba@GMAIL.COM30_Thu, 4 Feb 2010 12:45:25 +0530434_ISO-8859-1 Hi Walter, That is what I looked at immediately. They are all defined as LOCKRULE ANY and LOCKMAX SYSTEM. I even tried changing LOCKRULE to PAGE and ROW to see if the "S" locks (MASS DELETE) go away. The SQL runs against an join of 4 or 5 tables, one or two tables have "S" locks while the others just have "IS" locks. The "S" lock table is accessed via index and accessed as 3rd table in the join. It is partitioned. [...] 8995 362 39_Re: [DB2 v8 ] Dynamic SQL locks with UR9_DB2DBAzOS21_bala.db2dba@GMAIL.COM30_Thu, 4 Feb 2010 12:52:12 +0530618_ISO-8859-1 Hi Mike,

The victim here is trying to make an (qualified, just one row) UPDATE. Both the holder and the victim access the table via index.

thanks, Bala.

On Wed, Feb 3, 2010 at 7:49 PM, Mike Turner wrote:

> Just to be clear - the Mass Delete S-lock should not block normal update > activity by other users. It only blocks a Mass Delete operation (SQL DELETE > with no WHERE clause). > > Regards > Mike Turner > Email: mike.turner@gmx.com > Tel: +44 (0)1565-873702 > Web: www.michael-turner.ltd.uk > Michael Turner Ltd. Registered in England & Wales No. [...] 9358 302 51_Re: Fw: [DB2-L] [DB2 v8 ] Dynamic SQL locks with UR9_DB2DBAzOS21_bala.db2dba@GMAIL.COM30_Thu, 4 Feb 2010 12:53:56 +0530605_ISO-8859-1 Hi David,

batch program is trying to UPDATE while the distributed threads JUST read. With "S" locks on object, the Update fails because, the program can't acquire "U" or "X".

On Wed, Feb 3, 2010 at 7:30 PM, Dave Nance wrote:

> Bala, > What issue are the S locks causing to your batch process? What are these > batch processes doing that they do not allow an S lock on the table? > > David Nance > > > > ----- Forwarded Message ---- > *From:* DB2DBAzOS > *To:* DB2-L@WWW.IDUGDB2-L.ORG > *Sent:* Tue, February 2, 2010 10:56:48 [...] 9661 560 59_AW: [DB2-L] AW: [DB2-L] [DB2 v8 ] Dynamic SQL locks with UR35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM30_Thu, 4 Feb 2010 09:51:29 +0100449_iso-8859-1 Hi Bala

I still try to understand, why you conclude, that the S-lock is a mass-delete lock. My understanding is, and as Mike also mentioned, that a mass delete lock is a special lock, which does not compete with other intent locks on that table(space).

But if the S-lock is a gross lock on that tablespace, the only way I know how achieve that, is issuing the LOCK TABLE IN SHARE MODE statement. Have you checked that? [...] 10222 607 63_Re: AW: [DB2-L] AW: [DB2-L] [DB2 v8 ] Dynamic SQL locks with UR9_DB2DBAzOS21_bala.db2dba@GMAIL.COM30_Thu, 4 Feb 2010 15:59:19 +0530498_ISO-8859-1 Hi Walter,

The lock type was "Mass delete" and the lock state is "S" as I see on online monitoring.

Object Locked Type Duration St P/L Count --------------------------- -------- -------- --- --- ------ mmmmmm .xxxxxxxx MASS DEL COMMIT S L 1 nnnnnn .yyyyyyyy MASS DEL COMMIT S L 1

I'm unable to reproduce the contention successfully yet. May be, as you say, does "Mass Del" type of locks are special and they don't really lock resources for concurrent Updates ? [...] 10830 280 21_Lock and SCA duplexed12_Jose Antonio17_jamorcillo@CAM.ES30_Thu, 4 Feb 2010 12:37:12 +0100782_iso-8859-1 Hi everyone!





Is it worthy to have SCA and Lock structures duplexed under Data Sharing? We have it but we are thinking of changing it to simplexed

structures.





Thanks for your help!!!





__________________________ José A Morcillo Valenciano Tfno.: +34 965 90 51 43 747-Producción Informática



__________________________











Este correo electrónico es confidencial. Si lo ha recibido por error, por favor contacte con el remitente y destruya su contenido. Toda la información relativa a la Protección de Datos de Carácter Personal, se encuentra a su disposición en la página web www.cam.es , en el apartado Aviso legal [...] 11111 100 84_Reminder : Consolidation of IDUG groups on LinkedIn - IDUG Europe 2009 and subgroups10_Max Scarpa16_mscarpa@CESVE.IT30_Thu, 4 Feb 2010 14:43:15 +0100405_US-ASCII Esteemed listers

A quick note to remind some weeks ago IDUG started groups consolidation in LinkedIn with a main group "IDUG: The World Wide DB2 User Community ". Beneath this, there are now various subgroups and one, namely "IDUG Europe Conference ", will replace the old group IDUG Europe 2009 and all informations about IDUG European events will be posted in this brand new group. [...] 11212 339 25_Re: Lock and SCA duplexed16_Robert Catterall21_rfcatterall@GMAIL.COM30_Thu, 4 Feb 2010 10:24:49 -0500625_ISO-8859-1 Jose,

That depends in part on your parallel sysplex / data sharing configuration. Going to non-duplexed lock and SCA structures is probably a good idea if these structures are NOT in the same "box" as a DB2 subsystem that participates in the associated DB2 data sharing group. In that case, duplexing the structures imposes an overhead cost and delivers little in the way of availability benefits. If you are not duplexing the structures and you lose the CF LPAR holding the structures, they'll be automatically rebuilt quickly (if you have your structure failure management, or SFM, policy set up for [...] 11552 216 87_Re: Is there a standard way to determine which DB2 subsystem the program is talking to?11_Jerry Boehm22_gboehm@DOT.STATE.NY.US30_Thu, 4 Feb 2010 14:10:03 -0500408_US-ASCII In our shop, we implemented an ignorant man's approach (that is, for a person not skilled in the details of DB2). We created a single row table (called WHEREAMI) in each subsystem, accessible to the public. Anyone can select SSID from that table.

Now I must admit, I don't think anyone outside the database group uses it, and in fact maybe I'm the only one IN the group who uses it. ;-) [...] 11769 921 27_Re: Group Buffer Pools Size16_Robert Catterall21_rfcatterall@GMAIL.COM30_Thu, 4 Feb 2010 15:15:52 -0500585_windows-1252 Sorry about the delayed response, Jose -- I got behind on checking DB2-L posts.

If you have unallocated memory in your CF LPARs, and if structures other than your GBPs are already adequately sized, it's hard to see the harm in enlarging one or more GBPs. If you have a GBP for which you see a non-zero value for "write failures due to lack of storage" (you can get this value from a DB2 monitor statistics report or online display, or from the output of a -DISPLAY GROUPBUFFERPOOL DETAIL command), you should definitely make the GBP bigger (write failures due [...] 12691 64 87_Re: Is there a standard way to determine which DB2 subsystem the program is talking to?17_Gugel, Rich - DOA24_rich.gugel@WISCONSIN.GOV30_Thu, 4 Feb 2010 14:18:16 -0600664_us-ascii Hello Binyamin You could call the procedure SYSPROC.ADMIN_INFO_SSID. It says it returns the name of the connected db2 system

Rich



_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________

http://www.IDUG.org membership is now free. Do you have people in your office who are not an IDUG member? Show them how to access the information and help train the next generation of DB2 Users! _____________________________________________________________________ [...] 12756 208 32_Control Center Keyboard Shortcut14_Chris Zampogna34_Chris.Zampogna@STERLINGSAVINGS.COM30_Thu, 4 Feb 2010 14:07:48 -0800644_us-ascii Hello, Listers,

I use Command Editor in the Control Center view quite a bit and would like to know if there is a keyboard shortcut for the "execute" function to give me another way to execute SQL statements.

Thanks in advance!



Best Regards,

Chris Zampogna, PMP(r) Program Manager, Enterprise Data Warehouse

Sterling Savings Bank 111 North Wall Street Spokane, WA 99201 Office (509) 625-3402 - VOF(6435) Mobile (509) 368-0686 Fax (509) 458-2391 chris.zampogna@sterlingsavings.com www.sterlingsavingsbank.com [...] 12965 211 36_Re: Control Center Keyboard Shortcut18_Russel Wheelwright19_razzel6@HOTMAIL.COM30_Thu, 4 Feb 2010 15:08:05 -0800505_Windows-1252

isn't it CTL ENTER?

Russel Wheelwright





Date: Thu, 4 Feb 2010 14:07:48 -0800 From: Chris.Zampogna@STERLINGSAVINGS.COM Subject: [DB2-L] Control Center Keyboard Shortcut To: DB2-L@WWW.IDUGDB2-L.ORG









Hello, Listers,

I use Command Editor in the Control Center view quite a bit and would like to know if there is a keyboard shortcut for the “execute” function to give me another way to execute SQL statements. [...] 13177 55 24_db2 fast data copy tools10_Zhang Ming16_db2sub@YAHOO.COM30_Thu, 4 Feb 2010 17:06:18 -0800426_us-ascii Dear db2 lister, we are a large data testing center,need copy data between different lpars under z/os 1.9 and db2 v8. we need to buy some tools to easy and enhance our db2 data copy process does anyone know any db2 tools which can be used to copy data fast 1. target db2 table sometimes need to be added(adding data to existing target table) 2. copy data from segment tablespace to partition tablespace. Thanks. [...] 13233 54 75_Friday survey: How many members are you using in your largest DB2 DS group?0_24_hhuang@DCCSH.ICBC.COM.CN30_Fri, 5 Feb 2010 11:08:06 +0800507_US-ASCII It's Friday. :) Here is the survey, How many members are you using in your largest DB2 Date Sharing group?

Welcome your reply. It would be very kind of you to give any details, such like type and volume of workload, performance, data sharing cost, etc.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________ [...] 13288 79 28_Re: db2 fast data copy tools30_=?ISO-8859-1?Q?Georg_Thom=E9?=18_georg.thome@IEE.LU30_Fri, 5 Feb 2010 09:24:03 +0100 13368 159 87_AW: [DB2-L] Friday survey: How many members are you using in your largest DB2 DS group?35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM30_Fri, 5 Feb 2010 09:53:31 +0100833_iso-8859-1 Hi

We are using 6-way datasharing in our production system

Mit freundlichen Grüßen Walter Janißen

ITERGO Informationstechnologie GmbH Anwendungsentwicklung Laufzeitarchitektur Victoriaplatz 2 40477 Düsseldorf mailto:walter.janissen@itergo.com

Vorsitzender des Aufsichtsrates: Jürgen Vetter Geschäftsführung: Dr. Bettina Anders (Vorsitzende), Ina Kirchhof, Dr. Christian Nymphius, Dr. Michael Regauer, Wolfgang Schön. Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf, HRB 37996





________________________________ Von: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] Im Auftrag von hhuang@DCCSH.ICBC.COM.CN Gesendet: Freitag, 5. Februar 2010 04:08 An: DB2-L@WWW.IDUGDB2-L.ORG Betreff: [DB2-L] Friday survey: How many members are you using in your largest DB2 DS group? [...] 13528 290 34_IMMEDWRITE YES Performance problem12_Jose Antonio17_jamorcillo@CAM.ES30_Fri, 5 Feb 2010 12:27:39 +0100469_iso-8859-1 Hi everyone!





We have set IMMEDWRITE to YES after experiencing "row not found" under Data Sharing. We are really not sure if this is going to imply a

performance problem in our installation. Have anyone experience any after setting it to YES?





Thanks a lot!









__________________________ José A Morcillo Valenciano Tfno.: +34 965 90 51 43 747-Producción Informática [...] 13819 462 38_Re: IMMEDWRITE YES Performance problem12_Isaac Yassin20_yassini@BEZEQINT.NET30_Fri, 5 Feb 2010 13:38:38 +0200522_utf-8 Hi





If you want a response time disaster – do it !!!





Isaac Yassin

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jose Antonio Sent: Friday, February 05, 2010 1:28 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] IMMEDWRITE YES Performance problem





Hi everyone!





We have set IMMEDWRITE to YES after experiencing “row not found†under Data Sharing. We are really not sure if this is going to imply a [...] 14282 379 38_Re: IMMEDWRITE YES Performance problem35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM30_Fri, 5 Feb 2010 09:32:33 -0500425_iso-8859-1 I suggest that you do a lot more research of the implications before doing this. If you have a heavy workload, you will not be happy.

Regards, Joel



Joel Goldstein Responsive Systems IBM Gold Consultant Buffer Pool Tool for DB2, the worldwide industry standard Performance software that works...... Predicts IO Rate !! Predicts Group Buffer Pool performance too www.responsivesystems.com [...] 14662 333 38_Re: IMMEDWRITE YES Performance problem13_Case, Missy J24_Missy.Case@FIRSTDATA.COM30_Fri, 5 Feb 2010 08:57:30 -0600545_utf-8 Beware! Immediate write YES can be VERY expensive! Especially in our data sharing prod group. We had no issues until prod, but the CPU cost was far too high to let it ride – we changed it back to NO!





Missy Case

First Data Corp GTO

402-777-0081













From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Isaac Yassin Sent: Friday, February 05, 2010 5:39 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] IMMEDWRITE YES Performance problem [...] 14996 425 28_Re: db2 fast data copy tools14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Fri, 5 Feb 2010 10:31:11 -0500413_iso-8859-1 George, in my shop cursor loads work really well for small tables, and really slow - much slower than unloading to a flatfile and loading to the target - for large tables.

________________________________ From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Georg Thomé Sent: Friday, February 05, 2010 3:24 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] db2 fast data copy tools [...] 15422 286 28_Re: db2 fast data copy tools14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Fri, 5 Feb 2010 10:37:20 -0500488_us-ascii Zhang, I have a couple of links for you, and you should talk to the CA, BMC, and IBM vendor reps for your company as well, about their fast unload/load tools. http://www.esaigroup.com/products/bcv5.htm http://www.mainstar.com/busissue/75d2005/



________________________________ From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Zhang Ming Sent: Thursday, February 04, 2010 8:06 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] db2 fast data copy tools [...] 15709 258 28_Re: db2 fast data copy tools12_Peter Suhner24_peter_suhner@HOTMAIL.COM30_Fri, 5 Feb 2010 16:44:10 +0100594_iso-8859-1

Zhang, Georg,

Federation and the respective terms (wrapper/server/user mappings/nicknames) are the DB2 LUW view. These types of objects do not exist for DB2 z/OS.

Nevertheless you can interconnect disparate DB2 z/OS subsystems via DDF (Distributed Data Facility), which is a separate Started Task and will make your DB2 accessible from outside via a TCP/IP listener. This will allow you to directly execute SQL on a remote LPAR and as far as you have specified your requirements, I would chime in with Georg and recommend load/insert from a remote cursor. [...] 15968 434 28_Re: db2 fast data copy tools12_Weaver, Rick19_Rick_Weaver@BMC.COM30_Fri, 5 Feb 2010 11:16:48 -0600293_us-ascii Zhang, going from Segmented to Partitioned in DB2 V8 is going to be harder than a volume or dataset level copy/restore process. You will have to have a Partitioning Key on the target site, and it may be that your current Segmented source does not have a handy key to drive that. [...] 16403 267 79_Re: Friday survey: How many members are you using in your largest DB2 DS group?13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM30_Fri, 5 Feb 2010 09:27:37 -0800504_us-ascii We run 2-way data sharing, and I keep a spare member for rolling in maintenance. We're a pretty small shop, and only implemented data sharing for near-24x7 availability. All of our LPAR's plus the coupling facility run on a single CEC.

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of hhuang@DCCSH.ICBC.COM.CN Sent: Thursday, February 04, 2010 7:08 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Friday survey: How many members are you using in your largest DB2 DS group? [...] 16671 47 53_Revocation of PUBLIC - how to predetermine the damage5_Larry34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM30_Fri, 5 Feb 2010 18:19:51 +0000530_utf-8 I figure that someone has already prepared a query like the one I want, so, I am hoping not to have to reinvent the wheel.

I am about to revoke PUBLIC access from a table (actually, a view). I will be checking out my dynamic SQL users by way of auditing the table. However, I would like to find out which packages will be invalidated before I run the REVOKE. (Of course, I could always run the revoke and find out which packages were invalidated, but I think it would be better to do my homework ahead of time). [...] 16719 590 28_Re: db2 fast data copy tools14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Fri, 5 Feb 2010 14:05:52 -0500471_us-ascii Rick, my take on what Zhang was talking about was that the subject was moving data quickly between subsystems. You might want to point his salesrep towards a demo of BMC UNLOAD PLUS for DB2 and BMC LOADPLUS for DB2.

--Phil

________________________________ From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Weaver, Rick Sent: Friday, February 05, 2010 12:17 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] db2 fast data copy tools [...] 17310 636 28_Re: db2 fast data copy tools12_Weaver, Rick19_Rick_Weaver@BMC.COM30_Fri, 5 Feb 2010 13:27:35 -0600329_us-ascii What a wonderful idea!

Zhang, where are you located and I'll get someone to contact you off list. You can email me at rick_weaver@bmc.com.

For the CA and IBM folks on the list, no money changed hands between me and Phil. But I hope he makes it to IDUG or IOD this year ;-) [...] 17947 847 28_Re: db2 fast data copy tools14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Fri, 5 Feb 2010 15:06:58 -0500426_us-ascii If the IBM and CA folks aren't following up on this - I recommended that Zhang get in touch with them - then that would be their failure :-)

However, Rick, I won't be at IDUG or IOD - I'm an hourly paid consultant for a government entity and such are notoriously reluctant to pay for "consultants" to go on "junkets" - I'd have to lose a week of billable time and pay my own way. Raise a glass for me :-) [...] 18795 230 68_[AD] DB2 Connect CF602 March 8th - Remote or In Classroom - It's ON!7_Kim May28_kim.may@THEFILLMOREGROUP.COM30_Fri, 5 Feb 2010 16:15:18 -0500611_US-ASCII I posted a message about a month ago about upcoming classes at The Fillmore Group, one of which is the DB2 Connect class, CF602, scheduled to start on March 8, 2010.





This class is definitely going to run, and we have been approved to deliver it via distance learning to students unable to attend in-classroom. For anyone with training budget, but no travel budget, if you are in need of DB2 Connect training, I hope you will join us. All students attending will access the IBM Labs via remote connection, everyone will use IBM authorized curriculum, and everyone will "see" [...] 19026 26 36_New Blog Post on APARS for V8 and V911_Dave Beulke19_dave@DAVEBEULKE.COM30_Fri, 5 Feb 2010 21:17:49 +0000464_utf-8 Some of the new tablespace partitioning choices and features in DB2 Version 8 and now DB2 Version 9 for z/OS that I talked about last week are getting extra enhancements. ....Read more on my blog: http://davebeulke.com/

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________ [...] 19053 337 62_Re: Question about a error from db2 9.5 and PeopleSoft 8.9 LUW16_Robert Catterall21_rfcatterall@GMAIL.COM30_Fri, 5 Feb 2010 17:22:04 -0500597_windows-1252 Apologies for the late response.

Could this possibly have something to do with the fact that DB2 9.5 doesn't support the TRUNCATE TABLE statement (DB2 9.7 does support that statement)?

I realize that this may be a long shot, because you state that you are receiving the error after having migrated to DB2 9.5, and this implies that you were not getting the error prior to that DB2 migration. If PeopleSoft was issuing a TRUNCATE TABLE statement previously, and that was not generating an error, I'm at a loss as to how that could be explained. How could a TRUNCATE [...] 19391 108 57_Re: Revocation of PUBLIC - how to predetermine the damage17_Billy Sundarrajan21_billysundar@YAHOO.COM30_Fri, 5 Feb 2010 15:14:52 -0800330_us-ascii You can try this query and adjust it as needed. Also, once you identify the packages, if you GRANT appropriate access to the OWNER of the package, and then do a re-bind, packages will not get invalidated when you subsequently revoke the PUBLIC access.

Look out for access path changes...

Cheers Billy. [...] 19500 539 28_Re: db2 fast data copy tools16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM30_Fri, 5 Feb 2010 20:09:59 -0500305_UTF-8 Zhang - there are a couple of possible solutions from CA. Which one is the most suitable depends on the objects, what kind of outage and HW in place. Please feel free to contact me off the list and I can give you a call to discuss. I will be out of office the next week, but will respond asap. [...] 20040 304 28_Re: db2 fast data copy tools17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM30_Sat, 6 Feb 2010 16:39:36 -0000322_us-ascii Zhang Ming,

there are a number of vendors that offer Data copy and migration tools for the purposes that you mention and data warehousing - if you may be interested in hearing more about our tools (CA), please feel free to contact me offline, or call your local friendly CA Rep to come and visit you. [...] 20345 914 28_Re: db2 fast data copy tools17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM30_Sat, 6 Feb 2010 16:42:02 -0000467_us-ascii we certain ARE following this, guys, and I thank you for mentioning CA among the competitors in your first email :-)

I'll put a CA DB2 9 Catalog tables poster in the post for you if you want ;-)



Thanks.



Aurora



Aurora Emanuela Dell'Anno CA Sr. Engineering Services Architect Tel: +44 (0)1753 577 733 Mobile: +44 (0)7768 235 339 Aurora.Dellanno@ca.com http://www.ca.com/ [...] 21260 470 28_Re: db2 fast data copy tools7_Ed Long19_rdhm99a@PRODIGY.NET30_Sat, 6 Feb 2010 10:23:56 -0800652_utf-8 At our most recent New England DB2 User's group planning session, we tentatively settled on this very topic for our September Tools Fair. Given the combination of escalated testing demands, SOX, data warehousing and DR, data copy or data movement generally remains a potent cost and process challenge. Any vendors who have products that lower cost, improve the process, or generally make life easier for DBA's tasked with moving large amounts of data, who would like to reach most every DB2 shop in New England and beyond, please contact me at rdhm99a@prodigy.net More to come. Edward Long ________________________________ From: "Dell'Anno, [...] 21731 490 28_Re: db2 fast data copy tools8_Nagasuri20_r_nagasuri@YAHOO.COM30_Sat, 6 Feb 2010 12:26:16 -0800437_utf-8 Hello Aurora,

I had poster of DB2 UDB LUW 8.2 but unable to get the latest version. Is there a way that we can get the latest one (V9.7)?

Thank you, -Ram



--- On Sat, 2/6/10, Dell'Anno, Aurora wrote:

From: Dell'Anno, Aurora Subject: Re: [DB2-L] db2 fast data copy tools To: DB2-L@WWW.IDUGDB2-L.ORG Date: Saturday, February 6, 2010, 11:42 AM [...] 22222 249 62_Re: Question about a error from db2 9.5 and PeopleSoft 8.9 LUW9_Andy Hunt21_andy_hunt@YAHOO.CO.UK30_Sat, 6 Feb 2010 13:52:39 -0800608_utf-8 Im guessing that the PeopleSoft software is running a stored procedure/program to do a 'truncate table' process, rather than issuing a 9.7 type TRUNCATE TABLE statement explicitly. John says that it is doing an import /dev/null, which would be in the stored procedure/program. The SQL0437W is issued with a RC '1' . The manual has the following possible reasons for RC '1' "The join enumeration method was altered due to memory constraints". As John says, this doesn't make much sense for an IMPORT /dev/null. The manual then goes on to give possible resolutions for a RC'1', * Increase the size [...] 22472 41 39_Re: Single or cursor - which is better?15_Coleman, Troy L19_Troy.Coleman@CA.COM30_Sat, 6 Feb 2010 18:12:34 -0500329_UTF-8 Hi Sheldon, If you know you are going to always have 1 row returned then use SELECT INTO. If you are doing an existence check then you can use "FETCH FIRST 1 ROW ONLY" to avoid error checking. If you don't know what the result set is going to be. It could be one or more then use the declare/open/close cursor option. [...] 22514 41 47_Re: Which is better? "BETWEEN" vs "<=" and >"="15_Coleman, Troy L19_Troy.Coleman@CA.COM30_Sat, 6 Feb 2010 18:12:35 -0500377_UTF-8 My experience has shown that BETWEEN has a better filter factor and will influence DB2 to pick a better access path.

-Troy

-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sheldon Rich Sent: Thursday, January 14, 2010 7:41 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Which is better? "BETWEEN" vs "<=" and >"=" [...] 22556 55 57_Re: Revocation of PUBLIC - how to predetermine the damage14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Sun, 7 Feb 2010 19:26:48 +1100428_US-ASCII ROLLBACK is your friend.

1) Capture current authorities, *invalid* plans/packages, view names 2) REVOKE 3) Capture post-revoke authorities, *invalid* plans/packages, view names 4) ROLLBACK

Use (the ISPF utility) SUPERC to compare 1 and 3.

(I capture invalid plans and packages because there are fewer of them than valid ones.)

James Campbell

On 5 Feb 2010 at 18:19, Larry wrote: [...] 22612 60 49_Re: Finding DB2 objects in questionable status...0_22_DB2information@AOL.COM28_Sun, 7 Feb 2010 17:37:00 EST491_US-ASCII Take look at _www.recoverknowledge.com_ (http://www.recoverknowledge.com) and you will find a tool that will give you everything you ever wanted to know about questionable status. The ones that are mentions are all on one screen.

Ed.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * ** If you are going to attend only one conference this year, this is it! [...]