1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l August 2008, week 5
2 61 51_Re: Migration from native security to RACF security12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 29 Aug 2008 00:54:52 +0000483_utf-8 Forcing one option when customers choose the other does not deliver good customer value, but has substantial costs for customers. We've had to respond to this type of expectation before. Customers have had the RACF option for about 11 years now, and even longer for CA. Distributed private protocol has been difficult to remove from DB2, even with much more cost and less value. SQL standards include GRANT and REVOKE, providing better portability than external security. [...]
64 80 36_Re: DB2 V9 z/OS(CM) - SPT01 problems12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 29 Aug 2008 02:39:53 +0000300_utf-8 Have you called the IBM service group? We'll want to see what you have, hopefully some traces from before and after - statistics and accounting. Are you getting incremental BINDs? How big is the EDMPOOL and what statistics are you seeing for it? What is the buffer pool hit ratio for BP0? [...]
145 145 36_Re: DB2 V9 z/OS(CM) - SPT01 problems0_33_Paul.Z.Fegan@TRANSPORT.QLD.GOV.AU31_Fri, 29 Aug 2008 15:15:02 +1000557_US-ASCII Hi Roger,
All the info has been sent off to IBM. There latest request is for the before and after raw SMF data. We cranked BP0 up from 3000 pages to 30,000 pages and it's using the lot and still hammering SPT01.
I believe this is a problem with the EDMPOOL size, it's currently 60,000 KB. We tried to up it to 120,000KB using -set sysparm and bought our production DB2 down and it subsequently refused to come back up using the newly assembled zparm so swapped the old module back in. After looking at the reason for the failure [...]
291 1168 40_AW: [DB2-L] help - Pb with a SQL program0_26_Walter.Janissen@ITERGO.COM31_Fri, 29 Aug 2008 09:28:48 +0200552_iso-8859-1 Dave
I think, this query will have a comparable elapsed time to the original, because you didn't remove the stage2-predicate in the correlated subquery. And furthermore I think, that it is not necessary to change the column definition nor is it necessary to use a trigger. You can use the cast-function to get the definition of the substr-function compatible to the definition of column NOCEEL and that makes the predicate indexable. We often recommend that for adhoc queries having bad response times and it works like a charm. [...]
1460 127 39_Re: IRLM and SMP/E and all that jazz...0_24_aurora.dellanno@CFS.COOP31_Fri, 29 Aug 2008 11:58:54 +0100324_us-ascii Right.
here is where I hang my head in shame.
I had not noticed (well that's the only way I can describe it), that the same nice person who has put us in this SMP/E situation had for some unfathomable reason copied the IRLM modules to the SDSNLOAD library - they normally reside in the SDXRRESL. [...]
1588 207 39_Re: IRLM and SMP/E and all that jazz...14_Avram Friedman25_IBMsysProg@GEEK-SITES.COM31_Fri, 29 Aug 2008 12:46:31 +0000491_utf-8 When I took my first assembler programing class many years ago the instructor said the number of registers in any hardware design is a compermise beween 1 and infinity.
I bring this up as a result of the comment
>I had not noticed (well that's the only way I can describe it), that the >same nice person who has put us in this SMP/E situation had for some >unfathomable reason copied the IRLM modules to the SDSNLOAD library - they >normally reside in the SDXRRESL. [...]
1796 157 36_Re: DB2 V9 z/OS(CM) - SPT01 problems12_McLaren Phil34_Phil.McLaren@WINTERTHUR-LIFE.CO.UK31_Fri, 29 Aug 2008 13:59:43 +0100304_us-ascii Hi Paul,
Just double checking - didn't SPT01 move into BP8K0 with V8? I don't believe V9 changed that, but the only V9 I have is on a tape in my desk, so cannot verify that right now :-)
Would be grateful if you could publish any findings on this problem.
Regards Phil [...]
1954 223 39_Re: IRLM and SMP/E and all that jazz...10_Roger Hecq18_Roger.Hecq@UBS.COM31_Fri, 29 Aug 2008 09:17:48 -0400520_US-ASCII No apologies needed. Anyone with any experience has done worse. I'm just glad that you are on your way now. Have a good weekend. Trees frequently obfuscate our view of the forest.
Roger Hecq MF IB USA DB Support 203-719-0492 / 19-337-0492
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of aurora.dellanno@CFS.COOP Sent: Friday, August 29, 2008 6:59 AM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] IRLM and SMP/E and all that jazz... [...]
2178 95 27_AW: [DB2-L] Unicode explain0_23_Hans-Joachim.Mai@SDM.DE31_Fri, 29 Aug 2008 15:20:32 +0200348_iso-8859-1 Roland, your column is UTF-8, the UX constants are hex of UTF-16, so conversion will occur. In case the UX is smaller than '0080' UTF-8 and UTF-16 encodings are equal '5C', '005C' resp. From UX'0080' upwards UTF-8 will need at least two bytes, where the high byte according to the conversion rules is never x'00': UX'0080' - 'C280' [...]
2274 147 39_Re: IRLM and SMP/E and all that jazz...0_24_aurora.dellanno@CFS.COOP31_Fri, 29 Aug 2008 14:53:56 +0100550_us-ascii Hey Avram,
that would be fair enough if the person who had done it, had done it for any intelligent reason, however it is the same person who simply renamed an old back up of the target library for SMP/E after applying 2 years' worth of maintenance, did not tell anyone, left the SMP/E environment without a leg to stand on (did not document it, see your point below), and when asked why (as in, do you remember any significant event that meant you had to do things in a hurry and just renamed all the libraries instead of doing [...]
2422 187 44_AW: [DB2-L] DB2 V9 z/OS(CM) - SPT01 problems0_31_MARTIN.KETTERER@DE.KAERCHER.COM31_Fri, 29 Aug 2008 16:10:35 +0200528_iso-8859-1 Hello we are just migrating systems from V8 to V9, no changes to SPT01 here, but from our V7>V8 migration I see the define VSAM for SPT01 with CONTROLINTERVALSIZE(8192) in step ENFM0183 of DSNTIJNE. Should answer this question for you. Best regards Martin
-----Ursprüngliche Nachricht----- Von: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Im Auftrag von McLaren Phil Gesendet: Freitag, 29. August 2008 15:00 An: DB2-L@www.idugdb2-l.org Betreff: Re: [DB2-L] DB2 V9 z/OS(CM) - SPT01 problems [...]
2610 205 39_Re: IRLM and SMP/E and all that jazz...14_Avram Friedman25_IBMsysProg@GEEK-SITES.COM31_Fri, 29 Aug 2008 14:30:09 +0000360_utf-8 Forgive me This whole issue does sound like its an error by the old sysprog. No Doc Not keeping SMP in sync with the actual run time levels Bad backups (backups that match the live version and past version).
What caused me to comment was the question of why the datasets were combined. In my view this is not a rare or unreasonable practice. [...]
2816 25 44_Re: AW: [DB2-L] help - Pb with a SQL program8_Albert V24_albert.v@NUMERICABLE.COM31_Fri, 29 Aug 2008 14:41:20 +0000290_utf-8 Hi all, I asked the person to change the query as suggested and recommended by Walter and others and they have rerun the job, and we have observed a dramatic decrease in the elapsed time with the same results. Many thanks to all of you who have helped me. Kind regards Albert V. [...]
2842 201 36_Re: DB2 V9 z/OS(CM) - SPT01 problems12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 29 Aug 2008 15:59:30 +0000467_utf-8 Oops, BP8K0 is the one, but EDMPOOL space is a better place to avoid the IO. Do you have lots of small packages? I expected the REBINDs to help, moving some of the EDMPOOL space above the bar. What is the PMR or ETR number? Now that we have five parts for EDMPOOL, life is a bit more complex. Since this is causing IO, it seems likely that the EDM skeleton pool is the one which needs help. http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp [...]
3044 290 39_Re: IRLM and SMP/E and all that jazz...14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Fri, 29 Aug 2008 12:04:16 -0400523_us-ascii "OPERATOR ERROR. Replace OPERATOR and continue."
--Phil Sevetson, NYCAPS DBA Support Financial Information Services Agency of The City of New York 450 West 33rd Street, 4th Floor New York, NY 10001 phone: (212) 857-1688 mailto: psevetson@fisa.nyc.gov
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Avram Friedman Sent: Friday, August 29, 2008 10:30 AM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] IRLM and SMP/E and all that jazz... [...]
3335 64 10_DB2LOOK -l10_Mark Stone17_mastone@GMAIL.COM31_Fri, 29 Aug 2008 10:49:18 -0700373_ISO-8859-1 Does anyone else have problems getting DB2LOOK to export tablespaces using the -l option
My full command looks like
db2look -d database -i user -w password -l -o c:\temp\ts.sql
I can get the command to export tables and indexes but it refuses to give up the tablespaces.
We're running DB2 8.1.5 Z/OS
Thanks for any input. [...]
3400 419 14_Re: DB2LOOK -l12_Weaver, Rick19_Rick_Weaver@BMC.COM31_Fri, 29 Aug 2008 13:40:03 -0500517_us-ascii I don't know about DB2LOOK, but I'm sure there is no DB2 8.1.5 Z/OS version.
Rick Weaver Product Manager DB2 z/OS Solutions BMC Software
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mark Stone Sent: Friday, August 29, 2008 12:49 PM To: DB2-L@www.idugdb2-l.org Subject: [DB2-L] DB2LOOK -l
Does anyone else have problems getting DB2LOOK to export tablespaces using the -l option [...]
3820 184 14_Re: DB2LOOK -l10_Mark Stone17_mastone@GMAIL.COM31_Fri, 29 Aug 2008 13:06:55 -0700641_ISO-8859-1 Tell that to IBM
-- This CLP file was created using DB2LOOK Version 9.5 -- Timestamp: 8/29/2008 10:00:24 AM -- Database Name: DB2QLOC -- Database Manager Version: DB2 Version 8.1.5 -- Database Codepage: 1208
On Fri, Aug 29, 2008 at 11:40 AM, Weaver, Rick wrote:
> I don't know about DB2LOOK, but I'm sure there is no DB2 8.1.5 *Z/OS*version. > > > > Rick Weaver > Product Manager > DB2 z/OS Solutions > BMC Software > ------------------------------ > > *From:* DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] *On > Behalf Of *Mark Stone > *Sent:* Friday, August 29, 2008 [...]
4005 100 14_Re: DB2LOOK -l14_Wayne Driscoll22_wdriscoll8@COMCAST.NET31_Fri, 29 Aug 2008 15:55:55 -0500460_iso-8859-1 Mark, There is a version 8.1.5 (actually Version 8.1, fixpack 5) for DB2 for Linux, Unix & Windows (LUW) but NOT for DB2 for z/OS. That was Rick’s point.
Wayne Driscoll Product Developer NOTE: All opinions are strictly my own.
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mark Stone Sent: Friday, August 29, 2008 3:07 PM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] DB2LOOK -l [...]
4106 178 14_Re: DB2LOOK -l10_Mark Stone17_mastone@GMAIL.COM31_Fri, 29 Aug 2008 15:45:36 -0700379_ISO-8859-1 I'm more interesting in getting feedback on the DB2Look -l, just in case anyone has lost sight of the original question.
The 8.1.5 represents the client libraries in use (e.g Control Center, DB2 Connect, etc), which DB2Look reports as the DB2 Manager version. Sorry if I mistakenly assumed it was reporting information about the patch level on the server. [...]
4285 89 19_Re: Unicode explain0_25_jacampbell@ACSLINK.NET.AU31_Sun, 31 Aug 2008 11:51:12 +1000545_US-ASCII The data is actually being stored in UTF-8. UTF-8 is a multi byte character set. If the character is: - U+0000 to U+007F, then it is stored as a single byte, with the high-bit zero. These characters are identical to ASCII characters x'00' to x'7F'. - U+0080 upwards, then the character is stored as several bytes. The easy way of determining the number of bytes used is to look at the number of leading one bits in the first byte. Depending on the number of bytes used, various bits are used to re-construct the orginal character. [...]
4375 332 14_Re: DB2LOOK -l15_Leon Katsnelson15_leon@CA.IBM.COM31_Sun, 31 Aug 2008 02:26:08 -04001779_ISO-8859-1
Rick, DB2LOOK is part of the DB2 Connect product and does work with DB2 for z/OS.
Leon Katsnelson Program Director, Data Management Portfolio Management
I blog at: http://FreeDB2.com/ http://blogs.ittoolbox.com/database/talk/ http://DB2onRails.com/
|------------> | From: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |"Weaver, Rick" | >--------------------------------------------------------------------------------------------------------------------------------------------------| |------------> | To: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |DB2-L@www.idugdb2-l.org | >--------------------------------------------------------------------------------------------------------------------------------------------------| |------------> | Date: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |08/29/2008 03:08 PM | >--------------------------------------------------------------------------------------------------------------------------------------------------| |------------> | Subject: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |Re: [DB2-L] DB2LOOK -l | >--------------------------------------------------------------------------------------------------------------------------------------------------| [...]
4708 35 45_Ref:- Runstats problem with LOB table spaces.25_SUBCSRIBE DB2-L Anonymous21_kansas10@NTLWORLD.COM31_Sun, 31 Aug 2008 10:24:38 +0000349_utf-8 While running Runstats for LOB table spaces, SPACE, DSNUM and EXTENTS columns are not being updated in the SYSTABLEPART catalog table. I have also tried STOSPACE utility. I can see the updated data for all other kind of table spaces (Segmented, Partitioned), but information is not being updated for the majority of our LOB Table Spaces. [...]
4744 86 62_Antwort: [DB2-L] Ref:- Runstats problem with LOB table spaces.11_Roy Boxwell16_R.Boxwell@SEG.DE31_Sun, 31 Aug 2008 14:51:51 +0200483_US-ASCII This looks like works as designed to me! here is some data culled from various manuals
From the RUNSTATS utility
Auth: To gather statistics on a LOB table space, you must have SYSADM or DBADM authority for the LOB table space.
If the table space that is specified by the TABLESPACE keyword is a LOB table space, you can specify only the following additional keywords: SHRLEVEL REFERENCE or CHANGE, REPORT YES or NO, and UPDATE ALL or NONE. [...]
4831 26 16_DB2 intro course25_jan.vanbrabant@telenet.be25_jan.vanbrabant@TELENET.BE31_Sun, 31 Aug 2008 13:19:01 +0000479_utf-8 Hi,
I should give a small intro (half a day to 1 day maximum) of WHAT_IS_DB2 to a couple of new hirees.
In stead of having to invent the warm water (again), any idea where I could find some material or slides?
Rgds, Jan
______________________________________________________________________
* IDUG 08 Warsaw, Poland * 13-17 October 2008 * http://IDUG.ORG/lsEU * ______________________________________________________________________ [...]