1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l October 2004, week 5
2 99 26_Re: DB2 Development Center13_Lee Robertson24_lee_robertson@FSMAIL.NET31_Fri, 29 Oct 2004 03:59:54 -0500380_- Thanks for the reply Leon,
I checked our CD set and we do not have the Application Development Client CD. I am requesting this from IBM as I believe this has been omitted from our bundle in error. I tried the download and it isn't allowing me to get this.
Regards
Lee
On Wed, 27 Oct 2004 10:42:40 -0400, Leon Katsnelson wrote: [...]
102 24 35_DB2 connect Fix pack 13 for windows11_Gugel, Rich26_Rich.Gugel@DOA.STATE.WI.US31_Fri, 29 Oct 2004 07:26:54 -0500441_iso-8859-1 Has anyone been able to get to the DB2 Connect Version 7 fix pack site? I've been trying to get in for a couple of days without any success.
http://www-306.ibm.com/software/data/db2/udb/support/downloadv7.html
I did send feedback to IBM that it was not working.
Rich Gugel State of Wisconsin Department of Administration DB2 Systems Programmer Success is never final, but failure can be. By Bill Parcels [...]
127 71 30_Connecting DB2 z/os to UDB 8.213_Hodgin, Scott19_shodgin@SCFBINS.COM31_Fri, 29 Oct 2004 07:30:37 -0500459_iso-8859-1 Hi list,
A month or so back I successfully set up communication from DB2 v7.1 on z/os to UDB 8.2 where UDB was set up with CLIENT authentication. I'm having to back peddle on this and now I need for the UDB to be set up to do SERVER authentication. I've looked and looked at the 'Connectivity Cheat Sheet' that is generally available from a Google search, but I must be missing something. Maybe someone else can see what I doing wrong. [...]
199 91 19_Merge SQL statement26_David Wilson (Interactive)35_david.wilson@CAMELOTINTERACTIVE.COM31_Fri, 29 Oct 2004 13:30:20 +0100290_iso-8859-1 Hi all,
DB2/UDB V8.1.5 on AIX.
I am trying to use the merge statement to perform what should be a fairly simple operation. I want to modify a table by either INSERTing a row if one does not exist or UPDATEing the row if it does. I am using the following SQL:- [...]
291 44 39_Re: DB2 connect Fix pack 13 for windows11_Moore, Tony15_TMoore@IKON.COM31_Fri, 29 Oct 2004 08:33:23 -0400476_iso-8859-1 Rich, Just tried it and got nothing but a blank (white) screen.
Tony
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Gugel, Rich Sent: Friday, October 29, 2004 8:27 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: DB2 connect Fix pack 13 for windows
Has anyone been able to get to the DB2 Connect Version 7 fix pack site? I've been trying to get in for a couple of days without any success. [...]
336 166 37_Re: Current timestamp insert question12_Isaac Yassin20_yassini@BEZEQINT.NET31_Fri, 29 Oct 2004 14:50:16 +0200538_us-ascii Hi,
It's not a bug. TIMESTAMP is accurate to the micro-second. You can get duplicates easily on TIMESTAMP (I got a hit on 1990 on a J400 machine...)
If you need - use GENERATE_UNIQUE() function (retrofitted to V7).
Isaac Yassin
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Warren Homer Sent: Friday, October 29, 2004 4:40 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Current timestamp insert question [...]
503 253 37_Re: Current timestamp insert question14_Grainger, Phil20_Phil.Grainger@CA.COM31_Fri, 29 Oct 2004 13:56:46 +0100380_iso-8859-1 and an aside, if you do a multiple row INSERT (such as a select from another table or a V8 true multi-row insert) then any CURRENT TIMESTAMP is derived ONCE for the execution of the statement NOT once for each inserted row.
On the other hand, the GENERATE_UNIQUE() function mentioned by Isaac WILL be evaluated once per inserted row to guarantee uniqueness [...]
757 165 37_Re: Current timestamp insert question20_Friedman, Avram (IT)32_Avram.Friedman@MORGANSTANLEY.COM31_Fri, 29 Oct 2004 09:31:29 -0400449_us-ascii DB2 whas just enhanced with a new function to address this issue of duplicate time stamps. See APAR PQ70901. It introduces the new IBM provided GENERATE_UNIQUE() function. Don't know much about this myself yet.
_____
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Warren Homer Sent: Thursday, October 28, 2004 10:40 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Current timestamp insert question [...]
923 70 40_CDUG for z/OS - 1st Meeting - 11/11/200449_Crane, Rob --- Sr. Database Administrator --- CFS27_rob.crane@FREIGHT.FEDEX.COM31_Fri, 29 Oct 2004 07:34:53 -0600352_iso-8859-1 The Colorado DB2 User Group for z/OS invites you to join us on November 11, 2004 for a day of V8 education and discussion. IBM and the CDUG for z/OS leadership team have lined up 3 great presentations. John Lyle will be covering V8 Online Schema Evolution and V8 Migration Planning. Kevin Harrison will be covering V8 SQL Enhancements. [...]
994 63 39_Re: DB2 connect Fix pack 13 for windows0_15_Ale.Eba@CGI.COM31_Fri, 29 Oct 2004 10:37:49 -0400594_US-ASCII Try http://www-306.ibm.com/software/data/db2/udb/support/downloadv8.html
Ale Eba
"Gugel, Rich" cc: Sent by: DB2 Data Subject: DB2 connect Fix pack 13 for windows Base Discussion List
10/29/2004 08:26 AM Please respond to DB2 Database Discussion list at IDUG
Has anyone been able to get to the DB2 Connect Version 7 fix pack site? I've been trying to get in for a couple of days without any success. [...]
1058 84 39_Re: DB2 connect Fix pack 13 for windows11_Gugel, Rich26_Rich.Gugel@DOA.STATE.WI.US31_Fri, 29 Oct 2004 09:44:41 -0500633_iso-8859-1 Thanks, Unfortunately those are the version 8 fix packs. I still have a few servers stuck on version 7
-----Original Message----- From: Ale.Eba@CGI.COM [mailto:Ale.Eba@CGI.COM] Sent: Friday, October 29, 2004 9:38 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: DB2 connect Fix pack 13 for windows
Try http://www-306.ibm.com/software/data/db2/udb/support/downloadv8.html
Ale Eba
"Gugel, Rich" cc: Sent by: DB2 Data Subject: DB2 connect Fix pack 13 for windows Base Discussion List [...]
1143 30 37_Re: Current timestamp insert question0_16_mscarpa@CESVE.IT31_Fri, 29 Oct 2004 16:34:28 +0200363_US-ASCII Are you using new, fast processors in your machine or did you upgrade your maniframe ?
I don't remember where, but I think I read something about it, if you cut too short timestamp with fast processor this kind of
things may happen, maybe in some Cheryl Watson's Tuning letters. If I remember well the solution was a longer timestamp, [...]
1174 138 37_Re: Current timestamp insert question15_Gaston, Raymond17_GastonRay@ORU.COM31_Fri, 29 Oct 2004 11:09:17 -0400692_iso-8859-1 Also, I think if you're updating within a trigger the timestamp value is inherited from the calling environment!
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of Warren Homer Sent: Thursday, October 28, 2004 10:40 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Current timestamp insert question
Hi,
we are experiencing duplicate current timestamps when we insert into the same table (where the PK is the current timestamp) using parallel batch streams. My question is, is this a bug in DB2 or is this possible with DB2. If it is possible then I feel that either one or both of the following [...]
1313 33 11_View syntax14_Zobjeck, A. J.21_Allen_Zobjeck@TTX.COM31_Fri, 29 Oct 2004 11:12:53 -0500516_iso-8859-1 > Can someone telll me what the syntax error on this is? > > Thank You > > CREATE VIEW DB2TEST.VRA_AL3 > (BRPR.BILLING_TYP AS BRPR_BILLING_TYP , > BRPR.ACCT_DT AS BRPR_ACCT_DT , > BRPRH.BILLING_TYP AS BRPRH_BILLING_TYP , > BRPRH.ACCT_DT AS BRPRH_ACCT_DT) > AS > ((SELECT BR.BILLING_TYP, > BR.ACCT_DT > FROM DB2TEST.TRA_BRC_REPR BR > WHERE BR.BILLING_TYP = 'P') AS BRPR > UNION > (SELECT > BRH.BILLING_TYP, > BRH.ACCT_DT > FROM DB2TEST.TRA_BRC_REPR_HST BRH > WHERE BRH.BILLING_TYP = 'P') AS BRPRH); > [...]
1347 65 36_Colorado DB2 User Group - 11/11/200449_Crane, Rob --- Sr. Database Administrator --- CFS27_rob.crane@FREIGHT.FEDEX.COM31_Fri, 29 Oct 2004 10:21:05 -0600606_iso-8859-1 The Colorado DB2 User Group for z/OS invites you to join us on November 11, 2004 for a day of V8 education and discussion. IBM and the CDUG for z/OS leadership team have lined up 3 great presentations. John Lyle will be covering V8 Online Schema Evolution and V8 Migration Planning. Kevin Harrison will be covering V8 SQL Enhancements. Please visit our web site to get all the details and register for our first meeting. Go to the "Calendar of Events / Meeting details" link. http://www.coloradodb2rug.org John Lyle has worked at the Silicon Valley Laboratory in the DB2 organization since [...]
1413 82 15_Re: View syntax14_Peter Backlund21_BacklundDB2@TELIA.COM31_Fri, 29 Oct 2004 18:24:04 +0200
1496 167 15_Re: View syntax17_Duane Lee - EGOVX22_DLee@MAIL.MARICOPA.GOV31_Fri, 29 Oct 2004 09:24:07 -0700673_iso-8859-1 You are only selecting two (2) fields not the four (4) you want to define in the view.
-----Original Message----- From: Zobjeck, A. J. [mailto:Allen_Zobjeck@TTX.COM] Sent: Friday, October 29, 2004 9:13 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: View syntax
> Can someone telll me what the syntax error on this is? > > Thank You > > CREATE VIEW DB2TEST.VRA_AL3 > (BRPR.BILLING_TYP AS BRPR_BILLING_TYP , > BRPR.ACCT_DT AS BRPR_ACCT_DT , > BRPRH.BILLING_TYP AS BRPRH_BILLING_TYP , > BRPRH.ACCT_DT AS BRPRH_ACCT_DT) > AS > ((SELECT BR.BILLING_TYP, > BR.ACCT_DT > FROM DB2TEST.TRA_BRC_REPR BR > WHERE BR.BILLING_TYP = 'P') AS BRPR > UNION > (SELECT > [...]
1664 93 15_Re: View syntax0_33_waldo_tumanut@AMERICANCENTURY.COM31_Fri, 29 Oct 2004 11:24:42 -0500815_US-ASCII Try removing the () in the SELECT.
Waldo Tumanut Database Analyst
"Zobjeck, A. J." To: DB2-L@WWW.IDUGDB2-L.ORG Subject: View syntax
Sent by: DB2 Data Base Discussion List
10/29/2004 11:12 AM Please respond to DB2 Database Discussion list at IDUG
> Can someone telll me what the syntax error on this is? > > Thank You > > CREATE VIEW DB2TEST.VRA_AL3 > (BRPR.BILLING_TYP AS BRPR_BILLING_TYP , > BRPR.ACCT_DT AS BRPR_ACCT_DT , > BRPRH.BILLING_TYP AS BRPRH_BILLING_TYP , > BRPRH.ACCT_DT AS BRPRH_ACCT_DT) > AS > ((SELECT BR.BILLING_TYP, > BR.ACCT_DT > FROM DB2TEST.TRA_BRC_REPR BR > WHERE BR.BILLING_TYP = 'P') AS [...]
1758 114 15_Re: View syntax0_28_BILL.GALLAGHER@PHOENIXWM.COM31_Fri, 29 Oct 2004 12:25:38 -0400635_us-ascii Your syntax error is that you're trying to create a view of four columns based on a union of two subselects of two columns each. I think what you might be trying to do can be accomplished by this:
CREATE VIEW DB2TEST.VRA_AL3 (BRPR.BILLING_TYP AS BRPR_BILLING_TYP , BRPR.ACCT_DT AS BRPR_ACCT_DT , BRPRH.BILLING_TYP AS BRPRH_BILLING_TYP , BRPRH.ACCT_DT AS BRPRH_ACCT_DT) AS ((SELECT BR.BILLING_TYP, BR.ACCT_DT, NULL, NULL FROM DB2TEST.TRA_BRC_REPR BR WHERE BR.BILLING_TYP = 'P') AS BRPR UNION (SELECT NULL, NULL, BRH.BILLING_TYP, BRH.ACCT_DT FROM DB2TEST.TRA_BRC_REPR_HST BRH WHERE BRH.BILLING_TYP = 'P') AS BRPRH); [...]
1873 147 15_Re: View syntax11_Matt Kelley18_mgk333@HOTMAIL.COM31_Fri, 29 Oct 2004 11:37:10 -0500692_- Also, using "AS" in the column list of CREATE VIEW is not valid.
Just use:
CREATE VIEW DB2TEST.VRA_AL3 (BRPR_BILLING_TYP , BRPR_ACCT_DT , BRPRH_BILLING_TYP , BRPRH_ACCT_DT) AS ...
On Fri, 29 Oct 2004 12:25:38 -0400, BILL.GALLAGHER@PHOENIXWM.COM wrote:
>Your syntax error is that you're trying to create a view of four columns >based on a union of two subselects of two columns each. I think what you >might be trying to do can be accomplished by this: > >CREATE VIEW DB2TEST.VRA_AL3 > (BRPR.BILLING_TYP AS BRPR_BILLING_TYP , > BRPR.ACCT_DT AS BRPR_ACCT_DT , > BRPRH.BILLING_TYP AS BRPRH_BILLING_TYP , > BRPRH.ACCT_DT AS BRPRH_ACCT_DT) >AS > [...]
2021 143 15_Re: View syntax14_Larry Kintisch19_lkint@IX.NETCOM.COM31_Fri, 29 Oct 2004 14:16:24 -0700557_us-ascii Adding to Matt & Bill's comments:
(1) Older versions of DB2 did not allow UNION [that is, a full select]--check your version referenece manual.
(2) In some versions of DB2, the fullselect syntax for CREATE VIEW says UNION was not permitted, only UNION ALL.
(3) As stated, the purpose of the (view_col_name1, view_col_name2,...) specification after the view-name is to give names to the columns of the fullselect which are the view column names, so don't use (tab_col_name1 AS view_col_name1, ...): that syntax is invalid. [...]
2165 160 37_Re: Current timestamp insert question19_Humphris,Richard P.24_Richard.Humphris@CNA.COM31_Fri, 29 Oct 2004 13:30:48 -0500592_US-ASCII
Raymond has hit the nail on the head.
But as a side note, the newer processors have two clocks available. You can issue the STCK (store clock) command which returns a 8-byte tod clock where the lowest value in bit 63 = .000001 seconds. But you could also issue a STCKE (store clock extended) which returns a 16-byte tod clock which, depending on your machine, may have greater precision below .000001 seconds. Of course, the architecture allows for FAR greater accuracy but I doubt any model goes down to the theoretically low end of the bits in the STCKE bytes. [...]
2326 42 15_Re: View syntax14_Zobjeck, A. J.21_Allen_Zobjeck@TTX.COM31_Fri, 29 Oct 2004 14:01:31 -0500648_iso-8859-1 I'm on DB2 V6
> -----Original Message----- > From: Zobjeck, A. J. > Sent: Friday, October 29, 2004 11:13 AM > To: 'DB2-L@WWW.IDUGDB2-L.ORG' > Subject: View syntax > > > Can someone telll me what the syntax error on this is? > > Thank You > > CREATE VIEW DB2TEST.VRA_AL3 > (BRPR.BILLING_TYP AS BRPR_BILLING_TYP , > BRPR.ACCT_DT AS BRPR_ACCT_DT , > BRPRH.BILLING_TYP AS BRPRH_BILLING_TYP , > BRPRH.ACCT_DT AS BRPRH_ACCT_DT) > AS > ((SELECT BR.BILLING_TYP, > BR.ACCT_DT > FROM DB2TEST.TRA_BRC_REPR BR > WHERE BR.BILLING_TYP = 'P') AS BRPR > UNION > (SELECT > BRH.BILLING_TYP, > BRH.ACCT_DT > FROM DB2TEST.TRA_BRC_REPR_HST BRH > [...]
2369 23 12_Re: BMP jobs13_Patric Becker21_patric_becker@GMX.NET31_Sat, 30 Oct 2004 11:35:40 -0500356_ISO-8859-1 Koen,
there´s one more point your application developers may come across : When your application uses both IMS and DB2, tell them to use IMS SYNCCALL and ROLB, DB2´s COMMIT and ROLLBACK have no effect and you´ll receive SQLCODE (I think) 925 for COMMIT and 926 for ROLLBACK, because those commands are not valid in IMS environments. [...]