1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l January 2000, week 2
2 68 20_Re: db2 index broken0_24_ssethi@LOT.TATASTEEL.COM28_Fri, 7 Jan 2000 03:25:08 GMT497_us-ascii Hi Jan, U are selecting the rows via index but the possibility is that u are not selecting only the columns which are involved in index , i mean the scan might not be index only. if the scan is index only then i think the rows will be returned in the index order or the ASC order in ur case. In this case u must use ORDER BY clause if u need the rows to be returned in the order of index columns.If reorg solved ur problem i think LIST PREFETCH might also be done in ur case however [...]
71 98 22_Access Path of a Query0_24_ssethi@LOT.TATASTEEL.COM28_Sat, 8 Jan 2000 06:00:41 GMT414_us-ascii Hi all, I have got a query of 3 tables join and it is something like this ...<br><br>SELECT T1.COL1, T1.COL2,T1.COL3 ,T1.COL4 ,T1.COL5,T1.COL6,T1.COL7,T1.COL8, T2.COL1,T2.COL2,T2.COL3, T3.COL1,T3.COL2,T3.COL3 FROM T1,T2,T3 WHERE T1.COL1=T2.COL1 AND T2.COL2=T3.COL1 AND T1.COL2 = literal AND T1.COL5 = literal<br><br>AND T1.COL6 = host variable AND T1.COL7 = host variable AND T1.COL8 = host variable [...]
170 55 65_Re: DB2-OS/390- Statistical Analysis of Tablespaces Index spaces.14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Sat, 8 Jan 2000 12:02:17 -0500442_ISO-8859-1 Linda, The Buffer Pool Tool from Responsive Systems is the only product that can really do what you want, including the prediction of how many buffers you need for each pool. Part of the effective grouping of objects is the actual working set or number of pages an object actually uses within a pool. Information from the DB2 catalog about the number of pages an object actually has is not generally relevant for pool tuning. [...]
226 28 51_Registering DB2 with Db2 Performance Monitor for NT13_George Peters22_gpeters@COMPUSERVE.COM30_Sat, 8 Jan 2000 14:58:10 -0500595_iso-8859-1 Hi I have previously left a question a few times re the presence (more precisely, the absence) of DB2 objects in the WIN NT Performance Monitor (DB2 UDB W/Group/NT V6.1). For those who are interesated, the answer is that the Performance Counters must be Registered to the NT Perf Monitor with the db2perfi /i command. The funny thing is that "The setup program automatically registers DB2 with the Performance Monitor", but who am i? Personally, I didn't find this to be the case. This is documented, but it was a long process to find this obscure command, especially when setup [...]
255 33 49_What happened to the DB2 Archives from Listserv ?23_Chenniappan Solaiyappan18_fdwh2000@YAHOO.COM30_Sat, 8 Jan 2000 12:26:50 -0800754_us-ascii Hi Everyone,<br><br>What happened to the DB2 Archives from Listserv ? http://listserv.american.edu/archives/db2-l<br><br>I thought all those archived discussions will be included into http://jupiter.ryci.com/archives/db2-l<br><br>Does anyone have any information about those archives ?<br><br>Thanks<br><br><br><br><br><br>===== Chenny Solaiyappan DB2 DBA(S390 & NT) __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
289 18 20_Re: db2 index broken0_22_kmulcahy@CHECKFREE.COM30_Sun, 9 Jan 2000 07:26:02 -0500299_us-ascii The only way to guarantee the order of an SQL result set is to use the ORDER BY clause. I suspect that without the ORDER BY the order of your result depends on the contents of the bufferpool. Try this -- when you get a random result stop/start the tablespace and run your query again! [...]
308 53 24_Re: Unavailable Resource14_Campbell James30_James.Campbell@ENERGYIS.COM.AU31_Mon, 10 Jan 2000 10:24:17 +1000426_us-ascii Mike,<br><br>My experience is that I don't get a DSNT501I message for a stopped database/tablespace. Presumably because DB2 thinks that there is enough information in the SQLCA is recitify the problem. (Unfortunately, some applications just report the -904 and don't report the message tokens.)<br><br>It's only when there isn't enough information in the SQLCA to fix a -904 etc that I expect a console message. [...]
362 158 26_Re: Access Path of a Query14_Purcell, Terry37_Terry.Purcell@CORPMAIL.TELSTRA.COM.AU31_Mon, 10 Jan 2000 10:28:08 +1100526_iso-8859-1 Sanjeev,<br><br>The optimizer has obviously chosen the access path which it believes is the most efficient, based on the catalog statistics (as that is it's function!!!!!). Think about the access path you are trying to force on T1:<br><br>1. non-matching index scan using sequential prefetch (of the entire index space, similar to a tablespace scan on the data pages), and evaluation of predicates COL2 and COL5. 2. followed by random access to the data pages where predicates COL6, COL7 & COL8 are evaluated. [...]
521 80 24_Re: Unavailable Resource12_Mike O'Brien30_michael_obrien_48127@YAHOO.COM30_Sun, 9 Jan 2000 15:37:07 -0800581_us-ascii James, thanks for the info. That seems to answer the question. --- Campbell James <James.Campbell@ENERGYIS.COM.AU> wrote: > Mike, > > My experience is that I don't get a DSNT501I message > for a stopped > database/tablespace. Presumably because DB2 thinks > that there is enough > information in the SQLCA is recitify the problem. > (Unfortunately, some > applications just report the -904 and don't report > the message tokens.) > > It's only when there isn't enough information in the > SQLCA to fix a -904 > etc that I expect a console message. > > You may notice [...]
602 117 33_Re: Cretification courses in DB2.11_Roland Chua32_rolandchua@SINGAPOREEXCHANGE.COM31_Mon, 10 Jan 2000 09:20:03 +0800399_us-ascii I agree with John that working experience is more important than just a piece of paper. My personal view is that the certification is only good for people who do not have the relevent working experience.<br><br><br><br><br><br><br><br><br><br><br><br>John Wynton <jwynton@THEMISINC.COM> on 08/01/2000 05:18:48 AM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM> [...]
720 62 20_Re: db2 index broken16_Richard A Yevich21_ryevich@ATTGLOBAL.NET30_Sun, 9 Jan 2000 21:29:48 -0500662_iso-8859-1 Jan,<br><br>Indexes the determine the order into the DB2 engine.<br><br>ORDER BY determines the order returned to you.<br><br>If they match, wonderful! If they don't, DB2 sorts them to make sure you them correctly.<br><br>Regards, Richard +===+===+===+===+====+ ryevich@attglobal.net<br><br>> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Jan Rabaut > Sent: Thursday, January 06, 2000 10:13 AM > To: DB2-L@RYCI.COM > Subject: db2 index broken > > > We have a strange problem on new created indexspaces since 1 Jan 2000. > > Situation: We created a type 2 index containing 2 columns as key [...]
783 41 28_Re: DB2 PM and authasn (0C4)12_MILLS,Robert26_robert.mills@DEWRSB.GOV.AU31_Mon, 10 Jan 2000 15:37:51 +1100451_iso-8859-1 Franco,<br><br>The DB2PM Data Collector will try to start an Authorization Address Space if you are using the TCP/IP interface. The name of this started task is specified using the parameter AUTHORIZATIONADDRESSSPACE or AUTHASN. Check the output of the Data Collector to make sure this address space is being started. The member DGOVDCAS in the SDGOSAMP library contains sample JCL for this address space if you haven't set it up yet. [...]
825 168 33_Re: Cretification courses in DB2.14_Ron Warshawsky20_rwarsh@IX.NETCOM.COM31_Mon, 10 Jan 2000 00:46:28 -0600647_iso-8859-1 Certification is a good way to separate DBA with a years of real experience from "Robot DBA" with a years of doing very little every year.<br><br>Regards, Ron Warshawsky, Sr. DBA, Allied Group Insurance, IBM Certified Solutions Expert (DB2 DBA) ORACLE Certified DBA<br><br><br><br>> ----- Original Message ----- > From: "Roland Chua" <rolandchua@SINGAPOREEXCHANGE.COM> > Newsgroups: bit.listserv.db2-l > To: <DB2-L@RYCI.COM> > Sent: Sunday, January 09, 2000 7:20 PM > Subject: Re: Cretification courses in DB2. > > > > I agree with John that working experience is more important than just a > > piece of paper. My personal view is [...]
994 30 13_Command auth.18_CHRISTER JOHANSSON26_CHRISTER.JOHANSSON@D.SJ.SE31_Mon, 10 Jan 2000 08:19:00 +0100368_iso-8859-1 --- Received from D.Z013CJ 08-762 5641 00-01-10 08.19 -> DB2-L(a)RYCI.COM<br><br>Hi!<br><br>I have an authorization problem that puzzles me.<br><br>My id is connected to a RACF group that have sysadm authorization, but I'm not allowed to do -arc log from SDSF or the console. If I use Opt 7 DB2 Commands from DB2I or DSN in a batch it works perfectly. [...]
1025 85 17_Re: Command auth.0_29_Adrian.Talbot@BANKWEST.COM.AU31_Mon, 10 Jan 2000 15:45:36 +0800456_us-ascii Hi,<br><br>We had the same problem when we moved to RACF from ACF/2 DB2.<br><br>When you run the command under SDSF at our site it actually runs under a userid of SYSOPR and hence SYSOPR requires the ARCHIVE command access.<br><br>Hope this helps.<br><br>Adrian Talbot Database Administration Group Information Services, Level 10, Tower Bank of Western Australia Ph : (08) 9449-6273 Fax : (08) 9449-6133 eMail : adrian.talbot@bankwest.com.au [...]
1111 121 17_Re: Command auth.0_22_The-Thanh.Luong@AGF.BE31_Mon, 10 Jan 2000 09:00:26 +0100535_- Hi, Maybe you can check SYSIBM.SYSUSERAUTH to see if the grantee SYSOPR has the ARCHIVEAUTH = Y. Regards,<br><br>The-Thanh LUONG AGF Belgium Insurance, DB Administration and Security MGR E-mail <mailto: The-Thanh.Luong@agf.be> URL http://www.agf.be<br><br>===== Standard Disclaimer: opinions expressed are strictly my own, etc... =====<br><br><br><br><br><br>-----Original Message----- From: CHRISTER JOHANSSON [mailto:CHRISTER.JOHANSSON@D.SJ.SE] Sent: Monday, January 10, 2000 8:19 AM To: DB2-L@RYCI.COM Subject: Command auth. [...]
1233 105 22_Re: Command auth. MORE0_29_Adrian.Talbot@BANKWEST.COM.AU31_Mon, 10 Jan 2000 16:00:15 +0800610_us-ascii Hi,<br><br>We had the same problem when we moved to RACF from ACF/2 DB2.<br><br>When you run the command under SDSF at our site it actually runs under a userid of SYSOPR and hence SYSOPR requires the ARCHIVE command access.<br><br>Forgot that RACF also doesn't work for the ARCHIVE command.<br><br>You can setup the rules but it always defaults to Native DB2 security when checking for ARCHIVE as it doesn't always have an ACEE available. So you have to grant this and other command access via Native DB2. RACF also doesn't control the DISPLAYDB, STARTDB, STOPDB, BSDS, DISPLAY, RECOVER, STOPALL [...]
1339 65 28_Re: DB2 PM and authasn (0C4)22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Mon, 10 Jan 2000 09:48:14 +0000476_ISO-8859-1 Hi all, I have had this problem for a while and IBM have not been able to give me an answer on it yet...but you must setup the auth address space as mentioned below first.<br><br>Anybody else using TCPIP with PM in a big way?<br><br>Leslie<br><br><br><br>______________________________ Reply Separator _________________________________ Subject: Re: DB2 PM and authasn (0C4) Author: "MILLS;Robert" <robert.mills@DEWRSB.GOV.AU> at Internet Date: 1/10/00 3:37 PM [...]
1405 84 38_Re: DB2 PM and authasn (0C4):thank you14_Masone, Franco24_F.Masone@CEDACRIOVEST.IT31_Mon, 10 Jan 2000 11:23:07 +0100560_- Robert and Leslie : Thank you very much for help, problem solved !<br><br><br><br>> -----Messaggio originale----- > Da: Leslie Pendlebury-Bowe > [SMTP:Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP] > Inviato: Monday, January 10, 2000 10:48 AM > A: DB2-L@RYCI.COM > Oggetto: Re: DB2 PM and authasn (0C4) > > Hi all, > I have had this problem for a while and IBM have not been able to > give > me an answer on it yet...but you must setup the auth address space as > mentioned below first. > > Anybody else using TCPIP with PM in a big way? > > Leslie > > > [...]
1490 57 53_Re: What happened to the DB2 Archives from Listserv ?7_Gustavo26_lozano@BANDEIRANTES.COM.BR31_Mon, 10 Jan 2000 08:37:33 -0300849_iso-8859-1 Great, Chenny,<br><br>I missed the archives also. What happened?<br><br>Gustavo Lozano (lozano@bandeirantes.com.br) - DBA Banco Bandeirantes Sao Paulo - Brazil<br><br>-----Mensagem original----- De: Chenniappan Solaiyappan <fdwh2000@YAHOO.COM> Grupos de notícias: bit.listserv.db2-l Para: DB2-L@RYCI.COM <DB2-L@RYCI.COM> Data: Sábado, 8 de Janeiro de 2000 17:36 Assunto: What happened to the DB2 Archives from Listserv ?<br><br><br><br>>Hi Everyone, > >What happened to the DB2 Archives from Listserv ? >http://listserv.american.edu/archives/db2-l > >I thought all those archived discussions will be >included into http://jupiter.ryci.com/archives/db2-l > >Does anyone have any information about those archives >? > >Thanks > > > >===== >Chenny Solaiyappan >DB2 DBA(S390 & NT) >__________________________________________________ >Do [...]
1548 15 115_=?iso-8859-1?B?UulmLiA6IFJlOiBXaGF0IGhhcHBlbmVkIHRvIHRoZSBEQjIgQXJjaGl2?= =?iso-8859-1?B?ZXMgZnJvbSBMaXN0c2VydiA/?=0_26_denzil.coulter@UNICIBLE.CH31_Mon, 10 Jan 2000 11:51:15 +0100316_us-ascii take a look at<br><br>http://jupiter.ryci.com/archives/db2-l.html<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
1564 61 12_review db2-l12_Jacob Ganzel19_jacobg@SEMECH.CO.IL31_Mon, 10 Jan 2000 12:58:25 +0200321_x-user-defined review db2-l<br><br>---------------------------------------------------------------------------- ---------------------------- Jacob Ganzel<br><br>Database Products Mgr. SSM - SEMECH Software Marketing Ltd. 3b Netantahu St., OR YEHUDA, ISRAEL Email: jacobg@semech.co.il Tel: 972-3-5333144 Fax: 972-3-5333132
1626 36 121_=?iso-8859-1?Q?Re:______R=E9f._:_Re:_What_happened_to_the_DB2_Archiv_____?= =?iso-8859-1?Q?________es_from_Listserv_=3F?=7_Gustavo26_lozano@BANDEIRANTES.COM.BR31_Mon, 10 Jan 2000 09:08:43 -0300451_iso-8859-1 And what about the messages before October/1999?<br><br>Gustavo Lozano (lozano@bandeirantes.com.br) - DBA Banco Bandeirantes Sao Paulo - Brazil<br><br>-----Mensagem original----- De: denzil.coulter@UNICIBLE.CH <denzil.coulter@UNICIBLE.CH> Grupos de notícias: bit.listserv.db2-l Para: DB2-L@RYCI.COM <DB2-L@RYCI.COM> Data: Segunda-feira, 10 de Janeiro de 2000 7:51 Assunto: Réf. : Re: What happened to the DB2 Archiv es from Listserv ? [...]
1663 61 12_review db2-l12_Jacob Ganzel19_jacobg@SEMECH.CO.IL31_Mon, 10 Jan 2000 13:00:03 +0200321_x-user-defined review db2-l<br><br>---------------------------------------------------------------------------- ---------------------------- Jacob Ganzel<br><br>Database Products Mgr. SSM - SEMECH Software Marketing Ltd. 3b Netantahu St., OR YEHUDA, ISRAEL Email: jacobg@semech.co.il Tel: 972-3-5333144 Fax: 972-3-5333132
1725 23 40_Re: Strange Behavior of DB2 when Stopped15_Jeffery A Price17_jprice@IPALCO.COM31_Mon, 10 Jan 2000 06:38:52 -0500383_us-ascii Max,<br><br>We are DB2 V5.1 PUT9910, and have Boole and Babbage (I'm not sure which version), and have no problems stopping DB2 normally. We also didn't have any problems stopping DB2 when we were are maintenance level PUT9801 (had the Boole product then too).<br><br>Best of Luck, Jeffery A. Price Associate Engineer Indianapolis Power and Light Co. jprice@ipalco.com [...]
1749 139 26_Re: Access Path of a Query14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Mon, 10 Jan 2000 23:23:56 +1000712_us-ascii Sanjeev,<br><br>You didn't really ask a question or say what problem you have. Also clusterratios for indexes are important.<br><br>You are right. The Nested Table Expression made no difference because it was not materialized. 'View Merge' was used by DB2. Materialization can be forced by coding a little differently.<br><br>SELECT V1.* FROM (SELECT V2.* FROM (SELECT T1.COL1, T1.COL2,T1.COL3 ,T1.COL4 ,T1.COL5,T1.COL6,T1.COL7,T1.COL8, T2.COL1,T2.COL2,T2.COL3, T3.COL1,T3.COL2,T3.COL3 FROM T1,T2,T3 WHERE T1.COL1=T2.COL1 AND T2.COL2=T3.COL1 AND T1.COL2 = literal AND T1.COL5 = literal ) as V2 WHERE 1=1 ) as V1 WHERE T1.COL6 = host variable AND T1.COL7 = host variable AND T1.COL8 = host variable [...]
1889 159 17_Re: Command auth.11_Marge Lintz20_Lintzm@SCHNEIDER.COM31_Mon, 10 Jan 2000 06:37:52 -0600507_us-ascii Hi,<br><br>Something that worked for me is adding SYSOPR1=SYSOPR in DSNZPARMS for DSN6SPRM macro.<br><br>Marge<br><br><br><br><br><br>The-Thanh.Luo ng@AGF.BE To: DB2-L@RYCI.COM Sent by: DB2 cc: Data Base Subject: Re: Command auth. Discussion List <DB2-L@RYCI.C OM><br><br><br><br>01/10/2000 02:00 AM Please respond to DB2 Data Base Discussion List<br><br><br><br><br><br><br><br><br><br>Hi, Maybe you can check SYSIBM.SYSUSERAUTH to see if the grantee SYSOPR has the ARCHIVEAUTH = Y. Regards, [...]
2049 117 60_Re: A strange behavior of DB2 when stopped. Any suggestion ?14_Grainger, Phil21_Phil.Grainger@CAI.COM31_Mon, 10 Jan 2000 13:16:21 -0000454_- An alternative, which is 'guaranteed' to work is to issue a -STOP DB2 MODE(FORCE)<br><br>This sounds a bit nasty, but assuming you are shutting DB2 down for a good reason, then presumeably you have checked that there are no active threads beforehand..........<br><br>The only snag with -STOP DB2, is that once issued. you cannot issue any more commands (like -TERM THREAD or -STOP DB2 MODE(FORCE) so I would rather start with the biggest hammer!! [...]
2167 45 38_Re: DSNZPARM Option SEQCACH for RAID ?13_Lynne Flatley17_LFlatley@NEFN.COM31_Mon, 10 Jan 2000 08:34:09 -0500409_us-ascii What is very small? 64MB? Here's what our dasd folks said when I asked if this option is turned on for us,<br><br>I'm not sure if this is something we just want to try. We emulate 3990/3380's however, our RAMAC1 controllers to not have 'Large Cache' sizes. All of our RAMAC1 Controllers have 64 MB of Cache which is very small compared to the very large HDS 7700's or EMC Symmetric controllers. [...]
2213 170 60_Re: A strange behavior of DB2 when stopped. Any suggestion ?18_Andrade, Alexander25_alexander.andrade@CAI.COM31_Mon, 10 Jan 2000 13:45:19 -0000528_iso-8859-1 I had this happen to me when I was a sysprog, when you stopped certain subsystems like DB2 and HSM as well, it seemed to take up to 1/2hr for the address spaces to "bugger off".<br><br>If it is happening with HSM as well then it may be SMF cutting all of its records for every single dataset used during the life of the address space. To stop this there is a parmlib member SMFPRMxx which has a parameter DDCONS, if this is set to YES(the default...... I think) then an SMF record will be cut for each and every [...]
2384 22 13_Command auth.18_CHRISTER JOHANSSON26_CHRISTER.JOHANSSON@D.SJ.SE31_Mon, 10 Jan 2000 14:58:00 +0100508_iso-8859-1 --- Received from D.Z013CJ 08-762 5641 00-01-10 14.58 -> DB2-L(a)RYCI.COM<br><br>Hi!<br><br>Thank you all for responding on my query.<br><br>I've been testing them and they work the way I want.<br><br>Regards, Christer Johansson, Sys Prog, Swedish Stat Rail<br><br>===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
2407 65 38_Re: DSNZPARM Option SEQCACH for RAID ?22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Mon, 10 Jan 2000 14:04:15 +0000452_ISO-8859-1 Lynne just out of interest what are some of you average response times?<br><br>regards Leslie<br><br><br><br>______________________________ Reply Separator _________________________________ Subject: Re: DSNZPARM Option SEQCACH for RAID ? Author: Lynne Flatley <LFlatley@NEFN.COM> at Internet Date: 1/10/00 8:34 AM<br><br><br><br>What is very small? 64MB? Here's what our dasd folks said when I asked if this option is turned on for us, [...]
2473 138 57_Re: A strange behavior of DB2 when stopped. Any suggestio22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Mon, 10 Jan 2000 14:05:45 +0000400_ISO-8859-1 Phil or worse still is "cancel of the IRLM" .. :-) which I have had to issue as the bugger would not come down with a FORCE ... Leslie<br><br><br><br>______________________________ Reply Separator _________________________________ Subject: Re: A strange behavior of DB2 when stopped. Any suggestion ? Author: "Grainger; Phil" <Phil.Grainger@CAI.COM> at Internet Date: 1/10/00 1:16 PM [...]
2612 41 60_Re: A strange behavior of DB2 when stopped. Any suggestion ?11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Mon, 10 Jan 2000 09:18:49 -0500509_ISO-8859-1 Phil<br><br>A -STOP DB2 MODE(QUIESCE) can be overridden by a later -STOP DB2 MODE(FORCE). I admit I haven't had to use it for a while, but it used to work OK if the MODE(QUIESCE) was hanging because of active threads.<br><br>Regards Mike Turner Email: michael_turner@compuserve.com Home Page: http://ourworld.compuserve.com/homepages/michael_turner<br><br>Message text written by DB2 Data Base Discussion List >An alternative, which is 'guaranteed' to work is to issue a -STOP DB2 MODE(FORCE) [...]
2654 34 60_Re: A strange behavior of DB2 when stopped. Any suggestion ?14_Massimo Scarpa16_mscarpa@CESVE.IT31_Mon, 10 Jan 2000 15:23:58 +0100303_us-ascii I'm sure, as I experimented many times, that DB2 is a robust DBMS and it can survive<br><br>everything might happen, but I think it's not a 'normal' stopping mode using -STOP DB2(FORCE) every time I shutdown DB2, I'm pretty sure that DB2 will become full of dirty things and 'impatient' . [...]
2689 99 38_Re: DSNZPARM Option SEQCACH for RAID ?19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 10 Jan 2000 08:31:27 -0600324_iso-8859-1 Lynne, Abysmal I/O subsystem performance probably isn't directly related to whether or not caching is turned on or off for just "sequential prefetch" I/O. There will be many other factors involved. Show this ref. to your I/O subsystem tuning team. DB2 V6 for OS/390, Admin. Gde. Note 64MB reference as well. [...]
2789 113 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.16_Galambos, Robert29_Robert_Galambos@COMPUWARE.COM31_Mon, 10 Jan 2000 09:46:25 -0500377_iso-8859-1 <br><br>Chuck Hoover, from Compuware, has an excellent presentation concerning this subject. In his presentation, using information from the Buffer Pool Tool software, among others, he shows how to take the information retrieved, and digest it to formulate the right mix for your environment.<br><br>If you are interested in getting a copy, please let me know. [...]
2903 50 65_Re: Réf. : Re: What happened to the DB2 Archiv es from Listserv ?23_Chenniappan Solaiyappan18_fdwh2000@YAHOO.COM31_Mon, 10 Jan 2000 06:48:15 -0800385_us-ascii Denzil,<br><br>As i mentioned in my previous mail, http://jupiter.ryci.com/archives/db2-l.html has only archives from October 1999 Week 1 thru January 2000 Week 2.<br><br>but my question was, what happened to the archives prior to October 1,1999 ?<br><br>If anyone have any information about those archives, please let the entire discussion group about its whereabouts ? [...]
2954 66 66_Re: Rif. : Re: What happened to the DB2 Archiv es fr om Listserv ?10_Park, Stan17_SPark@STATE.NM.US31_Mon, 10 Jan 2000 08:06:17 -0700530_windows-1252 They used to be at http://listserv.american.edu/archives/db2-l.html but I was not able to get there this AM. -Stan -----Original Message----- From: Chenniappan Solaiyappan [mailto:fdwh2000@YAHOO.COM] Sent: Monday, January 10, 2000 7:48 AM To: DB2-L@RYCI.COM Subject: Re: Rif. : Re: What happened to the DB2 Archiv es from Listserv ?<br><br><br><br>Denzil,<br><br>As i mentioned in my previous mail, http://jupiter.ryci.com/archives/db2-l.html has only archives from October 1999 Week 1 thru January 2000 Week 2. [...]
3021 65 23_DB2 V6 Join Enhancement11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Mon, 10 Jan 2000 10:19:53 -0500436_ISO-8859-1 Perhaps someone who has a DB2 UDB for OS/390 V6 subsystem at their fingertips could answer the following question regarding the use of non-join (restrictive predicates) in the ON subclause of the FROM clause for Outer Joins. I am getting conflicting answers from the various documents I read: V6 SQL Reference, V6 Application Programming and SQL Guide, V6 Performance Red Book, and various IDUG presentations by IBMers. [...]
3087 85 66_Re: Rif. : Re: What happened to the DB2 Archiv es fr om Listserv ?13_Lynne Flatley17_LFlatley@NEFN.COM31_Mon, 10 Jan 2000 10:27:53 -0500656_us-ascii The DB2 listserv was moved from American University to a consulting firm's site in October of 1999. The archives at American University were not moved but we are extremely thankful that Richard Yevich's firm jumped in to host the listserv. It's archives are stored at http://jupiter.ryci.com/archives/db2-l.html.<br><br>> -----Original Message----- > From: Park, Stan [SMTP:SPark@STATE.NM.US] > Sent: Monday, January 10, 2000 10:06 AM > To: DB2-L@RYCI.COM > Subject: Re: Rif. : Re: What happened to the DB2 Archiv es fr om > Listserv ? > > They used to be at http://listserv.american.edu/archives/db2-l.html > but I was not able to get there [...]
3173 86 60_Re: A strange behavior of DB2 when stopped. Any suggestion ?19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 10 Jan 2000 09:37:45 -0600585_iso-8859-1 Hi all, I've never used the BOOLE & BABBAGE DB2 monitor but it would seem they should be able to capture any DB2 STOP messages, disconnect, and then sit around waiting for DB2 to start again. Maybe a BOOLE & BABBAGE person can answer this. The way I see it, how DB2 is brought down DEPENDS on the reason. Some reasons for stopping DB2 that I have seen range from "normal" to "immediate/bizarre", each with its own causes/requirements. Aren't these the methods for DB2 shutdown from mildest to most severe: -STOP DB2 (implied MODE(QUIESCE) most 24x7 shops can never get [...]
3260 67 66_Re: Rif. : Re: What happened to the DB2 Archiv es fr om Listserv ?0_22_Rohn.Solecki@MTS.MB.CA31_Mon, 10 Jan 2000 09:42:15 -0600551_us-ascii A while back I saved 2 alternate address for archives of DB2-L when it was at American U. I haven't checked them recently.<br><br>http://www.netexpress.net/~xavier/db2lfaq.html. - DB2-L FAQ<br><br>http://www.dejanews.com/home_ps.shtml - specify bit.listserv.db2-l in the FORUM field. It will allow you to search both current and archived DB2-L messages.<br><br>HTH Rohn<br><br><br><br><br><br><br><br>Lynne Flatley <LFlatley@NEFN.COM> on 2000/01/10 09:27:53 AM Subject: Re: Rif. : Re: What happened to the DB2 Archiv es fr om Listserv ? [...]
3328 64 60_Re: A strange behavior of DB2 when stopped. Any suggestion ?0_20_evans036@MC.DUKE.EDU31_Mon, 10 Jan 2000 11:07:26 -0500458_us-ascii once you have issued the -stop db2 command, i believe you can not then create a new thread that may be required to issue any further db2 commands (eg stop db2 mode(force)).<br><br>however i'm fairly sure you can still issue commands via the console.<br><br>steve<br><br><br><br><br><br><br><br><br><br>Mike Turner <Michael_Turner@COMPUSERVE.COM> on 01/10/2000 09:18:49 AM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM> [...]
3393 65 34_Re: SMF - CPU time, Plan, and User13_John Arbogast16_jfarbo@YAHOO.COM31_Mon, 10 Jan 2000 08:10:41 -0800563_us-ascii Bill -<br><br>SAS does a wonderful job of cutting down SMF files. If you know SAS, and use the SMF layouts provided by IBM, you can cut your SMF file into something manageable.<br><br>--- Joel Goldstein <joel_goldstein@COMPUSERVE.COM> wrote: > Bill, > The batch reporting side of whatever online monitor > you have can probably > do this for you quite > easily. One caveat may the be the cost of > processing all the 101 records > which depends on the > size/volume of your applications - how many actg > records you produce per > day. > Regards, > [...]
3459 92 66_Re: Rif. : Re: What happened to the DB2 Archiv es fr om Listserv ?16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Mon, 10 Jan 2000 11:10:50 -0500497_us-ascii Thanks Rohn, dejanews works fine Tom<br><br><br><br><br><br><br><br>Rohn.Solecki@MTS.MB.CA on 01/10/2000 10:42:15 AM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br>To: DB2-L@RYCI.COM cc: (bcc: Thomas E. Faglon/Telcordia) Subject: Re: Rif. : Re: What happened to the DB2 Archiv es fr om Listserv ?<br><br><br><br><br><br><br><br>A while back I saved 2 alternate address for archives of DB2-L when it was at American U. I haven't checked them recently. [...]
3552 97 34_Re: SMF - CPU time, Plan, and User0_22_BILL_GALLAGHER@PHL.COM31_Mon, 10 Jan 2000 11:14:22 -0500300_us-ascii John,<br><br>I do know SAS, and I think that is what I would be using to extract just the data I need for the department in question. My problem right now is trying to deciper the SMF layouts to figure out which offsets/fields to look at to make sure I extract the correct SMF records. [...]
3650 124 34_Re: SMF - CPU time, Plan, and User20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Mon, 10 Jan 2000 11:23:41 -0500434_- Bill<br><br>The SMF dump dataset has 4 byte RDW. That may or may not be available to you depending on the method you are using to retrieve the records. The offset to SMF record type may or may not need to have 4 bytes difference than you excepted. Moreover SMF dumps dataset has VBS format so it is possible that you might have record spilled over in to multiple segments. If you are using assembler than BFTEK could help you. [...]
3775 114 34_Re: SMF - CPU time, Plan, and User13_Chie, Jim (C)17_chiej@CONNEXT.COM31_Mon, 10 Jan 2000 08:24:02 -0800627_iso-8859-1 I bet your site has either MICS or MXG. The capacity planners use these products all the time, and they provide all the mappings for you.<br><br>-----Original Message----- From: BILL_GALLAGHER@PHL.COM [mailto:BILL_GALLAGHER@PHL.COM] Sent: Monday, January 10, 2000 8:14 AM To: DB2-L@RYCI.COM Subject: Re: SMF - CPU time, Plan, and User<br><br><br><br>John,<br><br>I do know SAS, and I think that is what I would be using to extract just the data I need for the department in question. My problem right now is trying to deciper the SMF layouts to figure out which offsets/fields to look at to make sure I extract [...]
3890 143 34_Re: SMF - CPU time, Plan, and User13_John Arbogast16_jfarbo@YAHOO.COM31_Mon, 10 Jan 2000 08:34:04 -0800348_us-ascii Bill -<br><br>Here is some old SAS I found after a quick look through some PDSs of mine. Hope this helps, or at least gives you a place to start.<br><br>INPUT @2 RECTYPE PIB1. @3 DATETIME SMFSTAMP8. @11 SYSID $4. @15 SSYSID $4.; IF SYSID='5PRD' AND RECTYPE=101; /* (RECTYPE=100 OR RECTYPE=102) AND DATEPART(DATETIME) = '11SEP96'D; */ [...]
4034 136 27_Re: DB2 V6 Join Enhancement20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Mon, 10 Jan 2000 11:46:49 -0500288_- Mike<br><br>DB2 UDB for OS/390 is trying to be closer to their brothers on NT or AIX. There is been changes in the way WHERE clause and ON clause works on LEFT OUTER JOINS.<br><br>The following SQL in DB2 V5 SELECT * FROM T1 LEFT OUTER JOIN T2 ON T1.C1 = T2.C5 WHERE T1.C3 >= 10 ; [...]
4171 35 39_Re: DB2 Visual Explain, Statement Table11_GOSE PAUL M17_pmgose@SRPNET.COM31_Mon, 10 Jan 2000 09:55:19 -0700386_iso-8859-1 Thanks Roger. Our DSNTESC member only contains DDL for the plan table. The table I'm interested in is the statement table that Visual Explain will access in addition to the plan and function tables. The table name is DSN_STATEMNT_TABLE. I'm also curious as to which product populates the statement table, is it Visual Explain or is it the EXPLAIN feature of DB2 OS/390? [...]
4207 35 39_Re: DB2 Visual Explain, Statement Table12_Roger Miller19_millerrl@US.IBM.COM31_Mon, 10 Jan 2000 09:14:34 -0800357_us-ascii That DSNTESC is not at the V6 level. I looked into mine and found about 191 records, instead of the 61 for V5 level. Here's a small part of it, about 120 lines down. Put your authid into the first qualifier. EXPLAIN populates the explain tables.<br><br>Roger Miller<br><br>--The following statement creates the V6.1 sample DSN_STATEMNT_TABLE. [...]
4243 52 39_Re: DB2 Visual Explain, Statement Table11_GOSE PAUL M17_pmgose@SRPNET.COM31_Mon, 10 Jan 2000 10:26:19 -0700626_iso-8859-1 Thanks Roger. I didn't realize that the statement table was not supported under version 5, and unfortunately, we haven't made it to version 6 yet.<br><br>Paul<br><br>-----Original Message----- From: Roger Miller [mailto:millerrl@US.IBM.COM] Sent: Monday, January 10, 2000 10:15 AM To: DB2-L@RYCI.COM Subject: Re: DB2 Visual Explain, Statement Table<br><br><br><br>That DSNTESC is not at the V6 level. I looked into mine and found about 191 records, instead of the 61 for V5 level. Here's a small part of it, about 120 lines down. Put your authid into the first qualifier. EXPLAIN populates the explain tables. [...]
4296 38 13_validate(run)11_Danny Davis16_DTDAVIS@PCMH.COM31_Mon, 10 Jan 2000 12:29:00 -0500614_US-ASCII Can someone help clarify the validate(run) option for me? It's not the preferred option correct? From what I've read, binding plans with validate(run) is not good at all, since it basically takes the bound sql statements and treats them as dynamic by validating syntax, security, access path, etc. We accidentally bound a plan with the validate(run) option and when I was reviewings stats for the plan, I noticed the 'incremental binds' count was very high. I did another bind on the plan with validate(bind). I confirmed that the plan is now bound with the validate(bind) option. The problem is the [...]
4335 27 30_QMF in place of COBOL programs15_Michael Bancale21_mbancale@TXFB-INS.COM31_Mon, 10 Jan 2000 12:12:48 -0600423_iso-8859-1 Is there anyone using QMF to produce reports from their production data in place of writing COBOL programs? Since it is so easy to create reports with QMF some people here are looking at using it to help with some of the batch reporting.<br><br>Any input would be helpful.<br><br><br><br><br><br><br><br>Michael Bancale mbancale@txfb-ins.com Texas Farm Bureau Insurance Company www.txfb-ins.com Waco, Texas [...]
4363 46 34_Re: QMF in place of COBOL programs17_Scarcella, Gary V21_ScarcellaGV@AETNA.COM31_Mon, 10 Jan 2000 13:31:20 -0500307_- Yes, we use QMF for batch reports. It's a lot easier than writing COBOL. It's also easy to prototype reports and make changes quickly. Keep in mind that you can also pass variable input parms from your JCL to the QMF proc to the query and form. Gary Scarcella Internet address: ScarcellaGV@aetna.com [...]
4410 66 17_Re: validate(run)22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Mon, 10 Jan 2000 13:31:56 -0500391_- I assume you're talking about DB2 UDB for OS/390. To paraphrase the DB2 for OS/390 V5 Command Reference - VALIDATE(RUN/BIND) is used to recheck, at run time, authorization failures & object not found failures that occurred during the bind process. It has nothing to do with access path, SQL syntax etc... I would not expect VALIDATE(RUN/BIND) to influence the incremental bind count. [...]
4477 78 47_Re: Where in your IS organization are the DBAs?11_Ron Johnson25_rjohnson@DATA-TRONICS.COM31_Mon, 10 Jan 2000 14:19:29 -0600671_iso-8859-1 In our organization the DBAs are in our technical services department. Within this department there are 5 areas, one of which is database systems. Even though we call ourselves DBAs and are referred to as DBAs (among other things I suppose!), we are also DB2 systems programmers and occasionally client/server administrators. We mainly support DB2 for OS/390 and DB2 for NT. There are a few offshoots we occasionally get into but nothing significant (SQL Server, Informix). The other areas include mainframe systems (OS/390 sysprogs, storage mgmt), transaction systems (CICS sysprogs), client/server systems (NT admins, web support, PC tech support), and [...]
4556 75 34_Re: QMF in place of COBOL programs0_24_Ray.Price@DRESDNERKB.COM31_Mon, 10 Jan 2000 20:30:27 -0000331_iso-8859-1 Michael,<br><br>We run quite a few QMF's in batch. They are quick and easy to develop, and you can do quite a lot in QMF forms. We use REXX to invoke QMF, which allows us to pass various parameters to the QMF as global variables. We also use REXX to reformat the output where required, into CSV files, for example. [...]
4632 46 55_DB2 5.1, OS/390 2.5, VB 6 - Setting CURRENT PACKAGE SET15_DeMarco, Joseph18_DeMarcoJ@CONED.COM31_Mon, 10 Jan 2000 15:31:00 -0500670_- We are developing a Visual Basic client application that accesses DB2 tables through the IBM DB2 Connect gateway product.<br><br>The VB client uses dynamic SQL. DB2 Connect routes these requests to the mainframe where packages with collection id = NULLID are executed. We have created new packages with different collection ids by application. We have been successful in executing these new packages by setting the CURRENTPACKAGESET parameter in the db2cli.ini file. (This results in the execution of a package named: CurrentPackageSet Name.Package Name.) We're doing this so that we can control security by application using the new collections/packages and the [...]
4679 20 45_Database Modeling tools - Erwin vs. ER/Studio17_John Breidenstine31_JBreidenstine@LEGIS.STATE.PA.US31_Mon, 10 Jan 2000 15:25:23 -0500330_iso-8859-1 Hello all,<br><br>We are evaluating the Erwin and ER/Studio modeling tools for DB2 UDB on AIX. We were wondering if anyone out there is using either tool and could share their satisfaction or dissatisfaction. We are especially interested to see if anyone uses ER/Studio because it is about half the cost of Erwin. [...]
4700 48 43_Default schema alternatives for UDB on AIX?0_18_damcon2@US.IBM.COM31_Mon, 10 Jan 2000 15:38:39 -0500555_us-ascii Hello all,<br><br>I apologize if you are getting this again, but I didn't get any responses last time, so I'm not sure if it didn't make it to everyone, I didn't ask the question properly, or there just aren't any options. So, I'm sending it again...<br><br>Does anyone know if there is a way to set a default schema for a database with DB2 UDB V5.2 on AIX, other than issuing the "set current schema" command. What we are looking for is a way for anyone who connects to the database to automatically have the same default schema instead of [...]
4749 142 47_Re: Where in your IS organization are the DBAs?12_Myron Miller22_myronwmiller@YAHOO.COM31_Mon, 10 Jan 2000 12:45:34 -0800370_us-ascii This particular topic can get as many different opinions as there are DBAs. There was some discussion about this last year, if you can see the old archives.<br><br>Basically DBAs for the most part are found in two places - Tech support organizations and in applications. In my humble opinion neither place is better, it just depends on the local politics. [...]
4892 36 16_Re: CDB software12_Raymond Bell20_raymondb@NZ1.IBM.COM31_Tue, 11 Jan 2000 09:58:27 +1300612_us-ascii Andy,<br><br>Several years ago I had the pleasure to use a tool called DB2 Workbench, later called DB!Workbench for DB2. Excellent tool. A bit like today's Catalog Manager and RC/Query, plus a bit more. It would extract Catalog information overnight into its own datasets which you would query the next day. Because of this it was lightning-fast and kept away from the Catalog - probably less of a problem these days. It was also used for our DDL backups before changes. Did the usual Catalog querying stuff, plus DDL/DCL generation, command generation, zparm viewer, etc. A great little tool, but [...]
4929 22 10_ACTIVE LOG12_Silvia Motta21_silviamotta@YAHOO.COM31_Mon, 10 Jan 2000 13:12:45 -0800512_us-ascii Hello,<br><br>The active log of DB2 /OS 390 is LINEAR. So, Is neccesary define index to the cluster ???<br><br>thanks<br><br>__________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
4952 12 14_Re: ACTIVE LOG12_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM31_Mon, 10 Jan 2000 15:21:51 -0600297_us-ascii No, you do not define an index to the cluster.<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
4965 26 34_Data sharing required at D/R site?0_23_Mike_Levine@TEKHELP.NET31_Mon, 10 Jan 2000 16:25:41 -0500494_us-ascii Hi,<br><br>If you are running a data sharing configuration in a parallel sysplex production environment are you required to also run in a data sharing environment at a D/R site? I.e., is it necessary to have a CF configured or even be in a parallel sysplex environment? I am under the impression that it is required but wanted to know if there might be a way around it. It seems that this could complicate the D/R exercise somewhat, lengthen it and increase the associated costs. [...]
4992 43 49_Re: Database Modeling tools - Erwin vs. ER/Studio14_subrata mondal25_subratamondal@HOTMAIL.COM29_Mon, 10 Jan 2000 21:35:47 GMT683_- We are using ERWIN extensively - i have also used ER/Studio. But I feel Er/studio is a much better tool. I would recommend Er/Studio.<br><br>Thanks Subrata<br><br><br><br>>From: John Breidenstine <JBreidenstine@LEGIS.STATE.PA.US> >Reply-To: DB2 Data Base Discussion List <DB2-L@RYCI.COM> >To: DB2-L@RYCI.COM >Subject: Database Modeling tools - Erwin vs. ER/Studio >Date: Mon, 10 Jan 2000 15:25:23 -0500 > >Hello all, > >We are evaluating the Erwin and ER/Studio modeling tools for DB2 UDB on >AIX. >We were wondering if anyone out there is using either tool and could share >their satisfaction or dissatisfaction. We are especially interested to see >if anyone uses ER/Studio [...]
5036 36 38_Re: DSNZPARM Option SEQCACH for RAID ?12_Roger Miller19_millerrl@US.IBM.COM31_Mon, 10 Jan 2000 13:35:48 -0800530_us-ascii Ok. I'll bite with some opinions - mine and not necessarily those of my employer, my wife, or anyone else.<br><br>This does sound like a blast from the past. I remember this kind of problem in 1995. We started recommending a minimum of 256 MB for the 3990 cache when used with RAMAC 2 back in 1995. We have taken dramatic strides in disk since then, with RAMAC 2, RAMAC 3, RVA and now the ESS, where the cache size is 6 GB. RAMAC 1 and a small cache are not the choices for anything that is sensitive to performance [...]
5073 182 33_Re: Load Errors using VARCHAR Col13_Horton, Libby20_Libby_Horton@BMC.COM31_Mon, 10 Jan 2000 16:44:10 -0600622_ISO-8859-1 Hello - The following response was provided by a BMC Support Analyst who is not a listserv subscriber so I am posting it. Hope this helps! Libby Horton<br><br><br><br><br><br>Unload Plus always generates a two byte length code for each varchar/long varchar column that is unloaded. This length code immediately preceeds the varchar data. Unload Plus has a command option, FIXEDVARCHAR YES, which will pad varchar data to the maximum length. However, this is NOT mandatory for a load to work and certainly not recommended if the varchar column is to be a true varchar and not contain the padded characters. [...]
5256 75 41_Re: DB2 UDB: Is SMS or DMS better to use?12_Chris Miller24_Chris_Miller@PAYLESS.COM31_Mon, 10 Jan 2000 16:56:40 -0600592_us-ascii We use SMS to avoid some of the space management administration that comes with DMS. Like yourself, we run UDB on NT and UNIX (AIX). DMS can give you some nice options (like locating indexes in a separate table space using different containers, the ability to add containers, etc.) We do use DMS in one of our OLTP databases where performance is a high concern. However, if you're not experiencing any big performance problems (like most of our other systems), I would stick with SMS. Its simply easier to manage (especially if you're understaffed and have many other things to [...]
5332 12 29_Rebind aft ALTER INDEX type 216_JOHN G. MATTHEWS26_HC#JGM@MVS.MEDCTR.UCLA.EDU31_Mon, 10 Jan 2000 15:12:00 -0800415_- I seem to remember something about need to REBIND packages after converting indexes from type 1 to type 2 but I don't see anything in the V5 manual. Is this a requirement?<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
5345 58 30_QMF in place of COBOL programs14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Tue, 11 Jan 2000 10:08:17 +1000404_us-ascii Michael,<br><br>We use QMF but in a limited way for reports whose structure is not too complex.<br><br>Sometimes if a report performs badly, people in the past have recommended to rewrite in COBOL. Actually QMF performs very well if used sensibly. We do not use CALC stuff because routines have to be loaded. However at some sites CALC performs alright due to different installation setup. [...]
5404 38 17_Re: validate(run)14_Susan Birgeles25_Susan.Birgeles@ALLTEL.COM31_Mon, 10 Jan 2000 16:09:00 -0600598_us-ascii an someone help clarify the validate(run) option for me? It's not the preferre d option correct? From what I've read, binding plans with validate(run) is not good at all, since it basically takes the bound sql statements and treats them a s dynamic by validating syntax, security, access path, etc. We accidentally bou nd a plan with the validate(run) option and when I was reviewings stats for the plan, I noticed the 'incremental binds' count was very high. I did another bind on the plan with validate(bind). I confirmed that the plan is now bound with t he validate(bind) option. [...]
5443 166 27_Re: DB2 V6 Join Enhancement14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Tue, 11 Jan 2000 10:29:54 +1000471_us-ascii This the new full functionality and fully optimized Outer Join in DB2 V6 OS/390.<br><br>Before than we had a sort of cut down Outer Join not really up to it for online use of multiple join SQLs.<br><br>Remember that logically the WHERE clause filters the final results. The ON clause restricts which rows will be matched together in the join between the 2 tables and which cases will not be matched therefore allowing Nulls in the right table of LEFT JOIN. [...]
5610 40 27_Stopping multi index access12_Dennis Raher27_Dennis_Raher@COMPUSERVE.COM31_Mon, 10 Jan 2000 19:54:21 -0500564_ISO-8859-1 I hope someone can help with a suggestion. I have a query against a table with a number of indexes, and the WHERE clause contains sets of very similar conditions which are OR'ed together. Wile there is an index which containes all of the needed WHERE conditions DB2 insists on using a combination of indexes in a multi-index access path that is giving horrible results. Actually the query is a join of two tables, a small header table and it's 14,000,000 detail table. It is the detail table that has all the indexes. I believe that if I could get [...]
5651 200 47_Re: Default schema alternatives for UDB on AIX?11_ALLEN,Bruce37_bruce.allen@EMPLOYMENTNATIONAL.COM.AU31_Tue, 11 Jan 2000 12:26:00 +1100588_- Hi Jay, Can you wait for v6? CLI option of CURRENTSCHEMA= set on the client (db2cli.ini file) will issue the set current schema for you.<br><br>HTH, Bruce<br><br>> -----Original Message----- > From: damcon2@US.IBM.COM [SMTP:damcon2@US.IBM.COM] > Sent: Tuesday, January 11, 2000 7:39 AM > To: DB2-L@RYCI.COM > Subject: Default schema alternatives for UDB on AIX? > > Hello all, > > I apologize if you are getting this again, but I didn't get any responses > last time, so I'm not sure if it didn't make it to everyone, I didn't ask > the question properly, or there just aren't any [...]
5852 73 38_Re: Data sharing required at D/R site?14_Linda Claussen18_lindafc@NETINS.NET31_Mon, 10 Jan 2000 21:01:24 -0600388_ISO-8859-1 As the manuals say:<br><br>"The recovery site must have a data sharing group that is identical to the group at the local site. It must have the same name, the same number of members and the names of the members must be the same. The CFRM policies at the recovery site must define the coupling facility structures with the same names (although the sizes can be different). [...]
5926 63 31_Re: Stopping multi index access0_24_ssethi@LOT.TATASTEEL.COM29_Tue, 11 Jan 2000 03:19:19 GMT295_us-ascii Hi Dennis, I think " OR (0=1) " with the predicate of the index which u don't want to use can help optimizer to avoid that index , If u feel only one index will be better . Regarding the use of smaller table first,I think accessing the smaller table first should not be a problem. [...]
5990 16 19_SQL to generate DDL14_Linda Hagedorn29_LLHAGEDORN@GWMAIL.STATE.NV.US31_Mon, 10 Jan 2000 17:15:56 -0800405_US-ASCII Does someone have a copy of the SQL that generates DDL which was posted on DB2-L about three years ago? I need and cannot find my copy.<br><br>Thanks. Linda<br><br>===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
6007 117 31_Re: Stopping multi index access14_Purcell, Terry37_Terry.Purcell@CORPMAIL.TELSTRA.COM.AU31_Tue, 11 Jan 2000 14:40:11 +1100561_iso-8859-1 Dennis,<br><br>The use of 0=1 is one of the many techniques available to disable index usage, however it can have a negative impact on performance in that it makes the predicate stage 2.<br><br>Other options are: 1. Optimize for 1 row "will", and optimize for n rows "may" remove multi-index. 2. Disabling the indexability of the individual OR'd predicates which you wish to discourage (by adding + 0 to a numeric or concat ' ' to a char - both stage 1 in V5) 3. Use of NOT logic to remove indexability of predicates (still stage 1) 4. Adding a [...]
6125 84 28_Re: DB2 PM and authasn (0C4)12_MILLS,Robert26_robert.mills@DEWRSB.GOV.AU31_Tue, 11 Jan 2000 15:30:20 +1100358_iso-8859-1 We use the DB2PM Workstation Monitor via TCP/IP successfully with most of our subsystems. It's a great feature of PM and I've been surprised that not more people use it.<br><br>I recall a problem with an OC4 after we had applied some DB2PM maintenance. From what I remember re-running the PM link job DGOJ6LNK in SDGOINS1 solved our problem. [...]
6210 70 34_Re: QMF in place of COBOL programs25_Robinson, Peter [IBM GSA]40_Peter.J.Robinson@CORPMAIL.TELSTRA.COM.AU31_Tue, 11 Jan 2000 15:53:30 +1100502_- Hi Michael<br><br>I've worked in sites where QMF was used for reporting and the only problem we ever had was that the code was not detected by a cross reference report, making change impact analysis difficult. Tools I have seen this happen with are Composer, Natural and some of the COBOL cross reference utilities. Just make sure the developers are careful with their impact analysis or they may find that after a database change goes into production, their QMF reports magically stop working. [...]
6281 178 26_Re: Access Path of a Query0_24_ssethi@LOT.TATASTEEL.COM29_Tue, 11 Jan 2000 05:33:50 GMT511_us-ascii Hi Michael, Thanks for a very good method of forcing it to do view materialization and forcing it to follow index (in my case). Considering all the informations are good enough and my maximum filtering can be done from these 2 predicates AND T1.COL2 = literal AND T1.COL5 = literal ,my question is will it be a good idea to follow this method for forcing the DB2 to use index and then apply the predicates which are not indexeable , considering the fact that view materialization is taking place. [...]
6460 39 17_Space calculation13_Marcus Davage29_Marcus.Davage@LLOYDSTSB.CO.UK31_Tue, 11 Jan 2000 10:33:00 -0000392_iso-8859-1 Given the row count (cardinality), row length, freepage, pctfree, pagesave (if compressed), pagesize, and anything else that is aqcuirable from the catalog, how can I deduce the PRIQTY and SECQTY for a tablespace and its indexes in order to reorg them into one extent?<br><br>We have BMC catalog and change manager and PDA, but I want to write a little Rexx to do it quickly. [...]
6500 43 14_Re: ACTIVE LOG7_Gustavo26_lozano@BANDEIRANTES.COM.BR31_Tue, 11 Jan 2000 08:55:05 -0300839_iso-8859-1 Silvia, we never defined an index to this cluster.<br><br>Gustavo Lozano (lozano@bandeirantes.com.br) - DBA Banco Bandeirantes Sao Paulo - Brazil<br><br>-----Mensagem original----- De: Silvia Motta <silviamotta@YAHOO.COM> Grupos de notícias: bit.listserv.db2-l Para: DB2-L@RYCI.COM <DB2-L@RYCI.COM> Data: Segunda-feira, 10 de Janeiro de 2000 18:12 Assunto: ACTIVE LOG<br><br><br><br>>Hello, > >The active log of DB2 /OS 390 is LINEAR. >So, Is neccesary define index to the cluster ??? > >thanks > >__________________________________________________ >Do You Yahoo!? >Talk to your friends online with Yahoo! Messenger. >http://im.yahoo.com > >================================================ >To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners [...]
6544 73 21_Re: Space calculation22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Tue, 11 Jan 2000 11:22:49 +0000527_ISO-8859-1 Marcus Adrian may reply more to this (calling Adrian .... ) but if it were me then I would run PDA stats collection (Fastscan) on all obkects (400 gig takes about 4/5 hours to scan to give you some idea of time) - then you will nice detailed data in your PDA database from which to then run an automated PDA sizing job (uding PDA internal sizing variables) and size objects into 1 Extent (assuming the object is not too big to go into 1 extent). (note that as long as the number of extents the dataset is in is [...]
6618 27 31_Estimation tools and techniques14_Jackie Gribbon23_jgribbon@GSSEC.BT.CO.UK31_Tue, 11 Jan 2000 12:08:20 +0000602_iso-8859-1 I'm carrying out a review of "common practice" in the field of estimation tools and techniques. If you are involved in estimating or have recent experience it would help me greatly if you could respond and tell me what tools or techniques you use and your opinion as to their accuracy or suitability to your particular field (please state). For anonymity, please respond by e-mail to jgribbon@gssec.bt.co.uk. Your individual replies will not be passed on to any other person, not even in my organisation. I will however collate the replies and will post the results to this list in due [...]
6646 26 38_Automatic Increment (+1)On Numeric Key17_Rabindra Senapati21_rsenapati@HOTMAIL.COM29_Tue, 11 Jan 2000 04:28:45 PST334_- Hi All,<br><br>I am wondering whether DB2 have the automatic increment feature by (+1) on a numeric key field like ORACLE and SQL Server[example: we mention identity(1,1)on SQL Server in the DDL scripts]. Is there any UDFS or something (which i don't know) to fulfill this or the application program going to takecare of that? [...]
6673 40 14_Re: ACTIVE LOG14_Wilco Boschman16_wilcob@XS4ALL.NL31_Tue, 11 Jan 2000 13:59:56 +0100330_- Hi,<br><br>you cannot, as far as I know, define indeces to LDS's from a AMS point of view. From a DB2 point of view the active log isn't a table with rows and columns, so you cannot create an index to that. DB2 keeps its own kind of 'index' to the log (not only the active log) i.e. in the logrange in the SYSIBM.SYSLGRNG. [...]
6714 70 21_Re: Space calculation19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Tue, 11 Jan 2000 07:09:58 -0600557_iso-8859-1 Marcus, I've always used HI_USED_RBA from a LISTCAT / 737,280 = 3390 triple cyls with the caveat that this field is only updated when a new extent is taken or the VLD is closed. There may be exceptions to this but I am unaware of any.<br><br>HTH, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have [...]
6785 107 22_Primary key of a table27_Thakral, Deepak Kumar (CTS)24_TDeepak@CHN.CTS-CORP.COM31_Tue, 11 Jan 2000 18:46:35 +0530475_iso-8859-1 Hi !<br><br>Which catalog of IBM should I query to find out the primary key of a table ?<br><br><br><br>Will Syskeys or Systables give that information ?<br><br>Thanks Deepak<br><br><br><br>DEEPAK THAKRAL PROGRAMMER ANALYST, FDR PROJECT, COGNIZANT TECHNOLOGY SOLUTIONS 226, CATHEDRAL ROAD,CHENNAI Email : tdeepak@chn.cts-corp.com Phone : 044-827 0063(2350) Email2: deepakthakral@mailcity.com If you are not living on the edge, you are occuping too much space [...]
6893 130 42_Re: SMF - CPU time, Plan, and User and MXG11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Tue, 11 Jan 2000 07:57:33 -0500375_iso-8859-1 For all those shops out there that have SAS you should check to see if you have MXG. I have used the features of this product for years for DB2 and CICS performance and accounting issues and there is lots of function there. One feature I use a lot is the DB2/PM style reports. The product is very reasonable if you already own SAS. (I think it is now $ 1500) [...]
7024 43 26_Re: Primary key of a table17_Marchese, Frank D18_fdmarchese@ATT.COM31_Tue, 11 Jan 2000 08:21:35 -0500402_iso-8859-1 SYSINDEXES, where UNIQUERULE = 'P' and join with SYSKEYS to get the column name.<br><br>-----Original Message----- From: Thakral, Deepak Kumar (CTS) [mailto:TDeepak@CHN.CTS-CORP.COM] Sent: Tuesday, January 11, 2000 8:17 AM To: DB2-L@RYCI.COM Subject: Primary key of a table<br><br><br><br><br><br>Hi !<br><br>Which catalog of IBM should I query to find out the primary key of a table ? [...]
7068 26 21_Re: Space calculation9_Colin Fay13_cfay2@CSC.COM31_Tue, 11 Jan 2000 08:21:13 -0500356_us-ascii Hi,<br><br>I have a REXX routine that reads a LISTCAT listing directly , calculates the primary and secondary extents and creates the JCL required to execute the ALTER statments. It also puts out an file of tablespaces and indexes that need to be reorged. This file can be put into another REXX routine that generates the JCL for the reorgs. [...]
7095 312 26_Re: Primary key of a table0_22_The-Thanh.Luong@AGF.BE31_Tue, 11 Jan 2000 14:24:57 +0100326_- Hi,<br><br>It is in the SYSCOLUMNS system table (we are running DB2 V4 - OS390). I use this query:<br><br>SELECT TBCREATOR ,TBNAME ,NAME ,KEYSEQ FROM SYSIBM.SYSCOLUMNS WHERE TBCREATOR = 'ownername' AND TBNAME = 'tablename' AND KEYSEQ > 0 ORDER BY TBNAME ; -- NOTE THAT KEYSEQ = COLUMN'S RELATIVE POSITION WITHIN TABLE'S P.K.
7408 37 21_Re: Space calculation14_Massimo Scarpa16_mscarpa@CESVE.IT31_Tue, 11 Jan 2000 14:42:09 +0100318_us-ascii This is the method ( I process a filtered LISTCAT with REXX ) I use for an automating tuning of<br><br>TS to maintain MAX 3 ext (for brief time) and to generate automatic ALTER statement needed<br><br>every day, too ! I use this method since 1992 and it still works......and less of 2% of our tablespace [...]
7446 34 32_ASYNCHRONOUS DATA MOVER FACILITY19_Briggs, N. - Neil -25_N.Briggs@CANON-EUROPA.COM31_Tue, 11 Jan 2000 14:46:25 +0100404_iso-8859-1 Dear All,<br><br>Os390, db2 v5<br><br>I am trying to move away from one large bufferpool, in order to use a number of smaller bufferpools to try and increase the performance of our production DB2 subsystem. When trying to create a virtual pool and a hiperpool I get the following message<br><br>"DSNB610I @ UNABLE TO CREATE HIPERPOOL BP0 - ASYNCHRONOUS DATA MOVER FACILITY NOT INSTALLED" [...]
7481 139 38_Re: DSNZPARM Option SEQCACH for RAID ?13_Lynne Flatley17_LFlatley@NEFN.COM31_Tue, 11 Jan 2000 09:00:27 -0500409_iso-8859-1 Here's a sampling of the average response times, as reported by our performance monitor, TMON for DB2,<br><br>DATE: 01/10/00 T H E M O N I T O R F O R D B 2 PAGE: 115 TIME: 14:49:11 P L A N R E S O U R C E R E A D I / O D E T A I L DATA IS FROM 01/05/00 AT 00:00 TO 01/05/00 AT 23:59 DB2 END DATE CONN ID PLAN RESOURCE OB # OF # ASYNC # ASYNC ASYNC RD # SYNC # SYNC SYNC RD NAME NAME RECS PGS [...]
7621 25 26_backup intelligent product17_Bartolucci Silvia25_S.Bartolucci@FONDIARIA.IT31_Tue, 11 Jan 2000 15:05:38 +0100385_- Hi ! Anyone can suggest me a product for 'intelligent backup' of tablespaces ? I really need to do tablespace backup without coding jcl , writing only some exception list to exclude some table from copying. So ,the 'intelligent product' , reading the DB2 catalog and my exception list ,can create the coding to make full and/or incremental.(also calculating the space needed ). [...]
7647 33 12_LPL recovery0_19_mike.holmans@BT.COM31_Tue, 11 Jan 2000 14:09:48 -0000561_- OS/390 1.2, DB2 V5.<br><br>One way of clearing an LPL status on an index is to START the indexspace ACC(RW).<br><br>How long should one expect it to take? OK, I know "it depends", but what does it depend on?<br><br>Yesterday I found an index on our development system was in LPL status. It takes up about 2000 tracks. -DIS DB(x) SPACE(y) LPL indicated that the error page list was 000000-ffffff, but that was only after I'd already issued the -STA DB(x) SPACE(y), and I can imagine that the error page list was a bit odd while recovery was proceeding. I [...]
7681 68 73_Resizing Tablespace With Larger Page/Blocksize in DB2 UDB on AIX Platform0_22_Stepansky_Ruby@EMC.COM31_Tue, 11 Jan 2000 09:11:00 -0500464_- Is there a way without creating a new table, which would mean affecting all current SQL, to use the Old table name in the new physical object?<br><br>Ruby Stepansky EMC Sr. Enterprise Data Warehousing Technology Architect Office: 212-301-7093 Fax: 212-564-6909 stepansky_ruby@emc.com <mailto:stepansky_ruby@emc.com><br><br>-----Original Message----- From: salhany, michael Sent: Thursday, January 06, 2000 5:05 PM To: Stepansky, Ruby Subject: FW: pmr 73587 [...]
7750 31 23_Re: SQL to generate DDL12_Lisle, Kathy19_KLLISLE@INTEGON.COM31_Tue, 11 Jan 2000 09:20:22 -0500496_windows-1252 Check the archives. It was reposted last Oct., to get it in our new archives. Search on "Gen DDL" in the subject line. It works well, by the way.<br><br>-----Original Message----- From: Linda Hagedorn [mailto:LLHAGEDORN@GWMAIL.STATE.NV.US] Sent: Monday, January 10, 2000 8:16 PM To: DB2-L@RYCI.COM Subject: SQL to generate DDL<br><br><br><br>Does someone have a copy of the SQL that generates DDL which was posted on DB2-L about three years ago? I need and cannot find my copy. [...]
7782 55 36_Re: ASYNCHRONOUS DATA MOVER FACILITY17_Snoeyenbos, Craig35_Craig.Snoeyenbos@STARWOODHOTELS.COM31_Tue, 11 Jan 2000 09:24:46 -0500442_iso-8859-1 Neil,<br><br>What is your hardware platform ? If you are on a CMOS box, the ADM is (mostly) not applicable, otherwise I'm suprised that it's not already there. In either case it's an issue for the MVS support people.<br><br>Craig<br><br>-----Original Message----- From: Briggs, N. - Neil - [mailto:N.Briggs@CANON-EUROPA.COM] Sent: Tuesday, January 11, 2000 8:46 AM To: DB2-L@RYCI.COM Subject: ASYNCHRONOUS DATA MOVER FACILITY [...]
7838 60 16_Re: LPL recovery12_Paul Packham28_packhamp@IT.POSTOFFICE.CO.UK31_Tue, 11 Jan 2000 14:26:20 -0000498_iso-8859-1 Mike,<br><br>The answer to your question might be never ! We have an open problem with the code team where we were getting index pages on the LPL & not recovering even after a -start db() etc. was issued. The Apar is still open. See pq30839 for details.<br><br>Regards, Paul<br><br><br><br>-----Original Message----- From: mike.holmans@BT.COM <mike.holmans@BT.COM> Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM <DB2-L@RYCI.COM> Date: 11 January 2000 14:11 Subject: LPL recovery [...]
7899 177 36_Re: ASYNCHRONOUS DATA MOVER FACILITY22_Kennedy, Tom - Cendant23_Tom.Kennedy@CENDANT.COM31_Tue, 11 Jan 2000 09:32:07 -0500536_iso-8859-1 The ADMF is a hardware feature that has to be activated at the console from where IPLs are initiated. It is not an installable product. We have an IBM 9672 and the ADMF feature had to be activated from the HMC, hardware management console. There was a box on the screen that needed to be "clicked on". After that was done an IPL has to be scheduled. The IPL has to be one that activates the lpar, not one that just does a load. Only when the IPL is an activate does the new feature, the ADMF activation, become enabled. [...]
8077 67 30_Re: backup intelligent product11_Carl Nelson20_Carl_Nelson@AICI.COM31_Tue, 11 Jan 2000 09:31:03 -0600378_US-ASCII Silvia<br><br>We use BMC to do that thinking for us. You can use filter lists to exclude/include specific TS. It also does this for reorgs and runstats. It determines which TS need attention based on criteria we set and builds the jobs for us. We do not allow it to auto-submit the jobs, however it can do that. We are happy with the product and the tech support. [...]
8145 217 26_Re: Access Path of a Query14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Wed, 12 Jan 2000 01:27:13 +1000355_us-ascii Sanjeev,<br><br>I suppose your original change of access path was a little suprizing, so most likely the choice by the Optimizer was a very borderline case re whether COL2 and COL5 did enough filtering to make index use worthwhile. However if your data is skewed you may very well know better than the Optimizer for your particular example. [...]
8363 15 21_Re: Space calculation11_Joe Bitetto31_joseph.bitetto@US.PWCGLOBAL.COM31_Tue, 11 Jan 2000 08:32:58 -0600402_- I believe someone already mentioned that with PDA you could collect statistics using FASTSCAN for all objects. Once you have these statistics you can then retrieve all necessary information such as PRIQTY, SECQTY and even Pages needed for reorg from Platinum table PTI.RATS_STAT_201. I have successfully used this information along with a SAS program to build DEFINE CLUSTER statements for D/R. [...]
8379 640 51_Gen DDL from DB2 Catlg V2 - Setup and Sample Output14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Wed, 12 Jan 2000 01:33:30 +1000198_us-ascii Generate DDL from DB2 Catlg using SQL: This part is Setup DDL/SQL followed by Sample Output after @@@ Actual DDL gen is other messages. Use at own risk.<br><br>SET CURRENT SQLID = 'GPRCTS';
9020 25 41_Disaster Recovery. Any book/article etc ?14_Massimo Scarpa16_mscarpa@CESVE.IT31_Tue, 11 Jan 2000 15:45:06 +0100375_us-ascii I've been asked, "obtorto collo", to begin to create a first 'nucleus' of Disaster Recovery<br><br>application. I've seen that the LIST had many posts about this argument and so I call for more<br><br>info: is there any (good) book or (serious) article, paper, presentation, review, proceedings ,<br><br>Internet site etc. etc. which deal (very well) with DR ? [...]
9046 636 34_Gen DDL from DB2 Catlg V2 - Part 114_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Wed, 12 Jan 2000 01:38:04 +1000494_iso-8859-1 Generate DDL from DB2 Catlg using SQL commences (continued in parts 2 and 3). Other message has setup and sample output. Most previous restrictions covered. -- LIMITATIONS: NO V6 STUFF. -- ONLY ALLOWS VIEWS ON VIEWS OR ON TABLES (NOT ON ALIASES OR SYNS) -- SOME LITTLE THINGS LEFT OUT, E.G. DS PASSWORDS. -- DOESN'T DO UTILITY CONTROL STMTS LIKE RECOV INDEX OR CHECK DATA -- NO SYNONYMS (ASSUMES USE OF ALIASES). -- SOME THINGS I FORGOT MAYBE? -- MODIFY TO SUIT YOUR OWN NEEDS. [...]
9683 729 34_Gen DDL from DB2 Catlg V2 - Part 214_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Wed, 12 Jan 2000 01:40:33 +1000743_us-ascii Generate DDL from DB2 Catlg using SQL continues (see also in parts 1 and 3). Other message has Setup and sample output.<br><br>---------------------------------------------------------------------- -- TABLE DROP RESTRICT ON DROP. ---------------------------------------------------------------------- SELECT SUBSTR(TEXT,1,80) AS TEXT ,TBCREATOR ,TBNAME ,CLAUSENO ,SUBNAME ,SEQNO ,LINENO FROM (SELECT CREATOR AS TBCREATOR ,NAME AS TBNAME ,' ' AS SUBNAME ,0 AS CLAUSENO ,0 AS SEQNO ,LINENO ,CASE WHEN LINENO = 1 THEN ' ALTER TABLE '!!STRIP(CREATOR)!!'.'!!STRIP(NAME) !! ' DROP RESTRICT ON DROP ;' WHEN LINENO = 2 THEN ' COMMIT;' ELSE F.FILL END AS TEXT FROM SYSIBM.SYSTABLES T ,GPRCTS.LINENOS L ,GPRCTS.TEXT80 F WHERE F.FILL = ' ' [...]
10413 34 21_Re: Space calculation50_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM31_Tue, 11 Jan 2000 09:49:59 -0500637_- It ran extremely slow.<br><br>> ---------- > From: Joe Bitetto[SMTP:joseph.bitetto@US.PWCGLOBAL.COM] > Reply To: DB2 Data Base Discussion List > Sent: Tuesday, January 11, 2000 9:32 AM > To: DB2-L@RYCI.COM > Subject: Re: Space calculation > > I believe someone already mentioned that with PDA you could collect > statistics using FASTSCAN for all objects. Once you have these statistics > you can then retrieve all necessary information such as PRIQTY, SECQTY and > even Pages needed for reorg from Platinum table PTI.RATS_STAT_201. I have > successfully used this information along with a SAS program to build > DEFINE > CLUSTER [...]
10448 688 34_Gen DDL from DB2 Catlg V2 - Part 314_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Wed, 12 Jan 2000 01:42:18 +1000934_us-ascii Generate DDL from DB2 Catlg using SQL completes (see also in parts 1 and 2). Other message has Setup and sample output.<br><br>---------------------------------------------------------------------- -- VIEWS - VIEW TEXT FROM SYSVIEWS ---------------------------------------------------------------------- SELECT TEXT80 AS TEXT ,LEVEL ,CREATOR ,NAME ,10 AS CLAUSENO ,LINENO FROM (SELECT SUBSTR(TEXT1 !! VALUE(SUBSTR(V.TEXT,1, CASE WHEN LENGTH(V.TEXT) >= PRIORLENREC2 THEN PRIORLENREC2 ELSE LENGTH(V.TEXT) END),'')!!' ' ,1,80) AS TEXT80 ,Y.NAME, Y.CREATOR, Y.LINENO ,LEVEL FROM ---------------------------------------------------------------------- -- THE FOLLOWING COMPLEX CODE REDISTRIBUTES VIEW TEXT -- TO 72 CHAR LINES FROM VARCHAR 254 IN CATLG. -- SEEMS TO WORK SO FAR??? ---------------------------------------------------------------------- (SELECT X.CREATOR ,X.NAME ,X.LINENO ,LEVEL ,X.RECNO2 ,X.PRIORLENREC2 ,CASE [...]
11137 47 30_Re: backup intelligent product22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Tue, 11 Jan 2000 14:58:18 +0000706_ISO-8859-1 Silvia can I suggest Platinum(CA) PDA ..<br><br>great product.<br><br>Leslie<br><br><br><br>______________________________ Reply Separator _________________________________ Subject: backup intelligent product Author: Bartolucci Silvia <S.Bartolucci@FONDIARIA.IT> at Internet Date: 1/11/00 3:05 PM<br><br><br><br>Hi ! Anyone can suggest me a product for 'intelligent backup' of tablespaces ? I really need to do tablespace backup without coding jcl , writing only some exception list to exclude some table from copying. So ,the 'intelligent product' , reading the DB2 catalog and my exception list ,can create the coding to make full and/or incremental.(also calculating the space needed ). [...]
11185 46 42_Re: Automatic Increment (+1)On Numeric Key14_subrata mondal25_subratamondal@HOTMAIL.COM29_Tue, 11 Jan 2000 15:05:28 GMT629_- >From: Rabindra Senapati <rsenapati@HOTMAIL.COM> I guess it is in Ver 6.1. I remember seeing the function in 6.1 but ver 5.2 has a function Identified but I am not sure what it does.<br><br>Thanks subrata<br><br>>Reply-To: DB2 Data Base Discussion List <DB2-L@RYCI.COM> >To: DB2-L@RYCI.COM >Subject: Automatic Increment (+1)On Numeric Key >Date: Tue, 11 Jan 2000 04:28:45 PST > >Hi All, > > I am wondering whether DB2 have the automatic increment feature by (+1) >on a numeric key field like ORACLE and SQL Server[example: we mention >identity(1,1)on SQL Server in the DDL scripts]. Is there any UDFS or >something (which [...]
11232 27 30_Re: backup intelligent product14_Massimo Scarpa16_mscarpa@CESVE.IT31_Tue, 11 Jan 2000 16:06:36 +0100571_us-ascii I agree with Leslie, Silvia.<br><br>When I worked in Infocamere we use PDA to manage DB2 objects and it's very<br><br>'intelligent' , so you can specify filters to create copy/reorg etc your TS, IX and so on as you<br><br>need.<br><br>Regards (Saluti.....:-)) )<br><br>Max Scarpa Cesve Spa Padova<br><br>mscarpa@cesve.it<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
11260 21 49_Extracting table level info from DB2 Recovery log9_Balaji.P.19_balajip@MAINTEC.COM31_Tue, 11 Jan 2000 20:25:43 +0530365_us-ascii We are in the process of developing a tool which will make the movement of data from DB2 database of IBM Mainframe to other databases and vice versa. We also intend using Recovery log of DB2 for this purpose.<br><br>In this regard, we wish to know, how we could relate a particular transaction of DB2 Recovery Log record to a particular table of DB2. [...]
11282 25 0_9_Balaji.P.19_balajip@MAINTEC.COM31_Tue, 11 Jan 2000 20:43:21 +053024_us-ascii REVIEW LACTACID
11308 22 6_RCT ?s12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Tue, 11 Jan 2000 09:23:00 -0500393_- What does your shop use for THRDMAX and THRDA and THRDM for your production systems?<br><br>Do you separate each transaction on a separate Entry Thread instead of grouping them on one entry? Ex. DSNCRCT TYPE=ENTRY,TXID=TX01,PLANNAME=PLAN1 or DSNCRCT TYPE=ENTRY,TXID=(TX01,TX02,TX0n),PLANNAME=PLAN1<br><br>Do you have protected threads, all threads default to pool or a mixture of both? [...]
11331 42 53_Re: Extracting table level info from DB2 Recovery log20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 11 Jan 2000 10:36:36 -0500374_- The bigger question is how you are reading DB2 logs ?<br><br>If you are not using LOG ANALYZER, you have following choice. - Use IFI and start traces to read LOG records. - Use DSNJSLR macro using assembler code - Use LOG CAPTURE exits (not recommended)<br><br>IFI is the best choice here. You could relate particular table using its OBID, DBID or pageset with PSID. [...]
11374 71 19_DB2 Connect and ADO24_Murray, David (CAP, CMC)28_David_Murray@MORTGAGE.GE.COM31_Tue, 11 Jan 2000 10:37:57 -0500305_iso-8859-1 Is anyone using DB2 Connect 5.1 (for OS390) and ADO 2.1 to support web applications? It seems that ADO properties like record count, etc. do not seem to be supported. This is our first attempt at this and we're not sure if it should work. We do use DB2 Connect from VB applications (DAO). [...]
11446 36 45_Re: Disaster Recovery. Any book/article etc ?12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Tue, 11 Jan 2000 09:36:00 -0500450_- Most of our disaster recovery was created from info in the RedBook - "DB2 OFFSITE RECOVERY SAMPLE PROCEDURES" GG24-3601-00. This books is fairly old and may be out of date/print.<br><br><br><br><br><br>>>> DB2-L@RYCI.COM@inter2 01/11/00 08:45AM >>> I've been asked, "obtorto collo", to begin to create a first 'nucleus' of Disaster Recovery<br><br>application. I've seen that the LIST had many posts about this argument and so I call for more [...]
11483 60 10_Re: RCT ?s12_craig patton21_prgpatton@HOTMAIL.COM29_Tue, 11 Jan 2000 07:47:15 PST583_- Bob,<br><br>First, THRDMAX should be: [(sum)THRDM + 3] . This will prevent hitting a the THRDMAX threshold, which causes all threads to be deleted (even if defined as permanent) at the end of each transaction. (This starts if [(SUM)THRDM] is within 2 of THRDMAX.)<br><br>Second, how to define entries gets much more complicated. I believe Craig Mullins' book has a good description of when to use each as it is one of those "It Depends" type of responses. Ie. Frequently executed, short transactions, most likely, should use permanent threads associated with their own entry. [...]
11544 17 45_Re: Disaster Recovery. Any book/article etc ?12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 11 Jan 2000 07:46:56 -0800520_us-ascii There are many redbooks on this topic. There is even a disaster recovery library, although it's getting old. I'd suggest searching the red books with the words availability, disaster and recovery separately to see which ones fit your needs the best.<br><br>Roger Miller<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
11562 52 16_Re: LPL recovery15_Di Carlo, Donna23_Donna_Bermender@BMC.COM31_Tue, 11 Jan 2000 09:54:09 -0600427_ISO-8859-1 During the START, DB2 uses log records to mend the space that is in LPL status. I would guess that the time to start the space would depend, partially, on how far back DB2 had to go to process log records.<br><br>Donna Di Carlo BMC Software<br><br>-----Original Message----- From: mike.holmans@BT.COM [mailto:mike.holmans@BT.COM] Sent: Tuesday, January 11, 2000 8:10 AM To: DB2-L@RYCI.COM Subject: LPL recovery [...]
11615 112 38_Re: Data sharing required at D/R site?0_18_damcon2@US.IBM.COM31_Tue, 11 Jan 2000 11:02:04 -0500570_us-ascii Linda,<br><br>For local configuration, if data sharing is being setup on one MVS system for multiple DB2 subsystems is the coupling facility and sysplex timer still required or is this only for when multiple MVS systems are involved?<br><br>Just curious, Jay<br><br><br><br>Jay Reavill damcon2@us.ibm.com IBM Global Services Tampa, Florida Tel: (813) 878-3525, Tie Line 8-427-3525 ----------------------------------------------------- Happiness is not around the corner. Happiness is the corner. - BMW ----------------------------------------------------- [...]
11728 81 53_Re: Extracting table level info from DB2 Recovery log13_Colin Dickens34_Colin.Dickens@CCMAIL.EU.SONY.CO.JP31_Tue, 11 Jan 2000 15:50:08 +0000463_ISO-8859-1 Without the use of oem or IBM s/w products to process log data, you are stepping into dangerous waters. Consider the following;<br><br><br><br>You will need to know the format of the log records produced by DB2, there are many different types of update log formats.<br><br>If you are using compressed data, you will either need to use the relevant IFCID to decompress these for you and they will need the current compression dictionaries present. [...]
11810 110 10_Re: RCT ?s20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 11 Jan 2000 11:12:04 -0500343_- In addition<br><br>There are differences between TCB and Thread. All protected threads have TCB initialized and attached before thread is created. If THRDMAX - 2 is reached then TCB is destroyed.<br><br>On the other hand, the protected thread does not persist after two purge cycle if no one else was using them while TCB still exists. [...]
11921 54 42_Re: Automatic Increment (+1)On Numeric Key12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 11 Jan 2000 07:58:44 -0800417_us-ascii There is an identity column, but it's not quite finished - almost. For example, If you are running DB2 for OS/390 Version 6, you can look at the cover letter for APAR PQ30652. The APAR is closed, so the description is there.<br><br>Roger<br><br><br><br>Rabindra Senapati <rsenapati@HOTMAIL.COM>@RYCI.COM> on 01/11/2000 04:28:45 AM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM> [...]
11976 73 42_Re: Automatic Increment (+1)On Numeric Key20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 11 Jan 2000 11:22:21 -0500618_- Roger<br><br>Is it on the web ? I searched http://www-4.ibm.com/software/data/db2/os390/v6apar.html couldn't get it. Is IBMLINK only choice ?<br><br>Thanks<br><br>> -----Original Message----- > From: Roger Miller [SMTP:millerrl@US.IBM.COM] > Sent: Tuesday, January 11, 2000 10:59 AM > To: DB2-L@RYCI.COM > Subject: Re: Automatic Increment (+1)On Numeric Key > > There is an identity column, but it's not quite finished - almost. For > example, > If you are running DB2 for OS/390 Version 6, you can look at the > cover letter for APAR PQ30652. The APAR is closed, so the description > is there. > > Roger > > > [...]
12050 21 26_DB2MOVE (DB2 UDB/CS on NT)0_19_Sven.Heidorn@CSN.SE31_Tue, 11 Jan 2000 16:39:42 +0100410_ISO-8859-1 Hi all,<br><br>does anyone know if there is a version of db2move that works against DB2 CS v2.1, and if there is, where I can get it.<br><br>TIA Sven Heidorn .<br><br>===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
12072 53 49_Re: Database Modeling tools - Erwin vs. ER/Studio14_Mullins, Craig21_Craig_Mullins@BMC.COM31_Tue, 11 Jan 2000 10:27:33 -0600673_ISO-8859-1 If you are evaluating data modeling tools for DB2 for UDB, you might want to include the following on your list.<br><br>Silverrun - http://www.silverrun.com System Architect - http://www.popkin.com<br><br>Both indicate DB2 support, but you will have to double-check for DB2 UDB on AIX support.<br><br>I have not used either of these products, nor do I necessarily endorse or recommend them. I am just sending this message for informational purposes in case you had not considered either of these products. Additionally, The Data Administration Newsletter (www.tdan.com) has a vendor and product list that lists several other data modeling tools and vendors [...]
12126 52 33_FW: Load Errors using VARCHAR Col13_Magill, James20_James_Magill@BMC.COM31_Tue, 11 Jan 2000 10:22:03 -0600518_ISO-8859-1 First of all I want to thank Libby for bringing this to our attention. Unload Plus always generates a two byte length code for each varchar/long varchar column that is unloaded. This length code immediately preceeds the varchar data. Unload Plus has a command option, FIXEDVARCHAR YES, which will pad varchar data to the maximum length. However, this is NOT mandatory for a load to work and certainly not recommended if the varchar column is to be a true varchar and not contain the padded characters. [...]
12179 69 45_Re: Disaster Recovery. Any book/article etc ?14_Richard Yevich17_ryevich@YAHOO.COM31_Tue, 11 Jan 2000 08:35:54 -0800606_us-ascii For a solid text book also, on this topic, see Jon Toigo, from Prentice Hall, 2nd edition, "Disaster Recovery Planning" -- but make sure you get the 2nd edition which was just published.<br><br><br><br>--- BOB JEANDRON <BOB.JEANDRON@USDA.GOV> wrote: > Most of our disaster recovery was created from info in the RedBook > - "DB2 > OFFSITE RECOVERY SAMPLE PROCEDURES" GG24-3601-00. This books is > fairly old > and may be out of date/print. > > > > >>> DB2-L@RYCI.COM@inter2 01/11/00 08:45AM >>> > I've been asked, "obtorto collo", to begin to create a first > 'nucleus' of > Disaster Recovery [...]
12249 43 33_Re: Rebind aft ALTER INDEX type 215_Gordon Fishwick39_Gordon.Fishwick@SCOTTISH-SOUTHERN.CO.UK31_Tue, 11 Jan 2000 16:39:31 +0000304_us-ascii John,<br><br>What you may have remembered is that if you convert from a TYPE 2 to TYPE 1 index then you need to REBIND. However, when you convert from TYPE 1 to TYPE 2 you do not have to rebind (there will be RECP status on the index!).<br><br>(I have checked in the DB2 Admin. Guide.....) [...]
12293 24 42_Re: Automatic Increment (+1)On Numeric Key12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 11 Jan 2000 08:40:44 -0800543_us-ascii Start at the DB2 home page. www.ibm.com/software/db2os390<br><br>Click on Support on the left.<br><br>Click on S/390 Tech Support<br><br>Enter the APAR number in the search and click Go.<br><br>Then click on the abstract below: PQ30652: ADD NEW FUNCTION - IDENTITY COLUMNS<br><br>Roger Miller<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
12318 38 33_Re: Rebind aft ALTER INDEX type 215_Gordon Fishwick39_Gordon.Fishwick@SCOTTISH-SOUTHERN.CO.UK31_Tue, 11 Jan 2000 16:45:34 +0000716_us-ascii John,<br><br>Just a quick correction, I checked in the SQL Reference, not the Admin. Guide, as previously stated. I'm sorry, it won't happen again ;-)<br><br>All the best,<br><br>Gordon CD Fishwick DB2 Systems Programmer Scottish and Southern Energy plc<br><br><br><br>********************************************************************** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy plc. It is intended solely for the addressees. Access to this E-Mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken [...]
12357 140 10_Re: RCT ?s0_23_Mike_Levine@TEKHELP.NET31_Tue, 11 Jan 2000 11:52:51 -0500313_us-ascii Hi Venkat,<br><br>I don't believe that you can assign protected threads (THRDS>0) to the POOL. You can specify a value but it is ignored and THRDS becomes 0 (at least that is what OMEGAMON tells me when I have tried to do this in the past). I'm not sure of the reason for this apparent restriction. [...]
12498 20 27_Re: DB2 V6 Join Enhancement11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Tue, 11 Jan 2000 12:02:24 -0500445_ISO-8859-1 Venkat and Michael<br><br>Many thanks for your helpful replies.<br><br>Regards Mike Turner Email: michael_turner@compuserve.com Home Page: http://ourworld.compuserve.com/homepages/michael_turner<br><br>===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
12519 16 36_Re: ASYNCHRONOUS DATA MOVER FACILITY0_31_truman.g.brown@BELLATLANTIC.COM31_Tue, 11 Jan 2000 12:18:24 -0500440_us-ascii This is an MVS panel entry (YES/NO) at the LPAR level. Get your MVS systems programmer involved - I don't recall but I think you'll need an IPL as opposed to a power on reset.<br><br>George<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
12536 84 23_Front-end tools for DB212_Raj, Dominic25_DRaj@FALLSCHURCH.ESYS.COM31_Tue, 11 Jan 2000 12:17:26 -0500409_iso-8859-1 <br><br>We are in the process of evaluating a PC front-end tool to call the stored procedure in DB2 (primarily on Os/390). Right now, it's going to be a 2-tier architecture.<br><br>Any experiences or recommendations in using these tools will be highly appreciated. I'm specifically interested in Visual Basic Vs Power builder. Please let us know if any other front-end tool worth considering. [...]
12621 653 7_Explain23_Trivedi, Kaushal J, BGM17_kjtrivedi@ATT.COM31_Tue, 11 Jan 2000 11:06:53 -0500512_ISO-8859-1 Hi everyone, I have a query and i would like to know if the run time is appropriate , It takes about 4 minutes of cpu time and 10 minutes elapsed time to run. I am attaching a spreadsheet that shows the explain and the Index details ( I have included all the indexes and highlighted the ones used in the Plan). One more question is that I am confused with the QBLOCKNO where it takes the table T05029 as a part of QBLOCKNO = 2 . Can this query be improved or any main points of interest would be [...]
13275 78 21_Re: Space calculation11_sanjay jain25_sanjay_jain@EMAIL.MSN.COM31_Tue, 11 Jan 2000 12:21:51 -0800362_- Bob,<br><br>you should check your PDA setting to run the scan faster.<br><br>-- Check the COMMIT parameter in PARMLIB(PDA). The less frequently you commit, the faster SCAN will run.<br><br>-- Set the ACCESS parameter in user's PDA profile to VSAM.<br><br>-- Is your PTDB database too large ? Do you perform regular maintenance on it to delete old stats ? [...]
13354 14 30_quiesce during online activity13_Karen Daniels21_Karen.Daniels@TRW.COM31_Tue, 11 Jan 2000 09:23:06 -0800381_US-ASCII I would like to perform a quiesce during our cics activity. Is anyone else doing this? How do I obtain the locks to run the quiesce?<br><br>===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
13369 23 47_Preventing user logons during batch job cycles.0_25_George_White@VANGUARD.COM31_Tue, 11 Jan 2000 12:46:43 -0500338_us-ascii What are accepted methods for locking out user logons for an extended period of time?<br><br>Locking the table at the beginning of the program can work, but not if the user is already actively querying the tables to be updated.<br><br>What options does one have?<br><br><br><br>I'd appreciate any help that can be provided. [...]
13393 74 42_Re: Automatic Increment (+1)On Numeric Key17_Rabindra Senapati21_rsenapati@HOTMAIL.COM29_Tue, 11 Jan 2000 09:47:37 PST634_- Thank you. This requirment in on DB2 UDB V6.1 FIXPACK 2 on WINDOWS NT 4.0. Could you please help me to get further details on perticular product?<br><br><br><br>Rabi.<br><br>>From: Roger Miller <millerrl@US.IBM.COM> >Reply-To: DB2 Data Base Discussion List <DB2-L@RYCI.COM> >To: DB2-L@RYCI.COM >Subject: Re: Automatic Increment (+1)On Numeric Key >Date: Tue, 11 Jan 2000 07:58:44 -0800 > >There is an identity column, but it's not quite finished - almost. For >example, >If you are running DB2 for OS/390 Version 6, you can look at the >cover letter for APAR PQ30652. The APAR is closed, so the description >is there. > >Roger [...]
13468 48 34_Re: quiesce during online activity0_19_csutfin@AMSOUTH.COM31_Tue, 11 Jan 2000 11:50:52 -0600326_- Hi Karen,<br><br>Try a 1. -STO database(........) at(commit) to get the locks 2. -Sta database access(ut) 3. run the Quiesce 4. -STA database(..........) access(RW)<br><br>you may get some -904 if any CICS transactions try to run during that time. You could perform this to certain tablespaces if that is all you need. [...]
13517 20 51_Re: Preventing user logons during batch job cycles.12_Chris Miller24_Chris_Miller@PAYLESS.COM31_Tue, 11 Jan 2000 11:56:47 -0600311_us-ascii On UDB for NT/AIX, we do the following: (1) revoke connect from the users (except for a few well behaved, controlled userid used for batch processing) (2) force applications off the database (3) run the batch cycle (using one of the accounts not revoked above) (4) grant connect back to the users [...]
13538 32 34_Re: quiesce during online activity13_Lynne Flatley17_LFlatley@NEFN.COM31_Tue, 11 Jan 2000 12:57:58 -0500438_us-ascii We did this for a few applications at the last place I worked at. You don't want to obtain locks specifically for the quiesce...DB2 takes care of this for you. Execute the quiesce and the log's RBA (LSN if you're data sharing) will be stored in SYSIBM.SYSCOPY for a TORBA recovery (if needed). Ideally, the quiesce will execute in a blink of the eye, unless certain processes are hanging onto locks longer than they should. [...]
13571 27 42_Design req documents for online processing17_Marchese, Frank D18_fdmarchese@ATT.COM31_Tue, 11 Jan 2000 13:01:58 -0500647_iso-8859-1 Hello fellow listees - a request for assistance from your collective genius.... we have several processes which are currently mostly or all batch processed. Many will be moved to do more processing via IMS transactions / DB2 attach (most of this applctn's data is in DB2 not IMS; IMS is almost strictly just an attachment mechanism). The pjt mgrs want to re-orient the design documents to include applicable info that designers must include for online processing functions. Some things that come to mind are: expected online hours of operation, expected transaction volume (peak hours and others), checkpoint/commit frequency - to [...]
13599 78 37_Query performance through DB2 connect26_Gatti, Suresh (Consultant)20_SGatti@ACNIELSEN.COM31_Tue, 11 Jan 2000 12:26:50 -0600586_- <br><br>Hi all,<br><br>I am basically a mainframe DB2 person. I have been asked to look into the SQL queries accessing DB2 on the mainframe (Version 5) from a Sun Solaris system using DB2 connect. The system is still in development(testing) stage. I looked at the queries and tested them on the mainframe. They look fine to me and run OK on the mainframe. But on the other side of the DB2 connect, they experience inconsistent response times, varying from 5 seconds to 15 minutes for the same query at different times. The delay happens especially when the mainframe's CPU usage [...]
13678 45 34_Re: quiesce during online activity17_Marchese, Frank D18_fdmarchese@ATT.COM31_Tue, 11 Jan 2000 13:26:42 -0500655_ISO-8859-1 Lynne - did you use WRITE(YES) or WRITE(NO) ?<br><br>-----Original Message----- From: Lynne Flatley [mailto:LFlatley@NEFN.COM] Sent: Tuesday, January 11, 2000 12:58 PM To: DB2-L@RYCI.COM Subject: Re: quiesce during online activity<br><br><br><br>We did this for a few applications at the last place I worked at. You don't want to obtain locks specifically for the quiesce...DB2 takes care of this for you. Execute the quiesce and the log's RBA (LSN if you're data sharing) will be stored in SYSIBM.SYSCOPY for a TORBA recovery (if needed). Ideally, the quiesce will execute in a blink of the eye, unless certain processes are hanging onto [...]
13724 63 38_Automatic Increment (+1)On Numeric Key12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Tue, 11 Jan 2000 12:36:26 -0600893_us-ascii Hi.<br><br>I do something like this with a "before update" trigger.<br><br>Sg<br><br>---------------------- Forwarded by Steve Grimes/Systems/ais on 01/11/2000 12:34 PM ---------------------------<br><br><br><br>Rabindra Senapati <rsenapati@HOTMAIL.COM> on 01/11/2000 06:28:45 AM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br><br><br><br><br>To: DB2-L@RYCI.COM<br><br>cc: (bcc: Steve Grimes/Systems/ais)<br><br><br><br><br><br>Subject: Automatic Increment (+1)On Numeric Key<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>Hi All,<br><br>I am wondering whether DB2 have the automatic increment feature by (+1) on a numeric key field like ORACLE and SQL Server[example: we mention identity(1,1)on SQL Server in the DDL scripts]. Is there any UDFS or something (which i don't know) to fulfill this or the application program [...]
13788 179 10_Re: RCT ?s20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 11 Jan 2000 13:54:03 -0500583_iso-8859-1 Mike<br><br>Probably you misunderstood me. I never said that POOL can have protected thread, I said POOL can have THRDS>0, this means that when attachment comes up the TCB is initialized. Omegamon might show you THRDS=0 but TCB is out there (as many TCB as THRDS in RCT).<br><br>The point I am trying to emphasis is that TCB and threads are different. TCBs are initialized for THRDS>0 when attachment comes up but thread is created when SQL request come in. The protected thread is purged with two purged cycle, if there is no taker but TCB remains until THRDMAX -2. [...]
13968 191 47_Recovery questions in regard to a RECOVER TORBA0_14_dcreed@CSC.COM31_Tue, 11 Jan 2000 12:57:41 -0600461_us-ascii Recovery questions in regards to a recover to RBA.<br><br>After recently reading the Administration Guide's advice on recovering a tablespace to a particular RBA, I have several questions. I apologise if this is too long for the newsgroup, but I couldn't figure out a way to ask the questions without supplying the documentation involved. My questions revolve around recommendations for "Procedure 2: If You Have Not Established a Quiesce Point". [...]
14160 50 51_Re: Preventing user logons during batch job cycles.14_Philip Gunning26_philip_gunning@HOTMAIL.COM29_Tue, 11 Jan 2000 10:57:38 PST535_- George, We have a VB application that requires users to be locked out when nightly batch starts. What we do is is maintain a system table with a column that indicates whether or not the system is available. At the start of batch, this column is updated to indicate not available, and via batch we knock users off the system and the VP app checks this table at user logon and if the flag is set refuses to let the user logon. After batch is completed, the column is updated and the system goes back to being available. There are [...]
14211 30 20_Indus/Passport & DB218_Whittaker, Stephen26_stephen.whittaker@CPLC.COM31_Tue, 11 Jan 2000 14:10:38 -0500462_iso-8859-1 We are currently running Version 7.1 of Indus/Passport on DB2 V5 for OS/390. Does anyone have any good performance hints for tuning this beast?? Or any type of hints that might help us ole DBA's work with this software?? I understand there's some 'gotchas' with this product and its quite a chore to manage. If anyone is running Passport with DB2 and would like to discuss this, please feel free to contact me off-line of this distribution list. [...]
14242 66 34_Re: quiesce during online activity13_Lynne Flatley17_LFlatley@NEFN.COM31_Tue, 11 Jan 2000 14:13:33 -0500619_us-ascii We always took the default (DB2 Version 4.1) which I believe was WRITE(YES).<br><br>> -----Original Message----- > From: Marchese, Frank D [SMTP:fdmarchese@ATT.COM] > Sent: Tuesday, January 11, 2000 1:27 PM > To: DB2-L@RYCI.COM > Subject: Re: quiesce during online activity > > Lynne - did you use WRITE(YES) or WRITE(NO) ? > > -----Original Message----- > From: Lynne Flatley [mailto:LFlatley@NEFN.COM] > Sent: Tuesday, January 11, 2000 12:58 PM > To: DB2-L@RYCI.COM > Subject: Re: quiesce during online activity > > > We did this for a few applications at the last place I worked at. You > don't > want [...]
14309 25 47_Welcome Lynne Flatley, new Associate List Owner13_Morrill, John12_JohnM@VP.NET31_Tue, 11 Jan 2000 12:14:30 -0700347_iso-8859-1 Greetings!<br><br>I am pleased to announce that Lynne Flatley has joined the DB2-L administration team as an Associate List Owner. Lynne will be primary responsible for the administration of DB2-L-Documents, a new mail list that will allow DB2-L subscribers to post attachments. We will be talking about that new list later today. [...]
14335 29 15_3390 conversion50_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM31_Tue, 11 Jan 2000 14:16:24 -0500378_- I am moving all DB2 data from 3380 to 3390.<br><br>Question: Moving BSDS ::<br><br>Anybody have problems with the 3380 10 recs/track 3390 12 recs/track<br><br><br><br>with the archlog tapes:: any change in the block counts ?<br><br>I try to put the max amount of data on the archlog tape. To put both A and B files on 1 tape. The B file uses 14 blocks. Does this change? [...]
14365 49 27_Re: Front-end tools for DB214_Philip Gunning26_philip_gunning@HOTMAIL.COM29_Tue, 11 Jan 2000 11:16:41 PST292_- Dominic, There are some white papers on the DB2 web site and I would suggest you get the redbook, "Stored Procdures, Give them a call through the Network". It is an excellent source and has VB and Powerbuilder examples. Also, Don Chamberlains book is pretty good for UDB SPs. HTH Phil [...]
14415 39 51_Re: Welcome Lynne Flatley, new Associate List Owner8_Long, Ed15_Ed.Long@FMR.COM31_Tue, 11 Jan 2000 14:17:16 -0500606_- Hooray and thanks Lynne for helping out.<br><br>> -----Original Message----- > From: Morrill, John [SMTP:JohnM@VP.NET] > Sent: Tuesday, January 11, 2000 2:15 PM > To: DB2-L@RYCI.COM > Subject: Welcome Lynne Flatley, new Associate List Owner > > Greetings! > > I am pleased to announce that Lynne Flatley has joined the DB2-L > administration team as an Associate List Owner. > Lynne will be primary responsible for the administration of > DB2-L-Documents, > a new mail list that will allow DB2-L subscribers to post attachments. We > will be talking about that new list later today. > > Please join [...]
14455 44 41_Re: Query performance through DB2 connect13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Tue, 11 Jan 2000 13:48:22 -0600615_US-ASCII If your running WLM in goal mode make sure the DIST address space is defined to a WLM service class. I believe if you do not assign a service class you fall into "sysother" very low priority service class. HTH Kurt<br><br><br><br>>>> "Gatti, Suresh (Consultant)" <SGatti@ACNIELSEN.COM> 01/11/00 12:26PM >>><br><br>Hi all,<br><br>I am basically a mainframe DB2 person. I have been asked to look into the SQL queries accessing DB2 on the mainframe (Version 5) from a Sun Solaris system using DB2 connect. The system is still in development(testing) stage. I looked at the queries and tested them on the [...]
14500 74 41_Re: Query performance through DB2 connect23_Chenniappan Solaiyappan18_fdwh2000@YAHOO.COM31_Tue, 11 Jan 2000 12:08:46 -0800390_us-ascii Suresh,<br><br>join the club.<br><br>we are facing the same problem in our datamart application(still at pilot level).<br><br>we tried the following few things: 1. find out the actual transmission rate from Mainframe to your server (we are using Visual Ace).<br><br>2. issue TRACERTE <ip address> command from maiframe, to findout how many hops it takes to reach your server. [...]
14575 61 34_Re: quiesce during online activity13_Karen Daniels21_Karen.Daniels@TRW.COM31_Tue, 11 Jan 2000 12:11:32 -0800404_US-ASCII thanks for your help.<br><br><<< <csutfin@AMSOUTH.COM> 1/11 12:53p >>> Hi Karen,<br><br>Try a 1. -STO database(........) at(commit) to get the locks 2. -Sta database access(ut) 3. run the Quiesce 4. -STA database(..........) access(RW)<br><br>you may get some -904 if any CICS transactions try to run during that time. You could perform this to certain tablespaces if that is all you need. [...]
14637 91 41_Re: Query performance through DB2 connect10_Park, Stan17_SPark@STATE.NM.US31_Tue, 11 Jan 2000 13:17:37 -0700599_windows-1252 See IBM's performance (with connect) articles<br><br>http://www-4.ibm.com/software/data/db2/performance/<br><br>-----Original Message----- From: Chenniappan Solaiyappan [mailto:fdwh2000@YAHOO.COM] Sent: Tuesday, January 11, 2000 1:09 PM To: DB2-L@RYCI.COM Subject: Re: Query performance through DB2 connect<br><br><br><br>Suresh,<br><br>join the club.<br><br>we are facing the same problem in our datamart application(still at pilot level).<br><br>we tried the following few things: 1. find out the actual transmission rate from Mainframe to your server (we are using Visual Ace). [...]
14729 27 24_DB2PM Documentation help13_John Arbogast16_jfarbo@YAHOO.COM31_Tue, 11 Jan 2000 12:23:18 -0800321_us-ascii Greetings All!<br><br>Does anyone know of a source for DB2PM documentation? Other than the PM manuals themselves. We are trying to use PM to read some raw SMF data and the PM manuals are poor at best. Specifically, how to customize the batch reports and exclude some of the fields we are not interested in. [...]
14757 38 47_Welcome Lynne Flatley, new Associate List Owner17_Gerald Bustamente20_ggbusta@LANDSEND.COM31_Tue, 11 Jan 2000 14:30:37 -0600627_koi8-r Welcome Lynne!<br><br>:-)<br><br>Jerry Bustamente Lands' End<br><br>Morrill, John wrote:<br><br>> Greetings! > > I am pleased to announce that Lynne Flatley has joined the DB2-L > administration team as an Associate List Owner. > Lynne will be primary responsible for the administration of DB2-L-Documents, > a new mail list that will allow DB2-L subscribers to post attachments. We > will be talking about that new list later today. > > Please join me in welcoming Lynne to the team. > > Cheers! > > J. Michael Morrill > DB2-L Chief List Owner > > ================================================ > To change your [...]
14796 119 41_Re: Query performance through DB2 connect14_Philip Gunning26_philip_gunning@HOTMAIL.COM29_Tue, 11 Jan 2000 12:32:19 PST595_- Suresh, There are many places that could be causing poor response. You indicate that the queries run fine on the host. The problem could be in one or more of the following areas:<br><br>TCPIP stack on host DIST address space priority SNA or TCPIP problems, not sure what you are using VTAM definition problems not enough sessions NIC card buffers TCPIP stack on gateway or client. Pacing and ru size. bind options used on the DB2 Connect package network packet size, 1500 for ethernet or 40000 for token ring, some sna products default to 265 bytes! Undersized clients Network congestion [...]
14916 45 34_DB2 Connect General Query Problems14_Philip Gunning26_philip_gunning@HOTMAIL.COM29_Tue, 11 Jan 2000 12:40:15 PST595_- Suresh, There are many places that could be causing poor response. You indicate that the queries run fine on the host. The problem could be in one or more of the following areas:<br><br>TCPIP stack on host DIST address space priority SNA or TCPIP problems, not sure what you are using VTAM definition problems not enough sessions NIC card buffers TCPIP stack on gateway or client. Pacing and ru size. bind options used on the DB2 Connect package network packet size, 1500 for ethernet or 40000 for token ring, some sna products default to 265 bytes! Undersized clients Network congestion [...]
14962 281 51_Re: Recovery questions in regard to a RECOVER TORBA11_Ball, Linda18_Linda_Ball@BMC.COM31_Tue, 11 Jan 2000 15:04:04 -0600568_ISO-8859-1 Danny, As it happens I just read the same section of the manual. I happen to work for BMC and we have products which make this process much simpler. But I am giving a talk at IDUG which touches on this issue and thought I'd review the IBM procedure. I basically gave up trying to understand this documentation. If you have only one table space involved, I'd suggest a different procedure. First, do as you suggest: look at DSNJU004 (Print Log Map) output to associate the interesting log with a date and time. (Remember the warning at the beginning of [...]
15244 18 25_IBM DB2 "Tech Conference"13_Lockwood Lyon23_Lockwood_Lyon@AMWAY.COM31_Tue, 11 Jan 2000 16:03:19 -0500299_us-ascii I think last year's IBM DB2 Tech Conference was sort of titled "DB2 and Data Warehousing". Anyone know which one it is this year? I'd guess it's the DB2 and Business Intelligence Tech Conference on Oct 16-20, in Las Vegas, but I can't tell from the IBM web page. Anyone know for sure? [...]
15263 35 29_Re: IBM DB2 "Tech Conference"14_Philip Gunning26_philip_gunning@HOTMAIL.COM29_Tue, 11 Jan 2000 13:21:15 PST676_- Thats it!<br><br><br><br>>From: Lockwood Lyon <Lockwood_Lyon@AMWAY.COM> >Reply-To: DB2 Data Base Discussion List <DB2-L@RYCI.COM> >To: DB2-L@RYCI.COM >Subject: IBM DB2 "Tech Conference" >Date: Tue, 11 Jan 2000 16:03:19 -0500 > >I think last year's IBM DB2 Tech Conference was sort of titled "DB2 and >Data Warehousing". Anyone know which one it is this year? I'd guess it's >the DB2 and Business Intelligence Tech Conference on Oct 16-20, in Las >Vegas, but I can't tell from the IBM web page. Anyone know for sure? > >-- Lockwood Lyon > Amway Corp > >================================================ >To change your subscription options or to cancel your subscription [...]
15299 23 29_Re: IBM DB2 "Tech Conference"13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Tue, 11 Jan 2000 16:26:40 -0500375_iso-8859-1 Hi Lockwood, The title last year was DB2 and Data Warehouse Technical Conference. See http://www-3.ibm.com/services/learning/conf/index.html<br><br>It looks to me like the name you have is the new name for it. Last September in New Orleans, it was announced that the DB2 Tech conference 2000 will be in Las Vegas. So I think you have the right name and date. [...]
15323 138 38_Re: Data sharing required at D/R site?11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Tue, 11 Jan 2000 16:25:32 -0500360_ISO-8859-1 Just a few minor points to add to Linda's posting:<br><br>1. If the backup site consists of a single CPC, then the Sysplex Timer is not required. At least one CF is always required.<br><br>2. One LPAR can be configured as a CF instead of having a separate CF. I suggest you only use this option for a single CPC, single DB2 member backup site. [...]
15462 16 45_How do you load literals with the IBM utility10_Rich Brown21_Rich.Brown@ALLTEL.COM31_Tue, 11 Jan 2000 16:37:00 -0600352_us-ascii We are trying to set up a database partitioned by company. Currently the company is not a field on the load file and we do not want to make the programmers change the program. I have read the IBM load utility manual and cannot see how I can load a literal to this field. We know what the company is by the input dataset name to the load. [...]
15479 30 18_Rollback Required?12_Jason Hughes20_Jason.Hughes@TRW.COM31_Tue, 11 Jan 2000 14:08:29 -0800417_US-ASCII The setup: We are using Access 97 thru DB2 Connect 5.2 to access DB2 ver 5.1 on an OS/390 machine. We use stored procedures (written in COBOL) to generate several reports. If there is an error in the stored procedure, it issues a ROLLBACK (no inserts/updates are ever done) which generates a trappable ODBC Call Failed error message in Access. User sees pretty message telling them to call for support. [...]
15510 36 43_reorg unload external - a single partition?14_Jessen Michael29_JessenMichel@JDCORP.DEERE.COM31_Tue, 11 Jan 2000 16:10:12 -0600329_- Is it possible to use reorg unload external to unload a single partition without specifying the partitioning index using the WHEN condition. I'm trying to unload 1 partition and only the partition I specify is put into a UTRO status, but when I display claimers, all partitions show and the entire tablespace is unloaded. [...]
15547 89 18_Re: Sort pool size22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Tue, 11 Jan 2000 17:32:16 -0500599_- I understand the basics of bufferpool tuning but I am having a little trouble understanding the SORT/MERGE performance statistics used to tune the DSNDB07 bufferpool and I hope someone can help me understand. Our DSNDB07 has a dedicated 4K page size bufferpool. No Hiperpool is defined.<br><br>Please tell me if I'm on the correct path... From your comments, "In a DB2 PM Statistics report, check the "workfile pages not written" value > against the "workfile pages to destruct" to see how much sorting is > staying in > storage.", > is it true that "workfile pages not written" <= "workfile [...]
15637 81 29_Multiple Counts & Outer Joins12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Tue, 11 Jan 2000 17:05:00 -0600444_us-ascii Hello.<br><br>I'm on DB2 UDB V6 OS/390<br><br>What follows is a loooong SQL Select statement. I'm not SQL proficient, and our programmer, (who says this worked under MS SQL Server 7.0) is suggesting two things:<br><br>1. DB2 can't handle multiple Count statements. 2. DB2 can't handle multiple Left outer join statements.<br><br>Here's his PowerBuilder generated SQL which bombs with a "syntax error" when he tries to execute it. [...]
15719 18 27_Changing to CURRENTDATA(NO)0_22_kmulcahy@CHECKFREE.COM31_Tue, 11 Jan 2000 18:14:43 -0500543_us-ascii We have an application that allowed bind package to default to CURRENTDATA(YES). We want to change it to CURRENTDATA(NO). We also want to insure there are no surprises created by this change. How can we insure a quality migration to CURRENTDATA(NO)?<br><br>Kevin Mulcahy CheckFree Corporation<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
15738 30 10_Re: RCT ?s15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Tue, 11 Jan 2000 10:00:17 -0600604_us-ascii Do most of you have THRDMAX >= all your THRDS? Does anyone have any specific benchmarks showing what CPU impact unnecessarily high THRDMAX has on the suspend/resume processing between the CICS main TCB and the thread TCBs?<br><br>Jim Lewandowski<br><br><br><br>> The point I am trying to emphasis is that TCB and threads are different. > TCBs are initialized for THRDS>0 when attachment comes up but thread is > created when SQL request come in. The protected thread is purged with two > purged cycle, if there is no taker but TCB remains until THRDMAX -2. If > THRDM=5,THRDA=3 and THRDS=2 [...]
15769 34 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Tue, 11 Jan 2000 10:09:00 -0600629_us-ascii I had sent out many copies of an SMF 42 subtype 6 REXX that provided a detail and summary of I/O response times (and their components) for each table/indexspace for a DB2 DBM1 subsystem. Anyone else interested in this?<br><br>Jim Lewandowski<br><br><br><br><br><br>Galambos, Robert wrote: > > Chuck Hoover, from Compuware, has an excellent presentation > concerning this subject. In his presentation, using information from the > Buffer Pool Tool software, among others, he shows how to take the > information retrieved, and digest it to formulate the right mix for your > environment. > > If you are interested in [...]
15804 37 34_Posting Code and other attachments13_Morrill, John12_JohnM@VP.NET31_Tue, 11 Jan 2000 17:09:19 -0700640_iso-8859-1 Greetings!<br><br>There is a new service available to DB2-L subscribers. You will now be able to share documents with other subscribers.<br><br>We have created a new mailing list call DB2-L-Documents. This list is for attachments and other large documents. However, when you post to this list, the message is not sent to the +2500 subscribers. Instead, the message with the attached document is stored in the DB2-L-Documents archives. You can then post a message to DB2-L that announces the document is available on the DB2-L-Documents achieves. Whoever is interested in the document can down load it from the archives, via [...]
15842 116 33_Re: Multiple Counts & Outer Joins14_Purcell, Terry37_Terry.Purcell@CORPMAIL.TELSTRA.COM.AU31_Wed, 12 Jan 2000 11:18:58 +1100397_iso-8859-1 Steve,<br><br>You can have multiple outer joins and multiple counts, but the COUNT syntax below is incorrect for DB2. Only COUNT(*) or COUNT(DISTINCT expression) are allowed. In this case you require COUNT(DISTINCT column-name) for each of the four ACCT_ID's, but unfortunately DB2 only allows DISTINCT to be used once in a SELECT (so multiple uses of count are limited with DB2). [...]
15959 58 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.11_Roland Chua32_rolandchua@SINGAPOREEXCHANGE.COM31_Wed, 12 Jan 2000 09:02:10 +0800664_us-ascii Hi Jim,<br><br>I am interested, will you send me a copy too. Thanks<br><br><br><br><br><br><br><br><br><br>Jim Lewandowski <jlewand@STARNETINC.COM> on 12/01/2000 12:09:00 AM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br>To: DB2-L@RYCI.COM cc: (bcc: ROLAND CHUA CHONG KEE/DATACEN/IT/SGX) Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.<br><br><br><br><br><br><br><br>I had sent out many copies of an SMF 42 subtype 6 REXX that provided a detail and summary of I/O response times (and their components) for each table/indexspace for a DB2 DBM1 subsystem. Anyone else interested in this? [...]
16018 48 22_Re: Rollback Required?13_Lynne Flatley17_LFlatley@NEFN.COM31_Tue, 11 Jan 2000 20:56:08 -0500453_us-ascii While it's a great technique to issue the ROLLBACK in the stored procedure (we're going to use it here to ensure that apps aren't allowed to continue if the stored procedure has a severe error which must be handled by the app), the app must then issue a ROLLBACK before they can continue. Place a SQL statement in the Access front-end to issue a ROLLBACK. I don't know if Access can do ROLLBACKs, it might need to be a pass-thru query(?). [...]
16067 64 22_Re: Rollback Required?13_Chie, Jim (C)17_chiej@CONNEXT.COM31_Tue, 11 Jan 2000 18:06:24 -0800284_iso-8859-1 if you are going to do a Rollback in the stored procedure, you need to use the Rollback method in Access. And if you use the Rollback method you must have previously used BeginTrans, and if it is successful you should also use CommitTrans. its all in the online help. [...]
16132 21 15_DB2 Connect 5.29_SrinivasG17_SRINIVASG@INF.COM31_Wed, 12 Jan 2000 07:54:36 +0530526_iso-8859-1 Hi,<br><br>Will DB2 Connect 5.2 work with OS/390 V1.3 ? I am trying to connect from DB2 Connect 5.2 to a server where OS/390 V1.3 exists db2 V5.1. But I get an Invalid Password error on the server Log. The same Password works with TSO.<br><br>Please help.<br><br>Srinivas G<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
16154 22 22_Re: Rollback Required?13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM31_Wed, 12 Jan 2000 09:35:08 +0530443_us-ascii hi !!!!<br><br>Have a look at the system log. The error and the return code will be shown there .. Also see the SSNNSPAS address space sysout . There you will get the CEEDUMP. which will tell you the error for the failure of stored procedure. If you are not able to find the error then you will have to debug the Stored procedure. Actually some error condition is not being handled in the stored procedure. that s why it aborts. [...]
16177 17 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM31_Wed, 12 Jan 2000 09:39:21 +0530305_us-ascii hi Jim<br><br>I am really interested . !!<br><br>Vishy<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
16195 26 22_DDL Generation Utility13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM31_Wed, 12 Jan 2000 09:47:03 +0530471_us-ascii Hi !!<br><br>Instead of using the query and Icetool combination , I have written a single program which will intelligenty scan the catalogue and generate the DDL's for a full application . You just have to give the HLQ of the system as input<br><br>It has the following features<br><br>1. It will take care of referential integrity and generate in the sequence for parent and child. 2. It will generate the tablespace the table and the indexes in sequence. [...]
16222 18 24_Is this list still alive13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Tue, 11 Jan 2000 22:28:14 -060097_us-ascii Hi,<br><br>The last note I received was 12/29/99.... Is this list still kicking?<br><br>
16241 141 33_Re: Multiple Counts & Outer Joins14_Linda Claussen18_lindafc@NETINS.NET31_Tue, 11 Jan 2000 22:25:04 -06001079_ISO-8859-1 Steve,<br><br>What are you trying to count? The format of the count for DB2 OS/390 is: either COUNT(*) to count the number of rows or COUNT (DISTINCT column-name) to count the number of distinct values in a column.<br><br>Try this in SPUFI or QMF and see if it's what he wants:<br><br>SELECT DBATEST.FIT_ALL_ACCT_BY_FY.FISCAL_YEAR, DBATEST.FIT_ALL_ACCT_BY_FY.ACCT_DEPT, DBATEST.FIT_ALL_ACCT_BY_FY.ACCT_FUND, DBATEST.FIT_ALL_ACCT_BY_FY.ACCT_LEDGER, DBATEST.FIT_ALL_ACCT_BY_FY.ACCT_CLASS, DBATEST.FIT_ALL_ACCT_BY_FY.LONG_TITLE, COUNT ( DISTINCT DBATEST.FIT_AWARD_BY_FY.ACCT_ID ), COUNT ( DISTINCT DBATEST.FIT_UNIT_BY_FY.ACCT_ID ), COUNT ( DISTINCT DBATEST.FIT_BUDG_BY_FY.ACCT_ID ), COUNT ( DISTINCT DBATEST.FIT_GL_BY_FY.ACCT_ID ) FROM DBATEST.FIT_ALL_ACCT_BY_FY LEFT OUTER JOIN DBATEST.FIT_AWARD_BY_FY ON DBATEST.FIT_ALL_ACCT_BY_FY.ACCT_ID = DBATEST.FIT_AWARD_BY_FY.ACCT_ID AND DBATEST.FIT_ALL_ACCT_BY_FY.FISCAL_YEAR = DBATEST.FIT_AWARD_BY_FY.FISCAL_YEAR LEFT OUTER JOIN DBATEST.FIT_UNIT_BY_FY ON DBATEST.FIT_ALL_ACCT_BY_FY.ACCT_ID = DBATEST.FIT_UNIT_BY_FY.ACCT_ID [...]
16383 48 30_Re: DB2MOVE (DB2 UDB/CS on NT)13_Umair Hussain25_umair_hussain@HOTMAIL.COM29_Wed, 12 Jan 2000 00:10:26 CST741_- There are different versions and platform of db2move in this directory.<br><br>ftp://ftp.software.ibm.com/ps/products/db2/tools/<br><br><br><br>Umair Hussain******************************** DBA Consultant * DB2 UDB, Oracle, Sybase, DataJoiner * IBM Certified Solution Expert - DB2 UDB DBA * IBM Certified AIX System Administrator * ********|All Disclaimers Apply|**************<br><br><br><br>>From: Sven.Heidorn@CSN.SE >Reply-To: DB2 Data Base Discussion List <DB2-L@RYCI.COM> >To: DB2-L@RYCI.COM >Subject: DB2MOVE (DB2 UDB/CS on NT) >Date: Tue, 11 Jan 2000 16:39:42 +0100 > >Hi all, > >does anyone know if there is a version of db2move that works against DB2 CS >v2.1, >and if there is, where I can get it. > >TIA >Sven Heidorn . > [...]
16432 42 28_Re: Is this list still alive19_Michael Piontkowski34_michael_piontkowski@COMPUSERVE.COM31_Wed, 12 Jan 2000 01:14:41 -0500444_iso-8859-1 Yes, its alive.<br><br><br><br><br><br>Mike Piontkowski mailto:michael_piontkowski@compuserve.com<br><br><br><br>-----Original Message----- From: owner-db2-l@RYCI.COM [mailto:owner-db2-l@RYCI.COM]On Behalf Of Willie Favero Sent: Tuesday, January 11, 2000 23:28 To: DB2-L@RYCI.COM Subject: [DB2-L] Is this list still alive<br><br><br><br><br><br>Hi,<br><br>The last note I received was 12/29/99.... Is this list still kicking?<br><br>
16475 82 69_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spaces.11_CIRSE / STE28_cirse.ste@CREDIT-AGRICOLE.FR31_Wed, 12 Jan 2000 07:21:14 +0100742_iso-8859-1 hello,<br><br>I am interested, will you send me a copy too. Thanks cirse.ste@credit-agricole.fr<br><br><br><br><br><br>----- Original Message ----- From: Roland Chua <rolandchua@SINGAPOREEXCHANGE.COM> Newsgroups: bit.listserv.db2-l To: <DB2-L@RYCI.COM> Sent: Wednesday, January 12, 2000 2:02 AM Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.<br><br><br><br>> Hi Jim, > > I am interested, will you send me a copy too. Thanks > > > > > > Jim Lewandowski <jlewand@STARNETINC.COM> on 12/01/2000 12:09:00 AM > > Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM> > > To: DB2-L@RYCI.COM > cc: (bcc: ROLAND CHUA CHONG KEE/DATACEN/IT/SGX) > Subject: Re: DB2-OS/390- Statistical Analysis [...]
16558 61 69_R: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.17_Bartolucci Silvia25_S.Bartolucci@FONDIARIA.IT31_Wed, 12 Jan 2000 08:16:57 +0100610_iso-8859-1 Hi, i'm very interested, please send a copy to me. Thanks Silvia<br><br><br><br>> -----Messaggio originale----- > Da: Jim Lewandowski [SMTP:jlewand@STARNETINC.COM] > Inviato: martedě 11 gennaio 2000 17.09 > A: DB2-L@RYCI.COM > Oggetto: Re: DB2-OS/390- Statistical Analysis of Tablespaces and > Index spa ces. > > I had sent out many copies of an SMF 42 subtype 6 REXX that provided a > detail and summary of I/O response times (and their components) for > each table/indexspace for a DB2 DBM1 subsystem. Anyone else interested > in this? > > Jim Lewandowski > > > > Galambos, Robert wrote: > > [...]
16620 25 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.14_Massimo Scarpa16_mscarpa@CESVE.IT31_Wed, 12 Jan 2000 08:43:06 +0100543_us-ascii I know Chuck Hoover's article but I never try to use SMF 42 to check I/O (my bosses think<br><br>this type of tuning this a game...) so I'm VERRRRY interested. Send me a copy too if you like at:<br><br>mscarpa@cesve.it<br><br>Thanks and Regards<br><br>Max Scarpa Data & System Admin Cesve Spa<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
16646 120 99_Posts to DB2-L-DOCUMENTS: was (R: DB2-OS/390- Statistical Analysis of Tablespaces and Index spaces.14_Paul A Redhead35_Paul.A.Redhead@TRANSPORT.QLD.GOV.AU31_Wed, 12 Jan 2000 17:40:14 +1000314_us-ascii <br><br><br><br>So now that we all know about the new central document place for DB2-L, namely DB2-L-DOCUMENTS, what are the procedures for placing something there ? After x (where x is a large number) of people have made a request for something does one of the list owners intervene ? Just curious. [...]
16767 72 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.12_Kim, Gye-Woo19_GYE-WOO.KIM@CAI.COM31_Wed, 12 Jan 2000 18:35:44 +1100646_euc-kr Hi.<br><br>I want to receive a copy. Please send to me.<br><br>Thanks.<br><br>> -----Original Message----- > From: Bartolucci Silvia [SMTP:S.Bartolucci@FONDIARIA.IT] > Sent: Wednesday, January 12, 2000 4:17 PM > To: DB2-L@RYCI.COM > Subject: R: DB2-OS/390- Statistical Analysis of Tablespaces and > Index spa ces. > > Hi, i'm very interested, please send a copy to me. > Thanks > Silvia > > > > -----Messaggio originale----- > > Da: Jim Lewandowski [SMTP:jlewand@STARNETINC.COM] > > Inviato: martedi 11 gennaio 2000 17.09 > > A: DB2-L@RYCI.COM > > Oggetto: Re: DB2-OS/390- Statistical Analysis of Tablespaces and > > Index spa ces. > [...]
16840 18 28_Re: DB2PM Documentation help14_Massimo Scarpa16_mscarpa@CESVE.IT31_Wed, 12 Jan 2000 09:03:23 +0100405_us-ascii There's a red book dealing with DB2PM. The title is<br><br>"DB2 PM USAGE GUIDE UPDATE" - sg24-2584-00 (it's a little old....)<br><br>HTH<br><br>Max Scarpa<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
16859 47 28_Re: DB2PM Documentation help22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Wed, 12 Jan 2000 08:59:25 +0000654_ISO-8859-1 John there are several books/papers on this .. will dig them out and send details to the list and you. Leslie<br><br><br><br>______________________________ Reply Separator _________________________________ Subject: DB2PM Documentation help Author: John Arbogast <jfarbo@YAHOO.COM> at Internet Date: 1/11/00 12:23 PM<br><br><br><br>Greetings All!<br><br>Does anyone know of a source for DB2PM documentation? Other than the PM manuals themselves. We are trying to use PM to read some raw SMF data and the PM manuals are poor at best. Specifically, how to customize the batch reports and exclude some of the fields we are not interested in. [...]
16907 43 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.11_PILI PASCAL18_pascal.pili@CDN.FR31_Wed, 12 Jan 2000 09:58:24 +0100549_- > Hi, > > I am interested, will you send me a copy too. Thanks > Pascal PILI.<br><br><br><br>> Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM> > > > > Galambos, Robert wrote: > > > > Chuck Hoover, from Compuware, has an excellent presentation > > concerning this subject. In his presentation, using information from the > > Buffer Pool Tool software, among others, he shows how to take the > > information retrieved, and digest it to formulate the right mix for your > > environment. > > > > If you are interested in getting [...]
16951 46 49_Re: How do you load literals with the IBM utility13_Marcus Davage29_Marcus.Davage@LLOYDSTSB.CO.UK31_Wed, 12 Jan 2000 09:06:52 -0000623_iso-8859-1 I've done something like this before. I SYNCSORTed the column onto the load file, and loaded from that.<br><br><br><br>-----Original Message----- From: Rich Brown [mailto:Rich.Brown@ALLTEL.COM] Sent: 11 January 2000 22:37 To: DB2-L@RYCI.COM Subject: How do you load literals with the IBM utility<br><br><br><br>We are trying to set up a database partitioned by company. Currently the company is not a field on the load file and we do not want to make the programmers change the program. I have read the IBM load utility manual and cannot see how I can load a literal to this field. We know what the company [...]
16998 57 34_Re: quiesce during online activity14_Jackie Gribbon23_jgribbon@GSSEC.BT.CO.UK31_Wed, 12 Jan 2000 09:23:12 +0000506_iso-8859-1 "Ideally" worries me. A "realistically" would give me more confidence!<br><br>I've also looked at this recently. We have an application which currently performs a quiesce outside the CICS on-line day and at a time when batch processing is also minimal. For greater flexibility we would like to have the option of performing it at any time, but our DBAs have advised against it due to potential conflicts with CICS transactions. Are they being over cautious, or is this a realistic concern? [...]
17056 82 34_Re: quiesce during online activity13_Adrian Savory24_adrian.savory@ZURICH.COM31_Wed, 12 Jan 2000 09:29:29 +0000452_us-ascii It depends on your application - certain applications I know you don't stand a cat in hell's chance of getting an application quiesce point any time day or night.<br><br>Adrian Savory ACSIS Ltd<br><br><br><br><br><br><br><br><br><br>Jackie Gribbon <jgribbon@GSSEC.BT.CO.UK> on 12/01/2000 09:23:12<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br>To: DB2-L@RYCI.COM cc: (bcc: Adrian Savory/ZI/England/Zurich) [...]
17139 55 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.10_Robert Ord21_robertord@HOTMAIL.COM29_Wed, 12 Jan 2000 09:33:20 GMT656_- I am interested, please can you send me a copy to robertord@hotmail.com<br><br>Thanks<br><br>Rob<br><br><br><br>>From: Jim Lewandowski <jlewand@STARNETINC.COM> >Reply-To: DB2 Data Base Discussion List <DB2-L@RYCI.COM> >To: DB2-L@RYCI.COM >Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa > ces. >Date: Tue, 11 Jan 2000 10:09:00 -0600 > >I had sent out many copies of an SMF 42 subtype 6 REXX that provided a >detail and summary of I/O response times (and their components) for >each table/indexspace for a DB2 DBM1 subsystem. Anyone else interested >in this? > >Jim Lewandowski > > > >Galambos, Robert wrote: > > > > Chuck [...]
17195 70 58_Re: DB2-OS/390- Statistical Analysis of Tablespaces and In10_Alan Kirby18_Alan.Kirby@WDR.COM31_Wed, 12 Jan 2000 10:12:52 +0000555_us-ascii Jim, Could you please send me a copy...<br><br>Thanks, Alan<br><br><br><br><br><br>______________________________ Reply Separator _________________________________ Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and In Author: jlewand (jlewand@STARNETINC.COM) at unix,mime Date: 11/01/00 16:09<br><br><br><br>I had sent out many copies of an SMF 42 subtype 6 REXX that provided a detail and summary of I/O response times (and their components) for each table/indexspace for a DB2 DBM1 subsystem. Anyone else interested in this? [...]
17266 94 58_Re: DB2-OS/390- Statistical Analysis of Tablespaces and In0_21_m.rowinski@PL.IBM.COM31_Wed, 12 Jan 2000 11:35:12 +0100514_us-ascii Jim, I am very interested, so could You please send me copy,<br><br>Pozdrawiam/Best Regards Maciej Rowinski<br><br><br><br>---------------------- Forwarded by Maciej Rowinski/Poland/IBM on 2000.01.12 11:33 ---------------------------<br><br>Alan Kirby <Alan.Kirby@WDR.COM> on 2000.01.12 11:12:52<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br>To: DB2-L@RYCI.COM cc: (bcc: Maciej Rowinski/Poland/IBM) Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and In [...]
17361 40 51_Re: Welcome Lynne Flatley, new Associate List Owner15_Gordon Fishwick39_Gordon.Fishwick@SCOTTISH-SOUTHERN.CO.UK31_Wed, 12 Jan 2000 11:38:09 +0000342_us-ascii Lynne,<br><br>May I be one of the, undoubtedly many, voices to say 'Thank You' for offering to help. This list really is an asset to us all and a credit to those involved in it's administration. (Wipes a tear, etc...... ;-))<br><br>All the best,<br><br>Gordon CD Fishwick DB2 Systems Programmer Scottish and Southern Energy plc [...]
17402 86 42_Re: Automatic Increment (+1)On Numeric Key17_Rabindra Senapati21_rsenapati@HOTMAIL.COM29_Wed, 12 Jan 2000 04:04:38 PST751_- Hi sg,<br><br>Could you please attach the trigger defination for reference?<br><br>Thank You Rabi.<br><br><br><br><br><br>>From: Steve Grimes <Steve_Grimes@AISMAIL.WUSTL.EDU> >Reply-To: DB2 Data Base Discussion List <DB2-L@RYCI.COM> >To: DB2-L@RYCI.COM >Subject: Automatic Increment (+1)On Numeric Key >Date: Tue, 11 Jan 2000 12:36:26 -0600 > >Hi. > >I do something like this with a "before update" trigger. > >Sg > >---------------------- Forwarded by Steve Grimes/Systems/ais on 01/11/2000 >12:34 PM --------------------------- > > >Rabindra Senapati <rsenapati@HOTMAIL.COM> on 01/11/2000 06:28:45 AM > >Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM> > > > > To: DB2-L@RYCI.COM > > cc: (bcc: Steve Grimes/Systems/ais) > > > [...]
17489 21 58_Re: DB2-OS/390- Statistical Analysis of Tablespaces and In16_Daniel Boulanger19_dboulang@CA.IBM.COM31_Wed, 12 Jan 2000 06:37:05 -0500628_us-ascii Jim, it sounds great. Would you be kind enough to provide me with a copy as well ?<br><br>Regards, ----------------------------------------------------------------------------------<br><br>Daniel Boulanger, Associate Analyst, Database Control Dorval, Quebec, Canada E-Mail: dboulang@ca.ibm.com -----------------------------------------------------------------------------------<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
17511 79 34_Re: quiesce during online activity13_Lynne Flatley17_LFlatley@NEFN.COM31_Wed, 12 Jan 2000 07:14:42 -0500652_us-ascii If an application's processes are designed well and commit updates in a timely fashion, there shouldn't be a problem. Also, this is assuming that the number of objects being quiesced is reasonable, 10 or 20 tablespaces, not 100 or 1,000.<br><br>> -----Original Message----- > From: Jackie Gribbon [SMTP:jgribbon@GSSEC.BT.CO.UK] > Sent: Wednesday, January 12, 2000 4:23 AM > To: DB2-L@RYCI.COM > Subject: Re: quiesce during online activity > > "Ideally" worries me. A "realistically" would give me more confidence! > > I've also looked at this recently. We have an application which currently > performs a quiesce outside the CICS on-line [...]
17591 97 58_Re: DB2-OS/390- Statistical Analysis of Tablespaces and In13_Scott Lindsey29_sflindsey@HIGHLIGHTS-CORP.COM31_Wed, 12 Jan 2000 07:15:00 -0500700_us-ascii This sounds like a perfect first candidate for the new DB2-L Documents Archival List (DB2-L-DOCUMENTS@RYCI.COM).<br><br>m.rowinski@PL.IBM.COM wrote: > > Jim, > I am very interested, so could You please send me copy, > > Pozdrawiam/Best Regards > Maciej Rowinski > > ---------------------- Forwarded by Maciej Rowinski/Poland/IBM on 2000.01.12 > 11:33 --------------------------- > > Alan Kirby <Alan.Kirby@WDR.COM> on 2000.01.12 11:12:52 > > Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM> > > To: DB2-L@RYCI.COM > cc: (bcc: Maciej Rowinski/Poland/IBM) > Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and In > > Jim, > Could you please send me a copy... [...]
17689 46 9_Piecesize0_27_BoSDBA@BANKOFSCOTLAND.CO.UK31_Wed, 12 Jan 2000 12:13:15 +0000545_us-ascii Dear List, We are on DB2 v 5.1 OS390 2.6 I have a question about other people's experience of using piecesize to increase the number of datasets on large NPIs on partitioned tablespaces. We have a partitioned tablespace with 2 NPIs of nearly 3 gig each. (it's part of a package, we didn't design it!). At present we use the default piecesize of 2 gig, and so both indexes are in 2 datasets. In a few months, this table will increase in size about 4 fold. We are considering whether to use piecesize to reduce the size of the index [...]
17736 30 45_Database Modeling tools - Erwin vs. ER/Studio12_Sams, Debbie13_dsams@UFL.EDU31_Wed, 12 Jan 2000 07:41:25 -0500544_iso-8859-1 About a year ago I researched and tested a number of products and ended up getting Erwin. I believe that ER/Studio (Embarcadero) did not support MVS DB2 at that time. It has taken a little time to set things up properly in Erwin to make it spit out DDL the way I like to see it, and there are some problems. Most of my current models have been reverse-engineered. To get the index ddl to say TYPE 2, I had to go into each model and unclick/click the CLUSTER option. I also have one database model that will not reverse-engineer [...]
17767 16 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.9_Colin Fay13_cfay2@CSC.COM31_Wed, 12 Jan 2000 07:43:04 -0500329_us-ascii Thank you for the offer. Could you send it to me? or post it?<br><br>Colin Fay<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
17784 54 26_Re: DDL Generation Utility14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Wed, 12 Jan 2000 23:49:02 +1000420_us-ascii Vishy,<br><br>Does it do everything? e.g. Views in correct dependency sequence, aliases, Unique Constraints, Check Constraints, etc.?<br><br>I didn't handle Synonyms on basis of being obsolete.<br><br>I wrote the thing as an SQL because runtime is O.K. although not most efficient possible, SQL is very easy to test & maintain for me, enhancement is easy for anyone, development time was quite short also. [...]
17839 100 26_Re: DDL Generation Utility13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM31_Wed, 12 Jan 2000 18:30:26 +0530378_us-ascii hi Michael !!<br><br>Ya it takes care of Tablespaces / Tables / indexes / Referential integrity constraints / Foreign keys etc. Same for Views. Actually I removed the option for views in my new version of it as it was not required at our shop.<br><br>regards Vishy<br><br><br><br><br><br><br><br>Michael Hannan <mhannan@C031.AONE.NET.AU> on 01/12/2000 07:19:02 PM [...]
17940 42 38_Re: Posting Code and other attachments10_Bill Brown25_bill_brown@SPRINGMAIL.COM31_Wed, 12 Jan 2000 08:09:02 -0500336_- I'm sure this is just a temporary thing, but I tried the web page this morning at 8am and its not there.<br><br>On Tue, 11 Jan 2000 17:09:19 -0700 "Morrill, John" <JohnM@VP.NET> wrote:<br><br>Greetings!<br><br>There is a new service available to DB2-L subscribers. You will now be able to share documents with other subscribers. [...]
17983 55 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.23_Donald W. Woodruff, Jr.30_dwoodruf@CI.NEWPORT-NEWS.VA.US31_Wed, 12 Jan 2000 08:11:17 -0500621_iso-8859-1 Could you send me a copy or post it DB2-L-Documents for myself and others to retrieve?<br><br>Thanks, Donnie<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Jim Lewandowski Sent: Tuesday, January 11, 2000 11:09 AM To: DB2-L@RYCI.COM Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.<br><br><br><br>I had sent out many copies of an SMF 42 subtype 6 REXX that provided a detail and summary of I/O response times (and their components) for each table/indexspace for a DB2 DBM1 subsystem. Anyone else interested in this? [...]
18039 68 38_Re: Posting Code and other attachments13_Lynne Flatley17_LFlatley@NEFN.COM31_Wed, 12 Jan 2000 08:20:28 -0500573_us-ascii Bill, can you get to other web sites? I just tried to access the page and I was able to reach it.<br><br>Thanks!<br><br>> -----Original Message----- > From: Bill Brown [SMTP:bill_brown@SPRINGMAIL.COM] > Sent: Wednesday, January 12, 2000 8:09 AM > To: DB2-L@RYCI.COM > Subject: Re: Posting Code and other attachments > > I'm sure this is just a temporary thing, but I tried the web page this > morning at 8am and its not there. > > On Tue, 11 Jan 2000 17:09:19 -0700 "Morrill, John" <JohnM@VP.NET> wrote: > > Greetings! > > There is a new service available to [...]
18108 48 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.24_Marchese, Frank D, CSCIO18_fdmarchese@ATT.COM31_Wed, 12 Jan 2000 08:26:49 -0500517_iso-8859-1 SELECT COUNT me in on this. Thank you.<br><br>-----Original Message----- From: Jim Lewandowski [mailto:jlewand@STARNETINC.COM] Sent: Tuesday, January 11, 2000 11:09 AM To: DB2-L@RYCI.COM Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.<br><br><br><br>I had sent out many copies of an SMF 42 subtype 6 REXX that provided a detail and summary of I/O response times (and their components) for each table/indexspace for a DB2 DBM1 subsystem. Anyone else interested in this? [...]
18157 69 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.16_Cockerill, Steve30_SLCockerill@NATIONALGYPSUM.COM31_Wed, 12 Jan 2000 08:27:29 -0500428_iso-8859-1 Same here,I'd like a copy. Steve Cockerill<br><br>-----Original Message----- From: Donald W. Woodruff, Jr. [mailto:dwoodruf@CI.NEWPORT-NEWS.VA.US] Sent: Wednesday, January 12, 2000 8:11 AM To: DB2-L@RYCI.COM Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.<br><br><br><br>Could you send me a copy or post it DB2-L-Documents for myself and others to retrieve?<br><br>Thanks, Donnie [...]
18227 61 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.11_Clark, Tony26_Tony.Clark@TWC.STATE.TX.US31_Wed, 12 Jan 2000 07:40:22 -0600674_- Jim:<br><br>Please send me a copy. Thanks.<br><br>Tony<br><br>Tony Clark DB2 System Administrator Texas Workforce Commission 15th Congress Ave ADP Room 320 Austin, Texas 78778-0001 E-Mail: tclark@twc.state.tx.us Phone: (512) 463-3079 Fax: (512) 936-3190<br><br>> -----Original Message----- > From: Jim Lewandowski [SMTP:jlewand@STARNETINC.COM] > Sent: Tuesday, January 11, 2000 10:09 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and > Index spa ces. > > I had sent out many copies of an SMF 42 subtype 6 REXX that provided a > detail and summary of I/O response times (and their components) for > each table/indexspace for a [...]
18289 33 34_Re: quiesce during online activity12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Wed, 12 Jan 2000 05:40:54 PST705_- Karen:<br><br>In our shop we do the same but we locks the tables using 'LOCK TABLE CREATOR.TABLENAME IN EXCLUSIVE MODE '. It is really faster.<br><br><br><br>>From: Karen Daniels <Karen.Daniels@TRW.COM> >Reply-To: DB2 Data Base Discussion List <DB2-L@RYCI.COM> >To: DB2-L@RYCI.COM >Subject: quiesce during online activity >Date: Tue, 11 Jan 2000 09:23:06 -0800 > >I would like to perform a quiesce during our cics activity. Is anyone else >doing this? How do I obtain the locks to run the quiesce? > >===============================================To change your subscription >options or to cancel your subscription visit the DB2-L webpage at >http://www.ryci.com/db2-l. The owners of the list can [...]
18323 63 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.11_Bill Morgan25_BillMorgan@WINN-DIXIE.COM31_Wed, 12 Jan 2000 08:30:58 -0500625_- I would, Thank you<br><br>> -----Original Message----- > From: Marchese, Frank D, CSCIO [SMTP:fdmarchese@ATT.COM] > Sent: Wednesday, January 12, 2000 8:27 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and > Index spa ces. > > SELECT COUNT me in on this. Thank you. > > -----Original Message----- > From: Jim Lewandowski [mailto:jlewand@STARNETINC.COM] > Sent: Tuesday, January 11, 2000 11:09 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index > spa ces. > > > I had sent out many copies of an SMF 42 subtype 6 REXX that provided a [...]
18387 17 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.0_23_pjackson@SUMMITBANK.COM31_Wed, 12 Jan 2000 08:41:06 -0500315_us-ascii Jim,<br><br>I would also be interested in a copy.<br><br>Thanks.<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
18405 46 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.14_Chris Cronrath18_CCronrath@NESL.COM31_Wed, 12 Jan 2000 08:38:36 -0500500_iso-8859-1 I'd love a copy.<br><br>Thanks.<br><br>-----Original Message----- From: Jim Lewandowski [SMTP:jlewand@STARNETINC.COM] Sent: Tuesday, January 11, 2000 11:09 AM To: DB2-L@RYCI.COM Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.<br><br>I had sent out many copies of an SMF 42 subtype 6 REXX that provided a detail and summary of I/O response times (and their components) for each table/indexspace for a DB2 DBM1 subsystem. Anyone else interested in this? [...]
18452 100 38_Re: Posting Code and other attachments14_David Williams21_dba-1@DOL.STATE.GA.US31_Wed, 12 Jan 2000 08:42:40 -0500406_us-ascii When I clicked on the url below, my e-mail system considered the right parenthesis part of the url. I got a "not found on server" error. When I removed the right parenthesis, I was able to access the page. Perhaps this is what happened to Bill.<br><br>---------- From: Lynne Flatley Sent: Wednesday, January 12, 2000 8:20 AM To: DB2-L@RYCI.COM Subject: Re: Posting Code and other attachments [...]
18553 48 45_Re: Disaster Recovery. Any book/article etc ?11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Wed, 12 Jan 2000 08:48:14 -0500488_iso-8859-1 Platinum put out a nice document called "Backup and Recovery for DB2 for OS/390 - A Practical Handbook"<br><br>This has lots of tips. Also tips in DB2 Admin Guide "Operation and Recovery" and Utilities Guide "Recovering Catalog and Directory Objects"<br><br><br><br>BMC has a product which we use called Recovery Manger for DB2 which has helped us to automate the offsite recovery process for the system and also has features related to coordinated application recoverys. [...]
18602 74 24_Re: Indus/Passport & DB20_23_Mike_Levine@TEKHELP.NET31_Wed, 12 Jan 2000 08:53:27 -0500576_us-ascii Hi Steve,<br><br>I am the DBA for Passport at a large electric and gas utility. I was the person responsible for getting the system to run when we went live with A/P, purchasing, inventory, procurement engineering and MSDS all at the same time. We have 6,000 users over three states. The first thing we noticed is that the system would not run on one CICS region. We wound up adding two more regions for a total of three. We found that the CICS region becomes stressed above 15k transactions/hr. Some transactions perform over 50,000 SQL calls! You also want to [...]
18677 40 38_Re: Posting Code and other attachments15_Gordon Fishwick39_Gordon.Fishwick@SCOTTISH-SOUTHERN.CO.UK31_Wed, 12 Jan 2000 13:53:26 +0000766_us-ascii Lynne/Bill,<br><br>I've just 'browsed' the site (' http://jupiter.ryci.com/archives/db2-l-documents.html') and everything seems to be OK, although there are no archives as yet!<br><br>Or is it just me?<br><br>Best Regards,<br><br>Gordon CD Fishwick DB2 Systems Programmer Scottish and Southern Energy<br><br><br><br>********************************************************************** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy plc. It is intended solely for the addressees. Access to this E-Mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in [...]
18718 55 38_Re: Posting Code and other attachments13_Lynne Flatley17_LFlatley@NEFN.COM31_Wed, 12 Jan 2000 09:02:29 -0500709_us-ascii There are no documents yet...hopefully by the end of the day (EST, GMT+5)?<br><br>> -----Original Message----- > From: Gordon Fishwick [SMTP:Gordon.Fishwick@SCOTTISH-SOUTHERN.CO.UK] > Sent: Wednesday, January 12, 2000 8:53 AM > To: DB2-L@RYCI.COM > Subject: Re: Posting Code and other attachments > > Lynne/Bill, > > I've just 'browsed' the site (' > http://jupiter.ryci.com/archives/db2-l-documents.html') and everything > seems to > be OK, although there are no archives as yet! > > Or is it just me? > > Best Regards, > > Gordon CD Fishwick > DB2 Systems Programmer > Scottish and Southern Energy > > > ********************************************************************** > The information [...]
18774 94 13_Re: Piecesize0_18_mebert@AMADEUS.NET31_Wed, 12 Jan 2000 15:03:54 +0100519_us-ascii If even your NPIs have 3 (soon 12?) GB, how big is your TS? I don't think you're going to be happy reorging this monster, no matter what you do. If you do reorg by partition, you will have a veeery long BUILD2 phase, because the keys are likely to be spread all through the NPIs (and your NPIs won't be reorg'd). Doing a full TS reorg, you will need large amounts of space for the shadow datasets, and you will get only a full TS imagecopy, which may cause long delays if you later want to recover only a [...]
18869 15 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.12_Bill Johnson17_wjjohnso@KENT.EDU31_Wed, 12 Jan 2000 09:14:33 -0500319_us-ascii I too would appreciate a copy. Thanks Bill Johnson wjjohnso@kent.edu<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
18885 52 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.12_Andy Wheeler25_Andy.Wheeler@GRIZZARD.COM31_Wed, 12 Jan 2000 09:15:03 -0500533_iso-8859-1 I'd love to receive it.<br><br>TIA<br><br>Andy Wheeler<br><br>-----Original Message----- From: Jim Lewandowski [mailto:jlewand@STARNETINC.COM] Sent: Tuesday, January 11, 2000 10:09 AM To: DB2-L@RYCI.COM Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.<br><br><br><br>I had sent out many copies of an SMF 42 subtype 6 REXX that provided a detail and summary of I/O response times (and their components) for each table/indexspace for a DB2 DBM1 subsystem. Anyone else interested in this? [...]
18938 55 34_Re: quiesce during online activity0_23_Mike_Levine@TEKHELP.NET31_Wed, 12 Jan 2000 09:15:46 -0500374_us-ascii Hi,<br><br>QUIESCE only requires a shr (read) lock to run. As long as you don't have any long running batch update jobs without commits, you should be able to run this with no problem. Instead of QUIESCing many tablespaces we simply put the database in read only mode and QUIESCE a single known tablespace to obtain the QUIESCE RBA for the entire application. [...]
18994 84 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.0_17_ttaylor@CHUBB.COM31_Wed, 12 Jan 2000 09:30:43 -0500891_us-ascii Jim<br><br>Please send a copy<br><br><br><br>Tom Taylor<br><br><br><br>PS. Why not put it on the new DOCUMENT list serv, then everyone could get it<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>Jim Lewandowski <jlewand@STARNETINC.COM> on 01/11/2000 11:09:00 AM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>To: DB2-L@RYCI.COM<br><br>cc: (bcc: Thomas G Taylor/ChubbMail)<br><br><br><br><br><br>Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>I had sent out many copies of an SMF 42 subtype 6 REXX that provided a detail and summary of I/O response times (and their components) for each table/indexspace for a DB2 DBM1 subsystem. Anyone else interested in this? [...]
19079 95 58_Re: DB2-OS/390- Statistical Analysis of Tablespaces and In14_C S R Krishnan29_csr_krishna@CHENNAI.TCS.CO.IN31_Wed, 12 Jan 2000 19:52:59 +0530474_us-ascii Jim,<br><br>Could you please pass on a copy to me too.<br><br>Thanks very much Krish<br><br><br><br><br><br><br><br><br><br>Alan Kirby <Alan.Kirby@WDR.COM> on 01/12/2000 03:42:52 PM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br>To: DB2-L@RYCI.COM cc: (bcc: C S R Krishnan/PLs/TCSCHENNAI) Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and In<br><br><br><br><br><br><br><br>Jim, Could you please send me a copy... [...]
19175 75 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.12_Ramana Nunna29_Ramana.Nunna@MAIL.STATE.AR.US31_Wed, 12 Jan 2000 08:33:59 -0600669_- Please send a copy for me too.<br><br><br><br>Thanks Ramana RAMANA.NUNNA@MAIL.STATE.AR.US<br><br><br><br>> ---------- > From: Andy Wheeler[SMTP:Andy.Wheeler@GRIZZARD.COM] > Reply To: DB2 Data Base Discussion List > Sent: Wednesday, January 12, 2000 6:15 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and > Index spa ces. > > I'd love to receive it. > > TIA > > Andy Wheeler > > -----Original Message----- > From: Jim Lewandowski [mailto:jlewand@STARNETINC.COM] > Sent: Tuesday, January 11, 2000 10:09 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index > spa ces. > > > I had [...]
19251 17 58_Re: DB2-OS/390- Statistical Analysis of Tablespaces and In14_Massimo Scarpa16_mscarpa@CESVE.IT31_Wed, 12 Jan 2000 15:36:44 +0100353_us-ascii LET THEM PAY THE REXX (S)!!!!!<br><br>You'll became a millionaire .....:-)))<br><br>Regards Max Scarpa<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
19269 73 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.13_Purnima Patel18_ppatel@METLIFE.COM31_Wed, 12 Jan 2000 09:37:49 -0500666_us-ascii Me too thanks in advance.<br><br><br><br><br><br><br><br>"Andy Wheeler" <Andy.Wheeler@GRIZZARD.COM> on 01/12/2000 09:15:03 AM<br><br>Please respond to "DB2 Data Base Discussion List" <DB2-L@RYCI.COM><br><br>To: DB2-L@RYCI.COM cc: (bcc: Purnima Patel/Bsg/MetLife/US) Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.<br><br><br><br><br><br>I'd love to receive it.<br><br>TIA<br><br>Andy Wheeler<br><br>-----Original Message----- From: Jim Lewandowski [mailto:jlewand@STARNETINC.COM] Sent: Tuesday, January 11, 2000 10:09 AM To: DB2-L@RYCI.COM Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces. [...]
19343 53 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.11_rick creech18_ykcirc@HOTMAIL.COM29_Wed, 12 Jan 2000 06:39:14 PST642_- JIm, I would appreciate a copy. Thanks. Rick Creech<br><br><br><br>>From: Jim Lewandowski <jlewand@STARNETINC.COM> >Reply-To: DB2 Data Base Discussion List <DB2-L@RYCI.COM> >To: DB2-L@RYCI.COM >Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa > ces. >Date: Tue, 11 Jan 2000 10:09:00 -0600 > >I had sent out many copies of an SMF 42 subtype 6 REXX that provided a >detail and summary of I/O response times (and their components) for >each table/indexspace for a DB2 DBM1 subsystem. Anyone else interested >in this? > >Jim Lewandowski > > > >Galambos, Robert wrote: > > > > Chuck Hoover, from Compuware, has an [...]
19397 59 38_Re: Posting Code and other attachments13_Lynne Flatley17_LFlatley@NEFN.COM31_Wed, 12 Jan 2000 09:45:28 -0500597_us-ascii Please do not request to join the DB2-L-Documents list at this time. It is not necessary to join the list to either submit documents nor view them from the web page.<br><br>Thanks for your patience while we work the procedures out!<br><br>> -----Original Message----- > From: Morrill, John [SMTP:JohnM@VP.NET] > Sent: Tuesday, January 11, 2000 7:09 PM > To: DB2-L@RYCI.COM > Subject: Posting Code and other attachments > > Greetings! > > There is a new service available to DB2-L subscribers. You will now be > able > to share documents with other subscribers. > > We have created a [...]
19457 40 26_Re: DDL Generation Utility11_Bill Morgan25_BillMorgan@WINN-DIXIE.COM31_Wed, 12 Jan 2000 09:54:59 -0500569_- Would you be willing to share the code?<br><br>> -----Original Message----- > From: Viswanathan N [SMTP:Viswanathan.N@POWAIMAIL.LTITL.COM] > Sent: Tuesday, January 11, 2000 11:17 PM > To: DB2-L@RYCI.COM > Subject: DDL Generation Utility > > Hi !! > > Instead of using the query and Icetool combination , I have written a > single program which will intelligenty scan the catalogue and generate > the > DDL's for a full application . You just have to give the HLQ of the system > as input > > It has the following features > > 1. It will take care of referential [...]
19498 91 34_Re: quiesce during online activity19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 12 Jan 2000 08:54:34 -0600583_iso-8859-1 Hi Mike and all, Another issue related to QUIESCE. Suppose a uncommitted, long-running task was holding up a QUIESCE. All tasks are SUSPENDED for the duration of QUIESCE or until they hit the timeout limit. The default duration is 5 seconds, but can be set up to 999. Also, plans should be made for handling failed QUIESCEs (retry, give up, etc). Mike, I can't remember, how do you know when the START DB(dbname) ACCESS(RO) has taken affect? I was thinking that as a separate batch step, the step would not finish until all non-SELECT activity completed. That right? [...]
19590 66 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.12_Jacob Ganzel19_jacobg@SEMECH.CO.IL31_Wed, 12 Jan 2000 17:04:39 +0200318_x-user-defined Thanks in advance for sending me a copy. Jacob.<br><br><br><br>--------------------------------------------------------------- Jacob Ganzel Database Products Mgr. SEMECH Software Marketing Ltd.<br><br>3b Netanyahu St., OR YEHUDA, ISRAEL Email: jacobg@semech.co.il Tel.: 972-3-5333144 Fax.: 972-3-5333132
19657 117 34_Re: quiesce during online activity0_23_Mike_Levine@TEKHELP.NET31_Wed, 12 Jan 2000 10:17:14 -0500560_us-ascii Hi Rick,<br><br>Actually, even if the START RO is issued in a separate step, the step completes (RC=0) even if there are uncommitted updates still in process. It does prevent subsequent updates from occurring. For this processes to be bullet proof, you would need to first issue a -STOP DATABASE and then a -START DB ACCESS(RO) IN THE SAME STEP. In this case the start will wait for the stop to complete which will wait for ALL accesses to be completed. This is somewhat more disruptive and we elect to go with just the start RO and quiesce of a [...]
19775 117 69_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spaces.0_34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM31_Wed, 12 Jan 2000 09:19:21 -0600681_us-ascii I am also interested. Could you send me a copy.<br><br>Thanks<br><br>Larry Kirkpatrick<br><br><br><br>|--------+------------------------------> | | "CIRSE / STE" | | | <cirse.ste@CREDIT-AG| | | RICOLE.FR> | | | | | | 01/12/2000 12:21 AM | | | Please respond to | | | DB2 Data Base | | | Discussion List | | | | |--------+------------------------------> >----------------------------------------------------------------------------| | | | To: DB2-L@RYCI.COM | | cc: (bcc: L-IS Kirkpatrick/MutualOMA) | | Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and | | Index spaces. | >----------------------------------------------------------------------------| [...]
19893 148 34_Re: quiesce during online activity19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 12 Jan 2000 09:40:57 -0600614_iso-8859-1 Hi Mike and all, I think the bullet proof method is what would apply to Karen's situation then. HTH, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying [...]
20042 32 29_Web access to S/390 DB2 data.12_Pullan, Mark18_PULLANM@RBOS.CO.UK31_Wed, 12 Jan 2000 15:40:01 -0000417_- At our shop we're trying to identify the most cost affective method to enable web browser access to S/390 data. Can anybody suggest a solution ?<br><br>thanks,<br><br>Mark Pullan Production DBA Middleware Services Royal Bank of Scotland (0131) 523 5628<br><br><br><br><br><br><br><br>The Royal Bank of Scotland plc is registered in Scotland No 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. [...]
20075 48 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.14_Maxfield, John21_John_Maxfield@BMC.COM31_Wed, 12 Jan 2000 09:53:01 -0600531_ISO-8859-1 Yes... I would be interested. Please send me a copy.<br><br>-----Original Message----- From: Jim Lewandowski [mailto:jlewand@STARNETINC.COM] Sent: Tuesday, January 11, 2000 10:09 AM To: DB2-L@RYCI.COM Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.<br><br><br><br>I had sent out many copies of an SMF 42 subtype 6 REXX that provided a detail and summary of I/O response times (and their components) for each table/indexspace for a DB2 DBM1 subsystem. Anyone else interested in this? [...]
20124 171 34_Re: quiesce during online activity0_23_Mike_Levine@TEKHELP.NET31_Wed, 12 Jan 2000 11:06:24 -0500451_us-ascii Rick, et al:<br><br>The QUIESCE will ensure that there is no update activity. You should be able to QUIESCE a list of tablespaces during a low transaction volume, non-update batch period as long as the list of TS' is not too long. Problems occur when you try to include a list of a thousand or more tablespaces in a single QUIESCE statement, which is why we do START RO and QUIESCE one TS. For a small list, there should be no problems. [...]
20296 65 33_Re: Web access to S/390 DB2 data.13_John Arbogast16_jfarbo@YAHOO.COM31_Wed, 12 Jan 2000 08:08:09 -0800568_us-ascii We have been looking at a product called "shadow web server" from Neon. Altougth I haven't been directly involved, a colleague gives it high marks.<br><br>Something to look at.<br><br>HTH John<br><br>--- "Pullan, Mark" <PULLANM@RBOS.CO.UK> wrote: > At our shop we're trying to identify the most cost > affective method to > enable web browser access to S/390 data. Can anybody > suggest a solution ? > > thanks, > > Mark Pullan > Production DBA > Middleware Services > Royal Bank of Scotland > (0131) 523 5628 > > > > > The Royal Bank of Scotland plc is [...]
20362 51 53_Re: Extracting table level info from DB2 Recovery log13_Baldon, David20_David_Baldon@BMC.COM31_Wed, 12 Jan 2000 10:09:36 -0600358_ISO-8859-1 Balaji,<br><br>BMC has tools that do what you are trying to do. The products are Log Master for DB2 for OS/390, Apply Plus for DB2 for OS/390, and PATROL® DB-Log Master(tm) for Oracle & Sybase. You can check them out on the web at http://www.bmc.com/products/prod_directory.html.<br><br>Thanks.....David BMC Software, Inc. Log Products Group [...]
20414 27 35_Changing NT Hostname and IP address0_26_denzil.coulter@UNICIBLE.CH31_Wed, 12 Jan 2000 17:19:34 +0100438_us-ascii What are the impacts for UDB when changing the NT hostname and/or IP address? Will the new hostname be displayed in the system level of the Control Center's object tree and journal center or will I need to modify the registery variable DB2SYSTEM?<br><br>We also use ADSM for backups. Will prior backups be available after the change or should I plan to take a backup as soon as the system is started using the new hostname? [...]
20442 58 46_Re: Design req documents for online processing19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 12 Jan 2000 10:19:40 -0600577_iso-8859-1 Frank, I hate to cloud a already tough subject, but I think it would be better to do your planning and construct your methods as if both batch and the onlines were always running together. That's where you'll be one day anyway!<br><br>Sorry, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in [...]
20501 20 71_Re: Tuning PeopleSoft on DB2 for OS/390 - Atlanta Class 1/17 -1/18/200011_Danny Davis16_DTDAVIS@PCMH.COM31_Wed, 12 Jan 2000 11:24:13 -0500512_US-ASCII Has anyone been to this class? If so, how was it? I am very interested in going.<br><br>>>> Brian Holroyd <Brian_Holroyd@DB-CONSULTING.COM> 12/30/99 08:46PM >>> Space is available in this class.<br><br>For registration and information, go to www.db-consulting.com<br><br>===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
20522 54 42_Re: Automatic Increment (+1)On Numeric Key12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Wed, 12 Jan 2000 10:25:45 -0600391_us-ascii Here's our DB2 V6 OS/390 trigger that does something similar to what I think you were talking about. When I run this under SPUFI, I set my SQL TERMINATOR terminator on the DEFAULTS panal to a colon ":". In another trigger, I was able to modify the Primary Key on the Insert -- very cool. I haven't tried this on an update trigger yet. This trigger manipulates non-key columns. [...]
20577 60 21_FW: Space calculation13_Marcus Davage29_Marcus.Davage@LLOYDSTSB.CO.UK31_Wed, 12 Jan 2000 16:31:12 -0000578_iso-8859-1 OK. I'll repost this with an update. (DB2 5.1, OS/390 V2.5) I've got the PRIQTY and SECQTY calculation for the tablespace done, but my problem is this: I am partitioning a currently segmented tablespace, and have written a Rexx that creates the DDL from the current catalog data, given the number of partitions I want to create. I know exactly how many rows there will be in each partition. The Rexx also creates the LIMITKEY for the partitioning index, but I don't know how to calculate the PRIQTY and SECQTY for each partition of the index. I thought of using [...]
20638 61 45_Re: Disaster Recovery. Any book/article etc ?19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 12 Jan 2000 10:32:28 -0600517_iso-8859-1 Max, See DB2 for OS/390 V5 Admin. Gde., bookmanager ref. Remote Site Recovery from Disaster at a Local Site" in topic 4.7.16. This section has improved over the years and will also make clear all the "pieces of the puzzle" that must go together. Nearly all of the procedure in 4.7.16 can be automated either by yourself or 3rd party vendors. Another alternative is a product like RRDF. This product basically helps you keep a mirror image of your production system nearly up to date at a remote site. [...]
20700 67 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.14_Phil Forestall19_forestall@SPRINT.CA31_Wed, 12 Jan 2000 11:35:41 -0500691_iso-8859-1 Yep, I'd love a copy Thanks. Phil Forestall ----- Original Message ----- From: "Maxfield, John" <John_Maxfield@BMC.COM> Newsgroups: bit.listserv.db2-l To: <DB2-L@RYCI.COM> Sent: Wednesday, January 12, 2000 10:53 AM Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.<br><br><br><br>> Yes... I would be interested. Please send me a copy. > > -----Original Message----- > From: Jim Lewandowski [mailto:jlewand@STARNETINC.COM] > Sent: Tuesday, January 11, 2000 10:09 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index > spa ces. > > > I had sent out many copies of an SMF 42 subtype 6 REXX that provided [...]
20768 86 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.12_INFO_SYSTEMS26_INFO_SYSTEMS@EMAIL.MSN.COM31_Wed, 12 Jan 2000 09:00:45 -0800689_- Please send me a copy. Thanks. -----Original Message----- From: Kim, Gye-Woo <GYE-WOO.KIM@CAI.COM> Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM <DB2-L@RYCI.COM> Date: Tuesday, January 11, 2000 11:46 PM Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.<br><br><br><br>> Hi. > > I want to receive a copy. > Please send to me. > > Thanks. > >> -----Original Message----- >> From: Bartolucci Silvia [SMTP:S.Bartolucci@FONDIARIA.IT] >> Sent: Wednesday, January 12, 2000 4:17 PM >> To: DB2-L@RYCI.COM >> Subject: R: DB2-OS/390- Statistical Analysis of Tablespaces and >> Index spa ces. >> >> Hi, i'm very interested, please send a copy to me. >> Thanks [...]
20855 25 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.18_Federico Rodriguez38_Federico.Rodriguez@BANCOGALICIA.COM.AR31_Wed, 12 Jan 2000 14:25:50 -0300584_iso-8859-1 pls. send me a copy, tks. Federico<br><br><br><br>-------------------------------------------------------------- Federico Rodriguez PROCESAMIENTO DE DATOS Y COMUNICACIONES Banco de Galicia y Buenos Aires Perón 444 Conmutador: 4329-6000 Tel/Interno: 3287 Fax: 3261 federico.rodriguez@bancogalicia.com.ar http://www.bancogalicia.com.ar<br><br>===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
20881 22 33_Re: Multiple Counts & Outer Joins12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Wed, 12 Jan 2000 11:35:16 -0600605_us-ascii Thank you Linda and Terry. It's working now. The programmer dropped the brackets on the code I sent and rearranged some things.<br><br>Thanks again.<br><br>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Steve Grimes Washington University Information Systems W: 314-935-4376 H: 314-928-5005 Isa.64:6 Steve_Grimes@aismail.wustl.edu ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
20904 88 61_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index40_Andersen, Cindy (CC-Application Support)26_Cindy.Andersen@CONAGRA.COM31_Wed, 12 Jan 2000 11:26:53 -0600332_iso-8859-1 Please DO NOT send your personal requests for information to the DB2-L@RYCI.COM address which is what appears in the To: on a Reply. This goes out to EVERYONE on the listserv.<br><br>You need to change that address and Reply to the email id of the person making the offer of the free code, not the listserv address. [...]
20993 17 25_Re: FW: Space calculation12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 12 Jan 2000 09:54:25 -0800438_us-ascii The formulas for calculating space are in the Installation Guide, chapter 2, under the topic Calculating the Space Required for a Table, page 2-29 in the V5 hard copy.<br><br>Roger Miller<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
21011 57 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.13_Mercy Scholes26_mercy.scholes@ZURICHUS.COM31_Wed, 12 Jan 2000 11:53:13 -0600631_us-ascii Hi, I'm inetested, can you send me a copy?<br><br>Thanks.<br><br><br><br><br><br><br><br>Jim Lewandowski <jlewand@STARNETINC.COM> on 01/11/2000 10:09:00 AM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br>To: DB2-L@RYCI.COM cc: (bcc: Mercy E Scholes/ZI/USA/Zurich) Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.<br><br><br><br><br><br>I had sent out many copies of an SMF 42 subtype 6 REXX that provided a detail and summary of I/O response times (and their components) for each table/indexspace for a DB2 DBM1 subsystem. Anyone else interested in this? [...]
21069 41 21_Join columns question15_Backes, Michael26_BackeM@MAIL.OA.STATE.MO.US31_Wed, 12 Jan 2000 12:09:16 -0600365_iso-8859-1 table A contains columns 1 2 3 4 5 table b contains columns 1 2 3 4<br><br>is there a way to combine columns in sql so that in my on clause i can make it do this a1=b1 and a2+a5 = b2 and a3 = b3 and a4=b4.<br><br>problem is that in table A columns 2 and 5 are separate (2 is char(10), 5 is char(1)) in table B column 2 contains both (2 is char(11)) [...]
21111 14 25_Re: Join columns question0_19_Tim.Lowe@STPAUL.COM31_Wed, 12 Jan 2000 12:16:13 -0600345_us-ascii Michael, Can you use a nested table expression in place of "table a" to create the new column?<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
21126 21 7_db2 sdk11_David Ayers24_david.ayers@HIGHMARK.COM31_Wed, 12 Jan 2000 13:24:26 -0500367_us-ascii Hello DB2 list<br><br>Can anyone give me information on the software developers kit. Looking for information to the following: - is a sperate cost product or does it come bundled with DB2 connect / DB2 UDB ... - if it is bundled with other products can it be installed separately. If so is it in a seperate directory on the CD or can it be downloaded ? [...]
21148 45 19_Re: DB2 Connect 5.20_15_leon@CA.IBM.COM31_Wed, 12 Jan 2000 13:26:13 -0500405_us-ascii Yes, DB2 Connect V5 will work with DB2 for OS/390 running on OS/390 Version 1Release 3. You should probably open a PMR so the problem you are seing can be investigated.<br><br>Leon Katsnelson, DB2 Connect Development Manager mailto:leon@ca.ibm.com<br><br><br><br>SrinivasG <SRINIVASG@INF.COM> on 01/11/2000 09:24:36 PM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM> [...]
21194 46 11_Re: db2 sdk14_Philip Gunning26_philip_gunning@HOTMAIL.COM29_Wed, 12 Jan 2000 10:32:44 PST622_- Dave, The SDK disk is now shipped with the UDB EE and EEE versions. Phil<br><br><br><br><br><br>Philip K. Gunning DB2DBA IBM Certified Advanced Technical Expert DB2 UDB -- DRDA Assoc List Owner DB2-l<br><br>>From: David Ayers <david.ayers@HIGHMARK.COM> >Reply-To: DB2 Data Base Discussion List <DB2-L@RYCI.COM> >To: DB2-L@RYCI.COM >Subject: db2 sdk >Date: Wed, 12 Jan 2000 13:24:26 -0500 > >Hello DB2 list > >Can anyone give me information on the software developers kit. Looking for >information to the following: > - is a sperate cost product or does it come bundled with DB2 connect / >DB2 UDB >... > - if it is [...]
21241 37 11_Re: db2 sdk13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Wed, 12 Jan 2000 12:36:06 -0600555_US-ASCII David, The SDK is a separate product under V5 and V5.2. It is available for download on the IBM website for V6. Kurt<br><br>>>> David Ayers <david.ayers@HIGHMARK.COM> 01/12/00 12:24PM >>> Hello DB2 list<br><br>Can anyone give me information on the software developers kit. Looking for information to the following: - is a sperate cost product or does it come bundled with DB2 connect / DB2 UDB ... - if it is bundled with other products can it be installed separately. If so is it in a seperate directory on the CD or can it be downloaded ? [...]
21279 68 13_Re: Piecesize32_Cuneyt Goksu (Garanti Teknoloji)22_CuneytG@GARANTI.COM.TR31_Wed, 12 Jan 2000 15:17:06 +0200400_- I use piecesize as much as possible. It increases the granularity of the index pagesets which gives more opportunity for the optimizer to use parallelism. In our DW environment we use piecesize for all NPIs with an acceptable size. It affects the access path selection for the optimizer.<br><br>BTW, There is an open APAR for V5 and V6 for Piecesize with LOAD RESUME.. Be careful with that... [...]
21348 76 25_Re: Join columns question0_22_Rohn.Solecki@MTS.MB.CA31_Wed, 12 Jan 2000 13:06:32 -0600367_us-ascii Use concatenation.<br><br>In this example taken from a SPUFI I was running this morning "... WHERE a2 || a5 = '9423345' " given that in my example A2 is Char 3 and A5 is Char 4<br><br><br><br>Rohn Solecki Database Administrator Manitoba Telecom Services PT 10A Box 6666 Winnipeg, M.B. Canada R3C 3V6 Phone: 1 204 941 6319 E-Mail: Rohn.Solecki@MTS.MB.CA [...]
21425 19 72_Re: Tuning PeopleSoft on DB2 for OS/390 - Atlanta Class 1/17 -1 /18/200012_Roger Miller19_millerrl@US.IBM.COM31_Wed, 12 Jan 2000 11:13:51 -0800489_us-ascii I've worked with Brian a number of times and have seen him present parts, but not this entire class. He is an excellent teacher and is the person I would go to for detailed technical problems. I'd recommend this class.<br><br>Roger Miller<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
21445 20 27_TCP/IP - DB2 - Pass Tickets18_William D Trago Jr33_William_D_Trago_Jr@FREDDIEMAC.COM31_Wed, 12 Jan 2000 14:39:22 -0500440_us-ascii We are looking at using the TCP/IP interface with DB2 (V5) on OS/390 (V26) from different clients (UNIX, AIX SP2, workstation) . Top Secret is our OS/390 security package. The good old issue of userids/passwords or pass tickets seem to be the options. We really want to use pass tickets. Is there anyone out there that has tried using pass tickets or knows of any good DB2 documentation pertaining to pass tickets in general. [...]
21466 24 16_Looking for help13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Wed, 12 Jan 2000 14:06:28 -0600117_us-ascii Hi,<br><br>Can someone please e-mail the correct e-mail address for listserv commands.<br><br>Thanks<br><br>
21491 20 31_Re: TCP/IP - DB2 - Pass Tickets12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 12 Jan 2000 12:05:41 -0800429_us-ascii The primary discussion of PassTickets is in the DB2 Administration Guide chapter 3-4 of the section on Security and Auditing, Controlling Access to a DB2 Subsystem. On page 3-89 of the V5 hard copy, the section title is Sending RACF PassTickets. The implementation is a lot more complex than the externals. I have no idea if or how this works with the CA products. You probably need to check with the other vendor. [...]
21512 18 6_Thanks13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Wed, 12 Jan 2000 14:17:11 -060075_us-ascii Hi<br><br>Thanks to all... I have the correct web URL now.<br><br>
21531 30 13_Re: Piecesize12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 12 Jan 2000 12:42:38 -0800417_us-ascii The easiest way to tell if splitting up the data set across volumes can help you is looking at the IOSQ time on the SMF 42-6 records for the data set. Until your RAID device works with Parallel Access Volumes (PAV) or something like it, concurrent requests for the same logical volume will queue in MVS IOS. If the secondary index is very busy, then the virtual disk can still be busy, making IOs wait. [...]
21562 44 33_Re: Multiple Counts & Outer Joins15_Philip, Sibimon19_PhilipS@SEALAND.COM31_Wed, 12 Jan 2000 16:32:07 -0500511_iso-8859-1 Could you please explain what he is trying to find out in that SQL? Also give the SQL which is working now. I tried a similar SQL in DB2 and it is not working because of count(......).<br><br>Thanks Sibimon Philip 972-702-2515 - Office 972-417-3597 - Residence E-mail - Sibimon_philip@sealand.com<br><br>-----Original Message----- From: Steve Grimes [mailto:Steve_Grimes@AISMAIL.WUSTL.EDU] Sent: Wednesday, January 12, 2000 11:35 AM To: DB2-L@RYCI.COM Subject: Re: Multiple Counts & Outer Joins [...]
21607 40 22_Re: Rollback Required?12_Jason Hughes20_jason.hughes@TRW.COM31_Wed, 12 Jan 2000 15:36:53 -0600482_- Just wanted to pass along the resolution for future reference.<br><br>While Jim's suggested method should work in theory, I could not get it to work with Access 97 and DB2 Connect PE 5.2 FixPak 11. Access thought it was issuing the Rollback, but DB2 never saw it. So, I ended up following Lynne's suggestion and issue a ROLLBACK through a pass-through query. It returns a -901 when there is something to rollback, but it clears up the problem. That's what I was looking for. [...]
21648 47 11_Re: db2 sdk0_15_leon@CA.IBM.COM31_Wed, 12 Jan 2000 17:26:18 -0500446_us-ascii DB2 SDK is now shipped with DB2 UDB and DB2 Connect Version 6.1 products. Previous releases were distributed as part of the DB2 UDB Developer Edition and DB2 UDB Enterprise Developer Edition products.<br><br>Leon Katsnelson, DB2 Connect Development Manager mailto:leon@ca.ibm.com<br><br><br><br>David Ayers <david.ayers@HIGHMARK.COM> on 01/12/2000 01:24:26 PM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM> [...]
21696 12 11_Create View0_22_Rohn.Solecki@MTS.MB.CA31_Wed, 12 Jan 2000 16:44:53 -0600425_us-ascii We are doing some restart processing on a table with 4 elements in its key. So we have to code a nasty where clause combining AND's and OR's to make sure we get the next row.<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
21709 59 33_Re: Multiple Counts & Outer Joins12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Wed, 12 Jan 2000 17:12:28 -0600620_us-ascii Hello.<br><br>I should have clarified that "multiple counts" did not work, but the multiple-joins did.<br><br>Here's the programmers note to me about it: -=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Here's what I got past the syntax checker. I believe it proves that you can have multiple left outer joins. The only thing weird with it is that I haven't included any columns from the tables we are joining. That's because those values were computed by the counts, which never actually appeared on the report. When I add the counts the syntax checker is very clear in its message that multiple counts are not allowed. As [...]
21769 117 25_Chuck Hoover presentation16_Galambos, Robert29_Robert_Galambos@COMPUWARE.COM31_Wed, 12 Jan 2000 18:18:06 -0500548_iso-8859-1 <br><br><br><br>Robert Galambos robert_galambos@compuware.com<br><br>Compuware Corp. Of Canada 1-905-803-8600 1-800-348-8299 (Canada & US) 1-905-803-8603 (fax) 1-800-447-1662 (Quebec)<br><br><br><br>First of all, I want to thank the 'billions and billions' of people who either emailed me directly, or on this listserver asking about this particular presentation.<br><br>First of all please do NOT post a request for the document on this list. it crowds this list for no good reason. If you are interested please email me directly. [...]
21887 25 28_Status of Documents web page13_Lynne Flatley17_LFlatley@NEFN.COM31_Wed, 12 Jan 2000 18:27:24 -0500394_us-ascii We're getting there! I 'archived' a test document on the site but unfortunately, it can only be downloaded as a html file at this time. We're actively working on this and I'm sure it'll be fixed soon!<br><br>Thanks!<br><br>"A foolish consistency is the hobgoblin of small minds" - Ralph Waldo Emerson<br><br>Lynne A. Flatley New England Financial (617) 578-4079 lflatley@nefn.com [...]
21913 101 35_unavailable resource after dsn1copy16_Mary Ann Pickett24_pickettm@DOT.STATE.AL.US31_Wed, 12 Jan 2000 17:24:33 -0600510_iso-8859-1 Hi all,<br><br>I hope someone can help me with this problem. We are on OS390, DB2 version 5. I am trying to use an image copy of our production data that was copied on December 29, 1999 to recover a test table to that point in time. I am using Dsn1copy with the image copy data set as input and the test table data set as output with sysxlat . I specified the source and target obids, psids, and dbids. I ran the job and got a 0 condition code. However, when I tried to access the table, I got [...]
22015 54 39_Re: unavailable resource after dsn1copy11_Ball, Linda18_Linda_Ball@BMC.COM31_Wed, 12 Jan 2000 17:40:38 -0600578_ISO-8859-1 REPAIR LEVELID <TS> should fix it up. DSN1COPY should work OK on segmented spaces but the source and target should have the same SEGSIZE.<br><br>-------------------------------------------- Opinions are mine! Linda Ball DB2 Corporate Architect OS/390 Product Development Direct Phone: (512) 340-6722 Fax: (512) 340-6646 Toll Free: (800) 841-2031 linda_ball@bmc.com<br><br>-----Original Message----- From: Mary Ann Pickett [mailto:pickettm@DOT.STATE.AL.US] Sent: Wednesday, January 12, 2000 5:25 PM To: DB2-L@RYCI.COM Subject: unavailable resource after dsn1copy [...]
22070 48 39_Re: unavailable resource after dsn1copy11_GOSE PAUL M17_pmgose@SRPNET.COM31_Wed, 12 Jan 2000 16:40:42 -0700667_ISO-8859-1 Have you tried the following?:<br><br>REPAIR LEVELID TABLESPACE database.tablespace<br><br>Paul Gose Salt River Project<br><br>-----Original Message----- From: Mary Ann Pickett [mailto:pickettm@DOT.STATE.AL.US] Sent: Wednesday, January 12, 2000 4:25 PM To: DB2-L@RYCI.COM Subject: unavailable resource after dsn1copy<br><br><br><br>Hi all,<br><br>I hope someone can help me with this problem. We are on OS390, DB2 version 5. I am trying to use an image copy of our production data that was copied on December 29, 1999 to recover a test table to that point in time. I am using Dsn1copy with the image copy data set as input and the test table data set [...]
22119 117 39_Re: unavailable resource after dsn1copy14_Paul A Redhead35_Paul.A.Redhead@TRANSPORT.QLD.GOV.AU31_Thu, 13 Jan 2000 09:36:20 +1000401_us-ascii <br><br><br><br>Mary, You need to use the 'RESET' option in your parm line (eg: PARM='OBIDXLAT,RESET') to reset the last update LOG RBA in each page header to 0. Also, if segmented, then the segsize on the previous version of the table MUST match the current version.<br><br>Paul.<br><br><br><br><br><br><br><br><br><br>Mary Ann Pickett <pickettm@DOT.STATE.AL.US> on 13/01/2000 09:24:33 [...]
22237 52 39_Re: unavailable resource after dsn1copy15_Murley, Michael22_Michael_Murley@BMC.COM31_Wed, 12 Jan 2000 17:47:33 -0600358_ISO-8859-1 Mary Ann,<br><br>Others have already suggested the REPAIR utility. Also, I think if you run DSN1COPY with the RESET option, you will avoid this problem. In fact, since your're going across subsystems, you should do that anyway since the production RBA values are meaningless on the test system. Am I guessing right that you didn't use RESET? [...]
22290 97 39_Re: unavailable resource after dsn1copy11_Ball, Linda18_Linda_Ball@BMC.COM31_Wed, 12 Jan 2000 17:50:17 -0600368_ISO-8859-1 You may get away with REPAIR LEVELID if your log RBA is lower on the test system than production. I believe the RESET in DSN1COPY resets ALL RBAs including the LEVELID one in the header so it cures two possible problems: LEVELID mismatch with SYSLGRNX and the possibility that a page's RBA is beyond the system log point which causes DB2 to get upset. [...]
22388 78 21_Join columns question14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Thu, 13 Jan 2000 10:43:26 +1000502_us-ascii The moral of the story is NEVER ever have a DB2 column that contains sub-fields. Use multiple columns.<br><br>Restrictions in ON clause are being relaxed somewhat in DB2 V6 for LEFT and RIGHT Outer Joins.<br><br>For DB2 V4 & V5 rules are very tough.<br><br>Using a Nested Table Expression can help materialise an intermediate result set with a new combined column it. SELECT ... FROM (SELECT ..., SUBSTR(a2 CONCAT a5, 1, 11) as newcol, ... FROM TABLE_A .... ) AS X LEFT JOIN TABLE_B etc. [...]
22467 96 49_Re: Database Modeling tools - Erwin vs. ER/Studio20_Guy Smallwood (HUON)24_Guy_Smallwood@HUON.CO.UK31_Wed, 12 Jan 2000 23:56:44 +0000463_iso-8859-1 Debbie<br><br>"the web publishing tool that works with ERWin", could you please give me some more detail as it sounds like something we could well make use of.<br><br><br><br><br><br><br><br><br><br><br><br>DB2 Data Base Discussion List<DB2-L@RYCI.COM> on 12/01/2000 00:57:25 Please respond to DB2 Data Base Discussion List<DB2-L@RYCI.COM> @ INTERNET To: DB2-L<DB2-L@RYCI.COM> @ INTERNET cc: Subject: Database Modeling tools - Erwin vs. ER/Studio [...]
22564 76 39_Re: unavailable resource after dsn1copy16_Mary Ann Pickett24_pickettm@DOT.STATE.AL.US31_Wed, 12 Jan 2000 18:14:03 -0600509_iso-8859-1 Michael,<br><br>I guess I wasn't clear in that even though we have production and test tables, they are both in the same subsystem. we separate them by specifing TEST.XXXX and PROD.XXXX.. Would the reset option work in this environment? Thanks,<br><br>Mary Ann -----Original Message----- From: Murley, Michael <Michael_Murley@BMC.COM> Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM <DB2-L@RYCI.COM> Date: Wednesday, January 12, 2000 5:51 PM Subject: Re: unavailable resource after dsn1copy [...]
22641 95 39_Re: unavailable resource after dsn1copy11_Ball, Linda18_Linda_Ball@BMC.COM31_Wed, 12 Jan 2000 18:30:35 -0600519_ISO-8859-1 The RESET would have done it. Now that the DSN1COPY is done, the REPAIR LEVELID will do it, too. RESET sets all Log Point (RBA, LRSN) values. REPAIR LEVELID just one, in the header, that's triggering your message.<br><br>Including RESET in the DSN1COPY will avoid this problem in the future.<br><br>LB<br><br>-----Original Message----- From: Mary Ann Pickett [mailto:pickettm@DOT.STATE.AL.US] Sent: Wednesday, January 12, 2000 6:14 PM To: DB2-L@RYCI.COM Subject: Re: unavailable resource after dsn1copy [...]
22737 73 49_Re: How do you load literals with the IBM utility14_Purcell, Terry37_Terry.Purcell@CORPMAIL.TELSTRA.COM.AU31_Thu, 13 Jan 2000 11:36:53 +1100362_- Another option........if the columns are defined as not null with default (and the default is the value you wish to load), then you can use the DEFAULTIF command in the load utility. If the columns are not defined with a default value then it is a bit messy to drop/recreate the table with defaults, unless you have BMC Change Manager or similar product. [...]
22811 94 50_Re: Disaster Recovery. Any book/article etc ?/RRDF12_<Paul Wendt>14_paulw@ENET.COM31_Wed, 12 Jan 2000 17:35:01 -0800447_- Thanks for the mention of RRDF.<br><br>RRDF transmits logs from the primary site to the backup site, and builds Change Log Inventory control cards to update the backup site BSDS with the logs from the sending/primary site. (RRDF also works with other mainframe databases, such as IMS, IDMS and ADABAS).<br><br>In addition, ENET provides the DB2-only product, Log Apply, which updates a full shadow DB2 database on the shadow/recovery site. [...]
22906 147 11_Re: Explain14_Purcell, Terry37_Terry.Purcell@CORPMAIL.TELSTRA.COM.AU31_Thu, 13 Jan 2000 13:24:00 +1100596_iso-8859-1 Kaushal,<br><br>Is this V6? The syntax and explain output does not look familiar. Anyway, I'll give it a try.....<br><br>It appears that the accesspath chosen involves firstly accessing T05029 and leftjoining to T05321 (queryblock 2). The results are stored in the workspace DSNWFQB, which is scanned sequentially and joined to the remaining 3 tables in the sequence shown by explain. Note: this is my interpretation of the output. Behaviour of Outer Joins is dependant on your DB2 Version and maintenance level. To be 100% sure I would usually trace the access path in Omegamon. [...]
23054 24 26_Reducing Logging on Tables11_Ellen Chiem21_ellen@NETTRACK.COM.AU31_Thu, 13 Jan 2000 17:31:48 +1100288_us-ascii Hi all, A simple question. When creating a table with "NOT LOGGED INITIALLY" option, the manual stated that any changes made on that table in the same unit of work in which the table was created will not be logged. Question: What does it mean by "in the same unit of work"? [...]
23079 215 36_Concurrence Between BATCH and ONLINE5_Pearl17_panidak@SCB.CO.TH31_Thu, 13 Jan 2000 15:14:53 +0700602_windows-874 Dear List Application Designer have some concurrent Batch and Online problems involved DB2 LOCK resources (DB2 V5 on OS390). We used DECLARE CURSOR... WITH HOLD..... FOR UPDATE OF ... in COBOL Program.(But it's difference between Batch & Online. Online will select and update data one row only. Online will select data a lot of rows but fetch one row to process update and commit when process many rows completely.) We define LOCKSIZE ROW and type-2 index for every table. When Batch & Online Programs run open cursor,its locked on ROW level by lock mode U-LOCK. We found 2 problems : [...]
23295 81 47_Re: reorg unload external - a single partition?0_18_mebert@AMADEUS.NET31_Thu, 13 Jan 2000 09:20:25 +0100366_us-ascii I have commented on this about half a year ago, and I mentioned this bug again in a posting 4 weeks ago. I got this reply from Manas Dasgupta:<br><br>True, there is (or was) a problem with PART option in that the entire tablespace is unloaded even if you specify PART n. But if you also specified the SORTDATA option then it would unload by partition. [...]
23377 441 40_Re: Concurrence Between BATCH and ONLINE0_24_ssethi@LOT.TATASTEEL.COM29_Thu, 13 Jan 2000 09:07:47 GMT733_iso-8859-1 <br><br><br><br>Hi Pearl, If ur batch application is coming to update 100 rows then it must be declaring the cursor for those 100 rows and opening it before fetch then it must be aquiring S-locks on all the 100 rows.First of all i am unable to think how can the online application update that 100th row.As per my understanding ,for updating it has to aquire X-locks on 100th row(if row level locking is there). This is according to the compatibility of the Page and Row lock modes which is given below. _______________________________________________________________________________________________________ Held Locks | Requested Locks | |-----------------+-----------------+-----------------+-----------------| | |S [...]
23819 19 45_Re: Disaster Recovery. Any book/article etc ?14_Massimo Scarpa16_mscarpa@CESVE.IT31_Thu, 13 Jan 2000 10:45:36 +0100449_us-ascii Many many thanks ( x 10+9) to all people who sent suggestions & indications abour Disaster<br><br>Recovery literature.<br><br>Many thanks even from my (almost) broken neck.....:-))<br><br>Max Scarpa<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
23839 105 25_Re: FW: Space calculation14_Massimo Scarpa16_mscarpa@CESVE.IT31_Thu, 13 Jan 2000 11:07:59 +0100305_us-ascii This is NOT a method to calculate space requested if you know the number of rows, the length of row, length of an index key etc. (we use DB2 ESTIMATOR, which is free !!!) , it's an 'iterative' method (and it works for me from a long time) for a daily space tuning and reorganizing of db(s). [...]
23945 138 25_Re: FW: Space calculation13_Adrian Savory24_adrian.savory@ZURICH.COM31_Thu, 13 Jan 2000 11:09:29 +0000516_us-ascii Max,<br><br>A number of people including yourself have advocated the use of Listcat information for space calculation of DB2 objects. The question I have is does the high-used-rba value always accurately reflect the amount of space used by DB2 data? The scenario I'm thinking of is where a large amount of data has been deleted. Would the hi-used-rba value always change to reflect this? I thought the answer to this was 'not necessarily' depending on what data had been deleted, but I could be wrong! [...]
24084 50 37_Re: CICS Transaction Gateway Problem.9_Reid, Ian18_Reid.Ian@PMINTL.CH31_Thu, 13 Jan 2000 12:30:14 +0100375_- Cross posted to CICS-l, DB2-L, TCPIP-L<br><br>Hello All,<br><br>Today's question revolves around DB2 threads, SYBASE Direct Connect and TCP/IP.<br><br>We have been using this product to access DB2 over SNA (LU62) for some time. We will be changing to use TCP/IP.<br><br>What a developer has noticed is that the DB2 Thread is not released *by CICS?* when using TCP/IP. [...]
24135 34 37_Re: CICS Transaction Gateway Problem.9_Colin Fay13_cfay2@CSC.COM31_Thu, 13 Jan 2000 07:09:10 -0500625_us-ascii This may be the cause of your hanging threads. From our recent (painful) conversion to 3-tier Omni:<br><br>"Once in production we were seeing hanging CICS transactions and DB2 threads. After speaking to Sybase Tech Support, we applied EBFs to DirectConnect and Open Server. These EBFs were applied in two stages. The transactions were still hanging. I was able to track down one of the hanging transactions to be KL. He was running the Material Sequencing PowerBuilder application. His report had successfully returned. If he performed an update to one of the rows, the CICS transaction and DB2 thread would go [...]
24170 26 0_0_29_STANLEY_GOODWIN@MECH.DISA.MIL31_Thu, 13 Jan 2000 07:15:34 -0500347_us-ascii Has anyone out there either tested the backout procedures or actually backed out a DB2 6.1 migration.<br><br>My question is how was apar PQ22051(catmaint) handled if this apar was averted by the apply of APAR PQ29582 in a 5.1 maint apply..<br><br>I was told that the 6.1 migrate changes the max from 254 to 255 for character fields. [...]
24197 40 25_Re: FW: Space calculation14_Massimo Scarpa16_mscarpa@CESVE.IT31_Thu, 13 Jan 2000 13:35:45 +0100313_us-ascii I made some test many years ago, and I found that the space occupied is correct, in tracks<br><br>or in Kb. But this is not the 'real' space occupied by rows (that is row size*number of rows) this is<br><br>the number of records, fixed sized 4096, that DB2 uses or "knows" or owns at VSAM level. Is [...]
24238 28 49_Re: Database Modeling tools - Erwin vs. ER/Studio21_Christopher T Everett24_cteveret@DUKE-ENERGY.COM31_Thu, 13 Jan 2000 07:33:38 -0500553_us-ascii >> "the web publishing tool that works with ERWin", could you please give me some >> more detail as it sounds like something we could well make use of.<br><br>I thought I would chime in here. Our shop found Web Publisher to be much more trouble than it was worth. The version with ERwin 3.5.2 requires you to start a DIFFERENT ERwin instance that basically can do everything ERwin can except save - and print to adobe acrobat. It is much simpler to just bag Web Publisher and buy a copy of adobe acrobat. It installs as just another print [...]
24267 27 45_Database Modeling tools - Erwin vs. ER/Studio12_Sams, Debbie13_dsams@UFL.EDU31_Thu, 13 Jan 2000 07:46:15 -0500500_iso-8859-1 Guy,<br><br>The product is called Model Web Publishers, version 3.5.2, price approx $1000 US. It creates PDF pages out of Erwin models that can be viewed through the web.<br><br>Debbie<br><br>>>From: "Guy Smallwood (HUON)" <Guy_Smallwood@HUON.CO.UK> >>Subject: Re: Database Modeling tools - Erwin vs. ER/Studio<br><br>>>Debbie<br><br>>>"the web publishing tool that works with ERWin", could you please give me some >>more detail as it sounds like something we could well make use of. [...]
24295 196 25_Re: FW: Space calculation19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 13 Jan 2000 07:00:40 -0600632_iso-8859-1 Adrian, HIGH_USED_RBA is always an approximation, for many reasons, one of which you pointed out. Could you please provide your method(s) for calculating space requirements? Regards, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other [...]
24492 95 26_Re: Primary key of a table0_24_ssethi@LOT.TATASTEEL.COM29_Thu, 13 Jan 2000 13:13:02 GMT355_iso-8859-1 Both syskeys and syscoulumns will give u the information.<br><br>1) With join of syskeys and sysindexes with this query u will get the primary keys.... SELECT COLNAME,COLSEQ, UNIQUERULE FROM SYSIBM.SYSINDEXES , SYSIBM.SYSKEYS WHERE NAME = IXNAME AND CREATOR = IXCREATOR AND TBNAME = &tbname AND TBCREATOR = &tbcreator AND UNIQUERULE = 'P' [...]
24588 703 11_Re: Explain0_24_ssethi@LOT.TATASTEEL.COM29_Thu, 13 Jan 2000 13:47:51 GMT520_us-ascii <br><br>Hi Kaushal, I think only thing which can be done is to combine all the inner joines together by writing a inline views and then that should be outer joined(left) with the table E .However it depends on ur data i.e how much data will be returned in the work file in this case(the query u have written) and how much it will take when u code the inline views because in both the cases work files are used.As table E is of very small size ,at the same time, D is bigger table and left table in ur case [...]
25292 59 30_Re: Reducing Logging on Tables15_Toine Michielse18_vndobtm@US.IBM.COM31_Thu, 13 Jan 2000 10:33:58 +0000320_us-ascii Hello Ellen,<br><br>"in the same unit of work" would mean until the unit-of-work (read your application) issues a commit or rollback. NOT-LOGGED-INITIALLY is useful if you create a table and populate it with a large amount of data and do not need the overhead of the logging while initially populating it. [...]
25352 238 25_Re: FW: Space calculation13_Adrian Savory24_adrian.savory@ZURICH.COM31_Thu, 13 Jan 2000 14:10:10 +0000581_us-ascii Rick,<br><br>Up until now I've been fortunate enough to work at sites that have tools to calculate space for you. I am now in the process of writing REXX execs to do space calculations for tablespaces and indexes, using the formulae in the DB2 Admin Guide. One complication I have is that the tablespace calculations use RECLENGTH from the SYSTABLES table. This gives the maximum record length for the row, but most of my data is VARCHAR (it's an SAP system). This means that if I base my size estimates on RECLENGTH then I could end up heavily overallocating spaces [...]
25591 43 25_Re: FW: Space calculation11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Thu, 13 Jan 2000 09:16:09 -0500461_ISO-8859-1 Adrian<br><br>One situation comes to mind where high-used-rba is of no use. It is when the tablespace or indexspace has been REORGed or LOAD REPLACEd with the PREFORMAT option. Either of these cause high-used-rba to be the same as high-alloc-rba.<br><br>Regards Mike Turner Email: michael_turner@compuserve.com Home Page: http://ourworld.compuserve.com/homepages/michael_turner<br><br>Message text written by DB2 Data Base Discussion List >Max, [...]
25635 21 20_Hardware Compression16_Dempsey, Michael20_MDempse@UNCH.UNC.EDU31_Thu, 13 Jan 2000 09:28:20 -0500392_iso-8859-1 Hey Folks... Our sytems people have asked what happens if we have hardware compressed tablespaces on RVA volumes. Evidently RVA technology compresses data also. They were wondering if the trade off of CPU overhead is worth doing the hardware compression on the tablespaces and just let the RVA technology compress it. Anyone have any bench marks or insight on this? Thanks... [...]
25657 25 24_Re: Hardware Compression14_Massimo Scarpa16_mscarpa@CESVE.IT31_Thu, 13 Jan 2000 15:37:54 +0100347_us-ascii IBM's experts say that if your CPU is away from 100% you can use both compression features.<br><br>Many people don't believe it and use only RVA compression.<br><br>In my experience if you have read only tables (mostly) you can use both, if more updated tables<br><br>than read-only and your CPU use is high, better RVA compression. [...]
25683 49 24_Re: Hardware Compression13_Adrian Savory24_adrian.savory@ZURICH.COM31_Thu, 13 Jan 2000 14:41:11 +0000811_us-ascii Michael,<br><br>Have a look at the 'Using RVA and Snapshot for Business Intelligence' redbook (SG24-5333-00), chapter 3.<br><br>Adrian Savory ACSIS Ltd<br><br><br><br><br><br><br><br><br><br>"Dempsey, Michael" <MDempse@UNCH.UNC.EDU> on 13/01/2000 14:28:20<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br>To: DB2-L@RYCI.COM cc: (bcc: Adrian Savory/ZI/England/Zurich)<br><br>Subject: Hardware Compression<br><br><br><br><br><br>Hey Folks... Our sytems people have asked what happens if we have hardware compressed tablespaces on RVA volumes. Evidently RVA technology compresses data also. They were wondering if the trade off of CPU overhead is worth doing the hardware compression on the tablespaces and just let the RVA technology compress it. Anyone have any bench [...]
25733 245 40_Re: Concurrence Between BATCH and ONLINE15_Toine Michielse18_vndobtm@US.IBM.COM31_Thu, 13 Jan 2000 15:33:37 +0000314_iso-8859-1 Hello,<br><br>> Again if the batch is processing the 1st row and it has declared the cursor and opened the cursor >accordingly mention by u then >above table says that all the 100 rows are having U-locks(Row level) and it should never allow the >100th row to be updated by the >online transaction. [...]
25979 47 24_Re: Hardware Compression9_Fox, Dave16_Dave_Fox@BMC.COM31_Thu, 13 Jan 2000 08:48:15 -0600421_ISO-8859-1 Remember also that RVA and similar DASD-based compression algorithms work on bit-streams with the goal of reducing the size of the block being transferred to/from the device. DB2 compression (using hardware assist or other mechanisms) work on the contents of DB2 pages with the goal of increasing the amount of data that can fit into a page. A combination of the two is ideal if you can spare the cycles. [...]
26027 203 40_Re: Concurrence Between BATCH and ONLINE13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Thu, 13 Jan 2000 09:17:32 -0600571_iso-8859-1 I just wanted to add one extra comment -- you mentioned the Application designer does not want to open the cursor at the first row in the event of contention problems, but just wants to write the failing-row out to a dataset for later processing. Remember that if you take a deadlock everything done since the last commit point is rolled back, not just the statement that took the deadlock. If they process 99 rows without a commit, take a -911 on record 100, and then just write record 100 out to a dataset for later processing, modifications to records [...]
26231 69 25_Re: FW: Space calculation19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 13 Jan 2000 09:28:25 -0600653_iso-8859-1 Mike, Wouldn't HIGH_USED_RBA be accurate in the case of a preformatted TS provided the HIGH_ALLOC_RBA was chosen correctly?<br><br>Regards, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying [...]
26301 24 17_DB2 V5 and TCP/IP16_Dempsey, Michael20_MDempse@UNCH.UNC.EDU31_Thu, 13 Jan 2000 10:35:32 -0500573_iso-8859-1 Hey Folks.. We're about to embark on a Web Enabled system going to DB2V5. Can someone who's done this before give me an idea if we're in the right direction? It's my assumptoin that we'l have to put the CAE on each client which will connect to DB2 Connect on a Web server, then connect to OM/390 (Unix services on OS/390), then talk to CICS to execute the stored procedures for data retrieval. If this is the right direction, can someone tell me what hardware their using for the middle tier (DB2 Connect). We're looking at approximately 600 user's. Thanks [...]
26326 216 11_Re: Explain14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Fri, 14 Jan 2000 02:31:47 +1000615_us-ascii >Date: Wed, 12 Jan 2000 09:41:41 +1000 >To: "Trivedi, Kaushal J, BGM" <kjtrivedi@ATT.COM> >From: Michael Hannan <mhannan@c031.aone.net.au> >Subject: Re: Explain > >Kaushal, > >Even without looking at the Explain at all, I can see a major problem with the SQL unless you are on DB2 V6 where it will auto rewrite your query behind the scenes to a better approach. > >Without bracketing and Nested Table Expressions, DB2 will execute your Left Outer Join (D to E) first before the other joins and before all of the where predicates and materialise the intermediate result set before joining to the other [...]
26543 97 33_Re: Multiple Counts & Outer Joins15_Philip, Sibimon19_PhilipS@SEALAND.COM31_Thu, 13 Jan 2000 10:50:42 -0500539_iso-8859-1 Thanks steve - I was confused about that count. I thought it will give a count on number of record in the child table. That would have been very nice. But this what I found.<br><br>I checked SQL server and the initial query works fine in SQLserver, but all the count returned will be the same based on the group by. So the query required only one count. In SQL server, if you specify count(*), it does a table space scan to find the count, but if we specify count(primary key field), then it uses primary index to find the [...]
26641 25 35_Using a INT field in 'where' clause13_Jaydeep Ghosh29_Jaydeep_Ghosh@PROGRESSIVE.COM31_Thu, 13 Jan 2000 10:50:32 -0500470_us-ascii A column ( SSN) is defined as INT . I want to use this column in the 'where' clause , to list records which have '123' as the first three position , like : Query : Select * from TABLE where substr(SSN,1,3) = '123'<br><br>Since SSN is defined as INT , SUBSTR does not work on it . One way is to convert it to DECIMAL , then CHAR and then do the SUBSTR . The results were not correct . Is there a way where I can use this column in the way I want to ? It is [...]
26667 57 21_Re: DB2 V5 and TCP/IP12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 13 Jan 2000 07:59:51 -0800423_us-ascii At my current client's site, they have a web server on an NT server with DB2 connect on the same server. Then each client (without CAE, just a browser) connects to the web server and then via DB2 connect to DB2.<br><br>In this particular case, the web server also invokes some code on the NT server which creates the SQL requests that are passed onto DB2. CICS is not involved in this particular application. [...]
26725 46 39_Re: Using a INT field in 'where' clause17_Kornblum, Kenneth24_Kenneth_Kornblum@BMC.COM31_Thu, 13 Jan 2000 10:09:36 -0600560_ISO-8859-1 Jaydeep,<br><br>How about:<br><br>where ssn between 123000000 and 123999999<br><br>Ken Kornblum BMC Software<br><br>-----Original Message----- From: Jaydeep Ghosh [mailto:Jaydeep_Ghosh@PROGRESSIVE.COM] Sent: Thursday, January 13, 2000 9:51 AM To: DB2-L@RYCI.COM Subject: [DB2-L] Using a INT field in 'where' clause<br><br><br><br>A column ( SSN) is defined as INT . I want to use this column in the 'where' clause , to list records which have '123' as the first three position , like : Query : Select * from TABLE where substr(SSN,1,3) = '123' [...]
26772 23 8_DSNTIAUL10_DB2 Review21_db2review@HOTMAIL.COM29_Thu, 13 Jan 2000 11:10:54 EST360_- We are attempting to understand and improve the the unload performance of DSNTIAUL - unloading a 30 Million row table (20 bytes per row) using 2:45 hours of c.p.u. and 3:45 elapsed.<br><br>The unload is done on a view which contains SQL mutiple case and cast statments. IBM has recommended trying H.P. Unload. Anyone have experience with this product ? [...]
26796 26 24_Re: Hardware Compression14_Massimo Scarpa16_mscarpa@CESVE.IT31_Thu, 13 Jan 2000 17:19:45 +0100395_us-ascii Yes, it is what I mean. Different kinds of compression, one on real data (DB2), one on RVA<br><br>disks work well toghether, as well as, for instance, DB2 compression and IDRC (LZ + arithmetic<br><br>adaptive technique) on tape or DB2 compression + HSM migration to ML2 (Huffman).<br><br>I think that in most cases the two compression types are 'out of phase' so they can do their [...]
26823 24 63_Using working storage variable on both side of the where clause8_madhavan16_madhavan@INF.COM31_Thu, 13 Jan 2000 20:41:30 +0530559_- Hi,<br><br>If I code the following where clause condition in a sql, will a table space scan be performed irrespective of other key column comparisions in the where clause?<br><br>select columns_value from some_table where :ws-variable-1 = :ws-variable-2 and table_key_column = :ws-key-value<br><br>regards Madhavan.<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
26848 93 39_Re: unavailable resource after dsn1copy15_Murley, Michael22_Michael_Murley@BMC.COM31_Thu, 13 Jan 2000 10:28:32 -0600549_ISO-8859-1 Mary Ann,<br><br>Yes, it would work in that environment.<br><br>Michael<br><br>-----Original Message----- From: Mary Ann Pickett [mailto:pickettm@DOT.STATE.AL.US] Sent: Wednesday, January 12, 2000 6:14 PM To: DB2-L@RYCI.COM Subject: Re: unavailable resource after dsn1copy<br><br><br><br>Michael,<br><br>I guess I wasn't clear in that even though we have production and test tables, they are both in the same subsystem. we separate them by specifing TEST.XXXX and PROD.XXXX.. Would the reset option work in this environment? Thanks, [...]
26942 29 39_Re: Using a INT field in 'where' clause14_Clayton, Colin21_Colin_Clayton@BMC.COM31_Thu, 13 Jan 2000 10:25:24 -0600657_ISO-8859-1 Jaydeep,<br><br>try the DIGITS function e.g.<br><br>SELECT COLINT FROM INTCXC.TBPART10 WHERE SUBSTR(DIGITS(COLINT),1,9) = '000000025' ---------+---------+---------+---------+---------+-- ---------+---------+---------+---------+---------+-- COLINT ---------+---------+---------+---------+---------+-- 257 258 259 NUMBER OF ROWS SELECTED 3<br><br><br><br>Opinions my own (for what they are worth etc......)<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
26972 79 24_Re: Hardware Compression14_Maxfield, John21_John_Maxfield@BMC.COM31_Thu, 13 Jan 2000 10:30:10 -0600512_ISO-8859-1 Dave raises a good point.<br><br>Part of the objective with DB2 compression is to reduce the number of pages required to store data. If DB2 compression does not increase the number of rows per page, there is no benefit in compressing the page set.<br><br>Another benefit of DB2 compression is that pages are transferred to DB2 buffer pools compressed. Once in the buffer pool, rows are decompressed as they are accessed. So, DB2 gives you the benefit of saving space in the buffer pools as well. [...]
27052 117 39_Re: unavailable resource after dsn1copy16_Duane Lee - ATCX22_DLee@MAIL.MARICOPA.GOV31_Thu, 13 Jan 2000 09:30:37 -0700609_- Remember to RECOVER/REBUILD any indexes associated with the copied tables as well.<br><br>Duane<br><br>> -----Original Message----- > From: Ball, Linda [SMTP:Linda_Ball@BMC.COM] > Sent: Wednesday, January 12, 2000 5:31 PM > To: DB2-L@RYCI.COM > Subject: Re: unavailable resource after dsn1copy > > The RESET would have done it. Now that the DSN1COPY is done, the REPAIR > LEVELID will do it, too. RESET sets all Log Point (RBA, LRSN) values. > REPAIR LEVELID just one, in the header, that's triggering your message. > > Including RESET in the DSN1COPY will avoid this problem in the future. > > LB > > [...]
27170 51 24_Re: Hardware Compression12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Thu, 13 Jan 2000 08:33:23 PST575_- Michael:<br><br>I would suggest still using db2 Data compression because it would bring you a lot of advantages that RVA can't. Some of these advantages are the reduction of space usage in the buffer pool, you can move a lot data with the minimal I/O posible, those pages will remain compresessed in the buffer pool and selected rows are descompressed before they are passed to the aplication. Other advantage is the high hit ratio in the buffer pool. You can keep more data there and it means more get pages resolves into the buffer pool without I/O. I think another [...]
27222 43 39_Re: Using a INT field in 'where' clause13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Thu, 13 Jan 2000 10:32:04 -0600419_US-ASCII Jaydeep, You can use SUBSTR(DIGITS(SSN),1,3) = '123' **WARNING this is NOT indexable.** HTH Kurt<br><br><br><br><br><br>>>> Jaydeep Ghosh <Jaydeep_Ghosh@PROGRESSIVE.COM> 01/13/00 09:50AM >>> A column ( SSN) is defined as INT . I want to use this column in the 'where' clause , to list records which have '123' as the first three position , like : Query : Select * from TABLE where substr(SSN,1,3) = '123' [...]
27266 41 67_Re: Using working storage variable on both side of the where clause9_Sally Mir16_smir@BCBS-GA.COM31_Thu, 13 Jan 2000 11:40:19 -0500543_us-ascii I'm sure you'll get a barrage of replies on this one, but here's mine:<br><br>You DON'T want to do this. Use IF logic in your program for host variable comparisons. In DB2, this predicate is Stage 2, which means it will be performed once for each row that is qualified by applying the other predicates first. If the comparison of the two host variables is false, then you have just made DB2 go through all of that for no reason (and go through it multiple times as well), when a simple check of it once in the program could have [...]
27308 33 25_Re: FW: Space calculation11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Thu, 13 Jan 2000 11:43:04 -0500309_ISO-8859-1 Rick<br><br>If you picked PRIQTY to be exactly what is needed for your data, then I guess that would be true. However I always allow some spare space to be on the safe side. Also, PREFORMAT is only useful when you have a lot of INSERTs to a table. In that case, what is the 'correct' PRIQTY?? [...]
27342 42 24_Re: Hardware Compression11_rick creech18_ykcirc@HOTMAIL.COM29_Thu, 13 Jan 2000 08:47:13 PST696_- There is a red book that recommends using db2 compression along with rva compression. see sg24-5333-00. Regards, Rick<br><br><br><br>>From: "Dempsey, Michael" <MDempse@UNCH.UNC.EDU> >Reply-To: DB2 Data Base Discussion List <DB2-L@RYCI.COM> >To: DB2-L@RYCI.COM >Subject: Hardware Compression >Date: Thu, 13 Jan 2000 09:28:20 -0500 > >Hey Folks... > Our sytems people have asked what happens if we have hardware >compressed >tablespaces on RVA volumes. Evidently RVA technology compresses data also. >They were wondering if the trade off of CPU overhead is worth doing the >hardware compression on the tablespaces and just let the RVA technology >compress it. Anyone have any bench marks or [...]
27385 42 25_Oracle Unix to DB2 OS/39022_BUECHLER, LINDA (SWBT)21_lb9533@MOMAIL.SBC.COM31_Thu, 13 Jan 2000 10:50:14 -0600592_iso-8859-1 Seeking the wisdom of folks familiar with porting applications from Oracle/Unix to DB2 OS/390, specifically in the area of database design: To use varchar or not. My background is almost entirely mainframe.<br><br>In the UNIX world it appears that use of varchar fields is quite common and not a big deal. In the DB2 OS/390 world, varchar columns are avoided (if possible) for a variety of reasons. In looking at the proposed DDL of tables being moved from Oracle to DB2 OS/390, I see a pattern of converting the tables column by column exactly as they are defined in Oracle. [...]
27428 28 25_Revoking sysadm authority0_27_mamccormack@STATESTREET.COM31_Thu, 13 Jan 2000 12:04:56 -0500451_US-ASCII We have the need to revoke sysadm authority from a userid. The cascading revoke of authorities it has granted will be a problem. We want to keep those other authorities in place.<br><br>I recall reading on this list in the past that the following is possible: 1. Change DSNZPARM to make the userid in question an Install Sysadm. 2. Revoke sysadm from userid in question. 3. Change DSNZPARM again to remove that userid as Install Sysadm. [...]
27457 43 39_Re: Using a INT field in 'where' clause14_McCombs, Terry20_tmccomb@SEDGWICK.GOV31_Thu, 13 Jan 2000 11:10:04 -0600520_US-ASCII Would BETWEEN 123000000 and 123999999 work?<br><br><br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Jaydeep Ghosh Sent: Thursday, January 13, 2000 9:51 AM To: DB2-L@RYCI.COM Subject: Using a INT field in 'where' clause<br><br><br><br>A column ( SSN) is defined as INT . I want to use this column in the 'where' clause , to list records which have '123' as the first three position , like : Query : Select * from TABLE where substr(SSN,1,3) = '123' [...]
27501 26 44_Address Spaces for DDF and Stored Procedures0_27_mamccormack@STATESTREET.COM31_Thu, 13 Jan 2000 12:14:01 -0500322_US-ASCII We have a couple of DB2 for OS/390 v5 test subsystems where we use neither DDF nor stored procedures.<br><br>I seem to recall a topic on this list (perhaps as long ago as a few years) of a method to avoid starting a DDF address space where it won't be used. Can someone refresh my memory on how to do this ? [...]
27528 137 29_Re: Revoking sysadm authority13_Brunner Don J24_Don.J.Brunner@M1.IRS.GOV31_Thu, 13 Jan 2000 12:14:46 -0500346_iso-8859-1 It is the correct procedure and I've successfully used it. Just be sure that the reassembled ZPARM module being used during the revoke is in the correct library used by DB2. I mention that because we run DB2 from different load libraries than the SMPE ones. After assembly we copy the new ZPARM member to the appropriate library. [...]
27666 53 29_Re: Revoking sysadm authority13_Colin Dickens34_Colin.Dickens@CCMAIL.EU.SONY.CO.JP31_Thu, 13 Jan 2000 17:16:17 +0000482_ISO-8859-1 Yes,<br><br><br><br>This is the way to remove old SYSADM's.<br><br>A tip for the future is to use Secondary or Group Auth-Ids to create, grant authorisations in DB2. You do not then have the problem when revoking SYSADM for DBA's etc.<br><br><br><br>Colin Dickens<br><br><br><br>______________________________ Reply Separator _________________________________ Subject: Revoking sysadm authority Author: mamccormack@STATESTREET.COM at Internet Date: 1/13/00 12:04 PM [...]
27720 59 25_Re: FW: Space calculation19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 13 Jan 2000 11:19:02 -0600632_iso-8859-1 Mike, You're not allowed to ask that question, NOBODY EVER KNOWS the answer!!!!!<br><br>;~) Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly [...]
27780 42 12_Re: DSNTIAUL22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Thu, 13 Jan 2000 17:20:56 +0000449_ISO-8859-1 what about reorg unload only?<br><br>Leslie<br><br><br><br>______________________________ Reply Separator _________________________________ Subject: DSNTIAUL Author: DB2 Review <db2review@HOTMAIL.COM> at Internet Date: 1/13/00 11:10 AM<br><br><br><br>We are attempting to understand and improve the the unload performance of DSNTIAUL - unloading a 30 Million row table (20 bytes per row) using 2:45 hours of c.p.u. and 3:45 elapsed. [...]
27823 134 48_Re: Address Spaces for DDF and Stored Procedures13_Brunner Don J24_Don.J.Brunner@M1.IRS.GOV31_Thu, 13 Jan 2000 12:24:24 -0500552_iso-8859-1 Update ZPARM DDSTART, set to NO.<br><br>Via the Installation/Update panels (select option 26, you'll then see the following):<br><br>DDF STARTUP OPTION ===> AUTO NO, AUTO, or COMMAND<br><br><br><br><br><br>-----Original Message----- From: mamccormack@STATESTREET.COM [mailto:mamccormack@STATESTREET.COM] Sent: Thursday, January 13, 2000 12:14 PM To: DB2-L@RYCI.COM Subject: Address Spaces for DDF and Stored Procedures<br><br><br><br>We have a couple of DB2 for OS/390 v5 test subsystems where we use neither DDF nor stored procedures. [...]
27958 40 48_Re: Address Spaces for DDF and Stored Procedures13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Thu, 13 Jan 2000 11:34:17 -0600334_US-ASCII Hello Mark, You can set DDF=NO in ZPARM to disable startup of DDF. If the STORPROC=XXXXSPAS in ZPARM is not in your proclib it will not start. Kurt<br><br><br><br>>>> <mamccormack@STATESTREET.COM> 01/13/00 11:14AM >>> We have a couple of DB2 for OS/390 v5 test subsystems where we use neither DDF nor stored procedures. [...]
27999 30 67_Re: Using working storage variable on both side of the where clause10_Bill Brown25_bill_brown@SPRINGMAIL.COM31_Thu, 13 Jan 2000 12:37:03 -0500404_- It would be more efficient to perform the an if statement prior to the SELECT and not perform the SQL statement if the condition is not met.<br><br>On Thu, 13 Jan 2000 20:41:30 +0530 madhavan <madhavan@INF.COM> wrote:<br><br>Hi,<br><br>If I code the following where clause condition in a sql, will a table space scan be performed irrespective of other key column comparisions in the where clause? [...]
28030 66 27_Changing to CURRENTDATA(NO)0_18_cmunson@US.IBM.COM31_Thu, 13 Jan 2000 10:59:44 -0700625_us-ascii Kevin, There has been much discussion and a lot of confusion on the CURRENTDATA parameter. I hope the following doesn't further confuse the issue but here is the deal. This parameter basically deals with lock avoidance. With CURRENTDATA(YES), you only get lock avoidance on the rows that do not qualify your search criteria. With CURRENTDATA(NO) you MIGHT get lock avoidance on rows that do qualify. Here are my recommendations on CURRENTDATA(NO) - in a nutshell, use it. First for read only plans/packages, it is a no brainer - the only behavior difference with CURRENTADATA deals with updating data. The only [...]
28097 88 31_Re: Changing to CURRENTDATA(NO)0_20_John_Lendman@FPL.COM31_Thu, 13 Jan 2000 13:05:39 -0500757_us-ascii Thanks Chris for this very clear explaination of CURRENTDATA. John<br><br><br><br><br><br><br><br>cmunson@US.IBM.COM on 01/13/2000 12:59:44 PM<br><br>Please respond to "DB2 Data Base Discussion List" <DB2-L@RYCI.COM><br><br>To: DB2-L@RYCI.COM cc: Subject: Changing to CURRENTDATA(NO)<br><br><br><br><br><br><br><br>Kevin, There has been much discussion and a lot of confusion on the CURRENTDATA parameter. I hope the following doesn't further confuse the issue but here is the deal. This parameter basically deals with lock avoidance. With CURRENTDATA(YES), you only get lock avoidance on the rows that do not qualify your search criteria. With CURRENTDATA(NO) you MIGHT get lock avoidance on rows that do qualify. Here are my recommendations [...]
28186 25 39_seeking help -904 -resource unavailable15_Narasim Narayan24_Narasim_Narayan@GLIC.COM31_Thu, 13 Jan 2000 14:11:34 -0500319_us-ascii Hi,<br><br>There is an increase in the number of these -904s and they all point to packages (resource 801- not always the same package)<br><br>There are no binds being done at the time these abends are occurring.<br><br>Can you please shed some some light why a package as resource would not be available [...]
28212 58 21_Re: DB2 V5 and TCP/IP0_15_leon@CA.IBM.COM31_Thu, 13 Jan 2000 14:12:45 -0500567_us-ascii Michael, congratulations on making the move in the right direction. The best part of going with the web-based applications is half of hte components and complexity that you are describing in your post is not needed. Here are the pieces that you will need in to run the application in production: - DB2 for OS/390 with DDF turned on (and set at the proper priority). You will NOT need CICS or UNIX services on the OS/390 side. - DB2 Connect server(s) running on Windows NT, Windows 2000 or UNIX server. Typically you would want DB2 Connect to run on the [...]
28271 51 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.13_Tierney, Mark20_mtierney@FIRSTAM.COM31_Thu, 13 Jan 2000 13:37:34 -0600592_- Hi Jim,<br><br>I'd love a copy....<br><br>TIA, Mark<br><br>> -----Original Message----- > From: Jim Lewandowski [SMTP:jlewand@STARNETINC.COM] > Sent: Tuesday, January 11, 2000 10:09 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and > Index spa ces. > > I had sent out many copies of an SMF 42 subtype 6 REXX that provided a > detail and summary of I/O response times (and their components) for > each table/indexspace for a DB2 DBM1 subsystem. Anyone else interested > in this? > > Jim Lewandowski > > > > Galambos, Robert wrote: > > > > Chuck [...]
28323 40 43_Re: seeking help -904 -resource unavailable10_Fritz Rapp21_FritzRapp@T-ONLINE.DE31_Thu, 13 Jan 2000 20:30:54 +0100513_ISO-8859-1 Hi Narasim, do you have a reason code that could help to specify the problem? Fritz Narasim Narayan schrieb: > Hi, > > There is an increase in the number of these -904s and they all point to > packages > (resource 801- not always the same package) > > There are no binds being done at the time these abends are occurring. > > Can you please shed some some light why a package as resource would not be > available > > Can you please direct me to the areas which would require more scrutiny > > TIA [...]
28364 88 43_Re: seeking help -904 -resource unavailable15_Narasim Narayan24_Narasim_Narayan@GLIC.COM31_Thu, 13 Jan 2000 14:59:57 -0500712_us-ascii <br><br><br><br>Hi Fritz, Thank you for response... the reason code is always 00C90090 and the resource is 801- package Thanks Narasim<br><br><br><br><br><br><br><br>Fritz Rapp <FritzRapp@T-ONLINE.DE> on 01/13/2000 02:30:54 PM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br>To: DB2-L@RYCI.COM cc: (bcc: Narasim Narayan/TheGuardian) Subject: Re: seeking help -904 -resource unavailable<br><br><br><br><br><br>Hi Narasim, do you have a reason code that could help to specify the problem? Fritz Narasim Narayan schrieb: > Hi, > > There is an increase in the number of these -904s and they all point to > packages > (resource 801- not always the same package) > > There [...]
28453 30 31_Debugging DB2 Stored Procedures9_Chu, Pius14_ChuP@CONED.COM31_Thu, 13 Jan 2000 15:14:42 -0500410_- We've been trying to make sense of the product packaging required for debugging DB2 Stored Procedures. The RedBook "Getting Started with DB2 Stored Procedures" goes into CODE/370 as the methodology. CODE/370 appears to consist of 2 products: The Debug Tool (that runs on OS/390), and the Workstation part that runs on OS/2. We don't use OS/2 any more, and there is no mention of NT workstation support. [...]
28484 15 45_Multiple Column Updates in a Single Case Stmt0_27_Charlotte_Hamilton@FFIC.COM31_Thu, 13 Jan 2000 11:58:14 -0800451_us-ascii Dear Listers, Is it possible to update multiple columns within a single CASE statement? What would the update statement look like? I'm having trouble specifying more than one column in the SET phrase.<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
28500 42 49_Re: Multiple Column Updates in a Single Case Stmt16_Robert Blackwell31_robert.blackwell@PIEDMONTNG.COM31_Thu, 13 Jan 2000 16:03:09 -0500711_us-ascii Below are parts of one that compacts a composite address.<br><br>UPDATE MK1.TBMKEXA3 SET ADDRESS = CASE WHEN SUBSTR(ADDRESS,16,21) = ' ' THEN SUBSTR(ADDRESS,01,15) CONCAT SUBSTR(ADDRESS,37,04) WHEN SUBSTR(ADDRESS,17,20) = ' ' THEN SUBSTR(ADDRESS,01,16) CONCAT SUBSTR(ADDRESS,37,04) ............................ ........................... ELSE ADDRESS END ,CITY_STATE = CASE WHEN SUBSTR(CITY_STATE,04,13) = ' ' THEN SUBSTR(CITY_STATE,01,03) CONCAT SUBSTR(CITY_STATE,17,04) WHEN SUBSTR(CITY_STATE,05,12) = ' ' THEN SUBSTR(CITY_STATE,01,04) CONCAT SUBSTR(CITY_STATE,17,04) ....................................... .................................... ELSE CITY_STATE END ,UF1 = '1' WHERE UF1 = ' ' ; [...]
28543 58 27_Distributed protocol errors16_Cockerill, Steve30_SLCockerill@NATIONALGYPSUM.COM31_Thu, 13 Jan 2000 16:06:04 -0500361_iso-8859-1 Hello,<br><br>We have a problem which escapes us at this time, does anyone have a clue. A new subsys was put up, Production Peoplesoft Financials database is being installed. The Development subsystem is running ok.<br><br>We have the database on OS390, NT app server is used, we use DB2Connect, this is the first database in the new subsystem. [...]
28602 11 20_Visual Explain Setup11_Tom Johnson25_new_to_db2@SPRINGMAIL.COM31_Thu, 13 Jan 2000 15:09:27 -0500353_- I just had my first opportunity to use Visual Explain. I have installed DB2 connect and I connect to the mainframe ok. When I go into VE and try to add a subsystem I put in a meaningful name for my subsystem nickname, but don't know what to put in database alias or where to look for the information. Any help would be appreciated from a newbie. [...]
28614 57 43_HELP ON UNAVAILABLE RESOURCE AFTER DSN1COPY16_Mary Ann Pickett24_pickettm@DOT.STATE.AL.US31_Thu, 13 Jan 2000 16:00:36 -0600154_iso-8859-1 THANKS TO ALL WHO GAVE ADVICE ON THIS PROBLEM. RUNNING DSN1COPY WITH THE RESET OPTION WORKED.<br><br>MARY ANN PICKETT DBA ALDOT<br><br><br><br>
28672 66 24_Re: Hardware Compression14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Fri, 14 Jan 2000 09:06:06 +1000725_us-ascii There is a Red Book specifically on DB2 Data Compression with and without RVA Hardware compression. It is not the one mentioned below.<br><br>Can be downloaded from IBM Web page.<br><br>From: Michael Hannan<br><br>>From: Adrian Savory <adrian.savory@ZURICH.COM> >Subject: Re: Hardware Compression >To: DB2-L@RYCI.COM > >Michael, > >Have a look at the 'Using RVA and Snapshot for Business Intelligence' redbook >(SG24-5333-00), chapter 3. > >Adrian Savory >ACSIS Ltd > > > > > >"Dempsey, Michael" <MDempse@UNCH.UNC.EDU> on 13/01/2000 14:28:20 > >Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM> > >To: DB2-L@RYCI.COM >cc: (bcc: Adrian Savory/ZI/England/Zurich) > >Subject: Hardware Compression > [...]
28739 42 8_DSNTIAUL14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Fri, 14 Jan 2000 09:15:02 +1000650_us-ascii With DSNTIAUL, your performance is governed by the SQL you are using and its access path. So need normal tuning of the SQL first.<br><br>Perhaps the SQL could be written more efficiently.<br><br>Just another option.<br><br>From: Michael Hannan<br><br>>From: DB2 Review <db2review@HOTMAIL.COM> >Subject: DSNTIAUL >To: DB2-L@RYCI.COM > >We are attempting to understand and improve the the unload performance of >DSNTIAUL - unloading a 30 Million row table (20 bytes per row) using 2:45 >hours of c.p.u. and 3:45 elapsed. > >The unload is done on a view which contains SQL mutiple case and cast >statments. IBM has recommended trying H.P. [...]
28782 38 24_Re: Visual Explain Setup13_Bruce Cornell23_bcornel@DOA.STATE.LA.US31_Thu, 13 Jan 2000 16:29:24 -0600574_us-ascii The Database Alias in Visual Explain is the same one that was created in DB2 Connect when the connections were set up. If you used the Client Configuration Assistant to create your connections, you can start it and the Database Alias will be on the first screen displayed.<br><br>Bruce<br><br>At 03:09 PM 1/13/2000 -0500, Tom Johnson wrote: >I just had my first opportunity to use Visual Explain. I have installed DB2 connect and I connect to the mainframe ok. When I go into VE and try to add a subsystem I put in a meaningful name for my subsystem nickname, [...]
28821 28 30_Long Term Contract in Illinois11_Chris Beaty20_cbeaty@EARTHLINK.NET31_Thu, 13 Jan 2000 15:42:46 -0800301_iso-8859-1 Our client in Bloomington Illinois is seeking a DB2 UDB DBA with NT experience. This is a one year contract with the opportunity for extensions. This is for an implementation of DB2 UDB for NT. H-1B's and Corp to Corp are welcome. For details please use the contact information below. [...]
28850 45 68_Re: Using working storage variable on both side of the where clau se14_Purcell, Terry37_Terry.Purcell@CORPMAIL.TELSTRA.COM.AU31_Fri, 14 Jan 2000 10:34:06 +1100604_- No, the ":ws1 = :ws2" clause will treated as any other stage 2 predicate.<br><br>Regards Terry Purcell CPT Consulting<br><br>> -----Original Message----- > From: madhavan [SMTP:madhavan@INF.COM] > Sent: Friday, 14 January 2000 2:12 am > To: DB2-L@RYCI.COM > Subject: Using working storage variable on both side of the where > clause > > Hi, > > If I code the following where clause condition in a sql, will a table > space > scan be performed irrespective of other key column comparisions in the > where > clause? > > select columns_value from some_table > where > :ws-variable-1 = :ws-variable-2 [...]
28896 101 39_Re: Using a INT field in 'where' clause0_29_Greg.Palgrave@BANKWEST.COM.AU31_Fri, 14 Jan 2000 08:31:05 +0800398_us-ascii I think what Jaydeep is looking for is a list of all records *starting* with '123',<br><br>e.g. 1234 123456 123456789<br><br>and I don't think it is easy to do in SQL. DIGITS function puts leading zeroes, so makes it hard to find.<br><br>I guess you could use<br><br>BETWEEN 1230 and 1239 OR BETWEEN 12300 and 12399 OR BETWEEN 123000 and 123999 OR BETWEEN 1230000 and 1239999 etc.... [...]
28998 126 39_Re: Using a INT field in 'where' clause14_Purcell, Terry37_Terry.Purcell@CORPMAIL.TELSTRA.COM.AU31_Fri, 14 Jan 2000 11:57:47 +1100656_- If that's the case then a combination of DIGITS, STRIP & SUBSTR should do the trick:<br><br>where SUBSTR(STRIP(DIGITS(SSN),L,'0'),1,3) = '123'<br><br>Again, not real elegant for performance, as it's not indexable and stage 2.<br><br>Regards, Terry Purcell CPT Consulting<br><br>> -----Original Message----- > From: Greg.Palgrave@BANKWEST.COM.AU [SMTP:Greg.Palgrave@BANKWEST.COM.AU] > Sent: Friday, 14 January 2000 11:31 am > To: DB2-L@RYCI.COM > Subject: Re: Using a INT field in 'where' clause > > I think what Jaydeep is looking for is a list of all records *starting* > with '123', > > e.g. 1234 123456 123456789 > > and I don't think it is easy [...]
29125 135 39_Re: Using a INT field in 'where' clause0_29_Greg.Palgrave@BANKWEST.COM.AU31_Fri, 14 Jan 2000 09:34:41 +0800626_us-ascii Yes, that's a better way - I forgot about the STRIP function in V5...<br><br>Cheers, Greg<br><br><br><br>---------------------------------------- Message History ----------------------------------------<br><br><br><br>From: "Purcell, Terry" <Terry.Purcell@CORPMAIL.TELSTRA.COM.AU> on 14/01/2000 08:57<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br>To: DB2-L@RYCI.COM cc: (bcc: Greg Palgrave/SDG/SS/BankWest)<br><br>Subject: Re: Using a INT field in 'where' clause<br><br><br><br><br><br><br><br>If that's the case then a combination of DIGITS, STRIP & SUBSTR should do the trick: [...]
29261 28 12_DB2 STO PROC25_Srirengan Venkatesh Kumar42_SRIRENGAN_VENKATESH_KUMAR/IRAS@IRAS.GOV.SG29_Fri, 14 Jan 2000 01:48:16 GMT355_us-ascii Hi,<br><br>I have one Db2 subsystem used for both development and production purposes. I am runing v5 env. If I develop a stored procedure how to test the procedure while there is one running in production (without calling it by another name). Can I use some version concept so that developers can still test while production env is stable. [...]
29290 57 35_unavailable resource after dsn1copy12_Dennis Raher27_Dennis_Raher@COMPUSERVE.COM31_Thu, 13 Jan 2000 21:01:48 -0500629_ISO-8859-1 The problem isn't the segmented tablespace but rather that you probably forgot the needed parameter to reset the level. One additional point that I will pass along deals with using DSN1COPY with compressed tablespaces. I recently had to recover a number of them to a test environment and it required starting with a full image copy and then applying several incrementals. This should be straight forward with DSN1COPY but it wasn't. The full copies applied fine, but the incrementals kept getting OBID translation errors, even though the same translation cards were being used. I finally got the answer from IBM. [...]
29348 73 27_Stopping multi index access12_Dennis Raher27_Dennis_Raher@COMPUSERVE.COM31_Thu, 13 Jan 2000 21:01:47 -0500575_ISO-8859-1 Hi Terry and Sanjeev<br><br>I wrote earlier about a query that was using multi-index access and was wondering about how to disable it, and I appreciate the input from both of you. Here's the results. After looking over your comments, it occurred to me that I really needed to determine if the multi-index really was the culprit or not. I eliminated the smaller table from the query and while the single table query still used the same access, the performance was very good, which led me to believe that wasn't the heart of the problem. It really was the fact [...]
29422 21 34_REXX for DB2 V6 beta now available14_Campbell James30_James.Campbell@ENERGYIS.COM.AU31_Fri, 14 Jan 2000 14:31:24 +1000427_us-ascii see http://www6.software.ibm.com/dl/os390/rls-p<br><br>/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9840 3864 james.campbell@energyis.com.au<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
29444 19 51_FAROFFPOSF info for an index in Platinum Statistics9_Paul Yuen16_pyuen@GIO.COM.AU31_Fri, 14 Jan 2000 14:57:09 +1000516_us-ascii Hi all, I'm wondering where the equivalent of FAROFFPOSF (SYSINDEXPART) is kept in PDA, as the DB2 statistics from the last runstats shows a very large amount of FAROFFPOSF in an NPI, I'd like reorg be triggered off based on that the FAROFFPOS/CARDF ratio. TIA Paul<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
29464 14 39_seeking help -904 -resource unavailable28_Dan Courter (1-408-463-3870)27_daniel_courter@VNET.IBM.COM29_Thu, 13 Jan 2000 23:30:03 PST388_- The 00C90090 is a conditional lock failure. For the lock on the package to fail there must be BIND activity running for that package.<br><br>Dan<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
29479 83 31_Re: Stopping multi index access0_18_mebert@AMADEUS.NET31_Fri, 14 Jan 2000 09:41:28 +0100590_us-ascii We too have many problematic queries involving the join between a small "dimensions" table and a large "fact" table, where the small table is accessed first and joined by nested loop join to the large table. This type of access is common for DSS (datawarehouse) type queries so I'm somewhat surprised at DB2s problems with this. I seem to recall having heard the catchphrase "star schema enhancements" in connection to DB2 V6. Maybe someone of the insiders can tell whether this will solve (or improve on) the situation mentioned above, and what exactly are the enhancements? [...]
29563 57 55_Re: FAROFFPOSF info for an index in Platinum Statistics0_18_mebert@AMADEUS.NET31_Fri, 14 Jan 2000 09:49:54 +0100378_us-ascii There has been a discussion about this just one or two weeks ago on this list... NEAROFFPOSF and FAROFFPOSF have meaning (with regards to REORGing) ONLY for the clustering index, not for NPIs (the Utility Guide mentions this, but in an extremely obscure manner).<br><br>Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany [...]
29621 26 25_Re: FW: Space calculation11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Fri, 14 Jan 2000 04:15:45 -0500599_ISO-8859-1 Oh good! I thought it was just me that didn't know.<br><br>Regards Mike Turner Email: michael_turner@compuserve.com Home Page: http://ourworld.compuserve.com/homepages/michael_turner<br><br>Message text written by DB2 Data Base Discussion List >Mike, You're not allowed to ask that question, NOBODY EVER KNOWS the answer!!!!!<br><br>;~) Rick Davis<<br><br>===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
29648 69 31_Re: Stopping multi index access11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Fri, 14 Jan 2000 04:50:50 -0500560_ISO-8859-1 Michael<br><br>I am not an insider, but I am currently deep into the V6 Performance Red Book. It has this to say about 'star join':<br><br>"DB2 sometimes uses the so-called 'early Cartesian product' technique. It first joins the dimension tables, even though the user did not explicitly code any predicates to join the dimension tables together, before accessing the fact table. In previous releases, DB2 was limited to join 5 dimension tables into a composite table before accessing the facts table. With DB2 V6 this limit is increased to 6." [...]
29718 79 43_Re: seeking help -904 -resource unavailable9_Jim Leask27_jim.leask@RS-COMPONENTS.COM31_Fri, 14 Jan 2000 10:33:02 -0000435_iso-8859-1 Narasim,<br><br>Could it be that automatic rebinds are taking place as the package is invalid. You can check for invalid packages using the following select.<br><br>SELECT * FROM SYSIBM.SYSPACKAGE WHERE VALID = 'N' ;<br><br>Jim.<br><br>-----Original Message----- From: Narasim Narayan [mailto:Narasim_Narayan@GLIC.COM] Sent: 13 January 2000 20:00 To: DB2-L@RYCI.COM Subject: Re: seeking help -904 -resource unavailable [...]
29798 28 38_Turning Correlated Subqueries to Views13_Philip Nelson24_philip@PANDP.SALTIRE.ORG31_Fri, 14 Jan 2000 11:14:48 +0000433_us-ascii Can anyone point me at some good documentation on how to turn a complex multi-level correlated subquery into a join.<br><br>I've got a very badly performing three stage correlated subquery with a scalar function at one of the levels and want to try to improve its performance.<br><br>I'll be adding indexes anyway, and wondered if it's actually worth the (not inconsiderable) effort of trying to get the SQL rewritten. [...]
29827 18 40_CURRENTDATA replies truncated from email0_22_kmulcahy@CHECKFREE.COM31_Fri, 14 Jan 2000 07:44:24 -0500353_us-ascii I sent in a question earlier this week about changing CURRENTDATA from YES to NO. I see by the numbered lists at the top of the emails Thursday and Friday that there have been replies but they are not included in the body of the email I received. If anyone has received these replies I would appreciate it if you would forward them to me. [...]
29846 38 23_Re: CHAR column problem24_Marchese, Frank D, CSCIO18_fdmarchese@ATT.COM31_Fri, 14 Jan 2000 08:42:00 -0500560_iso-8859-1 Hi - I recently bumped into a problem and wondering if anyone else has experienced it. An SQL Select that had a simple WHERE clause (WHERE C_TRAN = 'TTA') returned no rows when an unqualified SELECT showed that many rows satisfied this condition. The C_TRAN column is defined as CHAR(3) and non-nullable. It is one column in a 5 column composite index. C_TRAN is the first column of the index. We are running DB2 V5 on OS/390. I tried WHERE C_TRAN LIKE 'TTA%' - that returned the correct rows. I tried WHERE C_TRAN = 'TTA ' - and that returned [...]
29885 199 25_Re: FW: Space calculation14_Grainger, Phil21_Phil.Grainger@CAI.COM31_Fri, 14 Jan 2000 13:43:18 -0000661_iso-8859-1 Also,<br><br>Don't forget there's a new option on Load in V6 (or V5??) to preformat pages in the first extent allocation - I assume that use of this would lead the hi-rba to look like the tablespace was full<br><br>Phil Grainger Director DB2 Operations, Europe Computer Associates International<br><br><br><br>> -----Original Message----- > From: Adrian Savory [SMTP:adrian.savory@ZURICH.COM] > Sent: Thursday, January 13, 2000 11:09 AM > To: DB2-L@RYCI.COM > Subject: Re: FW: Space calculation > > Max, > > A number of people including yourself have advocated the use of Listcat > information for space calculation of DB2 objects. The question [...]
30085 102 53_Re: Extracting table level info from DB2 Recovery log14_Grainger, Phil21_Phil.Grainger@CAI.COM31_Fri, 14 Jan 2000 13:43:57 -0000637_- and, don't forget - As soon as you encounter data sharing, things just got (potentially) 32 times more complicated!!!<br><br>Phil G<br><br>PS and IBM don't announce when they are changing log record formats and it DOESN'T just happen with new releases......<br><br>> -----Original Message----- > From: Colin Dickens [SMTP:Colin.Dickens@CCMAIL.EU.SONY.CO.JP] > Sent: Tuesday, January 11, 2000 3:50 PM > To: DB2-L@RYCI.COM > Subject: Re: Extracting table level info from DB2 Recovery log > > Without the use of oem or IBM s/w products to process log data, you > are stepping into dangerous waters. Consider the following; > > > You [...]
30188 30 34_RACF Security for Web Applications13_Burgess Evans27_BMEVANS@AUDITOR.STATE.OH.US31_Fri, 14 Jan 2000 08:59:52 -0500584_US-ASCII We have future plans to develop an application that will run on OS/390 using DB2 UDB V5.0 for OS/390 and soon DB2 UDB V6 for OS/390, DB Connect, RACF, and Novell NetWare. There would be approximately 1000 - 1500 users accessing this system.<br><br>In a planning meeting, the subject of security came up. Currently we issue each new employee a sign-on and then assign them to a RACF group. This new application is not intended for employee use, it is intended for a specific group of known entities that will subscribe to this new application. Therefore we must devise a [...]
30219 81 23_Re: CHAR column problem15_Toine Michielse18_vndobtm@US.IBM.COM31_Fri, 14 Jan 2000 15:03:19 +0000390_us-ascii Hello Frank,<br><br>I suggest you compare code levels between TEST and PROD and see what maintenance is on TEST that is not yet on PROD. I have a REALLY quick scan and found a potential hit in PQ27186 describing a similar problem after UQ20576 is applied. Solved by UQ30617.<br><br>For more throrough analysis report the problem to your friendly IBM software support team.... [...]
30301 46 16_Re: DB2 STO PROC14_McCombs, Terry20_tmccomb@SEDGWICK.GOV31_Fri, 14 Jan 2000 08:11:10 -0600392_US-ASCII You can use the AUTHID column to allow the individual specified to execute a different version of the stored procedure with a different load module and collection.<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Srirengan Venkatesh Kumar Sent: Thursday, January 13, 2000 7:48 PM To: DB2-L@RYCI.COM Subject: DB2 STO PROC [...]
30348 39 38_Unable to treminate an UTILITY stopped14_Massimo Scarpa16_mscarpa@CESVE.IT31_Fri, 14 Jan 2000 15:18:28 +0100482_us-ascii It's may sound strange, but it happened...<br><br>We executed in our DB2 an utility, a reorg shrlevel none and this reorg ended with a return code 8, a space problem during reload phase. Utility was stopped and reimaned stopped for a 1 hour in RELOAD phase.<br><br>Meanwhile, a guy (me) dropped tablespace to be reorganized and create a new one, equal to the previous in attributes. Drop & created ended all ok. But the DB2 didn't realized were was a pending utility. [...]
30388 74 16_Re: DB2 STO PROC15_Toine Michielse18_vndobtm@US.IBM.COM31_Fri, 14 Jan 2000 15:23:04 +0000609_us-ascii Hello ....<br><br>I can see three options. Interested to hear other opinions.<br><br><br><br>Split TEST and PRODUCTION into tow different subsystems. In my opinion (if you have the resources) this is by far the best solution. It's not just for stored procedures but also for other forms of isolation that you may need. Maybe today, maybe in the future. The longer you wait with splitting.....the more work it will be in general. Give the TEST version a different loadmodule name and register the test version (in sysprocedures) with the authid and/or luname of the tester in such a way that the [...]
30463 34 13_Long varchars14_Winska, Krysia27_Krysia_Winska@THOMSON.CO.UK31_Fri, 14 Jan 2000 14:45:29 -0000513_- > We have a requirement to hold text on a DB2 table with max column length > of appx 3000 characters in one instance and two columns with the same > maximum in another table. > I have always understood it as best in terms of performance to avoid the > use of 32k bufferpools > but read the following in the DB2 Administration Guide: > DB2 provides a 32KB page size to allow for long records. You can > improve > performance by using 32KB pages for record lengths that are longer > than > 2028 bytes, as in [...]
30498 14 17_Re: Long varchars13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM31_Fri, 14 Jan 2000 20:32:08 +0530399_us-ascii When we specify the use of BP32 as the bufferpool , the unit of I/O will be escalated to 32K so u don't have to worry about 8 I/o's per record Vishy<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
30513 27 47_Cross reference of Table activity in programs??15_Michael Bancale21_mbancale@TXFB-INS.COM31_Fri, 14 Jan 2000 09:10:47 -0600404_iso-8859-1 We are beginning to grow in the use of DB2 and our scheduling crew would like to have a cross reference of the jobs which update/delete/insert and select from DB2 tables. We have written a COBOL program which will pass a COBOL program and Print the SQL from Exec to Exec. Are there any products out there which will provide a cross reference or are we better off trying to write our own? [...]
30541 65 17_Re: Long varchars15_Blaicher, Chris22_Chris_Blaicher@BMC.COM31_Fri, 14 Jan 2000 09:14:03 -0600432_ISO-8859-1 You are correct in your assumption that a 32K page is really made up of 8 4K pages, but it does not take 8 physical I/O's to do a read for it.<br><br>Media Manager (the I/O access method DB2 uses) can 'chain' (see Principles of Operations manual) the reads and writes for multiple blocks together so many blocks are read at one time. I have seen channel programs from media manager read a half a cylinder at a time. [...]
30607 68 23_Re: CHAR column problem19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Fri, 14 Jan 2000 09:16:35 -0600595_iso-8859-1 Frank, Another possibility here is that the index is missing entries. When the select uses the index it can't find certain entries, however, ts scan obviously does. Rebuild the index in question to see. HTH, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and [...]
30676 61 51_Re: Cross reference of Table activity in programs??9_Jim Leask27_jim.leask@RS-COMPONENTS.COM31_Fri, 14 Jan 2000 15:22:08 -0000528_iso-8859-1 Michael<br><br>If you use packages, you can perform the following SQL, after amending COLP to the collection name(s) you are interested in.<br><br>Jim.<br><br>SELECT GRANTEE AS PROGRAM, STNAME AS TABLE, DELETEAUTH, INSERTAUTH, SELECTAUTH, UPDATEAUTH FROM SYSIBM.SYSTABAUTH WHERE GRANTEETYPE = 'P' AND COLLID = 'COLP' ORDER BY 1,2 ;<br><br>SELECT STNAME AS TABLE, GRANTEE AS PROGRAM, DELETEAUTH, INSERTAUTH, SELECTAUTH, UPDATEAUTH FROM SYSIBM.SYSTABAUTH WHERE GRANTEETYPE = 'P' AND COLLID = 'COLP' ORDER BY 1,2 ; [...]
30738 79 42_Re: Unable to treminate an UTILITY stopped19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Fri, 14 Jan 2000 09:22:59 -0600584_iso-8859-1 Max, I've had a similar situation. The only way I could get rid of the entry(s) was to start DB2 in UT, make sure no utilities were executing, TERM'd all stopped utilities I could, IDCAMS delete/redefined SYSUTILX, and then started DB2 normal. HTH, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in [...]
30818 19 42_Re: Unable to treminate an UTILITY stopped14_Massimo Scarpa16_mscarpa@CESVE.IT31_Fri, 14 Jan 2000 16:32:00 +0100476_us-ascii Thanks Rick.<br><br>I was thinking the same thing, to correct the problem is the only action to do. You have to re-inizialize SYSUTIL, too. But first I'd like to try with a REPAIR on row.<br><br>THX again & Regards Max Scarpa<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
30838 88 23_Re: CHAR column problem0_19_Tim.Lowe@STPAUL.COM31_Fri, 14 Jan 2000 09:29:51 -0600430_us-ascii Frank, I have seen this problem many times in testing environments where LOAD RESUME is used. If the load abends before the build phase, then the index is not updated to reflect the new rows added by the load. I have then seen people then terminate the utility and do a start force to "fix" what they thought was the problem. The result is a tablespace and index that are not in sync. Is this possible in your case? [...]
30927 135 42_Re: Unable to treminate an UTILITY stopped12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Fri, 14 Jan 2000 07:33:47 PST479_- Massimo:<br><br>We had the same problem long time ago and the only way that we could find to fix it was executing a job that redefine the SYSUTILX. You can create a job to do it taking out what you need from the installation jobs DSNTIJIN and DSNTIJID which contain the JCL to create and initialize the Directory tablespaces and catalog tablespaces. Be sure that you just need the part to recreate and reinitialize the SYSUTILX. here is a copy below . I hope it help you. [...]
31063 15 42_Re: Unable to treminate an UTILITY stopped14_Massimo Scarpa16_mscarpa@CESVE.IT31_Fri, 14 Jan 2000 16:40:26 +0100355_us-ascii Is a DB2 stop/start really necessary ? Or is a STOP/START DSNDB01 sufficient ?<br><br>Regards Max Scarpa<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
31079 28 22_DBA Position Available13_penny andrews19_pzandrews@YAHOO.COM31_Fri, 14 Jan 2000 07:30:34 -0800470_us-ascii Hello...<br><br>There is a very nice DB2 DBA position available in Atlanta for a large financial institution, working with the UDB EEE product in a data warehousing environment.<br><br>If this sounds interesting, please send your resume to pzandrews@yahoo.com. All inquiries will be responded to.<br><br>Thanks!<br><br>__________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com [...]
31108 42 26_Re: DBA Position Available24_Marchese, Frank D, CSCIO18_fdmarchese@ATT.COM31_Fri, 14 Jan 2000 10:44:39 -0500432_iso-8859-1 Thanks but I am interested in NJ positions only.<br><br>-----Original Message----- From: penny andrews [mailto:pzandrews@YAHOO.COM] Sent: Friday, January 14, 2000 10:31 AM To: DB2-L@RYCI.COM Subject: DBA Position Available<br><br><br><br>Hello...<br><br>There is a very nice DB2 DBA position available in Atlanta for a large financial institution, working with the UDB EEE product in a data warehousing environment. [...]
31151 34 42_Re: Unable to treminate an UTILITY stopped12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Fri, 14 Jan 2000 07:48:02 PST661_- Massimo<br><br>Is just enough stop the SYSUTILX tablespace and the indexes tablespaces .<br><br>>From: Massimo Scarpa <mscarpa@CESVE.IT> >Reply-To: DB2 Data Base Discussion List <DB2-L@RYCI.COM> >To: DB2-L@RYCI.COM >Subject: Re: Unable to treminate an UTILITY stopped >Date: Fri, 14 Jan 2000 16:40:26 +0100 > >Is a DB2 stop/start really necessary ? Or is a STOP/START DSNDB01 >sufficient ? > >Regards >Max Scarpa > >================================================ >To change your subscription options or to cancel your subscription visit >the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can >be reached at DB2-L-REQUEST@RYCI.COM. [...]
31186 23 42_Re: Unable to treminate an UTILITY stopped14_Massimo Scarpa16_mscarpa@CESVE.IT31_Fri, 14 Jan 2000 16:56:52 +0100320_us-ascii Thanks again , folks. I've all informations now. I don't like to alter catalog tables, but I see that<br><br>many people did it safely and so I do it ! :-)<br><br>Next tuesday during the weekly DB2 shutdown I'll correct the problem. For now we have no<br><br>troubles for it. And I'll install DDF , too !! [...]
31210 85 17_Re: Long varchars15_Toine Michielse18_vndobtm@US.IBM.COM31_Fri, 14 Jan 2000 17:24:08 +0000393_us-ascii Hello Krysia,<br><br>Once you have DB2 V6 installed you have a some more options...<br><br>The first alternative would be to use a 8K bufferpool/pagesize ( or 16K if 8 is not enough). The other thing you could do is have the text fields defined as CLOBs. That way you could still have the table in the 4K bufferpool. Since the CLOB data will be stored in an auxilary tablespace. [...]
31296 172 31_Re: Stopping multi index access12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 14 Jan 2000 08:27:19 -0800542_us-ascii The DB2 V6 Performance Topics red book, SG24-5351 section on SQL enhancements describes most of the changes in more detail than we want to move over the web. Download the book. There was a small improvement to the star join there.<br><br>There is a much larger improvement to star joins in APAR PQ28813. The notes below are edited from the APAR cover letter. You can get it through your service or go to the DB2 for OS/390 home page, click on Support, then on S/390 Tech Support. Put the APAR number in the Search and click Go. [...]
31469 120 24_Re: Hardware Compression16_Richard A Yevich21_ryevich@ATTGLOBAL.NET31_Fri, 14 Jan 2000 10:21:13 -0500364_iso-8859-1 I think this is about the 4th time in as many weeks that this question has come up.<br><br>These two "compression" methods have nothing to do with one another. Each are used for different purposes today with these devices. The important part to remember with DB2 is that it is a row level compression (some rows have compressed data, some do not). [...]
31590 354 14_Abend 00C9010141_=?iso-8859-1?Q?Cl=E1udio_Meluzzi_Mendes?=18_P000002@BEG.COM.BR31_Fri, 14 Jan 2000 14:45:08 -0200601_iso-8859-1 Yesterday I discovered a 00C90101 abend which points to a production tablespace and to an index. The index refers to a table from another tablespace. Although the error description in DB2 Messages and Codes book says "In general, the data in these pages is fine" I would prefer to check and seek the origin of the problem. The manual gives advice on running the CHECK utility to determine the extent of index inconsistency. After running the CHECK DATA and CHECK INDEX utilities without any error reported I would like to know other checkings should I proceed to ensure data integrity [...]
31945 21 42_Re: Unable to treminate an UTILITY stopped13_Mercy Scholes26_mercy.scholes@ZURICHUS.COM31_Fri, 14 Jan 2000 10:47:42 -0600349_us-ascii We had the same problem about 3 months ago. We called IBM and they told us we had to reinitilized SYSUTILX.<br><br>We had to:<br><br>1. Stop the tablespace 2. Delete and reallocate the tablespace 3. run the install job DSNTIJID with only the step to init SYSUTILX .<br><br>You may want to check with IBM and see what they have to say. [...]
31967 239 21_Re: Disaster Recovery13_Melian, Terri20_Terri_Melian@BMC.COM31_Fri, 14 Jan 2000 10:52:46 -0600697_ISO-8859-1 One of the Professional Services consultants I work with is an expert on backup and recovery. He does not currently subscribe to the list, so I passed your question along to him. Here is his reply:<br><br>**************************************************************************** ********************IIf you use BMC Software's Recovery Manager for DB2, it does an "analysis" phase in which it does tape stacking determination. It will build Recovery Plus or DSNUTILB Recovery jobs which are cognizant of the tape sequence order and will optimize the recovery accordingly. If you only have Recovery Plus or DSNUTILB, you have to manually configure the tape sequence order. One of [...]
32207 67 55_Re: FAROFFPOSF info for an index in Platinum Statistics9_Rob Crane22_racrane@CONCENTRIC.NET31_Fri, 14 Jan 2000 10:39:32 -0700355_us-ascii Paul,<br><br>If you are wanting to set up PDA, you can use the following triggers. Change the % to meet your needs. You may want to focus on the cluster index first and keep historic stats in PDA to see the effect on the NPI's. You may find that the values you see now for your NPI are the best mix you can get with your current clustering. [...]
32275 128 62_Hoover presentations, 1) Buffer pool & 2) batch design for DB216_Galambos, Robert29_Robert_Galambos@COMPUWARE.COM31_Fri, 14 Jan 2000 13:09:11 -0500590_iso-8859-1 <br><br><br><br>First of all, I want to thank the more then 100 people who have asked for a copy of the Chuck Hoover presentation, "Everything you ever wanted to know about DB2 Buffering". To say the least, this was totally unexpected.<br><br>Based on this impressive response from the DB2 community for this type of information, Compuware has made a decision to post the presentation on our WEB site. We are currently revising it for soft copy format and our goal is to place it on our WEB site by January 24th. I will post another message with the address when available. [...]
32404 350 18_Re: Abend 00C9010113_Mercy Scholes26_mercy.scholes@ZURICHUS.COM31_Fri, 14 Jan 2000 12:14:56 -0600564_iso-8859-1 <br><br><br><br><br><br>We had this problem back in October. What caused the problem in our case was that the application DBA was running a LOAD of a large partitioned tablespace (multiple steps in the job) and everytime the job timeout she will terminate the utility and resubmit the job from the step that was currently executing. After she did this a few times the index was hosed and we could not even recover it. I called IBM and they told us that the only way to get out of it was to drop the object. The data wasn't really corrupted and the [...]
32755 59 23_Re: CHAR column problem24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Fri, 14 Jan 2000 10:40:46 -0800384_- The SELECT without a where clause is executing a tablespace scan while the SELECT with the where clause is using the index. Although it's probably too late now, you could have run the CHECK INDEX utility to identify the mis-matches between the data and the index. The most likely cause is a LOAD with resume, or an recovery of the tablespace which excluded the index recovery. [...]
32815 31 12_Column names19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Fri, 14 Jan 2000 12:41:22 -0600570_iso-8859-1 Hi all, Please allow me to get theoretical for a moment. And, while trying to observe both relational DB design and data modeling rules, how do you choose column names? In particular, how do you name columns that will be inherited as foreign keys or part of primary keys when both the parent and child table could have the same column name. Ex: tablea has a primary key column ident dec(3,0) and tableb has a primary key column ident smallint where tablea is parent to tableb. Tableb inherits ident from tablea and it now has two columns with same name. [...]
32847 55 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.16_Christine Sawyer20_cosawyer@HOTMAIL.COM29_Fri, 14 Jan 2000 13:49:03 EST642_- Hi Jim, Could you please send me a copy also?<br><br>Thanks Christine<br><br><br><br>>From: Jim Lewandowski <jlewand@STARNETINC.COM> >Reply-To: DB2 Data Base Discussion List <DB2-L@RYCI.COM> >To: DB2-L@RYCI.COM >Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa > ces. >Date: Tue, 11 Jan 2000 10:09:00 -0600 > >I had sent out many copies of an SMF 42 subtype 6 REXX that provided a >detail and summary of I/O response times (and their components) for >each table/indexspace for a DB2 DBM1 subsystem. Anyone else interested >in this? > >Jim Lewandowski > > > >Galambos, Robert wrote: > > > > Chuck Hoover, from [...]
32903 43 16_Re: Column names21_Christopher T Everett24_cteveret@DUKE-ENERGY.COM31_Fri, 14 Jan 2000 13:55:14 -0500552_us-ascii >> Please allow me to get theoretical for a moment. And, while trying >> to observe both relational DB design and data modeling rules, how do you >> choose column names? In particular, how do you name columns that will be >> inherited as foreign keys or part of primary keys when both the parent and >> child table could have the same column name. Ex: tablea has a primary key >> column ident dec(3,0) and tableb has a primary key column ident smallint >> where tablea is parent to tableb. Tableb inherits ident from tablea and it >> now [...]
32947 50 16_Re: Column names10_Bill Brown25_bill_brown@SPRINGMAIL.COM31_Fri, 14 Jan 2000 14:25:11 -0500568_- I agree that the column name should represent an atomic data fact, but I think names should be more meaningful. Like employee identification could possibly be defined as emp_id. However, an emp_id is an emp_id is an emp_id and in my thinking this name should be used everywhere. Possibly the example given, ident, is a bad example. This name really doesn't tell me anything. Is it an employee ident, a part ident, etc. The column should also have the same defintion wherever it is used. By using this type of a naming scheme I really don't care which table the [...]
32998 375 18_Re: Abend 00C901010_19_csutfin@AMSOUTH.COM31_Fri, 14 Jan 2000 13:37:05 -0600415_- Claudio,<br><br>I encouontered the same thing in DB2 V4 about a monoth ago. I ran a CHECK Data, REPAIR, and everthing else I could think of.<br><br>I finally unloaded the data (this happen to be two tables in a tablespace) Loaded using DSNTIAUL with the REPLACE option to force SMS to re-allocate the tablespace and everything was fine. There are several PTFs on IBMLINK about this particular error message. [...]
33374 28 37_Data Sort Big question - Help needed.14_subrata mondal25_subratamondal@HOTMAIL.COM29_Fri, 14 Jan 2000 20:05:51 GMT281_- I have a table which has 15 columns. One column has 3 possible values - That is C R and S. This column has a length of Varchar(1).<br><br>Now my clients wants the table to sort not on the dictionary standard. It should be sorted on R S then C. I mean R first then S then C. [...]
33403 32 7_SMS/DB210_Jim Tanner19_jim_tanner@BOMC.COM31_Fri, 14 Jan 2000 15:03:39 -0500586_us-ascii Hello List,<br><br>Our company is preparing to move into SMS management with our DB2 datasets. Our production DB2 datasets are User defined. I was interested in how other companies approched the initial conversion. Was the production system converted to SMS all at one time or was it phased in a piece at a time? We were thinking of creating one SMS Storage Group for our tablespaces and a second SMS Storage Group for our indexes. We would use filtering to send the files to the right SMS Storage Group. Our most critical datasets would remain user defined and not under [...]
33436 50 41_Re: Data Sort Big question - Help needed.15_Philip, Sibimon19_PhilipS@SEALAND.COM31_Fri, 14 Jan 2000 15:28:58 -0500455_iso-8859-1 May be you can get the data in order by using UNION ALL. Select data with R first and then union it with S and then with C.<br><br>Thanks Sibimon Philip 972-702-2515 - Office 972-417-3597 - Residence E-mail - Sibimon_philip@sealand.com<br><br><br><br>-----Original Message----- From: subrata mondal [mailto:subratamondal@HOTMAIL.COM] Sent: Friday, January 14, 2000 2:06 PM To: DB2-L@RYCI.COM Subject: Data Sort Big question - Help needed. [...]
33487 63 41_Re: Data Sort Big question - Help needed.12_John Cameron47_John_Cameron/MSI-CORP/MSI-INC@MSI-INSURANCE.COM31_Fri, 14 Jan 2000 14:32:20 -0600553_us-ascii Use the CASE statement, assign values : WHEN 'C' THEN '1' WHEN 'R' THEN '2' WHEN 'S' THEN '3' END<br><br>ORDER BY (column number)<br><br>This method has worked for me.<br><br>John Cameron jcameron@msi-insurance.com<br><br><br><br><br><br><br><br><br><br>subrata mondal <subratamondal@HOTMAIL.COM>@RYCI.COM> on 01/14/2000 02:05:51 PM<br><br>Please respond to subratamondal@hotmail.com<br><br>Sent by: DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br><br><br>To: DB2-L@RYCI.COM cc:<br><br>Subject: Data Sort Big question - Help needed. [...]
33551 61 41_Re: Data Sort Big question - Help needed.12_John Cameron47_John_Cameron/MSI-CORP/MSI-INC@MSI-INSURANCE.COM31_Fri, 14 Jan 2000 14:38:11 -0600503_us-ascii Sorry, that should have been :<br><br>SELECT col1, col2, colcrs, case colcrs when 'R' THEN '1' when 'S' THEN '2' when 'C' THEN '3' end from table order by 4<br><br><br><br><br><br><br><br><br><br><br><br>subrata mondal <subratamondal@HOTMAIL.COM>@RYCI.COM> on 01/14/2000 02:05:51 PM<br><br>Please respond to subratamondal@hotmail.com<br><br>Sent by: DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br><br><br>To: DB2-L@RYCI.COM cc:<br><br>Subject: Data Sort Big question - Help needed. [...]
33613 28 12_PGM vs SPUFI19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Fri, 14 Jan 2000 14:44:42 -0600368_iso-8859-1 Hi all and thx in advance, I did a cut and paste of a declare cursor statement's select into spufi. Hardcoded the one host variable into both the spufi and the program. The spufi works. The program gets +100. Huh??????? I checked all the obvious stuff, correct package with hardcoded host variable, correct load module executing, etc. What did I miss? [...]
33642 20 12_DBA position16_Cockerill, Steve30_SLCockerill@NATIONALGYPSUM.COM31_Fri, 14 Jan 2000 16:31:58 -0500464_iso-8859-1 We have an opening for DB2 DBA with PeopleSoft experience. We are located in Charlotte, NC. If interested, please send your resume to slcockerill@nationalgypsum.com.<br><br><br><br>Thanks,<br><br>Steve Cockerill<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
33663 27 38_Number of DD statement limited by TIOT24_Gendron, Dave (Exchange)28_Dave.Gendron@COASTALCORP.COM31_Fri, 14 Jan 2000 17:09:58 -0500379_- Our PeopleSoft DBA is using BMC to perform a migration. He apparently has 7500 DD statements in a single job step. On execution, he receives IEF649I msgs indicating an excessive number of DD statements. (seems like an understatement)<br><br>We seem to have three options:<br><br>1. Break the job into many steps, which apparently the BMC product can not do automatically. [...]
33691 48 16_Re: PGM vs SPUFI14_Theisen, Craig22_CTheisen@GUIDEMAIL.COM31_Fri, 14 Jan 2000 16:11:42 -0600410_iso-8859-1 Rick, Do you have a like statement in your Select? In SPUFI, if you have a 5 character column and you say Fielda like 'M%', it will work but in a COBOL program you must say Fielda like 'M%%%%'.<br><br>Craig Theisen<br><br><br><br>-----Original Message----- From: DAVIS, RICK (SBCSI) [mailto:RD8246@MOMAIL.SBC.COM] Sent: Friday, January 14, 2000 2:45 PM To: DB2-L@RYCI.COM Subject: PGM vs SPUFI [...]
33740 85 10_Use of GMT0_22_aylswop@WELLSFARGO.COM31_Fri, 14 Jan 2000 14:52:45 -0800443_iso-8859-1 Our company is discussing the possibility of setting all our mainframe operating systems to GMT time (with no offset). The purpose is to have all (geographically dispersed) systems operating on the same time. By using GMT time, we would achieve this, plus avoid having to make this kind of change in the future. We don't see any significant issues with DB2, IMS or operating system software if we do this. I would like to know [...]
33826 28 22_Requesting information16_McCoy, Theresa A21_tam441b@MAIL.SMSU.EDU31_Fri, 14 Jan 2000 16:45:05 -0600563_iso-8859-1 I have some questions for DB2 MVS or VM/VSE users. I work for Southwest Missouri State University and we are developing web applications for our students. We would like for these application to be available 24 x 7. But this raises many issues on data recovery, since with 24 x 7 both web applications and batch programs could be updating the same tables at the same time. So my questions are: Do you allow web or CICS updates to tables at the same time as batch update processing is occurring? If you do, I would be interesting in discussing data [...]
33855 19 14_Logging in DB212_Andy Wheeler25_Andy.Wheeler@GRIZZARD.COM31_Fri, 14 Jan 2000 17:57:06 -0500309_iso-8859-1 I have been asked several questions lately as to what is actually written to the logs. It seems that the location of VARCHAR columns in a table may affect the data that is included in the log. Does anyone have a definitive answer or a reference that I can look at that will show me the light. [...]
33875 42 42_Re: Number of DD statement limited by TIOT9_Rob Crane22_racrane@CONCENTRIC.NET31_Fri, 14 Jan 2000 16:14:50 -0700381_us-ascii Try breaking up your compare within the BMC worklist by wildcarding at the Tablespace level and end up with multiple worklists. You should be able to do some queries against the catalog to see where you want to break up the worklist to limit the number of objects (DD statements) and hopefully get a faster runtime with multiple worklists executing at the same time. [...]
33918 40 76_Re: RC/Migrator for Automated DB2 Statistics replication btw Prod & Test DBs16_Christine Sawyer20_cosawyer@HOTMAIL.COM29_Fri, 14 Jan 2000 18:22:29 EST609_- Hi Listserv, I'm having problem trying to migrate prod stats to a test database using using platinum's RC/Migrator. The database I want to populate with prod statistics reside in our test subsystem with other DB's. The RC/Migrator analysis, DDLfile creation phase, etc works fine. My problem is that I want to automatically rename the production catalog table names generated in the analysis phase to a different name using the RC/M Global Changes feature of migrator. I reviewed the output of the analysis phase and found that the prod database name was changed to the test DB name specified which is [...]
33959 31 31_Re: Distributed protocol errors15_Lynette Roberts21_llroberts@KSCABLE.COM31_Fri, 14 Jan 2000 17:35:43 -0600583_- Hi Steve, From what you have described here, it sounds very similiar to a problem that we encountered when setting up one of our PeopleSoft environments for HRMS. The version of PeopleSoft that we were installing used DataMover to create and populate all of the tables in the system, during which we received no errors. When we tried to actually select some data from one of the tables, we would get a similiar error as you are seeing, and the subsystem would crash. We finally tracked the problem down to an incompatibility with our compression load libraries (we were using [...]
33991 59 13_REXX doubt...13_Embar, Satish21_Satish.Embar@NIKE.COM31_Fri, 14 Jan 2000 15:31:55 -0800348_us-ascii Dear friends,<br><br>It is not exactly a DB2 question , but i have been stuck in it for quite some time now and would appreciate your thoughts.<br><br>I want to edit a dataset (USER.TEST.SEQ) by submitting a JCL. For this I have written a simple edit macro (CHGMAC) and then written following rexx (EDTREXX).EDTREXX looks like this : [...]
34051 47 18_Re: Logging in DB213_Baldon, David20_David_Baldon@BMC.COM31_Fri, 14 Jan 2000 17:45:45 -0600380_ISO-8859-1 Hi Andy, The quick answer is on an insert and delete the whole row is logged. On an update, the varchar column (assuming it is updated) and all following columns are logged. If I remember correctly, the logging of the varchar column data starts with the first changed byte. If you have data capture(changes) the entire before-image and the after-image is written. [...]
34099 72 18_Re: Logging in DB216_Richard A Yevich21_ryevich@ATTGLOBAL.NET31_Fri, 14 Jan 2000 17:51:21 -0500535_iso-8859-1 DB2, as of V3, logs as follows:<br><br>1 - fixed length rows only (no varchars) from first byte updated to last byte updated<br><br>2 - variable length rows (row containing at least one varchar) from first byte updated to END OF ROW<br><br>it has to log to end of row since the structure of the data row is dependent on the length bytes in the varchars -- that is: the only way to determine the end of the row without a lot of nonsensical calculations which only eat cpu besides a lot of other reasons is to log to the [...]
34172 84 17_Re: REXX doubt...13_Baldon, David20_David_Baldon@BMC.COM31_Fri, 14 Jan 2000 17:58:25 -0600311_ISO-8859-1 Hi Satish, The problem is that the EDIT command is an ISPF command and the way that your JCL is set up you're not creating an ISPF environment. I'm not certain that what you're trying is possible. The ISPF Dialog Developer's Guide and Reference contains information about running ISPF in batch. [...]
34257 115 17_FW: REXX doubt...13_Embar, Satish21_Satish.Embar@NIKE.COM31_Fri, 14 Jan 2000 16:37:58 -0800543_us-ascii Dear David,<br><br>Thanks for your response. You have written that you wonder whether the thing i am trying is possible at all. I was just wondering that had this not been possible at all, the REXX would not have run when I run it by giving an 'ex' in front of EDTREXX or even by giving typing TSO EXEC 'USER.TEST.EXEC(EDTREXX)' on a tso command line. But it runs pretty fine this way ; the only problem comes when I run EDTREXX through JCL using IKJEFT01 . Till now I was under the impression that any command that can be given [...]
34373 56 11_Re: SMS/DB212_Roger Miller19_millerrl@US.IBM.COM31_Fri, 14 Jan 2000 17:45:41 -0800610_iso-8859-1 I would definitely pull down the Storage Management with DB2 for OS/390 red book from www.ibm.com/redbooks It's fairly current (September 1999) and was written by field people with expertise in SMS and in DB2.<br><br>I've talked with quite a few customers, and the migrations are highly varied, ranging from something that the storage administrators did to a carefully coordinated project. If it was mine to do, I would not separate the indexes from the data, but look more at sizes of data sets. For performance management, the key measures are the SMF 42 subtype 6 records: I'd watch the top [...]
34430 67 42_Re: Turning Correlated Subqueries to Views0_24_ssethi@LOT.TATASTEEL.COM29_Sat, 15 Jan 2000 03:34:36 GMT519_us-ascii Hi Philip, If u feel like u have the bad performing queries then rewriting or some other kind of tuning approach for those queries will definitely be helpful but it all depends on individual queries.U have to check the EXPLAIN and monitor the query online(if needed) and then decide whether some problem really exist with the query or not(i mean the response time) and after rewriting and tuning it u should go for the same steps of checking the explain and monitoring it online for evaluating the costs. [...]
34498 163 21_Re: FW: REXX doubt...13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM31_Sat, 15 Jan 2000 08:46:08 +0530381_us-ascii hi !!<br><br>you can do the same thing thru JCL too , but just you have to concatenate the libs of ISPF that are in your logon proc to the JCL . This will solve the problem .. regards Vishy<br><br><br><br><br><br><br><br><br><br>"Embar, Satish" <Satish.Embar@NIKE.COM> on 01/15/2000 06:07:58 AM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM> [...]