1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l September 2000, week 1
2 72 33_Re: check data control statements14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Fri, 1 Sep 2000 16:49:29 +1100349_iso-8859-1 Alison<br><br>Once upon a time I had to do this. Knowing that all RI was between tables with the same creator ID, I just generated a FOR EXCEPTION IN list that had every table that was a child table and used the list for every CHECK DATA. DB2 (V6) didn't object to having exception tables that weren't descendants of the checked ts. [...]
75 18 44_Pamela Harris/IT/SEARS is out of the office.0_17_pharri1@SEARS.COM30_Fri, 1 Sep 2000 02:15:26 -0500537_us-ascii I will be out of the office from 08/31/2000 until 09/06/2000.<br><br>If you need assistance with DB2, please use the primary DB2 pager, for informix use the primary informix pager, for network issues please call Bill Pugh, PIN # 7270063.<br><br>DB2 pin # 7270526, Informix pin # 7270525<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
94 22 26_Detect Defer Define Option16_Roland Schiradin28_SchiradinR@ALTE-LEIPZIGER.DE30_Fri, 1 Sep 2000 09:42:18 +0200583_- PQ30999 introduced the defer define option for Tablespaces. Unfortunally the runstats utility ends with RC8 (DSNU185I) if one of tablespace are "undefined" and all following runstats statements are lost.<br><br>PQ34386 says it should end with RC0<br><br>However what is the best way to detect such a tablespace (db2-catalog)?<br><br>Roland<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
117 81 31_Re: Delaying Archive Log Copies12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK30_Fri, 1 Sep 2000 08:47:00 +0100324_- Its probably worth issuing an ARCHIVE LOG command and check that it is sucessful just before the tapes are taken out to ensure all of your logs are empty.<br><br>Colin Allen Abbey National ---------- From: john arbogast To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Delaying Archive Log Copies Date: 31 August 2000 08:52PM [...]
199 135 17_Re: DB2 SQL codes17_Alessandro Brezzi28_brezzi.isac@INTERBUSINESS.IT30_Fri, 1 Sep 2000 10:04:46 +0200650_us-ascii Hi all, my two cents ... I suppose the real question to pose is "How not to use the standard SQLSTATE, opposed to the old, deprecated SQLCODE?".<br><br>I'm a little curios about this: how many DB2 programmers write portable program using SQLSTATE tests?<br><br><br><br>ALessandro<br><br><br><br>>0 - good return >100 - no row found >803 - dupe row >805 - bad bind on dbrm package or plan >904 - resource unavailable > >----- Original Message ----- >From: "Ashish Mahajan" <blue_sky@WORLDNET.ATT.NET> >Newsgroups: bit.listserv.db2-l >To: <DB2-L@RYCI.COM> >Sent: Thursday, August 31, 2000 8:09 PM >Subject: DB2 SQL codes > > >> Hi! >> >> [...]
335 61 25_Re: DB2 for OS/390 to UDB12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Fri, 1 Sep 2000 11:10:09 +0200565_x-user-defined Hi, Once there used to be ISPF for PC. I worked on it and it was the same as on MVS, you could even wright REXX and execute it inside ! Where did it go ?<br><br>Isaac Yassin<br><br>"Philip, Sibimon" wrote: > > Just for information > > There is PC editor called TEXTPAD,(Not free, but can get the trial version > from TEXTPAD.COM). This is the best editor I used in the PC. > > Thanks > Sibimon Philip > > -----Original Message----- > From: Edward(Ed) J. Finnell, III [mailto:efinnell@SEEBECK.UA.EDU] > Sent: Wednesday, August 30, 2000 1:10 PM > [...]
397 181 17_Re: DB2 SQL codes0_18_mebert@AMADEUS.NET30_Fri, 1 Sep 2000 10:06:06 +0200606_us-ascii Hi Ash,<br><br>I might agree that somebody developing application programs for DB2 can be expected to know the meaning of SQL return codes 0,+100, and <0 because you have to test for these routinely (at least on the mainframe - PC GUI applications using class libraries and IDEs probably are entirely different). For a DB2 Administrator (such as myself), it is considerably less important because the work focus is different. I happened to know 0, +100 and -805 just because I love to tell developers how they can dramatically improve their programs. But there are hundreds of SQL codes (and [...]
579 399 25_Re: DB2 for OS/390 to UDB12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Fri, 1 Sep 2000 11:15:47 +0200706_x-user-defined Hi, I once wrote this for UNIX people that needed to work on the MF, it helped to ease the pain (for them)...<br><br>/* REXX */ TRACE O "ISREDIT MACRO (PARM) " "ISPEXEC CONTROL ERRORS RETURN" PARSE UPPER VAR PARM CMD STR COL IF CMD='' THEN CALL INFO; IF STR='' THEN STR=CMD; LSTR=LEFT(STR,1); IF LSTR='!' THEN STR=SUBSTR(STR,2); SELECT; WHEN LEFT(STR,1)='[' THEN CALL PATTERN; WHEN LEFT(STR,1)='~' THEN CALL START ; WHEN CMD='-V' | LSTR='!' THEN "ISREDIT EXCLUDE ALL '"STR"'"; OTHERWISE DO; "ISREDIT EXCLUDE ALL" "ISREDIT FIND ALL '"STR"'" END; END; /* "ISREDIT DELETE ALL EXCLUDE" "ISREDIT RESET" */ RETURN; /*****************************************************************/ PATTERN: [...]
979 102 35_SV: Visual Explain for db 0s/390 v60_19_Sven.Heidorn@CSN.SE30_Fri, 1 Sep 2000 10:48:44 +0200594_ISO-8859-1 You need to create the DSN_STATEMENT_TABLE which will hold the cost estimates from explain. See the V6 Application programming and SQL guide, page 679 - 683.<br><br>Sven Heidorn > -----Ursprungligt meddelande----- > Från: ttaylor@CHUBB.COM [SMTP:ttaylor@CHUBB.COM] > Skickat: den 31 augusti 2000 21:24 > Till: DB2-L@RYCI.COM > Ämne: Re: Visual Explain for db 0s/390 v6 > > how about v6 and/or v7 ? > > > > > > > > > Dan Tuck <dan_tuck@YAHOO.COM> on 08/31/2000 03:11:22 PM > > Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM> > > > > > > > > > To: DB2-L@RYCI.COM [...]
1082 138 17_Re: DB2 SQL codes10_John Hardy27_john_j_hardy@CONSULTANT.COM30_Fri, 1 Sep 2000 04:28:56 -0500420_- Hello Ash,<br><br>I would expect any potential candidate for a role as a developer in an OS/390 site (especially for a temporary position), to be able to recognise some basic SQL Codes. I would not worry too much if they got some wrong, but if, for instance, they did not know what an SQLCODE 0 or +100 meant, then the chances are that they have absolutely no experience of developing mainframe DB2 applications. [...]
1221 33 8_Sysibm.*9_Harish P.32_ParameswaranHarish@HALIFAX.CO.UK30_Fri, 1 Sep 2000 11:23:15 +0100797_us-ascii All,<br><br>As a new entrant to DB2, I would like to understand the working of the SYSIBM.* tables. Any idea where can I find the best possible information/reference??<br><br>Thanks.<br><br><br><br>Harish Parameswaran. Contractor - NMSP Programme. > * 01422 3(35192). Fax 01422 3(35614). mailto:ParameswaranHarish@halifax.co.uk. > * DC/G1/NMSP<br><br>------------------------------------------------------------------------------ Part of the Halifax Group, Halifax Group plc, Registered in England No. 2367076. Registered Office: Trinity Road, Halifax, West Yorkshire HX1 2RG. Represents only the Halifax Financial Services Marketing Group for the purposes of advising on and selling life assurance, pensions and unit trust business. The Marketing Group is regulated by the Personal [...]
1255 80 12_Re: Sysibm.*14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK30_Fri, 1 Sep 2000 11:36:19 +0100620_iso-8859-1 Try the SQL Reference Manual<br><br>Marcus<br><br>-----Original Message----- From: Harish P. [mailto:ParameswaranHarish@HALIFAX.CO.UK] Sent: 01 September 2000 11:23 To: DB2-L@RYCI.COM Subject: Sysibm.* Importance: High Sensitivity: Confidential<br><br><br><br>All,<br><br>As a new entrant to DB2, I would like to understand the working of the SYSIBM.* tables. Any idea where can I find the best possible information/reference??<br><br>Thanks.<br><br><br><br>Harish Parameswaran. Contractor - NMSP Programme. > * 01422 3(35192). Fax 01422 3(35614). mailto:ParameswaranHarish@halifax.co.uk. > * DC/G1/NMSP [...]
1336 63 12_Re: Sysibm.*19_Briggs, N. - Neil -25_N.Briggs@CANON-EUROPA.COM30_Fri, 1 Sep 2000 12:42:08 +0200317_ISO-8859-1 Ask your site DBA to loan you a copy of the DB2 reference Summary. This is a little book that provide a list of all the cat/dir tables with a brief description of the table and all the column names. Failing that a good book such as the DB2 developers guide will give you all the information you need. [...]
1400 104 30_Re: Detect Defer Define Option0_18_mebert@AMADEUS.NET30_Fri, 1 Sep 2000 13:13:27 +0200362_us-ascii SYSINDEXPART/SYSTABLEPART have SPACE column set to -1 for undefined datasets (see APAR text for PQ30999). Re the RC=8: check whether UQ40812 is really applied, and that you pick up DSNUTILB from the correct library. If yes... tell IBM.<br><br>Hth<br><br>Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany [...]
1505 117 23_Re: move DB2 v4.1 to v615_Loria, Susan C.27_Susan_C_Loria@TVRATINGS.COM30_Fri, 1 Sep 2000 07:55:19 -0400549_iso-8859-1 Hi Lisa,<br><br>In our environment, our plans were to skip V5 and go from V4.1 to V6.1, but the way we have done it, was to completely build a V6.1 subsystem as a brand new environment and capture all the application DDL, data, authorizations, etc. from our V4.1 subsystem and build them into our new V6.1 subsystem. The same was done for going from QMF V3.2 to V6.1, we unloaded our PROCs, Queries, forms, etc. and loaded them into our new QMF V6.1 tables. This method was done when we went from V2.3 of DB2 to V4.1 and worked well [...]
1623 259 17_Re: DB2 SQL codes15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Fri, 1 Sep 2000 07:25:19 -0500561_iso-8859-1 I agree! Some common ones are known simply because one encounters them often but I certainly wouldn't waste my time memorizing these things. I can look them up. It is much more important that I have a good understanding of how the systems works and be interested in continuing my education. I have worked in IT for 15 years and have a large range of knowledge in many areas, not just DB2. I think my employers would rather I knew how to put together a system and keep it running and running efficiently rather than memorize stuff. Any idiot can [...]
1883 19 13_Reorg on-line15_Claudio Sanchez20_clsanchez@BNL.COM.AR30_Fri, 1 Sep 2000 10:06:43 -0300468_us-ascii Hello list, We want to have opinions on reorg on-line for BD2 V5, due to permanent online service. someone it using ? We want to know experiences or suggestions of other products that have this facility.<br><br>Thank.<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
1903 99 17_Re: Reorg on-line0_18_mebert@AMADEUS.NET30_Fri, 1 Sep 2000 15:01:41 +0200274_us-ascii We are using it since about one year... it works but is not quite the wonderful thing that IBM PR makes it. There have been lots of postings about OLR in the past, look in the DB2-L archives (via the web site) for discussions, hints & tips as an introduction. [...]
2003 46 17_Re: Reorg on-line11_Ray H Janes27_ray_h_janes@EMAIL.MOBIL.COM30_Fri, 1 Sep 2000 08:21:30 -0500443_us-ascii we've been using it for two years. Mainly in our large SAP testing environments, but also in production. Only in production during a normal maintance window (all night). Keep current with fixes. Also, there are some new switches recently introduced to try and make the online reorg fail if there is contention with threads. One nice thing is the recovery after a failure. Just -TERM UTIL and DB2 does a great job of cleaning up. [...]
2050 104 12_Re: Sysibm.*11_John Wallin24_john.wallin@ZURICHUS.COM30_Fri, 1 Sep 2000 08:38:44 -0500781_us-ascii DB2 Developers Guide by Craig Mullins<br><br><br><br><br><br><br><br><br><br>"Davage, Marcus" <Marcus.Davage@LLOYDSTSB.CO.UK> on 09/01/2000 05:36:19 AM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br>To: DB2-L@RYCI.COM cc: (bcc: John Wallin/ZI/USA/Zurich)<br><br>Subject: Re: Sysibm.*<br><br><br><br><br><br>Try the SQL Reference Manual<br><br>Marcus<br><br>-----Original Message----- From: Harish P. [mailto:ParameswaranHarish@HALIFAX.CO.UK] Sent: 01 September 2000 11:23 To: DB2-L@RYCI.COM Subject: Sysibm.* Importance: High Sensitivity: Confidential<br><br><br><br>All,<br><br>As a new entrant to DB2, I would like to understand the working of the SYSIBM.* tables. Any idea where can I find the best possible information/reference?? [...]
2155 90 25_Re: DB2 for OS/390 to UDB12_Higgins John25_HigginsJohn@JOHNDEERE.COM30_Fri, 1 Sep 2000 08:46:58 -0500649_us-ascii Check out http://www.commandtechnology.com/ctcspfse.htm<br><br>Best regards, John P. Higgins Performance Specialist SAP BASIS Team<br><br>Deere & Company Voice: (309) 748-1625 Attn: GTTC East FAX: (309) 748-1605 One John Deere Place email: HigginsJohn@JohnDeere.com Moline, IL 61265-8098<br><br>> -----Original Message----- > From: Isaac Yassin [SMTP:yassin@NETVISION.NET.IL] > Sent: Friday, September 01, 2000 4:10 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2 for OS/390 to UDB > > Hi, > Once there used to be ISPF for PC. I worked on it and it was the same as > on MVS, you could even > wright REXX and execute it inside ! > Where did [...]
2246 90 31_Re: DSNL512I : DDF CANNOT START11_John Wallin24_john.wallin@ZURICHUS.COM30_Fri, 1 Sep 2000 08:58:12 -0500442_us-ascii TCPIP runs on the mainframe as an address space. NT will talk TCPIP with or without OE being present. Is the database on OE or OS/390? If it is on OS/390 the definitions for the sockets must be in the TCPIP startup parms. If the socket numbers agree it is possible that the TCPIP address space is not initializing socket correctly because of your OE startup error. This is a TCPIP problem ----- check with your local TCPIP Guru [...]
2337 20 29_DB2 V6 for OS/390 Try vs. Buy27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM30_Fri, 1 Sep 2000 09:00:26 -0500309_- Can someone explain how the try & buy options work? If I install something (like QMF) with the try option and then decide to buy it, do I have to do a full install of the buy option since it's a different FMID? SMPE-wise, that sounds like the way it would have to work, but would take a lot of effort. [...]
2358 53 33_Re: DB2 V6 for OS/390 Try vs. Buy15_Loria, Susan C.27_Susan_C_Loria@TVRATINGS.COM30_Fri, 1 Sep 2000 10:06:47 -0400435_iso-8859-1 Tina,<br><br>I have installed QMF V6.1 as we bought and use it. Following the program directory, I had to install the HSQ6610 (BUY) first (which is basically a full install as it had many more modules) and then I had to install the JSQ6611 (TRY) FMID next which has very minimal modules. IBM recommends following the program directory steps exactly as I had to talk to them about a problem we encountered, see below... [...]
2412 295 17_Re: DB2 SQL codes16_Provenzola, Tony24_Tony.Provenzola@NIKE.COM30_Fri, 1 Sep 2000 07:08:17 -0700563_iso-8859-1 When I was a computer operator, I once went to an interview and, while drilling me about hardware (model numbers and the such), the interviewer asked, "What's an SB37?". I couldn't think of any device with a model number of SB37, so I said I didn't know. 10 minutes after the interview, I realized that she was asking about a B37 System Error, an out-of-space condition that I dealt with on a daily basis, but being nervous, hearing it out of context, and hearing SB37 instead of B37 (sure both are valid, but one was more familiar than the other [...]
2708 143 28_UDB AIX Inactive Buffer Pool17_McDonnell, Victor22_vmcdonnell@CAYENTA.COM30_Fri, 1 Sep 2000 07:29:25 -0700509_iso-8859-1 Good morning esteemed colleagues,<br><br>(Using UDB v6.1 on rs/6000 AIX) -- so I created a 4k buffer pool and tablespaces with it ok; than I created an 8k pufferpool. bufferpool. I could not create tablespaces in this bufferpool -- 'says it's 'INACTIVE'. Messages and codes says to stop and start DB (restart DB?) Did that -- no good. We can not stop the instance (DB2STOP) -- we have other databases which must remain up. bufferpool and tblspace code follows; has anyone experienced this???. [...]
2852 28 44_DB2 and GDPS Recovery and Other DR Questions12_rl_cotterill24_rl_cotterill@BIGPOND.COM30_Sat, 2 Sep 2000 01:25:45 +1000357_us-ascii Hi, Has anyone had experiences with using the GDPS Disastery Recovery offering from IBM or equivilant.<br><br>Also 1. has anyone realy got a true 24x7 365 day environment 2. what is the DR setup 3. what is the delay from a disaster being declared to being fully operational at another site (particulary if you use DR) 4. do you have data loss [...]
2881 62 32_Re: UDB AIX Inactive Buffer Pool13_Fletcher, Jim21_jim.fletcher@BSIS.COM30_Fri, 1 Sep 2000 10:32:32 -0400349_iso-8859-1 To make the new bufferpool effective, you must deactivate the database. This is done by terminating all connections to that database, including the one that issued the create commands. If the ACTIVATE DB command was issued for the db, then you also need to issue a DEACTIVATE DB command. A RESTART DB command alone will not suffice. [...]
2944 348 17_Re: DB2 SQL codes10_John Hardy27_john_j_hardy@CONSULTANT.COM30_Fri, 1 Sep 2000 09:37:21 -0500613_- I think the issue here is the interviewer's motivation. If the question about SQLCODEs was just one of a series of questions to establish the candidates all round knowledge and experience, then the question might be legitimate. If, however, the interviewer simply expects the candidate to repeat chapter and verse from the manual parrot fashion, then I agree that this is just plain stupid. Instead of asking "What is a -805 SQLCODE", the interviewer might ask "Suppose your program failed with a -805 SQLCODE, which basically means that DB2 cannot find your package. What kind of things might cause this, [...]
3293 133 17_Re: DB2 SQL codes15_Blaney, Bill L.21_Bill.L.Blaney@SSA.GOV30_Fri, 1 Sep 2000 11:15:35 -0400614_iso-8859-1 Ash,<br><br>Whenever I hear a question asked along these lines, my first reaction is to ask, "Why, did you lose your manuals?"<br><br>The ability to memorize long lists of trivial data is a trait of idiot savants; experienced professionals learn to quickly pick up whatever they need to work with the current product and drop it once its no longer needed. It's the nature of the job: new technologies are constantly being evaluated and implemented, and it's more important to be able to quickly understand a products concepts than to memorize facts that can be gleaned from a quick-reference card. [...]
3427 69 25_Re: DB2 for OS/390 to UDB0_22_Rohn.Solecki@MTS.MB.CA30_Fri, 1 Sep 2000 10:20:53 -0500565_us-ascii We have used versions SPF (at website John mentions) on the PC for about 5 years now. Earlier versions (ie SPF/PRO) were almost exactly same as ISPF edit on mainframe. Current versions, SPF/SE, have a Windoze front end on them (with the option of converting to 3270 format display), but still use many of the ISPF editor commands and conventions. The major advantage I find with it is response time. You never have to wait for the cursor or for a command to execute because you (the developer) is at the bottom of the CPU cycle priority list. You can [...]
3497 38 26_Reported TCB time from MVS12_SSS MacNiven21_SSS.MacNiven@SWEST.DE30_Fri, 1 Sep 2000 17:05:02 +0200325_us-ascii Hi folks. This is my first post to the list so please bear with me.<br><br>I would like to report via an Assembler Program the TCB and SRB CPU times for a JOB Step. They should be the same as reported in message IEF374I.<br><br>This appears to work as desired with everything except DB2 IKJEFT01 Batch queries. [...]
3536 267 17_Re: DB2 SQL codes13_john arbogast19_arbo@CP-DEMO.CP.NET30_Fri, 1 Sep 2000 08:31:02 -0700426_- Linda hits the nail right on the head! How short-sighted it seems to me to have potential employees take a quiz on return codes?! That is what documentation is for. Most mainframe people know the common codes from OS/390 and DB2 simply because they are common. How much good does it do to know what the definition of certain codes?? Knowing how to find the error and more importantly what to do next is the real skill. [...]
3804 294 17_Re: DB2 SQL codes12_Hall, Robert25_Robert.Hall@OCC.TREAS.GOV30_Fri, 1 Sep 2000 11:35:28 -0400543_iso-8859-1 I actually had an interviewer ask me "what is an sqlcode..."...and before I even heard the code, I *knew* it was going to be -818. Every interviewer had asked me about -818 up to that point. So when the code '-911' followed, I answered correctly and the interviewer told me I was wrong and proceeded to describe the -818 error code as some kind of timestamp problem. I wasn't sure if it was a trick to see if I would change my answer, so I quoted the error messages verbatim. After working with this person for a few months, I [...]
4099 328 17_Re: DB2 SQL codes13_Fletcher, Jim21_jim.fletcher@BSIS.COM30_Fri, 1 Sep 2000 11:34:47 -0400649_iso-8859-1 Why don't y'all pros just admit it... You didn't know the answers!!! Everyone have a good holiday.<br><br>-----Original Message----- From: john arbogast [mailto:arbo@CP-DEMO.CP.NET] Sent: Friday, September 01, 2000 11:31 AM To: DB2-L@RYCI.COM Subject: Re: DB2 SQL codes<br><br><br><br>Linda hits the nail right on the head! How short-sighted it seems to me to have potential employees take a quiz on return codes?! That is what documentation is for. Most mainframe people know the common codes from OS/390 and DB2 simply because they are common. How much good does it do to know what the definition of certain codes?? Knowing how to [...]
4428 306 17_Re: DB2 SQL codes15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Fri, 1 Sep 2000 10:42:22 -0500617_iso-8859-1 -----Original Message----- From: Hall, Robert [mailto:Robert.Hall@OCC.TREAS.GOV] Sent: Friday, September 01, 2000 10:35 AM To: DB2-L@RYCI.COM Subject: Re: DB2 SQL codes<br><br><br><br>I actually had an interviewer ask me "what is an sqlcode..."...and before I even heard the code, I *knew* it was going to be -818. Every interviewer had asked me about -818 up to that point. So when the code '-911' followed, I answered correctly and the interviewer told me I was wrong and proceeded to describe the -818 error code as some kind of timestamp problem. I wasn't sure if it was a trick to see if I would [...]
4735 310 17_Re: DB2 SQL codes15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Fri, 1 Sep 2000 10:43:04 -0500639_iso-8859-1 I LOVE that answer!! I'll have to remember to use that one and then duck.<br><br>Linda<br><br>-----Original Message----- From: Hall, Robert [mailto:Robert.Hall@OCC.TREAS.GOV] Sent: Friday, September 01, 2000 10:35 AM To: DB2-L@RYCI.COM Subject: Re: DB2 SQL codes<br><br><br><br>I actually had an interviewer ask me "what is an sqlcode..."...and before I even heard the code, I *knew* it was going to be -818. Every interviewer had asked me about -818 up to that point. So when the code '-911' followed, I answered correctly and the interviewer told me I was wrong and proceeded to describe the -818 error code as some kind [...]
5046 344 17_Re: DB2 SQL codes15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Fri, 1 Sep 2000 10:44:19 -0500537_iso-8859-1 Of course I don't but I know where to look it up.<br><br>Linda<br><br>-----Original Message----- From: Fletcher, Jim [mailto:jim.fletcher@BSIS.COM] Sent: Friday, September 01, 2000 10:35 AM To: DB2-L@RYCI.COM Subject: Re: DB2 SQL codes<br><br><br><br>Why don't y'all pros just admit it... You didn't know the answers!!! Everyone have a good holiday.<br><br>-----Original Message----- From: john arbogast [mailto:arbo@CP-DEMO.CP.NET] Sent: Friday, September 01, 2000 11:31 AM To: DB2-L@RYCI.COM Subject: Re: DB2 SQL codes [...]
5391 338 17_Re: DB2 SQL codes13_john arbogast19_arbo@CP-DEMO.CP.NET30_Fri, 1 Sep 2000 09:04:15 -0700591_- HA HA HA! U Funny! U Funny man!?!?!<br><br>20,000 comedians starving to death and this guy is trying to break into the business.<br><br>On Fri, 01 September 2000, "Fletcher, Jim" wrote:<br><br>> > Why don't y'all pros just admit it... > You didn't know the answers!!! > Everyone have a good holiday. > > -----Original Message----- > From: john arbogast [mailto:arbo@CP-DEMO.CP.NET] > Sent: Friday, September 01, 2000 11:31 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2 SQL codes > > > Linda hits the nail right on the head! How short-sighted it seems to me to > have potential employees [...]
5730 106 33_Re: check data control statements16_Alison Pelletier26_alison_pelletier@YAHOO.COM30_Fri, 1 Sep 2000 09:05:14 -0700531_us-ascii Hey, that'll work. We're V6 in one test environment, V5 in other test env. and prod. I'll test to see if that works for V5. I'll reply the results. Thanks for the tip...Alison --- James Campbell <James.Campbell@HANCORP.COM.AU> wrote: > Alison > > Once upon a time I had to do this. Knowing that all > RI was between tables > with the same creator ID, I just generated a FOR > EXCEPTION IN list that had > every table that was a child table and used the list > for every CHECK DATA. > DB2 (V6) didn't object to having [...]
5837 26 8_00c9008e15_Rameswara Pavan24_RPAVAN@ISETS.STATE.IN.US30_Fri, 1 Sep 2000 11:15:29 -0500421_us-ascii Hi, Anybody come across the error like<br><br>DSNT408I SQLCODE = -911, ERROR: THE CURRENT UNIT OF WORK HAS BEEN ROLLED BACK DUE TO DEADLOCK OR TIMEOUT. REASON 00C9008E, TYPE OF RESOURCE 00000D01, AND RESOURCE NAME 00000264.00000144 DSNT418I SQLSTATE = 40001 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXRFF SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = 115 13172746 13172878 13226969 1026420731 536871168 [...]
5864 15 44_John Berry/dp/LADPS/us is out of the office.0_22_JBerry@DPS.STATE.LA.US30_Fri, 1 Sep 2000 10:42:59 -0500395_us-ascii I will be out of the office starting 09/01/2000 and will not return until 09/02/2000.<br><br>I will react to your demand when I return, if ever.<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
5880 41 33_FW: DB2 V6 for OS/390 Try vs. Buy12_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM30_Fri, 1 Sep 2000 12:07:58 -0400442_iso-8859-1 Tina,<br><br>In my earlier assignment, I noticed for the Bufferpool tool that only some licensing load modules differed (on doing dataset compares) but this was for a Starter Pak 3000 system configuration.<br><br>Nadir<br><br><br><br>-----Original Message----- From: Hilton, Tina, BmS - NMI -PM [mailto:Tina.Hilton@BMSUS.COM] Sent: Friday, September 01, 2000 10:00 AM To: DB2-L@RYCI.COM Subject: DB2 V6 for OS/390 Try vs. Buy [...]
5922 300 17_Re: DB2 SQL codes15_David A. Zelmer25_david.zelmer@CITICORP.COM30_Fri, 1 Sep 2000 11:11:04 -0500555_us-ascii If you like that one then you probably will like the I D 10 T abend code as well! This abend code has many many many uses!<br><br>Billings, Linda wrote: > > I LOVE that answer!! I'll have to remember to use that one and then duck. > > Linda > > -----Original Message----- > From: Hall, Robert [mailto:Robert.Hall@OCC.TREAS.GOV] > Sent: Friday, September 01, 2000 10:35 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2 SQL codes > > I actually had an interviewer ask me "what is an sqlcode..."...and before I > even heard the code, I *knew* it was [...]
6223 399 17_Re: DB2 SQL codes10_John Hardy27_john_j_hardy@CONSULTANT.COM30_Fri, 1 Sep 2000 10:56:28 -0500310_- Well it gave me a laugh. Jim obviously had his tongue embedded firmly in his cheek. I think we might be giving a bad impression to newcomers to the list like Ash by letting this discussion degenerate into a flame war.<br><br>On Fri, 1 Sep 2000 09:04:15 -0700, john arbogast <arbo@CP-DEMO.CP.NET> wrote: [...]
6623 75 12_Re: 00c9008e14_Arnold, Mark S20_Mark.Arnold@BNSF.COM30_Fri, 1 Sep 2000 11:15:53 -0500570_iso-8859-1 00C9008E<br><br>Explanation: A lock request for the resource identified by NAME could not be granted, and the request waited for a period longer than the maximum specified by the installation.<br><br>+---------------+---------------------------------------+----------------¦<br><br>¦ 00000D01 ¦ DBID/OBID ¦ DI.OI ¦<br><br>+---------------+---------------------------------------+----------------¦<br><br><br><br>In other words, your table (00000264.00000144 - look it up in systables) is in use; you cannot have the lock you wanted (try again later....) [...]
6699 49 12_Re: 00c9008e11_Ray H Janes27_ray_h_janes@EMAIL.MOBIL.COM30_Fri, 1 Sep 2000 11:11:43 -0500434_us-ascii Something has a lock on the structure. Look up the name for the DBID/OBID in sysibm.systablespace for the 264/144. The lock should also show in your *MSTR log.<br><br><br><br><br><br><br><br>Rameswara Pavan <RPAVAN@ISETS.STATE.IN.US> on 09/01/2000 11:15:29 AM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br>To: DB2-L@RYCI.COM cc: (bcc: Ray H Janes/C/Dallas/Mobil-Notes) Subject: 00c9008e [...]
6749 96 12_Re: 00c9008e23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Fri, 1 Sep 2000 17:24:15 +0100437_iso-8859-1 but would a table not be UA.R -> A01 ?<br><br>Les<br><br>-----Original Message----- From: Arnold, Mark S [mailto:Mark.Arnold@BNSF.COM] Sent: Friday, September 01, 2000 5:16 PM To: DB2-L@RYCI.COM Subject: Re: 00c9008e<br><br><br><br>00C9008E E xplanation: A lock request for the resource identified by NAME could not b e granted, and the request waited for a period longer than the maximum s pecified by the installation. [...]
6846 360 17_Re: DB2 SQL codes12_HEPP SHERY C17_schepp@SRPNET.COM30_Fri, 1 Sep 2000 09:26:13 -0700420_ISO-8859-1 Robert- I loved your response- thanks for the sharing your humor this Friday-<br><br>Shery Hepp<br><br>-----Original Message----- From: David A. Zelmer [mailto:david.zelmer@CITICORP.COM] Sent: Friday, September 01, 2000 9:11 AM To: DB2-L@RYCI.COM Subject: Re: DB2 SQL codes<br><br>If you like that one then you probably will like the I D 10 T abend code as well! This abend code has many many many uses! [...]
7207 175 48_Additional information- S0C4 Abends in DB2/OS39012_Hall, Robert25_Robert.Hall@OCC.TREAS.GOV30_Fri, 1 Sep 2000 12:30:54 -0400547_iso-8859-1 Hello,<br><br>I posted this question a few weeks ago and I have a few more details; I checked out the suggestions given and they don't *appear* to be factors in this case. I have narrowed the problem down to one table (at least I think this is the problem!). We were only getting the 0C4's in our development DB2, and not in QA or production. I could not reproduce the abend in any other subsystem. While doing some work in a little used subsystem, I noticed that the table in question had 15 indices in development, but only 9 in [...]
7383 135 12_Re: 00c9008e19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Fri, 1 Sep 2000 11:32:04 -0500636_iso-8859-1 Isn't resource type 000000D01 a DBID/OBID, DI.OI pair . . .<br><br>Regards, Rick Davis<br><br>"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited." [...]
7519 436 17_Re: DB2 SQL codes15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Fri, 1 Sep 2000 11:52:08 -0500547_iso-8859-1 Yes, I think that an innocent question about SQL codes has touched upon a real sensitive area for people in IT. There is a real lack of understanding of what it takes to really succeed in this field. I think that several people in this rather long thread of responses have touched upon this. This is that to succeed one has to be really good at picking up a new technology and piecing it together rapidly. You have to know how to learn the system and build a pattern in your head into to resolve problems. Once you have thoroughly [...]
7956 497 17_Re: DB2 SQL codes0_22_BILL_GALLAGHER@PHL.COM30_Fri, 1 Sep 2000 13:01:33 -0400503_us-ascii This is why I am welcoming the DB2 Certification program for OS/390! I know that it's not going to buy me anything at my current job, but hopefully if I ever to plan to move on to another job, having DB2 for OS/390 certification on my resume will mean something to potential employers, and avoid silly questions. Being certified should (theoretically) be a good indication that I know my stuff, especially when combined with a well written resume documenting my real-life work experience. [...]
8454 153 12_Re: 00c9008e23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Fri, 1 Sep 2000 18:06:01 +0100683_iso-8859-1 indeed it is Rick<br><br>Les<br><br>-----Original Message----- From: DAVIS, RICK (SBCSI) [mailto:RD8246@MOMAIL.SBC.COM] Sent: Friday, September 01, 2000 5:32 PM To: DB2-L@RYCI.COM Subject: Re: 00c9008e<br><br><br><br>Isn't resource type 000000D01 a DBID/OBID, DI.OI pair . . .<br><br>Regards, Rick Davis<br><br>"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 [...]
8608 66 19_Interview Questions16_Brookman, Gerald32_gerald.brookman@US.ORIGIN-IT.COM30_Fri, 1 Sep 2000 13:12:48 -0400265_iso-8859-1 The next time you run into one of these "people", ask them if their company administers a "TSTB" test.<br><br>When they invariably ask what kind of test that is, inform them it stands for "Too Stupid To Breathe".<br><br>Gerald R. (Garry) Brookman<br><br>
8675 516 17_Re: DB2 SQL codes15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Fri, 1 Sep 2000 12:15:30 -0500378_iso-8859-1 That is true. My whole team is thinking about going for the certification. I just hope that the test is a true measure of understanding and not a quiz on DB2 trivia.<br><br>Linda<br><br>-----Original Message----- From: BILL_GALLAGHER@PHL.COM [mailto:BILL_GALLAGHER@PHL.COM] Sent: Friday, September 01, 2000 12:02 PM To: DB2-L@RYCI.COM Subject: Re: DB2 SQL codes [...]
9192 45 17_Re: DB2 SQL codes23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Fri, 1 Sep 2000 18:15:40 +0100491_iso-8859-1 Linda<br><br>>people trying to hire for IT positions. How on earth do you spot someone >who will be successful this kind of thing? As one person pointed out >someone can interview very well and then perform very poorly. References >can help but not always.<br><br>I have first hand experience of this. More often you hire them and they morph into a person you never hired. Me and my local friends in DB2 land in the UK work on reputation and thus an interview is not needed. [...]
9238 539 17_Re: DB2 SQL codes22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM30_Fri, 1 Sep 2000 13:20:32 -0400619_iso-8859-1 The DB2 for OS/390 Certification test is scheduled to be available at the DB2 Tech Conference the week of 10/16/2000.<br><br><br><br>Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com<br><br><br><br><br><br>-----Original Message----- From: Billings, Linda [mailto:linda.billings@DOA.STATE.WI.US] Sent: Friday, September 01, 2000 13:16 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] DB2 SQL codes<br><br><br><br>That is true. My whole team is thinking about going for the certification. I just hope that the test is a true measure of understanding and not a quiz on DB2 trivia. [...]
9778 699 17_Re: DB2 SQL codes12_Myron Miller22_myronwmiller@YAHOO.COM30_Fri, 1 Sep 2000 10:27:29 -0700670_us-ascii Doesn't the certification test cover Release 7 of DB2?<br><br>--- Piontkowski Michael ML <michael.piontkowski@ASTRAZENECA.COM> wrote: > The DB2 for OS/390 Certification test is scheduled > to > be available at the DB2 Tech Conference the week of > 10/16/2000. > > > Mike Piontkowski > Voice/Fax: 302.886.4612 > mailto:michael.piontkowski@astrazeneca.com > > > > -----Original Message----- > From: Billings, Linda > [mailto:linda.billings@DOA.STATE.WI.US] > Sent: Friday, September 01, 2000 13:16 > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] DB2 SQL codes > > > That is true. My whole team is thinking about going > for the certification. > I just hope that [...]
10478 17 17_Re: DB2 SQL codes13_Johnson, Bill18_bjo23@ALLSTATE.COM30_Fri, 1 Sep 2000 12:28:16 -0500462_- My guess is that the certification test will consists of questions like.....What does it mean when you get an -818 abend!!! The same questions you get during an interview.<br><br>Bill Johnson DBA Allstate Insurance Co.<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
10496 601 24_Re: DB2 SQL codes -Reply11_John Puglia15_JPUGLIA@PCH.COM30_Fri, 1 Sep 2000 13:29:47 -0400422_US-ASCII For those of us who are not attending this years DB2 Tech Conference, does anyone know when it will be available?<br><br>I read September it would be available, but here we are 9/1 and no sign of the test on the IBM site.<br><br>>>> michael.piontkowski@ASTRAZENECA.COM 09/01/00 01:20pm >>> The DB2 for OS/390 Certification test is scheduled to be available at the DB2 Tech Conference the week of 10/16/2000. [...]
11098 388 17_Re: DB2 SQL codes13_Olson, Carlos14_COlson@QRS.COM30_Fri, 1 Sep 2000 10:27:28 -0700556_iso-8859-1 I totally agree with you that questions about SQLCODEs as just one of a series of questions to establish all around knowledge and experience is legitimate. I, as a DB2 DBA, have been asked by management to interview potential colleagues who were applying for DB2 DBA positions. I am guilty of having asked the meaning of the more common SQLCODEs such as -904 and -911. I wouldn't expect a quote from the manual but I would expect a DBA with 5+ years of experience to know that a -904 is a resource unavailable and that a -911 is a timeout. [...]
11487 16 17_Re: DB2 SQL codes26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU30_Fri, 1 Sep 2000 12:58:54 -0500370_- Did you see Dilbert's take on certification yesterday? Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
11504 37 17_Re: DB2 SQL codes17_Herschfus, Leslee30_Leslee_Herschfus@COMPUWARE.COM30_Fri, 1 Sep 2000 14:08:40 -0400532_iso-8859-1 in the comic strip or the series - tell me about it<br><br>Leslee Herschfus Leslee_Herschfus@Compuware.com Compuware Technical Support Voice: (800) 538-7822 Fax : (248) 737-7339<br><br><br><br>-----Original Message----- From: Edward(Ed) J. Finnell, III [mailto:efinnell@SEEBECK.UA.EDU] Sent: Friday, 01 September, 2000 01:59 PM To: DB2-L@RYCI.COM Subject: Re: DB2 SQL codes<br><br><br><br>Did you see Dilbert's take on certification yesterday? Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu [...]
11542 16 17_Re: DB2 SQL codes26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU30_Fri, 1 Sep 2000 13:34:05 -0500424_- Sorry, the comic strip. "I invoke the powers of certification" Well? "That's all I remember from the class." Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
11559 40 17_Re: DB2 SQL codes11_Ray H Janes27_ray_h_janes@EMAIL.MOBIL.COM30_Fri, 1 Sep 2000 13:38:50 -0500341_us-ascii Next day, he went and declared that he was quiting and "Got a better job for more pay and a better boss at a better company" Then at the new employment place, same pointy haired boss asking "Why did I hire you...?"<br><br><br><br><br><br><br><br>"Edward(Ed) J. Finnell, III" <efinnell@SEEBECK.UA.EDU> on 09/01/2000 01:34:05 PM [...]
11600 181 52_Re: Additional information- S0C4 Abends in DB2/OS39012_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV30_Fri, 1 Sep 2000 14:08:00 -0400555_- We don't have this problem but did you send the dump to IBM?<br><br>>>> DB2-L@RYCI.COM@inter2 09/01/00 11:32AM >>> Hello,<br><br>I posted this question a few weeks ago and I have a few more details; I checked out the suggestions given and they don't *appear* to be factors in this case. I have narrowed the problem down to one table (at least I think this is the problem!). We were only getting the 0C4's in our development DB2, and not in QA or production. I could not reproduce the abend in any other subsystem. While doing some work in a little [...]
11782 98 39_Thanks everyone on the DB2 SQL Codes...14_Ashish Mahajan25_blue_sky@WORLDNET.ATT.NET30_Fri, 1 Sep 2000 13:19:09 -0600444_iso-8859-1 Hi everyone!<br><br>Last nite after posing my SQL Codes question on this list, I shut down my computer. This morning as I booted it up and checked email I saw 50+ messages on this forum in regards to my original question. Wow!<br><br>I am very grateful to all of you for having taken the time to share your thoughts, and pet peeves on this topic. I have forwarded some of the messages to the student who had posed the question. [...]
11881 40 17_Re: DB2 SQL codes17_Herschfus, Leslee30_Leslee_Herschfus@COMPUWARE.COM30_Fri, 1 Sep 2000 15:26:58 -0400347_iso-8859-1 my attitude toward SQL codes (as a former programmer) is not do I know what they are - but do I know where to find the answer. I think knowing how to do research is more important than knowing the answers<br><br>Leslee Herschfus Leslee_Herschfus@Compuware.com Compuware Technical Support Voice: (800) 538-7822 Fax : (248) 737-7339 [...]
11922 29 43_Re: Thanks everyone on the DB2 SQL Codes...14_Philip Gunning18_pgunning@PHEAA.ORG30_Fri, 1 Sep 2000 15:33:18 -0400603_us-ascii Ash, I also teach undergraduate courses in Database at two universities. I use DB2 for the hands-on, real world portion. IBM has an IBM Scholars program. Just go to www.software.ibm.com/data/db2 and email them and they will send you DB2 for Universal Database for all platforms, the Software Development Kit (SDK) for use in developing programs and manuals to get you started. My students really enjoy the opportunity to work with a real database (they were used to ACCESS),they get to do a lot of practical exercises with SQL and we use the Store Procedure Builder to build JAVA SPs! HTH [...]
11952 188 27_Re: UDB AIX Discussion List16_McDonnell Victor22_vmcdonnell@CAYENTA.COM31_Wed, 30 Aug 2000 08:56:47 -0700504_iso-8859-1 How would one go about accessing, say, the 'comp.databases.ibm-db2' newsgroup. (I need the book 'Newsgroups for Dummies')<br><br>Thanks, Victor McDonnell Database Architecture and Administration<br><br>1900 Campus Commons Dr Reston, VA 20191 phone: 703.390.4826 email: vmcdonnell@cayenta.com<br><br>-----Original Message----- From: KUHN,Ulrich [mailto:ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU] Sent: Wednesday, August 30, 2000 2:04 AM To: DB2-L@RYCI.COM Subject: Re: UDB AIX Discussion List [...]
12141 206 52_Re: Additional information- S0C4 Abends in DB2/OS39012_Hall, Robert25_Robert.Hall@OCC.TREAS.GOV30_Fri, 1 Sep 2000 15:37:37 -0400383_iso-8859-1 IBM closed the original ticket because the 0C4's were happening in different places in the DB2 code every time. We ended up sending them about 10 dumps. I'm hoping the maintenance will solve this problem. We might have to open another ticket now that I can duplicate the problem (almost) at will. I can bring DB2 up cleanly, cause the problem, and then force a dump. [...]
12348 30 17_Re: DB2 SQL codes12_Roger Miller19_millerrl@US.IBM.COM30_Fri, 1 Sep 2000 14:22:23 -0500319_- There are a couple of general questions on Version 7, but these are mostly items that you can get from the What's New? book. We tried to avoid trivia questions, but I'm sure that we will find that the test can be improved too. I hope to see lots of people getting certified at the Technical Conference and IDUG. [...]
12379 17 17_Re: Reorg on-line12_Roger Miller19_millerrl@US.IBM.COM30_Fri, 1 Sep 2000 14:31:09 -0500574_- I'd suggest a White paper: Implementing Online Reorg in an Online Environment. It includes most of the concerns and techniques we have found from many customers.<br><br>Get it from ibm.com/software/db2os390 and pull in the PDF file or go direct to ibm.com/software/data/db2/os390/pdf/oreorg.pdf<br><br>Roger Miller, DB2 for OS/390<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
12397 28 12_Re: 00c9008e17_Venkat Srinivasan28_venkatsrinivasan@HOTMAIL.COM30_Fri, 1 Sep 2000 14:43:00 -0500549_- A most common cause of this DBD deadlock is in the Dynamic world. (ERP apps). When a DBD is not on the pool, DB2 takes a shared lock on the DBD01. The underlying tablespace is also locked. Now this could be promoted to a most restrictive lock if the application demands it. LOCKMAX being set at a low value will even escalate the lock, and the result is deadlock with the concurrent process that is requesting the same object. To avoid this, relook at your EDM Pool requirement, number of LOADS from DASD. You can somewhat try to package the [...]
12426 27 28_RCT with DB2 v3.2 & CICS 4.18_Ken Camp19_kcamp@SWMAIL.SW.ORG30_Fri, 1 Sep 2000 15:35:12 -0500404_- We have applied CICS maintenance for the RCT (UQ31408, PN55133, PN55990, PN58437)and other CICS maintenance. Review of the SMP Hold information by the Systems Programmer did not suggest any problem. Prior to the maintenance the CAF worked. After the maintenance and re-assembly of the RCT, CICS comes up and issues message: DSN2023I THE ATTACHMENT FACILITY HAS CONNECTED TO 'DSN3' USING 'DSN2CTS' [...]
12454 50 12_Re: 00c9008e13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM30_Fri, 1 Sep 2000 16:26:32 -0500553_iso-8859-1 Pavan,<br><br>I've seen this before and it was initially confusing.<br><br>We had a situation in which a TS was left in RO status. A read job obtained an S lock (instead of an IS lock) because of the RO status. Subsequent update jobs received a 00C9008E with a resource type of 0D01 (dbid/obid). If the read job was not holding the S lock, a -904 would be issued with a resource type of 220 (tablespace unavailable) instead. With a -904 it is clear that the status should be checked. It appears that the read job is holding a table lock [...]
12505 18 53_Re: Additional information- S0C4 Abends in DB2 OS/39012_Roger Miller19_millerrl@US.IBM.COM30_Fri, 1 Sep 2000 16:20:01 -0500468_- For rough guesses, your 9805 level DB2 is about 2000 fixes behind what we suggest, while the 9909 is only about a year back, and closer to 1000 fixes out. We still get S0C4 situations from a range of problems, including third party products, e.g. PQ39064 that I looked into earlier today. Running that far back level (even one year) makes it relatively difficult for our service group to help. Most of the changes they find require you to be closer to current. [...]
12524 45 47_Null terminated variables in DB2 OS/390 env????14_Theisen, Craig22_CTheisen@GUIDEMAIL.COM30_Fri, 1 Sep 2000 17:05:14 -0500418_iso-8859-1 I would appreciate some ideas from the shops developing Client Server apps in the DB2 for OS/390 enviornment:<br><br>We are implementing a strategy using using JAVA at the client doing SQL calls via JDBC / DB2 connect to stored procedures written in COBOL/MVS on OS/390. We are currently on DB2 version 5.1. (soon to go to version 6 so if your answer is release dependent I'd appreciate knowing that.) [...]
12570 134 43_Re: Thanks everyone on the DB2 SQL Codes...13_OConner, John26_John.OConner@COURTS.WA.GOV30_Fri, 1 Sep 2000 16:14:00 -0700568_iso-8859-1 Ash,<br><br>I think that Dilbert is really a reminder to us of what can go wrong in the world of big business and technology. I think that he demonstrates those qualities that we are trying to avoid.<br><br>In contrast, I find that this listserv demonstrates many of the qualities that most of us strive for. One example: There was a "how does DB2 do ..." question being discussed. One of the people who is recognized as an expert in DB2 responded with the actual test results from a test he performed on DB2. Another person responded with an "I don't [...]
12705 13 32_Re: RCT with DB2 v3.2 & CICS 4.113_Darrel Schumm23_dschumm@TOTALSYSTEM.COM30_Fri, 1 Sep 2000 17:21:44 -0400338_us-ascii make sure you are pointing to the right cics maclib on the syslib in the rct assemble .<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
12719 22 17_Re: DB2 SQL codes0_24_ujjwal@LOT.TATASTEEL.COM28_Thu, 3 Aug 2000 03:54:14 GMT546_us-ascii This discussion has brought one thing for sure , that nobody is going to take it lying down.The important thing what one should know is where to look for what information and what corrective measures one should take. And for all these there are online books,internet,intranet where this repository of information is stored and why should one memorize it ? A lot of IT talent is lost by firms whose Technical person instead of understanding the potential of the interviewee indulge in a oneupmanship tussle in which both are losers. [...]
12742 14 12_Re: 00c9008e17_Venkat Srinivasan28_venkatsrinivasan@HOTMAIL.COM30_Fri, 1 Sep 2000 22:40:33 -0500411_- Well, the other reason is an alter or a DDL can also acquire intent exclusive lock on DBD01. This could also intervene with other concurrent processes. Regards, Venkat<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
12757 56 17_Re: DB2 SQL codes12_Gerald Hodge20_ghodge@ATTGLOBAL.NET30_Sat, 2 Sep 2000 07:55:52 -0500564_us-ascii This thread is showing some interesting insights. Specific questions in an interview come form one of two sources. The first source is because a specific task will be performed, e.g. dealing with RI, and the purpose of the questions is to see if the candidate has done that before. The second source is from the "I have to ask something and show I have mastery of the area." These SQL questions are from the second source. The true point is to impress the candidate with the skills of the interviewer or to allow someone who can not do the interview [...]
12814 42 21_Large NPI maintenance12_Mark Roberts19_mhr@GLOBALNET.CO.UK30_Sat, 2 Sep 2000 09:56:20 -0500572_- Hello.... We are considering implementing a new application which will require access to 200 days of data. We will run a daily load of 4.5 million rows to one partition of a LARGE Tablespace defined with 200 partitions. On day 201 part 1 will be loaded with fresh data.<br><br>The table will require two NPI's to satisy business requirements. My concern is over our ability to maintain these NPI's (IBM REORG and REBUILD) given their size. We may be able to live without REORG, but not without recoverability. We are on DB2 OS/390 V5 and cannot assume that V6 will [...]
12857 108 25_Re: DB2 for OS/390 to UDB12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Sat, 2 Sep 2000 18:51:32 +0200608_x-user-defined Hi, Thanks a lot. Isaac Yassin<br><br>Higgins John wrote: > > Check out http://www.commandtechnology.com/ctcspfse.htm > > Best regards, > John P. Higgins > Performance Specialist > SAP BASIS Team > > Deere & Company Voice: (309) 748-1625 > Attn: GTTC East FAX: (309) 748-1605 > One John Deere Place email: HigginsJohn@JohnDeere.com > Moline, IL 61265-8098 > > > -----Original Message----- > > From: Isaac Yassin [SMTP:yassin@NETVISION.NET.IL] > > Sent: Friday, September 01, 2000 4:10 AM > > To: DB2-L@RYCI.COM > > Subject: Re: DB2 for OS/390 to UDB > > > > Hi, > > Once there used to be [...]
12966 21 37_Re: Precompiled on or before DB2 V2.212_Roger Miller19_millerrl@US.IBM.COM30_Sat, 2 Sep 2000 13:02:44 -0500594_- Susan, I have just one note on the expanded code. I think it is documented. Here is some text from the first Installation Guide, and it's also in the current one. The reality is a bit more complex, but it's in the incompatibilities section of the Migrating chapter.<br><br>... in Version 6, the host language statements generated by the precompiler for each SQL statement include a larger parameter list. As a result, the size of the object code that results from compiling the output of the precompiler increases. This increase varies according to the number of host variables that are [...]
12988 28 37_Re: Precompiled on or before DB2 V2.212_Roger Miller19_millerrl@US.IBM.COM30_Sat, 2 Sep 2000 14:34:24 -0500459_- The first question to ask is whether you ask your programmers to do what the books say or accept any program that appears to work. If the former, then the books have noted the standard for about the past ten years and you don't have many problems. The second question is whether you allow programmers to ignore warning messages from the precompilers. If you don't, then there is not a problem. This has been the case for the majority of our customers. [...]
13017 18 66_Re: Modifying code or sql to solve PeopleSoft Performance problems17_Venkat Srinivasan28_venkatsrinivasan@HOTMAIL.COM30_Sat, 2 Sep 2000 17:50:52 -0500429_- Well, The query in reference here refers to the POST/UNPOST journal process. For almost all of the offending queries like this, there are fixes available. Contact the GSC with the specific query that needs a rewrite and I am sure they will address this as soon as possible. For the specific example suggested herein, there is a fix for the cobol module. the fix will convert the EXISTS into a JOIN Clause. Regards, Venkat [...]
13036 51 16_Training Ground?17_Andrew Karandjeff17_eak3rd@SWBELL.NET30_Sat, 2 Sep 2000 19:55:46 -0500342_Windows-1252 I am a COBOL developer who works in the OS/390 environment who is also aspiring to be a DB2 DBA. Is there some sort of platform, preferably something I could load on my PC at home where I can develop some skills without risking the DB at work. I guess what I am looking for is a Flight Simulator for DB2. Any suggestions? Thanks.
13088 49 33_Re: DB2 V6 for OS/390 Try vs. Buy14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Sun, 3 Sep 2000 14:21:11 +1100412_iso-8859-1 Sorry to be pedantic, but isn't HSQ6610 the TRY and JSQ6611 the BUY?<br><br>/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au -----Original Message----- From: Loria, Susan C. [mailto:Susan_C_Loria@TVRATINGS.COM] Sent: Saturday, September 02, 2000 1:07 AM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] DB2 V6 for OS/390 Try vs. Buy [...]
13138 63 17_Re: DB2 SQL codes14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Sun, 3 Sep 2000 14:28:29 +1100330_iso-8859-1 Can't not make a few random observations:<br><br>- Albert Einstein was once asked for his home telephone number. Albert looked it up in a telephone directory. When amazement was expressed that he didn't know his own telephone number, Albert responded "Why should I memorise something I know I can find in a book?" [...]
13202 17 32_Re: RCT with DB2 v3.2 & CICS 4.126_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU30_Sat, 2 Sep 2000 23:31:25 -0500464_- And the right DB/2 MACLIB. Usually they're pretty good about ACTION holds, could have somthing in DB/2.SMPPTS that needs to be in the concatenation? Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
13220 97 17_Re: DB2 SQL codes16_Richard A Yevich21_ryevich@BELLSOUTH.NET30_Sun, 3 Sep 2000 00:41:16 -0400360_iso-8859-1 James,<br><br>You said it perfectly, especially: "I believe that the ultimate test of an Expert is someone who can resolve problems that they have never seen before. Not someone who remembers what they did last time they had the problem."<br><br>Now how to we get that painted on every HR interviewers wall, and then get them to understand it. [...]
13318 38 25_Re: Large NPI maintenance10_Bob Irving16_Rightbob@AOL.COM28_Sun, 3 Sep 2000 11:28:31 EDT431_US-ASCII Hello,<br><br>the 30,000 foot view from our experiences with a large tablespace 40 aprts approx 400 million rows, 1 NPI, 22 bytes. Also, the NPI has 6 physical files (6 pieces if you will)<br><br>Reorging using "traditional" REORG (putting the access of the TS's in UT mode) with the NPI took forever, one time the job failed to finish in our tech window (granted, everyone else is also reorging in the tech window). [...]
13357 66 33_Re: DB2 V6 for OS/390 Try vs. Buy15_Loria, Susan C.27_Susan_C_Loria@TVRATINGS.COM30_Sun, 3 Sep 2000 19:51:44 -0400698_iso-8859-1 I stand corrected, sorry for the confusion.<br><br>Thanks, Susan Loria<br><br>-----Original Message----- From: James Campbell [mailto:James.Campbell@HANCORP.COM.AU] Sent: Saturday, September 02, 2000 11:21 PM To: DB2-L@RYCI.COM Subject: Re: DB2 V6 for OS/390 Try vs. Buy<br><br><br><br>Sorry to be pedantic, but isn't HSQ6610 the TRY and JSQ6611 the BUY?<br><br>/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au -----Original Message----- From: Loria, Susan C. [mailto:Susan_C_Loria@TVRATINGS.COM] Sent: Saturday, September 02, 2000 1:07 AM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] DB2 V6 for OS/390 Try vs. Buy [...]
13424 25 26_Can u share any procedures25_Srirengan Venkatesh Kumar42_SRIRENGAN_VENKATESH_KUMAR/IRAS@IRAS.GOV.SG30_Mon, 4 Sep 2000 09:39:43 +0800282_us-ascii Hi,<br><br>1. We are currently working on a project using DB2 UDB. I am looking for procedures for database admin specific to UDB environment on RS 6000. Is there anybody out there who can point out a copy on the web or share a copy which I can tailor for my project. [...]
13450 44 30_Re: Can u share any procedures10_Marc Baime14_mbaime@GTE.NET30_Mon, 4 Sep 2000 00:04:58 -0400643_us-ascii Lins to everything you need may be found here: http://www-4.ibm.com/software/data/pubs/ .<br><br>Regards...Marc Baime<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Srirengan Venkatesh Kumar Sent: Sunday, September 03, 2000 9:40 PM To: DB2-L@RYCI.COM Subject: Can u share any procedures<br><br><br><br>Hi,<br><br>1. We are currently working on a project using DB2 UDB. I am looking for procedures for database admin specific to UDB environment on RS 6000. Is there anybody out there who can point out a copy on the web or share a copy which I can tailor for my project. [...]
13495 113 96_AW: IMAGE COPY UTILITY - Determining number of copied pages per t able space (DB2 for OS/390 V5)12_Peter, Georg15_G.Peter@DZBW.DE30_Mon, 4 Sep 2000 09:50:18 +0200709_iso-8859-1 Thanks, Jack.<br><br>With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------------ Datenzentrale Baden-Wuerttemberg Department Product Support Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ------------------------------------------------------------------------<br><br>-----Ursprüngliche Nachricht----- Von: Jack O'Connell [mailto:jack.oconnell@MCMASTER.COM] Gesendet am: Freitag, 25. August 2000 18:04 An: DB2-L@RYCI.COM Betreff: Re: IMAGE COPY UTILITY - Determining number of copied pages per t able space (DB2 for OS/390 V5) [...]
13609 42 29_Using DPROPR and DB2/OS390 V419_Michael Lim (HKSCC)24_TSMLIM@HKCLEARING.COM.HK30_Mon, 4 Sep 2000 16:47:04 +0800565_US-ASCII Hi,<br><br>I have just installed data propagator Capture and Apply V5.1 on OS/390. I am thinking of using this to replicate DB2/OS390 V4 tables from one subsystem to another.<br><br>From what I've read of the manual so far (Data Replication Guide and Ref V5), there seems to be no instructions on how to define a replication source for Capture on the mainframe. The manual shows how to perform this using the Control Center tool on the PC, but I do not want to go through the hassle of connecting my PC to the mainframe since I only want to replicate [...]
13652 177 43_Re: Thanks everyone on the DB2 SQL Codes...10_John Hardy27_john_j_hardy@CONSULTANT.COM30_Mon, 4 Sep 2000 05:00:24 -0500544_- Yes. This forum does usually seem to bring out the best in people. In response to Ash's point about people who have a technical bent having a tendency towards arrogance (sorry Ash, if I am misquoting you), I remember my first "expert". I was a junior programmer, and had a problem which I took to our acknowledged IMS guru. He came down from his ivory tower, and deigned to waste a little of his valuable time on my stupid little problem. In a flash, he had it all figured, and returned to his far more significant and lofty pursuits. I [...]
13830 56 53_Re: Additional information- S0C4 Abends in DB2 OS/39010_Robert Ord21_robertord@HOTMAIL.COM28_Mon, 4 Sep 2000 14:06:08 GMT334_- Thought I would put in my two pennies worth.<br><br>Can you recommend a maintenance release for v5 which is stable, we are trying to apply maintenance to 0004 but there are all sorts of bugs coming out of the woodwork.<br><br>If the maintenance is backed out everything returns to normal or at least to the bugs we know about. [...]
13887 125 60_IMAGE COPY UTILITY - Determining number of copied pages ....12_Peter, Georg15_G.Peter@DZBW.DE30_Mon, 4 Sep 2000 16:20:41 +0200366_iso-8859-1 Thanks, Rick.<br><br>In NACTIVE in SYSIBM.SYSTABLESPACE you can find the number of active pages in the tablespace (or pages formatted for rows, even if the page contains none).<br><br>It seems that your idea using NACTIVE is a good solution for a forecast (a request from our space guys....) "how big" an image copy for a given tablespace will grow. [...]
14013 58 33_Re: Using DPROPR and DB2/OS390 V424_The Fillmore Group, Inc.18_fillmore@CLARK.NET30_Mon, 4 Sep 2000 12:35:41 -0700606_us-ascii Michael, I don't believe you have any choice. The Control Center tool is required to set up and administer replication - regardless of the source and target.<br><br>Frank<br><br><br><br>On Mon, 4 Sep 2000 16:47:04 +0800, Michael Lim (HKSCC) wrote:<br><br>>Hi, > >I have just installed data propagator Capture and Apply V5.1 on OS/390. I am thinking of using this to replicate DB2/OS390 V4 tables from one subsystem to another. > >From what I've read of the manual so far (Data Replication Guide and Ref V5), there seems to be no instructions on how to define a replication source for Capture [...]
14072 115 25_Re: Large NPI maintenance12_Susan Lawson26_susan_lawson@ATTGLOBAL.NET30_Mon, 4 Sep 2000 17:21:47 -0500551_iso-8859-1 Hi Mark,<br><br>I can give you a few numbers from our experience with some NPIs that were around 200 GB.<br><br>RECOVERY.... To recover 1 NPI at 200GB (table of about 5.5 billion) took about 30 hours to unload and sort the keys(four hours/four partition for each job, 150 million rows per job, three executed in parallel) , and then another 30 to build the index. So in the event we had to recover we estimated about 30 hours because we kept the unload key files current. That is the key to keep this time to a minimum, the unload key [...]
14188 66 24_Re: write enginesMessage14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Mon, 4 Sep 2000 18:25:05 -0400597_ISO-8859-1 Max, the DASD/Xpert from Responsive Systems will show you all your DASD performance problems - with an easy to use graphics interface, so you have point/click/drill-down.<br><br>Regards, Joel<br><br><br><br>Message text written by DB2 Data Base Discussion List >Massimo Scarpa wrote: > > First of all, let me say how I appreciate your 'White Papers' in Responsive > System's Web site and your e-mails in DB2-l. > I started the study of BP tuning by reading your articles about BP and DASD > tuning, they are a real good guideline. > > And yes, I'm well aware that the problems are [...]
14255 88 33_Re: Using DPROPR and DB2/OS390 V411_rick creech18_ykcirc@HOTMAIL.COM28_Mon, 4 Sep 2000 22:37:07 GMT548_- Hi, We use DPROP on os/390 with DB2 5.1 to propagate from one sub-system to another. We use the DJRA admin tool instead of Control Center to administer the registration of source and target tables. The DJRA admin tool is very similar to Control Center in that it is a pc-based tool and connects to the host with DB2 connect. At the IBM dprop advanced class both control center and DJRA were used for the exercizes on UDB personal edition. When you use these tools for a dprop function, the sql required for a given task is generated and put [...]
14344 29 48_INSERT OR UPDATE FROM DIFERENT DB2 SUB USING DDF12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM28_Mon, 4 Sep 2000 23:20:36 GMT367_- Hi Folks:<br><br><br><br>I've got a question about is posible or not execute sql statements like update or insert across diferents db2 region. Can i do it using DDF?. What I've got do to be able to execute update , insert or delete sql statements between subsystems. What kind of changes has to be done in DDF to be able to do it. Thanks a lot for your help , [...]
14374 38 17_Re: DB2 SQL codes12_Doug Clifton16_dclifton@EV1.NET30_Mon, 4 Sep 2000 17:50:42 -0500549_us-ascii I couldn't agree with your comments more. I have been saying for years that a true judge of a person's skill is the ability to find the information in a manual in a timely manner. With the enormous amount of information we have thrown at us on a daily basis there is no way that we can memorize every little detail. However, analyzing a problem and determining what manual(s) can help is very important. I don't know about most people, but I do not exactly trust my memory at 3:00 am, during a potential crisis, on something that I do [...]
14413 56 42_DB2 Symposium Chicago IL September 13-15th12_Susan Lawson26_susan_lawson@ATTGLOBAL.NET30_Mon, 4 Sep 2000 19:09:46 -0500348_iso-8859-1 Dear DB2 Professional,<br><br>There is still time to register for the DB2 Symposium in Chicago, IL on September 13th-15th.<br><br>All in-depth sessions are 1 day each and are taught by some of the most famous DB2 instructors world-wide.<br><br>All attendees will recieve a FREE copy of the new YL&A DB2 Performance Journal Vol 1.1. [...]
14470 72 52_Re: INSERT OR UPDATE FROM DIFERENT DB2 SUB USING DDF14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Tue, 5 Sep 2000 13:36:51 +1100434_iso-8859-1 Harbry,<br><br>Up to DB2 OS/390 V6, each SQL statement can be on tables in one DB2 system only. DB2 V7 will (apparently) have some limited capability to have multi-system SQL.<br><br>Apart from that, there is Data Joiner - which I think only runs on UNIX type platforms. To DB2 it appears to be a single remote DB2 system, but under the covers can do multi-system SQL. (This paragraph exhausts my knowledge about it.) [...]
14543 103 52_Re: INSERT OR UPDATE FROM DIFERENT DB2 SUB USING DDF17_R.V. Subrahmanian33_rv_subrahmanian@CHENNAI.TCS.CO.IN30_Tue, 5 Sep 2000 09:23:48 +0530460_us-ascii James,<br><br>I would like to know more about the Data Joiner which allows SQL's on multiple DB2 subsytems.<br><br>I am not clear about how you can access multiple subsys from UNIX type platforms? Any idea where I can fine more about this???<br><br>Thanks, R V Subramanian<br><br><br><br><br><br><br><br>James Campbell <James.Campbell@HANCORP.COM.AU> on 09/05/2000 09:06:51<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM> [...]
14647 46 52_Re: INSERT OR UPDATE FROM DIFERENT DB2 SUB USING DDF14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Tue, 5 Sep 2000 16:23:45 +1100560_iso-8859-1 http://www-4.ibm.com/software/data/datajoiner/<br><br><br><br>-----Original Message----- From: R.V. Subrahmanian [mailto:rv_subrahmanian@CHENNAI.TCS.CO.IN] Sent: Tuesday, September 05, 2000 2:54 PM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] INSERT OR UPDATE FROM DIFERENT DB2 SUB USING DDF<br><br><br><br>James,<br><br>I would like to know more about the Data Joiner which allows SQL's on multiple DB2 subsytems.<br><br>I am not clear about how you can access multiple subsys from UNIX type platforms? Any idea where I can fine more about this??? [...]
14694 65 14_DSNHDECP CCSID11_John Matear27_John.Matear@BANKWEST.COM.AU30_Tue, 5 Sep 2000 13:35:57 +0800553_us-ascii I would appreciate some advice regarding SCCSID that is stored in DSNHDECP.<br><br>We are installing a DB2 V5 application system into a DB2 subsystem and we have discovered that the DSNHDECP settings for the new DB2 subsystem are different. Unfortunately this was only discovered after the DB2 objects (tablespace, table etc) had been created and the tables loaded with data. We changed the DSNHDECP for DATE and TIME from ISO to EUR. This worked fine. However, we are now encountering CCSID translation problems when trying to load data. [...]
14760 129 52_AW: INSERT OR UPDATE FROM DIFERENT DB2 SUB USING DDF12_Peter, Georg15_G.Peter@DZBW.DE30_Tue, 5 Sep 2000 08:47:08 +0200417_iso-8859-1 >>>> which I think only runs on UNIX type platforms <<<<.<br><br>James,<br><br>DB2 DataJoiner servers run on IBM AIX, Sun Solaris Operating Environment, HP-UX and Microsoft Windows NT, enabling you to work from your preferred UNIX or Intel platform. You can access DB2 DataJoiner using IBM DB2 Client Application Enabler (CAE) on IBM OS/2, Microsoft Windows, UNIX, Macintosh and some other platforms. [...]
14890 86 18_Re: DSNHDECP CCSID14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Tue, 5 Sep 2000 18:20:01 +1100468_iso-8859-1 John,<br><br>(warning, I've never done this)<br><br>Why not put a couple of rows into SYSIBM.SYSSTRINGS to do the translation from CCSID 0 to CCSID 500 and back again? Since you don't want any translation, TRANSTAB would contain x'000102...FEFF' for both rows (I think).<br><br>This should make the translation transparent.<br><br>/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au [...]
14977 132 18_Re: DSNHDECP CCSID12_Jacob Ganzel19_jacobg@SEMECH.CO.IL30_Tue, 5 Sep 2000 10:58:57 +0200531_x-user-defined Hello John and James.<br><br>I did this dummy translation successfully in V5, between 424 and 500 and it solved the problem.<br><br>Insert 2 rows in sysibm.sysstrings as follows:<br><br>INCCSID OUTCCSID TRANSTYPE ERRORBYTE SUBBYTE IBMREQ TRANSTAB<br><br>1. 0 500 'SS' NULL NULL 'N' nothing!!!! 2. 500 0 'SS' NULL NULL 'N' nothing!!!!<br><br>Good luck.<br><br>Jacob<br><br><br><br>--------------------------------------------------------------- Jacob Ganzel Database Products Mgr. SEMECH Software Marketing Ltd. [...]
15110 18 43_Tool to get Referential integrity relations24_Mahadevan Krishnamoorthy34_mahadevan.krishnamoorthy@WIPRO.COM30_Tue, 5 Sep 2000 13:20:11 +0530499_- Hi List,<br><br>Is there anyway we can find all the Referential integrity relations in a DB2 subsystem using any tools. I remember that there are already mails in the List about this. If anybody have this please send a copy.<br><br>Thanks<br><br>Mahadevan<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
15129 112 47_AW: Tool to get Referential integrity relations12_Peter, Georg15_G.Peter@DZBW.DE30_Tue, 5 Sep 2000 10:21:32 +0200415_iso-8859-1 Mahadevan,<br><br>some time ago Sibimon Philip has published the following queries. May be that is what you are looking for................<br><br>One of Sibimon's queries will find the parent of a table. Use the following query to find the children tables. It is written to find all the parent/child relationships in an application, but could be adapted to look for the children of a single table. [...]
15242 41 47_Re: Tool to get Referential integrity relations17_Vijay Subramanyam33_vijay.subramanyam@HPSBLR.SOFT.NET30_Tue, 5 Sep 2000 13:46:28 +0500665_- Hello Mahadevan.<br><br>The REPORT TABLESPACESET utility can be used to find all your RI. All you need to do is list 1 tablespaces and it will report all the related tablespaces & tables that are related. I have found this utility extremely beneficial in identifying relationships.<br><br>Regards, VIJAY<br><br>> -----Original Message----- > From: Mahadevan Krishnamoorthy [SMTP:mahadevan.krishnamoorthy@WIPRO.COM] > Sent: Tuesday, September 05, 2000 1:20 PM > To: DB2-L@RYCI.COM > Subject: Tool to get Referential integrity relations > > Hi List, > > Is there anyway we can find all the Referential integrity relations in a > DB2 subsystem using any tools. [...]
15284 201 18_Re: DSNHDECP CCSID11_John Matear32_John.Matear@CBS-SOLUTIONS.COM.AU30_Tue, 5 Sep 2000 16:33:08 +0800330_us-ascii James/Jacob This was my initial thought until I read the V5 manual which said :<br><br>The values in the INCCSID and OUTCCSID columns must be in the range of 1-65533.<br><br>So it looks as if I will still have to try and set SCCSID=500 in the DSNHDECP.<br><br>Thanks.<br><br>John Matear CBS Integrated Solutions Ltd [...]
15486 25 25_Re: Large NPI maintenance13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Tue, 5 Sep 2000 07:56:08 -0400401_iso-8859-1 Hi Susan,<br><br>Thanks for the post. This is great information.<br><br>I'm curious about the technique you used to prevent update of the columns upon which the NPI is based.<br><br>I wonder also if your session in the DB2 Symposium covers subjects such as this in greater detail. thanks<br><br>David Seibert Compuware Corporation File-AID Product Architect Dave.Seibert@Compuware.com [...]
15512 57 12_Re: Sysibm.*12_troy Coleman20_Troy.Coleman@UAL.COM30_Tue, 5 Sep 2000 07:31:31 -0500472_- I would try Craig Mullins book The DB2 Developers Guide located at URL http://www.craigsmullins.com/cm-book.htm<br><br>---------- From: ParameswaranHarish Sent: Friday, September 01, 2000 5:23 AM To: DB2-L Cc: ParameswaranHarish Subject: Sysibm.* Importance: High Sensitivity: Confidential<br><br>All,<br><br>As a new entrant to DB2, I would like to understand the working of the SYSIBM.* tables. Any idea where can I find the best possible information/reference?? [...]
15570 16 33_Re: Using DPROPR and DB2/OS390 V412_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM30_Tue, 5 Sep 2000 07:57:34 -0500366_us-ascii We use Data Propagator to do just that. Copy one sub system to another. What we have done is develope a COBOL program that reads the catalog of the source system and populates the Datapropagator tables with the required data. We don't use Capture when we do this. The we start the Apply, come back six hours later and 46,000,000 rows have been copied. [...]
15587 20 20_Email Address Change17_Sejal Champaneria30_Sejal.Champaneria@RICH.FRB.ORG30_Tue, 5 Sep 2000 09:22:51 -0400440_US-ASCII Please make a note of my changed email address:<br><br>OLD: sejal.champaneria@rich.frb.org (no longer in service) NEW: all4sej@yahoo.com<br><br>Thank You! -Sejal Champaneria all4sej@yahoo.com<br><br>===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
15608 71 81_Re: Additional information- S0C4 Abends in DB2 OS/390 and DB2 mai ntenance levels11_Hayden, Lee18_Lee_Hayden@CSX.COM30_Tue, 5 Sep 2000 09:36:46 -0400428_iso-8859-1 9911 was very stable for us. We are now rolling out 0006. If anyone is interested they can email me for information on some SMP/E techniques that I use to make DB2 more reliable.<br><br>Note. We are NOT data sharing.<br><br><br><br>-----Original Message----- From: Robert Ord [mailto:robertord@HOTMAIL.COM] Sent: Monday, September 04, 2000 10:06 AM Subject: Re: Additional information- S0C4 Abends in DB2 OS/390 [...]
15680 77 12_Re: 00c9008e15_Rameswara Pavan24_RPAVAN@ISETS.STATE.IN.US30_Tue, 5 Sep 2000 08:55:23 -0500547_us-ascii Hi Venkat, Thanks of responding, I was looking for this type of answer. Our situation is that, there are 12 jobs running in parallel. They run same program with different parameters. There is 13th job which also running in parallel to other 12 jobs but this job is executing other program. and all these jobs are batch jobs. In 12 jobs which are running in parallel there around 12 steps each for a job, for same program ( say X ) with different parameters. So there will be always 13 programs are running at a time in which 12 jobs [...]
15758 66 12_Re: Sysibm.*14_Theisen, Craig22_CTheisen@GUIDEMAIL.COM30_Tue, 5 Sep 2000 08:52:08 -0500442_iso-8859-1 Our senior DBA gave me a poster sized Computer Associates(Platinum) ER diagram named "The System Catalog" that I have tacked to my wall. I use it for my 1st reference and can answer many of my questions from glancing at it.(?maybe you can get from their web site?) If I need a little more detail, I use the appendixes in the references such as others have mentioned. (IBM SQL Reference Volume 2 or Mullins Developer's Guide.) [...]
15825 114 47_Re: Tool to get Referential integrity relations15_Philip, Sibimon20_SPhilip@CSXLINES.COM30_Tue, 5 Sep 2000 09:54:13 -0400302_- The following query list child tables up to four level deep for a table. Just replace creator and table name. I assume that all the table has the same creator. Even though it looks long, this runs fast. If DB2 on OS/390 supports recursion, it can be written very easily for any number of level. [...]
15940 47 24_HELP !!!!! EDM Pool Full12_Terry Spikes21_terryspikes@YAHOO.COM30_Tue, 5 Sep 2000 06:53:07 -0700411_us-ascii I have a programmer who has written a new set of DB2 programs and when he runs them the EDM pool fills up. I can't understand why?<br><br>Basically it's one main program that calls a DB2 program that does some SQL and/or calls another DB2 programs. The main program opens a cursor and the other DB2 Called modules opens other cursors to gather info and the main program eventually does an INSERT. [...]
15988 122 73_AW: where I can get some information about working of EDM pools a nd DBDs12_Peter, Georg15_G.Peter@DZBW.DE30_Tue, 5 Sep 2000 15:59:36 +0200380_iso-8859-1 Pavan,<br><br>to your request "where I can get some information about working of EDM pools and DBDs":<br><br>In 1998 I've prepared an alternate presentation for IDUG Europe with the title " Don't treat him like a stepchild - the EDM Pool".<br><br>If you are interested to receive this presentation please give me a mail and I'll send you the foils ( a *ppt.file). [...]
16111 17 77_Re: AW: where I can get some information about working of EDM pools a nd DBDs14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT30_Tue, 5 Sep 2000 16:07:12 +0100322_us-ascii Please, if you can, send me a copy<br><br>Many Thanks<br><br>Max Scarpa<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
16129 22 19_Death by Random I/O14_Philip Gunning18_pgunning@PHEAA.ORG30_Tue, 5 Sep 2000 10:07:48 -0400350_us-ascii Does anyone know of a good article or presentation on this subject? I'd like to get my hands on it if one exists. TIA<br><br>Phil Phil Gunning DB2 DBA IBM Certified Advanced Technical Expert -- DB2 UDB DRDA IBM Certified Solutions Expert -- DB2 UDB V6 IBM Certified Solutions Developer -- DB2 UDB V6 Assoc List Owner DB2-L pkg3@psu.edu [...]
16152 78 28_Re: HELP !!!!! EDM Pool Full15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Tue, 5 Sep 2000 09:22:46 -0500584_iso-8859-1 Hi, Terry,<br><br>Are these programs bound into one plan? How large is the DBD or DBDs that these programs are using?<br><br>Linda Billings Enterprise Systems Programmer Info-Tech Services Department of Administration State of Wisconsin<br><br>"I know! I'll transcribe the conversations between the voices in my head and send them to you!"<br><br>-David Borenstein<br><br><br><br><br><br><br><br>-----Original Message----- From: Terry Spikes [mailto:terryspikes@YAHOO.COM] Sent: Tuesday, September 05, 2000 8:53 AM To: DB2-L@RYCI.COM Subject: HELP !!!!! EDM Pool Full [...]
16231 179 12_AW: Sysibm.*12_Peter, Georg15_G.Peter@DZBW.DE30_Tue, 5 Sep 2000 16:28:54 +0200383_iso-8859-1 Harish,<br><br>take a look at http://www.cai.com/products/posters.htm<br><br>You'll find a) CA's System Catalog for DB2 for OS/390 V6 Poster, and you can order a hardcopy. a) CA's System Catalog for DB2 for OS/390 V5 Poster. c) CA's Access Path for DB2 for OS/390 V5 Poster. Both posters can be ordered as a hardcopy or you can download them (I've never tried that). [...]
16411 41 12_AW: Sysibm.*12_Peter, Georg15_G.Peter@DZBW.DE30_Tue, 5 Sep 2000 16:33:42 +0200397_iso-8859-1 Harish, sorry for the bad mail before.<br><br>Please take a look at http://www.cai.com/products/posters.htm<br><br>You'll find a) CA's System Catalog for DB2 for OS/390 V6 Poster, a) CA's System Catalog for DB2 for OS/390 V5 Poster, c) CA's Access Path for DB2 for OS/390 V5 Poster.<br><br>All posters can be ordered as a hardcopy or you can download them (I've never tried that). [...]
16453 78 77_Re: AW: where I can get some information about working of EDM pools a nd DBDs9_Cam White20_cwhite@REVEALNET.COM30_Tue, 5 Sep 2000 10:38:41 -0400630_iso-8859-1 Max, here's some info on EDM utilization from the RevealNet Knowledge Base for DB2:<br><br>The EDM (Environmental Descriptor Manager) Pool contains all the descriptions of open DBDs, Skeleton Cursor tables (or plans), and program cursor tables (corresponding roughly to threads).<br><br>When we talk about the EDM pool, we could be concerned with EDM pool efficiency which would concentrate on a small LOADS per REQUEST. This would indicate that I/O to the Directory is minimized, or in extreme cases, practically eliminated. But... Do you really need to constantly keep an eye on all this stuff? Not necessarily! [...]
16532 43 23_Re: Death by Random I/O14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Tue, 5 Sep 2000 10:47:01 -0400530_ISO-8859-1 Phil, I don't think there is anything specific written on this topic, as it ("Death by Random I/O") is a term I have used in several of my presentations within the last few years. It is caused by objects that are both very large, and the access very random - so it's impossible to get a good hit ratio in a buffer pool, and you often don't even get a good hit ratio in the DASD Cache. So, you have a high Synch I/O rate, and possibly poor DASD performance because of the cache miss and required read from multiple [...]
16576 17 23_Re: Death by Random I/O14_Philip Gunning18_pgunning@PHEAA.ORG30_Tue, 5 Sep 2000 10:52:10 -0400431_us-ascii Thanks Joel. That is what I am seeing. Obviously, there are some things to do to alleviate the problem like making BPs larger (if possible, not possible here right now, changing the application (if you can, not possible here short term), DASD placement, reviewing the cache data, etc. Anything else to add? Does the Buffer Pool Tool help in tuning these problems? Is there a particular report/field I should look at? [...]
16594 107 28_Re: HELP !!!!! EDM Pool Full12_Terry Spikes21_terryspikes@YAHOO.COM30_Tue, 5 Sep 2000 07:58:27 -0700644_us-ascii Linda,<br><br>RC/Query show the plans Base size is 13,520 and average size 5789 and Cachesize 1024. I'm going to try Cachesize(0) next.<br><br>The DBID in SYSDATABASE and SYSTABLESPACE is 293.<br><br>Thanks for the reply!<br><br><br><br>--- "Billings, Linda" <linda.billings@DOA.STATE.WI.US> wrote: > Hi, Terry, > > Are these programs bound into one plan? How large is the DBD or > DBDs that these programs are using? > > Linda Billings > Enterprise Systems Programmer > Info-Tech Services > Department of Administration > State of Wisconsin > > "I know! I'll transcribe the conversations between the voices in my > head and send [...]
16702 106 28_Re: HELP !!!!! EDM Pool Full12_Terry Spikes21_terryspikes@YAHOO.COM30_Tue, 5 Sep 2000 08:02:46 -0700622_us-ascii Linda,<br><br>I forgot to tell you in the last reply...<br><br>Yes. All 11 Programs/DBRMs are bound as 1 plan. No Packages. I wish they were packages but I can't do anything about that right now. This application is setup under ChangeMan to not use packages.<br><br><br><br>--- "Billings, Linda" <linda.billings@DOA.STATE.WI.US> wrote: > Hi, Terry, > > Are these programs bound into one plan? How large is the DBD or > DBDs that these programs are using? > > Linda Billings > Enterprise Systems Programmer > Info-Tech Services > Department of Administration > State of Wisconsin > > "I know! I'll transcribe [...]
16809 31 78_Re: AW: where I can get some information about working of EDM poo ls a nd DBDs11_Culp, Kathy18_kculp@ALLSTATE.COM30_Tue, 5 Sep 2000 09:24:01 -0500608_- Could you post it to the Documents Archives?<br><br>-----Original Message----- From: Massimo Scarpa [SMTP:Massimo_Scarpa@DEBIS.IT] Sent: Tuesday, September 05, 2000 10:07 AM To: DB2-L@RYCI.COM Subject: Re: AW: where I can get some information about working of EDM pools a nd DBDs<br><br>Please, if you can, send me a copy<br><br>Many Thanks<br><br>Max Scarpa<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. [...]
16841 24 18_Re: DSNHDECP CCSID12_Roger Miller19_millerrl@US.IBM.COM30_Tue, 5 Sep 2000 09:53:00 -0500415_- Changing the CCSID is a process that can cause you to damage your data, so please be very careful. Have you read the appendix of the Installation Guide about character conversion? In particular, most of the sites in Oz seem to use code page 37, rather than 500. It's fairly easy to get translations and have data in one subsystem that has several code pages, and some characters get lost in the translation. [...]
16866 70 23_Re: Death by Random I/O13_Adrian Savory24_adrian.savory@ZURICH.COM30_Tue, 5 Sep 2000 16:18:04 +0100550_us-ascii Phil,<br><br>If the objects that are causing you problems really are that big then making the buffer pool bigger probably is not going to help that much - you're not going to get the coverage you need to significantly improve your hit ratio. I take it these objects are isolated in their own pool? If not that's the first thing you should do. In my experience I've actually reduced the size of this sort of buffer pool once I've realised that I can't improve on the hit ratio, you might find you can make big savings in memory that can [...]
16937 87 23_Re: Death by Random I/O24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM30_Tue, 5 Sep 2000 08:29:26 -0700663_iso-8859-1 You might also consider isolating these objects to a separate buffer pool and then set VPSEQT to 0. This will effectively turn off sequential prefetch.<br><br>-----Original Message----- From: Adrian Savory [mailto:adrian.savory@ZURICH.COM] Sent: Tuesday, September 05, 2000 8:18 AM To: DB2-L@RYCI.COM Subject: Re: Death by Random I/O<br><br><br><br>Phil,<br><br>If the objects that are causing you problems really are that big then making the buffer pool bigger probably is not going to help that much - you're not going to get the coverage you need to significantly improve your hit ratio. I take it these objects are isolated in their own pool? [...]
17025 60 25_Re: Large NPI maintenance12_Susan Lawson22_lawson_susan@YAHOO.COM30_Tue, 5 Sep 2000 08:40:11 -0700431_us-ascii Hi Dave,<br><br>We controlled the updates via the application - nothing fancy. Although we did a a few slip pass!<br><br>In my DB2 High Performance Design seminar at the DB2 Symposiums, I do cover many design strategies for large tables, indexes, etc...talking about our experiences (both good and bad with the different options). You can find an abstract at www.db2-symposium.com or at our web site www.ylassoc.com. [...]
17086 35 23_Re: Death by Random I/O14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Tue, 5 Sep 2000 11:42:34 -0400744_ISO-8859-1 Why would you want to turn off prefetch when the problem is Synch I/O? Even if there is Dyn Pref triggering, turning off prefetch will usually hurt more than help. Setting VPSEQT to a low value might help, but again only if there is prefetch shown for the pool/object. Regards, Joel +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Buffer Pool Tool for DB2 - The only product that can Predict the effect of changes; shows you how to properly group objects DASD/Xpert for DB2 - Easily shows all your DASD performance problems, and recommends tuning options. Visit www.responsivesystems.com for performance white papers and presentations. +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ [...]
17122 100 28_Re: HELP !!!!! EDM Pool Full15_Gordon Fishwick39_Gordon.Fishwick@SCOTTISH-SOUTHERN.CO.UK30_Tue, 5 Sep 2000 16:44:55 +0100350_us-ascii Terry,<br><br>I think that a good approach would be to resize your EDM pool (9MB is rather small) so that the job runs successfully and then use your monitor to see exactly how much of the EDM pool is being used.<br><br>Just an idea...<br><br>Best regards,<br><br>Gordon Fishwick DB2 Systems Programmer Scottish and Southern Energy plc [...]
17223 133 28_Re: HELP !!!!! EDM Pool Full15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Tue, 5 Sep 2000 10:56:50 -0500535_iso-8859-1 I don't know what unit of measure RC/Query is using here. We have it at our shop but the help screen doesn't clarify. If it is pages, that is your problem. I don't know for sure but I think that the entire plan is brought into the EDMPOOL along with the DBD and space for the authorization caching (from what I have read). You will need to resize your EDMPOOL to accomodate this plan for the time being. I think that Gordon's suggestion is a good one although we have a system here that is not considered small and the [...]
17357 50 16_DB2Connect & MTS12_David Thomas21_llewelyn_us@YAHOO.COM30_Tue, 5 Sep 2000 08:47:04 -0700578_us-ascii I have a VB6 application that uses ADO to update a DB2 database. The application runs as a DLL under MTS 2.0 on a NT Server. The application is on the same server as MTS. Access to DB2 is through DB2Connect v6.1 which is on a gateway. The connection between the NT Server and gateway ( DB2Connect ) is TCP/IP. The connection between the gateway and mainframe is SNA. The application originally ran successfully when it was not part of an MTS transaction ( Property = "Does not support transactions." ) However, the DB2Connect Syncpoint Mgr has now been configured [...]
17408 47 23_Re: Death by Random I/O24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM30_Tue, 5 Sep 2000 08:58:52 -0700382_iso-8859-1 In our case, with several tables of up to 40 million rows each, all almost exclusively accessed randomly, turning off prefetch changed our buffer hit ratio from negative to 90%.<br><br>-----Original Message----- From: Joel Goldstein [mailto:joel_goldstein@COMPUSERVE.COM] Sent: Tuesday, September 05, 2000 8:43 AM To: DB2-L@RYCI.COM Subject: Re: Death by Random I/O [...]
17456 49 16_DB2Connect & MTS12_David Thomas21_llewelyn_us@YAHOO.COM30_Tue, 5 Sep 2000 08:49:36 -0700578_us-ascii I have a VB6 application that uses ADO to update a DB2 database. The application runs as a DLL under MTS 2.0 on a NT Server. The application is on the same server as MTS. Access to DB2 is through DB2Connect v6.1 which is on a gateway. The connection between the NT Server and gateway ( DB2Connect ) is TCP/IP. The connection between the gateway and mainframe is SNA. The application originally ran successfully when it was not part of an MTS transaction ( Property = "Does not support transactions." ) However, the DB2Connect Syncpoint Mgr has now been configured [...]
17506 37 23_Re: Death by Random I/O14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Tue, 5 Sep 2000 11:59:27 -0400514_ISO-8859-1 Phil, If the object is really large and very random, then increasing pool size usually does not help. The Buffer Pool Tool simulations will show you the working set size of the object and I/O rates for all simulated pool sizes - so you can easily see if memory will improve the I/O rate or not. After isolating an object(s) with these characteristics into their own pool, and many can be in the same pool, BPT will show you the best pool size to optimize the memory to I/O trade-off. Regards, Joel [...]
17544 130 28_Re: HELP !!!!! EDM Pool Full15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Tue, 5 Sep 2000 11:04:14 -0500528_iso-8859-1 I reread your original email and you say that you think that DB2 only loads the skeleton cursor table for the SQL being used and that it is reused by another person using the program. Please, someone correct me if I am wrong but according to a class that I attended ( I consulted my notes after my last email.) a base segment of the plan is pulled into the EDMPOOL at first. A clean section of the plan is pulled into the EDMPOOL when it is needed and multiple copies are made from this based on how many people [...]
17675 143 28_Re: HELP !!!!! EDM Pool Full15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Tue, 5 Sep 2000 11:09:52 -0500400_iso-8859-1 Sorry to be creating so many replies but here is some information concerning the definition of BASE SIZE that I found in Platinum.<br><br><br><br><br><br>Field: BASE SIZE<br><br><br><br><br><br>Description: The size of the base section of the plan. Plans are<br><br>divided into sections, but the base plan must be in the EDM pool<br><br>during the entire time the plan is executing. [...]
17819 113 52_Re: INSERT OR UPDATE FROM DIFERENT DB2 SUB USING DDF0_22_Rohn.Solecki@MTS.MB.CA30_Tue, 5 Sep 2000 11:09:55 -0500352_us-ascii You might want to look at the DB2 CONNECT command. If the insert/updates are in separate SQL by subsystem, this might work for you. ie<br><br>sql to insert into subsys 1 sql to update in subsys 1 CONNECT subsys 2 sql to insert into subsys 2 sql to update in subsys 2 CONNECT subsys 1 sql to insert into subsys 1 sql to update in subsys 1 [...]
17933 103 18_Re: DSNHDECP CCSID12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Tue, 5 Sep 2000 19:17:27 +0200563_x-user-defined Hi, I did it few times. Works fine. Just remember you need to have the column "IBMREQD" as "N". If you know your translations you can even build your own transtab - at your risk !!!<br><br>Issac Yassin<br><br>James Campbell wrote: > > John, > > (warning, I've never done this) > > Why not put a couple of rows into SYSIBM.SYSSTRINGS to do the translation > from CCSID 0 to CCSID 500 and back again? Since you don't want any > translation, TRANSTAB would contain x'000102...FEFF' for both rows (I > think). > > This should make the translation [...]
18037 18 23_Re: Death by Random I/O14_Philip Gunning18_pgunning@PHEAA.ORG30_Tue, 5 Sep 2000 12:16:22 -0400503_us-ascii Thanks for all the responses. These objects are 100+million rows to 500,000 ,000 rows in size. All objects in question are compressed. I'm thinking dataspaces in V6.1 might be an alternative, although memory and paging will have to be watched. These objects are separated into a few general bufferpools for general tablespaces. I will do some more analysis and break out the random readers on large objects to a pool of their own (or two), adjust thresholds as necessary and monitor. Phil [...]
18056 16 23_Re: Death by Random I/O14_Philip Gunning18_pgunning@PHEAA.ORG30_Tue, 5 Sep 2000 12:22:11 -0400331_us-ascii One other obvious possiblity I forgot to mention, is analyze the accesses against these objects and see if I can get index only access to a good extent. That way, if the indexes are much smaller, the chance of them being in the bufferpool will be greater provided that I have a good bufferpool strategy. Thanks, Phil [...]
18073 99 28_Re: HELP !!!!! EDM Pool Full17_Charles Jambrosic29_Charles_Jambrosic@CSIHOME.COM30_Tue, 5 Sep 2000 09:28:02 -0700545_us-ascii Terry,<br><br>You mentioned that you have 8850 pages or 9 meg. Unless you are using 1 k pages your EDMpool size is 35m.<br><br>We had a problem with our pool size of 33 m being full (package tables) and increased it to 40m or 10000 pages.<br><br>There is a performance trace class which will give you i/o activity to the pool which might help you although at this point I'm not sure about the overhead. We run about 500k to 700k of SQL requests per 15 minute interval via CICS and our problem was due to too many protected threads [...]
18173 73 28_Re: HELP !!!!! EDM Pool Full12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Tue, 5 Sep 2000 19:39:30 +0200315_x-user-defined Hi,<br><br>Do you use "release commit" or "release deallocate" on the bind command ? "release deallocate" can eat your EDM memory fastly. Issue the command "display db(xxxxx)" for the DB used in the programs and look at its size. If big it can be your culprit as well.. Switch to packages ASAP. [...]
18247 34 77_Re: AW: where I can get some information about working of EDM pools a nd DBDs21_Helio Pimpinato Rocha20_hrocha@TELESP.COM.BR30_Tue, 5 Sep 2000 13:54:12 -0300110_us-ascii I would like to receive this information too. My email is: hrocha@telesp.com.br<br><br>thanks<br><br>
18282 126 28_Re: HELP !!!!! EDM Pool Full12_Terry Spikes21_terryspikes@YAHOO.COM30_Tue, 5 Sep 2000 11:10:11 -0700325_us-ascii Thanks for the sugestions eveybody. Rather than reply to all I will include everything in this one. Here's some more info I've found.<br><br>1. The EDM pool must be 1K pages because TMON/DB2 show 9M for the Size.<br><br>2. I tried CASHESIZE(0). Didn't help.<br><br>3. The DBD length for this Database is 20180. [...]
18409 479 24_Dilbert on certification24_The Fillmore Group, Inc.18_fillmore@CLARK.NET30_Tue, 5 Sep 2000 14:17:38 -0700432_us-ascii <br><br>I know this is breaking the rule on attachments, but, hey, I've never let that stop me before. Enjoy... BTW, I forwarded this to some of the folks inside IBM who are responsible for DB2 certification and certification education. I think they've laughed the hardest.<br><br>For our international colleagues, "Dilbert" is a cartoon about a *typical* office worker professional. I believe the humor is universal. [...]
18889 16 23_Partitioning in EEE/AIX7_Db2 Dba24_data_analyst@HOTMAIL.COM30_Tue, 5 Sep 2000 13:06:27 -0500460_- Hi all,<br><br>What is the best way to decide how many partitions to have per node? I have heard of 1 partition/2 CPU.<br><br>Is there any advantage in having one partition per Volume Group that includes raw devices?<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
18906 145 28_Balt./Wash. DB2 Users' Group10_John Lantz23_john.lantz@ZURICHUS.COM30_Tue, 5 Sep 2000 14:24:39 -0400403_us-ascii This is a reminder notice about an upcoming meeting next week. A great chance to hear Craig Mullins in the Baltimore area. Visit our website at http://www.bwdb2ug.org/ for more info.<br><br>Baltimore/Washington DB2 Users' Group<br><br>Meeting Date: September 12,2000 (Please note: this is a Tuesday)<br><br>Location: Sheraton Columbia Inn 10207 Wincopin Circle Columbia, MD (410) 730-3900 [...]
19052 31 27_Re: Partitioning in EEE/AIX14_Mike Lebermann18_Lebermm@BCBSKC.COM30_Tue, 5 Sep 2000 13:45:00 -0500349_US-ASCII Take a look at the the redbook "Database Performance on AIX in DB2 UDB and Oracle Environments". They have some good info on partitioning and EEE.<br><br>Mike<br><br>>>> data_analyst@HOTMAIL.COM 09/05/00 01:06PM >>> Hi all,<br><br>What is the best way to decide how many partitions to have per node? I have heard of 1 partition/2 CPU. [...]
19084 18 28_Re: Dilbert on certification13_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM30_Tue, 5 Sep 2000 13:38:45 -0500470_- If you'd care to wait three days, you'd find this at<br><br>http://www.dilbert.com<br><br>-HJC<br><br>P.S.: In case I am sued for presenting a URL, I intend to call AOL as a codefendant, cause that's where I found the link. ;)<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
19103 21 12_Re: 00c9008e17_Venkat Srinivasan28_venkatsrinivasan@HOTMAIL.COM30_Tue, 5 Sep 2000 14:08:31 -0500510_- The Program X and Program Y must be accessing a common table. That is the reason you are running into deadlock. If it is a static program, it is easier to see and if it is dynamic application then the only way is to capure all the SQL staments from both the programs and compare. As for the DBD loads, it depends on the version of DB2. Until ver 5 they need contiguous space in the EDM pool. If no space is avlbl, then the pages from SQL Caching area, skel cursor table, skel package table or a LRU DBD [...]
19125 22 30_DB2 OS/390 V6. 16k bufferpools10_Dave Cully17_jdcully@YAHOO.COM30_Tue, 5 Sep 2000 14:50:10 -0500550_- My company recently upgraded to DB2 UDB for OS/390 Version 6. We now have a customer who needs to increase the length of a row in an existing table to 15000. Question: In a non data sharing environment what is involved in activating the bp16k bufferpools for customer use? I have looked in the manuals for information but I have not been able to locate any type of procedures for doing this. I have found that an alter tablespace bufferpool will be needed, then a bounce of the DB2 subsystem, but do I need to add 16k sortwork pools, increase [...]
19148 24 22_The federated database11_Wang, Jason23_jason.wang@CHECKSOL.COM30_Tue, 5 Sep 2000 15:48:56 -0500528_iso-8859-1 Greeting all,<br><br>I have a question regarding the federated database. I understand that one can set it up on the window NT platform accessing databases on both NT and OS/390 platform. But I can not find any info on the DB2 for OS/390 platform regarding how to setup federated database system on the OS/390 platform. Do anyone know if the federated databases is supported on the OS/390 ? (other than used as data source) and if it is, what release of DB2 for OS/390 does the federated database support begin ? [...]
19173 52 26_Re: The federated database0_15_leon@CA.IBM.COM30_Tue, 5 Sep 2000 17:18:52 -0400341_us-ascii "Federated database" is a new function that is delivered as part of DB2 Connect V7.1 and DB2 UDB for Unix, Windows and OS/2 V7.1. Take a look at the announcement for these V7.1 products for additional information. Here is a link to the DB2 Connect V7.1 US announcement letter http://www.ibmlink.ibm.com/usalets&parms=H_200-091 [...]
19226 69 26_FW: The federated database12_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM30_Tue, 5 Sep 2000 17:33:28 -0400699_iso-8859-1 This is also available in V6.1 - Refer to the Federated Database System Concepts section in Chapter 1 of the Administration Guide Design & Implementation.<br><br><br><br>-----Original Message----- From: leon@CA.IBM.COM [mailto:leon@CA.IBM.COM] Sent: Tuesday, September 05, 2000 5:19 PM To: DB2-L@RYCI.COM Subject: Re: The federated database<br><br><br><br>"Federated database" is a new function that is delivered as part of DB2 Connect V7.1 and DB2 UDB for Unix, Windows and OS/2 V7.1. Take a look at the announcement for these V7.1 products for additional information. Here is a link to the DB2 Connect V7.1 US announcement letter http://www.ibmlink.ibm.com/usalets&parms=H_200-091 [...]
19296 30 24_DB2 v7 Warehouse Manager11_Bob Bloomer21_rbloomer@PEARLNET.COM30_Tue, 5 Sep 2000 20:58:19 -0400548_iso-8859-1 Has anyone attempted to or is productively using DB2 v7.1 Data Warehouse Manager? We have run into various problems and most of them seem to relate to the warehouse control center. An operation that one time takes 6 seconds takes 3 hours on another day. It seems to relate to Java and use of a LOADWC.EXE. We have reinstalled DB2 v7 14 times now attempting to work around the problem (once the problem starts, the only way to clear it is to reinstall; rebooting does not help). We have a 30 day deadline to use it or write a custom [...]
19327 28 28_Re: HELP !!!!! EDM Pool Full16_Charles Valentin15_VALENCH@AOL.COM28_Tue, 5 Sep 2000 21:13:52 EDT340_US-ASCII The edmpool 1K pages? nah You can verify in DSNTIJUZ the dsnzparm EDMPOOL. IF edmpool=10000K, you'll get 2500pgs or 9.8meg. in storage. You may also want to look at IBMLink. There are a few recent PTF's related to EDMPOOL (00C90089) error messages which is (shortage of edmpool). Ptf's available are in (Put-0005/0006) level. [...]
19356 57 20_Re: Training Ground?14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Wed, 6 Sep 2000 13:19:02 +1100507_iso-8859-1 3 days and no response means that no-one else knows of anything either.<br><br>The best you might be able to do is download Personal Developer's Edition V7 (for non-OS/390) and have a play. ( http://www-4.ibm.com/software/data/db2/ <http://www-4.ibm.com/software/data/db2/> and the offer's at the top). OK, it's different from OS/390 but you'll be able to create tables and stuff. COBOL on non-OS/390 is more difficult (I don't even know if there is a COBOL precompiler) - but it's a start. [...]
19414 58 34_Re: DB2 OS/390 V6. 16k bufferpools12_Susan Lawson26_susan_lawson@ATTGLOBAL.NET30_Wed, 6 Sep 2000 00:17:20 -0500566_iso-8859-1 Dave,<br><br>There may be some space increases necessary for sort, but nothing 'official' needs to be done. There should be no effect on the EDM pool.<br><br>You alter a 16K bufferpool with appropriate space, alter/create a tablespace using that bufferpool, unload existing table using REORG UNLOAD EXTERNAL FROM TABLE, use CREATE TABLE LIKE to recreate the table in new tablespace with new page size, reload the table from the SYSREC using control statements from SYSPUNCH which were created from the REORG UNLOAD EXTERNAL, then drop all old stuff. [...]
19473 37 56_Service discontinuance of DB2 OS/390 V4 and V5 announced14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Wed, 6 Sep 2000 16:24:41 +1100644_iso-8859-1 http://www.ibmlink.ibm.com/usalets&parms=H_900-220<br><br>on 31 Dec 2001 others to be withdrawn before then include: IMS V5, COBOL for MVS V1, DFSORT V1R13, OS390 V2R6, CICS TS 1.2<br><br>/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au<br><br><br><br><br><br>********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. [...]
19511 79 34_Re: DB2 OS/390 V6. 16k bufferpools23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Wed, 6 Sep 2000 06:20:25 +0100352_iso-8859-1 Dave<br><br>If I take your request correctly(I hope I have not misunderstood what you are asking) you technically now have a pageset that will , when used, require the services of a 16K bpool (assuming you have ?<br><br>If this is so, then to activate it you just need to give it some storage to use .. which is the following command : [...]
19591 90 30_Re: FW: The federated database18_Gert van der Kooij15_geko@WANADOO.NL30_Wed, 6 Sep 2000 08:15:25 +0200696_iso-8859-1 Hi, The readme file of 6.1 says it is not supported, the docs were wrong in this case.<br><br>----- Original Message ----- From: "Nadir Doctor" <Nadir.Doctor@BGEHOME.COM> Newsgroups: bit.listserv.db2-l To: <DB2-L@RYCI.COM> Sent: Tuesday, September 05, 2000 11:33 PM Subject: FW: The federated database<br><br><br><br>> This is also available in V6.1 - Refer to the Federated Database System > Concepts section in Chapter 1 of the Administration Guide Design & > Implementation. > > > -----Original Message----- > From: leon@CA.IBM.COM [mailto:leon@CA.IBM.COM] > Sent: Tuesday, September 05, 2000 5:19 PM > To: DB2-L@RYCI.COM > Subject: Re: The federated database > > > "Federated [...]
19682 47 57_data sharing and Fast database recovery and /ERE Coldcomm12_Peter, Georg15_G.Peter@DZBW.DE30_Wed, 6 Sep 2000 10:11:24 +0200565_iso-8859-1 Hello list,<br><br>I know a lot of you are using DB2 and IMS. And therefore I've posted the following message that just came from the Lab. If you have the combination described below take a look at the APAR....<br><br>If a customer is using 1) data sharing 2) and using Fast Database Recovery 3) and they enter the /ERE COLDCOMM command (/ERE without the "COLDCOMM" keyword is fine) you should look at PQ40739 The combination of the 3 can cause duplicate backouts to occur - leading to a database integrity problem. The APAR for IMS V6 is PQ40739 . [...]
19730 24 15_set package set24_Mahadevan Krishnamoorthy34_mahadevan.krishnamoorthy@WIPRO.COM30_Wed, 6 Sep 2000 16:06:45 +0530516_- Hi List,<br><br>I have a cobol-db2 program bound to two collections (col1 and col2). I have a plan which plan1 which have col1.* and col2.* are included during my plan bind.<br><br>I am using my plan1 to run the program. I have a set package set to set the collection to col1 . After executing a couple of sqls can I change the collection (ie can I do a set package set to point to a different collection) dynamically or should I have only one set package set for the program. Please give your views on this. [...]
19755 87 26_Re: The federated database13_Lynne Flatley17_LFlatley@NEFN.COM30_Wed, 6 Sep 2000 07:08:09 -0400669_us-ascii No, actually. This feature was documented in Version 6.1 but they couldn't deliver it. I believe the releases notes confirm that. Looking forward to using it in Version 7.1!<br><br>> -----Original Message----- > From: Nadir Doctor [SMTP:Nadir.Doctor@BGEHOME.COM] > Sent: Tuesday, September 05, 2000 5:33 PM > To: DB2-L@RYCI.COM > Subject: FW: The federated database > > This is also available in V6.1 - Refer to the Federated Database System > Concepts section in Chapter 1 of the Administration Guide Design & > Implementation. > > > -----Original Message----- > From: leon@CA.IBM.COM [mailto:leon@CA.IBM.COM] > Sent: Tuesday, September 05, 2000 5:19 PM [...]
19843 37 19_SHARK Dasd & DB2 V518_Whittaker, Stephen26_stephen.whittaker@CPLC.COM30_Wed, 6 Sep 2000 07:22:47 -0400538_iso-8859-1 We are currently at DB2 V5 OS/390 and using Stogroups assigned to 3390 volumes. A new buzzword called 'SHARK' is being tossed around here and we've been asked to test out some DB2 databases on this new Dasd. My understanding, as limited as that is, is that this is an IBM product. As you might figure we DB2/DBA's are the last to know about anything until they tell us its here and to use it. Can anyone out there tell me if they are using this new DASD for their DB2 subsystems and how it is performing? Ie; Any problems [...]
19881 86 23_AW: SHARK Dasd & DB2 V512_Peter, Georg15_G.Peter@DZBW.DE30_Wed, 6 Sep 2000 13:38:52 +0200770_iso-8859-1 Stephen,<br><br>on March 28, 2000, IBM has announced new models of its "Shark" Enterprise Storage Server with the IBM 64-bit RISC processor, 16 gigabytes of cache, and additional PCI buses.<br><br>For more information take a look at http://www.storage.ibm.com/hardsoft/products/ess/ess.htm and the underlaying pages of this url.<br><br>HTH.<br><br>With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------------ Datenzentrale Baden-Wuerttemberg Department Product Support Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ------------------------------------------------------------------------ [...]
19968 52 19_Re: set package set15_Douwe van Sluis20_d.b.vansluis@KPN.COM30_Wed, 6 Sep 2000 13:44:01 +0200311_- Hi Maha,<br><br>You can switch collection id dynamically in a program by using 'SET CURRENT PACKAGESET'. You can change it multiple times in a program run. Be aware that all packages you want to use have to be in this collection id. Also, it's is wise to a commit after the switch, to release resources. [...]
20021 64 19_Re: set package set14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Wed, 6 Sep 2000 22:49:29 +1100487_iso-8859-1 Maha<br><br>You can set packageset as often as you like - even in one program. But, of course, only the last one executed will be active.<br><br>/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au<br><br>-----Original Message----- From: Mahadevan Krishnamoorthy [mailto:mahadevan.krishnamoorthy@WIPRO.COM] Sent: Wednesday, September 06, 2000 9:37 PM To: DB2-L@RYCI.COM Subject: [DB2-L] set package set [...]
20086 38 30_DB2 Connect to DB2 OS/390 V5.110_Robert Ord21_robertord@HOTMAIL.COM28_Wed, 6 Sep 2000 12:09:05 GMT472_- Has anyone seen this error before;<br><br>DSNL511I +DSNP DSNLIENO TCP/IP CONVERSATION FAILED TO LOCATION 134.60.3.81 IPADDR=134.60.3.81 PORT=2451 SOCKET=WRITEV RETURN CODE=1124 REASON CODE=C3170006<br><br>These errors are randomly appearing in the db2 log at the same time as users are experiencing extreme performance problems and even loss of data from result sets.<br><br>The problem is cleared by stopping and starting DDF and rebooting the db2 connect server. [...]
20125 82 34_Re: DB2 Connect to DB2 OS/390 V5.10_28_Roy_Bertossi@ABERCROMBIE.COM30_Wed, 6 Sep 2000 08:59:38 -0400562_us-ascii Rob,<br><br>I found the book on IBM's BookManager website. The URL is http://www.s390.ibm.com:80/bookmgr-cgi/bookmgr.cmd/BOOKS/BPXB100/CCONTENTS.<br><br>Roy ---------------------------------------------------------- Roy Bertossi Abercrombie & Fitch Senior Database Analyst (614) 577-6372<br><br><br><br><br><br>Robert Ord <robertord@HO To: DB2-L@RYCI.COM TMAIL.COM> cc: Sent by: DB2 Subject: DB2 Connect to DB2 OS/390 V5.1 Data Base Discussion List <DB2-L@RYCI.C OM><br><br><br><br>09/06/00 08:09 AM Please respond to DB2 Data Base Discussion List [...]
20208 49 28_Re: Dilbert on certification10_John Hardy27_john_j_hardy@CONSULTANT.COM30_Wed, 6 Sep 2000 07:30:56 -0500721_- I think you'll find that Dilbert is universal too............<br><br><br><br><br><br>On Tue, 5 Sep 2000 14:17:38 -0700, The Fillmore Group, Inc. <fillmore@CLARK.NET> wrote:<br><br>> >I know this is breaking the rule on attachments, but, hey, I've never let that stop me before. Enjoy... BTW, I forwarded this to some of the folks inside IBM who >are responsible for DB2 certification and certification education. I think they've laughed the hardest. > >For our international colleagues, "Dilbert" is a cartoon about a *typical* office worker professional. I believe the humor is universal. > > >+------------------------------------- +--------------------------------------+ >| Frank C. Fillmore, Jr. | Voice/Fax: [...]
20258 19 19_DB2 functions/FMIDs27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM30_Wed, 6 Sep 2000 07:49:45 -0500508_- Is there any place where all function sysmods/FMIDs are described? I'm installing DB2 V6 and trying to figure out which ones to exclude from teh receive job. For example, the ones for Data Propagator are labelled 'DB2 UDB Server'.<br><br>Thanks,<br><br>Tina Hilton<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
20278 49 23_Re: DB2 functions/FMIDs15_Loria, Susan C.27_Susan_C_Loria@TVRATINGS.COM30_Wed, 6 Sep 2000 09:02:01 -0400373_iso-8859-1 Hi Tina,<br><br>It's not as clear cut as I would have liked it, but you can find most of the FMIDs and product it belongs to on page 16 of the program directory document for DB2 for OS/390 V6 Volume 1 of 6 - that's for the DB2 UDB product. If you are installing DB2 PM product set, it is listed on page 3 of it's product directory, volume 2 of 6, etc. etc. [...]
20328 45 28_Re: HELP !!!!! EDM Pool Full12_Terry Spikes21_terryspikes@YAHOO.COM30_Wed, 6 Sep 2000 06:29:05 -0700602_us-ascii Charles,<br><br>You're right! I was thinking that ZPARM EDMPOOL was # of pages. It's actually the Size in kilobytes. I'll check IBM link for those PTFs.<br><br><br><br>--- Charles Valentin <VALENCH@AOL.COM> wrote: > The edmpool 1K pages? nah > You can verify in DSNTIJUZ the > dsnzparm EDMPOOL. > IF edmpool=10000K, you'll get > 2500pgs or 9.8meg. in storage. > You may also want to look at IBMLink. > There are a few recent PTF's related to > EDMPOOL (00C90089) error messages > which is (shortage of edmpool). > Ptf's available are in (Put-0005/0006) level. > > CValentin > DB2 Systems [...]
20374 38 41_Calling DB2 Stored Procedures from SAS PC17_Edward G. La Touf17_elatouf@YAHOO.COM30_Wed, 6 Sep 2000 08:33:11 -0500274_- I have a SAS PC program which accesses DB2 on OS390. I am trying to create a stored procedure for the SQL portion. It currently creates a SAS temporary data set and issues a select against a DB2 table to load the data set, then processes that SAS temporary data set. [...]
20413 44 60_Re: Service discontinuance of DB2 OS/390 V4 and V5 announced12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV30_Wed, 6 Sep 2000 09:53:00 -0400452_- Also, according to IBM support, CSP370/AD V4.1 and CSP370/RS V2.1 on Dec 31,2001.<br><br>>>> DB2-L@RYCI.COM@inter2 09/06/00 12:24AM >>> http://www.ibmlink.ibm.com/usalets&parms=H_900-220<br><br>on 31 Dec 2001 others to be withdrawn before then include: IMS V5, COBOL for MVS V1, DFSORT V1R13, OS390 V2R6, CICS TS 1.2<br><br>/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au [...]
20458 58 11_Re: DB2 UDB0_18_Usregion10@AOL.COM28_Wed, 6 Sep 2000 11:02:51 EDT479_ISO-8859-1 Hi Bill!<br><br>Thanks for your response to my previous note. I would appreciate if you could give answers to some the questions below.<br><br>1. What is your general rule for number of databases per instance ?<br><br>2. lets say you have more than one databases ? Do you have a unique directory per database, say /db2db1/...., /db2db2/....,/db2db3/... so on and so forth ? or do you use /db2db/dbxxxnnn (where nnn is 001, 002, 003) for more than one databases ? [...]
20517 72 34_Re: DB2 OS/390 V6. 16k bufferpools9_Rob Crane22_racrane@CONCENTRIC.NET30_Wed, 6 Sep 2000 09:47:27 -0600509_us-ascii Susan's point about the use and design of the 15000 byte row should be considered. Not saying that you don't have a business need for that large of a row but typically when I see that row size it is an attempt to just dump the old "vsam master file" into one row with a dummy key for the row that typically has nothing to do with the row or its contents. I would make sure to understand what the need for the 15000 byte row is before you implement the new page size and end up spending the next [...]
20590 12 28_Data Sharing Training? Where12_Richard Pack23_rpack1@MAIL.STATE.MO.US30_Wed, 6 Sep 2000 10:58:26 -0500450_- Can anyone suggest training options for DB2 Data Sharing implementation other than IBM. IBM's schedule class is scheduled later than I need. Any other companies having classes that the public can enroll in?<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
20603 47 19_Re: set package set13_Olson, Carlos14_COlson@QRS.COM30_Wed, 6 Sep 2000 09:34:30 -0700445_iso-8859-1 We have been successfully using the "SET PACKAGESET" statement in several of our batch programs to dynamically change the collection (to access the same table with a different CREATOR). Be aware that if you execute a SET PACKAGESET statement between FETCHes of the same OPEN CURSOR, you lose the cursor ie. when you open a cursor, you must complete fetching and close the cursor between executions of a SET PACKAGESET statement. [...]
20651 79 38_HeLp!!! bypass roll-forward pending???17_McDonnell, Victor22_vmcdonnell@CAYENTA.COM30_Wed, 6 Sep 2000 10:08:58 -0700355_iso-8859-1 DB2 UDB 6.1 on AIX/6000 'just did a recover from an *online* full database backup and *don't* want to apply the logs. Can one bypass the roll-forward???<br><br>Thanks,<br><br>Victor McDonnell Database Architect and Administrator <<...OLE_Obj...>> 1900 Campus Commons Dr Reston, VA 20191 phone: 703.390.4826 email: vmcdonnell@cayenta.com<br><br>
20731 30 15_CAE Information23_DePratti, Roland A H07A25_Roland.DePratti@CIGNA.COM30_Wed, 6 Sep 2000 13:15:55 -0400449_us-ascii A co-worker of mine has been asked to work on a project to upgrade CAE across our division, multiple sites. I am looking for good sources of information on what this may involve and the steps needed to complete ( i.e. more detail, than fluff). We currently use a thin client version. Any suggestions on Redbooks, white papers, etc. We have found the IBM Universal Connectivity Redbook from 1998. We are looking for additional sources. [...]
20762 122 23_Re: SHARK Dasd & DB2 V513_Olson, Carlos14_COlson@QRS.COM30_Wed, 6 Sep 2000 10:17:33 -0700628_iso-8859-1 We converted over to SHARK DASD in February and have not encountered any DB2 problems whatsoever. We are at OS390 2.6 on DB2V6. At the time of conversion we were at OS390 2.4 and DB2V4. I've done many REORGs, RECOVERYs, LOADs and UNLOADs since February using both IBM and CA/Platinum utilities. I recently did a LOAD REPLACE of 560 million rows into a 108 partition LARGE tablespace with 3 indices using CA/Platinum FASTLOAD VERSION 04.01.5 in 12 hours (CPU=12:55:58 ELAPSED=12:53:32)! I heard there were several disk failures, power unit failures, and one controller failure but none of these failures affected [...]
20885 68 19_Re: set package set15_David A. Zelmer25_david.zelmer@CITICORP.COM30_Wed, 6 Sep 2000 12:23:58 -0500474_us-ascii When I was testing with "SET PACKAGESET", I found that if you did not close the cursor before switching to another packageset, if you switched back to the original packageset the cursor was still available and more rows could be fetched. Further, in this cobol program, the open cursor statement could be executed twice w/o an intervening close as long as the packageset was changed. The program could switch back and forth and retrieve rows from each cursor. [...]
20954 133 23_Re: SHARK Dasd & DB2 V512_Carol Sutfin19_csutfin@AMSOUTH.COM30_Wed, 6 Sep 2000 12:35:39 -0500762_- Carlos,<br><br>Does your DASD management group have StoreWatch running to monitor your SHARK units???<br><br>Carol Sutfin Corporate DBA AmSouth Bank N.A. (205)326-5214 csutfin@amsouth.com<br><br><br><br><br><br>"Olson, Carlos" <COlson@QRS.COM> on 09/06/2000 12:17:33 PM<br><br><br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br>To: DB2-L@RYCI.COM cc: (bcc: Carol Sutfin/BIRMINGHAM/AL/AMSOUTH BANK) Subject: Re: SHARK Dasd & DB2 V5<br><br><br><br><br><br><br><br>We converted over to SHARK DASD in February and have not encountered any DB2 problems whatsoever. We are at OS390 2.6 on DB2V6. At the time of conversion we were at OS390 2.4 and DB2V4. I've done many REORGs, RECOVERYs, LOADs and UNLOADs since February using both [...]
21088 63 42_Re: HeLp!!! bypass roll-forward pending???0_18_damcon2@US.IBM.COM30_Wed, 6 Sep 2000 13:41:45 -0400310_us-ascii Victor,<br><br>Just an idea, haven't tried it myself, but shouldn't it be possible to fake it out by rolling forward to a timestamp that is just after the backup timestamp that you restored from? I would think this would have minimal impact to the restore since this is an on-line backup anyway. [...]
21152 65 34_Re: DB2 Connect to DB2 OS/390 V5.150_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM30_Wed, 6 Sep 2000 14:08:33 -0400377_- I have had similiar problem:<br><br>DSNL511I % DSNLIENO TCP/IP CONVERSATION FAILED TO LOCATION 147.154.246.171 IPADDR=147.154.246.171 PORT=2703 SOCKET=READ RETURN CODE=1121 REASON CODE=00000000<br><br>I found the return code :: if memory serves me correctly in:: open edition for appl programmers. It was buried in there:: then I went to IBMLINK for a full explanation. [...]
21218 106 19_Re: set package set13_Olson, Carlos14_COlson@QRS.COM30_Wed, 6 Sep 2000 11:20:17 -0700624_iso-8859-1 We implemented PACKAGESETs for similar reasons... our 16 partition tablespace in DB2 V2.3 was approaching the 4 GIG partition limit so we split the 16 partitions into 16 physical tablespaces with different CREATORs and created 16 synonyms to all other tables being referenced in the same programs. We initially coded the first program to use a cursor on a reference table (with 16 synonyms with the 16 CREATORs) to determine the input value for the SET PACKAGESET statement. That's when we discovered that after executing the SET PACKAGESET statement and processing some data, we could not go back and FETCH [...]
21325 176 23_Re: SHARK Dasd & DB2 V513_Olson, Carlos14_COlson@QRS.COM30_Wed, 6 Sep 2000 11:22:20 -0700565_iso-8859-1 Yes.<br><br>-----Original Message----- From: Carol Sutfin [mailto:csutfin@AMSOUTH.COM] Sent: Wednesday, September 06, 2000 10:36 AM To: DB2-L@RYCI.COM Subject: Re: SHARK Dasd & DB2 V5<br><br><br><br>Carlos,<br><br>Does your DASD management group have StoreWatch running to monitor your SHARK units???<br><br>Carol Sutfin Corporate DBA AmSouth Bank N.A. (205)326-5214 csutfin@amsouth.com<br><br><br><br><br><br>"Olson, Carlos" <COlson@QRS.COM> on 09/06/2000 12:17:33 PM<br><br><br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM> [...]
21502 88 34_Re: DB2 Connect to DB2 OS/390 V5.113_Mackey, Glenn21_GMackey@GUIDEMAIL.COM30_Wed, 6 Sep 2000 13:26:16 -0500591_iso-8859-1 Hi, Over time I have had similar unexplained and non-reproducible problems. This group gave some good points which you can investigate. Bottom line: seems that these are very hard to solve problems.<br><br>Visit the archives http://jupiter.ryci.com/archives/db2-l.html and search against the SUBJECT "Help needed with problem"<br><br>hth Glenn<br><br>-----Original Message----- From: Knight, Robert A. (Cameron of Pittsburgh at Alcoa) [mailto:Robert.Knight@ALCOA.COM] Sent: Wednesday, September 06, 2000 1:09 PM To: DB2-L@RYCI.COM Subject: Re: DB2 Connect to DB2 OS/390 V5.1 [...]
21591 120 19_Re: set package set15_David A. Zelmer25_david.zelmer@CITICORP.COM30_Wed, 6 Sep 2000 13:36:12 -0500542_us-ascii We are currently V5 but this testing was done several years ago, probably V3.1. We use alias instead of synonyms for the other tables that do not have a physical presence for all creators. Most of our tables in this situation are in support of OLTP and are interested in single row queries, i.e. acct #, so I can not relate to your situation. My testing was against the same logical table, split by different creators. I didn't try a cursor against a non-split table and switching between packagesets. Now I wish I had done it. [...]
21712 86 42_Re: HeLp!!! bypass roll-forward pending???14_Jack O'Connell26_jack.oconnell@MCMASTER.COM30_Wed, 6 Sep 2000 13:55:26 -0500548_iso-8859-1 Try to Recover TOCOPY instead of to a RBA. That means you lose all updates after the copy unless you apply them after the restore in another job or step.<br><br>-----Original Message----- From: McDonnell, Victor [mailto:vmcdonnell@CAYENTA.COM] Sent: Wednesday, September 06, 2000 12:09 PM To: DB2-L@RYCI.COM Subject: HeLp!!! bypass roll-forward pending???<br><br><br><br><br><br>DB2 UDB 6.1 on AIX/6000 'just did a recover from an *online* full database backup and *don't* want to apply the logs. Can one bypass the roll-forward??? [...]
21799 108 19_Re: set package set19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Wed, 6 Sep 2000 14:01:12 -0500439_iso-8859-1 Hi David, You said something that caught my attention: "We do use this quite extensively in production. The reason is to have the same logical definition but different physical objects. This is done to keep tables smaller. This way utility operations run quicker and outages can be kept to just a subset of the data." Could you please provide an example on or off List? I've had similar thoughts about dividing up objects. [...]
21908 67 19_Re: set package set19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Wed, 6 Sep 2000 14:09:30 -0500461_iso-8859-1 Would whoever is doing this please stop . . . thank you<br><br>This is an auto-generated system message. Please do not reply to this address.<br><br>*** E-Mail Acknowledgment/Important Notice *** Receipt of this acknowledgment confirms that the e-mail message you sent to an employee of Morgan Stanley Dean Witter has been received. Please be advised, however, that it is not an indication that the message was opened and read by the recipient. [...]
21976 79 42_FW: HeLp!!! bypass roll-forward pending???12_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM30_Wed, 6 Sep 2000 15:15:16 -0400393_iso-8859-1 I wonder if this can be done - On referring to the Command Reference manual, I doubt if the roll-forward could actually be disabled for an *offline* full database backup too.<br><br>-----Original Message----- From: damcon2@US.IBM.COM [mailto:damcon2@US.IBM.COM] Sent: Wednesday, September 06, 2000 1:42 PM To: DB2-L@RYCI.COM Subject: Re: HeLp!!! bypass roll-forward pending??? [...]
22056 160 19_Re: set package set19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Wed, 6 Sep 2000 14:10:55 -0500654_iso-8859-1 David, Carlos, With 254 partitions now available in V6, would you still consider using your "partitioning scheme"?<br><br>Regards, Rick Davis<br><br>"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of [...]
22217 34 32_FW: Data Sharing Training? Where12_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM30_Wed, 6 Sep 2000 15:36:38 -0400544_iso-8859-1 Perhaps, these websites may be of help:<br><br>http://www.mvs-training.com<br><br>http://www.nims.net<br><br><br><br><br><br>-----Original Message----- From: Richard Pack [mailto:rpack1@MAIL.STATE.MO.US] Sent: Wednesday, September 06, 2000 11:58 AM To: DB2-L@RYCI.COM Subject: Data Sharing Training? Where<br><br><br><br>Can anyone suggest training options for DB2 Data Sharing implementation other than IBM. IBM's schedule class is scheduled later than I need. Any other companies having classes that the public can enroll in? [...]
22252 38 42_Re: HeLp!!! bypass roll-forward pending???14_Mike Lebermann18_Lebermm@BCBSKC.COM30_Wed, 6 Sep 2000 14:31:53 -0500483_US-ASCII Victor,<br><br>You cannot bypass a roll-forward from an online backup. There is a minimum log timestamp you must rollforward to. If you specify the timestamp right after the online backup (from the recovery history file), your rollforward will not be successful. It will give you an error message with the minimum log timestamp value. That is the earliest timestamp you can use. Also you must use the CUT time for the rollforward timestamp. The restore use local time. [...]
22291 104 42_Re: HeLp!!! bypass roll-forward pending???10_Leo Pedron19_lpedron@BOSCOVS.COM30_Wed, 6 Sep 2000 15:47:43 -0400363_iso-8859-1 You can disable roll forward for an *offline* backup by specifying "without rolling forward" during the restore.<br><br>Although I have never done it, you can cancel a roll forward pending state. This will cause the database to be left in a restore pending state. Then you could re-restore the database using the "without rolling forward" option. [...]
22396 63 42_FW: HeLp!!! bypass roll-forward pending???12_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM30_Wed, 6 Sep 2000 15:51:54 -0400341_iso-8859-1 Mike,<br><br>On referring to the Command Reference manual, I couldn't find the option which one can specify so that this rollforward is done upto a certain timestamp - Please let us know.<br><br>Also, could you kindly elaborate more on: "you must use the CUT time for the rollforward timestamp. The restore use local time. " [...]
22460 31 25_DCLGEN bind package fails11_John Wallin24_john.wallin@ZURICHUS.COM30_Wed, 6 Sep 2000 14:37:13 -0500316_us-ascii We are trying to bind a package at the remote site RS/6000 AIX box and get this error. I can't find the error code in the UDB manuals and The Member DSNECP68 is a DBRM on the mainframe How can I remove the bad parm bind option (VERSION) from the DBRM to allow the bind? This is for the DCLGEN program. [...]
22492 121 34_Re: DB2 Connect to DB2 OS/390 V5.116_Marcelo Silveira22_mardb2ques@HOTMAIL.COM28_Wed, 6 Sep 2000 19:54:34 GMT862_- Hi,<br><br>There is also another website:<br><br>http://www-4.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/index.d2w/report<br><br><br><br>Marcelo.<br><br><br><br>>From: "Mackey, Glenn" <GMackey@GUIDEMAIL.COM> >Reply-To: DB2 Data Base Discussion List <DB2-L@RYCI.COM> >To: DB2-L@RYCI.COM >Subject: Re: DB2 Connect to DB2 OS/390 V5.1 >Date: Wed, 6 Sep 2000 13:26:16 -0500 > >Hi, >Over time I have had similar unexplained and non-reproducible problems. >This >group gave some good points which you can investigate. Bottom line: seems >that these are very hard to solve problems. > >Visit the archives http://jupiter.ryci.com/archives/db2-l.html and search >against the SUBJECT "Help needed with problem" > >hth >Glenn > >-----Original Message----- >From: Knight, Robert A. (Cameron of Pittsburgh at Alcoa) >[mailto:Robert.Knight@ALCOA.COM] >Sent: [...]
22614 116 42_FW: HeLp!!! bypass roll-forward pending???12_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM30_Wed, 6 Sep 2000 16:07:34 -0400586_iso-8859-1 Thanks, Leo.<br><br>-----Original Message----- From: Leo Pedron [mailto:lpedron@BOSCOVS.COM] Sent: Wednesday, September 06, 2000 3:48 PM To: DB2-L@RYCI.COM Subject: Re: HeLp!!! bypass roll-forward pending???<br><br><br><br>You can disable roll forward for an *offline* backup by specifying "without rolling forward" during the restore.<br><br>Although I have never done it, you can cancel a roll forward pending state. This will cause the database to be left in a restore pending state. Then you could re-restore the database using the "without rolling forward" option. [...]
22731 111 46_Re: FW: HeLp!!! bypass roll-forward pending???14_Mike Lebermann18_Lebermm@BCBSKC.COM30_Wed, 6 Sep 2000 15:09:43 -0500520_US-ASCII Nadir,<br><br>1. I've recently tested tablespace restores from online backups, but this should also apply to online database backups as well, just remove reference to tablespace(recover_ts):<br><br>db2 "restore db test_db tablespace(recover_ts) online use adsm taken at 20000717083340"<br><br>db2 "rollforward db test_db complete tablespace(recover_ts) online" (TO GET MINIMUM LOG TIMESTAMP TO ROLLFORWARD TO)<br><br>db2 "rollforward db test_db to 2000-07-17-13.34.01.000000 tablespace(recover_ts) online" [...]
22843 69 36_Re: FW: Data Sharing Training? Where12_Susan Lawson22_lawson_susan@YAHOO.COM30_Wed, 6 Sep 2000 13:33:21 -0700406_us-ascii Richard,<br><br>At the DB2 Symposium (www.db2-symposium.com) in San Francisco on Nov 6th and in Phoenix, AZ on Dec 8th, I will be teaching the 1 day DB2 Data Sharing Implementation and Performance course. It is a very intense 1 day data sharing implementation course covering everyting from sysplex hardware to DB2 application/system performance. Up to date with V7 and may user experiences. [...]
22913 31 35_Re: Who issued the command - DB2 V512_tim malamphy20_timalamphy@YAHOO.COM30_Wed, 6 Sep 2000 13:35:41 -0700580_us-ascii You may be able to find it in the MVS log also...you should find either a TSO id or a console address. --- HesterRC@AOL.COM wrote: > Is there any way to determine who issued a start or > stop database command on DB2 for OS/390 V5? > example: > -STA DB(DB1234) SPACE(SP00001) ACCESS(RO) > -STO DB(DB1234) SPACE(SP00001) > > ================================================ > To change your subscription options or to cancel > your subscription visit the DB2-L webpage at > http://www.ryci.com/db2-l. The owners of the list > can be reached at DB2-L-REQUEST@RYCI.COM. [...]
22945 194 49_Re: set package set - one way to use this concept15_David A. Zelmer25_david.zelmer@CITICORP.COM30_Wed, 6 Sep 2000 15:58:22 -0500325_us-ascii This post is rather long, so please bear with me.<br><br>My company is a rather large company with a goal of 1 billion customers by 2010. We are in over 100 countries around the globe. Understandably we have a lot of data to keep track of. Luckily for me I deal with a subset of this data but it is still huge. [...]
23140 109 31_Re: Delaying Archive Log Copies12_tim malamphy20_timalamphy@YAHOO.COM30_Wed, 6 Sep 2000 14:00:09 -0700577_us-ascii Have you thought about archiving to disk, instead of tape during that time frame? tim --- "Snoeyenbos, Craig" <Craig.Snoeyenbos@STARWOODHOTELS.COM> wrote: > I've had the "pleasure" of watching a DB2 system > lock itself at 100% due to > silo issues under V3 without the cancel command. > (Normal IPL scheduled for > 03:00 Sunday, DB2 filled at about 01:45.) No other > problems due to letting > it fill. > > In Anthony's case, I'd recommend haveing the > operators reply no to the mount > requests and then just issueing a normal archive > command as soon as the [...]
23250 604 48_Re: Triggers - Where can I get more information?0_34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM30_Wed, 6 Sep 2000 15:16:06 -0500454_us-ascii Here are some examples of triggers that I coded to accomplish two exercises that I did simply to get familiar with triggers.<br><br>I welcome comments regarding these in that it is my first attempt to code triggers and I would like to know more about them:<br><br>My first exercise was to create a parent and child table with the referential integrity maintained by triggers instead of traditional RI. My DDL that I created to do this was: [...]
23855 117 28_Re: Cross LPAR communication12_Vernon, John27_John.Vernon@TRS.STATE.TX.US30_Wed, 6 Sep 2000 16:09:37 -0500496_iso-8859-1 My sincerest Thanks to Tony Clark, Kurt Sahlberg, Jaap Slot and Kirk Hampton for their advice and help in solving my VTAM problem. It turned out that there were errors in the original VTAM setup, once these were corrected we now have cross-lpar communication!<br><br>Thanks gang!!<br><br>John<br><br>-----Original Message----- From: Slot, JP (Jaap) [mailto:J.P.Slot@RF.RABOBANK.NL] Sent: Thursday, August 24, 2000 10:18 AM To: DB2-L@RYCI.COM Subject: Re: Cross LPAR communication [...]
23973 328 19_Re: set package set15_David A. Zelmer25_david.zelmer@CITICORP.COM30_Wed, 6 Sep 2000 16:08:12 -0500542_us-ascii I just sent a long post on our design, but the short answer is no. The reason is the data in a partitioned table is sorted by one clustering key, either ascending or descending. Doesn't matter if you do not know in advance where your growth will come from. What if all the growth is in one partition? Yes, repartitioning will be fun the first time but what about the 10th or 20th time? Pros and cons exist either way. I think each application should be evaluated on its own merits. Maybe we would have rethought this if it were [...]
24302 226 49_Re: set package set - one way to use this concept19_Rajeev P. Dhanawade22_rdhanawade@STATE.DE.US28_Wed, 6 Sep 2000 17:05:36 EDT317_us-ascii Hi David,<br><br>We have a similar design here but for another purpose. A few weeks ago I had suggested this approach to someone on this list to manage unit testing of development teams in a project. At that time, it was debunked as a "Tree shade mechanic" approach.<br><br>I am glad I have company ;-) [...]
24529 87 22_Re: Db2 subsystem name12_tim malamphy20_timalamphy@YAHOO.COM30_Wed, 6 Sep 2000 14:15:28 -0700593_us-ascii If you look at the ????MSTR address space startup messages, DSNZ002I will tell you the subsystem name that particular DB2 region is using. I think most sysprogs will have used whatever ???? is. Setting your prefix to *MSTR (using SDSF) will show you all the different DB2 regions on that LPAR. --- Kurian B <Bejoy_Kurian@MAY-CO.COM> wrote: > Use DB2 command -DISPLAY GROUP you can see the > current version of DB2 > running. > Thanks > Bejoy > > > > From: "Sinha, Ranjay Kumar (CTS)" > <SRanjay@CAL.CTS-CORP.COM>@RYCI.COM> on > 08/28/2000 11:36 PM > > Please respond to DB2 Data [...]
24617 117 46_FW: FW: HeLp!!! bypass roll-forward pending???12_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM30_Wed, 6 Sep 2000 17:33:08 -0400546_iso-8859-1 Thanks much, Mike.<br><br><br><br>-----Original Message----- From: Mike Lebermann [mailto:Lebermm@BCBSKC.COM] Sent: Wednesday, September 06, 2000 4:10 PM To: DB2-L@RYCI.COM Subject: Re: FW: HeLp!!! bypass roll-forward pending???<br><br><br><br>Nadir,<br><br>1. I've recently tested tablespace restores from online backups, but this should also apply to online database backups as well, just remove reference to tablespace(recover_ts):<br><br>db2 "restore db test_db tablespace(recover_ts) online use adsm taken at 20000717083340" [...]
24735 636 48_Re: Triggers - Where can I get more information?9_Cam White20_cwhite@REVEALNET.COM30_Wed, 6 Sep 2000 17:36:32 -0400727_iso-8859-1 The March issue of the Pipeline Newsletter has an article on Triggers by Craig Mullins. This article is one of the topics inside RevealNet's Knowledge Base for DB2. Here's the link to the newsletter: http://www.revealnet.com/newsletter/newsletter_0300.htm<br><br>A 30-day trial of the knowledge base is available from www.revealnet.com<br><br>Best wishes,<br><br>Cam White RevealNet<br><br>> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > L-IS.Kirkpatrick@MUTUALOFOMAHA.COM > Sent: Wednesday, September 06, 2000 4:16 PM > To: DB2-L@RYCI.COM > Subject: Re: Triggers - Where can I get more information? > > > Here are some examples of triggers that I coded [...]
25372 291 49_Re: set package set - one way to use this concept25_Robinson, Peter [IBM GSA]33_Peter.J.Robinson@TEAM.TELSTRA.COM30_Thu, 7 Sep 2000 09:08:45 +1100537_iso-8859-1 Hi David<br><br>Have you ever had any problems with DSMAX? We found it limiting at times using the type of structure you have (long story below). For example, we always had to think carefully about adding a new index because there would be many copies of the same index. We also had to put multiple tables in a single tablespace just to bring down out number of open datasets so we could add required indexes. Of course, DSMAX was lower in those days. We did however find the advantages far outweighed the disadvantages. [...]
25664 35 35_Application & Data Layer Separation15_Camitta, Steven30_steven.camitta@INGRAMMICRO.COM30_Wed, 6 Sep 2000 17:49:22 -0700491_iso-8859-1 We're interested in exploring the concept of constructing applications that have a distinct and separate application layer and data layer. We've noticed that most application changes that move through the lifecycle affect what would be considered the application layer. They infrequently change the data layer. By commingling the layers, as we do today, we're constantly precompiling, binding, explaining and reexamining access paths as our code moves from QA to production. [...]
25700 138 45_SIRDUG Meeting (Charlotte, NC) September 15th11_Paul Turpin22_pault704@EARTHLINK.NET30_Wed, 6 Sep 2000 20:15:37 -0500614_- Southeastern Inter-Relational Database Users' Group (SIRDUG) http://users.vnet.net/sirdug<br><br>WHEN? Friday September 15, 2000<br><br>WHERE? Renaissance Suites Hotel 2800 Coliseum Drive Charlotte, NC (704) 357-1414<br><br>COST? Free - Note: Please pre-register. Whoever pre-registers is guaranteed lunch. Drop-ins may have to fend for them selves.<br><br>September 15th Meeting Features: Vendor Fair<br><br>Come and learn the latest that the vendors are offering by visiting their booths in the vendor area, and become eligible for drawings for prizes at the end of the day (grand prize is a Palm Pilot). [...]
25839 21 12_Load Problem7_Db2 Dba24_data_analyst@HOTMAIL.COM30_Thu, 7 Sep 2000 01:12:11 -0500309_- Hi everyone,<br><br>Today I loaded 40,000 rows into a table in EEE/AIX using Autoloader on a single partition. It took about a couple of minutes to complete. When I changed one of the column attributes from 'varchar(30)' to 'varchar(30) not null with default', the load took about 2 hours to complete. [...]
25861 30 35_A question about DR and archive log14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT30_Thu, 7 Sep 2000 09:35:47 +0100601_us-ascii We have a DR procedure and we are migrating from one toolz to another toolz (from BMC Recovery Manager to Platinum Recovery Analyzer). There are many differences between RM and RA, but not so substantial.<br><br>But I'm wondering why in BMC's Recovery Manager DR job there is a step (after BSDS recovery) where the procedure delete ALL archive logs in BSDS AND a subsequent step with the addition of the SAME archive logs, i.e. the same archive logs deleted in the previous step,via NEWLOG instruction using change log inventory. In IBM's DR procedure this step is not present, the same [...]
25892 65 39_Re: A question about DR and archive log23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Thu, 7 Sep 2000 08:43:35 +0100307_iso-8859-1 Max<br><br>The only reason why I think this would be needed is to change the Volume on which the dataset(archlog) resides as defined int he BSDS......i.e at DR it may end up on a different volume ... at our shop the volume is ignored anyway so we do not bother deleting and redefining it .. [...]
25958 36 39_Re: A question about DR and archive log14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT30_Thu, 7 Sep 2000 10:41:33 +0100279_us-ascii Hi Leslie, nice to meet you again and thanks for your reply. With your magic powers you switch the light on, so I resolve the problem !!!<br><br>In our production we have the first archive on DASD, the second on STK tape, and the tapes of this archives are sent to [...]
25995 56 19_Re: set package set17_R.V. Subrahmanian33_rv_subrahmanian@CHENNAI.TCS.CO.IN30_Thu, 7 Sep 2000 14:16:57 +0530679_us-ascii Hi Maha,<br><br>I think the same can be achieved by defining alias of the table(s) and having a single packageset in the program.<br><br>Regards, R V Subramanian<br><br><br><br><br><br><br><br><br><br>Mahadevan Krishnamoorthy <mahadevan.krishnamoorthy@WIPRO.COM> on 09/06/2000 17:06:45<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br>To: DB2-L@RYCI.COM cc: (bcc: R.V. Subrahmanian/MLs/TCSCHENNAI)<br><br>Subject: set package set<br><br><br><br><br><br><br><br>Hi List,<br><br>I have a cobol-db2 program bound to two collections (col1 and col2). I have a plan which plan1 which have col1.* and col2.* are included during my plan bind. [...]
26052 41 20_Re: Training Ground?10_John Hardy27_john_j_hardy@CONSULTANT.COM30_Thu, 7 Sep 2000 04:46:56 -0500554_- The problem is that A DBAs responsibilities are so closed tied to the platform on which he/she is working. Short of running MVS/TSO on your PC at home, you can't really do much!<br><br>You haven't told us what steps you have taken already to further your ambitions. Assuming you are a permanent member of staff, if you haven't done so already (and assuming you have discussed this with your boss), you could do worse than have a chat with your friendly local DBA. He/She will probably be able to help you, and give you some good books to read. If [...]
26094 28 28_Bind plan for Dpropr Capture19_Michael Lim (HKSCC)24_TSMLIM@HKCLEARING.COM.HK30_Thu, 7 Sep 2000 17:53:05 +0800636_US-ASCII Hi,<br><br>I'm trying to bind the plan for Data Propagator Capture and it is looking for a table called IBMSNAP_PRUNE_LOCK. This table is not mentioned in either the documentation or the DPCNTL.MVS file. Does anyone know where I can find the DDL to create this table?<br><br>TIA, Michael<br><br>"This message is intended only for use of the addressee and may contain information that is privileged and confidential. If you are not the intended recipient, you are hereby notified that any use or dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us [...]
26123 78 32_Re: Bind plan for Dpropr Capture11_Arne Nilsen18_Arne.Nilsen@SDS.NO30_Thu, 7 Sep 2000 12:53:00 +0200463_iso-8859-1 Hi;<br><br>I can't refer to any manual, but I have compared the tabledefinitions i V5 an V6 and observed these differencies:<br><br>2 new tables og changes in 1 old<br><br>Here is "our" DDL:<br><br>CREATE TABLE ASN.IBMSNAP_PRUNE_LOCK (DUMMY CHAR(1) ) IN XDCB00.TSCB0001 AUDIT NONE DATA CAPTURE CHANGES CCSID EBCDIC; CREATE TABLE ASN.IBMSNAP_REG_SYNCH (TRIGGER_ME CHAR(1) NOT NULL ) IN XDCB00.TSCB0001 AUDIT NONE DATA CAPTURE CHANGES CCSID EBCDIC; [...]
26202 79 30_Not quite relational SQL Query14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK30_Thu, 7 Sep 2000 11:55:35 +0100415_iso-8859-1 Hi, all you SQL gurus out there.<br><br>I've been puzzling over an SQL problem for a day, and can't seem to bottom it out. I could easily pass it to a developer and say "write a program to do it," but that would admit defeat!<br><br>I have an audit trail table, which records actions against objects. I need to display any object which has an action of "C" IMMEDIATELY FOLLOWED BY an action of "R". [...]
26282 76 29_Re: DCLGEN bind package fails0_25_Ed_Vetock@NAVYFEDERAL.ORG30_Thu, 7 Sep 2000 06:59:03 -0400684_us-ascii Hi John,<br><br>We went through the same thing...We were successful binding on OS/390 to an AIX box with the following:<br><br>BIND PACKAGE (BG1TO1DB.DSNESPCS) OWNER (OSS02) QUALIFIER (OSS02) MEMBER(DSNESM68) LIBRARY('DB2SMPE.V51.DB2TZT1.SDSNDBRM') SQLERROR(NOPACKAGE) VALIDATE(BIND) ISOLATION(CS) CURRENTDATA(YES) ACTION(REPLACE) BIND PACKAGE (BG1TO1DB.DSNESPRR) OWNER (OSS02) QUALIFIER (OSS02) MEMBER(DSNESM68) LIBRARY('DB2SMPE.V51.DB2TZT1.SDSNDBRM') SQLERROR(NOPACKAGE) VALIDATE(BIND) ISOLATION(CS) CURRENTDATA(YES) ACTION(REPLACE)<br><br><br><br>HTH<br><br>Ed<br><br><br><br><br><br><br><br>John Wallin <john.wallin@ZURICHUS.COM>@RYCI.COM> on 09/06/2000 03:37:13 PM [...]
26359 14 49_Re: set package set - one way to use this concept9_Colin Fay13_cfay2@CSC.COM30_Thu, 7 Sep 2000 07:20:05 -0400324_us-ascii Hi David,<br><br>This sounds like a wonderful IDUG presentation! Why not?<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
26374 60 29_Re: DCLGEN bind package fails11_David Ayers24_david.ayers@HIGHMARK.COM30_Thu, 7 Sep 2000 07:19:55 -0400445_us-ascii John, only a certain number of bind parms are valid as drda remote binds (version is not). If you have the program you shoud re-compile with the pre compile version option disabled -hth dfa<br><br><br><br><br><br><br><br>John Wallin <john.wallin@ZURICHUS.COM>@RYCI.COM> on 09/06/2000 03:37:13 PM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br>Sent by: DB2 Data Base Discussion List <DB2-L@RYCI.COM> [...]
26435 381 49_Re: set package set - one way to use this concept0_18_mebert@AMADEUS.NET30_Thu, 7 Sep 2000 13:54:45 +0200409_us-ascii We're using the same strategy here - for us it's countries, not teams (65 currently, each with about 18 tables and 50 packages). Our production subsystem has about 13.000 VSAM files, while DSMAX is 4.000 - no problem (on test it's 37.000 vs. 4.000).<br><br>One disadvantage of this packageset scheme is that you greatly multiply packages, which requires us to fight to keep DSNDB01.SPT01at 2GB. [...]
26817 104 34_Re: Not quite relational SQL Query15_Lankester, Andy22_Andy_Lankester@BMC.COM30_Thu, 7 Sep 2000 07:16:47 -0500472_iso-8859-1 Without doing the SQL:<br><br>Same table join the R and C rows for the same object id with timestamp R > timestamp C where not exists any row between the two timestamps<br><br>This will give you only one result row per incidence which may not be what you want!<br><br>Andy<br><br>-----Original Message----- From: Davage, Marcus [mailto:Marcus.Davage@LLOYDSTSB.CO.UK] Sent: 07 September 2000 11:56 To: DB2-L@RYCI.COM Subject: Not quite relational SQL Query [...]
26922 200 34_Re: Not quite relational SQL Query0_18_mebert@AMADEUS.NET30_Thu, 7 Sep 2000 13:35:27 +0200654_us-ascii Hi Marcus,<br><br>this is what I came up with (note I have not tried it). The strategy: for an object with action 'R', look up the same object with action 'C' and then check whether there is another entry between these two.<br><br>SELECT OBJECT, DATE, TIME, ACTION FROM AUDIT A WHERE A.ACTION='R' AND EXISTS ( SELECT 1 FROM AUDIT B WHERE B.OBJECT=A.OBJECT AND B.ACTION='C' AND (B.DATE<A.DATE OR (B.DATE=A.DATE AND B.TIME<A.TIME)) AND NOT EXISTS ( SELECT 1 FROM AUDIT C WHERE C.OBJECT=A.OBJECT AND (C.DATE<A.DATE OR (C.DATE=A.DATE AND C.TIME<A.TIME)) AND (C.DATE>B.DATE OR (C.DATE=B.DATE AND C.TIME>B.TIME)) ) ) ORDER BY OBJECT, DATE, TIME; [...]
27123 16 19_Re: CAE Information14_Philip Gunning18_pgunning@PHEAA.ORG30_Thu, 7 Sep 2000 08:21:14 -0400535_us-ascii The best source of information for this is the Installation and Configuration Supplement. Gives you step by step procedures and several alternatives. There is also a white paper,Distributed Windows Install of DB2 Products. It is off the db2 home page. I forget the exact url. HTH Phil<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
27140 138 34_Re: Not quite relational SQL Query0_24_db46@DAIMLERCHRYSLER.COM30_Thu, 7 Sep 2000 08:29:12 -0400510_us-ascii SELECT MQ.OBJECT, MQ.D_DATE, MQ.T_TIME FROM T5070DB.TBAUDIT MQ, ( SELECT AU.OBJECT, MAX (CHAR (AU.D_DATE) || '-' || CHAR (AU.T_TIME)) AS DTM FROM T5070DB.TBAUDIT AS AU, ( SELECT OBJECT, CHAR (D_DATE) || '-' || CHAR (T_TIME) AS DTM FROM T5070DB.TBAUDIT WHERE ACTION = 'R' ) AS RV WHERE AU.OBJECT = RV.OBJECT AND CHAR (AU.D_DATE) || '-' || CHAR (AU.T_TIME) < RV.DTM GROUP BY AU.OBJECT ) AS OQ WHERE MQ.OBJECT = OQ.OBJECT AND CHAR (MQ.D_DATE) || '-' || CHAR (MQ.T_TIME) = OQ.DTM AND MQ.ACTION = 'C' [...]
27279 27 48_Re: Triggers - Where can I get more information?14_Philip Gunning18_pgunning@PHEAA.ORG30_Thu, 7 Sep 2000 08:33:07 -0400547_us-ascii Two things. The information I have read on triggers, and don't get me wrong, I think they are great, indicates that if you can do it with check constraints or DB2 RI, then use those methods first as a trigger is more overhead. Of course, keep in mind "It depends". Secondly, there are examples of before and after triggers in the Redbook, DB2 UDB Server for OS/390 Version 6 Technical Update, SG 24-6108-00. Also, Gabrielle Wiorkowski gave a good presentation on this at IDUG, plus Willie Favero has a presentation on this. HTH Phil [...]
27307 136 34_Re: Not quite relational SQL Query14_Larry D Bolick24_ldbolick@DUKE-ENERGY.COM30_Thu, 7 Sep 2000 09:15:24 -0400515_us-ascii You could use a CASE statement to assign a sequence number to each ACTION code and then order by this column as follows:<br><br>SELECT OBJECT, DATE, TIME, ACTION, CASE WHEN ACTION = 'C' THEN 1 WHEN ACTION = 'R' THEN 2 ELSE '0' END AS ACTION_SEQ FROM AUDIT WHERE OBJECT IN (SELECT OBJECT FROM AUDIT A WHERE A.ACTION='R' AND EXISTS (SELECT * FROM AUDIT B WHERE A.OBJECT = B.OBJECT AND B.ACTION = 'C' AND (B.DATE<A.DATE OR (B.DATE=A.DATE AND B.TIME<A.TIME)) ) ) ORDER BY OBJECT, DATE, ACTION_SEQ, TIME ; [...]
27444 39 34_Re: Not quite relational SQL Query14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK30_Thu, 7 Sep 2000 14:19:19 +0100602_iso-8859-1 Thanks to Andy Lankester and Michael Ebert for their help. It produces the result I expected, but also performs like expected! ;-)<br><br>Happy, but impatient, Marcus<br><br><br><br>----------------------------------------------------------------------------------------------------------------------- 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. [...]
27484 60 34_Re: Not quite relational SQL Query15_Lankester, Andy22_Andy_Lankester@BMC.COM30_Thu, 7 Sep 2000 08:29:44 -0500457_iso-8859-1 Yes, I was afraid that might be the case! NOT EXISTS is a pretty good pointer to potential performance problems. It might improve if you used a timestamp column instead of separate date and time and had an index on objectid/timestamp/action.<br><br>Andy<br><br>-----Original Message----- From: Davage, Marcus [mailto:Marcus.Davage@LLOYDSTSB.CO.UK] Sent: 07 September 2000 14:19 To: DB2-L@RYCI.COM Subject: Re: Not quite relational SQL Query [...]
27545 78 34_Re: Not quite relational SQL Query14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK30_Thu, 7 Sep 2000 14:37:19 +0100431_iso-8859-1 Out of interest, it's completely index only access, but as it's on a third party product, I can't do much about the separate date/time columns. What's even worse, DATE and TIME are defined on the database as INTEGER both! =:-O<br><br>Marcus -----Original Message----- From: Lankester, Andy [mailto:Andy_Lankester@BMC.COM] Sent: 07 September 2000 14:30 To: DB2-L@RYCI.COM Subject: Re: Not quite relational SQL Query [...]
27624 41 16_Re: Load Problem14_Mike Lebermann18_Lebermm@BCBSKC.COM30_Thu, 7 Sep 2000 08:47:30 -0500591_US-ASCII A few questions:<br><br>1. Are you running EEE/AIX on a single partition or do you have some tablespaces in a single node nodegroup (one partition) ?<br><br>2. Since it is only 40,000 rows, did you try an import?<br><br>Mike >>> data_analyst@HOTMAIL.COM 09/07/00 01:12AM >>> Hi everyone,<br><br>Today I loaded 40,000 rows into a table in EEE/AIX using Autoloader on a single partition. It took about a couple of minutes to complete. When I changed one of the column attributes from 'varchar(30)' to 'varchar(30) not null with default', the load took about 2 hours to complete. [...]
27666 33 49_Re: set package set - one way to use this concept15_David A. Zelmer25_david.zelmer@CITICORP.COM30_Thu, 7 Sep 2000 08:48:14 -0500368_us-ascii Thanks for the compliment! I would love to present at IDUG, however my management will not approve of this. They think they will be giving away company secrets. Plus the lawyers would have to get involved, ugh. But as I have discovered from this list, others have independently come up with the same concepts. Perhaps one of them could take on the task. [...]
27700 44 28_BMC Unload/Load Plus for DB214_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK30_Thu, 7 Sep 2000 14:54:13 +0100344_iso-8859-1 To copy data between identical tables on different subsytems, I currently: BMC UNLOAD+ from latest imagecopy into flat file BMC LOAD+ into table from flat file.<br><br>Is there a way I can BMC LOAD+ into table from imagecopy to save time and space? (hmmm... maybe if I save lots of time and space, I could start a continuum...) [...]
27745 33 22_DB2 Archive Terminated14_Dean Montevago18_DMonteva@VNSNY.ORG30_Thu, 7 Sep 2000 09:55:00 -0400293_- Hi, I have an archive setup to kickoff at a specific time, I don't specify WAIT so this is an ASYNCHRONOUS request. I received the message below, and the archive terminated. Should I increase the time interval so the archive will wait until it able to quiesce ? Please advise. TIA Dean [...]
27779 133 34_Re: Not quite relational SQL Query16_Derrick, Forrest20_fderrick@SCFBINS.COM30_Thu, 7 Sep 2000 09:02:00 -0500606_iso-8859-1 If I understand your request the following should work, you will probably need to adjust the paranthesis on the date (and, or) logic though.<br><br><br><br>Select a.object, a.date, a.time, a.action, b.date, -- For Query Verification b.time -- "<br><br>From Audit a, Audit b<br><br>Where a.action = 'c' -- Edit for requested 'Action' of 'C' and a.object = b.object -- Match Object Key and b.action = 'r' -- Edit for second requested 'Action' of 'R' and b.date > a.date -- Edit that second action follows first action or (b.date = a.date and b.time > a.time) AND NOT EXISTS -- EDIT for other [...]
27913 93 32_Re: BMC Unload/Load Plus for DB20_18_mebert@AMADEUS.NET30_Thu, 7 Sep 2000 16:00:56 +02001778_us-ascii Simply use DSN1COPY.<br><br>Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany<br><br><br><br><br><br><br><br>From: "Davage, Marcus" <Marcus.Davage@LLOYDSTSB.CO.UK> on 07/09/2000 13:54 GMT<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br><br><br><br><br><br><br><br><br>|---------> | | |---------> >---------------------------------------------------------------------------> | | >---------------------------------------------------------------------------> >-------------------------------------------| | | >-------------------------------------------| |---------> |To: | |---------> >---------------------------------------------------------------------------> |DB2-L@RYCI.COM | >---------------------------------------------------------------------------> >-------------------------------------------| | | | | >-------------------------------------------| |---------> |cc: | |---------> >---------------------------------------------------------------------------> | (bcc: Michael Ebert/MUC/AMADEUS) | >---------------------------------------------------------------------------> >-------------------------------------------| | | | | >-------------------------------------------| |---------> | | |---------> >---------------------------------------------------------------------------> | | >---------------------------------------------------------------------------> >-------------------------------------------| | | >-------------------------------------------| |---------> |Subject: | |---------> >---------------------------------------------------------------------------> |BMC Unload/Load Plus for DB2 | >---------------------------------------------------------------------------> [...]
28007 71 32_Re: BMC Unload/Load Plus for DB215_Lankester, Andy22_Andy_Lankester@BMC.COM30_Thu, 7 Sep 2000 09:07:18 -0500517_iso-8859-1 Marcus,<br><br>If you have BatchPipes you can pipe the unload file directly into LOADPLUS avoiding the double IOs. Alternatively you could use DSN1COPY or BMC RECOVER PLUS with R+/RESOURCE MAXIMIZER with OBID translation to read the IC directly.<br><br>Regards<br><br>Andy Lankester BMC Software Ltd. http://www.bmc.com<br><br>-----Original Message----- From: Davage, Marcus [mailto:Marcus.Davage@LLOYDSTSB.CO.UK] Sent: 07 September 2000 14:54 To: DB2-L@RYCI.COM Subject: BMC Unload/Load Plus for DB2 [...]
28079 81 32_Re: BMC Unload/Load Plus for DB20_22_BILL_GALLAGHER@PHL.COM30_Thu, 7 Sep 2000 10:05:55 -0400459_us-ascii Sorry Marcus,<br><br>No new continuum for you . . . BMC Load+ can only use a sequential file as input.<br><br>Bill Gallagher, DBA Phoenix Home Life Enfield, CT 06083<br><br><br><br><br><br><br><br>"Davage, Marcus" <Marcus.Davage@LLOYDS To: DB2-L@RYCI.COM TSB.CO.UK> cc: Sent by: DB2 Data Subject: BMC Unload/Load Plus for DB2 Base Discussion List <DB2-L@RYCI.COM><br><br><br><br>09/07/00 09:54 AM Please respond to DB2 Data Base Discussion List [...]
28161 34 36_Are Reorgs Necessary for Version 6 ?13_Moss, William15_MossW@AETNA.COM30_Thu, 7 Sep 2000 10:11:10 -0400617_- Our environment is currently DB2 Version 5, OS/390 2.8.<br><br>This past June we used DSN1COPY to move the data for thousands of tablespaces and indexspaces from a non-data sharing environment to a data sharing environment. In December this data sharing subsystem will be upgraded to Version 6.<br><br>The question is, do we need to reorg all of the tablespaces that were DSN1COPY'd before will migrate to Version 6 ? The discussions we have had center around the contents of the header pages of the tablespaces and indexspaces and how they will still contain old information from the non-data sharing Version [...]
28196 72 32_Re: BMC Unload/Load Plus for DB219_Rajeev P. Dhanawade22_rdhanawade@STATE.DE.US28_Thu, 7 Sep 2000 10:11:10 EDT501_us-ascii Hi,<br><br>We used to do that too. It is much faster to use DSN1COPY. But watch out for those PSIDs and OBIDs ... they sometimes change when you drop and re-create a tablespace or table. If you drop a DATABASE and re-create it, then the DBID too might change.<br><br>Also make sure other parameters are the same e.g. segsize. I once had a monster time trying to figure out what went wrong when a select from the table produced zero records! A good friend of mine helped me out as usual. [...]
28269 101 32_Re: BMC Unload/Load Plus for DB213_john arbogast19_arbo@CP-DEMO.CP.NET30_Thu, 7 Sep 2000 07:45:24 -0700772_- How does that save anything? Its still a 2 step process. What am I missing?<br><br>On Thu, 07 September 2000, mebert@AMADEUS.NET wrote:<br><br>> > Simply use DSN1COPY. > > Dr. Michael Ebert > DB2 Database Administrator > aMaDEUS Data Processing > Erding / Munich, Germany > > > > > From: "Davage, Marcus" <Marcus.Davage@LLOYDSTSB.CO.UK> on 07/09/2000 13:54 GMT > > Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM> > > > > > > |---------> > | | > |---------> > >---------------------------------------------------------------------------> > | | > >---------------------------------------------------------------------------> > >-------------------------------------------| > | | > >-------------------------------------------| > |---------> > |To: | [...]
28371 114 37_Fwd: Re: BMC Unload/Load Plus for DB213_john arbogast19_arbo@CP-DEMO.CP.NET30_Thu, 7 Sep 2000 07:51:47 -0700414_- Nevermind.... I missed the image copy part of the first message.<br><br><br><br>------- Start of forwarded message -------<br><br>Subject: Re: BMC Unload/Load Plus for DB2 To: DB2-L@RYCI.COM From: john arbogast <arbo@cp-demo.cp.net> Date: 07 Sep 2000 07:45:24 PDT<br><br>How does that save anything? Its still a 2 step process. What am I missing?<br><br>On Thu, 07 September 2000, mebert@AMADEUS.NET wrote: [...]
28486 82 49_Re: set package set - one way to use this concept0_19_Tim.Lowe@STPAUL.COM30_Thu, 7 Sep 2000 09:49:16 -0500433_us-ascii Dave, Why would your lawyers ever think you would give away company secrets at an IDUG presentation, but not have a problem discussing this on this list? Is this logical? (do dumb lawyer jokes apply?) Do they let you attend IDUG, or is this too dangerous as well? I am sorry for my ranting, but sometimes there are some pretty ridiculous rules that I wish more people would work to change. But, politics usually rules. [...]
28569 65 40_Re: Are Reorgs Necessary for Version 6 ?23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Thu, 7 Sep 2000 15:53:57 +0100627_iso-8859-1 simple answer is no .. becuase this is what we did and we have had zip all problems.<br><br>regards<br><br>Leslie<br><br>-----Original Message----- From: Moss, William [mailto:MossW@AETNA.COM] Sent: Thursday, September 07, 2000 3:11 PM To: DB2-L@RYCI.COM Subject: Are Reorgs Necessary for Version 6 ?<br><br><br><br>Our environment is currently DB2 Version 5, OS/390 2.8.<br><br>This past June we used DSN1COPY to move the data for thousands of tablespaces and indexspaces from a non-data sharing environment to a data sharing environment. In December this data sharing subsystem will be upgraded to Version 6. [...]
28635 77 34_Re: Not quite relational SQL Query12_Moreno, Jose19_Jose_Moreno@BMC.COM30_Thu, 7 Sep 2000 09:52:50 -0500385_iso-8859-1 What about a 0=SELECT COUNT(*) WHERE instead of NOT EXISTS, I have seen huge performance improvment in the past using this technique (I have not tested it for a while). Jose.<br><br>-----Original Message----- From: Lankester, Andy [mailto:Andy_Lankester@bmc.com] Sent: Thursday, September 07, 2000 3:30 PM To: DB2-L@RYCI.COM Subject: Re: Not quite relational SQL Query [...]
28713 54 19_Re: set package set0_22_Rohn.Solecki@MTS.MB.CA30_Thu, 7 Sep 2000 10:01:57 -0500439_us-ascii The disadvantage to Alias is that you won't be able to use the same alias names, therefore each table will require separate SQL<br><br><br><br><br><br><br><br><br><br>"R.V. Subrahmanian" <rv_subrahmanian@CHENNAI.TCS.CO.IN>@RYCI.COM> on 2000/09/07 03:46:57 AM Subject: Re: set package set<br><br>Hi Maha,<br><br>I think the same can be achieved by defining alias of the table(s) and having a single packageset in the program. [...]
28768 39 32_Re: BMC Unload/Load Plus for DB215_Lankester, Andy22_Andy_Lankester@BMC.COM30_Thu, 7 Sep 2000 10:12:48 -0500633_iso-8859-1 A further thought. Not only does DSN1COPY have the problems mentioned by Rajeev but you also have to recover all the indexes afterwards.<br><br>Andy Lankester<br><br>-----Original Message----- From: Rajeev P. Dhanawade [mailto:rdhanawade@state.de.us] Sent: 07 September 2000 15:11 To: DB2-L@RYCI.COM Subject: Re: BMC Unload/Load Plus for DB2<br><br><br><br>Hi,<br><br>We used to do that too. It is much faster to use DSN1COPY. But watch out for those PSIDs and OBIDs ... they sometimes change when you drop and re-create a tablespace or table. If you drop a DATABASE and re-create it, then the DBID too might change. [...]
28808 67 18_denormalize or not13_Brian Merrick26_BHMerrick@HOUSEOFLLOYD.COM30_Thu, 7 Sep 2000 10:15:05 -0500298_iso-8859-1 We are os/390 01.03 & db2 v5. I have an application programmer requesting a denormalized table containing 30 item quantity columns to be displayed on a html page. The data needs to be retained between sessions so a temp table won't work. We are not in CICS. What other options do I have?
28876 39 41_DB2 Audit and a DB2 v6 compatible release0_27_jim.leask@RS-COMPONENTS.COM30_Thu, 7 Sep 2000 16:22:49 +0100382_ISO-8859-1 At present we are planning to upgrade DB2 from v4 to v6 (migrate to v5 as an intermediate step) prior to the end of the year.<br><br>However on checking with Grafton/Cotec who supply third party product DB2 Audit, they are telling us that they do not have a DB2 v6 compatible release and do not think they will have one ready until 1st quarter 2001 at the earliest. [...]
28916 30 33_A few questions on DB2 UDB on AIX7_J. Wang32_Jizhong_Wang@EMAIL.WHIRLPOOL.COM30_Thu, 7 Sep 2000 11:40:24 -0400598_US-ASCII Hi all,<br><br>after being Oracle DBA for many years, I am recently involved with DB2 UDB on AIX platform and having many basic questions (even after taking an IBM fast track class on DB2). Would someone be kind enough to help me out? Thanks.<br><br>1. To keep table/index statistics current, I can use "runstats" to calculate statistics on ONE table or/and index. How can I "runstats" on multiple tables/indexes, say by owner/schema? Could some share scripts? 2. We need to store credit card information in a DB2 UDB database, and need to encryption on it (not just a home-made one, [...]
28947 20 16_Re: Load Problem7_Db2 Dba24_data_analyst@HOTMAIL.COM30_Thu, 7 Sep 2000 10:40:07 -0500370_- Mike,<br><br>I am running the load in a single partition in our test environment. In fact, the setup is EE not EEE, i.e., we don't have nodegroups defined at all.<br><br>I have not used IMPORT simply because our actual data file will include tens of millions of rows and will be loaded by exploiting the parallelism available to us in the production environment. [...]
28968 57 34_Re: Not quite relational SQL Query12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Thu, 7 Sep 2000 19:23:58 +0200674_x-user-defined Hi, Do you have an index on OBJECT, DATE, TIME, ACTION ? Isaac Yassin<br><br>"Davage, Marcus" wrote: > > Thanks to Andy Lankester and Michael Ebert for their help. > It produces the result I expected, but also performs like expected! ;-) > > Happy, but impatient, > Marcus > > ----------------------------------------------------------------------------------------------------------------------- > 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 [...]
29026 22 40_implementing physical db using case tool0_18_Usregion10@AOL.COM28_Thu, 7 Sep 2000 12:31:43 EDT552_ISO-8859-1 Hi all!<br><br>Today we had an interesting discussion on the role of a data modelling case tool (such as ERWIN) in the creation of the physical database. In my view, these tools do almost 90% of the work. But you have to make some modifications to the DDL before you can implement on db2 or udb. However, some of the people in our group have the vision that a case tool could configured to produce exactly what you want to actually implement. What are the experiences of the people who have attempted to do so ? Looking forward to hear [...]
29049 112 49_Re: set package set - one way to use this concept0_18_mebert@AMADEUS.NET30_Thu, 7 Sep 2000 18:08:33 +0200384_us-ascii Just so I don't put on false laurels, it was my colleague Mr. Vitor Pacheco who had brought this idea from his previous company - I barely knew DB2 at that time.<br><br>Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany<br><br><br><br><br><br><br><br>From: "David A. Zelmer" <david.zelmer@CITICORP.COM> on 07/09/2000 13:48 GMT [...]
29162 78 49_Re: set package set - one way to use this concept15_David A. Zelmer25_david.zelmer@CITICORP.COM30_Thu, 7 Sep 2000 11:40:40 -0500280_us-ascii I have no idea what the lawyers would say, as this hasn't been done. Mgmt has just indicated in the past that the lawyers would need to be involved. The unsaid implied point being is that a presentation will not be done. As far as this list goes, DO NOT TURN ME IN! [...]
29241 45 44_Re: implementing physical db using case tool13_Lynne Flatley17_LFlatley@NEFN.COM30_Thu, 7 Sep 2000 12:43:41 -0400528_us-ascii Hot spot! These tools do 90% of the work, if you're lucky. Don't get me wrong, Data Modelers have a challenging job in designing a logical model but I've worked with several DAs (who have generated models from several different tools) and I have found it to be very difficult to get a good physical model out of a tool. It's not so bad when you have a new database, but when you have an existing database and the model has many, many changes, it's not a pretty sight. I have found this to be true for 2 flavors of [...]
29287 27 34_Re: Not quite relational SQL Query13_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM30_Thu, 7 Sep 2000 11:31:22 -0500377_- >NOT EXISTS is a pretty good pointer to potential performance problems. >Andy<br><br>UDB has gotten a lot better at this, but by mechanically rewriting<br><br>and Not exists (Select * from this where that.key = this.key)<br><br>to<br><br>and not that.key in (Select this.key from this)<br><br>I actually get the stupid thing to occasionally look at a primary key index. [...]
29315 47 50_Reorg them all and let the database sort them out.13_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM30_Thu, 7 Sep 2000 11:47:35 -0500815_- >How can I "runstats" on multiple tables/indexes, say by owner/schema? >Could some share scripts?<br><br>Will Java do? ;)<br><br>This reorgs ALL tables by their primary keys.<br><br>If you don't want a certain table orgged by its primary key then change keys!<br><br>Note, this code prints a script.<br><br>java.sql.PreparedStatement query = connection.prepareStatement ("SELECT TBCREATOR, TBNAME, CREATOR, NAME FROM sysibm.SYSINDEXES" +" WHERE UNIQUERULE='P'"); java.sql.ResultSet resultSet = query.executeQuery(); while(resultSet.next()){ String tab[] = new String[2]; tab[0] = resultSet.getString(1).trim() +"." +resultSet.getString(2).trim(); tab[1] = resultSet.getString(3).trim() +"." +resultSet.getString(4).trim(); tables.addElement(tab); } // while rows to convert resultSet.close(); query.close(); [...]
29363 124 32_Re: BMC Unload/Load Plus for DB20_18_mebert@AMADEUS.NET30_Thu, 7 Sep 2000 18:18:34 +0200592_us-ascii Sure - but LOAD processing needs to do that too, it just does it behind the covers, so to speak. One would need to try both methods to see how much one might gain. The Unload/Load process is certainly more robust & universal. Also there is a considerable number of PTFs around concerning DSN1COPY for partitioned & compressed TSs. I've done a DSN1COPY/REBUILD recently for copying production data to test env; there were some other oddities. For example, a couple of partitions needed a lot more space than the original one; after a REORG, the sizes were identical between test [...]
29488 127 37_Re: A few questions on DB2 UDB on AIX0_22_BILL_GALLAGHER@PHL.COM30_Thu, 7 Sep 2000 13:23:12 -0400708_us-ascii Jizhong,<br><br>Here's an AIX script that will perform RUNSTATS for all user tables for all databases for all instances on a particular AIX box. Works fine for us:<br><br>#!/bin/ksh . $HOME/.profile >/dev/null 2>&1 if [ $# -eq 1 ];then HOLD1=$1 fi echo "Runstats Script Started at `date`"<br><br>DB2ILIST="`db2ilist`"<br><br>for DB2INST in $DB2ILIST do DB2INSTANCE=$DB2INST db2 "attach to $DB2INST" db2 "list database directory" | egrep "Database name|Local database directory" | while read listout do print ${listout%=*} | read data_label print ${listout##*=} | read data_value if [ "$data_label" = "Database name" ]; then DBNAME=$data_value fi if [ "$data_label" = "Local database directory" [...]
29616 57 37_Re: A few questions on DB2 UDB on AIX10_Leo Pedron19_lpedron@BOSCOVS.COM30_Thu, 7 Sep 2000 13:28:30 -0400313_iso-8859-1 You could also use the REORGCHK command with the update option. This will perform the runstats against selected tables, system tables, all tables, or just user tables. The added benefit of doing it this way is you also can tell if tables need to be reorged. See the command reference for details. [...]
29674 21 46_DB2 Connect 7.1 & Secureway Network Dispatcher15_Camitta, Steven30_steven.camitta@INGRAMMICRO.COM30_Thu, 7 Sep 2000 10:32:53 -0700594_iso-8859-1 In the DB2 Connect 7.1 product announcement<br><br>http://www.ibmlink.ibm.com/usalets&parms=H_200-091<br><br>there's a reference to SecureWay Network Dispatcher as a front-end load balancer & high availability solution. Is anyone using it? I can't find any references to the product. Or perhaps it's a feature of a product?<br><br>TIA, Steve<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
29696 63 45_Re: DB2 Audit and a DB2 v6 compatible release22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM30_Thu, 7 Sep 2000 13:37:04 -0400329_iso-8859-1 Since DB2 for OS/390 V6.1 has been GA since June 1999, and they won't be ready until 1Q2001 at the earliest, it seems like the vendor is not that interested in staying current with DB2 for OS/390. Maybe you should consider switching to a product that is committed to being current with DB2 for OS/390 and Oracle. [...]
29760 48 44_Re: implementing physical db using case tool12_Kline, Wayne27_wayne.kline@INGRAMMICRO.COM30_Thu, 7 Sep 2000 10:53:25 -0700469_iso-8859-1 Some of the modeling tools are very complete in their ability to handle physical parameters in the DDL (Bachman was the best, way back when). But the big issue is naming in my view. If you can provide rigorous policies and procedures to DA's (or whoever is maintaining the models) for handling physical naming conventions, the DDL should be pretty much runnable as is. But the DBA's should ALWAYS be authorized to change any physical aspect of the DDL. [...]
29809 30 8_Rollback13_Scott Lindsey29_sflindsey@HIGHLIGHTS-CORP.COM30_Thu, 7 Sep 2000 14:15:34 -0400535_us-ascii Hi, Listers! I had a job that was doing an insert statement with a subselect i.e. INSERT INTO table1 (column list) SELECT (column list) FROM table2 WHERE criteria The job was cancelled after running two hours and took twenty hours to back out. There could possibly be 300,000 rows inserted. This query was run in PRF (the old Platinum Report Facility, a QMF type product) and parallelism was running on the subselect. Does 20 hours seem extremely long?? Does parallelism play a part in the 20 hours it took to back out?? [...]
29840 15 10_DB2 Traces17_Charles Jambrosic29_Charles_Jambrosic@CSIHOME.COM30_Thu, 7 Sep 2000 11:33:35 -0700373_us-ascii Does anyone have any info on the overhead of running the DB2 V5.1 performance trace class(4) IFCIDs 23 and 30?<br><br>TIA.<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
29856 44 26_Re: DB2 Archive Terminated12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV30_Thu, 7 Sep 2000 13:31:00 -0400440_- We attempted to archive the log with the quiesce option for a while and kept increasing the time to wait. Eventually, it got to the point where the max was not long enough and we were not getting archive logs when we needed them. Now, we don't specify quiesce. We get a log, without quiesce, at a consistent time every night and it has always worked at the disaster recovery site. Quiesce would be optimal but we needed the archive. [...]
29901 68 29_Re: DCLGEN bind package fails11_John Wallin24_john.wallin@ZURICHUS.COM30_Thu, 7 Sep 2000 13:34:31 -0500341_us-ascii Thanks David and others for the replies. IBM says that DCLGEN is not supported on any UDB platform other than OS/390 So even if we could get the bind to work there would be no program to run on the AIX world. We have gotten SPUFI and QMF to run however. They at least allow us access to the box and are a test of connectivity. [...]
29970 174 32_Re: BMC Unload/Load Plus for DB211_Kwan, James18_James_Kwan@BMC.COM30_Thu, 7 Sep 2000 13:47:20 -0500474_iso-8859-1 Hi Dr. Ebert,<br><br>You are correct, indexes have to be build one way or the other. Have you or anyone done any benchmark using unload/load (Unload+/Load+ if you have these tools) vs dsn1copy/rebuild? I wonder if there is a significant difference in term of elapse time and CPU time. Also you can use load utility to produce an image copy and produce runstat info while loading the data. If you use DSN1COPY/REBUILD, I believe you have to do it separately. [...]
30145 73 71_00c90101 - Partitioned tablespace - Delete where current of cursor-name15_Anthony R Gould17_agould@UAKRON.EDU30_Thu, 7 Sep 2000 14:58:57 -0400344_us-ascii OS390 v2.8 - DB2 v5.1<br><br>We have an Easytrieve Plus program that deletes records on a table using<br><br>the CURRENT OF cursor-name. This program has been in production for a few years and runs four times per year. The program abended this week with a 00C90101. The additional information from the Write To Operator (WTO) is: [...]
30219 57 12_Re: Rollback12_craig patton21_prgpatton@HOTMAIL.COM28_Thu, 7 Sep 2000 18:59:19 GMT665_- Scott,<br><br>Are you using Data Sharing as well as parallelism??<br><br>20 Hours DOES seem excessive.<br><br>Craig<br><br><br><br>>From: Scott Lindsey <sflindsey@HIGHLIGHTS-CORP.COM> >Reply-To: DB2 Data Base Discussion List <DB2-L@RYCI.COM> >To: DB2-L@RYCI.COM >Subject: Rollback >Date: Thu, 7 Sep 2000 14:15:34 -0400 > >Hi, Listers! >I had a job that was doing an insert statement with a subselect >i.e. INSERT INTO table1 > (column list) > SELECT (column list) > FROM table2 > WHERE criteria >The job was cancelled after running two hours and took twenty hours to back >out. >There could possibly be 300,000 rows inserted. This query was run in PRF >(the [...]
30277 106 22_Re: denormalize or not14_John P Shipley24_jpshiple@DUKE-ENERGY.COM30_Thu, 7 Sep 2000 15:02:49 -0400575_us-ascii <br><br><br><br>My opinion is that denormalization is a technique used to enhance the performance of one application at the expense of either another application and/or the flexibility of the database in handling new types of data. You should ask the "owners" of the data if these are the only quantities they will ever want or if they might add more in the future. If you have a real performance issue that is driving you to want to do less SQL or less physical i/o then you should consider denormalizing. I personally find it best in the long run to keep the [...]
30384 33 14_Re: DB2 Traces20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Thu, 7 Sep 2000 15:11:34 -0400634_us-ascii If you are looking for only few IFCIDs such as 23,25 and 30 then there is very low overhead. Don't forget to start trace with CLASS(30) not CLASS(4).<br><br>Remember IFCID 23 is paired with 25 and both needs to be trigger not just 23 as you mentioned.<br><br>> -----Original Message----- > From: Charles Jambrosic [SMTP:Charles_Jambrosic@CSIHOME.COM] > Sent: Thursday, September 07, 2000 2:34 PM > To: DB2-L@RYCI.COM > Subject: DB2 Traces > > Does anyone have any info on the overhead of running the > DB2 V5.1 performance trace class(4) IFCIDs 23 and 30? > > TIA. > > ================================================ > [...]
30418 68 26_Re: DB2 Archive Terminated14_Dean Montevago18_DMonteva@VNSNY.ORG30_Thu, 7 Sep 2000 15:19:19 -0400573_- Aren't you concerned about tasks that are in-flight, or on the the runway , or waiting to be committed ??<br><br>> -----Original Message----- > From: BOB JEANDRON [SMTP:BOB.JEANDRON@USDA.GOV] > Sent: Thursday, September 07, 2000 1:31 PM > To: DB2-L@RYCI.COM > Subject: Re: DB2 Archive Terminated > Sensitivity: Personal > > We attempted to archive the log with the quiesce option for a while and > kept > increasing the time to wait. Eventually, it got to the point where the > max > was not long enough and we were not getting archive logs when we needed > them. > [...]
30487 100 23_Re: DB2 functions/FMIDs12_Hylton Tom P20_Tom.P.Hylton@IRS.GOV30_Thu, 7 Sep 2000 15:45:20 -0400370_iso-8859-1 If you have access to IBMLINK, you can use the PCR function (Product Cross Reference List) under the Service option. This will give you a list of all components under a product, including FMIDs. The description isn't detailed, but does have the common name of the functions.<br><br>You need to know the program number for the product you're looking for. [...]
30588 78 26_Re: DB2 Archive Terminated12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV30_Thu, 7 Sep 2000 14:46:00 -0400563_- Yes, that was why we wanted to use quiesce. But, the bottom line is that we have a window to produce an archive log for DR and using QUIESCE was interfering with having the latest possible log at the DR site. The tablespaces of in-flight URs are identified and recovered to the latest available quiesce point after the latest available image copy. We do tablespace quiesce points after each image copy. >>> DB2-L@RYCI.COM@inter2 09/07/00 02:18PM >>> Aren't you concerned about tasks that are in-flight, or on the the runway , or waiting to be committed ?? [...]
30667 78 14_Re: DB2 Traces17_Charles Jambrosic29_Charles_Jambrosic@CSIHOME.COM30_Thu, 7 Sep 2000 13:07:03 -0700612_us-ascii Sorry let me reword my question.<br><br>Does anyone have any info as to the associated overhead of turning on the DB2 performance class(4) trace plus ifcids 23 and 30.<br><br>The cpu is a 165 mip machine.<br><br>TIA.<br><br><br><br><br><br><br><br>|--------+-----------------------> | | "Pillay, | | | Venkat (PCA)"| | | <venkat_pilla| | | y@ML.COM> | | | | | | 09/07/00 | | | 12:11 PM | | | Please | | | respond to | | | DB2 Data Base| | | Discussion | | | List | | | | |--------+-----------------------> >--------------------------------------------------------| | | | To: DB2-L@RYCI.COM | | cc: [...]
30746 23 12_Online Reorg10_Fred Edgar22_fred_edgar@HOTMAIL.COM28_Thu, 7 Sep 2000 20:04:13 GMT322_- I am curious about this online reorg thing. I've run several IBM SHRLEVEL CHANGE reorgs, with DRAIN WRITERS and DRAIN ALL, and both cause problems with our busy tables. CDB advertises a true online reorg with zero downtime. Has anyone used this? Or does anyone know of any other true online reorg products? Thanks. [...]
30770 29 28_DB2 Connect - Need Info ASAP14_Dean Montevago18_DMonteva@VNSNY.ORG30_Thu, 7 Sep 2000 16:14:45 -0400384_- Hi,<br><br>There is a step in setting up DB2 Connect/EE that defines the remote databases as local databases. What type of serialization is done, while this is executing ? Also, are just the tablespace names being identified or are the table attributes also identified on the server. What happens when a new table is added or modified, does this process have to be done again. [...]
30800 71 12_Re: Rollback13_Scott Lindsey29_sflindsey@HIGHLIGHTS-CORP.COM30_Thu, 7 Sep 2000 16:09:47 -0400560_us-ascii No. I am not using Data Sharing.<br><br>craig patton wrote: > > Scott, > > Are you using Data Sharing as well as parallelism?? > > 20 Hours DOES seem excessive. > > Craig > > >From: Scott Lindsey <sflindsey@HIGHLIGHTS-CORP.COM> > >Reply-To: DB2 Data Base Discussion List <DB2-L@RYCI.COM> > >To: DB2-L@RYCI.COM > >Subject: Rollback > >Date: Thu, 7 Sep 2000 14:15:34 -0400 > > > >Hi, Listers! > >I had a job that was doing an insert statement with a subselect > >i.e. INSERT INTO table1 > > (column list) > > SELECT (column list) > > FROM table2 > [...]
30872 151 22_Re: denormalize or not0_22_Rohn.Solecki@MTS.MB.CA30_Thu, 7 Sep 2000 15:18:19 -0500581_us-ascii <br><br>If denormalized is the only workable solution, another alternative is to use a pseudo temp table.<br><br>Define a denormalized version of the table, as a regular table, not a temp table. At the start of the transaction load it with the required data from the normalized table, adding a key that will identify the user/or transaction. Do your HTML against the denormalized table. At the end of the transaction, delete the rows associated with the transaction. So the normal state of the table is empty, it only contains rows while a transaction is in process. [...]
31024 55 16_Re: Online Reorg11_Trace Jones31_Trace_R_Jones@RELIANTENERGY.COM30_Thu, 7 Sep 2000 15:28:35 -0500437_us-ascii Hi,<br><br>We use the CD Reorg product and have been very happy. You can use the rw reorg from CDB with no downtime. Howerver, if you are using the option to resize vsams during reorg then it must take a quick stop of the database to the rename. So, if anyone has any locks in the database, the CDB job will come down. But, what I like is that it remebers where it left off and all you have to do is resubmit the same job. [...]
31080 45 32_FW: DB2 Connect - Need Info ASAP12_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM30_Thu, 7 Sep 2000 16:48:51 -0400680_iso-8859-1 The Cataloging (DCS, Database & Node Directory) is only required for databases & needs to be done once.<br><br><br><br>-----Original Message----- From: Dean Montevago [mailto:DMonteva@VNSNY.ORG] Sent: Thursday, September 07, 2000 4:15 PM To: DB2-L@RYCI.COM Subject: DB2 Connect - Need Info ASAP<br><br><br><br>Hi,<br><br>There is a step in setting up DB2 Connect/EE that defines the remote databases as local databases. What type of serialization is done, while this is executing ? Also, are just the tablespace names being identified or are the table attributes also identified on the server. What happens when a new table is added or modified, does this process [...]
31126 88 12_Re: Rollback12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV30_Thu, 7 Sep 2000 16:44:00 -0400541_- That seems like a long time. The most we have done here is when someone did 10 of those jobs, copying millions of rows with no commits then canceled all of them after 4 hours. There were only 7 task, if I am remembering correctly, allocated to rollback so it took about 20 hours for the 1st 7 jobs and another 20 hours for the last 3. These started going faster when I allocated more tapes via the SET ARCHIVE command. Are you Compacting the archive logs? P2-197 v5 install guide. Did you use the display archive command to determine [...]
31215 82 44_Re: implementing physical db using case tool25_Robinson, Peter [IBM GSA]33_Peter.J.Robinson@TEAM.TELSTRA.COM30_Fri, 8 Sep 2000 09:00:14 +1100574_- Hi Anil<br><br>I've had similar experiences to what Lynne and Wayne have already mentioned. Setting up an initial model is not too tough - but time consuming. If you have significant changes to the logical model, re-building the physical version can be very hard.<br><br>You can, however, get around some of the problems with things like grants if you use a tool like BMC's change manager to apply the changes rather than running the DDL. This way you can choose to leave the grants the way they are and just apply the other DDL. Just make sure you thoroughly review [...]
31298 83 20_Re: DB2Connect & MTS0_15_leon@CA.IBM.COM30_Thu, 7 Sep 2000 18:19:41 -0400459_us-ascii David, is there any way you can stop using SNA? SNA configuration is very complex for even simple connectivity. When it comes to supporting MTS and 2-phase commit it is an incredible pain. To diagnose the cause of the problem we would have to start asking you about version of Comm Manager you are using, look at your config parameters etc. I would not be able to help you via this list and would ask you to call our service and support people. [...]
31382 62 16_Re: Online Reorg11_GOSE PAUL M17_pmgose@SRPNET.COM30_Thu, 7 Sep 2000 15:37:45 -0700570_ISO-8859-1 Fred, We use CDB RW/Reorg and have been happy with it for the most part, although we do have a criticism or two. Most of our recent experience with CDB has been under DB2 Version 5.1 and CDB version 5.2, we have DB2 Version 6 in our test subsystems only right now. As for downtime, the phases causing downtime are similar to that of IBM SHRLEVEL CHANGE reorgs. According to the documentation, CDB puts the objects in read-only mode and issues a QUIESCE to flush the buffers immediately before it performs the final change apply (similar to the final log [...]
31445 26 41_Searchable DB2EUG list archives available11_D. Williams17_dale@METRONET.COM30_Thu, 7 Sep 2000 17:50:31 -0500475_iso-8859-1 Greetings,<br><br>Some of this list are also among the 300+ subscribers to the DB2 UDB mailing list (db2eug@lists.best.com). That list is comprised primarily of users, engineers, developers, and DBAs discussing IBM's DB2 Universal Database and its predecessors in all its forms, DB2/6000, DB2/NT, DB2/2, and DB2/CS.<br><br>Searchable list archives for that list are now available at http://www.herethey.com covering list inception in November '98 to current. [...]
31472 66 38_Re: JAVA, DB2 and varchar/fixed length0_15_leon@CA.IBM.COM30_Thu, 7 Sep 2000 18:59:47 -0400756_us-ascii Where is your Java application running i.e. OS/390 or some midle-tier system (NT, SUN, AIX etc.)?<br><br>Leon Katsnelson, DB2 Connect Development Manager mailto:leon@ca.ibm.com<br><br><br><br>"Mackey, Glenn" <GMackey@GUIDEMAIL.COM> on 08/31/2000 04:49:29 PM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br>To: DB2-L@RYCI.COM cc: Subject: JAVA, DB2 and varchar/fixed length<br><br><br><br><br><br><br><br>Hi,<br><br>We have an issue with JAVA programs accessing DB2 which returns CHAR data padded to the length as defined in the catalog. Also, when shipping data to DB2 (insert, where predicates, Stored procedure parameters etc) from JAVA the data is not padded with blanks and the results are not as expected. [...]
31539 58 39_Re: db2 connectivity to other platforms0_15_leon@CA.IBM.COM30_Thu, 7 Sep 2000 19:13:21 -0400542_us-ascii ODBC/CLI does not eanble any connectivity. ODBC and CLI are application programming interfaces just like Embedded SQL is. ODBC/CLI support that you get as part of the DB2 for OS/390 product (note that this is completely different from ODBC/CLI support you get with DB2 Connect) simplifies the jod of porting a Windows or UNIX application code to run on S/390. While it does seem like a worthwhile thing to do in principle, in practice very few people do this. Most people prefer to develop S/390 applications using Embeded SQL. [...]
31598 74 23_OO Data modelling Tools12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM30_Fri, 8 Sep 2000 10:17:45 +1100568_- I would like to take Anil's question and push it a little wider. I've had a quick peak in the Archives but this looks like it might be new territory.<br><br>I've been looking recently at some modelling tools, as we are moving away from Cool:GEN at last =:-o. I looked at a number of traditional ERD tools which I generally liked, but as per the comment below all had their little idiosyncrasies that would at least mean some DDL massaging when hitting the mainframe. (Anil, my general view on modelling tools is that it's great for Table structure, and Primary [...]
31673 58 32_Re: DB2 Connect - Need Info ASAP0_15_leon@CA.IBM.COM30_Thu, 7 Sep 2000 19:24:36 -0400530_us-ascii Dean, when you read DB2 Connect information the term "database" is NOT what you are thinking of as a DATABASE in DB2 for OS/390. "Database" means DB2 for OS/390 subsystem. In other words, you never deal with tablespaces etc. when you are configuring DB2 Connect. If your DB2 Connect is running on Windows NT/2000 I strongly urge yo to use DB2 CCA (Client Configuration Assitant). It will help you get throught he tasks without going off on a wrong tangent. I also urge you to read DB2 Connect Quick Beginnings book. [...]
31732 576 49_Re: set package set - one way to use this concept25_Robinson, Peter [IBM GSA]33_Peter.J.Robinson@TEAM.TELSTRA.COM30_Fri, 8 Sep 2000 10:53:08 +1100382_iso-8859-1 For each region (about 65 of them), we had about 500 packages, 50 Aliases, 100 Tables and 150 Views, 25 tablespaces and 50 indexes all of which were fairly active so the subsystem was chockers. This was in the days before slow close and all that lovely stuff.<br><br>I like the *.* in the package list. I'll remember that in case I ever have to do this stuff again. [...]
32309 92 34_Re: Not quite relational SQL Query14_Purcell, Terry30_Terry.Purcell@TEAM.TELSTRA.COM30_Fri, 8 Sep 2000 12:42:49 +1100550_- Marcus,<br><br>To increase the performance of the previous examples you may wish to complement the predicate:<br><br>AND (B.DATE<A.DATE OR (B.DATE=A.DATE AND B.TIME<A.TIME))<br><br>by also including:<br><br>AND B.DATE<=A.DATE<br><br>The original is a non-Boolean Term and is therefore not indexable whereas the addition of the '<=' is indexable (Note: I'm assuming that this can then be an index matching rather than index screening predicate, as you haven't mentioned your index column sequence). Do not remove the original predicate though. [...]
32402 18 23_Date Data Type in Index0_20_bjnigh@HOUSEHOLD.COM30_Thu, 7 Sep 2000 16:47:29 -0700283_us-ascii We have heard that the use of the date datatype in an index causes performance issues in DB2. Is this a true statement? We are currently looking at using a date datatype in an index for a data warehouse and would like to know if this would cause a performance problem. [...]
32421 75 27_Re: Date Data Type in Index0_31_greg.palgrave@UNISYSWEST.COM.AU30_Fri, 8 Sep 2000 11:27:06 +0800410_us-ascii Not true for 'big DB2' (i.e. MVS) as far as I know - but I did see an APAR on IBMLINK which is still waiting on a PTF:<br><br>APAR Identifier ...... PQ39589 Last Changed..00/08/24 OPTIMIZER INCONSISTENT CHOOSING ACCESS PATH WHEN LITERAL VALUES USED FOR DATE/TIMESTAMP VARIABLES.<br><br>Regards,<br><br>Greg Palgrave Technical Services Unisys West Services eMail : greg.palgrave@unisyswest.com.au [...]
32497 133 22_Re: denormalize or not23_Puddy, Andrew (CALBRIS)36_Andrew.PUDDY@COMALCO.RIOTINTO.COM.AU30_Fri, 8 Sep 2000 04:02:20 -0000463_iso-8859-1 what about a generalised table with a key and text field and they can store what they like it and the application is responsible for the data format of the text field .<br><br>Andrew Puddy IBMGSA (onsite at Comalco) Phone 07 3867 1747 Mobile 0419 824 076<br><br><br><br><br><br>-----Original Message----- From: John P Shipley [mailto:jpshiple@DUKE-ENERGY.COM] Sent: Friday, 8 September 2000 5:03 To: DB2-L@RYCI.COM Subject: Re: denormalize or not [...]
32631 59 22_Re: denormalize or not12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM30_Fri, 8 Sep 2000 15:39:00 +1100410_- What about creating a summary table. If the data doesn't need to be current you could reload it nightly via a batch utility job. This could be used as a temp fix until you go V6.<br><br>One of the benefits is that you keep the "base" structure normalised and pure. You could even give the table a slightly different naming standard to indicate which are Normalised Data Model, and which are summarised. [...]