1 IDUGDB2-L.ORG /home/listserv/home/db2-l April 2010, week 1
2 191 18_Re: [LUW] SQL3132W12_Cuneyt Goksu22_cuneyt.goksu@GMAIL.COM30_Thu, 1 Apr 2010 09:16:57 +0300502_ISO-8859-1 Hello Peter,
Yes the command was "db2set db2codepage=1046"
This is Suse Linux. The OS's variable setting for locale is LANG=POSIX
Before db2codepage = 1046, DB2 was using from OS and export was running
incorrectly.
Regards, Cuneyt
-----Original Message-----
*From:* IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] *On Behalf Of *Peter Suhner
*Sent:* Thursday, April 01, 2010 12:00 AM
*To:* DB2-L@IDUGDB2-L.ORG
*Subject:* Re: [DB2-L] [LUW] SQL3132W [...]62_z2s7343f26c1003312316ib12d314dle19c348a02146e28@mail.gmail.com
194 265 37_Re: Local Date exit on DB2 V9 NF MODE12_Asamoto, Roy25_Roy.Asamoto@STATEAUTO.COM30_Thu, 1 Apr 2010 06:34:39 -0400572_us-ascii Thanks for replying Tink. Yes that works.
________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of B. L. "Tink"
Tysor
Sent: Wednesday, March 31, 2010 6:19 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Local Date exit on DB2 V9 NF MODE
Hi Roy,
Would this work for you?
SELECT CHAR(HEX(CURRENT DATE)) FROM SYSIBM.SYSDUMMY1
1
--------
20100331
1 record(s) selected.
Tink
On Wed, Mar 31, 2010 at 5:00 PM, Asamoto, Roy
wrote: [...]68_0915161C01220E479F8F96BA3A27C741010A333F@SACOLEX8.corp.stateauto.com
460 163 21_Re: Handouts at IDUGs13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Thu, 1 Apr 2010 07:29:14 -0400445_iso-8859-1 Thanks Joel, this is VERY interesting
(and there is a Staples almost next door to the hotel I'll be staying in for a couple of days prior to IDUG starting!!)
Perhaps this IS workable after all
Still - it is worth emphasizing that most sessions will probably NOT have handouts, so if you do know in advance which sessions you might be attending it is still worth visiting idug.org to download them yourselves [...]58_4440F5DA00E3F3459BBCB97431B91B6611B00C03@MAILR004.mail.lan
624 94 62_Re: Information Center updated (standard end of month message)13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Thu, 1 Apr 2010 09:23:01 -0400828_utf-8 Well, this is doing something different today
It now finds the ftp server OK, but reports the following
" FTP update site is being discontinued... version 1.1.9
Description:
The FTP update site is being discontinued. Updates will be provided through an HTTP update site.
Instructions for updating the IBM IMZIC 1.1.0 Information Center to use the new update site:
Download the IBM_imzic_HTTP_patch.zip file from the following location to a temporary directory
http://download.boulder.ibm.com/ibmdl/pub/software/data/db2/zos/family/patch/IBM_imzic_HTTP_patch.zip
Unzip the IBM_imzic_HTTP_patch.zip file to the temporary directory.
You should now have an IBM_imzic_HTTP_patch.exe file in the temporary directory.
Run the IBM_imzic_HTTP_patch.exe file and follow the prompts to [...]58_4440F5DA00E3F3459BBCB97431B91B6611B00C1B@MAILR004.mail.lan
719 409 62_Re: Information Center updated (standard end of month message)15_Pierre R Bodart23_Bodart_Pierre_R@CAT.COM30_Thu, 1 Apr 2010 15:41:20 +0200640_US-ASCII Phil,
I installed the patch and now I received
Can not connect to update site:
http://public.dhe.ibm.com/software/data/db2/zos/family/
Is it working for you ?
Thks,
Pierre
Phil Grainger
Sent by: IDUG DB2-L
04/01/2010 03:25 PM
Please respond to
IDUG DB2-L
To
DB2-L@IDUGDB2-L.ORG
cc
Subject
Re: [DB2-L] Information Center updated (standard end of month message)
Caterpillar: Confidential Green Retain Until: 05/01/2010
Well, this is doing something different today [...]71_OF31AD91E4.338E2C2D-ONC12576F8.004B1F16-C12576F8.004B35E9@notes.cat.com
1129 535 70_AW: [DB2-L] Information Center updated (standard end of month message)12_Peter, Georg15_G.Peter@DZBW.DE30_Thu, 1 Apr 2010 15:45:22 +0200675_iso-8859-1 Pierre, I just tried it and it works.
IBM_HTTP_Server Server at public.dhe.ibm.com Port 80
With kind regards - mit freundlichen Gruessen,
G e o r g H . P e t e r
-------------------------------------------------------------------
Datenzentrale Baden-Wuerttemberg
Development and Product Support (E3)
Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, Europe
e:mail G.Peter@dzbw.de
Phone 0049-711-8108-27271
PC-Fax 004971189696071
Internet (only in german language):http://www.dzbw.de
----------------------------------------------------------------------
P Think before you print. [...]58_99E58D5AC1BE6D4CBF492AF72B942C3D061ADBD1@dzstus010.dzbw.de
1665 754 62_Re: Information Center updated (standard end of month message)13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Thu, 1 Apr 2010 09:47:49 -0400471_us-ascii It is indeed working, but slowly. Mind you, I seem to be only getting around 1Mbps off my ADSL today, so I can hardly blame IBM
Phil Grainger
Cogito Ltd.
phil.grainger@cogito.co.uk
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk
Attend IDUG 2010 - Europe, the premiere event for DB2 professionals.
8-12 November 2010, Vienna
Learn more at http://www.idug.org [...]58_4440F5DA00E3F3459BBCB97431B91B6611B00C23@MAILR004.mail.lan
2420 81 50_LOAD of TS Part 20 contends with SELECT on Part 1?14_Lyon, Lockwood20_Lockwood.Lyon@53.COM30_Thu, 1 Apr 2010 10:32:24 -0400515_us-ascii Dear Esteemed List:
Job P0DWDU55 is a LOAD. It began at 00:48 and ended successfully at
00:55.
LOAD DATA LOG YES SORTKEYS SORTDEVT (DISK) SORTNUM(5)
INDDN SYSREC00 INTO TABLE PROD.RLTN_DIM PART 20
REPLACE
Table PROD.RLTN_DIM is table-based partitioned. All indexes are NPIs (no
DPSIs).
Job P0DWDA63 is a DSNTIAUL executing a SELECT ... FROM PROD.RLTN_DIM
WITH UR. it began at 00:47 and abended at 00:50:30 with a Drain lock
request timeout (x'00C900BA'). [...]72_4C9F8982DB3D124695B6B4621DA3700C2B2228@SCCINDCE2K301-B.dm0001.info53.com
2502 329 40_Re: [z/OS - DB2 V9] Access Path question11_Roy Boxwell16_R.Boxwell@SEG.DE30_Thu, 1 Apr 2010 16:54:59 +02000_64_OF67307442.28B1986B-ONC12576F8.0051F030-C12576F8.0051F055@seg.de
2832 126 54_Re: LOAD of TS Part 20 contends with SELECT on Part 1?16_Daniel Luksetich18_danl@DB2EXPERT.COM30_Thu, 1 Apr 2010 09:56:04 -0500521_us-ascii Lockwood,
Resource type 2006 is a partition so x'20' is the part.
Dan
Daniel L Luksetich
IBM Information Champion
IBM Certified Database Administrator - DB2 9 for z/OS
IBM Certified System Administrator - DB2 9 for z/OS
IBM Certified Solutions Expert - DB2 Universal Database V7.1 Database
Administration for UNIX, Windows, and OS/2
IBM Certified Solutions Expert - DB2 UDB V7.1 Family Application Development
IBM Certified Advanced Technical Expert - DB2 Data Replication [...]35_002101cad1ab$744237f0$5cc6a7d0$@com
2959 224 54_Re: LOAD of TS Part 20 contends with SELECT on Part 1?12_Ashish Kumar17_bssboys@GMAIL.COM30_Thu, 1 Apr 2010 20:21:56 +0530676_ISO-8859-1 Dear All,
If you are looking to outsource any of your development/administration work,
please let me know.
Regards
Ashish Kumar
On Thu, Apr 1, 2010 at 8:02 PM, Lyon, Lockwood wrote:
> Dear Esteemed List:
>
> Job P0DWDU55 is a LOAD. It began at 00:48 and ended successfully at
> 00:55.
>
> LOAD DATA LOG YES SORTKEYS SORTDEVT (DISK) SORTNUM(5)
> INDDN SYSREC00 INTO TABLE PROD.RLTN_DIM PART 20
> REPLACE
>
> Table PROD.RLTN_DIM is table-based partitioned. All indexes are NPIs (no
> DPSIs).
>
> Job P0DWDA63 is a DSNTIAUL executing a SELECT ... FROM PROD.RLTN_DIM
[...]62_h2wb3bf881a1004010751racc4393aq6feb949b008597fa@mail.gmail.com
3184 107 54_Re: LOAD of TS Part 20 contends with SELECT on Part 1?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Thu, 1 Apr 2010 11:06:26 -0400510_us-ascii Lock,
Look up Resource Type 2006. Your error message is referring to a *partition* number 20, not a *page* number 20. (I don't know why there'd be a drain on Part 20 -- is the contending plan doing a relational scan?)
--Phil Sevetson
-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Lyon, Lockwood
Sent: Thursday, April 01, 2010 10:32 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] LOAD of TS Part 20 contends with SELECT on Part 1? [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC4678D@MAIL02.fisalan.nycnet
3292 132 34_[ADMIN] Reminders from list owners16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM30_Thu, 1 Apr 2010 11:07:21 -0400461_utf-8 This posting is something we (the list owners) are sending out about every couple of months. The purpose is to highlight information about DB2-L and also remind subscribers about certain information. Some information will be repeated to benefit new subscribers. We hope you will find the information useful, and save it for future reference. If you have feedback or suggestions, please contact us (the list owners) at DB2-L-Request@www.idugdb2-l.org [...]70_551C24F0D5EA4E47BA9B76E14D016DD5067D0815@nasa-dtw-ex005.nasa.cpwr.corp
3425 39 24_Question on LOAD Utility13_Sekhar Mekala23_SEKHAR.MEKALA@GMAIL.COM30_Thu, 1 Apr 2010 11:17:55 -0400347_UTF-8 Dear DB2 Gurus,
I have a question about DB2 LOAD Utility in DB2 V8.1 (or higher) in z/OS.
I have 10000 Records in a file, but I want to restrict the LOAD utilty to just LOAD first 10 records only. Is there any option in LOAD Utility to make sure that it considers only the first 10 records (or first "n" records) in the file? [...]55_2454736687550576.WA.SEKHAR.MEKALAGMAIL.COM@www.idug.org
3465 121 54_Re: LOAD of TS Part 20 contends with SELECT on Part 1?11_Mike Turner19_mike.turner@GMX.COM30_Thu, 1 Apr 2010 16:26:20 +0100512_iso-8859-1 Hi Lock
The Type in your DSNT501I message is 2006, which is a Tablespace partition
CS-claim class. For this Type, the Name in the message is
dbname.tsname.partition. It looks like the partition bit of the name is
decimal (20). Either that or it is hex (part 32). I suspect the Select is
trying to get a read claim on partition 20 and, unsurprisingly, failing. You
need to check the Where clause in the Select to ensure that it does not
include any row from partition 20. [...]44_EB9F81FFB3BB464C95B92203007865D1@ToshibaA300
3587 69 28_Re: Question on LOAD Utility14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Thu, 1 Apr 2010 11:28:11 -0400483_us-ascii Sekhar,
You should consider creating a separate file for this, as there is no record-limiting facility in the LOAD utility. DFSORT/SYNCSORT has a facility for this; the command is
//SYSIN DD *
SORT FIELDS=COPY,STOPAFT=10
/*
-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sekhar Mekala
Sent: Thursday, April 01, 2010 11:18 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] Question on LOAD Utility [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC46790@MAIL02.fisalan.nycnet
3657 111 18_Re: [LUW] SQL3132W13_Ian Bjorhovde23_ian.bjorhovde@GMAIL.COM30_Thu, 1 Apr 2010 09:01:20 -0700443_ISO-8859-1 On Wed, Mar 31, 2010 at 1:59 PM, Peter Suhner wrote:
> Cuneyt, all,
>
> great that this option worked. Nontheless it occurs to me as a strange
> behavior. As you state, the warning occurs during export. I'd expect DB2 to
> be able to handle the export correctly and you said the database codepage
> was also set to 1046 and the OS codepage should be detected automatically.
> [...]62_n2jd59713de1004010901y7ae950fbv43e028d09c0cb34b@mail.gmail.com
3769 28 21_Re: Handouts at IDUGs13_Ian Bjorhovde23_ian.bjorhovde@GMAIL.COM30_Thu, 1 Apr 2010 09:07:26 -0700390_ISO-8859-1 I am surprised that Phil identifies only cost of reproduction as an
issue here.
I would think that printing 1,500 pages of handouts (for just 2
sessions) is not "green" behaviour. Isn't this the point of making
presentations available online? So people can download them ahead of
time, and (if they really want it) then bring their own printed
copies? [...]62_s2jd59713de1004010907lcc407cdev3f5e2317a9627a21@mail.gmail.com
3798 70 38_Kuhr, Richard L. is out of the office.0_13_RLKUHR@UP.COM30_Thu, 1 Apr 2010 11:19:14 -0500630_US-ASCII I will be out of the office starting 04/01/2010 and will not return until
04/05/2010.
I will respond to your message when I return. If this is an emergency
please contact Computer Scheduling.
**
This message and any attachments contain information from Union Pacific which may be confidential and/or privileged. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited by law. If you receive this message in error, please contact the sender immediately and delete the message and any attachments. [...]64_OF2F8CE126.2A24F07E-ON862576F8.0059A71C-862576F8.0059A71C@UP.COM
3869 33 37_[Fluff] Spaceship Earth "safety card"14_Larry Kintisch17_LKint@VERIZON.NET30_Thu, 1 Apr 2010 13:32:38 -0400517_us-ascii Hi Listers across the world,
One of the reasons I haven't been so active on the DB2-list these
last 6 months is because I've read through two manuscript drafts of
my son's new book on geoengineering and helped a bit with research.
He created an educational promo for the book, great as a
conversation starter for your desk or home: "EARTH Emergency
Procedures Safety Card" which you should find in your seat-back
pocket when riding on Spaceship Earth. Here's a link, enjoy! [...]40_0L0700CBLKQVJI40@vms173019.mailsrvcs.net
3903 917 40_Re: [z/OS - DB2 V9] Access Path question18_Satish Srikakulapu26_Satish.Srikakulapu@APS.COM30_Thu, 1 Apr 2010 14:32:18 -0700511_us-ascii Thank you very much for the suggestion, Roy. This information helps me.
I love DB2-L for this. There are so many experienced DB2 professionals who are ready to help you and share their experiences when you ask for help.
Regards,
Satish
________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Roy Boxwell
Sent: Thursday, April 01, 2010 7:55 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] [z/OS - DB2 V9] Access Path question [...]55_D42E68651088914B9B327A4EEA8433ACA6CCF17B@VM251.apsc.com
4821 188 18_Re: [LUW] SQL3132W12_Peter Suhner24_peter_suhner@HOTMAIL.COM30_Fri, 2 Apr 2010 00:29:48 +0200695_iso-8859-1 Ian,
thanks for your details on the interaction of DB2 with the OS to what concerns codepage settings. This makes clear to me what actually happened.
Regards,
Peter
Date: Thu, 1 Apr 2010 09:01:20 -0700
From: ian.bjorhovde@GMAIL.COM
Subject: Re: [DB2-L] [LUW] SQL3132W
To: DB2-L@IDUGDB2-L.ORG
On Wed, Mar 31, 2010 at 1:59 PM, Peter Suhner wrote:
Cuneyt, all,
great that this option worked. Nontheless it occurs to me as a strange behavior. As you state, the
warning occurs during export. I'd expect DB2 to be able to handle the
export correctly and you said the database codepage was also set [...]43_SNT107-W17F522F424866D87C771DFF11D0@phx.gbl
5010 89 28_Re: Question on LOAD Utility10_Max Scarpa16_mscarpa@CESVE.IT30_Fri, 2 Apr 2010 09:22:03 +0200304_US-ASCII HI
You can REPRO in another file (to use as input) only 'n' records or use
COPY option of DFSORT (or other sort product) to extract a subset of rows.
If you have SAS you can do the same with a simple PROC COPY. Or you can
invalidate all rows but 10 so they cannot be loaded [...]66_OF1BEEBBC7.2313F38E-ONC12576F9.00269366-C12576F9.0028196A@cesve.it
5100 27 41_Garth Oldham/Australia/IBM is unavailable12_Garth Oldham19_vcgarth@AU1.IBM.COM30_Fri, 2 Apr 2010 20:04:28 +1100418_US-ASCII I will be out of the office starting 02/04/2010 and will not return until
19/04/2010.
I am unavailable to attend to your email I am out of the office from
02/04/10 til 19/04/10. For urgent requests please email the
DBDCSUP@AU1.IBM.COM mailbox. For any Requested product maintenance please
send the request to DBDCSUP@AU1.IBM.COM it will be sent to a senior DB2
person for approval. [...]69_OFDF804C31.A557F1A2-ONCA2576F9.0031D90E-CA2576F9.0031D90E@au1.ibm.com
5128 36 71_AUTO: Chandan K Vishwakarma is out of the office (returning 05/04/2010)21_Chandan K Vishwakarma19_cvishwak@IN.IBM.COM30_Fri, 2 Apr 2010 16:04:02 +0530490_US-ASCII I am out of the office until 05/04/2010.
I will respond to your message when I return.
NASCO - Please contact Somasekhar Mothukuru (Somasekhar
Mothukuru/India/IBM).
APMM - Please contact Amit Pishe (Amit K Pishe/India/IBM)
For any Technical escalations, please contact Roona Shree (Roona
Shree/India/IBM).
Note: This is an automated response to your message "DB2-L Digest - 1 Apr
2010 to 2 Apr 2010 (#2010-92)" sent on 2/4/10 10:30:01. [...]68_OF42619D32.CC88F892-ON652576F9.003A0C53-652576F9.003A0C53@in.ibm.com
5165 75 54_Re: Question on Partition rotation in DB2 V8.1 on z/OS16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM30_Fri, 2 Apr 2010 13:56:20 -0400370_utf-8 Hello Sekhar - I have been working a lot with TCP since DB2 V8, and I didn't know the answer to your question, so I decided to do a small case study - and here is the result.
I captured screen shots of the pages throughout the scenario, so if you want all the page displays in order to see I tell the truth, please let me know and I can send the word doc. [...]56_0A18F096E689AC43BB2F52DAE5674D6008115FD4@USILMS14.ca.com
5241 58 51_IBM DB2 Database Administration Certification - 73214_Vivek Tripathi29_Vivek.Tripathi@IN.FUJITSU.COM30_Mon, 5 Apr 2010 19:20:03 +0530526_us-ascii Hello Group,
I have recently cleared IBM DB2 730 Certification and now plan to go for
"IBM DB2 Database Administration Certification - 732". I referred Roger
Sander's book for 730 but I do not have any idea how to prepare for 732
Exam. Please let me know if anybody can share soft copy of "DB2 9 for
z/OS Database Administration
Certification Study Guide by Author: Susan Lawson, Dan Luksetich" or let
me know if there is any more study material which can help me to clear
this exam. [...]71_7D0B4948BCFF3D48A1D1CAFBB94423EE02A01942@delhi-mail1.india.rapidigm.com
5300 33 44_revert to uncompressed after COMPRESS_SPT01?11_Gary Martin29_Gary.Martin@LIBERTYMUTUAL.COM30_Mon, 5 Apr 2010 11:17:39 -0400422_UTF-8 I read a few posts (last month) about DB2/zOS shops implementing COMPRESS_SPT01=YES. I've experimented with this parm in a "sandbox" with promising results (78% compression). I'm wondering if anyone has reverted back to uncompressed (COMPRESS_SPT01=NO, followed by REORG), and if they experienced any issues with the process. IBM Support indicates no experience with this, but states it should be OK to revert. [...]61_8711104163885961.WA.Gary.MartinLibertyMutual.com@www.idug.org
5334 87 48_Re: revert to uncompressed after COMPRESS_SPT01?12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM30_Mon, 5 Apr 2010 11:38:48 -0500406_UTF-8 Gary:
We have been told that you cannot go back. Uncompressing poses several difficulties. This compression is a good option, but I would not project a sandbox environment on to development or production. We have been working with a lot of Version-to-Version migrations. It is our experience that there is a lot of detritus in production systems. (Development can be an even worse mess.) [...]35_008901cad4de$7d150c00$773f2400$@com
5422 40 51_Sign up for the DB2 10 for z/OS Webcast 4-13 today!11_Dave Beulke19_dave@DAVEBEULKE.COM30_Mon, 5 Apr 2010 13:53:01 -04000_51_9408197500763625.WA.davedavebeulke.com@www.idug.org
5463 99 48_Re: revert to uncompressed after COMPRESS_SPT01?13_Walters, Paul28_Paul.A.Walters@SALLIEMAE.COM30_Mon, 5 Apr 2010 14:19:59 -0400374_utf-8 I would be interested in the "cannot go back". We did test this in our sandbox - compressing and uncompressing - and had no issues - but it was a sandbox.
I also do not understand - the next version to version issue. Compression of SPT01 is supported under V8 and V9 - vnext I believe gets a major change to SPT01 that eliminates the need for compression. [...]70_EBC218E23BF7B5468DC64F2ED8547F427701DFBCA2@VREEXMBX01.us.ad.usa-ed.net
5563 31 29_zOS DB2 9 CM & Run Time Stats11_Hardy, Dale14_DHardy@MIB.COM30_Mon, 5 Apr 2010 14:33:42 -0400461_utf-8 We recently migrated to V9 CM in our development subsystem and noticed that DB2 is no longer updating the V8 RTS tables. The last updated timestamp in either table is just prior to the V9 migration. The new SYSIBM.SYSTABLESPACESTATS & SYSIBM.SYSINDEXSPACESTATS are both empty.
STATHIST is set to 30. I see there is job to copy the V8 RTS to the new tables when migrating to NF. But does this mean we have to live without updated stats until then? [...]60_C008965E3996AB4FA3A61A6AA4EF84ED1B5C3E44@mibmailexch.mib.com
5595 122 48_Re: revert to uncompressed after COMPRESS_SPT01?13_Willie Favero21_wfavero@ATTGLOBAL.NET30_Mon, 5 Apr 2010 13:42:38 -0500383_UTF-8 The compression fix for SPT01 doesn't exist in DB2 10 because the way
SPT01 is organized has been changed. It is ONLY valid for DB2 9 and DB2
V8. I'm sure this will be pointed out in the IBM sponsored Webcast on
DB2 10 on April 13. You can register for the webcast at
http://www-01.ibm.com/software/os/systemz/webcast/13apr/index.html?S_TACT=100GU00M&S_CMP=SP [...]28_4BBA2F1E.20403@attglobal.net
5718 169 48_Re: revert to uncompressed after COMPRESS_SPT01?12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM30_Mon, 5 Apr 2010 15:25:05 -0500359_UTF-8 1.) Our understanding from IBM briefings is that fall back is not supported. We have figured out how to do it and I would not want to try it outside of a sandbox. As a simple example assume that the uncompressed SPT01 would exceed the allowable space for SPT01. Then there is no going back. The question should be, why would you want to fall back? [...]35_00b201cad4fe$143b1b00$3cb15100$@com
5888 349 48_Re: revert to uncompressed after COMPRESS_SPT01?7_Ed Long19_rdhm99a@PRODIGY.NET30_Mon, 5 Apr 2010 13:32:17 -0700441_iso-8859-1 I have now heard two IBM'ers -independently- with knowledge of the situation describe V10 exactly the way my favorite Corvette consultant described the situation today on this forum.
In effect, V10 makes the compression option moot due to a redesign - or refactor to borrow a term from our Java brethren.
It appears that the NDA's, with regard to this specific matter, permit this level of discussion.
Edward Long [...]42_34218.20290.qm@web80207.mail.mud.yahoo.com
6238 70 41_Re: [Fluff] Spaceship Earth "safety card"13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM30_Mon, 5 Apr 2010 14:51:26 -0700566_us-ascii The "safety card" is a riot! I hope his book is a bestseller.
-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Larry Kintisch
Sent: Thursday, April 01, 2010 10:33 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] [Fluff] Spaceship Earth "safety card"
Hi Listers across the world,
One of the reasons I haven't been so active on the DB2-list these
last 6 months is because I've read through two manuscript drafts of
my son's new book on geoengineering and helped a bit with research. [...]64_927FE8790B320742927BCF9ADF7AE48A18EEFC284C@PDXMAIL.pacificorp.us
6309 291 152_The DB2Night Show Episode #16 - DB2 AUTONOMICS UPDATES and STMM with special guest Adam Storm, IBM Toronto Lab - Friday 9 April 2010 at 10:00 am USA CDT13_David Chapman24_David.Chapman@IAG.COM.AU30_Tue, 6 Apr 2010 17:30:25 +1000763_us-ascii _______________________________________________________________________________________
Note: This e-mail is subject to the disclaimer contained at the bottom of this message.
_______________________________________________________________________________________
Hello DB2 List,
The DB2Night Show Episode #16 - "DB2 AUTONOMICS UPDATES and STMM", with special guest Adam Storm, IBM Toronto Lab
The International DB2 Users Group (IDUG) is pleased to partner with DBI to deliver a free Webcast by renowned presenter Scott Hayes, President & CEO, DBI. This live event will run approximately 60 minutes and participants will have the opportunity to pose questions to the presenter. Capacity is limited, so register early. [...]43_DB2-L%201004060335409785.01C3@IDUGDB2-L.ORG
6601 41 76_Does DB2 drive an exit when a member in a data sharing group changes status?15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM30_Tue, 6 Apr 2010 14:30:27 +0300212_us-ascii I have been going thru the various DB2 manuals and I am looking for a way that
DB2A can detect that DB2B's status has changed or that DB2C has joined the
data sharing group.
Any suggestions?42_0k6mr5p34p5h23j2hsnh5eo534g263tqli@4ax.com
6643 93 55_Re: IBM DB2 Database Administration Certification - 73216_Daniel Luksetich18_danl@DB2EXPERT.COM30_Tue, 6 Apr 2010 07:54:16 -0500532_us-ascii "share a soft copy"?
I still haven't caught up on the sleep I lost writing that one each night
after work.
Ouch.
You could actually buy a copy and then I can afford to buy my kids each a
McDouble next time a royalty check arrives.
Dan
-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Vivek Tripathi
Sent: Monday, April 05, 2010 8:50 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: [SPAM] IBM DB2 Database Administration Certification - 732 [...]35_022601cad588$67528410$35f78c30$@com
6737 28 80_Re: Does DB2 drive an exit when a member in a data sharing group changes status?11_Nenad Vidak21_nenad.vidak@GMAIL.COM30_Tue, 6 Apr 2010 09:21:40 -0400332_UTF-8 Hello,
I'm not aware of such feature within DB2. But there are numerous ways to detect the status (or the status change) of a DB2 member : parsing SYSLOG messages, parsing output of (DB2) commands like "DISPLAY GROUP", calling some of DB2 supplied stored proc., detecting listener on a DDF port etc.
Regards, Nenad [...]53_5479704348171717.WA.nenad.vidakgmail.com@www.idug.org
6766 136 55_Re: IBM DB2 Database Administration Certification - 73212_Martin Hubel17_Martin@MHUBEL.COM30_Tue, 6 Apr 2010 09:24:39 -04000_43_DB2-L%201004060924482361.01F0@IDUGDB2-L.ORG
6903 152 55_Re: IBM DB2 Database Administration Certification - 73214_Vivek Tripathi29_Vivek.Tripathi@IN.FUJITSU.COM30_Tue, 6 Apr 2010 18:54:26 +0530553_us-ascii Dan,
I needed the soft copy only because I could not get your book here in
India. I spent my weekend searching your book but could not so just
thought if anybody can help me... Anyways ..I have placed an order for
this book from infibeam.com and hoping to receive it in a day or two. I
appreciate your views and as an author, you very well deserve for the
royalty for your excellent work. Let me tell you that I have got a very
good feedback about your book and lokking forward very eagerly to
receive my copy. [...]71_7D0B4948BCFF3D48A1D1CAFBB94423EE02A01C09@delhi-mail1.india.rapidigm.com
7056 202 55_Re: IBM DB2 Database Administration Certification - 73223_Parvathavardhini Kannan21_pkannan@INAUTIX.CO.IN30_Tue, 6 Apr 2010 19:31:36 +0530761_US-ASCII Hi,
The book is available in Chennai, Tamilnadu,India in the shop : Odeyssy.
Everyone in my company used this book for passing the exam. All the best
for you.
________________________
Parvathavardhini Kannan (Vardhini)
Vivek Tripathi
N.FUJITSU.COM> To
Sent by: IDUG DB2-L@IDUGDB2-L.ORG
DB2-L cc
ORG> Subject
Re: [DB2-L] IBM DB2 Database
Administration Certification - 732
04/06/2010 06:54
PM
Please respond to
IDUG DB2-L
ORG>
Dan,
I needed the soft copy only because I could not get your book here in
India. I spent my weekend searching your book but could not so just
thought if anybody can help [...]71_OFD44A8FB9.8E697283-ON652576FD.004CDDFE-652576FD.004D0D4B@inautix.co.in
7259 121 55_Re: IBM DB2 Database Administration Certification - 73214_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Tue, 6 Apr 2010 10:09:16 -0400441_us-ascii Dan,
For what it's worth, I bought hardcopy. Still haven't made my way through it all, but I paid full (Amazon) retail.
--Phil Sevetson
-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Daniel Luksetich
Sent: Tuesday, April 06, 2010 8:54 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] IBM DB2 Database Administration Certification - 732
"share a soft copy"? [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC467B7@MAIL02.fisalan.nycnet
7381 51 80_Re: Does DB2 drive an exit when a member in a data sharing group changes status?15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM30_Tue, 6 Apr 2010 17:26:21 +0300393_us-ascii On Tue, 6 Apr 2010 09:21:40 -0400 Nenad Vidak wrote:
:>I'm not aware of such feature within DB2. But there are numerous ways to detect the status (or the status change) of a DB2 member : parsing SYSLOG messages, parsing output of (DB2) commands like "DISPLAY GROUP", calling some of DB2 supplied stored proc., detecting listener on a DDF port etc. [...]42_8sgmr5pr785mp7g3ar2a3mhh419elumvju@4ax.com
7433 411 66_FW: HURRY: IDUG 2010 Europe Call for Presentations Closes 15 April13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Tue, 6 Apr 2010 10:35:46 -0400350_utf-8 Just received this from IDUG about IDUG Europe 2010
If you are an end user of DB2, please take careful note of the part that starts “Remember: The ‘U’ in IDUG stands for User. We are especially interested in presentation proposals from users of DB2…..”
It is not too late to submit your abstracts for consideration [...]58_4440F5DA00E3F3459BBCB97431B91B6611B0112D@MAILR004.mail.lan
7845 49 25_DB2 for z/OS RUNSTATS etc12_Jim McAlpine22_jim.mcalpine@GMAIL.COM30_Tue, 6 Apr 2010 15:41:45 +0100687_ISO-8859-1 I'm sure that over the last month or so someone posted a url to a manual or
presentation on DB2 performance and the use of runstats and explain but I
can't find anything in the archives. Please say I didn't dream the whole
thing up.
Jim McAlpine
_____________________________________________________________________
* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________ [...]62_s2o21d1f8c21004060741pc9d57b01u3c9a2fafc4fc8225@mail.gmail.com
7895 252 55_Re: IBM DB2 Database Administration Certification - 73223_Jeffrey Benner, DB2 DBA22_consulting@EBENNER.COM30_Tue, 6 Apr 2010 07:42:46 -0700583_ISO-8859-1 I hear you can get it on bittorrent.
Anyway, ignore what Dan says about feeding his poor children. We all know
that mainframe DBA's are filthy rich. Dan writes certification guides to
kill time between yacht races.
On Tue, Apr 6, 2010 at 05:54, Daniel Luksetich wrote:
> "share a soft copy"?
>
> I still haven't caught up on the sleep I lost writing that one each night
> after work.
>
> Ouch.
>
> You could actually buy a copy and then I can afford to buy my kids each a
> McDouble next time a [...]62_u2ta19d988c1004060742o2fc223b2z6e5e46e5d830d9ac@mail.gmail.com
8148 104 55_Re: IBM DB2 Database Administration Certification - 73210_Max Scarpa16_mscarpa@CESVE.IT30_Tue, 6 Apr 2010 18:28:06 +0200340_US-ASCII > We all know that mainframe DBA's are filthy rich. Dan writes
certification guides to kill time between yacht races.
Only a yacht ? I heard some DBAs own a black MD-80 (previously DC-9) with
a bunny on the tail and a lot of nice passengers. On the other hand the
word 'Gold' should suggest something.....;-)) [...]66_OF4853B088.920636A5-ONC12576FD.005755D0-C12576FD.005A160A@cesve.it
8253 93 33_Re: zOS DB2 9 CM & Run Time Stats18_Satish Srikakulapu26_Satish.Srikakulapu@APS.COM30_Tue, 6 Apr 2010 10:06:50 -0700377_us-ascii Hello Dale,
We found during our testing to DB2 V9 CM migration that till we move to DB2 V9 NFM, RTS tables would be SYSIBM.TABLESPACESTATS and SYSIBM.INDEXSPACESTATS. The new RTS tables (The new SYSIBM.SYSTABLESPACESTATS & SYSIBM.SYSINDEXSPACESTATS) will start getting populated only in DB2 V9 NFM. From what I recall, that was what was told to us by IBM. [...]55_D42E68651088914B9B327A4EEA8433ACA6CCF1AD@VM251.apsc.com
8347 104 80_Re: Does DB2 drive an exit when a member in a data sharing group changes status?11_Roy Boxwell16_R.Boxwell@SEG.DE30_Tue, 6 Apr 2010 22:17:49 +02000_64_OF692C1849.4E33B9ED-ONC12576FD.006F7EA3-C12576FD.006F7EB1@seg.de
8452 43 77_Index-controlled to Table-controlled partitioning - Performance benefits poll11_Sameer Rana21_sameerdrana@GMAIL.COM30_Tue, 6 Apr 2010 16:50:10 -0400740_UTF-8 Hello folks ,
We have a few legacy applications that have very old (index-controlled ) partitioning schemes/strategies for some of our partitioned tables, probably a perfect opportunity to convert to table-controlled partitioning.
Although we have begun to leverage the table-controlled partitioning feature introduced with Version 8 for our new tables, we are still weary of making this change without sufficient evidence/merits of doing so to our existing index-controlled tables.
Here's what I was looking for : Anyone who has quantified the advantages/savings derived out of converting an 'existing index-controlled partitioned table' to table-controlled partitioning with figures to support the conversion.
[...]53_1329872782462420.WA.sameerdranagmail.com@www.idug.org
8496 57 81_Re: Index-controlled to Table-controlled partitioning - Performance benefits poll13_Willie Favero21_wfavero@ATTGLOBAL.NET30_Tue, 6 Apr 2010 16:18:29 -0500686_UTF-8 You may also want to take into consideration whether indexed controlled
partitioning might be deprecated in a future version of DB2.
Willie
On 4/6/2010 3:50 PM, Sameer Rana wrote:
> Hello folks ,
>
> We have a few legacy applications that have very old (index-controlled ) partitioning schemes/strategies for some of our partitioned tables, probably a perfect opportunity to convert to table-controlled partitioning.
> Although we have begun to leverage the table-controlled partitioning feature introduced with Version 8 for our new tables, we are still weary of making this change without sufficient evidence/merits of doing so to our existing [...]30_4BBBA525.4020003@attglobal.net
8554 41 80_Re: Does DB2 drive an exit when a member in a data sharing group changes status?14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Wed, 7 Apr 2010 07:42:26 +1000613_US-ASCII Another option for Up/Down would be to monitor the ERLY block (hangs off the SSVT). (I
put some REXX code to create a DB2 menu in the Code Place - this will give an example.)
James Campbell
On 6 Apr 2010 at 14:30, Binyamin Dissen wrote:
> I have been going thru the various DB2 manuals and I am looking for a way that
> DB2A can detect that DB2B's status has changed or that DB2C has joined the
> data sharing group.
>
> Any suggestions?
>
> --
> Binyamin Dissen
> http://www.dissensoftware.com
>
> Director, Dissen [...]49_4BBC3762.15274.17149C9D@jacampbell.acslink.net.au
8596 32 29_DB2 Workfile Space Management10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Tue, 6 Apr 2010 18:04:41 -0400405_UTF-8 This is in DB2 9 for z.os
Per prod subsystem we have defined 10 32k workfile tablespaces with 2GB primary each.
So far so good.
As processes come and sort the 10 datasets get extended (A0002, A0003 etc)
Over time some of the workfile tablespaces allocate quite a few datasets.
Is the best (only?) way to handle this growth to drop and re-create the workfile tablespaces? [...]53_3102353371243995.WA.jorghluekebcbsmn.com@www.idug.org
8629 67 81_Re: Index-controlled to Table-controlled partitioning - Performance benefits poll12_Hepp Shery C21_Shery.Hepp@SRPNET.COM30_Tue, 6 Apr 2010 15:36:44 -0700691_utf-8 Sameer, I'm not sure about specific performance benefits between the two, but we converted ALL of our index partitioned tables to table controlled partitioning. We have experienced no performance impacts. (DISCLAIMER: we only converted the partitioning. We have not (nor do we plan to) convert NPI's to DPSI's)
The main reasons for doing the conversion to table controlled partitioning was from a maintenance standpoint. Index controlled still requires unloads/drops/reloads when making certain changes. You have much more flexibility with making changes when table controlled partitioned. Plus the conversion is super simple and requires virtually no down time. For us it [...]55_4B518F9CD247DA458840B9A5B9435D1602F5BE36@EXCV25.srp.gov
8697 471 63_[FLUFF} Re: IBM DB2 Database Administration Certification - 73216_Daniel Luksetich18_danl@DB2EXPERT.COM30_Tue, 6 Apr 2010 19:33:54 -0500454_US-ASCII First of all thanks to Vivek and Phil S for purchasing a copy, and thanks
to Martin for standing up to the authors of copyrighted material. I did
recently eliminated all non-purchased music on my computer and have been
paying for everything.
Also thanks to everyone who commented on the amazing amount of money I make
as a DB2 z/OS consultant. Hysterical!!! I'm actually cross-platform so I
rake it in even double ;-) [...]35_000901cad5ea$2e3a59c0$8aaf0d40$@com
9169 107 88_Re: [SPAM] Index-controlled to Table-controlled partitioning - Performance benefits poll16_Daniel Luksetich18_danl@DB2EXPERT.COM30_Tue, 6 Apr 2010 19:33:54 -0500568_UTF-8 Hello,
There is no immediate advantage. However, if switching to table controlled allows you to eliminate an index then you can save on insert and delete costs. For example, if you have a partitioning index on col1, col2 you could also have a unique index on col1, col2, col3. Any queries that use the col1, col2 index can possibly switch to the col1, col2, col3 index, but this will have to be tested on a statement by statement basis. In addition, if you drop the partitioning index on col1, col2 then it is the clustering index and you've dropped the [...]35_001901cad5ea$54d72590$fe8570b0$@com
9277 50 80_Re: Does DB2 drive an exit when a member in a data sharing group changes status?15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM30_Wed, 7 Apr 2010 09:41:45 +0300445_us-ascii On Wed, 7 Apr 2010 07:42:26 +1000 James Campbell
wrote:
:>Another option for Up/Down would be to monitor the ERLY block (hangs off the SSVT). (I
:>put some REXX code to create a DB2 menu in the Code Place - this will give an example.)
That only works if the data sharing group is on the same main. There is no way
to access the ERLY of a DB2 on a different system in the sysplex. [...]42_q5aor51vs0uul213qgu9bmrt5fco6f1h2h@4ax.com
9328 77 81_Re: Index-controlled to Table-controlled partitioning - Performance benefits poll13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Wed, 7 Apr 2010 04:01:56 -0400512_utf-8 You might also want to consider that if your index controlled partitioned objects really are "very old" then regardless of the high limit key on the last partition, there may well be rows in there with even HIGHER keys.
Phil Grainger
Cogito Ltd.
phil.grainger@cogito.co.uk
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk
Attend IDUG 2010 - Europe, the premiere event for DB2 professionals.
8-12 November 2010, Vienna
Learn more at http://www.idug.org [...]58_4440F5DA00E3F3459BBCB97431B91B6611B01172@MAILR004.mail.lan
9406 51 33_Re: DB2 Workfile Space Management13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Wed, 7 Apr 2010 04:04:34 -0400361_utf-8 Jorg
I'd like to ask you a question in return first please
You have 10 x 2Gb (minimum) of work file allocation - that's 20Gb (and growing by the sound of it)
What on earth are your users doing??
Have you analysed why there is such usage?
Is it all sorting, all scrollable cursors, all DGTTs - or some combination?? [...]58_4440F5DA00E3F3459BBCB97431B91B6611B01173@MAILR004.mail.lan
9458 111 88_Re: [SPAM] Index-controlled to Table-controlled partitioning - Performance benefits poll13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Wed, 7 Apr 2010 04:09:24 -0400524_utf-8 " but this will have to be tested on a statement by statement basis " - hmmm......
Sounds like what is needed is some sort of tool that could mimic dropping an index (perhaps by using the virtual index support in DB2 V8 and 9) and then reanalyze an entire SQL workload to see what improved and what got worse. Something like EZ-Index Analyzer perhaps? Or EZ-Impact Analyzer - see http://www.cogito.co.uk/ezdb_db2.htm and beyond for more details. Or contact me off list
[...]58_4440F5DA00E3F3459BBCB97431B91B6611B01174@MAILR004.mail.lan
9570 50 80_Re: Does DB2 drive an exit when a member in a data sharing group changes status?14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Wed, 7 Apr 2010 22:03:56 +1000562_US-ASCII You are unable to send a message from one system to another???
James Campbell
On 7 Apr 2010 at 9:41, Binyamin Dissen wrote:
> On Wed, 7 Apr 2010 07:42:26 +1000 James Campbell
> wrote:
>
> :>Another option for Up/Down would be to monitor the ERLY block (hangs off the SSVT). (I
> :>put some REXX code to create a DB2 menu in the Code Place - this will give an example.)
>
> That only works if the data sharing group is on the same main. There is no way
> to access the ERLY of a [...]49_4BBD014C.13080.1A29596C@jacampbell.acslink.net.au
9621 116 81_Re: Index-controlled to Table-controlled partitioning - Performance benefits poll10_Dave Nance16_dav1mo@YAHOO.COM30_Wed, 7 Apr 2010 05:15:01 -0700600_iso-8859-1 Sameer, I do not have exact stats. I did, however work with a very large government agency a few years back, where we were able to save a huge amount of DASD by switching to table controlled partitioning. The partitioned index was ONLY used for partitioning, not by the app at all, in fact, the app knew nothing about the partitioning key. So switching was a no brainer. Aside from huge amounts of DASD savings (a few of the tables were in the billions of rows)there were, also, CPU improvements on insert/load performance. David Nance ________________________________ From: [...]43_764050.13377.qm@web57802.mail.re3.yahoo.com
9738 142 33_Re: DB2 Workfile Space Management10_Max Scarpa16_mscarpa@CESVE.IT30_Wed, 7 Apr 2010 15:11:20 +0200393_US-ASCII HI all
I had in a recent past a 'semi-periodic' shortage in workfile and it was
due to some query doing 'something' using LOB objects. I had to add many
new DSNDB07 files many times (it was in V8).
After a brief check it came out a query (it was a 3rd party application)
processing some historical data (a lot !). It could be scroll. cursors,
triggers, [...]66_OF71AB8444.9AAEA3D4-ONC12576FE.00437BAF-C12576FE.00481236@cesve.it
9881 27 29_Re: DB2 for z/OS RUNSTATS etc11_Roy Boxwell16_R.Boxwell@SEG.DE30_Wed, 7 Apr 2010 15:14:14 +0200388_US-ASCII well there is the IBM Performance guide with everything in it or there's
even my Runstats Master ppt file (Which contains lots of RUNSTATS tips and
tricks) I find the Runstats Master, the DFSORT survival guide and the RTS
and RUNSTATS hot APAR list are my top three things I send out...
If you're interested drop me a line off list and I mail 'em all to ya! [...]64_OFA5A25906.AEB910C5-ONC12576FE.0048B6D9-C12576FE.0048B6DD@seg.de
9909 34 57_DB2 Connect and DB2 for z/OS - encrypting user/password ?11_Nenad Vidak21_nenad.vidak@GMAIL.COM30_Wed, 7 Apr 2010 09:38:57 -0400520_UTF-8 Hello,
I'm a bit confused about security options in DB2 connect when configuring connection to DB2 for z/OS :
Running DB2 V9 NFM and DB2 Connect 9.5 :
1. which (if any) encryption will be in use if I choose:
a) Use authentication value in server's DBM Configuration ?
b) Server authentication (SERVER) + Enable Encription ? ( DES, AES or ...)
2. is there a way on DB2 z/OS to disable DRDA access from clients that don't use encryption?
3. should I forget all together and switch to SSL ? [...]53_6278277361380085.WA.nenad.vidakgmail.com@www.idug.org
9944 581 67_Re: [FLUFF} Re: IBM DB2 Database Administration Certification - 73214_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Wed, 7 Apr 2010 09:56:16 -0400390_us-ascii Dan:
Just FYI, I purchased hardcopy only because there wasn't a Kindle edition available. I'd much prefer softcopy, even with DRM-locking. If anyone asks your opinion as an author, your fans (!) - at least some of them - would prefer to see this kind of material online. I'd even pay for a subscription to receive updates, for this kind of career-critical material.
-ps [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC467BE@MAIL02.fisalan.nycnet
10526 99 81_Re: Index-controlled to Table-controlled partitioning - Performance benefits poll14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Wed, 7 Apr 2010 09:59:11 -0400568_us-ascii Willie,
Just as long as they don't deprecate NPSIs! And... would deprecating table-controlled partitioning eliminate our ability to create unique partitioned indexes subject to the partitioning key being the first n columns of the index? Say it ain't so!
--ps
-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Willie Favero
Sent: Tuesday, April 06, 2010 5:18 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Index-controlled to Table-controlled partitioning - Performance benefits poll [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC467BF@MAIL02.fisalan.nycnet
10626 42 67_Re: [FLUFF} Re: IBM DB2 Database Administration Certification - 73210_Joe Geller21_joerg6666@HOTMAIL.COM30_Wed, 7 Apr 2010 10:16:03 -0400416_UTF-8 Actually, there is a version online available to members of the ACM
(Association for Computing Machinery). The ACM has many books
(through Books 24X7) and online courses available to its members.
The books are free with membership (which you pay for). I don't
know if Dan gets any royalties for this, but I would assume his
publisher does (which of course wouldn't be fair if Dan doesn't). [...]53_8369865892267481.WA.joerg6666hotmail.com@www.idug.org
10669 41 33_Re: DB2 Workfile Space Management10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Wed, 7 Apr 2010 10:22:55 -0400541_UTF-8 Phil,
I ask myself what are they doing almost every day :-)
Seriously we have one set of business users that use an old warehouse. I don't like the design because because for every question about claims they will usually need three queries and 2-5 joins. These queries look back 3months - 3 years which is a lot of data, and for big joins a lot of workfile usage. We do have SAS, and I figured out for them how to run queries for just the past month and then merge that with SAS files fom previous months (much more [...]53_2631531631452499.WA.jorghluekebcbsmn.com@www.idug.org
10711 143 81_Re: Index-controlled to Table-controlled partitioning - Performance benefits poll13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Wed, 7 Apr 2010 10:31:21 -0400347_iso-8859-1 Phil
Two points
1. If a partitioned index includes the partition key at it's "high" end, it's not a DPSI so will always allowed to be unique (it's just a partitioned index)
2. Some DPSIs are also now allowed to be unique - IF they contain (anywhere) the partitioning key columns
Hope this relaxes you a tad [...]58_4440F5DA00E3F3459BBCB97431B91B6611B011BE@MAILR004.mail.lan
10855 283 67_Re: [FLUFF} Re: IBM DB2 Database Administration Certification - 73213_Michael Ebert18_mebert@AMADEUS.COM30_Wed, 7 Apr 2010 15:00:52 +0000374_ISO-8859-1 Purchasing copyrighted material benefits the authors only marginally. Most
goes to the Fat Cats. Self-publishing on the internet and asking for a
small fee, or even just a donation, cuts out the sticky-fingered
middlemen. Oh well, there's enough discussion in the WWW about copyright
and intellectual property if you care for that sort of thing. [...]69_OF9A4577EC.1B52B282-ON002576FE.0051AF81-C12576FE.00527A1A@amadeus.com
11139 674 67_Re: [FLUFF} Re: IBM DB2 Database Administration Certification - 73214_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Wed, 7 Apr 2010 11:10:33 -0400540_iso-8859-1 Michael, if someone published a major DB2 book without peer review and professional editing, I'd be reluctant to spend serious money on it. Significant value is added by the so-called "Fat Cats" in many, if not most, cases. Self-publishing cuts costs but also, in many cases, cuts value.
I refer you to John Scalzi's post on the subject for some relevant numbers and considerations, at
http://whatever.scalzi.com/2010/02/03/why-in-fact-publishing-will-not-go-away-anytime-soon-a-deeply-slanted-play-in-three-acts/ [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC467C0@MAIL02.fisalan.nycnet
11814 653 67_Re: [FLUFF} Re: IBM DB2 Database Administration Certification - 73223_Jeffrey Benner, DB2 DBA22_consulting@EBENNER.COM30_Wed, 7 Apr 2010 08:35:38 -0700604_windows-1252 "Professional editing" is no guarantee of quality. Roger Sanders' latest DB2
LUW v9 Advanced DBA certification guide has at least a couple dozen typos
and errors, spelling errors, problems with the index and table of contents,
etc. Just because it has been published by a dead tree company doesn't mean
it has been seriously proofread and edited. OTOH I have gotten huge value
from articles written by "self-published" DB2 and Unix bloggers on the
Internet. Once you gain a certain level of experience you can begin to
separate the gold from the dross on your own. [...]62_l2oa19d988c1004070835v1a274b79ze48111cc03c8ef53@mail.gmail.com
12468 26 33_Re: DB2 Workfile Space Management10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Wed, 7 Apr 2010 10:25:24 -0400302_UTF-8 Max,
I've been looking for accounting info on users that I can use for a report but I haven't found anythign yet that tells me something like workfiles allocated by corrname. That's what I'd like. I know pretty much who is doing the usage, but it's always best to have the hard data. [...]53_2776142313041093.WA.jorghluekebcbsmn.com@www.idug.org
12495 159 67_Re: [FLUFF} Re: IBM DB2 Database Administration Certification - 73213_Willie Favero21_wfavero@ATTGLOBAL.NET30_Wed, 7 Apr 2010 11:42:35 -0500619_windows-1252 Phil,
I'm with you on the Kindle stuff... I have found few if any technical
books that are Kindle ready. I keep clicking the little that says to
let the publisher know I want this book for my Kindle.
So all you authors, suggest Kindle format as an alternate publishing
format your books..
Willie
On 4/7/2010 8:56 AM, Sevetson, Phil wrote:
> Dan:
>
> Just FYI, I purchased hardcopy only because there wasnt a Kindle
> edition available. Id much prefer softcopy, even with DRM-locking. If
> anyone asks your opinion as an author, your fans (!) at [...]30_4BBCB5FB.8000604@attglobal.net
12655 70 38_Lack of DBA's harms the market for DB223_Jeffrey Benner, DB2 DBA22_consulting@EBENNER.COM30_Wed, 7 Apr 2010 09:50:21 -0700392_ISO-8859-1 In recent contract negotiations I came to learn that two separate companies
were so discouraged by their inability to find DB2 LUW database admins that
they were considering going to Oracle; simply because they perceived there
to be many more Oracle DBAs. The lack of DBA's seems to be a bottleneck in
the use of the product in at least some parts of the country. [...]62_l2ia19d988c1004070950uebc29e84j5025074ce4bcbcc7@mail.gmail.com
12726 66 20_Separation of Duties14_Renzo razzetti24_renzo.razzetti@GMAIL.COM30_Wed, 7 Apr 2010 14:12:41 -0300386_windows-1252 Hello Everybody!!!
In DB2 9.7 LUW there is a new feature, Separation of Duties features, that
's means for newly created* *databases in DB2 9.7 are:
The SYSADMs no longer implicitly get DBADM authority, which means they
dont automatically get data access.
When is the feature available in DB2 z/OS ???? Anybody know ?
Thanks and Regards [...]62_g2i933265621004071012k652b442dr219e6565d229af60@mail.gmail.com
12793 335 42_Re: Lack of DBA's harms the market for DB220_Govan, Hal (RET-DAY)29_Harold.Govan@REEDELSEVIER.COM30_Wed, 7 Apr 2010 13:13:06 -0400800_us-ascii APPLAUSE, APPLAUSE !
Hal Govan
Senior Database Administrator
Reed Elsevier - Technology Services
harold.govan@reedelsevier.com
Phone: (937) 865-7820
________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jeffrey
Benner, DB2 DBA
Sent: Wednesday, April 07, 2010 12:50 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] Lack of DBA's harms the market for DB2
In recent contract negotiations I came to learn that two separate
companies were so discouraged by their inability to find DB2 LUW
database admins that they were considering going to Oracle; simply
because they perceived there to be many more Oracle DBAs. The lack of
DBA's seems to be a bottleneck [...]70_B2E52C321789B2499E54141B682F43781AC83ED1@LNGDAYEXCP01VA.legal.regn.net
13129 99 33_Re: DB2 Workfile Space Management10_Max Scarpa16_mscarpa@CESVE.IT30_Wed, 7 Apr 2010 19:40:06 +0200422_US-ASCII Jorg
I think IFCID 342 could provide some indications as it gives workfile
usage per agent. From IBM redbook:
"This can be a very interesting IFCID for monitors to trigger exceptions,
for example, to catch
runaway queries before the monopolize the system and cause other
applications to fail,
because the workfile database and TEMP database are shared amongst all DB2
users." [...]66_OFC20B59AD.D67DDBFF-ONC12576FE.005F50A3-C12576FE.0060AD6C@cesve.it
13229 299 42_Re: Lack of DBA's harms the market for DB213_George Toolan19_gtoolan@COMCAST.NET30_Wed, 7 Apr 2010 13:55:04 -0400396_us-ascii I have found that when you are a very senior mainframe DB2 DBA in a large
corporation, management will usually not give you the time or opportunity to
learn/support distributed databases. The best I could do at my last employer
is get to the IBM DB2 LUW course for mainframe DBA's. The training is all on
the W platform while customers are interested in AIX experience. [...]35_00b201cad67b$74162410$5c426c30$@net
13529 396 42_Re: Lack of DBA's harms the market for DB214_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Wed, 7 Apr 2010 14:24:14 -0400453_us-ascii I'd love to take a position (somewhere in the New York/Philadelphia corridor) where they'd consider my DB2 z/OS experience an _asset_ in dealing with learning DB2 on AIX. Any takers?
-ps
________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of George Toolan
Sent: Wednesday, April 07, 2010 1:55 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Lack of DBA's harms the market for DB2 [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC467C5@MAIL02.fisalan.nycnet
13926 58 33_Re: DB2 Workfile Space Management10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Wed, 7 Apr 2010 14:30:48 -0400455_UTF-8 Max,
Thanks. What I just did is looked at the BP getpages requests to BP7 and BP32K7.
Converting the getpages into space, we were averaging about 20GB of DSNDB07 getpage
requests per hour. When this one very bad redesign went in teh request went up to 275GB per hour.
Hence the sudden increase in allocation of workfiles. Of course each time this thing runs on
a different data sharing member more workfiles get created. [...]53_1625663019867084.WA.jorghluekebcbsmn.com@www.idug.org
13985 104 42_Re: Lack of DBA's harms the market for DB28_duam lee20_duam_lee@HOTMAIL.COM30_Wed, 7 Apr 2010 18:32:13 +0000451_ks_c_5601-1987 Hi Jeff,
I appreciate your message, but not agreeing on this below comments.
This is not true hence more.
"Even offshoring is not an option because all you find over there is generally junior level script monkey talent"
With Thanks
Duam.
Date: Wed, 7 Apr 2010 09:50:21 -0700
From: consulting@EBENNER.COM
Subject: [DB2-L] Lack of DBA's harms the market for DB2
To: DB2-L@IDUGDB2-L.ORG [...]43_SNT137-w2676D25CB78FFD6F94E1FAE1170@phx.gbl
14090 488 42_Re: Lack of DBA's harms the market for DB27_Kim May28_kim.may@THEFILLMOREGROUP.COM30_Wed, 7 Apr 2010 14:48:56 -0400493_us-ascii Oracle and Microsoft both have healthy training channel ecosystems that
provide local training in most major metropolitan areas. The availability
of training seeds the market and supports adoption of their products. My
company has struggled - year after year - to be "allowed" to provide IBM
authorized training - in spite of being an IBM Business Partner for over
twenty years and having a close-to-perfect class delivery history, and a
really nice classroom. [...]45_4bbcd39f.9915f10a.0846.ffffec3c@mx.google.com
14579 92 42_Re: Lack of DBA's harms the market for DB215_Chris Hoelscher21_choelscher@HUMANA.COM30_Wed, 7 Apr 2010 15:10:14 -0400500_US-ASCII i can only speak for myself - i do not think i would have difficulty
learning DB2 for LUW - what i *would* need training for is finding my way
around L or U or W - THAT is the problem as i see it
at our site - our MF system DBA team is acquiring support responsibilities
for DB2 connect - learning DB2 connect does not appear to be the problem -
having access to and learning to access the platforms upon which DB2
Connect resides will be the big hurdle here..... [...]68_OFBB4C6BF1.C0ADB373-ON852576FE.0068E32C-852576FE.00694EAC@humana.com
14672 110 42_Re: Lack of DBA's harms the market for DB28_Nagasuri20_r_nagasuri@YAHOO.COM30_Wed, 7 Apr 2010 12:35:27 -0700345_iso-8859-1 I wonder to here this.
I am working as DB2 UDB DBA for last 9+ years and most of the time it is short term contracts. I am willing to take a fulltime DB2 (LUW) DBA for last two years.
Recently, I had to switch to UNIX admin though I am experienced and certified in both DB2 (LUW), AIX, SUN Solaris administration. [...]44_600060.38059.qm@web113802.mail.gq1.yahoo.com
14783 97 31_DB2 V81 z/OS - running DSNTIJP915_Chris Hoelscher21_choelscher@HUMANA.COM30_Wed, 7 Apr 2010 15:50:38 -0400419_US-ASCII good evening all
i an running DSNTIJP9 in preparations of someday migrating to v 9.1
we are seeing something odd in the report
report 9 - a STATUS of 'I' (shich indicates table definition is not fully
complete) but a TABLESTATUS of blank (which indicates table definition IS
complete)
any guidence on resolving this seeming contradiction would be greatly
appreciated! [...]68_OF9DB4270D.E9738FEF-ON852576FE.006C9AA9-852576FE.006D0186@humana.com
14881 38 33_Re: DB2 Workfile Space Management14_Paul Peplinski24_Paul.Peplinski@WPSIC.COM30_Wed, 7 Apr 2010 15:58:40 -0400479_UTF-8 >>You have 10 x 2Gb (minimum) of work file allocation - that's 20Gb (and growing by the sound of it)
>>
>>What on earth are your users doing??
>>
>>Have you analysed why there is such usage?
>>
>>Is it all sorting, all scrollable cursors, all DGTTs - or some combination??
I have 44 32K and 24 4K 2G spaces - and still run out with reason 00C90085. No DGTTs yet. Last count was 27 million tracks. Not sure if that was all DSNDB07 or just 32K. [...]56_2767738045911146.WA.Paul.Peplinskiwpsic.com@www.idug.org
14920 28 46_Adding an IDENTITY column to an existing table12_George White25_george_white@VANGUARD.COM30_Wed, 7 Apr 2010 16:20:51 -0400403_UTF-8 I have an existing, populated table which requires an alternate key added for referential constraint purposes. We have looked at other columns in the table and have determined that none are candidates for creating a unique index to be used for RI purposes.
Therefore, can someone describe the steps I would need to take, and in what order, to add a new column to the table using IDENTITY? [...]56_3489396094640654.WA.georgewhitevanguard.com@www.idug.org
14949 164 50_Re: Adding an IDENTITY column to an existing table12_Paul Ogborne19_paulogborne@AOL.COM30_Wed, 7 Apr 2010 16:42:52 -0400525_us-ascii Hi George,
In my experience it is a nuisance having an identity column in a table with other columns. Far better to define a single (identity) column table that you can insert into to obtain new unique keys for your existing table (then run a truncate/delete/load replace overnight to clear it down). This solution performs well in data sharing etc.
If you are not tied into an identity column solution then I would also consider a 'sequence'; this will also provide performance in data sharing etc.. [...]56_8CCA4AA0744C871-12FC-2916@webmail-stg-m04.sysops.aol.com
15114 56 50_Re: Adding an IDENTITY column to an existing table14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Wed, 7 Apr 2010 16:50:46 -0400370_us-ascii George,
My brain is trying to explode after not being able to figure out why you need a synthetic key for RI purposes. Doesn't the information in the table give you the link to the "parent" table? If it's not well-defined relationally, shouldn't you be using INSERT and UPDATE Triggers instead of declarative Referential Integrity, in this case?
-ps [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC467CB@MAIL02.fisalan.nycnet
15171 385 42_Re: Lack of DBA's harms the market for DB212_Phil Gunning19_pkgunning@GMAIL.COM30_Wed, 7 Apr 2010 18:28:03 -0400382_us-ascii Actually, I haven't seen this to be the case. I work with DB2 LUW DBAs
around the country in all regions and there seems to be plenty of them out
there. We remain quite busy with remote DB2 consulting or onsite work. We
don't work through recruiters though. PG
Phil Gunning
IBM Information Champion
The World Leader in DB2 LUW Consulting [...]35_01be01cad6a1$97d29700$c777c500$@com
15557 343 42_Re: Lack of DBA's harms the market for DB217_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM30_Wed, 7 Apr 2010 23:53:10 +0100520_us-ascii this topic seems to re-surface every 14 months or so, and it is always
very interesting.
To look at a slightly different consequence of the lack of mainframe DB2
jobs, I will reply again what I replied last year, i.e. quoting Ed
Vassie who is now working on SQL Server and said it was the easiest
thing in the world for him to "convert" or adapt is MF DB2 skills...
because the training and mindset he got in all his years as a MF DB2
specialist are rare in the distributed world. [...]56_3D02E8610514C04F991CF832BA154C66105671BF@UKSLMS11.ca.com
15901 37 42_Re: Lack of DBA's harms the market for DB211_Ted MacNEIL18_eamacneil@YAHOO.CA30_Wed, 7 Apr 2010 23:19:26 +0000501_Windows-1252 >This is not true hence more.
>"Even offshoring is not an option because all you find over there is generally junior level script monkey talent"
Just because you state it, it is not necessarily accurate.
I've been involved in offshoring, and have found talent lacking.
For whatever reasons, it is still generally true:
Lack of educational institutions?
Lack of commitment from offshore/onshore management?
Lack of commitment from staff?
High turnaround? [...]104_555123064-1270682362-cardhu_decombobulator_blackberry.rim.net-2083928159-@bda026.bisx.prod.on.blackberry
15939 269 33_Re: DB2 Workfile Space Management35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM30_Wed, 7 Apr 2010 20:34:16 -0400594_UTF-8 Jorg,
I'm not questioning whatever you see regarding usage.....
However, you cannot create any relationship between getpages and object size/usage.
Do you access 1 page 1,000,000 times, or 1,000,000 pages once each?
Unless you run a buffer manager trace, you can't know.
Regards,
Joel
Joel Goldstein
Responsive Systems
IBM Gold Consultant
Buffer Pool Tool for DB2, the worldwide industry standard
Performance software that works...... Predicts IO Rate !!
Predicts Group Buffer Pool performance too
www.responsivesystems.com [...]46_A430C83B7D844D47AE4CB9CEFE1C68DA@DellNotebook3
16209 68 50_Re: Adding an IDENTITY column to an existing table12_Myron Miller22_myronwmiller@YAHOO.COM30_Wed, 7 Apr 2010 18:32:05 -0700436_us-ascii Don't do it. It will create no end of headaches down the line if you ever have to copy the table's data to other environments. Make it a column that holds a value from a sequence number or from another standalone identity column table. Don't create an identity column just for this table. I've been there and regret that identity columns were ever invented for this purpose. It's been many hundreds of hours of headaches. [...]44_625743.41091.qm@web112103.mail.gq1.yahoo.com