1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l June 2002, week 5
2 98 11_error in V714_Bernd Oppolzer26_Bernd.Oppolzer@T-ONLINE.DE31_Sat, 29 Jun 2002 09:01:53 +0200587_- Hello DB2-List,<br><br>since we migrated our test system to V7 some weeks ago, we get strange results from some outer joins.<br><br>I'll try to give you an example:<br><br>SELECT ABT.ABTID, MIT.PERSNR, MIT.NAME, KT.KURSWOCHE, KK.DM, K.KURSID, SUBSTR (K.KURSNAME,1,20) FROM VXXABT ABT JOIN VXXMITAR MIT ON ABT.ABTID = MIT.ABTID JOIN VXXKURST KT ON MIT.PERSNR = KT.PERSNR JOIN (SELECT KURSID, KURSWOCHE, DM FROM VXXKUKO WHERE KURSWOCHE BETWEEN 1985.00 AND 1992.00) AS KK ON KT.KURSID = KK.KURSID AND KT.KURSWOCHE = KK.KURSWOCHE JOIN VXXKURSE K ON KK.KURSID = K.KURSID ORDER BY 1,4; [...]
101 189 18_Re: database sizes12_Isaac Yassin20_yassini@BEZEQINT.NET31_Sat, 29 Jun 2002 15:24:38 +0200427_- IBG - Inter Block Gap. (can't be used by your data)<br><br>Isaac Yassin DBMS & IT Consultant IBM Certified Solution Expert DB2 V7.1 Database Administration for OS/390<br><br><br><br><br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM] On Behalf Of Rohn.Solecki@MTS.MB.CA Sent: Friday, June 28, 2002 4:32 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: database sizes [...]
291 183 15_Re: View Puzzle11_Endy Lambey20_endyl@CENTRIN.NET.ID31_Sun, 30 Jun 2002 08:47:09 +0700779_- Hi Sam, Thanks for your reply... I've actually tried teh UNION, but I also come up with some LEFT OUTER JOIN SQL. Seems like the OUTER JOINS performance is faster than UNION, I don't if that is true.<br><br>select (case when t1.level_number_01 is null then t1.classification_scheme_id else case when t2.level_number_02 is null then t2.classification_scheme_id else case when t3.level_number_03 is null then t3.classification_scheme_id else t3.classification_scheme_id end end End) as class_sch_id, t0.level_number_00 as level0, t0.scheme_name_english as level0_desc, t1.level_number_01 as level1, (Case when t1.level_number_01 is null then null else t1.scheme_name_english end) as level1_desc, t2.level_number_02 as level2, (Case when t2.level_number_02 is null then null [...]
475 35 57_Re: List of Stage 1 and Stage 2 Predicates (v7 on OS/390)9_Rob Crane22_racrane@CONCENTRIC.NET31_Sat, 29 Jun 2002 21:56:58 -0600569_us-ascii I like the list Sheryl Larsen has. Check out her web page link below.<br><br>http://www.smlsql.com/wsnDBF3.html<br><br>-Rob<br><br>> "Trbovic, Phil" wrote: > > Greetings fellow listers, > I have been spending the better part of this afternoon to find a > comprehensive list of Stage 1 and Stage 2 predicates in version 7 of > DB2 for OS/390. I'm interested in knowing which Stage 1 predicates are > index able and which one are not. Also, any predicates that may have > moved from Stage 2 to Stage 1. > > Does anyone know if such a document? If so, Could [...]
511 48 32_Re: DB2 V6 and Peoplesoft V5.1.216_Michael McCawley20_Mike_DBA@HOTMAIL.COM31_Sun, 30 Jun 2002 14:58:05 -0500442_Windows-1252 Robert -<br><br>So far as I know, PeopleSoft (versions 5.1 through 7.3) does not use any database features that would preclude upgrading DB2 to either V6.1 or V7. If you have overcome the PS v5.1 Oracle to DB2 transition challenges (single DB, 15-18? TS's ,Multi-Table TS Oracle-like design to something more reasonable for DB2 for OS/390), then new versions of DB2 should only provide better functionality and performance. [...]
560 45 16_Re: RDO problems16_Michael McCawley20_Mike_DBA@HOTMAIL.COM31_Sun, 30 Jun 2002 15:10:43 -0500372_Windows-1252 Kathy -<br><br>The Reorg and Bind (and subsequent Newcopy) would address possible -805 problems, but would not have any effect on -922 errors.<br><br>Check the user ID passed by the CICS transaction to DB2. The text of the -922 error should contain the ID that is 1. Not authorized to execute the Plan/Package, or 2. Not authorized for the table access. [...]