1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l August 2009, week 2
2 26 76_Re: AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)11_Ted MacNEIL18_eamacneil@YAHOO.CA30_Sat, 8 Aug 2009 01:45:08 +0000741_- >You will receive a notification for each message you send to this person while the person is away.
Time for somebody to be set to NOMAIL! - Too busy driving to stop for gas!
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *
_____________________________________________________________________
IDUG Europe Attendee Testimonial- "I had my first experience with certifications (and passed)! I learned a lot about DB2 version 9 (LUW) that hopefully will enable me to convince management a timely migration will be of benefit for the business." _____________________________________________________________________
29 72 21_Re: DB2 9 Family Test14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Sat, 8 Aug 2009 13:26:51 +1000325_ISO-8859-1 The actual fundamentals test had no LUW specific stuff that I can recall. The only catch is introduction says "best possible answer". What that can mean is that the behaviour is based on STD rules not DB2 rules.
I would expect that you (Phil) would probably pass with the skill level you display here. [...]
102 67 65_AUTO: John Iczkovits is out of the office. (returning 08/31/2009)14_John Iczkovits19_iczkovit@US.IBM.COM30_Fri, 7 Aug 2009 22:03:52 -0600456_US-ASCII
I am out of the office until 08/31/2009.
Note: This is an automated response to your message "DB2-L Digest - 7 Aug 2009 to 8 Aug 2009 (#2009-230)" sent on 8/7/09 19:00:00.
This is the only notification you will receive while this person is away. _____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...]
170 218 31_Insert with select distinct ???9_Dee Reins21_rcwingman@COMCAST.NET30_Sun, 9 Aug 2009 21:24:21 +0000434_utf-8 We have a process that creates a reporting table from a foreign key table . The first thing we do is use the DB2 load utility and load from DD Dummy to empty the table. The next step we load the table, with SQL listed below.
When we upgraded DB2 from V8 to 9.1 this process started failing with DSNT408I SQLCODE = -803, ERROR: AN INSERTED OR UPDATED VALUE IS INVALID BECAUSE INDEX IN INDEX SPACE RPTRTASK CONSTRAINS [...]
389 193 21_Re: DB2 9 Family Test9_Dee Reins21_rcwingman@COMCAST.NET30_Sun, 9 Aug 2009 21:48:05 +0000390_utf-8 This is old hat, but I used Susan Lawsons book DB2 for Z/os Version 8 DBA certification guide.
It worked for me, I would recommend a book written by her.
Dee
----- Original Message ----- From: "Phil Sevetson" To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Friday, August 7, 2009 9:48:03 AM GMT -08:00 US/Canada Pacific Subject: DB2 9 Family Test [...]
583 198 46_Re: DB2 9 Family Test (I couldn't agree more).13_Brendan Friel21_bjpafriel@HOTMAIL.COM30_Sun, 9 Aug 2009 16:54:20 -0500657_iso-8859-1
I couldn't agree more.
Its especially annoying that the features that don't exist or won't work on z/OS aren't identified.
Cheers,
Brendan
> Date: Sat, 8 Aug 2009 13:26:51 +1000 > From: jacampbell@ACSLINK.NET.AU > Subject: Re: [DB2-L] DB2 9 Family Test > To: DB2-L@WWW.IDUGDB2-L.ORG > > The actual fundamentals test had no LUW specific stuff that I can recall. > The only catch is introduction says "best possible answer". What that can > mean is that the behaviour is based on STD rules not DB2 rules. > > I would expect that you (Phil) would probably pass with the skill [...]
782 125 13_Re: RE DSSIZE12_Roger Miller19_millerrl@US.IBM.COM31_Mon, 10 Aug 2009 01:08:21 +0000474_utf-8 You probably need to concatenate the two lines together, as the listserv editing line is too short, marking the URL as only the first part:
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db29.do c.sqlref/db2z_sql_createtablespace.htm
If all else fails, check the SQL Reference, under CREATE TABLESPACE.
Roger Miller, DB2 for z/OS
On Fri, 7 Aug 2009 13:02:47 +0100, Bruce Williamson wrote: [...]
908 138 21_Re: IRLM LOCK REQUEST12_Roger Miller19_millerrl@US.IBM.COM31_Mon, 10 Aug 2009 01:20:02 +0000473_utf-8 If you are running something like 20 concurrent utility jobs, with 200 partitions each, then that tends to exceed the concurrency possible with UTSERIAL. In our tests, we tend to get lots of abends. This needs a rewrite, but a rewrite does not fit into the service stream, as errors cause problems. So part of the answer coould need to wait for a new version, like DB2 X. Try slide 7 in this presentation. http://www.cdug.org/dec_11_2008_john_campbell_db2_x.pdf [...]
1047 121 46_Re: DB2 9 Family Test (I couldn't agree more).12_Roger Miller19_millerrl@US.IBM.COM31_Mon, 10 Aug 2009 01:34:59 +0000303_utf-8 As I remember the intent, we wanted to teach the common function in the fundamentals class and have the fundamentals test include only the common DB2 function. Getting the first certification means multiple tests, one on common fundamentals and one on either DB2 for LUW or for DB2 for z/OS. [...]
1169 70 58_AUTO: Arun Rao is out of the office (returning 08/11/2009)8_Arun Rao16_arunr@US.IBM.COM30_Sun, 9 Aug 2009 19:43:37 -0600330_US-ASCII
I am out of the office until 08/11/2009.
I will be out of the office on Mon 08/10/2009. Please contact my manager for any issues that can't wait.
Note: This is an automated response to your message "DB2-L Digest - 9 Aug 2009 to 10 Aug 2009 (#2009-232)" sent on 8/9/09 19:00:05. [...]
1240 131 9_Re: Blogs12_jim harrison24_jimh_listsub@VERIZON.NET30_Sun, 9 Aug 2009 21:52:12 -0400630_windows-1252 But posting multiple posts per day - forever - on various lists is NOT narcisstic? Stop driving and buy some gas.
On 8/6/2009 5:06 PM, Ted MacNEIL wrote: > I tend to think BLOGS are , and haven't found a reason for them to exist! > > - > Too busy driving to stop for gas! > > ------------------------------------------------------------------------ > *From*: "Sevetson, Phil" > *Date*: Thu, 6 Aug 2009 17:03:26 -0400 > *To*: > *Subject*: [DB2-L] Blogs > > Todays question: Is there a central aggregation point where someone > is collecting the websites of people who blog about [...]
1372 126 9_Re: Blogs11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Mon, 10 Aug 2009 02:08:26 +0000460_Windows-1252 If posting to discussion forms is narcisstic, then we should all stop!
Blogs are 'look at me'! - Too busy driving to stop for gas!
-----Original Message----- From: jim harrison
Date: Sun, 9 Aug 2009 21:52:12 To: Subject: Re: [DB2-L] Blogs
But posting multiple posts per day - forever - on various lists is NOT narcisstic? Stop driving and buy some gas. [...]
1499 582 9_Re: Blogs15_Coleman, Troy L19_Troy.Coleman@CA.COM30_Sun, 9 Aug 2009 22:18:30 -0400344_us-ascii Hey Willie did you forget about me J
My blog DB2utor covers DB2 for z/OS version 9 and soon I hope to start covering DB2 X.
I enjoy teaching and like you Willie hope the material is of interest and can help people. I do get a lot of thank you emails telling me that the material has saved some people hours of work. [...]
2082 82 9_Re: Blogs15_Coleman, Troy L19_Troy.Coleman@CA.COM30_Sun, 9 Aug 2009 22:22:21 -0400590_us-ascii Sounds like good Blog material Todd.. A lot of people can learn from you :-)
Troy Coleman CA, Inc. Principal Product Manager Office: +1630 505 6025 Mobile: +1224 343 0073 Blog: http://ibmsystemsmag.blogs.com/db2utor/ Twitter: http://twitter.com/DB2utor Twitter: http://twitter.com/troycoleman Linkedin: http://www.linkedin.com/in/troylcoleman
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Todd Burch Sent: Thursday, August 06, 2009 6:26 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Blogs [...]
2165 79 46_Re: DB2 9 Family Test (I couldn't agree more).13_David Simpson22_dsimpson@THEMISINC.COM30_Sun, 9 Aug 2009 22:23:39 -0400561_utf-8 Just took this test at IDUG and found that many questions were LUW specific functionality and were not labeled as such. Only reason I knew is that I was somewhat familiar with both platforms.
David Simpson Senior Technical Advisor Themis Training dsimpson@themisinc.com http://www.themisinc.com -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Roger Miller Sent: Sunday, August 09, 2009 8:35 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 9 Family Test (I couldn't agree more). [...]
2245 29 9_Re: Blogs11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Mon, 10 Aug 2009 02:24:28 +0000358_- > BTW, if my blog should become narcissistic, I would hope someone would point that out to me.
The funny thing is, after I made my comments, I looked at the UserFriendly WebSite (www.userfriendly.org), and found the cartoonist had the same attitude as I did. February 2009.
Do what you want. I try to help, but I don't need the ego boo. [...]
2275 746 57_IDUG 2010 North America - Call For Presentations is Open!13_Vijay Sitaram23_vijay.sitaram@GMAIL.COM30_Sun, 9 Aug 2009 21:24:48 -0500506_WINDOWS-1252 Hello Everyone,
The International DB2 Users Group (IDUG) is accepting presentation abstracts for IDUG 2010 - North America, May 10-14 in Tampa, Florida. This is your opportunity to share your DB2 experience and expertise with an audience of your peers who rely on, or are considering incorporating DB2 in their shop. If your presentation abstract is selected to be delivered at the conference, you will receive one complimentary IDUG 2010 - North America conference registration. [...]
3022 51 27_Re: SQL to remove dupes. ??12_Bill Cummins18_brcummin@ILSTU.EDU31_Mon, 10 Aug 2009 13:13:14 +0000744_utf-8 David, Dee or anyone -- what does the "WITH UR" argument do?
Thanks.
>----- Original Message ----- >From: "David Simpson"
>SELECT FK_TCPSERQASR_NBR, FK_TCPCIRCDSGNID , >COUNT(*) OCCURS >FROM CTCPXD.TCPCKCD ORGA >GROUP BY FK_TCPSERQASR_NBR, FK_TCPCIRCDSGNID > >HAVING COUNT(*) > 1 >ORDER BY FK_TCPSERQASR_NBR, FK_TCPCIRCDSGNID >WITH UR ;
>From: DB2 Data Base Discussion List on behalf of Dee Reins > >I am trying to identify duplicates . The SQL is wroing but I can't see to figure out why > >Please help :-( > >SELECT DISTINCT FK_TCPSERQASR_NBR, FK_TCPCIRCDSGNID , >COUNT(FK_TCPCIRCDSGNID) OCCURS >FROM CTCPXD.TCPCKCD ORGA >WHERE OCCURS > 1 >GROUP BY FK_TCPSERQASR_NBR, [...]
3074 106 35_AW: [DB2-L] SQL to remove dupes. ??12_Peter, Georg15_G.Peter@DZBW.DE31_Mon, 10 Aug 2009 15:18:58 +0200712_iso-8859-1 Bill,
the uncommitted Read (UR) -- also known as "dirty read" or "read through locks" -- was one of the most useful features of DB2 V4.1. ...(yes, 4.1 !)
With kind regards - mit freundlichen Gruessen, G e o r g H . P e t e r ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Development and Product Support (E3) Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, Europe e:mail G.Peter@dzbw.de Phone 0049-711-8108-271 PC-Fax 004971189696071 Internet (only in german language):http://www.dzbw.de ---------------------------------------------------------------------- THINK GREEN - DON'T PRINT THIS EMAIL UNLESS YOU REALLY NEED TO ! [...]
3181 216 21_Re: DB2 9 Family Test14_M. Khalid Khan24_Mohammad_Khan@BCBSIL.COM31_Mon, 10 Aug 2009 08:26:30 -0500528_iso-8859-1 I found this out when I decided on the spur of the moment to take the certification test while at an IDUG conference. Talk about timing ! I did better in the second test ( z/OS specific one ) but was able to clear the Dysfunctional Family Fundamentals test as well with some guess work and luck. I'd suggest that you don't sweat too much about it. Just read through some documents / presentations comparing the two platforms and you should be good for the 60% score it requires. Good luck with your tests Khalid [...]
3398 70 29_DB2 z/OS auditing SYSADM use?18_GRESHAM, DEBORAH B18_DGRESHAM@SCANA.COM31_Mon, 10 Aug 2009 09:28:46 -0400315_us-ascii We are DB2 z/OS V9 NFM. My supervisor has asked me how SYSADM authority is handled at other companies. Do you have it granted permanently or have to request it from security each time it is needed? Do you have a change log to support the use of SYSADM? I appreciate any feedback you can give on this. [...]
3469 219 21_Re: DB2 9 Family Test14_Barbara Koenen33_barbara.koenen.bgit@STATEFARM.COM31_Mon, 10 Aug 2009 06:41:18 -0700328_UTF-8 I also found the preparation book very useful for the V8 DBA tests. It helped me eek my way through the family test, refreshing me on concepts I hadn’t reviewed in a while. I took the DB2 9 tests right before the book was available for 9 and I have to admit I didn’t do quite as well, even though I still passed. [...]
3689 153 33_Re: DB2 z/OS auditing SYSADM use?15_Chris Hoelscher21_choelscher@HUMANA.COM31_Mon, 10 Aug 2009 09:43:26 -0400365_US-ASCII Deborah -
1) SYSADM is granted permanently at our site (but we have had many heated discussions about who needs it - due to limitations in who can drop some objects, etc) 2) we have weekly jobs (CA-LOG ANALYZER to report SYSADM usage
Chris Hoelscher Senior IDMS & DB2 Database Administrator Humana Inc 502-476-2538 choelscher@humana.com [...]
3843 21 55_Re: Will CA Insight read Audit trace records from SMF ?12_Arledge Bill20_bill_arledge@BMC.COM31_Mon, 10 Aug 2009 13:55:15 +0000509_utf-8 BMC MAINVIEW for DB2 provides a full set of reports from the SMF DB2 Audit trace records as well.
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *
_____________________________________________________________________
IDUG Europe Attendee Testimonial- "This was definitely the best IDUG conference I have ever attended." _____________________________________________________________________
3865 57 33_Re: DB2 z/OS auditing SYSADM use?12_Jeff Frazier31_Jeffrey.Frazier@WENDYSARBYS.COM31_Mon, 10 Aug 2009 10:00:43 -0400770_US-ASCII SYSADM is granted to 2 people at our site. We did go thru recently and revoked all others we found in catalog that had that SYSADM access to clean up folks that did not need .
Jeff Notice: This e-mail message and its attachments are the property of Wendy's/Arby's Group Inc. or one of its subsidiaries and may contain confidential or legally privileged information intended solely for the use of the addressee(s). If you are not an intended recipient, then any use, copying or distribution of this message or its attachments is strictly prohibited. [...]
3923 282 33_Re: DB2 z/OS auditing SYSADM use?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Mon, 10 Aug 2009 10:02:32 -0400517_us-ascii Deborah, At our site, SYSADM is granted to the members of the DBA group in the lowest, "development" environment. In "System Test" and "User-Acceptance Test" and Production, SYSADM is a secondary AuthID which DBAs are attached to; thus, to exercise SYSADM functions, we must "SET CURRENT SQLID = '[SYSADM]" first. This seems to work for our purposes, as it allows DBAs to come and go without the need for revoking SYSADM and the consequent cascades; it also preserves evidence of who created an object. [...]
4206 58 55_Re: Will CA Insight read Audit trace records from SMF ?11_Bear, Brian23_Brian.Bear@CHARMING.COM31_Mon, 10 Aug 2009 10:04:51 -0400362_us-ascii And they are great. I use Performance Reporter to load db2 tables with the SMF data. I keep a month's worth in the tables and create MS Excel docs showing weekly package and plan statistics. I've been doing this for years so I have a wealth of historic information to reference whenever performance or usage questions arise. I highly recommend it. [...]
4265 94 33_Re: DB2 z/OS auditing SYSADM use?10_Fred Edgar18_fredgarx@YAHOO.COM31_Mon, 10 Aug 2009 07:13:06 -0700616_iso-8859-1 permanent
--- On Mon, 8/10/09, GRESHAM, DEBORAH B wrote:
From: GRESHAM, DEBORAH B Subject: [DB2-L] DB2 z/OS auditing SYSADM use? To: DB2-L@WWW.IDUGDB2-L.ORG Date: Monday, August 10, 2009, 8:28 AM
We are DB2 z/OS V9 NFM. My supervisor has asked me how SYSADM authority is handled at other companies. Do you have it granted permanently or have to request it from security each time it is needed? Do you have a change log to support the use of SYSADM? I appreciate any feedback you can give on this. [...]
4360 93 21_Re: DB2 9 Family Test14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Mon, 10 Aug 2009 10:17:45 -0400485_iso-8859-1 Hrmp. Thank you.
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of James Campbell Sent: Friday, August 07, 2009 11:27 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 9 Family Test
The actual fundamentals test had no LUW specific stuff that I can recall. The only catch is introduction says "best possible answer". What that can mean is that the behaviour is based on STD rules not DB2 rules. [...]
4454 258 21_CA IDUG Award for DB217_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Mon, 10 Aug 2009 15:19:24 +0100706_utf-8
Dear DB2-L colleagues,
While this announcement is about a prize sponsored by CA, it is a prize about DB2!
Consider Submitting for the CA IDUG Award for Outstanding Work in DB2: Great Prizes. Get Recognized.
September 11, 2009 deadline.
In conjunction with IDUG and four independent DB2 consultants, CA has opened the submissions process for the second presentation of this award for DB2. –Beware– This is not your typical vendor-driven award. It is open to DB2 shops from any corner of the globe, whether they use CA’s products, another vendor’s tools or homegrown technologies. [...]
4713 172 21_CA IDUG Award for DB217_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Mon, 10 Aug 2009 15:21:13 +0100385_utf-8 Sorry, re-sending in different format since it seems like the email comes out wrong in the digest...
Dear DB2-L colleagues,
While this announcement is about a prize sponsored by CA, it is a prize about DB2!
Consider Submitting for the CA IDUG Award for Outstanding Work in DB2: Great Prizes. Get Recognized. September 11, 2009 deadline. [...]
4886 908 17_DB2 9 Family Test14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Mon, 10 Aug 2009 10:24:35 -0400664_us-ascii David,
Thanks for the warning. Pretty much what I was afraid of, based on the Sanders prep book.
** TO WHOEVER IS RESPONSIBLE FOR DESIGNING THE DB2 V10 FAMILY FUNDAMENTALS TEST **
I realize it's too late to change the curriculum for DB2V9, but I strongly urge that _at least_ one pure-mainframe expert be included in the test design team for DB2V10 Fundamentals (in order to vet the test for things mainframe people would not be exposed to in their jobs). Alternately, that the test be split into separate mainframe and LUW tracks, at least in the Database Mechanics (filesystems) [...]
5795 340 21_Re: DB2 9 Family Test12_Mark Vickers26_MarkVickers@GROCERYBIZ.COM31_Mon, 10 Aug 2009 09:28:02 -0500378_ISO-8859-1 Phil, I took Susan's crammer class at IDUG the day before and that was what got me through the test. Worth the price in my book. Mark.
"Sevetson, Phil" Sent by: DB2 Data Base Discussion List 08/10/2009 09:19 AM Please respond to DB2 Database Discussion list at IDUG [...]
6136 82 33_Re: DB2 z/OS auditing SYSADM use?0_24_carol.sutfin@REGIONS.COM31_Mon, 10 Aug 2009 09:30:33 -0500433_US-ASCII SYSADM is given to our Systems Programmer and System DBA.
The production scheduler task also has SYSADM.
Application DBA's only get DBADM for their databases in the test DB2 subsystem.
Also, as System DBA, I cannot update DSNLOAD ot DSNEXIT. This keeps the auditors happy with "separation of duties".
Carol Sutfin Corporate DBA Regions Financial Corp. (205)261-5214 carol.sutfin@regions.com [...]
6219 616 21_Re: DB2 9 Family Test14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Mon, 10 Aug 2009 10:31:24 -0400497_iso-8859-1 Thanks for the suggestion. Unfortunately I'm not financially in a position to attend IDUG (I'm an hourly-paid consultant for a government agency at present and they don't pay for consultants to attend seminars). I have to do this on the cheap.
________________________________ From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mark Vickers Sent: Monday, August 10, 2009 10:28 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 9 Family Test [...]
6836 27 21_Re: IRLM LOCK REQUEST9_Dinu Paul21_dinucpaul@YAHOO.CO.IN31_Mon, 10 Aug 2009 14:37:28 +0000461_utf-8 Thanks Roger and Vaughan for your prompt response.
But for us the problem become(IRLM LOCK REQUEST FAILED) worst around 2 months before. Before that there were only few failures. SYSUTILX directory space is quite small, similar to other datasharing systems and extend is less five.
Dinu
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...]
6864 199 25_Re: CA IDUG Award for DB215_Tonmoy Dasgupta28_tonmoy.dasgupta@ARKANSAS.GOV31_Mon, 10 Aug 2009 09:42:33 -0500355_utf-8 This is a great idea from CA. It would be good to have a gauge as to what projects were the winners in the last year. Is that information available?
I am wondering… is it the size and scale of solution benefits a big factor? In that case, small county or local government solutions would may make way for global business corporations. [...]
7064 30 33_Re: DB2 z/OS auditing SYSADM use?9_Dinu Paul21_dinucpaul@YAHOO.CO.IN31_Mon, 10 Aug 2009 14:49:02 +0000319_utf-8 Hi Deborah,
At our site, SYSADM is granted to seconday AuthIDs and all system DBAs are attached to it.We also used to maintain two separate secondary ID , one for dev system and other for production.
Also revoking the SYSADM access regularly is not a good idea, it may cascade too many things. [...]
7095 62 33_Re: DB2 z/OS auditing SYSADM use?14_Lyon, Lockwood20_Lockwood.Lyon@53.COM31_Mon, 10 Aug 2009 11:08:43 -0400457_us-ascii Carol,
How are your DBAs able to GRANT SELECT access on Views that you create? I thought that wasn't possible with the DBADM privilege.
Lock Lyon Fifth Third Bancorp
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of carol.sutfin@REGIONS.COM Sent: Monday, August 10, 2009 10:31 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 z/OS auditing SYSADM use? [...]
7158 454 36_Re: CA IDUG Award for DB2 - Criteria9_Dee Reins21_rcwingman@COMCAST.NET31_Mon, 10 Aug 2009 15:09:39 +0000566_utf-8 The Judging Criteria is on the CA website.
This from the document.
criteria. The award will be granted to the highest-scoring submission:
Weight Description
2 Scope and complexity of challenge
2.5 Technical innovation employed/discovered (uniqueness of solution)
1.5 Business/organizational innovation
1 Personal or team initiative/determination
2 Quantitative results demonstrated
1 Relevance of approach to other organizations
10 TOTAL (highest possible score is 50) [...]
7613 236 21_Re: DB2 9 Family Test28_Balachandran Chandrasekaran119_balaccha@IN.IBM.COM31_Mon, 10 Aug 2009 20:15:07 +0530349_UTF-8 That is a valid question. I amused myself couple of times about it and even wrote to IBM Certify asking this twice. And, following was the response: (I don't see a reason to take DB2 9 Family fundamentals when somebody is DBA already on v8 on z/OS. They could have included an extra chapter instead in the DB2 9 DBA Certification test !) [...]
7850 24 33_Re: DB2 z/OS auditing SYSADM use?9_Dinu Paul21_dinucpaul@YAHOO.CO.IN31_Mon, 10 Aug 2009 15:41:21 +0000506_utf-8 Yes Lyon, Its not possible with DBADM access. System DBA have to grant the access.
Dinu
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *
_____________________________________________________________________
IDUG Europe Attendee Testimonial- "This was definitely the best IDUG conference I have ever attended." _____________________________________________________________________
7875 325 33_Re: DB2 z/OS auditing SYSADM use?13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Mon, 10 Aug 2009 17:47:17 +0200568_us-ascii Deborah,
When I were a DBA I always had Sysadm permanently, either granted directly or through membership of a RACF group in the SYSADM2 Zparm. Except one role that was pure Development Support when I had DBADM on the databases that were 'mine'. OK, except another role, where I had to request Sysadm of the Security Team, who then escorted me physically to the front security desk where they handed me an envelope (after I'd signed for it, of course) with the password of the Sysadm ID on it. I'd then do what I needed to, tell them I'd finished [...]
8201 244 33_Re: DB2 z/OS auditing SYSADM use?10_Roger Hecq18_Roger.Hecq@UBS.COM31_Mon, 10 Aug 2009 11:50:15 -0400382_us-ascii Visit our website at http://www.ubs.com
This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. [...]
8446 308 33_Re: DB2 z/OS auditing SYSADM use?19_Prasad Rao Mocharla19_mocharlap@YAHOO.COM31_Mon, 10 Aug 2009 11:00:00 -0700596_utf-8 Hi, This depends on the activities that a DBA haves to perform. Some of the shops prefer to have permanent SYSADM to all the DBA's Irrespective of their roles or DBAs. In those shops DBAs (with no distinction) may be supporting Application in production/development (Application DBA); alongside doing some the system programmers activates. My view is a DBA supporting only application and development teams don't need this Access. Similarly the DBA who is doing data molding work also won't need this. These roles must not be attached to any individuals Id. I [...]
8755 157 34_[Semi-OT] "Relearning Programming"14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Mon, 10 Aug 2009 14:47:08 -0400614_us-ascii Several of you have expressed interest in following my blog about re-educating myself in non-mainframe technologies. This is in response to those requests. If you're not interested, by all means use the delete key :-)
The first two entries are up now; I'd appreciate comments, especially if I forgot to tie my shoes or the literary equivalent. The entry is at http://it.toolbox.com/blogs/relearning-programming/. The entries are autobiographical in nature and discuss how I came to be doing this and why I'm making the choices I'm making - which new technologies I will pursue, in what order. [...]
8913 174 34_[Semi-OT] "Relearning Programming"14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Mon, 10 Aug 2009 14:47:08 -0400613_us-ascii Several of you have expressed interest in following my blog about re-educating myself in non-mainframe technologies. This is in response to those requests. If you're not interested, by all means use the delete key :-)
The first two entries are up now; I'd appreciate comments, especially if I forgot to tie my shoes or the literary equivalent. The entry is at http://it.toolbox.com/blogs/relearning-programming/. The entries are autobiographical in nature and discuss how I came to be doing this and why I'm making the choices I'm making - which new technologies I will pursue, in what order [...]
9088 193 38_Re: [Semi-OT] "Relearning Programming"13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Mon, 10 Aug 2009 15:28:11 -0500611_ISO-8859-1 Thanks for the link Phil.
Willie
Sevetson, Phil wrote: > > Several of you have expressed interest in following my blog about > re-educating myself in non-mainframe technologies. This is in > response to those requests. If you're not interested, by all means > use the delete key :-) > > > > The first two entries are up now; I'd appreciate comments, especially > if I forgot to tie my shoes or the literary equivalent. The entry is > at http://it.toolbox.com/blogs/relearning-programming/. The entries > are autobiographical in nature and discuss how I came to be doing this > and [...]
9282 304 38_Re: [Semi-OT] "Relearning Programming"15_Tonmoy Dasgupta28_tonmoy.dasgupta@ARKANSAS.GOV31_Mon, 10 Aug 2009 16:12:04 -0500527_us-ascii Very readable Phil... I am waiting for your next post.
Tonmoy.
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sevetson, Phil Sent: Monday, August 10, 2009 1:47 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] [Semi-OT] "Relearning Programming"
Several of you have expressed interest in following my blog about re-educating myself in non-mainframe technologies. This is in response to those requests. If you're not interested, by all means use the delete key :-) [...]
9587 44 50_REX routine to create dsn1copy jcl for a database.9_Dee Reins21_rcwingman@COMCAST.NET31_Mon, 10 Aug 2009 23:42:36 +0000573_utf-8
Does anyone know where i could find a Rexx routine or something like that , that would build DSN1COPY JCL from one database to another?
Thanks Dee
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *
_____________________________________________________________________
IDUG Europe Attendee Testimonial- "This was definitely the best IDUG conference I have ever attended." _____________________________________________________________________
9632 207 40_Re: Can Db2 z/os access Sql Server 2005?14_Walter Trovijo18_wtrovijo@GMAIL.COM31_Mon, 10 Aug 2009 22:29:01 -0300377_windows-1252 Scott,
You need at least one DB2 UDB server - I think all editions will work for this purpose - to do this; from there you create a database and then oledb table functions that will map to sql server tables. DB2 ZOS will then be the UDB client. Ive used it to access Oracle databases from ZOS apps but I believe mssql would work pretty much the same. [...]
9840 98 54_Re: REX routine to create dsn1copy jcl for a database.14_Walter Trovijo18_wtrovijo@GMAIL.COM31_Mon, 10 Aug 2009 22:49:21 -0300270_ISO-8859-1 Dee,
Ive some code that does not generate any jcl but does dsn1copy directly from rexx. Its not ready to use in other environments but - in my opinion - its quite easy to be changed to work for you. If you want to have a copy, pls let me know. [...]
9939 109 21_Re: DB2 9 Family Test16_Gregory Palgrave28_gpalgrave@STAFF.IINET.NET.AU31_Tue, 11 Aug 2009 10:09:33 +0800806_utf-8 For those that are interested, I came across these just the other day (LUW biased I think):
DB2 9 Fundamentals certification 730 prep series http://www.ibm.com/developerworks/offers/lp/db2cert/db2-cert730.html
DB2 9 Database administration 731 certification prep series http://www.ibm.com/developerworks/offers/lp/db2cert/db2-cert731.html
More info on certifications resources can be found here:
DB2 9 certification: Everything you need to know: http://www.ibm.com/developerworks/data/library/techarticle/dm-0401fosdick/
Cheers
Greg
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Barbara Koenen Sent: Monday, 10 August 2009 9:41 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 9 Family Test [...]
10049 161 54_Re: REX routine to create dsn1copy jcl for a database.12_Fay, Colin M13_CFay@UNUM.COM31_Tue, 11 Aug 2009 07:40:08 -0400539_us-ascii
I have some rexx routines driven by ISPF panels that do just that
Some of it is site specific (ssid for example) , so you will have to rework that.
Contact me direactly if you want to look at this
Colin
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Dee Reins Sent: Monday, August 10, 2009 7:43 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] REX routine to create dsn1copy jcl for a database. [...]
10211 114 65_Experience with SMS controlled datasets for catalog and directory21_Clark, Tony (Anthony)31_Anthony.Clark@TXDPS.STATE.TX.US31_Tue, 11 Aug 2009 07:16:31 -0500533_us-ascii Greetings to all:
We are considering converting all catalog and directory datasets to SMS control to eliminate down time for EXTEND failure errors. My question is what are the downsides to this move? What problems can we expect to encounter?
Thanks.
Tony Clark Database Administrator Texas Department of Public Safety (512) 424-5109
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...]
10326 57 33_Re: DB2 z/OS auditing SYSADM use?11_Mukesh Jain21_jain.mukesh@AOINS.COM31_Tue, 11 Aug 2009 12:40:09 +0000421_utf-8 At our site we had secondary auth id as SYSADM which is RACF group. Our schedular was connected to that group and no one had access to that group. Similarly we had couple of RACF groups for each database, one only select access, one will select insert, update and one with SYSADM. There was one database per application and per country. So if someone get access it is limited to his application database only. [...]
10384 36 54_Re: REX routine to create dsn1copy jcl for a database.11_Mukesh Jain21_jain.mukesh@AOINS.COM31_Tue, 11 Aug 2009 12:56:25 +0000439_utf-8 I have some REXX routine to generate the DSN1COPY JCL. That works for clonning one databse to another database in the same DB2 subsystem or different DB2 subsytem if you have CDB entry to connect those DB2 subsystems.
You need to provide input as source database name, target database name, source DB2 subsytem, target DB2 subsystem and image high level qualifier of the imagecopy dataset name and it will build the JCL. [...]
10421 150 21_Re: DB2 9 Family Test16_Mark Labby - AES21_mlabby@AESSUCCESS.ORG31_Tue, 11 Aug 2009 09:04:35 -0400
10572 436 69_Re: Experience with SMS controlled datasets for catalog and directory16_Broyles, Carol L27_Carol.L.Broyles@ACS-INC.COM31_Tue, 11 Aug 2009 08:58:51 -0500522_us-ascii Tony,
We manage all our catalog and directory datasets on SMS volumes. I'm not sure if there are any downsides, but we keep each DB2 system (or group) on its own DASD. User data goes in a separate SMS group on separate DASD volumes but in the same ICF catalog as the catalog and directory. Active logs and bsds are kept separate on their own DASD volumes, SMS group, and ICF catalog. We do this for recoverability using BACKUP/RESTORE SYSTEM and also to facilitate cloning of systems. [...]
11009 357 69_Re: Experience with SMS controlled datasets for catalog and directory16_Broyles, Carol L27_Carol.L.Broyles@ACS-INC.COM31_Tue, 11 Aug 2009 08:58:51 -0500506_us-ascii Tony,
We manage all our catalog and directory datasets on SMS volumes. I'm not sure if there are any downsides, but we keep each DB2 system (or group) on its own DASD. User data goes in a separate SMS group on separate DASD volumes but in the same ICF catalog as the catalog and directory. Active logs and bsds are kept separate on their own DASD volumes, SMS group, and ICF catalog. We do this for recoverability using BACKUP/RESTORE SYSTEM and also to facilitate cloning of systems. [...]
11367 227 21_Re: DB2 9 Family Test12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 11 Aug 2009 15:12:30 +0000415_utf-8 I sent a note to Roger Sanders, who responded ...
I went out there and tried to post a comment, but for some reason the system would not let me post. Anyway, the DB2 9 Fundamentals exam is supposed to cover all platforms, but it does tend to be more LUW centric. During the exam development process, we had z/OS people on the team who would comment if an exam question was not applicable to z/OS. [...]
11595 100 12_[z/OS] Perl?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 11 Aug 2009 12:37:52 -0400642_us-ascii Does anyone know if there's an implementation of Perl on z/OS? ("Should there be?" is a question for a different post.)
--Phil
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *
_____________________________________________________________________
IDUG Europe Attendee Testimonial- The main reason for my attendance at IDUG - Europe was general training and rekindling enthusiasm. I took away more knowledge and enthusiasm IDUG did the job!" _____________________________________________________________________
11696 65 16_Re: [z/OS] Perl?0_25_scott.taylor@AUTOZONE.COM31_Tue, 11 Aug 2009 11:54:15 -0500523_UTF-8 I think so, check here under IBM Ported Tools for z/OS:
http://www-03.ibm.com/servers/eserver/zseries/zos/unix/port_tools.html
Scott
From: "Sevetson, Phil" To: DB2-L@WWW.IDUGDB2-L.ORG Date: 08/11/2009 11:49 AM Subject: [DB2-L] [z/OS] Perl? Sent by: DB2 Data Base Discussion List
Does anyone know if there’s an implementation of Perl on z/OS? (“Should there be?” is a question for a different post.) [...]
11762 155 21_Re: DB2 9 Family Test14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 11 Aug 2009 12:48:18 -0400466_utf-8 Roger (M.),
My concern certainly isn't with Roger S.'s book -- if I gave that impression, I apologize to one and all. Although I'm struggling with the LUW materials, that's not _his_ fault. My lack of experience is the problem there.
My reference to Roger Sanders' book was due to the fact that the material he provides is my only guide to the content of the test. As such, _the content of the Fundamentals test_ is the focus of my concern. [...]
11918 179 16_Re: [z/OS] Perl?23_BOLEY Maurice C * Cliff32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Tue, 11 Aug 2009 09:51:03 -0700460_US-ASCII "Should there be?" NO, REXX is much easier to work with. Unless you enjoy cryptic languages.
ie. s/[(]+/ /g;
I inherited some Perl scripts on Windows servers and don't like working with them.
Cliff:-)
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sevetson, Phil Sent: Tuesday, August 11, 2009 9:38 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] [z/OS] Perl? [...]
12098 357 16_Re: [z/OS] Perl?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 11 Aug 2009 12:51:59 -0400432_us-ascii Yup. Ported for Unix System Services. ::sigh:: well, it's a start. Sorry, got a bit off-topic there.
________________________________ From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of scott.taylor@AUTOZONE.COM Sent: Tuesday, August 11, 2009 12:54 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] [z/OS] Perl?
I think so, check here under IBM Ported Tools for z/OS: [...]
12456 282 29_AW: [DB2-L] DB2 9 Family Test12_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 11 Aug 2009 19:03:12 +0200409_iso-8859-1 Okay Roger, but are you still know that of lot of people are going to Oracle 11g ? Better support - YES- Better database engine: YES. It seems over the year IBM has a real problem - do you agree ? I think not......................
My management decides to go in the direction of ORACLE - on LINUX. So if you can, please give some GOOD arguments this managament againts the path........ [...]
12739 368 16_Re: [z/OS] Perl?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 11 Aug 2009 13:10:28 -0400388_us-ascii I like REXX, don't get me wrong. But it's a hard sell to the college IT crowd these days to get them to dump all the LUW knowledge they've picked up in their Computer Science courses and start essentially all over with the mainframe. I'm thinking about IBM's strategic direction and the fact that most universities aren't teaching mainframe skills in undergraduate courses. [...]
13108 282 29_AW: [DB2-L] DB2 9 Family Test12_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 11 Aug 2009 19:11:05 +0200364_iso-8859-1 Just an addional mail, to Roger.
Okay, IBM has been the mayor player in the database market. And now - for me, it seems- they are install functions, that Oracle had sincemthe 90'es.... PLEASE GIMME SOME GOOD ADVICES TO STAY AT DB2 FOR z/OS - okay ?
Thanks in advance for any information you are willing to pass along. [...]
13391 82 36_Re: SQL to remove dupes. [ WITH UR ]14_Larry Kintisch17_LKint@VERIZON.NET31_Tue, 11 Aug 2009 13:43:46 -0400332_us-ascii Hi Bill,
When you have specified "small" locks [ ROW or PAGE ] and you are doing a "read" operation [SELECT or searching for rows to change] then ISOLATION LEVEL comes into effect. This is normally specified at the BIND PACKAGE process [and the ISOLATION LEVEL for a package can be seen in the Package catalog. [...]
13474 36 76_Re: AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Tue, 11 Aug 2009 19:01:06 +0100426_utf-8 Did anyone else notice that Bud is out of the office? ;-)
Aurora Emanuela Dell'Anno CA Sr. Engineering Services Architect Tel: +44 (0)1753 577 733 Mobile: +44 (0)7768 235 339 Aurora.Dellanno@ca.com
please don't print this e-mail unless you really need to!
IDUG Europe 2009 - Rome, Italy - October 5-9, 2009 http://IDUG.ORG/EU [...]
13511 62 50_DB2 9 z/OS Conversion Mode ... 25% inDB2-CPU spike12_Kapil Mathur25_kapilmathur2000@YAHOO.COM31_Tue, 11 Aug 2009 18:07:06 +0000415_utf-8 Hi Listers,
My site just migrated our DB2 subsystems from DB2 V8 NFM to DB2 9 Conversion Mode uneventfully ... except for one vendor-written online application , which saw a 25% immediate jump in-DB2-CPU time .... which went down immediately, back to V8-CPU-usage levels the instant I reorganized and ran runstats on all the tablespaces associated with this application after we were in DB2 9 CM. [...]
13574 43 76_Re: AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)12_Cuneyt Goksu22_cuneyt.goksu@GMAIL.COM31_Tue, 11 Aug 2009 18:07:48 +0000631_utf-8 Aurora,
His setting is already set to NOMAIL ;-)
Cuneyt
AVEA BlackBerry® Servisi ile gönderildi.
-----Original Message----- From: "Dell'Anno, Aurora"
Date: Tue, 11 Aug 2009 19:01:06 To: Subject: Re: [DB2-L] AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)
Did anyone else notice that Bud is out of the office? ;-)
Aurora Emanuela Dell'Anno CA Sr. Engineering Services Architect Tel: +44 (0)1753 577 733 Mobile: +44 (0)7768 235 339 Aurora.Dellanno@ca.com [...]
13618 112 76_Re: AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)10_Roger Hecq18_Roger.Hecq@UBS.COM31_Tue, 11 Aug 2009 14:08:17 -0400463_iso-8859-1 Who / where in the world is Bud Greenman? Fortunately, the messages have stopped.
Roger Hecq MF IB USA DB Support 203-719-0492 / 19-337-0492
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Dell'Anno, Aurora Sent: Tuesday, August 11, 2009 2:01 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009) [...]
13731 187 33_Re: AW: [DB2-L] DB2 9 Family Test17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Tue, 11 Aug 2009 19:09:07 +0100373_utf-8 Georg,
I am sure any of your Mainframe vendors for DB2 Tools and Utilities (as well as the base-software suppliers IBM), will help you guys create a GREAT TCO study / paper, to demonstrate how the mainframe works out more reliable and cheaper (both per user and per SLA breach)...
Start calling or emailing them and ask for their help, sofort! :-) [...]
13919 471 36_Re: CA IDUG Award for DB2 - Criteria17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Tue, 11 Aug 2009 19:11:42 +0100439_utf-8 Thanks very much Dee, I only look at the list emails in the evening and was going to give exactly this reply just now!
I believe my colleague Adam Frary is also replying to Tonmoy offline.
Thanks again!
Aurora Emanuela Dell'Anno CA Sr. Engineering Services Architect Tel: +44 (0)1753 577 733 Mobile: +44 (0)7768 235 339 Aurora.Dellanno@ca.com [...]
14391 55 76_Re: AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Tue, 11 Aug 2009 19:12:25 +0100370_utf-8 Are you SERIOUS? Then why did we get the out of office message about 23 times, twice over? :-)
Aurora Emanuela Dell'Anno CA Sr. Engineering Services Architect Tel: +44 (0)1753 577 733 Mobile: +44 (0)7768 235 339 Aurora.Dellanno@ca.com
please don't print this e-mail unless you really need to! [...]
14447 84 76_Re: AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Tue, 11 Aug 2009 19:12:59 +0100358_utf-8 I guess if I had any holiday I'd also try and make a point of gloating about it...
Aurora Emanuela Dell'Anno CA Sr. Engineering Services Architect Tel: +44 (0)1753 577 733 Mobile: +44 (0)7768 235 339 Aurora.Dellanno@ca.com
please don't print this e-mail unless you really need to! [...]
14532 61 76_Re: AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 11 Aug 2009 14:19:15 -0400450_utf-8 That was _before_ they set him to nomail! :-)
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Dell'Anno, Aurora Sent: Tuesday, August 11, 2009 2:12 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)
Are you SERIOUS? Then why did we get the out of office message about 23 times, twice over? :-) [...]
14594 24 76_Re: AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Tue, 11 Aug 2009 18:22:20 +0000402_- >Are you SERIOUS? Then why did we get the out of office message about 23 times, twice over? :-)
If you read the text of the message, you were told that you'd receive a response for each e-mail you sent. - Too busy driving to stop for gas!
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...]
14619 40 76_Re: AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Tue, 11 Aug 2009 19:28:15 +0100330_utf-8 Yes Ted thanks, I did (and whistled to myself, since most systems I know only send one message a day or summat),
But my question was why are we receiving the emails, if he has been set to NOMAIL - and I know it's not Friday, but it was meant as a bit of banter with Cuneyt in his function as DB2-L volunteer :-D [...]
14660 190 76_Re: AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)14_M. Khalid Khan24_Mohammad_Khan@BCBSIL.COM31_Tue, 11 Aug 2009 13:43:24 -0500519_utf-8
HCSC Company Disclaimer
The information contained in this communication is confidential, private, proprietary, or otherwise privileged and is intended only for the use of the addressee. Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately at (312) 653-6000 in Illinois; (800)835-8699 in New Mexico; (918)560-3500 in Oklahoma; or (972)766-6900 in Texas. [...]
14851 180 25_Re: CA IDUG Award for DB216_Mark Labby - AES21_mlabby@AESSUCCESS.ORG31_Tue, 11 Aug 2009 15:44:25 -0400
15032 592 25_Re: CA IDUG Award for DB215_Tonmoy Dasgupta28_tonmoy.dasgupta@ARKANSAS.GOV31_Tue, 11 Aug 2009 15:36:02 -0500470_us-ascii Wow... our solutions look so small against the grand scale of the AXA effort.
Yours humbled,
Tonmoy
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mark Labby - AES Sent: Tuesday, August 11, 2009 2:44 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] CA IDUG Award for DB2
Tonmoy,
The winner of the last award was AXA Technology. http://www.ca.com/us/press/release.aspx?cid=208317 [...]
15625 66 26_Re: OT - DB2 9 Family Test22_Leslie Pendlebury-Bowe21_db2dba@BTINTERNET.COM31_Tue, 11 Aug 2009 21:43:51 +0100287_us-ascii Guys (Marked off topic just incase I get hung for hijacking the thread)
I've done most of the tests down the years Phil and I agree with you on all your comments, luckily I've worked on all the platforms since version 1, thanks be that I did or I would have failed. [...]
15692 87 27_Re: SQL to remove dupes. ??23_Barutcu, Cuneyt (SPFLD)27_Cuneyt.Barutcu@ILLINOIS.GOV31_Tue, 11 Aug 2009 16:03:51 -0500325_us-ascii UR stands for Uncommitted Read also known as the "dirty read". It is one of the isolation levels in DB2. It will allow you to read the data that is not yet committed. Below is a link that describes the isolation levels in detail. Craig Mullins describes the UR and other isolation levels in pretty good detail. [...]
15780 122 54_Re: DB2 9 z/OS Conversion Mode ... 25% inDB2-CPU spike12_Myron Miller22_myronwmiller@YAHOO.COM31_Tue, 11 Aug 2009 14:54:51 -0700674_utf-8 Remember that in DB2 V9, the optimizer depends much much more on distribution and more comprehensive stats than even V8 did. So it's entirely possible that the optimizer chose different access paths without good stats than V8 did. No surprise there. Somewhere I remember seeing some of the documentation for V9 that stated over and over get your stats complete and in order. If not, expect some regression issues. Myron ________________________________ From: Kapil Mathur To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Tuesday, August 11, 2009 2:07:06 PM Subject: [DB2-L] DB2 9 z/OS Conversion Mode ... 25% inDB2-CPU spike Hi Listers, My site just [...]
15903 287 21_Re: DB2 9 Family Test12_Myron Miller22_myronwmiller@YAHOO.COM31_Tue, 11 Aug 2009 15:02:58 -0700540_utf-8 Roger, How does this relate to the issue of Z/OS people needing to learn LUW? Great advertisement for book. But still, if we're only Z/OS and never will be or have been LUW people do we need to know anything at all about LUW for any part of the exam? That's the real question here that people are asking! Certainly there are a number of very good study guides or courses that will assist you in taking the tests. But for those of us that only use Z/OS materials, this means that a portion of the Fundamentals test has absolutely [...]
16191 118 43_Re: Performance issue with a delete process14_Larry Kintisch17_LKint@VERIZON.NET31_Tue, 11 Aug 2009 20:41:46 -0400505_us-ascii Hi Kals,
I've read the later replies to this post. To analyze your problem, we need to know a few more facts. On the DELETEd table, how many indexes are there? Which is the CLUSTER index? What are the key sizes for each index? What are the freespace settings for each index? How often is the table reorganized and/or how often are the indexes [alone] reorganized? What is the frequency of running the DELETE-PROC and in that time period what is the estimated number of rows inserted? [...]
16310 208 43_Re: Performance issue with a delete process10_Teldb2kals22_teldb2kals@TELSTRA.COM31_Wed, 12 Aug 2009 06:03:59 +0000502_utf-8 Hi Larry,
Thanks for your response. I was hoping for somebody to provide some clue as to why the behaviour is like this, or if I am missing something simple. I will try to provide you the infm you asked for.
Indexes : I have now experienced the problem with 3 tables, and have (temporarily) moved them all to reorg discard. One of them has 6 indexes, another has 4 and another has 3. Each of the tables has one of the indexes pointing to the timestamp field used for deletion. [...]
16519 207 43_Re: Performance issue with a delete process0_22_agentlease@HOTMAIL.COM31_Wed, 12 Aug 2009 13:40:48 +0100494_UTF-8 Hi,
One way I resolved this was to extract the rows to be deleted from the table and build a temporary table and then drive the delete from this temporary table. This fixed my problem as I got a hang like you.
Thanks.
----- Original Message ----- From: "Teldb2kals" Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, August 12, 2009 7:03 AM Subject: Re: [DB2-L] Performance issue with a delete process [...]
16727 102 43_Re: Performance issue with a delete process12_Isaac Yassin20_yassini@BEZEQINT.NET31_Wed, 12 Aug 2009 15:55:44 +0300377_iso-8859-1 Hi,
Much easir is to find the start timestamp from which to delete and do 24 deletes in a loop based on "BETWEEN" of 1 hour interval starting from the calculated start. if 1 hour is too much, do it in 48 intervals of 30 minutes each, or 288 intervals of 5 minutes .... No need for comlicated SQL to calculate time and again the entry point for deletion. [...]
16830 42 54_Re: DB2 9 z/OS Conversion Mode ... 25% inDB2-CPU spike11_Mukesh Jain21_jain.mukesh@AOINS.COM31_Wed, 12 Aug 2009 15:11:31 +0000374_utf-8 We have migrated to DB2 v9 NFM and we saw drastic increase in CPU for SAP application and that was gone once we did runstats or rerg on some highly used tablaspaces. In DB2 v9 there are many changes for the statistics and internal structure. Since you are using dynamic SQLs you can expect those spikes as the new optimizer expect the new statistics with DB2 v9. [...]
16873 130 54_Re: DB2 9 z/OS Conversion Mode ... 25% inDB2-CPU spike15_Patrick Bossman25_patrick.bossman@GMAIL.COM31_Wed, 12 Aug 2009 16:12:03 +0000323_UTF-8 Hello, The only way to know the root cause of your regression would be to do a performance analysis of the particular query. Hopefully the rest of this note will still be useful in explaining what we observe, and why different solutions can be effective and what solutions I would expect might not be effective. [...]
17004 31 54_Re: DB2 9 z/OS Conversion Mode ... 25% inDB2-CPU spike12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Wed, 12 Aug 2009 11:42:36 -0500434_UTF-8 If bind / rebind management surprises are a problem, may I suggest a workshop at IOD in Las Vegas that Jay Bruce and I are doing. It is on Tuesday afternoon, October 27th. It will be a hands on laboratory for IBM's DB2 Tools: Bind manager and Path Checker. We will show how these tools may assist you in reducing your exposure to these risks in both DB2 Migrations and your standard application migrations into production. [...]
17036 39 23_DB2 DISCARD recognition11_Mark Kerner18_Mark.Kerner@PB.COM31_Wed, 12 Aug 2009 17:40:56 +0000385_utf-8 Hi all,
Other than using a “DISCARDS 1” parameter in a DB2 utility LOAD step (assuming more than one record is discarded), is there a way to get some notification from the load step that alerts someone to the fact that there were records discarded due to bad data (e.g. conversion errors), but allows the load to execute, so that they can take subsequent action? [...]
17076 36 27_Re: DB2 DISCARD recognition14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Wed, 12 Aug 2009 13:46:38 -0400392_utf-8 What we do here is just read a single record from the discard file. If it's not EOF, we send email to the affected parties.
--Phil Sevetson
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mark Kerner Sent: Wednesday, August 12, 2009 1:41 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 DISCARD recognition [...]
17113 505 28_(off topic) LISTSERV mystery17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Wed, 12 Aug 2009 18:49:56 +0100331_iso-8859-1 Dear lists,
I need your help, please!
you MAY have noticed that basically if you get the digest version of the list's day, my email come out in some mysterious language from outer space, as well as "plain" English (although of course my English is beautiful and most interesting, if I say so myself). [...]
17619 893 25_Re: CA IDUG Award for DB217_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Wed, 12 Aug 2009 18:52:27 +0100805_us-ascii Wow guys you really do my day's work for me J
Thanks!
Aurora Emanuela Dell'Anno CA Sr. Engineering Services Architect Tel: +44 (0)1753 577 733 Mobile: +44 (0)7768 235 339 Aurora.Dellanno@ca.com
P please don't print this e-mail unless you really need to!
IDUG Europe 2009 - Rome, Italy - October 5-9, 2009
http://IDUG.ORG/EU
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Tonmoy Dasgupta Sent: 11 August 2009 21:36 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] CA IDUG Award for DB2 [...]
18513 76 26_Re: OT - DB2 9 Family Test17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Wed, 12 Aug 2009 18:58:40 +0100534_utf-8 Well,
Do you remember Mr. Vassie?
I hope he will not mind me quoting an email he sent me around Feb. of this year:
"SQL Server can be fun! One major feature for the next release is a formalisation of support for shared nothing. This is a concept very new to SQL Server people, but I am glad I kept my late 90's notes about DB2/PE and DB2 LUW as this makes me an expert on the new stuff. This keeps happening :) so any DB2 expert who suddenly finds they cannot learn anything new can make a good living [...]
18590 78 8_DSNHDECP14_Renzo razzetti24_renzo.razzetti@GMAIL.COM31_Wed, 12 Aug 2009 15:19:07 -0300543_ISO-8859-1 Hello
We have many DB2 subsystems. And we have the following libraries. * SYS1.DSNxxx.SDSNEXIT SYS1.DSNxxx.SDSNLINK SYS1.DSNxxx.SDSNLOAD *
At the SDSNLOAD we have one ZPARM for each DB2 subsystem. And in the SDSNEXIT we have one DSNHDECP for all the DB2 subsystem
Until now, we have working without troubles. But now we are migrating the subsystem to V8. And in the same LPAR we are migrating one by one. And the problem we have is becuasse we have only one DSNHDECP for all the subsystem. [...]
18669 696 32_Re: (off topic) LISTSERV mystery10_Roger Hecq18_Roger.Hecq@UBS.COM31_Wed, 12 Aug 2009 14:23:48 -0400382_us-ascii Visit our website at http://www.ubs.com
This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. [...]
19366 1238 32_Re: (off topic) LISTSERV mystery17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Wed, 12 Aug 2009 19:32:00 +0100440_iso-8859-1 I suspected as much Roger, but the original of the message was in plain text!
What I am waiting for, is the digest, tomorrow, to see how THAT came out from the webmail server (which is not an Exchange 2007 job)...
Marketing ploy? Hmmm... (actually the sequence is ICAg) - and what gets me is that it is not hex, and I will be happier when I understand what alien language it is [...]
20605 216 12_Re: DSNHDECP12_Mark Vickers26_MarkVickers@GROCERYBIZ.COM31_Wed, 12 Aug 2009 13:39:21 -0500449_US-ASCII Renzo, I had the same situation for v8. Since you share load libs on an LPar, you are going to need a new/different set of load libraries for the v8 subsystems, so that is where you should put your DSNHDECP for v8. When doing this, if you use the LINKLIST as we do, we had to remove these from the LINKLIST and JOBLIB/steplib everything and it's dog, cat and canary. I will try to avoid that situation next time around ! Mark Vickers. [...]
20822 44 12_Re: DSNHDECP11_Mukesh Jain21_jain.mukesh@AOINS.COM31_Wed, 12 Aug 2009 18:43:50 +0000567_utf-8 Hi Renzo, You can nore have different name for DSNHDECP. DB2 need the name as DSNHDECP as i know. Please correct me anyone if i am wrong. With the DB2 v8 IBM is getting rid of DSNHDECP in SDSNLOAD. I believe you are doing the reverse of the normal practice for maintaing the SDSNEXIT and SDSNLOAD. Generally you have one SDSNEXIT per DB2 subsytem which containd ZPARM, DSNHDECP and any user written exit routines. and Common SDSNLOAD for all the DB2 subsytems. I think you should have one DSNHDECP per DB2 subsytem and put it into SDSNEXIT and concat that [...]
20867 330 21_Re: DB2 9 Family Test12_tim malamphy20_timalamphy@YAHOO.COM31_Wed, 12 Aug 2009 15:12:48 -0700599_utf-8 I beg to differ, and defend this apparrently unpopular practice.
The test title does say FAMILY test. If I was taking a test on the Addams Family, I'd expect to have to know a little about Gomez, Morticia, Uncle Fester, Pugsly and Wednesday...and maybe even Lurch. Besides, the test seems structured that if you are truly an expert in one area, you can blow another part and still pass. There are all these pesky LUW products littering our corporate hardware landscape that have DB2 in the name somewhere, and which allow new whiz-bang technology like websphere and App Servers to [...]
21198 276 32_Re: (off topic) LISTSERV mystery14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Thu, 13 Aug 2009 08:31:17 +1000641_US-ASCII The problem is that your mail program decides to encode your (Aurora's) text as base64 - note these headers which appear in your undigested messages:
Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64
Basic SMTP, the standard internet protocol for email, allows only 7-bit characters, the high order bit must be off. Base64 takes 3 bytes, which might have the high order bit turned on, and recasts them as 4 bytes, which don't. From memory, all you need to do to translate the stuff below into something readable is take the bottom 6 bits of each character in its ASCII encoding, do that [...]
21475 432 21_Re: DB2 9 Family Test12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 12 Aug 2009 16:16:00 -0700563_utf-8 It's amazing, I've been able to allow the new "whiz-bang" technology to connect to the Z/OS mainframe for years without any and I do mean not any LUW databases creeping in. Zero, nada, zip. DB2 connect is another story. But that's a communication product and not LUW. No LUW features have been used or needed for the last X years where X is very large. Oracle, SQL Server, Oracle Gateway, DB2 connect, weblogic, java, XML true, but not one LUW DB. Guess my clients over the last number of years have been unique. And they've been well in the forefront [...]
21908 152 62_AW: [DB2-L] DB2 9 z/OS Conversion Mode ... 25% inDB2-CPU spike35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM31_Thu, 13 Aug 2009 10:22:03 +0200489_iso-8859-1 Hi Pat
You say, you ask customer to collect additional statistics or all the statistics, runstats can collect. I don't know, how other companies run their runstats, but we run runstats always as inline stats as a part of the reorg process. But then, you cannot collect all the stats, which might be necessary, e.g histogram statistics or even worse, because we run our reorgs always on a partition level, no runstats is ever be executed for non partitioned indexes. [...]
22061 480 79_Antwort: [DB2-L] AW: [DB2-L] DB2 9 z/OS Conversion Mode ... 25% inDB2-CPU spike11_Roy Boxwell16_R.Boxwell@SEG.DE31_Thu, 13 Aug 2009 10:28:54 +0200418_ISO-8859-1 Start dangerous plug
or you buy a tool that can do that!
/plug
Doing anything like this manually is just not worth it or as a colleague would say "So last century..."
Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Strae 5 40470 Dsseldorf/Germany Tel. +49 (0)211 96149-675 Fax +49 (0)211 96149-32 Email: R.Boxwell@seg.de http://www.seg.de [...]
22542 172 26_Re: OT - DB2 9 Family Test22_Leslie Pendlebury-Bowe21_db2dba@BTINTERNET.COM31_Thu, 13 Aug 2009 09:58:26 +0100288_iso-8859-1 Hi Aurora
Yes I tend always think that knowing "z" is a good thing and puts me way ahead of the chasing pack ... :-)
However, I would have thought people would have a greater opinion of what I said ... maybe I'm the only one that thinks the way I do. :-)))) [...]
22715 123 12_Re: DSNHDECP14_Renzo razzetti24_renzo.razzetti@GMAIL.COM31_Thu, 13 Aug 2009 09:45:09 -0300572_windows-1252 Are you are sure DB2 need the name "DSNHDECP" ?
On Wed, Aug 12, 2009 at 3:43 PM, Mukesh Jain wrote:
> Hi Renzo, > You can nore have different name for DSNHDECP. DB2 need > the name as DSNHDECP as i know. Please correct me anyone if i am > wrong. > With the DB2 v8 IBM is getting rid of DSNHDECP in SDSNLOAD. > I believe you are doing the reverse of the normal practice for maintaing > the > SDSNEXIT and SDSNLOAD. Generally you have one SDSNEXIT per DB2 > subsytem which containd ZPARM, DSNHDECP and [...]
22839 327 20_AW: [DB2-L] DSNHDECP12_Peter, Georg15_G.Peter@DZBW.DE31_Thu, 13 Aug 2009 14:58:53 +0200920_iso-8859-1 >> Are you are sure DB2 need the name "DSNHDECP" ?<<
Renzo,
the answer is "YES" because
1. A DSNHDECP macro is generated as a part of installing or migrating DB2.
2. The DSNHDECP module that is supplied by DB2 is being used to run the DB2 precompiler.
3. etc. etc.
HTH.
With kind regards - mit freundlichen Gruessen, G e o r g H . P e t e r ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Development and Product Support (E3) Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, Europe e:mail G.Peter@dzbw.de Phone 0049-711-8108-271 PC-Fax 004971189696071 Internet (only in german language):http://www.dzbw.de ---------------------------------------------------------------------- THINK GREEN [...]
23167 29 12_Re: DSNHDECP11_Mukesh Jain21_jain.mukesh@AOINS.COM31_Thu, 13 Aug 2009 13:16:31 +0000452_utf-8 No you can not have different name for DSNHDECP. You can search the old post with DSNHDECT someone tried with it and DB2 was always starting with defaukt name DSNHDECP so i believe that you can't have diffrenet name.
Thanks Mukesh Jain Senior DB2 DBA & System programmer (517) 9801064
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...]
23197 250 66_Re: AW: [DB2-L] DB2 9 z/OS Conversion Mode ... 25% inDB2-CPU spike13_Terry Purcell18_tpurcel@US.IBM.COM31_Thu, 13 Aug 2009 13:17:44 +0000432_utf-8 Hi Walter (and all),
The original question was effectively: "why did I see the regression/why did REORG/RUNSTATS fix it?". And Pat correctly pointed out - we can give you "guesses", but the only way to give a definitive answer is to look at the specific case in detail. Just the same as if you phoned your mechanic to say your car is making a funny noise. He/she would need to see the car to diagnose the problem. [...]
23448 278 43_Re: Performance issue with a delete process13_Terry Purcell18_tpurcel@US.IBM.COM31_Thu, 13 Aug 2009 14:11:15 +0000424_utf-8 Hi Kals,
You were hoping for some clue as to why this degrades. OK, I'll bite, with a possible theory (ie. a guess).
The way the query is written:
SELECT TSfield,ROW# FROM table1 A, TABLE (SELECT COUNT(*)+1 ROW# FROM table1 B WHERE B.TSfield
1) I don't know where you're working, but in the last eight places I worked, only four had _any_ UDB LUW, and only two of those had a _significant_ LUW presence, defined as more than one instance, and application development taking place. And none of the four let z/OS DBAs anywhere near their distributed systems. [...]
23969 43 52_Awareness of some V9 CM compatibility issues with V85_Larry34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM31_Thu, 13 Aug 2009 11:19:56 -0500323_us-ascii As we are currently installing V9, I am becoming very aware of some new features that are becoming available in CM (as they should) and others that do not become available (also, by design).
One feature that seems to me to be in the "grey area" is that I can code the following SQL statement in V9 CM: [...]
24013 77 56_Re: Awareness of some V9 CM compatibility issues with V814_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Thu, 13 Aug 2009 12:31:58 -0400517_us-ascii Hard to find but easy to fix, eh?
--Phil
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Larry Sent: Thursday, August 13, 2009 12:20 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Awareness of some V9 CM compatibility issues with V8
As we are currently installing V9, I am becoming very aware of some new features that are becoming available in CM (as they should) and others that do not become available (also, by design). [...]
24091 220 43_Re: Performance issue with a delete process14_Larry Kintisch17_LKint@VERIZON.NET31_Thu, 13 Aug 2009 12:58:32 -0400335_us-ascii Hi Kals, I'm a bit busy and it may take a while for me to get back to you. I tried to reach you directly via your email but it bounced back.
I'd like to make some suggestions, but I need a few more things, off list.
What is the CLUSTER-Ratio of the TStamp index [correlation to the actual Cluster columns]? [...]
24312 100 56_Re: Awareness of some V9 CM compatibility issues with V810_Todd Burch17_toddburch@MAC.COM31_Thu, 13 Aug 2009 13:56:30 -0500664_US-ASCII Here's a technote I wrote about one positive aspect that came about from the V9 parser generator change.
http://www-01.ibm.com/support/docview.wss?rs=64&context=SSEPEK&dc=DB560&dc=DB520&q1=parser&uid=swg21383935&loc=en_US&cs=utf-8&lang=en
Todd DB2 for z/OS Level 2
On Aug 13, 2009, at 11:31 AM, Sevetson, Phil wrote:
Hard to find but easy to fix, eh?
--Phil
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Larry Sent: Thursday, August 13, 2009 12:20 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Awareness of some V9 CM compatibility issues with V8 [...]
24413 37 86_How to move all the Tasks in the DB2 Task Centre Tools database to a new blade server?14_Brenda Boshoff21_b.boshoff@UTORONTO.CA31_Thu, 13 Aug 2009 15:25:51 -0400511_us-ascii Hi,
How would our DB2 systems programmer move all the tasks we have currently setup in our DB2 v8.1 on Zseries Tools database to a new DB2 Tools database on a blade server running DB2 v9.7? We are so badly cpu constrained on the existing zseries IFL that it takes forever to get any kind of response. What would you recommend we do to move the tasks as fast and as soon as possible? Any help would be appreciated as we have to get these databases and task centres off the old machine asap. [...]
24451 117 25_Re: CA IDUG Award for DB212_Peter Suhner24_peter_suhner@HOTMAIL.COM31_Fri, 14 Aug 2009 00:29:55 +0000341_UTF-8 Well, our project actually has been selected as the winner of the CA-IDUG Award in Dallas earlier this year. Unfortunately my managers do not (yet) allow me to freely publish the document I had handed in. But let me try to give you a quick overview of what it was about. Quick is relative, so this is going to be a lengthy one... [...]
24569 45 25_FPEU0100S in DB2PM Report13_Steve Mallett21_malutjuta@HOTMAIL.COM31_Fri, 14 Aug 2009 01:18:59 +0000434_utf-8 Hi Listers,
We get an intermitent failure with a DB2PM Audit Report on DB2 for z/OS V8.1 NFM with the following informational messages
IEF403I DB2PMJOB - STARTED - TIME=13.47.03 +FPEU0100S INFORMATION FOR PROBLEM ANALYSIS BY SUPPORT: REFERENCE IS MODULE DGOTCDIV, CODE=12 +FPEU0100S INFORMATION FOR PROBLEM ANALYSIS BY SUPPORT: REFERENCE IS MODULE DGOTCREO, CODE=12 (with last message repeated several times) [...]
24615 36 32_Sajad Javid is out of the office11_Sajad Javid19_sajad.javid@TCS.COM31_Fri, 14 Aug 2009 11:19:42 +0530660_us-ascii I will be out of the office starting 08/13/2009 and will not return until 08/17/2009.
=====-----=====-----===== Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you [...]
24652 34 54_DB2-UDB fro LUW - restarted identity column next value16_Peter Richardson27_peter.richardson@HBF.COM.AU31_Fri, 14 Aug 2009 07:10:33 +0000532_utf-8 Hiya's,
I'm tryna find the next value for an identity column in the situation where the column has been restarted with a particular value. In this case, SYSIBM.SYSSEQUENCES has the LASTASSIGNEDVALUE as null and SYSCAT.COLIDENTATTRIBUTES has NEXTCACHEFIRSTVALUE SET to the original start value (not the restart value).
I know that under z\os SYSIBM.SYSSEQUENCES has a RESTARTWITH column, but this does not appear to be the case under LUW. So how can I determine if an identity column has been restarted ...? [...]
24687 30 44_Deb Van Epps/MutualOMA is out of the office.0_30_Deb.Van.Epps@MUTUALOFOMAHA.COM31_Fri, 14 Aug 2009 05:01:02 -0500656_us-ascii I will be out of the office starting 08/13/2009 and will not return until 08/17/2009.
If you need immediate assistance please contact my manager Kevin Stettler x3185.
This e-mail and any files transmitted with it are confidential and are solely for the use of the addressee. It may contain material that is legally privileged, proprietary or subject to copyright belonging to Mutual of Omaha Insurance Company and its affiliates, and it may be subject to protection under federal or state law. If you are not the intended recipient, you are notified that any use of this material is strictly prohibited. [...]
24718 123 37_DB2 z/os v8.1 before trigger question13_Hodgin, Scott19_shodgin@SCFBINS.COM31_Fri, 14 Aug 2009 07:32:29 -0400313_us-ascii I'm trying to prevent rows from being inserted into a table based on some criteria. The Sql reference manual indicates that the transition tables cannot be altered, so it seems that I cannot intercept the rows from being inserted forcing me to create an after trigger to clean up the unwanted rows. [...]
24842 336 41_Re: DB2 z/os v8.1 before trigger question11_Mike Turner19_mike.turner@GMX.COM31_Fri, 14 Aug 2009 12:52:09 +0100420_iso-8859-1 DB2 z/os v8.1 before trigger questionHi Scott
You could use SIGNAL SQLSTATE to fail the insert. Here is an example:
CREATE TRIGGER CKAVAIL NO CASCADE BEFORE INSERT ON ORD REFERENCING NEW AS NEW_ORD FOR EACH ROW MODE DB2SQL WHEN (NEW_ORD.QUANTITY > (SELECT QTY_ON_HAND FROM PARTS WHERE PARTS.PARTNO = NEW_ORD.PARTNO)) BEGIN ATOMIC SIGNAL SQLSTATE '79001' ('Insufficient Stock'); END [...]
25179 13 63_Tomas Vasko/IEA/EAGA/EAG/AT ist au=?ISO-8859-1?Q?=DFer_?= Haus.11_Tomas Vasko23_tomas.vasko@GENERALI.AT31_Fri, 14 Aug 2009 13:57:43 +0200221_ISO-8859-1
Ich bin ab 14.08.2009 auer Haus und ab 31.08.2009 wieder im Bro. I'm out of the office from 14.08.2009 and will be back on 31.08.2009.
Ich werde Ihre Nachricht nach meiner Rckkehr beantworten.
25193 716 41_Re: DB2 z/os v8.1 before trigger question13_Hodgin, Scott19_shodgin@SCFBINS.COM31_Fri, 14 Aug 2009 08:15:56 -0400519_us-ascii Thanks for the reply Mike, but I only want _some_ of the rows to not be inserted.
Scott Hodgin
Database Administrator, MCITP South Carolina Farm Bureau Insurance Company
shodgin@scfbins.com
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mike Turner Sent: Friday, August 14, 2009 7:52 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 z/os v8.1 before trigger question [...]
25910 685 41_Re: DB2 z/os v8.1 before trigger question11_Mike Turner19_mike.turner@GMX.COM31_Fri, 14 Aug 2009 13:39:59 +0100554_iso-8859-1 DB2 z/os v8.1 before trigger questionHi Scott
That is what the WHEN clause is for. The trigger body is only executed if the WHEN condition evaluates to True.
The trigger is fired before each new row is inserted into the Order table ORD. It uses the Part Number from the new order to check the PARTS table to see if there is enough of the part on hand to meet the order. If there is not enough stock on hand for the order the INSERT statement that fired the trigger will receive SQLCODE = -438. The SQLCA SQLSTATE field will [...]
26596 1188 41_Re: DB2 z/os v8.1 before trigger question13_Hodgin, Scott19_shodgin@SCFBINS.COM31_Fri, 14 Aug 2009 08:54:59 -0400597_us-ascii I guess I'm not being clear enough.
I want to successfully insert into a table all rows EXCEPT the rows that look like blah. If the row looks like blah, don't insert and go to the next row that is being inserted.
The back story - We have a bunch of Cobol programs that are inserting what is now unnecessary data and until we can get around to addressing each of these programs, I was wanting to use a trigger to handle the deletion (or preferably the non-insertion) of the unnecessary rows, thereby reducing the amount of data that will [...]
27785 119 41_Re: DB2 z/os v8.1 before trigger question14_M. Khalid Khan24_Mohammad_Khan@BCBSIL.COM31_Fri, 14 Aug 2009 08:13:42 -0500378_iso-8859-1 So you want the rows to not get inserted but still return sqlcode zero to the program so that you don't have to change it. Stopping the insert will result in error condition so that's not an option. We don't have any equivalent of "DD DUMMY" where this insert could be redirected to. So about the only option left is to delete it in an after trigger. HTH Khalid [...]
27905 224 41_Re: DB2 z/os v8.1 before trigger question11_Mike Turner19_mike.turner@GMX.COM31_Fri, 14 Aug 2009 14:32:52 +0100633_iso-8859-1 Hi Scott
If Khalid has correctly interpreted your requirement, then I agree that you will have to delete the bad rows with an after trigger.
Regards Mike Turner Email: mike.turner@gmx.com Tel: +44 (0)1565-873702 Web: www.michael-turner.ltd.uk Michael Turner Ltd. Registered in England & Wales No. 1433722. Registered Office: 131 King Street, Knutsford, Cheshire, WA16 6EJ. VAT No. GB 338 4159 44. ----- Original Message ----- From: M. Khalid Khan Newsgroups: bit.listserv.db2-l To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Friday, August 14, 2009 2:13 PM Subject: Re: [DB2-L] DB2 z/os v8.1 before trigger question [...]
28130 635 41_Re: DB2 z/os v8.1 before trigger question13_Hodgin, Scott19_shodgin@SCFBINS.COM31_Fri, 14 Aug 2009 09:43:12 -0400643_us-ascii Yes, Khalid is interpreting my requirement correctly. I guess I was looking for the same kind of functionality afforded me in Sql Server Instead of triggers where I can control what actually gets inserted.
Scott Hodgin
Database Administrator, MCITP South Carolina Farm Bureau Insurance Company
shodgin@scfbins.com
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mike Turner Sent: Friday, August 14, 2009 9:33 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 z/os v8.1 before trigger question [...]
28766 51 23_I am out of the office.12_Mark Vickers26_MarkVickers@GROCERYBIZ.COM31_Fri, 14 Aug 2009 09:00:07 -0500449_US-ASCII
I will be out of the office starting 08/14/2009 and will not return until 08/17/2009.
I will respond to your message when I return. If you need immediate assistance, please contact Ted Flowers x6562, Ramona Kipfer x5721 or Scott Stritchko x5669. thank you, Mark Vickers.
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...]
28818 694 41_Re: DB2 z/os v8.1 before trigger question14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Fri, 14 Aug 2009 10:13:23 -0400496_us-ascii Scott:
Okay, then... why don't you _use_ an INSTEAD OF INSERT trigger to decide what rows to accept? My read of the INSTEAD OF syntax says it should be possible to drive your decisions that way,
--Phil Sevetson
________________________________ From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Hodgin, Scott Sent: Friday, August 14, 2009 9:43 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 z/os v8.1 before trigger question [...]
29513 864 41_Re: DB2 z/os v8.1 before trigger question13_Mertens, Bart18_bart.mertens@CZ.NL31_Fri, 14 Aug 2009 16:22:06 +0200698_us-ascii Phil,
INSTEAD OF is new in V9. Scott is using V8.1
Also, when using an INSTEAD OF trigger, you can't use a WHEN clause.
Bart Mertens
Van: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Namens Sevetson, Phil Verzonden: vrijdag 14 augustus 2009 16:13 Aan: DB2-L@WWW.IDUGDB2-L.ORG Onderwerp: Re: [DB2-L] DB2 z/os v8.1 before trigger question
Scott:
Okay, then... why don't you _use_ an INSTEAD OF INSERT trigger to decide what rows to accept? My read of the INSTEAD OF syntax says it should be possible to drive your decisions that way, [...]
30378 111 26_[z/OS] REORG SCOPE PENDING14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Fri, 14 Aug 2009 10:22:25 -0400402_us-ascii I'm puzzled by the behavior of REORG TABLESPACE / SCOPE PENDING under DB2V9. I thought partition level REORGs under DB2V9 automatically REORG the entire index for all nonpartitioned indexes? I'm not seeing evidence that that's happening in my REORG jobs - the SORTBLD phase only indicates as many rows as were REORGed in the affected partitions. Can anyone clarify what's happening here? [...]
30490 150 41_Re: DB2 z/os v8.1 before trigger question10_Dave Churn19_davechurn@GMAIL.COM31_Fri, 14 Aug 2009 09:23:09 -0500570_windows-1252 Listers,
On z/OS, an INSTEAD OF trigger only works on a view. Are the COBOL programs deleting from a view of the table or the actual table?
-- David Churn Database Architect, DST Systems, Inc. President, Heart of America DB2 Users Group
On Fri, Aug 14, 2009 at 9:13 AM, Sevetson, Phil wrote: > Scott: > > > > Okay, then why dont you _use_ an INSTEAD OF INSERT trigger to decide what > rows to accept? My read of the INSTEAD OF syntax says it should be possible > to drive your decisions that way, > > > > [...]
30641 899 41_Re: DB2 z/os v8.1 before trigger question13_Hodgin, Scott19_shodgin@SCFBINS.COM31_Fri, 14 Aug 2009 10:23:30 -0400353_us-ascii Ok, now I'm confused. I cannot seem to find a reference to INSTEAD OF INSERT trigger anywhere in the DB2 Sql Reference guide for DB2 z/os V8.1. I can only find examples of plain NO CASCADE BEFORE and AFTER triggers.
If this functionality actually exists in DB2 z/os v8, could someone point me to some documentation? [...]
31541 924 41_Re: DB2 z/os v8.1 before trigger question14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Fri, 14 Aug 2009 10:26:27 -0400469_us-ascii Sorry, Scott, as has been just pointed out on the List; I missed your being on DB2v8 z/OS. Also missed the small print about INSTEAD OF being valid only for views (strange).
--Phil Sevetson
________________________________ From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Hodgin, Scott Sent: Friday, August 14, 2009 10:24 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 z/os v8.1 before trigger question [...]
32466 720 41_Re: DB2 z/os v8.1 before trigger question11_Mike Turner19_mike.turner@GMX.COM31_Fri, 14 Aug 2009 15:26:24 +0100601_iso-8859-1 Hi Phil
INSTEAD OF triggers are V9 and Scott is V8. Also, they are only available for views, not for tables.
Regards Mike Turner Email: mike.turner@gmx.com Tel: +44 (0)1565-873702 Web: www.michael-turner.ltd.uk Michael Turner Ltd. Registered in England & Wales No. 1433722. Registered Office: 131 King Street, Knutsford, Cheshire, WA16 6EJ. VAT No. GB 338 4159 44. ----- Original Message ----- From: Sevetson, Phil Newsgroups: bit.listserv.db2-l To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Friday, August 14, 2009 3:13 PM Subject: Re: [DB2-L] DB2 z/os v8.1 before trigger question [...]
33187 22 43_Re: Performance issue with a delete process5_anand19_mahadea@LABCORP.COM31_Fri, 14 Aug 2009 19:32:27 +0000686_UTF-8 Faced with a similar delete situation we kept it simple and deleted it one by one using a cursor and committed every 1000 deletes.
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *
_____________________________________________________________________
IDUG Europe Attendee Testimonial- "I had my first experience with certifications (and passed)! I learned a lot about DB2 version 9 (LUW) that hopefully will enable me to convince management a timely migration will be of benefit for the business." _____________________________________________________________________
33210 70 49_[Ad] IBM Training - Internet or NYC in Sept - Oct14_Larry Kintisch17_LKint@VERIZON.NET31_Fri, 14 Aug 2009 17:03:11 -0400429_us-ascii Hi Listers,
I'll be teaching DB2 classes as a contract instructor for IBM, as I have for 18 years, and hope this trio of IBM classes is just what some of your "newbies" or managers are looking for. Maybe some of you were recently thrust into the DB2 Database Administrator role. Help your boss spend his 2009 training budget while you get up to speed in exciting midtown New York or, for the CV721, on-line. [...]
33281 222 27_Re: DB2 DISCARD recognition13_David S Waugh16_dsw-dba@JUNO.COM29_Fri, 14 Aug 2009 23:21:56 GMT623_windows-1252 Mark:
I wrote a clist that checks the DISCARD dataset for records. The LOAD job JCL invokes the clist after the LOAD step completes, then determines whether to send an email out. Here it is (use at your own risk):
PROC 1 ODSNAME TEST /*********************************************************************** /* CKSYSDIS /* /* THIS CLIST IS INTENDED TO CHECK THE LOAD UTILITY'S SYSDISC DATASETS /* TO SEE IF ANYTHING HAS BEEN DISCARDED DUE TO DUPLICATES OR RI ERRORS. /* /* YOU WILL EXECUTE THIS CLIST AGAINST ALL THE SYSDISC DATASETS IN A JOB /* AT THE END OF THE JOB TO DETERMINE WHETHER TO [...]