1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l December 2009, week 4
2 77 74_AUTO: Mike Dupuis/Ontario/IBM is out of the office. (returning 01/04/2010)11_Mike Dupuis18_mdupuis@CA.IBM.COM31_Mon, 21 Dec 2009 22:12:05 -0500417_US-ASCII
I am out of the office until 01/04/2010.
I will respond to your message when I return. If this is an urgent matter please call the Heldesk and ask that an IGS DB2 support person be paged. For less urgent matters pls email SLCDB2.
Note: This is an automated response to your message "DB2-L Digest - 21 Dec 2009 to 22 Dec 2009 (#2009-364)" sent on 12/21/09 20:00:00. [...]
80 187 38_Re: Applying lots of PTFs a DB2 system9_DB2DBAzOS21_bala.db2dba@GMAIL.COM31_Tue, 22 Dec 2009 11:15:31 +0530461_ISO-8859-1 Hello Keith,
We have done a similar exercise at our shop recently but, the DB2 was v7. We did that ahead of v8 Migration. What I wanted to do was just apply the Hiper PTFs along with the fallback PTF.
But, several HIPERs had requirements that made us pull as many as 2000+ PTFs. Our shop is small but, had Pre-PROD and PROD at the same z/OS LPAR. I ran the APPLY CHECK weeks ahead and analyzed the HOLD DATA carefully by category. [...]
268 230 38_Re: Applying lots of PTFs a DB2 system11_Nenad Vidak21_Nenad.Vidak@GMAIL.COM31_Tue, 22 Dec 2009 12:26:46 +0000432_UTF-8 Hello, I've been applying DB2 maintenance and analyzing actions required for years and from my personal experience dealing with few hundreds of ptfs in a single apply is not an issue - as Cathy said most of DB2BIND and all DOC actions can be ignored.( I've never done mass rebind. - that should be done by DBA responsible for particular application) At the end you'll come out with the list of 10-20 actions ( jobs ) ... [...]
499 58 73_Re: Is there anything Written on the use and/or misuse of Collectin-ids ?11_Daniel Lapp21_lapp.daniel@GMAIL.COM31_Tue, 22 Dec 2009 13:00:33 +0000550_- Robert, thanks for responding ! We seem to have few plans with lots of wildcarding in the pklist which I am sure causes some overhead as well. Am I correct in thinking that DB2 then has to keep a copy of each package in the EDMPOOL and search looking for the one with the correct CONTOKEN to execute since there appears to be load libraries aligned with each of the different collection ids. It's an assumption on my part but I would guess each load library has a different version of each corresponding program which would mean each load had [...]
558 43 45_Dynamic versus Static SQL from a Java program17_Hunsicker, Brenda20_BHunsicker@GLHEC.ORG31_Tue, 22 Dec 2009 07:36:42 -0600396_us-ascii
Is anyone using SQLJ instead of JDBC for access to DB2 z/OS from a Java program run on an intel box?
How about the use of stored procedures or Java Beans executing a CICS program for access to DB2 z/OS?
We are looking at ways to improve the performance of our Java programs and we are considering a standard that states that DB2 z/OS access is via static SQL. [...]
602 35 28_Aliases - v7 Migrating to v815_Donald Gormanly33_donald.gormanly@AXA-EQUITABLE.COM31_Tue, 22 Dec 2009 15:30:04 +0000403_utf-8 When migrating from DB2 for z/OS v7 to v8, are there any problems with Aliases, in regards to the Local Subsystem being upgraded to v8 while the Remote Subsystem is still on v7? I know about the whole DBPROTOCOL DRDA vs PRIVATE issue. But, does anyone know if there are any problems related to the fact that the Local and Remote locations may temporarily reside on different versions of DB2? [...]
638 220 73_Re: Is there anything Written on the use and/or misuse of Collectin-ids ?11_Suresh Sane21_data_arch@HOTMAIL.COM31_Tue, 22 Dec 2009 09:33:22 -0600492_Windows-1252
Daniel,
The scenario you describe is correct if you precompile/compile/link/bind 30 different times.
A few things to add:
1. In the Redbook, see chap 3, especially diagrams 3-6 and 3-7, which are an old-style flowchart of how the package is searched and loaded.
2. If the program issues a SET CURRENT PACKAGESET, only that collection is searched (29 others are irrelevant). [...]
859 90 34_HP Unload Question re: Date Fields15_Mike Dransfield29_michael.dransfield@BARCAP.COM31_Tue, 22 Dec 2009 15:53:50 +0000347_utf-8 Hey, All,
I’m running HP Unload against an image copy to produce a flat file. The output data is delimited with x’1D’ (chosen because that’s no present in the data).
In the output dataset, date data are being preceded by x’00’ for some reason, and I can’t seem to eliminate them. Here’s what I’ve tried: [...]
950 37 38_Re: Applying lots of PTFs a DB2 system13_Keith Gooding17_kwg25@YAHOO.CO.UK31_Tue, 22 Dec 2009 16:22:37 +0000426_utf-8 Thanks to everyone who has replied.I get the message that there is no pain- free way - I have to read through the hold actions and I need to understand more of DB2. Some of the replies referred to the 'Database Administrator'. We have no such person - just anarchic developers with SYSADM authority, some of whom are very knowledeable about DB2. I will get some advice/assistance from one of those in the new year. [...]
988 272 73_Re: Is there anything Written on the use and/or misuse of Collectin-ids ?11_Daniel Lapp21_lapp.daniel@GMAIL.COM31_Tue, 22 Dec 2009 11:26:16 -0500564_windows-1252 Suresh, how can I reach you offline ? My email is lapp.daniel@gmail.com.
My concerns are definetly the size of SPT01 but also maintenance/cleanup is a nightmare and can't be safely done until after a release cycle is complete. The compression PTF is fine but does not really address the issues I have with how the whole environment is managed and the amount of redundancy it has created. Along with the redundancy is a waste of a lot of memory and cpu. So, compressing only allows people to continue with bad habits which waste resources. [...]
1261 192 38_Re: HP Unload Question re: Date Fields14_jack fernicola20_bowling730@YAHOO.COM31_Tue, 22 Dec 2009 08:39:10 -0800424_utf-8 MIke,  Just a side note, you will need to upgrade HP Unload to V3.2 when going to DB2 V8 NFM.Â
Jack Â
--- On Tue, 12/22/09, Mike Dransfield wrote:
From: Mike Dransfield Subject: [DB2-L] HP Unload Question re: Date Fields To: DB2-L@WWW.IDUGDB2-L.ORG Date: Tuesday, December 22, 2009, 10:53 AM
Hey, All, [...]
1454 36 38_Re: Applying lots of PTFs a DB2 system14_Leblanc, Fritz27_fritz.leblanc@SALLIEMAE.COM31_Tue, 22 Dec 2009 11:48:22 -0500653_utf-8 'global rebind' just means rebinding everything.
-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Keith Gooding Sent: Tuesday, December 22, 2009 11:23 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Applying lots of PTFs a DB2 system
Thanks to everyone who has replied.I get the message that there is no pain- free way - I have to read through the hold actions and I need to understand more of DB2. Some of the replies referred to the 'Database Administrator'. We have no such person - just anarchic developers with SYSADM authority, some of whom are very knowledeable about DB2. I will [...]
1491 91 38_Re: Applying lots of PTFs a DB2 system12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Tue, 22 Dec 2009 10:51:29 -0600335_UTF-8 Keith:
The way I interpret your question there is no global rebind command, but you could state REBIND *.*. We have seen this done and it can run for very long time. Since you stated this was for an ISV, have you considered creating a new subsystem? We are an ISV and that is what we do with each new version of DB2. [...]
1583 24 38_Re: HP Unload Question re: Date Fields9_Dan Chatt15_dchatt@FNNI.COM31_Tue, 22 Dec 2009 17:26:50 +0000604_utf-8 Is the DATE field NULLABLE? If so, the one byte NULL INDICATOR would be before the DATE field.
_____________________________________________________________________
* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________
http://www.idug.org/solutions-journal.html - home of the IDUG Solutions Journal Technical atricles from world famous authors in DB2's most prestigious, peer reviewed magazine now on-line! _____________________________________________________________________ [...]
1608 173 38_Re: Applying lots of PTFs a DB2 system13_Keith Gooding17_kwg25@YAHOO.CO.UK31_Tue, 22 Dec 2009 09:55:05 -0800624_iso-8859-1 Gerald, Yes, we do create new subsystems for each new version of DB2. But I wanted to upgrade our existing 9.1 subsystem(s) to a more recent maintenance level, specifically to include a particular PTF. I was hoping to do it quickly and in in a way which did not require any action from the developers. I think I may do as you suggest and create a new subsystem specifically for the person who needs to test the new function in January and let the developers decide what to do next. Keith ________________________________ From: Gerald Hodge To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Tue, [...]
1782 127 38_Re: HP Unload Question re: Date Fields13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Tue, 22 Dec 2009 14:32:41 -0500544_utf-8 Hello Mike.
I suspect Dan has a good guess at the explanation.
What is your intent for the output flat file? That will help us understand your concern with eliminating the x'00's.
Dave
The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. [...]
1910 182 38_Re: HP Unload Question re: Date Fields15_Mike Dransfield38_Michael.Dransfield@BARCLAYSCAPITAL.COM31_Tue, 22 Dec 2009 14:50:37 -0500356_us-ascii Dave,
Yes, Dan was correct.
The data is being FTPed to an accounting firm, who is likely loading it into a non-DB2 platform. It could be Sybase, Oracle or MS SQL Server. I don't have direct contact with them.
The accounting firm has less appetite than I do for writing a program to strip off the extra x'00' occurrences. [...]
2093 206 38_Re: HP Unload Question re: Date Fields14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 22 Dec 2009 15:52:17 -0500440_us-ascii Mike, DFSORT/Syncsort can be used to reformat records in the way you desire without more complex programming. And it's blindingly fast.
--Phil
-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mike Dransfield Sent: Tuesday, December 22, 2009 2:51 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] HP Unload Question re: Date Fields
Dave,
Yes, Dan was correct. [...]
2300 42 49_AUTO: Gab Gambassi is away (returning 12/29/2009)12_Gab Gambassi20_gabriele@NZ1.IBM.COM31_Wed, 23 Dec 2009 16:03:56 +1300510_US-ASCII I am out of the office until 12/29/2009.
I am sorry, I am away from the office. For urgent matters please contact: my collegaue Art Balingit Phone 09-359-8417 Mobile 021-464-958 Mail balingit@nz1.ibm.com
or my Team Leader , Joshua Joshua Phone 09-359-8523 Mobile 021-2442673 Mail joshuaj@nz1.ibm.com
Thanks for you patience.
Note: This is an automated response to your message "DB2-L Digest - 22 Dec 2009 to 23 Dec 2009 (#2009-365)" sent on 23/12/09 14:00:00. [...]
2343 128 38_Re: Applying lots of PTFs a DB2 system12_Ayalew Kassa20_ayalakassa@YAHOO.COM31_Tue, 22 Dec 2009 19:45:23 -0800340_iso-8859-1 Keith,
Global rebind is rebinding all of the packages of a subsystem. In my shop, I do not do global rebind after applying fixes because my team does not know how often reorg and runstats job execute against the DB2 objects. If the DB2 objects have old statstics, doing rebind by itself my cause access path changes. [...]
2472 101 49_Re: Dynamic versus Static SQL from a Java program7_Jan tje25_jan.moeyersons@ADELIOR.BE31_Wed, 23 Dec 2009 11:26:18 +0000522_utf-8 On Tue, 22 Dec 2009 07:36:42 -0600, Hunsicker, Brenda wrote:
> >Is anyone using SQLJ instead of JDBC for access to DB2 z/OS from a Java >program run on an intel box? Yes. And frankly, for all cases where you have to actually code the SQL, this is my preferred way. Comes actually rather close to embedded SQL like we used to do in the COBOL days (that are far from over, B.T.W.) There is a little extra burden in preparing the programs, but tools like RAD7 are doing that for you. [...]
2574 30 38_Re: HP Unload Question re: Date Fields12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Wed, 23 Dec 2009 11:41:46 +0000292_utf-8 Mike, if the x'00' is as result of a nullable column you can use the NULLID or NULL keywords in your USER block to handle that. The default for NULLID is NO, so you shouldn't be getting a preceding null indicator unless you've maybe got it set to yes in your Options or elsewhere. [...]
2605 55 57_AW: [DB2-L] Dynamic versus Static SQL from a Java program12_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 23 Dec 2009 13:14:35 +0100589_us-ascii >> If you call a stored procedure that then runs for half an hour and returns just one row; that's OK.<<
Jan, you are just kidding ?
With kind regards - mit freundlichen Gruessen, Georg H. Peter c/o Datenzentrale Baden-Wuerttemberg Software Development & Technology Center Knowledge Center Database Systems 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 ---------------------------------------------------------------------- [...]
2661 32 61_Re: AW: [DB2-L] Dynamic versus Static SQL from a Java program11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Wed, 23 Dec 2009 12:50:09 +0000472_- >> If you call a stored procedure that then runs for half an hour and returns just one row; that's OK.<<
>Jan, you are just kidding ?
What if that one row contains data that is mission critical?
Technicians should NOT be making business decisions. What you should be doing is determining the best method to support the business. If this one row per half-hour is the best way, it is NOT up to you to stop it. - Too busy driving to stop for gas! [...]
2694 50 46_AD: graingerdatabasesolutions.com is now LIVE!13_Phil Grainger34_phil@GRAINGERDATABASESOLUTIONS.COM31_Wed, 23 Dec 2009 14:05:27 -0000433_us-ascii Hopefully the list admins will cut me a little festive slack for a quick advertisement/announcement.
As many of you already know, CA and I parted company during the summer, and I have spent the last few months since the end of my "gardening leave" deciding what to do next.
It's no surprise that I am sticking with DB2 - after all, I have far too much of my life invested in it to think of anything else. [...]
2745 100 50_Re: AD: graingerdatabasesolutions.com is now LIVE!14_Peter Backlund21_BacklundDB2@TELIA.COM31_Wed, 23 Dec 2009 16:02:16 +0100
2846 48 58_AW: [DB2-L] AD: graingerdatabasesolutions.com is now LIVE!12_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 23 Dec 2009 16:17:27 +0100322_us-ascii Nice to see your mail, Phil.
And we (Eva & Georg) wish you a stress free christmas (or what ever you celebrating) and we hope to see both of you next year.
Thanks in advance for any information you are willing to pass along.
With kind regards - mit freundlichen Gruessen, Georg H. Peter [...]
2895 76 50_Re: AD: graingerdatabasesolutions.com is now LIVE!13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Wed, 23 Dec 2009 10:08:33 -0600546_ISO-8859-1 Congratulations Phil on the company startup and the web site... and good luck in 2010... I wish you all the success in the new year.
Willie
Phil Grainger wrote: > Hopefully the list admins will cut me a little festive slack for a quick > advertisement/announcement. > > As many of you already know, CA and I parted company during the summer, and > I have spent the last few months since the end of my "gardening leave" > deciding what to do next. > > It's no surprise that I am sticking with DB2 - after all, I have [...]
2972 454 73_Re: Is there anything Written on the use and/or misuse of Collectin-ids ?16_Robert Catterall21_rfcatterall@GMAIL.COM31_Wed, 23 Dec 2009 11:21:47 -0500579_windows-1252 Regarding the EDM pool: when a program containing embedded SQL issues a call to DB2 (the precompile process comments out SQL statements and replaces them with calls to DB2), DB2 will look in the SKPT (skeleton package table) portion of the EDM pool to see if the package section needed to execute the SQL statement corresponding to the call is there (and yes, the call contains the package's consistency token, as well as the package name and a SQL statement number). If it isn't, DB2 will locate the package in the directory and load it into the SKPT. It will [...]
3427 97 49_Re: HP Unload Question re: Date Fields - Success!15_Mike Dransfield38_Michael.Dransfield@BARCLAYSCAPITAL.COM31_Wed, 23 Dec 2009 11:45:33 -0500397_us-ascii Adam,
Reporting back, for the betterment of DBAkind :)
After a couple unsuccessful attempts:
COL MDT TYPE DATE NULLID NO COL MDT TYPE DATE NULLID YES (just for fun)
I tried this:
COL MDT TYPE CHAR(10) NULLID NO
This final attempt eliminated the x'00'.
I'll have to track down where the NULLID is (apparently) set to YES here. [...]
3525 25 42_Mike Hopkins/COR/AWG is out of the office.12_Mike Hopkins19_mhopkins@AWGINC.COM31_Wed, 23 Dec 2009 19:47:07 -0600676_US-ASCII I will be out of the office starting 12/23/2009 and will not return until 12/28/2009.
If you need immediate assistance, please e-mail edi@awginc.com.
_____________________________________________________________________
* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________
http://www.IDUG.org membership is now free. Do you have people in your office who are not an IDUG member? Show them how to access the information and help train the next generation of DB2 Users! _____________________________________________________________________ [...]
3551 39 73_AUTO: Andrew Butcher/HAV/SSE is out of the office. (returning 29/12/2009)0_38_Andrew.Butcher@SCOTTISH-SOUTHERN.CO.UK31_Thu, 24 Dec 2009 04:00:59 +0000387_us-ascii I am out of the office until 29/12/2009.
I will respond to your message when I return. In the meantime, if it is important then please forward your Email to my colleague Steve Spurgin or contact him on Ext. 44988.
Note: This is an automated response to your message "DB2-L Digest - 23 Dec 2009 to 24 Dec 2009 (#2009-366)" sent on 24/12/2009 01:00:00. [...]
3591 61 49_Re: HP Unload Question re: Date Fields - Success!12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Thu, 24 Dec 2009 07:25:02 +0000631_utf-8 Mike, I think that the reason that it's not working with DATE is that in this context the DATE keyword is in correct.
Try with:
COL MDT TYPE DATE_X NULLID NO
Where the X of DATE_X is a character A - P according to the list below:
DATE_A format MM-DD-YYYY DATE_B format MM-DD-YY DATE_C format YYYY-MM-DD DATE_D format YY-MM-DD DATE_E format DD-MM-YYYY DATE_F format DD-MM-YY DATE_G format YYYY-DDD DATE_H format YY-DDD DATE_I format MMDDYYYY DATE_J format MMDDYY DATE_K format YYYYMMDD DATE_L format YYMMDD DATE_M format DDMMYYYY DATE_N format DDMMYY DATE_O format YYYYDDD DATE_P format YYDDD [...]
3653 28 50_Re: AD: graingerdatabasesolutions.com is now LIVE!12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Thu, 24 Dec 2009 07:29:46 +0000664_utf-8 Phil - good luck and best wishes for the new venture. Glad that you're active on the list again.
Have a great Christmas.
Cheers, Adam
_____________________________________________________________________
* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________
http://www.IDUG.org membership is now free. Do you have people in your office who are not an IDUG member? Show them how to access the information and help train the next generation of DB2 Users! _____________________________________________________________________ [...]
3682 43 61_Re: AW: [DB2-L] Dynamic versus Static SQL from a Java program7_Jan tje25_jan.moeyersons@ADELIOR.BE31_Thu, 24 Dec 2009 11:19:07 +0000597_utf-8 On Wed, 23 Dec 2009 13:14:35 +0100, Peter, Georg wrote:
>>> If you call a stored procedure that then runs for half an hour and >returns just one row; that's OK.<< > >Jan, you are just kidding ?
Only half...
The point is that the overhead of invoking a stored procedure is considerable. When the stored procedure does a fair amount of work, that is no problem, because, percentage-wise, the overhead will be small. But if the stored procedure is only doing a simple select and nothing else, then indeed the overhead will be bigger than the cost of [...]
3726 54 61_Re: AW: [DB2-L] Dynamic versus Static SQL from a Java program7_Jan tje25_jan.moeyersons@ADELIOR.BE31_Thu, 24 Dec 2009 11:25:17 +0000320_utf-8 On Wed, 23 Dec 2009 12:50:09 +0000, Ted MacNEIL wrote:
>What if that one row contains data that is mission critical? Well, probably it will. But that is not the point. If you have to get to the data in order to accomplish your mission, then you must get to it. One way or another. [...]
3781 77 50_Re: AD: graingerdatabasesolutions.com is now LIVE!15_Chris Hoelscher21_choelscher@HUMANA.COM31_Thu, 24 Dec 2009 09:15:17 -0500576_US-ASCII WOW - this is surprising .... but then .... grainger things have happened .....
Chris Hoelscher Senior IDMS & DB2 Database Administrator Humana Inc 502-476-2538 choelscher@humana.com
you only need to test the programs that you want to work correctly
The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information. [...]
3859 42 36_Plan name used by an IMS transaction15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM31_Thu, 24 Dec 2009 17:05:58 +0200293_us-ascii According to the DB2 install guide, the plan used for an IMS transaction is the transaction load module name.
It appears to me that it uses the CSECT name of entry point (at least, if LE enabled).
Can anyone who has played with this let me know what is accurate?
3902 44 14_Happy holidays17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Thu, 24 Dec 2009 18:05:49 -0000348_UTF-8 Hi dear colleagues,
Just a quick email to wish you and yours a very peaceful and happy festive season.
Happy holidays.
Peace.
Aurora
*** sent via mobile email ***
Aurora Emanuela Dell'Anno CA Mobile: +44 (0)7768 235 339
please don't print this e-mail unless you really need to!
3947 78 49_Re: Dynamic versus Static SQL from a Java program15_Campbell, Wayne28_Wayne.Campbell@COURTS.WA.GOV31_Thu, 24 Dec 2009 10:21:56 -0800624_us-ascii You may also want to look into IBM's PureQuery. It has some benefits, in that you don't have to rewrite you Java code to run static packages, ease of development, ant the ability to refer back to the java code where the SQL is being called.
Wayne Campbell DB2 DBA Administrative Office of the Courts (360) 705-5268 Email: wayne.campbell@courts.wa.gov -----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Hunsicker, Brenda Sent: Tuesday, December 22, 2009 5:37 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Dynamic versus Static SQL from a Java program [...]
4026 333 17_Seasons Greetings22_Frank C. Fillmore, Jr.19_tfgpublic@GMAIL.COM31_Thu, 24 Dec 2009 14:57:26 -0500608_iso-8859-1 Merry Christmas!
Happy Channukah!
Blessed Kwanzaa!
Prayerful Ramadan!
Delightful Diwali!
Joyeux Noel et Bonne Année! (French)
YENI YILINIZ KUTLU OLSUN (Happy New Year in Turkish)
Nadolig Llawen a Blwyddyn Newydd Dda (Welsh)
Folle lok en seine (Frysian)
Gelukkig nieuwjaar (Dutch)
And a safe, happy, healthy, and prosperous 2010 to us all.
Frank
P.S. And if I missed a celebration that is important to you, please e-mail it to me and I will honor it next year. [...]
4360 79 50_Re: AD: graingerdatabasesolutions.com is now LIVE!6_Leslie21_db2dba@BTINTERNET.COM31_Thu, 24 Dec 2009 20:28:37 -0000405_us-ascii Phil Well done and welcome to the world of business, wish you all the best for Christmas and New Year. Happy Christmas to the rest of the DB2-List as well. Leslie
-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Phil Grainger Sent: 23 December 2009 14:05 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] AD: graingerdatabasesolutions.com is now LIVE! [...]
4440 47 45_Sherri Sterling/OIT/BPD is out of the office.0_29_Sherri.Sterling@BPD.TREAS.GOV31_Thu, 24 Dec 2009 22:31:40 -0500662_US-ASCII
I will be out of the office starting 12/24/2009 and will not return until 01/04/2010.
I will respond to your message when I return.
_____________________________________________________________________
* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________
http://www.idug.org/db2-videos.html has hundreds of video presentations! Did you miss out on attending an IDUG conference? Many of the presentations were recorded and are available on our website! _____________________________________________________________________
4488 69 65_AUTO: John Iczkovits is out of the office. (returning 12/30/2009)14_John Iczkovits19_iczkovit@US.IBM.COM31_Fri, 25 Dec 2009 22:07:45 -0700544_US-ASCII
I am out of the office until 12/30/2009.
Note: This is an automated response to your message "DB2-L Digest - 25 Dec 2009 to 26 Dec 2009 (#2009-368)" sent on 12/25/09 18:00:00.
This is the only notification you will receive while this person is away. _____________________________________________________________________
* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________ [...]
4558 93 50_Re: AD: graingerdatabasesolutions.com is now LIVE!11_Roy Boxwell16_R.Boxwell@SEG.DE31_Sat, 26 Dec 2009 14:50:50 +0100
4652 158 21_Re: Seasons Greetings7_Ed Long19_rdhm99a@PRODIGY.NET31_Sat, 26 Dec 2009 09:50:32 -0800691_iso-8859-1 A Festive Festivus for all. Edward Long ________________________________ From: "Frank C. Fillmore, Jr." To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Thu, December 24, 2009 2:57:26 PM Subject: [DB2-L] Seasons Greetings Merry Christmas! Happy Channukah! Blessed Kwanzaa! Prayerful Ramadan! Delightful Diwali! Joyeux Noel et Bonne Année! (French) YENI YILINIZ KUTLU OLSUN (Happy New Year in Turkish) Nadolig Llawen a Blwyddyn Newydd Dda (Welsh) Folle lok en seine (Frysian) Gelukkig nieuwjaar (Dutch) And a safe, happy, healthy, and prosperous 2010 to us all. Frank P.S. And if I missed a celebration that is important to you, please e-mail it to me and I will honor [...]
4811 35 50_Re: AD: graingerdatabasesolutions.com is now LIVE!13_Maja Markotic17_majaDB2@GMAIL.COM31_Sun, 27 Dec 2009 09:41:24 +0000864_UTF-8 Congrats Mr. G!
I'm looking forward to your first presentation without a 5 minute CA legal disclaimer ;-)
I wish you all the best with your new company as well as in your personal life.
Happy holidays!
Miss M
_____________________________________________________________________
* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________
http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations! DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among many more categories of help waiting for you! Whether you are an old hand or a DB2 newbie, we have presentations for every level. _____________________________________________________________________ [...]
4847 38 41_Sajad Javid is out of the office (Travel)11_Sajad Javid19_sajad.javid@TCS.COM31_Mon, 28 Dec 2009 10:02:17 +0530660_us-ascii I will be out of the office starting 12/28/2009 and will not return until 12/30/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 [...]
4886 186 32_DB2 for z/OS Year in Review 200910_DB2usa !!!19_db2usa3@HOTMAIL.COM31_Mon, 28 Dec 2009 04:42:40 -0500701_iso-8859-1
Hi DB2 user,
Here is a non-profit Blog about DB2 for z/OS (IBM mainframes): http://db2usa.blogspot.com
Last update on Monday, December 28th 2008
Here is the list of 2009 DB2usa Blog posts:
- UK GSE Conference 2008 presentations - z/Journal (October - November 2008 issue) - Technotes (FAQ), Withdrawal Announcement and Upcoming Redbook residencies - Redbook DB2 9 for z/OS: Packages Revisited - IDUG Solutions Journal (Winter 2008) - DB2 articles from z/OS Hot Topics newsletter - Presentations from New England DB2 Users Group - Redbook 50 TB Data Warehouse Benchmark on IBM System z - Presentations from Colorado DB2 Users [...]
5073 72 48_SV: [DB2-L] Plan name used by an IMS transaction13_Hanne Lyssand20_Hanne.Lyssand@VPS.NO31_Mon, 28 Dec 2009 10:44:08 +0100529_iso-8859-1 Hopefully someone with more up to date information will answer. But as I remember it as a default the load module name, but you can override it by making a some definitions in IMS. It's 10years since I last worked with IMS, so I don't remember more details.
Best regards
Hanne Lyssand -----Opprinnelig melding----- Fra: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] På vegne av Binyamin Dissen Sendt: 24. desember 2009 16:06 Til: DB2-L@WWW.IDUGDB2-L.ORG Emne: [DB2-L] Plan name used by an IMS transaction [...]
5146 184 52_Re: SV: [DB2-L] Plan name used by an IMS transaction13_Gerard LE ROY24_gerard.le.roy@WANADOO.FR31_Mon, 28 Dec 2009 16:53:39 +0100692_UTF-8 It's 8 years for me, so I remember you have to populate a "Resource Translation Table" to associate a PLAN and a Load Module. I've lost details but you could find them here I think : http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.inst/db2z_dsnmapn.htm
Regards Gerard
> Message du 28/12/09 11:54 > De : "Hanne Lyssand" > A : DB2-L@WWW.IDUGDB2-L.ORG > Copie à : > Objet : [DB2-L] SV: [DB2-L] Plan name used by an IMS transaction > > > Hopefully someone with more up to date information will answer. But as I remember it as a default the load module name, but you can override it [...]
5331 34 40_Re: Plan name used by an IMS transaction12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Mon, 28 Dec 2009 16:02:33 +0000359_utf-8 The default plan name (for an IMS transaction accessing DB2) is the IMS application control block name.
Using the RTT (Resource Translation Table) you can map IMS control block names to DB2 plan names. If there is no RTT defined, the default plan name is used.
Are you using an RTT?? Also, what versions of DB2 / IMS are you running. [...]
5366 40 73_Are the various tokens in SQLERRM and their sequence documented anywhere?15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM31_Mon, 28 Dec 2009 18:03:01 +0200218_us-ascii Or must one via trial and error dump the contents and see what is there?
Are the tokens always in the sequence as DB2 V9.1 for z/OS Codes shows them, i.e., -803 means token #1 is the index name?
5407 168 50_Re: AD: graingerdatabasesolutions.com is now LIVE!10_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 28 Dec 2009 17:32:49 +0100449_UTF-8 Hi Phil
Great ! Good luck for your new adventure and I've the feeling we'll meet soon, guess why....
Max Scarpa Certified Santa Claus Version 2009.1 Certified Xmas gift (to be recycled) Certified DB2 sysprog in twilight zone
Massimo Scarpa - Ufficio Sistemi Cesve Servizi Informatici Bancari v. Longhin, 1 - 35129 Padova Tel. 049.8067111 - Fax. 049.8067300 E-Mail: mscarpa@cesve.it - Web: http://www.cesve.it [...]
5576 85 77_Re: Are the various tokens in SQLERRM and their sequence documented anywhere?13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Mon, 28 Dec 2009 12:04:31 -0500448_utf-8 Hello Binyamin,
I have found that the Codes manual accurately documents the content and sequence for SQLERRM. But I have not studied whether this can change release to release. It certainly changes between SQLCodes. For instance as you say, the -803 first token is indexspace and for -805 the first token is package/dbrm name. I would be surprised to see the order or contents change, but I wouldn't bet much that it never would. [...]
5662 194 40_DB2 STORED PROCEDURE FROM COBOL PROGRAM.16_mallik vemugunta19_kris_vemu@YAHOO.COM31_Mon, 28 Dec 2009 13:02:35 -0800326_iso-8859-1 Hi,
I am new to DB2 stored procedure , can you please help me how I can call COBOL CICS application program.
We already have a DB2 stored procedure that is being called from Java application and we had a requirement to call the same procedure from COBOL program, here is CREATE procedure syntax. [...]
5857 80 55_Query output difference on using new index after rebind10_Teldb2kals22_teldb2kals@TELSTRA.COM31_Mon, 28 Dec 2009 22:57:49 +0000315_utf-8 Hi,
We had a production issue over the weekend where some transactions were appearing twice, and after a lot of investigation, the only thing that had changed was the access path for a query in the program following a rebind on the weekend. The query started using a different index (say Index2). [...]
5938 110 59_Re: Query output difference on using new index after rebind14_Fazio, Richard21_RFAZIO@TRANSUNION.COM31_Mon, 28 Dec 2009 17:45:29 -0600520_us-ascii I would check to make sure the indexes are both consistent. Run check index on both to make sure that both indexes are good.
Big assumption. Both indexes are on the same table....yes?
Indexes should only affect performance...never the result. faz
-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Teldb2kals Sent: Monday, December 28, 2009 4:58 PM To: DB2-L@www.idugdb2-l.org Subject: [DB2-L] Query output difference on using new index after rebind [...]
6049 100 59_Re: Query output difference on using new index after rebind9_Mike Bell21_mbell11a1@VERIZON.NET31_Mon, 28 Dec 2009 17:54:05 -0600385_us-ascii Item 1 - time to open a problem report. Incorrect output is one of the more common problems Item 2 - first thing IBM will ask for is check index for both index 1 and 2. Item 3 - access path changes are usually tied to runstats - if the index has more than 2 columns, you always need to specify KEYCARD. If the SQL has literals or reoptvars, then FREQVAL is also usefull. [...]