1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l June 2005, week 5
2 87 43_Re: Z/OS QMF & DB2 connect - unicode issues18_McAuliffe, Stephen35_Stephen.McAuliffe@BANKOFAMERICA.COM31_Wed, 29 Jun 2005 09:13:12 +0100568_iso-8859-1 Jamie,
May not be of use, but I had a similar error when testing the JDBC driver to the host, it seems that the full set of Java character sets wasn't installed on my machine.
I think it was this one..jre/lib/charsets.jar
Cheers, Steve McAuliffe Tel: (020) 8760 6988 Internal: x 66988
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jaime Fernandez Sent: 28 June 2005 17:54 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Z/OS QMF & DB2 connect - unicode issues [...]
90 51 16_GSE Requirements12_Kornelis Abe26_a.kornelis@PINKROCCADE.COM31_Wed, 29 Jun 2005 14:05:54 +0200389_iso-8859-1 Hello all,
Just wondering if anyone here has any experience using the Requirements system deployed by GSE/SHARE - because I'm having some troubles with it.
I entered my first requirement in the REQS_DATA_DB2 area. IIRC, the requirement was to be checked, and I'd receive a notification by e-mail within - I think - two weeks. I never received such an e-mail. [...]
142 435 27_Re: Confused - DB2 v8.2 AIX9_Barry Leb17_bjleb@HOTMAIL.COM31_Wed, 29 Jun 2005 08:19:26 -0400661_- DMS file. Here's the table layouts.
CREATE TABLE "xxxxx "."tab1" ( "MANDT" CHAR(3) NOT NULL WITH DEFAULT '000' , "AUFNR" VARCHAR(12) NOT NULL WITH DEFAULT ' ' , "GLTRP" VARCHAR(8) NOT NULL WITH DEFAULT '00000000' , "GSTRP" VARCHAR(8) NOT NULL WITH DEFAULT '00000000' , "FTRMS" VARCHAR(8) NOT NULL WITH DEFAULT '00000000' , "GLTRS" VARCHAR(8) NOT NULL WITH DEFAULT '00000000' , "GSTRS" VARCHAR(8) NOT NULL WITH DEFAULT '00000000' , "GSTRI" VARCHAR(8) NOT NULL WITH DEFAULT '00000000' , "GETRI" VARCHAR(8) NOT NULL WITH DEFAULT '00000000' , "GLTRI" VARCHAR(8) NOT NULL WITH DEFAULT '00000000' , "FTRMI" VARCHAR(8) NOT NULL WITH DEFAULT '00000000' , [...]
578 161 178_Re: DB2 Admin Client v8.1 Fixpack 6B os(win2003) thru sun gateway DB2 Connect EE v8.1 fixpack 6b to z/os 1.4 V7.1 DB2 - connection error sql30081 rc:11004 if hostname, 10060 w/ip14_Martin Flavell18_mflavell@I-TCS.COM31_Wed, 29 Jun 2005 13:39:18 +01006_UTF-8
740 124 37_Re: Converting Catalog to SMS managed14_Mark E Vickers26_MarkVickers@GROCERYBIZ.COM31_Wed, 29 Jun 2005 07:50:25 -0500454_US-ASCII Thanks Jim and Basivi, we are hoping to get FlashCopy soon and I will get together with my Sysprog to plan the pool setup.
JTonchick@AOL.COM Sent by: DB2 Data Base Discussion List 06/28/2005 11:12 PM Please respond to DB2 Database Discussion list at IDUG
To DB2-L@WWW.IDUGDB2-L.ORG cc
Subject Re: Converting Catalog to SMS managed [...]
865 25 14_Re: DDF Tuning19_Luis Enrique Valdez27_evaldez@BANCOFRANCES.COM.AR31_Wed, 29 Jun 2005 08:08:41 -0500408_- Hi Bob:
We suffered similar trouble in our site (OS/390 2.10 and DB2 V7.1). Our OS/390 system programmer did some 'tweaking' with WLM. It's not actually a 'tweak' but a series of steps to declare and assign certain service classes to your DDF activity. These steps are well documented in section 3.4 (WLM setup) of the Redbook "Distributed Functions of DB2 for z/OS and OS/390" (SG24-6952-00). [...]
891 104 55_Why so much Service Task Wait time? - DB2 V7.2 for z/OS11_Jay Reavill23_Jay.Reavill@CERTEGY.COM31_Wed, 29 Jun 2005 10:45:46 -0400477_us-ascii Hello All,
I'm a bit perplexed as to why we are seeing Omegamon reporting that a read-only program is consistently spending the majority of it's time in DB2 Service Task Wait time? There are no commits and only one read-only cursor issued by this program. No datasets are being opened/closed/recalled. There are other programs involved in this thread, but this is the only one with a large Service Task Wait time. Any insight would be greatly appreciated. [...]
996 15 11_z/os v8 oam10_Bill Brown21_db2_dba@BELLSOUTH.NET31_Wed, 29 Jun 2005 09:48:31 -0500463_- we are looking at partitioning our oam tablespaces. the current clustering index on both the 4k and 32k tablespace is otclid and otname. i am leaning heavily toward partitioning on otname since it is essentially a timestamp and data will be added to the end of the existing data. has anyone switched the columns in the clustering index to be otname and otclid? or has anyone, in db2 v8, used table partitioning using otname and leaving the index the same? [...]
1012 172 59_Re: Why so much Service Task Wait time? - DB2 V7.2 for z/OS12_Ray Williams23_Ray.Williams@UNITED.COM31_Wed, 29 Jun 2005 10:19:18 -0500555_ISO-8859-1 Does Omegamon include Other Service Wait time in Service Task Wait Time? If so you might be CPU constrained. . . . You may be waiting on CPU. I'm guessing because of your CPU to Elapsed ratio.
Ray Williams - WHQKO United Airlines Database Administration (847) 700-4359
-----Original Message----- From: Jay.Reavill@CERTEGY.COM [SMTP:Jay.Reavill@CERTEGY.COM] Sent: Wednesday, June 29, 2005 9:46 AM To: DB2-L@www.idugdb2-l.org Cc: Jay.Reavill@CERTEGY.COM Subject: [DB2-L] Why so much Service Task Wait time? - DB2 V7.2 for z/OS [...]
1185 13 67_Re: DB2 Z/Os Version 8 Compatibility Mode & 3rd Party Tools Support12_Richard Link16_linkr@BCBSIL.COM31_Wed, 29 Jun 2005 10:24:11 -0500558_- For us, the extracts will not run under V8 compatility mode. Explain still functions.
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
1199 253 59_Re: Why so much Service Task Wait time? - DB2 V7.2 for z/OS13_Richard Fazio21_rfazio@TRANSUNION.COM31_Wed, 29 Jun 2005 11:00:06 -0500407_US-ASCII Are you sure DB2 knows the cursor is "read only". If ambiguous, a "FOR FETCH ONLY" may help with lock avoidance. I'm assuming this is a batch process (if CICS, this could easily be attributed to delays in a task switch).
Also, is this read only job the first process run after a major delete. If so, you may be going through the "garbage collection" process to clean up pseudo deletes. [...]
1453 61 15_Re: z/os v8 oam12_Kirk Hampton28_khampto1@CAPGEMINIENERGY.COM31_Wed, 29 Jun 2005 11:10:07 -0500456_us-ascii Hello Bill, Yes, we partitioned some of our 32K OAM tables on OTNAME,OTCLID,OTSEG and it has been working just fine for us for about 4 years now. Our 4k tables are unused by the application (OnDemand/390), so we did not bother with them. We actually supply only the first 12 or so characters of OTNAME as the LIMITKEY, after analysis of how OnDemand populates the OTNAME column, and that got us down to the month part of the date, I believe. [...]
1515 196 59_Re: Why so much Service Task Wait time? - DB2 V7.2 for z/OS13_Martin Packer24_martin_packer@UK.IBM.COM31_Wed, 29 Jun 2005 17:25:38 +0100711_US-ASCII A (relevant) question on this: Is this a DB2 on z/OS DDF requester?
Martin
Martin Packer, MBCS CITP Martin Packer/UK/IBM 020-8832-5167 in the UK (+44) (MOBX 273643, Internal 7-325167, Mobile 07802-245584)
"Las cosas de palacio van despacio"
External Blog: http://www-128.ibm.com/developerworks/blogs/dw_blog.jspa?blog=476 Internal Blog: http://barney.adtech.internet.ibm.com/pilot/weblogs/comments/martin_packer@uk.ibm.com
Ray Williams To Sent by: DB2 Data DB2-L@WWW.IDUGDB2-L.ORG Base Discussion cc List Re: [DB2-L] Why so much Service Task Wait time? - DB2 V7.2 for z/OS 29-06-05 16:19 [...]
1712 256 59_Re: Why so much Service Task Wait time? - DB2 V7.2 for z/OS11_Jay Reavill23_Jay.Reavill@CERTEGY.COM31_Wed, 29 Jun 2005 12:46:09 -0400446_us-ascii No, it is local TSO batch. Also, in reference to the other responses so far... Yes, we are CPU constrained and yes, there is a considerable amount of delete activity on the tables involved. So both of these could be legitimate issues.
---------------------------------------- Jay Reavill DBA Certegy Card Services 11601 Roosevelt Blvd. St. Petersburg, FL. 33716 Office (727) 227-2144 ---------------------------------------- [...]
1969 45 27_Re: Confused - DB2 v8.2 AIX9_Barry Leb17_bjleb@HOTMAIL.COM31_Wed, 29 Jun 2005 13:06:16 -0400522_- Number of pages is coming from 2 places, npages and fpages from syscat.tables. Also from reorgchk. I've done the reorg and nothing changes. All the tables are in the same DMS tablespace along with 100's of additional tables. I just happen to choose these three as an example. This is a migrated system for testing purposes from Informix to DB2 support an SAP installation. This is the result immediately post migration. No activity on the tables since. Again, reorg's change nothing appreciably. Thus my confusion. [...]
2015 48 42_Free Data Integrity and Compliance Seminar16_Craig S. Mullins23_craig@CRAIGSMULLINS.COM31_Wed, 29 Jun 2005 12:01:49 -0500461_- Worried about regulatory compliance? Unsure of how to provide data integrity amid the daily tumult of data manipulation, transformation and administration? Interested in a free seminar on database management and regulatory compliance?
Data, database integrity and management processes have multimillion-dollar implications. And you need robust, intelligent and automated techniques to assure the integrity of your valuable corporate data. [...]
2064 193 46_Re: Free Data Integrity and Compliance Seminar14_Mark E Vickers26_MarkVickers@GROCERYBIZ.COM31_Wed, 29 Jun 2005 12:14:48 -0500710_US-ASCII TRY THIS LINK:
http://www.craigsmullins.com/seminars.html
"Craig S. Mullins" Sent by: DB2 Data Base Discussion List 06/29/2005 12:01 PM Please respond to DB2 Database Discussion list at IDUG
To DB2-L@WWW.IDUGDB2-L.ORG cc
Subject Free Data Integrity and Compliance Seminar
Worried about regulatory compliance? Unsure of how to provide data integrity amid the daily tumult of data manipulation, transformation and administration? Interested in a free seminar on database management and regulatory compliance? [...]
2258 74 41_Region, Datasharing group, subsystem etc.9_David Pat22_davidpatty72@YAHOO.COM31_Wed, 29 Jun 2005 10:25:23 -0700332_iso-8859-1
Hello
Please help me to understand these concepts
Is "data sharing group" is having a physical existence?. (like can we see that anywhere in any system jobs ). Or that is logical existence as a "group of subsystems". How can we find out how many data sharing groups are existing in one system. [...]
2333 48 33_DB2 Z/OS Stored proc error -202048_ING User21_inguser2005@YAHOO.COM31_Wed, 29 Jun 2005 12:27:34 -0500373_- Hi,
We are encountering a problem while setting up a Java stored proc on Z/OS1.6 with DB2 v8. On invoking the stored proc, it returns -20204. The error is as follows:
DSNT408I SQLCODE = -20204, ERROR: THE USER-DEFINED FUNCTION OR PROCEDURE QUAL.GET_DATA_MIGRATOR WAS UNABLE TO MAP TO A SINGLE JAVA METHOD DSNT418I SQLSTATE = 46008 SQLSTATE RETURN CODE [...]
2382 95 27_Re: Confused - DB2 v8.2 AIX15_Jeremy Schwartz25_jeremyaschwartz@YAHOO.COM31_Wed, 29 Jun 2005 10:43:10 -0700542_iso-8859-1 Barry,
Everything you stated below makes sense, and thank you for explaining. I'm kind of confused on this one as well. Did you run RUNSTATS after the reorg to update the catalog statistics? This is something you should do after completing a reorg. Beyond this the only other things that I can think of are: 1) The table has the APPEND ON attribute set. 2) A DB2 registry setting might be affecting how rows are inserted into your tablespaces. DB2MAXFSCRSEARCH comes to mind but I doubt it's the cause of your problem. [...]
2478 34 59_Re: Why so much Service Task Wait time? - DB2 V7.2 for z/OS13_Martin Packer24_martin_packer@UK.IBM.COM31_Wed, 29 Jun 2005 18:52:03 +0100381_US-ASCII Thanks. If it had been a DDF requester then DB2 Services Wait also includes time spent waiting for the answer back from the server.
If you subtract the "new" V6 buckets from the "headline" number what's left is normally 0. I have seen DDF Requester cases where the number is very significantly > 0 and had it confirmed with the DB2 lab that that's what it is. [...]
2513 55 24_Re: DB2 Connect Problem?14_David W Nobles26_David.W.Nobles@CGI-AMS.COM31_Wed, 29 Jun 2005 13:54:07 -0400465_us-ascii Chris,
Thanks for the information. Did the failed stored procedures fall into any pattern or just across the board randomly?
David Nobles CGI-AMS Greater Washington Region HHS Strategic Account Group
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Chris Worthington Sent: Tuesday, June 28, 2005 4:48 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 Connect Problem? [...]
2569 57 12_Db2 version.9_David Pat22_davidpatty72@YAHOO.COM31_Wed, 29 Jun 2005 11:27:01 -0700440_iso-8859-1 When representing DB2 version for example for version 7 , it was mentioned as DB2 7.1.1.
My understanding is that
Version - 7 Release - 1
What represents the third node 1 from 7.1.1?.
Thanks David
--------------------------------- Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football
---------------------------------------------------------------------------------
2627 20 11_Dynamic SQL12_Bob Jeandron21_bobjeandron@YAHOO.COM31_Wed, 29 Jun 2005 13:49:44 -0500542_- We have heavy CICS and Dynamic SQL from DB2 Connect. The Prepare for these statements is very costly, approx. 70-80% of the CPU of the queries. I have tested a reorg of the catalog, since it shows to need it, and it has provided very little benefit. Have turned on global statement caching and that has helped. Have investigated parameter markers, that seems to be the best option, but that requires program changes (which are far and few between). Anyone know of a miracle cure for this problem that I can do from the system/dba end? [...]
2648 202 16_Re: Db2 version.13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Wed, 29 Jun 2005 14:59:39 -0400369_- Hello David,
In my experience the levels are referred to as version, release, and modification level.
I assume you're referring to Unix, Linux, & Windows DB2.
The mainframe DB2 hasn't really had a suffixed release in many years -- since 2.3 in 1980-something.
Since then it's just been DB2 v3, v4, v5, v6, v7, v8 and of course VNext. [...]
2851 76 15_Re: Dynamic SQL0_19_csutfin@AMSOUTH.COM31_Wed, 29 Jun 2005 14:06:32 -0500368_us-ascii Bob,
Other than taking away the ability to run dynamic sql (wish I could do that, too) have you considered turning on predictive governer in RLF.
That way you can force yor users to write effecient SQL and you don't waste as much time running bad sql.
I limit any plan/package combination that will run dynamic sql to 2 CPU minutes. [...]
2928 71 15_Re: Dynamic SQL14_David A Palmer23_David_Palmer@JBHUNT.COM31_Wed, 29 Jun 2005 14:13:12 -0500567_US-ASCII I have been fighting the same problem for several years. The use of parameter markers is the only solution that we found. You might get with your Systems folks (or whoever does hardware purchasing/justification) and see when the next CPU upgrade is scheduled. I was able to effect program changes by showing the cost of an upgrade vs. the cost of making program changes. Our prepare overhead was also about 75% of the SQL statement. Also, with a bit of analysis you will probably find that you can change 20% of the programs and get 80% of the benefit. [...]
3000 157 15_Re: Dynamic SQL11_David Nance16_DWNance@FHSC.COM31_Wed, 29 Jun 2005 14:03:33 -0500512_us-ascii I have been meaning to start investigating this on my own, but just haven't had the time as yet and our dynamic workload is still so light, its not a huge issue. In fact, still have the hardcopy of article on my desk. Susan Lawson and Dan Luksetich did an article for the IDUG Solutions Journal earlier this year about static profiling. I would highly suggest looking up this article and the manuals. Good luck. Also, if you do attempt this route, I would be appreciative to find out your results. [...]
3158 52 15_Re: Dynamic SQL12_HEPP SHERY C17_schepp@SRPNET.COM31_Wed, 29 Jun 2005 12:27:27 -0700385_us-ascii Have you considered converting the dynamic sql into stored procedures that the cics app can call? That would eliminate the dynamic sql and convert it to static. It also would provide your shop the ability to streamline the code into reusable modules. Yes it's initial work for the application- but the cost benefit in saving cpu cycles might be the justification enough. [...]
3211 45 29_UDB Health Indicator question27_DB2 Database Solutions Port26_db2dba_certified@YAHOO.COM31_Wed, 29 Jun 2005 13:14:37 -0700455_iso-8859-1 Hello there, I noticed that health indicator is showing "Database Backup Required" alert frequently. I don't see any tablespaces in backup-pending state. How do I find whats causing this?. Any help is appreciated.
Thanks.
-VG
--------------------------------- Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football
---------------------------------------------------------------------------------
3257 207 108_Dynamic SQL is "everywhere" and it is degrading your DB2 performance! - Upcoming free Webinar deals with it!10_David Kane14_dkane@TACT.COM31_Wed, 29 Jun 2005 16:20:36 -0400664_iso-8859-1 Dynamic SQL is everywhere and it is degrading your DB2 performance! Join us online for a free "Webinar" presentation:
"How EZ-DB2 Captures and Consolidates Dynamic SQL from the Distributed Environment, and helps you dramatically improve your Mainframe DB2 Performance." The EZ-DB2 family of products is the only DB2 software for z/OS that lets you Capture and Consolidate Dynamic and Static SQL Statements that are essentially the same, Load them into an SQL Warehouse, Pin-Point the Top 20 SQL Statements that consume the most Resources, Alert you to SQL Statements that breach System and User-Defined Performance Rules, and empower you to [...]
3465 128 16_Re: Db2 version.9_David Pat22_davidpatty72@YAHOO.COM31_Wed, 29 Jun 2005 13:49:20 -0700441_iso-8859-1 David
Thank you so much for your reply.
I am referring to mainframe DB2. Where i say display group command it says v7.1.0. I heard that about only version 7.
Thanks Prasad
"Seibert, Dave" wrote: Hello David,
In my experience the levels are referred to as version, release, and modification level.
I assume you're referring to Unix, Linux, & Windows DB2. [...]
3594 120 15_Re: Dynamic SQL12_Ray Williams23_Ray.Williams@UNITED.COM31_Wed, 29 Jun 2005 16:30:18 -0500411_ISO-8859-1 I'm not a systems guy but i think there is a ZPARM value MXQBCE that will "shut" the optimizer off from determining the best access path at a specific number of passess through the sql statement and choose the best accesspath found to that point . . . . But it works for all SQL Dynamic or Static. We use it for SQL statements that materialize more than 40 answersets and they run "sub-second". [...]
3715 25 25_Re: DMS Rebalancing in V613_Ian Bjorhovde23_ian.bjorhovde@GMAIL.COM31_Wed, 29 Jun 2005 15:13:11 -0700352_ISO-8859-1 On 6/28/05, Manoj Krishna wrote: > Is there any way of knowing the progress of DMS Rebalancing process in DB2 > V6 in AIX and Windows?
If I remember correctly, DB2 UDB V6.1 printed some status messages in the db2diag.log as the rebalancer runs, along the lines of "10000 out of 35000 pages complete". [...]
3741 27 33_Re: UDB Health Indicator question13_Ian Bjorhovde23_ian.bjorhovde@GMAIL.COM31_Wed, 29 Jun 2005 15:24:30 -0700381_ISO-8859-1 On 6/29/05, DB2 Database Solutions Port wrote: > Hello there, > I noticed that health indicator is showing "Database Backup Required" alert > frequently. I don't see any tablespaces in backup-pending state. How do I > find whats causing this?. Any help is appreciated. >
This is one of the autonomic features that IBM has added. [...]
3769 102 15_Re: Dynamic SQL35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Wed, 29 Jun 2005 20:50:13 -0400450_iso-8859-1 That's the old standard 80/20 rule, but I modify this for DB2 systems. While every system/application is unique, I often find that it's more like a 10% or 5% change to get 90-95% of the benefit.
Regards, Joel
----- Original Message ----- From: "David A Palmer" Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, June 29, 2005 3:13 PM Subject: Re: [DB2-L] Dynamic SQL [...]
3872 130 16_Re: Db2 version.15_Jeremy Schwartz25_jeremyaschwartz@YAHOO.COM31_Wed, 29 Jun 2005 19:20:43 -0700616_iso-8859-1 David,
Typically IBM uses the third node to represents the maintenance or modification level of the software. So 7.1.1 would actually represent Version 7, Release 1, Maintenance level 1.
--- David Pat wrote:
> David > > Thank you so much for your reply. > > I am referring to mainframe DB2. Where i say display group command it > says v7.1.0. > I heard that about only version 7. > > Thanks > Prasad > > "Seibert, Dave" wrote: > Hello David, > > In my experience the levels are referred to as version, release, and > [...]
4003 84 45_Re: Region, Datasharing group, subsystem etc.12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 29 Jun 2005 22:04:00 -0500460_- I think you need to start with the introduction chapter in the data sharing book. Here is the URL for the V8 pdf, for instance. http://publib.boulder.ibm.com/epubs/pdf/dsndsj12.pdf
For seeing the group, try -display group,detail There are a number of other definitions. Each member of a group is a separate subsystem, usually in a separate LPAR or separate machine for capacity and availability. Each subsystem has its own set of address spaces. [...]
4088 59 43_Re: Z/OS QMF & DB2 connect - unicode issues12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 29 Jun 2005 22:18:54 -0500550_ISO-8859-1 65534 is the CCSID used for mixed and graphic on a subsystem where the mixed attribute is turned off, in short an error. See the Installation Guide Appendix for examples of CCSIDs. Here is a paste:
If you specify MIXED DATA=NO on installation panel DSNTIPF, specify an SBCS CCSID from Table 122 in the EBCDIC CCSID field on DSNTIPF. You must specify a SBCS CCSID from Table 123 on page 519 in the ASCII CCSID field on DSNTIPF. Mixed character data and graphic data cannot be defined on a system when you specify MIXED DATA=NO. [...]
4148 79 37_Re: Converting Catalog to SMS managed0_17_JTonchick@AOL.COM29_Wed, 29 Jun 2005 23:59:43 EDT509_US-ASCII You don't have to have IBM's Flashcopy to utilize the V8 BACKUP SYSTEM utility. IBM's older RVA dasd with Snapshot, STK's SVA with Snapshot are also "certified" to work. We have STK SVA model V2X dasd and when I first learned about the new utility, I quickly asked our STK maintenance folks to check into compatibility. They assured me that their dasd conforms to the Flashcopy API. I believe that EMC's Time Finder and a similar Hitachi utility also work, but you'll have to hear it from them. [...]
4228 98 23_AW: [DB2-L] z/os v8 oam35_=?iso-8859-1?Q?Kurtz=2C_R=FCdiger?=28_Ruediger.Kurtz@HUK-COBURG.DE31_Thu, 30 Jun 2005 09:06:19 +0200368_iso-8859-1 Hello Bill,
it's basically the same here; we partitioned our OAM-Tablespaces on OTNAME, starting out with 26 partitions and finally going up to 104, and we experienced no problems with our applications. Even though we're still on V7 I doubt that there will be problems when going to V8.
Rüdiger Kurtz Abteilung Informatik Betrieb [...]
4327 65 37_The usual optimal index not chosen...10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 30 Jun 2005 10:45:30 +0200353_US-ASCII Estimeed listers
We have this SQL:
SELECT P28008_A200 into :hv1 FROM P28RT008 WHERE P28008_A050 = :hv2 AND P28008_0010 = :hv3 AND P28008_0860 = :hv4 AND P28008_0840 = :hv5 ;
We have a problem with an index, that isn't used even if it's the 'optimal' index. There are 2 good indexes on the table (actually they are 3): [...]
4393 106 41_Re: The usual optimal index not chosen...11_David Nance16_DWNance@FHSC.COM31_Thu, 30 Jun 2005 04:55:23 -0500319_us-ascii Max, You could try altering the catalog stats to make you other index look more attractive to the optimizer. It would be best to proceed with getting the approval for the zparm change, even if you do get this one to change without using hints.
Dave Nance First Health Services, Corp. (804)527-6841 [...]
4500 146 41_Re: The usual optimal index not chosen...17_SALVADORI Etienne17_esalvadori@GMF.FR31_Thu, 30 Jun 2005 13:43:25 +0200447_iso-8859-1 Dave, How can you ensure that these human-modified-stats will be kept for years for future Bind PKG or auto-Bind ?
Etienne Salvadori
AZUR-GMF . SGBD Levallois . ISM 01-49-64-37-73
-----Message d'origine----- De : DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] De la part de David Nance Envoyé : jeudi 30 juin 2005 11:55 À : DB2-L@WWW.IDUGDB2-L.ORG Objet : Re: The usual optimal index not chosen... [...]
4647 163 41_Re: The usual optimal index not chosen...0_21_Kathy_Culp@BCBSTX.COM31_Thu, 30 Jun 2005 08:07:51 -0500581_us-ascii For V8 take a look at Volatile Table. It will encourage the use of an index.
Kathy Culp Enterprise Database Administration 972-996-8049 2-8049 (Richardson internal) 8-996-8049 (Chicago internal)
|---------+----------------------------> | | "David Nance" | | | | | | Sent by: "DB2 | | | Data Base | | | Discussion List" | | | | | | | | | | | | 06/30/2005 04:55 | | | AM | | | Please respond to| | | "DB2 Database | | | Discussion list | | | at IDUG" | |---------+----------------------------> [...]
4811 121 45_Re: Region, Datasharing group, subsystem etc.9_David Pat22_davidpatty72@YAHOO.COM31_Thu, 30 Jun 2005 06:15:08 -0700392_iso-8859-1 Thanks Roger. I am confused with the daily usage terminologies and actual technical environement. I will go through the manual. Thank you so much.
Roger Miller wrote:I think you need to start with the introduction chapter in the data sharing book. Here is the URL for the V8 pdf, for instance. http://publib.boulder.ibm.com/epubs/pdf/dsndsj12.pdf [...]
4933 106 41_Re: The usual optimal index not chosen...9_Mike Bell21_mbell11a1@VERIZON.NET31_Thu, 30 Jun 2005 08:24:41 -0500571_windows-1250 One of the basic problems with index with more than 2 columns is DB2 doesn't normally collect distribution statistics for the number of columns between first col card and full key card. DB2 attempts to estimate the column distribution using column cardinalities but many times the columns in the index are stronly correlated and the estimates are wildly wrong. I have found that collecting statistics for number of columns in the index - 1 is the best solution. INDEX (ALL KEYCARD FREQVAL NUMCOLS 2 COUNT 10 ) would be correct for a 3 column index etc. [...]
5040 138 45_Re: Region, Datasharing group, subsystem etc.9_David Pat22_davidpatty72@YAHOO.COM31_Thu, 30 Jun 2005 06:22:45 -0700396_iso-8859-1 Roger
Few more doubts.
1) If there is a existing databases on one Datasharing group and if we want to move to new datasharing group what are the steps we need to follow. 2) Imagine that we have to use the existing Datasharing group to onlines (with high prioirty) and other datasharing group for batch programs (low priority) where we have to setup this priorities. [...]
5179 42 49_Problems with unload from copy and version 8 Z/OS13_Hanne Lyssand10_han@VPS.NO31_Thu, 30 Jun 2005 15:32:32 +0200506_us-ascii We have upgraded two test systems to DB2 version 8 in NFM. There have been some problems and most of them because we use national letters in columnames.
We have a problem with unload from copy.
UNLOAD TABLESPACE D98.S9850 FROMCOPYDDN INN PUNCHDDN SYSPUNCH UNLDDN SYSREC
When we unload from tables with columnames with national characters the SYSPUNCH datasett konverts to UNICODE we use this dataset in a PLI program and have some problems with finding a way to read it. [...]
5222 398 41_Re: The usual optimal index not chosen...11_David Nance16_DWNance@FHSC.COM31_Thu, 30 Jun 2005 08:48:33 -0500473_iso-8859-1 Etienne, They wouldn't be kept past the next runstats. I was attempting to give Max a suggestion to try out, until he does get the zparm changed and he starts using opthints. Though updating the stats has been a norm in some shops. There was a process, that when certain packages were being migrated to production, would be run to update the stats, bind the programs in question, then put the stats back to what they were previously for all other packages. [...]
5621 130 53_Re: Problems with unload from copy and version 8 Z/OS13_Richard Fazio21_rfazio@TRANSUNION.COM31_Thu, 30 Jun 2005 08:49:34 -0500475_US-ASCII For the SYSPUNCH thing...check out PQ96711 faz
Rich Fazio DB2 OS390 DBA
TransUnion, LLC SSG/Data Services Team, 5th Floor 555 West Adams St. Chicago, IL 60661 Phone (312) 985-3270 Fax (312) 466-8398
Talk to teach - Listen to learn
>>> han@VPS.NO 2005-06-30 8:32:32 AM >>> We have upgraded two test systems to DB2 version 8 in NFM. There have been some problems and most of them because we use national letters in columnames. [...]
5752 51 7_Proedit13_Agarwal, Amit33_amit_agarwal@STANDARDANDPOORS.COM31_Thu, 30 Jun 2005 10:03:09 -0400330_iso-8859-1 DB2 v5 OS/390 v2r10 (moving to V7)
We copied over our db2 subsystem and ISV products to another LPAR and are having problems with using Proedit. This software was installed non-smpe a long time ago. Any ideas where I could look at? This particular module(CSBROWS) seems to be present in multiple libraries. [...]
5804 152 11_Re: Proedit13_Richard Fazio21_rfazio@TRANSUNION.COM31_Thu, 30 Jun 2005 09:10:46 -0500351_US-ASCII An S122 is an operator cancel.
Check the MVS Syslogs to see if it was actually canceled by a human or possibly AO.
Possible slip trap could be in place. faz
Rich Fazio DB2 OS390 DBA
TransUnion, LLC SSG/Data Services Team, 5th Floor 555 West Adams St. Chicago, IL 60661 Phone (312) 985-3270 Fax (312) 466-8398 [...]
5957 137 11_Re: Proedit13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Thu, 30 Jun 2005 10:18:07 -0400657_- Didn't Proedit go out of support back in DB2 v6 days?
Dave
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Richard Fazio To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Proedit
>>> amit_agarwal@STANDARDANDPOORS.COM 2005-06-30 9:03:09 AM >>> DB2 v5 OS/390 v2r10 (moving to V7)
We copied over our db2 subsystem and ISV products to another LPAR and are having problems with using Proedit. This software was installed non-smpe a long time ago. Any ideas where I could look at? This particular module(CSBROWS) seems to be present in multiple libraries. [...]
6095 83 11_Re: Proedit9_Mike Bell21_mbell11a1@VERIZON.NET31_Thu, 30 Jun 2005 09:27:00 -0500466_windows-1250 SYSTEM COMPLETION CODE=122 is usually operator cancel. You might check if there is a message showing on mvs log that your ops package is replying cancel to. If all else fails, contact the vendor.
Mike Bell HLS Technologies -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Agarwal, Amit Sent: Thursday, June 30, 2005 9:03 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Proedit [...]
6179 187 47_Loading CLOB data in DB2 UDB using LOAD command20_Zhang, Min - ESA CTR17_Zhang.Min@DOL.GOV31_Thu, 30 Jun 2005 10:38:54 -0400742_iso-8859-1 Hi listeners,
Anyone have an example of load that I can use to load CLOB data to a table?
I got a MTK generated load script for the CLOB table below
LOAD FROM C:\MTK\projects\whdbra\DataOutscripts\loaddata\gendecision.UNL OF DEL MODIFIED BY COLDEL| LOBS FROM C:\MTK\projects\whdbra\DataOutscripts\loaddata\gendecision/ MODIFIED BY LOBSINFILE METHOD P(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15) REPLACE INTO gendecision.
Would you provide an example of load script for loading LOB and file example of LOB. In above script, gendecision.UNL is an unloaded Informix file with delimiter '|'. But I would like to see a LOB file example called gendecision in above. Is this file [...]
6367 31 41_Re: The usual optimal index not chosen...10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 30 Jun 2005 16:54:40 +0200460_US-ASCII Estimeed listers
Thank you all for help. Just tried RUNSTATS with FREQVAL NUMCOLS option but thre's no way, EXPLAIN shows it continues to use the index 2 (3 columns) instead of the index 3 (5 columns,matchcols 4):
RUNSTATS INDEX(FN0CES0T.IPRE017403) FREQVAL NUMCOLS 4 COUNT(20) RUNSTATS INDEX(FN0CES0T.IPRE017402) FREQVAL NUMCOLS 2 COUNT(20)
Have to talk with programmer to see if there's something wrong with host variable. [...]
6399 292 41_Re: The usual optimal index not chosen...12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Thu, 30 Jun 2005 10:05:00 -0500621_us-ascii _____
From: Gerald Hodge [mailto:ghodge@hlstechnologies.com] Sent: Thursday, June 30, 2005 9:59 AM To: 'DB2 Database Discussion list at IDUG' Subject: RE: [DB2-L] The usual optimal index not chosen...
Max:
The issue with HINTS is that any bind or rebind has to reference the hint for it to stay in effect. Most places do not have the controls on this type of activity to ensure the hint is not dropped. HINTS is meant to get you out of a problem, so that you can find the correct solution. Falsifying the statistics has the risk of damaging someone else, and being lost [...]
6692 87 41_Re: The usual optimal index not chosen...0_28_Missy.Case@FIRSTDATACORP.COM31_Thu, 30 Jun 2005 10:07:51 -0500321_US-ASCII Max,
I had a join like that - darn thing just wouldn't stay with what we all knew was the best index & inner table to use. Every 2 or 3 months for some reason the stats would suddenly, inexplicably make it use the really large (100+ mln) row table as the inner table instead of the much smaller one. [...]
6780 55 53_Re: Problems with unload from copy and version 8 Z/OS13_Hanne Lyssand10_han@VPS.NO31_Thu, 30 Jun 2005 18:30:51 +0200431_us-ascii Tanks Rich Fazio The ptf solved the problem. For the SYSPUNCH thing...check out PQ96711
I still have problem with the sysrec file. An it looks fine when i only have one table in the tablespace. If the tablespace has more than one table the first fire bytes in all records don't make sence. The syspunch for example says that: WHEN(00001:00002) = X'0003' WHEN(00001:00002) = X'0004' WHEN(00001:00002) = X'0005' [...]
6836 128 22_Re: Proedit - resolved13_Agarwal, Amit33_amit_agarwal@STANDARDANDPOORS.COM31_Thu, 30 Jun 2005 13:15:03 -0400522_windows-1250 Thank you for your suggestions. Just in case some tries to search the list in future for this issue, the problem was that the CA9 services (which checks licencing issues) was not started. Once the system programmer started it, the wierd s122 errors went away.
Thanks Amit
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of Mike Bell Sent: Thursday, June 30, 2005 10:27 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Proedit [...]
6965 16 26_update trigger through ddf13_Trace R Jones33_trace.jones@CENTERPOINTENERGY.COM31_Thu, 30 Jun 2005 12:48:43 -0500631_US-ASCII Is it possible to use a trigger on a action in a table in one subsystem to fire and then insert/update a table in another subsystem?
TRJ
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
6982 47 30_Re: update trigger through ddf13_Kenney, Marty24_Marty.Kenney@RAILINC.COM31_Thu, 30 Jun 2005 13:53:26 -0400547_US-ASCII Yes, but it can not directly issue the SQL, it needs to call a procedure that uses the three part name of the table that you want to update.
Of course this is assuming there is a DDF connection between the two.
Marty Kenney Sr. DB2 DBA Railinc (919) 651-5211
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Trace R Jones Sent: Thursday, June 30, 2005 1:49 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] update trigger through ddf [...]
7030 269 16_Re: Db2 version.12_Isaac Yassin20_yassini@BEZEQINT.NET31_Thu, 30 Jun 2005 21:27:49 +0200456_us-ascii Hi,
Small correction - there were 1.1 1.2 1.3 2.1. 2.2 2.3 3.1 3.2 3.3 and then 4.1 (the 4.2 was named 5 before going GA) AFAIK 1.1 was not actually sold, but 1.2 was sold to customers.
Isaac Yassin
_____
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Seibert, Dave Sent: Wednesday, June 29, 2005 9:00 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Db2 version. [...]
7300 13 45_Re: Region, Datasharing group, subsystem etc.12_Richard Link16_linkr@BCBSIL.COM31_Thu, 30 Jun 2005 14:10:14 -0500711_- 1) A existing database is moved from one data sharing group to another the same way it is moved from one subsystem to another. 2) Priority is defined for each subsystem in the data sharing group the same way priority is defined for subsystems not in data sharing groups.
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at [...]
7314 142 16_Re: Db2 version.11_Mark Ediger22_MEDIGER@TRANSUNION.COM31_Thu, 30 Jun 2005 14:41:39 -0500463_US-ASCII Isaac DB2 1.1 was sold to customers because my employer at the time bought it when we converted from DOS/VSE to MVS/SP. We needed it because we has SQL/DS production applications.
Mark Ediger
>>> yassini@BEZEQINT.NET 6/30/2005 2:27:49 PM >>> Hi,
Small correction - there were 1.1 1.2 1.3 2.1. 2.2 2.3 3.1 3.2 3.3 and then 4.1 (the 4.2 was named 5 before going GA) AFAIK 1.1 was not actually sold, but 1.2 was sold to customers. [...]
7457 230 20_DB2 v7 to v8 upgrade14_David W Nobles26_David.W.Nobles@CGI-AMS.COM31_Thu, 30 Jun 2005 15:48:25 -0400327_us-ascii I'll look through the archives since I'm sure this has been discussed ad nauseum but also thought I'd
check with group about any particularly nasty problems. We only have a handful of COBOL programs
since most of our access is through VB 6.0. No stored procedures, yet. We'll start with those after [...]
7688 316 24_Re: DB2 v7 to v8 upgrade21_Bryant II, David, ISD27_DBryant106@WORLDSAVINGS.COM31_Thu, 30 Jun 2005 15:29:10 -0500514_us-ascii Yes It is.
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of David W Nobles Sent: Thursday, June 30, 2005 2:48 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 v7 to v8 upgrade
I'll look through the archives since I'm sure this has been discussed ad nauseum but also thought I'd
check with group about any particularly nasty problems. We only have a handful of COBOL programs [...]
8005 216 16_Re: Db2 version.16_Charles Crockett30_Charles_Crockett@HAM.HONDA.COM31_Thu, 30 Jun 2005 16:34:13 -0400413_us-ascii I sure remember going to Education & installing 1.1 back in Oct of 83 (or there abouts). One interesting thing that IBM did at that time, when you got the initial product at each version level, it appeared to be 1.0, 2.0 or 3.0 version/release number, it wasn't until they announced the Release 2 for that version that they suddenly started referring to what you had been working with as Release 1. [...]
8222 178 16_Re: Db2 version.16_Craig S. Mullins23_craig@CRAIGSMULLINS.COM31_Thu, 30 Jun 2005 15:37:58 -0500480_US-ASCII There were no point releases for V3.
And, technically, there was no V6.2 either. It was called the V6 Refresh. It did come with new functionality though, similar to a point release.
The information in the original post is accurate, too, though. Even though there have been no points or mods in DB2 versions since V2.3 timeframe, the IBM version/release naming "standards" (for lack of a better word) do discuss "version"."release"."modification level" [...]
8401 90 24_Re: DB2 v7 to v8 upgrade9_Mike Bell21_mbell11a1@VERIZON.NET31_Thu, 30 Jun 2005 16:01:12 -0500605_windows-1250
Base Version 8 requires z/os 1.3 but there are optional features that can require as current as z/os 1.5. That information is usually in the program directory http://www.elink.ibmlink.ibm.com/public/applications/publications/cgibin/pbi .cgi?CTY=US&FNC=SRX&PBL=GI10-8566-03# It also has all the other prereq's and coreqs.
Mike Bell HLS Technologies -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of David W Nobles Sent: Thursday, June 30, 2005 2:48 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 v7 to v8 upgrade [...]
8492 79 29_Failing App in DB2 Connect V813_Steve Runtsch26_steve.runtsch@ASSURANT.COM31_Thu, 30 Jun 2005 16:50:02 -0500588_US-ASCII We have a Visual Basic application that accesses a DB2 z/OS V7 table which has a primary key which is a TIMESTAMP. In order for the app to work correctly in DB2 Connect V7, we set PATCH1=131072 in db2cli.ini. 131072 was deprecated in V8 (but was reinstated in fix pack 6, I believe) and the right combination of the MapTime... and MapDate... parameters took its place. This should cause DB2 to convert the time stamp to a 26-byte character format field. Unfortunately, our application fails with or without any of these parameters. The buffer length for the 26-byte time is [...]
8572 59 45_Re: Region, Datasharing group, subsystem etc.14_Andy Lankester30_andy.lankester@CDBSOFTWARE.COM31_Thu, 30 Jun 2005 17:21:53 -0500402_windows-1250 Be VERY careful about the use of the word 'database'! In DB2 z/OS and previous mainframe incarnations it is merely a logical and administrative grouping of objects that in no way (that I can think of late at night) restricts relationships (eg views/referential integrity) between other objects in other databases in the same DB2 subsystem/datasharing group i.e. the same DB2 Catalog. [...]
8632 85 24_Re: DB2 v7 to v8 upgrade13_Glenn Hassert22_ghassert@OPTONLINE.NET31_Thu, 30 Jun 2005 20:04:41 -0400709_windows-1250 I believe you also need to be on a specific hardware platform also. I don't have the doc in front of me, but I think it has to be a 'Z' box or better?
Mike Bell wrote:
> >Base Version 8 requires z/os 1.3 but there are optional features that can >require as current as z/os 1.5. >That information is usually in the program directory >http://www.elink.ibmlink.ibm.com/public/applications/publications/cgibin/pbi >.cgi?CTY=US&FNC=SRX&PBL=GI10-8566-03# >It also has all the other prereq's and coreqs. > >Mike Bell >HLS Technologies >-----Original Message----- >From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf >Of David W Nobles >Sent: Thursday, June 30, [...]