1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l April 2002, week 5
2 51 29_Re: AIX UDB EE V7.2 code base11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM31_Mon, 29 Apr 2002 01:07:28 -0400444_iso-8859-1 Paul,<br><br>Your understanding is correct. A 7.2 CD would be easier (fewer steps). I am not aware of any differences.<br><br>Regards, Scott<br><br>Scott Hayes DGI www.breakthroughdb2.com<br><br><br><br><br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Martin, Paul Sent: Thursday, April 25, 2002 9:19 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: AIX UDB EE V7.2 code base [...]
54 120 12_FW: z800 box19_Dransfield, Michael19_mdransfi@LEHMAN.COM31_Thu, 25 Apr 2002 11:22:34 -0400380_iso-8859-1 -----Original Message----- From: Dransfield, Michael Sent: Thursday, April 25, 2002 10:06 AM To: 'DB2 Data Base Discussion List' Subject: RE: z800 box<br><br><br><br>Cliff,<br><br>001: one engine, 192.5 MIPS; 002: two 192.5 MIPS engines, and should = 385 MIPS, but does not because of a certain amount of overhead required to balance work between the two engines. [...]
175 12 4_Test14_Lennart Henang25_lennart.henang@FOLKSAM.SE31_Mon, 29 Apr 2002 08:46:26 +0200278_us-ascii Just testing.<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
188 24 5_down?16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Thu, 25 Apr 2002 15:48:51 -0400549_iso-8859-1 No connection (tried from two different providers) to: http://www.ylassoc.com/<br><br>Also, archive search at http://jupiter.ryci.com/cgi/wa.exe?S1=db2-l are no longer accessible. What is the current URL for the archives?<br><br><br><br>Regards, eric pearson NS ITO Database Support<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
213 23 5_Down?16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Thu, 25 Apr 2002 11:31:44 -0400535_iso-8859-1 No connection (tried from two different providers) to: http://www.ylassoc.com/<br><br>Also, archives at http://jupiter.ryci.com/cgi/wa.exe?S1=db2-l are no longer accessible. What is the current URL for the archives?<br><br>Regards, eric pearson NS ITO Database Support<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
237 35 12_(no subject)20_Edward C. Benoit Jr.19_DB2Automate@AOL.COM29_Sun, 28 Apr 2002 12:26:17 EDT89_US-ASCII sub DB2-L@RYCI.COM Edward C. Benoit, Jr.<br><br><br><br><br><br><br><br><br><br>
273 21 8_No news.18_Eva Molina Jimenez20_evamolina@ES.IBM.COM31_Mon, 29 Apr 2002 09:16:12 +0200472_iso-8859-1 No new message from the list, is all rigth?<br><br>Saludos/ Regards --------------------------------------------------- Eva Molina Jiménez. Automation/Tivoli. IBM Global Services. SPAIN Tlf: +34 91.397.94.18<br><br>===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
295 49 11_UDB Journal12_Brejza, Adam23_Adam.Brejza@GEDAS.CO.UK31_Mon, 29 Apr 2002 11:50:21 +0100338_iso-8859-1 Hi, I have a number of jobs that I have submitted from the UDB script centre which show as running jobs in the journal, but are apparently "stuck" for whatever reason. Unlike pending or completed jobs, there does not appear to be any way to delete/cancel these. Any ideas for getting rid of these? Product is DB2 UDB V7.2 [...]
345 19 20_Re: The List is Back14_Clayton, Colin21_Colin_Clayton@BMC.COM31_Mon, 29 Apr 2002 06:30:36 -0500447_iso-8859-1 Hi listers,<br><br>is anyone else unable to access http://www.ylassoc.com/ or http://listserv.ylassoc.com/ ?<br><br>I'm getting a 'Bad Gateway' (host not found) error.<br><br>Colin<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
365 47 20_Re: The List is Back18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Mon, 29 Apr 2002 07:52:04 -0400519_iso-8859-1 The links identified below work for me. I just tried them...<br><br>Peter J. Krawetzky, DBA IBM Certified Solutions Expert DB2 UDB V7.1 Database Administration For Unix, Windows and OS/2<br><br><br><br>-----Original Message----- From: Clayton, Colin [mailto:Colin_Clayton@BMC.COM] Sent: Monday, April 29, 2002 7:31 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: The List is Back<br><br><br><br>Hi listers,<br><br>is anyone else unable to access http://www.ylassoc.com/ or http://listserv.ylassoc.com/ ? [...]
413 38 20_Re: The List is Back13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 29 Apr 2002 07:58:13 -0400772_iso-8859-1 Hi Clayton,<br><br>I can get at both of the sites.<br><br>However in the archives site http://listserv.ylassoc.com/archives/db2-l.html attempting to access >April 2002 week 5< I'm unable. Prior week's posts seem to be available.<br><br>You might contact the list owners at DB2-L-request@listserv.ylassoc.com to describe your problem.<br><br>David Seibert Compuware Corporation File-AID Product Architect Dave.Seibert@compuware.com<br><br><br><br><br><br><br><br><br><br><br><br><br><br>The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error [...]
452 74 24_Re: The List is Back (?)17_Dr. Michael Ebert18_mebert@AMADEUS.NET31_Mon, 29 Apr 2002 14:02:04 +0200560_us-ascii For me, they both became available this morning - some hours ago. Both sites (and all subpages) are a pain to use because of the ActiveX controls they use, which here are disabled (as they probably are in most companies where security is any issue at all), so you've got to click "Ok" more than half a dozen times before you can do anything else. The "Sent by:" field still says RYCI.COM. Looks like the move still isn't completed. The file in the DB2-L archive for the current week is inaccessible. I have received just a few postings since the [...]
527 18 20_Re: The List is Back18_Eva Molina Jimenez20_evamolina@ES.IBM.COM31_Mon, 29 Apr 2002 14:07:44 +0200418_iso-8859-1 I don't have problems to access to anyone of the two URL.<br><br>Saludos/ Regards --------------------------------------------------- Eva Molina Jiménez.<br><br>===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
546 74 32_Trigger calling stored procedure15_Saffer, Michele26_Michele.Saffer@ACS-INC.COM31_Mon, 29 Apr 2002 08:00:38 -0400528_iso-8859-1 > I have a two-part dilema. First of all, I'm trying to return an error > using SQLSTATE from a stored procedure to a trigger and not having any > luck. I looked in the Redbook "DB2 for z/OS Application Programming > Topics" and followed the instructions there, but it's not returning the > error like I want it to. (We are not z/OS, we are OS/390 2.6, and DB2 UDB > for OS/390 Version 6.) I will be happy to supply the trigger and stored > procedure details, if anyone thinks they can help. > > Second, even if [...]
621 43 51_Re: Selecting data from tables in two UDB databases9_Ed Lipson20_elipson@BANKOFNY.COM31_Mon, 29 Apr 2002 08:10:23 -0400386_us-ascii Why not set up a federated nickname of one table from the other database? You can join then as if both tables were in the same database.<br><br>Ed Lipson Bank of New York elipson@bankofny.com<br><br>----- Message from "Seibert, Dave" <Dave_Seibert@COMPUWARE.COM> on Fri, 26 Apr 2002 07:07:44 -0400 -----<br><br>Subject: Re: Selecting data from tables in two UDB databases [...]
665 80 88_Re: Significant increase in SSAS MSTR address space CPU usage aft er DB2 V7 installation16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 29 Apr 2002 08:16:23 -0400431_iso-8859-1 DITTO! We saw a huge increase with OA on. Got a PTF from Candle which reduced but not eliminated the cost.<br><br>Regards, eric pearson NS ITO Database Support<br><br><br><br>-----Original Message----- From: Boone, Henry [mailto:HBoone@GEICO.COM] Sent: Thursday, April 25, 2002 6:30 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Significant increase in SSAS MSTR address space CPU usage aft er DB2 V7 installation [...]
746 18 9_subscribe0_25_haroldramsey@NETSCAPE.NET31_Mon, 29 Apr 2002 08:24:47 -0400616_iso-8859-1 send/receive<br><br><br><br>__________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/<br><br>Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
765 25 9_subscribe0_25_Ed_Vetock@NAVYFEDERAL.ORG31_Thu, 25 Apr 2002 15:31:19 -0400512_us-ascii Ed Vetock ---------------------- Forwarded by Ed Vetock/40/HQ/NFCU on 04/25/2002 03:31 PM ---------------------------<br><br><br><br>Ed Vetock 04/25/2002 11:56 AM<br><br>To: DB2-L@LISTSERV.YLASSOC.COM cc:<br><br>Subject: subscribe<br><br>Ed Vetock<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
791 12 9_subscribe0_25_Ed_Vetock@NAVYFEDERAL.ORG31_Thu, 25 Apr 2002 11:56:18 -0400274_us-ascii Ed Vetock<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
804 35 32_DB2 OS/390: Coding SQL statement0_25_Ed_Vetock@NAVYFEDERAL.ORG31_Thu, 25 Apr 2002 07:30:39 -0400291_us-ascii All,<br><br>(1) A Cobol SQL question:<br><br>- COL A in Table 1 is defined as a DATE field - COL B in Table 2 is defined as a SMALLINT field to represent number of months<br><br>(2) A programmer would like to do the following:<br><br>STEP 1: Select COL B from TABLE 2 into :HV [...]
840 68 20_Re: The List is Back0_17_sjvagnier@AEP.COM31_Mon, 29 Apr 2002 08:55:58 -0400534_us-ascii Colin, I accessed both URL's without any problems at 8:54 AM EDT.<br><br>Regards...<br><br>**************************************** Steve Vagnier Principal IT Systems Administrator American Electric Power Shared Services One Riverside Plaza Columbus, Ohio 43215 Email: sjvagnier@aep.com Phone: 614-223-3677 Audinet: 200-3677<br><br><br><br><br><br><br><br>"Clayton, Colin" To: DB2-L@LISTSERV.YLASSOC.COM <Colin_Clayton cc: @BMC.COM> Subject: Re: The List is Back Sent by: DB2 Data Base Discussion List <DB2-L@RYCI.CO M> [...]
909 19 27_Do we need to re-subscribe?11_Judy Kibler21_judith.kibler@TRW.COM31_Mon, 29 Apr 2002 08:06:38 -0500509_us-ascii Hello all,<br><br>Maybe I didn't fully read one of the early postings regarding the new home for the list, but I am noticing everyone seems to be subscribing. Do we have to sign up again, even if we were already subscribers?<br><br>Thanks, Judy<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
929 40 31_Re: Do we need to re-subscribe?16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 29 Apr 2002 09:29:23 -0400567_iso-8859-1 I did not resubscribe and have been able to receive and send.<br><br>Regards, eric pearson NS ITO Database Support<br><br><br><br>-----Original Message----- From: Judy Kibler [mailto:judith.kibler@TRW.COM] Sent: Monday, April 29, 2002 9:07 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Do we need to re-subscribe?<br><br><br><br>Hello all,<br><br>Maybe I didn't fully read one of the early postings regarding the new home for the list, but I am noticing everyone seems to be subscribing. Do we have to sign up again, even if we were already subscribers? [...]
970 47 31_Re: Do we need to re-subscribe?10_Paul Riker22_paul_riker@YLASSOC.COM31_Mon, 29 Apr 2002 08:31:22 -0500365_us-ascii No you do not need to re-subscribe. The list was copied from the old list server at RYCI.com to listserv.ylassoc.com bringing all of the existing members with it.<br><br>Thanks,<br><br>Paul Riker Consultant Yevich, Lawson & Associates<br><br>"My girlfriend asked me how long I was going to be gone on this tour. I said 'the whole time'" Steven Wright [...]
1018 42 31_Re: Do we need to re-subscribe?16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Mon, 29 Apr 2002 09:29:38 -0400573_us-ascii no need to sebscribe<br><br><br><br><br><br><br><br>Judy Kibler <judith.kibler@TRW.COM> on 04/29/2002 09:06:38 AM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@LISTSERV.YLASSOC.COM><br><br>To: DB2-L@LISTSERV.YLASSOC.COM cc: (bcc: Thomas E. Faglon/Telcordia) Subject: Do we need to re-subscribe?<br><br><br><br><br><br>Hello all,<br><br>Maybe I didn't fully read one of the early postings regarding the new home for the list, but I am noticing everyone seems to be subscribing. Do we have to sign up again, even if we were already subscribers? [...]
1061 40 25_Accessing YLASSOC website14_Clayton, Colin21_Colin_Clayton@BMC.COM31_Mon, 29 Apr 2002 08:36:46 -0500585_iso-8859-1 Thanks Herr Doktor and everyone else who replied,<br><br>however I still cannot access http://listserv.ylassoc.com/ <http://listserv.ylassoc.com/> or www.ylassoc.com <http://www.ylassoc.com> . I get :-<br><br><br><br><br><br><br><br>Bad Gateway<br><br><br><br>The following error occurred:<br><br><br><br>A DNS lookup error occurred. The host was not found.<br><br>_____<br><br><br><br>Please contact the administrator.<br><br><br><br>This is the same whether I use IE or Netscape, and it only happens with this website. Surely I am not the only one ? Is it personal ? [...]
1102 17 31_Re: Do we need to re-subscribe?10_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 29 Apr 2002 15:41:56 +0200374_iso-8859-1 I think you don't, I'm receiving a lot of subscribe requests.....<br><br>Max Scarpa Certified @!$%&@!zot!!£@@<br><br>===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
1120 64 29_Re: Accessing YLASSOC website31_=?iso-8859-1?q?Sanjeev=20....?=24_sanjeev_db2l@YAHOO.CO.IN31_Mon, 29 Apr 2002 14:38:54 +0100594_iso-8859-1 I am also unable to access this website. I hope its going to be up and running today.<br><br>With Best Regards, Sanjeev<br><br>--- "Clayton, Colin" <Colin_Clayton@BMC.COM> wrote: > Thanks Herr Doktor and everyone else who replied, > > however I still cannot access > http://listserv.ylassoc.com/ > <http://listserv.ylassoc.com/> or www.ylassoc.com > <http://www.ylassoc.com> > . I get :- > > > > > Bad Gateway > > > The following error occurred: > > > A DNS lookup error occurred. The host was not found. > > _____ > > > Please contact the administrator. > > > This is the same [...]
1185 128 31_Re: Do we need to re-subscribe?14_Grainger, Phil20_Phil.Grainger@CA.COM31_Mon, 29 Apr 2002 14:47:25 +0100377_iso-8859-1 Definitely NOT<br><br>If you are receiving other peoples "subscribe" messages (which, incidentally, they should NOT be sending to the list but to the list SERVER - hint hint), then you are subscribed<br><br>Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com [...]
1314 38 15_Re: Vendor Spam8_Ron Root24_ron.root@CPA.STATE.TX.US31_Thu, 25 Apr 2002 09:01:17 -0500474_iso-8859-1 That's how you pay for the webcast. If it wasn't worth the cost, don't sign up.<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Jeremiah Eden Sent: Thursday, April 25, 2002 8:09 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Vendor Spam<br><br><br><br>I just got an email advertising CA products because:<br><br>"You have been referred to me as an attendee in our March 6th Webcast discussing DB2 logs." [...]
1353 21 7_Testing19_Insixiengmay, Vince22_vinsixieng@STATE.PA.US31_Mon, 29 Apr 2002 09:49:06 -0400444_iso-8859-1 This is only a test.<br><br>Vince<br><br><br><br>Vince Insixiengmay PA Dept of Revenue Bureau of Information Systems 717-772-9612 vinsixieng@state.pa.us <vinsixieng@state.pa.us><br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
1375 56 26_Re: VSam Extended Datasets14_William Poston21_william.poston@DB.COM31_Mon, 29 Apr 2002 09:32:54 -0600475_us-ascii I want to began a discussion on Vasam extended datasets. We are converting from version 5 to version 7. We are doing a clean install and recreating the environment. We are creating our devl environment now. I have noticed that the datasets are not VSAM extended. What has to be done to create datasets as VSAM Extended? What are the benefits? Larger datasets? Does this means that Segmented tablespaces are not limited to 2 GB before going to a second dataset? [...]
1432 49 67_Re: question about coupling facility gbp size and directory entries11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Mon, 29 Apr 2002 07:14:54 -0400538_ISO-8859-1 Rick<br><br>The SCA and LOCK1 structures must reside in the CFs central storage. The GBP directories must also be in central storage, but the data can reside in expanded storage. GBP data pages can be transferred to and from the CF GBP in expanded storage without having to be staged via central storage. Central storage is limited to 2GB, but you can configure some or all of the extra CF storage as expanded storage and therefore make you GBPs more than 2GB total. Just watch the size of the directory part of the GBPs. [...]
1482 50 21_Re: Changes for z/OS?11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Mon, 29 Apr 2002 07:14:44 -0400393_ISO-8859-1 Mark<br><br>You probably know this already, but ... When you remove your Hiperpools you will want to increase the size of your VBPs. Move one or more VBP to a data space to avoid storage problems in DBM1. The MVS LPAR can have more than 2GB real central storage and so can manage more address spaces and data spaces, but the 2GB virtual address space limit is still in effect. [...]
1533 90 26_Re: VSam Extended Datasets16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 29 Apr 2002 10:46:08 -0400311_iso-8859-1 To use VSAM extended, make sure you use a DFSMS data class which specifies this, and make your tablespace DSSIZE > 4GB. DFSMS must be 1.5 or higher. I think you can only do this with LOBs and partitioned tablespaces. At least I've not made it work with segmented (but I've not tried very hard!) [...]
1624 69 36_Re: Trigger calling stored procedure14_Peter Backlund21_pbacklu@ATTGLOBAL.NET31_Mon, 29 Apr 2002 16:51:09 +0200
1694 76 62_Re: REMINIDER- PLEASE READ - URGENT - DB2L - MOVING WEDNESDAY!14_Toppins, Smike21_smike.toppins@GWL.COM31_Fri, 26 Apr 2002 10:10:01 -0600529_- Is there a problem with DB2-L? I don't appear to be getting the postings anymore since this change?<br><br>SMike Toppins Great-West Life topp@gwl.com<br><br><br><br>-----Original Message----- From: Susan Lawson [mailto:susan_lawson@ylassoc.com] Sent: Wednesday, April 24, 2002 7:55 AM To: DB2-L@ryci.com Subject: REMINIDER- PLEASE READ - URGENT - DB2L - MOVING WEDNESDAY!<br><br>Don't forget....this move occurs tonight at 6pm CST. After this you will need to send/receive mails for the list at DB2-L@listserv.ylassoc.com [...]
1771 75 29_Re: Accessing YLASSOC website12_Phil Gunning17_db2jock@YAHOO.COM31_Mon, 29 Apr 2002 07:49:37 -0700610_us-ascii Colin, this seems like a local error. Have your network folks check it out, try refreshing your browser cache, etc. Regards, Phil<br><br><br><br>--- "Clayton, Colin" <Colin_Clayton@BMC.COM> wrote: > Thanks Herr Doktor and everyone else who replied, > > however I still cannot access > http://listserv.ylassoc.com/ > <http://listserv.ylassoc.com/> or www.ylassoc.com > <http://www.ylassoc.com> > . I get :- > > > > > Bad Gateway > > > The following error occurred: > > > A DNS lookup error occurred. The host was not found. > > _____ > > > Please contact the administrator. > > > This is the same [...]
1847 146 12_Re: z800 box11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Mon, 29 Apr 2002 07:56:03 -0700612_iso-8859-1 Mike, thanks for the info. cliff:-)<br><br>-----Original Message----- From: Dransfield, Michael [mailto:mdransfi@LEHMAN.COM] Sent: Thursday, April 25, 2002 8:23 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: FW: z800 box<br><br><br><br>-----Original Message----- From: Dransfield, Michael Sent: Thursday, April 25, 2002 10:06 AM To: 'DB2 Data Base Discussion List' Subject: RE: z800 box<br><br><br><br>Cliff,<br><br>001: one engine, 192.5 MIPS; 002: two 192.5 MIPS engines, and should = 385 MIPS, but does not because of a certain amount of overhead required to balance work between the two engines. [...]
1994 23 8_SQL0440N13_Thomas Schulz20_thomas.schulz@SVI.DE31_Mon, 29 Apr 2002 09:43:32 -0500336_- Dear List User's<br><br>I try to run a runstats from the Control Center and receive the following message<br><br>SQL0440N - There is no funktion with the name " " and no arguments found in the function path. SQLSTATE 42884<br><br>We have Connect 7.2 PE and DB2 V5.1 running.<br><br>Has anybody a idea.<br><br>Best regards Thomas [...]
2018 113 26_Re: VSam Extended Datasets17_Dr. Michael Ebert18_mebert@AMADEUS.NET31_Mon, 29 Apr 2002 17:18:46 +0200406_us-ascii No. The DSSIZE parameter (or PIECESIZE>4GB), which you need for EA datasets, applies only to partitioned and LOB TSs and their Indexes (the same goes for the V6 LARGE parameter with dataset size 4GB, which is non-EA). You should probably only create EA datasets if you really need them. Mr. Raymond Bell posted some messages about problems and pitfalls a few months ago; search the archives. [...]
2132 20 23_RUNSTATS & NULL columns13_Daryl Johnson28_daryl.johnson@PACIFICORP.COM31_Mon, 29 Apr 2002 09:58:20 -0500283_- Dear list,<br><br>I recieved this comment from one of my users, "RUNSTATS COUNTS NULLS AS A VALUE GREATER THAN 10". I have not been able to find any documentation on this subject and was wondering if anyone could direct me to some or at least shed some light on this subject. [...]
2153 14 48_Ideas for connectivity to Compaq non-stop server18_Sandra Lakenburger34_sandra.lakenburger@MAIL.SPRINT.COM31_Mon, 29 Apr 2002 10:07:27 -0500333_- I have been asked what would be the best way to allow an application running on a Compaq non-stop server the ability to call a DB2 stored procedure. There does not appear to be a flavor of DB2 Connect available that will run on this box so one option being discussed is the use of MQ. Are there any other alternatives? Thanks [...]
2168 17 42_Problems with DB2 V7 maintenance (UQ59415)18_Sandra Lakenburger34_sandra.lakenburger@MAIL.SPRINT.COM31_Mon, 29 Apr 2002 10:18:08 -0500468_- Has anyone successfully installed ptf UQ59415 in a DB2 V7 SMP/E environment? I have tried twice and am getting a rc=08 in the linkedit of DSNRLI. I'm seeing a reference to the DSNACCOR load module that has not yet been installed as PQ48448/UQ60825 has error holds on it. I've got a pmr open with IBM and they're telling me that no one else has reported this kind of problem. At this point, I'm just trying to see if anyone has successfully installed it. Thanks [...]
2186 26 4_Test12_Phil Gunning17_db2jock@YAHOO.COM31_Sun, 28 Apr 2002 18:54:48 -0700683_us-ascii This is a test.<br><br>===== Phil Gunning Certified Advanced Technical Expert -- DB2 DRDA Certified Advanced Technical Expert -- DB2 Clusters 1-877-432-4897x8 Achieving Breakthrough Results for DB2 www.breakthroughdb2.com IDUG North America, San Diego,Ca. May 12-16, 2002<br><br>__________________________________________________ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
2213 22 4_TEST12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Thu, 25 Apr 2002 10:26:52 -04009_us-ascii 
2236 21 0_12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Thu, 25 Apr 2002 13:57:47 -04009_us-ascii 
2258 65 36_Re: DB2 OS/390: Coding SQL statement11_Suresh Sane21_data_arch@HOTMAIL.COM31_Mon, 29 Apr 2002 09:23:37 -0500386_- Ed,<br><br>This should work as written (I recall doing this via a host var - the source of the host var is irrelevant).<br><br>One possible gotcha - beware of bad dates resulting from (say) adding 1 month to March 31 resulting in April 30 (DB2 adjusts). I think you get a sqlcode 0 with warnings but the sqlstate may be non-blank? Bottom line is you need to hanldle it properly. [...]
2324 52 27_Re: RUNSTATS & NULL columns14_Bernd Oppolzer26_Bernd.Oppolzer@T-ONLINE.DE31_Mon, 29 Apr 2002 17:41:07 +0200575_- Hello,<br><br>I only can guess.<br><br>First, NULL-columns have a indicator byte, which is X'FF' for NULL values, and so it could be that RUNSTATS considers the NULL values as very large values, with respect to the stats columns LOW2KEY and HIGH2KEY. Maybe this is what the user observed.<br><br>Another idea: RUNSTATS by default computes the first 10 peak values of a given column and puts this values and their percentages in some catalog table (SYSCOLDIST, I think). If a given column is often NULL, this NULL value may appear (in my opinion) in these peak values. [...]
2377 60 8_Re: Test12_Kline, Wayne27_wayne.kline@INGRAMMICRO.COM31_Mon, 29 Apr 2002 08:57:27 -0700698_iso-8859-1 Ditto.<br><br>-----Original Message----- From: Snyder, Kei E. [mailto:kesnyder@SOUTHERNCO.COM] Sent: Wednesday, April 24, 2002 8:06 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Test<br><br><br><br>Why am I getting emails from you? Shouldn't it just go to the DB2-L? I've been getting LOTS of email that should have gone to the list.<br><br>> -----Original Message----- > From: Seibert, Dave [SMTP:Dave_Seibert@COMPUWARE.COM] > Sent: Wednesday, April 24, 2002 9:35 PM > To: DB2-L@LISTSERV.YLASSOC.COM > Subject: Re: Test > > Looks like we're up and running. > > Right? > > David Seibert > Compuware Corporation File-AID Product Architect > Dave.Seibert@compuware.com > > > > > > > [...]
2438 101 29_Re: Accessing YLASSOC website12_Phil Gunning17_db2jock@YAHOO.COM31_Mon, 29 Apr 2002 08:45:41 -0700611_us-ascii Depending on where you are located and how your DNS is setup it might take till this afternoon. In the meantime, try http://209.16.210.42. Everyone should be fine by this afternoon at the latest. Phil<br><br>Assoc List Owner DB2-L<br><br>--- "Sanjeev ...." <sanjeev_db2l@YAHOO.CO.IN> wrote: > I am also unable to access this website. I hope its > going to be up and running today. > > With Best Regards, > Sanjeev > > --- "Clayton, Colin" <Colin_Clayton@BMC.COM> wrote: > > > Thanks Herr Doktor and everyone else who replied, > > > > however I still cannot access > > http://listserv.ylassoc.com/ [...]
2540 125 29_Re: Accessing YLASSOC website12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Mon, 29 Apr 2002 09:47:17 -0400539_us-ascii No i get the samething. Jeff<br><br><br><br><br><br><br><br>"Clayton, Colin" <Colin_Clayton@BMC.COM> Sent by: DB2 Data Base Discussion List <DB2-L@RYCI.COM> 04/29/02 09:36 AM Please respond to DB2 Data Base Discussion List<br><br><br><br>To: DB2-L@LISTSERV.YLASSOC.COM cc: Subject: Accessing YLASSOC website<br><br><br><br>Thanks Herr Doktor and everyone else who replied,<br><br>however I still cannot access http://listserv.ylassoc.com/ <http://listserv.ylassoc.com/> or www.ylassoc.com <http://www.ylassoc.com> . I get :- [...]
2666 26 21_Re: Changes for z/OS?17_Armando Zaporteza29_armando.zaporteza@PHOENIX.GOV31_Mon, 29 Apr 2002 09:15:28 -070031_us-ascii Test... test..<br><br>
2693 50 36_Re: DB2 OS/390: Coding SQL statement14_Bernd Oppolzer26_Bernd.Oppolzer@T-ONLINE.DE31_Mon, 29 Apr 2002 17:32:48 +0200492_- I think, Step 2 is possible. I did it already with CURRENT TIMESTAMP + :hv MINUTES; that should be the same.<br><br>Regards<br><br>Bernd<br><br><br><br><br><br>Am Don, 25 Apr 2002 schrieben Sie: > All, > > (1) A Cobol SQL question: > > - COL A in Table 1 is defined as a DATE field > - COL B in Table 2 is defined as a SMALLINT field to represent number of > months > > (2) A programmer would like to do the following: > > STEP 1: Select COL B from TABLE 2 into :HV > > STEP 2: UPDATE [...]
2744 74 36_Re: Trigger calling stored procedure15_Saffer, Michele26_Michele.Saffer@ACS-INC.COM31_Mon, 29 Apr 2002 12:26:32 -0400355_iso-8859-1 This is what I've already tried and can't do. It does state in the DB2 UDB for OS/390 Version 6 SQL reference that "If the trigger is defined as BEFORE, a fullselect must not refer to the triggering table." I assume this means that I cannot do what you are suggesting, either in the trigger or in a stored procedure called by the trigger. [...]
2819 30 8_Test....17_Armando Zaporteza29_armando.zaporteza@PHOENIX.GOV31_Mon, 29 Apr 2002 09:56:11 -070079_us-ascii Test... test.....<br><br>Undelivered the last few time I send.<br><br>
2850 212 12_Re: Test....19_Insixiengmay, Vince22_vinsixieng@STATE.PA.US31_Mon, 29 Apr 2002 13:08:01 -0400321_iso-8859-1 Your test is ok. It's good.<br><br><br><br>Vince<br><br>-----Original Message----- From: Armando Zaporteza [mailto:armando.zaporteza@PHOENIX.GOV] Sent: Monday, April 29, 2002 12:56 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Test....<br><br><br><br>Test... test.....<br><br>Undelivered the last few time I send.
3063 60 15_Re: UDB Journal14_Steve Westfall26_Steve.Westfall@EQUIFAX.COM31_Mon, 29 Apr 2002 12:13:41 -0500580_us-ascii Adam,<br><br>I don't believe that the Journal has any facility for cancelling running jobs. [ Hint to IBM: this would be a nice future enhancement! ]<br><br>You don't mention what platform you are running on, but you'll have to take care of it using your native operating system commands. For example, on UNIX you would use "ps" to identify the process ID, then use "kill" to terminate the process. On NT/Windows 2000, I'm not sure, perhaps use the Windows Task Manager to display running applications and processes, then use the "End Task" or "End process" button. [...]
3124 14 4_test8_K.Balaji19_K.Balaji@TARGET.COM31_Mon, 29 Apr 2002 12:19:59 -0500303_iso-8859-1 test mail Balaji Ph # (510) 727-3259<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
3139 79 15_Re: UDB Journal16_Cynthia Prohaska22_c_prohaska@HOTMAIL.COM31_Mon, 29 Apr 2002 17:40:46 +0000653_- NT / Windows 2000 use 'pulist' then kill.<br><br><br><br>>From: Steve Westfall <Steve.Westfall@EQUIFAX.COM> >Reply-To: DB2 Data Base Discussion List <DB2-L@LISTSERV.YLASSOC.COM> >To: DB2-L@LISTSERV.YLASSOC.COM >Subject: Re: UDB Journal >Date: Mon, 29 Apr 2002 12:13:41 -0500 > >Adam, > >I don't believe that the Journal has any facility for cancelling running >jobs. [ Hint to IBM: this would be a nice future enhancement! ] > >You don't mention what platform you are running on, but you'll have to take >care of it using your native operating system commands. For example, on >UNIX you would use "ps" to identify the process ID, then use "kill" [...]
3219 50 9_test mail9_M.Nagaiah20_M.Nagaiah@TARGET.COM31_Mon, 29 Apr 2002 12:41:33 -0500110_iso-8859-1 Test .....<br><br>Thanks & Regards ,<br><br>Nagaiah, Mervyn's California, 510-727-3123 (w).<br><br>
3270 117 36_Re: Trigger calling stored procedure15_Saffer, Michele26_Michele.Saffer@ACS-INC.COM31_Mon, 29 Apr 2002 14:01:09 -0400577_iso-8859-1 Thank you very much for your response. Turns out my problem was with the fact that I did not have indicator variables in the linkage section of my stored procedure for my input parameters. Turns out this is described pretty well in the Application Programming Guide under the section, Example of stored procedure linkage convention DB2SQL. So between the Redbook and the DB2 manuals, I found pretty much all the info I needed to return the SQLSTATE from a stored procedure to a trigger. One thing I could not find was an example of a call to a stored procedure [...]
3388 61 84_Off-topic - if you work as a DB2 DBA for ACS, could you please co ntact me off list?16_Brookman, Gerald30_gerald.brookman@ATOSORIGIN.COM31_Thu, 25 Apr 2002 14:18:49 -0400262_iso-8859-1 This is NOT about applying for employment!!!. Thanks.<br><br>Gerald R. (Garry) Brookman Atos Origin, Inc. DB2 Technician 5000 South Bowen Road Arlington, TX 76017 (817) 264-8336 Fax (817) 264-8599 E-mail: gerald.brookman@atosorigin.com<br><br><br><br>
3450 70 35_Questions about new DB2 Sub-Systems22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM31_Mon, 29 Apr 2002 14:18:38 -0500485_- We're a new DB2 shop and so far, we've had one DB2 Sub-System in our Test LPAR. We're now ready to create our Sub-Systems in our Prod LPAR. I have the following questions:<br><br>1. Our Systems folks are saying that all they'll do is copy the Run-time libraries over and rename them to 4 different sets (for 4 Sub-systems) and I need to do is go thru' the panels required to customize DB2 and of course, I'll have to create Catalog, Directory etc manually. Is this a good idea? [...]
3521 20 24_3390-3 Volume allocation7_Su Arun22_subha_sivaji@YAHOO.COM31_Mon, 29 Apr 2002 14:19:27 -0500471_- Hi listers , We are OS/390 with 3390-3 volumes.In a specific volume , I have both User managed and System managed Datasets related with DB2 tablespaces. This volume is 98% full . The question have is , if the space is requested by user defined VSAM files when it grow ( assuming < 2G ), will the new volume be added by system manager as in the case of System managed datasets as it grow ( related with DB2 tablespaces) . Can some one please help me to understand. [...]
3542 105 35_Questions about new DB2 Sub-Systems22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM31_Mon, 29 Apr 2002 14:18:38 -0500496_Windows-1252 We're a new DB2 shop and so far, we've had one DB2 Sub-System in our Test LPAR. We're now ready to create our Sub-Systems in our Prod LPAR. I have the following questions:<br><br>1. Our Systems folks are saying that all they'll do is copy the Run-time libraries over and rename them to 4 different sets (for 4 Sub-systems) and I need to do is go thru' the panels required to customize DB2 and of course, I'll have to create Catalog, Directory etc manually. Is this a good idea? [...]
3648 105 35_Questions about new DB2 Sub-Systems22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM31_Mon, 29 Apr 2002 14:18:38 -0500496_Windows-1252 We're a new DB2 shop and so far, we've had one DB2 Sub-System in our Test LPAR. We're now ready to create our Sub-Systems in our Prod LPAR. I have the following questions:<br><br>1. Our Systems folks are saying that all they'll do is copy the Run-time libraries over and rename them to 4 different sets (for 4 Sub-systems) and I need to do is go thru' the panels required to customize DB2 and of course, I'll have to create Catalog, Directory etc manually. Is this a good idea? [...]
3754 85 39_Re: Questions about new DB2 Sub-Systems16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 29 Apr 2002 15:56:26 -0400572_iso-8859-1 1) copy runtime and customize from there has worked for me many times in the past. I don't think you need to do the server-pack install if you copy all the right things and run the right catalog/directory/bsds/clsit/panel initializations etc. 2) what you can have only one of per LPAR is the ERLY code - the code which is in SDSNLINK. This code is accessed at IPL time from a LINKLIST library. Fortunately ERLY code is very stable, downward tolerant to subsystems at least one and usually more versions older, and changes very little. So if you have 4 DB2 [...]
3840 79 39_Re: Questions about new DB2 Sub-Systems14_Picou, Michael33_picou.michael@MAIL.DC.STATE.FL.US31_Mon, 29 Apr 2002 15:55:04 -0400542_- There are some things that should be in different libraries for each image of DB2 you bring up, separate these out with a node in the dataset. I don't know if you really want to have 4 sets of DB2 load modules (DSNxxx.SDSNLOAD, SYS1.DSNxxx. etc.), I assume the test LPAR is for system testing and the prod LPAR is used for programming & production, perhaps you could test eminence on the test LPAR. If you have more than 1 library of the DB2 load modules on the prod LPAR it can turn into a headache to keep straight where maintenance [...]
3920 54 15_REBIND PROBLEM.16_Sreedhar Bobbadi24_sbobbadi@DUKE-ENERGY.COM31_Mon, 29 Apr 2002 16:05:17 -0400776_us-ascii Hi Folks<br><br>We recently upgraded to Ver 7 DB2 OS/390. During REBIND I am getting the following error.<br><br>READY DSN S(DD11) DSN REBIND PACKAGE (PASSPTST.P506415.(*)) DSNT254I -DD11 DSNTBRB2 REBIND OPTIONS FOR PACKAGE = ADS.PASSPTST.P506415.() ACTION OWNER TIGTECH QUALIFIER PASSPTST VALIDATE BIND EXPLAIN YES ISOLATION CS RELEASE DEALLOCATE COPY DSNT255I -DD11 DSNTBRB2 REBIND OPTIONS FOR PACKAGE = ADS.PASSPTST.P506415.() SQLERROR NOPACKAGE CURRENTDATA NO DEGREE ANY DYNAMICRULES DEFER NOREOPT VARS KEEPDYNAMIC NO IMMEDWRITE NO DBPROTOCOL PRIVATE OPTHINT ENCODING EBCDIC(00037) PATH DSNT232I -DD11 SUCCESSFUL REBIND FOR PACKAGE = ADS.PASSPTST.P506415.() DSN REBIND PACKAGE (PASSPTST.P506417.(*)) DSN ENDED DUE TO ERROR+ SYSTEM ABEND CODE 04E REASON CODE [...]
3975 95 39_Re: Questions about new DB2 Sub-Systems23_Tello Najera Juan Pablo26_jp.tello@BBVA.BANCOMER.COM31_Mon, 29 Apr 2002 15:39:47 -0500526_iso-8859-1 Venkatesh<br><br>1.- Whenever you install a new subsystem you need to go through the Installation CLIST for each new subsystem. Each subsystem will need it's own VCAT alias, and its own Catalgo and Directory. I think that defining new ones for each one, is the best way to do it. You don't need to do a server pack installation for each subsystem, but if you are not an SMP expert maybe this is the best way to do it. Also I think and this is going to save you a lot of rework in a few months, You should have [...]
4071 88 15_Re: UDB Journal20_Napolitano, Fabrizio22_fnapolitano@INSIRIO.IT31_Mon, 29 Apr 2002 22:42:08 +0200366_iso-8859-1 Hi, I think it's a Journal bug. There are some jobs finished or abended that are still reported as running. I think at the moment the only way to clean it was to delete a couple of configuration file in the DAS istance path. Sorry but I don't remember which of them... you should try to browse the list archive or the ones of comp.databases.ibm-db2. [...]
4160 151 39_Re: Questions about new DB2 Sub-Systems22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM31_Mon, 29 Apr 2002 15:40:11 -0500347_- Thanks, Eric and Michael. I think I'll go with you guys and stay with only one set of DB2 Load Libs/LPAR. As far the Sub-System installation, I may have to struggle to get everything right for the first one, but, I think I can get it. If not, since we're new, I always have the option to delete everything and run Server-Pack installation. [...]
4312 186 39_Re: Questions about new DB2 Sub-Systems22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM31_Mon, 29 Apr 2002 15:40:11 -0500358_Windows-1252 Thanks, Eric and Michael. I think I'll go with you guys and stay with only one set of DB2 Load Libs/LPAR. As far the Sub-System installation, I may have to struggle to get everything right for the first one, but, I think I can get it. If not, since we're new, I always have the option to delete everything and run Server-Pack installation. [...]
4499 186 39_Re: Questions about new DB2 Sub-Systems22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM31_Mon, 29 Apr 2002 15:40:11 -0500358_Windows-1252 Thanks, Eric and Michael. I think I'll go with you guys and stay with only one set of DB2 Load Libs/LPAR. As far the Sub-System installation, I may have to struggle to get everything right for the first one, but, I think I can get it. If not, since we're new, I always have the option to delete everything and run Server-Pack installation. [...]
4686 38 4_test12_Rajesh Parab22_Rajesh.Parab@TELUS.COM31_Mon, 29 Apr 2002 14:50:23 -060019_iso-8859-1 <br><br>
4725 28 16_Cost per insert?10_Mark Labby21_mlabby@AESSUCCESS.ORG31_Mon, 29 Apr 2002 17:20:19 -0400529_us-ascii Is there some rule of thumb to estimate the cost of doing inserts in a mainframe environment?<br><br>We have users who want to make a fairly major change to their process which would add millions of inserts to a process each night. They would be done using individual statements throughout the night using a trigger, not as a block or with a utility. I did warn them that there was going to be a performance cost to adding all of this activity due to increased I/O, logging, locking, contention on the table, etc.. [...]
4754 25 34_Permissions on Export Output Files16_Swinski, Kenneth23_KSwinski@MASSMUTUAL.COM31_Mon, 29 Apr 2002 17:23:55 -0400272_iso-8859-1 In DB2 for AIX, the export utility always creates an ixf file without any permission for "other" to read it (-rw-r-----). The umask makes no difference. I know I can do a chmod, but is there a way for export to create the file so that "other" can read it? [...]
4780 57 22_PeopleSoft SQL Problem15_Zimmerman Terry35_Terry.Zimmerman@GENERALCASUALTY.COM31_Mon, 29 Apr 2002 06:45:37 -0500360_iso-8859-1 We are having problems with the following PeopleSoft generated SQL statement. Before upgrading to OS/390 DB2 V7, the SQL statement would return rows. Currently no rows are returned. I am being told by the applications people that they think it is a DB2 bug. IBM has been contacted about this problem. They are sending it to their defects team. [...]
4838 56 38_Re: Permissions on Export Output Files18_Gert van der Kooij16_gkooij@XS4ALL.NL31_Mon, 29 Apr 2002 23:34:20 +0200463_iso-8859-1 Hi,<br><br>I can't test it at home, but if I remember right you can touch the file before running the export and chmod it the way you want it (and at least write for the DB2 instance owner).<br><br>Hope this helps<br><br>----- Original Message ----- From: "Swinski, Kenneth" <KSwinski@MASSMUTUAL.COM> Newsgroups: bit.listserv.db2-l To: <DB2-L@LISTSERV.YLASSOC.COM> Sent: Monday, April 29, 2002 11:23 PM Subject: Permissions on Export Output Files [...]
4895 38 26_Re: VSam Extended Datasets12_Raymond Bell17_rbell@NZ1.IBM.COM31_Tue, 30 Apr 2002 09:50:15 +1200444_us-ascii Peer recognition! Cool! I'm well on the way to achieving Maslow's Hierarchy of Needs. Now all I need is a flash car, a house, shedloads of dosh, etc. OK, so strictly speaking they're not in Maslow's hierarchy, but I feel like I need them...<br><br><br><br>Raymond PS. On a serious note, try and avoid the 'large' clause (unless you're V5). Just stick to using the 'dssize' clause if you wanna go large. From the V6 SQL Reference: [...]
4934 120 29_Re: AIX UDB EE V7.2 code base14_Swamy Kanathur24_swamy.kanathur@QUEST.COM31_Mon, 29 Apr 2002 15:14:36 -0700488_iso-8859-1 But the levels are different when you do a db2level<br><br>UDB EE V7.2 is v7.1.0.40 UDB V7.1 FP3 is v7.1.0.41<br><br>Swamy Kanathur<br><br>-----Original Message----- From: Martin, Paul [mailto:Paul.Martin@ECOLAB.COM] Sent: Thursday, April 25, 2002 8:19 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: AIX UDB EE V7.2 code base<br><br><br><br>I have heard that you can get to UDB EE V7.2 either by installing it using the V7.2 CD or installing V7.1 and then installing fixpak3. [...]
5055 18 28_Re: 3390-3 Volume allocation14_Donald A Smith18_dsmithj@US.IBM.COM31_Mon, 29 Apr 2002 16:53:53 -0400463_us-ascii The user defined VSAM cluster will have to have been defined w/sufficient candidate volumes to allow this dataset to extend to new volumes. You may have to run an IDCAMS ALTER ADDVOL on the VSAM cluster to specify additional volumes. In a SMS managed environment the ADDVOL statement will look something like this where the * represents 1 volume: ADDVOL(* * * * *). This is how we do it in my shop. Be sure to put a space between each *. Good luck. [...]
5074 70 18_Lost Update Method13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Mon, 29 Apr 2002 17:24:21 -0500458_iso-8859-1 Hi,<br><br>I have 2 questions.<br><br>1. I wanted to know what techniques other site use to resolve the lost update scenario? (We use a trigger and counter to manage this issue describe below if you are interested)<br><br>2. Could anyone say what techniques other DBMS's use to solve the issue?<br><br>---------------------------------------------------------------------------- ------------------------<br><br>Some other information for ya. [...]
5145 49 12_Re: SQL0440N13_LOMBARD,Shaun25_shaun.lombard@DEWR.GOV.AU31_Tue, 30 Apr 2002 08:36:08 +1000488_US-ASCII Do you have the DSNUTILS stored procedure defined on DB2 V5.1 ?<br><br>-----Original Message----- From: Thomas Schulz [mailto:thomas.schulz@SVI.DE] Sent: Tuesday, April 30, 2002 12:44 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: SQL0440N<br><br><br><br>Dear List User's<br><br>I try to run a runstats from the Control Center and receive the following message<br><br>SQL0440N - There is no funktion with the name " " and no arguments found in the function path. SQLSTATE 42884 [...]
5195 24 30_Problem with a query on OS/39019_Sachin Girish Kumar33_sachin.girishkumar@ORBITECH.CO.IN31_Tue, 30 Apr 2002 03:59:10 +0530530_ISO-8859-1 Hi<br><br>The following query works fine on UDB on SUN Solaris.<br><br>SELECT HOUR(TIM_STP), count(MSG_ID) FROM MSG_LOG a group by HOUR(TIM_STP)<br><br>However when we are connecting to DB2 on OS/390 it does not work. Any reasons for this ??<br><br>Regards Sachin<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
5220 121 22_Re: Lost Update Method10_James Kwan19_jamesdb2kwan@CS.COM31_Mon, 29 Apr 2002 17:48:38 -0500586_iso-8859-1 Glenn,<br><br>Before I answer your questions, I just want to point out that I know a lot of non-mainframe developers don't test their applications extensively. QA is a foreign word to them.<br><br>1) We have used a similar method you describe in your technique for single row update session with timestamp instead of update seq number. The idea is the same and it should work. This is help to improve concurrency expecially during the old days where you don't have row locking. I don't see how you can lose a transaction update by using this technique. DB2 (or any DBMS [...]
5342 97 22_Re: Lost Update Method13_Steve Tennant28_steve.tennant@CUSTOMS.GOV.AU31_Tue, 30 Apr 2002 08:58:05 +1000575_iso-8859-1 Hi Glenn, to answer your web developers questions I would explain that if two transactions are trying to do this at the same time, then db2's locking does take care of it. However if you are psuedo conversational and 'remembering' data between transactions then it simply is not possible.<br><br>To answer your question: We are using a timestamp (LAST_UPDATED column). I have seen both methods used (a count and a timestamp) and the only problem that can occur with the count, depending on design, is the time/effort taken to find the current largest number. [...]
5440 104 22_Re: Lost Update Method10_James Kwan19_jamesdb2kwan@CS.COM31_Mon, 29 Apr 2002 17:53:46 -0500669_iso-8859-1 Glenn,<br><br>Amendment to my previous message. You did use trigger. I am wondering why are losing your update data.<br><br><br><br>Regards,<br><br>James Kwan IBM Certified Solutions Expert ----- Original Message ----- From: "Mackey, Glenn" <GMackey@GUIDEMAIL.COM> Newsgroups: bit.listserv.db2-l To: <DB2-L@LISTSERV.YLASSOC.COM> Sent: Monday, April 29, 2002 5:24 PM Subject: Lost Update Method<br><br><br><br>> Hi, > > I have 2 questions. > > 1. I wanted to know what techniques other site use to resolve the lost > update scenario? (We use a trigger and counter to manage this issue describe > below if you are interested) > > 2. Could anyone say what [...]
5545 84 19_Re: REBIND PROBLEM.13_LOMBARD,Shaun25_shaun.lombard@DEWR.GOV.AU31_Tue, 30 Apr 2002 08:55:03 +1000435_US-ASCII Lookup the 00E70005 error message, it provides some clues on how to determine what is wrong. Additional information can be found in the SVC Dump and SYS1.LOGREC. It would also help to search IBMLINK for any known problems.<br><br>Shaun<br><br>-----Original Message----- From: Sreedhar Bobbadi [mailto:sbobbadi@DUKE-ENERGY.COM] Sent: Tuesday, April 30, 2002 6:05 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: REBIND PROBLEM. [...]
5630 173 30_Debugging SQL Stored Procedure12_Rajesh Parab22_Rajesh.Parab@TELUS.COM31_Mon, 29 Apr 2002 16:57:42 -0600635_iso-8859-1 Hi Everyone,<br><br>What kind of techniques everybody is using to debug SQL Stored Procedure. We are using some batch debugging buts its lot of work to trap all the information. Is there any easy way we can debug/troubleshoot SQL Stored Procedure. If SQL Stored procedure happens to fail in production environment is there any way we can trap all the information without hand-coding bunch of insert statement inside SQL Stored Procedure. We are looking at getting as much information as possible like procedure name, location, SQL, SQLCODE, SQLSTATE, If possible data used for failed SQL etc. There is no documentation [...]
5804 52 34_Re: Problem with a query on OS/39014_Bernd Oppolzer26_Bernd.Oppolzer@T-ONLINE.DE31_Tue, 30 Apr 2002 01:17:31 +0200562_- Hello,<br><br>with DB2 for OS/390, you cannot GROUP on expressions directly.<br><br>Instead you have to use a nested table expression as follows:<br><br>select h, count(*) from (SELECT HOUR(TIM_STP) as h, MSG_ID FROM MSG_LOG) as a group by h;<br><br>Another issue: count(column) is not supported by DB2 for OS/390, as it's always the same as count(*). count(distinct column) is supported. Therefore you wouldn't have to select msg_id in the inner query. Otherwise, you could specify count(distinct msg_id) on the outer query, if that's what you intended. [...]
5857 193 30_Debugging SQL Stored Procedure12_Rajesh Parab22_Rajesh.Parab@TELUS.COM31_Mon, 29 Apr 2002 09:28:31 -0600635_iso-8859-1 Hi Everyone,<br><br>What kind of techniques everybody is using to debug SQL Stored Procedure. We are using some batch debugging buts its lot of work to trap all the information. Is there any easy way we can debug/troubleshoot SQL Stored Procedure. If SQL Stored procedure happens to fail in production environment is there any way we can trap all the information without hand-coding bunch of insert statement inside SQL Stored Procedure. We are looking at getting as much information as possible like procedure name, location, SQL, SQLCODE, SQLSTATE, If possible data used for failed SQL etc. There is no documentation [...]
6051 31 36_OMVS-mounted DB2 for OS/390 Datasets12_Raymond Bell17_rbell@NZ1.IBM.COM31_Tue, 30 Apr 2002 12:01:55 +1200486_us-ascii Colleagues,<br><br>Our sysprogs here are having a bit of a cleanup and came across some seemingly DB2-related OMVS datasets. I've tried to find out what they might be used for but aren't having much luck searching the Admin and Install manuals.<br><br>The datasets have names like this:<br><br>OMVS.DSN*subsystemname*.JDBC.*LPARname*.HFS<br><br>Any clues as to what these are/are for? Or, if you feel I'm being lazy, any pointers as to where I can find the relevant info? [...]
6083 46 34_Re: Debugging SQL Stored Procedure12_Phil Gunning28_pgunning@BREAKTHROUGHDB2.COM31_Mon, 29 Apr 2002 20:39:54 -0400652_- Check out the Redbook, Cross-Platform DB2 Stored Procedures: Building and Debugging, SG24-5485-01and the Application Programming and SQL Guide. Phil<br><br>> Hi Everyone,<br><br>What kind of techniques everybody is using to debug SQL Stored Procedure. We are using some batch debugging buts its lot of work to trap all the information. Is there any easy way we can debug/troubleshoot SQL Stored Procedure. If SQL Stored procedure happens to fail in production environment is there any way we can trap all the information without hand-coding bunch of insert statement inside SQL Stored Procedure. We are looking at getting as much information as [...]
6130 156 39_Re: Questions about new DB2 Sub-Systems14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 30 Apr 2002 10:39:24 +1000549_US-ASCII One option to consider is to have one set of runtime libraries, and use catalog aliases to give each subsystem their own 'image' of those libraries. So: real libraries are SYS2.DB2#1.SDSNLOAD, etc aliases are: SYS2.DB2P.SDSNLOAD, SYS2.DB2Q.SDSNLOAD etc<br><br>The advantage comes when applying maintenance, upgrades etc. You create a new set of libraries (SYS2.DB2#2.SDSNLOAD etc), and switch a subsystem's aliases to use the new set. When happy, switch all the other aliases over and delete the the original (SYS2.DB2#1...) libraies. [...]
6287 42 34_Re: Problem with a query on OS/39014_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 30 Apr 2002 10:39:24 +1000601_US-ASCII DB2 for z/OS and OS/390 does not allow GROUP BY on anything other than a column name.<br><br>Try select hour_tim_stp, count_msg_id from ( SELECT HOUR(TIM_STP) as hour_tim_stp, count(MSG_ID) as count_msg_id FROM MSG_LOG) as a group by HOUR_TIM_STP<br><br>James Campbell<br><br>On 30 Apr 2002 at 3:59, Sachin Girish Kumar wrote:<br><br>> Hi > > The following query works fine on UDB on SUN Solaris. > > SELECT HOUR(TIM_STP), count(MSG_ID) FROM MSG_LOG a group by > HOUR(TIM_STP) > > However when we are connecting to DB2 on OS/390 it does not work. Any > reasons for this ?? > > Regards > [...]
6330 14 4_test14_Steve Anderson18_andste@IWAYNET.NET31_Mon, 29 Apr 2002 20:52:43 -0400271_iso-8859-1 Test<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
6345 55 36_OMVS-mounted DB2 for OS/390 Datasets12_Raymond Bell17_rbell@NZ1.IBM.COM31_Tue, 30 Apr 2002 13:08:21 +1200311_us-ascii Typical. As soon as I post a question I find the answer myself. Should have known from the 3rd qualifier below. They're for SQLJ and JDBC Java support, which we don't use, which is probably why they're not mounted.<br><br>Don't worry about replying to my first note, unless I'm well off the mark. [...]
6401 15 47_Le BD Nguyen/AIS/US/Ahold is out of the office.12_Le BD Nguyen20_lnguyen@AHOLDUSA.COM31_Mon, 29 Apr 2002 21:11:17 -0400423_us-ascii I will be out of the office starting 04/29/2002 and will not return until 05/03/2002.<br><br>I am out of the office from 04/29/2002 to 05/02/2002 inclusively.<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
6417 28 76_Re: Running RUNSTATS ( DB2 on OS/390) on Tablespaces only when the y need it0_19_Tim.Lowe@STPAUL.COM31_Thu, 25 Apr 2002 09:36:05 -0500485_us-ascii Sanjeev, I am curious, how would the _HIST tables in DB2 V7 help automate runstats?<br><br>I can see how real-time stats in DB2 V7 could help automate this, but not the _HIST tables.<br><br>Thanks, Tim Lowe IBM Certified Solutions Expert DB2 UDB V7.1 Database Administration for OS/390<br><br>Sanjeev wrote: Looks like _HIST catalog tables in V7 for OS/390 should help you automate the whole process. But it has a little bit of work to do before you can enjoy its usage. [...]
6446 26 9_Traces???15_Mark Maziarczyk22_MMaziarczyk@SYMCOR.COM31_Mon, 29 Apr 2002 22:33:48 -0400494_us-ascii I don't know how to run a trace on the database, can someone tell me how?? I am new to DB2 and am the person that people come to ask when something goes wrong, what has been happening recently is that when we try to stop DB2 for offline backups, the database stays up and returns an error. What we would like to do is run a trace to see what is causing this the next time it happens. It does not happen all the time but it is something that we want to look at. We are running DB2 [...]
6473 102 22_Re: Lost Update Method11_David Nance16_DWNance@FHSC.COM31_Mon, 29 Apr 2002 22:56:42 -0400358_US-ASCII Glenn, Are the program's SQL being run with cursor stability? What about using a cursor with "FOR UPDATE OF"? The other way to go is as someone mentioned earlier with selecting a timestamp, then update where timestamp = :HV.<br><br>Dave Nance First Health Services, Corp. (804)527-6841<br><br>>>> GMackey@GUIDEMAIL.COM 04/29/02 06:24PM >>> Hi, [...]
6576 231 29_Re: AIX UDB EE V7.2 code base19_Michael Piontkowski34_michael_piontkowski@COMPUSERVE.COM31_Mon, 29 Apr 2002 23:01:28 -0400501_iso-8859-1 RE: AIX UDB EE V7.2 code baseI remember reading on DB2-L that there are some differences between DB2 UDB V7.2 on CD and DB2 UDB + FP3.<br><br>Search the DB2-L archives (or http://www.dejanews.com) for " DB2 FP3". Essentially they are the same.<br><br>From dejanews...<br><br>From: Blair Kenneth Adamache (adamache@ca.ibm.com) Subject: Re: Does DB2 V7 FP3 = DB2 7.2 ? Newsgroups: comp.databases.ibm-db2 View: Complete Thread (5 articles) | Original Format Date: 2001-04-30 08:00:27 PST [...]
6808 95 22_Re: Lost Update Method9_Rob Crane22_racrane@CONCENTRIC.NET31_Mon, 29 Apr 2002 23:18:24 -0600343_us-ascii WEB based applications tied to OO languages tend to use a BLACK BOX approach which select an entire row and update an entire row only if one column of that row has changed which adds to what DB2 has to log along with the other concerns you have with update statements occurring without ensuring the selected row is most current. [...]
6904 22 40_Re: OMVS-mounted DB2 for OS/390 Datasets10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 30 Apr 2002 08:39:49 +0200541_us-ascii Hi Raymond<br><br>They are HFS created installing JAVA for DB2 (JDBC/SQLJ) to have room for directories like usr/lpp/db2/......under USS. Take a look to Peggy Rader's papers for a checklist of all directories (IDUG solution Journal)<br><br>HTH<br><br>Max Scarpa Certified *.**<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
6927 40 11_unsubscribe29_Umapathy, Gopalakrishna (CTS)26_UGopalak@CHN.COGNIZANT.COM31_Tue, 30 Apr 2002 12:22:43 +0530268_- <br><br><br><br>Cheers. _________________________________________________________________________ Gopal (Tmoil Offshore) * work (91) (44) 811 3063 Ext-2334 * ugopalak@chn.cognizant.com _________________________________________________________________________<br><br>
6968 27 20_Re: Cost per insert?10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 30 Apr 2002 09:23:14 +0200343_us-ascii Hi<br><br>There are 2 recent Shibamiya's papers about insert performance (July 2000) :<br><br>'Insert Performance Considerations in DB2 for OS/390 - Part 1 & 2'<br><br>You can find it in www.share.org web site (proceeedings)<br><br>If you won't be able to find these papers let me know I'll send you the articles in .zip format. [...]
6996 31 36_Re: Harry -cdn is out of the office.11_ANGOT HARRY18_harry.angot@CDN.FR31_Tue, 30 Apr 2002 09:41:10 +0200362_- > I will be out of the office starting 04/30/2002 and will not return until > 05/06/2002. > > . > > ================================================ > To change your subscription options or to cancel your subscription visit > the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list > can be reached at DB2-L-REQUEST@listserv.ylassoc.com. [...]
7028 25 40_ADO Update with DateTime columns-Sovled!11_Dimoka Popy24_dimokap@INTERAMERICAN.GR31_Tue, 30 Apr 2002 11:19:08 +0300417_- Hello Listers ! For those who had followed my thread and anybody else interested,I'd like to say that the problem i had when trying to directly update a timestamp column through a VB Result Set with a value like "2000-05-21-22.30.02.204702" was finally solved by setting Patch1=131084 (describe timestamps as a char(26) ) in db2cli.ini. That was recommended by Chuck Kosin,who had also faced the same problem. [...]
7054 136 15_Re: UDB Journal12_Brejza, Adam23_Adam.Brejza@GEDAS.CO.UK31_Tue, 30 Apr 2002 11:03:44 +0100871_iso-8859-1 Many thanks Fabrizio, I'll check that out.<br><br>Regards, Adam.<br><br>Adam Brejza<br><br>--------------------------------------------------- gedas united kingdom limited CC Operations Garamonde Drive, Wymbush Milton Keynes MK8 8NZ England Phone +44-1908-548244 Telefax +44-1908-548611 Mailto:adam.brejza@gedas.co.uk http://www.gedas.net ---------------------------------------------------<br><br><br><br><br><br>-----Original Message----- From: Napolitano, Fabrizio [mailto:fnapolitano@INSIRIO.IT] Sent: 29 April 2002 21:42 To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: UDB Journal<br><br><br><br>Hi, I think it's a Journal bug. There are some jobs finished or abended that are still reported as running. I think at the moment the only way to clean it was to delete a couple of configuration file in the DAS istance path. Sorry but I don't remember which [...]
7191 124 15_Re: UDB Journal12_Brejza, Adam23_Adam.Brejza@GEDAS.CO.UK31_Tue, 30 Apr 2002 11:04:45 +0100628_iso-8859-1 Many thanks Cynthia, I'll give that a go.<br><br>Adam Brejza<br><br>--------------------------------------------------- gedas united kingdom limited CC Operations Garamonde Drive, Wymbush Milton Keynes MK8 8NZ England Phone +44-1908-548244 Telefax +44-1908-548611 Mailto:adam.brejza@gedas.co.uk http://www.gedas.net ---------------------------------------------------<br><br><br><br><br><br>-----Original Message----- From: Cynthia Prohaska [mailto:c_prohaska@HOTMAIL.COM] Sent: 29 April 2002 18:41 To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: UDB Journal<br><br><br><br>NT / Windows 2000 use 'pulist' then kill. [...]
7316 109 15_Re: UDB Journal12_Brejza, Adam23_Adam.Brejza@GEDAS.CO.UK31_Tue, 30 Apr 2002 11:07:16 +0100756_iso-8859-1 Many thanks Steve, I'll give it a go.<br><br>Regards, Adam.<br><br>Adam Brejza<br><br>--------------------------------------------------- gedas united kingdom limited CC Operations Garamonde Drive, Wymbush Milton Keynes MK8 8NZ England Phone +44-1908-548244 Telefax +44-1908-548611 Mailto:adam.brejza@gedas.co.uk http://www.gedas.net ---------------------------------------------------<br><br><br><br><br><br>-----Original Message----- From: Steve Westfall [mailto:Steve.Westfall@EQUIFAX.COM] Sent: 29 April 2002 18:14 To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: UDB Journal<br><br><br><br>Adam,<br><br>I don't believe that the Journal has any facility for cancelling running jobs. [ Hint to IBM: this would be a nice future enhancement! ] [...]
7426 38 38_disaster recovery to another subsystem11_Adam Daniel16_dadam@GRATEX.COM31_Thu, 25 Apr 2002 15:40:45 +0200479_iso-8859-2 Hi, is it possible to create a db2 subsystem (clone) in the same LPAR using archive logs + image copies from the original db2 subsystem ? I'm using remote site disaster recovery procedure from DB2 manuals - Admin. Guide, ch. 4.7.17. (I skipped the ICF cat. export/import though.)<br><br>I set cond. restart control record (CRCR) to force db2 to discard anything with RBA > endrba of the latest archive log. When I try to start db2 in maint. mode I get following: [...]
7465 43 28_Re: 3390-3 Volume allocation13_Barb Milligan25_Barb_Milligan@CARGILL.COM31_Tue, 30 Apr 2002 07:11:09 -0500445_ISO-8859-1 Su,<br><br>This depends whether you use SMS or not. With SMS, new storage will just go to another disk in the pool. It is not SMS, your job may just abend. It will not overwrite storage that is already in use.<br><br>Barb<br><br>-----Original Message----- From: LISTSERV@LISTSERV.YLASSOC.COM [mailto:LISTSERV@LISTSERV.YLASSOC.COM] Sent: Monday, April 29, 2002 2:19 PM Cc: subha_sivaji@YAHOO.COM Subject: 3390-3 Volume allocation [...]
7509 108 22_Re: Lost Update Method14_Zobjeck, A. J.18_Al_Zobjeck@TTX.COM31_Tue, 30 Apr 2002 07:50:58 -0500491_iso-8859-1 I would start an Omegamon trace and look at the results.<br><br>-----Original Message----- From: David Nance [mailto:DWNance@FHSC.COM] Sent: Monday, April 29, 2002 9:57 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Lost Update Method<br><br><br><br>Glenn, Are the program's SQL being run with cursor stability? What about using a cursor with "FOR UPDATE OF"? The other way to go is as someone mentioned earlier with selecting a timestamp, then update where timestamp = :HV. [...]
7618 129 22_Re: Lost Update Method13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Tue, 30 Apr 2002 07:58:07 -0500542_iso-8859-1 James,<br><br>Thanks for your reply. We are not losing any updates, we do not have a problem in that regard - the technique works perfectly. The reason for my question is that I have some developers, for whatever reason, who are skeptical of the method I am requesting that they use. They find it hard to believe that the database does not take care of the situation for them. So, in order to convince them of the need, I wanted to present them with an independent view how other sites handle the problem - hence the posting. [...]
7748 41 26_Re: PeopleSoft SQL Problem8_Carey Fu24_Carey_Fu@CA.CGUGROUP.COM31_Tue, 30 Apr 2002 09:10:26 -0400227_us-ascii Terry,<br><br>Do you have parallel processing turned on? If so, try SET CURRENT DEGREE = '1', and run your SQL again. That's all I can think of so far. Good luck!<br><br><br><br>Best regards, Carey Fu Tel: 416-288-2978
7790 145 22_Re: Lost Update Method14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 30 Apr 2002 14:22:08 +0100542_iso-8859-1 Slightly off-topic, but you might want to run the following past them<br><br>1. If you just SELECT the data, DB2 assumes all you are interested in is LOOKING AT IT. If you (the developer) subsequently decide to update, then that's your lookout<br><br>2. If you SELECT the data FOR UPDATE, then DB2 know you want to update the data later in the unit or work and can take U-locks accordingly. If you choose to update the data in ANOTHER unit of work, without reaffirming the data has not changed, then that's also your problem. [...]
7936 152 22_Re: Lost Update Method16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 30 Apr 2002 09:23:39 -0400442_iso-8859-1 Glenn, Are your developers unable to read and understand the excellent manuals supplied with DB2? If so, perhaps an alternate carrer path (food service, marketing, management, ....) is in order.<br><br>Regards, eric pearson<br><br><br><br><br><br>-----Original Message----- From: Mackey, Glenn [mailto:GMackey@GUIDEMAIL.COM] Sent: Tuesday, April 30, 2002 8:58 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Lost Update Method [...]
8089 46 44_Re: ADO Update with DateTime columns-Sovled!15_Shields Michael28_ShieldsMichael@JOHNDEERE.COM31_Tue, 30 Apr 2002 08:29:36 -0500291_iso-8859-1 FYI... timestamp is only 10 bytes, your char(26) is 26 bytes so you'll be adding length to each record. If you're updating the record to the current time of the update (as in most cases) you can just use CURRENT_TIMESTAMP as the value. Just another idea to throw in the mix. [...]
8136 94 26_Re: PeopleSoft SQL Problem15_Zimmerman Terry35_Terry.Zimmerman@GENERALCASUALTY.COM31_Tue, 30 Apr 2002 08:44:21 -0500496_iso-8859-1 Carey,<br><br>Thanks for your help. IBM sent us a APAR yesterday to fix our incorrect output problem. We are now getting the correct output.<br><br>Terry<br><br>APAR PQ56103 INCORRECT OUTPUT, WHEN USING HYBRID JOIN (ZPARM SPRMNHJM), RUNNING A SELECT THAT CONTAINS A CONCAT PREDICATE.<br><br><br><br>-----Original Message----- From: Carey Fu [mailto:Carey_Fu@CA.CGUGROUP.COM] Sent: Tuesday, April 30, 2002 8:10 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: PeopleSoft SQL Problem [...]
8231 58 42_Re: disaster recovery to another subsystem10_Ali OZTURK27_Ali.OZTURK@PAMUKBANK.COM.TR31_Tue, 30 Apr 2002 17:57:58 +0300608_iso-8859-2 Hi Adam, Did you create active log datasets and register into the BSDS ?<br><br>Regards. Ali<br><br><br><br>-----Original Message----- From: Adam Daniel [mailto:dadam@GRATEX.COM] Sent: Thursday, April 25, 2002 4:41 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: disaster recovery to another subsystem<br><br><br><br>Hi, is it possible to create a db2 subsystem (clone) in the same LPAR using archive logs + image copies from the original db2 subsystem ? I'm using remote site disaster recovery procedure from DB2 manuals - Admin. Guide, ch. 4.7.17. (I skipped the ICF cat. export/import though.) [...]
8290 18 22_Resetting VSAM Extents7_Su Arun22_subha_sivaji@YAHOO.COM31_Tue, 30 Apr 2002 09:58:56 -0500285_- Hi Listers,<br><br>In my test databse , OS390 ( 3390-3) I have VSAM - DB2 datasets ( user definded VCAT ) showing 110 ext . Is there any tools or process to make them 1 (one) in the palce of 110. I do see there is limit for this number of extents. Any thoughts will be helpful. [...]
8309 70 30_MF DB2 SP Performance Question11_Chuck Kosin24_chuck.kosin@EXPERIAN.COM31_Tue, 30 Apr 2002 10:22:46 -0500403_ISO-8859-1 During our MF DB2 SP performance tests, some of the internal SPAS load modules are using a heck of a lot of CPU time. Is this the way it is supposed to work? Any hints or tips are much appreciated.<br><br>Here is some more detail. From a UNIX WebLogic instance, 1 to 10 SP CALLs per second are sent to a MF V6 DB2 Data Sharing Member. During these tests, we have observed the following: [...]
8380 71 36_Re: Trigger calling stored procedure14_Peter Backlund21_pbacklu@ATTGLOBAL.NET31_Tue, 30 Apr 2002 17:32:16 +0200
8452 53 26_Re: Resetting VSAM Extents16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 30 Apr 2002 11:34:05 -0400362_iso-8859-1 A fairly simple way: IDCAMS DEFINE another dataset with the same attributes but with sufficient primary space allocation to contain all 100 extents. Then -STOP the object. DSN1COPY the object dataset into the new dataset. IDCAMS DELETE the object dataset. IDCAMS ALTER .... NEWNAME to rename the new datast to the old dataset. -START the object. [...]
8506 42 26_Re: Resetting VSAM Extents25_Smock, Dale, BmS - NMI-PM20_Dale.Smock@BMSUS.COM31_Tue, 30 Apr 2002 10:39:59 -0500343_iso-8859-1 DFDSS and FDR or similar utilities will move DB2 datasets to another volume with available space in 1 extent. The dataset must be closed (stop object in DB2) and specify by the cluster name.<br><br>Another method is DSN1COPY and Reorg, after altering the primary quantity to the required allocation size.<br><br>Dale Smock BMG [...]
8549 225 34_Re: Debugging SQL Stored Procedure15_Russell Collins21_russell@ECTAUSTIN.COM31_Tue, 30 Apr 2002 11:03:54 -0700619_iso-8859-1 The easiest way that I can think of to do this is to use DB2 Stored Procedure Builder. You can build, write, run, test, and bind your Stored Procedure without having to develop separate jobs for testing.<br><br>Russell Collins Database Development Director IBM DB2 Certified Specialist eCommerce Technology Austin www.ectaustin.com<br><br>mailto:russell@ectaustin.com<br><br><br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Rajesh Parab Sent: Monday, April 29, 2002 3:58 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Debugging SQL Stored Procedure [...]
8775 136 36_Re: Trigger calling stored procedure15_Saffer, Michele26_Michele.Saffer@ACS-INC.COM31_Tue, 30 Apr 2002 11:46:52 -0400706_iso-8859-1 I didn't get an error, it just did the delete even when it shouldn't have. Did you try a delete after you created the trigger?<br><br>Thanks, Michele<br><br>-----Original Message----- From: Peter Backlund [mailto:pbacklu@ATTGLOBAL.NET] Sent: Tuesday, April 30, 2002 11:32 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Trigger calling stored procedure<br><br><br><br><html> <head> </head> <body> Michele,<br> <br> I just visited one of my clients and tested the following SQL in DB2 for OS/390, both V6 and V7<br> <br> <tt>create table saffer(c integer);<br> <br> create trigger saffer<br> no cascade before delete on saffer<br> referencing old as o<br> for each row mode db2sql<br> when ( [...]
8912 15 42_Re: disaster recovery to another subsystem11_Daniel Adam16_dadam@GRATEX.COM31_Tue, 30 Apr 2002 10:50:56 -0500486_- Hi, in case anyone comes across the same problem - the archive log was copied and registered in the bsds, but it had different blocksize than the original archive log - I did not set the blocksize when I copied it... Bye, Daniel<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
8928 21 34_Re: Debugging SQL Stored Procedure12_Rajesh Parab22_Rajesh.Parab@TELUS.COM31_Tue, 30 Apr 2002 10:32:47 -0600401_iso-8859-1 Thanks Russell for your reply. We are looking at building a log file or log table which provides all the information about successful or failed SQL. Only thing I can log from exception handler is SQLCODE/SQLSTATE. But that won't provide me with required information like failed SQL and data used for that SQL. Is there any way we can extract this information inside exception handler. [...]
8950 126 15_SQL Performance11_Pawan Reddy24_pawan_kalyan75@YAHOO.COM31_Tue, 30 Apr 2002 09:42:33 -0700766_us-ascii <br><br>I have the following SQL which is running for about 25 min. Can anybody help me in tuning this SQL? I am running under OS/390 SELECT C.CUST_ID , O.ORDER_BR , O.ORDER_ID , I.TRANS_DT , I.TRANS_TIME , C.NAME , I.ORDER_QTY_1 , I.ORDER_QTY_2 , I.ORDER_QTY_3 , I.ORDER_QTY_4 , I.ORDER_QTY_5 , I.ORDER_QTY_6 , I.ORDER_QTY_7 , I.ORDER_QTY_8 , I.ORDER_QTY_9 , I.ORDER_QTY_10 , I.ORDER_QTY_11 , I.ORDER_QTY_12 , I.ORDER_QTY_13 , I.ORDER_QTY_14 , I.ORDER_QTY_15 , I.ORDER_QTY_16 , O.CUST_PO_NUMBER , O.HEAD_ERROR_MSG , O.HEAD_PROCESS_SW , O.ORDER_LINE_NBR_1 , O.PART_DESC_1 , O.UPC_CD_1 , O.ERROR_SW_1 , O.LINE_ERROR_MSG_1 , O.ORDER_LINE_NBR_2 , O.PART_DESC_2 , O.UPC_CD_2 , O.ERROR_SW_2 , O.LINE_ERROR_MSG_2 FROM B1.P2PI_KIT_ORDER I , B1.P2PO_KIT_ORDER [...]
9077 31 26_Re: PeopleSoft SQL Problem14_Zobjeck, A. J.18_Al_Zobjeck@TTX.COM31_Tue, 30 Apr 2002 11:44:24 -0500469_iso-8859-1 Why the "SET"? Why doesn't it work with parallel processing turned on?<br><br>-----Original Message----- From: Carey Fu [mailto:Carey_Fu@CA.CGUGROUP.COM] Sent: Tuesday, April 30, 2002 8:10 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: PeopleSoft SQL Problem<br><br><br><br><br><br><br><br>Terry,<br><br>Do you have parallel processing turned on? If so, try SET CURRENT DEGREE = '1', and run your SQL again. That's all I can think of so far. Good luck! [...]
9109 67 26_Re: Resetting VSAM Extents14_Harvey Puckett19_hpuckett@GTA.GA.GOV31_Tue, 30 Apr 2002 12:45:44 -0400602_us-ascii Quick way is ADRDSSU as follows (with object STOPped):<br><br>//STEP1 EXEC PGM=ADRDSSU,REGION=4096K % ,PARM='TYPRUN=SCAN' //* //SYSPRINT DD SYSOUT=* //SYSPRINT DD DSN=SGDS.HARV.EXEC.SYSPRINT, // DISP=(,CATLG,KEEP), // UNIT=SYSDA, // SPACE=(TRK,(15,15),RLSE), // RECFM=FBA, // LRECL=133 //INDD DD VOL=SER=DBT401,UNIT=3390,DISP=SHR //OUTDD DD VOL=SER=DBT402,UNIT=3390,DISP=SHR //SYSIN DD * COPY DATASET( - INCLUDE( - HRCSDBT3.DSNDBD.DBEUT001.TSEUT001.** - )) - DELETE - OUTDD(OUTDD) - SELECTMULTI(ANY) - LOGINDDNAME(INDD) - PURGE - RECATALOG(*) - ALLDATA(*) - TGTALLOC(SRC) - WAIT(0,0) //* [...]
9177 113 46_Disaster recovery - recovery of sysutilx fails11_Daniel Adam16_dadam@GRATEX.COM31_Tue, 30 Apr 2002 11:35:59 -0500553_- Hello, This is DB2 v7r1 on OS/390 v2r10. During the disaster recovery of the whole db2 subsystem I receive an error when recovering the tablespace dsndb01.sysutilx. This is supposed to be the first tablespace to recover according the DB2 Administration Guide, ch. 4.7.17. Yet the DB2 during the recovery of SYSUTILX expects DBD01 to be present. But DBD01 will only be recovered after SYSUTILX and its indexes are recovered !!! The exact error message is: DSNT500I DSNUGBAC - RESOURCE UNAVAILABLE REASON 00C90094 TYPE 00000200 NAME DSNDB01 .DBD01 [...]
9291 23 23_DB2 Connect alias error9_Don Cross20_Don.Cross@TC.FAA.GOV31_Tue, 30 Apr 2002 12:49:20 -0400405_us-ascii We are running DB2 v6 on os390v2.9. There is a network of 5 users who wish to connect to our server thru ODBC.<br><br>One connection is defined and all users use it to communicate with DB2.<br><br>When a network user tries to add a new alias but connect to the same server(ip address) the user gets SQL1317N ' The local database already exists in the Database Connection Services directory. [...]
9315 91 13_Re: Traces???14_Steve Westfall26_Steve.Westfall@EQUIFAX.COM31_Tue, 30 Apr 2002 11:55:34 -0500574_us-ascii Mark,<br><br>Personally, I think you're getting a little ahead of yourself. You can learn how to take a trace by reading the description of "db2trc" in the Command Reference manual. But as the Command Reference indicates, normally a trace is only taken when IBM Support requests it, and you format the output and send it to them for analysis. I suggest that first you follow up on the error messages that you are receiving when you try to stop DB2. What are the specific error messages, and have you looked them up in the Messages Reference manual to see what [...]
9407 140 50_Re: Disaster recovery - recovery of sysutilx fails14_Harvey Puckett19_hpuckett@GTA.GA.GOV31_Tue, 30 Apr 2002 13:08:45 -0400420_us-ascii SYSUTILX must be recovered in its own jobstep ... as must DBD01 ... the others you may gang up ...<br><br>Your order is fine ... are you in ACCESS(MAINT)? Are you install sysadm? Looks like you are ...<br><br>-----Original Message----- From: Daniel Adam [mailto:dadam@GRATEX.COM] Sent: Tuesday, April 30, 2002 12:36 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Disaster recovery - recovery of sysutilx fails [...]
9548 196 15_Re: UDB Journal14_MIKE FRIEDRICH27_RDBA002@REVENUE.STATE.IL.US31_Tue, 30 Apr 2002 12:20:38 -0500345_US-ASCII Hope this helps. There may be more available in the DB2 Product & Service Technical Library.<br><br>It was a problem in DB2 UDB (NT) Version 6 and I haven't seen it happen in Version 7. The following is from the DB2 Product & Service Technical Library.<br><br>DB2 DAS - Journal Job Information Problems (Pending, Running, History) [...]
9745 31 27_Re: DB2 Connect alias error13_Shauna Hadden24_shauna.hadden@BCBSKS.COM31_Tue, 30 Apr 2002 12:19:02 -0500334_- Are they using Client Configuration Assistant? I have seen this same error message using DB2 Connect Version PE V7 to connect to OS/390 DB2 V6. I found that if you use the line commands, you don't get this error....only when using CCA.<br><br><br><br>On Tue, 30 Apr 2002 12:49:20 -0400, Don Cross <Don.Cross@TC.FAA.GOV> wrote: [...]
9777 142 50_Re: Disaster recovery - recovery of sysutilx fails13_Pothoff, Bill20_Bill_Pothoff@BMC.COM31_Tue, 30 Apr 2002 12:25:43 -0500507_iso-8859-1 Daniel,<br><br>Here are a couple of apars that you might find useful:<br><br>PQ55551 - Applies to DB2 V6 & V7 PQ50757 - Applies to DB2 V6, and offers a workaround to circumvent a similar problem.<br><br>Hope that helps!<br><br>Bill Pothoff BMC Technical Support Recovery Manager for DB2<br><br>-----Original Message----- From: Daniel Adam [mailto:dadam@GRATEX.COM] Sent: Tuesday, April 30, 2002 11:36 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Disaster recovery - recovery of sysutilx fails [...]
9920 102 22_Re: Lost Update Method12_Isaac Yassin20_yassini@BEZEQINT.NET31_Tue, 30 Apr 2002 20:48:40 +0200383_us-ascii Hi, On top of all other answers - I once encountered an application that always kept all columns of the row and used them In the "where" part of the update command (works even in pseudo-conversational) . Performance wise it's not recommended, but very easy to implement .... I prefer the counter/timestamp method - one field is enough . Trigger is too costly for that. [...]
10023 12 26_Re: Resetting VSAM Extents14_Harvey Puckett19_hpuckett@GTA.GA.GOV31_Tue, 30 Apr 2002 12:42:51 -0500349_- OOOOOOOPs ... must be the cluster ... change DSNDBD to DSNDBC ...<br><br>sia jai duey cuhp!<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
10036 57 20_Re: Cost per insert?10_Mark Labby21_mlabby@AESSUCCESS.ORG31_Tue, 30 Apr 2002 14:03:40 -0400470_us-ascii Thanks Max, I found the papers and am reviewing them now.<br><br><br><br><br><br><br><br>Max Scarpa <mscarpa@CESVE.I To: DB2-L@LISTSERV.YLASSOC.COM T> cc: Sent by: DB2 Subject: Re: Cost per insert? Data Base Discussion List <DB2-L@RYCI.COM><br><br><br><br>04/30/02 03:23 AM Please respond to DB2 Data Base Discussion List<br><br><br><br><br><br><br><br><br><br><br><br>Hi<br><br>There are 2 recent Shibamiya's papers about insert performance (July 2000) : [...]
10094 82 34_Re: Problem with a query on OS/3900_24_db46@DAIMLERCHRYSLER.COM31_Tue, 30 Apr 2002 14:05:44 -0400483_us-ascii Basically, you cannot group by the result from a column function on OS/390<br><br>Use a nested table to get your results><br><br>SELECT COUNT (MSG_ID) FROM (SELECT HOUR (TIM_STP) AS THE_HOUR , MSG_ID FROM MSG_LOG) AS T1 GROUP BY THE_HOUR<br><br>Dean<br><br><br><br><br><br><br><br>Sachin Girish Kumar <sachin.girishkumar@ORBI To: DB2-L@LISTSERV.YLASSOC.COM TECH.CO.IN> cc: Sent by: DB2 Data Base Subject: Problem with a query on OS/390 Discussion List <DB2-L@RYCI.COM> [...]
10177 129 13_Re: Traces???23_Baskerville, Mark {PBG}26_mark.baskerville@PEPSI.COM31_Tue, 30 Apr 2002 14:13:13 -0400358_iso-8859-1 Mark,<br><br>We ran into the same problem. The offline backup requires that the user running the backup get an exclusive connect to the database. You do not want to actually stop db2, but there cannot be any applications connected to the database when the backup command is issued. We run a backup script that issues the following commands : [...]
10307 101 22_Re: Lost Update Method0_19_Tim.Lowe@STPAUL.COM31_Tue, 30 Apr 2002 13:13:13 -0500483_us-ascii Glenn, While the title does not exactly match your question, I think it might be a good idea for you to look at the following IBM white paper. It does discuss the topic in question extensively.<br><br>Optimistic Locking in IBM Websphere Application Server 4.0.2.<br><br>http://www7b.software.ibm.com/wsdd/library/summaries/24626755.html<br><br><br><br>I hope this helps.<br><br>Thanks, Tim Lowe IBM Certified Solution Expert DB2 V7.1 Database Administration for OS/390 [...]
10409 129 50_Re: Disaster recovery - recovery of sysutilx fails14_Picou, Michael33_picou.michael@MAIL.DC.STATE.FL.US31_Tue, 30 Apr 2002 14:16:30 -0400702_- Did you delete/redefine all the DSNDB01 & DSNDB06 tablespaces?<br><br>-----Original Message----- From: Daniel Adam [mailto:dadam@GRATEX.COM] Sent: Tuesday, April 30, 2002 12:36 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Disaster recovery - recovery of sysutilx fails<br><br><br><br>Hello, This is DB2 v7r1 on OS/390 v2r10. During the disaster recovery of the whole db2 subsystem I receive an error when recovering the tablespace dsndb01.sysutilx. This is supposed to be the first tablespace to recover according the DB2 Administration Guide, ch. 4.7.17. Yet the DB2 during the recovery of SYSUTILX expects DBD01 to be present. But DBD01 will only be recovered after SYSUTILX and its indexes are [...]
10539 37 18_INSERT Performance4_Anil18_usregion10@AOL.COM31_Tue, 30 Apr 2002 13:11:55 -0500461_- Hi All!<br><br>I am tuning a data conversion program. It's a one time deal. I say that because I have some leeway in doing things on a one time basis. The program does massive inserts (i think about 105 million inserts). The insert statements are generated using a sequential file. My thoughts on making it run faster are 1. Alter tablespace PCTFREE = 0 and FREEPAGE = 0 2. DROP INDEX 3. RUN MULTIPLE JOBS (split the input file into several small files) [...]
10577 157 50_Re: Disaster recovery - recovery of sysutilx fails0_20_John_Lendman@FPL.COM31_Tue, 30 Apr 2002 14:30:56 -0400419_us-ascii The key here is what some one said. YOU MUST DO SYSUTLX IN IS OWN STEP. If not you will receive the error you got.<br><br><br><br>John C. Lendman DBA Jlendman@fpl.com (561) 694-5085 Beeper FPL 7413<br><br><br><br><br><br>"Daniel Adam" <dadam@GRATEX To: DB2-L@LISTSERV.YLASSOC.COM .COM> cc: Sent by: "DB2 Subject: Disaster recovery - recovery of Data Base sysutilx fails Discussion List" <DB2-L@RYCI.C OM> [...]
10735 131 29_Re: AIX UDB EE V7.2 code base13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Tue, 30 Apr 2002 13:31:25 -0500371_iso-8859-1 V7.1 FP3 is 2 APARS higher than v7.2. With the exception of those 2 APARS, the code is identical. That is why db2level shows v7.1 fp3 as higher than 7.2 (7.1.0.41 versus 7.1.0.40).<br><br>Beginning with V7.1 FP4, the v7.1 and v7.2 code is identical (i.e. v7.1 FP4/v7.2 FP4, and v7.1 FP5/V7.2 FP5 are exactly the same, a db2level will show the same info). [...]
10867 57 22_Re: INSERT Performance14_Toppins, Smike21_smike.toppins@GWL.COM31_Tue, 30 Apr 2002 12:45:25 -0600669_- Why not use LOAD RESUME since the data is in a sequential file already?<br><br>SMike Toppins Great-West Life topp@gwl.com<br><br><br><br>-----Original Message----- From: Anil [mailto:usregion10@aol.com] Sent: Tuesday, April 30, 2002 12:12 PM To: DB2-L@listserv.ylassoc.com Subject: INSERT Performance<br><br>Hi All!<br><br>I am tuning a data conversion program. It's a one time deal. I say that because I have some leeway in doing things on a one time basis. The program does massive inserts (i think about 105 million inserts). The insert statements are generated using a sequential file. My thoughts on making it run faster are 1. Alter tablespace PCTFREE = 0 [...]
10925 46 33_syntax question on CASE statement10_Shery Hepp17_schepp@SRPNET.COM31_Tue, 30 Apr 2002 11:46:02 -0700302_iso-8859-1 I have a case statement that I've tested- it works- but now I need to modify it to add additional conditions- and I'm having a hard time with the syntax. Does anyone know of any good examples available online I could reference? ( I searched the archives and didn't find a good example) [...]
10972 122 19_Re: SQL Performance14_Bernd Oppolzer26_Bernd.Oppolzer@T-ONLINE.DE31_Tue, 30 Apr 2002 20:45:04 +0200484_- Hello,<br><br>first of all, I would change the non correlated subquery into a correlated one.<br><br>AND O.CUST_PO_NUMBER NOT IN (SELECT X.CUST_PO_NUMBER FROM B1.P2PO_KIT_ORDER X WHERE X.HEAD_PROCESS_SW <> 'E' AND X.ORDER_ID <> ' ')<br><br>In my opinion, DB2 has to execute the subquery first, write the result to disk, do the duplicate elimination. I have no idea, how big the result of this subquery can be. But there is no index on the temp object that DB2 can use (afaik). [...]
11095 174 13_Re: Traces???14_Steve Westfall26_Steve.Westfall@EQUIFAX.COM31_Tue, 30 Apr 2002 13:59:27 -0500580_us-ascii Mark Maziarczyk, can you clarify what kind of backup you are trying to make? Do you want a DB2 database backup using the DB2 "backup database" command? Or do you want a file-level backup, outside of DB2, using AIX facilities? I concluded from the fact that you are trying to stop DB2 that you want the DB2 instance shut down so that you can do file system backups at the operating system level. If, however, you are trying to use the "BACKUP DATABASE" command, Mark Baskerville's comments are what you want. "BACKUP DATABASE" defaults to an offline backup. Sorry if [...]
11270 16 22_Re: INSERT Performance4_Anil18_usregion10@AOL.COM31_Tue, 30 Apr 2002 14:02:30 -0500534_- Point of Clarification: I have already examined the process to see if LOAD can be used. But because of the nature of application, we will have to live with INSERTS. Which means now my mission is to optimize insert performance and not determine if LOAD can be used.<br><br>Anil<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
11287 70 37_Re: syntax question on CASE statement14_Bernd Oppolzer26_Bernd.Oppolzer@T-ONLINE.DE31_Tue, 30 Apr 2002 21:09:09 +0200310_- Hello,<br><br>I don't understand why your solution shouldn't work. In my opinion, it's all correct. The only errors I can imagine are<br><br>- ctoc exists in A and in B, so you would have to specify a.ctoc or b.ctoc - ctoc numeric, not char, then 100 without '' would be ok - ctoc not in A and not in B [...]
11358 85 29_Referential Integrity problem17_Alessandro Brezzi24_alessandro.brezzi@TIN.IT31_Tue, 30 Apr 2002 21:21:45 +0200489_us-ascii Hi all, we have a little problem defining some referential integrity constraint in a DB2 v5.2 for OS/390; I made a simple DDL to clarify: there is a table TESTA (for clarity with only one attr. PKEY CHAR(4) NOT NULL, wich is PK) from wich depend a table TABLE B with a compound key PKEY + SKEY and a foreing key for TABLEA on PKEY, with the clause "ON DELETE RESTRICT". Then came TABLE C with a foreingn key to TABLEB, "ON DELETE CASCADE". Last, I try to create table TESTD: [...]
11444 97 37_Re: syntax question on CASE statement10_Shery Hepp17_schepp@SRPNET.COM31_Tue, 30 Apr 2002 12:32:46 -0700502_iso-8859-1 Bernd- thank you! (your response and my short lunch break helped clear my head) I got it to work- I changed the order a bit to this-<br><br>, CASE WHEN (B.VW_LBR_F = 'Y' AND CTOC_NB = '100') THEN JV_CHRG_Q ELSE 0 END<br><br>And it works! Thanks for the fresh perspective-<br><br>Shery -----Original Message----- From: Bernd Oppolzer [mailto:Bernd.Oppolzer@T-ONLINE.DE] Sent: Tuesday, April 30, 2002 12:09 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: syntax question on CASE statement [...]
11542 208 13_Re: Traces???15_Mark Maziarczyk22_MMaziarczyk@SYMCOR.COM31_Tue, 30 Apr 2002 15:39:43 -0400310_us-ascii Well we do a database backup then we do a filesystem backup. We are using DB2 as the Database for IBM's Content Manager OnDemand product. We call a backall script through a cron job which shuts down all the services and does service level backups then we proceed to do the AIX filesystem backup. [...]
11751 54 46_Re: Problems with DB2 V7 maintenance (UQ59415)0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM31_Tue, 30 Apr 2002 14:41:32 -0500781_us-ascii We successfully installed in in December. Worked o.k. for us.<br><br><br><br><br><br><br><br><br><br>Sandra Lakenburger <sandra.lakenburger@MAI To: DB2-L@LISTSERV.YLASSOC.COM L.SPRINT.COM> cc: Subject: Problems with DB2 V7 maintenance (UQ59415) Sent by: DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br><br><br>04/29/2002 10:18 AM Please respond to DB2 Data Base Discussion List<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>Has anyone successfully installed ptf UQ59415 in a DB2 V7 SMP/E environment? I have tried twice and am getting a rc=08 in the linkedit of DSNRLI. I'm seeing a reference to the DSNACCOR load module that has not yet been installed as PQ48448/UQ60825 has error holds on it. I've got a pmr open with IBM and they're [...]
11806 29 20_Meta Data Repository14_Judy Woodfield13_judyw@CAE.COM31_Mon, 29 Apr 2002 13:52:07 -0400555_iso-8859-1 Dear Listers:<br><br>Can anyone give me some input related to metadata repositories. We need to use one here, but of course have no budget for one.<br><br>We use ERwin to do our data models, but in order to capture meta data in ERwin, we need to have everything modeled in ERwin. We have a huge IDMS production database (that will be going to DB2 eventually) and IDMS has some metadata within its data dictionary. We also use Versata, which has some limited metadata use. And of course we have many DB2 databases plus Oracle and MSAccess. [...]
11836 23 19_Metadata Repository14_Judy Woodfield13_judyw@CAE.COM31_Thu, 25 Apr 2002 11:34:18 -0400561_iso-8859-1 Dear Listers:<br><br>Can anyone give me some advice and tips on a strategy for a Metadata repository. We are extremely limited in budget, and we'd like to explore what options are available to us.<br><br>All information will be welcome.<br><br>Thanks in advance.<br><br>Judy Woodfield, CAE Inc.<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
11860 33 46_Re: Problems with DB2 V7 maintenance (UQ59415)13_Lockwood Lyon24_Lockwood.Lyon@MEIJER.COM31_Tue, 30 Apr 2002 16:11:34 -0400604_US-ASCII We successfully APPLY-ed UQ59415 in February to our V7 system. No problems.<br><br>I don't see anything in the HOLDDATA about having to Re-Link DSNRLI ... is that part of your process for some other PTF, or did I misread something?<br><br>- Lockwood Lyon Meijer Stores<br><br>>>>>>>>>>>>>>>>>> Has anyone successfully installed ptf UQ59415 in a DB2 V7 SMP/E environment? I have tried twice and am getting a rc=08 in the linkedit of DSNRLI. I'm seeing a reference to the DSNACCOR load module that has not yet been installed as PQ48448/UQ60825 has error holds on it. I've got a pmr open with [...]
11894 38 34_Re: Debugging SQL Stored Procedure15_Russell Collins21_russell@ECTAUSTIN.COM31_Tue, 30 Apr 2002 15:41:17 -0700377_iso-8859-1 I wouldn't know of any quick method to capture this. The only thing that I can think about is customizing you exception results.<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Rajesh Parab Sent: Tuesday, April 30, 2002 9:33 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Debugging SQL Stored Procedure [...]
11933 22 11_WEB ADDRESS16_Jeff A L'Italien25_jeff.a.l'italien@AEXP.COM31_Tue, 30 Apr 2002 13:46:26 -0700328_us-ascii To whom it may concern,<br><br>Can you tell me what the new web address is for the DB2-L discussion group? I have atttempted to use the address from my internet "favorites", but the entries within that address are only as recent as 4/24/02. Any help is appreciated.<br><br>Regards, Jeff L'Italien American Express [...]
11956 43 15_Re: WEB ADDRESS10_Bruce, Mae26_BruceM@MAIL.OA.STATE.MO.US31_Tue, 30 Apr 2002 15:45:42 -0500490_iso-8859-1 Here is the address for the list http://listserv.ylassoc.com and here is the address for the archives http://listserv.ylassoc.com/archives/db2-l.html<br><br>Mae Bruce OA/Division of Information Services Phone: (573) 522-2489 Fax: (573) 751-3229<br><br><br><br>-----Original Message----- From: Jeff A L'Italien [mailto:jeff.a.l'italien@AEXP.COM] Sent: Tuesday, April 30, 2002 3:46 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: WEB ADDRESS<br><br><br><br>To whom it may concern, [...]
12000 73 15_Re: WEB ADDRESS16_Jeff A L'Italien25_jeff.a.l'italien@AEXP.COM31_Tue, 30 Apr 2002 14:08:31 -0700468_us-ascii Thanks Mae,<br><br>For some reason when I use the Google search for this group, it brings up the old address which had moved as of this past week.<br><br>Regards, Jeff L'Italien American Express<br><br><br><br><br><br>From: "Bruce, Mae" <BruceM@MAIL.OA.STATE.MO.US>@RYCI.COM> on 04/30/2002 03:45 PM EST<br><br>Please respond to "DB2 Data Base Discussion List" <DB2-L@LISTSERV.YLASSOC.COM><br><br>Sent by: "DB2 Data Base Discussion List" <DB2-L@RYCI.COM> [...]
12074 140 19_Re: SQL Performance10_Missy Case28_Missy.Case@FIRSTDATACORP.COM31_Tue, 30 Apr 2002 16:19:44 -0500375_us-ascii The first thing I spotted was the difference in the lengths of your subsrtings....That'll cost you (BIG TIME)<br><br><br><br>AND SUBSTR(I.BRANCH,2,4) = SUBSTR(C.PNT_TO_PNT_BRANCH,1,4)<br><br><br><br>Also, you could/should probably create more indexes to support this query if it's going to run often. Build for cardinality, and = leave the >, < and ^= to last. [...]
12215 73 22_Re: INSERT Performance11_Robert Jans26_robert.jans@ALBERTSONS.COM31_Tue, 30 Apr 2002 15:38:08 -0600369_- Anil, a couple of thoughts.<br><br>1. Calculate reasonable sizes for the partitions (or table space if not partitioned) and indexes. Alter the PRIQTY and SECQTY, then perform a reorg on the empty objects using the PREFORMAT option (DB2 V6.1 Utility Guide and Reference page 299). This means DB2 will not have to wait to format pages as you're doing the inserts. [...]
12289 82 67_Posted as a courtesy to IDUG:IDUG NA 2002 May 12 -16, San Diego, Ca12_Phil Gunning28_pgunning@BREAKTHROUGHDB2.COM31_Tue, 30 Apr 2002 17:45:57 -0400476_- The International DB2 User Group (IDUG) invites you attend IDUG 2002 ? North America, May 12 - 16 at the San Diego Marriott Hotel & Marina. This conference, the organizations flagship event, is the leading user-run conference dedicated exclusively to users of IBMs DB2 Universal Database (DB2 UDB). Advance registration is available through May 6 at www.idug.org/naconf/2002/reg_2002sd.cfm. Detailed event information can be found on the IDUG Web site at www.idug.org. [...]
12372 60 40_Re: OMVS-mounted DB2 for OS/390 Datasets12_Raymond Bell17_rbell@NZ1.IBM.COM30_Wed, 1 May 2002 10:02:02 +1200367_us-ascii Hi Max,<br><br>Found a coupla papers from Peggy at www.idug.org (after going to an unrelated Korean site - www.idug.com - first) but couldn't see anything specifically on the directory structure. But it was interesting, describing a mini application developed using all sorts of whizz-bang PC-based tools and accessing DB2 on OS/390. Interesting stuff. [...]
12433 192 22_Re: Lost Update Method12_Raymond Bell17_rbell@NZ1.IBM.COM30_Wed, 1 May 2002 10:31:11 +1200475_us-ascii Bit hard on the food service industry, aren't you Eric? I've had some good service from 'the Scottish restaurant' over the years...<br><br><br><br>Raymond PS. Would you like fries with that?<br><br><br><br><br><br>"Pearson, Eric L," To: DB2-L@LISTSERV.YLASSOC.COM <Eric.Pearson@NSC cc: ORP.COM> Subject: Re: Lost Update Method Sent by: DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br><br><br>01/05/02 01:23 Please respond to DB2 Data Base Discussion List [...]
12626 24 55_Re: DB2 v4.1 compatibility with OS/390 release 2.10 ???12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 30 Apr 2002 17:19:43 -0500493_- So if anything goes wrong, and these people need help, who can they call? If they need service, do they expect to pay an hourly rate? get what they don't pay for? purchase a bridge? If they expect PTFs, that will be expensive.<br><br>My guess is that changing the environment adds to their risks. If they try to run old software in the UNIX or Windows environments, they'll probably find that they will be paying much more, because the standard support tends to be a year or 18 months. [...]
12651 16 20_Re: Cost per insert?12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 30 Apr 2002 17:37:03 -0500336_- The rules of thumb continue to change, but not as quickly as before. There is a good capacity planning Redbook, SG24-2244 that outlines the various methods. There is also the DB2 Estimator, noted in that book, which costs a download. For the next lesson, Shibamiya-san will be teaching DB2 capacity planning at IDUG May 12 - 16. [...]
12668 164 19_Re: SQL Performance13_Kavita Mittal16_kavitam@ZOWI.COM31_Tue, 30 Apr 2002 16:02:21 -0700494_iso-8859-1 hi Missy, I'm not sure what the last statement means. Could you explain please?<br><br>>Build for cardinality, and = leave the >, < and ^= to last.<br><br>thx kavita<br><br>-----Original Message----- From: Missy Case [mailto:Missy.Case@FIRSTDATACORP.COM] Sent: Tuesday, April 30, 2002 2:20 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: SQL Performance<br><br><br><br>The first thing I spotted was the difference in the lengths of your subsrtings....That'll cost you (BIG TIME) [...]
12833 189 19_Re: SQL Performance11_Pawan Reddy24_pawan_kalyan75@YAHOO.COM31_Tue, 30 Apr 2002 16:11:52 -0700386_us-ascii <br><br>Thanks all for your responses, here my Explain statement looks like QueryLockNo Planno Method Tname TabNo AccessType MatchCols AccessName IndexOnly 7 1 0 Bossct2 12 I 2 BctrlI4 Y 7 2 3 0 0 N 7 3 3 0 0 N 6 1 0 Bossct2 11 I 2 Bctrl4 Y 6 2 3 0 0 N 6 3 3 0 0 N 4 1 0 pt2ptin 10 R 0 N 4 2 4 pt2ptout 6 I 1 pt2pt01 N 4 3 3 0 0 N 3 1 0 Bossct2 5 N 1 BCtrl1 N 2 1 0 4 N 1 [...]
13023 118 22_Re: Lost Update Method12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 30 Apr 2002 18:09:33 -0500584_- I have a small point, Rob. There are cpu costs in updating the entire row, but DB2 avoids the log volume issues and does not do index updates for columns that are not really updated.<br><br>Roger Miller<br><br>On Mon, 29 Apr 2002 23:18:24 -0600, Rob Crane <racrane@CONCENTRIC.NET> wrote:<br><br>>WEB based applications tied to OO languages tend to use a BLACK BOX >approach which select an entire row and update an entire row only if one >column of that row has changed which adds to what DB2 has to log along >with the other concerns you have with update statements occurring [...]
13142 170 39_Re: Questions about new DB2 Sub-Systems13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Tue, 30 Apr 2002 16:17:49 -0700485_iso-8859-1 Be sure to check with your systems programmer before choosing to create dataset aliases. Some hate them, some hate them with a passion, and some just love them so much they create thousands of them. I'm sure there are many people using them responsibly, but they need to be clearly documented and consistently used. Personally, I use real datasets, unique to each subsystem, and when I need to perform maintenance I zero out the directory and copy in the new contents. [...]
13313 49 36_Re: [Note From YL&A Regarding DB2-L]12_GENE TILELLI16_geetee52@USA.NET31_Sun, 28 Apr 2002 18:43:29 -0400550_ISO-8859-1 Hi Paul -<br><br>Can you send a status email to the folks on the list giving us a current update?<br><br>Thanks.<br><br>Gene Tilelli Coral Springs, FL<br><br><br><br>Paul Riker <paul_riker@YLASSOC.COM> wrote: > --------------------------------------------- > Attachment: > MIME Type: multipart/alternative > --------------------------------------------- Dear DB2-L Listers,<br><br>We did complete the switch successfully last night and were back up and running. But as you have noticed, the list is not available, nor is our website. [...]
13363 59 22_Re: Lost Update Method12_Raymond Bell17_rbell@NZ1.IBM.COM30_Wed, 1 May 2002 12:12:18 +1200581_us-ascii Hi Roger,<br><br>Interesting comment. I've a follow-on question for you. I understand from the last half of your sentence that DB2 is smart enough not to try to update index entries for rows whose key values haven't changed - cool. But the bit about 'avoids the log volume' puzzles me, and it may just be my interpretation. Are you saying DB2 avoids the logging issue BECAUSE it doesn't do any non-essential index updates (which, presumably, are otherwise logged - I guess so, as you can image copy indexes and do PIT recoveries of them) or because DB2 only logs the [...]
13423 99 33_Re: Referential Integrity problem14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Wed, 1 May 2002 11:02:25 +1000556_US-ASCII Alessandro<br><br>The second explanation for a -632 (in the V6 M+C) clearly covers this. Or did you mistype the name of the child table in the second ALTER?<br><br>James Campbell<br><br>On 30 Apr 2002 at 21:21, Alessandro Brezzi wrote:<br><br>> Hi all, > we have a little problem defining some referential integrity constraint in > a DB2 v5.2 for OS/390; I made a simple DDL to clarify: > there is a table TESTA (for clarity with only one attr. PKEY CHAR(4) NOT > NULL, wich is PK) from wich depend a table TABLE B with a compound key PKEY > [...]
13523 88 22_Re: Lost Update Method13_Steve Tennant28_steve.tennant@CUSTOMS.GOV.AU30_Wed, 1 May 2002 11:04:40 +1000352_iso-8859-1 Hi Raymond, I'm not sure if this really answers your questions to Roger but.....from test I did way back in V4 if you update a column with the same value it already has then it isn't logged. My guess is because the logged data is from the first byte changed to the end of the row. As there are no changed bytes there is nothing to log. [...]
13612 240 19_Re: SQL Performance31_=?iso-8859-1?q?Sanjeev=20....?=24_sanjeev_db2l@YAHOO.CO.IN30_Wed, 1 May 2002 03:49:25 +0100577_iso-8859-1 Pawan,<br><br>I think this query should take 25 minutes. Its joining on SUBSTR and EXPLAIN shows lots of table scan. Follow some of these general purpose rules (whichever apply):-<br><br>1) Change non-correlated subquery to some effective methods if size of the inner table is large. The effective method could be join or correlated subquery. Looks like table BOSSCTRL_DAY is small and have one row only but table P2PO_KIT_ORDER may be a trouble. Even if BOSSCTRL_DAY is having 1 row, why not SELECT it before this query and make this query little bit simpler. [...]
13853 84 22_Re: INSERT Performance31_=?iso-8859-1?q?Sanjeev=20....?=24_sanjeev_db2l@YAHOO.CO.IN30_Wed, 1 May 2002 03:57:14 +0100527_iso-8859-1 Looks like best approach if LOAD is not possible is to have the tablespace partitioned. The file can be splitted into multiple files dependingon the sorted values which will be partitioning key and multiple instances of the program should be able to insert it into the different partitions.<br><br>I am not sure what are you trying to achieve by ALTERing the table with PCTFREE and FREEPAGE as zero without really doing the REORG. If you can explain little bit more specific, i should be able to get something. [...]
13938 22 11_unsubscribe8_sncmonty18_sncmonty@YAHOO.COM31_Tue, 30 Apr 2002 21:34:47 -0700547_us-ascii ===== "This is the day the Lord has made. I will rejoice in it and be glad. Amen."<br><br><br><br>Stella N. Chibundu sncmonty@yahoo.com<br><br>__________________________________________________ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.