1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l June 2009, week 5
2 255 50_The end of an era .... and the start of a new one!14_Grainger, Phil20_Phil.Grainger@CA.COM31_Mon, 29 Jun 2009 08:58:24 +0100398_us-ascii
A few months ago, CA took the decision to relocate the DB2 Product Manager roles to the US. For me to have kept working in this role at CA, I would have had to relocate to our DB2 development centre in Lisle, Illinois.
For many reasons, I have declined to relocate which means, from June 30th, I will no longer be a DB2 Product Manager with CA. [...]
258 196 34_Articles from IBM Techdocs Library10_DB2usa !!!19_db2usa3@HOTMAIL.COM31_Mon, 29 Jun 2009 04:35:01 -0400497_Windows-1252
Hi DB2 user,
Here is a non-profit Blog about DB2 for z/OS (IBM mainframes): http://db2usa.blogspot.com
Last update on Monday, June 29th 2009
Here are several articles from IBM Techdocs Library, available on IBM Techdocs Website:
- Identifying the dynamic SQL statement which is causing a lock escalation by Richard Corrihons
- Tape Authorization for DB2 RESTORE SYSTEM Utility by Judy Ruby-Brown [...]
455 26 58_Re: Equivalent to Synonyms for Stored Procs (DB2 z/OS v8)?13_Graham O'Hara32_graham.ohara@NORWICH-UNION.CO.UK31_Mon, 29 Jun 2009 08:54:18 +0000629_windows-1252 Thanks for taking time out to respond James.
I've been thinking about it but am a little unclear on the approach that you are suggesting... would you be able to elaborate a little?
Thanks, Graham.
_____________________________________________________________________
* 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." _____________________________________________________________________
482 240 67_Antwort: [DB2-L] The end of an era .... and the start of a new one!11_Roy Boxwell16_R.Boxwell@SEG.DE31_Mon, 29 Jun 2009 12:23:49 +0200426_ISO-8859-1 wow! Bad news indeed! Good luck with whatever you plan to do next (be it gardening or drinking beer all day) you have earned a good rest and good place to be - even perhaps in England! :)
Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Straße 5 40470 Düsseldorf/Germany Tel. +49 (0)211 96149-675 Fax +49 (0)211 96149-32 Email: R.Boxwell@seg.de http://www.seg.de [...]
723 290 54_Re: The end of an era .... and the start of a new one!12_McLaren Phil32_Phil.McLaren@AXAWINTERTHUR.CO.UK31_Mon, 29 Jun 2009 12:05:06 +0100509_us-ascii Big news indeed, best of luck Phil.
I don't often post to DB2-L but I've followed it for many years, and you have been a great contributor. I hope things work out and it's good to see you remaining in the industry
Phil McLaren
________________________________ From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Grainger, Phil Sent: 29 June 2009 08:58 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] The end of an era .... and the start of a new one! [...]
1014 178 54_Re: The end of an era .... and the start of a new one!12_Paul Ogborne19_paulogborne@AOL.COM31_Mon, 29 Jun 2009 07:27:56 -0400361_us-ascii Hi Phil, Thank you for your continuing contribution to this list, the DB2 community and all the best for the future. Best regards, Paul Ogborne.
-----Original Message----- From: Grainger, Phil To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Mon, 29 Jun 2009 8:58 Subject: [DB2-L] The end of an era .... and the start of a new one! [...]
1193 441 54_Re: The end of an era .... and the start of a new one!19_Foundoulakis Petros25_PFoundoulakis@EUROBANK.GR31_Mon, 29 Jun 2009 14:34:25 +0300547_us-ascii These are bad news for all of us, that we were waiting to hear from you all the "goodies" about DB2.
All the DBA's from Eurobank EFG Greece wish you good lack to whatever you are going to do. Because you will be the best (as usual).
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Grainger, Phil Sent: 29 June 2009 08:58 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] The end of an era .... and the start of a new one! [...]
1635 40 58_Re: Equivalent to Synonyms for Stored Procs (DB2 z/OS v8)?14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Mon, 29 Jun 2009 21:45:33 +1000532_US-ASCII You were the one who wrote "I am thinking along the lines of tables/views where it would be possible to create a synonym with the userid as the prefix pointing at the appropriate qualifier/schema."
Personally the only way I know how to do what you want is by having program logic and manipulating the schema/current path. But you ruled those out. So I pointed out that, since the concepts were so similar, you should be able to transpose whatever mechanism you had in mind for synonyms to unqualified SP calls. [...]
1676 26 54_Re: The end of an era .... and the start of a new one!12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Mon, 29 Jun 2009 12:49:56 +0000624_windows-1252 Phil - many, many thanks for all of your input, contributions and help - both on and off list. You will be greatly missed. All the best for the future.
A million thanks and best wishes.
Adam.
_____________________________________________________________________
* 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." _____________________________________________________________________
1703 52 54_Re: The end of an era .... and the start of a new one!14_Grainger, Phil20_Phil.Grainger@CA.COM31_Mon, 29 Jun 2009 13:55:04 +0100507_iso-8859-1 Hey, I did say I'd still be on db2-l didn't I
I certainly meant to......
________________________________
From: DB2 Data Base Discussion List on behalf of Adam Baldwin Sent: Mon 29/06/2009 13:49 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] The end of an era .... and the start of a new one!
Phil - many, many thanks for all of your input, contributions and help - both on and off list. You will be greatly missed. All the best for the future. [...]
1756 121 54_Re: The end of an era .... and the start of a new one!10_Nicola Nur17_nick_nur@YAHOO.CA31_Mon, 29 Jun 2009 06:15:24 -0700587_iso-8859-1 Take care Phil and thanks for all the help you have given to all of us. Good luck. Nick Nur ________________________________ From: "Grainger, Phil" To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Monday, June 29, 2009 3:58:24 AM Subject: [DB2-L] The end of an era .... and the start of a new one! A few months ago, CA took the decision to relocate the DB2 Product Manager roles to the US. For me to have kept working in this role at CA, I would have had to relocate to our DB2 development centre in Lisle, Illinois. For many reasons, I have declined to relocate [...]
1878 176 36_ADMIN:VACATION RIMINDER (I am tired)16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Mon, 29 Jun 2009 09:40:35 -0400354_us-ascii Guys
I am extremely tired in going in every week and reviewing all the 'out of office' messages (especially this time of year for the northern hemisphere countries). I am sure you understand that its a simple action to address this issue, and allows us, as volunteers administrators, to work on more pressing, actual support issues. [...]
2055 441 54_Re: The end of an era .... and the start of a new one!14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Mon, 29 Jun 2009 09:45:11 -0400694_us-ascii Phil,
I hope you find good work, quickly.
--Phil Sevetson "One of the many other Phils"
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Grainger, Phil Sent: Monday, June 29, 2009 3:58 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] The end of an era .... and the start of a new one!
A few months ago, CA took the decision to relocate the DB2 Product Manager roles to the US. For me to have kept working in this role at CA, I would have had to relocate to our DB2 development centre in Lisle, Illinois. [...]
2497 200 31_[DB2 V9 CM] 00c90096 on a FETCH35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM31_Mon, 29 Jun 2009 16:02:13 +0200625_iso-8859-1 Hi all
I am puzzled with a problem, I do not have any explanation for. A program executes the following SQL:
EXEC SQL DECLARE CURSOR C WITH ROWSET POSITIONING WITH HOLD FOR SELECT 1 FROM Q.OBJECT_DATA WHERE OWNER IN (SELECT PNR_ALT FROM DB2.ISTB0007 ) FOR UPDATE END-EXEC
There are only 2 rows which qualify. Access is using a tablespace scan. The first fetch gets SQLCODE -904 with resoncode 00C90096 after scanning 10,000 pages. Fetch acquires just U-page-locks, but I do not understand, why the page lock for the previous page is not released, when scanning starts with the next page, [...]
2698 227 35_Re: [DB2 V9 CM] 00c90096 on a FETCH12_Jeff Frazier31_Jeffrey.Frazier@WENDYSARBYS.COM31_Mon, 29 Jun 2009 10:22:56 -0400751_ISO-8859-1 Hi, I know it is an older APAR but PK41812 references that error. HTH's Jeff
Walter Janißen Sent by: DB2 Data Base Discussion List 06/29/2009 10:02 AM Please respond to DB2 Database Discussion list at IDUG
To DB2-L@WWW.IDUGDB2-L.ORG cc
Subject [DB2-L] [DB2 V9 CM] 00c90096 on a FETCH
Hi all I am puzzled with a problem, I do not have any explanation for. A program executes the following SQL: EXEC SQL DECLARE CURSOR C WITH ROWSET POSITIONING WITH HOLD FOR SELECT 1 FROM Q.OBJECT_DATA WHERE OWNER IN (SELECT PNR_ALT FROM DB2.ISTB0007 ) FOR UPDATE END-EXEC There are [...]
2926 379 43_AW: [DB2-L] [DB2 V9 CM] 00c90096 on a FETCH35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM31_Mon, 29 Jun 2009 16:41:08 +0200441_iso-8859-1 Hi Jeff
Thank you for your reply. Although it is a very old PTF, it matches our situation very well. May be, they implemented the same bug agian in V9. I will check with IBM.
Mit freundlichen Grüßen Walter Janißen
ITERGO Informationstechnologie GmbH Anwendungsentwicklung Laufzeitarchitektur Victoriaplatz 2 40198 Düsseldorf Tel.: +49 211 477-2928 Fax: +49 211 477-2615 mailto:walter.janissen@itergo.com [...]
3306 432 60_Antwort: [DB2-L] AW: [DB2-L] [DB2 V9 CM] 00c90096 on a FETCH11_Roy Boxwell16_R.Boxwell@SEG.DE31_Mon, 29 Jun 2009 16:52:53 +0200637_ISO-8859-1 really good bugs *always* come back !!!
Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Straße 5 40470 Düsseldorf/Germany Tel. +49 (0)211 96149-675 Fax +49 (0)211 96149-32 Email: R.Boxwell@seg.de http://www.seg.de
Software Engineering GmbH Amtsgericht Düsseldorf, HRB 37894 Geschäftsführung: Siegfried Fürst, Gerhard Schubert
Walter Janißen Gesendet von: DB2 Data Base Discussion List 29.06.2009 16:41 Bitte antworten an DB2 Database Discussion list at IDUG [...]
3739 602 72_AW: [DB2-L] Antwort: [DB2-L] AW: [DB2-L] [DB2 V9 CM] 00c90096 on a FETCH35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM31_Mon, 29 Jun 2009 16:57:33 +0200823_iso-8859-1 Hi Roy
Seems so. let's see, what IBM say about that.
Mit freundlichen Grüßen Walter Janißen
ITERGO Informationstechnologie GmbH Anwendungsentwicklung Laufzeitarchitektur Victoriaplatz 2 40198 Düsseldorf mailto:walter.janissen@itergo.com
Vorsitzender des Aufsichtsrats: Jürgen Vetter Geschäftsführung: Dr. Bettina Anders (Vorsitzende), Dr. Christian Nymphius, Dr. Michael Regauer, Wolfgang Schön. Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf, HRB 37996
________________________________
Von: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Im Auftrag von Roy Boxwell Gesendet: Montag, 29. Juni 2009 16:53 An: DB2-L@WWW.IDUGDB2-L.ORG Betreff: [DB2-L] Antwort: [DB2-L] AW: [DB2-L] [DB2 V9 CM] 00c90096 on a FETCH [...]
4342 197 54_Re: The end of an era .... and the start of a new one!15_Aurora Dellanno17_adpucci@GMAIL.COM31_Mon, 29 Jun 2009 15:56:37 +0100574_ISO-8859-1 I hope you have a wonderful relaxing notice period... And see you around, wish I were going to continue working with you... And don't be a stranger, if you're ever in the 'pool :-)
Aurora x
2009/6/29 Grainger, Phil
> > > A few months ago, CA took the decision to relocate the DB2 Product Manager > roles to the US. For me to have kept working in this role at CA, I would > have had to relocate to our DB2 development centre in Lisle, Illinois. > > > > For many reasons, I have declined to relocate [...]
4540 50 28_z/OS Saving Access Path Data15_Tami Van Dreese27_tami.vandreese@LANDSEND.COM31_Mon, 29 Jun 2009 15:07:26 +0000518_windows-1252 We are in the process of upgrading to V9 and have decided to create all of our plan tables in new databases. However, we want to save the data for the production programs. I set up jcl to extract the data from the existing tables using DSNTIAUL and to load to the new sets of tables using the LOAD utility. Two of the tables are giving me problems. In both cases, the column definition changes somewhat, but there are other columns on the same table with the same changes that don’t show any errors. [...]
4591 110 58_Re: Equivalent to Synonyms for Stored Procs (DB2 z/OS v8)?16_Robert Catterall21_rfcatterall@GMAIL.COM31_Mon, 29 Jun 2009 11:26:11 -0400384_ISO-8859-1 Graham,
For what it's worth, I'm not aware of anything, SQL-wise, that will do for an unqualified stored procedure reference what a synonym or alias will do for an unqualified table or view reference. I know that program logic is not your first choice for resolving unqualified references in stored procedure calls, but I don't see that there's an alternative. [...]
4702 101 32_Re: z/OS Saving Access Path Data14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Mon, 29 Jun 2009 11:38:48 -0400547_us-ascii 1) Is it too late to just change the names of the old tables, implement the new tables, and INSERT INTO/SELECT FROM to move the data?
2) More to the point, why are you changing the definitions of existing columns in DSN_PGROUP_TABLE and DSN_PTASK_TABLE?
You probably need to redefine the appropriate columns of the new version of these tables as FOR SBCS DATA; the manual doesn't specify which setting you need to use, so use the one which gives you compatibility until-and-unless you run into trouble with it. [...]
4804 132 32_Re: z/OS Saving Access Path Data18_Van Dreese, Tami S27_Tami.Vandreese@LANDSEND.COM31_Mon, 29 Jun 2009 10:54:14 -0500514_us-ascii 1) Thanks, that's probably a simpler process than what I was doing.
2) I haven't intentionally changed the column definitions. This is what they were created with when we did it through the Optimization Service Center (v1.1.6).
Tami Van Dreese
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sevetson, Phil Sent: Monday, June 29, 2009 10:39 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] z/OS Saving Access Path Data [...]
4937 173 32_Re: z/OS Saving Access Path Data14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Mon, 29 Jun 2009 12:01:40 -0400445_us-ascii Okay -- probably time to open an ETR with IBM over the question of what the column definitions _should_ be and how to fix the data if the current definitions are wrong...
--Phil
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Van Dreese, Tami S Sent: Monday, June 29, 2009 11:54 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] z/OS Saving Access Path Data [...]
5111 186 52_Re: How do I find out the Dataset names used by DB2.16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Mon, 29 Jun 2009 12:12:33 -0400573_us-ascii Issac
Why don't you put that REXX in the CODE PLACE in www.idug.org
So one does not have to 'bug' you for it and it will last 'forever'
Le contenu de ce courriel s'adresse au destinataire seulement. Il contient de l'information pouvant etre confidentielle. Vous ne devez ni le copier ni l'utiliser ni le divulguer a qui que ce soit a moins que vous soyez le destinataire ou une personne designee autorisee. Si vous le receviez par erreur, veuillez nous aviser immediatement et le detruire. [...]
5298 28 28_java jcc driver db2 packages27_peggy.donovan@citigroup.com27_Peggy.donovan@CITIGROUP.COM31_Mon, 29 Jun 2009 17:20:38 +0000378_windows-1252 I'm testing the Java universal driver - setup & use. I need to set up so that the application packages are in an application COLLID but DB2 packages are still found in NULLID as NULLID.SYSSTAT. I'm missing something as the stored procedures fail -805 looking for applicationCOLLID.SYSSTAT. Can someone point me in the right direction? Thanks in advance, Peggy [...]
5327 36 37_Buffer- how long does data stay here?5_anand19_mahadea@LABCORP.COM31_Mon, 29 Jun 2009 17:30:19 +0000273_ISO-8859-1 I inserted a row into a table via a CICS screen and then right away ran an unload job on that tablespace. The row I inserted didn't show up in the unloaded file because I had QUIESCE set to NO. So I guess it was still in the buffer and not flushed to disk. [...]
5364 82 41_Re: Buffer- how long does data stay here?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Mon, 29 Jun 2009 13:35:26 -0400362_us-ascii Anand,
Virtual Buffers are flushed at DB2 Checkpoints, and earlier if the DWQT or VDWQT thresholds are triggered. So if you have a not-particularly-busy system and your checkpoints are, say, 10 minutes, or even x-number-of-log-recs, your inserted row could go quite a long time before being written to the tablespace.
--Phil Sevetson [...]
5447 78 41_Re: Buffer- how long does data stay here?11_Mike Turner19_mike.turner@GMX.COM31_Mon, 29 Jun 2009 18:45:58 +0100305_iso-8859-1 Hi
If you ran the IBM DB2 Unload utility or you used DSNTIAUL (SQL application) then the new row would be read from the buffer. If you used a third-party Unload utility, they often bypass the buffer and read from the VSAM dataset directly and you therefore may not see the new row. [...]
5526 324 54_Re: The end of an era .... and the start of a new one!10_Roger Hecq18_Roger.Hecq@UBS.COM31_Mon, 29 Jun 2009 14:03:33 -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. [...]
5851 358 52_Re: How do I find out the Dataset names used by DB2.12_Isaac Yassin22_isaac.yassin@GMAIL.COM31_Mon, 29 Jun 2009 21:12:43 +0300319_ISO-8859-1 Hi
It's there - just waiting for someone from the team. I could not do it before as I was out at a customer site with no propere internet access
Isaac Yassin IBM Data Champion IBM Certified Solution Expert IBM Certified Database Administrator - DB2 for z/OS V8 & 9 IDUG Israel RUG [...]
6210 118 52_Re: [Z/OS] Reorg Utility - Using lots of Real Memory23_Barutcu, Cuneyt (SPFLD)27_Cuneyt.Barutcu@ILLINOIS.GOV31_Mon, 29 Jun 2009 13:13:49 -0500406_utf-8 Value of 0K or 0M is used to request the largest available region size. Did you try Thierry's recommendation?
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sangameswara.R.Panchomarthi@CHASE.COM Sent: Friday, June 19, 2009 12:11 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] [Z/OS] Reorg Utility - Using lots of Real Memory [...]
6329 65 76_DB2 Chat with the Lab: Enabling applications from Oracle to DB2 the easy way10_anne Stout23_anne.stout@DOWJONES.COM31_Mon, 29 Jun 2009 18:20:10 +0000
6395 51 32_Re: java jcc driver db2 packages13_Palko, George16_gpalko@OPERS.ORG31_Mon, 29 Jun 2009 18:29:23 +0100454_us-ascii Hi Peggy,
The Nullid, which is the default, can be changed by executing the DB2binder and DB2XSRBinder Utilities which are explained in the Installation Guide.
Regards, George
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of peggy.donovan@citigroup.com Sent: Monday, June 29, 2009 1:21 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] java jcc driver db2 packages [...]
6447 48 54_Re: The end of an era .... and the start of a new one!16_mocion@libero.it16_mocion@LIBERO.IT31_Mon, 29 Jun 2009 21:36:27 +0200670_windows-1252 Hi Phil
I'm sure you'll leave a road to find an highway :-). Good luck !
Max Scarpa Certified road runner (until next ravine).
Adam Baldwin ha scritto: > Phil - many, many thanks for all of your input, contributions and help - both on > and off list. You will be greatly missed. All the best for the future. > > A million thanks and best wishes. > > Adam. > > _____________________________________________________________________ > > * IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * > > _____________________________________________________________________ > > IDUG Europe Attendee Testimonial- > "This was [...]
6496 266 103_Re: [SPAM] - [DB2-L] The end of an era .... and the start of a new one! - Bayesian Filter detected spam18_McBride, Catherine18_CMcbride@KABLE.COM31_Mon, 29 Jun 2009 14:50:22 -0500310_iso-8859-1 Lisle is less than an hour from our location. It would be great having you on this side of the pond for a while. But we can also understand just how huge that type of relocation would be. Please stay active on the DB2-L list, you're one of the good guys and we all benefit from your knowledge. [...]
6763 147 52_Re: [Z/OS] Reorg Utility - Using lots of Real Memory0_37_Sangameswara.R.Panchomarthi@CHASE.COM31_Mon, 29 Jun 2009 16:17:35 -0400387_iso-8859-1 In our environment, we are recommended to use REGION=0M, system automatically assigns the available memory based on what else is running at that time. These REORG jobs are showing 960MB memory usage (above the bar) in the SDSF after the job completion.
After further research we have noticed that the same job is showing the usage 7.2 GB of HIPERSPACE for DFSORT. [...]
6911 126 103_Re: [SPAM] - [DB2-L] The end of an era .... and the start of a new one! - Bayesian Filter detected spam0_24_carol.sutfin@REGIONS.COM31_Mon, 29 Jun 2009 16:14:34 -0500546_US-ASCII Can't blaim you for not wanting to go to Lisle.
The location in Britian is much better. Winters can be awful in Illinois.
Carol Sutfin Corporate DBA Regions Financial Corp. (205)261-5214 carol.sutfin@regions.com
"McBride, Catherine" DB2-L@WWW.IDUGDB2-L.ORG Sent by: DB2 Data cc Base Discussion List Subject end of an era .... and the start of a new one! - Bayesian Filter detected spam 06/29/2009 02:50 PM [...]
7038 157 32_Re: z/OS Saving Access Path Data12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Mon, 29 Jun 2009 16:51:26 -0500584_us-ascii Tami:
On our download page there is a reference document showing the contrast between various levels of OSC support by DB2 Version. You have to register, but that is just to allow us to track who is downloading what. Hope this is of some help.
Gerald Hodge HLS Technologies.com www.hlstechnologies.com
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Van Dreese, Tami S Sent: Monday, June 29, 2009 10:54 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] z/OS Saving Access Path Data [...]
7196 113 48_z/OS V9 NF - OSC SQL text is all @@@@ characters11_Roy Boxwell16_R.Boxwell@SEG.DE31_Tue, 30 Jun 2009 07:27:35 +0200351_ISO-8859-1 Hi list!
I am too stupid to use OSC....when I wish to look at a package SQL I give the COLLID and PACKAGE name. It downloads the package SQL..but its all @@@@@ which looks either like EBCDIC in ASCII or the other way around...
What am I doing wrong????? or how can I tell the OSC what to do (CCSID conversions etc. etc.) [...]
7310 161 32_Re: java jcc driver db2 packages28_Balachandran Chandrasekaran119_balaccha@IN.IBM.COM31_Tue, 30 Jun 2009 11:23:41 +0530674_US-ASCII I think you may have to run the jdbc binder step after setting up the jdbc driver and before executing jdbc applications. There was a thread/post on this subject. If possible, try in the archives.
Or, search for "db2jdbcbind" on IBM's infocenter (simply, http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.admin.cmd.doc/doc/r0010332.html)
Regards, Bala
"peggy.donovan@citigroup.com" Sent by: DB2 Data Base Discussion List 29/06/2009 22:50 Please respond to DB2 Database Discussion list at IDUG [...]
7472 178 41_Re: Buffer- how long does data stay here?28_Balachandran Chandrasekaran119_balaccha@IN.IBM.COM31_Tue, 30 Jun 2009 11:33:32 +0530363_US-ASCII Hi Anand,
I guess, you had run either IBM Fast unload or BMC unload or other similar vendor product. Please have Quiesce Yes specified always as it may cause inconsistent unload file. I have myself faced such situation once.
If you are doing DSNUTILB or DSNTIAUL , it must pick committed rows in buffer automatically. Hope this helps. [...]
7651 118 32_Re: java jcc driver db2 packages13_Laila hosaini19_lshosaini@YAHOO.COM31_Tue, 30 Jun 2009 00:25:46 -0700491_iso-8859-1 you should bind or rebind SYSSTAT again. you can use BIND option on "DB2-CONNECT" THEN "CONFIGURATION ASSIST", right click on DB2 LOCATION which you are use.
another way to bind ;is on DOS-COMMAND-LINE CHANGE your current path to: :/SQLLIB/BIN AND THEN enter bellow command db2jdbcbind.exe -url jdbc:db2//SERVET-IPADDRESS:PORT/DB2-LOCATION -user USERNAME -PASSWORD
there is a point ,users with BINDADD privilage can issue this command. I hope ,this help. L.S.H [...]
7770 61 63_SQLCODE -904 while accessing Windows DB2 Data on Z/OS using DDF22_Devyani R Sahasrabudhe22_devyani.sah@IN.IBM.COM31_Tue, 30 Jun 2009 09:15:44 +0000292_windows-1252 Hi folks,
I am trying to get the data from windows DB2 server to mainframe server. I am trying to run SQL using three part name. However I am getting SQLCODE - 904. I have bound package DSNUGSQL against the DB2 subsystem and looks like CDB has been set up correctly. [...]
7832 92 67_Re: SQLCODE -904 while accessing Windows DB2 Data on Z/OS using DDF9_Chris Tee23_Chris.Tee@SENTENIAL.COM31_Tue, 30 Jun 2009 11:16:46 +0100517_us-ascii Devyani
You say that the z/OS DB2 is V8 but the reason code refers to V9 functionality, is it definitely V8? You say you have bound the DSNUGSQL package on z/OS but have you bound it on the Windows DB2 as well? You will need to do this if you intend to use the crossloader to pull the data from the Windows DB2. You don't say what you were trying when you got the -904 but it looks like you were trying access the remote system from Admin Tool, in which case you will need to bind the Admin Tool [...]
7925 187 57_Re: OT The end of an era .... and the start of a new one!14_Barbara Koenen33_barbara.koenen.bgit@STATEFARM.COM31_Tue, 30 Jun 2009 04:25:42 -0700413_us-ascii Some of us survive winters in Illinois just fine. I've been here over 20 years and except for the last couple, we've hardly had any snow. Now you do have to get used to the prairie winds, but growing up in Nebraska, that was bred into me.
I just spent a week down in Gulf Shores, Alabama, and while it was a lovely vacation, I couldn't handle that humidity all the time. Illinois has enough. [...]
8113 143 36_DB2 connect problem on DB2 z/OS V8CM14_Martin Flavell24_Martin.Flavell@I-TCS.COM31_Tue, 30 Jun 2009 12:36:18 +0100593_iso-8859-1 Hi,
I am in the process of upgrading DB2 under z/OS from version 7 to version 8. I have a development subsystem at V8 CM and a production subsystem at V7.
We use DB2 connect V8.1 on a windows server for most of the remote company access to the production system. During the testing we have found that remote machines running anything from DB2 Connect 8.2 to 9.1, whilst they can connect to the development subsystem, via the Connect server, they get SQLCode -30073, SQLState 58017 doing a number of functions. There are no problems going through to production or [...]
8257 423 40_Re: DB2 connect problem on DB2 z/OS V8CM12_Travis, John25_john.travis@CAPGEMINI.COM31_Tue, 30 Jun 2009 13:07:40 +0100503_us-ascii Martin,
What are the parameters and subcodes associated with the -30073 sqlcode? Did you set up the Unicode code page conversions required for the DB2 Connect Gateway?
Regards,
John Travis
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Martin Flavell Sent: 30 June 2009 12:36 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 connect problem on DB2 z/OS V8CM [...]
8681 255 57_Re: OT The end of an era .... and the start of a new one!15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM31_Tue, 30 Jun 2009 15:11:03 +0300608_ISO-8859-1 I have been in both Britain (London) and Chicago during the winter.
While Chicago gets a lot colder, your have heat and good insulation everywhere. Not in London.
On Tue, 30 Jun 2009 04:25:42 -0700 Barbara Koenen wrote:
:>Some of us survive winters in Illinois just fine. I've been here over :>20 years and except for the last couple, we've hardly had any snow. Now :>you do have to get used to the prairie winds, but growing up in :>Nebraska, that was bred into me. :> :>I just spent a week down in Gulf Shores, Alabama, and while it [...]
8937 97 74_Antwort: Re: [DB2-L] OT The end of an era .... and the start of a new one!11_Roy Boxwell16_R.Boxwell@SEG.DE31_Tue, 30 Jun 2009 14:14:52 +0200522_ISO-8859-1 I have been in both Britain (London) and Chicago during the winter.
While Chicago gets a lot colder, your have heat and good insulation everywhere. Not in London.
Unless you eat lots of hot curries and sleep in cardboard boxes - then its perfectly OK...
Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Straße 5 40470 Düsseldorf/Germany Tel. +49 (0)211 96149-675 Fax +49 (0)211 96149-32 Email: R.Boxwell@seg.de http://www.seg.de [...]
9035 445 40_Re: DB2 connect problem on DB2 z/OS V8CM9_Chris Tee23_Chris.Tee@SENTENIAL.COM31_Tue, 30 Jun 2009 13:17:17 +0100614_us-ascii Martin
Have a look at APAR JR21645 http://www-01.ibm.com/support/docview.wss?uid=swg1JR21645
Regards
Chris
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Martin Flavell Sent: 30 June 2009 12:46 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 connect problem on DB2 z/OS V8CM
Hi,
I am in the process of upgrading DB2 under z/OS from version 7 to version 8. I have a development subsystem at V8 CM and a production subsystem at V7. [...]
9481 404 40_Re: DB2 connect problem on DB2 z/OS V8CM14_Martin Flavell24_Martin.Flavell@I-TCS.COM31_Tue, 30 Jun 2009 13:15:01 +0100636_iso-8859-1 John,
The parameters and subcodes were both 0. Does the gateway need special Unicode conversion? We are using the default DB2 module which seems to have every conversion imaginable.
Regards, Martin Flavell
------------------------------------------------------------------------- IBM Certified Database Administrator -- DB2 UDB V8.1 for z/OS IBM Certified Database Administrator -- DB2 UDB V8.1 for Linux, Unix, Windows ------------------------------------------------------------------------- Technical Consultant Thesaurus Computer Services Ltd. Technical Infrastructure and Professional Services [...]
9886 363 40_Re: DB2 connect problem on DB2 z/OS V8CM14_Martin Flavell24_Martin.Flavell@I-TCS.COM31_Tue, 30 Jun 2009 13:55:01 +0100586_iso-8859-1 Thanks Chris, I'll try it and see the result.
Regards, Martin Flavell
------------------------------------------------------------------------- IBM Certified Database Administrator -- DB2 UDB V8.1 for z/OS IBM Certified Database Administrator -- DB2 UDB V8.1 for Linux, Unix, Windows ------------------------------------------------------------------------- Technical Consultant Thesaurus Computer Services Ltd. Technical Infrastructure and Professional Services
martin.flavell@i-tcs.com Telephone:01908 246500. Fax:01908 246555. WWW: www.i-tcs.com [...]
10250 22 41_Re: Buffer- how long does data stay here?5_anand19_mahadea@LABCORP.COM31_Tue, 30 Jun 2009 13:02:23 +0000683_ISO-8859-1 Thanks Phil and Mike. I didn't know about the distinction b/w DB2 Checkpoint and Commit, either! I'll follow up with the DBA's to find out about those DWQT and VDWQT parms.
_____________________________________________________________________
* 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!" _____________________________________________________________________
10273 275 57_Re: OT The end of an era .... and the start of a new one!10_Roger Hecq18_Roger.Hecq@UBS.COM31_Tue, 30 Jun 2009 09:04:03 -0400385_US-ASCII And Chicago has great food! London ?
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 Binyamin Dissen Sent: Tuesday, June 30, 2009 8:11 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] OT The end of an era .... and the start of a new one! [...]
10549 315 57_Re: OT The end of an era .... and the start of a new one!9_Stan Hoey22_shoey@CIRCLE-GROUP.COM31_Tue, 30 Jun 2009 14:16:24 +0100516_US-ASCII Guys,
I don't think I've ever flown through O'Hare without a connecting flight being delayed or cancelled, so my impression is jaundiced. Its too hot in the summer and too cold in the winter. Aside from having also been damaged by fire, there is no comparison between London and Chicago.
London is one of the cultural capitals of the world whereas Chicago might be the best place in Illinois (with due respect to the fine folks of Springfield). Despite this, it's a great place to visit. [...]
10865 365 57_Re: OT The end of an era .... and the start of a new one!10_Roger Hecq18_Roger.Hecq@UBS.COM31_Tue, 30 Jun 2009 09:28:57 -0400312_US-ASCII I have to be fair and honest. O'Hare is probably the worst airport to fly through and London is absolutely fascinating. After several visits, there is still soo much that I have not seen. The whole country is full of great history.
Roger Hecq MF IB USA DB Support 203-719-0492 / 19-337-0492 [...]
11231 387 40_Re: DB2 connect problem on DB2 z/OS V8CM14_Martin Flavell24_Martin.Flavell@I-TCS.COM31_Tue, 30 Jun 2009 14:55:25 +0100398_iso-8859-1 The exact messages I'm getting are 2 pop-up boxes containing
DSNT408I SQLCODE = -30073, SQLSTATE = 58017, SYSTEM ERROR FROM DB2 UDB for AIX, Linux, HP-UX, Sun, and Windows TOKENS 0x0000 0x0000
and
[IBM][CLI Driver] CLI0115E Invalid cursor state. SQLSTATE=24000
Both DB2 Connect systems - my local one and the server - have RQRIOBLK set at 32767 already. [...]
11619 759 40_Re: DB2 connect problem on DB2 z/OS V8CM9_Chris Tee23_Chris.Tee@SENTENIAL.COM31_Tue, 30 Jun 2009 15:43:40 +0100553_us-ascii Martin
What fixpak level is your Connect server at? Working on previous V8 migrations, I have found that numerous errors occurred when trying to connect from back-level versions of Connect. The best solution is to get the latest fixpak on as soon as possible.
Chris
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Martin Flavell Sent: 30 June 2009 15:19 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 connect problem on DB2 z/OS V8CM [...]
12379 437 57_Re: OT The end of an era .... and the start of a new one!12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Tue, 30 Jun 2009 09:51:22 -0500547_us-ascii Roger:
This is just unbelievable. Chicago is one of the best places I have found to go through Immigration and Customs in the US. I am traveling through it at least once to twice a month. The other airport is DFW in Texas. Weather is an issue in the American Midwest and any airport in the Midwest has seasonal issues. London City Airport is by far the best way in and out of London to the Continent for a business traveler. The other airports in London are no match for O'Hare or DFW. I have accumulated over 3 million miles [...]
12817 308 57_Re: OT The end of an era .... and the start of a new one!0_24_carol.sutfin@REGIONS.COM31_Tue, 30 Jun 2009 10:02:47 -0500388_UTF-8 Gerald
I can speak with great knowledge about Chicago, I was born across the street from Chicago, literally, and lived there for almost 40 years. Went to school there and my family has been there since 1910.
Great place to visit, culture, food, public transportation are wonderful.
Traffic, crowds, and weather in the winter are things I can live without. [...]
13126 481 57_Re: OT The end of an era .... and the start of a new one!10_Roger Hecq18_Roger.Hecq@UBS.COM31_Tue, 30 Jun 2009 11:18:37 -0400405_US-ASCII What a brouhaha I have stirred up.
Immigration & Customs are a breeze in Chicago and Dallas, compared to JFK. Been there, done that, and agree. I have never been to the London City airport. When I don't have a direct flight, I always endup changing at Heathrow, where they have always been very good at finding out where my luggage was sent and getting it rerouted to my destination. [...]
13608 86 37_Re: undocumented reason code 00E400C816_Broyles, Carol L27_Carol.L.Broyles@ACS-INC.COM31_Tue, 30 Jun 2009 10:21:33 -0500323_iso-8859-1 Hi JR,
I've been on vacation so hope my response isn't too dated. We back up many SAP systems using the IBM COPY utility. We use a REXX to build the backup JCL and submit it. We mirror production systems at our hotsite for DR but we also take image copies of everything (including the test systems). [...]
13695 26 32_Re: java jcc driver db2 packages27_peggy.donovan@citigroup.com27_Peggy.donovan@CITIGROUP.COM31_Tue, 30 Jun 2009 15:30:27 +0000434_windows-1252 We currently bind the packages into the application ID's. But are not happy with that solution due to increase binds as more applications move to the new driver & ongoing upgrades of the software. I was just hoping someone knew a way around this. Thanks again. Peggy
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...]
13722 805 57_Re: OT The end of an era .... and the start of a new one!0_22_sally.mir@WACHOVIA.COM31_Tue, 30 Jun 2009 11:53:58 -04006_UTF-8
14528 826 57_Re: OT The end of an era .... and the start of a new one!0_22_sally.mir@WACHOVIA.COM31_Tue, 30 Jun 2009 11:53:58 -0400356_UTF-8 The closing of The Berghoff was a travesty! Also Marshall Field's. The Loop will never be the same.... How sad. :(
Roger Hecq To Sent by: DB2 Data DB2-L@WWW.IDUGDB2-L.ORG Base Discussion cc List Re: OT The end of an era .... and the start of a new one! [...]
15355 29 57_Re: OT The end of an era .... and the start of a new one!11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Tue, 30 Jun 2009 17:07:04 +0000320_- >This is just unbelievable. Chicago is one of the best places I have found to go through Immigration and Customs in the US. I am traveling through it at least once to twice a month. The other airport is DFW in Texas. Weather is an issue in the American Midwest and any airport in the Midwest has seasonal issues. [...]
15385 319 40_Re: DB2 connect problem on DB2 z/OS V8CM12_Myron Miller22_myronwmiller@YAHOO.COM31_Tue, 30 Jun 2009 13:52:42 -0700439_us-ascii Unless you're at least fp10 on DB2 Connect 8.1, these type of errors will happen. That's a pretty solid release for V8 NFM of DB2 Z/OS but anything less can experience all types of wierd errors.
________________________________ From: Martin Flavell To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Tuesday, June 30, 2009 9:55:25 AM Subject: Re: [DB2-L] DB2 connect problem on DB2 z/OS V8CM [...]
15705 219 0_15_Russell Collins28_Russell.Collins@MCLANEAT.COM31_Tue, 30 Jun 2009 15:57:04 -0500283_us-ascii I am having some issue with the restore command on DB2 Express so I may be on the wrong list. I have done a search for this issue but there has not been a solution that I can find but it seems like it would be simple. Please note that I am kind of new so bear with me. [...]
15925 96 54_Re: The end of an era .... and the start of a new one!12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 30 Jun 2009 21:01:16 +0000547_windows-1252 I decided to learn from others and not make any remarks about geography in my note. As with many others, I'm grateful for all you've done for DB2 and our customers in the past, looking forward to the next step in your future. I've learned from your classes, helped fix some of your complaints, and enjoyed your company. I'm expecting that you'll have a solid class on DB2 X in the future, and maybe one on DB2 XI too. We'll need to enjoy a beverage some time soon, even if mine is Diet Coke, toasting your new employment. In the [...]
16022 198 36_Re: SQL0968C The File System is Full12_tim malamphy20_timalamphy@YAHOO.COM31_Tue, 30 Jun 2009 14:16:39 -0700419_iso-8859-1 Assuming the restore is on a different system than where the backup was taken, I'll take a wild guess and say one of your file systems is filling during the Restore process. As an even wilder guess, I'd bet it's the filesystem that you're trying to restore the database into. My suggestion:Make sure the filesystem you are restoring into, is at least as big as the filesystem holding the live database. [...]
16221 164 44_[DB2 v9 z/OS] OPTIONS PREVIEW and INDEX COPY14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 30 Jun 2009 17:48:33 -0400488_us-ascii Can anyone come up with a good reason why OPTIONS PREVIEW doesn't notice that an index isn't copyable, when it's included in a COPY LIST? We had a production ABEND and I got a (an unfortunately deserved) chewing-out because of an error I made, which we'd have caught if the test run had noticed that one of the indexes I was trying to copy was set to COPY NO. OPTIONS PREVIEW ended with the standard RC=04, but when I ran the utility, it terminated with RC=08 on the issue. [...]
16386 133 41_Re: Buffer- how long does data stay here?16_Robert Catterall21_rfcatterall@GMAIL.COM31_Tue, 30 Jun 2009 18:04:06 -0400467_windows-1252 Anand,
COMMIT just forces a write to the transaction log so that the data change can be re-done in a recovery situation - it doesn't externalize the changed data or index page to disk (in a data sharing environment, changed pages of group buffer pool-dependent data sets are externalized to the appropriate group buffer pool in a coupling facility at commit, but those pages will not be written to disk until a subsequent CASTOUT operation). [...]
16520 28 31_DB2 Connect V8 Error CLI Driver5_Kevin27_kevin.anderson@MARRIOTT.COM31_Tue, 30 Jun 2009 22:29:38 +0000469_windows-1252 Has anyone seen this error '[IBM][CLI Driver] SQL8002N Connect processing failed; a valid product license was not found. SQLSTATE=42968'
I am using DB2 Connect Unlimited edition Version 8 on AIX. Trying to connect to DB2 z/OS.
The DB2 Connect license is valid. Expiration date: Permanent
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...]