1 IDUGDB2-L.ORG /home/listserv/home/db2-l April 2010, week 2 2 46 50_Re: Adding an IDENTITY column to an existing table9_Tony Saul30_generalemaillists@YAHOO.COM.AU30_Wed, 7 Apr 2010 21:35:14 -0700562_iso-8859-1 The other option I have seen is to define a DateTime (timestamp with millisecs)  field WITH Default so that when a record is added it gets the current date and time. The catch is that you will need to generate the date in the existing records, but that can be achieved through an Define column, UNLOAD / LOAD or a one off program. The added advantage is that it can be used as an additional audit if necessary providing the exact date and time the record was created. I have seen it used at many sites and only in some older versions of DB2 have [...]43_744811.38165.qm@web34404.mail.mud.yahoo.com 49 64 33_Re: DB2 Workfile Space Management18_Juergen Ritterbach29_juergen.ritterbach@ITERGO.COM30_Thu, 8 Apr 2010 02:54:25 -0400664_UTF-8 Hi Jorg & Phil,

I've made simular experiences within our 6-way DSG.
Our workfile-setup for both sizes (4K/32K) for each
db2-member is:
2x 2GB/2GB (priqty/secqty) (=> Temp-DB functionality)
2x 2GB/0GB (priqty/secqty) (=> Work-DB functionality)

Currently the first two TS with secqty 2GB increased up to 32 datasets.
We are sure that we do not have a lot of DGTTs-usage.
So there must be some other processes within the dbms switching
to this "temp-db-datasets" and leading to this huge amount of space.
may be that single qmf-user-requests are one reason.
I didn't recreate the work-db up to now, cause I'm still [...]61_6689411365332209.WA.juergen.ritterbachitergo.com@www.idug.org 114 471 32_AW: [DB2-L] Separation of Duties12_PUSCH Othmar27_Othmar.Pusch@IT-AUSTRIA.COM30_Thu, 8 Apr 2010 09:14:57 +0200386_us-ascii Hi dear Renzo (RR) ! Just some solution's & idea's (1 til 4) ...

On Mainframe ya can run (1) CA's ENFDB2-TSSDB2-package or (2) CA's ENFDB2-ACFDB2_package or (3) IBM's RACFDB2-package ... and then you've this wanted security-option and much more security-possibilities (from my tech-point of view) as with the old db2-z/OS_internal-security in V10, V9, V8, V7 ... ! [...]63_81BB61A7ECD28B40BC5E4701B999860895729C52E6@A2XMXS1V1.A2X.LAN.AT 586 62 42_Re: Lack of DBA's harms the market for DB211_Dave Harvey17_db2dave@GMAIL.COM30_Thu, 8 Apr 2010 05:41:05 -04000_49_2107208425489566.WA.db2davegmail.com@www.idug.org 649 62 43_DB2 scheduler unable to generate passticket15_Yadigar Dirican18_ydirican@YAHOO.COM30_Thu, 8 Apr 2010 02:56:16 -0700440_iso-8859-1 Hi listers,

My DBA colleuage is trying to use DB2 scheduler.  But he received DSNA691I.
It seems to be related to security configuration.
But  I defined all of which was referenced in DSNTIJRA member.
The result did not change.
I suppose I missed something, but what is it?

Environment:
Operating system    :  z/os 1.9
DB subsystem         : DB2  V8.1
Security subsystem:  CA-TOPSECRET    [...]43_753384.67831.qm@web52105.mail.re2.yahoo.com 712 342 42_Re: Lack of DBA's harms the market for DB213_Crissy, Frank28_Frank_N_Crissy@HOMEDEPOT.COM30_Thu, 8 Apr 2010 07:24:04 -0500515_us-ascii If there are jobs out there for DB2 UDB DBA's where are they? All I see is Oracle and SQLServer DBA openings. If the companies who are UDB are discouraged I believe there are lots of UDB trained DBA's equally discouraged. We opened a UDB DBA position and have been flooded with interested applicants. Whoever these discouraged companies are they need to tell their HR people to advertise where they can be found by the thousands of unemployed and under employed DB2 DBA's that are seeking a position. [...]73_8F09E4A93B2EAE4DBB31891A893D6BA908EA9DA890@025-NAMSG-04.025d.mgd.msft.net 1055 84 50_Re: Adding an IDENTITY column to an existing table14_Lyon, Lockwood20_Lockwood.Lyon@53.COM30_Thu, 8 Apr 2010 08:29:11 -0400465_utf-8 George,

As others have already noted, your need is a bit ... puzzling.

1. If you are requiring this table (the "existing, populated") one to be the CHILD TABLE of a one-to-n relationship, then to use DBMS-enforced Referential Integrity you must add to the table a FOREIGN KEY column having the attributes of the PRIMARY KEY of the PARENT TABLE. Then, you must populate rows of the child table with the "matching" values of the parent rows. [...]72_4C9F8982DB3D124695B6B4621DA3700C2B2276@SCCINDCE2K301-B.dm0001.info53.com 1140 87 42_Re: Lack of DBA's harms the market for DB212_Myron Miller22_myronwmiller@YAHOO.COM30_Thu, 8 Apr 2010 05:57:16 -0700311_us-ascii In my own opinion from a mainframe point of view, Data Studio is not an advancement over prior tools, such as Visual explain, Optimum Service Center, etc. I'm still having issues with it not working for a number of cases when I try to tune various queries, etc. that the prior tools work fine on. [...]44_574673.54973.qm@web112119.mail.gq1.yahoo.com 1228 164 42_Re: Lack of DBA's harms the market for DB210_Max Scarpa16_mscarpa@CESVE.IT30_Thu, 8 Apr 2010 15:18:58 +0200616_US-ASCII Hi All

Curious, during last IDUG in Rome I received some indications that DB2 LUW
market was increasing but IBM didn't 'redirected/trained' enough resources
(people I mean) to AIX/DB2 platform, expecially
from z/OS side. I've been contacted at least 5 times for positions for
DB2 LUW. I had an interview as well, but I was considered (so I was told
many months after) 'too old' to learn UNIX/AIX :-((((.
I had a quick look in a previous company on AIX/DB2 systems and the only
problem I had was, obviously, my lack of knowledge of AIX/UNIX operating
system. For the rest [...]66_OFE244AE39.9C8CB382-ONC12576FF.00443436-C12576FF.0048C563@cesve.it 1393 31 33_Re: DB2 Workfile Space Management10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Thu, 8 Apr 2010 09:49:33 -0400573_UTF-8 Joel,

That's theoretically true. But I know that this process tablescans and merges two large tables using workfiles.
I also know that with the tablescan its reading every page once not rereading any pages.
Lastly, I know that since it went in each member has allocated 200GB of extra workfiles (that's from the storage report) .
I agree that our normal request of 20GB worth of DSNDB07 pages per hour doesn't mean the workfiles need to be 20GB, but I do know that this one new process is reponsible for all the bad things that are happening :-) [...]53_0755393249987261.WA.jorghluekebcbsmn.com@www.idug.org 1425 264 50_Re: Adding an IDENTITY column to an existing table11_Jerry Boehm22_gboehm@DOT.STATE.NY.US30_Thu, 8 Apr 2010 09:49:13 -0400329_US-ASCII Hi Lock,

This is off-topic, but your latest contribution to the list gives me a
good opportunity to follow up on a curiosity ...

I've always been curious about some bank names. Can you tell me
anything about how your company name came to be? What is it a "fifth"
of? What is it a "third" of? [...]28_sbbda6a7.008@dot.state.ny.us 1690 34 42_Re: Lack of DBA's harms the market for DB210_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Thu, 8 Apr 2010 10:09:27 -0400613_UTF-8 Ted,

There is no lack of talent in ofshoring anymore than there is in onshoring. There's very skilled people and not so skilled people, there's very industrious people and some rather lazy people. That's anywhere. What I've found different in working with offshore my whole career is that it's very difficult to retain skilled people in their positions. We used to train DBAs and most moved on after 2 years to better jobs or into management type positions. The same was true on the application side, really skilled people wanted to advance, become PMs, managers, leads etc. The opportunity for [...]53_1926022470631027.WA.jorghluekebcbsmn.com@www.idug.org 1725 29 42_Re: Lack of DBA's harms the market for DB212_Adam Baldwin22_adambaldwin@ES.IBM.COM30_Thu, 8 Apr 2010 10:35:37 -0400344_UTF-8 Re the onshore / offshore debate, it all depends on one's point of view. I certainly have encountered some of the best DB2 technicians in the world offshore - all those in the labs - Santa Teresa and elsewhere - for a start.

Just my 6 centimos / pennies / cents worth. DB2 is a global product and we're all onshore somewhere. [...]54_2821229220394349.WA.adambaldwines.ibm.com@www.idug.org 1755 74 42_Re: Lack of DBA's harms the market for DB212_Martin Hubel17_Martin@MHUBEL.COM30_Thu, 8 Apr 2010 10:57:19 -04000_43_DB2-L%201004081057291785.02DC@IDUGDB2-L.ORG 1830 250 50_Re: Adding an IDENTITY column to an existing table11_Jerry Boehm22_gboehm@DOT.STATE.NY.US30_Thu, 8 Apr 2010 11:07:33 -0400447_US-ASCII My apologies to the esteemed gathering. My previous submission was
intended as a private correspondence, but I "pulled the trigger" too
soon.

Jerry Boehm
NY State Dept of Transportation
50 Wolf Rd, POD 2-1
Albany, NY 12232
518-485-8628
PThink before you print.

>>> On 4/8/2010 at 8:29 AM, Lockwood.Lyon@53.COM wrote:
George,

As others have already noted, your need is a bit ... puzzling. [...]28_sbbdb8fa.059@dot.state.ny.us 2081 139 45_Re: z/OS DB2 V8 ZOS 1.11 USEZOSV1R9RULES(NO).11_Ron Johnson25_rjohnson@DATA-TRONICS.COM30_Thu, 8 Apr 2010 10:08:20 -0500328_US-ASCII Has anyone tried this change and measured the savings?

Roger, do you or anyone know what kind of percentage decrease we could
expect in DBM1 CPU usage? What is a 'large DB2 and high CPU site'?
We're trying to decide if this change is worth the risk of causing
problems in application and ISV code. [...]58_5119C2BD5B2AB54E8656D8766C8A18AB0C6AB252@DTEXCH1A.dtc.corp 2221 493 32_HOTDUG meeting on April 13, 20108_Lo, Mary17_Mary.Lo@TGSLC.ORG30_Thu, 8 Apr 2010 10:11:48 -0500401_us-ascii Please join us for our 2nd quarterly meeting on April 13, 2010 (Tuesday) at BMC. This meeting is focused on DB2 for z/OS; however, the presentation topics (DDF and SQL) are cross-platform as well. As always, attendance is free of charge. Please RSVP to mary.lo@tgslc.org. Hope to see you!

------------- -------------------- ----------------------------- [...]65_550D0016ABCA22488AD932ACA94AC56831B841D612@CORPEXCHMBOX.tgslc.org 2715 174 42_Re: Lack of DBA's harms the market for DB223_Jeffrey Benner, DB2 DBA22_consulting@EBENNER.COM30_Thu, 8 Apr 2010 08:08:31 -0700570_ISO-8859-1 No offense was intended. It is merely my experience that when I send things
to offshore, I do not expect senior level experience because it never seems
to be present in my personal interactions. Offshore resources seems very
often to be recently trained with almost no LUW DB2 experience. I have to
give very precise instructions and I have often felt that I am training them
in their position. I am referring to the typical employees of a company like
Cognizant or Cap Gemini, and can only refer to my own experience of the
matter. [...]62_y2ra19d988c1004080808gc9d0e631u75750ce3721a7813@mail.gmail.com 2890 444 42_Re: Lack of DBA's harms the market for DB223_Jeffrey Benner, DB2 DBA22_consulting@EBENNER.COM30_Thu, 8 Apr 2010 08:20:34 -0700606_windows-1252 I suppose my next question would be, are you in a dense urban industrial
market? And are the candidates all willing to relocate? The stories I
recently heard were in the western U.S. and the candidates they saw during
their search were barely junior level. Other candidates were unwilling to
relocate. My impression in northern California is that the area is so
dominated by Oracle that most DB2 DBA's have given up and moved elsewhere.
The companies that are in the area and use DB2 have a tough time finding
experienced people willing to sell their house and move. [...]62_y2ya19d988c1004080820qe27286a3w6cd8d8b4bd8c6dd8@mail.gmail.com 3335 53 41_How to verify table no longer being used?13_Donna Domovic28_Donna.Domovic@EXELONCORP.COM30_Thu, 8 Apr 2010 11:12:59 -0400491_UTF-8 Hello,

We have several application tables in our system that we think are no longer being used. We would like to drop them but, before we do that and before we stop them for a period of time, we need to confirm that this is in fact the case.

We know that we can check to see if any plans or packages are using the tables/tablespaces but we also want to confirm that they are not being used for queries, dynamic SQL, or anything outside of DB2 such as DSN1COPY, etc. [...]60_3316546322689484.WA.Donna.Domovicexeloncorp.com@www.idug.org 3389 113 42_Re: Lack of DBA's harms the market for DB223_Jeffrey Benner, DB2 DBA22_consulting@EBENNER.COM30_Thu, 8 Apr 2010 08:22:43 -0700642_ISO-8859-1 This seems a plausible explanation for why I never seem to be dealing with
knowledgeable people in offshore interactions.

I have heard the developers are better; it just seems that the admins fall
short.

On Thu, Apr 8, 2010 at 07:09, Jorg Lueke wrote:

> Ted,
>
> There is no lack of talent in ofshoring anymore than there is in onshoring.
> There's very skilled people and not so skilled people, there's very
> industrious people and some rather lazy people. That's anywhere. What I've
> found different in working with offshore my whole career is that it's [...]61_q2qa19d988c1004080822n1b5a922gb19825a350347727@mail.gmail.com 3503 229 49_[AD] DB2 Listdef and Template features automation13_Edward Benoit29_db2tech@RECOVERYKNOWLEDGE.COM30_Thu, 8 Apr 2010 08:44:19 -0700690_iso-8859-1 DB2 Listdef and Template features are now automated.   Listdef Manager forDB2automates the LISTDEF (Grouping of DB2 Objects) and TEMPLATE (Dynamic Allocation) features of DB2 z/Os.  The software product stores all listdef, template and group entries in DB2 tables for better security, management and automation.   The management of these entries (add, change, delete and view) are all ISPF Panel driven. The DB2 DBA and DB2 System organization use this process to automate the generation of DB2 utilities including the recovery process.    The Automation of Listdef feature includes: 1. Recover ·        Forward ·        TORBAusing Archive Log Quiesce command  RBA(Nice for [...]46_690380.61722.qm@web1202.biz.mail.gq1.yahoo.com 3733 22 32_How to monitor growth of DSNDB0720_Arthur Lee Robertson26_robertsona@FINANCE.NYC.GOV30_Thu, 8 Apr 2010 12:58:10 -0400557_UTF-8 Any ideas on how to monitor growth of DSNDB07? I would like to be proactive so that I do not run out of space at the wrong time.

_____________________________________________________________________

* 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! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________ [...]58_6545196234241361.WA.robertsonafinance.nyc.gov@www.idug.org 3756 253 33_Re: DB2 Workfile Space Management35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM30_Thu, 8 Apr 2010 13:04:47 -0400401_UTF-8 Jorg,

I'm not questioning the apparent reality that this new process is driving your sort workload bonkers.

However, you will usually find a lot of random access to your workfiles, on some systems almost 50% although around 20% seems to be average.

Prefetches only read the pages that are NOT in the pool already. An actual prefetch will read anywhere from 0-32 pages. [...]46_14491D2E57D24D8CBD278B271DE7FDE8@DellNotebook3 4010 211 67_Re: [FLUFF} Re: IBM DB2 Database Administration Certification - 73214_Barbara Koenen33_barbara.koenen.bgit@STATEFARM.COM30_Thu, 8 Apr 2010 10:08:02 -0700326_us-ascii First off, let me say that I did purchase the V8 book before I took the
V8 certification tests. I wasn't able to get a my hands on a V9 book
before I took those tests. I did much better on the V8 tests, due to
reviewing the book, so it was money well spent, even though I did also
pass the V9 tests. [...]67_9321A73F77470E4CB44903D606D207190D5A6DF1@WPSCV6MQ.OPR.STATEFARM.ORG 4222 107 45_Re: How to verify table no longer being used?10_Roger Hecq18_Roger.Hecq@UBS.COM30_Thu, 8 Apr 2010 13:11:36 -0400511_US-ASCII The real-time stats will tell you if there has been any insert, update,
or delete activity, from either dynamic or static SQL, on the
tablespace. If you only have 1 table per tablespace, this would tell
you if there is any "update" type activity, but it would not reflect
query utilization. You should be able to tell which dependant packages
are being executed from the SMF data. You would have to look at the SQL
in the dynamic statement cache to find dynamic select activity. [...]62_1A700EEF49343148A08879B1E3CA5BA6147F4498@NSTMC101PEX1.ubsw.net 4330 97 42_Re: Lack of DBA's harms the market for DB213_Ian Bjorhovde23_ian.bjorhovde@GMAIL.COM30_Thu, 8 Apr 2010 10:12:29 -0700429_ISO-8859-1 I think there are a few disconnects:

1) My experience has been that recruiters are absolutely terrible when it
comes to identifying skilled DB2 LUW resources. If a resume has "DB2" on it
a recruiter will pass it on, which is maddening to companies looking for a
DBA. How much time do managers waste throwing away bad resumes, or (worse)
interviewing people that don't *really* have LUW skills? [...]62_w2md59713de1004081012s346c64bfr6fbdf05c4e31438c@mail.gmail.com 4428 105 45_Re: How to verify table no longer being used?15_Mike Dransfield38_Michael.Dransfield@BARCLAYSCAPITAL.COM30_Thu, 8 Apr 2010 13:12:51 -0400279_us-ascii Hi, Donna,

When we're 99.9% sure that it's no longer in use, we either stop the tablespace or start it in utility only mode a week or more before the drop. If an app pops up that needs it, it's easy enough for the DBA on call to start it and avert a crisis. [...]76_1F3DCD8A1A1ADF4D99443C7A341695F6244EDE8F@NYKPCMMGMB07.INTRANET.BARCAPINT.COM 4534 92 45_Re: How to verify table no longer being used?0_33_armando.jorge.arranja@BANCOBPI.PT30_Thu, 8 Apr 2010 18:28:13 +0100334_us-ascii We use RUNSTATS HISTORY on a regular basis. We keep at HIST tables
almost one and a half year of data.

From time to time, we query the HIST tables for objects with no changes
during a certain period of time, we have a look at real-time statistics
and syscopy and then we ask developers/users about them. [...]69_12B88FB8BDDD354BB209A8DED6324373077B4AA5@SCCSEXM01.scentrais.gbpi.loc 4627 337 42_Re: Lack of DBA's harms the market for DB235_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM30_Thu, 8 Apr 2010 13:30:54 -0400534_iso-8859-1 Hi Max,

"For them is unthinkable to pay someone working on AIX/DB2 as they pay mainframers, they have to pay (by far) less as they think
there's no need of 'experts' for this platform. "

Back in the early to mid 80's, when DB2 was really starting to take off - there was a statement from IBM someplace, that production systems
probably would not require a full time DBA. Also, around 1986, the State of FL was developing a huge DB2 application that was going
to have 10,000,000 rows of data.... [...]46_DDD32467325C40FD9DFC30A64DF19409@DellNotebook3 4965 126 45_Re: How to verify table no longer being used?16_Lavoie, Frederic29_Frederic.Lavoie@CRA-ARC.GC.CA30_Thu, 8 Apr 2010 13:50:26 -0400340_iso-8859-1 Hello,

It is not exactly what you've requeted, but it might help.

In V9 a new column has been added to the sysibm.sysindexspacestats table. It shows the last date the index was used. I do not know exactly if the the column is updated right away or not or it is queued or not. This is something I hcve to find. [...]62_7A2589420A0D884C8EDE008CF8077E63E86027F2@SD01CFMV0001.PROD.NET 5092 32 42_Re: Lack of DBA's harms the market for DB211_Ted MacNEIL18_eamacneil@YAHOO.CA30_Thu, 8 Apr 2010 17:53:35 +0000396_- >No offense was intended. It is merely my experience that when I send things to offshore, I do not expect senior level experience because it never seems to be present in my personal interactions.

That agrees with my experience, and not just with IT.
One of Canada's cell phone company's help-desk is offshored, and so incompetent, that I only call them when absolutely required. [...]103_226303013-1270749210-cardhu_decombobulator_blackberry.rim.net-481589601-@bda026.bisx.prod.on.blackberry 5125 147 45_Re: How to verify table no longer being used?0_24_carol.sutfin@REGIONS.COM30_Thu, 8 Apr 2010 14:02:34 -0500534_US-ASCII Likewise here.

We stop the database for a time (usually a month), back the data and DDL up
before dropping it and then it goes away.

It is easy enough to start the database again if needed.

Carol Sutfin
Corporate DBA
Regions Financial Corp.
(205)261-5214
carol.sutfin@regions.com

From: Mike Dransfield

To: DB2-L@IDUGDB2-L.ORG

Date: 04/08/2010 01:53 PM

Subject: Re: [DB2-L] How to verify table no longer being used? [...]71_OF4F450FB1.99BBC146-ON862576FF.00686CAE-862576FF.00689B17@corp.rgbk.com 5273 612 42_Re: Lack of DBA's harms the market for DB220_Govan, Hal (RET-DAY)29_Harold.Govan@REEDELSEVIER.COM30_Thu, 8 Apr 2010 15:07:58 -0400805_us-ascii We have had similar experience with other off-shore companies Jeffrey.

Hal Govan
Senior Database Administrator
Reed Elsevier - Technology Services
harold.govan@reedelsevier.com
Phone: (937) 865-7820

________________________________

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jeffrey
Benner, DB2 DBA
Sent: Thursday, April 08, 2010 11:09 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Lack of DBA's harms the market for DB2

No offense was intended. It is merely my experience that when I send
things to offshore, I do not expect senior level experience because it
never seems to be present in my personal interactions. Offshore
resources seems very often to be recently trained [...]70_B2E52C321789B2499E54141B682F43781ACC13B6@LNGDAYEXCP01VA.legal.regn.net 5886 117 42_Re: Lack of DBA's harms the market for DB214_M. Khalid Khan24_Mohammad_Khan@BCBSIL.COM30_Thu, 8 Apr 2010 14:39:43 -0500616_us-ascii Recruiters can't identify anything, they just do pattern matching.
Depending on the market conditions and urgency the match can be very fuzzy
or too restrictive. I have been contacted for IDMS DBA jobs because I once
coded for IDMS in an application a LONG time ago and the string DBA occurs
in other places in my resume. I have been asked about "number of years I
have worked with JCL" after stating clearly that I have x years of
mainframe experience. I have come across recruiters insisting on
experience with specific vendor (monitoring or query tuning) tool for a
database [...]66_OF71F9AF73.F80A1785-ON862576FF.006A4082-862576FF.006C01AF@hcsc.net 6004 336 58_Re: [FLUFF] [DB2-L] Lack of DBA's harms the market for DB214_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Thu, 8 Apr 2010 15:52:50 -0400651_us-ascii ROFL at your DB-1

________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of M. Khalid Khan
Sent: Thursday, April 08, 2010 3:40 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Lack of DBA's harms the market for DB2

Recruiters can't identify anything, they just do pattern matching. Depending on the market conditions and urgency the match can be very fuzzy or too restrictive. I have been contacted for IDMS DBA jobs because I once coded for IDMS in an application a LONG time ago and the string DBA occurs in other places in my resume. I have been asked about "number of years [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC467D7@MAIL02.fisalan.nycnet 6341 326 58_Re: [FLUFF] [DB2-L] Lack of DBA's harms the market for DB214_Lyon, Lockwood20_Lockwood.Lyon@53.COM30_Thu, 8 Apr 2010 16:02:21 -0400451_us-ascii I've been asked about my "DB/2" experience. I reply "About 5 years ...
so tell me, how many OS/2 workstations are in use?" I always get a
blank stare.

-Lock Lyon

Fifth Third Bancorp

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sevetson,
Phil
Sent: Thursday, April 08, 2010 3:53 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] [FLUFF] [DB2-L] Lack of DBA's harms the market for
DB2 [...]72_4C9F8982DB3D124695B6B4621DA3700C2B2281@SCCINDCE2K301-B.dm0001.info53.com 6668 363 42_Re: Lack of DBA's harms the market for DB27_Kim May28_kim.may@THEFILLMOREGROUP.COM30_Thu, 8 Apr 2010 16:04:55 -0400634_us-ascii .and when IS that DB3 coming out?? J

Kim

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of M. Khalid Khan
Sent: Thursday, April 08, 2010 3:40 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Lack of DBA's harms the market for DB2

Recruiters can't identify anything, they just do pattern matching. Depending
on the market conditions and urgency the match can be very fuzzy or too
restrictive. I have been contacted for IDMS DBA jobs because I once coded
for IDMS in an application a LONG time ago and the string DBA occurs in
other places in my resume. I have been asked [...]41_4bbe36ef.9915f10a.100b.1300@mx.google.com 7032 86 42_Re: Lack of DBA's harms the market for DB215_Chris Hoelscher21_choelscher@HUMANA.COM30_Thu, 8 Apr 2010 16:08:55 -0400361_US-ASCII a problem my company has encountered is that many contractors (for
whatever reason) have a 1 year life span - even if they are technically
proficient, they have n concept of how WE work - some of them never grasps
our nuances - others do get it but then their 1 year time limit is up and
they must return to where=ever they came from. [...]68_OF3A3BCC7D.F3EADB4E-ON852576FF.006E5268-852576FF.006EAE1E@humana.com 7119 136 42_Re: Lack of DBA's harms the market for DB214_M. Khalid Khan24_Mohammad_Khan@BCBSIL.COM30_Thu, 8 Apr 2010 15:49:01 -0500510_iso-8859-1 IBM missed that chance, after DB2 9 it was perfectly logical to come out
with DB3 0 but they don't get it.

Khalid

PS : Just using my Friday privileges a day in advance. I'll keep quiet
tomorrow, I promise.

?and when IS that DB3 coming out?? J

Kim

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of M. Khalid Khan
Sent: Thursday, April 08, 2010 3:40 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Lack of DBA's harms the market for DB2 [...]66_OFFE696A9A.DD585F7C-ON862576FF.0071CF2A-862576FF.007259CE@hcsc.net 7256 31 33_Re: DB2 Workfile Space Management10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Thu, 8 Apr 2010 17:04:30 -0400583_UTF-8 Joel,

Ok not every getpage is a phyical read, true. I meant more that both tablespaces need to be read in full and that all the pages are being written to the workfiles. This I know from my explain which shows that the process expects two workfiles of 13million records with 13.2k record sizes. That matches the 275GB that were initially allocated. Unfortunately new workfile additions keep being allocated now, I am assuming because other work is using some of the existing tablespaces. So far we are at 1.5 TB and storage has capped the pool so this process will [...]53_5181837153353596.WA.jorghluekebcbsmn.com@www.idug.org 7288 469 58_Re: [FLUFF] [DB2-L] Lack of DBA's harms the market for DB219_Srikakolapu, Dinesh28_dinesh.srikakolapu@UCONN.EDU30_Thu, 8 Apr 2010 16:58:04 -0400455_us-ascii I may not quite qualify to say that recruiters talk weirdly, as I have a long way to go.

But the best I was asked has to be, "What version of DB2 you worked on, is it 2000 or 2005?"

Dinesh
UCONN

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Lyon, Lockwood
Sent: Thursday, April 08, 2010 4:02 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] [FLUFF] [DB2-L] Lack of DBA's harms the market for DB2 [...]71_01DE4625CCDFB349924BAE09DCD4512C2F129405CE@EXCHANGE4.grove.ad.uconn.edu 7758 393 42_Re: Lack of DBA's harms the market for DB212_Weaver, Rick19_Rick_Weaver@BMC.COM30_Thu, 8 Apr 2010 16:13:33 -0500520_us-ascii As a matter of fact, when DB2 9 'Viper' was being discussed several years ago, the XML construct created a 'hybrid' database (part Relational, part XML) and I heard it was kicked around at IBM to call the new hybrid database DB3.

Rick Weaver
DB2 z/OS Product Manager
BMC Software

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of M. Khalid Khan
Sent: Thursday, April 08, 2010 3:49 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Lack of DBA's harms the market for DB2 [...]69_B04A515BCAE7C34D90FEE204B055E3B24A43F506E3@PHXCCRPRD02.adprod.bmc.com 8152 530 45_Re: How to verify table no longer being used?9_Ford Wong14_fordie@SHAW.CA30_Thu, 8 Apr 2010 15:16:19 -0600314_us-ascii Hello,

Like everyone, I would probably make the tablespace unavailable for a time and see who screams?

Another way which is more work is to ALTER THE TABLE AUDIT ALL, turn on the AUDIT trace and then look at the AUDIT trace records to see if anyone has used it.

Hope this helps. [...]30_d076c82b1e5b7.4bbdf343@shaw.ca 8683 500 42_Re: Lack of DBA's harms the market for DB213_George Toolan19_gtoolan@COMCAST.NET30_Thu, 8 Apr 2010 17:41:01 -0400426_us-ascii Here is another true story from the mid 90's. An application manager told me
he just hired someone more advanced than the DB2 DBA's, he hired a DB4 DBA.
He had a programmer with Dbase4 on his resume.

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Kim May
Sent: Thursday, April 08, 2010 4:05 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Lack of DBA's harms the market for DB2 [...]35_01a301cad764$2f21dbd0$8d659370$@net 9184 197 42_Re: Lack of DBA's harms the market for DB215_Leon Katsnelson15_leon@CA.IBM.COM30_Thu, 8 Apr 2010 17:54:18 -0400568_UTF-8 That would not be accurate.

Leon Katsnelson
Program Director, IBM Data Servers

From: "Weaver, Rick"
To: DB2-L@IDUGDB2-L.ORG
Date: 2010/04/08 05:50 PM
Subject: Re: [DB2-L] Lack of DBA's harms the market for DB2
Sent by: IDUG DB2-L

As a matter of fact, when DB2 9 ‘Viper’ was being discussed several years
ago, the XML construct created a ‘hybrid’ database (part Relational, part
XML) and I heard it was kicked around at IBM to call the new hybrid
database DB3. [...]68_OFBFA4663D.C23B5CA5-ON852576FF.00783E09-852576FF.007853CA@ca.ibm.com 9382 57 21_It Can't Be That Easy7_Ed Long19_rdhm99a@PRODIGY.NET30_Thu, 8 Apr 2010 15:39:31 -0700358_us-ascii We are an ISV who gets most of our software from the AD/DLT team.

In that world, a single HLQ includes the DB2 libraries, HFS's, Catalog data sets, and ARCHIVE log data sets.

This approach has the advantage of simplicity; one catalog, one alias (sounds like the Texas Rangers).

It also means maintenance upgrades are ugly. [...]43_656898.72334.qm@web80202.mail.mud.yahoo.com 9440 100 20_IBM Unload and Limbo7_Ed Long19_rdhm99a@PRODIGY.NET30_Thu, 8 Apr 2010 15:59:49 -0700545_iso-8859-1 Begin Editorial:
I had to set up a job today to reorganize the DSN_STATEMENT_CACHE_TABLE.
 
Because this is Version 8, and this table has a LOB, I had to use Unload and Load.
 
There are 22000 rows in the table. Care to guess how long the IBM Unload took to unload the data...Well, I won't tell you yet but,
 
I did notice that it does a number of things per row that most of us would be fricassed for; like allocate, open, write, and close a data set. At 22,000 rows then we have 88,000 SVC's paired nicely [...]43_165879.61044.qm@web80204.mail.mud.yahoo.com 9541 471 42_Re: Lack of DBA's harms the market for DB213_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM30_Thu, 8 Apr 2010 16:16:59 -0700391_us-ascii Jeff, if your company chooses to retain young (cheap) talent versus experience, then yes, you will have the opportunity to train them. Back in the day, Arthur Andersen routinely sent out armies of bright-faced college graduates who then had to be trained on the job. I recall a spontaneous presentation I gave to a group of them when they asked me what "above the line" meant. [...]64_927FE8790B320742927BCF9ADF7AE48A18EF1361A4@PDXMAIL.pacificorp.us 10013 524 42_Re: Lack of DBA's harms the market for DB223_BOLEY Maurice C * Cliff32_Maurice.C.BOLEY@ODOT.STATE.OR.US30_Thu, 8 Apr 2010 16:33:49 -0700560_US-ASCII Cathy,
the value of experience like instructional knowledge does not have a
entry on a company's P&L (profits and loss) report so it has no value.
Pay does, as a liability. ergo. a employee is a liability and a chair
is an asset.

Now you know where we all stand ;-)

cliff:-)

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of
Taddei, Cathy
Sent: Thursday, April 08, 2010 4:17 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Lack of DBA's harms the market for DB2 [...]71_1885C0CA1657E04F827207AC4D66568F07D2099D@ex-salemrev-3.odot.state.or.us 10538 538 42_Re: Lack of DBA's harms the market for DB235_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM30_Thu, 8 Apr 2010 20:02:34 -0400518_iso-8859-1 I remember the Androids well..... I educated a lot of them, even on basics of JCL coding...

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

Buffer Pool Tool for DB2 on www.LinkedIn.com
Watch the 3-Minute Buffer Pool Tool Movie at: www.responsivesystems.com/Movie1 [...]46_6C64ED148ADA4D2A90A82300B446FC4E@DellNotebook3 11077 102 24_Re: IBM Unload and Limbo12_Myron Miller22_myronwmiller@YAHOO.COM30_Thu, 8 Apr 2010 17:05:25 -0700495_us-ascii Ed,
Welcome to the wonderful world of IBM LOB support. Isn't the performance wonderful? There is a fix that is available for V9 and should be retrofitted to V8 as well that eliminates all of the allocate/open/closes of the dataset at least. The rest of the lousy performance is still there ("working as designed according to IBM"). You wouldn't believe what it took to get them to get rid of the allocate, etc and how many times I heard it was working as designed and was fine. [...]44_176652.92441.qm@web112109.mail.gq1.yahoo.com 11180 628 42_Re: Lack of DBA's harms the market for DB235_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM30_Thu, 8 Apr 2010 20:21:44 -0400541_iso-8859-1 MessageCliff, it sounds like sitting on a chair is decreasing the value of company assets.

Well, it is almost Friday !!

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

Buffer Pool Tool for DB2 on www.LinkedIn.com
Watch the 3-Minute Buffer Pool Tool Movie at: www.responsivesystems.com/Movie1 [...]46_5F38FACD66D44932A422217372C73E4C@DellNotebook3 11809 81 33_Re: DB2 Workfile Space Management35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM30_Thu, 8 Apr 2010 20:31:31 -0400335_UTF-8 Jorg,

That makes a bit more sense, thanks.

You need a chargeback system, and a way to bill the user for job execution
costs.... that would stop it really fast.
When other users get nailed by the -904, give them the phone number of those
that run this killer job that uses up all the system resources. [...]46_0F8D8826D59543ACA174450E5A63C8C7@DellNotebook3 11891 355 58_Re: [FLUFF] [DB2-L] Lack of DBA's harms the market for DB216_Gregory Palgrave28_gpalgrave@STAFF.IINET.NET.AU30_Fri, 9 Apr 2010 10:48:05 +0800537_us-ascii A very long time ago, we were advertising for a Mainframe DB2 DBA - one applicant responded that he also knew DB3 and DB4....meaning dBASE II, dBASE III, dBASE IV...etc.
No, he didn't get the job.

Too many TLA's with the same abbreviation but different meanings.

Greg

(TLA - Three Letter Acronym)

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Kim May
Sent: Friday, 9 April 2010 4:05 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Lack of DBA's harms the market for DB2 [...]71_8522673947DF7D4394C962BFE441CD2759EBCE01@PER-EXCHMBX.win2k.iinet.net.au 12247 398 42_Re: Lack of DBA's harms the market for DB223_Jeffrey Benner, DB2 DBA22_consulting@EBENNER.COM30_Thu, 8 Apr 2010 19:57:13 -0700340_windows-1252 The most frequent misstep I have seen recruiters make in the past year is to
ask for a "SQL DBA". Of course they mean SQL Server. I get so sick of it. I
also frequently have to train recruiters on the difference between z/OS and
LUW DB2, and the further difference between single partition and data
warehouse. [...]62_q2ta19d988c1004081957xa04be5f1lc76c021099194164@mail.gmail.com 12646 23 25_Re: It Can't Be That Easy11_Steven Lamb24_steven.lamb@BARCLAYS.COM30_Fri, 9 Apr 2010 04:26:37 -0400625_UTF-8 RACF or equivalent product rules?

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________ [...]56_6658591272766056.WA.steven.lambbarclays.com@www.idug.org 12670 30 25_Re: It Can't Be That Easy13_Frans Pieters24_frans.pieters@ALLIANZ.NL30_Fri, 9 Apr 2010 05:37:07 -0400841_UTF-8 Hello Ed,
If you are running DB2 for z/OS V9 in NFM you could also create a scenario with CATMAINT UPDATE VCAT SWITCH and/or CATMAINT UPDATE SCHEMA SWITCH.
I used this as part of a subsystem clone scenario

best regards,
Frans Pieters

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________ [...]56_6619780907077675.WA.frans.pietersallianz.nl@www.idug.org 12701 64 89_[AD] Webinar - Index Optimization (was Index-controlled to Table-controlled partitioning)13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Fri, 9 Apr 2010 08:05:03 -0400607_utf-8 Looks like Dan knows more about my future than I do (spooky)

I just found out that I am standing in for one of my colleagues here at Cogito in delivering a webinar next week

It's on Tuesday at noon (Eastern), called "Workload Centric Index Optimization". The abstract says "Join Phil as he discusses the challenges of Index Design in support of your SQL workload, and the importance of capturing the SQL statistics that properly represent your business operations. Phil will also at SQL consolidation to ensure the workload is truly representative of SQL activity and is not just a [...]58_4440F5DA00E3F3459BBCB97431B91B6611B012A0@MAILR004.mail.lan 12766 207 45_Re: How to verify table no longer being used?13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Fri, 9 Apr 2010 08:08:36 -0400338_iso-8859-1 The problem is, of course, what is meant by "used"

I used to use hsm to migrate things that I felt were not being used, only to have them recalled by the next RUNSTATS job that ran :(

This is also the snag with using the high used RBA - do you regard RUNSTATS, COPY etc as "use" - probably not, but DB2 does [...]58_4440F5DA00E3F3459BBCB97431B91B6611B012A1@MAILR004.mail.lan 12974 43 42_Re: Lack of DBA's harms the market for DB210_Joe Geller21_joerg6666@HOTMAIL.COM30_Fri, 9 Apr 2010 08:49:15 -0400596_UTF-8 While there is certainly less experience overall among offshore developers and DBAs,
the big problem with offshoring (and outsourcing in general) is that you don't get
to choose who you are getting. I've found everywhere, that 10% are top-notch,
70% are so-so and 20% are absolutely terrible.

When I hire IT people I try to pick out those who are at least in the top 1/2
(depending on what is available and how many I need).
But in an outsourced project, the consulting firm supplies 10 or 20
of whoever they have. You get the garbage along with some quality. [...]53_6714793942205101.WA.joerg6666hotmail.com@www.idug.org 13018 243 42_Re: Lack of DBA's harms the market for DB210_Max Scarpa16_mscarpa@CESVE.IT30_Fri, 9 Apr 2010 15:15:35 +0200388_US-ASCII Hi Joel

Yes, absolutely true. But it's also true that having poor skilled people
*helps a lot*.
And I've in my mind a particular guy, 'The Antithesis of Good z/OS
performances' (The Evil TAGzOS from planet KAOS [= Knowing All Operating
Systems]) . After years he's still searching the perfect performance
policy.....if he only knew where to search it. [...]66_OF82FD9A64.E3EF4432-ONC1257700.0043C39C-C1257700.0048762B@cesve.it 13262 41 45_Re: How to verify table no longer being used?13_Donna Domovic28_Donna.Domovic@EXELONCORP.COM30_Fri, 9 Apr 2010 09:20:05 -0400311_UTF-8 Hello,

Thanks for everyone's input. We will definitely stop the tablespace for a period of time before we drop it to confirm it is not being used. We also think we've tracked down what was updated the referred date in ISPF 3.4 (it was a runstats job) and will remove the object from that job. [...]60_4076353580411133.WA.Donna.Domovicexeloncorp.com@www.idug.org 13304 118 45_Re: How to verify table no longer being used?10_Max Scarpa16_mscarpa@CESVE.IT30_Fri, 9 Apr 2010 15:31:42 +0200592_US-ASCII Stopping is a good idea but:

- STOP/START of TSs (maybe in RO)
- HMIG of underlying VSAM (if you've HSM) and check from time to time to
see if it's recalled via 3.4 (and recall date should be registered if I
remember well).

This prevents problems if your DBA/early warning man is on
holidays/ill/chatting with the gorgeous blonde of next office AND your CEO
is using THAT database....He'll wait a little ('Sorry boss our machine is
busy....') but your job is safe....without using SMF which usually is
processed 'async' with daily procedures. [...]66_OF0C6B995E.9C57E1C9-ONC1257700.0048FD58-C1257700.0049EFD4@cesve.it 13423 227 66_Redbook "Application Design for High Performance and Availability"13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Fri, 9 Apr 2010 09:30:56 -0400334_us-ascii Hi all,

I was reviewing this red book today, when I realised it's "getting on a bit" (aren't we all....) - it was written for V8 in late 2005

I looked around to see if there was one for DB2 9 (I thought I'd seen mention of one a few years ago) but didn't immediately find what I was looking for at ibm.com [...]58_4440F5DA00E3F3459BBCB97431B91B6611B012AE@MAILR004.mail.lan 13651 72 42_Re: Lack of DBA's harms the market for DB212_Martin Hubel17_Martin@MHUBEL.COM30_Fri, 9 Apr 2010 09:31:09 -04000_43_DB2-L%201004090931205806.0337@IDUGDB2-L.ORG 13724 285 24_Re: IBM Unload and Limbo10_Max Scarpa16_mscarpa@CESVE.IT30_Fri, 9 Apr 2010 15:39:49 +0200331_US-ASCII Hi Ed

Myron, may I join you in saying 'Welcome' to Ed ? I had the same problem
some years ago.

If you're using PDS-E there's a PTF (z/OS PTF) that should be applied.
Search archives. Anyway it was for V7 and z/OS 1.7. If you have BMC
Change Manager with Data Mover you can use it, it's faster. [...]66_OF97FE033F.1463D97E-ONC1257700.004A7E63-C1257700.004AADDE@cesve.it 14010 61 45_Re: How to verify table no longer being used?13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Fri, 9 Apr 2010 09:35:49 -0400492_utf-8 You could use IFCID 107 (smf 102, subtype 107) to track DB2 opens and closes

But you would have to start a DB2 trace to build a history - you couldn't go back retrospectively and look for them

Phil Grainger
Cogito Ltd.
phil.grainger@cogito.co.uk
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk

Attend IDUG 2010 - Europe, the premiere event for DB2 professionals.
8-12 November 2010, Vienna
Learn more at http://www.idug.org [...]58_4440F5DA00E3F3459BBCB97431B91B6611B012B0@MAILR004.mail.lan 14072 439 45_Re: How to verify table no longer being used?13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Fri, 9 Apr 2010 09:40:13 -0400568_us-ascii BUT starting RO will not alert you to anyone who is "only" reading the dataset - until you drop the object!

As a final step before the actual DROP you could always rename the table - that'll catch any access you missed AND gives you a quick recovery path

((ALERT - Friday Story Approaching))
Years ago when the company I was at implemented SMS and HSM for the first time, our storage admins had an ACS routine that said "any dataset not used for 15 months gets deleted". Sounded just dandy. EXCEPT, what we didn't know is that (for some [...]58_4440F5DA00E3F3459BBCB97431B91B6611B012B2@MAILR004.mail.lan 14512 26 33_Re: DB2 Workfile Space Management10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Fri, 9 Apr 2010 10:52:16 -0400717_UTF-8 Joel,

A chargeback system would be ideal for several classes of users we have. Unfortunately it's not going to happen.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________ [...]53_8835295549119972.WA.jorghluekebcbsmn.com@www.idug.org 14539 143 42_Re: Lack of DBA's harms the market for DB212_Phil Gunning22_pgunning@GUNNINGTS.COM30_Fri, 9 Apr 2010 15:12:28 +0000660_Windows-1252 Uh Sapiens, I remember it well.
Sent via BlackBerry by AT&T

-----Original Message-----
From: Martin Hubel
Date: Fri, 9 Apr 2010 09:31:09
To:
Subject: Re: [DB2-L] Lack of DBA's harms the market for DB2

DB1 did exist. It was an application generator/ development environment. It was renamed SAPIENS in 1988. It *might* be a legitimate request, but probably not. Ian, salaries/rates on LUW vary a lot. I've seen that too. I'm not sure if LUW is being compared to low rates on SQL Server, or they are just hoping. --Martin >> Recruiters can't identify anything, they just do [...]103_871133920-1270825949-cardhu_decombobulator_blackberry.rim.net-595137701-@bda628.bisx.prod.on.blackberry 14683 70 45_Re: How to verify table no longer being used?17_Gugel, Rich - DOA24_rich.gugel@WISCONSIN.GOV30_Fri, 9 Apr 2010 10:19:27 -0500501_us-ascii Have you looked at 42-6 records? These records report activity and performance statistics by a job to a dataset. If you have MXG they are easy to report on. Cheryl Watson has a nice article on them if you subscribe

Regards
Rich Gugel

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Donna Domovic
Sent: Friday, April 09, 2010 8:20 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] How to verify table no longer being used? [...]79_3A61DE20404B9D41A954E5380147DD28013D2F5B83FC@MEWMAD0PC02G02.accounts.wistate.us 14754 398 42_Re: Lack of DBA's harms the market for DB214_Brian Goldberg22_Brian.Goldberg@QVC.COM30_Fri, 9 Apr 2010 11:21:46 -0400756_us-ascii I thought DB1 was an Aston-Martin.

Thanks.

brian goldberg | applications developer iv, distribution applications |information technologies|studio park|484.701.1210 | brian.goldberg@qvc.com

This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient of this e-mail (even if the e-mail address above is yours), (i) you may not use, copy or retransmit it, (ii) please delete this message and (iii) please notify the sender immediately. Any disclosure, copying, or distribution of this message or the taking of any action based on it, is strictly prohibited.
From: [...]66_59DA3219313D3942BBBEBC461A0CA9020B6CD37109@VPWMX250.qvcdev.qvc.net 15153 333 70_Re: Redbook "Application Design for High Performance and Availability"13_Bell, Raymond20_Raymond_Bell@BMC.COM30_Fri, 9 Apr 2010 10:23:32 -0500454_us-ascii 'DB2 9 for z/OS Performance Topics' any good?

Raymond

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Phil Grainger
Sent: 09 April 2010 14:31
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] Redbook "Application Design for High Performance and Availability"

Hi all,

I was reviewing this red book today, when I realised it's "getting on a bit" (aren't we all....) - it was written for V8 in late 2005 [...]67_78B3EFE2C0C5D74E9E7777D1D669D5420A99EACA@PHXCCRPRD04.adprod.bmc.com 15487 53 45_Re: How to verify table no longer being used?19_Jardine, Lawrence J19_JardineLJ@AETNA.COM30_Fri, 9 Apr 2010 11:24:24 -0400649_us-ascii Instead of Stop, I prefer to START ACCESS(UT) so that my daily image copy jobs with listdefs do not fail.

Larry Jardine

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Donna Domovic
Sent: Friday, April 09, 2010 9:20 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] How to verify table no longer being used?

Hello,

Thanks for everyone's input. We will definitely stop the tablespace for a period of time before we drop it to confirm it is not being used. We also think we've tracked down what was updated the referred date in ISPF 3.4 (it was a runstats job) [...]70_C7DCA78FAF334147B2FD39A220A4C500019F075E25@HFDPMSGCMS02.aeth.aetna.com 15541 239 45_Re: How to verify table no longer being used?10_Max Scarpa16_mscarpa@CESVE.IT30_Fri, 9 Apr 2010 17:29:02 +0200397_UTF-8 Phil, I meant STOP/START (maybe in RO) as action BEFORE migration, sorry
if I wasn't clear, I'd have to number the steps.

Once, if you stopped/started a TS and no one accessed it VSAM open bit
remained OFF so you were able to migrate underlying VSAM. Any RO query
(or every action that needed to open VSAM) must RECALL TS (and IXs if
migrated as well and using them. [...]66_OFA09243C2.B4D33A65-ONC1257700.00529D55-C1257700.0054ADDF@cesve.it 15781 408 38_[AD:]Are you attending IDUG in Tampa??13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Fri, 9 Apr 2010 11:28:22 -0400381_us-ascii We know your time is precious at IDUG, and it's not always convenient to talk during the expo hours so ....

Please join Cogito for breakfast or lunch at IDUG in Tampa to learn more from EZ-DB2's key product architects.

If you're interested, let us know and we'll reach out to schedule a meeting. Just drop an eMail to Rosette Hapsis at rhapsis@hmna.com [...]58_4440F5DA00E3F3459BBCB97431B91B6611B012CA@MAILR004.mail.lan 16190 127 45_Re: How to verify table no longer being used?10_Max Scarpa16_mscarpa@CESVE.IT30_Fri, 9 Apr 2010 17:46:25 +0200431_US-ASCII We used SMF 42-6 for other purposes in a recent past (in association with
MXG) and it was a good option, but it generated a lot of SMF records
causing a frequent switch of SMF datasets and some problems with batch
procedures doing accounting (problem with B37 in SORT dataset and SAS
programs processing SMF records for WLC,accounting and so on: mainly
reports that goes directly to 'the Heavens' )) . [...]66_OF477BC81B.6F599114-ONC1257700.0055C221-C1257700.0056453F@cesve.it 16318 224 70_Re: Redbook "Application Design for High Performance and Availability"11_Suresh Sane21_data_arch@HOTMAIL.COM30_Fri, 9 Apr 2010 10:50:50 -0500427_Windows-1252 Phil,

I know there is a Performance Topics and a Technical Overview, but don't think there is one specifically for Application Design.

I think Redbooks are extremely valuable for disseminating DB2 knowledge and yet, the funding for them has been drastically reduced in the past few years. Today, I think there is only one Project Leader who can do perhaps 4 books a year (and he does IMS too!). [...]43_COL104-W37974EB3A8DF197D2C5A1A98150@phx.gbl 16543 74 36_Re: AW: [DB2-L] Separation of Duties12_Roger Miller19_millerrl@US.IBM.COM30_Fri, 9 Apr 2010 11:42:44 -0400413_UTF-8 One more option is to use the function in DB2 10 for z/OS that is similar, with SECADM and an option for DBADM without data access. This version is still in beta, but there is a webcast next week with a little on this topic.
http://www.ibm.com/software/os/systemz/webcast/13apr/index.html

Roger Miller, DB2 for z/OS

Hi dear Renzo (RR) ! Just some solution’s & idea’s (1 til 4) … [...]51_9881506912077284.WA.millerrlus.ibm.com@www.idug.org 16618 220 45_Re: How to verify table no longer being used?12_Myron Miller22_myronwmiller@YAHOO.COM30_Fri, 9 Apr 2010 08:56:45 -0700626_utf-8 Instead of RO, just STOP it. That will find anyone that needs access. ________________________________ From: Phil Grainger To: DB2-L@IDUGDB2-L.ORG Sent: Fri, April 9, 2010 9:40:13 AM Subject: Re: [DB2-L] How to verify table no longer being used? BUT starting RO will not alert you to anyone who is “only†reading the dataset – until you drop the object! As a final step before the actual DROP you could always rename the table – that’ll catch any access you missed AND gives you a quick recovery path ((ALERT – Friday Story Approaching)) Years ago when the company I was at [...]44_802996.73735.qm@web112118.mail.gq1.yahoo.com 16839 529 50_Re: [Fluff] Lack of DBA's harms the market for DB214_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Fri, 9 Apr 2010 12:44:01 -0400602_us-ascii Weren't you thinking of the DB5? The car with the incredible ejector seat, in, what, _Goldfinger_?

________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Brian Goldberg
Sent: Friday, April 09, 2010 11:22 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Lack of DBA's harms the market for DB2

I thought DB1 was an Aston-Martin.

Thanks.

brian goldberg | applications developer iv, distribution applications |information technologies|studio park|484.701.1210 | brian.goldberg@qvc.com [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC467DF@MAIL02.fisalan.nycnet 17369 31 57_DB2 for z/OS -Difference between OR vs IN on same column?17_Darren Kilpatrick31_darren.kilpatrick@WELLPOINT.COM30_Fri, 9 Apr 2010 13:22:51 -0400844_UTF-8 Is there a difference between using OR statements and IN statements when evaluating a column? This is for DB2 on z/OS Version 9 NFM. For example:

WHERE (CLM_TYP_CD = :WS1 OR CLM_TYP_CD = :WS2)

vs.

WHERE CLM_TYP_CD IN ( :WS1, :WS2 )

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________ [...]63_3507237443280430.WA.darren.kilpatrickwellpoint.com@www.idug.org 17401 310 45_Re: How to verify table no longer being used?10_Max Scarpa16_mscarpa@CESVE.IT30_Fri, 9 Apr 2010 19:28:18 +0200390_US-ASCII I really like DB2-L. It's a so Diversified Universe, where to achieve the
same goal you get so many different ways. And all useful. And I'm NOT
kidding.

Forgot: some years ago I heard about a solution based on automation tool
intercepting VSAM recall or DATASET open or something similar (don't
remember well), anyway based on action DB2 does on VSAM file. [...]66_OFC46262B4.F2699428-ONC1257700.005EE6E5-C1257700.005F98FF@cesve.it 17712 30 26_DB2 10 webinar on April 1312_Roger Miller19_millerrl@US.IBM.COM30_Fri, 9 Apr 2010 14:31:57 -0400383_UTF-8 DB2 10 for z/OS is in beta now, but we can provide a little information in a webcast. I hope you can sign up for this one. Dave Beulke and I will be going through the talk, and then answering questions. I'll be calling in from Yosemite.
If the timing is not convenient for you, you can use the replay.
http://www.ibm.com/software/os/systemz/webcast/13apr/index.html [...]51_2783780197731688.WA.millerrlus.ibm.com@www.idug.org 17743 404 42_Re: Lack of DBA's harms the market for DB212_Isaac Yassin20_yassini@BEZEQINT.NET30_Fri, 9 Apr 2010 22:18:09 +0300499_UTF-8 Hi,

Actually there is a DB called DB1 (OK – it's called Sapiens now but the original name was DB1)

It is Hierarchic, it has built-in dictionary, SP, triggers and more. Very easy to "paint" screens and has a way to connect to DB2 as well.

Isaac Yassin

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of M. Khalid Khan
Sent: Thursday, April 08, 2010 10:40 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Lack of DBA's harms the market for DB2 [...]35_016201cad819$6453dc80$2cfb9580$@net 18148 90 45_Re: How to verify table no longer being used?12_Kirk Hampton37_kirk.hampton@ENERGYFUTUREHOLDINGS.COM30_Fri, 9 Apr 2010 14:25:27 -0500503_us-ascii Donna,
As Ford recommended yesterday, when we want to find out if a DB2 table
is still being accessed by anyone or anything, we do an ALTER TABLE
xxx.yyy AUDIT ALL. And we have the Audit Trace turned on in ZPARMS:
AUDITST=(4,5,6). I'm not sure what SMF type this trace produces (101 or
102?). Then we have a daily DB2/PM report that runs against the previous
day's SMF data, and if there has been access by anything (RUNSTATS, SQL
Select, etc.) it will show up there. [...]71_31F1BA84DF370A4C825F6E64D59DAF5403D3465B@MDCTXUEXCL01N4.corptxu.txu.com 18239 93 15_database unload15_Frank Swarbrick30_frank.swarbrick@EFIRSTBANK.COM30_Fri, 9 Apr 2010 14:47:55 -0600878_us-ascii I have the following VSE JCL that runs a DB2/VSE utility ARIDBS (aka DBSU: Database Services Utility):

// JOB DBUNLOAD
// DLBL SBXCUSI,'SFBX.PROD.MSAM.SBXCUSI',,VSAM,CAT=CUSTCAT
// EXEC ARIDBS,SIZE=AUTO
READ MEMBER VSEUSER.$;
DATAUNLOAD
SELECT CIF_NUMBER
, BRANCH_NUMBER
, CAST(APPL_ID AS DECIMAL(7)) AS APPL_ID
, PMT_APPL_CODE
, CAST(PMT_APPL_ID AS DECIMAL(10)) AS PMT_APPL_ID
, PRIMARY_RELATIONSHIP AS PRIM_RELATION
FROM ACCOUNT_MASTER ACCT
JOIN ACCOUNT_RELATIONSHIPS AREL
ON ACCT.ACCOUNT_ID = AREL.ACCOUNT_ID
JOIN RELATIONSHIP_CODES RC
ON AREL.RELATIONSHIP_CODE = RC.CODE
WHERE ACCT.APPL_CODE = 'SBX'
AND ACCT.CLOSED_DATE IS NULL
UNION ALL
SELECT CAST(999999999 AS DECIMAL(9)) AS CIF_NUMBER
, CAST(99999 AS DECIMAL(5)) AS BRANCH_NUMBER
, CAST(9999999 AS DECIMAL(7)) AS APPL_ID
, CAST(' ' [...]35_4BBF3E19.6F0F.0085.0@efirstbank.com 18333 146 19_Re: database unload0_24_carol.sutfin@REGIONS.COM30_Fri, 9 Apr 2010 17:35:05 -0500357_US-ASCII Frank

Since it is late on Friday, I will give this a go.

If you have DSNTEP2/DSNTEP4 in your subsystem you can probably use that.
Depends on the DB2 Version.

DSNTIAUL is another option.
This will allow you to run SQL and generate an output file.
You would need to run with PARM('SQL') but it would probably work. [...]71_OFC4CDC128.D1602C75-ON86257700.007B9A2A-86257700.007C100E@corp.rgbk.com 18480 228 19_Re: database unload9_Don Leahy19_don.leahy@LEACOM.CA30_Fri, 9 Apr 2010 18:31:26 -0400718_ISO-8859-1 DSNTIAUL can do the job. Make sure that you use PARM('SQL'), which will
tell it to accept a full SELECT statement as input.

On Fri, Apr 9, 2010 at 16:47, Frank Swarbrick <
frank.swarbrick@efirstbank.com> wrote:

> I have the following VSE JCL that runs a DB2/VSE utility ARIDBS (aka DBSU:
> Database Services Utility):
>
> // JOB DBUNLOAD
> // DLBL SBXCUSI,'SFBX.PROD.MSAM.SBXCUSI',,VSAM,CAT=CUSTCAT
> // EXEC ARIDBS,SIZE=AUTO
> READ MEMBER VSEUSER.$;
> DATAUNLOAD
> SELECT CIF_NUMBER
> , BRANCH_NUMBER
> , CAST(APPL_ID AS DECIMAL(7)) AS APPL_ID
> , PMT_APPL_CODE
> , CAST(PMT_APPL_ID AS DECIMAL(10)) AS PMT_APPL_ID
> , PRIMARY_RELATIONSHIP AS [...]62_h2s6133ad1f1004091531jfb13fdb7k595934f8e42d1057@mail.gmail.com 18709 200 45_Re: z/OS DB2 V8 ZOS 1.11 USEZOSV1R9RULES(NO).13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM30_Fri, 9 Apr 2010 16:00:04 -0700531_us-ascii We only had it in for 2 weeks, which wasn't really long enough to measure any changes in CPU utilization. I backed it out today due to an abend 0C4 when getting in to CA Report Facility. The abend was very sporadic at first (we could log off of TSO and back on, then succesfully get in to PRF), but for whatever reason the abend became very persistent today. I changed USEZOSV1R9RULES back to YES, and could not get PRF to abend. Changed it to NO again, and the thing abended right away. I will open an issue with CA [...]64_927FE8790B320742927BCF9ADF7AE48A18EF1B43D8@PDXMAIL.pacificorp.us 18910 256 19_Re: database unload15_Frank Swarbrick30_frank.swarbrick@EFIRSTBANK.COM30_Fri, 9 Apr 2010 17:12:22 -0600679_us-ascii Should this be able to run against a remote non-zOS database (DB2 9.5 for LUW, for example)?
I first ran it without binding it to the remote server and got this:

CONNECT TO CORE1
CONNECT SUCCESSFUL
DSNT400I SQLCODE = 000, SQLSTATE = 00000, UNQUALIFIED SUCCESSFUL COMPLETION FROM DB2 UDB for AIX, Linux, HP-UX, Sun,
and Windows TOKENS 1 1252 APPLUSER COREDB2T QDB2/LINUXX8664 6525 6525 0 1208 1
DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME CORE1..DSNTIAUL.188F466605D421BC NOT FOUND IN PLAN DSNTIAUL.
REASON 01
DSNT418I SQLSTATE = 51002 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXEPM SQL PROCEDURE DETECTING ERROR
DSNT416I [...]35_4BBF5FF5.6F0F.0085.0@efirstbank.com 19167 470 19_Re: database unload9_Chris Tee25_chris.tee@NOVAMAGIC.CO.UK31_Sat, 10 Apr 2010 00:55:33 +0000652_iso-8859-1 Frank

You will need to add SQLERROR(CONTINUE) to your bind cards and use PARMS('SQL,1') when you run it to disable multirow fetch.

Chris

> Date: Fri, 9 Apr 2010 17:12:22 -0600
> From: frank.swarbrick@EFIRSTBANK.COM
> Subject: Re: [DB2-L] database unload
> To: DB2-L@IDUGDB2-L.ORG
>
> Should this be able to run against a remote non-zOS database (DB2 9.5 for LUW, for example)?
> I first ran it without binding it to the remote server and got this:
>
> CONNECT TO CORE1
> CONNECT SUCCESSFUL
> DSNT400I SQLCODE = 000, SQLSTATE = 00000, UNQUALIFIED SUCCESSFUL COMPLETION FROM DB2 UDB for [...]43_COL121-W22AC4BB206564CC0482C38A6140@phx.gbl 19638 29 81_Re: Index-controlled to Table-controlled partitioning - Performance benefits poll11_Sameer Rana21_sameerdrana@GMAIL.COM30_Fri, 9 Apr 2010 23:24:54 -0400669_UTF-8 Thanks a lot for your insights Phil!
Appreciate!

Regards,
Sameer

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________ [...]53_2267249163231991.WA.sameerdranagmail.com@www.idug.org 19668 29 81_Re: Index-controlled to Table-controlled partitioning - Performance benefits poll11_Sameer Rana21_sameerdrana@GMAIL.COM30_Fri, 9 Apr 2010 23:36:32 -0400669_UTF-8 Thanks a lot Dave,
Your insight is very helpful.

Regards,
Sameer

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________ [...]53_3947452128625701.WA.sameerdranagmail.com@www.idug.org 19698 29 81_Re: Index-controlled to Table-controlled partitioning - Performance benefits poll11_Sameer Rana21_sameerdrana@GMAIL.COM30_Fri, 9 Apr 2010 23:26:07 -0400658_UTF-8 Thank you very much Phil!
Appreciate!

Regards,
Sameer

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________ [...]53_0385363663551907.WA.sameerdranagmail.com@www.idug.org 19728 131 93_Re: [AD] Webinar - Index Optimization (was Index-controlled to Table-controlled partitioning)12_Isaac Yassin20_yassini@BEZEQINT.NET31_Sat, 10 Apr 2010 11:18:51 +0300484_UTF-8 Hi Phil,

I'm still pondering at the meaning of " Phil will also at SQL consolidation " :-)

Isaac Yassin

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Phil Grainger
Sent: Friday, April 09, 2010 3:05 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] [AD] Webinar - Index Optimization (was Index-controlled to Table-controlled partitioning)

Looks like Dan knows more about my future than I do (spooky) [...]35_017d01cad886$73f40670$5bdc1350$@net 19860 112 45_Re: How to verify table no longer being used?12_Isaac Yassin20_yassini@BEZEQINT.NET31_Sat, 10 Apr 2010 11:24:23 +0300410_UTF-8 Hi

I've uploaded a REXX to analyze the SMF 42 -subtype 6 to the Code Place at IDUG few years ago.
Feel free to use it :-)

Isaac Yassin

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Gugel, Rich - DOA
Sent: Friday, April 09, 2010 6:19 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] How to verify table no longer being used? [...]35_017f01cad887$39c421a0$ad4c64e0$@net 19973 345 53_uuaaa: [DB2-L] Lack of DBA's harms the market for DB214_Michael Kaplan25_micaelkp@NETVISION.NET.IL31_Sat, 10 Apr 2010 13:54:01 +0300357_US-ASCII . I have also been asked about my experience with DB1 ( yeah no kidding ).

Who knows, Khalid. Probably, the recruiter really needed such person. DB1
really exists and this is the name of database used by Sapiens Technologies.

And, this name ( DB1) was invented before DB2, and this may be a reason of
number 2 in DB2 name. [...]38_504A0596CD784EF4ABA3E0A1072A53B1@MERAV 20319 111 42_Re: Lack of DBA's harms the market for DB211_Roy Boxwell16_R.Boxwell@SEG.DE31_Sat, 10 Apr 2010 14:51:58 +02000_64_OF08281949.73433754-ONC1257701.0046AD0F-C1257701.0046AD2B@seg.de 20431 66 23_DB2 LUW - DARI Support?13_Brian Stewart23_briankstewart@GMAIL.COM31_Sat, 10 Apr 2010 11:20:49 -0600558_ISO-8859-1 Hello -

I have an interesting situation where we want to run an application on
Windows Server 2008 or Win7 that uses DARI to interface with DB2. The last
support DB2 had for DARI was in version 7.2 and although 7.2 will install
and run on Windows Server 2008 it spews errors in db2diag.log and I don't
trust it at all. I know, I know - it's crazy and it's not even supported
anymore. Does anyone know if IBM in any way continued to support DARI after
7.2 via some other mechanism? Ideally, I'd like to be able to run [...]62_m2ma771e61c1004101020l15e5fd97pd308a6d1e644002d@mail.gmail.com 20498 47 61_Re: DB2 for z/OS -Difference between OR vs IN on same column?14_Peter Vanroose17_pvanroose@ABIS.BE31_Sat, 10 Apr 2010 15:19:58 -0400537_UTF-8 I guess there's no difference.
Just ask EXPLAIN to find out!

EXPLAIN PLAN SET QUERYNO = 12345 FOR
SELECT *
FROM my_table
WHERE CLM_TYP_CD = ? OR CLM_TYP_CD = ?
;
EXPLAIN PLAN SET QUERYNO = 12346 FOR
SELECT *
FROM my_table
WHERE CLM_TYP_CD IN (?,?)
;
SELECT * FROM plan_table
WHERE queryno IN (12345, 12346)
;

In both cases, I'm getting "ACCESSTYPE='N'" when there's an index on that column.
All detailed measures (those visible in DSN_DETCOST_TABLE) are also identical. [...]49_8161860614817434.WA.pvanrooseabis.be@www.idug.org 20546 102 45_Re: How to verify table no longer being used?12_Myron Miller22_myronwmiller@YAHOO.COM31_Sat, 10 Apr 2010 18:41:07 -0700444_us-ascii True, but if you're truly trying to eliminate all potential usages, then the stop will identify those daily image copy jobs that are still copying it so that you can change the listdef to not include it.

________________________________
From: "Jardine, Lawrence J"
To: DB2-L@IDUGDB2-L.ORG
Sent: Fri, April 9, 2010 11:24:24 AM
Subject: Re: [DB2-L] How to verify table no longer being used? [...]44_553321.30488.qm@web112117.mail.gq1.yahoo.com 20649 315 24_Re: IBM Unload and Limbo12_Myron Miller22_myronwmiller@YAHOO.COM31_Sat, 10 Apr 2010 18:44:54 -0700449_us-ascii I know about the PDSE ptf. I've had it on since it was originally created ( As a side note, I was the originator of it). Data Mover is a side extra cost item for BMC Change Manager.

As an additional note, a PDSE is limited to only about 500,000 rows being unloaded. I don't remember the exact number at this point. Anything larger hits the limitation of the size of a PDSE. Then you must use the USS system unloaded. No choice. [...]44_281230.90077.qm@web112107.mail.gq1.yahoo.com 20965 285 27_Re: DB2 LUW - DARI Support?12_Phil Gunning19_pkgunning@GMAIL.COM31_Sun, 11 Apr 2010 00:22:59 -0400419_us-ascii DARI are stored procedures. If your V7.2 was using SQL Procedures, which
were introduced in DB2 V7.1 you should be able to recreate them and move to
a supported version of DB2 like, DB2 9.1, 9.5 or 9.7. PG

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Brian Stewart
Sent: Saturday, April 10, 2010 1:21 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] DB2 LUW - DARI Support? [...]35_007801cad92e$ae90ab00$0bb20100$@com 21251 77 61_Re: DB2 for z/OS -Difference between OR vs IN on same column?12_Isaac Yassin20_yassini@BEZEQINT.NET31_Sun, 11 Apr 2010 07:48:03 +0300469_utf-8 Hi

When dealing with same column in OR then DB2 changes it to IN-LIST except in CASE processing.

Isaac Yassin

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Peter Vanroose
Sent: Saturday, April 10, 2010 10:20 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] DB2 for z/OS -Difference between OR vs IN on same column?

I guess there's no difference.
Just ask EXPLAIN to find out! [...]35_000001cad932$35b691f0$a123b5d0$@net 21329 975 22_No estoy en la oficina32_Lainez Gutierrez, Maria Victoria21_mvlainez@IBERDROLA.ES31_Sun, 11 Apr 2010 07:36:55 +0200710_iso-8859-1 Hola,

Hasta el 15 de Abril no voy a estar en la oficina. Para algún tema urgente relacionado con DB2 escribe un correo a Juan Calleja (jcallejav@iberdrola.es).

Un saludo,
Vicky

===============================================================
Este mensaje se dirige exclusivamente a su destinatario. Los datos incluidos en el
presente correo son confidenciales y sometidos a secreto profesional, especialmente en lo que
respecta a los datos personales, se prohibe divulgarlos, en virtud de las
leyes vigentes. Si usted no lo es y lo ha recibido por error o tiene conocimiento
del mismo por cualquier motivo, le rogamos que nos lo comunique por este medio y [...]73_534FFF2C8B16444DBF458EFA2E0C9F74012411AC@CLFEXBUZ23A.corp.iberdrola.local 22305 77 73_AUTO: Ashvin Amin/Dallas/IBM is out of the office. (returning 04/13/2010)11_Ashvin Amin17_ashvin@US.IBM.COM31_Sun, 11 Apr 2010 04:01:01 -0600403_US-ASCII I am out of the office until 04/13/2010.

I will be out of the office on business until Apr 13. I will repsond to
your messages within 24 hours.

If you need immediate assistance, please contact Jack
Mason...masonja@us.ibm.com

Note: This is an automated response to your message "DB2-L Digest - 10 Apr
2010 to 11 Apr 2010 (#2010-100)" sent on 4/10/10 23:00:00. [...]68_OF9C6E054B.08C6106B-ON87257702.00370683-87257702.00370683@us.ibm.com 22383 228 45_Re: How to verify table no longer being used?19_Jardine, Lawrence J19_JardineLJ@AETNA.COM31_Sun, 11 Apr 2010 12:30:57 -0400544_us-ascii 1. A good DBA continues periodic image copies until it is determined that the tablespace is no longer used; so removal of the image copy would be the last step prior to the drop of the tablespace.
2. A well-written LISTDEF with smart wild-carding would not have to be changed.

________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Myron Miller
Sent: Saturday, April 10, 2010 9:41 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] How to verify table no longer being used? [...]70_C7DCA78FAF334147B2FD39A220A4C50001A32A0077@HFDPMSGCMS02.aeth.aetna.com 22612 261 67_Re: [FLUFF} Re: IBM DB2 Database Administration Certification - 73216_Daniel Luksetich18_danl@DB2EXPERT.COM31_Sun, 11 Apr 2010 13:48:29 -0500339_US-ASCII Barbara,
I will definitely pass your comments on to my publisher and the
certification folks. In my opinion the DB2 for z/OS book market is in the
pits right now. I have two books ready to go, but doubt I can find a taker
right now. I think when I get a break from my day job I'll self publish.
Cheers,
Dan [...]35_03d901cad9a7$a2cb9fe0$e862dfa0$@com 22874 494 70_Re: Redbook "Application Design for High Performance and Availability"16_Daniel Luksetich18_danl@DB2EXPERT.COM31_Sun, 11 Apr 2010 13:48:29 -0500485_US-ASCII Susan and I have two free performance guides out on db2expert.com sponsored
by your competitors. They contain information relevant to DB2 9.

Cheers,

Dan

Daniel L Luksetich

IBM Information Champion

IBM Certified Database Administrator - DB2 9 for z/OS

IBM Certified System Administrator - DB2 9 for z/OS

IBM Certified Solutions Expert - DB2 Universal Database V7.1 Database
Administration for UNIX, Windows, and OS/2 [...]35_03da01cad9a7$a4339450$ec9abcf0$@com 23369 761 29_Re: [AD] IBM Unload and Limbo12_Weaver, Rick19_Rick_Weaver@BMC.COM31_Sun, 11 Apr 2010 14:33:26 -0600460_us-ascii I would like to clarify something.

LOB Data Mover is a feature of the BMC Database Administration for DB2 solution. That solution builds on the following components - CHANGE MANAGER for DB2, CATALOG MANGER for DB2, LOADPLUS for DB2, UNLOAD PLUS for DB2, COPY PLUS for DB2, and SNAPSHOT UPGRADE FEATURE for DB2. The LOB Data Mover is an example of how we can build on the synergy of having several component products in a solution wrapper. [...]69_B04A515BCAE7C34D90FEE204B055E3B25CBCF8412D@PHXCCRPRD02.adprod.bmc.com 24131 617 29_Re: [AD] IBM Unload and Limbo16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Sun, 11 Apr 2010 18:10:07 -0400354_iso-8859-1 Since Rick has been so kind to provide some BMC details, I can't help to add another advert. CA Fast Unload in conjunction with CA Fast Load will copy your LOB data too. It can be done as "stand alone" jobs or scheduled via CA RC/Migrator where all the neededd control cards including any source/target table differences will be handled. [...]56_0A18F096E689AC43BB2F52DAE5674D6008151FE4@USILMS14.ca.com 24749 442 29_Re: [AD] IBM Unload and Limbo7_Ed Long19_rdhm99a@PRODIGY.NET31_Sun, 11 Apr 2010 19:21:46 -0700298_utf-8 I am encouraged to hear the progress CA and BMC  report making in re LOBS. Would it be too direct to inquire what took so long? LOBS first appeared in V6 I believe or about 12 years ago.

I remain astounded that basic support for LOBS continues to be an issue. Its not on ORACLE. [...]43_253197.39059.qm@web80208.mail.mud.yahoo.com 25192 422 19_Re: database unload15_Frank Swarbrick30_frank.swarbrick@EFIRSTBANK.COM31_Sat, 10 Apr 2010 07:16:46 -0600633_us-ascii Hmm, getting closer. Now I'm getting this:

********************************* TOP OF DATA **************************************************************************
DSNT490I SAMPLE DATA UNLOAD PROGRAM
DSNT505I DSNTIAUL OPTIONS USED: SQL,1
DSNT503I UNLOAD DATA SET SYSPUNCH RECORD LENGTH SET TO 80
DSNT504I UNLOAD DATA SET SYSPUNCH BLOCK SIZE SET TO 27920

CONNECT TO CORE1
CONNECT SUCCESSFUL
DSNT400I SQLCODE = 000, SQLSTATE = 00000, UNQUALIFIED SUCCESSFUL COMPLETION FROM DB2 UDB for AIX, Linux, HP-UX, Sun,
and Windows TOKENS 1 1252 APPLUSER COREDB2T QDB2/LINUXX8664 750 750 0 1208 1 [...]35_4BC025DD.6F0F.0085.0@efirstbank.com 25615 116 24_Re: IBM Unload and Limbo10_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 12 Apr 2010 09:08:45 +0200520_US-ASCII Hi Myron

I didn't know you hit the ground before me, but for me it was a bad hit.
DB2 crashes before realizing 2 GB limit was reached for DBM1 due to PDSE
LOB unload garbage. We tried even USS files but it was slow as well.
Anyway if our 'smart' z/OS sysprog had applied some PSP or at least
consolidated z/OS PTFs (that PTF was almost 2-years old) we'd had been no
problem, only (very very) slow unload. 'The importance of being Earliest'
is a book missing in that guy's library. [...]66_OF64B40935.FAD6E3DF-ONC1257703.00256620-C1257703.0026DDEF@cesve.it 25732 31 107_AUTO: Norbert Jenninger/Germany/IBM is out of the office until Friday April 16, 2010 (returning 04/16/2010)17_Norbert Jenninger14_JEN@DE.IBM.COM31_Mon, 12 Apr 2010 10:11:38 +0200364_US-ASCII I am out of the office until 04/16/2010.

I am out of office, travelling to Finland (customer) and willl be back in
the office at Friday April 16, 2010. I'll try to check my mailbox once a
day..

Note: This is an automated response to your message "DB2-L Digest - 11 Apr
2010 to 12 Apr 2010 (#2010-101)" sent on 12/4/10 7:00:01. [...]68_OF7436ADBE.2CBDE1F2-ONC1257703.002D02CD-C1257703.002D02CE@de.ibm.com 25764 73 22_DB2 UNLOAD consumption11_Tomas Vasko23_tomas.vasko@GENERALI.AT31_Mon, 12 Apr 2010 10:58:04 +0200450_US-ASCII Hello.

We unload each working day some DB2 Catalog Tables with DB2 UNLOAD Utility.
Always the same tables with the same job. But I found out, that the CPU consumption
vary till 100% !!!
Is there any explanation for such volatile CPU consumption?

Vasko Tomas
Generali IT-Solutions GmbH
A-1220 Wien, Kratochwjlestrasse 4
Tel.: +43 1 53401-1074
Fax: +43 1 5320949-1074
e-mail: tomas.vasko@generali.at [...]68_OFFC32E1C7.9DC53543-ONC1257703.002C6615-C1257703.0031432C@AT.TOP.COM 25838 112 93_Re: [AD] Webinar - Index Optimization (was Index-controlled to Table-controlled partitioning)13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Mon, 12 Apr 2010 06:19:50 -0400496_utf-8 Thanks Isaac

Moral - "Never cut and paste and add your own flavour without proofreading"

What that should say is

"Phil will also LOOK AT SQL consolidation to ensure the workload is truly representative of SQL activity and is not just a collection of SQL statements with execution frequencies"

Apologies for any confusion

Phil Grainger
Cogito Ltd.
phil.grainger@cogito.co.uk
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk [...]58_4440F5DA00E3F3459BBCB97431B91B6611B01321@MAILR004.mail.lan 25951 253 93_Re: [AD] Webinar - Index Optimization (was Index-controlled to Table-controlled partitioning)14_Peter Backlund21_BacklundDB2@TELIA.COM31_Mon, 12 Apr 2010 13:49:56 +02000_26_4BC308E4.2080007@telia.com 26205 480 93_Re: [AD] Webinar - Index Optimization (was Index-controlled to Table-controlled partitioning)13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Mon, 12 Apr 2010 07:56:03 -0400565_utf-8 Thanks Peter

I was under the impression ours was at noon Eastern (my Tech Talks always are), but you are right

I wonder if it’s too late to postpone or reschedule this to a better time

Watch this space
Phil Grainger
Cogito Ltd.
phil.grainger@cogito.co.uk
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk

Attend IDUG 2010 - Europe, the premiere event for DB2 professionals.
8-12 November 2010, Vienna
Learn more at http://www.idug.org [...]58_4440F5DA00E3F3459BBCB97431B91B6611B01328@MAILR004.mail.lan 26686 462 70_Re: Redbook "Application Design for High Performance and Availability"13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Mon, 12 Apr 2010 08:15:51 -0400604_us-ascii Indeed it is - Many thanks Raymod
Phil Grainger
Cogito Ltd.
phil.grainger@cogito.co.uk
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk

Attend IDUG 2010 - Europe, the premiere event for DB2 professionals.
8-12 November 2010, Vienna
Learn more at http://www.idug.org

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Bell, Raymond
Sent: 09 April 2010 16:24
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Redbook "Application Design for High Performance and Availability" [...]58_4440F5DA00E3F3459BBCB97431B91B6611B0132C@MAILR004.mail.lan 27149 119 45_Re: How to verify table no longer being used?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Mon, 12 Apr 2010 11:28:07 -0400598_us-ascii Rich -- Cheryl Watson? Subscribe to what? MXG, or something else? I'm interested, but confused.
--Phil Sevetson

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Gugel, Rich - DOA
Sent: Friday, April 09, 2010 6:19 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] How to verify table no longer being used?

Have you looked at 42-6 records? These records report activity and performance statistics by a job to a dataset. If you have MXG they are easy to report on. Cheryl Watson has a nice article on them if you subscribe [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC467E8@MAIL02.fisalan.nycnet 27269 161 19_Cheryl Watson & MXG12_Martin Hubel17_Martin@MHUBEL.COM31_Mon, 12 Apr 2010 11:52:57 -04000_43_DB2-L%201004121153084914.0142@IDUGDB2-L.ORG 27431 26 34_CPU savings just by running DB2 9?17_Darren Kilpatrick31_darren.kilpatrick@WELLPOINT.COM31_Mon, 12 Apr 2010 11:53:31 -0400684_UTF-8 Hello,
Just wanted to make sure on this:

By just upgrading to and running DB2 9 NFM, there is little to no CPU savings compared to Version 8. Much of the CPU savings is a result of the improved functions and utilities in DB2 9. Is that correct?

_____________________________________________________________________

* 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! *
** The best DB2 technical sessions in the world
** NEW - IBM hands-on labs -> no additional charge
_____________________________________________________________________ [...]63_7760592511086188.WA.darren.kilpatrickwellpoint.com@www.idug.org 27458 38 23_Re: Cheryl Watson & MXG15_Lizette Koehler23_starsoul@MINDSPRING.COM31_Mon, 12 Apr 2010 12:42:23 -04000_72_3158907.1271090543458.JavaMail.root@elwamui-lapwing.atl.sa.earthlink.net 27497 181 23_Re: Cheryl Watson & MXG17_Gugel, Rich - DOA24_rich.gugel@WISCONSIN.GOV31_Mon, 12 Apr 2010 11:51:20 -0500512_us-ascii There is a tool someone wrote that does SMF type 42 parsing. If you don't have MXG it may be worth looking into. I have MXG so I have not used the program in the link. Here is the link

http://www.ibm.com/developerworks/exchange/dw_entryView.jspa?externalID=531

________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Lizette Koehler
Sent: Monday, April 12, 2010 11:42 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Cheryl Watson & MXG [...]79_3A61DE20404B9D41A954E5380147DD28013D2F5B8403@MEWMAD0PC02G02.accounts.wistate.us 27679 1067 40_Re: [z/OS - DB2 V9] Access Path question18_Satish Srikakulapu26_Satish.Srikakulapu@APS.COM31_Mon, 12 Apr 2010 11:05:35 -0700583_us-ascii Hello:

After the DB2 V9 upgrade, we ran the RUNSTATS and rebound all the programs. We found that though the accesspath was looking better for a particular program using Visual Explain and Path Checker, the execution time was probably 200 times worser than the original.

We didn't know the cause as the access path was looking good, so we used rebound the program with REBIND SWITCH(ORIGINAL) (Initially we rebound all the programs with REBIND PLANMGMT(EXTENDED) option). After getting the accesspath from V8, the job ran with the expected execution time. [...]55_D42E68651088914B9B327A4EEA8433ACA6CCF1DB@VM251.apsc.com 28747 53 17_PLANMGMT question9_Ed Vetock25_Ed_Vetock@NAVYFEDERAL.ORG31_Mon, 12 Apr 2010 15:41:56 -0400668_US-ASCII Hi

I was wondering if anyone figured out a way to verify that an access path
reverted after executing the rebind option SWITCH (previous|original)
other than a return code = 0 from the batch job?

Thanks
Ed Vetock

_____________________________________________________________________

* 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! *
** The best DB2 technical sessions in the world
** NEW - IBM hands-on labs -> no additional charge
_____________________________________________________________________ [...]73_OF48CD6D3C.D2848BD5-ON85257703.006B0C94-85257703.006C358E@navyfederal.org 28801 69 38_Re: CPU savings just by running DB2 9?12_Myron Miller22_myronwmiller@YAHOO.COM31_Mon, 12 Apr 2010 13:04:08 -0700517_us-ascii I can't say. Our experience was a noticeable degradation (increased CPU) even after seriously extended runstats. We're still up about 20% over pre-V9.

So your mileage may vary. Some have experienced improvements with improved runstats and some have it worse.

Myron

________________________________
From: Darren Kilpatrick
To: DB2-L@IDUGDB2-L.ORG
Sent: Mon, April 12, 2010 11:53:31 AM
Subject: [DB2-L] CPU savings just by running DB2 9? [...]44_840249.83210.qm@web112110.mail.gq1.yahoo.com 28871 108 23_Re: Cheryl Watson & MXG10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 13 Apr 2010 08:53:19 +0200408_US-ASCII Cheryl Watson is a constat presence in Capacity Tuning area with his
'Tuning Letters' and in SHARE is famous for her presentation 'Cheryl's Hot
Flashes #'n'' where 'n' is a progressive number. She collects even user
experiences (she published our experience with CA-SORT) and tips/hints
from lists. She produced a SMF chart and her IBM CPU Chart is widespread
among mainframers. [...]66_OF3E3D5B95.4BD01C43-ONC1257704.00243BC9-C1257704.0025748B@cesve.it 28980 317 21_Re: PLANMGMT question13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Tue, 13 Apr 2010 03:35:14 -0400330_us-ascii Not sure I understand your question Ed

Are you asking whether you can "trust" DB2 to have switched your access path when you asked?

Isn't that a bit like saying "I've inserted a row and committed the insert. I got SQLCODE zero for both statements, but how do I know that DB2 really inserted the row"?? [...]58_4440F5DA00E3F3459BBCB97431B91B6611B01396@MAILR004.mail.lan 29298 1160 48_AW: [DB2-L] [z/OS - DB2 V9] Access Path question35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM31_Tue, 13 Apr 2010 09:37:47 +0200660_iso-8859-1 What do you mean with: "The access path was looking better"? I think, without having any information about the old and the new access path, we cannot give you any help.

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 [...]43_DB2-L%201004130339546564.0164@IDUGDB2-L.ORG 30459 567 103_Re: [AD] POSTPONED Webinar - Index Optimization (was Index-controlled to Table-controlled partitioning)13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Tue, 13 Apr 2010 03:42:06 -0400542_utf-8 Hi all

Well, although postponing the Cogito webinar on Index Optimization was definitely the right thing to do in view of the clash with IBM, Roger Miller and Dave Buelke it has become harder than I expected to fix an alternate date and time

However, I will make an announcement here when the rescheduled webinar will take place, so please bear with us
Phil Grainger
Cogito Ltd.
phil.grainger@cogito.co.uk
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk [...]58_4440F5DA00E3F3459BBCB97431B91B6611B01397@MAILR004.mail.lan 31027 192 19_Re: database unload16_Wallace, Stephen25_stephen.wallace@LANDG.COM31_Tue, 13 Apr 2010 09:53:54 +0100588_us-ascii Frank,
You'll need to add SQLERROR(CONTINUE) to your bind cards. This will
allow the package to bind whilst ignoring the multi-row fetch cursor.
When you run DSNTIAUL you need to enforce a single row fetch by using
PARM('SQL,1').

Regards,
Steve Wallace
Mainframe DBA
Legal & General Assurance Society
Work: 01737 374308 (7100 4308)

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Frank
Swarbrick
Sent: 10 April 2010 00:12
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] database unload [...]59_2A5FCDEE9A299647B797452C9EE9CBB50939AF8F@KWDMXV41.landg.net 31220 303 21_Re: PLANMGMT question12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Tue, 13 Apr 2010 06:50:03 -0500534_US-ASCII Ed:

I believe that SEG has a solution for this question.

Gerald Hodge

HLS Technologies, Inc.

www.hlstechnologies.com

DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ed Vetock
Sent: 12 April 2010 20:42
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] PLANMGMT question

Hi

I was wondering if anyone figured out a way to verify that an access path
reverted after executing the rebind option SWITCH (previous|original) other
than a return code = 0 from the batch job? [...]35_001901cadaff$74a115b0$5de34110$@com 31524 271 19_Re: database unload16_Wallace, Stephen25_stephen.wallace@LANDG.COM31_Tue, 13 Apr 2010 15:41:37 +0100358_us-ascii Frank,
You cannot use connect with the unload program. You'll need to either
use a 3 part name or create an alias. I believe the alias name has to
be the same name as the name of the object on the remote database.

Regards,
Steve Wallace
Mainframe DBA
Legal & General Assurance Society
Work: 01737 374308 (7100 4308) [...]59_2A5FCDEE9A299647B797452C9EE9CBB50939AFA1@KWDMXV41.landg.net 31796 100 49_DB2 V8 NFM - Z/OS 1.9 - CICS DB2 access to Oracle16_Wolters, Jeff B.24_Jeff.Wolters@PGNMAIL.COM31_Tue, 13 Apr 2010 11:21:24 -0400364_us-ascii Honored listeners (hope that butters you up enough to answer :))

Developers would like to access Oracle in their CICS DB2 transactions.
We have Oracle Net Services 10g, for accessing oracle in batch COBOL programs.
But can this be used in CICS programs?
Has anyone used anything else?
Does one need Oracle Access Manager for CICS? [...]81_7FD614EFA33B03448166AF44364F42AE0CCDF92D4D@WN000075.oak.zone1.progress-energy.com 31897 55 36_Z/OS DB2 V8 to Oracle Data Warehouse10_Dave Nance16_dav1mo@YAHOO.COM31_Tue, 13 Apr 2010 09:27:35 -0700430_iso-8859-1 Hey folks,     Since someone else already opened the Oracle door this morning, thought I would ask this one. I am being asked tomorrow afternoon about moving data from our Z/OS DB2 database to a warehouse on Oracle and they want it near realtime. I think they should leave where it is, but wanted to see if any of you are already doing this type set up and anything special to watch out for. Thanks.   David Nance [...]43_886681.42286.qm@web57808.mail.re3.yahoo.com 31953 334 51_Re: [AD DB2-L] Z/OS DB2 V8 to Oracle Data Warehouse12_Weaver, Rick19_Rick_Weaver@BMC.COM31_Tue, 13 Apr 2010 10:40:32 -0600531_us-ascii David, we have customers using our Log Master for DB2 product with High Speed Apply Engine moving data from DB2 to Oracle with low lag times.

Contact me off list at rick_weaver@bmc.com if you would like more detail.

Rick Weaver
DB2 z/OS Product Manager
BMC Software

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Dave Nance
Sent: Tuesday, April 13, 2010 11:28 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] Z/OS DB2 V8 to Oracle Data Warehouse [...]69_B04A515BCAE7C34D90FEE204B055E3B25CBD5B9957@PHXCCRPRD02.adprod.bmc.com 32288 308 40_Re: Z/OS DB2 V8 to Oracle Data Warehouse14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 13 Apr 2010 12:49:00 -0400371_us-ascii Dave,

We've found about equal speeds for either:
a) Using Oracle Loader through Oracle Transparent Gateway to access the DB2 data, or;
b) (i) DB2 Unload Util to cursor-delimited files, (ii) Secure FTP through Unix System Services to flatfiles on the Oracle server, (iii) Oracle datapump to the Oracle DB.

We haven't tried other methods. [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC467FE@MAIL02.fisalan.nycnet 32597 181 40_Re: Z/OS DB2 V8 to Oracle Data Warehouse12_Peter Suhner24_peter_suhner@HOTMAIL.COM31_Tue, 13 Apr 2010 18:56:16 +0200448_Windows-1252 David,

we're feeding Oracle databases from DB2 z/OS through DB2 SQL Replication (DPropr Capture on z/OS, DB2 LUW Federation with Relational Wrappers, Apply process running on the Nicknames). We've been doing this for years and it's quite stable and sufficient for our needs. Won't give you real-time - minimum delays would practically be at about 3 minutes (the longer the delay, the smaller the synchronisation overhead). [...]42_SNT107-W540257FB2C7935D897A6EF1110@phx.gbl 32779 155 19_Re: database unload15_Frank Swarbrick30_frank.swarbrick@EFIRSTBANK.COM31_Tue, 13 Apr 2010 10:53:01 -0600632_us-ascii If I cannot use CONNECT how come I was able to use it and successfully connect?

Anyway, I will try and see if that three part name works. Thanks,
Frank
--

Frank Swarbrick
Applications Architect - Mainframe Applications Development
FirstBank Data Corporation - Lakewood, CO USA
P: 303-235-1403

On 4/13/2010 at 8:41 AM, "Wallace, Stephen" wrote:
> Frank,
> You cannot use connect with the unload program. You'll need to either
> use a 3 part name or create an alias. I believe the alias name has to
> be the same name as the name of the object [...]35_4BC44D0C.6F0F.0085.0@efirstbank.com 32935 516 40_Re: Z/OS DB2 V8 to Oracle Data Warehouse7_Kim May28_kim.may@THEFILLMOREGROUP.COM31_Tue, 13 Apr 2010 14:25:36 -0400359_us-ascii Dave,

You can use Q Replication to do the same thing as SQL Rep only a bit faster,
and typically more expensive. If you need ETL functionality, DataStage and
Change Data Capture (the heritage DataMirror product) work really well
together.or you could use CDC alone. Let me know if you want/need more info
to do a comparison - [...]45_4bc4b727.8278e70a.5452.ffffe302@mx.google.com 33452 52 47_DB2 9 CM on z/OS and DB2 connect: SQLCODE -122414_Peter Vanroose17_pvanroose@ABIS.BE31_Tue, 13 Apr 2010 15:03:52 -0400344_UTF-8 Dear listers,

After our host z/OS upgraded to DB2 9 CM last Friday, some of our Linux apps started to give an SQLCODE -1224 on opening a cursor.
Narrowing the possible causes, I was able to reproduce that problem from the Linux command line with a simple query, actually any query that returns a sufficient amount of rows. [...]49_3831615863856278.WA.pvanrooseabis.be@www.idug.org 33505 78 42_Tuning high inserts in DB2 DPF environment10_Mir, Sally15_SMir@BBANDT.COM31_Tue, 13 Apr 2010 15:02:23 -0400380_us-ascii Hi everyone! I've recently made the switch from DB2 z/OS to DB2 for
LUW. I'd like to hear if anyone has any cool tips and techniques for
tuning high inserts in a DPF environment. I understand that DPF is
intended for fast reading, not necessarily fast writing, but would like
to be able to tune our insert processing to at least something
reasonable. [...]62_994039AECC75DF4CAFE407FA0F32CDD00D1D3D26@wil-exmb01.bbtnet.com 33584 28 20_Universal tablespace20_Kumara Sai Singaraju19_satdb2dba@GMAIL.COM31_Tue, 13 Apr 2010 14:15:54 -0500698_ISO-8859-1 Hi,

We have an application with hundreds of table spaces and we don' want
to drop and recreate them to make UTS. Is IBM planning to have an
option to simply alter segmented tablespaces to UTS in version 10?

Version 9 , Zos 1.10

thanks

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________ [...]62_u2w4d222ac61004131215j2aaabae7hab8652151bde83c8@mail.gmail.com 33613 52 24_Re: Universal tablespace14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 13 Apr 2010 15:37:29 -0400472_us-ascii Yes.

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Kumara Sai Singaraju
Sent: Tuesday, April 13, 2010 3:16 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] Universal tablespace

Hi,

We have an application with hundreds of table spaces and we don' want
to drop and recreate them to make UTS. Is IBM planning to have an
option to simply alter segmented tablespaces to UTS in version 10? [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC46803@MAIL02.fisalan.nycnet 33666 85 24_Re: Universal tablespace12_Weaver, Rick19_Rick_Weaver@BMC.COM31_Tue, 13 Apr 2010 14:54:00 -0500402_us-ascii Roger Miller and Dave Beulke gave a webinar on DB2 V10 this morning at 10am US Central time. It had a slide discussing the enhancements to ALTER that included going to UTS. A single-table Simple or Segmented space will go to UTS Partition by Growth, a classic partitioned space will convert to UTS Partition by Range. It is a one way conversion, no going back once the ALTER is executed. [...]69_B04A515BCAE7C34D90FEE204B055E3B25CBD5B9C71@PHXCCRPRD02.adprod.bmc.com 33752 95 32_AW: [DB2-L] Universal tablespace35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM31_Wed, 14 Apr 2010 09:04:50 +0200819_iso-8859-1 Hi

It depends. If the segmented tablespace contains one table, then yes otherwise no.

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

-----Ursprüngliche Nachricht-----
Von: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] Im Auftrag von Sevetson, Phil
Gesendet: Dienstag, 13. April 2010 21:37
An: DB2-L@IDUGDB2-L.ORG
Betreff: Re: [DB2-L] Universal tablespace [...]43_DB2-L%201004140305006988.0202@IDUGDB2-L.ORG 33848 36 33_Extended Addressability questions11_Sameer Rana21_sameerdrana@GMAIL.COM31_Wed, 14 Apr 2010 10:18:46 -0400578_UTF-8 Hello all ,

I had two questions regarding Extended Addressability :
1) Is there any downside from performance perspective or any other in converting existing objects or defining new objects with Extended Addressability (EA-enabled DSSIZE 64G ) as opposed to other DSSIZEs ( non EA-enabled )?
2) Although Version 10 is not generally available yet, I heard that it is possible to convert objects to Extended Addressability by altering tablespace to DSSIZE 64G and REORGing it. Is this true ? And if so, does IBM plan to retrofit this feature in VERSION 9? [...]53_7092025337181885.WA.sameerdranagmail.com@www.idug.org 33885 114 22_[Sorta OT] Ooo, SHINY!14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Wed, 14 Apr 2010 10:54:27 -0400776_us-ascii I stumbled across a recent work by Chris Date when O'Reilly sent me an invitation to his online video master class. The book is "SQL And Relational Theory: How to Write Accurate SQL Code." Anybody got a copy and an opinion about it?
http://oreilly.com/catalog/9780596523084

-ps

_____________________________________________________________________

* 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! *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC4680A@MAIL02.fisalan.nycnet 34000 59 19_DB2 Unload and Load18_Mary-Jane Mulligan31_MaryJane.Mulligan@SENTENIAL.COM31_Wed, 14 Apr 2010 11:33:29 -0400325_- Hi,

I am trying to get the DB2 samples for DB2 8 on Z/OS to work. I want to be able to unload data from a database and reload to another database which has the same tables defined, same columns, etc.
I am building the jobs based on SDSNSAMP(DSNTEJ1).
I have the unload job working using the following JCL [...]63_9853394862599656.WA.MaryJane.MulliganSentenial.com@www.idug.org 34060 64 26_Re: [Sorta OT] Ooo, SHINY!13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Wed, 14 Apr 2010 12:32:10 -0500422_windows-1252 Haven't read it.. although I have read other stuff Date has written.
Back in the day, his books were one of the few places to get detailed
information on relational. Sometimes, I even understood what he write..

I did notice it is available as an eBook... include Kindle format, for a
few dollars less... with an eBook/hardcopy purchase option. Wish more
technical books came this way. [...]30_4BC5FC1A.8000704@attglobal.net 34125 44 61_- so are we in trouble with this index or how big will it go.13_Walters, Paul28_Paul.A.Walters@SALLIEMAE.COM31_Wed, 14 Apr 2010 15:59:41 -0400410_us-ascii We have an index on tablesspace that is defined with a dssize of 4g.

The index was defined with a dssize of 2g.

Here was what the db2 Limits says: - note the second paragraph refers to the underlying table space - is that index space or table space?

Our index just started to use dataset 32 - wonder if we need to rebuild it with a larger dssize before we actually find out. [...]70_EBC218E23BF7B5468DC64F2ED8547F427701DFBD22@VREEXMBX01.us.ad.usa-ed.net 34170 83 65_Re: - so are we in trouble with this index or how big will it go.14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Wed, 14 Apr 2010 16:21:26 -0400614_us-ascii Paul,

I recall anecdotally that the space rules for indexes were the same as the space rules for tablespaces -- you're looking at 4096 datasets. However, I don't have documentation support, so don't relax yet.

If you don't get an answer soon, you might want to consider Index Compression. For a fairly thorough discussion of what is required for this, you should read Section 3.8 of the DB2 9 for z/OS Technical Overview, found at http://publib-b.boulder.ibm.com/Redbooks.nsf/RedbookAbstracts/sg247330.html?Open (or at http://bit.ly/a8fjJG if your email reader doesn't like long URLs). [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC4680F@MAIL02.fisalan.nycnet 34254 117 65_Re: - so are we in trouble with this index or how big will it go.13_Walters, Paul28_Paul.A.Walters@SALLIEMAE.COM31_Wed, 14 Apr 2010 16:59:19 -0400262_us-ascii Thanks - if you find the doc we would be interested. We are V8 so index compression is not an option for us.

We are not 100% sure we have a problem - but we are having problems locating any doc that says yes it is a problem or no it is not. [...]70_EBC218E23BF7B5468DC64F2ED8547F427701DFBD26@VREEXMBX01.us.ad.usa-ed.net 34372 143 65_Re: - so are we in trouble with this index or how big will it go.14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Wed, 14 Apr 2010 17:04:28 -0400372_us-ascii You should probably open an ETR with IBM on this, given that you're already in 32 datasets.

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Walters, Paul
Sent: Wednesday, April 14, 2010 4:59 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] - so are we in trouble with this index or how big will it go. [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC46810@MAIL02.fisalan.nycnet 34516 43 65_How to retry IDENTIFY failures for 00f30025, 00f30056 or 00f300a215_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM31_Thu, 15 Apr 2010 00:48:09 +0300189_us-ascii What is the proper way to retry an IDENTIFY when DB2 returns 00f30025,
00f30056 or 00f300a2?

Will the STARTECB be posted?

Is the only option to periodically retry?42_sqdcs5pljss1psvpq6hu5r64h27pc791qk@4ax.com 34560 38 39_Question about result table of a cursor11_Wilson Liao16_d000660@SINA.COM31_Wed, 14 Apr 2010 21:00:54 -0400361_UTF-8 The environment is DB2 z/os V7 V8.

From DB2 SQL reference about OPEN statement, it tells me that DB2 may create a temporary copy of result table at OPEN or derive result table rows at later FETCH for a read-only cursor. And Peter Vanroose wrote that Materializing / not materializing is a free choice of the optimizer in a post of March,2008. [...]48_7024166414700594.WA.d000660sina.com@www.idug.org 34599 42 39_Question about result table of a cursor11_Wilson Liao16_d000660@SINA.COM31_Wed, 14 Apr 2010 21:19:34 -0400425_UTF-8 Hello listers

If I post twice, please forgive me.

The environment is DB2 z/os V7 V8.

From DB2 SQL reference about OPEN statement, it tells me that DB2 may create a temporary copy of result table at OPEN or derive result table rows at later FETCH for a read-only cursor. And Peter Vanroose wrote that Materializing / not materializing is a free choice of the optimizer in a post of March,2008. [...]48_5213023576347573.WA.d000660sina.com@www.idug.org 34642 44 20_[z/OS] DSNTEP2 Input4_Anil21_alisha_kale@YAHOO.COM31_Wed, 14 Apr 2010 21:33:19 -0400549_UTF-8 Hi All,

The DSNTEP2 program (DB2 on z/os) reads SQL statements from a 80 bytes input data. Actually, the SQL statement is to be coded in the first 72 bytes. Although it is possible to span the sql statment on multiple lines (records), is it possible to specify a input dataset greater than 80 characters ?
I would like to generate sql/ddl statements using SQL. In doing so, I would want to use the output of my sql as an input to something like DSNTEP2 or maybe the IBM DB2 ADMIN tool.
For example I want to generate a bunch [...]52_7196754350801505.WA.alishakaleyahoo.com@www.idug.org 34687 29 24_Re: [z/OS] DSNTEP2 Input4_Anil21_alisha_kale@YAHOO.COM31_Wed, 14 Apr 2010 21:38:48 -0400761_UTF-8 oops I had a typo in my original sql. but i guess you get the gist of the question. I meant to say sql statement as
SELECT 'GRANT SELECT,INSERT,UPDATE,DELETE ON ' || SUBSTR(CREATOR,1,8) || '.' || SUBSTR(NAME,1,18) || ' TO id1, id2,....$' FROM SYSIBM.SYSTABLES
WHERE .......

_____________________________________________________________________

* 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! *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train [...]52_1051528181253353.WA.alishakaleyahoo.com@www.idug.org 34717 47 24_Re: [z/OS] DSNTEP2 Input13_Dan Luksetich18_danl@DB2EXPERT.COM31_Thu, 15 Apr 2010 01:53:09 +0000677_utf-8 You can use a qmf form if you have that or download the ylaparse tool from db2expert.com it is free and will remove all the spufi messages too!
Cheers,
Dan
Sent via BlackBerry from T-Mobile

-----Original Message-----
From: Anil
Date: Wed, 14 Apr 2010 21:38:48
To:
Subject: [SPAM] Re: [z/OS] DSNTEP2 Input

oops I had a typo in my original sql. but i guess you get the gist of the question. I meant to say sql statement as
SELECT 'GRANT SELECT,INSERT,UPDATE,DELETE ON ' || SUBSTR(CREATOR,1,8) || '.' || SUBSTR(NAME,1,18) || ' TO id1, id2,....$' FROM SYSIBM.SYSTABLES
WHERE ....... [...]105_1573455505-1271296408-cardhu_decombobulator_blackberry.rim.net-1131225014-@bda205.bisx.prod.on.blackberry