1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l November 1999, week 5
2 26 15_db2 5.1 and csa18_Campidoglio, Elena29_E.Campidoglio@CEDACRIOVEST.IT31_Mon, 29 Nov 1999 10:35:27 +0100458_- hi everybody, perhaps this argument has been posted some time ago, at any rate... we suspect that the ipl of this morning at our site has been caused by an exaggerate use of csa by our new db2 subsystem at level 5.1 that we activated in production a week ago. this subsystem has very little activity and by now has used a bit more csa than our heavy production subsys. if someone would like to tell his experience on thisargument I'd be very thankful [...]
29 149 15_Re: SQL Problem0_24_DB46@DAIMLERCHRYSLER.COM31_Mon, 29 Nov 1999 07:33:49 -0500455_us-ascii <br><br><br><br><br><br>Grouping the result of this join is not the problem. Sorting the groups is. So I would do a nested table using the min time of the group to 'mark' the lowest one as follows:<br><br>SELECT ET.EMPNO, ET.LASTNAME, IO.IN, IO.OUT, T1.MIN_IN FROM EMPLOYEE ET, INOUT IO, (SELECT EMPNO, MIN (IN) AS MIN_IN FROM INOUT GROUP BY EMPNO) AS T1 WHERE ET.EMPNO = T1.EMPNO AND ET.EMPNO = ET.EMPNO ORDER BY T1.MIN_IN, ET.EMPNO, IO.IN [...]
179 46 46_Re: Gordon Reich/WCBAlta is out of the office.18_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM31_Mon, 29 Nov 1999 06:55:28 -0600620_iso-8859-1 Gordon, please don't AutoReply to db2-l. To stop posts while you're gone send the following to: listserv@ryci.com SET NOMAIL to resume posts SET MAIL<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, [...]
226 263 27_Re: DB2 Tools - CA/Platinum18_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM31_Mon, 29 Nov 1999 07:44:34 -0600607_iso-8859-1 Hi all, Platinum provided a list of recommended catalog indexes, by product, in their install guide several releases ago (P97something). I don't know if the list has been updated for the more recent releases, or even provided anymore.<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 received this message in error, please notify the [...]
490 15 24_Re: Year 2000 procedures0_22_Bob_Yoder@ILLINOVA.COM31_Mon, 29 Nov 1999 07:43:18 -0600516_us-ascii We are planning on taking everything down by 11:58pm and bring it backup after midnight(except for OS/390). Then we plan on image copying evey application. We are doing it to protect the application data from applications that might have some sort of a logic error.<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.
506 55 19_Re: db2 5.1 and csa22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Mon, 29 Nov 1999 13:13:59 +0000296_ISO-8859-1 Elena ....I am going to guess from your mail that you have a storgae problem with DB2 .. if this is the case (and you are on the correct release for the problem to happen) can you confirm to me that you have applied the PTF for the db2 storgae problem "storage contraction" ... ? [...]
562 42 24_Re: Year 2000 procedures24_The Fillmore Group, Inc.18_fillmore@CLARK.NET31_Mon, 29 Nov 1999 08:42:26 -0800495_us-ascii An IBMer told me - and I'm trying to get positive confirmation - that IBM recommends NOT reIPLing, recycling DB2, or doing anything else that you don't usually do on 12/31/1999. It makes sense: if you don't usually reIPL, etc. on a Friday night/Saturday morning you are introducing a whole new set of variables. If you are at the requisite levels of software you shouldn't have to take extraordinary measures. The image copy to protect against a logic error is a good idea though. [...]
605 40 11_unsubscribe12_Dennis Monce20_dennis.monce@ASU.EDU31_Mon, 29 Nov 1999 07:45:40 -070022_iso-8859-1 unsubscribe
646 91 15_Re: SQL Problem0_24_DB46@DAIMLERCHRYSLER.COM31_Mon, 29 Nov 1999 07:43:21 -0500431_us-ascii Grouping the result of this join is not the problem. Sorting the groups is. So I would do a nested table using the min time of the group to 'mark' the lowest one as follows:<br><br>SELECT ET.EMPNO, ET.LASTNAME, IO.IN, IO.OUT, T1.MIN_IN FROM EMPLOYEE ET, INOUT IO, (SELECT EMPNO, MIN (IN) AS MIN_IN FROM INOUT GROUP BY EMPNO) AS T1 WHERE ET.EMPNO = T1.EMPNO AND ET.EMPNO = ET.EMPNO ORDER BY T1.MIN_IN, ET.EMPNO, IO.IN [...]
738 66 46_Re: Gordon Reich/WCBAlta is out of the office.13_Baldon, David20_David_Baldon@BMC.COM31_Mon, 29 Nov 1999 09:52:58 -0600482_ISO-8859-1 Rick, If I SET NOMAIL and then 2 weeks later I SET MAIL, will I then get all the posts that were sent during the NOMAIL period? If not do you know how that can be accomplished? I suspect this could be why folks don't want to SET NOMAIL.<br><br>Thanks.....David<br><br>-----Original Message----- From: DAVIS, RICK (SWBT) [mailto:RD8246@MOMAIL.SBC.COM] Sent: Monday, November 29, 1999 6:55 AM To: DB2-L@RYCI.COM Subject: Re: Gordon Reich/WCBAlta is out of the office. [...]
805 187 39_Re: Workload Balancing over DB2 Connect0_17_ttaylor@CHUBB.COM31_Mon, 29 Nov 1999 11:08:38 -0500542_us-ascii Leon<br><br>1) please expand upon why I would see 'lower host CPU' ( host being 0S/390) 2) we currently use distributed directory infront of the ddcs gateways. does e-network dispatcher replace this or work with it.<br><br><br><br>Tom<br><br><br><br><br><br><br><br><br><br><br><br><br><br>leon@ca.ibm.com on 11/24/99 11:58:25 PM<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) [...]
993 92 37_Re: Another Data Compression question11_Paul Turpin26_Paul.Turpin@FIRSTUNION.COM31_Mon, 29 Nov 1999 10:03:30 -0800544_- Thank you for your response. I do need some further clarification, if you don't mind. You mention using NPAGES instead of SPACE. I am looking at the description of the data in the NPAGES column and it says it is the total number of pages on which rows appear. That sounds like this column would need to be multiplied by 4K or 32K (depending on page size). This column appears to be updated by RUNSTATS, which was just run on the object I am interested in. The NPAGES value is 219,310. The problem with using this value is the tablespace [...]
1086 24 30_Re: out of the office notices.13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 29 Nov 1999 11:13:55 -0500609_iso-8859-1 Hi David, What I do when I'm away is Set Nomail<br><br>and then get caught up perusing the archive site at http://jupiter.ryci.com/archives/db2-l.html.<br><br>I have to comment that the archives are much more reliable now than when the list was at American.edu.<br><br>David Seibert Compuware Corporation File-AID product planner Dave_Seibert@compuware.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.
1111 96 46_Re: Gordon Reich/WCBAlta is out of the office.18_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM31_Mon, 29 Nov 1999 10:18:16 -0600600_iso-8859-1 David, I don't know the answer for sure, but it seems you should be able to get any missed posts from the archives should you need them. Try sending your question to: db2-L-request@ryci.com<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 [...]
1208 124 37_Re: Another Data Compression question18_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM31_Mon, 29 Nov 1999 10:27:22 -0600585_iso-8859-1 Paul, Another thing you can do is to STOP/START the tablespace partitions, then do a IDCAMS LISTCAT on them. Then find HI-USED-RBA for each. Add them up and divide the sum by 737280 to give 3390 triple cylinders.<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 received this message in error, please notify the [...]
1333 138 55_Re: Oracle Transparent Gateway TCP/IP to DB2 for OS/39022_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Mon, 29 Nov 1999 11:27:54 -0500588_iso-8859-1 Robi -<br><br>Thanks for the info. It appears that you're using Oracle Transparent Gateway for DB2. I agree that this supports TCP/IP. My understanding is that this solution runs as a task on OS/390. That's not our 1st choice solution.<br><br>We are interested in TCP/IP support from a different solution - Oracle Transparent Gateway for IBM DRDA. This product is installed on the HP-UX box and talks to DB2 through a SNA DRDA connection. I was wondering if anyone was aware if Oracle Transparent Gateway for IBM DRDA supported a TCP/IP DRDA connection to DB2 for OS/390. [...]
1472 222 39_Re: Workload Balancing over DB2 Connect0_15_leon@CA.IBM.COM31_Mon, 29 Nov 1999 11:36:36 -0500446_us-ascii We have performed extensive measurements of TCP/IP vs. SNA connectivity. The results are very clear: "TCP/IP is a much better choice for connecting to DB2". These are the areas where TCP/IP excels: 1. TCP/IP provides significantly better overall throughput. 2. TCP/IP provides better response time 3. TCP/IP consumes much less resources on DB2 Connect servers 4. TCP/IP consumes significantly less S/390 CPU (OS/390 V2R6 and later) [...]
1695 119 37_Re: Another Data Compression question15_Philip, Sibimon19_PhilipS@SEALAND.COM31_Mon, 29 Nov 1999 12:02:24 -0500741_ISO-8859-1 Paul,<br><br>You can find NPAGES for each partition from sysibm.systabstats after RUNSTATS.<br><br>Thanks Sibimon Philip 972-702-2515 - Office 972-417-3597 - Residence E-mail - Sibimon_philip@sealand.com<br><br><br><br><br><br>-----Original Message----- From: Paul Turpin [mailto:Paul.Turpin@FIRSTUNION.COM] Sent: Monday, November 29, 1999 12:04 PM To: DB2-L@RYCI.COM Subject: Re: Another Data Compression question<br><br><br><br>Thank you for your response. I do need some further clarification, if you don't mind. You mention using NPAGES instead of SPACE. I am looking at the description of the data in the NPAGES column and it says it is the total number of pages on which rows appear. That sounds like this column would [...]
1815 19 31_DB2 Installation Process on AIX10_Nash Gupta19_nashgupt@US.IBM.COM31_Mon, 29 Nov 1999 12:17:22 -0500423_us-ascii Hello List!<br><br>Is there any book/redbook/white paper etc. that gives a good treatment of DB2 installation on AIX 4.3 ??<br><br>Help is appreciated.<br><br>-- Nash Gupta<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.
1835 66 35_Re: DB2 Installation Process on AIX0_15_sokeefe@VCU.EDU31_Mon, 29 Nov 1999 12:20:12 -0500719_us-ascii Nash, I have always found the IBM DB2 Universqal Database for UNIX "Quick Beginings" manual to be sufficient for an install. Version 5 has a part number of: S10J-8148-00. Good luck,<br><br>Sean<br><br>Sean O'Keefe Virginia Commonwealth University Administrative Systems/Applications Technical Services Operating Systems Analyst (804) 828-8415 sokeefe@vcu.edu<br><br><br><br><br><br>|--------+-----------------------> | | Nash Gupta | | | <nashgupt@US.| | | IBM.COM> | | | | | | 11/29/1999 | | | 12:17 PM | | | Please | | | respond to | | | DB2 Data Base| | | Discussion | | | List | | | | |--------+-----------------------> >----------------------------------------------------------------------------| | [...]
1902 29 44_UDB NT 6.1 and DB2 Connect 5.2 compatibility13_Lynne Flatley17_LFlatley@NEFN.COM31_Mon, 29 Nov 1999 12:27:17 -0500386_- We are planning on installing UDB 6.1 on NT shortly. I have a couple of questions regarding this that I'd like to ask you folks.<br><br>Does UDB 6.1 come with a type 4 JDBC driver and a type 3 ODBC driver?<br><br>We currently have DB2 Connect 5.2 installed in both test and production. Will there be a computability issue with the CAE accessing both DB2 Connect 5.2 and UDB 6.1? [...]
1932 26 37_Re: Another Data Compression question16_Daniel Boulanger19_dboulang@CA.IBM.COM31_Mon, 29 Nov 1999 12:21:47 -0500389_us-ascii One easy way to calculate the number of active pages is to extract the information from the ListCat command.<br><br>Construct you ListCat command using the VCatName.DSNDB*.DbName.TsName... then calculate the space by substracting the LO-RBA from the HI-RBA. Divide the result by 4096 to have it in 4K increments. Hope it helps. The best thing is this method is not RUNSTATS. [...]
1959 49 37_Re: Another Data Compression question15_Philip, Sibimon19_PhilipS@SEALAND.COM31_Mon, 29 Nov 1999 12:36:25 -0500522_ISO-8859-1 Is LO-RBA and HI-RBA current or is it based on the last file close?<br><br>Sibimon Philip 972-702-2515 - Office 972-417-3597 - Residence E-mail - Sibimon_philip@sealand.com<br><br><br><br><br><br>-----Original Message----- From: Daniel Boulanger [mailto:dboulang@CA.IBM.COM] Sent: Monday, November 29, 1999 11:22 AM To: DB2-L@RYCI.COM Subject: Re: Another Data Compression question<br><br><br><br>One easy way to calculate the number of active pages is to extract the information from the ListCat command. [...]
2009 265 39_Re: Workload Balancing over DB2 Connect0_17_ttaylor@CHUBB.COM31_Mon, 29 Nov 1999 12:48:25 -0500912_us-ascii Leon<br><br>What about question #2 - using distributed director in front of the gateways<br><br>Tom<br><br><br><br><br><br><br><br><br><br><br><br><br><br>leon@CA.IBM.COM on 11/29/99 11:36:36 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: Workload Balancing over DB2 Connect<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>We have performed extensive measurements of TCP/IP vs. SNA connectivity. The results are very clear: "TCP/IP is a much better choice for connecting to DB2". These are the areas where TCP/IP excels: 1. TCP/IP provides significantly better overall throughput. 2. TCP/IP provides better response time 3. TCP/IP consumes much less resources on DB2 Connect servers 4. TCP/IP [...]
2275 159 36_Re: Platinum Rapid Reorg and Maxrows19_Ohling, Tim R - CNF18_Ohling.Tim@CNF.COM31_Mon, 29 Nov 1999 09:53:02 -0800364_iso-8859-1 What version of Platinum are you on? That is: is it (supposed to be) current with the version of DB2 you are running or is a product bug?<br><br>Thanks, Tim<br><br><br><br>-----Original Message----- From: Marcel Lepage [mailto:iml@COLBA.NET] Sent: Friday, November 26, 1999 10:12 PM To: DB2-L@RYCI.COM Subject: Re: Platinum Rapid Reorg and Maxrows [...]
2435 51 24_Re: Year 2000 procedures10_Mark Labby16_mlabby@PHEAA.ORG31_Mon, 29 Nov 1999 13:29:32 -0500372_us-ascii Our systems have been tested repeatedly, both in an LPAR and at an off-site facility and everything seems fine. However, we are a financial services company, and in order to make sure there is no possiblity of any repercussions or questions about performing due diligence, we are doing the belt, suspenders, safety pins, and rope around the waist routine... [...]
2487 272 27_Re: DB2 Tools - CA/Platinum16_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Mon, 29 Nov 1999 13:47:03 -0500600_- I see RC/Migrator and RC/Update as essential because of the number of objects. Since PeopleSoft now delivers the complete set of tables whether you purchase all modules or not, you can be creating 4.900+ tables (+ views + indexes etc) for the Financial side and 3,300 tables (+ views + indexes etc) for the HR side of the house. Mitrator will be essential as you create multiple instances for testing/production. I have not used RC/Query, but then we have QMF and Fileaid for DB2 for that purpose. We also have recently Index Expert, Detector, Subsystem Analyzer and Thread Terminator. Thread [...]
2760 99 24_Re: Year 2000 procedures8_Long, Ed15_Ed.Long@FMR.COM31_Mon, 29 Nov 1999 13:54:53 -0500482_- Very interesting procedure.<br><br>One set of lawyers I have heard said don't do anything different than you normally do. The approach described in Mark's note certainly deviates from the norm. But as he says, it also represents one approach to minimizing the risk of being sued.<br><br>The other alternative is to try to keep things as normal as possible and not stop anything. For many organizations 12*31 and 1*03 are workdays a fact which severely limits backup options. [...]
2860 202 63_Re: -632 on Foreign key DDL: Can somebody from IBM answer this?15_Philip, Sibimon19_PhilipS@SEALAND.COM31_Mon, 29 Nov 1999 13:59:07 -0500622_iso-8859-1 Sibimon Philip 972-702-2515 - Office 972-417-3597 - Residence E-mail - Sibimon_philip@sealand.com<br><br>-----Original Message----- From: DAVIS, RICK (SWBT) [mailto:RD8246@MOMAIL.SBC.COM] Sent: Wednesday, November 24, 1999 8:21 AM To: DB2-L@RYCI.COM Subject: Re: -632 on Foreign key DDL<br><br><br><br>Mike, Now that I've reread my reply I agree with you. I ran two rules together leaving a wrong impression. Previously, I emailed Sibimon directly saying I agreed with him in that there doesn't seem to be any reason why two SET NULL "children" can't exist for a single "parent". I'd like to know why too! [...]
3063 28 15_Package Backups12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Mon, 29 Nov 1999 12:57:00 -0500309_- We are looking at methods of backing up packages as part of implementing modified production programs. The idea here is to switch back to an older version of a program without too much pain and to keep an existing access path in case performance is degraded or problems occur with the updated program. [...]
3092 20 9_SAP Stats12_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM31_Mon, 29 Nov 1999 13:11:42 -0600577_us-ascii Has anyone adjusted the space parameters for their SAP application? We are running DB2 version 5 on OS/390. We have done a runstats and developed a program to create ALTER statements for PRIQTY and SECQTY. The program takes the value in the SPACE column from SYSTABLEPART and divides it by 4 and plugs the value into an ALTER statement for PRIQTY. It then takes 10 percent of that value and plugs it into the SECQTY. We are also changing FREEPAGE and PCTFREE. Using C. Mullins recommendation, we changed FREEPAGE to 0 and left PCTFREE at 16. Has anyone else done [...]
3113 24 29_Calculate Reorg like reorgchk10_Tim Miller21_tmiller@TELCORDIA.COM31_Mon, 29 Nov 1999 14:27:01 -0500296_us-ascii Hello,<br><br><br><br>I have a "C" program which I used to Reorg and do runstats on user tables. I was wondering if there is a way to check if a table needs reorganizating like doing a "Reorgchk" command, but from my "C" program, and to use this to determine which tables to reorg. [...]
3138 24 35_Calculate Reorg like reorgchk - UDB10_Tim Miller21_tmiller@TELCORDIA.COM31_Mon, 29 Nov 1999 14:35:55 -0500332_us-ascii Hello,<br><br><br><br>I have a "C" program which I used to Reorg and do runstats on user tables. I was wondering if there is a way to check if a table needs reorganizating like doing a "Reorgchk" command, but from my "C" program, and to use this to determine which tables to reorg. I need this for a DB2 UDB database. [...]
3163 110 24_Re: Year 2000 procedures10_Mark Labby16_mlabby@PHEAA.ORG31_Mon, 29 Nov 1999 15:07:24 -0500558_us-ascii We found NO major problems at all in testing either our code or any of the utilities we use in the past year. This is strictly their effort to have a fail safe backup and restore procedure if anything would go wrong.<br><br>I think you will be seeing lots of financial institutions doing extraordinary things at the end of the year. Most of the large banks around here have already announced that they will be open during normal work hours that weekend. Most of it is a PR effort to make sure customers are comfortable with the banks having no [...]
3274 52 13_Re: SAP Stats0_22_Rohn.Solecki@MTS.MB.CA31_Mon, 29 Nov 1999 14:10:47 -0600565_us-ascii Not SAP but related to your question... when I first had to do space allocation (for lots of tables on OS/390) I compared the physical file size to the PRIQTY/SECQTY. To my surprise I found that the physical file was ALWAYS allocated in full tracks (12 DB2 pages per 3390 disk pack track) regardless of the units in the catalog (and in DBXpert the catalog value always reverted always reverted to pages, that might be DBXpert, I don't know), rounding the PRIQTY/SECQTY page sizes up to the full track. So, to keep the DB2 catalog size the same as the [...]
3327 14 19_Re: Package Backups11_Bernie Watt16_BWATT@KEYFIN.COM31_Mon, 29 Nov 1999 15:20:57 -0500419_us-ascii My recommendation is to use different DBRM and objec libraries then if you have to back off, point your jobs/systems to the old object libraries and BIND the old DBRMs.<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.
3342 63 13_Re: SAP Stats18_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM31_Mon, 29 Nov 1999 14:29:52 -0600563_iso-8859-1 Dan, There may be some "gotchas" lurking in your plans. As of DB2 for OS/390 V5, consider these for your site: 1) Remember that FREEPAGE and PCTFREE take affect at reLOAD, REORG, and REBUILD. 2) FREEPAGE can be useful for variable length columns that will expand on update (helps maintain clustering). 3) 16% of a table page with 50 byte rows and one with 300 byte rows doesn't leave room for the same number of rows on each table. 4) Not all tablespaces grow at the same rate (SECQTY 10% of PRIQTY). This method encourages extents which can be a [...]
3406 75 19_Re: Package Backups18_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM31_Mon, 29 Nov 1999 14:48:43 -0600479_iso-8859-1 Bob, Use PACKAGE auto-versioning and always keep the 0 and -1 gen. versions. If you start keeping them any deeper the ugly question of "how many" starts cropping up.<br><br>Use this SQL to find all BUT the 0 and -1 gens:<br><br>SELECT A.COLLID, A.NAME, A.VERSION FROM SYSIBM.SYSPACKAGE A WHERE A.VERSION <> ' ' AND 2 <= (SELECT COUNT(*) FROM SYSIBM.SYSPACKAGE B WHERE A.LOCATION = B.LOCATION AND A.COLLID = B.COLLID AND A.NAME = B.NAME AND A.VERSION < B.VERSION) [...]
3482 91 19_Re: Package Backups13_Paul Weissman21_Paul.Weissman@WDR.COM31_Mon, 29 Nov 1999 16:19:48 -0500604_us-ascii We're using package versioning and have implemented it with our source management system under CA-Endevor. It's implemented in Test and Production, with some differences:<br><br>Production. * package version is generated by Endevor and includes a timestamp. * When Endevor backs out a program it does not recompile or rebind, so having multiple versions available is a plus. * We do not have the fully automatic process set up yet for freeing old versions, but our plan is to keep a minimum of the three most recent versions for any program. * Production CICS uses a single plan name and a [...]
3574 44 26_Simple SQL UPDATE question24_SC Farm Bureau Insurance21_webmaster@SCFBINS.COM31_Mon, 29 Nov 1999 16:24:24 -0500535_iso-8859-1 We are new to DB2 and I have a simple SQL question and I can't seem to find the simple answer in any book.<br><br>Under DB2 5.1 under OS/390, is it possible to update a column of a table with a sub-select column function from another table? I keep getting syntax errors. What am I doing wrong? In Richard Yevich's new book "DB2 Answers", there is an example that is supposed to work, but the book indicates UDB and I don't know in this instance whether that means only on the PC. I can't find any other book that gives [...]
3619 20 59_Use of LOCKPART to Enable Selective Partition Locking (SPL)11_Jeff Schade15_JSCHADE@PCH.COM31_Mon, 29 Nov 1999 16:46:33 -0500412_- We are looking into the possibility of specifying LOCKPART YES for some of our larger partitioned tablespaces in order to allow more concurrent processing and reduce the impact of lock escalation. All the documentation I have found talks about the benefits for LOCKPART YES but do not mention a downside. I was wondering what the downside is and why LOCKPART NO is the default when defining a tablespace. [...]
3640 452 43_Re: !Message from the list Owners: RE: TIME16_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Mon, 29 Nov 1999 17:00:29 -0500590_iso-8859-1 thank you!!!<br><br>Andrea Milligan DataBase Administrator BlueCross BlueShield of Tennessee<br><br>> -----Original Message----- > From: Morrill, John [SMTP:JohnM@VP.NET] > Sent: Saturday, November 27, 1999 10:24 PM > To: DB2-L@RYCI.COM > Subject: !Message from the list Owners: RE: TIME > > Greetings! > > As a general rule, I take a country club approach to managing the content > of > the post to DB2-L. I don't jump right in and order threads which have > wander > off topic to stop, I wait a bit to see if they will burn themselves out. > However, when I feel they are [...]
4093 112 22_Re: Inconsistent Index15_Di Carlo, Donna23_Donna_Bermender@BMC.COM31_Mon, 29 Nov 1999 16:20:34 -0600662_ISO-8859-1 As our friend Ken likes to say, "Be sure to practice safe DB2!"<br><br>Donna Di Carlo BMC Software<br><br>-----Original Message----- From: Murley, Michael [mailto:Michael_Murley@bmc.com] Sent: Sunday, November 28, 1999 11:28 PM To: DB2-L@RYCI.COM Subject: Re: Inconsistent Index<br><br><br><br>I agree that it is generally better to use Rebuild Index rather than Repair to correct data integrity problems - if you can. And, by the way, I agree with Tim Lowe that we should all use 'Rebuild' to mean the unload/sort/build approach to indexes and 'Recover' to describe the image copy/log record method. In fact, I began forcing myself to make that [...]
4206 207 34_Re: Non-Uniform Distribution Stats10_Mark Labby16_mlabby@PHEAA.ORG31_Mon, 29 Nov 1999 17:20:36 -0500410_us-ascii Thanks Michael, Venkat, and Rick:<br><br>I agree with everything you've pointed out. I don't want to force it not to use the primary index, since as has been pointed out, it is needed to prevent the sort and it will be the best initial cut at the data. What I had hoped to gain with the additional index was that it could be used in a Multiple Index Access to reduce the data pages actually hit. [...]
4414 43 28_DSN1COPY from index to index0_14_whomer@CSC.COM31_Tue, 30 Nov 1999 09:40:31 +1000379_us-ascii Hi all,<br><br>First of all we are DB2 V4.<br><br>I have set up jobs to DSN1COPY PROD tablespaces and indexes to TEST tablespaces and indexes. The tablespace transfer ran fine. However the index transfer ran without error only if the source index dataset did not contain ZERO pages (this is what I assume the problem was). The error message that I was issued was : [...]
4458 19 32_Re: DSN1COPY from index to index0_19_csutfin@AMSOUTH.COM31_Mon, 29 Nov 1999 16:54:01 -0600487_- Warren:<br><br>At V4.1, rather than using DSN1COPY for the indexes, just RECOVER them after you have used DSN1COPY for the tablespaces. This way you don't have the zero pages problems.<br><br>Hope this helps<br><br>Carol Sutfin AmSouth Bank NA<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.
4478 191 55_Re: Oracle Transparent Gateway TCP/IP to DB2 for OS/39013_Joaquin Frias19_frias@STARQUEST.COM31_Mon, 29 Nov 1999 15:27:34 -0800
4670 309 39_Re: Workload Balancing over DB2 Connect0_15_leon@CA.IBM.COM31_Mon, 29 Nov 1999 19:17:46 -0500605_us-ascii I am not sure what you mean by distributed director If what you are talking about is CISCO Local Director then e-Network Dispatcher performs very similar function. Both of these products provide a single IP address to the clients (this is why these solutions are frequently called "virtual IP"). CISCO Local Director is a hardware solution while e-Network Dispatcher is a piece of software with no hardware attached to it. Both solutions have their plusses and minuses. The thing I like about e-Network Dispatcher is the fact that it can be very smart when it comes to load balancing. CISCO [...]
4980 79 32_Re: DSN1COPY from index to index15_Di Carlo, Donna23_Donna_Bermender@BMC.COM31_Mon, 29 Nov 1999 18:22:15 -0600322_ISO-8859-1 Warren,<br><br>I can't say for sure if the zero page is what caused your problem. It does look suspicious. The best way to determine if the index has a zero page is to look for the warning message in your DSN1COPY output:<br><br>DSN1985I ZERO PAGES ENCOUNTERED. FIRST PAGE = 0000000A, LAST PAGE = 0000000A [...]
5060 280 55_Re: Oracle Transparent Gateway TCP/IP to DB2 for OS/39022_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Mon, 29 Nov 1999 19:24:55 -0500343_iso-8859-1 Joaquin -<br><br>Your point is well taken & I agree with you. I have no control and or influence on the proposed solution except to offer alternatives. Thanks for the choices.<br><br>The folks in charge of the project are comfortable with the Oracle Transparent Gateway for IBM DRDA solution. Cost doesn't seem to be an issue. [...]
5341 62 0_0_36_Shaun.Z.Lombard@TRANSPORT.QLD.GOV.AU31_Tue, 30 Nov 1999 16:56:39 +1000452_- Watch out for objects REORGed or LOADed with the PREFORMAT option as this would cause all pages from Hi-used to Hi-alloc to be formatted, making HI-USED = HI-ALLOC.<br><br><br><br><br><br><br><br>Daniel Boulanger <dboulang@CA.IBM.COM> on 30/11/99 03:21:47<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br>To: DB2-L@RYCI.COM cc: (bcc: Shaun Z Lombard/CorpServ/qdot/au) Subject: Re: Another Data Compression question [...]
5404 91 37_Re: Another Data Compression question22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Tue, 30 Nov 1999 06:05:04 +0000280_ISO-8859-1 Paul Hi. I recently wrote a program that did this sort of thing for us but it also talked to a SAP report so that it could give better information on the compression and in addition a league table of those objects left that may be good candidates for compression. [...]
5496 45 22_RE : CRYSTAL REPORTING12_Andre Cupido22_wcacu@WOOLWORTHS.CO.ZA31_Tue, 30 Nov 1999 09:36:16 +0200298_US-ASCII Hi All<br><br>We are running DB2 V4 on Os390 V 2.4 ..<br><br><br><br>How do i use Crystal Reporting to extract data from DB2 . What would i need to do to be able to achieve this ?<br><br>Is this the best way of viewing DB2 data from a browser .<br><br><br><br>Thanking you in advance [...]
5542 140 24_Re: Year 2000 procedures12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK31_Tue, 30 Nov 1999 09:14:00 -0000417_iso-8859-1 I agree that lots of financial institutions are doing extraordinary things at the end of the year, the question is, how much of it is down to:<br><br>a). Y2K project teams having their last moment of glory/ensuring they have everything covered from their perspective (but not necessarily from the applications view) b). Massive payments being made to anyone having to work over the Millenium weekend. [...]
5683 64 13_Re: SAP Stats22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Tue, 30 Nov 1999 09:04:37 +0000542_ISO-8859-1 Dan<br><br>re PCTFREE ... and FREEPAGE .. I have given this a lot of thought.<br><br>Your thoughts are along the right lines ..<br><br>I think you need to consider the insert/update and delete activity on the pagesets aswell. This information can be obtained from an ST10 report over say a month .. that way you can then determine if the pageset is a high read only pageset or high update(varchars will cause the freepage and pct free space to be used). ... high inserts are an obvious candidate for freepage and pctfree .. . [...]
5748 88 13_Re: SAP Stats12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK31_Tue, 30 Nov 1999 11:44:00 -0000486_- I think your secondary quantity calculation may benefit from a little refinement depending on the maturity of your application. You may want to consider a ceiling and floor value. If you are a new installation with rapidly growing tablespaces there is probably a minimum value that you don't want to drop below (depending on the frequency of your checks) and at the other extreme, a maximum value above which you are unlikely to find the contiguous free space in your DASD Pool. [...]
5837 40 8_Sign-off30_Karthigai Thirunal,J16 Chennai25_ekarthik@MSDC.HCLTECH.COM31_Tue, 30 Nov 1999 17:48:53 +053025_iso-8859-1 SIGN-OFF DB2-L
5878 186 24_Re: Year 2000 procedures0_19_mike.holmans@BT.COM31_Tue, 30 Nov 1999 12:41:33 -0000576_ISO-8859-1 The systems which I support are accounting and bank payments applications. In the UK, Jan 1 is not a banking day.<br><br>My users have decided that since their processing is not time-critical, there is no desperate need to run something which might fail with a B37 at 00:02 and have everyone thinking it's a Y2K failure and set them into panic mode. So we won't be running our normal overnight batch suite on 31/12, mostly for the sake of a quiet life. The other applications sharing the box will be running normally, and we won't be doing any IPLs, recycling [...]
6065 97 0_18_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM31_Tue, 30 Nov 1999 07:34:53 -0600602_iso-8859-1 Shaun, Good catch. However, now the question of were the preformatted pages there because they'll soon be used or are they left over excess? This DBA stuff just keeps getting more complex. :)<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 [...]
6163 62 63_Re: Use of LOCKPART to Enable Selective Partition Locking (SPL)11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Tue, 30 Nov 1999 08:49:06 -0500322_ISO-8859-1 Jeff<br><br>In a non-Data Sharing environment, the only benefit of LOCKPART YES is in limiting the scope of lock escalation. If you are getting lock escalation, it may be better to stop the escalation - maybe higher LOCKMAX value or even LOCKMAX 0. But make sure IRLM can handle all the page or row locks. [...]
6226 104 46_Re: Gordon Reich/WCBAlta is out of the office.12_Kevin Porter28_Kevin.Porter@LLOYDSTSB.CO.UK31_Tue, 30 Nov 1999 14:17:31 -0000391_iso-8859-1 If you have Internet Access then you can easily catch up with any missed weeks by going to the DB2-L archives at http://jupiter.ryci.com/archives/db2-l.html All the threads are neatly grouped together in an easily navigated format.<br><br>If you only have email then it is trickier but as far as I can see it's still possible, contact the list owners for the exact commands. [...]
6331 113 24_Re: SYSPROCEDURES Insert0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM31_Tue, 30 Nov 1999 08:27:54 -0600510_us-ascii Hi Julian,<br><br>We use Endeavor and implemented stored procedures this year.<br><br>(We are on DB2 V5 and realize that the catalog tables will change significantly for Stored Procedures in V6 but still felt it was worth the effort to create some panels that would automate much of the work, which will help to avoid possible error). Since we also have 17 DBAs on staff and not all DBAs are well versed in Stored procedures, we felt the more consistent the process the better chance of success. [...]
6445 224 24_Re: Year 2000 procedures14_Harvey Wachtel22_HWachtel@UAPC.CUNY.EDU31_Tue, 30 Nov 1999 09:37:40 -0500507_us-ascii That's a good point we hadn't thought of. We've already been scared by one pseudo-Y2K bug in testing.<br><br><br><br><br><br>mike.holmans@ BT.COM To: DB2-L@RYCI.COM Sent by: DB2 cc: Data Base Subject: Re: Year 2000 procedures Discussion List <DB2-L@RYCI.C OM><br><br><br><br>1999-11-30 07:41 Please respond to DB2 Data Base Discussion List<br><br><br><br><br><br><br><br><br><br>The systems which I support are accounting and bank payments applications. In the UK, Jan 1 is not a banking day. [...]
6670 31 45_DBRM libraries for a particular db2 subsystem19_Balaji.D (Exchange)20_Balaji.D@DHCMAIL.COM31_Tue, 30 Nov 1999 08:42:01 -0600399_iso-8859-1 Hi,<br><br>I have a few questions regarding DBRM libraries for a sub system.<br><br>1) How to find the DBRM libraries that are concatenated to a DB2 subsystem ( say DB2T)<br><br>2) In a scenario where my DBRM is present in a different library which is not concatenated to the subsystem, then if I copy the member to any of the concatenated libraries, will the program get executed ? [...]
6702 19 8_SIGN-OFF16_Adams, Timothy D28_Timothy.Adams@PSS.BOEING.COM31_Tue, 30 Nov 1999 06:31:05 -0800312_- SIGN-OFF DB2-L :-)Timothy D. Adams > * Phone: (425) 237-0161 Pager: (206) 416-4724 > * Bldg: 7.42-5 Cube 5F3-1 M/S: 6C-PJ > *E-Mail: Timothy.D.Adams@boeing.com > * 4x10: 6:00 am - 4:30 pm with Friday off The definition of insanity is doing the same thing over and over again, expecting different results. [...]
6722 16 49_Re: DBRM libraries for a particular db2 subsystem11_Bernie Watt16_BWATT@KEYFIN.COM31_Tue, 30 Nov 1999 09:42:29 -0500454_us-ascii A DBRM is not concatenated into a subsystem. to determine what DBRM pds is used, you will have to check the column PDSNAME in SYSPACKAGES for packages and SYSDBRM for plans. hope this helps<br><br>Bernie<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.
6739 74 49_AW: DBRM libraries for a particular db2 subsystem17_Schreiber, Ursula34_Ursula.Schreiber@DRESDNER-BANK.COM31_Tue, 30 Nov 1999 15:51:00 +0100462_iso-8859-1 A DBRM is never used during program execution. You only need the DBrm during BIND process.<br><br>For Binding there is a parameter LIBRARY(dbrm-pds-name) in BIND PACKAGE and BIND PLAN Statement for the DBRM Library you want to use.<br><br>Best Regards / Mit freundlichen Gruessen<br><br>Ursula Schreiber<br><br>Dresdner Bank AG KS Organisation und Informatik IT Research und Standards Consulting und Architektur Datenmanagement D-60301 Frankfurt [...]
6814 66 49_Re: DBRM libraries for a particular db2 subsystem14_Harvey Wachtel22_HWachtel@UAPC.CUNY.EDU31_Tue, 30 Nov 1999 10:02:59 -0500365_us-ascii For (2) and (3): DBRMs are not referenced at execution time, only during BIND. For (1), the DBRM library at BIND is specified in the BIND command.<br><br><br><br><br><br>"Balaji.D (Exchange)" To: DB2-L@RYCI.COM <Balaji.D@DHC cc: MAIL.COM> Subject: DBRM libraries for a particular db2 subsystem Sent by: DB2 Data Base Discussion List <DB2-L@RYCI.C OM> [...]
6881 89 49_Re: DBRM libraries for a particular db2 subsystem19_Balaji.D (Exchange)20_Balaji.D@DHCMAIL.COM31_Tue, 30 Nov 1999 09:26:20 -0600520_iso-8859-1 Harvey,<br><br>I'm getting -805 sqlcode when I try to execute a program, for which the reason being package was not found. When I did the compilation, the BIND process was successfull and the DBRM was put in a PDS.<br><br>what you think would be the probable cause for this problem ?<br><br>balaji<br><br>-----Original Message----- From: Harvey Wachtel [mailto:HWachtel@UAPC.CUNY.EDU] Sent: Tuesday, November 30, 1999 9:03 AM To: DB2-L@RYCI.COM Subject: Re: DBRM libraries for a particular db2 subsystem [...]
6971 104 49_Re: DBRM libraries for a particular db2 subsystem11_Hilton Tina15_HiltonT@TCE.COM31_Tue, 30 Nov 1999 10:31:25 -0500540_ISO-8859-1 Are you sure the package belongs to a collection that is part of the plan you used?<br><br>-----Original Message----- From: Balaji.D (Exchange) [mailto:Balaji.D@DHCMAIL.COM] Sent: Tuesday, November 30, 1999 10:26 AM To: DB2-L@RYCI.COM Subject: Re: DBRM libraries for a particular db2 subsystem<br><br><br><br>Harvey,<br><br>I'm getting -805 sqlcode when I try to execute a program, for which the reason being package was not found. When I did the compilation, the BIND process was successfull and the DBRM was put in a PDS. [...]
7076 104 49_Re: DBRM libraries for a particular db2 subsystem12_Claude Birtz24_Claude.Birtz@CIE.ETAT.LU31_Tue, 30 Nov 1999 16:35:23 +0100492_us-ascii What is the reason code of this -805 code? (complete form of the message: -805 DBRM or PACKAGE NAME location-name.collection-id.dbrm-name.consistency -token NOT FOUND IN PLAN plan-name. REASON reason)<br><br>If it is 03 you might have a problem with the consistency token, i.e. the package has not the same consistency token as the application program you try to execute. From your first posting I get the feeling that you might mix up DBRM libraries and load-module libraries. [...]
7181 126 49_Re: DBRM libraries for a particular db2 subsystem14_Harvey Wachtel22_HWachtel@UAPC.CUNY.EDU31_Tue, 30 Nov 1999 10:40:28 -0500463_us-ascii As others have mentioned, it's the package (in the system tables) that results from the BIND rather than the DBRMs that went into it that are required at execution. Did you bind the package on the subsystem that the program is executing on?<br><br><br><br><br><br>"Balaji.D (Exchange)" To: DB2-L@RYCI.COM <Balaji.D@DHC cc: MAIL.COM> Subject: Re: DBRM libraries for a particular db2 subsystem Sent by: DB2 Data Base Discussion List <DB2-L@RYCI.C OM> [...]
7308 85 30_Re: Simple SQL UPDATE question14_Mullins, Craig21_Craig_Mullins@BMC.COM31_Tue, 30 Nov 1999 09:57:41 -0600442_ISO-8859-1 Scott:<br><br>The UPDATE statement can not be used to update columns to values retrieved using a SELECT statement as you tried in your example SQL. The SET clause of the UPDATE statement is used to set a column to a value in the form of an expression (or to NULL). The expression is formulated as specified beginning on page 129 of the IBM DB2 V6 SQL Reference manual (which can be downloaded for free from the IBM web site). [...]
7394 18 30_Re: Simple SQL UPDATE question12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 30 Nov 1999 08:08:32 -0800492_us-ascii One minor addition.<br><br>Then if you are running Version 6, look at APAR PQ30383, which does permit update with a subselect. I think the APAR is closed, but the PTF is not ready yet. The APAR cover letter discusses the syntax.<br><br>Roger<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.
7413 19 20_rough time estimates13_Martin Kenney25_martin.kenney@RAILINC.COM31_Tue, 30 Nov 1999 12:11:01 -0500513_us-ascii I have requested our outsourced systems group to install the stored procedures and db2 connect features on our test environment by the end of year so that we can test and be ready to utilize after our Y2000 production freeze is up. They are indicating that there is way to much involved to get this done by then. Does any one out there have just a rough estimate for the time it takes to install these products. We are on DB2 V5.1, OS/390 1.3 and have LE/370 but will need to steplib to it. Thanks! [...]
7433 42 24_Re: rough time estimates13_Lynne Flatley17_LFlatley@NEFN.COM31_Tue, 30 Nov 1999 13:01:46 -0500484_- It all depends! If you are planning on using a DB2-managed stored procedure address space then I shouldn't think this would be out of the question by year-end. WLM-managed is another thing...I think the set-up for Work-Load Manager can be pretty onerous.<br><br>DB2 Connect could take a couple of weeks (total elapsed time) to get squared away with VTAM issues and such on the mainframe. The DB2 set-up work, once again, is not onerous, another address space, some binds, etc. [...]
7476 149 24_Re: SYSPROCEDURES Insert12_Lisle, Kathy19_KLLISLE@INTEGON.COM31_Tue, 30 Nov 1999 13:02:37 -0500677_windows-1252 At a previous employer, we did something very similar to this, but with one significant difference: to create the SYSPROCEDURES row, programmers used a fill-in-the-blank panel to create a formatted PDS member. This PDS member was implemented through Endeavor, and the Endeavor process created the row in the test or production SYSPROCEDURES table and stopped and started the stored procedure. Creating the Endeavor process took a lot of work from a knowledgeable person, but it was really slick. It avoided direct DBA involvement in the implementation process. Also, since Endeavor kept old versions of the SYSPROCEDURES information, fallback procedures were [...]
7626 26 13_Can this work6_starre21_t.v.d.starre@BLINC.NL31_Tue, 30 Nov 1999 19:34:24 +0100396_us-ascii Hi all,<br><br>I wat to know if this setup will work:<br><br>I have DB2 5.2 on OS/390 and DB2 UDB 6 on NT. I want an application running on OS/390 to update a table in DB2 UDB 6 (NT). This via DRDA. Then I want to create triggers on this table which will call a storedprocedure. This storedprocedure will call an API, by which we create a record in an application on a NT platform. [...]
7653 120 13_Re: SAP Stats22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Tue, 30 Nov 1999 12:51:09 +0000322_ISO-8859-1 Colin some good points ..<br><br>I am not saying that my last mail was exact or the finished product. I think to the contrary any program that tried to estimate the correct value must do based on as much information as possible whilst at the same time stick within pre-defined upper and lower barriers ... [...]
7774 49 17_Re: Can this work14_Philip Gunning20_pgunning@BOSCOVS.COM31_Tue, 30 Nov 1999 16:02:34 -0800356_us-ascii Ton, DB2 UDB V6.1 on Nt does not support the bind option of sqlerror(continue). So you can't use static SQL if you are doing a distributed unit of work. You should be able to do it with dynamic SQL. HTH Phil<br><br>Philip K. Gunning DB2 DBA IBM Certified Solutions Expert -- DB2 UDB IBM Cetfified Solutions Expert -- CICS TS Assoc List Owner [...]
7824 184 15_Re: CRUD Matrix17_Price, Jeff (EDS)14_jprice@NCL.COM31_Tue, 30 Nov 1999 16:02:16 -0500663_iso-8859-1 This would almost work, assuming no dynamic SQL, but you need to also consider the referential integrity rules (eg. CASCADE DELETE) which are not recorded in SYSTABAUTH. If you programatically process the info in SYSTABAUTH, table it, and then process the info in SYSRELS, you can create what I refer to as a SINCRUD matrix. S=select I=insert N=set NULL C=cascade delete R=restrict delete U=update D=delete Regards Jeff Price JPrice@NCL.com > -----Original Message----- > From: Paul A Redhead [SMTP:Paul.A.Redhead@TRANSPORT.QLD.GOV.AU] > Sent: Wednesday, October 27, 1999 9:11 PM > To: DB2-L@RYCI.COM > Subject: Re: CRUD Matrix > > John, > If you [...]
8009 492 39_Re: DATE function to reduce CPU time???17_Price, Jeff (EDS)14_jprice@NCL.COM31_Tue, 30 Nov 1999 16:23:23 -0500341_iso-8859-1 My guess would be that earlier versions of DB2 were rectifying the comparison of a date column with a character literal at stage-2 rather than at stage-1. So I suspect it use to matter. Similar to unequal length column joins (fixed in V5 with APAR). I just recently encountered a similar phenomina with NULL incompatability. [...]
8502 100 19_need help with drda14_Marg Gozdowski27_marg.gozdowski@LA-Z-BOY.COM31_Tue, 30 Nov 1999 16:29:08 -0500509_iso-8859-1 Well, I am still trying to get the pc to mainframe working.<br><br>We are using Microsoft's ODBC Driver - tcp/ip setup - ar only - & on the mainframe, we are getting err msg:<br><br>00D31050<br><br>Explanation: DB2 expected to receive security information for the remote client but a valid DRDA SECCHK command was not received for a connection request from a DRDA application requester (AR). The DRDA SECCHK command is only valid with a DRDA security manager level greater than or equal to 5. [...]
8603 119 23_Re: need help with drda22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Tue, 30 Nov 1999 17:10:04 -0500501_iso-8859-1 I'm assuming your connecting to a DB2 for OS/390 V5.1 subsystem. I'm not familiar with Microsoft's ODBC driver. Does it support the DRDA protocol across TCP/IP? Does it request and pass on to DB2 a userid & password?<br><br>We're using the StarSQL ODBC driver on Win95 across TCP/IP into DB2 for OS/390 V5.1 on OS/390 V2.5. The ODBC driver requests & passes on to DB2 a userid & password as part of the connection process. DB2 calls RACF to verify that the userid & password is valid. [...]
8723 100 23_Re: need help with drda14_Philip Gunning20_pgunning@BOSCOVS.COM31_Tue, 30 Nov 1999 17:25:37 -0800457_us-ascii Marg, Sounds like you need to change the VTAM appl SECACPT DDF option to ALREADYV. Have your VTAM person check this out. HTH Phil<br><br>Philip K. Gunning DB2 DBA IBM Certified Solutions Expert -- DB2 UDB IBM Cetfified Solutions Expert -- CICS TS Assoc List Owner<br><br>-----Original Message----- From: Marg Gozdowski [SMTP:marg.gozdowski@LA-Z-BOY.COM] Sent: Tuesday, November 30, 1999 1:29 PM To: DB2-L@RYCI.COM Subject: need help with drda [...]
8824 123 49_Re: DBRM libraries for a particular db2 subsystem19_Balaji.D (Exchange)20_Balaji.D@DHCMAIL.COM31_Tue, 30 Nov 1999 16:37:51 -0600378_iso-8859-1 Thanks for the advice. By mistake, I used a different plan due to which I got -805. Now I rectified it and the program works fine.<br><br>thanks again balaji<br><br><br><br>-----Original Message----- From: Hilton Tina [mailto:HiltonT@TCE.COM] Sent: Tuesday, November 30, 1999 9:31 AM To: DB2-L@RYCI.COM Subject: Re: DBRM libraries for a particular db2 subsystem [...]
8948 16 28_DSN1COPY from index to index22_Dan Courter (543-3870)27_daniel_courter@VNET.IBM.COM29_Tue, 30 Nov 1999 14:36:23 PST460_- Warren,<br><br>There were two APARs in V4 to fix this, PQ00479 and PQ03459. Zero pages are normal and the DSN1COPY translation module was changed to handle them. Check your maintenance for these two fixes.<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.
8965 836 111_Central PA RUG - April 5th and 6th - DB2 UDB for V6 & DRDA Classes - $150 each! - Linda Claussen - Register NOW0_23_cathy.peck@HIGHMARK.COM31_Tue, 30 Nov 1999 17:58:59 -0500446_us-ascii Hi all! Hope everyone had a grand holiday last week!!<br><br>I wanted to give everyone a head's up on two upcoming all-day DB2 classes.<br><br>WHERE - Camp Hill, PA<br><br>WHEN - April 5th & April 6th<br><br>WHO - Linda Claussen<br><br>WHAT - DB2 UDB for OS/390 Version 6 - Migration and Implementation - April 5th - DRDA and DB2 Connect - Putting the pieces of the puzzle together. (DRDA, DB2 Connect, TCP/IP and More) - April 6th [...]
9802 84 27_Re: DB2 Tools - CA/Platinum15_Amir Heydarpour39_Amir.Heydarpour@DWNPLAZA.NCOM.NT.GOV.AU30_Wed, 1 Dec 1999 09:41:48 +0930514_iso-8859-1 The list of indexes to improve performance of CA/Platinum products are in the following manual:<br><br>"PLATINUM Products for DB2 for OS/390 Installation Guide", section: "Improving performance - catalog indexes"<br><br>The indexes required for RC/Migrator, RC/Compare, and RC/Merger (good if you migrating large volume of data) are:<br><br>*** SYSKEYS***<br><br>IXCREATOR, IXNAME, COLSEQ<br><br>This index should improve performance when using any feature in RC/Migrator, RC/Compare or RC/Merger. [...]
9887 332 76_IBM DB2 OLAP Server for OS/390, Version 1.1 (Preview Announcement , 11/2/99)13_Morrill, John12_JohnM@VP.NET31_Tue, 30 Nov 1999 18:17:06 -0700433_iso-8859-1 Dear DB2 Interested Parties,<br><br>Below is an excerpt from last week's preview announcement* of a new version of IBM DB2 OLAP Server for the OS/390 platform. DB2 OLAP Server for OS/390, Version 1.1 will offer the option of relational (i.e., DB2) or multi- multidimensional (i.e., Essbase) storage for multi-dimensional applications built for and leveraging the functions of industry leading Hyperion Essbase 5.0.2. [...]
10220 26 87_CORRECTION: IBM DB2 OLAP Server for OS/390, Version 1.1 (Preview Announcement, 11/2/99)13_Morrill, John12_JohnM@VP.NET31_Tue, 30 Nov 1999 18:18:52 -0700606_iso-8859-1 DB2 Friends,<br><br>The URLs in my bulletin below apparently do not work for everyone. Instead, use these:<br><br>IBM DB2 OLAP Server web site: > http://www-4.ibm.com/software/data/db2/db2olap/<br><br>Information on the beta program: > http://www-4.ibm.com/software/data/db2/db2olap/aolap390.html<br><br>Sorry for any inconvenience.<br><br>Regards, Mike<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.
10247 124 47_S/390 and ESS Lead the Way with DB2 Performance13_Morrill, John12_JohnM@VP.NET31_Tue, 30 Nov 1999 18:20:15 -0700382_iso-8859-1 Dear DB2 Interested Parties,<br><br>This fall, IBM Storage Systems Division (SSD) announced the Enterprise Storage Server (ESS, codenamed "Shark"). The architecture and implementation of this new system is very beneficial to the DB2 UDB for OS/390 environment. Below is a brief bulletin about some initial findings of tests run by the DB2 and ESS development teams. [...]
10372 140 36_Re: Platinum Rapid Reorg and Maxrows13_Marcel Lepage13_iml@COLBA.NET31_Tue, 30 Nov 1999 23:22:09 -0700571_iso-8859-1 Hi Tim,<br><br>Platinum PTP97G1 and Rapid reorg is at 5.1.5 and it supposed to be current with our 5.1 release of DB2.<br><br>Thanks.<br><br>Marcel<br><br>"Ohling, Tim R - CNF" a écrit :<br><br>> What version of Platinum are you on? That is: is it (supposed to be) > current with the version of DB2 you are running or is a product bug? > > Thanks, > Tim > > -----Original Message----- > From: Marcel Lepage [mailto:iml@COLBA.NET] > Sent: Friday, November 26, 1999 10:12 PM > To: DB2-L@RYCI.COM > Subject: Re: Platinum Rapid Reorg and Maxrows > > Tim, > > [...]