1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l October 2003, week 5
2 33 10_banner_add12_Phil Gunning20_pgunning@COMCAST.NET31_Thu, 30 Oct 2003 14:16:56 -050011_iso-8859-1
36 27 11_PIT Recover0_20_ravi.reddy@PS.GE.COM31_Thu, 30 Oct 2003 13:08:05 -0500429_ISO-8859-1 Hi List,
Question on PIT Recovery for DB2 V6 OS/390.
I need to recover a database to yesterday 1400 hrs due to some application team inserting bad data.
My understanding is for PIT recover we need to find the start RBA using DSN1LOGP and then to recover using TORBA.
What is procedure to find out the RBA in the DSN1LOGP output for a certain point of time to which i want to recover ? [...]
64 14 56_Shan Leatherman/MO/americancentury is out of the office.0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM31_Thu, 30 Oct 2003 13:32:02 -0600182_US-ASCII I will be out of the office starting 10/30/2003 and will not return until 10/31/2003.
If you need additional assistance, send a message to *DB.
Shan Leatherman
79 23 33_UNSUBSCRIBE Request not Fulfilled11_Scott Barry19_sbarry@SBBWORKS.COM31_Thu, 30 Oct 2003 12:36:17 -0700452_US-ASCII To the List-Owner:
I sent an UNSUBSCRIBE request yesterday to the appropriate EMAIL address, and I received a "droid" confirmation response almost immediately in the early afternoon.
Why do I continue to receive list postings today?
I also attempted to EMAIL webmaster@idugdb2-l.org and received an undelivered EMAIL about invalid recipient.
See to it that sbarry@sbbworks.com is removed immediately from this list.
103 24 14_Re: banner_add0_16_LJKeeler@USS.COM31_Thu, 30 Oct 2003 14:39:25 -0500249_US-ASCII Phil Gunning cc: Sent by: DB2 Data Subject: banner_add Base Discussion List
10/30/2003 02:16 PM Please respond to DB2 Database Discussion list at IDUG
128 22 14_Re: banner_add9_Sam Mehta19_sam.mehta@QUEST.COM31_Thu, 30 Oct 2003 13:40:18 -0600309_us-ascii Phil,
Could you please make sure that I am off the list serve. Sam Mehta
-----Original Message----- From: DB2 Data Base Discussion List To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Thu Oct 30 11:16:56 2003 Subject: banner_add
151 74 16_Re: SQL question14_Dash, Sushanta21_sushanta.dash@EDS.COM31_Thu, 30 Oct 2003 05:13:22 -0600354_iso-8859-1 Hi Sanjay, for full outer joins the select list inside the view definition should be stand alone column for avoiding the materialization. From your query the COALESCE(A.COL1, B.COL1),COALESCE(A.COL2, B.COL2) are not stand alone columns. So I guess this is the root cause for materialization. Hope there would be experts comments on this. [...]
226 62 14_Re: banner_add18_Ghose, Roger (MTO)25_Roger.Ghose@MTO.GOV.ON.CA31_Thu, 30 Oct 2003 14:47:27 -0500274_iso-8859-1 Phil, Could you please tell me how to get HTML Digest. Thanks! Roger
-----Original Message----- From: Phil Gunning [mailto:pgunning@COMCAST.NET] Sent: October 30, 2003 02:17 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: banner_add
289 25 60_Re: Shan Leatherman/MO/americancentury is out of the office.14_Drechsler, Rob30_Rob.Drechsler@TRANSAMERICA.COM31_Thu, 30 Oct 2003 13:45:57 -0600490_ISO-8859-1 I asked and was supposedly removed on Tuesday, please take me off of this list
-----Original Message----- From: Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM [mailto:Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM] Sent: Thursday, October 30, 2003 1:32 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Shan Leatherman/MO/americancentury is out of the office.
I will be out of the office starting 10/30/2003 and will not return until 10/31/2003. [...]
315 34 14_Re: banner_add14_Drechsler, Rob30_Rob.Drechsler@TRANSAMERICA.COM31_Thu, 30 Oct 2003 13:55:11 -0600449_ISO-8859-1 ??????
-----Original Message----- From: LJKeeler@USS.COM [mailto:LJKeeler@USS.COM] Sent: Thursday, October 30, 2003 1:39 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: banner_add
Phil Gunning cc: Sent by: DB2 Data Subject: banner_add Base Discussion List
10/30/2003 02:16 PM Please respond to DB2 Database Discussion list at IDUG
350 54 33_Re: banner_add email and settings14_Olsen, Crystal31_Crystal.Olsen@BANKOFAMERICA.COM31_Thu, 30 Oct 2003 15:05:16 -0500361_iso-8859-1 Can someone please explain why my settings of "digest" keep getting reset back to individual every time a change is made by the administrator? This is getting rather frustrating.
Crystal S. Olsen DB2 Database Administration NC1-025-04-61 704-683-1724
"I love a dog, he does nothing for political reasons"
405 34 37_Re: UNSUBSCRIBE Request not Fulfilled11_John Kruger23_DHSPA43@DHS.STATE.IL.US31_Thu, 30 Oct 2003 14:05:42 -0600534_US-ASCII OH NO! It's started all over again. The unsubscribed work for awhile but it looks like someone restored the old subcriber list. Is this TRICK in Trick-or-Treat?
Please UNSUBCRIBE me again. I will subscribe when the dust settles.
Thanks, John
>>> Scott Barry 10/30/03 01:36PM >>> To the List-Owner:
I sent an UNSUBSCRIBE request yesterday to the appropriate EMAIL address, and I received a "droid" confirmation response almost immediately in the early afternoon. [...]
440 93 11_unsubscribe15_Brett Wesoloski25_Brett.Wesoloski@ROEHL.NET31_Thu, 30 Oct 2003 14:06:37 -0600533_us-ascii -----Original Message----- From: Dash, Sushanta [mailto:sushanta.dash@EDS.COM] Sent: Thursday, October 30, 2003 5:13 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: SQL question
Hi Sanjay, for full outer joins the select list inside the view definition should be stand alone column for avoiding the materialization. From your query the COALESCE(A.COL1, B.COL1),COALESCE(A.COL2, B.COL2) are not stand alone columns. So I guess this is the root cause for materialization. Hope there would be experts comments on this. [...]
534 84 37_FW: IMPORTANT - FROM DB2-L LIST OWNER15_Thomas, Janis E19_Janis.Thomas@CA.COM31_Thu, 30 Oct 2003 14:17:29 -0600547_iso-8859-1
> The server had major problems (that we did not cause) & Phil Gunning worked all day with support to get the server back running, but unfortunately he had to refresh the listserv back to how it was a couple of days ago. If you unsubscribed before, and you get this message, you need to do it again. Same for digest mode. Do not respond to the list. > Send the following message in the body of the email (not the subject line) to LISTSERV@WWW.IDUGDB2-L.ORG > if you want to signoff: > SIGNOFF DB2-L > or if you want digest [...]
619 28 11_unsubscribe0_22_NORRISS@NATIONWIDE.COM31_Thu, 30 Oct 2003 15:10:33 -0500107_us-ascii I tried this the other day and I guess I am still on it, please remove me...
Thanks
648 25 19_Unsubscribe Address11_Bruce Galle17_bgalle@US.IBM.COM31_Thu, 30 Oct 2003 15:18:54 -0500287_US-ASCII Help! I have been trying to unsubscibe via listserve address but this does not seem toexist (for me). I was getting digest version and this was fine, but I just inthe last hour was set into nodigest mode. I either write a filter or find the listserver to process commands. [...]
674 29 37_Re: UNSUBSCRIBE Request not Fulfilled11_Danny Davis16_DTDAVIS@PCMH.COM31_Thu, 30 Oct 2003 15:24:32 -0500457_US-ASCII What he said.
>>> Scott Barry 10/30/03 02:36PM >>> To the List-Owner:
I sent an UNSUBSCRIBE request yesterday to the appropriate EMAIL address, and I received a "droid" confirmation response almost immediately in the early afternoon.
Why do I continue to receive list postings today?
I also attempted to EMAIL webmaster@idugdb2-l.org and received an undelivered EMAIL about invalid recipient. [...]
704 70 61_Bottom Trailer on how to subscribe or unsubscribe to the list12_Phil Gunning20_pgunning@COMCAST.NET31_Thu, 30 Oct 2003 15:18:31 -0500647_iso-8859-1 We had to install a hiper patch from LSOFT International. If you are recieving mail and you don't want to be, follow the below instructions. Thanks, Phil
############################################################# To change your subscription options or subscribe or to cancel your subscription visit the DB2-L webpage at http://www.idugdb2-l.org/adminscripts/wa.exe?REPORT&Z=3. To UNSUBSCRIBE send the UNSUBSCRIBE command to listserv@www.idugdb2-l.org and to set yourself to use DIGEST mode send the SET DB2-L DIGEST command to listerv@www.idugdb2-l.org. The owners of the list can be reached at
775 85 30_Here is a way to stop the mail0_24_Allen_Glinter@MAY-CO.COM31_Thu, 30 Oct 2003 14:39:01 -0600640_us-ascii FYI.
Al Glinter, Lead Database Administrator The May Department Stores Company Mid-West Data Center 611 Olive Street St. Louis, MO 63101 314-342-6800 X-3389
----- Forwarded by Allen Glinter/MDSC/MAYCO on 10/30/2003 02:37 PM -----
cathy.peck@highma rk.com To: Allen_Glinter@May-Co.com cc: Cathy.Peck@highmark.com, Erin_Thornburg@sba.com 10/28/2003 12:07 Subject: Re: DB2-L@WWW.IDUGDB2-L.ORG PM
Allen, please do the following.
Send an email to: listserv@www.idugdb2-l.org On the BODY of the email, not the subject, enter the following: Set DB2-L nomail [...]
861 30 30_How to suspend mail from DB2-L14_Shelton, Glenn21_Glenn_Shelton@BMC.COM31_Thu, 30 Oct 2003 14:49:38 -0600475_iso-8859-1 ______________________________________________ Send an email to LISTSERV@WWW.IDUGDB2-L.ORG
placing the following command in the BODY of the message; "SET DB2-L NOMAIL" (without the quotes)
You turn it back on in a day or so once the list administrator has corrected the problem.
Regards, Glenn
Glenn R. Shelton Sr. Product Line Manager CHANGE MANAGER for DB2 BMC Software Phone: (512) 340-6261 Email: Glenn_Shelton@bmc.com [...]
892 14 12_DB2-L nomail9_John Reid14_jreid@FBFS.COM31_Thu, 30 Oct 2003 14:57:45 -0600513_us-ascii DB2-L nomail
############################################################# To change your subscription options or subscribe or to cancel your subscription, visit the DB2-L webpage at http://www.idugdb2-l.org/adminscripts/wa.exe?REPORT&Z=3. To UNSUBSCRIBE send the UNSUBSCRIBE DB2-L command to listserv@www.idugdb2-l.org and to set yourself to use DIGEST mode send the SET DB2-L DIGEST command to listserv@www.idugdb2-l.org. The owners of the list can be reached at DB2-L-REQUEST@www.idugdb2-l.org.
907 55 11_UNSUBSCRIBE10_Bob Treski19_Bob_Treski@SPGL.COM31_Thu, 30 Oct 2003 14:59:20 -0600500_us-ascii
************************************************************************** ** This email and all files transmitted with it are confidential and ** intended solely for the use of the individual or entity to whom they ** are addressed. ** ** This message also confirms that all contents were examined ** by MIMEsweeper and Anti-Virus Software. ** ** System Administrator ** postmaster@spgl.com ** ************************************************************************** [...]
963 50 17_A Modest Proposal0_26_Phil.Sevetson@WAKEFERN.COM31_Wed, 29 Oct 2003 09:46:42 -0500418_us-ascii You know, maybe if we asked someone who knows LISTSERV programming, they'd write us a user exit...
Which would automatically reject any message posted to this list with 'unsubscribe' as the first-word-in-title or first-word-in-text. Ya gotta admit it'd cut down on unnecessary traffic.
Any uber-geeks out there know whether this can be done with the listserv software in use for this list? [...]
1014 47 22_Unload using Templates14_Galeos Antonis19_AGaleos@EUROBANK.GR31_Wed, 29 Oct 2003 16:32:15 +0200413_iso-8859-7 Hello Listers We are in DB2 V7 . Is it possible in an Unload utility using Listdef and Templates to declare the Syspunch dummy or as a member in a library. Like the examples below.
TEMPLATE INPRTEMP UNIT SYSDA DSN(GEBD.BAT1NBAS.SYSREC.&TS..T&TI.) DISP(NEW,CATLG,DELETE) TEMPLATE PUNCTEMP UNIT SYSDA DSN DUMMY OPTIONS LISTDEFDD LISTDSN UNLOAD LIST TESTTEMP UNLDDN INPRTEMP PUNCHDDN PUNCTEMP [...]
1062 57 0_0_26_Jeanine_Trachsel@BCBST.COM31_Wed, 29 Oct 2003 10:04:26 -0500796_iso-8859-1 Please UNSCRIBE my address.
Please see the following link for the BlueCross BlueShield of Tennessee E-mail disclaimer: http://www.bcbst.com/email_disclaimer.shtm
############################################################# Welcome to the IDUG DB2-L list. To change your subscription options or subscribe or to cancel your subscription, visit the IDUGDB2-L webpage at http://www.idugdb2-l.org/adminscripts/wa.exe?REPORT&Z=3. WE URGE YOU TO USE THE WEB page but if you can't then send commands to the list as follows: To UNSUBSCRIBE send the UNSUBSCRIBE DB2-L command to listserv@www.idugdb2-l.org and to set yourself to use DIGEST mode or NOMAIL send the SET DB2-L DIGEST or SET DB2-L NOMAIL command to listserv@www.idugdb2-l.org. Only send one command at a [...]
1120 16 11_UNSUBSCRIBE13_ASHWINI KUMAR22_Ashwini.Kumar@SLMA.COM31_Wed, 29 Oct 2003 10:07:33 -0500705_US-ASCII DB2-L NOMAIL .
############################################################# Welcome to the IDUG DB2-L list. To change your subscription options or subscribe or to cancel your subscription, visit the IDUGDB2-L webpage at http://www.idugdb2-l.org/adminscripts/wa.exe?REPORT&Z=3. WE URGE YOU TO USE THE WEB page but if you can't then send commands to the list as follows: To UNSUBSCRIBE send the UNSUBSCRIBE DB2-L command to listserv@www.idugdb2-l.org and to set yourself to use DIGEST mode or NOMAIL send the SET DB2-L DIGEST or SET DB2-L NOMAIL command to listserv@www.idugdb2-l.org. Only send one command at a time.The owners of the list can be reached at DB2-L-REQUEST@www.idugdb2-l.org.
1137 40 15_OT (Re: Filter)0_26_Phil.Sevetson@WAKEFERN.COM31_Wed, 29 Oct 2003 10:23:42 -0500767_us-ascii Filter sounds like a good idea (He said, ruefully surveying the ruins of his in-box). Does anyone know how to set an input filter in the Lotus Notes email database/client?
--Phil Sevetson phil.sevetson@wakefern.com Database Administration Wakefern Food Corporation
############################################################# Welcome to the IDUG DB2-L list. To change your subscription options or subscribe or to cancel your subscription, visit the IDUGDB2-L webpage at http://www.idugdb2-l.org/adminscripts/wa.exe?REPORT&Z=3. WE URGE YOU TO USE THE WEB page but if you can't then send commands to the list as follows: To UNSUBSCRIBE send the UNSUBSCRIBE DB2-L command to listserv@www.idugdb2-l.org and to set yourself to use DIGEST mode [...]
1178 151 16_Re: CICS Spufi !13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Wed, 29 Oct 2003 09:15:12 -0600555_iso-8859-1 From my experience the timeron value is not a good reliable indicator of actual runtime. We tried something similar with a CICS application (basing "run/don't run" decisions on the timeron value) but using timerons just wasn't very effective. If you are really looking for an excuse to upgrade off of V5, you might be able to use the availability of the predictive governor as a reason (I haven't had enough experience with it to be able to say how reliable it is, but I'm going to guess it also has limitations to the magic it can work). [...]
1330 108 45_PLEASE READ: HOW TO UNSUBSCRIBE FROM NEW LIST15_Thomas, Janis E19_Janis.Thomas@CA.COM31_Wed, 29 Oct 2003 09:27:34 -0600569_iso-8859-1 Send the following message in the body of the email (not the subject line) to LISTSERV@WWW.IDUGDB2-L.ORG:
signoff DB2-L
(or unsubscribe DB2-L also works) Only if you have trouble signing off (maybe your email address changed since first subscribing), then contact the list owners:
owner-db2-l@WWW.IDUGDB2-L.ORG
We do not have the time to unsubscribe everyone manually who sends an UNSUBSCRIBE message to the list. Thank you for understanding. Replies to this message will go to the list owners, not to the DB-L list. [...]
1439 194 30_Excessive DRAIN LOCK WAIT time0_26_rkalyana@NOTES.STATE.NE.US31_Wed, 29 Oct 2003 09:17:31 -0600478_US-ASCII We are investigating a performance issue with a few of our long running batch applications and what we are seeing is a large number on the DRAIN_WAIT count and there is a strong positive correlation between DRAINWCNT and PAGEUPDT on all the applications that incur large DRAIN_WAIT time. Please note that this is happening in INSERTS/UPDATES and is mostly restricted to a few VOLUMEs. (DASD: Logical 3390-3; Physical RVA-9393X82). We are running DB2V7 at PUT0307. [...]
1634 125 21_Re: A Modest Proposal15_Foweather, Iris30_Iris.Foweather@UK.EXPERIAN.COM31_Wed, 29 Oct 2003 15:02:16 -0000588_- Could we also filter out the 'out of office' messages whilst we are at it?
Iris Foweather Technology Services Wollaton House Lower Ground Experian Tel: 0115 9344312 Email : iris.foweather@uk.experian.com
-----Original Message----- From: Phil.Sevetson@WAKEFERN.COM [mailto:Phil.Sevetson@WAKEFERN.COM] Sent: Wednesday, October 29, 2003 2:47 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: A Modest Proposal
You know, maybe if we asked someone who knows LISTSERV programming, they'd write us a user exit... [...]
1760 101 19_Re: Runstats Systax17_Patrick D Bossman18_bossman@US.IBM.COM31_Wed, 29 Oct 2003 10:20:22 -0500364_US-ASCII Hello, I saw a note which indicated many frequencies were being collected. In an SAP R3 environment, frequencies will rarely be used because the literal values are not known. SAP R3 provides parameter markers. There are some situations where SAP R3 will use REOPT(VARS), but these situations are rare. In these situations, frequencies can be useful. [...]
1862 81 26_Re: Unload using Templates0_22_sally.mir@WACHOVIA.COM31_Wed, 29 Oct 2003 10:22:28 -0500646_US-ASCII Try this:
TEMPLATE PUNCTEMP UNIT SYSDA DSN(NULLFILE)
Sally Mir
Galeos Antonis @IDUGDB2-L.ORG> on 10/29/2003 09:32:15 AM
Please respond to DB2 Database Discussion list at IDUG
Sent by: DB2 Data Base Discussion List
To: DB2-L@WWW.IDUGDB2-L.ORG cc:
Subject: Unload using Templates
Hello Listers We are in DB2 V7 . Is it possible in an Unload utility using Listdef and Templates to declare the Syspunch dummy or as a member in a library. Like the examples below. [...]
1944 63 19_Re: OT (Re: Filter)13_Michael Ebert18_mebert@AMADEUS.NET31_Wed, 29 Oct 2003 16:34:04 +0100403_us-ascii Open the Rules folder, then click on New Rule... from then on it should be self-explanatory.
Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany
Filter sounds like a good idea (He said, ruefully surveying the ruins of his in-box). Does anyone know how to set an input filter in the Lotus Notes email database/client? [...]
2008 41 37_Migrating OS/390 DB2 to OS/390 ORACLE13_John Fletcher27_johnefletcher2000@YAHOO.COM31_Wed, 29 Oct 2003 07:26:00 -0800591_us-ascii I am working with a client who, due to implementation of an ERP, now have one or two small legacy applications using CICS COBOL and DB2 on the OS/390. Given they have a site license for ORACLE are interested in modifying their application to use ORACLE on OS/390.
If anyone has been involved in a similar project, do you have any tips you could share or point me in the right direction for documentation relating to migrating the database and any application (COBOL) changes required?. ORACLE has a workbench for migrating from DB2, however this does not operate on the [...]
2050 84 15_OT (Re: Filter)13_Joseph Fatula22_jfatula@AESSUCCESS.ORG31_Wed, 29 Oct 2003 10:30:48 -0500431_iso-8859-1 While we're at it, how about one for "Out of Office" or "Out of the Office"? Those messages are hardly "on topic" either. In the long run, we probably get more of those.
Joe Fatula
----- Forwarded by Joseph Fatula/PHEAA on 10/29/03 10:27 AM -----
Phil.Sevetson@WA KEFERN.COM To: DB2-L@WWW.IDUGDB2-L.ORG Sent by: DB2 cc: Data Base Subject: OT (Re: Filter) Discussion List [...]
2135 49 19_Re: OT (Re: Filter)0_22_BRIAN_GOLDBERG@QVC.COM31_Wed, 29 Oct 2003 10:33:33 -0500424_us-ascii There's supposed to be a Rules folder where you can set them, but I haven't been able to get it working correctly yet.
Phil.Sevetson@WAK EFERN.COM To: DB2-L@WWW.IDUGDB2-L.ORG Ext: cc: (bcc: BRIAN GOLDBERG/QVC) Sent by: DB2 Data Subject: OT (Re: Filter) Base Discussion List
10/29/2003 10:23 AM Please respond to DB2 Database Discussion list at IDUG [...]
2185 107 22_Re: REORG with DISCARD0_28_Missy.Case@FIRSTDATACORP.COM31_Wed, 29 Oct 2003 09:34:03 -0600470_US-ASCII I have used this exact statement successfully:
REORG TABLESPACE TFRDBH01.RDTSTFH2 SHRLEVEL REFERENCE DISCARD FROM TABLE TFRD1.RDTBDFS2 WHEN ( TRAN_DATE < CURRENT DATE - 12 MONTHS ) SORTDEVT SYSDA SORTNUM 32 SORTKEYS COPYDDN SYSCP03
Missy Case FDR 701-275-6358
mflavell@I-TCS.CO M To: DB2-L@WWW.IDUGDB2-L.ORG Sent by: DB2 Data cc: Base Discussion bcc: List Subject: Re: REORG with DISCARD [...]
2293 112 83_db2 maintenance warning... don't apply UQ80257 ... until ptf for PQ79857 is written19_Humphris,Richard P.24_Richard.Humphris@CNA.COM31_Wed, 29 Oct 2003 09:43:37 -0600451_us-ascii Hi all,
We recently applied PQ77234/UQ80257, but I'd suggest NOT applying this ptf until IBM has a ptf written for PQ79857.
Based on my ETR with IBM, I know IBM will be updating the apar description for PQ79857 soon. However, IBM (currently) doesn't have the UQ80257 ptf problem documented as the causer of the problem in the apar description for PQ79857; but they told me that was the offending ptf in our ETR discussion. [...]
2406 171 47_Re: Update from List Admin (former Assoc owner)13_Hanken, Patti30_Patti.Hanken@NWDC.IBS-LMCO.COM31_Wed, 29 Oct 2003 07:48:09 -0800655_iso-8859-1 Please remove me from the list.
-----Original Message----- From: Phil Gunning [mailto:pgunning@COMCAST.NET] Sent: Tuesday, October 28, 2003 4:32 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Update from List Admin (former Assoc owner) Importance: High
Well, as some of you know, our volume and throughput was quite good the last two days:). Hey Max, I bet you could attest to that:)..It seems like the new server and bandwidth are quite capable to support our list. For those of you that are curious, I put about 100 hrs in moving this list the last 3 weeks while providing world leading DB2 UDB consulting during daylight [...]
2578 22 20_Re: set db2-l digest15_Conoway, Roslyn28_Roslyn_Conoway@COMPUWARE.COM31_Wed, 29 Oct 2003 10:39:05 -0500378_iso-8859-1 set db2-I digest
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 please notify us immediately and then destroy it. . [...]
2601 139 22_Re: REORG with DISCARD16_Lemaire, Nigel B21_nigel.lemaire@EDS.COM31_Wed, 29 Oct 2003 09:57:32 -0600736_- It is the missing parens that is causing the problem...
Nigel Lemaire EDS Americas Infrastructure Technology & Engineering Mainframe DB2 Production DBA Phone : 541-618-8444 vnet : NONE Pager : 1-877-285-2796 Email page : Nigel.Lemaire@skytel.com EMAIL : Nigel.Lemaire @ EDS.COM AOLIM : WA6MSE SAMETIME : C-Nigel.Lemaire JABBER : nigel.lemaire
> -----Original Message----- > From: Missy.Case@FIRSTDATACORP.COM > [mailto:Missy.Case@FIRSTDATACORP.COM] > Sent: Wednesday, October 29, 2003 7:34 AM > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: Re: REORG with DISCARD > > > I have used this exact statement successfully: > > REORG TABLESPACE TFRDBH01.RDTSTFH2 > SHRLEVEL REFERENCE > DISCARD FROM TABLE > TFRD1.RDTBDFS2 > WHEN [...]
2741 111 19_Re: OT (Re: Filter)0_26_Phil.Sevetson@WAKEFERN.COM31_Wed, 29 Oct 2003 11:04:14 -0500284_us-ascii It took a bit of scrounging around, but I finally figured out what y'all meant by your advice, and I now am able to refuse UNSUBSCRIBE email. I'm not sure I _want_ to refuse out-of-office mail; I might actually need to know if someone in my extended workgroup isn't in. [...]
2853 121 21_Re: A Modest Proposal12_McKown, John26_john.mckown@UICIINSCTR.COM31_Wed, 29 Oct 2003 10:09:18 -0600285_- If so, then perhaps a body with instructions on how to properly issue listserv command. Oh, and also set it up so that somebody clicking on "reply" would have the "reply" go to the listserv control address instead of the list itself.
Good idea.
2975 22 10_unsuscribe16_Pary Alain (DBB)19_Alain.Pary@DEXIA.BE31_Wed, 29 Oct 2003 17:02:22 +0100713_iso-8859-1 please can you unsuscribe my name from the list my email is alain.pary@dexia.be
Alain Pary CCDBMS/DB2 DEXIA BANK
+32 (0) 2 222 64 48 .
############################################################# Welcome to the IDUG DB2-L list. To change your subscription options or subscribe or to cancel your subscription, visit the IDUGDB2-L webpage at http://www.idugdb2-l.org/adminscripts/wa.exe?REPORT&Z=3. WE URGE YOU TO USE THE WEB page but if you can't then send commands to the list as follows: To UNSUBSCRIBE send the UNSUBSCRIBE DB2-L command to listserv@www.idugdb2-l.org and to set yourself to use DIGEST mode or NOMAIL send the SET DB2-L DIGEST or SET DB2-L NOMAIL command to [...]
2998 50 23_LUW - tcpip error 1011012_Travis, John20_john.travis@CGEY.COM31_Wed, 29 Oct 2003 16:08:53 -0000371_- All, We have been seeing some intermittent problems on a UDB V7 Server on Windows NT recently. The only evidence are entries in db2diag.log pointing to a tcp/ip problem. I have so far been unable to determine the cause of this error. Has anybody seen anything similar or can explain whet the error 10110 is, as it does not appear in the Messages and codes manual. [...]
3049 151 25_Re: Strange Explain issue20_M'Cartney, Michael N24_michael.mcartney@EDS.COM31_Wed, 29 Oct 2003 16:10:41 -0000326_- Myron, Just a thought... When you do the explain of the dynamic SQL, do you have values coded instead of host variable markers ('?'). If you do then this is the equivalent of coding REOPT(VARS) on the BIND for the static SQL.
If you don't have static (hard-coded) values in your dynamic SQL, ignore my comments. [...]
3201 240 34_Re: Excessive DRAIN LOCK WAIT time0_25_antoine.michielse@UBS.COM31_Wed, 29 Oct 2003 17:12:28 +0100484_iso-8859-1 This looks like a reporting problem I have seen before in various performance monitors. Check with the vendor to see if they are current with the DB2 class 3 breakdown. (log write I/O specifically)..
Toine Michielse
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of rkalyana@NOTES.STATE.NE.US Sent: Mittwoch, 29. Oktober 2003 16:18 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Excessive DRAIN LOCK WAIT time [...]
3442 30 37_Report Recovery Utility - PIT Recover0_20_ravi.reddy@PS.GE.COM31_Thu, 30 Oct 2003 16:48:34 -0500398_ISO-8859-1 Hello All,
Question on Report Recovery ouput , DB2 V6 OS/390
Report Recovery gives me the SYSLGRNX ROWS from BSDS, including the STARTRBA and ENDRBA.
Can i use this STARTRBA value to do a Point in Time Recovery ( Recover TORBA ) ?
How/When are DSN1LOGP / DSNJU004 useful in a PIT Recovery scenario if Report Recovery does give me the RBA values needed ? [...]
3473 27 15_FW: UNSUBSCRIBE17_Nelson, Debbie R.22_debbie.nelson@USAA.COM31_Wed, 29 Oct 2003 10:26:21 -0600866_US-ASCII -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Derrick Tatem Sent: Tuesday, October 28, 2003 9:55 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: UNSUBSCRIBE
Regards,
------------------------------------------------------------------------ -----
Derrick M. Tatem, I/T Specialist .
############################################################# Welcome to the IDUG DB2-L list. To change your subscription options or subscribe or to cancel your subscription, visit the IDUGDB2-L webpage at http://www.idugdb2-l.org/adminscripts/wa.exe?REPORT&Z=3. WE URGE YOU TO USE THE WEB page but if you can't then send commands to the list as follows: To UNSUBSCRIBE send the UNSUBSCRIBE DB2-L command to listserv@www.idugdb2-l.org and to set yourself to use DIGEST mode or NOMAIL send the [...]
3501 15 19_Recall: UNSUBSCRIBE17_Nelson, Debbie R.22_debbie.nelson@USAA.COM31_Wed, 29 Oct 2003 10:38:23 -0600722_US-ASCII The sender would like to recall the message, "UNSUBSCRIBE". .
############################################################# Welcome to the IDUG DB2-L list. To change your subscription options or subscribe or to cancel your subscription, visit the IDUGDB2-L webpage at http://www.idugdb2-l.org/adminscripts/wa.exe?REPORT&Z=3. WE URGE YOU TO USE THE WEB page but if you can't then send commands to the list as follows: To UNSUBSCRIBE send the UNSUBSCRIBE DB2-L command to listserv@www.idugdb2-l.org and to set yourself to use DIGEST mode or NOMAIL send the SET DB2-L DIGEST or SET DB2-L NOMAIL command to listserv@www.idugdb2-l.org. Only send one command at a time.The owners of the list can be reached [...]
3517 24 11_Unsubscribe0_26_Paul.ORourke@CAREFIRST.COM31_Wed, 29 Oct 2003 11:42:27 -0500733_- ******************************************************************************** Unauthorized interception of this communication could be a violation of Federal and State Law. This communication and any files transmitted with it are confidential and may contain protected health information. This communication is solely for the use of the person or entity to whom it was addressed. If you are not the intended recipient, any use, distribution, printing or acting in reliance on the contents of this message is strictly prohibited. If you have received this message in error, please notify the sender and destroy any and all copies. Thank you. ******************************************************************************* . [...]
3542 60 31_Forcing to use a specific index0_31_shankar.mridha@SOMERFIELD.CO.UK31_Wed, 29 Oct 2003 17:01:43 -0000374_iso-8859-1 Help required,
I have a table which has 4 indexes. Cluster ratio 99 index1- primary index Clustered col1, col2, col3, col4, col5, col6 77 index2- Secondary index nonclustered col5
67 index3- Secondary index nonclustered col3, col4 72 index4- Secondary index nonclustered col3, col4, col5, col6, col7
My query is having a where clause of [...]
3603 133 87_Re: db2 maintenance warning... don't apply UQ80257 ... until ptf for PQ79857 is written13_Jeremiah Eden28_JEREMIAH.EDEN@RADIOSHACK.COM31_Wed, 29 Oct 2003 11:07:01 -0600479_us-ascii Thanks. I wish more people would send info like this.
-----Original Message----- From: Humphris,Richard P. [mailto:Richard.Humphris@CNA.COM] Sent: Wednesday, October 29, 2003 9:44 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: db2 maintenance warning... don't apply UQ80257 ... until ptf for PQ79857 is written
Hi all,
We recently applied PQ77234/UQ80257, but I'd suggest NOT applying this ptf until IBM has a ptf written for PQ79857. [...]
3737 92 22_Re: REORG with DISCARD15_Barbara J. Nigh20_bjnigh@HOUSEHOLD.COM31_Wed, 29 Oct 2003 09:25:22 -0800534_us-ascii All I needed was a parenthesis around the when clause. Thanks for your assistance.
"Dash, Sushanta" cc: Sent by: DB2 Data Subject: Re: REORG with DISCARD Base Discussion List
10/28/2003 10:22 PM Please respond to DB2 Database Discussion list at IDUG
Hi , though not checked the syntax , but immediate thought would be to test with this kind of syntax. [...]
3830 76 41_Re: Report Recovery Utility - PIT Recover14_Andy Lankester30_andy.lankester@CDBSOFTWARE.COM31_Thu, 30 Oct 2003 22:09:55 -0000396_us-ascii Ravi,
You should only do a PiT recovery to a point of consistency for the tablespace (and any RI or application related tablespaces). This means a _common_ COPY SHRLEVEL REFERENCE or a QUIESCE point, all of which will be in SYSCOPY.
Any other point and you are in no-mans's land with half completed transactions and/or related tablespaces recovered to different PiTs. [...]
3907 98 15_Re: PIT Recover0_16_khampto1@TXU.COM31_Thu, 30 Oct 2003 16:22:56 -0600621_us-ascii Hello Ravi, you would first need to figure out which of your archive log datasets (assuming that the log has switched and archives since yesterday) covers the time period around 1400 hrs yesterday. You can see a list of all the archives and their times if you run the bootstrap print program, DSNJU004. Then you would run the DSN1LOGP utility, using that log archive as input, and use something like this for SYSIN: RBASTART(000000000000) RBAEND(FFFFFFFFFFFF) SUMMARY(ONLY) Then search the printout for the INSERT activity around the 1400 time period, (hopefully you know an AUTHID as well, and try to find [...]
4006 132 41_Re: Report Recovery Utility - PIT Recover0_16_khampto1@TXU.COM31_Thu, 30 Oct 2003 16:27:06 -0600514_us-ascii Ravi, looks like Andy has a very good point, but if no good point of recovery can be found from SYSCOPY, my way might still work.
Kirk Hampton DB2 OS/390 Sysprog IBM Certified Solutions Expert - DB2 V7 Database Administration OS/390 TXU Business Services Dallas, Texas
Andy Lankester cc: Sent by: DB2 Data Subject: Re: Report Recovery Utility - PIT Recover Base Discussion List [...]
4139 55 65_Re: Bottom Trailer on how to subscribe or unsubscribe to the list14_Alexander John28_jalexander@WOOLWORTHS.COM.AU31_Fri, 31 Oct 2003 09:31:18 +1100542_iso-8859-1 Can you please remove jalexander@woolworths.com.au from distribution list.
many thanks john
-----Original Message----- From: Phil Gunning [mailto:pgunning@COMCAST.NET] Sent: Friday, 31 October 2003 7:19 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Bottom Trailer on how to subscribe or unsubscribe to the list
We had to install a hiper patch from LSOFT International. If you are recieving mail and you don't want to be, follow the below instructions. Thanks, Phil [...]
4195 51 37_Re: UNSUBSCRIBE Request not Fulfilled6_Ravi P22_ravidb2dba@HOTMAIL.COM31_Thu, 30 Oct 2003 16:40:49 -0600731_- Hello,
Same thing happening me also.Please remove my maild your distribution list.
>From: Danny Davis >Reply-To: DB2 Database Discussion list at IDUG >To: DB2-L@WWW.IDUGDB2-L.ORG >Subject: Re: UNSUBSCRIBE Request not Fulfilled >Date: Thu, 30 Oct 2003 15:24:32 -0500 > >What he said. > > >>> Scott Barry 10/30/03 02:36PM >>> >To the List-Owner: > >I sent an UNSUBSCRIBE request yesterday to the appropriate EMAIL >address, and I received a "droid" confirmation response almost >immediately in the early afternoon. > >Why do I continue to receive list postings today? > >I also attempted to EMAIL webmaster@idugdb2-l.org and received an [...]
4247 37 37_Re: UNSUBSCRIBE Request not Fulfilled27_Anyanso Phillips Agwu-Okeke17_pagwu@HOTMAIL.COM31_Thu, 30 Oct 2003 17:57:04 -0500
4285 61 15_Re: PIT Recover0_22_DB2information@AOL.COM29_Thu, 30 Oct 2003 17:53:57 EST808_US-ASCII In a message dated 10/30/2003 11:32:03 AM Pacific Standard Time, ravi.reddy@PS.GE.COM writes: Ravi Ravi, To automate this process using ISPF panel driven method visit:www.recoveryknowledge.com
Regards, Ed. Benoit Recovery Knowledge The DB2 Disaster Recovery People www.recoveryknowledge.com
############################################################# Welcome to the IDUG DB2-L list. To change your subscription options or subscribe or to cancel your subscription, visit the IDUGDB2-L webpage at http://www.idugdb2-l.org/adminscripts/wa.exe?REPORT&Z=3. WE URGE YOU TO USE THE WEB page but if you can't then send commands to the list as follows: To UNSUBSCRIBE send the UNSUBSCRIBE DB2-L command to listserv@www.idugdb2-l.org and to set yourself to use DIGEST mode or NOMAIL send [...]
4347 16 47_Tom Koerner/MKE/METAVANTE is out of the office.0_25_Tom.Koerner@METAVANTE.COM31_Thu, 30 Oct 2003 17:03:49 -0600729_us-ascii I will be out of the office starting 10/29/2003 and will not return until 11/03/2003.
I will respond to your message when I return.
############################################################# Welcome to the IDUG DB2-L list. To change your subscription options or subscribe or to cancel your subscription, visit the IDUGDB2-L webpage at http://www.idugdb2-l.org/adminscripts/wa.exe?REPORT&Z=3. WE URGE YOU TO USE THE WEB page but if you can't then send commands to the list as follows: To UNSUBSCRIBE send the UNSUBSCRIBE DB2-L command to listserv@www.idugdb2-l.org and to set yourself to use DIGEST mode or NOMAIL send the SET DB2-L DIGEST or SET DB2-L NOMAIL command to listserv@www.idugdb2-l.org. [...]
4364 45 28_DSNJW101 VIA MODULE DSNJL0020_26_rkalyana@NOTES.STATE.NE.US31_Thu, 30 Oct 2003 20:01:20 -0600396_US-ASCII One of my strobe reports (on a long running batch sequential insert programs) is showing a large amount wait time (about 65% of the total INDB2TIME) on DSNJW101 via module DSNJL002 (LOG COMMON SUBROUTINES). We are thinking of increasing the LOG OUTPUT BUFFER SIZE and/or increasing the LOG WRITE THRESHOLD. I am looking for other solutions, if any. We are running DB2V7 at PUT0307. [...]
4410 38 32_Guidelines for Stored Procedures0_14_DPetro@AOL.COM29_Thu, 30 Oct 2003 21:07:22 EST741_US-ASCII Does anyone have any guidelines for when to use Stored Procedures over subroutines that they'd be willing to share?
Thanks. Dave.
############################################################# Welcome to the IDUG DB2-L list. To change your subscription options or subscribe or to cancel your subscription, visit the IDUGDB2-L webpage at http://www.idugdb2-l.org/adminscripts/wa.exe?REPORT&Z=3. WE URGE YOU TO USE THE WEB page but if you can't then send commands to the list as follows: To UNSUBSCRIBE send the UNSUBSCRIBE DB2-L command to listserv@www.idugdb2-l.org and to set yourself to use DIGEST mode or NOMAIL send the SET DB2-L DIGEST or SET DB2-L NOMAIL command to listserv@www.idugdb2-l.org. Only send one [...]
4449 163 35_Re: Forcing to use a specific index0_13_apapad@NBG.GR31_Fri, 31 Oct 2003 08:21:07 +0200368_ISO-8859-7 Hello Shankar,
What is the CARDF of your table (and how old are the statistics)? The RECLENGTH (how many rows do you have per page)? What are the FIRSTKEYCARDFs, FULLKEYCARDFs and NLEVELs of your indexes? Do data types match for col5, col3, col4, col6 host variables? Since the optimizer chooses this index there must (or should???) be a reason [...]
4613 158 25_SQL Performance very slow11_Pawan Reddy24_pawan_kalyan75@YAHOO.COM31_Thu, 30 Oct 2003 23:45:01 -0800395_us-ascii
Dear Listners,
I have done explains on the below query and tried to make it more efficient,
but it appears the changes only make it less efficient (even though by looking at the explain, it would appear to be more efficient).
Could you please tell me where the query is taking long time to execute or how to reduce the running time of the below query. [...]
4772 65 36_Re: Guidelines for Stored Procedures13_Martin Packer24_martin_packer@UK.IBM.COM31_Fri, 31 Oct 2003 07:53:12 +0000549_us-ascii If your application can stand it subroutines will perform better than Stored Procedures, especially in the "nested" case. But there may well be VERY good reasons from an application componentry perspective why you do Stored Procedures.
It turns out I'm writing a chapter in a new Red Book on Stored Procedures in November. It'll be about Stored Procedures performance - having spent a lot of time this year working on customer situations with SPs. I expect my "2004 Season" new presentation will go into lots of detail on this. [...]
4838 174 35_Re: Forcing to use a specific index63_=?ISO-8859-1?B?Sm9hcXVpbSBKb3PpIA==?=Carreira do Espirito Santo12_jes@PYXIS.PT31_Fri, 31 Oct 2003 07:58:36 +0000329_ISO-8859-1 Hi
Since DB2 optimizer is choosing index1, i think you have to figure out if that is not the best way to access the data.
If you are sure that index4 is better,if the dimension of the result is small and if the dimension of the matching interval is also small its safe to apply the following trick: [...]
5013 315 29_Re: SQL Performance very slow0_19_mike.holmans@BT.COM31_Fri, 31 Oct 2003 08:13:28 -0000730_iso-8859-1 Pawan,
If you'd share with us the results of those EXPLAINs and tell us what indexes you have on the tables, we'd probably be able to be of more assistance.
Mike Holmans Database consultant BTexact ESS Database Services mike.holmans@bt.com __________________________________________ British Telecommunications plc Registered office: 81 Newgate Street London EC1A 7AJ Registered in England no. 1800000 This electronic message contains information from British Telecommunications plc which may be privileged and confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient, be aware that any disclosure, copying, [...]
5329 23 50_ZOS: Using Listdef/Template just for ds allocation25_Sorensen Henrik (KAFC 21)33_henrik.sorensen@CREDIT-SUISSE.COM31_Fri, 31 Oct 2003 09:14:09 +0100453_- Dear list,
After a very busy week of deleting messages from DB2-L, things seems to be settling down.
One question,
If I want to use the LISTDEF and TEMPLATE utility statements, just to allocate the datasets, how can this be done ?
As far as I understand, the datasets in the template is only allocated when a utility uses the LIST option. But we want to allocate the datasets for some other purpose the DB2 utilities. [...]
5353 35 11_UNSUBSCRIBE0_31_MWrzesien@WENUS.WSIZ.RZESZOW.PL31_Fri, 31 Oct 2003 09:29:29 +0100396_ISO-8859-2 mgr in¿. Mariusz Wrzesieñ Sekretarz Katedry Systemów Ekspertowych i Sztucznej Inteligencji Wy¿sza Szko³a Informatyki i Zarz±dzania z siedzib± w Rzeszowie tel. 017 - 8661191
############################################################# Welcome to the IDUG DB2-L list. To change your subscription options or subscribe or to cancel your subscription, visit the IDUGDB2-L webpage at
5389 31 15_Re: PIT Recover0_16_mscarpa@CESVE.IT31_Fri, 31 Oct 2003 10:26:29 +0100541_us-ascii Hi
It happened to me some times and we use archive logs as 'timeline' for DB2 (we use timestamp as a part of archive file name), as suggested. It's easy if the time between two consecutive updates is long. But it happens very rarely.
If the evil updates are few, probably you know which they are (as you can say 'This is bad update executed at xx:yy:zz time ') and in this case is better to eliminate them via SQL delete. Of course if they are few. But if they are a lot probably there are better solution than a [...]
5421 75 70_DB2 on OS/390 - page lock on non-qualifying row with ambiguous cursor?0_26_Moira.LANGLEY@CA-DIALOG.FR31_Fri, 31 Oct 2003 10:31:40 +0100319_us-ascii Apologies for posting a question which I suspect has been asked in the past, but I can't access the archives at the moment .......
In the case of an ambiguous cursor, does DB2 take a page lock for rows which satisfy all indexable predicates but do not satisfy one or more non-indexable predicates? [...]
5497 15 74_Re: DB2 on OS/390 - page lock on non-qualifying row with ambiguous cursor?0_16_mscarpa@CESVE.IT31_Fri, 31 Oct 2003 11:00:04 +0100715_us-ascii Which CURRENTDATA do you have ? I presume you've isolation CS.
############################################################# Welcome to the IDUG DB2-L list. To change your subscription options or subscribe or to cancel your subscription, visit the IDUGDB2-L webpage at http://www.idugdb2-l.org/adminscripts/wa.exe?REPORT&Z=3. WE URGE YOU TO USE THE WEB page but if you can't then send commands to the list as follows: To UNSUBSCRIBE send the UNSUBSCRIBE DB2-L command to listserv@www.idugdb2-l.org and to set yourself to use DIGEST mode or NOMAIL send the SET DB2-L DIGEST or SET DB2-L NOMAIL command to listserv@www.idugdb2-l.org. Only send one command at a time.The owners of the list can be [...]
5513 35 74_Re: DB2 on OS/390 - page lock on non-qualifying row with ambiguous cursor?0_26_Moira.LANGLEY@CA-DIALOG.FR31_Fri, 31 Oct 2003 11:06:22 +0100759_us-ascii Yes - isolation CS on all the packages/plans concerned.
Pour : DB2-L@WWW.IDUGDB2-L.ORG cc : Objet : Re: DB2 on OS/390 - page lock on non-qualifying row with ambiguous cursor?
Which CURRENTDATA do you have ? I presume you've isolation CS.
############################################################# Welcome to the IDUG DB2-L list. To change your subscription options or subscribe or to cancel your subscription, visit the IDUGDB2-L webpage at http://www.idugdb2-l.org/adminscripts/wa.exe?REPORT&Z=3. WE URGE YOU TO USE THE WEB page but if you can't then send commands to the list as follows: To UNSUBSCRIBE send the UNSUBSCRIBE DB2-L command to listserv@www.idugdb2-l.org and to set yourself to use [...]
5549 37 74_Re: DB2 on OS/390 - page lock on non-qualifying row with ambiguous cursor?0_26_Moira.LANGLEY@CA-DIALOG.FR31_Fri, 31 Oct 2003 11:08:16 +0100383_us-ascii Yes - isolation CS on all the packages/plans concerned and CURRENTDATA(NO).
Sorry for the previous abbreviated reply - hit 'send' by mistake!
Pour : DB2-L@WWW.IDUGDB2-L.ORG cc : Objet : Re: DB2 on OS/390 - page lock on non-qualifying row with ambiguous cursor?
Which CURRENTDATA do you have ? I presume you've isolation CS. [...]
5587 58 15_Re: PIT Recover12_Isaac Yassin20_yassini@BEZEQINT.NET31_Fri, 31 Oct 2003 12:07:11 +0200298_- Hi,
Few days before the big cut-over to IDUG-L I've posted on the document list a REXX called READLOGP that will help you to analyze the SYSSUMMRY file from DSN1LOGP to find a "good" PIT to recover to. The REXX is generating 5 reports + a HELP in order to facilitate an easier usage. [...]
5646 22 74_Re: DB2 on OS/390 - page lock on non-qualifying row with ambiguous cursor?0_27_walter.janissen@VICTORIA.DE31_Fri, 31 Oct 2003 04:31:06 -0500412_- Moira
As you said, the application is bound with isolation CS and Currentdata NO, the Lock Avoidance algorithm will be applied and that means, that DB2 will avoid a lock, if it is safe, that the row was not updated. Because an application holds an X lock on that page, only the punc bit could tell DB2, that a lock is not necessary. But DB2 requests a lock, so I conclude, that the punc bit is on. [...]
5669 156 75_Re: DB2 on OS/390 - page lock on non-qualifying row with ambiguou s cursor?14_Dash, Sushanta21_sushanta.dash@EDS.COM31_Fri, 31 Oct 2003 05:08:31 -0600620_iso-8859-1 Hi Moira, from the current data no and isolation level cs it is sure that lock avoidance would take place. For ambiguous select statement to have lock avoidance work fine the following options hold good. ACQUIRE(USE), RELEASE(DEALLOCATE), ISLVL(CS) and CURRENTDATA(NO). This lock avoidance works fine with release(deallocate) if the intent of the program is read only. As you have mentioned that only few programs is the cause of time out , check for that particular program to see whether the intent is read only. If that is the case then release(deallocate) would work fine. If you have any updates or [...]
5826 27 74_Re: DB2 on OS/390 - page lock on non-qualifying row with ambiguous cursor?0_16_mscarpa@CESVE.IT31_Fri, 31 Oct 2003 12:25:12 +0100437_us-ascii Hi
With isolation CS and CURRENTDATA=NO (for ambiguous/unambiguous read-only cursors) the lock (conditional lock) must be taken because CS doesn't admit uncommitted data and doesn't want 'dirty' pages (Bonnie Baker dixit) even if no rows qualify. With UR BIND parameter you might avoid (if it's possible) it as the lock evauation is done at an 'higher' level (with Bonnie Baker's And Terrizzano's flows in my mind). [...]
5854 27 74_Re: DB2 on OS/390 - page lock on non-qualifying row with ambiguous cursor?0_26_Moira.LANGLEY@CA-DIALOG.FR31_Fri, 31 Oct 2003 14:22:16 +0100570_us-ascii Many thanks for the prompt replies ........ looks like I need to either press for them to evaluate the use of WITH UR for this cursor or else find a way to force the cursor access via the partitioning index without killing the performance. (Dash, release deallocate isn't an option as these jobs need to run in parallel and they all update at some stage Max, if I bind the package WITH UR then I affect every select/fetch in the whole application for this tablespace. I'm not confident we understand the processing well enough to judge whether or not it's [...]
5882 94 36_Re: Guidelines for Stored Procedures0_26_Phil.Sevetson@WAKEFERN.COM31_Fri, 31 Oct 2003 08:57:48 -0500455_us-ascii I don't believe we use subroutines at all, when DB2 access is occurring. We get better source control and simpler compiles by using stored procedures.
--Phil Sevetson phil.sevetson@wakefern.com Database Administration Wakefern Food Corporation
DPetro@AOL.COM Sent by: DB2 Data Base Discussion List 10/30/2003 09:07 PM Please respond to DB2 Database Discussion list at IDUG [...]
5977 28 74_Re: DB2 on OS/390 - page lock on non-qualifying row with ambiguous cursor?0_16_mscarpa@CESVE.IT31_Fri, 31 Oct 2003 14:59:15 +0100349_us-ascii Hi Moira
Yes of course BIND parameter UR affects the whole package. I suggested it as you said that WITH UR is difficult to implement in a 3rd party application and in any case this must be agreed with the programmer who made the application. I completely agree with you that WITH UR in fetches/select has a better granularity. [...]
6006 73 36_Re: Guidelines for Stored Procedures15_Diana Shemenski20_dshemenski@WMATA.COM31_Fri, 31 Oct 2003 09:24:40 -0500460_US-ASCII ** Proprietary **
Please remove me from your BLIND COPY sent to the DB2-L list.
I am getting everyone's email to the DB2-L list because somehow they (the List people) messed up and put me as a BLIND COPY (BC). Thanks
>>> Phil.Sevetson@WAKEFERN.COM 10/31/2003 8:57:48 AM >>> I don't believe we use subroutines at all, when DB2 access is occurring. We get better source control and simpler compiles by using stored procedures. [...]
6080 96 36_Re: Guidelines for Stored Procedures0_24_lightsey@ITS.STATE.MS.US31_Fri, 31 Oct 2003 08:36:26 -0600394_us-ascii We generally us stored procedures - 95% + of our applications are distributed or web-based in some combination of PowerBuilder, VB, Java, C , ???. It is much more reasonable to code the common stuff as a SP then have the programmers use that instead of re-inventing the wheel in a new language on a new platform each time. Our DB2s are v6 on z/OS and v7.2 on AIX , Linux, and M$. [...]
6177 117 16_Trigger Question11_David Nance16_DWNance@FHSC.COM31_Fri, 31 Oct 2003 09:37:15 -0500458_US-ASCII Can't get past a -104 on the create of a trigger. I'm trying to create a Before Insert trigger on a table. I want to populate a column in the table with the value from a column in another table. Here's the general SQL that I'm using:
CREATE TRIGGER DB2Q85.T85CP671 NO CASCADE BEFORE INSERT ON TABLE1 REFERENCING NEW AS NEW FOR EACH ROW MODE DB2SQL BEGIN ATOMIC SET NEW.COL5 = (SELECT T2.COL5 FROM TABLE2 T2 WHERE T2.KEY = NEW.KEY) ; END [...]
6295 66 20_Re: Trigger Question0_25_antoine.michielse@UBS.COM31_Fri, 31 Oct 2003 15:54:47 +0100584_iso-8859-1 David,
Are you using a SQL delimiter different from ';' ?
(see manuals for details)
Toine -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of David Nance Sent: Freitag, 31. Oktober 2003 15:37 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Trigger Question
Can't get past a -104 on the create of a trigger. I'm trying to create a Before Insert trigger on a table. I want to populate a column in the table with the value from a column in another table. Here's the general SQL that I'm using: [...]
6362 89 20_Re: Trigger Question14_Peter Backlund21_pbacklu@ATTGLOBAL.NET31_Fri, 31 Oct 2003 15:54:45 +0100
6452 14 20_Re: Trigger Question0_27_walter.janissen@VICTORIA.DE31_Fri, 31 Oct 2003 09:09:31 -0500729_- Dave
I think, you cannot use a SELECT-statement in a SET-clause. Look up SQL Reference for the syntax of the SET transition variable.
############################################################# Welcome to the IDUG DB2-L list. To change your subscription options or subscribe or to cancel your subscription, visit the IDUGDB2-L webpage at http://www.idugdb2-l.org/adminscripts/wa.exe?REPORT&Z=3. WE URGE YOU TO USE THE WEB page but if you can't then send commands to the list as follows: To UNSUBSCRIBE send the UNSUBSCRIBE DB2-L command to listserv@www.idugdb2-l.org and to set yourself to use DIGEST mode or NOMAIL send the SET DB2-L DIGEST or SET DB2-L NOMAIL command to listserv@www.idugdb2-l.org. Only [...]
6467 88 20_Re: Trigger Question0_28_fred_jaschick@PEOPLESOFT.COM31_Fri, 31 Oct 2003 10:00:07 -0500458_us-ascii David,
I believe the semicolon is only required if you have multiple SQL's in the ATOMIC statement.
Fred Jaschick PeopleSoft 877-339-9858 ''If man could have half his wishes, he would double his troubles.'' - Benjamin Franklin
"David Nance" cc: Sent by: "DB2 Subject: Trigger Question Data Base Discussion List" [...]
6556 228 20_Re: Trigger Question11_David Nance16_DWNance@FHSC.COM31_Fri, 31 Oct 2003 10:09:45 -0500558_US-ASCII Yes. We're using a ~. The trigger is failing with a -104 at the column being selected. Thanks.
Dave Nance First Health Services, Corp. (804)527-6841
>>> antoine.michielse@UBS.COM 10/31/03 9:54:47 AM >>> David,
Are you using a SQL delimiter different from ';' ?
(see manuals for details)
Toine -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of David Nance Sent: Freitag, 31. Oktober 2003 15:37 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Trigger Question [...]
6785 111 8_Re: test12_Bob Galeotti22_bgaleotti@SOFTBASE.COM31_Fri, 31 Oct 2003 10:03:16 -0500673_iso-8859-1 got it ----- Original Message ----- From: Phil Gunning Newsgroups: bit.listserv.db2-l To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Sunday, October 26, 2003 4:58 PM Subject: test
This is a test post. Please please reply to me if you received it. Thanks, Phil
Philip K. Gunning Check out the latest tips at the DB2 ZONE http://www.gunningts.com/db2zone.htm The world leader in DB2 UDB Consulting. 1.888.241.1070 Associate List Owner DB2-L IDUG NA 2004 Ast.Co- Conference Chair IBM Certified Advanced Technical Expert DB2 Clusters & DRDA http://www.amazon.com/exec/obidos/ASIN/0130661112/qid=1047537798/sr=2-2/ref=sr_2_2/002-8474274-1422405 [...]
6897 83 41_Check out some new entries on the DB2ZONE12_Phil Gunning22_pgunning@GUNNINGTS.COM31_Fri, 31 Oct 2003 10:39:49 -0500685_iso-8859-1 Subscribers, Based on my recent attendance at the IBM Datamanagement Conference which ends today, I thought I'd offer some thoughts for those of you that may not have made it. Check out the DB2ZONE for some new interesting products and papers, and some book referrals. Cheers, Phiil
Philip K. Gunning Check out the latest tips at the DB2 ZONE http://www.gunningts.com/db2zone.htm The world leader in DB2 UDB Consulting. 1.888.241.1070 Associate List Owner DB2-L IDUG NA 2004 Ast.Co- Conference Chair IBM Certified Advanced Technical Expert DB2 UDB V8 http://www.amazon.com/exec/obidos/ASIN/0130661112/qid=1047537798/sr=2-2/ref=sr_2_2/002-8474274-1422405 [...]
6981 19 22_Performance Monitoring16_Carole Rivington26_carole.rivington@EMPIRE.CA31_Fri, 31 Oct 2003 10:50:13 -0500733_- Hi,
Do any of you have any opinions or suggestions on the best performance monitoring tool for DB2 for OS390 ?
Thanks, Carole Rivington
############################################################# Welcome to the IDUG DB2-L list. To change your subscription options or subscribe or to cancel your subscription, visit the IDUGDB2-L webpage at http://www.idugdb2-l.org/adminscripts/wa.exe?REPORT&Z=3. WE URGE YOU TO USE THE WEB page but if you can't then send commands to the list as follows: To UNSUBSCRIBE send the UNSUBSCRIBE DB2-L command to listserv@www.idugdb2-l.org and to set yourself to use DIGEST mode or NOMAIL send the SET DB2-L DIGEST or SET DB2-L NOMAIL command to listserv@www.idugdb2-l.org. [...]
7001 50 74_Re: DB2 on OS/390 - page lock on non-qualifying row with ambiguous cursor?0_26_Moira.LANGLEY@CA-DIALOG.FR31_Fri, 31 Oct 2003 17:00:50 +0100330_us-ascii Hi Max
I sympathise - having to trundle backwards and forwards to the supplier is one of the most frustrating aspects of this problem. If we even had access to the source code of this program I'm sure we'd have made better progress. As it is, it's really difficult to get a clear picture of what's happening. [...]
7052 65 41_DB2 Records Manager consulting assignment9_Ken Paris22_KenParis@AUSTIN.RR.COM31_Fri, 31 Oct 2003 09:53:31 -0800305_iso-8859-1 I posted this to the old server - I apologize if this is a duplicate.
A friend of mine has been asked to find someone with "DB2 Records Manager" expertise for a 6 month contract in the Chicago area. If you qualify and are interested, let me know and I'll put you in touch with her. [...]
7118 111 26_Re: Performance Monitoring0_26_Phil.Sevetson@WAKEFERN.COM31_Fri, 31 Oct 2003 11:09:15 -0500451_us-ascii BMC MainView, (CA-?)Omegamon, CA-Insight, Boole & Babbage, take your pick. Quest has a recent offering which claims to do 'bout everything including Windows. Dunno about other vendors.
If you're looking particularly for application-level monitoring, rather than subsystem-level, you should also consider Compuware STROBE for DB2.
--Phil Sevetson phil.sevetson@wakefern.com Database Administration Wakefern Food Corporation [...]
7230 49 26_Re: Performance Monitoring8_Ron Root24_ron.root@CPA.STATE.TX.US31_Fri, 31 Oct 2003 10:21:15 -0600516_iso-8859-1 Carole, DB2 subsystem or DB2 application performance monitoring? Really two different tools. I use BMC's APPTUNE every day for monitoring application/SQL performance and love it. I have seen or used about every tool on the market and like APPTUNE the best.
Ron Root
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of Carole Rivington Sent: Friday, October 31, 2003 9:50 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Performance Monitoring [...]
7280 14 12_DB2-L nomail8_Ward Fry12_fryw@USA.NET31_Fri, 31 Oct 2003 12:48:00 -0500705_ISO-8859-1 DB2-L nomail
############################################################# Welcome to the IDUG DB2-L list. To change your subscription options or subscribe or to cancel your subscription, visit the IDUGDB2-L webpage at http://www.idugdb2-l.org/adminscripts/wa.exe?REPORT&Z=3. WE URGE YOU TO USE THE WEB page but if you can't then send commands to the list as follows: To UNSUBSCRIBE send the UNSUBSCRIBE DB2-L command to listserv@www.idugdb2-l.org and to set yourself to use DIGEST mode or NOMAIL send the SET DB2-L DIGEST or SET DB2-L NOMAIL command to listserv@www.idugdb2-l.org. Only send one command at a time.The owners of the list can be reached at DB2-L-REQUEST@www.idugdb2-l.org.
7295 158 45_Re: Check out some new entries on the DB2ZONE14_Jacques SAMBUC22_jsam.prof.serv@FREE.FR31_Fri, 31 Oct 2003 18:51:05 +0100468_iso-8859-1 Phil,
Life was all right until you laid your clumsy hands on DB2-L ... now enough is enough ! I keep setting my options to "nomail", and you keep resetting it to "mail". Could you get back where you belong ?
-----Message d'origine----- De: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]De la part de Phil Gunning Date: vendredi 31 octobre 2003 16:40 À: DB2-L@WWW.IDUGDB2-L.ORG Objet: Check out some new entries on the DB2ZONE [...]
7454 12 7_no mail0_27_vasant.n.parmar@VERIZON.COM31_Fri, 31 Oct 2003 10:01:23 -0800676_- ############################################################# Welcome to the IDUG DB2-L list. To change your subscription options or subscribe or to cancel your subscription, visit the IDUGDB2-L webpage at http://www.idugdb2-l.org/adminscripts/wa.exe?REPORT&Z=3. WE URGE YOU TO USE THE WEB page but if you can't then send commands to the list as follows: To UNSUBSCRIBE send the UNSUBSCRIBE DB2-L command to listserv@www.idugdb2-l.org and to set yourself to use DIGEST mode or NOMAIL send the SET DB2-L DIGEST or SET DB2-L NOMAIL command to listserv@www.idugdb2-l.org. Only send one command at a time.The owners of the list can be reached at DB2-L-REQUEST@www.idugdb2-l.org.
7467 275 45_Re: Check out some new entries on the DB2ZONE13_Mark A. Doyle19_mdoyle@JCPENNEY.COM31_Fri, 31 Oct 2003 12:51:53 -0600507_- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. [...]
7743 112 45_Re: Check out some new entries on the DB2ZONE0_25_antoine.michielse@UBS.COM31_Fri, 31 Oct 2003 20:08:05 +0100617_iso-8859-1 hear hear!!!!! Toine -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of Mark A. Doyle Sent: Freitag, 31. Oktober 2003 19:52 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: Check out some new entries on the DB2ZONE
Jacques, If the recent bobbles with the list-serv are all it takes to have your LIFE be not all right, then I feel very sorry for you. But that is still not an excuse for you to abuse Phil. You write as though Phil is doing it to you personally. STOP IT! I've watched the whining with amusement, but when it turns to abuse, I [...]
7856 67 14_Trace Question9_D Brunner20_brunnerd@COMCAST.NET31_Fri, 31 Oct 2003 13:56:42 -0500462_iso-8859-1 We're currently collecting SMF101 records (classes: 1,2,3,7,8), with the trace data being sent to OPn (the trace is started automatically via a DB2 monitor). If an exact same trace is started, with the only difference being that the data is now sent to SMF, has the overhead essentially doubled by setting the second trace? or being that the exact same data is already captured by the first trace, some of the overhead is shared between the two? [...]
7924 20 10_Re: nomail9_Oliver Su14_ojsu@EMAIL.COM31_Fri, 31 Oct 2003 11:02:30 -0800
7945 382 45_Re: Check out some new entries on the DB2ZONE19_Jardine, Lawrence J19_JardineLJ@AETNA.COM31_Fri, 31 Oct 2003 14:11:54 -0500452_iso-8859-1
I vote to ban this guy(?) from the list forever.
Larry
-----Original Message----- From: Jacques SAMBUC [mailto:jsam.prof.serv@FREE.FR] Sent: Friday, October 31, 2003 12:51 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: Check out some new entries on the DB2ZONE
Phil,
Life was all right until you laid your clumsy hands on DB2-L ... now enough is enough ! [...]
8328 211 45_Re: Check out some new entries on the DB2ZONE0_17_sjvagnier@AEP.COM31_Fri, 31 Oct 2003 14:15:34 -0500575_iso-8859-1 I agree totally with Mark's comments. This should not be a forum for personal attacks against anybody, let alone a DB2-L administrator.
**************************************** Steve Vagnier American Electric Power Data Services One Riverside Plaza Columbus, Ohio 43215 Email: sjvagnier@aep.com Phone: 614-716-3677 Audinet: 200-3677
"Mark A. Doyle" cc: Sent by: DB2 Data Subject: Re: Check out some new entries on the DB2ZONE Base Discussion List [...]
8540 347 45_Re: Check out some new entries on the DB2ZONE15_Perumal, Kannan22_kannan.perumal@EDS.COM31_Fri, 31 Oct 2003 13:15:39 -0600574_iso-8859-1 First of all you need to wake up from your sleep and set yourself in a conscious state then read the instruction correctly. Phil and his fellow buddies behind the list worked hundreds of hours making the move, it is not just like the way you move your laptop from home to office. Real hard work which many people can understand but still only a few can volunteer under their busy schedule. You don't need to appreciate them but without knowing anything you should not hurt them by your words. Please read the UPPERCASE statement and respond properly: If you [...]
8888 295 45_Re: Check out some new entries on the DB2ZONE12_Mark Granger22_the_grange@MBOX.COM.AU31_Fri, 31 Oct 2003 15:11:34 -0400339_us-ascii I don't know the stats, but I feel certain the 'silent' majority appreciate the time and effort and understand from previous experience that '..it happens' when changes occur.
Anyway Phil and all associated with DB2-L both past and present, I, and I believe a lot of others, do appreciate your commitment and efforts. [...]
9184 391 45_Re: Check out some new entries on the DB2ZONE12_Bob Galeotti22_bgaleotti@SOFTBASE.COM31_Fri, 31 Oct 2003 14:34:26 -0500356_iso-8859-1 Here here. We are all just frail little creatures enjoying each others' company in this dimension. Talk about ugly Americans, SHEESH!
Bob Galeotti ----- Original Message ----- From: Mark A. Doyle Newsgroups: no To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Friday, October 31, 2003 1:51 PM Subject: Re: Check out some new entries on the DB2ZONE [...]
9576 13 16_Re: DB2-L nomail14_Moran, William21_William_Moran@BMC.COM31_Fri, 31 Oct 2003 13:26:54 -0600705_iso-8859-1 DB2-L nomail
############################################################# Welcome to the IDUG DB2-L list. To change your subscription options or subscribe or to cancel your subscription, visit the IDUGDB2-L webpage at http://www.idugdb2-l.org/adminscripts/wa.exe?REPORT&Z=3. WE URGE YOU TO USE THE WEB page but if you can't then send commands to the list as follows: To UNSUBSCRIBE send the UNSUBSCRIBE DB2-L command to listserv@www.idugdb2-l.org and to set yourself to use DIGEST mode or NOMAIL send the SET DB2-L DIGEST or SET DB2-L NOMAIL command to listserv@www.idugdb2-l.org. Only send one command at a time.The owners of the list can be reached at DB2-L-REQUEST@www.idugdb2-l.org.
9590 464 45_Re: Check out some new entries on the DB2ZONE15_McClendon, Rick24_RMcClendon@ADMIN.FSU.EDU31_Fri, 31 Oct 2003 14:44:07 -0500486_us-ascii I'll second the motion..... All in favor, say "I".... *The crowd sends a resounding *I* through the far-reaching routers of the world*
Motion Approved!
Dude - You are a really good bad example...
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jardine, Lawrence J Sent: Friday, October 31, 2003 2:12 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: Check out some new entries on the DB2ZONE [...]
10055 108 30_Plans & Packages for BMC Tools13_Michael Ebert18_mebert@AMADEUS.NET31_Fri, 31 Oct 2003 21:23:19 +0100326_us-ascii Hi list,
to help you get back to DB2 things: in preparation for the upcoming DB2 V7 migration & Cat/Dir REORG, I wanted to clean up some of the 33.000 packages in our test ssid. The intended victim is old versions of BMC tools. Currently we have DASD Mgr Plus 6.1.03 Catalog Mgr 7.1.01 Change Mgr 7.1.01E [...]
10164 48 45_Re: Check out some new entries on the DB2ZONE0_22_DB2information@AOL.COM29_Fri, 31 Oct 2003 15:36:02 EST729_US-ASCII Phil, You are doing a great job, most of us appreciate your hard work. Also I would like to think you for adding our link to your DB2ZONE.
Recovery Knowledge The DB2 Disaster Recovery People www.recoveryknowledge.com
############################################################# Welcome to the IDUG DB2-L list. To change your subscription options or subscribe or to cancel your subscription, visit the IDUGDB2-L webpage at http://www.idugdb2-l.org/adminscripts/wa.exe?REPORT&Z=3. WE URGE YOU TO USE THE WEB page but if you can't then send commands to the list as follows: To UNSUBSCRIBE send the UNSUBSCRIBE DB2-L command to listserv@www.idugdb2-l.org and to set yourself to use DIGEST mode or NOMAIL [...]
10213 358 45_Re: Check out some new entries on the DB2ZONE13_Hougrand, Rob21_HougrandRW1@AETNA.COM31_Fri, 31 Oct 2003 15:30:59 -0500513_iso-8859-1 well done. -----Original Message----- From: Jardine, Lawrence J Sent: Friday, October 31, 2003 2:12 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: Check out some new entries on the DB2ZONE
I vote to ban this guy(?) from the list forever.
Larry
-----Original Message----- From: Jacques SAMBUC [mailto:jsam.prof.serv@FREE.FR] Sent: Friday, October 31, 2003 12:51 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: Check out some new entries on the DB2ZONE [...]
10572 234 34_Re: Plans & Packages for BMC Tools10_Bob Riehle18_BOB.RIEHLE@DHL.COM31_Fri, 31 Oct 2003 12:33:44 -0800617_iso-8859-1 Dr Ebert, The nullid collection is set up when you install DB2 connect. BOb
-----Original Message----- From: Michael Ebert [mailto:mebert@AMADEUS.NET] Sent: Friday, October 31, 2003 12:23 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Plans & Packages for BMC Tools
Hi list,
to help you get back to DB2 things: in preparation for the upcoming DB2 V7 migration & Cat/Dir REORG, I wanted to clean up some of the 33.000 packages in our test ssid. The intended victim is old versions of BMC tools. Currently we have DASD Mgr Plus 6.1.03 Catalog Mgr 7.1.01 Change Mgr 7.1.01E [...]
10807 18 43_Test of Out of Office agent - please ignore0_26_Steve.Westfall@EQUIFAX.COM31_Fri, 31 Oct 2003 15:39:51 -0500723_US-ASCII I will be out of the office starting 10/31/2003 and will not return until 11/03/2003.
This is only a test. Please ignore this message.
Steve Westfall
############################################################# Welcome to the IDUG DB2-L list. To change your subscription options or subscribe or to cancel your subscription, visit the IDUGDB2-L webpage at http://www.idugdb2-l.org/adminscripts/wa.exe?REPORT&Z=3. WE URGE YOU TO USE THE WEB page but if you can't then send commands to the list as follows: To UNSUBSCRIBE send the UNSUBSCRIBE DB2-L command to listserv@www.idugdb2-l.org and to set yourself to use DIGEST mode or NOMAIL send the SET DB2-L DIGEST or SET DB2-L NOMAIL command [...]
10826 19 43_Test of Out of Office agent - please ignore0_26_Steve.Westfall@EQUIFAX.COM31_Fri, 31 Oct 2003 15:41:48 -0500727_US-ASCII I will be out of the office starting 10/31/2003 and will not return until 11/03/2003.
This is a test to verify that the Notes Out of Office agent is NOT replying to Internet email addresses. Please ignore this message.
Steve Westfall
############################################################# Welcome to the IDUG DB2-L list. To change your subscription options or subscribe or to cancel your subscription, visit the IDUGDB2-L webpage at http://www.idugdb2-l.org/adminscripts/wa.exe?REPORT&Z=3. WE URGE YOU TO USE THE WEB page but if you can't then send commands to the list as follows: To UNSUBSCRIBE send the UNSUBSCRIBE DB2-L command to listserv@www.idugdb2-l.org and to set yourself to [...]
10846 133 45_Re: Check out some new entries on the DB2ZONE0_20_ravi.reddy@PS.GE.COM31_Fri, 31 Oct 2003 15:50:49 -0500453_ISO-8859-1 Yes Phil,
We appreciate your efforts and dedication to this List. Janis and Yourself are doing good job ! Some mails must be disturbing, but dont let them get you down !
We support you !
Rgds, Ravi.
-----Original Message----- From: DB2information@AOL.COM [mailto:DB2information@AOL.COM] Sent: Friday, October 31, 2003 3:36 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: Check out some new entries on the DB2ZONE [...]
10980 199 45_Re: Check out some new entries on the DB2ZONE0_22_BRIAN_GOLDBERG@QVC.COM31_Fri, 31 Oct 2003 15:59:15 -0500423_iso-8859-1 It must be hard being perfect. I wouldn't know from personal experience.
"Hougrand, Rob" cc: (bcc: BRIAN GOLDBERG/QVC) Ext: Subject: Re: Check out some new entries on the DB2ZONE Sent by: DB2 Data Base Discussion List
10/31/2003 03:30 PM Please respond to DB2 Database Discussion list at IDUG [...]
11180 305 45_Re: Check out some new entries on the DB2ZONE12_Weigend, Don17_DWeigend@WBMI.COM31_Fri, 31 Oct 2003 14:56:36 -0600511_us-ascii I second this!!!
Don Weigend
DB2 OS/390 Sysprog
IBM Certified Solutions Expert - DB2 V7 Database Administration OS/390
West Bend Mutual Insurance Company
-----Original Message----- From: Jardine, Lawrence J [mailto:JardineLJ@AETNA.COM] Sent: Friday, October 31, 2003 1:12 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: Check out some new entries on the DB2ZONE
I vote to ban this guy(?) from the list forever. [...]
11486 272 45_Re: Check out some new entries on the DB2ZONE12_HEPP SHERY C17_schepp@SRPNET.COM31_Fri, 31 Oct 2003 14:01:57 -0700447_iso-8859-1 I agree- this list has helped me numerous times in the past- a big thanks to all of the people and hard work they've put into providing this service to the list serve members.
Regards, Shery
-----Original Message----- From: DB2information@AOL.COM [mailto:DB2information@AOL.COM] Sent: Friday, October 31, 2003 1:36 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: Check out some new entries on the DB2ZONE [...]
11759 130 36_Re: Guidelines for Stored Procedures14_Timothy Curley26_timothy_curley@HOTMAIL.COM31_Fri, 31 Oct 2003 14:22:07 -0700410_- If there is a chance that you require access to the data outside your base application or if your application is distributed then stored procedures can reduce network traffic and simplify coding.
If your application is completly contained with no hope of ever making calls to the data from outside the application, then subroutines would make more sense. Not many applications like this anymore. [...]
11890 23 24_Attn: DB2-L Digest users14_Gill, Joseph G19_joseph.gill@EDS.COM31_Fri, 31 Oct 2003 16:30:35 -0500422_- If you use Outlook (not Outlook Express!) as your mail client,(this may work for other mail clients, but I don't know), You may want to look at setting the MIME option also, on this list. By default it is set OFF.
Set to OFF, you get one long message of all the messages, with an 'index' at the front. Set to ON, you get a message containing 1 message for each message posted, plus 1 message with the index. [...]
11914 300 45_Re: Check out some new entries on the DB2ZONE17_Schlueter, Edward35_Edward.Schlueter@ANHEUSER-BUSCH.COM31_Fri, 31 Oct 2003 15:31:34 -0600511_US-ASCII Since it's not clear from the context, who are you voting to ban? Would it be Phil, who is apparently modifying profiles in order to advertise his consulting business and Web site; or would it be Jacques, who is complaining about Phil's actions?
I have variously had my profile set for DIGEST or NOMAIL, and now it has been set to MAIL without any action on my part. The first item I received was Phil's announcement about the DB2ZONE on Phil's site, along with Phil's mail signature, etc. [...]
12215 21 12_Connect Time13_Horacio Villa17_hvilla@AR.IBM.COM31_Fri, 31 Oct 2003 16:31:22 -0500366_US-ASCII Hi everybody,
I have a DRDA connection from OS/390 DB2 V5 to AIX DB2 V7.1 working OK. But whenever the AIX server goes down, the response time for a CONNECT (in a program running on CICS) is about 3 minutes. Is there any parameter on ZPARM to check, or what can I do to have a quicker response time in this situation? Thanks in advance, Horacio [...]
12237 178 45_Re: Check out some new entries on the DB2ZONE0_26_Phil.Sevetson@WAKEFERN.COM31_Fri, 31 Oct 2003 17:04:47 -0500346_us-ascii With an attitude/manners like that, he doesn't have to bother applying for a job in any organization I'll ever work for. Openly insulting colleagues is unacceptable behavior in any team environment.
Besides, moving a mailing list from one host to another _is_ Rocket Science. There's probably some black magic involved, too. [...]
12416 25 9_Apologies0_26_Steve.Westfall@EQUIFAX.COM31_Fri, 31 Oct 2003 16:19:03 -0600379_US-ASCII I wish to apologize for the "Test of Out-of-Office agent" messages that were sent to the list today. My tech support person told me that they had fixed Lotus Notes so that when I tell my Out-of-Office agent NOT to reply to Internet addresses, it will not reply to Internet addresses. Obviously, he was incorrect, and it's still replying to email from the Internet. [...]
12442 169 18_Re: Trace Question12_michael bell24_mbell11@WORLDNET.ATT.NET31_Fri, 31 Oct 2003 16:40:33 -0600351_iso-8859-1 A question from listserv that I can answer with the usual answer - it depends.
The overhead of collecting the trace data only occurs once. That overhead is part of the TCB processing of the application.
The overhead of sending the DB2 data to SMF will be a new cost and will be added to the TCB time for the application. [...]
12612 167 47_Re: Plans & Packages for BMC Tools - and NULLID13_Michael Ebert18_mebert@AMADEUS.NET30_Sat, 1 Nov 2003 01:52:23 +0100414_us-ascii Hi Bob, yes I know that. But we've got 157 packages in this collection in the maintenance system, 676 (!) in Test/Dev, between 64 and 75 on the SAP ssids, and 326 in Prod... why these differences? Is it an indicator of different usage of DB2 Connect on these systems? And are really all of these packages needed, or do we again have leftovers from previous installs? If yes, how do I identify these? [...]
12780 107 18_Object Access Info0_23_IDeutsch@SUNAMERICA.COM31_Fri, 31 Oct 2003 16:47:55 -0800400_ISO-8859-1 Hi guys,
Unfortunately I'll be sunsetting my system and I need to understand what objects are being accessed. Yes, that's all. Not how much or how well it is being accessed, but just that it IS being accessed. The feeling is that there are large tables that may not be accessed anymore, and can be dispensed with (or at least archived), when we send the system across country. [...]
12888 187 23_A Bit of An Explanation12_Phil Gunning22_pgunning@GUNNINGTS.COM30_Sat, 1 Nov 2003 00:24:09 -0500591_iso-8859-1 Dear Subscribers, In an attempt to keep the list going, it was migrated in a short period of time. When migrating lists things like digest and no mail do not come with the output from listserv software. After the initial migration, a bug with hyperthreading on the new W2k server and the list software was discovered, so I had to reinstall all the software again Thursday morning, and re-add all users with a batch job...so subscribers who we had unsubscribed after the initial migration became subscribed again. Also, in the past, many people have been set to NO MAIL which [...]