1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l March 2008, week 5
2 37 24_Re: View Materialization15_Patrick Bossman18_bossman@US.IBM.COM31_Fri, 28 Mar 2008 17:44:28 +0000580_UTF-8 Hi Jorg, In recent releases, we've worked at improving the filter factor estimates for a limited and frequently occuring set of correlated subqueries. (In particular, correlated subqueries where the referencing table, and the correlated subquery table are the same table). Your case is not one of those.
What OSC can show you here is that DB2 has a challenge with the filter factor estimate for the correlated subquery, and it can result in a lower estimated number of rows than what actually occurs. This may or may not result in optimizer making a bad choice. [...]
40 85 51_Enabling Optimization Service Center on DB2 z/OS v80_26_MarkVickers@GROCERYBIZ.COM31_Fri, 28 Mar 2008 10:34:24 -0500487_US-ASCII There are two jobs supplied in DB2 z/OS v9 to enable OSC on the server.
We have v8, so does anyone know how to do this on v8 ?
Optimization Service Center enablement The Optimization Service Center functions are enabled on the DB2 subsystem. Two jobs, which are delivered with DB2 Version 9.1 for z/OS, must be run to enable each to work with Optimization Service Center. The sample JCL jobs DSNTIJOS and DSNTIJRA are provided in the SDSNSAMP target library. [...]
126 37 4_z/os12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Fri, 28 Mar 2008 16:18:06 -0400305_US-ASCII Hello, quick question, is there a z/os list server group? TIA
______________________________________________________________________
* IDUG 08 Warsaw, Poland * 13-17 October 2008 * http://IDUG.ORG/lsEU * ______________________________________________________________________
164 171 55_Re: Stored Procedure SQLCODE Handling - DB2 V7 for z/OS12_Reavill, Jay22_Jay.C.Reavill@FNIS.COM31_Fri, 28 Mar 2008 08:11:47 -0500352_us-ascii Hi Myron,
Now that I've had a little more time to think about this I'm wondering...
With a triggered call how does the SQLCODE get passed back to the program that performed the triggering action?
Say a program updates a row which fires a trigger that calls a stored procedure that performs another update that fails. [...]
336 574 55_Re: Stored Procedure SQLCODE Handling - DB2 V7 for z/OS12_Reavill, Jay22_Jay.C.Reavill@FNIS.COM31_Fri, 28 Mar 2008 08:13:54 -0500825_us-ascii Hi Agus,
Both, but the main lack of clarity is in regard to triggered calls.
Thanks,
Jay
-------------------------------------------------------------
Jay Reavill
DBA
Fidelity National Information Services, Inc.
11601 Roosevelt Blvd.
St. Petersburg, FL. 33716
Office (727) 227-2144
Mobile (727) 215-5794
Jay.Reavill@fnis.com
-------------------------------------------------------------
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of askwe@OPTONLINE.NET Sent: Thursday, March 27, 2008 8:29 PM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] Stored Procedure SQLCODE Handling - DB2 V7 for z/OS [...]
911 151 51_Re: Question re. Dclgen host vars & Cobol host vars0_24_Mohammad_Khan@BCBSIL.COM31_Fri, 28 Mar 2008 08:13:37 -0500395_us-ascii There is another issue that plays out now ( post version 7) - multi row fetch and insert. The host variable arrays needed for these operations are not provided by DCLGEN which will force the use of manually coded host variables and possible type errors. I wish there were some automated facility to do, probably something like : EXEC SQL INCLUDE TABLEABC OCCURS n END-EXEC. Khalid [...]
1063 165 60_Re: Is SQL Procedure Debugger still available for DB2 z/OS ?13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Fri, 28 Mar 2008 18:28:14 -0400656_us-ascii Hello Agus,
I don't know the answer. I've had trouble connecting from Data Studio since re-installing DB2. And I haven't had time to chase it down.
But have you tried the IBM forum for Data Studio? http://www.ibm.com/developerworks/forums/forum.jspa?forumID=1086&start=0
Good luck 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. [...]
1229 48 8_Re: z/os14_Avram Friedman25_ibmsysprog@GEEK-SITES.COM31_Sat, 29 Mar 2008 12:07:23 +0000398_utf-8 Jeffery Yes there is a "z/os" group: IBM-MAIN I assume you would like to know how to get to it and join as well. http://bama.ua.edu/cgi-bin/wa?A0=ibm-main Select the item (forth down in the main column) that says Join or leave the list (or change settings)
Regards Avram Friedman
On Fri, 28 Mar 2008 16:18:06 -0400, Jeff Frazier wrote: [...]
1278 22 55_Re: Enabling Optimization Service Center on DB2 z/OS v815_Patrick Bossman18_bossman@US.IBM.COM31_Sat, 29 Mar 2008 19:43:13 +0000776_UTF-8 Hi Mark, I think this is what you're looking for: PK58941: ADDITIONAL FUNCTION OF DB2 FOR Z/OS OPTIMIZATION SERVICE CENTER
Regards, Pat
______________________________________________________________________
* IDUG 08 Warsaw, Poland * 13-17 October 2008 * http://IDUG.ORG/lsEU * ______________________________________________________________________
The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership [...]
1301 197 55_Re: Stored Procedure SQLCODE Handling - DB2 V7 for z/OS12_Myron Miller22_myronwmiller@YAHOO.COM31_Sat, 29 Mar 2008 15:42:16 -0700311_iso-8859-1 Your trigger is going to have to intercept the returned variable from the sp and then fire some type of code that sets the code back for the caller. I think that there's a way to do this, but at the moment I don't remember and I'm a long ways away from work right now so it's not easy to check. [...]
1499 246 51_Re: Question re. Dclgen host vars & Cobol host vars12_Troy Coleman25_troy.coleman@SOFTBASE.COM31_Fri, 28 Mar 2008 08:59:03 -0500504_windows-1252 Hi John, Again, if I have a PIC X(02) in WS-VARIABLE.WS-STATE-CODE and PIC X(02) in :DCLDSD-GV-WET.STATE-CODE then you will get the same access path unless runstats has changed and DB2 picks something else.
Troy Coleman, Support Engineer IBM Certified Solutions Expert
SoftBase Systems, Inc. 847-776-0618 828-670-9900 ext. 334 troy.coleman@softbase.com
Compliance Challenged with Test Data Privacy? White Papers and More at http://www.softbase.com/ [...]
1746 458 55_Re: Stored Procedure SQLCODE Handling - DB2 V7 for z/OS0_19_askwe@OPTONLINE.NET31_Sat, 29 Mar 2008 14:38:53 +0000589_us-ascii Hi Jay,
If the stored procedure is invoked using 'exec sql call' then the stored procedure can return its sqlcode and other sqlca field values via the call parameters.
If the stored procedure is triggered by sql insert/update/delete statements, then the only way for the application program to receive sqlca values from the stored procedure is if the stored procedure abends right away after receiving the negative sqlcode value. This is only possible if the stored procedure is coded in SQL Procedure Language that does not issue any 'exit handler' statement. [...]
2205 38 43_How can I verify that the DB2 port is open?15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM31_Sat, 29 Mar 2008 23:01:32 +0300280_us-ascii Got message
DSNL519I -DB8G DSNLIRSY TCP/IP SERVICES AVAILABLE FOR DOMAIN domain AND PORT number
How can I verify the port?
I tried TELNETing in on the port, but timed out before a data request. I would think that telnet should open something.
2244 76 47_Re: How can I verify that the DB2 port is open?12_Troy Coleman25_troy.coleman@SOFTBASE.COM31_Sat, 29 Mar 2008 23:39:30 -0500394_ISO-8859-1 Pull up the DB2 Master Address Space in SDSF and do a find on "DDF" Look at the following message: DSNL004I -DB9G DDF START COMPLETE 666 LOCATION DB9GLOC LU USAxxx02.DB9GLU1 GENERICLU -NONE DOMAIN xxxxx.yyyyy.com TCPPORT 50012 SECPORT 0 RESPORT 50013 IPNAME -NONE
You can reach this DB2 on port 50012.
Troy Coleman, Support Engineer IBM Certified Solutions Expert [...]
2321 222 55_Re: Stored Procedure SQLCODE Handling - DB2 V7 for z/OS14_Michael Kaplan25_micaelkp@NETVISION.NET.IL31_Sat, 29 Mar 2008 19:17:00 +0300363_us-ascii Hi Jay,
You are right: you can set SQLSTATE not only in AIX but also in MainFrame. I have done it in my COBOL SP program which is called from Trigger.
The "trick" is to use PARAMETER STYLE DB2SQL . Then, you should add all necessary definitions, including SQLSTATE and DIAGNISTIC MESSAGE, to COBOL program linkage section. [...]
2544 248 55_Re: Stored Procedure SQLCODE Handling - DB2 V7 for z/OS10_Dave Churn19_davechurn@GMAIL.COM31_Fri, 28 Mar 2008 11:42:59 -0500435_WINDOWS-1252 Jay,
When dealing with a triggered stored procedure, the calling program will always get a -438 (trigger failed) SQLCODE when something in the stored procedure causes and abend. Note, we have not found a way to get the trigger to pass back anything from the stored procedure that it calls.
With a called stored procedure, you can define a parameter to pass the SQLCODE back. (and add the program logic) [...]
2793 177 60_Re: Is SQL Procedure Debugger still available for DB2 z/OS ?0_19_askwe@OPTONLINE.NET31_Sat, 29 Mar 2008 17:25:05 +0000378_us-ascii Hi Dave,
Thank you for telling me about the IBM Forum for Data Studio. I have posted my question in that forum.
Thanks, Agus Kwee Themis Training
----- Original Message ----- From: "Seibert, Dave" Date: Saturday, March 29, 2008 11:05 am Subject: Re: [DB2-L] Is SQL Procedure Debugger still available for DB2 z/OS ? To: DB2-L@www.idugdb2-l.org [...]
2971 168 55_Re: Enabling Optimization Service Center on DB2 z/OS v814_Adrian Collett24_adriancollett@TISCALI.IT31_Sat, 29 Mar 2008 14:31:18 +0100559_ISO-8859-1 Mark, check out: PK58941 It should cover OSC enablement for V8. If it works let us know... we're just about to go down that road as well.. :-) Ciao, Adrian
MarkVickers@GROCERYBIZ.COM ha scritto: > > There are two jobs supplied in DB2 z/OS v9 to enable OSC on the server. > > We have v8, so does anyone know how to do this on v8 ? > > *Optimization Service Center enablement* > > The Optimization Service Center functions are enabled on the DB2 > subsystem. Two jobs, which are delivered with DB2 Version 9.1 for > z/OS, must be [...]
3140 62 47_Re: How can I verify that the DB2 port is open?15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM31_Sun, 30 Mar 2008 11:15:00 +0300398_us-ascii On Sat, 29 Mar 2008 23:39:30 -0500 Troy Coleman wrote:
:>Pull up the DB2 Master Address Space in SDSF and do a find on "DDF" :>Look at the following message: :>DSNL004I -DB9G DDF START COMPLETE 666 :> LOCATION DB9GLOC :> LU USAxxx02.DB9GLU1 :> GENERICLU -NONE :> DOMAIN xxxxx.yyyyy.com :> TCPPORT 50012 :> SECPORT 0 :> RESPORT 50013 :> IPNAME -NONE [...]
3203 142 55_Re: Stored Procedure SQLCODE Handling - DB2 V7 for z/OS0_25_jacampbell@ACSLINK.NET.AU31_Sun, 30 Mar 2008 14:42:52 +1100517_US-ASCII If the called SP was created with PARAMETER STYLE SQL and sets an SQLSTATE of '38xxx' (see the Appendix in DB2 Codes for values which have a reserved meaning), then the caller will receive SQLCODE -443 from the call. The SP might also set up the diagnostic message parameter with, well what ever it likes - in your case a failing SQLCODE and other diagnostics seem good. This message will be returned to the caller as one of the tokens. This applies whether the caller is a trigger or application code. [...]
3346 34 74_Recommendations on free ODBC/JDBC drivers for Windows XP (to connect to Z)15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM31_Sun, 30 Mar 2008 14:20:02 +0300196_us-ascii Are there any IBM supplied drivers, available via PW or on the ADCD?
If not, any recommendations on cheap ones. They will not be used for production - just for development.
3381 71 78_Re: Recommendations on free ODBC/JDBC drivers for Windows XP (to connect to Z)7_Ed Long19_rdhm99a@PRODIGY.NET31_Sun, 30 Mar 2008 08:17:13 -0700476_iso-8859-1 I assume your looking for an LUW driver. I believe the z/OS ODBC/JDBC driver comes with DB2 for z. For that, you will need an ADCD contract.
If you are a PWD member, and you pay for access to the software access catalog (SAC), or whatever its now called, you can download a copy of DB2/LUW V8 or V9 which installs the production ready ODBC and JDBC drivers used by many. I always install EE not connect so I can do lots of local stuff at the same time. [...]
3453 1002 55_Re: Stored Procedure SQLCODE Handling - DB2 V7 for z/OS14_Michael Kaplan25_micaelkp@NETVISION.NET.IL31_Sun, 30 Mar 2008 19:23:19 +0300507_us-ascii Hi,
Just to illustrate what James has explained:
This is an example what the Client program gets when SP Cobol Program fill SQLSTATE and Diag-Message files ( using DB2SQL Parameter Style):
DSNT408I SQLCODE = -723, ERROR: AN ERROR OCCURRED IN A TRIGGERED SQL
STATEMENT IN TRIGGER MNMSHD1D.UPDMRD, SECTION NUMBER 2.
INFORMATION RETURNED: SQLCODE -443, SQLSTATE 38MRD, AND MESSAGE [...]
4456 90 47_Re: How can I verify that the DB2 port is open?12_Troy Coleman25_troy.coleman@SOFTBASE.COM31_Sun, 30 Mar 2008 18:49:53 -0500337_ISO-8859-1 I don't think you can connect to DB2 using telent. But for grins I did try to connect to DB2 on z/OS using telnet ipaddress port. Telent just hung.. no response, which is more than I was expecting. I figured it would just drop off without even trying.
Troy Coleman, Support Engineer IBM Certified Solutions Expert [...]
4547 57 22_partitioning question.14_Renzo razzetti24_renzo.razzetti@GMAIL.COM31_Mon, 31 Mar 2008 09:15:18 +0800495_ISO-8859-1 Hi Folks,
My customer have a plan to parition existing tables, they will add a new column PTT_NBR, which shall be used as partition index column. They also plans to change the clustering key of the partitioned table. Column PTT_NBR will be the new clustering key, and the index for the column that was originally used as the clustering key will be kept, but it will not be used as clustering index any more. Both the newly added column and the original column are unique. [...]
4605 70 47_Re: How can I verify that the DB2 port is open?14_Wayne Driscoll22_wdriscoll8@COMCAST.NET31_Sun, 30 Mar 2008 23:17:50 -0500297_us-ascii If you have any software that can act as a DRDA requestor, (such as DB2 Connect Personal Edition) you can define a remote connection through that. DB2 connect is (in my opinion) the easiest option, although you could also set up a DDF connection from one DB2 z/OS system to another. [...]
4676 34 37_GALLAGHER, BILL is out of the office.0_28_BILL.GALLAGHER@PHOENIXWM.COM31_Mon, 31 Mar 2008 04:00:46 -0400817_US-ASCII I will be out of the office starting 03/30/2008 and will not return until 04/01/2008.
If you need immediate assistance, please contact Jean Williams at x5945.
----------------------------------------- ******************************************************************* CONFIDENTIAL: This communication, including attachments, is intended only for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information. If you are not the intended recipient, you are hereby notified that you have received this document in error, and any use, review, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and [...]
4711 61 26_Re: partitioning question.14_Peter Vanroose26_peter_vanroose@YAHOO.CO.UK31_Mon, 31 Mar 2008 10:06:32 +0200602_iso-8859-1 > 1. Is there any performance impact after changing the original > clustering index to non clustering index ?
Yes: assuming you do the usual reorg & runstats & rebind, you'll see some "list prefetch" access appear (for the old cluster index) and disappear (for the new cluster index), or index choices change (typically to the new cluster index, to avoid a list prefetch, but sometimes just the other way around, e.g. in case of a "FOR UPDATE" cursor). If you do the reorg but not the rebind, you'll most certainly notice some performance degradation (minor or major: depends on [...]
4773 43 47_Re: How can I verify that the DB2 port is open?14_Peter Vanroose26_peter_vanroose@YAHOO.CO.UK31_Mon, 31 Mar 2008 10:11:18 +0200355_iso-8859-1 Isn't there any documentation on the (low-level) TCP/IP data protocol used by DRDA? Based on that, it should be easy to write a small script (e.g. in Perl) that contacts the port and interprets the returned message.
-- Peter.
4817 27 52_CN=Thomas Frieske/OU=IL/O=HCSC is out of the office.0_25_Thomas_Frieske@BCBSIL.COM31_Mon, 31 Mar 2008 03:19:35 -0500609_us-ascii I will be out of the office starting 03/31/2008 and will not return until 04/07/2008.
**********
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. [...]
4845 34 48_Is a DB2 Connect license indluded with the ADCD?15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM31_Mon, 31 Mar 2008 13:51:13 +0300124_us-ascii Is a DB2 Connect license included with the ADCD?
Didn't see that it was priced when I downloaded it.
4880 1509 55_Re: Stored Procedure SQLCODE Handling - DB2 V7 for z/OS12_Reavill, Jay22_Jay.C.Reavill@FNIS.COM31_Mon, 31 Mar 2008 07:39:44 -0500728_us-ascii Thanks to everyone! This is excellent information!
-------------------------------------------------------------
Jay Reavill
DBA
Fidelity National Information Services, Inc.
11601 Roosevelt Blvd.
St. Petersburg, FL. 33716
Office (727) 227-2144
Mobile (727) 215-5794
Jay.Reavill@fnis.com
-------------------------------------------------------------
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Michael Kaplan Sent: Sunday, March 30, 2008 11:23 AM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] Stored Procedure SQLCODE Handling - DB2 V7 for z/OS [...]
6390 66 52_Re: Is a DB2 Connect license included with the ADCD?12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Mon, 31 Mar 2008 08:29:42 -0500286_us-ascii All that we have been able to find is the personal edition at $489.00 a copy. We have purchased a Z/9 and run the Z/OS software under license from IBM for development. There used to be a free Personal Edition for developers, but w cannot find it for the current editions. [...]
6457 66 52_Re: Is a DB2 Connect license indluded with the ADCD?12_Troy Coleman25_troy.coleman@SOFTBASE.COM31_Mon, 31 Mar 2008 08:29:50 -0500424_ISO-8859-1 DB2 Connect is not on the ADCD tape. DB2 Connect is only need on your client side. As mentioned by Ed Long in your message titled "Recommendations on free ODBC/JDBC drivers for Windows XP (to connect to Z)" you need to purchase the Software Access Catalog also known as the Software Mall. You can then download and install DB2 Connect or DB2 Enterprise Edition which includes the drivers to connect to z/OS. [...]
6524 23 24_Re: View Materialization10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Mon, 31 Mar 2008 14:32:32 +0000357_utf-8 Thanks Patrick, this has been extremely helpful to me. I do love the oSC and the access path graphs, that has really helped even in modeling some query types with cost category A and B. If the additional pieces included in optimization expert are as good I will make every effort to get the company to pay the few extra dollars for that license. [...]
6548 321 57_ADMIN: Errors/bounce backs reporting non receipt of posts16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Mon, 31 Mar 2008 11:48:36 -0400584_iso-8859-1 In the hope of keeping the subscribers up to date I am postings another one of my updates to the list (feel free in deleting)
1) As we have been going through the bounce backs that the listserv receives, we have been noticing some interesting items.
A) A couple of domains rely on a blacklist that has been closed for more then one year. See sample error message below 5.7.1 554 5.7.1 Service unavailable; Client host [xx.xxx.xxx.xx] blocked using relays.ordb.org; ordb.org was shut down on December 18, 2006. Please remove from your mailserver. [...]
6870 124 70_OSC connection to z/OS error sqlstate 42968 - JDBC driver not licensed12_Troy Coleman25_troy.coleman@SOFTBASE.COM31_Mon, 31 Mar 2008 11:31:16 -0500535_UTF-8 Hello List, I currently have DB2 ESE 9.5 on a Vista Business edition macine. I have connected to DB2 9 for z/OS without a problem. I have data studio installed and connect to DB2 9 for z/OS without a problem also. Now I'm trying to use OSC V1.1 Fixpak 4 and am receiving a license error. My classpath was using SQLLIB driver db2cc_license_cu.jar Since I was having problems I tried pulling in db2cc_license_cisuz.jar and added that to my classpath but that didn't help. Any ideas from the list would be greatly appreciated. [...]
6995 44 35_DB2 PM report Accounting statistics5_Rao A17_a.rao08@YAHOO.COM31_Mon, 31 Mar 2008 09:41:17 -0700514_us-ascii I am looking for a list of parameters to be included in the SYSIN card of my JCL to produce a DB2PM Accounting Report at a package level for a particular time period with a long layout. Can someone provide me with the list of parameters?
Thanks Rao
____________________________________________________________________________________ Like movies? Here's a limited-time offer: Blockbuster Total Access for one month at no cost. http://tc.deals.yahoo.com/tc/blockbuster/text4.com [...]
7040 175 26_Re: partitioning question.14_Case, Missy J.24_Missy.Case@FIRSTDATA.COM31_Mon, 31 Mar 2008 12:01:13 -0500601_us-ascii *** Warning:::: What follows is strictly my opinion, not foolproof, just based on my experience!
I can't help but throw a suggestion out here. Don't do it! Creating a false column to partition a table on is rarely a good idea.
From a design perspective, no customer/user will EVER want to see the data in that column, and won't want their data in that order anyway, so you've basically forced an order by on almost every online access that will now require a sort, when previously you retrieved by clustering or other index, not saying you never sorted before, but [...]
7216 77 47_Re: How can I verify that the DB2 port is open?12_tim malamphy20_timalamphy@YAHOO.COM31_Mon, 31 Mar 2008 10:31:03 -0700624_iso-8859-1 netstat command
will return more information about your ports than you want to know
--- Binyamin Dissen wrote:
> Got message > > DSNL519I -DB8G DSNLIRSY TCP/IP SERVICES AVAILABLE > > FOR DOMAIN domain AND PORT number > > How can I verify the port? > > I tried TELNETing in on the port, but timed out > before a data request. I would > think that telnet should open something. > > -- > Binyamin Dissen > http://www.dissensoftware.com > > Director, Dissen Software, Bar & Grill - Israel > > > Should you use the mailblocks package [...]
7294 81 47_Re: How can I verify that the DB2 port is open?15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM31_Mon, 31 Mar 2008 20:38:45 +0300364_us-ascii On Sun, 30 Mar 2008 18:49:53 -0500 Troy Coleman wrote:
:>I don't think you can connect to DB2 using telent. But for grins I did :>try to connect to DB2 on z/OS using telnet ipaddress port. :>Telent just hung.. no response, which is more than I was expecting. :>I figured it would just drop off without even trying. [...]
7376 573 26_Re: partitioning question.12_Weaver, Rick19_Rick_Weaver@BMC.COM31_Mon, 31 Mar 2008 12:40:26 -0500375_us-ascii There is relief for this type of situation with DB2 9. The new Universal Tablespace allows for Partition By Growth. No partitioning key is required, so there is no partitioning index.
I know DB2 9 is a future (maybe distant future) option for some customers, but UTS is one of the reasons many customers will go there sooner than normal. [...]
7950 81 39_DB2z OLR Parameters to Avoid RC00C900BA5_Lance25_lance.d.ziegler1@AEXP.COM31_Mon, 31 Mar 2008 17:42:49 +0000
8032 162 26_Re: partitioning question.9_Mike Bell21_mbell11a1@VERIZON.NET31_Mon, 31 Mar 2008 13:03:59 -0600570_windows-1250 Just want to agree that a generated partition id is usually a bad design choice.
The last time I dealt with a design that had a partition number that was assigned by the application, 2 things happened. 1. the subroutine that assigned the partiton had to be modified several times during the course of the project because the data did not split the way they expected. keeping track of what data was in what partition became a major set of code. 2. because the data was split, all the batch processes ended up with major IO issues that were never [...]
8195 97 47_Re: How can I verify that the DB2 port is open?12_Troy Coleman25_troy.coleman@SOFTBASE.COM31_Mon, 31 Mar 2008 14:41:49 -0500594_ISO-8859-1 You didn't telnet to that port, just to the machine. Correct?
-Troy
Binyamin Dissen wrote: > On Sun, 30 Mar 2008 18:49:53 -0500 Troy Coleman > wrote: > > :>I don't think you can connect to DB2 using telent. But for grins I did > :>try to connect to DB2 on z/OS using telnet ipaddress port. > :>Telent just hung.. no response, which is more than I was expecting. > :>I figured it would just drop off without even trying. > > The problem was that the ports were not properly defined through two routers. > > Once defined, [...]
8293 150 26_Re: partitioning question.12_Troy Coleman25_troy.coleman@SOFTBASE.COM31_Mon, 31 Mar 2008 14:52:52 -0500543_ISO-8859-1 I fully agree with Missy on this. The other issue you may find is changing the clustering index on one table can caused you a huge performance problem if the other tables you are joining with do not have the same clustering. When I was consulting I was brought into a customer site that had done this and they could not figure out why all of a sudden the CICS transactions are taking for ever to run. I found the changed table and had them change it back. This was real dollars lost, they estimated the fix saved them $400.000 [...]
8444 100 39_DB2z OLR Parameters to Avoid RC00C900BA16_Lance D Ziegler125_Lance.D.Ziegler1@AEXP.COM31_Mon, 31 Mar 2008 12:59:05 -0700
8545 97 47_Re: How can I verify that the DB2 port is open?15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM31_Mon, 31 Mar 2008 23:55:40 +0300633_us-ascii No, to that port.
Some other ports on that machine did work OK as they were properly forwarded.
On Mon, 31 Mar 2008 14:41:49 -0500 Troy Coleman wrote:
:>You didn't telnet to that port, just to the machine. Correct? :> :>-Troy :> :> :> :>Binyamin Dissen wrote: :>> On Sun, 30 Mar 2008 18:49:53 -0500 Troy Coleman :>> wrote: :>> :>> :>I don't think you can connect to DB2 using telent. But for grins I did :>> :>try to connect to DB2 on z/OS using telnet ipaddress port. :>> :>Telent just hung.. no response, which is more than [...]
8643 48 24_DB2 z/OS v8 SQL Question13_FRITZ LEBLANC27_FRITZ.LEBLANC@SALLIEMAE.COM31_Mon, 31 Mar 2008 17:21:06 -0400322_utf-8 Hi!
I have a table with 2 columns, item_name and eff_date. I need to create a query which returns the item_name and the range of effective dates. For example, I have the following data:
I need results that look like the following:
Appreciate the help.
Thanks!
Fritz
8692 84 44_Error while running the application in V8 CM15_Attuluri, Vidya27_Vidya.Attuluri@MARRIOTT.COM31_Mon, 31 Mar 2008 17:44:47 -0400324_us-ascii All,
We just moved one of our test substems to V8 CM and when we try to run our java application it fails with JDBC SQLException CLI0611E Invalid Column Name.
The application runs fine with V7.
Is there any change to JDBC driver behaviour? The SQL that it is failing is a UNION statement. [...]
8777 380 28_Re: DB2 z/OS v8 SQL Question11_Bear, Brian23_Brian.Bear@CHARMING.COM31_Mon, 31 Mar 2008 17:53:04 -0400541_US-ASCII You pics didn't make it through.
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of FRITZ LEBLANC Sent: Monday, March 31, 2008 5:21 PM To: DB2-L@www.idugdb2-l.org Subject: [DB2-L] DB2 z/OS v8 SQL Question
Hi!
I have a table with 2 columns, item_name and eff_date. I need to create a query which returns the item_name and the range of effective dates. For example, I have the following data: [...]
9158 48 28_Re: DB2 z/OS v8 SQL Question14_Peter Vanroose26_peter_vanroose@YAHOO.CO.UK30_Tue, 1 Apr 2008 00:10:04 +0200374_iso-8859-1 > I have a table with 2 columns, item_name and eff_date. I need to > create a query which returns the item_name and the range of > effective dates.
SELECT item_name, MIN(eff_date), MAX(eff_date) FROM my_table GROUP BY item_name
-- Peter.
9207 112 43_Re: DB2z OLR Parameters to Avoid RC00C900BA0_24_carol.sutfin@REGIONS.COM31_Mon, 31 Mar 2008 17:10:01 -0500588_US-ASCII Lance,
I encountered the same problems in one of our applications a while back.
This would also cause problems with some of our on-line transactions hanging.
There is no easy way to solve this if your are in V8.
For our problems, I finally convinced the application programmers that having the tablespace unavailable for 3 to 4 minutes was better than having abends in the on-line application. They have a way to set an indicator that tells the on-line(actually our ATM and Internet banking) that the tables are unavailable and to use a default. [...]
9320 230 26_Re: partitioning question.0_24_carol.sutfin@REGIONS.COM31_Mon, 31 Mar 2008 17:16:24 -0500432_US-ASCII I will add my agreement also.
This is never a good idea.
It will create performance problems for both batch and on-line applications. You also end up with more indexes than you really need which will add to the performance problems.
I work with several applications now that either use a generated partition id or partition based on the lowest cardinal values in the tables. Nothing but problems. [...]
9551 63 52_Re: Is a DB2 Connect license indluded with the ADCD?7_Ed Long19_rdhm99a@PRODIGY.NET31_Mon, 31 Mar 2008 15:27:38 -0700235_iso-8859-1 No its not. See my previous notes for the detail.
Binyamin Dissen wrote: Is a DB2 Connect license included with the ADCD?
Didn't see that it was priced when I downloaded it.