1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l April 2009, week 5
2 317 146_Upcoming IDUG Webcast - "DB2 LUW PERFORMANCE AND IT COST OPTIMIZATION FOR A SMARTER PLANET" - Wednesday May 6 at 9:30 am USA Central Daylight Time13_David Chapman24_David.Chapman@IAG.COM.AU31_Wed, 29 Apr 2009 12:41:13 +1000764_us-ascii
_______________________________________________________________________________________
Note: This e-mail is subject to the disclaimer contained at the bottom of this message. _______________________________________________________________________________________
Hello DB2 List,
DB2 LUW PERFORMANCE AND IT COST OPTIMIZATION FOR A SMARTER PLANET - Scott Hayes, DBI Software
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. [...]
320 284 27_URGENT :load Delimited file13_Laila hosaini19_lshosaini@YAHOO.COM31_Tue, 28 Apr 2009 22:09:38 -0700283_utf-8
Hi Dear Listers I'm trying to load a Delimited file to a DB2 V9.1 /zos,I got this error"   DSNURCON - INPUT FIELD 'RETAILER_ID',  INVALID FOR 'OIL.RETAILER_OIL11',                ERROR CODE '02 - INPUT NUMERIC INVALID'         [...]
605 86 31_Re: DB2 for z/OS v9 C question.11_Nenad Vidak21_Nenad.Vidak@GMAIL.COM31_Wed, 29 Apr 2009 06:07:51 +0000329_ISO-8859-1 I always allocate WORK TS VSAM dataset with the secondary allocation set to zero, otherwise its size is driven by the amount of data being sorted. If there is a real need for additional space, I allocate/add a new dataset ...
On Tue, 28 Apr 2009 18:19:23 +0200, Hanne Lyssand wrote: [...]
692 133 31_Re: DB2 for z/OS v9 C question.14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 29 Apr 2009 08:32:19 +0100418_iso-8859-1 Snag is, currently in DB2 9 you need
1. Work table spaces with ZERO secondary allocations to ensure that sorting can be spread over multiple page sets, without driving a single one into multiple secondaries 2. Work table spaces with NON-ZERO secondary allocations to ensure that scrollable cursors and temp tables (which CANNOT span work page sets) do not fail if they fill up a single page set [...]
826 304 31_Re: URGENT :load Delimited file0_29_Onder.CAGATAY@HALKBANK.COM.TR31_Wed, 29 Apr 2009 11:04:17 +0300490_utf-8
I think you need also specify the format for decimal numbers, can you try with DECPT option by adding it in the FORMAT DELIMITED..
Önder Çağatay Halkbank IT Speciailist - DBA E-mail : onder.cagatay@halkbank.com.tr
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Laila hosaini Sent: Wednesday, April 29, 2009 8:10 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] URGENT :load Delimited file [...]
1131 54 65_V8 - How to scan SYSPACKSTMT for a particular string of character3_duc17_ndt.db2@GMAIL.COM31_Wed, 29 Apr 2009 10:48:53 +0200367_ISO-8859-1 Dear all ,
We are trying to locate updates with a particular string on a table
SELECT NAME, STMTNO, STMTNOI, STMT FROM SYSIBM.SYSPACKSTMT WHERE NAME = 'DVB170' AND STMT LIKE '%DVA037%' AND NOT (STMTNO=0 AND SEQNO=0 AND SECTNO=0) ORDER BY STMTNO, STMTNOI;
With QMF , we see the string 'DVA037' , but the select returns 0 rows .... [...]
1186 164 42_Betr.: [DB2-L] URGENT :load Delimited file16_Ralph van Zagten32_ri.van.zagten@BELASTINGDIENST.NL31_Wed, 29 Apr 2009 10:54:29 +0200366_iso-8859-1 I had some problems with UNLOAD DELIMITED COLDEL ',' in combination with decimal columns, because the Z-parm for the decimal point in our shop is also defined as ','
Maybe you kan try to adjust the syspunch and change the column specification DECIMAL EXTERNAL(8,0) in INTEGER EXTERNAL(8) :
"RETAILER_ID" POSITION(*) INTEGER EXTERNAL(8) [...]
1351 193 82_Antwort: [DB2-L] V8 - How to scan SYSPACKSTMT for a particular string of character11_Roy Boxwell16_R.Boxwell@SEG.DE31_Wed, 29 Apr 2009 10:56:12 +0200588_ISO-8859-1 unicode???
Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Straße 5 40470 Düsseldorf/Germany Tel. +49 (0)211 96149-675 Fax +49 (0)211 96149-32 Email: R.Boxwell@seg.de http://www.seg.de
Software Engineering GmbH Amtsgericht Düsseldorf, HRB 37894 Geschäftsführung: Siegfried Fürst, Gerhard Schubert
duc Gesendet von: DB2 Data Base Discussion List 29.04.2009 10:48 Bitte antworten an DB2 Database Discussion list at IDUG [...]
1545 202 68_AW: [DB2-L] DB2 for z/OS Version 9 - problem with unicode conversion0_26_Walter.Janissen@ITERGO.COM31_Wed, 29 Apr 2009 10:56:48 +0200498_iso-8859-1 Jim
We saw this after migrating to DB2 V8 mainly in or developments systems, where a lot of SET CURRENT PACKAGESETs (almost before every SQL-statement) were executed. Because the special register is UNICODE, but the host variable isn't, a lot of conversion took place.
Mit freundlichen Grüßen Walter Janißen
ITERGO Informationstechnologie GmbH Anwendungsentwicklung Laufzeitarchitektur Victoriaplatz 2 40198 Düsseldorf mailto:walter.janissen@itergo.com [...]
1748 227 86_Re: Antwort: [DB2-L] V8 - How to scan SYSPACKSTMT for a particular string of character3_duc17_ndt.db2@GMAIL.COM31_Wed, 29 Apr 2009 11:00:47 +0200654_ISO-8859-1 Yes , the table is in Unicode (V8) but the STMT contents is in EBCDIC (NEWFUN=NO)
On Wed, Apr 29, 2009 at 10:56 AM, Roy Boxwell wrote:
> > unicode??? > > > * > Roy Boxwell* > SOFTWARE ENGINEERING GMBH > -Product Development-* > Robert-Stolz-Straße 5 > 40470 Düsseldorf/Germany > Tel. +49 (0)211 96149-675 > Fax +49 (0)211 96149-32 > Email: R.Boxwell@seg.de > http://www.seg.de > > Software Engineering GmbH > Amtsgericht Düsseldorf, HRB 37894 > Geschäftsführung: Siegfried Fürst, Gerhard Schubert > * > > > *duc * > Gesendet von: DB2 Data Base Discussion List > > [...]
1976 35 31_Re: DB2 for z/OS v9 C question.13_Hanne Lyssand20_Hanne.Lyssand@VPS.NO31_Wed, 29 Apr 2009 11:31:34 +0200319_iso-8859-1 Temporary-tables can not switch tablespace, this could also be a reason to have secondary allocation on your work-files.
There was early one a problem with freeing space used for temporary tables in some special cases, so if you use temporary tables it could be a good idée to check into PK72190 [...]
2012 88 45_Re: Mainframe Cobol SQL programming guideline0_17_Rolf.Drees@GAD.DE31_Wed, 29 Apr 2009 11:20:45 +0200451_ISO-8859-1 Another point for every SQL (not only COBOL): In SQLs that reference more than one table use always correlation-ids! Qualify any column-reference with correlation-ids wherever it occurs (where-clause, select-clause, on-clause, group-by ... and so on). A simple rule that clarifies a lot.
Kind regards Rolf Drees Anwendungsentwicklung Querschnittsfunktionen / Datenbankmanagement Tel.: 0251 7133 - 2238 ; Fax.: 0251 7133 - 92238 [...]
2101 90 72_Re: AW: [DB2-L] DB2 for z/OS Version 9 - problem with unicode conversion12_Jim McAlpine22_jim.mcalpine@GMAIL.COM31_Wed, 29 Apr 2009 11:09:10 +0100424_ISO-8859-1 On Wed, Apr 29, 2009 at 9:56 AM, wrote:
> Jim > > We saw this after migrating to DB2 V8 mainly in or developments systems, > where a lot of SET CURRENT PACKAGESETs (almost before every SQL-statement) > were executed. Because the special register is UNICODE, but the host > variable isn't, a lot of conversion took place. > > > Mit freundlichen Grüßen > Walter Janißen > > [...]
2192 256 80_AW: [DB2-L] AW: [DB2-L] DB2 for z/OS Version 9 - problem with unicode conversion0_26_Walter.Janissen@ITERGO.COM31_Wed, 29 Apr 2009 12:37:08 +0200478_iso-8859-1 Hi Jim
The special register in DB2, I am referring to is CURRENT PACKAGESET. I can assign a value to that register by executing:
EXEC SQL SET CURRENT PACKAGESET TO :Host-Variable END-EXEC
By doing this, I control, which Packagelist-entry to take, to fetch a package from the SPT01.
We can't fix this problem, because this is working as designed and we have to live with it. But now we have an explanation for the increased CPU-usage. [...]
2449 32 32_Re: IDUG 2010 - North America ??11_Paul Turpin16_pault3@YAHOO.COM31_Wed, 29 Apr 2009 10:52:21 +0000412_ISO-8859-1 Mark is correct about the location of the IDUG 2010 North America (NA) Conference. The Planning Committee is busy at work planning for the IDUG 2010 NA Conference. The 2010 Conference will be held in Tampa, Florida, May 10 - 14, 2010. After the IDUG 2009 North America conference ends, I will post some more details about the 2010 conference, here in DB2-L, so stay tuned for additional details. [...]
2482 122 11_unsubscribe26_Cavanaugh, Michael S WDC3127_Michael.Cavanaugh@CIGNA.COM31_Wed, 29 Apr 2009 07:39:27 -0400826_us-ascii
Mike Cavanaugh Enterprise Database Services Phone: (860)298-2178 / 3-2178 Email: michael.cavanaugh@cigna.com
Confidential, unpublished property of CIGNA. Do not duplicate or distribute. Use and distribution limited solely to authorized personnel. (c) Copyright 2009 CIGNA.
------------------------------------------------------------------------------ CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for [...]
2605 39 49_Re: Question ABout EBCIDIC DB creation on UDB 9.514_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 29 Apr 2009 22:28:20 +1000401_US-ASCII CREATE DATABASE .... USING CODESET IBM-37 TERRITORY US ... (if that's what you actually want).
Look for "Supported territory codes and code pages" in the documentation to see what's valid
James Campbell
On 28 Apr 2009 at 17:54, renusharma@AOL.COM wrote:
> > Hello list > > How can I create EBCIDIC code page for a udb 9.5 Database. > > Thanks > Renu Sharma > [...]
2645 39 77_Re: Help: Where can I find the toleration PTFS for DB2 v8.1 to support DB2 V914_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 29 Apr 2009 22:28:19 +1000682_US-ASCII http://www-01.ibm.com/support/docview.wss?uid=isg1II14401
Normal maintenance procedures will get you the actual PTFs.
James Campbell
On 28 Apr 2009 at 12:39, Clark, Kevin wrote:
> Are they on the IBM website ? > > Kevin "MVS GUY" not "DB2 GUY" Clark > > >
_____________________________________________________________________
* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA *
There is a discussion list for people who are going to IDUG NA09 in Denver - http://www.idug.org/cgi-bin/wa?A0=DB2-NA-IDUG-CONF-PARTICIPANT _____________________________________________________________________ [...]
2685 111 31_Re: URGENT :load Delimited file14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 29 Apr 2009 22:28:20 +1000589_ISO-8859-1 CHARDEL X'20'? Are you really delimiting character data with blanks? Because some of the blanks don't look like they are actually delimiters.
James Campbell
On 28 Apr 2009 at 22:09, Laila hosaini wrote:
> > > > Hi Dear Listers > I'm trying to load a Delimited file to a DB2 V9.1 /zos,I got this error" > > DSNURCON - INPUT FIELD 'RETAILER_ID', > INVALID FOR 'OIL.RETAILER_OIL11', > ERROR CODE '02 - INPUT NUMERIC INVALID' > Load statement is this: > LOAD DATA INDDN SYSREC LOG NO RESUME YES > ASCII > FORMAT DELIMITED COLDEL X'2C' CHARDEL X'20' > INTO [...]
2797 585 60_Re: Procedure for fallback from DB2 v8 ENFM/NFM to DB2 v8 CM14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 29 Apr 2009 22:28:19 +1000517_US-ASCII Few corrections - V8 format log records are written in V8 CM. I had reason to check this earlier today. - Consider a datasharing group, one member in V8 NFM, the others in V8 CM. A Recover is run on a V8 CM member. It has to be able to process the log records from V8 NFM - dunnit? (Similarly a V7 system would have to be able to process V8 CM log records.) - According to the Diag Guide, the only tablespace with an actual DB2 Version code is DSNDB01.DBD01. This, of course, does have to be restored - [...]
3383 137 86_Re: Antwort: [DB2-L] V8 - How to scan SYSPACKSTMT for a particular string of character3_duc17_ndt.db2@GMAIL.COM31_Wed, 29 Apr 2009 14:47:39 +0200707_ISO-8859-1 Finally, find this from IBM support
http://www-01.ibm.com/support/docview.wss?rs=0&uid=swg21203359
Question The following query returns no rows in DB2® Version 8 new-function mode:
SELECT * FROM SYSIBM.SYSPACKSTMT WHERE STMT LIKE '%DECLARE % CURSOR % FOR %' ;
Prior to Version 8 this query returned DECLARE CURSOR statements.
Cause The STMT column in catalog table SYSIBM.SYSPACKSTMT is defined as FOR BIT DATA in Version 8, because it contains both the statement text (either in UNICODE or EBCDIC) and various control blocks. Because the column is defined as FOR BIT DATA, it is treated as binary data and is not converted to EBCDIC for predicate [...]
3521 432 51_Tridex DB2 User Group Meeting Thursday May 7th (NY)20_Arettines, Angela M.29_Angela.Arettines@US.NGRID.COM31_Wed, 29 Apr 2009 09:24:30 -0400438_iso-8859-1
Fellow Listers, For those of you who have not yet heard about the upcoming Tridex DB2 User Group meeting, please see below. Regards, Angela
TRIDEX Second Quarterly User Group Meeting DON'T JUST KEEP UP - STAY AHEAD! All Meetings are FREE. You must Pre-register to Attend. Walk-in registration will not be accepted. A photo ID is required for building access. http://tridexdb2.natemurphy.net [...]
3954 96 86_Re: Antwort: [DB2-L] V8 - How to scan SYSPACKSTMT for a particular string of character9_Mike Bell21_mbell11a1@VERIZON.NET31_Wed, 29 Apr 2009 08:50:47 -0500598_US-ASCII Actually, it is even worse - because SYSPACKSTMT is FOR BIT DATA, the text is stored in the same format as the origional DBRM. So any V8 NEWFUN(NO) DBRM's will have the text in EBCDIC but NEWFUN(YES) will have unicode.
It makes for interesting SQL statements.
Mike HLS Technologies
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of duc Sent: Wednesday, April 29, 2009 7:48 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Antwort: [DB2-L] V8 - How to scan SYSPACKSTMT for a particular string of character [...]
4051 552 45_Re: Mainframe Cobol SQL programming guideline20_Bruzdzinski, Michael27_Michael.Bruzdzinski@SSA.GOV31_Wed, 29 Apr 2009 09:59:09 -0400604_us-ascii Thanks for becoming the 'editor'!
Michael Bruzdzinski
Social Security Administration
DCS/OESAE/DDBS/DBSB
410-966-7185
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Cuneyt Goksu (Gmail) Sent: Wednesday, April 22, 2009 10:36 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Mainframe Cobol SQL programming guideline
Thanks. I'm collecting all of them. When the guideline is finished, will send a note to DB2-L for interested people... [...]
4604 18 53_Re: Question: db2icrt failure at DB2 V9.5 on AIX V5.312_Ram Nagasuri20_r_nagasuri@YAHOO.COM31_Wed, 29 Apr 2009 13:59:22 +0000
4623 24 32_Re: IDUG 2010 - North America ??10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Wed, 29 Apr 2009 14:19:47 +0000498_windows-1252 That is the best location. I wonder if that one will also be the hardest to get to due to the economic climate.
_____________________________________________________________________
* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA *
There is a discussion list for people who are going to IDUG NA09 in Denver - http://www.idug.org/cgi-bin/wa?A0=DB2-NA-IDUG-CONF-PARTICIPANT _____________________________________________________________________ [...]
4648 22 32_Re: Clustering Index = Cluster N10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Wed, 29 Apr 2009 14:21:46 +0000635_windows-1252 Thanks Pat, that is good to know.
_____________________________________________________________________
* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA *
There is a discussion list for people who are going to IDUG NA09 in Denver - http://www.idug.org/cgi-bin/wa?A0=DB2-NA-IDUG-CONF-PARTICIPANT _____________________________________________________________________
IDUG North America 2008 Attendee Testimonial- "Each session I took away something that I could apply at my shop. I always learn something new." _____________________________________________________________________
4671 69 32_Re: IDUG 2010 - North America ??14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 29 Apr 2009 15:24:16 +0100533_iso-8859-1 Won't we have had "climate change" buy then?
I sure hope so (in this context anyway)
I've had Tampa in my diary for some time
Phil Grainger CA Senior Principal Product Manager Phone: +44 (0)1753 577 733 Mobile: +44 (0)7970 125 752 eMail: phil.grainger@ca.com
Ditton Park Riding Court Road Datchet Slough SL3 9LL
CA plc a company registered in England and Wales under company registration number 1282495 with its registered office at the address set out above. VAT number 697904179. [...]
4741 82 70_Re: Wrong access path due to wrong cardinality estimation, DB2 Z/OS V810_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Wed, 29 Apr 2009 14:36:45 +0000368_windows-1252 Hi Pat,
Your interpretation is correct. But our main issue is less the access path and more the cost estimate. We'd like to get the -495 instead of the -905 at 60000000 SU. The colgroup stats do help but the cos just isn't quite right overall. The table with the predicates applied to looks OK but the 8 joins don't seem to cost out properly. [...]
4824 117 60_Re: Procedure for fallback from DB2 v8 ENFM/NFM to DB2 v8 CM12_Arlene Brown32_Arlene.Brown@EXPRESS-GIFTS.CO.UK31_Wed, 29 Apr 2009 15:35:36 +0100372_us-ascii Hi Donna, We took a flashcopy of all the vols for the subsystem we were going to ENFM on.
Arlene
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Donna Domovic Sent: 28 April 2009 19:31 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Procedure for fallback from DB2 v8 ENFM/NFM to DB2 v8 CM [...]
4942 45 70_Re: Wrong access path due to wrong cardinality estimation, DB2 Z/OS V815_Patrick Bossman25_patrick.bossman@GMAIL.COM31_Wed, 29 Apr 2009 15:28:22 +0000467_ISO-8859-1 Hi Jorg, There are other issues which can make costing difficult. - column expressions - non-column expressions - join miss, join fan-out estimation challenges - cross table correlations
In most cases, collection of frequencies for point skew, histograms for range skew, and multi-column cardinalities (KEYCARD, multi-column COLGROUP) allow the optimizer to cost well enough to differentiate between the efficient and inefficient access paths. [...]
4988 85 60_Re: DB2 for z/OS Version 9 - problem with unicode conversion12_Jim McAlpine22_jim.mcalpine@GMAIL.COM31_Wed, 29 Apr 2009 16:32:05 +0100599_ISO-8859-1 Problem solved. It was caused by a join being done between 2 tables with different EBCDIC code pages. Thanks for the responses.
Jim McAlpine
On Tue, Apr 28, 2009 at 4:46 PM, Jim McAlpine wrote:
> cross posted to IBM-MAIN and DLB2-L > > I've just converted one DB2 system to DB2 Version 9 NFM and I'm getting a > problem which manifests itself as huge CPU usage in CICS/DB2 transactions. > These applications work perfectly in DB2 Version 8 on the same z/OS 1.7 > system. In DB2 Version 9 the transactions typically use over a minute of > [...]
5074 77 45_Re: Mainframe Cobol SQL programming guideline9_Don Leahy19_don.leahy@LEACOM.CA31_Wed, 29 Apr 2009 11:23:53 -0400386_ISO-8859-1 I strongly advise using the "Field Name Prefix" feature of the DCLGEN command. This causes each Cobol field in the DCLGEN to have the same prefix. This makes coding much easier, as it can eliminate the need to code Cobol "OF"s when referring to a field.
How many of your tables contain an account number field? A good many of them, probably. It is easier to code [...]
5152 39 57_Re: Migrating programs/dbrms from DB2 v8 NFM to DB2 v8 CM13_Donna Domovic28_Donna.Domovic@EXELONCORP.COM31_Wed, 29 Apr 2009 17:20:57 +0000501_windows-1252 Hi Dave,
It's good to hear that we shouldn't have problems but I do have 1 question. I'm a little confused by your post but figure it's just a typo.
Your post said don't copy the dbrm and then bind. Did you mean that the dbrm should be copied along with the load module and then a bind should be done? That's what our normal migration procedure is so I'm hoping that will work even if the development environment is DB2 v8 NFM and the production is still at DB2 v8 CM. [...]
5192 76 70_Re: Wrong access path due to wrong cardinality estimation, DB2 Z/OS V810_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Wed, 29 Apr 2009 18:21:19 +0000306_windows-1252 Thanks Pat,
That's what I'm trying to do. I'm piecing out the query into sub components and then running them through the stats advisor, seeing the numbers that come up and so on. But that's a little bit slow work. I will post a related but more concrete example of a recent issue [...]
5269 118 32_Same Table Different Access Path10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Wed, 29 Apr 2009 18:29:25 +0000411_windows-1252 We have a table cloned in two environments. The rowcount is slightly different (97 million to 120 million) but it used tio have the same access path. After a reload one table took a newer, worse access path MX versus I access, and we had to resort to a hint to keep the more efficient access. I'm posting some info below in case anyone out there has an idea why table2 is now using MX access. [...]
5388 76 49_Re: How Much Business Data is Actually Relational10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Wed, 29 Apr 2009 18:33:21 +0000616_windows-1252 A performance update on this. By adding the grandparent key and clustering on that key the bulk test showed a 95% reduction in getpages, i/o and response time.
On Fri, 13 Feb 2009 05:19:04 +0000, Jorg Lueke wrote:
>Besides the data actually in IMS there seems to be a lot of data that is >quite hierarchical in structure (an insurance claim, financial records) that >is then stuffed into relational databases often in third normal form. I >know IMS has limitations, few fans in architecture, and is not good in all >cases, but even so it seems like there is [...]
5465 124 57_Re: Migrating programs/dbrms from DB2 v8 NFM to DB2 v8 CM14_David A. Smith28_Dave.Smith@CO.HENNEPIN.MN.US31_Wed, 29 Apr 2009 14:00:54 -0500554_US-ASCII Hey Donna,
My synapses misfired. I was thinking of copying SYSIBM.SYSDBRM.
Copying the load module and the DBRM and then running a BIND will accomplish the task.
Dave
P Please consider the environment before printing this email.
Hennepin County Information Technology Operations/Mainframe Services A-023 Government Center Ph: 612.348.2660 FAX: 612.348.4663 Emergency Cell: 612.490.2586 dave.smith@co.hennepin.mn.us
From: Donna Domovic [...]
5590 85 29_Re: DSNTIAUL abend in DB2 NFM10_Nicola Nur17_nick_nur@YAHOO.CA31_Wed, 29 Apr 2009 12:09:57 -0700506_utf-8 Hi colleagues
Can you help if possible?
Our DB2 is z/OS v8.1 NFM. Ran DSNTIAUL of V8. Got this error: reason code x’00C50109’. ======================================================== DSNT570I WARNING: THIS APPLICATION HAS SELECTED DSNTIAR TO PERFORM SQL MESSAGE FORMATTING BECAUSE THE GET DIAGNOSTICS SERVICE RETURNED AN UNEXPECTED SQLCODE WHILE FORMATTING MESSAGES FOR ONE OR MORE SQL WARNING OR ERROR CONDITIONS. A DUMP OF THE SQLCA FOR THE GET DIAGNOSTICS REQUEST FOLLOWS: [...]
5676 319 64_June Meeting - Baltimore/Washington DB2 Users' Group - 6/10/200914_Henry L Nalven25_HENRY.NALVEN@MARRIOTT.COM31_Wed, 29 Apr 2009 19:55:16 +0000515_- The Baltimore/Washington DB2 Users' Group Meeting Schedule for June 10, 2009 (Wednesday)
When? Wednesday, June 10,2009 9:00 AM-3:30 PM (Registration at 8:30 AM)
Where? Sheraton Columbia, 10207 Wincopin Circle Columbia, MD (410) 730-3900
Meeting Fees (please note changes): Pre-registered members $30 Pre-registered non-members $40 At-the-door for members $40 At-the-door for non-members $50
To pre-register, please mail the appropriate fee with attendee's and employer's name to: [...]
5996 125 29_Re: DSNTIAUL abend in DB2 NFM14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 29 Apr 2009 20:55:26 +0100375_iso-8859-1 Hmm
Only one hit at ibm.com for this reason code - and that was for V5, 6 and 7
I think you need to talk to ibm
Phil Grainger CA
________________________________
From: DB2 Data Base Discussion List on behalf of Nicola Nur Sent: Wed 29/04/2009 20:09 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DSNTIAUL abend in DB2 NFM [...]
6122 153 29_Re: DSNTIAUL abend in DB2 NFM10_Todd Burch17_toddburch@MAC.COM31_Wed, 29 Apr 2009 15:07:15 -0500345_ISO-8859-1 The first thing I would check would be to see if you have link edited DSNELI from, say V9, into your application but you are running on V8.
Todd DB2 z/OS Support
On Apr 29, 2009, at 2:55 PM, Grainger, Phil wrote:
Hmm
Only one hit at ibm.com for this reason code - and that was for V5, 6 and 7 [...]
6276 570 65_[AD] Advanced Query Tuning with Optimization Service Center (OSC)14_John Caccavale18_jcac@THEMISINC.COM31_Wed, 29 Apr 2009 20:22:30 +0000
6847 30 27_ENCRYPTION of Credit number9_Raj Ghose17_raj.ghose@RBC.COM31_Wed, 29 Apr 2009 21:09:14 +0000613_windows-1252 Hi List, We have a requirement to encrypt the credit card number in our Z/OS DB2 tables. It will be much appreciated if you could share your knowledge/experience or have any ideas how it is done.
Many Thanks!
Raj
_____________________________________________________________________
* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA *
There is a discussion list for people who are going to IDUG NA09 in Denver - http://www.idug.org/cgi-bin/wa?A0=DB2-NA-IDUG-CONF-PARTICIPANT _____________________________________________________________________ [...]
6878 145 49_Re: Question ABout EBCIDIC DB creation on UDB 9.50_18_renusharma@AOL.COM31_Wed, 29 Apr 2009 17:19:59 -0400494_us-ascii Hello James
I am sorry EBCIDIC is IBM37 somehow its not allowing me to create with this codeset
Thanks
Renu
-----Original Message----- From: James Campbell To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Wed, 29 Apr 2009 8:28 am Subject: Re: [DB2-L] Question ABout EBCIDIC DB creation on UDB 9.5
CREATE DATABASE .... USING CODESET IBM-37 TERRITORY US ... (if that's what you actually want). [...]
7024 102 37_ZIIP Engine CPU Utilization Reporting25_Hall, Robert (Contractor)25_Robert.Hall@OCC.TREAS.GOV31_Wed, 29 Apr 2009 17:26:31 -0400559_us-ascii Are many shops using the ZIIP engine? If so, are you running regular reports to track utilization? I'm trying to get a feel for how much workload will be offloaded to the ZIIP engine once we migrate production to Version 8.
I am trying to write a report using TMON Report Writer without much success. If anyone has the TMON report commands that you are willing to share, I would greatly appreciate it. I want a simple report that shows by jobname/DDF Thread the amount of CP CPU and the amount of ZIIP CPU. I think the TMON report writer [...]
7127 80 53_Re: Question: db2icrt failure at DB2 V9.5 on AIX V5.38_D. James20_dj53tx-udb@YAHOO.COM31_Wed, 29 Apr 2009 22:22:07 -0500703_ISO-8859-1 I had a problem at one time the the icrt under 9.5 and it was due to icrt expecting the IP ports to be defined in /etc/services where version 8 did not require them to be predefined.
On Wed, Apr 29, 2009 at 8:59 AM, Ram Nagasuri wrote:
> I have exactly the same issue. Are you able to come over this issue? Any > update from IBM support? Please repond. > ------------------------------ > > [image: Join us in Denver!] > There is a discussion list for people who are going to IDUG NA09 in Denver > - http://www.idug.org/cgi-bin/wa?A0=DB2-NA-IDUG-CONF-PARTICIPANT [...]
7208 116 31_Re: ENCRYPTION of Credit number14_Matthew Donald26_matthew.b.donald@GMAIL.COM31_Thu, 30 Apr 2009 15:16:13 +1000512_ISO-8859-1 There is a new Redbook which discusses this issue in detail: Securing and Auditing Data on DB2 for z/OS (SG24-7720-00). While "Part 5. Data Encryption for IMS and DB2 Databases" will be of especial interest to you, there is a lot more to securing and auditing sensitive data (such as credit card no's) than just encrypting a column in a table. The rest of the redbook discusses all the related problems and offers solutions. Matthew [...]
7325 343 176_Upcoming IDUG Webcast - "Musings on DB2 Security for the DB2 LUW DBA - Rebecca Bond, Independent Security Consultant" - Thursday May 7 2009 at 9:30 am USA Central Daylight Time13_David Chapman24_David.Chapman@IAG.COM.AU31_Thu, 30 Apr 2009 18:02:04 +1000733_us-ascii
_______________________________________________________________________________________
Note: This e-mail is subject to the disclaimer contained at the bottom of this message. _______________________________________________________________________________________
Hello DB2 List,
Musings on DB2 Security for the DB2 LUW DBA - Rebecca Bond, Independent Security Consultant
The International DB2 Users Group (IDUG) is pleased to partner with DBI to deliver a free Webcast by renowned presenter Rebecca Bond. 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. [...]
7669 122 29_Re: DSNTIAUL abend in DB2 NFM14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Thu, 30 Apr 2009 22:11:48 +1000484_ISO-8859-1 Add a //DSNTRACE DD SYSOUT=* to your job. Don't know what you'll find it it - but that is the "DSN tracing turned on" referred to in the 00c50109 text.
The problem that we see is that all the error codes say "there was a previous error. Fix that up"; none of them are for the actual problem. I have a vague recollection of getting an error like this a looong time ago. There was some reason code in the DSNTRACE that prompted me to be able to solve the problem [...]
7792 400 43_zOS DB2 9: Native SQL procedure (SQL-20071)11_Mike Jessen22_jessenmike@HOTMAIL.COM31_Thu, 30 Apr 2009 08:50:34 -0500316_iso-8859-1
We are trying to use SPUFI to define our first native SQL stored procedure, but keep recieving an error message saying we need a WLM. Has anyone encountered this - what are we doing wrong? According the the SQL Guide, it sounds like these can be created outside Data Studio/Dev Workbench.... [...]
8193 32 41_Re: ZIIP Engine CPU Utilization Reporting10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Thu, 30 Apr 2009 13:59:18 +0000361_windows-1252 Hi Robert,
We use Ziips and we get quite a bit of offloading for our distributed threads. Because we have a whole OLAP application that comes in with large queries the ziip offload is quite good. We do collect the information with IBM DB2 PE (or is it PM?) but we don't generally report on it. The capacity folks have the data as well. [...]
8226 409 47_Re: zOS DB2 9: Native SQL procedure (SQL-20071)12_Jeff Frazier31_Jeffrey.Frazier@WENDYSARBYS.COM31_Thu, 30 Apr 2009 10:03:49 -0400750_US-ASCII Mike, found this
Problem(Abstract) When you deploy a native SQL stored procedure that targets DB2 for z/OS using IBM Data Studio or Developer Workbench, you might see the following error: SQLCODE -20071. If this error occurs, the deployment fails.
Symptom
Resolving the problem To resolve this error, specify a non-blank value for the WLMENV ZPARM. You cannot set this value in the Data Studio or Developer Workbench tooling. You set it in the DB2 for z/OS system, either during installation or dynamically by using the DB2 command -SET SYSPARM. Discuss WLM environment assignments with your DB2 for z/OS system administrator. [...]
8636 46 60_Re: Procedure for fallback from DB2 v8 ENFM/NFM to DB2 v8 CM13_Donna Domovic28_Donna.Domovic@EXELONCORP.COM31_Thu, 30 Apr 2009 14:12:21 +0000430_windows-1252 James,
Your email mentioning that only the system type datasets (ie catalog/directory, BSDS, logs, etc.) would need to be dumped and restored sounded much more like what I was expecting and much more promising than having to back up all of our application data especially since we don't have flashcopy. I agree it's something I hope we never have to do but I'd rather have the plan in place just in case. [...]
8683 33 48_DB2 V9 z/OS - SQL insert horrible experience ...11_Nenad Vidak21_Nenad.Vidak@GMAIL.COM31_Thu, 30 Apr 2009 14:57:56 +0000534_ISO-8859-1 Hello, on two different DB2 tables in two different DB2 V9 subsystems on our production SQL INSERTs suddenly started to consume huge amount of CPU and generate getpages on tables they insert into ( not on indexes as expected). After 8 hours of finding solution involving raising the PMR on priority 1, rebuilding all indexes on tables, running DSN1COPY, changing zPARMs, tracing applications involved in all possible ways, reorganizing tablespaces finally solved the problem. Still don't know where the cause was .... [...]
8717 767 47_Re: zOS DB2 9: Native SQL procedure (SQL-20071)14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Thu, 30 Apr 2009 11:48:04 -0400477_US-ASCII Mike,
If you haven't specified a default WLM in your DB2V9 ZPARMS, and you want to define a native SQL Stored Procedure, you have to include one of the following two lines in your definition:
Either
DISABLE DEBUG MODE
Or
WLM ENVIRONMENT FOR DEBUG MODE [some valid WLM environment here]
We put the above language immediately after the LANGUAGE SQL parm in the "CREATE PROCEDURE" statement. [...]
9485 244 23_DB2 Archive Log on 359211_Moore, Tony15_TMoore@IKON.COM31_Thu, 30 Apr 2009 11:52:21 -0400594_us-ascii I currently make copies (IEBGENER) of my DB2 archive log tapes and send these copies offsite for disaster recovery. My archive logs are on 3590 tapes as are the copies. The copies are created with no compression (DCB=TRTCH=NOCOMP) due to DB2 requirements (at least it was years ago).
We are now in the process of converting all our offsite DR tapes to 3592 encrypted tapes. I've run my IEBGENER to copy a 3590 archive log tape to a 3592 encrypted / noncompressed tape successfully. I've run a DSN1LOGP on both the real (3590) archive log and ran one on the [...]
9730 592 47_Re: zOS DB2 9: Native SQL procedure (SQL-20071)11_Mike Turner29_michael_turner@COMPUSERVE.COM31_Thu, 30 Apr 2009 16:58:08 +0100347_iso-8859-1 Mike
This was discussed on the list back in February. Below is an answer from Hunter Cobb which explains what the problem is:
>>>>>>>>>>>>>>>>> At DB2 V9 install time, there is an option to specify a default WLM environment. This can be left blank by the installer. However, then there is no default WLM environment. [...]
10323 69 27_Re: DB2 Archive Log on 35920_24_carol.sutfin@REGIONS.COM31_Thu, 30 Apr 2009 12:04:32 -0500360_UTF-8 Tony,
We have been placing our archive logs on 3592 tapes for almost two years now with no problems.
I have even been through two D.R. scenarios where we have used the tapes to lay down the log files to restart the DB2 subsystem.
We use ADRDSSU to copy the datasets from DASD to 3592 and to restore them back to DASD if needed. [...]
10393 323 47_Re: zOS DB2 9: Native SQL procedure (SQL-20071)12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 30 Apr 2009 10:29:53 -0700453_us-ascii Specifying WLM ENVIRONMENT FOR DEBUG MODE xxxxx does not work even with DISALLOW DEBUG MODE. You must either allow debugging and go in and alter it manually or it won't build.
Myron
________________________________ From: Mike Turner To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Thursday, April 30, 2009 11:58:08 AM Subject: Re: [DB2-L] zOS DB2 9: Native SQL procedure (SQL-20071) [...]
10717 171 38_Re: DSNTIAUL abend in DB2 NFM. Update.10_Nicola Nur17_nick_nur@YAHOO.CA31_Thu, 30 Apr 2009 10:39:14 -0700342_iso-8859-1 Thanks James and all who answered. Just an update. Mystery is solved. DB2 development crashed at lunch and no body noticed. This job was running at that time. It did not occur to me to check the availability of DB2 because the error did not direct me to suspect the DB2 subsystem itself. This is an update. Thanks again. Nick [...]
10889 34 29_Re: Tab or special characters14_Peter Vanroose17_pvanroose@ABIS.BE31_Thu, 30 Apr 2009 18:28:52 +0000403_ISO-8859-1 Dean J. Burchill wrote: >Found it using the HEX (SUBSTR (MY_COL, 1, 1)) which returned an '09'
Wayne Stevens wrote: >That is a vertical tab.. the hex 05 was a horizontal tab.
Actually, MY_COL could have a Unicode or ASCII encoding, in which case 09 *is* a horizontal TAB. Also, in EBCDIC, the vertical tab is 0B, not 09. [...]
10924 48 41_DB2 LUW - LOAD CLIENT from Runtime Client0_28_BILL.GALLAGHER@PHOENIXWM.COM31_Thu, 30 Apr 2009 14:47:01 -0400461_US-ASCII A simple question for the DB2-L List:
Can you run a DB2 "LOAD CLIENT . . . " utility from a DB2 Runtime Client? Or do you need a full-blown DB2 Client (App Dev, Admin, or Connect client) to run a "LOAD CLIENT . . . " utility?
------------------------------------------------------- Bill Gallagher, Logical DBA IT / Infrastructure Services Phoenix Life Insurance Company (W) 860-403-6327 (C) 860-539-5576 bill.gallagher@phoenixwm.com [...]
10973 43 29_Re: Tab or special characters14_Peter Vanroose17_pvanroose@ABIS.BE31_Thu, 30 Apr 2009 19:07:15 +0000403_ISO-8859-1 Dean Burchill wrote: >Found it using the HEX (SUBSTR (MY_COL, 1, 1)) which returned an '09'
Wayne Stevens answered: >That is a vertical tab.. the hex 05 was a horizontal tab.
Actually, MY_COL could have a Unicode or ASCII encoding, in which case 09 *is* a horizontal TAB. Also, in EBCDIC, the vertical tab is 0B, not 09. [...]
11017 65 23_DB2 for z/OS V9 Classes13_Irwin Deutsch28_ideutsch@PRINCESSCRUISES.COM31_Thu, 30 Apr 2009 12:42:16 -0700532_US-ASCII Hi Listers,
Can anyone recommend a classroom DB2 course for system programmers or system administrators? I'm trying to update my skills from last classes 14 years ago. My skillset is somewhere between intermediate and advanced. Feel free to contact me off-list.
Also any tips on technical conferences would be great.
Thanks,
Irwin
_____________________________________________________________________
* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA * [...]
11083 171 29_Re: DSNTIAUL abend in DB2 NFM10_Nicola Nur17_nick_nur@YAHOO.CA31_Thu, 30 Apr 2009 12:39:15 -0700342_iso-8859-1 Thanks James and all who answered. Just an update. Mystery is solved. DB2 development crashed at lunch and no body noticed. This job was running at that time. It did not occur to me to check the availability of DB2 because the error did not direct me to suspect the DB2 subsystem itself. This is an update. Thanks again. Nick [...]
11255 1101 47_Re: zOS DB2 9: Native SQL procedure (SQL-20071)14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Thu, 30 Apr 2009 15:57:18 -0400581_US-ASCII That wasn't my experience when creating one in DB2V9/CM. Did you use a valid WLM?
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Myron Miller Sent: Thursday, April 30, 2009 1:30 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] zOS DB2 9: Native SQL procedure (SQL-20071)
Specifying WLM ENVIRONMENT FOR DEBUG MODE xxxxx does not work even with DISALLOW DEBUG MODE. You must either allow debugging and go in and alter it manually or it won't build. [...]
12357 97 23_DB2 for z/OS V9 Classes13_Irwin Deutsch28_ideutsch@PRINCESSCRUISES.COM31_Thu, 30 Apr 2009 12:42:16 -0700532_us-ascii Hi Listers,
Can anyone recommend a classroom DB2 course for system programmers or system administrators? I'm trying to update my skills from last classes 14 years ago. My skillset is somewhere between intermediate and advanced. Feel free to contact me off-list.
Also any tips on technical conferences would be great.
Thanks,
Irwin
_____________________________________________________________________
* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA * [...]
12455 414 29_Re: DSNTIAUL abend in DB2 NFM12_Ayalew Kassa20_ayalakassa@YAHOO.COM31_Thu, 30 Apr 2009 15:37:00 -0700460_iso-8859-1
were you running /invoking DSNTIAUL from development center ? I have not done that before ..
In our shop we run it as a batch JCL job. any reason for invoking it from develoment ceneter ?
--- On Thu, 4/30/09, Nicola Nur wrote:
From: Nicola Nur Subject: Re: [DB2-L] DSNTIAUL abend in DB2 NFM To: DB2-L@WWW.IDUGDB2-L.ORG Date: Thursday, April 30, 2009, 2:39 PM [...]
12870 96 53_Re: Question: db2icrt failure at DB2 V9.5 on AIX V5.38_Nagasuri20_r_nagasuri@YAHOO.COM31_Thu, 30 Apr 2009 15:48:26 -0700624_iso-8859-1 Hi James, Thanks for the response. I still have the same issue. Would you please provide a little more details about the fix? Thank you, -Ram ________________________________ From: D. James To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Wednesday, April 29, 2009 11:22:07 PM Subject: Re: [DB2-L] Question: db2icrt failure at DB2 V9.5 on AIX V5.3 I had a problem at one time the the icrt under 9.5 and it was due to icrt expecting the IP ports to be defined in /etc/services where version 8 did not require them to be predefined. On Wed, Apr 29, 2009 at 8:59 AM, Ram Nagasuri [...]
12967 154 53_Re: Question: db2icrt failure at DB2 V9.5 on AIX V5.38_D. James20_dj53tx-udb@YAHOO.COM31_Thu, 30 Apr 2009 18:13:46 -0500621_ISO-8859-1 I just added the entries to the /etc/services file before I ran the db2icrt. Just be sure you use the right format for the entry names.
DJ
On Thu, Apr 30, 2009 at 5:48 PM, Nagasuri wrote:
> Hi James, > > Thanks for the response. > I still have the same issue. > Would you please provide a little more details about the fix? > > Thank you, > -Ram > > ------------------------------ > *From:* D. James > *To:* DB2-L@WWW.IDUGDB2-L.ORG > *Sent:* Wednesday, April 29, 2009 11:22:07 PM > *Subject:* Re: [DB2-L] Question: db2icrt failure at DB2 [...]
13122 180 53_Re: Question: db2icrt failure at DB2 V9.5 on AIX V5.38_D. James20_dj53tx-udb@YAHOO.COM31_Thu, 30 Apr 2009 18:13:46 -0500621_ISO-8859-1 I just added the entries to the /etc/services file before I ran the db2icrt. Just be sure you use the right format for the entry names.
DJ
On Thu, Apr 30, 2009 at 5:48 PM, Nagasuri wrote:
> Hi James, > > Thanks for the response. > I still have the same issue. > Would you please provide a little more details about the fix? > > Thank you, > -Ram > > ------------------------------ > *From:* D. James > *To:* DB2-L@WWW.IDUGDB2-L.ORG > *Sent:* Wednesday, April 29, 2009 11:22:07 PM > *Subject:* Re: [DB2-L] Question: db2icrt failure at DB2 [...]
13303 70 6_ebooks23_Jeffrey Benner, DB2 DBA22_consulting@EBENNER.COM31_Thu, 30 Apr 2009 18:34:58 -0500569_ISO-8859-1 I'm reading Sanders and Snow's "*DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification Study Guide " *and I would love it if this were available as a PDF. Just a thought if anyone out there is listening.*
I use flashcard software and if I had a pdf it would be much easier to create a flashcard set from some of the material where I want to focus more effort. It would also make a nice reference on my laptop. The book is *huge*, not something you want to carry around. [...]