1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l March 2000, week 5
2 221 44_Re: migrate DB2 NT to DB2 AIX (same version)18_Gert van der Kooij15_geko@WANADOO.NL31_Wed, 29 Mar 2000 08:23:11 +0200419_iso-8859-1 Hi,
Try db2move, it will create the export/import for you. ----- Original Message ----- From: Romeo B Titong Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Sent: Wednesday, March 29, 2000 7:49 AM Subject: Re: migrate DB2 NT to DB2 AIX (same version)
Thanks for the reply!
I am actually doing the export-import procedure. I was hoping there would be a quicker solution :) [...]
224 221 44_Re: migrate DB2 NT to DB2 AIX (same version)14_Romeo B Titong26_rbtitong@ACISYSTEMS.COM.PH31_Wed, 29 Mar 2000 15:01:29 +0800869_us-ascii i read the description about "db2move" and i think it is what i need. i'll try the command.
thanks!
Romeo
Gert van der Kooij on 03/29/2000 02:23:11 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM
cc: (bcc: Romeo B Titong/Operations/ACISystems)
Subject: Re: migrate DB2 NT to DB2 AIX (same version)
Hi,
Try db2move, it will create the export/import for you. ----- Original Message ----- From: Romeo B Titong Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Sent: Wednesday, March 29, 2000 7:49 AM Subject: Re: migrate DB2 NT to DB2 AIX (same version) [...]
446 135 21_Re: db2UDB on Solaris11_ALLEN,Bruce37_bruce.allen@EMPLOYMENTNATIONAL.COM.AU31_Wed, 29 Mar 2000 17:32:34 +1000306_- Hi Jimmy, (an update) Select Control Panel, Services, Startup for DB2 JDBC Applet Server - Control Center and change from Logon as System Account to This Account (and specify your userid and password). The reason it says SYSTEM is not authorized is that this the user name used for system accounts. [...]
582 138 36_Re: HAVE TO CONVERT INDEX ? Xephon??12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK31_Wed, 29 Mar 2000 09:07:00 +0100431_iso-8859-1 I would say that if you find one useful routine each year that would be sufficient to save the subscription price compared to developing it yourself, and if you are not expert at Assembler or REXX you will probably find things that you couldn't develop yourself anyway. If you go to their web site and select Journals... DB2 Update you can browse their archives up to 1997 free of charge and make your own mind up. [...]
721 22 25_Re: Has anyone found REXX16_Eric Ng Yew Heng22_ngyh@PUBLICBANK.COM.MY31_Wed, 29 Mar 2000 17:06:50 +0800277_us-ascii Hi, it would be very useful to have REXX on NT. I would be able to automate a lot of things, such as running a stream of batch jobs. SchiradinR, where to get the software REXX on NT? Is there a shareware? Peter, could you tell me something about your experience? [...]
744 46 19_Catalog Reorg stats11_Peter Marsh23_Peter.Marsh@ITNET.CO.UK31_Wed, 29 Mar 2000 11:56:45 +0100428_us-ascii Help,
We have just converted to DB2 version 4 for OS/390. Since doing this we have just put in place catalog Reorgs. Taking Runstats before and after Reorgs we have found that the Leafdist figure for the respective indexes has increased (freepage=0,nlevels=2, leafdist>200).
Can anybody explain why? I had expected the reverse to be true! The DB2 IBM manual would seem to support my way of thinking. [...]
791 48 25_AW: Has anyone found REXX16_Roland Schiradin28_SchiradinR@ALTE-LEIPZIGER.DE31_Wed, 29 Mar 2000 14:06:06 +0200631_iso-8859-1 It was included in V5 for
http://www-4.ibm.com/software/ad/obj-rexx/ibmrexxp.html
> -----Ursprüngliche Nachricht----- > Von: Eric Ng Yew Heng [SMTP:ngyh@PUBLICBANK.COM.MY] > Gesendet am: Mittwoch, 29. März 2000 11:07 > An: DB2-L@RYCI.COM > Betreff: Re: Has anyone found REXX > > Hi, it would be very useful to have REXX on NT. > I would be able to automate a lot of things, such as running a > stream of > batch jobs. > SchiradinR, where to get the software REXX on NT? Is there a > shareware? > Peter, could you tell me something about your experience? > > > > Poor mainframe [...]
840 63 20_Re: Archive products0_24_db46@DAIMLERCHRYSLER.COM31_Wed, 29 Mar 2000 07:36:35 -0500534_us-ascii We've used Princeton Softech tools here at our shop at DCX, but I've mostly used it for movement of data from production to test and for creating DDL from existing tables. We've also used it for browsing and updating tables.
I've found the product quite useful for the above purposes. The only problems I've encountered is sometimes it abends when trying to extract a large amount of data. But I am sure all products have their limits. Unfortunately the product has not been used for archiving here at this time. [...]
904 15 9_DB2 Forms10_Pat Brazil27_pbrazil@MIDATLANTIC.AAA.COM31_Wed, 29 Mar 2000 08:29:36 -0500409_iso-8859-1 I just got an announcement letter from IBM about DB2 Forms. Has anyone got any experience with the product that they would like to share?
Thanks, Pat
================================================ 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.
920 50 42_Re: Trap and Analyze Dynamic SQL in Flight12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Wed, 29 Mar 2000 06:24:20 PST270_- Nelson:
Is strobe available in your shop? If yes, it can help you to trap dynamic sql in flight. you only have to submit your sql in a batch job and trace it. This report has a complete and exact information that could help you. If you have it try it out. [...]
971 31 18_hot backup for DB213_Martin Kenney25_martin.kenney@RAILINC.COM31_Wed, 29 Mar 2000 09:30:20 -0500562_us-ascii Our systems and application people are around one month into the planning phase of making our production DB2 system available on a backup CPU in read write mode (I heard about this in a staff meeting and was more than a little suprised the DBAs were not envolved). The plan is that when/if our production LPAR goes down to bring up our backup CPU with a copy of our DB2 subsystem pointing to all of our production DASD volumes. This backup CPU would then become our production system until our next schedule monthly outage when we would go back to [...]
1003 95 57_Re: Why is 'explain' output different from 'bind' output?0_22_BILL_GALLAGHER@PHL.COM31_Wed, 29 Mar 2000 09:36:01 -0500536_us-ascii Terry,
I've seen a lot of responses to your posting, but nobody has mentioned what (to me) would be the first thing I would normally check . . . how are the columns BEG_AR_KEY_NUM and END_AR_KEY_NUM defined in the table, and how are the corresponding host variables defined in the program? 99% of the time I have seen this kind of problem in my shop, the problem was caused by the programmers using host variables that did not match the definition of the columns, i.e. not using the host variables from the DCLGEN. [...]
1099 119 57_Re: Why is 'explain' output different from 'bind' output?20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 29 Mar 2000 09:36:48 -0500375_iso-8859-1 Sanjeev
I think he has three indexes.
1. on BEG_AR_KEY_NUM, which is unique 2. on END_AR_KEY_NUM, which is unique again 3. on ADDITION_NUM + BEG_AR_KEY_NUM, unique
The reason multi-index access was used is because for non-BT predicates the matching index access is not possible unless multi-index access is used or list-prefetch is used. [...]
1219 79 22_Re: hot backup for DB215_Loria, Susan C.27_Susan_C_Loria@TVRATINGS.COM31_Wed, 29 Mar 2000 09:44:02 -0500569_iso-8859-1 You have every right to be concerned not only from a DBA standpoint, but even an end-user.
How do you connect to your backup LPAR in the event the production one fails or is this transparent to the end-user?
Has your CPU failed often and that's the reason for this effort or is your CPU a UNIX machine and they want to provide for fail over? It would be helpful to understand the reasoning behind it. If there're intent is to have a full functioning DB2 subsystem the minute the LPAR fails, they may want to duplicate your DB2 environment [...]
1299 71 22_Re: hot backup for DB212_craig patton21_prgpatton@HOTMAIL.COM29_Wed, 29 Mar 2000 06:46:03 PST539_- Martin,
The systems staff where I am contracted has just done this same exact scenario. At our site, they created a new LPAR for a new version of OS/390. This system had availability to all of the DASD in our production LPAR. We shutdown DB2 in the production LPAR. Started the SAME DB2 on the TEST LPAR and had NO problems. Am I scared for you that YOUR DBAs are not involved? Absolutely. Who is going to test utilities such as REORG or RECOVER or IC. I would make sure (and would not fear for problems) that all NORMAL DBA [...]
1371 57 22_Re: hot backup for DB29_Don Alden26_Don.Alden@PKSIS.LEVEL3.COM31_Wed, 29 Mar 2000 07:43:35 -0700698_iso-8859-1 Answer to all of your questions .... THINK PARALLEL SYSPLEX !!
GOOD LUCK, Don Alden DB2/IMS DBA Phone:(480) 775-5474 Pager: (888) 610-8507 E-Mail: Don.Alden@pksis.level3.com
-----Original Message----- From: Martin Kenney [mailto:martin.kenney@RAILINC.COM] Sent: Wednesday, March 29, 2000 7:30 AM To: DB2-L@RYCI.COM Subject: hot backup for DB2
Our systems and application people are around one month into the planning phase of making our production DB2 system available on a backup CPU in read write mode (I heard about this in a staff meeting and was more than a little suprised the DBAs were not envolved). The plan is that when/if our production LPAR [...]
1429 12 22_Re: hot backup for DB210_Bill Brown25_bill_brown@SPRINGMAIL.COM31_Wed, 29 Mar 2000 09:54:17 -0500385_- Sounds like you need to investigate data sharing. That way if one LPAR goes down the other LPAR(s) are already up and running DB2. No outage.
================================================ 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.
1442 97 57_Re: Why is 'explain' output different from 'bind' output?14_McCombs, Terry20_tmccomb@SEDGWICK.GOV31_Wed, 29 Mar 2000 09:05:44 -0600506_us-ascii If I do the explain with "OPTIMIZE FOR 1 ROW", I get the same path that the program gets, the tablespace scan. The program is doing a singleton select. Explain won't let me use "INTO ?", so the explain is assuming a cursor, I would guess.
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Michael Hannan Sent: Tuesday, March 28, 2000 5:16 PM To: DB2-L@RYCI.COM Subject: FW: Why is 'explain' output different from 'bind' output? [...]
1540 114 23_Re: Catalog Reorg stats0_18_mebert@AMADEUS.NET31_Wed, 29 Mar 2000 17:14:07 +0100703_us-ascii See the Utilities Guide for REORG, "Phases for Reorganizing the Catalog and Directory" (in V5, pp. 2-207 f.). There are 6 "special" Tablespaces containing links:
DSNDB01.DBD01 DSNDB06.SYSDBASE DSNDB06.SYSDBAUT DSNDB06.SYSGROUP DSNDB06.SYSPLAN DSNDB06.SYSVIEWS
The indexes for these are built up as the TS is loaded, no SORT/BUILD phase. For non-clustering (either implicit or explicit) indexes, this may lead to high LEAFDIST. This should be true e.g. for two of the indexes SYSIBM.DSNDXX01/02/03 depending on which one is considered the (implicit) clustering index (in our case, DSNDXX02 has the smallest LEAFDIST; however our Cat/Dir Reorg was 7 months ago so this may not [...]
1655 140 57_Re: Why is 'explain' output different from 'bind' output?20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 29 Mar 2000 10:23:13 -0500547_iso-8859-1 Terry
The singleton select is not necessarily OPTIMIZEd FOR 1 ROW.
When you did an explain using OPTIMIZE FOR 1 ROW, what it essentially did was, it suppressed multi-index access. As I have mentioned in my previous mail that when you use OR or non Boolean term then matching index scan is not possible and multi-index access is one alternative. Since you suppressed multi-index access by using OPTIMIZE FOR 1 ROW, the access path started using tablespace scan. It was not because you went closer to singleton select. [...]
1796 130 22_Re: hot backup for DB20_19_Tim.Lowe@STPAUL.COM31_Wed, 29 Mar 2000 09:24:14 -0500486_us-ascii Martin, It sounds to me that if the production system goes down hard, that they just intend to start the same DB2 subsystem on another CPU that shares dasd and would have cross-system locking (GRS?). Therefore, I would not think that any utilities would need to be tested, the primary concern to me would be how to route the jobs to the "other cpu". And, I believe that dataset locking would prevent the same subsystem from being started on 2 subsystems at the same time. [...]
1927 19 20_DB2 V5 to V6 (OS390)13_Mario Novelli15_mfn@PO.CWRU.EDU31_Wed, 29 Mar 2000 10:21:03 -0500332_us-ascii Hi all, we are about to begin migration of our DB2 V5 for OS390 systems to V6. Any opinions out there as to a good service level to use as a launching point? We are currently at 9906 and not Data Sharing.
Also anyone been to the IBM V6 Transition class? Is it any good? Do they discuss migrating from v5 to v6? [...]
1947 23 16_Re: RPG to COBOL10_Ken Koleto23_kkoleto@PAINEWEBBER.COM31_Wed, 29 Mar 2000 10:36:21 -0500460_iso-8859-1 Terry,
I've seen this done in another life. If I remember correctly, we did this to a few programs as part of the MVS conversion and the tools were from CA (I think).
What we got was practically unreadable and completely unmaintainable. I didn't recommend it then, and I caution you as well. If you do locate a tool, make sure you see a sample of the finished product using one of your programs so you can test it on your system. [...]
1971 42 22_Re: hot backup for DB212_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK31_Wed, 29 Mar 2000 16:55:00 +0100534_- We just moved 5 development subsystems from one physical machine to another using a shared DASD pool and had no problems at all, the more you think about it, the less work there is to do. The Sysprogs say that all you need to do is 'flip flop' the VTAM definitions, the DBA's did nothing (damn, there's an achievement struck from my monthly report). Of course we did a test run a couple of months ago first on one of our production systems (is this the wrong way round?) and as there was another subsystem on the new machine I [...]
2014 65 22_Re: hot backup for DB222_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Wed, 29 Mar 2000 17:00:59 +0000379_ISO-8859-1 Martin I am very surprised that you are not involved in this. To this point I would be creating loudly if it was my shop.
We all work on the same team here .. OS390 sysprogs, Db2 sysprogs ... Unix ones infact everyone .. one boss ... if somebody was going to go near DB2 in anyway and I was not informed my boss would climb the wall and then jump on them. [...]
2080 58 42_Re: Trap and Analyze Dynamic SQL in Flight14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Wed, 29 Mar 2000 11:06:04 -0500661_iso-8859-1 Carl:
Predictive governing in V6 addresses this problem.
You setup entries in DSNRLST?? table with threshold values in ASU units and DB2 will issue -495 on prepare if error threshold is reached or +495 if warning threshold is reached. Based on the return code you then decide to execute the query.
Manas.
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Carl_Nelson@AICI.COM > Sent: Tuesday, March 28, 2000 6:15 PM > To: DB2-L@RYCI.COM > Subject: Trap and Analyze Dynamic SQL in Flight > > > We would like to trap dynamic SQL in flight, analyze [...]
2139 99 53_Re: Recovery - appreciate feedback on how to do wiser19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 29 Mar 2000 10:22:44 -0600670_iso-8859-1 Jerry, Message DSN3201I ABNORMAL EOT IN PROGRESS FOR USER=xxxxxxxx CONNECTION-ID=yyyyyyyy CORRELATION-ID=zzzzzzzzzzzz JOBNAME=aaaaaaaa TCB=99999999 might be of some help as far as notification is concerned. I'd hate to be beeped every time one of these occurred. Maybe you could write something that sees how long its been since this message was issued and then be beeped if x amount of time has gone by and the job hasn't terminated. OPS/MVS could do this. This wouldn't catch an application initiated ROLLBACK. Finally, shame on those responsible for no COMMIT/RESTART logic. Maybe an hourly status report/wake up call to those responsible could bring [...]
2239 80 38_Trap and Analyze Dynamic SQL in Flight0_20_Carl_Nelson@AICI.COM31_Wed, 29 Mar 2000 12:14:48 -0500712_us-ascii Thanks. I think the predictive governor is what we are looking for. I'll throw this in with the debate for going v6.
Manas Dasgupta on 03/29/2000 11:06:04 AM
To: DB2-L@RYCI.COM cc: (bcc: Carl Nelson/IN002/AICI/US)
Subject: Re: Trap and Analyze Dynamic SQL in Flight
Carl:
Predictive governing in V6 addresses this problem.
You setup entries in DSNRLST?? table with threshold values in ASU units and DB2 will issue -495 on prepare if error threshold is reached or +495 if warning threshold is reached. Based on the return code you then decide to execute the query. [...]
2320 146 53_Re: Recovery - appreciate feedback on how to do wiser0_19_Tim.Lowe@STPAUL.COM31_Wed, 29 Mar 2000 11:40:47 -0500481_us-ascii Jerry, I think that your DB2 systems programmer should investigate setting the zaprm "URCHKTH" (on panel DSNTIPN) so that DB2 issues warning messages about long-running uncommitted units of recovery. (so that this problem does not occur again)
Thanks, Tim Lowe
"DAVIS, RICK (SBCSI)" on 03/29/2000 11:22:44 AM
Please respond to DB2 Data Base Discussion List [...]
2467 138 53_Re: Recovery - appreciate feedback on how to do wiser17_Gerald Bustamente20_ggbusta@LANDSEND.COM31_Wed, 29 Mar 2000 12:13:22 -0600657_us-ascii Tim,
Thanks alot. Great idea. Just what I was looking for.
Sincerely,
Jerry
Tim.Lowe@STPAUL.COM wrote:
> Jerry, > I think that your DB2 systems programmer should investigate setting the zaprm > "URCHKTH" (on panel DSNTIPN) so that DB2 issues warning messages about > long-running uncommitted units of recovery. > (so that this problem does not occur again) > > Thanks, > Tim Lowe > > "DAVIS, RICK (SBCSI)" on 03/29/2000 11:22:44 AM > > Please respond to DB2 Data Base Discussion List > > To: DB2-L@RYCI.COM > > cc: (bcc: Tim Lowe/sfm/spc) > > Subject: Re: Recovery - [...]
2606 230 12_Re: DSNTIAUL0_19_mike.holmans@BT.COM31_Wed, 29 Mar 2000 17:03:30 +0100417_iso-8859-1 ----Original Message----- From: Greg P Mucha [SMTP:Greg_P_Mucha@CARADON.COM] Sent: Thursday, March 23, 2000 3:26 PM To: DB2-L@RYCI.COM Subject: Re: DSNTIAUL
Bejoy ---
I'm not a DBA....I don't have those manuals. And with the attitude of some of the folks in charge, if I start doing REORG's without knowing EXACTLY what I am doing, they are liable to yank MORE priviledges away from me. [...]
2837 145 53_Re: Recovery - appreciate feedback on how to do wiser19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 29 Mar 2000 13:19:02 -0600502_iso-8859-1 Tim, Jerry, Using URCHKTH would seem to be a good way to find any and all processes that may have a problem with COMMIT frequency. As you are probably aware, the "wall time" between CHECKPOINTs can vary significantly. Another area where you would need to be careful is that there are several different events that trigger CHECKPOINTs. These events could happen fairly close together and might make a process look bad when it really wasn't. So a little investigation would be necessary. [...]
2983 157 53_Re: Recovery - appreciate feedback on how to do wiser17_Gerald Bustamente20_ggbusta@LANDSEND.COM31_Wed, 29 Mar 2000 13:42:02 -0600609_us-ascii Rick,
Good advice. Thanks alot.
Jerry
DAVIS, RICK (SBCSI) wrote:
> Tim, Jerry, > Using URCHKTH would seem to be a good way to find any and all > processes that may have a problem with COMMIT frequency. > As you are probably aware, the "wall time" between CHECKPOINTs can > vary significantly. Another area where you would need to be careful is that > there are several different events that trigger CHECKPOINTs. These events > could happen fairly close together and might make a process look bad when it > really wasn't. So a little investigation would be necessary. [...]
3141 25 21_DB2 Connect with JDBC13_Shauna Hadden24_shauna.hadden@BCBSKS.COM31_Wed, 29 Mar 2000 13:37:58 -0600350_- We are a pure DB2 Connect/ODBC only shop. We are using DB2 Connect PE on an NT workstation(s) and connecting to several OS/390 DB2 subsystems. We originally did a custom install selecting ODBC, Bind files, CCA and Misc Tools.
We have a new project in house and I have been asked to set up some PC's with the JDBC flavor of DB2 Connect. [...]
3167 34 24_Re: DB2 V5 to V6 (OS390)11_Joe Luthman22_jluthma@BGNET.BGSU.EDU31_Wed, 29 Mar 2000 15:02:58 -0500445_us-ascii According to Sheryl Larsen of RYC,inc. , you should wait until the May/June refresh. Here at BGSU, though, we have migrated to V6 and are not experiencing any problems. I gather those who use data sharing should proceed with more caution. As to service level, I believe we are at about 9910 and counting. Any appropriate HIPER that I saw when already asking for new function such as SAVEPOINT or REXX Stored Procedures, I ordered. [...]
3202 59 22_Re: hot backup for DB213_Tierney, Mark20_mtierney@FIRSTAM.COM31_Wed, 29 Mar 2000 14:05:46 -0600443_- Hello Martin,
As long as the Other CPU is running the same DB2 subsystem (not concurrently, of course) and shares the DASD environment (catalogs, etc) this should be OK. It's just a matter of defining that DB2 to the other MVS. Maybe someone else could answer the mirroring question as I typically think of that as DASD fault protection (or DR) and not CPU fault protection. This of course could also be handled by Data Sharing. [...]
3262 183 74_Repost: Teraplex White Paper Available: DB2 UDB EEE Competitive S trengths13_Morrill, John12_JohnM@VP.NET31_Wed, 29 Mar 2000 14:11:31 -0700608_iso-8859-1 Greetings!
Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.
Cheers!
J. Michael Morrill Chief DB2-L List Owner =================================================
Dear DB2 Interested Parties,
Below is a bulletin about an experience report from the IBM Teraplex Integration Center about a proof-of-concept done for an Internet company on an RS/6000 SP and DB2-based 750GB data warehouse. [...]
3446 59 24_Re: DB2 V5 to V6 (OS390)14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Wed, 29 Mar 2000 15:20:12 -0500410_iso-8859-1 There are currently only 80+ sites under production on V6, basically due to the Y2K slowdown. However, there are some "problems". There is a stated direction from IBM, made most recently at the Tech Conference last week in Barcelona, to please wait if possible until after the refresh of V6. The refresh was originally supposed to be in March but has been delayed until approximately June 1st. [...]
3506 100 57_Re: Why is 'explain' output different from 'bind' output?13_Helen Johnson25_Helen_Johnson@RAC.RAY.COM31_Wed, 29 Mar 2000 15:27:47 -0600351_us-ascii Bill, That is a really good point. Another thing that the programmers do that doesn't show in the explain is how many times they executed that tablespace scan. Sixty-seven hundred rows to scan is not as bad as doing that scan 1000 times in the program. I have found a number of those over the years. Helen Johnson, DBA Raytheon Aircraft [...]
3607 198 27_Re: Has anyone found REXX ?11_ALLEN,Bruce37_bruce.allen@EMPLOYMENTNATIONAL.COM.AU31_Thu, 30 Mar 2000 08:38:53 +1000549_- Hi Peter, Have you tried sqllib\djra? djra.exe self-installs (unzips) to reveal Data (Joiner) Replication Administration tool. Also available as download from http://www.ibm.com/software/data/dpropr. Some of this product is object Rexx, and the djrax.exe appears to have no trouble executing 'real' Rexx, and it is executing SQL.
However, since IBM appear to have gone to some trouble to hide Rexx, it may be well under the covers next time. I think your new pooch will have long legs. Do you know of any converters from Rexx to Java? [...]
3806 327 34_Re: Column Definition in SYSTABLES16_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Wed, 29 Mar 2000 17:54:59 -0500636_- Thanks a bunch. I figured it was in a manual somewhere, but at the moment I am buried in supporting 10 PeopleSoft instances and just needed a quick answer if someone had it. I appreciate your takig the time.
Andrea Milligan DataBase Administrator BlueCross BlueShield of Tennessee
> -----Original Message----- > From: James Campbell [SMTP:James.Campbell@HANCORP.COM.AU] > Sent: Wednesday, March 29, 2000 12:53 AM > To: DB2-L@RYCI.COM > Subject: Re: Column Definition in SYSTABLES > > Andrea, > > Have you put DEC31 on? Then read the SQL Reference definition of the SUM > function. Especially the bit that goes: "If [...]
4134 53 25_Re: DB2 Connect with JDBC15_Richard Simpson25_rsimpson@MACQUARIE.COM.AU31_Thu, 30 Mar 2000 09:09:42 +1000379_iso-8859-1 I recently installed JDBC connectivity to OS/390 from an NT box.
The application team already had Java talking to DB2 UDB for NT. I simply defined the connection to OS/390 through the CCA and they told their JDBC application to call 'DB2T' (the 'database' representing the OS/390 test DB2) rather than the UDB database they has previously been talking to. [...]
4188 24 79_Re: Repost: Teraplex White Paper Available: DB2 UDB EEE Competiti ve S trengths11_Wayne Kline27_wayne.kline@INGRAMMICRO.COM31_Wed, 29 Mar 2000 15:21:16 -0800571_iso-8859-1 John: Would very much appreciate getting a copy of this white paper!
TIA,
Wayne Kline
-----Original Message----- From: Morrill, John [mailto:JohnM@VP.NET] Sent: Wednesday, March 29, 2000 1:12 PM To: DB2-L@RYCI.COM Subject: Repost: Teraplex White Paper Available: DB2 UDB EEE Competitive S trengths
================================================ 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.
4213 292 12_Re: DSNTIAUL12_Greg P Mucha24_Greg_P_Mucha@CARADON.COM31_Thu, 30 Mar 2000 00:36:07 +0100466_us-ascii I hear ya. Right now I have to REQUEST the DBA's to do rinky dink stuff and they take all damn day because of other priorities.
What happened that triggered this mess is that I was doing a mass delete from a test environment prior to some high visibility customer testing. Well, all this stuff got logged prior to delete. I'm used to working in shops where the Systems people are on top of the disk space needs and anticipate peaks and valleys. [...]
4506 114 57_Re: Why is 'explain' output different from 'bind' output?14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Thu, 30 Mar 2000 10:14:35 +1000386_us-ascii Explain doesn't assume a Cursor because it gives same access path for both singleton Select and for a Cursor unless Optimize for n Rows is added.
I have asked Akira Shibamiya why Singleton Select is not optimized for 1 row automatically, but the lab never envisaged anyone would need it. However for Existance check it would be very useful on problem access paths. [...]
4621 24 35_Problem in - ssnm START DB2 Command11_Manish Lall31_Manish.Lall@POWAIMAIL.LTITL.COM31_Thu, 30 Mar 2000 10:28:46 +0530371_us-ascii Hi
We are facing problem while starting db2. DB2 subsystem was stopped and then it was attempted to start using a userid which did'nt have authority . The start DB2 command is protected via RACF opercmds profile.
After this the start command of db2 gives no response even from master console. no messages. The SSI for the subsystem is active. [...]
4646 184 53_Re: Recovery - appreciate feedback on how to do wiser22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Thu, 30 Mar 2000 06:09:29 +0000348_ISO-8859-1 Tim et al, that is what we do here ..
- we have URCHKTH set at 10 now (too many messages when at 2) - We scan Mstr and report on long running uncommitted units of recovery (using SDSF in batch) - our OS390 sysprog has written an alert monitor for checking on messages in the log (so URs get put to my screen when they occur) [...]
4831 22 20_packages and pklists11_Beni Nissim26_benjamin.nissim@BNHP.CO.IL31_Thu, 30 Mar 2000 08:27:32 +0300332_us-ascii hi, we want to start working with packages. what is the advantages and disadvantages in the following two methods: 1. each pklist contains just one package and then the plan will consist many pklists. 2. pklist can contains many packages (that belong to a big project), and then the plan will consist just one pklist. [...]
4854 49 39_Re: Problem in - ssnm START DB2 Command9_Chris Tee18_TEECHRI@UK.IBM.COM31_Thu, 30 Mar 2000 09:10:27 +0100628_us-ascii I've come across this problem before. The only way to sort it out was to IPL.
Manish Lall on 30/03/2000 05:58:46
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Chris Tee/UK/Contr/IBM) Subject: Problem in - ssnm START DB2 Command
Hi
We are facing problem while starting db2. DB2 subsystem was stopped and then it was attempted to start using a userid which did'nt have authority . The start DB2 command is protected via RACF opercmds profile. [...]
4904 175 23_Re: Catalog Reorg stats11_Peter Marsh23_Peter.Marsh@ITNET.CO.UK31_Thu, 30 Mar 2000 09:42:17 +0100600_us-ascii Thank you very much
These are the stats after the catalog Reorgs( before the Leafdist was below 200):-
DB TS T IX LeafDist DSNDB06 SYSDBASE SYSCOLUMNS DSNDCX01 5909
After Index Reorg
DB TS T IX LeafDist DSNDB06 SYSDBASE SYSCOLUMNS DSNDCX01 4889
A slight improvement!
mebert@AMADEUS.NET 29/03/2000 17:14 cc:Mail
To: DB2-L@RYCI.COM cc: Subject: Re: Catalog Reorg stats
From: mebert@AMADEUS.NET To: DB2-L@RYCI.COM Date: Wed, 29 Mar 2000 17:14:07 +0100 Subject: Re: Catalog Reorg stats [...]
5080 48 24_Re: packages and pklists0_19_mike.holmans@BT.COM31_Thu, 30 Mar 2000 10:48:01 +0100576_- I'd definitely go with 2.
By binding your plan with PKLIST(mycollid.*), you only bind it the once and leave it alone thereafter. As new programs get added, so new packages get added, and the plan sails sedately on regardless.
The main function of the plan entity in a package environment is authorization control. If I were building an application from scratch, I would intend to have two or three plans only, one for CICS, bound with the option ENABLE(CICS), one for batch - ENABLE(BATCH), and maybe one or two which were designed for restricted access. [...]
5129 24 34_Stored procedures instead of CICS.31_Cagdas Ucar (Garanti Teknoloji)22_cagdasu@GARANTI.COM.TR31_Thu, 30 Mar 2000 12:52:14 +0300515_- Hi all,
Now that we have stored procedures and RRSAF, can't we port CICS transactions to DB2?.. Of course, start transactions, and XCTLs wouldn't be ported, but if one is using CICS for just processing (with only links), and some other product for interface, this seems to be possible... What would be the advantages/disadvantages of such a scheme?.. I think the performance would increase as there won't be CICS keeping the system busy. Is DB2 as efficient as CICS for managing stored procedures?... [...]
5154 182 23_Re: Catalog Reorg stats0_18_mebert@AMADEUS.NET31_Thu, 30 Mar 2000 12:05:19 +0100582_us-ascii Hhmm. There was a posting on 18.1.2000 by Dan Courter, subject "PCTFREE 0", stating that many catalog TSs and IXs have PCTFREE 0, even if the catalog says something different, and you have to do an explicit ALTER to change this to a value>0. Try ALTER INDEX SYSIBM.xxx FREEPAGE 8 PCTFREE 15 (or something) for all SYSIBM indexes & TSs (TSs FREEPAGE 0) mentioned, then rerun the REORG. But I have currently no idea why the REORG INDEX improved matters so little. Maybe REORG INDEX has special treatment for these indexes as well; look for messages in the SYSPRINT. Was [...]
5337 81 14_COLUMN LENGTHS4_DBAS14_dbas@CWCOM.NET31_Thu, 30 Mar 2000 11:24:56 +0100356_iso-8859-1 We are currently running version 4.1 of DB2. The current maximum allowable length of the name column for the following are:
COLUMN 18 Characters TABLES 18 Charatcers INDEXES 18 Characters DATABASE 8 Characters TABLESPACE 8 Characters
Do any of these change in later releases and what do they change to ?
Thanks for your help
5419 203 53_Re: Recovery - appreciate feedback on how to do wiser12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK31_Thu, 30 Mar 2000 11:32:00 +0100404_iso-8859-1 Platinum (CA) log analyser produces a nice report of updates per commit with various filtering options as well as providing all of the SQL undo/redo options.
Colin Allen, DB2 DBA Abbey National
Colin.Allen@AbbeyNational.Co.Uk ---------- From: Leslie Pendlebury-Bowe To: DB2-L@RYCI.COM Subject: Re: Recovery - appreciate feedback on how to do wiser Date: 30 March 2000 07:09 [...]
5623 42 21_Listserv Archives OK?15_Gordon Fishwick39_Gordon.Fishwick@SCOTTISH-SOUTHERN.CO.UK31_Thu, 30 Mar 2000 11:27:49 +0100800_us-ascii Fellow List Members,
I'm having difficulty accessing the archives (http://jupiter.ryci.com/archives/db2-l.html - Unknown WWW server). Is anyone else having problems?
Is it just me?
Any insights would be greatly appreciated...
Best regards,
Gordon Fishwick DB2 Systems Programmer Scottish and Southern Energy plc
********************************************************************** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy plc. It is intended solely for the addressees. Access to this E-Mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to [...]
5666 45 24_Re: packages and pklists12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK31_Thu, 30 Mar 2000 11:35:00 +0100463_- The last I heard, the packages in a collection id are indexed, but the list of collections in the plan is just searched sequentially, so if you have lots of collections there is an overhead in searching them.
When we converted (many years ago!) we used an initial strategy of one collection per package then never had a good reason to change from that. I know other sites have had good reasons to do things other ways, but they never applied to us. [...]
5712 232 53_Re: Recovery - appreciate feedback on how to do wiser22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Thu, 30 Mar 2000 11:45:37 +0000421_ISO-8859-1 Colin, yes a good product and infact the 99H tape has some excellent features added that I requested a while back(due out soon).
The Log Analyser developer was onsite here Monday/Tuesday of this week and I learnt a whole lot more about the product from him ..
I would, however, say that for apps going through URs I find the MSTR messages easier to deal with than keep running Log Analazer. [...]
5945 104 21_Listserv Archives OK?15_Gordon Fishwick39_Gordon.Fishwick@SCOTTISH-SOUTHERN.CO.UK31_Thu, 30 Mar 2000 11:43:14 +0100517_us-ascii Fellow List Members,
False alarm, seems to be OK now (probably just me/some random bizarre phenomenon!)
Sorry for wasting your time...
Best regards
Gordon Fishwick DB2 Systems Programmer Scottish and Southern Energy plc ---------------------- Forwarded by Gordon Fishwick/HAV/SSE on 30/03/2000 11:41 --------------------------- (Embedded image moved to file: pic00970.pcx) Gordon Fishwick 30/03/2000 10:27
To: DB2-L@RYCI.COM cc: Subject: Listserv Archives OK? [...]
6050 126 27_Re: FW: Catalog Reorg stats0_18_mebert@AMADEUS.NET31_Thu, 30 Mar 2000 12:52:35 +0100414_us-ascii Looks like you subscribed using a different email address. If you cannot resolve this from the internet site, send an email describing your problem to the list owners, as stated in the letter: DB2-L-request@RYCI.COM (I've copied them on this mail too). This may take a day or two.
MfG, ME.
From: Latha Sunder on 30/03/2000 10:42 GMT [...]
6177 62 25_Re: Listserv Archives OK?15_Gordon Fishwick39_Gordon.Fishwick@SCOTTISH-SOUTHERN.CO.UK31_Thu, 30 Mar 2000 11:59:17 +0100875_us-ascii Paul,
Thanks for the swift response.
All is OK for me now too, must've been a temporary glitch.
Best regards,
Gordon Fishwick DB2 Systems Programmer Scottish and Southern Energy plc
paul.packham@postoffice.co.uk on 30/03/2000 11:47:52
To: Gordon Fishwick/HAV/SSE cc: Subject: Re: Listserv Archives OK?
Gordon,
I've just tried the archives & all seems to be OK.
Regards, Paul
********************************************************************** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy plc. It is intended solely for the addressees. Access to this E-Mail by anyone else is unauthorised. If you [...]
6240 26 32_DB2 Estimator and Visual Explain13_Michael Fleck19_m.fleck@MAIL.LVR.DE31_Thu, 30 Mar 2000 13:18:47 +0100398_US-ASCII Hi list members,
I did some initial tests with DB2 Estimator and Visual Explain and was wondering, if anybody knows of a good documentation for these tools. I've looked on the IBM Websites, but couldn't find any hints.
Thanks in advance, Michael
Landschaftsverband Rheinland Datenbank- und Ressourcenmanagement Ottoplatz 2, 50679 Koeln Tel: 0221/809/2826 [...]
6267 81 39_Re: Problem in - ssnm START DB2 Command11_Manish Lall31_Manish.Lall@POWAIMAIL.LTITL.COM31_Thu, 30 Mar 2000 16:48:25 +0530479_us-ascii Hi Chris,
The same problem was raised by Dresdner Global IT-Services Frankfurt / Main, Germany. Their PMR is 89725,071,724.and it's still open.
Has IBM come out with some patch to rectify the above.
Rgds, Manish DB2 DBA.
Chris Tee on 03/30/2000 02:40:27 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Manish Lall/LTITL) [...]
6349 70 24_Fw: packages and pklists9_jim.szabo22_jim.szabo@MCIWORLD.COM31_Thu, 30 Mar 2000 07:01:36 -0500563_iso-8859-1 We have found the following strategy works very well for DB2 for OS/390 V5:
For each application, create two plans - one with the "ONLIN" (online) suffix, and the other "BATCH" (batch). Use the "ONLIN" plan for CICS, placing this name into the CICS definitions (RCT if CICS V4 or earlier, RDO if CICS TS or greater). Or in the appropriate place if you use IMS as a TP front end. Use the "BATCH" plan for all batch processes. Separation of plans in this way allows you to GRANT EXECUTE on "ONLIN" TO PUBLIC, and control security via your TP [...]
6420 82 39_AW: Problem in - ssnm START DB2 Command16_Roland Schiradin28_SchiradinR@ALTE-LEIPZIGER.DE31_Thu, 30 Mar 2000 14:13:08 +0200620_iso-8859-1 Or your set ERLY+23 to X'00'
Roland
> -----Ursprüngliche Nachricht----- > Von: Chris Tee [SMTP:TEECHRI@UK.IBM.COM] > Gesendet am: Donnerstag, 30. März 2000 10:10 > An: DB2-L@RYCI.COM > Betreff: Re: Problem in - ssnm START DB2 Command > > I've come across this problem before. The only way to sort it out was to > IPL. > > > > > > Manish Lall on 30/03/2000 05:58:46 > > Please respond to DB2 Data Base Discussion List > > To: DB2-L@RYCI.COM > cc: (bcc: Chris Tee/UK/Contr/IBM) > Subject: Problem in - ssnm START DB2 Command > > > > [...]
6503 79 27_Re: Has anyone found REXX ?0_23_john.lantz@ZURICHUS.COM31_Thu, 30 Mar 2000 08:19:14 -0400355_us-ascii There was a part in the license that we signed for the V7 Beta program that specifically said that the REXX part of DRJA is to be used only for DRJA and not to be used with anything else. It sounds like you have to purchase it separately. Bummer for us since we wrote a lot of stuff (like managing logs, checking status, etc...) using Rexx. [...]
6583 107 39_Re: Problem in - ssnm START DB2 Command9_Chris Tee18_TEECHRI@UK.IBM.COM31_Thu, 30 Mar 2000 13:39:44 +0100580_us-ascii I don't know what version of OS/390 you are on, but take a look at OW26652 and II04773
Manish Lall on 30/03/2000 12:18:25
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Chris Tee/UK/Contr/IBM) Subject: Re: Problem in - ssnm START DB2 Command
Hi Chris,
The same problem was raised by Dresdner Global IT-Services Frankfurt / Main, Germany. Their PMR is 89725,071,724.and it's still open. [...]
6691 96 39_AW: Problem in - ssnm START DB2 Command16_Roland Schiradin28_SchiradinR@ALTE-LEIPZIGER.DE31_Thu, 30 Mar 2000 15:06:42 +0200736_iso-8859-1 sorry for confussion I mean ERLY+X'23
0000 00A50098 C5D9D3E8 C4C2F2E2 C4C2F2E2 *.v.qERLYDB2SDB2S* 0010 D4E2E3D9 00001D00 09FFCE60 08FFD4D0 *MSTR.......-..M.* 0020 00000002 00000000 00000002 00B52F68 *................* **
Roland
> -----Ursprüngliche Nachricht----- > Von: Schiradin,Roland HG-Dir rz-db/dc > Gesendet am: Donnerstag, 30. März 2000 14:13 > An: 'DB2 Data Base Discussion List' > Cc: 'teechris@uk.ibm.com' > Betreff: AW: Problem in - ssnm START DB2 Command > > Or your set ERLY+23 to X'00' > > Roland > > > -----Ursprüngliche Nachricht----- > Von: Chris Tee [SMTP:TEECHRI@UK.IBM.COM] > Gesendet am: Donnerstag, 30. März 2000 10:10 > An: DB2-L@RYCI.COM > Betreff: Re: Problem in - [...]
6788 18 21_Re: Disaster Recovery20_Edward C. Benoit Jr.19_db2automate@AOL.COM31_Thu, 30 Mar 2000 06:55:40 -0600594_- Dave, Andy is correct the maintenance of the BSDS is labor-intensive. We have a tool that automate the creation of the delete/newlog archive logs and delete/newlog active cntl cards and JCL for the DB2 utility. The tool will also automate the recovery of the BSDS, Active Logs, user Tablespaces, work tablespaces and other things On-site and Off-site disaster recovery. The BSDS and Active Logs recovery is done based on the DB2 messages issued. That take the guess work out of the picture and make the generated jobs JCL error free as well Cntl cards error free. For information on how [...]
6807 232 20_V6 Migration problem13_Brunner Don J21_Don.J.Brunner@IRS.GOV31_Thu, 30 Mar 2000 08:16:45 -0500366_ISO-8859-1 Before I give IBM a call, I'd like to know if anyone else has encountered this problem and come up with a resolution.
We've just migrated two subsystems to V6 (Base=9918). One part of the IVP steps is to execute member DSNTESA in NEW.SDSNSAMP. This member creates some tables, executes inserts and updates, then performs some catalog queries. [...]
7040 224 53_Re: Recovery - appreciate feedback on how to do wiser18_Martinson, Barbara25_Barbara_Martinson@BMC.COM31_Thu, 30 Mar 2000 07:47:21 -0600420_ISO-8859-1 FYI: BMC's product, RESOLVE LOG MASTER FOR DB2, provides a Commit report and it can also produce undo/redo SQL based on search criteria.
The Commit report provides information about commit frequency for application tuning and system performance purposes. Depending on how you order the report, counts are maintained for each unit of recovery to indicate the activity volume between commit points. [...]
7265 13 53_Re: Recovery - appreciate feedback on how to do wiser12_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM31_Thu, 30 Mar 2000 08:46:35 -0500286_us-ascii I would like to get a copy. Thanks.
================================================ 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.
7279 77 78_Repost: Webcast from IBM DB2 & Siebel Systems - March 31 (replays for 30 days)13_Morrill, John12_JohnM@VP.NET31_Thu, 30 Mar 2000 07:18:04 -0700599_- Greetings!
Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.
Cheers!
J. Michael Morrill Chief DB2-L List Owner =================================================
Dear DB2 Interested Parties,
Please find below a bulletin for a "web seminar" this Friday (with replays until April 30) about the combination of Siebel's eBusiness 2000 applications and DB2. The URL to register is included. [...]
7357 43 67_SQL ERROR SQL0902C - trying to add a new database on a new instance15_Joel Zigelstein20_jzigel1@HALLMARK.COM31_Thu, 30 Mar 2000 08:27:37 -0600564_- Hi ...
First a bit of history. I am a DBA new to DB2 UDB (experience lies in DB2 Server for VM and VSE). I have had the default instance (DB2) running our production database (our first and only one) for sometime. Our developers now need to start phase 2 of the project and need a development database. I went to our actually server (not a client workstation) and created a new instance - using DB2ICRT - called DB2DEVT. The command worked fine and both instances were listed using DB2ILIST. I then started the control centre and the second instance [...]
7401 53 25_Datasharing Configuration9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Thu, 30 Mar 2000 15:56:15 +0100483_us-ascii Hi, We are currently looking at datasharing across 2 sites (2 members) at DB2 V5.1 , OS390 2.4.
Proposed configuration is as follows........
2 datacentres 13km apart 9672-X77 on one site with 9674-C05 Coupling Facility 9672-X37 on the other site with 9674-C05 Coupling Facility
100 mbs coupling links between the sites
Data on either IBM ESS 2105-E20 or StorageTek SVA cross site connected through two pairs of 9032 Model 3 Escon Directors. [...]
7455 25 25_Osolete SYSIBM Databases?13_Bernie Polley29_bpolley@JHUADIG.ADMIN.JHU.EDU31_Thu, 30 Mar 2000 11:15:08 -0500473_US-ASCII Are the following SYSIBM databases used by DB2 for OS390 Version 5?
DSNCV DSNDDF DSNRGFDB DSNRLST
Your response would be greatly appreciated.
Bernard Polley Johns Hopkins University berns@jhu.edu
===============================================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.
7481 122 18_Re: COLUMN LENGTHS14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Thu, 30 Mar 2000 10:20:13 -0500550_iso-8859-1 They are on a list of things to be changed in a future release. Regards, Richard +===+===+===+===+====+ Richard_Yevich@attglobal.net www.YLAssoc.com www.RYCi.com www.DB2-Performance-Journal.com
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of DBAS Sent: Thursday, March 30, 2000 5:25 AM To: DB2-L@RYCI.COM Subject: COLUMN LENGTHS
We are currently running version 4.1 of DB2. The current maximum allowable length of the name column for the following are: [...]
7604 51 29_Re: Osolete SYSIBM Databases?0_17_sjvagnier@AEP.COM31_Thu, 30 Mar 2000 11:26:19 -0500544_us-ascii Hi Bernie,
DSNCV and DSNDDF are no longer used by DB2 for OS/390 V5.
DSNRGFDB and DSNRLST are still used by DB2 for OS/390 V5.
Bernie Polley on 03/30/2000 11:15:08 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Stephen J Vagnier/OR1/AEPIN)
Subject: Osolete SYSIBM Databases?
Are the following SYSIBM databases used by DB2 for OS390 Version 5? [...]
7656 37 18_Re: COLUMN LENGTHS0_19_mike.holmans@BT.COM31_Thu, 30 Mar 2000 15:07:25 +0100608_- There are no changes to those lengths in any version of DB2 announced so far.
Mike Holmans BT ISE Technical Design mike.holmans@bt.com
> -----Original Message----- > From: DBAS [SMTP:dbas@CWCOM.NET] > Sent: Thursday, March 30, 2000 11:25 AM > To: DB2-L@RYCI.COM > Subject: COLUMN LENGTHS > > We are currently running version 4.1 of DB2. > The current maximum allowable length of the name column for the following > are: > > COLUMN 18 Characters > TABLES 18 Charatcers > INDEXES 18 Characters > DATABASE 8 Characters > TABLESPACE 8 Characters > > Do any of these change in later releases [...]
7694 55 77_Re: Repost: Teraplex White Paper Available: DB2 UDB EEE Competitive Strengths12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Thu, 30 Mar 2000 18:46:20 +0200634_x-user-defined Hi,
Where can it be downloaded ? - would be easier then sending it to each requester.
Isaac Yassin
"Morrill, John" wrote: > > Greetings! > > Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If > you would like to join his list, you can e-mail him at dbswift@us.ibm.com. > Not all posting to DB2 Interested Parties are re-posted here. > > Cheers! > > J. Michael Morrill > Chief DB2-L List Owner > ================================================= > > Dear DB2 Interested Parties, > > Below is a bulletin about an experience report from the IBM Teraplex [...]
7750 64 25_Re: DB2 Connect with JDBC9_SrinivasG17_SRINIVASG@INF.COM31_Thu, 30 Mar 2000 10:57:15 +0530647_iso-8859-1 Hi, Along with DB2 Connect, there is a directory , java , that gets created under c:\sqllib. This contains two zip files called db2java.zip and runtime.zip. You have to include this folder in the classpath. So Class path should look like :
C:\SQLLIB\java\db2java.zip;C:\SQLLIB\java\runtime.zip;C:\SQLLIB\java\sqlj.zi p;C:\SQLLIB\samples\java;C:\SQLLIB\java\jdk\bin
and Path should be
C:\SQLLIB\java\jdk\bin;C:\SQLLIB\BIN;C:\SQLLIB\FUNCTION;C:\SQLLIB\SAMPLES\RE PL;C:\SQLLIB\HELP;C:\SQLLIB\java\db2java.zip.
Then code a java program that has a db2 connect statement and accesses a db2 table. Execute it. [...]
7815 78 24_db2 client configuration14_Nancy Westover22_nwestover@NETSCAPE.NET29_Thu, 30 Mar 2000 12:03:40 EST383_US-ASCII Hi,
In November I sent the message below about having problems cataloging databases using the DB2CCA. Someone responded and the advice was bang on. I need the information again since I left my company and forgot to take the information with me. I'd really appreciate the info again.
TIA .. Please respond to nwestover@hotmail.com as well as the listserv. [...]
7894 41 28_Re: db2 client configuration14_Wayne Driscoll19_wdriscoll@QUEST.COM31_Thu, 30 Mar 2000 09:07:14 -0800357_iso-8859-1 Nancy, Probably your best bet would be to vist the list server archives. They are located at http://jupiter.ryci.com/archives/db2-l.html It has a searchable interface, or a week by week listing of postings back to October 1999. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own. [...]
7936 86 18_Re: COLUMN LENGTHS13_Umair Hussain25_umair_hussain@HOTMAIL.COM29_Thu, 30 Mar 2000 11:21:16 CST524_- But ....... if you switch to db2udb UNIX v6.1
Database, Database Alias, and Catalog Node Name 8 Characters
Object Name Rules ----------------- Database objects include: Tables, Views, Columns, Indexes, User-defined functions (UDFs), User-defined types (UDTs), Triggers, Aliases, Table spaces, Schemas, Can contain 1 to 18 characters except for the following:
Table names (including view names, summary table names, alias names, and correlation names), which can contain up to 128 characters; and [...]
8023 39 14_MEMBER CLUSTER17_Nagaraj Pudukotai25_Nagaraj.Pudukotai@WDR.COM31_Thu, 30 Mar 2000 18:32:58 +0100594_US-ASCII Hi
What are the implications of MEMBER CLUSTER option on CREATE TABLESPACE statement used for creating a partitioned tablespace. I have V5 manuals and I am unable to get any info. on this.
TIA for any info.
Nagaraj
This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. [...]
8063 78 18_Re: MEMBER CLUSTER19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 30 Mar 2000 11:45:14 -0600667_iso-8859-1 Nagaraj, See DB2 for OS/390, V5, Admin. Guide, bookmanager ref. 5.7.3.2, Recommendations for Database Design:
"On the other hand, if your application does sequential batch insertions for which the input data is not in clustering sequence, there can be excessive contention on the space map page for the table space. This problem is especially apparent in data sharing, where contention on the space map means the added overhead of page P-lock negotiation. For these types of applications, consider using the MEMBER CLUSTER option of CREATE TABLESPACE. This option causes DB2 to disregard the clustering index (or implicit clustering index) for [...]
8142 67 18_Re: MEMBER CLUSTER14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Thu, 30 Mar 2000 11:50:20 -0500742_iso-8859-1 This is an option specifically for data sharing. Inserts are done based solely on free space availability, and not on clustering sequence. It is to alleviate contention on batch insert processes on the space map pages.
Regards, Richard +===+===+===+===+====+ Richard_Yevich@attglobal.net www.YLAssoc.com www.RYCi.com www.DB2-Performance-Journal.com
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Nagaraj Pudukotai > Sent: Thursday, March 30, 2000 12:33 PM > To: DB2-L@RYCI.COM > Subject: MEMBER CLUSTER > > > Hi > > What are the implications of MEMBER CLUSTER option on CREATE > TABLESPACE statement used for creating a partitioned tablespace. > [...]
8210 128 28_Re: db2 client configuration0_23_sjtoeniskoetter@AEP.COM31_Thu, 30 Mar 2000 12:55:25 -0500420_us-ascii Nancy,
I replied last time with these instructions. When I catalog a database through CCA, if the system or instance has not been previously cataloged, some of the system or instance information is missing in CC, leading to the problem you're having. To update it do this:
In Control Center, expand the Systems icon, right click on the desired system and select Change. Fill it in like this: [...]
8339 24 27_DB2 V6 - Data Sharing - SAP11_Chris Hardy17_hhardy@SWBELL.NET31_Thu, 30 Mar 2000 13:12:46 -0600556_iso-8859-1 HI,
I'm looking for a shop supporting db2 v6, data sharing environment running SAP R3.
I'm interested in process used for data recovery.... Can someone share their process with me..... type of backup, point-in-time recovery - backup-forward etc....
Thanks in advance...
Chris
================================================ 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.
8364 44 42_List prefetch questions - VPSEQT threshold0_34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM31_Thu, 30 Mar 2000 13:58:38 -0600396_us-ascii I am wondering if the VPSEQT threshold applies to List prefetch. I have seen some objects in a bufferpool dominate that bufferpool and I am curious to know why this might be happening.
I ran a test to try to determine the answer to the above question for which I really cannot explain the results. I executed a query against a 17 million row table that was constructed like: [...]
8409 52 31_Re: DB2 V6 - Data Sharing - SAP19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 30 Mar 2000 14:19:19 -0600633_iso-8859-1 Chris, As I recall, (once did some research on similar issue), there are many REDBOOKS, PIECES, and PAPERS on SAP/DB2.
HTH, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, [...]
8462 87 46_Re: List prefetch questions - VPSEQT threshold20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 30 Mar 2000 15:23:41 -0500331_us-ascii I am not completely sure if List-prefetch counts towards VPSEQT. But I guess, it doesn't.
When get-page is done, the DB2 knows how the page was brought. IFCID 198 indicates 'S' for sequential prefetch, 'R' for random and 'L' for RID list access and only 'S' is counted towards Sequential threshold (my guess). [...]
8550 25 34_Re: Archive products/Chat Response10_Feeny, Jim23_Jim_Feeny@COMPUWARE.COM31_Thu, 30 Mar 2000 15:33:51 -0500647_iso-8859-1 Hi:
Have you considered File-AID/RDX from Compuware. The product primarily is used to extract related subsets of DB2 and/or VSAM data. However, it also works nicely as an archiving tool for DB2 data. Please see attached URL for use of File-AID/RDX as an archiving tool.
http://www.compuware.com/products/file/
Jim Feeny Product Manager Compuware Corporation
================================================ 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.
8576 26 22_IBM supplied RACF exit16_bat-chen zeliger16_bzeliger@EMC.COM31_Thu, 30 Mar 2000 15:42:23 -0500367_us-ascii Hi,
I'm thinking of externalizing DB2 authorizations to RACF, and was wondering if you folks are using the sample exit supplied by IBM or have you customized it?
I'm a little concerned to use a routine that resides in a SAMPLIB library. Should I be concerned or is this 'sample' fully supported by IBM ? anybody had any problems with it ? [...]
8603 96 46_Re: List prefetch questions - VPSEQT threshold14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Thu, 30 Mar 2000 14:52:40 -0500497_iso-8859-1 Larry,
VPSEQT - pages retrieved sequentially on behalf of list prefetch will be in the that area. It does not matter by what sequential method they were brought into the pool.
You query qualified the whole table. But due to statistics, the access path selected when using the host variables picked list prefetch. At run time, once 25% of the rids were qualified, you should have fallen over to a tablespace scan and would have seen the rows immediately from then on. [...]
8700 54 26_Re: IBM supplied RACF exit0_22_BILL_GALLAGHER@PHL.COM31_Thu, 30 Mar 2000 16:08:08 -0500553_us-ascii Bat-Chen,
I believe we are using the exit as it came in SAMPLIB, without any customization. Everything is working fine.
BIll Gallagher, DBA Phoenix Home Life Enfield, CT
bat-chen zeliger on 03/30/2000 03:42:23 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: BILL GALLAGHER/Phoenix Home Life Mutual Insurance) bcc: BILL GALLAGHER/Phoenix Home Life Mutual Insurance Subject: IBM supplied RACF exit [...]
8755 42 26_Re: IBM supplied RACF exit12_Terry Spikes21_terryspikes@YAHOO.COM31_Thu, 30 Mar 2000 13:08:38 -0800586_us-ascii If you're talking about DSNX@XAC, then yes we use it. If I remember correctly the only thing we did change was the "Classification Model Type" and the "DB2 Sub-System ID" parameters. No problems here.
Terry Spikes
--- bat-chen zeliger wrote: > Hi, > > I'm thinking of externalizing DB2 authorizations to RACF, and was > wondering if you folks are using the sample exit supplied by IBM or have > you customized it? > > I'm a little concerned to use a routine that resides in a SAMPLIB > library. > Should I be concerned or is this 'sample' [...]
8798 55 17_tcp/ip connection13_Jimmy Willett24_Jimmy.Willett@NCMAIL.NET31_Thu, 30 Mar 2000 16:22:38 -0500562_us-ascii I had DB2 UDB installed on Solaris server with windows nt clients. Then went thru the configuration from the client to the server connecting to the SAMPLE database. All went fine. Able to connect and retrieve data from the SAMPLE database. Then the Solaris ops rebooted their machine and since I have not been able to connect to the SAMPLE database. I can get to the Solaris from the NT using telnet and do some unix commands, but get SQL30081N communications error. I have looked at everything I can look at on the NT and all seems ok. However, I [...]
8854 56 21_Re: tcp/ip connection18_Gert van der Kooij15_geko@WANADOO.NL31_Thu, 30 Mar 2000 23:54:41 +0200552_iso-8859-1 Hi,
Try to connect to sample at your Solaris server. It will work or you will get the SQL1032 message. If you get the 1032 message db2 isn't started. 'su - ' to your instance owner and enter the db2start command. If the connect at the server works you have to check your db2diag.log for error messages related to the TCPIP protocol, it probably isn't started. If you can't find any messages that seems to be related check the port DB2 is listening at with the 'netstat' command. I don't know which options, can't try it at home. [...]
8911 152 46_Re: List prefetch questions - VPSEQT threshold0_34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM31_Thu, 30 Mar 2000 16:13:39 -0600575_us-ascii Richard - I took another look at the process and I found that I did have rid pool failure. As a retest, I then revised my keys and "only" qualified 150,000 rows. When I then reran the query, I saw the bufferpool being dominated by my process. I was looking at a bufferpool snapshot via Omegamon to determine the saturation of the bufferpool by the (tablespace) object that I was selecting from. Of course, the index object obeyed the limits of VPSEQT and remained only a rather small portion of the bufferpool. However the tablespace was occupying over half of [...]
9064 223 24_Re: V6 Migration problem12_Kirk Hampton16_khampto1@TXU.COM31_Thu, 30 Mar 2000 16:18:06 -0600597_us-ascii
Yep, I hit this, too. You have to apply fix PQ31611/UQ39371, or else you have to disable statement cache by setting the ZPARM DYNCACHE=NO.
Brunner Don J on 03/30/2000 07:16:45 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Kirk Hampton/Texas Utilities) Subject: V6 Migration problem
Before I give IBM a call, I'd like to know if anyone else has encountered this problem and come up with a resolution. [...]
9288 31 28_Alter Tablespaces in batches20_Chatterjee, Anindita28_Anindita.Chatterjee@NIKE.COM31_Thu, 30 Mar 2000 14:49:46 -0800366_us-ascii I have a question. supposing I want to alter tablespaces in a particular subsystem and I try to issue the alter commands in batches through a spufi; ie, I have a PDS member where I have all the -stop db(dbname) ts(tsname) statements and then all the alter statements and then all the -start db(dbname) ts(tsname) statements. will there be any problem? [...]
9320 54 32_Re: Alter Tablespaces in batches11_Suresh Sane21_data_arch@HOTMAIL.COM29_Thu, 30 Mar 2000 17:14:31 CST648_- This should work since STOP works synchronously in batch (alters will not be issued till stop is complete).
In any case, do you really need the stop? Several ts attributes can be altered without a stop in V5+.
Suresh
>From: "Chatterjee, Anindita" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Alter Tablespaces in batches >Date: Thu, 30 Mar 2000 14:49:46 -0800 > >I have a question. supposing I want to alter tablespaces in a particular >subsystem and I try to issue the alter commands in batches through a spufi; >ie, I have a PDS member where I [...]
9375 54 18_hot backup for DB211_James Drewe20_James.Drewe@AEXP.COM31_Thu, 30 Mar 2000 16:35:06 -0700443_- Martin
One performance consideration that you should think about is the potential disparities between the processors. When you bind a plan on one processor and it gets run on another processor, you may have access path surprises. Although this is true in a parallel sysplex environment as well, I understand that in Version 6 of DB2 (OS390), IBM has scaled down the weighted value of a processor ,s performance in the optimizer. [...]
9430 87 32_Re: Alter Tablespaces in batches20_Chatterjee, Anindita28_Anindita.Chatterjee@NIKE.COM31_Thu, 30 Mar 2000 15:40:03 -0800576_us-ascii > I am sorry. we will not be issuing stop and start commands from the spufi. > only the Alter statements. I wanted to know , if I am doing some thousands > of alter statements, will there be a problem. > the stop statement is not required, true, but we generally issue > it, so that the ts does not go into stop pending, in case anyone is using > it. > Anindita. > > -----Original Message----- > From: Manas Dasgupta [SMTP:manas.dasgupta@pfsfhq.com] > Sent: Thursday, March 30, 2000 3:23 PM > To: Anindita.Chatterjee@NIKE.COM > Subject: RE: Alter Tablespaces in [...]
9518 116 18_Re: MEMBER CLUSTER14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Fri, 31 Mar 2000 11:12:36 +1000449_us-ascii Both Rick and richard had good answers already.
A couple of additional points to explain what Member Clster actually does to solve the problem.
Since multiple members of a Data Sharing env. could be fighting each other to update the same space map page, and for BP coherency, page p-locks are used to negotiate who has control of the latest copy of a page at any point in time, too much elapsed time for this contention. [...]
9635 187 44_Re: migrate DB2 NT to DB2 AIX (same version)11_Chris Hardy17_hhardy@SWBELL.NET31_Wed, 29 Mar 2000 20:52:20 -0600504_iso-8859-1 Hi,,,,
You might want to look around @ vendors who claim the ability (functionality) & support to migration schema, data, RI's, object dependency, grants, security across (different & same) enterprise db & OS platforms.....
chris -----Original Message----- From: KUHN,Ulrich Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Date: Tuesday, March 28, 2000 9:37 PM Subject: Re: migrate DB2 NT to DB2 AIX (same version) [...]
9823 47 21_Re: tcp/ip connection7_revadee18_revadeev@SCB.CO.TH31_Fri, 31 Mar 2000 09:55:18 +0700443_iso-8859-1 Hi, Jimmy I'm not sure this is your point. In SQL30081N, there is reason code number that tell you about detail error of TCPIP. Are you check it?. And are you set about tcpip service both in nt client and solaris (db server) already?. At solaris (db server) you must set svcename in dbm cfg that match with service tcpip port on NT Client. And you must use db2set command to provide TCPIP protocol too. That's all you must do. [...]
9871 135 39_Re: Problem in - ssnm START DB2 Command13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM31_Fri, 31 Mar 2000 08:46:32 +0530445_us-ascii hi Chris !!
we are running os390 v 2.6 DB2 V 5.1 but the patch u specified is in which service level ... I mean month and year ??
Vishy
Chris Tee on 03/30/2000 06:09:44 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Viswanathan N/LTITL)
Subject: Re: Problem in - ssnm START DB2 Command [...]
10007 42 32_Re: Alter Tablespaces in batches14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Fri, 31 Mar 2000 14:03:46 +1000418_iso-8859-1 Anindita
- Prior to DB2 V6, each alter will log the complete before and after image of the DBD. This puts a big load on logging. It is possible that the logs will fill quicker than they can be archived, and you will notice periods when the system just stops - because it is busy archiving the oldest log. Batch the alters, so you can let any archiving complete before you submit the next batch. [...]
10050 127 32_Re: Alter Tablespaces in batches10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Fri, 31 Mar 2000 03:42:30 GMT523_us-ascii Hi Anindita, I think i know u as u were working with us some 1 year back. Now regarding ur question , i think if u won't issue the stop u might get a lots of contention in the DBD for those tablespaces.If ur STOP is not thru spufi/batches then it will be asynchronous and u have to wait till the time that stop commands drains all the calims.It might fail as well draining all the clain due to timeout issues.So, u can wither issue it in batch or u can write small rexx to check which all tablespaces stopped [...]
10178 38 32_Re: Alter Tablespaces in batches13_Aratos Sicyon25_aratos_sicyon@HOTMAIL.COM30_Fri, 31 Mar 2000 10:01:59 EEST545_- Hi Sanjeev.
This truly is meant to be polite so please don't take it the wrong way. I have difficulty reading your (very useful) postings because of the use of 'u' and 'ur'.
Thank you in advance for not being offended that I say this!
Aratos
Hi Anindita, I think i know u as u were working with us some 1 year back. Now regarding ur question , i think if u won't issue the stop u might get a lots of contention in the DBD for those tablespaces.If ur STOP is not thru spufi/batches then it will be asynchronous [...]
10217 57 65_Re: DB2-OS/390- Statistical Analysis of Tablespaces Index spaces.17_suthep thampranee18_suthepth@SCB.CO.TH31_Fri, 31 Mar 2000 14:23:17 +0700382_ISO-8859-1 Hi Jim I'm very interested. Please send me a copy Suthep Thampranee DBA SCB BANK
---------- > From: Joel Goldstein > To: DB2-L@RYCI.COM > Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces Index spaces. > Date: 9 Á¡ÃÒ¤Á 2543 0:02 > > Linda, > The Buffer Pool Tool from Responsive Systems is the only product that can [...]
10275 57 31_Re: DB2 V6 - Data Sharing - SAP22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Fri, 31 Mar 2000 09:01:54 +0000499_ISO-8859-1 Chris Hi.
I am putting Datasharing live in my SAP DB2 OS390 shop at the end of April .. we have been running with a DS envrionment in our shop for about 4 months now.
We will be going to V6 in June/July/August timeframe .. and we have a V6 installation up and running. I would however say that V6 at teh moment is not stable enough to go V6 DS in a SAP R3 environment .. but after June 1st a code base will be released that includes new functionality and is stable ... [...]
10333 56 32_Re: Alter Tablespaces in batches10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Fri, 31 Mar 2000 07:24:29 GMT469_us-ascii Hi Aratos, I am sorry and i will definitely try and correct this habit . But ,till i completely come out of this habit... for your(corrected..) information...
u --> YOU ur--> YOUR
Regards and good to see openness you have shown.
Sanjeev
Aratos Sicyon @RYCI.COM> on 03/31/2000 10:01:59 AM
Please respond to DB2 Data Base Discussion List [...]
10390 18 17_Shark DASD & DB2.0_20_rob_gould@UK.IBM.COM31_Fri, 31 Mar 2000 09:33:22 +0100475_us-ascii Hello, I seem to remember a while back people having problems with the Shark DASD and DB2 - does anyone know whether this has been fixed and/or whether there really is a problem anymore.
-=- Rob Gould -=- DB2 Sysprog.
================================================ 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.
10409 39 35_SQL/VSE 3.5 Problem with DB-restore15_Thomas Machovec26_thomas.machovec@AT.IBM.COM31_Fri, 31 Mar 2000 11:53:49 +0200434_iso-8859-1 Dear friends,
I tried to do a restore of my DB the first time and end in an error message
ARI0040 with modulename ARIYL22 and code=05
The restore job was started with STARTUP=R and LOGMODE=A and run well for a long time. First the DB-Directory was formated and restored, then the datafiles where formated and the reload begun. At the 6th of 7 volumes the job ended with the error mentioned above. [...]
10449 37 21_Re: Shark DASD & DB2.22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Fri, 31 Mar 2000 11:26:24 +0000478_ISO-8859-1 no more problems .. but you loose functionality so be aware ..
Les
______________________________ Reply Separator _________________________________ Subject: Shark DASD & DB2. Author: rob_gould@UK.IBM.COM at Internet Date: 3/31/00 9:33 AM
Hello, I seem to remember a while back people having problems with the Shark DASD and DB2 - does anyone know whether this has been fixed and/or whether there really is a problem anymore. [...]
10487 24 21_Re: Shark DASD & DB2.14_Massimo Scarpa16_mscarpa@CESVE.IT31_Fri, 31 Mar 2000 12:40:19 +0200525_us-ascii Hi Leslie, just a curiosity:
what do you mean with 'you loose functionality so be aware ..' ?
I heard rumours that some installation had problem with ESS, but
nothing about functionality loss.
Regards
Max Scarpa Data & System Admin
================================================ 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.
10512 93 39_Re: SQL/VSE 3.5 Problem with DB-restore4_IBM116_IBM1@UBIL.COM.TR31_Fri, 31 Mar 2000 14:36:12 +0300391_ISO-8859-9 hello thomas,
the message code is probably ARI0040E.
if it is so, look at the messages and codes under "DB2 for VSE System Control, if the DB2 abended you can actually look at message ARI0042I for a little more info.
ARIYL22 is actually the name of the limit error, I looked through them for your error but just like yourself, I could not find anything. [...]
10606 164 18_Re: MEMBER CLUSTER13_Adrian Savory24_adrian.savory@ZURICH.COM31_Fri, 31 Mar 2000 13:17:22 +0100494_us-ascii Michael,
That's interesting. I used to work at a site where we defined MEMBER CLUSTER on a set of tablespaces in preparation for data sharing. These tablespaces were very volatile, containing transient data and critical to the performance of the system (SAP's asynchronous update protocol tables for anyone who's interested!). These objects were 'ring-fenced' in their own virtual pool to give maximum coverage and we also ensured that all access paths were via the index. [...]
10771 105 21_Re: Shark DASD & DB2.9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Fri, 31 Mar 2000 13:29:27 +0100377_us-ascii Dog, This is the flash we received from IBM when enquiring about these problems. We have been running with Shark, in development for over a month and go into production next week. No problems so far.
|---------------| |February 9, | |2000 | |---------------|
Classification: This flash is unclassified and may be given to customers. [...]
10877 77 22_Re: hot backup for DB220_Beighton-Dykes, Hugh27_hugh.beighton-dykes@EDS.COM31_Fri, 31 Mar 2000 14:06:24 +0100323_iso-8859-1 Just binding on one processor and running on another shouldn't in itself lead to any surprises I think, though I agree this is something to bear in mind when and if the plans are rebound. Anyway I guess if you are planning to run for up to a month with the new configuration then it must be pretty similar. [...]
10955 68 32_Re: Alter Tablespaces in batches12_Kirk Hampton16_khampto1@TXU.COM31_Fri, 31 Mar 2000 07:20:29 -0600415_us-ascii I second James' recommendation on having frequent COMMIT's in among the ALTER's. I recently did this to ALTER several thousand tablespaces and index spaces from one bufferpool to another, with COMMIT's about every 100 ALTER's. And having done it both ways, may I also suggest you use your PDS members as input to a batch job running DSNTEP2 instead of SPUFI, it ran many times faster for me than TSO. [...]
11024 39 31_-818 error in DCLGEN from SPUFI17_Luke G. Bauerlein24_lbauerlein@MANDTBANK.COM31_Fri, 31 Mar 2000 08:25:55 -0500338_US-ASCII DB2 sysprogs, Developer receives following message after migration from V4 to V5 upon first execution of DB2I option 2 DCLGEN. DSNTIJSG job binds package DSNEDCL member DSNECP68 from DSDNDBRM. Bind runs successfully but I still get a time stamp mismatch. Any ideas ? Thanks in advance, Luke
BINDPARMS are as follows: [...]
11064 184 18_Re: MEMBER CLUSTER22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Fri, 31 Mar 2000 14:24:26 +0000800_ISO-8859-1 ...The VBLOG tables are too dynamic for member cluster .. insert/delete/insert/delete hundreds of times/second.
Les (from that previous site) :-)
______________________________ Reply Separator _________________________________ Subject: Re: MEMBER CLUSTER Author: Adrian Savory at Internet Date: 3/31/00 1:17 PM
Michael,
That's interesting. I used to work at a site where we defined MEMBER CLUSTER on a set of tablespaces in preparation for data sharing. These tablespaces were very volatile, containing transient data and critical to the performance of the system (SAP's asynchronous update protocol tables for anyone who's interested!). These objects were 'ring-fenced' in their own virtual pool to give maximum [...]
11249 58 35_Re: -818 error in DCLGEN from SPUFI12_craig patton21_prgpatton@HOTMAIL.COM29_Fri, 31 Mar 2000 05:32:50 PST291_- Luke, Double check your SPUFI options and make sure you are executing the correct plan. (Isolation defaults to RR in SPUFI and if you do NOT bind the RR SPUFI plan, then you get the -818) If this is YOUR case, you can test by changing the Isolatino to CS then try to get into DCLGEN. [...]
11308 104 35_Re: -818 error in DCLGEN from SPUFI17_Luke G. Bauerlein24_lbauerlein@MANDTBANK.COM31_Fri, 31 Mar 2000 08:41:23 -0500456_US-ASCII I found the problem from a past posting to this list which I saved (Dionne Warwick would be interested as to why). The text follows: Thanks to Bing Alabata.
Using Tape 9906 in our V4 to V5 migration, we encountered the same error on running DSNTEJ2C (COBOL IVP job). As in your case, the DSNTIJSG ran OK. On closer examination, the V5 DSNTIJSG did not contain a BIND PLAN(DSNEDCL)... for DCLGEN. It did have a BIND PACKAGE(DSNEDCL)... [...]
11413 92 39_Re: SQL/VSE 3.5 Problem with DB-restore4_IBM116_IBM1@UBIL.COM.TR31_Fri, 31 Mar 2000 16:47:27 +0300513_ISO-8859-9 > hello thomas, > > the message code is probably ARI0040E. > > if it is so, look at the messages and codes under "DB2 for VSE System > Control, if the DB2 abended you can actually look at message ARI0042I for > a little more info. > > ARIYL22 is actually the name of the limit error, I looked through them for > your error but just like yourself, I could not find anything. > > Could you have written it wrongly and could it be ARIYI22 instead? if it > is so, the manual reads "not enough storage [...]
11506 43 31_-206 SQLCODE after System Crash0_22_BILL_GALLAGHER@PHL.COM31_Fri, 31 Mar 2000 09:31:51 -0500343_us-ascii Hi,
We experienced a rather severe and ugly system outage yesterday when somebody accidentally hit the big "emergency power off" button in the data center yesterday. We finally got all our systems back up after a couple of hours, but we are now experiencing a very unusual problem in our test DB2 data sharing subsystems. [...]
11550 166 18_Re: MEMBER CLUSTER20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Fri, 31 Mar 2000 09:36:27 -0500448_iso-8859-1 The segmented tablespace have a different spacemap structure than that of MEMBER CLUSTER and that is why SEGSIZE & MEMBER CLUSTER are mutually exclusive.
The spacemap can have up to 199 pages representation per spacemap for MEMBER CLUSTER. If a spacemap is available then it can be used by any members in a data-sharing group. Only when there is contention of the spacemap or the spacemap is full, a new spacemap is created. [...]
11717 48 21_Re: Shark DASD & DB2.0_19_csutfin@AMSOUTH.COM31_Fri, 31 Mar 2000 08:38:25 -0600458_- Rob
We are running both development and production DB2 on Shark Dasd. We have had the development subsystem on ESS for over two months and production for about a month.
We have not encountered any problems so far. (knock, knock)
Carol Sutfin Corporate DBA AmSouth Bank NA
rob_gould@UK.IBM.COM on 03/31/2000 02:33:22 AM
Please respond to DB2 Data Base Discussion List [...]
11766 111 32_Re: Alter Tablespaces in batches20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Fri, 31 Mar 2000 09:44:20 -0500301_us-ascii If you have protected threads from CICS then you may have problems both during stop as well as alter unless you issue -STOP AT(COMMIT). AT(COMMIT) will be able to break your protected thread else you will not be able to stop the tablespace or alter until the protected thread is purged. [...]
11878 47 39_FW: SQL/VSE 3.5 Problem with DB-restore13_Morrill, John12_JohnM@VP.NET31_Fri, 31 Mar 2000 07:55:14 -0700670_iso-8859-1 -----Original Message----- From: thomas.machovec@AT.IBM.COM [mailto:thomas.machovec@AT.IBM.COM] Sent: Friday, March 31, 2000 2:45 AM To: DB2-L-request@RYCI.COM Subject: SQL/VSE 3.5 Problem with DB-restore
Dear friends,
I tried to do a restore of my DB the first time and end in an error message
ARI0040 with modulename ARIYL22 and code=05
The restore job was started with STARTUP=R and LOGMODE=A and run well for a long time. First the DB-Directory was formated and restored, then the datafiles where formated and the reload begun. At the 6th of 7 volumes the job ended with the error mentioned above. [...]
11926 48 21_Re: Shark DASD & DB2.22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Fri, 31 Mar 2000 15:53:21 +0000275_ISO-8859-1 I think it is to do with Snaps and the alike ..... I believe there are limitations ... but I will also say that the hardware is amazingly fast and does do what it says ..
There were problems with ESS and I do believe these have now been sorted by IBM. [...]
11975 230 46_Re: List prefetch questions - VPSEQT threshold14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Fri, 31 Mar 2000 09:05:14 -0500497_iso-8859-1 Larry,
Re: 1 - always set up BPs by common use, but pages coming in from list prefetch are sequential so it just needs to be a sequential pool (except for the index access). Your pool of 15% sequential with only a random HP would be really ugly for a large list prefetch or any heavy sequentially scanning. You could balance that particular pool by leaving the HP random (wonderful idea - wish I could get more to do that), but upping the VPSEQT on the base BP much higher. [...]
12206 77 21_Re: Shark DASD & DB2.13_Adrian Savory24_adrian.savory@ZURICH.COM31_Fri, 31 Mar 2000 16:01:50 +0100746_us-ascii Certainly when Sharks were first announced they did not support Snapshot, although the intention was that they would at some time in the future. Don't know if that's the case yet.
Adrian
|--------+---------------------------------------------> | | Leslie Pendlebury-Bowe | | | | | | | | | 31/03/00 16:53 | | | Please respond to DB2 Data Base | | | Discussion List | | | | |--------+---------------------------------------------> >---------------------------------------------------------| | | | To: DB2-L@RYCI.COM | | cc: (bcc: Adrian Savory/ZI/England/Zurich) | | Subject: Re: Shark DASD & DB2. | >---------------------------------------------------------| [...]
12284 25 15_Index Screening12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Fri, 31 Mar 2000 07:23:57 PST586_- Hi folks:
I would like to hear your explanation about how does Index Screening work? . I read something but it had a brief explanation about it. Thanks a lot for your help,
harbry
______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com
================================================ 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.
12310 24 32_What is best DB2 Monitoring Tool10_ajay kumar19_db2v5r1@HOTMAIL.COM29_Fri, 31 Mar 2000 20:56:52 IST300_- Hi
We are using DB2 V5R1 and started to use for production environment, I would like to know what is the best monitoring tool to check the DB2 threads, performance and Lock & Latch information. Would like to use the tool to kill the long standing threads too.
Is DB2 PM good ?.. [...]
12335 69 19_Re: Index Screening20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Fri, 31 Mar 2000 10:35:27 -0500539_us-ascii Consider following example -
SELECT ... FROM TABLE_A WHERE C1 = :H AND C2 > :H AND C3 = :H
The index on TABLE_A has 3 columns C1,C2,C3
Cardinality for C1 = 10 Cardinality for C1 & C2 = 500 Cardinality for C1 & C3 = 400
The explain will show you that index is used with match col = 2 and no list-prefetch is used. The DB2 will traverse through tree-structure but since only values for C1 & C2 are known it can't use C3. However DB2 can filter down # of RIDs selected by applying C3 predicate where [...]
12405 12 32_segmented to partitioned tblspac0_27_Bud.Greenman@ONONDAGA.NY.US31_Fri, 31 Mar 2000 10:54:01 -0500446_- I need to change some segmented tablespaces to partitioned with 3 partitions each. There is one table with on delete cascade RI on one of the tables to be changed. What would be the best way to do this?
================================================ 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.
12418 110 19_Re: Index Screening17_Nagaraj Pudukotai25_Nagaraj.Pudukotai@WDR.COM31_Fri, 31 Mar 2000 17:15:32 +0100495_us-ascii Hi Venkat
Because C3 is part of the index why dosen't DB2 use C3 during index screening?. C3 is known (C3 =:H) in the select clause?. Am I missing something obvious?. Or did you mean C1,C2 are only part of the index and not C3?.
Thanks and Regards
Nagaraj
______________________________ Reply Separator _________________________________ Subject: Re: Index Screening Author: venkat.pillay (venkat_pillay@ML.COM) at unix,mime Date: 31/03/00 16:35 [...]
12529 45 36_Re: segmented to partitioned tblspac12_craig patton21_prgpatton@HOTMAIL.COM29_Fri, 31 Mar 2000 08:16:40 PST428_- Bud, I am sure you will get many answers for this one. 2 ideas: 1 - Temporarily drop the RI constraint on the child table, then add it back when done and run your CHECK DATA utility. OR 2 - Unload the the foreign key table along with the others, then Drop/recreate/load the all the tables with the child table being the first table dropped, and the last loaded. This would be easiest unless you have cyclical RI defined. [...]
12575 135 19_Re: Index Screening20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Fri, 31 Mar 2000 11:47:17 -0500578_iso-8859-1 Probably you misunderstood me. I said C3 is used for index-screening unless you have a list-prefetch ( & lower version of DB2).
> -----Original Message----- > From: Nagaraj Pudukotai [SMTP:Nagaraj.Pudukotai@WDR.COM] > Sent: Friday, March 31, 2000 11:16 AM > To: DB2-L@RYCI.COM > Subject: Re: Index Screening > > Hi Venkat > > Because C3 is part of the index why dosen't DB2 use C3 during > index > screening?. C3 is known (C3 =:H) in the select clause?. Am I missing > something obvious?. Or did you mean C1,C2 are only part of the index > and not C3?. > [...]
12711 151 32_Re: Alter Tablespaces in batches20_Chatterjee, Anindita28_Anindita.Chatterjee@NIKE.COM31_Fri, 31 Mar 2000 08:47:51 -0800557_iso-8859-1 Sanjeev, Thanks. we were wondering whether there will be log offloads or not.
how are u? I keep seeing ur mails in the list discussion. so , u are doing a lot of studies. Anindita.
> -----Original Message----- > From: Sanjeev .. [SMTP:ssethi@LOT.TATASTEEL.COM] > Sent: Thursday, March 30, 2000 7:43 PM > To: DB2-L@RYCI.COM > Subject: Re: Alter Tablespaces in batches > > Hi Anindita, > I think i know u as u were working with us some 1 year back. > Now regarding ur question , i think if u won't issue the stop u might get > a [...]
12863 49 36_Re: What is best DB2 Monitoring Tool11_Chris Hardy17_hhardy@SWBELL.NET31_Fri, 31 Mar 2000 10:55:46 -0600458_iso-8859-1 Hi,
Not sure about "the BEST" db2 monitoring tool but do look at Detector & Thread Terminator..... latch suspensions (waits) per plan/program/sql call, lock state, type, IRLM lock request etc...
chris
-----Original Message----- From: ajay kumar Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Date: Friday, March 31, 2000 9:25 AM Subject: What is best DB2 Monitoring Tool [...]
12913 61 32_Re: Alter Tablespaces in batches20_Chatterjee, Anindita28_Anindita.Chatterjee@NIKE.COM31_Fri, 31 Mar 2000 09:03:03 -0800572_us-ascii James, Thanks . this was what I was looking for. I had done it once long back and faced the problem. Anindita.
> -----Original Message----- > From: James Campbell [SMTP:James.Campbell@HANCORP.COM.AU] > Sent: Thursday, March 30, 2000 8:04 PM > To: DB2-L@RYCI.COM > Subject: Re: Alter Tablespaces in batches > > Anindita > > - Prior to DB2 V6, each alter will log the complete before and after image > of the DBD. This puts a big load on logging. It is possible that the > logs > will fill quicker than they can be archived, and you will notice periods [...]
12975 192 19_Re: Index Screening19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Fri, 31 Mar 2000 11:46:42 -0600527_iso-8859-1 Hi all, Here's definition of matching index scan that may help. Also note exceptions for List Prefetch and MX access associated with an IN-list. See DB2 for OS/390, V5, Admin. Guide, bookmanager ref. 5.10.3.3.1, Matching Index Scan (MATCHCOLS>0).
" Look at the index columns from leading to trailing. For each index column, if there is at least one indexable Boolean term predicate on that column, it is a match column. (See "Properties of Predicates" in topic 5.8.2.1 for a definition of Boolean term.) [...]
13168 214 18_Re: MEMBER CLUSTER17_Nagaraj Pudukotai25_Nagaraj.Pudukotai@WDR.COM31_Fri, 31 Mar 2000 19:12:47 +0100544_iso-8859-1 Hi Venkat
For example spacemap page S1 covers data pages 5 thru 150, S2 covers data pages 152 thru 300, S3 covers 302 thru 450. If two processes from two data-sharing members want to insert rows into pages 152 thru 300, then there would be a contention for spacemap page S2. In this case will a new space map page Sx be created and given to one member and S2 given to the other member. And will Sx now cover say pages 226 thru 300 and S2 covers 152 thru 224?. If so to what extent this splitting goes?. ( [...]
13383 60 36_Re: Your -206 SQLCODEs might be ....0_22_BILL_GALLAGHER@PHL.COM31_Fri, 31 Mar 2000 13:14:06 -0500552_us-ascii Roy,
That's exactly what our problem was, we just resolved it about an hour ago after IBM pointed us in this direction. Apparently, our DB2 sysprog applied some maintenance earlier this week that would have been picked up over the weekend when we cycled the subsystems. Instead, the crash we experienced yesterday changed out schedule somewhat. One of the modules affected by the maintenance was DSNXGRDS. We also have Hourglass in the *DBM1 STEPLIB, and apparently we were picking up the old, unmaintained version of this module. [...]
13444 258 18_Re: MEMBER CLUSTER20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Fri, 31 Mar 2000 13:22:57 -0500333_iso-8859-1 No.. there is no splitting between spacemaps. If S2 has contention than one member will move to a different spacemap which has space available. 199 pages per spacemap they don't split the page range. 200 onwards will have a different spacemap. It is just like non-partitioned spacemap except it covers only 199 page. [...]
13703 18 36_Re: Your -206 SQLCODEs might be ....14_Roy R Reynolds20_Roy_Reynolds@GAP.COM31_Fri, 31 Mar 2000 10:55:07 -0800291_us-ascii Bill, Sorry about the timing. I'm in San Bruno, CA, a few hours away. I seem to get beeped when anything in the world goes haywire, so I'm surprised your company didn't get me out of bed in the wee hours to add my 2cents worth at the right time . Glad you solved it. Roy [...]
13722 18 21_Re: Shark DASD & DB2.25_Edward(Ed) J. Finnell,III23_efinnell@SEEBECK.UA.EDU31_Fri, 31 Mar 2000 13:14:43 -0600568_us-ascii There were new announcements on Tuesday regarding the Sharks and the new "F" models, internally about 75% faster transfer, CACHE upped to 16GB, and some interesting connections for SAN solutions. Further information as to "Feature" delivery schedules for the coming months. www.ibmlink.ibm.com click on Announcements.
================================================ 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.
13741 25 24_Add DB Operation Fails!!16_Dempsey, Michael20_MDempse@UNCH.UNC.EDU31_Fri, 31 Mar 2000 14:16:30 -0500385_iso-8859-1 Hey Folks... I'm trying to add a database through the CCA. When I finish, it tells me... Add Database Operation Failed SQL1317N The local database name already exisits in the database connection services directory.
When I look at the available databases screen, the database I'm trying to add is not there! Any idea as to how I can remove this entry?? Thanks... [...]
13767 42 28_Re: Add DB Operation Fails!!13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Fri, 31 Mar 2000 13:35:36 -0600461_US-ASCII Hello Michael, Either use the CLP or Command Center and issue the UNCATALOG command. ex. UNCATALOG DB XXXXXXXX where xxxxxxx is the db name. HTH Kurt
>>> "Dempsey, Michael" 03/31/00 01:16PM >>> Hey Folks... I'm trying to add a database through the CCA. When I finish, it tells me... Add Database Operation Failed SQL1317N The local database name already exisits in the database connection services directory. [...]
13810 18 32_DB2 Connectivity with SNA Server10_Parry, Dan17_DAN.PARRY@SSA.GOV31_Fri, 31 Mar 2000 14:43:02 -0500344_iso-8859-1 Does anyone have experience using Microsoft's OLE DB provider for DB2 OS/390 (the one packaged with SNA Server)? We've been using DB2 Connect EE running with SNA Server for the past couple of years and Microsoft is now telling our management that we no longer need DB2 Connect. Any thoughts or experiences would be appreciated. [...]
13829 43 28_Re: Add DB Operation Fails!!13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Fri, 31 Mar 2000 13:51:51 -0600502_US-ASCII Sorry, I meant to say CATALOG Either use the CLP or Command Center and issue the CATALOG DB command. ex. CATALOG DB XXXXXXXX where xxxxxxx is the db name. This will get your DB recataloged. HTH Kurt
>>> "Dempsey, Michael" 03/31/00 01:16PM >>> Hey Folks... I'm trying to add a database through the CCA. When I finish, it tells me... Add Database Operation Failed SQL1317N The local database name already exisits in the database connection services directory. [...]
13873 63 32_DB2 3 Day Symposium in St. Louis14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Fri, 31 Mar 2000 14:06:16 -0500360_iso-8859-1 DB2 Symposium Education Event ** St. Louis, MO April 12th-14th **
Other schedules at end of message for: US, Europe, Africa, Australia, New Zealand, Singapore
Wednesday, April 12th DB2 Internal and Performance - Klaas Brant DB2 Version 6 for OS/390 Impacts on Performance - Richard Yevich Advanced and Complex SQL - Sheryl Larsen [...]
13937 54 28_Re: Add DB Operation Fails!!16_Dempsey, Michael20_MDempse@UNCH.UNC.EDU31_Fri, 31 Mar 2000 15:16:51 -0500461_iso-8859-1 Hey Kurt... Many thanks.. That did the trick!!
-----Original Message----- From: Kurt Sahlberg [mailto:Kurt.Sahlberg@EXPERIAN.COM] Sent: Friday, March 31, 2000 2:52 PM To: DB2-L@RYCI.COM Subject: Re: Add DB Operation Fails!!
Sorry, I meant to say CATALOG Either use the CLP or Command Center and issue the CATALOG DB command. ex. CATALOG DB XXXXXXXX where xxxxxxx is the db name. This will get your DB recataloged. HTH Kurt [...]
13992 63 35_Re: -818 error in DCLGEN from SPUFI38_Enarson, Mike (CC-Application Support)24_Mike.Enarson@CONAGRA.COM31_Fri, 31 Mar 2000 15:30:09 -0600414_iso-8859-1 I also ran into this problem way back when. You need to do A FREE PLAN first to get rid of the DBRM before adding it back in as a package. Version 5 converted those programs used by DCLGEN, spufi etc. to packages, but when you execute the program I think it is picking up the old DBRM and of course the timestamps for the DBRM (probably from version 4) and your version 5 load module do not match. [...]
14056 68 30_Re: Obsolete SYSIBM Databases?19_Saunders, William C27_William_Saunders@CGUUSA.COM31_Fri, 31 Mar 2000 16:36:36 -0500571_- As far as I can remember, DSNCV was used by Catalog Visibility, which appeared in Version 2.3 and slipped quietly into the night in Version 3. I guess part of going quietly is not telling anyone that they can drop the database.
> -----Original Message----- > From: sjvagnier@AEP.COM [SMTP:sjvagnier@AEP.COM] > Sent: Thursday, March 30, 2000 11:26 AM > To: DB2-L@RYCI.COM > Subject: Re: Osolete SYSIBM Databases? > > Hi Bernie, > > DSNCV and DSNDDF are no longer used by DB2 for OS/390 V5. > > DSNRGFDB and DSNRLST are still used by DB2 for OS/390 V5. > > > [...]
14125 89 30_Re: Obsolete SYSIBM Databases?38_Enarson, Mike (CC-Application Support)24_Mike.Enarson@CONAGRA.COM31_Fri, 31 Mar 2000 15:46:38 -0600417_iso-8859-1 Actually, I think it was documented in the version 3 install manual. It has been a while, but I think it was somewhere in the chapter on Migration to version 3 procedures.
Regards Mike Enarson
-----Original Message----- From: Saunders, William C [mailto:William_Saunders@CGUUSA.COM] Sent: Friday, March 31, 2000 3:37 PM To: DB2-L@RYCI.COM Subject: Re: Obsolete SYSIBM Databases? [...]
14215 37 43_DB2/MVS V4 distributed performance question11_Hilton Tina15_HiltonT@TCE.COM31_Fri, 31 Mar 2000 08:13:35 -0500574_iso-8859-1 We upgraded to V4 last weekend, and we've been having performance problems with a distributed application since then. We've always had problems with this application, but it wasn't causing this much trouble last week. The application was written with SQL*Windows, which I've been told generates the SQL based upon criteria entered by the user. A lot of the SQL is nasty (one is a 4 table join with subselects 2 or 3 deep). They can't change the SQL since it is generated, so that's not an option. Don't ask me why it was allowed to go into production in the [...]
14253 119 35_Re: -818 error in DCLGEN from SPUFI12_Bing Alabata25_bing.alabata@MCMASTER.COM31_Fri, 31 Mar 2000 18:13:42 -0600465_us-ascii Just an addendum to my initial posting on this -818 DCLGEN issue:
Mike is right. If you rerun the DB2 installation clist with an install option, it will generate a
BIND PLAN(DSNEDCL) PKLIST(DSNEDCL.DSNECP68) - ISOLATION(CS) ACTION(REPLACE)
in the DSNTIJSG installation job which will not be the case with a migration option. Thus, if you installed (vs. migrated) DB2 V4, you will not encounter the -818 error when running DCLGEN. [...]