1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l February 2000, week 5
2 84 40_DB2 V5, type 2 indexes, currentdata(yes)17_Nagaraj Pudukotai33_nagaraj.pudukotai@HPSBLR.SOFT.NET30_Mon, 1 Mar 1999 14:25:26 +0530444_iso-8859-1 Hi John The problem is caused by the inserts being found in the index.<br><br>CURRENTDATA yes or no will have no effect.<br><br>An order by clause that causes the cursor to be materialized when it is opened would fix the problem. The result set would be built in a temporary tablespace, and the rows fetched from there. Any inserts are put into the tablespace and index, but we aren't fetching from there, so we don't see them. [...]
87 56 57_Re: Products that archive and restore DB2 historical data0_23_J.P.Slot@RF.RABOBANK.NL31_Tue, 29 Feb 2000 11:17:04 +0100582_us-ascii Hello Martin,<br><br>I am wondering about the ARCHIVE for DB2 product as you mentioned. Is it possible to ARCHIVE DB2 data that isn't used for a while (a pre-selected period). Such a feature would be perfect in datawarehouse surroundings. A collegue of mine suggested to use OAM with an in-house build cobol-program to ARCHIVE and RESTORE data in such a manner. Does the product you mentioned provide such a feature too? Maybe there are other products that provide a better solution or is there a function within DB2 (in development) that does this kind of ARCHIVE's? [...]
144 69 42_Re: db2-l@ryci.com(C90101 in Online Reorg)24_Peter_Schwarcz (Bigpond)26_Peter_Schwarcz@BIGPOND.COM31_Tue, 29 Feb 2000 22:37:15 +1100336_us-ascii I have had a similar experience recently where after running an on-line reorg of a non unique type 2 clustering index I came up with a corrupted index key entry. I subsequently did an INDEX REBUILD and I have not been able to pin down the cause of the index corruption, but the problem poses another interesting question. [...]
214 24 18_DB2 connectivity..0_25_Julian_Peacock@SWEB.CO.UK31_Tue, 29 Feb 2000 12:01:00 +0000475_ISO-8859-1 Fellow DB2ers,<br><br>Just a quick question: What is the difference between DB2 Connect and ODBC? I am only looking for a high level overview.<br><br>Thanks in advance<br><br>Julian Peacock DB2 DBA SWEB/LE Plymouth England<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.
239 59 22_Re: DB2 connectivity..17_Alessandro Brezzi28_brezzi.isac@INTERBUSINESS.IT31_Tue, 29 Feb 2000 13:23:18 +0100628_us-ascii Hi Julian, DB2 Connect allow you to connect, using DRDA as "db2-protocol" to servers running DB2 with external client connection active and properly configured (DDF under OS/390, PROTOCOL=AUTO for DB2 VM or DB2 VSE). You need also the communication protocol: TCP/IP (the standard one under W95 NT is good) or SNA (use PCOMM and select the appropriate DLL for CPI-C). ODBC (the MS version for the standard CLI) is a library of API for standard or custom programs to connect to a server. After installing the communication protocol (i.e. using SNA, defining the local-PC and remote-MainFrame nodes), you install and [...]
299 123 44_Re: DB2 V5, type 2 indexes, currentdata(yes)10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Tue, 29 Feb 2000 12:52:48 GMT511_us-ascii Hi Nagaraj, I read the explanations given by u and it is a new information for me, what i would like to ask now is what if there is tablespace scan.Will the data inserted be returned if tablespace scan is done. As i think , in case of tablespace scan if the newly inserted row will be returned then it will be fetched irrespective of the index type .In this case can we only blame the application design ?. And if newly inserted rows will not be returned in case of the tablespace scan then how ? [...]
423 57 34_Re: PeopleSoft Roles - Tax Updates11_Nancy Reile24_Nancy.E.Reile@AM.PNU.COM31_Tue, 29 Feb 2000 08:00:55 -0500575_US-ASCII We follow the same process that Marty does.<br><br>Nancy.<br><br>________________________________________________________________________________ Date: Mon, 28 Feb 2000 11:15:28 -0800 From: "Killen, Martin W - CNF" <Killen.Martin@CNF.COM> Subject: Re: PeopleSoft Roles - Tax Updates MIME-Version: 1.0 Content-Type: text/plain<br><br>The applications folks create the scripts and pass them along to the DBA's here. We review the scripts and make any necessary changes and execute them. We do not allow alters, creates, etc to be done by anyone other than a DBA. [...]
481 32 26_42-6 RMF REPORT GENERATION12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Tue, 29 Feb 2000 05:03:25 PST531_- HI Folks:<br><br><br><br>I'm trying to make good strategy to distribute the db2 datasets into the db2 pool (DASD) and I need to generate a RMF REPORT with the record 42 subtype 6 (42-6) because it can give me the information such as dataset id , volser , access intensity , I/O rate and others values that can help to do a good balancing of my db2 pool. If anybody made that kind of activity before and has the job that read SMF archives and generate it report I would be really appreciate if could send a copy of this job. [...]
514 125 42_Re: db2-l@ryci.com(C90101 in Online Reorg)9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Tue, 29 Feb 2000 13:05:22 +0000415_us-ascii BMCs Check Plus does allow you to carry out a 'SHRLEVEL CHANGE' CHECK INDEX. You also have to buy the BMC Snapshot Upgrade Feature (SUF) of their buffer manager XBM for this to work. Kind Regards, Andy Hunt - Scottish And Southern Energy.<br><br><br><br><br><br><br><br>"Peter_Schwarcz (Bigpond)" <Peter_Schwarcz@BIGPOND.COM> on 29/02/2000 11:37:15<br><br>Please respond to Peter_Schwarcz@bigpond.com [...]
640 41 13_CATMAIN ERROR0_30_Franco_Oberto@NOTES.AMDAHL.COM31_Tue, 29 Feb 2000 13:09:09 +0000643_us-ascii Hi all,<br><br>we are migrating to db2 v5 from db2 v4 , but during CATMAIN process we receive these errors :<br><br>DSNP008I )Y2K DSNSPCS0 REQUIRED USER DEFINED DARA SER NOT AVAILABLE<br><br>DSN41B.DSNDBC.DSNDB06,SYSDDF.I0001.A0001 RC=00D70002 CONNECTION ID =.................................................................. LUW ID=*<br><br>DSNP016I )Y2K DSNPCS0 CREATE FAILED FOR<br><br>DSNDB06.SYSDDF,I0001. RC=00D70002 CONNECTION ID =.............................................................................<br><br><br><br>Now , DB2 v 4 has the database SYSDDF out from DSNDB06 and the utility never found the datasets . [...]
682 83 39_DB2 Enterprise Edition and perl DBD/DBI10_Tim Miller21_tmiller@TELCORDIA.COM31_Tue, 29 Feb 2000 08:17:41 -0500432_us-ascii Steve,<br><br><br><br>To configure DB2 Client with a local database alias to a remote database connection you must do the following:<br><br>1) Catalog the Database Connection Services (DCS) Directory<br><br>db2 => catalog dcs database DB2G1 as DB2G DCS 1 entry:<br><br>Local database name = DB2G1 Target database name = DB2G Application requestor name = DCS parameters = Comment = DCS directory release level = 0x0100 [...]
766 84 44_Re: No. of qualifying rows at declare cursor15_Toine Michielse18_vndobtm@US.IBM.COM31_Tue, 29 Feb 2000 12:28:34 +0000360_us-ascii Hello Jaydeep,<br><br>First of all a declare statement will never cause any result set to materialize (you're only DECLARING). This MAY happen at open cursor time. However, the presence of the ORDER BY clause is not really what drives this. The result set will be materialized at OPEN time if the ORDER BY clause causes a sort of the result set. [...]
851 75 34_Re: PeopleSoft Roles - Tax Updates12_Susan Tipton22_tiptosa@SHANDS.UFL.EDU31_Tue, 29 Feb 2000 08:24:03 -0500709_US-ASCII We too follow Marty's procedures for both PS Financials and HR.<br><br>Susan<br><br>>>> Nancy.E.Reile@AM.PNU.COM 02/29/00 08:00AM >>> We follow the same process that Marty does.<br><br>Nancy.<br><br>________________________________________________________________________________ Date: Mon, 28 Feb 2000 11:15:28 -0800 From: "Killen, Martin W - CNF" <Killen.Martin@CNF.COM> Subject: Re: PeopleSoft Roles - Tax Updates MIME-Version: 1.0 Content-Type: text/plain<br><br>The applications folks create the scripts and pass them along to the DBA's here. We review the scripts and make any necessary changes and execute them. We do not allow alters, creates, etc to be done by anyone other than a DBA. [...]
927 22 24_Re: 4GL Reccommendations12_Kalman, Jeff20_JKalman@UNCH.UNC.EDU31_Tue, 29 Feb 2000 08:29:12 -0500463_iso-8859-1 Good morning, Can I get some reccommendations on a 4GL that interfaces with DB2. This is primarily for report generation, though it would be nice if it could interface with COBOL (ie; callable sub-routine). We want to get away from writing COBOL programs for some of the requests that we receive our users because of the obvious (it takes too long and it is cumbersome for some of these remedial tasks). Any reccommendations would be aprreciated. [...]
950 53 24_Re: 4GL Reccommendations13_Marcus Davage29_Marcus.Davage@LLOYDSTSB.CO.UK31_Tue, 29 Feb 2000 13:31:07 -0000376_iso-8859-1 Software AG's Natural is a good bet, but make sure the level of the Natural/DB2 interface supports your release of DB2. I was at DB2 V4.1 when the NDB2 interface only supported V2.3 SQL!<br><br><br><br>-----Original Message----- From: Kalman, Jeff [mailto:JKalman@UNCH.UNC.EDU] Sent: 29 February 2000 13:29 To: DB2-L@RYCI.COM Subject: Re: 4GL Reccommendations [...]
1004 14 17_Why Not DB2??????10_Bill Brown25_bill_brown@SPRINGMAIL.COM31_Tue, 29 Feb 2000 08:34:29 -0500657_- Disclaimer: I am a DB2 proponent and feel it is the strongest player in the data base market today and would recommend it without hesitation regardless of platform.<br><br>Recent articles in The Wall Street Journal talk about two recent projects that sound very interesting. GM, Ford, and Diamler-Chrysler in one article and Sears and Carrefour in another article are planning HUGE electronic commerce projects. It would seem from my techie standpoint that these companies would want the strongest, most robust, most reliable multi-platform data base available. They chose Oracle. Why????? It is also mentioned that Wal-Mart chose not to participate [...]
1019 138 43_Re: DB2 V5,type 2 indexes, currentdata(yes)17_Nagaraj Pudukotai33_nagaraj.pudukotai@HPSBLR.SOFT.NET30_Mon, 1 Mar 1999 19:10:35 +0530545_iso-8859-1 Hi Sanjeev, If you did not have the index, then it all depends on where the new rows go. Yes you might have the new rows in the subsequent fetches or may be not, depending on where the new rows went into the tablespace.<br><br>Thanks<br><br>Nagaraj<br><br>Hi Nagaraj, I read the explanations given by u and it is a new information for me, what i would like to ask now is what if there is tablespace scan.Will the data inserted be returned if tablespace scan is done. As i think , in case of tablespace scan if the newly inserted [...]
1158 50 22_Re: DB2 connectivity..13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Tue, 29 Feb 2000 07:36:43 -0600366_iso-8859-1 Open DataBase Connectivity is a layer of software (Microsoft standard and a good idea i think) between the application and, in your case, DB2 Connect (or any database vendor native routines).<br><br>Before ODBC, accessing different DMBSs meant knowing each vendors interface which added to maintenance and knowledge of each interface had to be know. [...]
1209 46 24_Re: 4GL Reccommendations17_Alessandro Brezzi28_brezzi.isac@INTERBUSINESS.IT31_Tue, 29 Feb 2000 14:52:08 +0100589_us-ascii Hi Jeff, we use QMF for batch report as for online report; it is callable in OS/390 and VM from COBOL, REXX, PL/I and C ... but we prefere to write QMF procs running QMF queries with associated forms.<br><br>Alessandro<br><br>>Good morning, >Can I get some reccommendations on a 4GL that interfaces with DB2. This is >primarily for report generation, though it would be nice if it could >interface with COBOL (ie; callable sub-routine). We want to get away from >writing COBOL programs for some of the requests that we receive our users >because of the obvious (it takes too [...]
1256 94 24_Re: 4GL Reccommendations0_18_Luke.McGee@WDR.COM31_Tue, 29 Feb 2000 08:46:22 -0500479_iso-8859-1 Natural usually runs under ADABAS, which is a costly license. I believe it can also run straight under VSAM. Also, Natural for DB2 is an add on to the base Natural, so you are talking about several hundred thousand in licenses, if using ADABAS and then there are those pesky annual maintenance fees... I worked with ADABAS/Natural (W/DB2) for many years and it is a great environment but if you are just looking for a report generator, Natural would be overkill. [...]
1351 93 27_Re: DB2 connect w/ MS Query9_John Reid14_jreid@FBFS.COM31_Tue, 29 Feb 2000 07:53:26 -0600507_us-ascii Craig, thanks for the response.<br><br>We are at 6.1.0 no fixpacks applied, patch 1 and 2 are zero. Yes we have tried the "Excel Query Wizard" but still get the same problem. If we start MS QUERY , select NEW, un-check "to use wizard", select our HOST DB2 dsn (from the database list) , we get the logon screen, enter information and press enter , this is when it dumps. I see no connection to the mainframe (Using TMON for DB2) so it seems it abends prior to trying to making the connection. [...]
1445 61 24_Re: 4GL Reccommendations12_Kalman, Jeff20_JKalman@UNCH.UNC.EDU31_Tue, 29 Feb 2000 08:52:31 -0500496_iso-8859-1 Thank you for your reply. Does this work with flat files as well?<br><br><br><br>-----Original Message----- From: Alessandro Brezzi [mailto:brezzi.isac@INTERBUSINESS.IT] Sent: Tuesday, February 29, 2000 8:52 AM To: DB2-L@RYCI.COM Subject: Re: 4GL Reccommendations<br><br><br><br>Hi Jeff, we use QMF for batch report as for online report; it is callable in OS/390 and VM from COBOL, REXX, PL/I and C ... but we prefere to write QMF procs running QMF queries with associated forms. [...]
1507 10 30_Re: 42-6 RMF REPORT GENERATION10_Bill Brown25_bill_brown@SPRINGMAIL.COM31_Tue, 29 Feb 2000 08:55:23 -0500426_- Take a look at the article in the current "DB2 Magazine" titled "Time to Reconsider SMS" by Robert Catterall. It makes a lot of good points and could possibly save you a lot of time.<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.
1518 36 45_Invoking DB2 Stored Procedure Via DB2 Connect16_Charles Stansell19_cfstansell@JUNO.COM31_Tue, 29 Feb 2000 08:01:58 -0600481_- All,<br><br>We currently have users accessing our DB2 subsystems via DB2 Connect and now have a requirement for the users to invoke a DB2 stored procedure (Cobol). Other than defining the stored procedure in SYSIBM.SYSPROCEDURES and starting it, is there anything special that needs to be done on the mainframe or client that is specific to invoking DB2 stored procedures from DB2 Connect ? Any examples of what needs to be done or what the DB2 connect client needs to do ? [...]
1555 17 31_ERwin support for V6 for OS390?11_Joe Luthman22_jluthma@BGNET.BGSU.EDU31_Tue, 29 Feb 2000 09:19:20 -0500358_us-ascii I am having some trouble finding if ERwin has been upgraded to support DB2 UDB V6 for OS390. Does anyone know if this is already there or when it will be? Joe Luthman DBA Information Technology Services Phone: (419)372-7750 260 Hayes Hall FAX: (419)372-7723 Bowling Green State University E-Mail: jluthma@bgnet.bgsu.edu Bowling Green, OH 43403 [...]
1573 122 27_Re: DB2 connect w/ MS Query15_Craig Wahlmeier27_cwahlmeier@DATA-TRONICS.COM31_Tue, 29 Feb 2000 08:23:46 -0600318_iso-8859-1 John,<br><br>I tried to replicate the problem but it does not blow up for me. However, I do not have a file named msqry32.dbg on any of my test machines. This is suspicious. Any idea what that file does. Never heard of the dbg extension. We install Office 97 Professional Edition. What do you install? [...]
1696 179 43_Re: DB2 V5,type 2 indexes, currentdata(yes)10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Tue, 29 Feb 2000 14:35:52 GMT527_us-ascii Hi Nagraj, It looks bit surprising to me .To get some more clarification, suppose a tablespace is scanned and all the pages are brought to the pool ..say pages 1 ,2,3 and 4. If a row is found in page 1 and inserted into page 4 then that row(newly inserted) will again come when page 4 is read.U mean to say if some row from page 3 is fetched and inserted into page 1 then it will not be returned.Now if in this case page 1 is rereferenced then newly inserted row will come. very complecated......... . I am sorry [...]
1876 466 43_Re: DB2 V5,type 2 indexes, currentdata(yes)16_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Tue, 29 Feb 2000 09:36:06 -0500623_iso-8859-1 interesting "sent date" on this e-mail!<br><br>Andrea Milligan DataBase Administrator BlueCross BlueShield of Tennessee<br><br>> -----Original Message----- > From: Nagaraj Pudukotai [SMTP:nagaraj.pudukotai@HPSBLR.SOFT.NET] > Sent: Monday, March 01, 1999 8:41 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2 V5,type 2 indexes, currentdata(yes) > > Hi Sanjeev, > If you did not have the index, then it all depends on where the new > rows go. Yes you might have the new rows in the subsequent fetches or > may be not, depending on where the new rows went into the tablespace. > > Thanks > > Nagaraj > > Hi Nagaraj, [...]
2343 47 35_Re: ERwin support for V6 for OS390?19_Lisa Westcott-Dryer29_Lisa_Westcott-Dryer@AMWAY.COM31_Tue, 29 Feb 2000 09:33:12 -0500281_us-ascii Through my rep and product coordinator Cindy Gillis 248 263 9700 #12825 at CA, they say they have no immediate release date for the support of version 6 UDB (MVS or whatever) with the Erwin product. Let's hassle 'em and get 'em going! I have not checked the web yet. [...]
2391 14 23_MISTAKE : CATMAIN ERROR0_30_Franco_Oberto@NOTES.AMDAHL.COM31_Tue, 29 Feb 2000 15:13:44 +0000363_us-ascii Sorry , for E-mail but we have found the error . We don't have executed the job DSNTIJIN . Kind regards , Franco<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.
2406 108 52_Re: Platinum RCM problem - anyone else experiencing?14_Gary Bernhardt18_GBernhardt@CSI.COM31_Tue, 29 Feb 2000 09:11:50 -0600636_ISO-8859-1 Shan, You might investigate whether you have old migrate strategies that need to be deleted. I have seen where this seems to trip up analysis. Gary Bernhardt<br><br>---------- > From: Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM > To: DB2-L@RYCI.COM > Subject: Platinum RCM problem - anyone else experiencing? > Date: Sunday, February 27, 2000 10:39 AM > > > Problem: We have been working with Platinum for the last 6 months on this > problem with > no resolution. We're told only one other company is > experiencing this problem and > unfotunately Platinum is unable to reproduce it, so I thought > perhaps I [...]
2515 164 91_Re: Loading data into DB2/UNIX via load command from DB2 OS/390 DSNTIAUL unload output file14_Gary Bernhardt18_GBernhardt@CSI.COM31_Tue, 29 Feb 2000 09:14:52 -0600587_ISO-8859-1 It has been a long time since I have done this, but if you have DB2 Connect, can't you export from DB2/OS/390, then import into DB2/Unix? Gary<br><br>---------- > From: Scarcella, Gary V <ScarcellaGV@AETNA.COM> > To: DB2-L@RYCI.COM > Subject: Re: Loading data into DB2/UNIX via load command from DB2 OS/390 DSNTIAUL unload output file > Date: Sunday, February 27, 2000 1:41 PM > > I tried these suggestions, but am getting the following error message in the > DB2 UNIX load command rejecting all of the rows. > > SQL3118W The field value in row "1" and column "1" cannot [...]
2680 27 43_Re: DB2 V5,type 2 indexes, currentdata(yes)12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 29 Feb 2000 10:14:17 -0600445_- It seems that some programmers assume that isolation from other's updates extends to protection from themselves. That's not true. We don't spend much time telling what is not so in our books, since they would never be complete and would be too large for a database. Here is some text pasted from the SQL Reference. We have found some problems in the books, but the Version 6 text under OPEN (page 708 in the Adobe Acrobat tool) looks ok. [...]
2708 12 44_Re: No. of qualifying rows at declare cursor12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 29 Feb 2000 10:17:29 -0600330_- For Toine's book reference, try SG24-2233 in your red book search.<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.
2721 41 21_LARGE DB2 BUFFERPOOLS12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Tue, 29 Feb 2000 08:35:19 PST513_- Hi Folks:<br><br>Here I have another point that I would like to discuss with all of you. How I would know when a db2 bufferpool is too large or large because I want to improve my hit ratio on my db2 bufferpools and I know that the sum of all DB2 virtual buffer pools cannot exceed 1.6GB and the sum of all hiperpools cannot exceed 8GB(db2 version 4) . I don't want to reach the limit because is too much memory and I don't want to kill my system. I use five buferpools defined as follow : BP0 just catalog [...]
2763 75 30_Re: 42-6 RMF REPORT GENERATION14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Tue, 29 Feb 2000 11:38:18 -0500610_ISO-8859-1 Harbry, Our DASD/Xpert for DB2 does this for you, with sophisticated graphics on the PC that provides easy point/click sorting on all important data variables, and quick drill down to the object (dataset) level. This saves you from trying to wade through pages of useless reports. It provides everything you are looking for, plus much more. Dataset placement is still a critical performance issue, dispite the 'nay sayers" - because this is a major problem at every site I visit, and every set of performance data I review. If you would like more information, please let me know. Regards, Joel [...]
2839 21 39_Equivalent of "Describe" command in DB20_15_Db2user@AOL.COM29_Tue, 29 Feb 2000 11:43:10 EST488_US-ASCII Is there a command in DB2 that would give you all the column definitions on a table? - like what "describe" does in Oracle. I know we run a query on syscolumns and systables, but is there an easier way?<br><br>Thanks.<br><br>David Taylor<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.
2861 90 24_Re: 4GL Reccommendations17_Alessandro Brezzi28_brezzi.isac@INTERBUSINESS.IT31_Tue, 29 Feb 2000 17:58:13 +0100369_us-ascii Jeff, QMF can import / export data to external "flat" files, as described in "Developing QMF applications" appendix B and QMF Reference; the format of this sort of files is IXF (not PC IXF but the format of DXT). Your file, to be imported, must have header records and fixed length-fixed format data record ... you can also export report in HTML form ... [...]
2952 79 25_Re: LARGE DB2 BUFFERPOOLS14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Tue, 29 Feb 2000 11:52:32 -0500433_ISO-8859-1 Harbry, Every system is different, and there are no standard guidelines. A general rule of thumb however, is that a HP should be at least twice the size of a VP... and then you tune from there. You may need another couple of pools to optimize performance - and the total memory you need may be more, or less than you currently have allocated. I find most site can optimize in 6-8 pools, and some may need a few more. [...]
3032 114 25_Re: LARGE DB2 BUFFERPOOLS10_Bill Welch27_spgwdw@UCLINK4.BERKELEY.EDU31_Tue, 29 Feb 2000 09:02:52 -0800465_us-ascii Many performance analysts say that your hiperpools should be twice the size of your virtual pools for the best performance. Assuming that will be true in your case, you might get better performance with this configuration:<br><br>BP0 just catalog and directory 8,000 pages VP 16,000 pages HP BP1 just index access 8000 pages VP 16,000 pages HP BP2 just tablespace access 8,000 pages VP 16,000 pages HP BP3 just db2 workfiles 15000 pages VP 0 pages HP [...]
3147 321 43_Re: Equivalent of "Describe" command in DB227_Radonjic, Bora (Consultant)23_BRadonjic@ACNIELSEN.COM31_Tue, 29 Feb 2000 11:02:40 -0600522_- Apart from using tools you may use DRAW command in QMF:<br><br>SQL QUERY MODIFIED LINE 1<br><br><br><br><br><br>UPDATE SYSIBM.SYSTABLES SET<br><br>-- COLUMN NAME ENTER VALUES BELOW DATA TYPE LENGTH NULLS NAME= -- VARCHAR 18 NO , CREATOR= -- CHAR 8 NO , TYPE= -- CHAR 1 NO , DBNAME= -- CHAR 8 NO , TSNAME= -- CHAR 8 NO , DBID= -- SMALLINT NO , "OBID"= -- SMALLINT NO , COLCOUNT= -- SMALLINT NO , EDPROC= -- CHAR 8 NO , VALPROC= -- CHAR 8 NO , CLUSTERTYPE= -- CHAR 1 NO , CLUSTERRID= -- INTEGER NO , CARD= -- INTEGER [...]
3469 90 25_Re: Large (?) bufferpools0_31_truman.g.brown@BELLATLANTIC.COM31_Tue, 29 Feb 2000 12:40:16 -0500460_us-ascii Harby,<br><br>I assume you're using DB2 V5/OS390; 15,000 pages really isn't that large.<br><br>Your BP0 is probably larger than necessry; we have several quite large databases with a BP0 of 6,000 pages. The 4K work dataset bufferpool should be the same size as the one for tablespaces (larger if there are lots of large concurrent cursers, e.g., more than one per thread). Index bufferpool can normally be smaller than the tablespace bufferpool. [...]
3560 123 33_Re: Time consuming Load Processes12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Tue, 29 Feb 2000 19:46:16 +0200583_x-user-defined Hi, Another thought. What's the blocksize of the sequential data sets? - Should be about half a track. What's the number of buffers used while loading? - If you can up it to about 80-90 it may help. (Pay attention to region size in that case).<br><br>Isaac Yassin<br><br><br><br><br><br>Jeff A L'Italien wrote: > > Kartik, > > We in doing exactly the same as what as you are attempting to do. If your > production and test machines are in the same relative physical location, you > might want to explore the possibility of using cross-center cataloguing of the > [...]
3684 70 25_Re: Large (?) bufferpools14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Tue, 29 Feb 2000 12:50:32 -0500530_ISO-8859-1 Many sites get a decent return when putting an HP behind the BP for the sortworks. You have to try it to see if it helps you or not. You need to monitor the avg pages/write when determining how to set VDWQT. In most systems this seems to be a low number... like 1.5, or 2.7, or 3.9. When this is low the VDWQT should be set to ZERO unless you are in a datasharing environment. Also, be careful of setting the Sortpool size in your zparm. Since this is max space PER USER, several large concurrent sorts will drive [...]
3755 123 43_Re: DB2 Enterprise Edition and perl DBD/DBI12_Janet Rolsma12_janet@NM.NET31_Tue, 29 Feb 2000 11:13:08 -0700356_us-ascii Actually, we use perl for a lot of our web applications here. For the smaller applications, it has good performance, especially if you use the modperl which supports persistent connections to the database.<br><br>We are using Linux and AIX DB2 UDB and our databases are rather small. We find it's easier to develop something quickly in perl. [...]
3879 28 31_NFS mounted databases (UDB 5.2)12_Janet Rolsma12_janet@NM.NET31_Tue, 29 Feb 2000 11:15:02 -0700318_us-ascii Just FYI:<br><br>The answer from IBM support is that they do not support the database on NFS mounted drives but they do support the sqllib mounted NFS.<br><br>So, Scott, you were right that they aren't supported even though they now allow you to create the database on the drive that's mounted that way. [...]
3908 92 21_Re: Why Not DB2??????12_Greg P Mucha24_Greg_P_Mucha@CARADON.COM31_Tue, 29 Feb 2000 18:25:31 +0000606_us-ascii Well, Bill,<br><br>How much sense does it make, from a business standpoint, to buy a DBMS from a hardware vendor??<br><br>That's a strong argument to overcome when you're pitching to a customer that has seen IBM get swallowed up by a marketplace on fire, and REMEMBERS the expense per megaflop and cost per megabyte of mainframe horsepower, meanwhile all these PC dweebs were buying tremendous computing power for practically bupkis. It tends to torque the shorts of an IT manager whose company won't put a CIO on the Executive Board because the suits in Finance took PC Computing courses in [...]
4001 26 23_FW: Message Quarantined26_Thornton Patrick (DBM1PXT)15_dbm1pxt@UPS.COM31_Tue, 29 Feb 2000 13:24:45 -0500470_iso-8859-1 I am getting 20-30 of these a/day .... anything you think might be causing this????? my id was changed to pthornton@ups.com .....<br><br><br><br><br><br>-----Original Message----- From: InterScan@ups.com [mailto:InterScan@ups.com] Sent: Tuesday, February 29, 2000 11:54 AM To: dbm1pxt@us.ups.com Subject: Message Quarantined<br><br><br><br><br><br>A decoding error has been detected in your message from owner-db2-l@RYCI.COM. The message is quarantined. [...]
4028 149 27_Re: DB2 connect w/ MS Query9_John Reid14_jreid@FBFS.COM31_Tue, 29 Feb 2000 12:31:22 -0600385_us-ascii Craig, Thanks for your help. We don't have a msqry32.dbg either but that is what shows up in the diagonistics. I did get it to work some what by creating a MS ACCESS linked MDB to DB2 OS/390 and then access that from MS QUERY. But it won't let me save the query I created. So for now I have refered it to our network guys to re-install MS QUERY to see if that will help. [...]
4178 27 30_DB2 DBA needed in Portland, OR6_RandyS27_RandyS@EMPLOYMENTTRENDS.COM31_Tue, 29 Feb 2000 10:24:06 -0800459_iso-8859-1 Employment Trends, a leading professional services company in Portland, OR is actively looking for an experienced DB2 DBA to join an internet start up company here in Portland. In this position you will be doing all associated DBA tasks, including architecture, design, performance tuning and backup/restore. This position requires five years DB2 DBA experience plus five years Unix experience. Great opportunity at this fast growing company. [...]
4206 21 18_ABEND 04E000 hex ?0_22_Rohn.Solecki@MTS.MB.CA31_Tue, 29 Feb 2000 12:37:38 -0600468_us-ascii "Abend 04E000 hex occurred processing command 'DSN '. "<br><br>I got that error when trying to do a SPUFI on a single table (SELECT * FROM DB.TB;) . SPUFI is abended, I am returned to the DB2I menu. The table was recently loaded (and RUNSTAT'ed) with no apparent errors (I still have the load job output). I can access other tables in the db with no problem. TS is in RW status. I could not find any form of the error in bookreader. OS/390 V2.4, DB2 V5. [...]
4228 18 29_Use of COMMENT ON for columns19_Lisa Westcott-Dryer29_Lisa_Westcott-Dryer@AMWAY.COM31_Tue, 29 Feb 2000 14:19:25 -0500317_us-ascii I'm wondering whether or not to use this feature and if it would be helpful somewhere. Does anyone have experiences? Does anyone use the COMMENT ON feature in DB2 (I'm V5)? Is it a performance issue? Has anyone made COMMENT ONs helpfull to others (clients etc.) - see it or use it in some way? Curious. [...]
4247 20 33_DB2 Connect & Password Encryption10_Ben Alford21_PA7280@UTKVM1.UTK.EDU29_Tue, 29 Feb 2000 14:37:29 EDT363_US-ASCII Has anyone tried the Password Encryption Support in DB2 Connect?<br><br>It was added to DB2 Connect V5.2 via fixpack 7 and is part of DB2 Connect V6.1. We've tried to use it with DB2 for OS/390 and keep getting SQL1402N.<br><br>Ben Alford (865) 974-1600 Enterprise Systems Programming University of Tennessee, Knoxville INTERNET: ben-alford@utk.edu [...]
4268 63 22_Re: DB2 connectivity..0_15_leon@CA.IBM.COM31_Tue, 29 Feb 2000 14:39:02 -0500488_us-ascii Please don't take this the wrong way but what you are asking is to compare a steering wheel with a car. ODBC is an API much like Embedded SQL is i.e. it is something that an application developer has to know. DB2 Connect is a product that provides API(s) (including ODBC) as well as the rest of the infrastructure to make it work. To draw a parallel with my previous statement ODBC is like a steering wheel and DB2 Connect is the whole car that includes the steering wheel. [...]
4332 47 22_Re: ABEND 04E000 hex ?14_Wayne Driscoll19_wdriscoll@QUEST.COM31_Tue, 29 Feb 2000 11:53:24 -0800404_iso-8859-1 Abend Code 04E is one of the default DB2 Abends. Look in the job log of the DBM1 or MSTR address space (or in the SYSLOG for error messages from DB2. There should be an error code associated with the abend that you will need to look up in the DB2 Messages Manual. Good luck. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own. [...]
4380 91 21_Re: Why Not DB2??????14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Tue, 29 Feb 2000 14:56:58 -0500594_ISO-8859-1 If you really take a look at the costs, it's generally less expensive to put it on the mainframe than on many dozens of smaller server platforms. When you look at really large systems with massive data volumes, the only place they can currently run effectively is on the mainframe. If you look at the real benchmarks, and TPC and TPD data (and can avoid the apple to football comparisons) DB2 blows away everything else in the marketplace. IBM has been Gaining marketshare with DB2 on the non-mainframe platforms as well. Then there are always the standard factors of security, [...]
4472 91 33_Re: Time consuming Load Processes7_I Singh21_ISingh@DSTSYSTEMS.COM31_Tue, 29 Feb 2000 13:52:52 -0600507_us-ascii DSN1COPY might not be a feasible solution if you have varchar fields for then you will have to reorg your tables on test. ---------------------- Forwarded by Inderpal Singh/IRM/DST/US on 02/29/2000 01:49 PM ---------------------------<br><br><br><br>Isaac Yassin <yassin@NETVISION.NET.IL> on 02/28/2000 12:11:17 PM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br>To: DB2-L@RYCI.COM cc: (bcc: Inderpal Singh/IRM/DST/US) Subject: Re: Time consuming Load Processes [...]
4564 12 26_Header page field HPGCLRSN11_Lori Bewley21_lori_bewley@SABRE.COM31_Tue, 29 Feb 2000 14:13:54 -0600461_- We're are in the process of testing SMS Concurrent copy and noticed that this field, HPGCLRSN, is not updated by concurrent copy, but is updated by the regular DB2 copy. Can anyone explain what this field is used for?<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.
4577 53 30_Re: Header page field HPGCLRSN15_Murley, Michael22_Michael_Murley@BMC.COM31_Tue, 29 Feb 2000 14:53:27 -0600554_ISO-8859-1 This field in the header page represents the logpoint of the most recent image copy and is used to determine whether or not an update to a data page should cause that page to be marked in the space map for inclusion in a subsequent incremental image copy.<br><br>When a data page is updated, DB2 compares the current data page PGLOGRRBA value (last update RBA or LRSN) to HPGCLRSN in the header page. If PGLOGRBA is lower than the most recent copy, this must be the first update to the page since that copy. So DB2 sets the modified page [...]
4631 16 28_I want to automate the REORG11_Arne Nilsen18_Arne.Nilsen@SDS.NO31_Tue, 29 Feb 2000 21:52:53 +0100478_- and I'm looking for parameters to decide execution or not. Can anybody help me with values ("thumb-rules") for CLUSTERRATIO, FAROFFPOS, LEAFDIST, NEAROFFPOS,NLEAF, NLEVELS etc. Any written papers/books to recommend?<br><br>Arne Nilsen<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.
4648 42 33_Re: Use of COMMENT ON for columns17_Alessandro Brezzi28_brezzi.isac@INTERBUSINESS.IT31_Tue, 29 Feb 2000 22:05:11 +0100626_us-ascii In our shop, "COMMENT ON" is required for documentation in every DDL. So you can prepare some QMF report from the catalog for every table in a database or for selected table ...<br><br>HTH Alessandro<br><br>>I'm wondering whether or not to use this feature and if it would be helpful >somewhere. Does anyone have experiences? Does anyone use the COMMENT ON >feature in DB2 (I'm V5)? Is it a performance issue? Has anyone made >COMMENT ONs helpfull to others (clients etc.) - see it or use it in some >way? Curious. > >Lisa > >================================================ >To change your subscription options [...]
4691 14 32_Re: I want to automate the REORG12_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM31_Tue, 29 Feb 2000 14:58:48 -0600468_us-ascii There are a group of queries that come in the db2 samplib that you can use as a rule of thumb. These queries tell you what needs to be reorged. You could also get Mullins DB2 Developers Guide for some recommendations.<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.
4706 88 30_Re: Header page field HPGCLRSN20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 29 Feb 2000 16:06:20 -0500376_us-ascii That was a very nice explanation Mike.<br><br>Also in v6 the TRACKMOD NO has the following functionality -<br><br>Insert or delete operation on the page always populates HPGCLRSN as well as PGLOGRRBA. The space map modified bit is also updated to indicated modified page.<br><br>On the other hand Updates on the page does not modify second part of the spacemap. [...]
4795 40 32_Re: I want to automate the REORG11_rick creech18_ykcirc@HOTMAIL.COM29_Tue, 29 Feb 2000 13:12:43 PST472_- The queries are also in the DB2 utility guide. According to the V6 Migration Class, in version 6 the reorg utility will give you the option of having the reorg utility doing these queries and only performing the reorg if indicated criteria are met. For example, if you have a regularly scheduled weekly reorg, the job will run every week but the reorg may or may not actually take place depending upon the condition of the tablespace or index. Regards, Rick Creech [...]
4836 16 32_Re: I want to automate the REORG13_Dan S Brogdon22_Dan.S.Brogdon@AEXP.COM31_Tue, 29 Feb 2000 15:11:18 -0700452_- Use BMC DASD+ - leafdist at 250, max extents at 5, clusterratio at 90. Use the history tables to monitor your windows, use the slib to control dasd and tape, i.e. go to tape on sysrec if greater than 50 cyls.<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.
4853 68 33_Re: Use of COMMENT ON for columns40_Andersen, Cindy (CC-Application Support)26_Cindy.Andersen@CONAGRA.COM31_Tue, 29 Feb 2000 16:29:45 -0600585_iso-8859-1 At a previous company, we also added the COMMENT ON to each Table and each Column definition. It did take time to generate these definitions, i.e. someone had to write them up and key the statements in, but they proved to be invaluable.<br><br>The DBAs set up QMF procs(with special QMF queries & QMF forms for each report) to list all tables for a given application system with their description & related info, to list all columns with their description for each table in a given application system, and to list all indexes with their columns & descriptions for each [...]
4922 51 43_Re: Equivalent of "Describe" command in DB215_Mallett, Steven38_Steven.Mallett@CORPMAIL.TELSTRA.COM.AU30_Wed, 1 Mar 2000 09:44:10 +1100559_- We've got a query that runs on DB2 V5.1 using QMF 3.3 which gives for each table in a DB2 Database column name, description (format) and nullability/defaults #pages and #rows in table index columns, type, order #pages and #nodes on each index foreign key columns and types<br><br>The reports can be quite lengthy for a complex database ( in our case 40 pages for 130 tables ) but takes only a few seconds to run. I'd imagine the QUERY would require some customization on you're behalf but if you're interested give as a 'hoy and I'll try and provide a [...]
4974 52 19_Re: Machine Upgrade15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Thu, 24 Feb 2000 13:35:23 -0600341_us-ascii Remember, the more CPs that exist on the complex (image, LPAR), the more MVS overhead (wasted CPU as MVS intercommunicates amongst CPs) there is.<br><br>Since CICS is a single TCB structure (excluding RCT TCBs and VSAM write subtasking TCB SIT option), fewer faster CPs will allow more functional capacity (less MVS overhead). [...]
5027 31 14_SQL Procedures0_18_damcon2@US.IBM.COM31_Tue, 29 Feb 2000 17:57:29 -0500534_us-ascii Hello all,<br><br>I've been able to find information regarding SQL procedures for OS/390, but am unable to find anything for AIX. Anyone know what the availability of this feature on the AIX platform is?<br><br>Thanks, 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 ----------------------------------------------------- [...]
5059 49 25_Re: LARGE DB2 BUFFERPOOLS15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Thu, 24 Feb 2000 14:01:37 -0600555_us-ascii When you begin to experience MVS WAIT for PAGE-IN for your xxxxDBM1, you have too many buffers (DB2 I/O algorithm is better for getting multiple, consecutive pages than the MVS Paging I/O methodology).<br><br>Jim Lewandowski<br><br><br><br>HARBRY ARIZA wrote: > > Hi Folks: > > Here I have another point that I would like to discuss with all of you. > How I would know when a db2 bufferpool is too large or large because I want > to improve my hit ratio on my db2 bufferpools and I know that the sum of all > DB2 virtual buffer pools cannot [...]
5109 56 18_Re: SQL Procedures0_15_leon@CA.IBM.COM31_Tue, 29 Feb 2000 18:33:32 -0500398_us-ascii DB2 UDB for UNIX, Windows NT, and OS/2 supports stored procedures written in Java or other 3GL languages. You can expect to see support for stored procedures written in procedural SQL to be delivered shortly as part of our new upcoming release.<br><br>Leon Katsnelson, DB2 Connect Development Manager mailto:leon@ca.ibm.com<br><br><br><br>damcon2@US.IBM.COM on 02/29/2000 05:57:29 PM [...]
5166 70 85_PeopleSoft on DB2 for OS/390 Performance & Tuning Class - Minneapolis 3/27/00-3/28/0013_BRIAN HOLROYD31_BRIAN_HOLROYD@DB-CONSULTING.COM31_Tue, 29 Feb 2000 17:53:50 -080069_iso-8859-1 Visit http://www.db-consulting.com/seminar.htm for details
5237 76 19_Re: Machine Upgrade14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Tue, 29 Feb 2000 21:16:38 -0500472_ISO-8859-1 And depending on your workload, fewer faster engines may provide less total concurrency and throughput. Everything depends on the particular workload. There is no overall best answer, or optimal worldwide solution. Regards, Joel<br><br><br><br><br><br>Message text written by DB2 Data Base Discussion List > >Remember, the more CPs that exist on the complex (image, LPAR), the more >MVS overhead (wasted CPU as MVS intercommunicates amongst CPs) there is. [...]
5314 13 24_DB2 V4 or V5 requirement15_anthony babonas28_tonybabonas@WORLDNET.ATT.NET31_Tue, 29 Feb 2000 20:08:04 -0600302_iso-8859-1 Is DB2 V5 required for web enablement on OS/390 ?<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.
5328 98 25_Re: LARGE DB2 BUFFERPOOLS16_Galambos, Robert29_Robert_Galambos@COMPUWARE.COM31_Tue, 29 Feb 2000 23:21:15 -0500670_iso-8859-1 <br><br>Harby<br><br>There is an excellent presentation, by chuck Hoover, concerning bufferpool management. the URL is http://www.compuware.com/products/db2.htm<br><br>Look for the link to Chuck Hoover presentation series. This is a technical presentation with no marketing fluff. Hope this helps<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>-----Original Message----- From: HARBRY ARIZA [mailto:harbry_a@HOTMAIL.COM] Sent: February 29, 2000 11:35 AM To: DB2-L@RYCI.COM Subject: LARGE DB2 BUFFERPOOLS [...]
5427 136 30_Re: Header page field HPGCLRSN20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 29 Feb 2000 23:23:23 -0500408_iso-8859-1 Yup.. That is a typo. What I was trying to say was insert/delete modifies PGLOGRBA as well as spacemap. I didn't mean HPGCLRSN. I should have been more careful while typing that. It just slipped.<br><br>-----Original Message----- From: Murley, Michael [mailto:Michael_Murley@bmc.com] Sent: Tuesday, February 29, 2000 5:49 PM To: 'venkat_pillay@ML.COM' Subject: FW: Header page field HPGCLRSN [...]
5564 229 43_Re: DB2 V5,type 2 indexes, currentdata(yes)17_Nagaraj Pudukotai33_nagaraj.pudukotai@HPSBLR.SOFT.NET30_Mon, 1 Mar 1999 09:55:48 +0530301_iso-8859-1 Hi Sanjeev, The following is some documentation I found in SQL REFERENCE which partly answers your question.<br><br>6.51 OPEN © Copyright IBM Corp. 1982, 1997 Topic lines 155 to 171 of 262 | Effect of a temporary copy of a result table: DB2 can process a cursor in two different ways: [...]
5794 332 43_Re: DB2 V5,type 2 indexes, currentdata(yes)10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM28_Wed, 1 Mar 2000 05:01:36 GMT572_iso-8859-1 Thanks to Nagraj and Roger for a very clear explanation.<br><br>Regards<br><br>Sanjeev<br><br><br><br><br><br><br><br>Nagaraj Pudukotai <nagaraj.pudukotai@HPSBLR.SOFT.NET>@RYCI.COM> on 03/01/99 09:55:48 AM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br>Sent by: DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br><br><br>To: DB2-L@RYCI.COM cc: Subject: Re: DB2 V5,type 2 indexes, currentdata(yes)<br><br><br><br>Hi Sanjeev, The following is some documentation I found in SQL REFERENCE which partly answers your question. [...]