1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l October 2002, week 5
2 48 19_HOW TO USE DSNUTILS7_a00089621_a000896@MS.SKH.ORG.TW31_Tue, 29 Oct 2002 16:20:50 +0800138_big5 hi : list i want to use dsnutils utility, but i do'nt know how to use, can anyone provide cobol2 sample program call dsnutils
51 39 23_AW: HOW TO USE DSNUTILS12_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 29 Oct 2002 09:44:21 +0100436_big5 Hello a000896,
take a look at TSO/SPUFI and there the DB2 PRIMARY OPTION MENU. Under point 8 is the possibility to invoke DB2 utilities.
HTH.
With kind regards - mit freundlichen Gruessen, Georg H. Peter
---------------------------------------------------------------------- The crystal ball gets cloudier as we proceed into the future. (heard at the IBM laboratory in Boeblingen, Germany) [...]
91 16 18_DSNTEP2 substitute18_Di Franco Vincenzo22_difrancov@ISIDE.BCC.IT31_Tue, 29 Oct 2002 10:07:55 +0100407_iso-8859-1 Hi all, at my shop does not exist a PLI_COMPILER TO COMPILE DSNTEP2 SOURCE, so I'M SEARCHING FOR A FREE SUSTITUTE. THANK YOU IN ADVANCE. BYE
================================================ 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.
108 30 22_Re: DSNTEP2 substitute13_Schulz Thomas20_thomas.schulz@SVI.DE31_Tue, 29 Oct 2002 11:49:21 +0100578_us-ascii Hi Vincenzo
take a look on the following link
http://www.gseukdb2.org.uk/shareware.htm
Regards Thomas
Di Franco Vincenzo schrieb: > > Hi all, > at my shop does not exist a PLI_COMPILER TO COMPILE DSNTEP2 SOURCE, so I'M > SEARCHING FOR A FREE SUSTITUTE. > THANK YOU IN ADVANCE. BYE > > ================================================ > 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. [...]
139 18 24_UDB AIX CLOB performance13_Ealey, Paul M18_paul.ealey@EDS.COM31_Tue, 29 Oct 2002 10:48:40 -0000399_iso-8859-1 Can anyone point me to some reference material about CLOB performance on UDB AIX please.
Thank you.
Paul Ealey EDS, UK
================================================ 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.
158 23 44_Missing QMDA Section for DDF Work in SMF 10113_Martin Packer24_martin_packer@UK.IBM.COM31_Tue, 29 Oct 2002 11:03:08 +0000363_us-ascii Has anyone ever seen Accounting Trace (SMF 101) records for DDF (QWHCATYP = QWHCRUW or QWHCDUW) where there are no QMDA sections? This is for IFCID 3 so it's not a package overflow (IFCID 239) situation.
My only thought is that it could be for a client that doesn't provide any accounting information. But I wouldn't know what that would be. [...]
182 141 22_Re: DSNTEP2 substitute16_Tee, Christopher31_Christopher.Tee@LLOYDSTSB.CO.UK31_Tue, 29 Oct 2002 11:05:15 -0000514_iso-8859-1 Vincenzo
If you are on V6, job DSNTEJ1L in SDSNSAMP linkedits the provided object DSNTEP2L to create DSNTEP2 without requiring a PL/I compiler.
Chris
-----Original Message----- From: Di Franco Vincenzo [mailto:difrancov@ISIDE.BCC.IT] Sent: 29 October 2002 09:08 To: DB2-L@LISTSERV.YLASSOC.COM Subject: DSNTEP2 substitute
Hi all, at my shop does not exist a PLI_COMPILER TO COMPILE DSNTEP2 SOURCE, so I'M SEARCHING FOR A FREE SUSTITUTE. THANK YOU IN ADVANCE. BYE [...]
324 51 43_Re: Precompiler Warming - upgrade to error?0_19_mike.holmans@BT.COM31_Tue, 29 Oct 2002 12:02:10 -0000313_iso-8859-1 Aw, shucks. When I saw the Subject: line from our office where the heating doesn't work, I thought there might have been a software solution rather than the hardware-based pullovers and thermal underwear. After all, since DB2 can do basically anything, why shouldn't it warm up the office for us? [...]
376 17 43_Re: Precompiler Warming - upgrade to error?14_Clayton, Colin21_Colin_Clayton@BMC.COM31_Tue, 29 Oct 2002 06:20:08 -0600434_iso-8859-1 Hey Mike,
does that mean a bribe in the form of a warming alcoholic beverage would help to speed the conversion of my local exchange to broadband ?
Colin
================================================ 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.
394 54 27_Re: DB2 v7 DSNHADD2 problem13_Jeremiah Eden28_JEREMIAH.EDEN@RADIOSHACK.COM31_Tue, 29 Oct 2002 07:28:20 -0600458_- Maybe I'm lost on this one. ..OK, most of them. But I would think that putting on V7/UQ68370 would resolve your problem if you had put on V6/UQ58459. UQ68370 puts back DSNHADD2. What am I missing? If the V7 version is not compatible, then I would push harder for an APAR and start getting those account reps you pay $$$s involved. Tell them you can't go to V7 till this is fixed. And if you can't go to V7, then you can't go to V8 and get a Z/OS box. [...]
449 26 40_Bank One is Hiring DB2 Data Sharing Guru12_Glen Gardner24_glen_gardner@BANKONE.COM31_Tue, 29 Oct 2002 07:42:50 -0600574_- Sr. DB2 Systems Programmer (os/390) Full function Senior DB2 OS/390 systems programmer with in depth knowledge of DB2 running in a data sharing environment. Must be proficient with advanced DB2 internals. Key Responsibilities: DB2 subsystem and 3rd party software installation, maintenance and technical support in a complex environment. Provide in- depth consulting to management and staff at the highest technical level in identification and resolution of intricate DB2 system software problems. Perform advanced DB2 system design and performance tuning functions. [...]
476 74 33_Re: Mulitple Line Output in SPUFI13_Lockwood Lyon24_Lockwood.Lyon@MEIJER.COM31_Tue, 29 Oct 2002 09:41:21 -0500567_US-ASCII If I understand this correctly, the problem isn't simply to have the "generating" SQL statement create multiple lines; rather, it's to have the final results come out on multiple lines so that you can run it in SPUFI (which requires SQL statements between cols 1 and 72).
I do this as follows: I run my Generating SQL statement in SPUFI and have the resultant SQL statement be however long it comes out (perhaps several hundred bytes; doesn't matter). My output file record length is long enough to accomodate the length of the result statement. [...]
551 44 33_Re: Mulitple Line Output in SPUFI11_David Nance16_DWNance@FHSC.COM31_Tue, 29 Oct 2002 09:54:26 -0500268_US-ASCII Rob, Is QMF out of the question? We use it quite extensively as part of applications we sell to clients. Try to do all reporting with it and I use it quite a bit for making ddl changes, grants, etc.... Use of the query with forms really makes life easy. [...]
596 31 33_Re: Mulitple Line Output in SPUFI17_Robert J. Milonas20_XRJMBOB@NETSCAPE.NET31_Tue, 29 Oct 2002 10:22:41 -0500352_iso-8859-1 Rob, Are you running on a mainframe?????
>>>> rbadger@WPSIC.COM 10/28/02 4:03:33 PM >>> >I am trying to create a SPUFI to generate SQL statements. I need the >output from my SPUFI to produce 2 lines for each SLQ statement. I do >not >know how to get that to work. > >Thanks in advance for your help. > >Rob Badger >WPS Insurance [...]
628 116 33_Re: Mulitple Line Output in SPUFI13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Tue, 29 Oct 2002 10:58:02 -0500446_iso-8859-1 Years ago, I used to do something similar to what Lockwood describes. I wrote an ISPF Edit macro (Included below) to split the data records. See tutorial at end of this message.
I think the Union SQL statement method is more elegant and simpler.
Naturally, your mileage may vary. You might get no mileage at all. This is Dave-uware code, not Compuware. No warranty, no refunds; you get what you didn't pay for. etc. [...]
745 32 21_Lock on TEMP database15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Tue, 29 Oct 2002 14:53:16 -0500305_iso-8859-1 Once in a while we are getting a database lock on TEMP database by some client application. Once this happen nobody can create any declare global temporary tables. This cause most of our application to go down since we use lot of TEMP tables . Let me know if anybody has experienced this. [...]
778 121 28_Re: XML Data upload/download14_Sinha, Abhijit20_Abhijit.Sinha@GS.COM31_Tue, 29 Oct 2002 15:04:45 -0500394_iso-8859-1 Raja,
If you are still interested, this is something I came across and remembered that you wanted something similar.
REC2XML scalar function in UDB V7.2.
Say you have a table with 3 cols as below:
/home/sinhaab/SQLStuff:/> db2 "select * from halu"
COL_A COL_B COL_C ----------- ----------- ----------- 4 5 6 7 8 9
2 record(s) selected. [...]
900 27 14_DB2 UDB on AIX0_17_cflink@AWGINC.COM31_Tue, 29 Oct 2002 13:56:25 -0600309_us-ascii Esteemed List, My management has been asking if there are any utilities that can read the DB2 logs (UDB on AIX) and determine when a particular event has occurred.. I have perused the DB2 documentation and have come up empty... Does anyone out there know of something that can do this?????? TIA [...]
928 137 28_Re: XML Data upload/download12_Myron Miller22_myronwmiller@YAHOO.COM31_Tue, 29 Oct 2002 12:50:59 -0800544_us-ascii Abhijit, Do you know if this REC2XML function is available in OS/390 DB2 V7 as well? Or is it strictly a UDB function? --- "Sinha, Abhijit" wrote: > Raja, > > If you are still interested, this is something I came across and remembered > that you wanted something similar. > > REC2XML scalar function in UDB V7.2. > > Say you have a table with 3 cols as below: > > /home/sinhaab/SQLStuff:/> db2 "select * from halu" > > COL_A COL_B COL_C > ----------- ----------- ----------- > 4 5 6 > 7 8 9 > > 2 record(s) [...]
1066 170 28_Re: XML Data upload/download14_Sinha, Abhijit20_Abhijit.Sinha@GS.COM31_Tue, 29 Oct 2002 16:17:03 -0500696_iso-8859-1 Myron,
No, I didn't find this function for z/OS and OS/390. Only for UDB. Yet another difference !!!
Abhijit
-----Original Message----- From: Myron Miller [mailto:myronwmiller@YAHOO.COM] Sent: Tuesday, October 29, 2002 3:51 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: XML Data upload/download
Abhijit, Do you know if this REC2XML function is available in OS/390 DB2 V7 as well? Or is it strictly a UDB function? --- "Sinha, Abhijit" wrote: > Raja, > > If you are still interested, this is something I came across and remembered > that you wanted something similar. > > REC2XML scalar function in UDB V7.2. > > [...]
1237 21 39_Service Level Agreements and DB2 OS/39015_Connie Shockley26_connie.m.shockley@LMCO.COM31_Tue, 29 Oct 2002 15:22:02 -0600474_- I'm trying to find what other organizations are doing with SLAs and DB2. We currently are not doing any thing and have been asked to. Right now we report on CICS, TSO, etc response times less than so many seconds and a percentage.
For CICS/DB2 trans, the DB2 response would be a subset of the CICS time. I'm not sure what average batch response times would do for anyone. TSO time would include SPUFI, QMF and other vendor products, again I wonder about this. [...]
1259 54 18_Re: DB2 UDB on AIX4_Smit24_robert.erwin.smit@WXS.NL31_Tue, 29 Oct 2002 10:45:30 +0100425_iso-8859-1 Tia,
Tivoli (IBM product) and Patrol 2000 (BMC product) both have a db2 module to monitor db2 on AIX.
Perhaps one of these products can do the things you want.
Robert E. Smit ZeluS Support.
----- Original Message ----- From: Newsgroups: bit.listserv.db2-l To: Sent: Tuesday, October 29, 2002 8:56 PM Subject: DB2 UDB on AIX [...]
1314 97 18_Re: DB2 UDB on AIX9_Mark Ruhe19_mark.ruhe@QUEST.COM31_Tue, 29 Oct 2002 13:52:57 -0800394_iso-8859-1 I don't believe any third party vendors support a log analyzer at this time. IBM does have an API to read the log and the log record formats can be found in the manual. Unfortunately the API is difficult to use. Depending on the type of activity you are looking for, you might be able to use an event monitor. Perhaps you could send some details on what you are trying to find? [...]
1412 24 18_Re: DB2 UDB on AIX16_Ian D. Bjorhovde23_ianbjor@MOBILEAUDIO.COM31_Tue, 29 Oct 2002 14:58:01 -0700367_US-ASCII On Tue, 29 Oct 2002 cflink@AWGINC.COM wrote:
> Esteemed List, > My management has been asking if there are any utilities that can read the > DB2 logs (UDB on AIX) and determine when a particular event has occurred.. > I have perused the DB2 documentation and have come up empty... Does anyone > out there know of something that can do this?????? [...]
1437 52 18_Re: DB2 UDB on AIX16_APPACHAR Narayan28_Narayan.Appachar@STATE.OR.US31_Tue, 29 Oct 2002 14:29:08 -0800348_- We have UDB 7.2 on Solaris 5.8. We have an inhouse korn shell script which basically runs every hour and parses the db2diag.log file. If it finds any matching line in the pattern of DIA1003C ( First 3 characters DIA and rest any number/characters), it sends an email message to DBA's. It also keeps track of how many times an event occured. [...]
1490 60 42_Re: Instalation of DB2 on linux as service14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 30 Oct 2002 08:31:18 +1000583_US-ASCII I hope you get a better reply than this, 'cause I'm a Linux newbie and far from my system.
Firstly, each distribution has its own method of running stuff at startup. I use (when I use any) Red Hat.
(I'm going from memory from here on - so handle with care)
In /etc/init there are a series of directories rc.1, rc.2 etc. When Linux is started the files in the corresponding "runlevel" directory are processed. So when it starts in, say, runlevel 3, then the files in rc.3 are processed - in filename sequence. When linux stops they are reprocessed. [...]
1551 92 31_FW: Re: DB2 v7 DSNHADD2 problem10_Frank.John21_John.Frank@FTB.CA.GOV31_Tue, 29 Oct 2002 14:34:28 -0800310_iso-8859-1 We are on v7, now. Putting on UQ68370 fixed our problem by creating a new DSNHADD2 for v7. Our problem was that we weren't aware of UQ68370 at first and had some COBOL programs trying to call DSNHADD2.
We had a problem where UQ58460 was not applied because it was superseded by UQ62510. [...]
1644 92 27_Re: DB2 v7 DSNHADD2 problem10_Frank.John21_John.Frank@FTB.CA.GOV31_Tue, 29 Oct 2002 14:37:38 -0800310_iso-8859-1 We are on v7, now. Putting on UQ68370 fixed our problem by creating a new DSNHADD2 for v7. Our problem was that we weren't aware of UQ68370 at first and had some COBOL programs trying to call DSNHADD2.
We had a problem where UQ58459 was not applied because it was superseded by UQ62510. [...]
1737 81 33_Re: Help Need a Job for A DB2 DBA13_David S Waugh16_dsw-dba@JUNO.COM29_Tue, 29 Oct 2002 23:50:54 GMT545_- Willie Favero wrote: "Does anyone remember trying to run DB2 V1.1?"
I do - we (at an internal IBM plant site) got it several months before it went GA. Other Internal sites (Poughkeepsie or East Fishkill, I think) had it almost a year before we did. Ran like a dog (not a scalded dog, more like a geriatric dog). Kinda difficult to work with, as it was new & unfamiliar and the documentation wasn't very good yet. The install clist didn't work worth a darn, as I remember. No tools to speak of, we were pretty much flying blind and [...]
1819 20 33_Re: Help Need a Job for A DB2 DBA8_Tim Lowe17_tim.lowe@JUNO.COM31_Tue, 29 Oct 2002 18:08:54 -0600424_- St. Paul Companies laid off 3 IMS/DB2 DBAs today, me included. But, we were not alone, rumor is that 70 people were laid off today. Technical Support, DBA, Operations, Networking......some in St. Paul, some in Baltimore (former USF&G). Support was not the place to be today.
I have only worked with DB2 since DB2 V2R3, in 1990? (-: But, if you hear of any opportunities, please contact me at tim.lowe@juno.com [...]
1840 74 33_db2 dba position in San Mateo, CA13_Murali Kanaga19_murali@EPIPHANY.COM31_Tue, 29 Oct 2002 19:52:18 -0500590_iso-8859-1 All,
If any one in the Bay area is insterested, please send your resume to me.
Thanks, -Murali
DB2 Administrator Epiphany is seeking a seasoned DB2 Administrator. This is a terrific growth opportunity in an intense and dynamic environment. You will be responsible for administering, maintaining, developing and implementing procedures for ensuring the integrity and uptime of the company's development and QA DB2 databases. You will actively seek out DB2 needs of Engineering/Development groups and proactively work with managers to bring needs online. [...]
1915 49 44_Re: Bank One is Hiring DB2 Data Sharing Guru11_Tim Wilkins25_richard.wilkinsjr@GTE.NET31_Tue, 29 Oct 2002 20:51:12 -0800563_us-ascii Glen,
Not to sound rude but I myself applied to Bank One a couple of months ago following the placement of the ad in the Chicago Tribune and I saw it again about two weeks ago. I personally can't stop you from posting the information on this board, but perhaps your management needs to do a better job of reviewing the resumes and documentation sent with it. My guess, according to the information found on zazona.com about Bank One, that some H1-B Visa holder probably reviewed it and pitched it aside. Bank One had the chance so why ask or [...]
1965 227 33_Re: Help Need a Job for A DB2 DBA12_Violet Bliss20_vbliss@TEBOZANDT.COM31_Tue, 29 Oct 2002 21:45:51 -0600556_US-ASCII Hi.from a very long-time lurker,
I was an IMS DBA from 79-84 in the Data Management group at Blue Cross Blue Shield Wisconsin. I remember going to an IBM office in Milwaukee for a 2-3 hour session on DB2 and what planning we needed to get started on conversion from IMS to DB2. The SE that presented to us had invited us and a couple of other large IMS shops in the city to that presentation. That was in the March-April 1984 timeframe. Then EDS came in a couple months later, moved all our systems to a data center in [...]
2193 26 24_SMP/E discussion list...16_Raquel Rodriguez28_raquel_rodriguezus@YAHOO.COM31_Tue, 29 Oct 2002 21:36:20 -0800630_us-ascii Greetings Esteemed Listers,
Can someone let me know if there is a Mailing list (or an internet discussion group) for SMP/E questions too as there is this list for DB2 questions; and how do I access that?
TIA. Raquel.
__________________________________________________ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/
================================================ 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.
2220 60 16_ROWID Unload....16_Raquel Rodriguez28_raquel_rodriguezus@YAHOO.COM31_Tue, 29 Oct 2002 21:39:12 -0800395_us-ascii Esteemed listers,
Per S/390 V7 Utility guide:
"When you run the UNLOAD utility DB2 generates a LOAD statement that you can use to load the unloaded data into any table that has a compatible format. If the source table has a ROWID column that is defined with GENERATED ALWAYS, the generated LOAD statement contains a dummy field named DSN_ROWID for the ROWID column." [...]
2281 99 20_Re: ROWID Unload....14_Peter Backlund21_pbacklu@ATTGLOBAL.NET31_Wed, 30 Oct 2002 07:51:53 +0100305_us-ascii Raquel,
in the sequential file generated by UNLOAD in this case,
pos 1-2 is the OBID of the table (useful if you have multiple tables in the tablespace) pos 3-44 is the external form of COL1 (the rowid) pos 45-46 is COL2 pos 47 is the NULL indicator for COL3 pos 48-55 is COL3 [...]
2381 17 53_Tara-Mae Richards/ID/CitiStreet is out of the office.17_Tara-Mae Richards30_TRichards@CITISTREETONLINE.COM31_Wed, 30 Oct 2002 02:57:39 -0500521_us-ascii I will be out of the office from 10/29/2002 until 11/05/2002.
I will review and respond to your message when I return.
If it is an emergency or something that needs immediate attention or clarification, please email Don Pegg with the details.
================================================ 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.
2399 18 48_Kunjar Bhaduri/FL/FDMS/FDC is out of the office.14_Kunjar Bhaduri28_Kunjar.Bhaduri@FIRSTDATA.COM31_Wed, 30 Oct 2002 03:20:39 -0500568_us-ascii I will be out of the office starting 10/30/2002 and will not return until 11/13/2002.
I will be out of office starting 10/30/2002 (Wednesday) till 11/13/2002. If you have any IDS issues that need immediate attention, please contact Steve Stern (954-845-5739) or Chetan Soni (954-845-4965). Thanks
================================================ 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.
2418 28 18_DSN_STATEMNT_TABLE14_Galeos Antonis19_AGaleos@EUROBANK.GR31_Wed, 30 Oct 2002 10:15:00 +0200483_iso-8859-7 Dear listers We running DB2 V5 in an OS/390 . After the IDUG 2002 in Lisboa I've heard about DSN_STATEMNT_TABLE . I would like to know if DB2 V5 support it
Thank you all
Antonis Galaios
Disclaimer
This e-mail is confidential. If you are not the intended recipient, you should not copy it, re-transmit it, use it or disclose its contents, but should return it to the sender immediately and delete the copy from your system. [...]
2447 64 22_Re: DSN_STATEMNT_TABLE19_Alekos Papadopoulos13_apapad@NBG.GR31_Wed, 30 Oct 2002 10:49:57 +0200429_iso-8859-7 It seems that DSN_STATEMNT_TABLE came in V6
Alekos
-----Αρχικό μήνυμα----- Από: Galeos Antonis [mailto:AGaleos@EUROBANK.GR] Αποστολή: Τετάρτη, 30 Οκτωβρίου 2002 10:15 πμ Προς: DB2-L@LISTSERV.YLASSOC.COM Θέμα: DSN_STATEMNT_TABLE
Dear listers We running DB2 V5 in an OS/390 . After the IDUG 2002 in Lisboa I've heard about DSN_STATEMNT_TABLE . I would like to know if DB2 V5 support it [...]
2512 84 26_Answer: DSN_STATEMNT_TABLE12_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 30 Oct 2002 10:11:02 +0100799_iso-8859-7 Antonis,
the DSN_STATEMNT_TABLE came in with Version 6.
More information under http://www-3.ibm.com/software/data/db2/os390/pdf/whatv6.pdf
HTH.
With kind regards - mit freundlichen Gruessen, Georg H. Peter c/o ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Software Development & Technology Center Knowledge Center Database Systems Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, ?urope e:mail G.Peter@dzbw.de Phone 0049-711-8108-271 PC-Fax 004971189696071 Internet (only in german language):http://www.dzbw.de ---------------------------------------------------------------------- The crystal ball gets cloudier as we proceed into the future. (heard at the IBM laboratory in Boeblingen, Germany) [...]
2597 72 32_Re: os/390 db2 dba certification11_Popi Dimoka24_dimokap@INTERAMERICAN.GR31_Wed, 30 Oct 2002 13:53:44 +0200515_iso-8859-1 I was lucky enough to attend the free Pre-Conference preparation for certification by Susan Lawson in Lisbon on the 20th of October.The presentation she gave had all the possible questions covered and made me pass the exams with a very good score.So,i guess the book suggested will contain the same material.As for the 512 which is a prerequisite,GOOD knowledge of SQL + DB2 FAMILY products knowledge will do the job.For me,516 , after studying Susan's Presentation, was a lot easier.... Good Luck! [...]
2670 111 28_Re: SMP/E discussion list...13_Lockwood Lyon24_Lockwood.Lyon@MEIJER.COM31_Wed, 30 Oct 2002 07:45:20 -0500478_US-ASCII Raquel,
I'm not sure about a specific SMP/E list, but the IBM-Main ListServ has threads about SMP/E all the time.
To check out their recent threads on SMP/E visit and search their List Archive at:
http://www.bama.ua.edu/archives/ibm-main.html
This web site also has links for Joining the List as well.
- Lockwood Lyon Meijer Stores
>>> raquel_rodriguezus@YAHOO.COM 10/30/02 12:36AM >>> Greetings Esteemed Listers, [...]
2782 20 37_TS with DSSIZE 8G and page range scan33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Wed, 30 Oct 2002 06:43:00 -0600529_- Hi
I just begun to work with a tablespace which I defined with a DSSIZE of 8G. Because I got some problems with a LOAD-Utility, I wanted to look in a special partition. Therfore, before I ran my SELECT, I've done an explain for it and tried to achieve a page range scan, but with no success. We have a second similar tablespace, which is only created with the "old" keyword LARGE. For that table, I got my page range scan. Does anybody know, if a page range scan will not be taken into account for TS with DSSIZE > [...]
2803 24 24_How to Initialize job Id11_ali hasnain23_me_alihasnain@YAHOO.COM31_Wed, 30 Oct 2002 05:22:37 -0800593_us-ascii Hi;
When ever i do some process in DB2 UDB v7 for Win2000. I get a unique job id my job id's are in thousands now. Pls tell me how can i initialize the job id??
Thanks Ali Hasnain
__________________________________________________ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/
================================================ 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.
2828 34 39_DB2 Stored Procedures _ Microsoft OLEDB13_Oberto Franco21_F.OBERTO.globc@RAI.IT31_Wed, 30 Oct 2002 14:45:57 +0100379_iso-8859-1 Dear Lister,
I have a problem calling DB2 V5 OS/390 STORED PROCDURES , writed in COBOL2 ,
from NT or W2000 with Microsoft OLEDB for DB2 .
The data received from Server are unreadable.
All examples that I wiewed of Stored Procedures are written in C language .
Now, is it possible call DB2 Cobol Stored Procedures from Microsoft [...]
2863 63 33_Re: Help Need a Job for A DB2 DBA12_Dunn, Judith27_Judith.Dunn@INGRAMMICRO.COM31_Wed, 30 Oct 2002 09:08:10 -0500473_iso-8859-1 Hi Tim,
I'm in Buffalo, NY and we have two large banks, M&T and HSBC, that are always looking and you can contact them directly. We may get a few snowflakes here but at least we don't have to plug our cars into those heater contraptions.
Also, here in Buffalo I worked for EDS until three years ago. I was a DBA at the Tech Support Center so I had customers all over the place. EDS is always looking for people with your wealth of experience. [...]
2927 121 35_When is long too long? resubmitted.15_Smith, Dennis J22_dennis.j.smith@EDS.COM31_Wed, 30 Oct 2002 08:57:34 -0600308_iso-8859-1 I sent this out a little while back, and never got any responses. Hopefully this time I will get at least an I don't know ;-)
I would like to know when is a RID chain for a duplicate index too long? I have heard lots of different answers that really don't seem to answer the question. [...]
3049 136 28_Re: XML Data upload/download11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Wed, 30 Oct 2002 08:43:51 -0500428_iso-8859-1 I have not yet used it but the documentation for the DB2 Z/OS V7 XML Extender seems to provide many functions. See:
DB2 Universal Database for OS/390 and z/OS XML Extender Administration and Programming Version 7 Document Number SC26-9949-00
-----Original Message----- From: Sinha, Abhijit [mailto:Abhijit.Sinha@GS.COM] Sent: Tuesday, October 29, 2002 3:05 PM Subject: Re: XML Data upload/download [...]
3186 18 22_Re: DSN_STATEMNT_TABLE9_Ford Wong14_fordie@SHAW.CA31_Wed, 30 Oct 2002 08:53:10 -0600343_- Hello,
It has been a while but I believe that in V5 you can invoke the additional explain tables by tweeking a hidden parameter in one of the DB2 macros in SDSNSAMP and recompiling the DSNZPARM? Unfortunately, I cann't remember where and what module to zap to get this to work. Perhaps one of the other DB2 Listers can remember. [...]
3205 138 33_Re: Help Need a Job for A DB2 DBA12_Moulder, Tom19_Tom_Moulder@BMC.COM31_Wed, 30 Oct 2002 09:08:29 -0600408_iso-8859-1 I'll agree with David. Some people don't have twenty years of experience, they just have one year of experience twenty times.
Tom Moulder BMC software, Inc. my opinions, not my employers ...
-----Original Message----- From: David S Waugh [mailto:dsw-dba@JUNO.COM] Sent: Tuesday, October 29, 2002 5:51 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Help Need a Job for A DB2 DBA [...]
3344 167 33_Re: Help Need a Job for A DB2 DBA11_Ashvin Amin17_ashvin@US.IBM.COM31_Wed, 30 Oct 2002 09:13:06 -0600544_us-ascii Willie,
I pretty much agree with David's comments. We were running DB2 V1.1 in IBM Sterling Forest during those days (if I am not mistaken we were the beta site as well for quite some time). It was difficult to work with and users complained a lot about performance (they were used to IMS database performance and kept comparing both all the time). It was hard to convince people to consider to write their apps for DB2. Systems programmers were not too thrilled about the installation procedures and documentation either. [...]
3512 83 44_Re: Bank One is Hiring DB2 Data Sharing Guru19_Robert M Collins Jr17_kcoll1956@AOL.COM29_Wed, 30 Oct 2002 10:54:50 EST581_US-ASCII At first when I saw Richard's comment, "What we need in this country in my opinion are American companies employing American citizens who quit undermining the standard of living and the educational system in this country.", I didn't know what to think.
I worked at an India owned company i2 Technologies on 9/11. Most of those employed at i2 are non-American. Many(I don't have the exact numbers) were Muslim. i2 is a company that designs and develops Supply Chain and Order Management software along with other tools. At one point they had over 250 products. [...]
3596 25 10_Cache Size13_Raja Ram Balu19_rajaram.balu@BT.COM31_Wed, 30 Oct 2002 16:28:48 -0000383_iso-8859-1 Hi All,
I am just trying to understand how EDM Pool is been utilised during program run. I have come across couple of places wherein there was a mention that if PLAN has been granted to PUBLIC, then the CACHESIZE can be given as 0, thus reducing the utilisation of EDM. I could understand the justification behind it. Can someone share their view on the same. [...]
3622 60 33_Re: Help Need a Job for A DB2 DBA15_Smith, Dennis J22_dennis.j.smith@EDS.COM31_Wed, 30 Oct 2002 10:32:29 -0600421_iso-8859-1 Gee I was with DB2 when it was 1.2.... we had 1.1 for about ten minutes, and then we went to 1.2. We just got the new machine, so no applications where allowed while we played with it. We had converted from Burroughs machine, database, and move to DB2. It was a mess! We had 1.2 under test migration constructions and went live with 1.3. We sated there until 2.1/2.3 We skipped 2.2. Those where the days! [...]
3683 36 49_Error loading using FORMAT UNLOAD data (DSNU314I)11_Jeff Agosta20_agost003@MC.DUKE.EDU31_Wed, 30 Oct 2002 10:18:45 -0600573_- Hi Esteemed gurus et al Quite some time ago (07/14/98), Lockwood Lyon posted a query on the db2 listserver regarding a load problem stemming from unloading a table in one subsys to another with a load that was created via reorg unload. We're currently in a situation where we are pushing the db2 4/64 gig limit in a 16 part tablespace. I'm reorg unloading from each ts part, creating a new tablspace (large) with more parts and limitkeys. The orig was 16 parts, limit keys A99999999999 > P99999999999. For initial testing purposes I created a new ts with limit keys [...]
3720 16 44_Re: Bank One is Hiring DB2 Data Sharing Guru23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Wed, 30 Oct 2002 11:40:59 -0500602_us-ascii **************************************************************** Bear Stearns is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. ***********************************************************************
================================================ 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.
3737 16 20_Re: ROWID Unload....9_Jim Ruddy18_jaruddy@US.IBM.COM31_Wed, 30 Oct 2002 10:47:54 -0600495_- This is a bug which is in the process of being fixed by APAR PQ66326.
If the books says something should occur and it doesn't assume it is a bug and open a problem with the support center.
Jim Ruddy DB2 for z/OS Development
================================================ 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.
3754 35 44_Re: Bank One is Hiring DB2 Data Sharing Guru15_Janardhan Ragam16_sragam@YAHOO.COM31_Wed, 30 Oct 2002 09:12:37 -0800564_us-ascii I am sure the list owners are monitoring the thread but I am not sure why they are not putting an end to topics that are un-related to the goal of this group.
My 2 cents: People who have a problem with the hourly rates...have you ever thought why this is actually happening? It is because of the "system" and not the "people". Abandon all these middle body shopping companies and ask the corporations to deal with the individuals direclty...unfortunately you will come back and say this is not possible. But I think it is and that is the only [...]
3790 50 33_Re: Mulitple Line Output in SPUFI12_Isaac Yassin20_yassini@BEZEQINT.NET31_Wed, 30 Oct 2002 19:20:56 +0200495_- Hi,
This got rejected - so here it is again :-)
I use something like the edit macro below to do the split of long lines from SPUFI.
/* REXX */ TRACE O ADDRESS ISREDIT MACRO SAY "STARTING" TIME('R') "FIND " WHERE " LAST" DO WHILE (RC = 0); TSPLIT "FIND " WHERE " PREV " END; SAY "AFTER WHERE" TIME('R') "FIND " AND " LAST" DO WHILE (RC = 0); TSPLIT "FIND " AND " PREV " END; SAY "AFTER AND" TIME('R') "FIND " SET " LAST" DO WHILE (RC = 0); TSPLIT "FIND " SET " PREV " [...]
3841 55 27_Re: DB2 v7 DSNHADD2 problem13_Jeremiah Eden28_JEREMIAH.EDEN@RADIOSHACK.COM31_Wed, 30 Oct 2002 11:31:49 -0600486_- OK. So NO recompiles now. Great. That makes more sense with UQ68370 on.
-----Original Message----- From: Frank.John [mailto:John.Frank@FTB.CA.GOV] Sent: Tuesday, October 29, 2002 4:38 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: DB2 v7 DSNHADD2 problem
We are on v7, now. Putting on UQ68370 fixed our problem by creating a new DSNHADD2 for v7. Our problem was that we weren't aware of UQ68370 at first and had some COBOL programs trying to call DSNHADD2. [...]
3897 182 41_Online Reorg causing Unavailable Resource13_Skerritt, Ann21_Ann.Skerritt@ITSIS.IE31_Wed, 30 Oct 2002 17:30:18 -0000576_iso-8859-1 Hi list,
Recently we had a problem where Online Reorg seemed to cause an unavailable resource in DB2. We did some investigation for our Pointy Headed Boss and came up with the following explanation...
When Online Reorg Utility runs it does not take the tables off the air, however the final phase - the Switch Phase, of the reorg does take the table off the air while it switches the old table and the shadow (newly reorged) table around. This outage is typically, in the order of 5 seconds in our shop, which should be well within the wait time [...]
4080 64 48_Los Angeles Area DB2 User Group November Meeting15_Donna O'Connell26_donna.oconnell@SAFEWAY.COM31_Wed, 30 Oct 2002 09:42:53 -0800375_us-ascii Our November meeting is sponsored by QUEST SOFTWARE. This will be a full day meeting with breakfast and lunch offered. The meeting will be held at the Sheraton Cerritos. I do expect that we will have a good showing for this meeting since this is our last full day meeting this year at the Sheraton. We need you to be there to show your support for the program. [...]
4145 16 33_Re: Help Need a Job for A DB2 DBA0_26_truman.g.brown@VERIZON.COM31_Wed, 30 Oct 2002 12:45:49 -0500375_us-ascii My favorite "early days" DB2 events were educating IBM SE's (I'm an ex-IBM SE myself). I remember one presentation where the IBMer was presenting estimated DASD space requirements based on total DASD capacity; when he finished I had to explain to him (in front of about twenty people) that he was only half right due to 4096 CI's, IRG's, and page/row overhead. [...]
4162 14 44_Re: Bank One is Hiring DB2 Data Sharing Guru0_26_truman.g.brown@VERIZON.COM31_Wed, 30 Oct 2002 12:48:05 -0500450_us-ascii I have done independent contracting in the past; you have to know where the need is and sell yourself. Networking in users' groups may provide you with independent contracting contacts.
================================================ 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.
4177 43 37_Binding Cross Platform Loader package15_Robert Lawrence21_rlawrence@BOSCOVS.COM31_Wed, 30 Oct 2002 12:54:37 -0500502_iso-8859-1 Hi,
I am trying to implement the cross platform loader package to be able to load data from DB2 UDB on NT to a table on DB2 UDB V7 on OS/390. I have bound the package on DB2 UDB on OS/390 successfully however when I try to do a remote bind with the bind command specified in the DB2 for z/OS and OS/390 Version 7: Using the Utilities Suite Redbook BIND PACKAGE(GIFTREGP.DSNUTIL) - COPY(DSNUTIL.DSNUGSQL) COPYVER(V7R1)- CURRENTDATA(NO) ISOLATION(CS)- ACTION(ADD) OPTIONS(COMMAND) [...]
4221 16 17_DB2 gui installer11_Craig Otway18_otwayc@EDNET10.NET31_Wed, 30 Oct 2002 11:38:06 -0600400_- I am about to install v7 on 2.10 and would like to use the gui installer. After the install of v7 is tested I plan to use the same gui installer to migrate v5 up to v7. Has anyone successfully done either an install or a migration using this method? I have searched the archives and only come up with a couple of hits. http://www-3.ibm.com/software/data/db2/os390/v6facts/db2inst.html Thanks. [...]
4238 224 44_Re: Bank One is Hiring DB2 Data Sharing Guru16_Miller, Marilynn22_Marilynn.Miller@CA.COM31_Wed, 30 Oct 2002 13:09:33 -0500308_iso-8859-1 I agree fully. Though I am no longer in consulting, I was for 24 years. Almost all I know that did this are out of work now. For long perios, some up to 2 years now. The companies keep asking the gov't to increase H1B's because they can't find the help they need. While we're all unemployed. [...]
4463 81 45_Re: Online Reorg causing Unavailable Resource10_Todd Burch22_tburch@CDBSOFTWARE.COM31_Wed, 30 Oct 2002 12:12:51 -0600422_iso-8859-1 Conor,
The rest of the planet feels your pain. Yes, your assements are correct. Your PHB will be happy.
Other than not running TX's during your online reorg (which, pretty much makes it a moot facility), you can contact your local CDB Software representative and order CDB/Auto-Online Reorg. It's the only reorg on the planet for DB2 for OS/390 and z/OS that does not take an outage. Period. [...]
4545 52 44_Re: Bank One is Hiring DB2 Data Sharing Guru16_Miller, Marilynn22_Marilynn.Miller@CA.COM31_Wed, 30 Oct 2002 13:13:31 -0500482_iso-8859-1 A bit testy here, aren't we???? Feeling a little guilt, are we???
-----Original Message----- From: Janardhan Ragam [mailto:sragam@YAHOO.COM] Sent: Wednesday, October 30, 2002 11:13 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Bank One is Hiring DB2 Data Sharing Guru
I am sure the list owners are monitoring the thread but I am not sure why they are not putting an end to topics that are un-related to the goal of this group. [...]
4598 32 39_DB2 Times - News, Hints and Tips on DB211_Klaas Brant14_kbrant@KBCE.NL31_Wed, 30 Oct 2002 12:10:40 -0600597_ISO-8859-1 Dear DB2 User,
At IDUG Europe 2002 we launched our new information source for the DB2 community: DB2 Times.
It consist of a web site and an e-mail newsletter. It is brought to you free of charge by four leading DB2 companies ( Brainware, KBCE, Triton and YL&A). We will bring to you news, information, hints, tips, downloads, SQL tips and much more. The DB2 community is rapidly growing and DB2 Times provides you with concise information about DB2 and everything related to it. We cover OS/390, Linux, Unix and Windows version of DB2. Stories are written by some of [...]
4631 123 39_Re: When is long too long? resubmitted.10_Todd Burch22_tburch@CDBSOFTWARE.COM31_Wed, 30 Oct 2002 12:29:32 -0600381_iso-8859-1 Dennis, other than obtaining a reading on your specific question, "when is a rid chain for duplicate keys too long?", I'm having a difficult time trying to determine what you would actually do with this information... And, too long for what? To cut down on long rid chains - your only option is to get rids of duplicate rows, or change the key to be more distinct. [...]
4755 40 21_Re: DB2 gui installer12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 30 Oct 2002 10:54:26 -0800532_us-ascii You need DB2 Connect to use the GUI Installer. Good luck on using it. Hope you're more successful than I was. I had a couple of major problems with it, both of which were never resolved by IBM. I finally abandoned using it and went back to the old CLIST TSO ISPF panels and got that to work. The GUI looked nice but the support was somewhat less than satisfactory. Lots of finger-pointing and little resolution. That's my personal opinion and the views herein do not reflect anybody but myself. Your mileage may vary. [...]
4796 15 95_LOB columns > 32K - how are shops unloading/loading the LOB data when drop/create is performed?0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM31_Wed, 30 Oct 2002 13:19:01 -0600455_us-ascii "For shops with DB2 for z/OS tables with LOB columns greater than 32K in length, how are you unloading and loading the LOB data when a DROP/CREATE is required to perform schema maintenance?"
================================================ 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.
4812 187 33_Re: Help Need a Job for A DB2 DBA13_Davis, Ronald17_DavisRo@CONED.COM31_Wed, 30 Oct 2002 14:20:26 -0500313_ISO-8859-1 Ashvin, How are you. I remember our days at Sterling Forest. We were in the same DBA group back then. Yes, we have come a long way. Migrating from test to production with no tools made every little change a big production. That's when SPUFI was - System Programmers User Friendly Interface - LOL. [...]
5000 115 44_Re: Bank One is Hiring DB2 Data Sharing Guru16_Raquel Rodriguez28_raquel_rodriguezus@YAHOO.COM31_Wed, 30 Oct 2002 11:31:19 -0800577_us-ascii Robert,
I have NO IDEA why you have mentioned 9/11 and ‘Muslims’ in your mail. Can you please elaborate… Corporations in US have for ages been moving their manufacturing bases to other countries for cheaper costs. Most of the retailers (GAP, CARTER etc.) have their factories spread all over Asian countries. While these countries do benefit because many local people get employed, the American consumers are benefitted because they get cheaper products. So, I can't understand why there is such hue and cry now when i2 is moving it's operations to India. [...]
5116 18 32_Re: os/390 db2 dba certification13_Kjell Hansson12_kjell@SUI.NU31_Wed, 30 Oct 2002 13:20:40 -0600544_- I also passed the certification a couple of days ago.
I used YLA's certification book. I think it was a good source. You can find it on http://www.amazon.com/exec/obidos/tg/detail/- /0130650765/qid=1036005576/sr=8-3/ref=sr_8_3/102-0190101-7718527? v=glance&n=507846
/Kjell
================================================ 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.
5135 78 45_Re: Online Reorg causing Unavailable Resource11_Ron Johnson25_rjohnson@DATA-TRONICS.COM31_Wed, 30 Oct 2002 13:45:54 -0600598_iso-8859-1 Conor,
Yes, I would also agree your assessment is correct. We occasionally have problems just prior to the actual switch where new transactions get held up while the online reorg waits to drain everything.
I have a question on this subject... Does anyone know how to tell which transactions are causing the reorg to wait? More specifically I want to know after the fact by using some sort of report facility. We have Omegamon II for DB2 and the locking contention report tells me which transactions got timed out by the utility but it doesn't tell me what the utility [...]
5214 30 100_Re: LOB columns > 32K - how are shops unloading/loading the LOB d ata when drop/create is performed?16_Roland Schiradin28_SchiradinR@ALTE-LEIPZIGER.DE31_Wed, 30 Oct 2002 20:50:53 +0100661_- Create a shadow table and INSERT INTO shadow-lob-table SELECT * FROM original-lob-table
Roland
> -----Original Message----- > From: Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM > [SMTP:Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM] > Sent: Wednesday, October 30, 2002 8:19 PM > To: DB2-L@LISTSERV.YLASSOC.COM > Subject: LOB columns > 32K - how are shops unloading/loading the LOB > data when drop/create is performed? > > "For shops with DB2 for z/OS tables with LOB columns greater than 32K in > length, how are you unloading and loading the LOB data when a DROP/CREATE > is required to perform schema maintenance?" > > [...]
5245 54 21_Re: DB2 gui installer13_David S Waugh16_dsw-dba@JUNO.COM29_Wed, 30 Oct 2002 20:14:46 GMT280_- I'd have to agree with Myron. I tried using the GUI Installer tool when I installed V5 for a client a couple of years ago. I had a variety of problems with it (some of it just flat didn't work), and I finally gave up and went back to using the old-fashioned Install Clist. [...]
5300 31 44_Re: Bank One is Hiring DB2 Data Sharing Guru0_26_truman.g.brown@VERIZON.COM31_Wed, 30 Oct 2002 15:17:47 -0500605_us-ascii For many, many years the USA was an isolated country with somewhat artificial cultural and economic structures. These structures began to break down and move toward the reality of a world community following World War II, and that breakdown accellerated rapidly throughout the 1970's, 80's, and 90's.
World community means that corporations will both hire people and relocate operations to get the best bang for the buck. What this means to the USA is that people are going to have to acquire better educations and work harder for less money just to compete in the world marketplace. [...]
5332 86 45_Re: Online Reorg causing Unavailable Resource13_David S Waugh16_dsw-dba@JUNO.COM29_Wed, 30 Oct 2002 20:27:54 GMT496_- Conor:
You're pretty much on the money with your explanation -- some other process is probably holding locks and the Online Reorg SWITCH phase sits and waits for the locks to be freed. I've had the same problem from time to time.
Unfortunately, I never found a good way to find out who the culprit was, as there were no messages issued unless a timeout occurred. I'm sure I could have plowed through the logs and found it, but I never really had the time (and I'm too lazy). [...]
5419 160 39_Re: When is long too long? resubmitted.15_Smith, Dennis J22_dennis.j.smith@EDS.COM31_Wed, 30 Oct 2002 14:40:18 -0600642_iso-8859-1 See my answers below, prefixed with ***
-----Original Message----- From: Todd Burch [mailto:tburch@cdbsoftware.com] Sent: Wednesday, October 30, 2002 11:30 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: When is long too long? resubmitted.
Dennis, other than obtaining a reading on your specific question, "when is a rid chain for duplicate keys too long?", I'm having a difficult time trying to determine what you would actually do with this information... And, too long for what? To cut down on long rid chains - your only option is to get rids of duplicate rows, or change the key to be more distinct. [...]
5580 106 45_Re: Online Reorg causing Unavailable Resource16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Wed, 30 Oct 2002 15:35:59 -0500335_iso-8859-1 In order to get the information after the fact we had to collect the info while the problem was happening.
At the start of the reorg we initiated a job which did -DIS DB(dbname) SPACE(tablespace,index1,index2,..) CLAIMERS ONLY and had the scheduler rerun the job once a minute for the duration of the REORG job. [...]
5687 90 21_Re: DB2 gui installer12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 30 Oct 2002 12:50:25 -0800366_us-ascii David, My problems with the GUI are with the V7 version. I just tried a couple of months ago, so its pretty recent. It wasn't so much the difference between the clists, but the fact that it flat wouldn't work in a few places at all. Like it wouldn't connect to one of the DB2's I was trying to migrate, even though regular DB2 connect would just fine. [...]
5778 110 31_RACF violation on Creating View10_Grace Chen22_gchen@CUCENTRAL-AB.COM31_Wed, 30 Oct 2002 14:21:41 -0700538_iso-8859-1 Hi List, One of our programmer was trying to create a VIEW from a table which he has select authority. The view got created successfully. However, we got lots of RACF violation message indicate that this programmer was trying to insert, delete and update the base table. My question is : Will create VIEW perform update, insert and delete from the base table ? The create VIEW statement is as following: CREATE VIEW BAAAV1 AS SELECT * FROM TDXXXP0D.BAAABH WHERE STAGING_DT = (SELECT MIN(STAGING_DT) FROM TDXXXP0D.BAAABH); [...]
5889 16 24_Temporary Table Clean Up11_Mike Fatula22_mfatula@AESSUCCESS.ORG31_Wed, 30 Oct 2002 16:27:38 -0500354_us-ascii We are creating temporary user tables through a java called stored procedure using run-time version JRE 1.4. There are issues with the temp tables remaining after the stored procedure completes on AIX and OS2. We also have issues on OS2 with locks being held on the DB2 tables. Has anyone else run into this and if so , how was it handled? [...]
5906 26 31_ESCON to FICON and 3990 to 210517_Doreen D. Rowland28_db2nm@NORTHWESTERNMUTUAL.COM31_Wed, 30 Oct 2002 15:33:38 -0600430_ISO-8859-1 Would anyone be able to share any of their experiences with the following hardware changes? All experiences would be greatly appreciated, especially those in regards to how they might affect DB2 UDB for OS/390 V6 or V7. We are on two IBM 9672s, R36 and Y26, running OS/390 2.10.
01. Going from using ESCON to FICON 02. 3990 controller definition to a 2105 definition (we already have a heads up on PQ45985) [...]
5933 22 21_HACMP Classic and DB215_Arni Eggertsson16_arnie@GORMUR.COM31_Wed, 30 Oct 2002 21:32:47 +0000347_us-ascii Hello list
This may not be the best mailing list to post this question, but what the heck!
I am running an HACMP Classic installation with DB2 7.1, I know that DB2 includes scripts to do let HACMP/ES (using custum events) do some database monitoring, however these scripts are not compliant with HACMP Classic. [...]
5956 57 39_Re: When is long too long? resubmitted.15_Blaicher, Chris22_Chris_Blaicher@BMC.COM31_Wed, 30 Oct 2002 15:49:11 -0600569_iso-8859-1 Dennis,
Architecturally, there is no such thing as too long, outside of object size limitations.
Practically, the answer is when the index does not give you the performance you want. Another criteria might be, does DB2 use this index to get back only the rows that are desired?
The purpose of an index is to get you to a record or set of records faster. If you have an index that has 1,000,000 RIDS hung off a single key, then I would really question the value of that index, unless you have an object with billions of rows and you [...]
6014 137 45_Re: Online Reorg causing Unavailable Resource17_Kornblum, Kenneth24_Kenneth_Kornblum@BMC.COM31_Wed, 30 Oct 2002 15:58:46 -0600383_iso-8859-1 Hint for users of BMC Reorg Plus for DB2
Since this thread has raised the question and it's common for customers to be unaware of some features of the products they're using, I thought I'd respond with this usage hint.
BMC's Reorg Plus for DB2 has an option (by Default or Syntax) to DISPLAY CLAIMERS and LOCKS when we can't get a DRAIN and must retry. [...]
6152 39 57_SQL update that causes a row to move to another partition14_Mark McCormack27_mamccormack@STATESTREET.COM31_Wed, 30 Oct 2002 17:14:49 -0500548_us-ascii I post this for co-workers. We seek advice from more experienced folks. environment - OS/390 v2.10, DB2 v6, data sharing enabled, no sharing across members for this application.
We have an application with many partitioned tablespaces. Developers are working on a process that will make changes to columns in the partitioning key, via SQL update stmts. This causes rows to move to other partitions. It's also running very slowly. The developers really want to use update instead of insert and delete. It makes for simpler SQL. [...]
6192 19 28_Re: Temporary Table Clean Up0_18_IWANT2BEME@AOL.COM31_Wed, 30 Oct 2002 17:20:30 -0500371_iso-8859-1 Mike,
Yes, we DROP the temp tables (DTTs) before creating them since they will remain with thread reuse.
We also experienced locks being held on the DB2 tables, so we are issuing a COMMIT to free DB2 resources after a unit of work is completed. We changed out DTTs to ON COMMIT PRESERVE ROWS so rows inserted won't be deleted by the COMMIT. [...]
6212 27 33_Re: Help Need a Job for A DB2 DBA13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Wed, 30 Oct 2002 16:32:09 -0600579_us-ascii Did you ever make it to the DB2 Boot Camp class for SE's only back in the late 80's?... It was a 10 day class taught in Irving.
Willie
truman.g.brown@VERIZON.COM wrote:
> My favorite "early days" DB2 events were educating IBM SE's (I'm an ex-IBM > SE myself). I remember one presentation where the IBMer was presenting > estimated DASD space requirements based on total DASD capacity; when he > finished I had to explain to him (in front of about twenty people) that he > was only half right due to 4096 CI's, IRG's, and page/row overhead. > > [...]
6240 59 61_Re: SQL update that causes a row to move to another partition11_Robert Jans26_robert.jans@ALBERTSONS.COM31_Wed, 30 Oct 2002 15:45:10 -0700525_- Mark, the whole problem with the UPDATE scenario is that you must get exclusive lock on not only the source and target partitions but any partitions in between. If the developers want this to run make them do the insert/delete processing
Robert Jans
-----Original Message----- From: Mark McCormack [mailto:mamccormack@STATESTREET.COM] Sent: Wednesday, October 30, 2002 3:15 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: SQL update that causes a row to move to another partition [...]
6300 212 36_Re: Business Objects and DB2 Connect13_Merritt, Hank16_HMerritt@GHI.COM31_Wed, 30 Oct 2002 17:45:49 -0500652_iso-8859-1 Dear List,
Thanks for the helpful suggestions, especially how to trace what's going on. The problem turned out to be a not very well documented (except in the Business Objects Knowledgebase) requirement that the Web Intelligence connections on the server be defined as system resources by going in through: Control Panel --> Administrative Tools --> ODBC Data Source Administrator --> System DSN (tab). The DB2 Connect Client Configuration Assistant entries were not being used the same way as on the workstations. The distinction between system and user resources on the server had eluded me, since Web Intelligence serves as a [...]
6513 103 41_Changes to default bind option DBPROTOCOL13_Merritt, Hank16_HMerritt@GHI.COM31_Wed, 30 Oct 2002 18:06:28 -0500342_iso-8859-1 Dear List,
We are OS/390 2.10, DB2 V6.1 (with V7.1 just up on our test LPAR today). We are planning to change a default BIND option on the mainframe, from DBPROTOCOL=PRIVATE to DBPROTOCOL=DRDA. Only accessing data at a remote location with a three-part name (location.owner.object) seems to be affected by this change. [...]
6617 25 10_Cache Size13_Raja Ram Balu19_rajaram.balu@BT.COM31_Wed, 30 Oct 2002 23:20:16 -0000387_iso-8859-1 Hi All,
I am just trying to understand how EDM Pool is been utilised during program run. I have come across couple of places wherein there was a mention that if PLAN has been granted to PUBLIC, then the CACHESIZE can be given as 0, thus reducing the utilisation of EDM. I could not understand the justification behind it. Can someone share their view on the same. [...]
6643 30 38_MMIS HIPAA compliance - using DB2 UDB?13_David S Waugh16_dsw-dba@JUNO.COM29_Wed, 30 Oct 2002 23:33:52 GMT323_- I was hoping someone who works for First Health Services could help me get in contact with the First Health group who's handling the MMIS HIPAA contract for the State of Nevada (in particular, someone in their DBA department).
If so, please have them contact me offline at DSW-CS@juno.com or DSW-DBA@juno.com [...]
6674 159 28_Help ! - Wait DB2 I/O - time22_Ramesh Balasubramanyan15_RAMBAL@SAIF.COM31_Wed, 30 Oct 2002 16:14:03 -0800543_iso-8859-1 Dear Listers , I have been struggling with a some long I/O wait times in a DB2 Connect/Powerbuilder /DB2 V7.1 application for quite some time now. I think I have enough and more tools to fight this issue and I am unable to nail the issue. Please enlighten me on how I can determine where the I/O wait time is happeniing . A detailed 'I/O summary by pageset report' shows that some of the pageset have horrendous max response times of over 5 seconds...my question is how do I break this I/O wait time to a any greater detail at [...]
6834 63 32_Re: Help ! - Wait DB2 I/O - time10_Rick Davis18_RDavis8727@AOL.COM29_Wed, 30 Oct 2002 20:11:36 EST438_US-ASCII Well, you probably won't have to break it down any further. Long I/O wait times are usually caused by too many busy files/datasets on the same disk/volume, the table or index needs to be reorg'd, the disk/DASD controller is too busy, you are experiencing a lot of cache write misses in controller cache, or channel(s) to the controller are too busy. I'd first check to see if the affected tables/indexes need to be reorg'd. [...]
6898 50 44_Re: Bank One is Hiring DB2 Data Sharing Guru15_Donna O'Connell26_donna.oconnell@SAFEWAY.COM31_Wed, 30 Oct 2002 17:52:31 -0800608_us-ascii Of course, it is very hard to accept that one's children will not have as high a standard of living as we do now.
truman.g.brown@VERIZON.COM wrote:
> For many, many years the USA was an isolated country with somewhat > artificial cultural and economic structures. These structures began to > break down and move toward the reality of a world community following World > War II, and that breakdown accellerated rapidly throughout the 1970's, > 80's, and 90's. > > World community means that corporations will both hire people and relocate > operations to get the best bang for the [...]
6949 184 32_Re: Help ! - Wait DB2 I/O - time12_Higgins John25_HigginsJohn@JOHNDEERE.COM31_Wed, 30 Oct 2002 20:03:09 -0600417_iso-8859-1 You say you change from 5 seconds to milliseconds when you change from Powerbuilder to SPUFI ?
It MUST be true that there are two very different plans involved.
It is likely that the SQL is different.
I'll bet the Powerbuilder used host variables in the predicates and SPUFI used literal values.
That is exactly enough for DB2 to switch from one index to another, etc, etc [...]
7134 39 28_Re: Temporary Table Clean Up11_David Nance16_DWNance@FHSC.COM31_Wed, 30 Oct 2002 23:02:08 -0500614_US-ASCII What is your release option on the bind for these packages or plans? It kind of sounds like you're probably using release instead of commit.
Dave Nance First Health Services, Corp. (804)527-6841
>>> mfatula@AESSUCCESS.ORG 10/30/02 4:27:38 PM >>> We are creating temporary user tables through a java called stored procedure using run-time version JRE 1.4. There are issues with the temp tables remaining after the stored procedure completes on AIX and OS2. We also have issues on OS2 with locks being held on the DB2 tables. Has anyone else run into this and if so , how was it handled? [...]
7174 76 61_Re: SQL update that causes a row to move to another partition11_David Nance16_DWNance@FHSC.COM31_Wed, 30 Oct 2002 23:05:28 -0500373_US-ASCII You've already said what the DB2 problem is here and others will back you up on that. I think the big issue here is updating your primary key, that is a HUGE design error. That is what should really be concentrated on here. You can do the delete/insert, but you said for millions of rows per day, that will be a nightmare maintenance and application problem. [...]
7251 149 14_Re: Cache Size14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 31 Oct 2002 08:00:53 -0000425_iso-8859-1 I love questions with simple answers
"YES"
A bit is set in a public plan so that all are allowed to execute it WITHOUT doing an AUTH check against the catalog (or the userid cache). So CACHESIZE(0) WILL make the plan slightly smaller
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 [...]
7401 70 23_Fw: HOW TO USE DSNUTILS7_a00089621_a000896@MS.SKH.ORG.TW31_Thu, 31 Oct 2002 16:18:09 +0800307_big5
----- Original Message ----- From: a000896 To: DB2 Data Base Discussion List Sent: Tuesday, October 29, 2002 4:20 PM Subject: HOW TO USE DSNUTILS
hi : list i want to use dsnutils utility, but i do'nt know how to use, can anyone provide cobol2 sample program call dsnutils
7472 20 54_Re: Help Need a Job for A DB2 DBA / the history of DB210_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 31 Oct 2002 09:37:10 +0100489_us-ascii A question came in my mind reading this thread.......But are we (DB2ers I mean) growing SO old ?
Regards
Max Scarpa Certified denture-less (until now) DB2 sysprog (But y presbyopia is around the corner)
================================================ 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.
7493 40 47_Re: Online Reorg causing Unavailable Resource -10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 31 Oct 2002 11:24:53 +0100597_us-ascii Hi listers & Ron
A technique I used as I do not have any high-performance 3rd party utility (but I've a scheduler/automation tool) to detect who is using a database is 'sampling' ie as I know or I can reasonably predict the duration of the reog job I execute, using a scheduler or an automation tool, a job or a command to display users/claimers/etc for a database/tablespace/index on regular intervals. It's trivial and absolutely not sophisticated, I know it, but at least it's relatively cheap and it helps to restrict the time window where problems occurs, at least for a [...]
7534 37 25_test mesage please ignore5_Saima22_sjelani@COMSATS.NET.PK31_Thu, 31 Oct 2002 16:05:30 +050019_iso-8859-1
7572 30 61_Re: SQL update that causes a row to move to another partition10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 31 Oct 2002 12:06:03 +0100421_us-ascii Hi Mark
Do not use it.
I know it'as a stupid reply but in this case I think (my opinion) this is not a case where to use this DB2 feature (since V5 by APAR) as it introduce a terrible performance degradation and a cause of deadlocks in your application to have only a simpler SQL. Don't let the programmers to manage performance in a DB2 world, they should try a different application design. [...]
7603 19 35_Platinum Database Analyzer Question18_Di Franco Vincenzo22_difrancov@ISIDE.BCC.IT31_Thu, 31 Oct 2002 12:48:19 +0100345_iso-8859-1 Hi all, When I generate an image copy jcl with Database analyzer I include in the copy dataset, like mid-qualifiers, date and time. So now I need to generate with the same products a corresponding recover tocopy jcl (same date and same time specified in the previous imagecopy). Someone have an idea ? Thank you in advance. Bye. [...]
7623 18 44_Re: Bank One is Hiring DB2 Data Sharing Guru11_Tim Wilkins25_richard.wilkinsjr@GTE.NET31_Thu, 31 Oct 2002 05:47:26 -0800522_us-ascii First let me say that Glen did call me yesterday to explain Bank One's employment position in regard to H1-B's and I do thank him for taking the time for doing so. I would say that Donna's comment sums up my position on this. I sit on a local school board and you know I sit there and think many times when we vote to spend the money on technology are we throwing this money at a worthless cause or what because of what the future holds in IT. I've read comments about racism. No, sorry it isn't about that. [...]
7642 61 61_Re: SQL update that causes a row to move to another partition12_michael bell24_mbell11@WORLDNET.ATT.NET31_Thu, 31 Oct 2002 07:03:40 -0600534_iso-8859-1 What is the fastest way to move millions of rows? read/delete - write record with new keys to output file sort the file insert the rows with new values. EVERYONE underestimates the cost and elapsed time of random processing for saving a few lines of code.
----- Original Message ----- From: "Mark McCormack" Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, October 30, 2002 4:14 PM Subject: SQL update that causes a row to move to another partition [...]
7704 76 41_FW: Binding Cross Platform Loader package13_Jeremiah Eden28_JEREMIAH.EDEN@RADIOSHACK.COM31_Thu, 31 Oct 2002 07:13:04 -0600404_- Meant to send this to the Listserv in case someone else tries to use the Cross Loader but somehow my RE just went to Mr. Lawrence. Anyway, does anyone have this feature working between and OS/390 DB2 and another platform.
-----Original Message----- From: Jeremiah Eden Sent: Wednesday, October 30, 2002 1:49 PM To: 'rlawrence@boscovs.com' Subject: RE: Binding Cross Platform Loader package [...]
7781 90 44_Re: Bank One is Hiring DB2 Data Sharing Guru14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Thu, 31 Oct 2002 13:21:45 -0000570_iso-8859-1 Having misread the subject heading, I thought an esoteric hostage situation had occurred... "Bank One is Hiding DB2 Data Sharing Guru"
----------------------------------------------------------------------------------------------------------------------- This e-mail is intended only for the above addressee. It may contain privileged information. If you are not the addressee you must not copy, distribute, disclose or use any of the information in it. If you have received it in error please delete it and immediately notify the sender. [...]
7872 43 30_Access Path for Cascade Delete10_Bruce, Mae26_BruceM@MAIL.OA.STATE.MO.US31_Thu, 31 Oct 2002 07:44:17 -0600419_iso-8859-1 I have a parent (REGISTER) and child (MEMBER) relationship with a cascade delete defined. I have an index defined on the foreign keys on the MEMBER table and I have now made it the clustering index (and updated stats). But when we run the program that deletes REGISTER, it appears that a table scan is happening on MEMBER instead of using the index. I have just over a million rows in the MEMBER table. [...]
7916 34 54_Re: Help Need a Job for A DB2 DBA / the history of DB213_Willie Favero21_wfavero@ATTGLOBAL.NET31_Thu, 31 Oct 2002 08:01:08 -0600351_us-ascii AGE is nothing more than a state of mind.. -- And some of us will be immature forever.. LOL
When presenting at IDUG NA 2002, I was introduced as having 29 years with database. A young lady came up to me after the presentation and pointed out that I was working with database BEFORE she was born... I felt so good.... (smile)..... [...]
7951 70 34_Re: Access Path for Cascade Delete14_Martin Flavell18_mflavell@I-TCS.COM31_Thu, 31 Oct 2002 14:06:53 +0000
8022 70 39_AW: Platinum Database Analyzer Question12_Thomas Weber23_thomas.weber@LDS.NRW.DE31_Thu, 31 Oct 2002 15:08:28 +0100557_iso-8859-1 Hi Vincenzo,
if I understand your problem right, you want to run a COPY strategy first, and then a RECOVER strategy. Then your dataset names will be different because the value for %TIME has changed. If you want to get the same %TIME value, you have to tie both action procedures to the same extract procedure. The catch is, that you'll have the RECOVER together with the COPY i.e. COPY dbname1.tsname1 RECOVER TABLESPACE dbname1.tsname1 COPY dbname1.tsname2 RECOVER TABLESPACE dbname1.tsname2 .... I think, that's not what you want. [...]
8093 111 45_Re: Changes to default bind option DBPROTOCOL13_Dan Mortensen31_Dan.Mortensen@MUTUALOFOMAHA.COM31_Thu, 31 Oct 2002 08:05:41 -0600605_us-ascii Hank; We had asked IBM this question when we changed to DRDA and here is what we got back:
Hello; I have two questions concerning DB2 DRDA and Private Protocol. 1. Is there a way to determine if applications are using private protocol? 2. Is there a way we can prohibit our application people using private protocol and still allow them to use DRDA? . The sure is a way you can determine whether applications are using private protocol. Perform a SELECT against SYSIBM.SYSPLAN and also against SYSIBM.SYSPACKAGE looking for DBPROTOCOL = 'P' (for private). . Unfortunately there is no [...]
8205 109 39_Re: Platinum Database Analyzer Question23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Thu, 31 Oct 2002 14:28:18 -0000327_iso-8859-1 yes but PDA does not load balance .. and never did produce the correct recovery jobs.
You could write your oiwn in REXX like most of us have. Works well and in minutes, produces backups balanced by resource (Tape) and produces recovery jobs that retain the tapes and use correct dataset in the recovery. [...]
8315 48 21_Ann: Sui - Query tool13_Kjell Hansson12_kjell@SUI.NU31_Thu, 31 Oct 2002 08:11:54 -0600583_ISO-8859-1 I know that product announcements are a controversial issue on this forum. Even though here is another one. This time the software is completely free (freeware).
Sui is a simple Query and report tool. It’s intended for database professionals and advanced end-users. I wrote the tool when I got fed up with all fancy query tools and their pointing and clicking. I wanted a simple query tool where I could write the SQL my self and execute it against any DBMS. Since the tool is using JDBC and is written in Java it requires that you have java runtime installed [...]
8364 33 29_storage problems with 64 bit?14_Hickman, Mindy29_Mindy.Hickman@DEG.STATE.WI.US31_Thu, 31 Oct 2002 08:34:28 -0600561_iso-8859-1 We were wondering if anyone else has experienced this problem. We're two-way datasharing, OS/390 2.10, DB2 V7. Our IMS and CICS are not yet sysplex so we have our systems pointing to only one member of the production datasharing groups. We just got our second z-series box two weeks ago. One box is 64 bit while the other is still 32 bit. We're planning on switching the new box to 64 bit this weekend but we're having some concerns. We've been having storage problems in our DBM1 address spaces on the subsystems that are on the box that is 64 [...]
8398 18 44_Re: Bank One is Hiring DB2 Data Sharing Guru13_Villa Horacio17_hvilla@TTI.COM.AR31_Thu, 31 Oct 2002 11:28:41 -0300506_iso-8859-1 Of course, it's very hard to accept that one's children will not have as high a standard of living as YOU do now.
Horacio Villa IBM Certified Solutions Expert-DB2 UDB V7.1 Admininstration for OS/390 TTI S.A. Buenos Aires - Argentina
================================================ 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.
8417 43 34_Re: Access Path for Cascade Delete10_Bruce, Mae26_BruceM@MAIL.OA.STATE.MO.US31_Thu, 31 Oct 2002 08:42:18 -0600386_iso-8859-1 Yes, I have. But the EXPLAIN does not show the access path for the child table. I only an entry for the parent table. Is there a way for the EXPLAIN to give me that info?
-----Original Message----- From: Martin Flavell [mailto:mflavell@I-TCS.COM] Sent: Thursday, October 31, 2002 8:07 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Access Path for Cascade Delete [...]
8461 15 39_Re: When is long too long? resubmitted.16_Tapio Lahdenmaki27_tapio_lahdenmaki@FI.IBM.COM31_Thu, 31 Oct 2002 08:42:49 -0600507_- Maybe this another index-related myth. The myths never die, they just fade away.
Long RID chains were a common performance problem with type 1 indexes, making delete of a single row very slow. The symptoms were high CPU time slow. The problem
================================================ 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.
8477 31 29_Mainframe DB2 Monitor ans SAP12_Paul Packham26_paul.packham@CONSIGNIA.COM31_Thu, 31 Oct 2002 14:46:41 +0000535_us-ascii Hi Everyone,
It might be the way we use it (sparingly I admit), but I have never thought that a traditional mainframe DB2 monitor on SAP gave us a great deal over what we can get out of CCMS. OK I know the batch reporting side of DB2PM (for example) is strong, but we don't use it. If we want historical information, we go to the PDB. I am giving some thought to ditching our mainframe monitor on SAP, and I was wondering what you're views on this are ? Is there anyone out there supporting complex SAP systems on [...]
8509 35 44_Re: Bank One is Hiring DB2 Data Sharing Guru10_Jose Moura25_jose.antonio.moura@CGD.PT31_Thu, 31 Oct 2002 15:10:27 -0000602_- Invisible professions and looking for who does better earning less:
Anyone from this list is perfectly unknown by the public (in what respects to DB2 activities). Can we compare our jobs with some professionals - even not considering sportsmen, actors and other performers - like lawyers and architects just to point a few in which people have some public exposure and can build a celebrity path? I can not imagine any reporter interviewing a DB2 DBA about a sucessful migration to production or any special bufferpool tuning. And that is the point. If this community could find a way to [...]
8545 42 47_Re: When is long too long? resubmitted. (retry)16_Tapio Lahdenmaki27_tapio_lahdenmaki@FI.IBM.COM31_Thu, 31 Oct 2002 09:17:20 -0600505_- Dennis,
Maybe this is another index-related myth. These myths never die, they just fade away.
Long RID chains were a common performance problem with type 1 indexes, making delete of a single row very slow. The symptoms were high CPU time and many seq prefetch requests. The reason was that DB2 had to search the RID chain until it found the RID that points to the row to be deleted. The standard solution was to add the primary key to the index if any key value has more 10,000 RIDs. [...]
8588 183 44_Re: Bank One is Hiring DB2 Data Sharing Guru18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Thu, 31 Oct 2002 10:28:35 -0500488_iso-8859-1 That is very true. Its the old 'out of site - out of mind' as to the way DB2/DBA's are viewed. But wait until that big ole legacy Database bites the dust and then we're the ones on the carpet for it. When I was with IBM for 20+ years it was ' don't bother us by saying you need this tool or that tool to better your job' just make it happen with what you have. Again until that Database crashes or the DASD fails they think this stuff runs by itself. My 2 cents worth.... [...]
8772 81 61_Re: SQL update that causes a row to move to another partition10_Todd Burch22_tburch@CDBSOFTWARE.COM31_Thu, 31 Oct 2002 09:51:02 -0600393_iso-8859-1 >From DB2 V5 Admin Guide:
# Recommendation: choose values for partitioning keys that are unlikely to # be updated. Updates that cause a row to move from one partition to another # have lower performance. To prevent degrading the performance of other SQL # statements that are in the same unit of work, update partitioning keys in # a separate unit of work, if possible. [...]
8854 38 36_Secondary Authids with multiple apps16_Philippe Godfrin38_philippe.godfrin@JUDICIARY.STATE.NJ.US31_Thu, 31 Oct 2002 10:21:23 -0600491_- Greetings oh esteemed listees....
We are using Secondary authids and ACF2 to secure our databases. The natural tendency is to group secondary authids by application.
So we would have app1: 2ndary auth app1.tbl1 idapp1
app2: app2.tbl2 idapp2
A third app is a 'global' enterprise app: global.tbl3 idglobal
I believe ACF2 does not allow groups within groups (e.g. group idapp1 would have group idlgobal included in it). So that leaves us in a quandry. [...]
8893 31 25_SQL0301N in websphere 4.011_Lynne Davis17_LDavis@LLBEAN.COM31_Thu, 31 Oct 2002 12:52:55 -0500483_US-ASCII We recently upgraded our production Websphere Application Server to 4.0. Since the upgrade we are seeing 2500+ SQL0301N's per day in our DB2 diag log. When we were running at Websphere Application Server 3.5 we were seeing 6 or less a day. We havethe DIAGLEVEL set to 4 in 3.5 and 4.0. We turned the DB2 statement monitor on but the reports don't show any -301 sqlcodes. (The time period on our statement report matches a time in the diag log when we got many -301's.) [...]
8925 42 34_DCLGEN use for many tables at once17_Giorgio De Nunzio25_giorgio.denunzio@UNILE.IT31_Thu, 31 Oct 2002 19:10:45 +0100380_US-ASCII Hi all!
I am learning some DB2 with an old MVS 5.2.2, DB2 v3.1 (please don't laugh.. ;-)
I have to generate SQL includes for table description in a C program (I mean EXEC SQL DECLARE MYTABLE TABLE stuff, and EXEC SQL BEGIN DECLARE SECTION; struct...). OK, I thought, this is DCLGEN job! I used it once, so here I am diligently studying DCLGEN details. [...]
8968 19 40_Re: Secondary Authids with multiple apps16_Philippe Godfrin38_philippe.godfrin@JUDICIARY.STATE.NJ.US31_Thu, 31 Oct 2002 12:07:57 -0600524_- OK - I'm answering my own post...
ACF2 does allow cross referencing of Spurce Groups - which is a group within a group. However, it doesn't work...
I think the auth exit is not cascading down the list of groups...
more on this later...
pg
================================================ 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.
8988 35 27_Bind Failure in DB2 Connect0_30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Thu, 31 Oct 2002 12:33:27 -0600575_us-ascii Hello,
We're stuck trying to bind the CLI/ODBC support. We're using DB2 Connect, PE, 7.2 The subsystem is DB2 V7.1 - OS/390 V2R10.
Here's the message:
LINE MESSAGES FOR db2ajgrt.bnd ------ -------------------------------------------------------------------- SQL0061W The binder is in progress. SQL0551N "" does not have the privilege to perform operation "GRANT EXECUTE" on object "NULLID.SQLABD01". SQLSTATE=42501 SQL0082C An error has occurred which has terminated processing. SQL0091N Binding was ended with "2" errors and "0" warnings. [...]
9024 39 33_Re: Help Need a Job for A DB2 DBA18_Gerrit Groenendaal22_groenen@WORLDONLINE.NL31_Thu, 31 Oct 2002 19:45:25 +0100355_iso-8859-1 Ronald,
Great, I never knowed what the acronyms of the letters spufi was! I'am in DB2 from 1989, of course IMS for a lot of years 1973, I hope that every body knows thay the DB2 catalog is based on IMS DB(pointers), may be CFMS. Who knows Chained File Management Systems(CFMS), that was before IMS? I'am old!, but DB2 is beautifull [...]
9064 192 34_Re: Access Path for Cascade Delete13_Merritt, Hank16_HMerritt@GHI.COM31_Thu, 31 Oct 2002 13:50:35 -0500452_iso-8859-1 Bruce,
With host variables and an unexpected access path, have you considered the bind option REOPT(VARS)? This bind option may fix this problem, but must be used very judiciously (i.e. never in online programs and only when absolutely necessary in batch programs). For details see section 7-3 of the Application Programming and SQL Guide, under the heading of "Using host variables efficiently". It's on page 678 of my version. [...]
9257 54 31_Re: Bind Failure in DB2 Connect12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 31 Oct 2002 10:52:53 -0800632_us-ascii Steve, What OS/390 DB2 authorities does the ID that was used to connect to OS/390 when the BIND was issued thru DB2 Connect? Easiest I've found is to have someone with SYSADM sign on thru CCA and issue the binds with their userid.
Myron --- Steve_Grimes@AISMAIL.WUSTL.EDU wrote: > Hello, > > We're stuck trying to bind the CLI/ODBC support. We're using DB2 Connect, > PE, 7.2 > The subsystem is DB2 V7.1 - OS/390 V2R10. > > Here's the message: > > LINE MESSAGES FOR db2ajgrt.bnd > ------ > -------------------------------------------------------------------- > SQL0061W The binder is in progress. > SQL0551N "" [...]
9312 164 31_Re: Bind Failure in DB2 Connect13_Merritt, Hank16_HMerritt@GHI.COM31_Thu, 31 Oct 2002 13:53:13 -0500577_iso-8859-1 Steve,
Does the userid entered in the panel when starting the binds have the appropriate authority on the host system that you are trying to connect to?
Hank Merritt
-----Original Message----- From: Steve_Grimes@AISMAIL.WUSTL.EDU [mailto:Steve_Grimes@AISMAIL.WUSTL.EDU] Sent: Thursday, October 31, 2002 1:33 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: [DB2-L] Bind Failure in DB2 Connect
Hello,
We're stuck trying to bind the CLI/ODBC support. We're using DB2 Connect, PE, 7.2 The subsystem is DB2 V7.1 - OS/390 V2R10. [...]
9477 58 44_Re: Bank One is Hiring DB2 Data Sharing Guru16_Philippe Godfrin38_philippe.godfrin@JUDICIARY.STATE.NJ.US31_Thu, 31 Oct 2002 12:59:28 -0600466_- Well, here's my two cents - um - too...
This is a topic that is near and dear to our hearts (and wallets) because this affects us directly. Therefore it's pretty easy to get emotional and lose oneselves in ideological name calling.
So I will be honest and to the point.
This situation is exactly like what has happened to the manufacturing base in the USA. Corporations have moved manufacturing out of this country because it is cheaper. [...]
9536 121 33_Re: Help Need a Job for A DB2 DBA12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Thu, 31 Oct 2002 14:00:48 -0500699_us-ascii Gee i always thought it was SQL Processor Using File Input(SPUFI).
Gerrit Groenendaal Sent by: DB2 Data Base Discussion List 10/31/02 01:45 PM Please respond to DB2 Data Base Discussion List
To: DB2-L@LISTSERV.YLASSOC.COM cc: Subject: Re: Help Need a Job for A DB2 DBA
Ronald,
Great, I never knowed what the acronyms of the letters spufi was! I'am in DB2 from 1989, of course IMS for a lot of years 1973, I hope that every body knows thay the DB2 catalog is based on IMS DB(pointers), may be CFMS. Who knows Chained File Management Systems(CFMS), that was before [...]
9658 174 38_Re: DCLGEN use for many tables at once13_Mark A. Doyle19_mdoyle@JCPENNEY.COM31_Thu, 31 Oct 2002 13:17:19 -0600558_iso-8859-1 Giorgio,
I'm not completely sure what you are trying to accomplish, but have you considered using SPUFI to build the DB2 DCLGEN commands statements? Below is a SPUFI SQL statement I used to create my DCLGEN members. You will have to do a small amount of editing on the input for your situation V3, C language, your library, etc -- and to remove the RTRIM DB2V6 function. And some editing on the output to make it usable, but this should give you the control cards for your job. The second gives you include statements (for the C code) [...]
9833 76 33_Re: Help Need a Job for A DB2 DBA14_David S. Waugh24_dwaugh@NOTES.STATE.NE.US31_Thu, 31 Oct 2002 13:25:21 -0600474_us-ascii SPUFI actually stands for SQL Processor Using File Input, not what that one fellow posted (his definition was a little tongue-in-cheek)...
Thanks, David
"In my next life, I'm going to have more memory installed..."
Gerrit Groenendaal To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Help Need a Job for A DB2 DBA Sent by: DB2 Data Base Discussion List [...]
9910 102 31_Re: Bind Failure in DB2 Connect0_30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Thu, 31 Oct 2002 13:27:32 -0600445_us-ascii Hi - yes - we think so. We used an ID that I was told was the "alternate SYSADM", whatever that means.
Plus, I used SYSADM to GRANT the "alternate sysadm" - SYSADM authority.
Same error.
Stg
"Merritt, Hank" To: DB2-L@LISTSERV.YLASSOC.COM Sent by: DB2 Data cc: Base Discussion Subject: Re: Bind Failure in DB2 Connect List [...]
10013 48 29_Re: SQL0301N in websphere 4.014_Manas Dasgupta22_dasgupta@BELLSOUTH.NET31_Thu, 31 Oct 2002 14:45:15 -0500386_iso-8859-1 Did you also upgrade DB2 Connect / Client around the same time or are you in V7 FP1 or FP2? I believe V7 Fp1 or Fp2 introduced some -301 errors? Thanks, Manas. ----- Original Message ----- From: "Lynne Davis" Newsgroups: bit.listserv.db2-l To: Sent: Thursday, October 31, 2002 12:52 PM Subject: SQL0301N in websphere 4.0 [...]
10062 52 33_Re: Help Need a Job for A DB2 DBA13_Davis, Ronald17_DavisRo@CONED.COM31_Thu, 31 Oct 2002 14:51:10 -0500624_ISO-8859-1 Today SPUFI is SQL Processing Using File Input.
-----Original Message----- From: Gerrit Groenendaal [mailto:groenen@WORLDONLINE.NL] Sent: Thursday, October 31, 2002 1:45 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Help Need a Job for A DB2 DBA
Ronald,
Great, I never knowed what the acronyms of the letters spufi was! I'am in DB2 from 1989, of course IMS for a lot of years 1973, I hope that every body knows thay the DB2 catalog is based on IMS DB(pointers), may be CFMS. Who knows Chained File Management Systems(CFMS), that was before IMS? I'am old!, but DB2 is beautifull [...]
10115 33 34_Re: Access Path for Cascade Delete10_Bruce, Mae26_BruceM@MAIL.OA.STATE.MO.US31_Thu, 31 Oct 2002 13:53:12 -0600737_iso-8859-1 Thanks for the suggestion, but it is already bound with REOPT(VARS).
Mae
-----Original Message----- From: Merritt, Hank [mailto:HMerritt@GHI.COM] Sent: Thursday, October 31, 2002 12:51 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Access Path for Cascade Delete
Bruce,
With host variables and an unexpected access path, have you considered the bind option REOPT(VARS)? This bind option may fix this problem, but must be used very judiciously (i.e. never in online programs and only when absolutely necessary in batch programs). For details see section 7-3 of the Application Programming and SQL Guide, under the heading of "Using host variables efficiently". It's on page 678 [...]
10149 41 40_Re: Secondary Authids with multiple apps16_Miller, Marilynn22_Marilynn.Miller@CA.COM31_Thu, 31 Oct 2002 14:58:26 -0500531_iso-8859-1 Did you try calling ACF2 TechSupport? They might have a suggestion. (They sit in my wing here at CA)
-----Original Message----- From: Philippe Godfrin [mailto:philippe.godfrin@JUDICIARY.STATE.NJ.US] Sent: Thursday, October 31, 2002 12:08 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Secondary Authids with multiple apps
OK - I'm answering my own post...
ACF2 does allow cross referencing of Spurce Groups - which is a group within a group. However, it doesn't work... [...]
10191 64 29_Re: SQL0301N in websphere 4.011_Lynne Davis17_LDavis@LLBEAN.COM31_Thu, 31 Oct 2002 15:06:49 -0500528_US-ASCII yes, we did upgrade DB2 Connect at the same time.
thanks for your response, lynne
>>> dasgupta@BELLSOUTH.NET 10/31/02 02:45PM >>> Did you also upgrade DB2 Connect / Client around the same time or are you in V7 FP1 or FP2? I believe V7 Fp1 or Fp2 introduced some -301 errors? Thanks, Manas. ----- Original Message ----- From: "Lynne Davis" Newsgroups: bit.listserv.db2-l To: Sent: Thursday, October 31, 2002 12:52 PM Subject: SQL0301N in websphere 4.0 [...]
10256 63 34_Re: Access Path for Cascade Delete11_David Nance16_DWNance@FHSC.COM31_Thu, 31 Oct 2002 15:13:05 -0500457_US-ASCII Mae, What is the locking like on the child table? In a past life, I had a similar problem. We had deletes against a parent table that could only be done at certain times of day to the high use on the child table and that was even with having deleted the child row first. One thing we started doing on a rather large set of tables that had very high usage was to do a reorg with delete, then run check data on the child, it worked fairly well. [...]
10320 182 34_Re: Access Path for Cascade Delete15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Thu, 31 Oct 2002 15:21:56 -0500498_iso-8859-1 Check whether the host variable type and length match with table column. DB2 suppose to be using index on cascade delete if the index is the same order of the foreign. But there is no way to verify it. This is one of the many things missing in DB2.
thanks..sibi
-----Original Message----- From: Merritt, Hank [mailto:HMerritt@GHI.COM] Sent: Thursday, October 31, 2002 12:51 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Access Path for Cascade Delete [...]
10503 156 31_Re: Bind Failure in DB2 Connect0_30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Thu, 31 Oct 2002 14:38:54 -0600475_us-ascii Hello,
Well, when I went out to tell them about this, they said it is apparantly now working. No one is sure what fixed it -- several folks went off and were trying their own ideas in separate corners. Hoo-boy....
Stg ----- Forwarded by Steve Grimes/Systems/ais on 10/31/2002 02:39 PM -----
"Manas Dasgupta" To: Subject: Re: Re: Bind Failure in DB2 Connect 10/31/2002 02:16 PM [...]
10660 25 26_DB2UEXT2 for DB2 V7 on AIX0_19_csutfin@AMSOUTH.COM31_Thu, 31 Oct 2002 14:39:51 -0600589_us-ascii I'm confused.
Where should the executable for the User exit be stored on AIX?
in /sqllib/bin/ or in sqllib/adm/ as is states in the sample exit.
The manual does not really specify where it belongs.
Thanks Carol Sutfin Corporate DBA AmSouth Bank (205)326-5214 Fax:(205)326-5613 csutfin@amsouth.com
================================================ 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.
10686 48 34_Re: Access Path for Cascade Delete10_Bruce, Mae26_BruceM@MAIL.OA.STATE.MO.US31_Thu, 31 Oct 2002 14:52:41 -0600339_iso-8859-1 The locking on the child table is a pageset lock with intent exclusive at the tablespace level. There are no locks on the index on this table (which is why I decided it was doing a ts scan.) We are running this currently in our development environment, so I am not getting into locking contentions with other applications. [...]
10735 15 30_Re: DB2UEXT2 for DB2 V7 on AIX11_Mike Fatula22_mfatula@AESSUCCESS.ORG31_Thu, 31 Oct 2002 15:54:38 -0500380_us-ascii THE USER EXIT RESIDES IN PATH /DB2/DBLGS/SQLLIB/ADM
DB2UEXT.C IS THE SOURCE CODE DB2UEXT2 IS THE OBJECT CODE
================================================ 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.
10751 70 34_Re: Access Path for Cascade Delete13_Steve Tennant28_steve.tennant@CUSTOMS.GOV.AU30_Fri, 1 Nov 2002 07:55:14 +1100404_iso-8859-1 Hi Bruce, One thing that caught me in the past was that the index _appeared_ to match but in fact one column was ASCending in one index and DESCending in another.
Regards,
Steve T
-----Original Message----- From: Bruce, Mae [mailto:BruceM@MAIL.OA.STATE.MO.US] Sent: Friday, 1 November 2002 00:44 To: DB2-L@LISTSERV.YLASSOC.COM Subject: Access Path for Cascade Delete [...]
10822 120 45_Re: Online Reorg causing Unavailable Resource16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Thu, 31 Oct 2002 10:53:36 -0500666_iso-8859-1 The problem is not usually LOCKS, but CLAIMS. The display needs to be -DIS DB(dbname) SPACE(tsname,ixname1,ixname2,...) CLAIMERS ONLY
Regards, Eric Pearson NS ITO DB2 support
-----Original Message----- From: David S Waugh [mailto:dsw-dba@JUNO.COM] Sent: Wednesday, October 30, 2002 3:28 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Online Reorg causing Unavailable Resource
Conor:
You're pretty much on the money with your explanation -- some other process is probably holding locks and the Online Reorg SWITCH phase sits and waits for the locks to be freed. I've had the same problem from time to time. [...]
10943 43 34_Re: Access Path for Cascade Delete10_Bruce, Mae26_BruceM@MAIL.OA.STATE.MO.US31_Thu, 31 Oct 2002 14:59:53 -0600559_iso-8859-1 The cobol program has the host variables defined like this which matches up, I beleive. REG X(1) POS X(4) APP S9(9) COMP
The MEMBER table also has a FK from another parent table (REQUEST), and the primary key and primary index on the MEMBER table includes this column as the first column. But I do have another unique index defined that contains the FK fields from MEMBER which the leading columns are the FK columns and are in the order that the FK columns are. My understanding was that the index on the FK columns did not have to be [...]
10987 45 30_Re: DB2UEXT2 for DB2 V7 on AIX18_Stritzinger, David24_StritzingerD@NABISCO.COM31_Thu, 31 Oct 2002 15:59:52 -0500438_- Carol,
The ~/sqllib/bin is a symbolic link back to $DB2DIR/sqllib/bin, so if you want a different user exit for each instance, then it must go into the ~/sqllib/adm. At least that is the way my system is set-up.
Dave S.
-----Original Message----- From: csutfin@AMSOUTH.COM [mailto:csutfin@AMSOUTH.COM] Sent: Thursday, October 31, 2002 3:40 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: DB2UEXT2 for DB2 V7 on AIX [...]
11033 51 30_Re: DB2UEXT2 for DB2 V7 on AIX15_Janardhan Ragam16_sragam@YAHOO.COM31_Thu, 31 Oct 2002 13:06:51 -0800563_us-ascii It should exist under sqllib/adm. What I would suggest is to leave the executable in one place, say sqllib/bin (or whatever your shop std. is), and create a link under sqllib/adm.
Sai J Ragam. IBM Certified DB2 DBA. Oracle 8i Certified DBA. SQL Server DBA. --- csutfin@AMSOUTH.COM wrote: > I'm confused. > > Where should the executable for the User exit be > stored on AIX? > > in /sqllib/bin/ or in sqllib/adm/ as is states in > the sample exit. > > The manual does not really specify where it belongs. > > Thanks > Carol Sutfin > Corporate [...]
11085 50 14_Trigger Insert11_John Kruger23_DHSPA43@DHS.STATE.IL.US31_Thu, 31 Oct 2002 16:10:36 -0600411_US-ASCII I have a trigger that automates the incrementing of a sequence number.
CREATE TRIGGER DHSDB2.TRCSBSABI00 NO CASCADE BEFORE INSERT ON DHSDB2.TBCSBSA REFERENCING NEW AS NewRow FOR EACH ROW MODE DB2SQL WHEN ((NewRow.INDV_SQNM = 0) OR (NewRow.INDV_SQNM is null)) Begin atomic SET NewRow.INDV_SQNM = ( SELECT COALESCE(MAX(INDV_SQNM),0)+1 FROM DHSDB2.TBCSBSA WHERE INDV_ID=NewRow.INDV_ID ); end; [...]
11136 136 45_Re: Online Reorg causing Unavailable Resource13_David S Waugh16_dsw-dba@JUNO.COM29_Thu, 31 Oct 2002 22:24:37 GMT467_- Good point Eric. If you wanted to be really thorough, you probably should issue 3 displays: -DIS DB(dbname) SPACE(tsname,ixname1,ixname2,...) CLAIMERS ONLY -DIS DB(dbname) SPACE(tsname,ixname1,ixname2,...) LOCKS ONLY -DIS DB(dbname) SPACE(tsname,ixname1,ixname2,...) USE ONLY
that should catch just about anything that might interfere with the SWITCH phase.
David Waugh, NCW
---------- "Pearson, Eric L," writes: [...]
11273 32 54_Re: Help Need a Job for A DB2 DBA / the history of DB213_David S Waugh16_dsw-dba@JUNO.COM29_Thu, 31 Oct 2002 22:32:35 GMT361_- Yep - one foot in the grave, and the other on a banana peel...
David Waugh Certified bald AND gray, creaking badly
---------- Max Scarpa writes:
From: Max Scarpa To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Help Need a Job for A DB2 DBA / the history of DB2 Date: Thu, 31 Oct 2002 09:37:10 +0100 [...]
11306 31 23_Really, really old code14_Allen, Susan A24_susan.a.allen@BOEING.COM31_Thu, 31 Oct 2002 15:09:19 -0800379_iso-8859-1 I am rehosting an application that has code that was not upgraded to DB2 V5 (we are at V7) OS/390
I am looking at more then one cursor declaration that start off as:
DECLARE IMPLICIT CURSOR FOR
and I am fairly certain this is not correct; but since I mainly write stored procedures; perhaps I am wrong about the need for unique cursor names. [...]
11338 36 40_Re: Secondary Authids with multiple apps11_Tim Wilkins25_richard.wilkinsjr@GTE.NET31_Thu, 31 Oct 2002 18:40:40 -0800300_us-ascii Philippe
I will try to look around in some of my older ACF2 documentation and see how that was done. I know it can be done however if you should consider doing a conversion to RACF at some future date it does cause some problems because RACF does not allow groups within groups. [...]
11375 50 66_Platinum Log Analyzer extract problem. Can some guru help us here!11_Linda Ayeni22_lindaayeni@HOTMAIL.COM31_Thu, 31 Oct 2002 20:51:58 -0700585_- Dear listers, We are DB2 V6 and currently developing a "in-house" replication process for our web application. We have created a DB2 Log extract strategy that produces DML activity report. This report is critical to our web application and data integrity is absolutely no 1. We extract log data for a given set of tables and after massaging the extract file, FTP the output to webserver for application use. The problem (if it is a problem) is this: After extracting from the archive or current log for a given date range, we are discovering multiple INSERTS for the same table [...]