1 IDUGDB2-L.ORG /home/listserv/home/db2-l March 2010, week 5 2 275 62_Re: Information Center updated (standard end of month message)11_Roy Boxwell16_R.Boxwell@SEG.DE31_Mon, 29 Mar 2010 10:22:20 +0200496_ISO-8859-1 Hi all!

I just downloaded the books (pdf format) and tried to find the "updated
pages"...no joy...Does anyone know a method where I can see the
differences between the old and the new? (Without downloading and
installing dodgy free software of course!)
Whatever happened to change bars...I swear that I used to see a first
"chapter" with a list of what has been changed with the classic line
"numerous small editorial changes" in it...or I am dreaming??? [...]64_OFBC8379D7.F15B8DD3-ONC12576F5.002DBA38-C12576F5.002DFDE2@seg.de 278 162 44_z/Journal (October 2009 - March 2010 issues)10_DB2usa !!!19_db2usa3@HOTMAIL.COM31_Mon, 29 Mar 2010 05:50:12 -0400537_iso-8859-1 Hi DB2 user,

Here is a non-profit Blog about DB2 for z/OS (IBM mainframes):
http://db2usa.blogspot.com

Last update on Monday, March 29th 2010

Articles from October 2009 - March 2010 issues of z/Journal are available online:

- Collecting Histogram Statistics With RUNSTATS
by Craig Mullins

- 11 Rules of the Road for DBAs
by Craig Mullins

- Using SMF for Cost-Effective DB2 Security, Auditing & Compliance Monitoring
by Jerry Harding, Stephen Rubin and William Buriak [...]43_SNT118-W32FCD07CF5AB97DEDD01B3AF200@phx.gbl 441 50 16_sync. log write.10_Zhang Ming16_db2sub@YAHOO.COM31_Mon, 29 Mar 2010 03:14:08 -0700303_iso-8859-1 Dear all, Does anyone know under which conditions db2 will do sync.log write. I had a batch job which run very  longer than before, the only difference I can see from PM report is that is had a large of time doing sync. log write. any experience to share are welcome. Tks. best Regards. [...]44_685121.43436.qm@web113714.mail.gq1.yahoo.com 492 35 20_Re: sync. log write.12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Mon, 29 Mar 2010 09:01:26 -0400535_UTF-8 Synchronous Log Writes - i.e. externalizing the log buffers to the active log dataset(s) - occur for a number of reasosons, including COMMITs, system CHECKPOINTS, data sharing heartbeat, ARCHIVE LOG command, buffer log write threshold reached, Database writes and a few others which escape me at the moment.

Is the bacth process the only process showing increased time due to log writes? Are you sure that the workload being performed by this batch was identical in both cases? What about overall subsystem workload? [...]54_1127358223243886.WA.adambaldwines.ibm.com@www.idug.org 528 55 20_Re: sync. log write.9_Mike Bell21_mbell11a1@VERIZON.NET31_Mon, 29 Mar 2010 08:07:21 -0500365_US-ASCII Sync log write is usually a symptom of COMMIT. Check the number of commit
calls executed.

I once had a quick program go in to fix a problem and it correctly waited
for 100 updates to do the commit but forgot to reset the counter and did
commit on every row after that. Ran for a very long time. Do not let DBA's
write fix programs. [...]43_75B3D8A365CD46C9BF1444EC3D830E7C@mikelaptop 584 382 62_Re: Information Center updated (standard end of month message)17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Mon, 29 Mar 2010 14:44:57 +0100643_iso-8859-1 ISPF 3.12?

Sorry I know it's only Monday...

Thanks.

Aurora

Aurora Emanuela Dell'Anno
CA MSC
Sr. Engineering Services Architect
Tel: +44 (0)1753 577 733
Mobile: +44 (0)7768 235 339
Aurora.Dellanno@ca.com

http://www.ca.com/

P please don't print this e-mail unless you really need to!

________________________________

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Roy Boxwell
Sent: 29 March 2010 09:22
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Information Center updated (standard end of month message) [...]56_3D02E8610514C04F991CF832BA154C661056709F@UKSLMS11.ca.com 967 151 11_RACF Expert11_Robin Marsh21_robin.marsh@GMAIL.COM31_Mon, 29 Mar 2010 09:31:02 -0500456_windows-1252 Palladian Consulting, a leader in IT services is seeking a RACF / JCL
Mainframe Programmer Analyst for a 6 Month contract in Overland Park, KS

All work is to be done onsite with contract to hire potential

Start immediately after onsite interview

Skills: Programming Languages – JCL Advanced

Required:
- RACF-Expert Knowledge, More than provisional access must have
administrative component experience [...]59_5046d2201003290731g5ac12106u80462cbfe8a0db09@mail.gmail.com 1119 65 20_Fw: sync. log write.10_Zhang Ming16_db2sub@YAHOO.COM31_Mon, 29 Mar 2010 07:46:58 -0700530_iso-8859-1 Dear all,it's no problem now,and is related with comit frequency. Tks. ----- Forwarded Message ---- From: Zhang Ming To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Mon, March 29, 2010 6:14:08 PM Subject: sync. log write. Dear all, Does anyone know under which conditions db2 will do sync.log write. I had a batch job which run very  longer than before, the only difference I can see from PM report is that is had a large of time doing sync. log write. any experience to share are welcome. Tks. best Regards. [...]43_927898.4346.qm@web113701.mail.gq1.yahoo.com 1185 95 62_Re: Information Center updated (standard end of month message)11_Roy Boxwell16_R.Boxwell@SEG.DE31_Mon, 29 Mar 2010 16:57:59 +0200554_ISO-8859-1 ISPF 3.12?

Sorry I know it's only Monday...

someone here (who shall remain nameless...) actually suggested
that.....and then came out with the equally brilliant idea "Print them all
out and do a page by page check"...of course I have nothing else to do for
the next three years.... ;)

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 [...]64_OF7942B79E.35ADFB68-ONC12576F5.00522AD8-C12576F5.00523718@seg.de 1281 31 25_[Fluff] Holiday greetings14_Larry Kintisch17_LKint@VERIZON.NET31_Mon, 29 Mar 2010 11:29:24 -0400742_us-ascii Hi Listers across the world,

In this holiday season for so many of us, let's use our lives to
add some love to the world. There is --enough-- hate.

For my Jewish friends, Happy Passover.

For my Christian friends, Happy Easter.

For others, a peaceful spring!

Larry Kintisch

_____________________________________________________________________

* 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! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________ [...]40_0L01007ZHV1IHU70@vms173011.mailsrvcs.net 1313 123 53_[z/OS] REXX inspired by C, a short tale for z/OS DBAs14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Mon, 29 Mar 2010 11:40:10 -0400411_us-ascii At my blog, I have a new entry and some shareable REXX code to fix date-partitioned tablespaces which have gotten out of date.
"REXX inspired by C, a short tale for z/OS DBAs": http://it.toolbox.com/blogs/relearning-programming/rexx-inspired-by-c-a-short-tale-for-zos-dbas-37734

Permission granted to take a copy of the code for corporate use (but not for resale). Comments appreciated. [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC4676B@MAIL02.fisalan.nycnet 1437 258 70_AW: [DB2-L] Information Center updated (standard end of month message)12_Peter, Georg15_G.Peter@DZBW.DE31_Mon, 29 Mar 2010 18:49:35 +0200523_iso-8859-1 Roy,

>>of course I have nothing else to do for the next three years.... ;) << It seems that the IBM Information Center Papers will go direct into Oracles new www.support.oracle.com and they will leave their reputation.

The red company HAD a very good support website (aka known as metalink at oracle dot com). And they changed the websites also. So call it "we (IBM & Oracle) have to save money. Not good for us. And you - as a paying customer - have to accept our (IBM's and Oracle's) rules. [...]58_99E58D5AC1BE6D4CBF492AF72B942C3D061ADBB5@dzstus010.dzbw.de 1696 46 37_AW: [DB2-L] [Fluff] Holiday greetings12_Peter, Georg15_G.Peter@DZBW.DE31_Mon, 29 Mar 2010 18:54:12 +0200582_us-ascii Larry, greetings from the smallest town in Germany in south germany, yes
it is a town, just 2997 residents, OBERRIEXINGEN.

If you want: www.oberriexingen.de ;-))

Keep cool and enjoy the free -non database related - days... ;_))

Georg

Abonnieren Sie unseren Infobrief und erfahren Sie regelmäßig die neuesten Nachrichten über unsere Lösungen, aktuellen Projekte und Entwicklungen. Melden sie sich an mit diesem Link http://www.datenzentrale.de/Info-Brief
_______________________________________________________________________________ [...]58_99E58D5AC1BE6D4CBF492AF72B942C3D061ADBB6@dzstus010.dzbw.de 1743 92 41_Re: AW: [DB2-L] [Fluff] Holiday greetings10_Roger Hecq18_Roger.Hecq@UBS.COM31_Mon, 29 Mar 2010 14:02:24 -0400452_iso-8859-1 It may be small, but it certainly looks pretty. My recollection is that the food and beer in that area are also quite enjoyable.

Roger Hecq
MF IB USA DB Support
203-719-0492 / 19-337-0492

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Peter, Georg
Sent: Monday, March 29, 2010 12:54 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] AW: [DB2-L] [Fluff] Holiday greetings [...]62_1A700EEF49343148A08879B1E3CA5BA6145174E1@NSTMC101PEX1.ubsw.net 1836 352 41_Re: AW: [DB2-L] [Fluff] Holiday greetings12_Jeff Frazier31_Jeffrey.Frazier@WENDYSARBYS.COM31_Mon, 29 Mar 2010 14:43:21 -0400514_ISO-8859-1 Isn't that close to Ludwigsburg? And yes the countryside is very nice as i
remember.

Roger Hecq
Sent by: IDUG DB2-L
03/29/2010 02:38 PM
Please respond to
IDUG DB2-L

To
DB2-L@IDUGDB2-L.ORG
cc

Subject
Re: [DB2-L] AW: [DB2-L] [Fluff] Holiday greetings

It may be small, but it certainly looks pretty. My recollection is that
the food and beer in that area are also quite enjoyable. [...]68_OF6D5F1968.6BCD1145-ON852576F5.0066951D-852576F5.0066D8BB@wendys.com 2189 444 41_Re: AW: [DB2-L] [Fluff] Holiday greetings10_Roger Hecq18_Roger.Hecq@UBS.COM31_Mon, 29 Mar 2010 15:50:12 -0400394_us-ascii Visit our website at http://www.ubs.com

This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system. [...]62_1A700EEF49343148A08879B1E3CA5BA614690168@NSTMC101PEX1.ubsw.net 2634 100 29_Re: [Fluff] Holiday greetings13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Mon, 29 Mar 2010 13:19:08 -0700437_us-ascii They grow cute kids there, but they don't do so well with the corn. Come to think of it, the corn I grew in my garden looked exactly like that.

Happy everything to all!

Cathy

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Peter, Georg
Sent: Monday, March 29, 2010 9:54 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] AW: [DB2-L] [Fluff] Holiday greetings [...]64_927FE8790B320742927BCF9ADF7AE48A18EED4D04B@PDXMAIL.pacificorp.us 2735 256 15_Re: RACF Expert13_BOND Victor A30_Victor.A.BOND@ODOT.STATE.OR.US31_Mon, 29 Mar 2010 15:43:55 -0700501_US-ASCII Robin,
Didn't get near the hassles here as you got on the CICS list.
Wonder if that means something?
Victor

________________________________

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Robin Marsh
Sent: Monday, March 29, 2010 7:31 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] RACF Expert

Palladian Consulting, a leader in IT services is seeking a RACF / JCL
Mainframe Programmer Analyst for a 6 Month contract in Overland Park, KS [...]71_D3B03C67566CCC4BA0527224221B814406AFE587@EX-SALEMREV-4.odot.state.or.us 2992 33 19_Data Migration Tool22_Devyani R Sahasrabudhe22_devyani.sah@IN.IBM.COM31_Tue, 30 Mar 2010 03:03:39 -0400406_UTF-8 Hello All,

Recently we had to undergo data model change and newer version is denormalized one. Now we need to migrate the data from the old tables to the new tables. Therefore was wondering if there is any tool existing for the same. Any such tool available which can take care of this or this needs to be done writing scripts? Current database is on Linux server and DB2 version is 8.2. [...]54_9827901313152785.WA.devyani.sahin.ibm.com@www.idug.org 3026 105 29_Re: [Fluff] Holiday greetings10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 30 Mar 2010 09:51:43 +0200597_US-ASCII Hi Larry

Peace and love ! Live long and prosper !

Max Scarpa
Certified DB2 sysprog

Murphy's law applied to DB2 ----> 'If Optimizer can choose the wrong
access path, it'll do'.
IT theorem of equality: 'There's no difference between DB2 and Oracle when
they crash.'

*******************************************************************************************************************************************
Attend IDUG 2010 - Europe, the premiere event for DB2 professionals.
8-12 November 2010, Vienna
Learn more at http://www.idug.org [...]66_OFCAAED837.881B1E85-ONC12576F6.002904A9-C12576F6.002AD0C0@cesve.it 3132 274 37_Determining DB2 z/OS version and mode12_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 30 Mar 2010 11:56:18 +0200627_us-ascii Environment: DB2 z/OS V8 CM
----------------------------------
Collegues,

in e.g. Oracle I can do a select * from V$VERSION and I receive this:

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit
Production

PL/SQL Release 11.1.0.7.0 - Production

CORE 11.1.0.7.0 Production

TNS for 64-bit Windows: Version 11.1.0.7.0 - Production

NLSRTL Version 11.1.0.7.0 - Production

And within SQL Server I can determine if an instance of a SQL Server is
the full version or the MSDE version by running this command: select
@@version. The result is: [...]58_99E58D5AC1BE6D4CBF492AF72B942C3D061ADBC1@dzstus010.dzbw.de 3407 44 41_Re: Determining DB2 z/OS version and mode10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 30 Mar 2010 12:05:32 +0200626_US-ASCII - DIS GROUP ?

Max Scarpa

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________ [...]66_OF6B93B2E9.582B0F62-ONC12576F6.00376655-C12576F6.00371122@cesve.it 3452 404 41_AW: Determining DB2 z/OS version and mode12_Thomas Weber22_Thomas.Weber@IT.NRW.DE31_Tue, 30 Mar 2010 12:17:14 +0200782_iso-8859-1 Hi Georg,

what about built-in session variables (cf. SQL Ref.) i.e.

SELECT GETVARIABLE('SYSIBM.VERSION')
FROM SYSIBM.SYSDUMMY1;

Regards

Thomas Weber
______________________________________________
IT NRW
Mauerstr. 51
40476 Düsseldorf
Tel. 0211 9449-2545
email: thomas.weber@it.nrw.de

________________________________
Von: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] Im Auftrag von Peter, Georg
Gesendet: Dienstag, 30. März 2010 11:56
An: DB2-L@IDUGDB2-L.ORG
Betreff: [DB2-L] Determining DB2 z/OS version and mode

Environment: DB2 z/OS V8 CM
----------------------------------
Collegues,

in e.g. Oracle I can do a select * from V$VERSION and I receive this: [...]72_C129734D873435418B3C3C91E9CBF3A368F2534246@LDSXS01EVS.service.lds.nrw.de 3857 59 41_Re: Determining DB2 z/OS version and mode14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 30 Mar 2010 21:19:33 +1100726_US-ASCII EXEC SQL CONNECT END-EXEC
DISPLAY SQLERRP

or, in V8 +

SELECT GETVARIABLE('SYSIBM.VERSION') FROM SYSIBM.SYSDUMMY1;

James Campbell

On 30 Mar 2010 at 11:56, Peter, Georg wrote:

>
> Environment: DB2 z/OS V8 CM
> ----------------------------------
> Collegues,
>
> ine.g. Oracle I can do a select * from V$VERSION and I receivethis:
>
> Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
> PL/SQL Release 11.1.0.7.0 - Production
> CORE 11.1.0.7.0 Production
> TNS for 64-bit Windows: Version 11.1.0.7.0 - Production
> NLSRTL Version 11.1.0.7.0 - Production
>
> And within SQL Server I can determine if an instance [...]46_4BB26AE5.18402.EEE82@jacampbell.acslink.net.au 3917 35 20_Re: sync. log write.12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Tue, 30 Mar 2010 06:29:27 -0400296_UTF-8 Zhang - I'm replying to your email on list. With data sharing under V8 an index page split will result in 2 forced log writes - there is relief for this in V9.

I suggest (if you haven't already seen it) that you take a look at John Cambell's presentation on Insert Performance: [...]54_0325737445488456.WA.adambaldwines.ibm.com@www.idug.org 3953 79 41_Re: Determining DB2 z/OS version and mode11_Roy Boxwell16_R.Boxwell@SEG.DE31_Tue, 30 Mar 2010 12:38:23 +0200928_ISO-8859-1 or just do a CONNECT and look in the SQLERRP variable...

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

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 [...]64_OF62DA9D3C.6291E36C-ONC12576F6.003A6A5D-C12576F6.003A7273@seg.de 4033 516 41_AW: Determining DB2 z/OS version and mode12_PUSCH Othmar27_Othmar.Pusch@IT-AUSTRIA.COM31_Tue, 30 Mar 2010 12:39:29 +0200700_iso-8859-1 Hi dear Peter !

A lot of possibilities ... only some quick ideas:

o) DB2-Command: "-DISPLAY GROUP DETAIL"
o) DB2-DSNUTIL: "DIAGNOSE DISPLAY MEPL"
o) DB2-SQL (V8): "SELECT GETVARIABLE('SYSIBM.VERSION') FROM SYSIBM.SYSDUMMY1;"
o) DB2-Connect: "EXEC SQL CONNECT END-EXEC --> DISPLAY SQLERRP"
o) etc. etc. etc.

Kinds/Othmar :-)

________________________________
Von: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] Im Auftrag von Peter, Georg
Gesendet: Dienstag, 30. März 2010 11:56
An: DB2-L@IDUGDB2-L.ORG
Betreff: [DB2-L] Determining DB2 z/OS version and mode
Environment: DB2 z/OS V8 CM
----------------------------------
Collegues, [...]63_81BB61A7ECD28B40BC5E4701B99986089571F7A8B3@A2XMXS1V1.A2X.LAN.AT 4550 56 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Tue, 30 Mar 2010 10:14:18 -0400345_utf-8 I mean to post this last Friday (honest) but something reminded me today

In the month (or so) since I asked "Is DB2 He or She?", over 100 people have voted and it turned out to be a largely pointless question

29% said "DB2 is an it"
25% said "DB2 is just DB2"
21% said "Definitely a he"
20% said "DB2 is a she" [...]58_4440F5DA00E3F3459BBCB97431B91B6611B00AF3@MAILR004.mail.lan 4607 195 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?7_Ed Long19_rdhm99a@PRODIGY.NET31_Tue, 30 Mar 2010 07:25:57 -0700316_iso-8859-1 I had a Shakespeare prof in college - a Yale man no less - whose verbal tick was "What not".
In one otherwise excellent lecture on King Lear, I counted 125 "What not's".

In a similar vein, I went to see the play Glen Gary Glen Ross a few years ago and counted 40+ F bombs in the first act. [...]43_675850.73942.qm@web80202.mail.mud.yahoo.com 4803 88 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 30 Mar 2010 16:43:34 +0200368_US-ASCII >
> In a similar vein, I went to see the play Glen Gary Glen Ross a few
> years ago and counted 40+ F bombs in the first act.
>

Sorry for my deep ignorance..... what's a 40+ F bombs ? It sounds like a
guided laser bomb.... Thanks.....

Max Scarpa

From Plato's orations on DB2: "'Utility job' is a contradiction in terms." [...]66_OF55D73504.7035C07F-ONC12576F6.005021FC-C12576F6.00508588@cesve.it 4892 65 23_Re: Data Migration Tool14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 30 Mar 2010 10:40:37 -0400505_us-ascii Devyani,
Several vendors offer tools to accomplish this task. CA offers RC/Migrator, IBM offers Princeton Move for DB2. I don't know about other vendors. You'd have to define your denormalizations, probably using SQL or a tool interface.

--Phil Sevetson

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Devyani R Sahasrabudhe
Sent: Tuesday, March 30, 2010 3:04 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] Data Migration Tool [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC46773@MAIL02.fisalan.nycnet 4958 325 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 30 Mar 2010 10:43:56 -0400383_us-ascii Max,
It's an American (USA) circumlocution (talking around a subject). "The F-Bomb" is a euphemism, a substitute for a four-letter obscene word beginning with the letter "F" and banned from most civil discussion. On the other hand, it's a most satisfying word to swear with when you're awakened at 2AM because your new job blew up in the middle of a production run. [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC46774@MAIL02.fisalan.nycnet 5284 211 41_Re: Determining DB2 z/OS version and mode12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Tue, 30 Mar 2010 09:50:00 -0500559_us-ascii From the manual -

SYSIBM.VERSION Contains a string that represents the version of DB2. This
string has the form pppvvrrm where:

ppp is a product string that is set to the value 'DSN'

vv is a two-digit version identifier such as '09'

rr is a two-digit release identifier such as '01'

m is a one-digit maintenance level identifier such as '5' (Values 0, 1, 2,
3, and 4 are reserved for compatibility mode and enabling-new-function mode,
and values 5, 6, 7, 8, and 9 are reserved for new function mode.) [...]35_013001cad018$469f2db0$d3dd8910$@com 5496 238 15_Re: RACF Expert11_Robin Marsh21_robin.marsh@GMAIL.COM31_Tue, 30 Mar 2010 10:30:51 -0500667_windows-1252 Hi Victor, Maybe they arent aware of tomato alley in here.. haha
are you aware of anyone that is a RACF expert?

Robin

On Mon, Mar 29, 2010 at 5:43 PM, BOND Victor A <
Victor.A.BOND@odot.state.or.us> wrote:

> Robin,
> Didn't get near the hassles here as you got on the CICS list.
> Wonder if that means something?
> Victor
>
> ------------------------------
> *From:* IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] *On Behalf Of *Robin Marsh
> *Sent:* Monday, March 29, 2010 7:31 AM
> *To:* DB2-L@IDUGDB2-L.ORG
> *Subject:* [DB2-L] RACF Expert
>
> Palladian Consulting, a leader in IT services is [...]58_5046d2201003300830j4057eeaau7911b0359a7f0f5@mail.gmail.com 5735 81 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 30 Mar 2010 17:41:40 +0200826_US-ASCII Opssss

Sorry, it's clear I'm not used with classic circumlocution in US.
Apologies. A lot of things to learn, as usual.

Thank you Phil.....

Max

*******************************************************************************************************************************************
Attend IDUG 2010 - Europe, the premiere event for DB2 professionals.
8-12 November 2010, Vienna
Learn more at http://www.idug.org

IDUG's law: To be a happy DB2er you don't need to attend IDUG EU 2010, but
it helps.
Kaplan's corollary: after you attended IDUG EU 2010 to convince your DB2
programmers there's only a large hammer.
******************************************************************************************************************************************* [...]66_OFCFD7E9A6.80CEC895-ONC12576F6.0055CE07-C12576F6.0055D737@cesve.it 5817 143 23_Re: Data Migration Tool16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Tue, 30 Mar 2010 11:44:38 -0400601_utf-8 Phil

I am 'hurt' that you did not mention Compuware's tool... I 'think' its called FILEAID.. ;-)

My laptop 'forced me' to post this.

Robert Galambos CIPP/C CIPP/IT

Compuware Senior Technical Specialist
IBM Certified Database Associate
IBM Certified DB2 9 for z/OS Database Administration
Certified Information Privacy Professional/Canada
Certified Information Privacy Professional/Information Technology

robert.galambos@compuware.com

Tel: +1 905 886 7000
Toll Free: +1 800 263 7189
Fax: +1 905 886 7023
Quebec: +1 877-281-1888 [...]70_551C24F0D5EA4E47BA9B76E14D016DD5067D07F4@nasa-dtw-ex005.nasa.cpwr.corp 5961 119 23_Re: Data Migration Tool13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Tue, 30 Mar 2010 10:54:25 -0500348_utf-8 I see a lot of z/OS-based products being alluded to (OK, I'm being generous) but young Devyani specifically mentioned Linux and DB2 8.2, so I'm guessing this is an off-host requirement.

Cheers,

Raymond
PS. Robert, show your laptop who's boss; don't let it treat you that way. Ooh, I feel a 'Communards' cover coming on. [...]67_78B3EFE2C0C5D74E9E7777D1D669D5420A74404B@PHXCCRPRD04.adprod.bmc.com 6081 218 23_Re: Data Migration Tool16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Tue, 30 Mar 2010 11:59:15 -0400486_utf-8 You maybe right, but then again there 'is a fileaid for that'

Now my laptop expects an apology ;-)

Le contenu de ce courriel s'adresse au destinataire seulement. Il contient de l'information pouvant être confidentielle. Vous ne devez ni le copier ni l'utiliser ni le divulguer à qui que ce soit à moins que vous soyez le destinataire ou une personne désignée autorisée. Si vous le receviez par erreur, veuillez nous aviser immédiatement et le détruire. [...]70_551C24F0D5EA4E47BA9B76E14D016DD5067D07F5@nasa-dtw-ex005.nasa.cpwr.corp 6300 339 15_Re: RACF Expert13_BOND Victor A30_Victor.A.BOND@ODOT.STATE.OR.US31_Tue, 30 Mar 2010 09:02:57 -0700511_US-ASCII Sorry Robin, not to the level you require.

________________________________

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Robin Marsh
Sent: Tuesday, March 30, 2010 8:31 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] RACF Expert

Hi Victor, Maybe they arent aware of tomato alley in here.. haha
are you aware of anyone that is a RACF expert?

Robin

On Mon, Mar 29, 2010 at 5:43 PM, BOND Victor A
wrote: [...]71_D3B03C67566CCC4BA0527224221B814406AFE588@EX-SALEMREV-4.odot.state.or.us 6640 165 23_Re: Data Migration Tool13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Tue, 30 Mar 2010 11:04:00 -0500421_utf-8 I'll get my laptop to e-mail your laptop. Or rather, I'll ask it nicely to do so...

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Galambos, Robert
Sent: 30 March 2010 16:59
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Data Migration Tool

You maybe right, but then again there 'is a fileaid for that'

Now my laptop expects an apology ;-) [...]67_78B3EFE2C0C5D74E9E7777D1D669D5420A744097@PHXCCRPRD04.adprod.bmc.com 6806 168 23_Re: Data Migration Tool14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 30 Mar 2010 12:25:25 -0400480_iso-8859-1 Robert,
My bad -- We worked with it on an evaluation basis at a former employer, but they didn't make a decision to purchase. I even forget the name, all these years later. Sorry. It's not just Fileaid, it's a special tool, RDX maybe?

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Galambos, Robert
Sent: Tuesday, March 30, 2010 11:45 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Data Migration Tool [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC46775@MAIL02.fisalan.nycnet 6975 44 14_[LUW] SQL3132W12_Cuneyt Goksu22_cuneyt.goksu@GMAIL.COM31_Tue, 30 Mar 2010 19:37:50 +0300478_ISO-8859-1 Hi,

I receive following warning during Export.

SQL3132W The character data in column "ORD_CLIENT_NAME" will be
truncated to size "70".

The datatype of the column
ORD_CLIENT_NAME CHARACTER 70 not null

Because of those warnings, imported data looks different and wrong!

I verify this by looking the HEX content of the data as well.
db2 "select hex(ord_client_name) from rsnfs.tbpmtord" --> Looks good.
Original table [...]59_7343f26c1003300937n1ed83ef2u551d919690a2bf26@mail.gmail.com 7020 214 23_Re: Data Migration Tool16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Tue, 30 Mar 2010 12:48:51 -0400444_utf-8 File-AID RDX for m/f
File-AID client server for open systems

Le contenu de ce courriel s'adresse au destinataire seulement. Il contient de l'information pouvant être confidentielle. Vous ne devez ni le copier ni l'utiliser ni le divulguer à qui que ce soit à moins que vous soyez le destinataire ou une personne désignée autorisée. Si vous le receviez par erreur, veuillez nous aviser immédiatement et le détruire. [...]70_551C24F0D5EA4E47BA9B76E14D016DD5067D07F7@nasa-dtw-ex005.nasa.cpwr.corp 7235 59 18_Re: [LUW] SQL3132W10_Joe Geller21_joerg6666@HOTMAIL.COM31_Tue, 30 Mar 2010 13:23:38 -0400404_UTF-8 "Because of those warnings, imported data looks different and wrong!"

Different how? Is it totally unreadable, are a few characters different?
Is it shifted by a byte or two?

I've seen some references to problems like this that had to do with
codepage changes. Is the problem only happening with one column
or the whole table? Do you have this warning for other tables? [...]53_6803579437455333.WA.joerg6666hotmail.com@www.idug.org 7295 68 18_Re: [LUW] SQL3132W12_Cuneyt Goksu22_cuneyt.goksu@GMAIL.COM31_Tue, 30 Mar 2010 17:44:43 +0000377_utf-8 Focused on this table now. Its happening to some char column and some rows of this table. Probably there are others.

Hex length of the data is same. But hex looking is different. After certain byte the original hex and imported hex are different. Before that byte they're same.

Source and target tables are in the same Database. So codepages are same. [...]106_1509587229-1269971110-cardhu_decombobulator_blackberry.rim.net-933237599-@bda144.bisx.produk.on.blackberry 7364 103 18_Re: [LUW] SQL3132W10_Joe Geller21_joerg6666@HOTMAIL.COM31_Tue, 30 Mar 2010 14:17:37 -0400471_UTF-8 Since the data "goes bad" part way through the row, and not for all rows, it does seem
like some character is throwing things off. Do the "bad" rows have the same
character(s) at the spot where things change?

It does seem like a codepage issue. If the database codepage has not changed, and the
codepage of the table matches the database, could the codepage of the output file
be different? There could be conversion going on at that point. [...]53_1350684006611028.WA.joerg6666hotmail.com@www.idug.org 7468 304 23_Re: Data Migration Tool17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Tue, 30 Mar 2010 19:50:57 +0100452_iso-8859-1 Raymond has come back from an extended stay in NZ with this urge to sing 1980s songs.

Let's be glad he's not threatening Rick Astley today, I guess.

We (CA) have a range of tools to move data around, also between platforms, from RC/Migrator to InfoRefiner and InfoTransport, the Compuware one is File-AID Client-Server if memory serves me right, and I apologise if you (BMC) have something the name of which I know not... [...]56_3D02E8610514C04F991CF832BA154C66105670D5@UKSLMS11.ca.com 7773 135 18_Re: [LUW] SQL3132W13_Ian Bjorhovde23_ian.bjorhovde@GMAIL.COM31_Tue, 30 Mar 2010 12:22:06 -0700632_ISO-8859-1 I agree that there is probably a codepage issue occurring.

The database codepage is 1046, but what codepage is your client using?
(i.e. what is LANG set to on the machine where you run the export
utility). It sounds like there's some conversion/data loss happening
during export.

Ian Bjorhovde

On Tue, Mar 30, 2010 at 10:44 AM, Cuneyt Goksu wrote:
>
> Focused on this table now. Its happening to some char column and some rows of this table. Probably there are others.
>
> Hex length of the data is same. But hex looking is different. After certain [...]59_d59713de1003301222w51425656o52530997ca7fb48f@mail.gmail.com 7909 152 18_Re: [LUW] SQL3132W9_Mike Bell21_mbell11a1@VERIZON.NET31_Tue, 30 Mar 2010 14:24:49 -0500487_iso-8859-1 from the fine manual on the subject of DBCS character strings - in this
case as DB2 identifiers but still applies

if encoded in EBCDIC, must start with a shift-out | (X'0E') and end with a
shift-in (X'0F'). There must be an even number | of bytes between the
shift-out and the shift-in. An odd-numbered byte | between those shifts must
not be a shift-out. DBCS blanks (X'4040' in | EBCDIC) are not acceptable
between the shift-out and the shift-in. [...]43_C492A6B62D5E40FC8761DA5834E5FDE4@mikelaptop 8062 297 18_Re: [LUW] SQL3132W12_Peter Suhner24_peter_suhner@HOTMAIL.COM31_Tue, 30 Mar 2010 21:30:14 +0200641_iso-8859-1 Cuneyt,

could it possibly be a UNICODE table?

Just a late evening wild guess,
Peter

> Date: Tue, 30 Mar 2010 12:22:06 -0700
> From: ian.bjorhovde@GMAIL.COM
> Subject: Re: [DB2-L] [LUW] SQL3132W
> To: DB2-L@IDUGDB2-L.ORG
>
> I agree that there is probably a codepage issue occurring.
>
> The database codepage is 1046, but what codepage is your client using?
> (i.e. what is LANG set to on the machine where you run the export
> utility). It sounds like there's some conversion/data loss happening
> during export.
>
>
> Ian Bjorhovde
>
>
>
> On Tue, [...]43_SNT107-W34204149D0FB1E585A7B00F11F0@phx.gbl 8360 182 15_Re: RACF Expert10_Dave Nance16_dav1mo@YAHOO.COM31_Tue, 30 Mar 2010 13:46:47 -0700620_utf-8 BUT, you both may start getting hassled for going back n forth on list rather than to each other:)   David Nance   ________________________________ From: Robin Marsh To: DB2-L@IDUGDB2-L.ORG Sent: Tue, March 30, 2010 11:30:51 AM Subject: Re: [DB2-L] RACF Expert Hi Victor, Maybe they arent aware of tomato alley in here.. haha  are you aware of anyone that is a RACF expert? Robin On Mon, Mar 29, 2010 at 5:43 PM, BOND Victor A wrote: Robin, >Didn't get near the hassles here as you got on the CICS list. >Wonder if that means something? >Victor > > [...]43_230879.93968.qm@web57808.mail.re3.yahoo.com 8543 161 18_Re: [LUW] SQL3132W17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Tue, 30 Mar 2010 23:33:08 +0100673_iso-8859-1 Cu,

Any special characters in any of the SELECT string?

Is there any going back and forth with Unicode (table or DBRM for application) anywhere there?

Thanks.

Aurora

Aurora Emanuela Dell'Anno
CA MSC
Sr. Engineering Services Architect
Tel: +44 (0)1753 577 733
Mobile: +44 (0)7768 235 339
Aurora.Dellanno@ca.com

http://www.ca.com/

P please don't print this e-mail unless you really need to!

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Cuneyt Goksu
Sent: 30 March 2010 18:45
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] [LUW] SQL3132W [...]56_3D02E8610514C04F991CF832BA154C66105670DE@UKSLMS11.ca.com 8705 25 91_Re: Is there a way to execute the same non-CICS DB2 COBOL program in both batch and online?12_Roy Reynolds17_royr@BERKELEY.EDU31_Tue, 30 Mar 2010 19:45:49 -0400688_UTF-8 Did you read the ListServ archived subject 'Calling DB2 subroutines from CICS' from Nov 3, 2004?

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________ [...]49_2271790892437922.WA.royrberkeley.edu@www.idug.org 8731 299 132_The DB2Night Show Episode #15 - "ONLINE TABLE MOVES", with Ergin Babani, IBM Toronto Lab - Friday - 2 April 2010 at 10:00 am USA CDT13_David Chapman24_David.Chapman@IAG.COM.AU31_Wed, 31 Mar 2010 17:24:04 +1100753_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 #15 - 2 April 2010 - "ONLINE TABLE MOVES", with Ergin Babani, 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%201003310224156047.00CB@IDUGDB2-L.ORG 9031 491 18_Re: [LUW] SQL3132W10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 31 Mar 2010 08:57:04 +0200684_ISO-8859-1 Any FOR BIT DATA or something similar ?

"Dell'Anno, Aurora"
Sent by: IDUG DB2-L
31/03/2010 00.39
Please respond to
IDUG DB2-L

To
DB2-L@IDUGDB2-L.ORG
cc

Subject
Re: [DB2-L] [LUW] SQL3132W

Cu,

Any special characters in any of the SELECT string?

Is there any going back and forth with Unicode (table or DBRM for
application) anywhere there?

Thanks.

Aurora

Aurora Emanuela Dell'Anno
CA MSC
Sr. Engineering Services Architect
Tel: +44 (0)1753 577 733
Mobile: +44 (0)7768 235 339
Aurora.Dellanno@ca.com [...]66_OFF9AD9CA4.E3A54039-ONC12576F7.0026237F-C12576F7.0025D01D@cesve.it 9523 371 18_Re: [LUW] SQL3132W12_Cuneyt Goksu22_cuneyt.goksu@GMAIL.COM31_Wed, 31 Mar 2010 11:18:19 +0300540_ISO-8859-1 Peter,

Database is defined as ASCII.
Table's CCSID value is ASCII.

This database was created codepage 1046 and loaded with data
The challenge is moving it to another database...

Backup/Restore is working fine.
The issue is with Export, because of data.

Cuneyt

-----Original Message-----
*From:* IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] *On Behalf Of *Peter Suhner
*Sent:* Tuesday, March 30, 2010 10:30 PM
*To:* DB2-L@IDUGDB2-L.ORG
*Subject:* Re: [DB2-L] [LUW] SQL3132W [...]62_z2v7343f26c1003310118o4cb2b56btfdc3be3c55078647@mail.gmail.com 9895 420 18_Re: [LUW] SQL3132W17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Wed, 31 Mar 2010 09:54:42 +0100621_iso-8859-1 how is the data entered though?

also, why is the data truncated?

Thanks.

Aurora

Aurora Emanuela Dell'Anno
CA MSC
Sr. Engineering Services Architect
Tel: +44 (0)1753 577 733
Mobile: +44 (0)7768 235 339
Aurora.Dellanno@ca.com

http://www.ca.com/

P please don't print this e-mail unless you really need to!

________________________________

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Cuneyt Goksu
Sent: 31 March 2010 09:18
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] [LUW] SQL3132W [...]56_3D02E8610514C04F991CF832BA154C66105670E6@UKSLMS11.ca.com 10316 81 18_Re: [LUW] SQL3132W10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 31 Mar 2010 11:12:38 +0200538_US-ASCII I did an export in my DB2 express and I saw they are comma
separated....did you missed some separator ? A shot in the dark.

Max Scarpa

- Mossbauer's law: if all runs fine, probably you're looking at the wrong
DB2.

*******************************************************************************************************************************************

Attend IDUG 2010 - Europe, the premiere event for DB2 professionals.
8-12 November 2010, Vienna
Learn more at http://www.idug.org [...]66_OFAFC3DE09.68BA1C33-ONC12576F7.003223AF-C12576F7.00323950@cesve.it 10398 72 62_Re: Information Center updated (standard end of month message)13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Wed, 31 Mar 2010 05:39:45 -0400415_utf-8 Is anyone else having problems updating their Info Center?

Mine reports that it can't connect to the update site at ftp://ftp.software.ibm.com/software/imzic

Mind you, I can ping ftp.software.ibm.com OK and I can browse to ftp://ftp.software.ibm.com/software/imzic in Chrome - it just seems to be Info Center that is struggling

So I am confused....

Thanks for any suggestions [...]58_4440F5DA00E3F3459BBCB97431B91B6611B00B63@MAILR004.mail.lan 10471 407 18_Re: [LUW] SQL3132W12_Cuneyt Goksu22_cuneyt.goksu@GMAIL.COM31_Wed, 31 Mar 2010 12:42:07 +0300550_ISO-8859-1 No FOR BIT DATA
Export in IXF format but it behaves the same in DEL as well..

-----Original Message-----
*From:* IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] *On Behalf Of *Max Scarpa
*Sent:* Wednesday, March 31, 2010 9:57 AM
*To:* DB2-L@IDUGDB2-L.ORG
*Subject:* Re: [DB2-L] [LUW] SQL3132W

Any FOR BIT DATA or something similar ?

*"Dell'Anno, Aurora" *
Sent by: IDUG DB2-L

31/03/2010 00.39
Please respond to
IDUG DB2-L [...]61_v2h7343f26c1003310242me4fb540fse995f649073c4a8@mail.gmail.com 10879 74 57_AUTO: Bill Pigg/San Jose/IBM is out of the office and ...9_Bill Pigg16_wpigg@US.IBM.COM31_Wed, 31 Mar 2010 04:00:56 -0600364_US-ASCII I am out of the office until 11/02/2010.

... and has left the building. I will be selectively available at
wm_pigg@yahoo.com. Good luck to you all! I'm riding my new HD Ultra and
going fishing.

Note: This is an automated response to your message "DB2-L Digest - 30 Mar
2010 to 31 Mar 2010 (#2010-89)" sent on 3/30/10 23:00:00. [...]68_OFFF37F158.B75C9CF9-ON872576F7.003704A8-872576F7.003704A9@us.ibm.com 10954 29 18_Re: [LUW] SQL3132W16_Aurora Dell'Anno22_aurora.dellanno@CA.COM31_Wed, 31 Mar 2010 05:00:22 -0400846_UTF-8 there is also this about conversion in transferring data between different versions of DB2 LUW:

http://database.ittoolbox.com/groups/technical-functional/db2-l/export-warning-sql3132w-with-nonzero-return-code-1894433

it suggests an explicit "db2 set codepage" command.

_____________________________________________________________________

* 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! *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to $1600 off when you both come to the conference!
_____________________________________________________________________ [...]54_3345118882952764.WA.aurora.dellannoca.com@www.idug.org 10984 327 62_Re: Information Center updated (standard end of month message)15_Pierre R Bodart23_Bodart_Pierre_R@CAT.COM31_Wed, 31 Mar 2010 12:59:36 +0200583_US-ASCII Phil,

I have exactly the same problem here at the office or from home.

So, I have no suggestion, just hope someone by IBM is aware of....

Thks,

Pierre
Caterpillar Belgium

Phil Grainger
Sent by: IDUG DB2-L
03/31/2010 11:41 AM
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: 04/30/2010 [...]71_OFA8DC92D4.9365F4CD-ONC12576F7.003C43BD-C12576F7.003C6717@notes.cat.com 11312 626 62_Re: Information Center updated (standard end of month message)13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Wed, 31 Mar 2010 07:07:10 -0400583_us-ascii Aha!

Thanks
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

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Pierre R Bodart
Sent: 31 March 2010 12:00
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Information Center updated (standard end of month message) [...]58_4440F5DA00E3F3459BBCB97431B91B6611B00B6A@MAILR004.mail.lan 11939 119 18_Re: [LUW] SQL3132W12_Cuneyt Goksu22_cuneyt.goksu@GMAIL.COM31_Wed, 31 Mar 2010 14:33:24 +0300839_ISO-8859-1 Bulls Eye!

db2set codepage=1046
export / import
worked fine...

Thanks to all great feedbacks...

---

there is also this about conversion in transferring data between different
versions of DB2 LUW:

*
http://database.ittoolbox.com/groups/technical-functional/db2-l/export-warning-sql3132w-with-nonzero-return-code-1894433
*

it suggests an explicit "db2 set codepage" command.

_____________________________________________________________________

* 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! * [...]62_n2l7343f26c1003310433nc28d7d17yaa153cc0856b8fda@mail.gmail.com 12059 61 62_Are DSNTEP2/4 supposed to be compatible with current DB2 LUW ?11_Nenad Vidak21_nenad.vidak@GMAIL.COM31_Wed, 31 Mar 2010 05:41:46 -0400657_UTF-8 Hello,
I managed to bind SPUFI to DB2 on AIX, but DSNTEP2/4 bind fails with:

DSNT270I -DB1T THE FOLLOWING SQLCA INFORMATION WAS RETURNED FROM
SQLRA126
SQLCODE = 20
SQLSTATE =
SQLERRMT = STRDEL DECDEL RELEASE ENCODING MINDIVSCALE
SQLWARN 0= ,1= ,2= ,3= ,4= ,5= ,6= ,7= ,8= ,9= ,A=
DSNT271I -DB1T THE FOLLOWING SQLCA INFORMATION WAS RETURNED FROM
SQLNP012
SQLCODE = -104
SQLSTATE = 42601
SQLERRMT = WITH DECLARE C1 CURSOR FOR
SQLWARN 0= ,1= ,2= ,3= ,4= ,5= ,6= ,7= ,8= ,9= ,A=
STATEMENT= 1248
DSNT271I -DB1T THE FOLLOWING SQLCA INFORMATION WAS RETURNED FROM
QLNP012
SQLCODE = -104
SQLSTATE [...]53_4764528107444473.WA.nenad.vidakgmail.com@www.idug.org 12121 52 50_Question on Partition rotation in DB2 V8.1 on z/OS6_Sekhar23_sekhar.mekala@GMAIL.COM31_Wed, 31 Mar 2010 08:41:46 -0400346_UTF-8 Hi all,
In one of our DB2 databases (on z/OS) we are rotating the first logical partition of a partitioned table to hold new data. The table space’s partitions were already having Compressed dictionaries (COMPRESS YES was specified in table space definition and sample data was loaded to built the dictionary for each partition). [...]55_1087596599315751.WA.sekhar.mekalagmail.com@www.idug.org 12174 78 54_Re: Question on Partition rotation in DB2 V8.1 on z/OS13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Wed, 31 Mar 2010 09:42:33 -0400668_utf-8 Sekhar - see below for answers

Hope these are helpful

Rotating is very useful but also fraught with many dangers to trap the unwary

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

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sekhar
Sent: 31 March 2010 13:42
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] Question on Partition rotation in DB2 V8.1 on z/OS [...]58_4440F5DA00E3F3459BBCB97431B91B6611B00B85@MAILR004.mail.lan 12253 92 66_Re: Are DSNTEP2/4 supposed to be compatible with current DB2 LUW ?16_Wallace, Stephen25_stephen.wallace@LANDG.COM31_Wed, 31 Mar 2010 15:04:36 +0100350_us-ascii Nenad,
We're a Windows site rather than a AIX site but we had a similar problem
with DSNTIAUL. To bind the new multi row fetch version of DSNTIAUL on
windows we had to add SQLERROR(CONTINUE) to our bind cards. When
running DSNTIAUL at the remote database we had to add the parameter
PARM('1') to disable multi row fetch. [...]59_2A5FCDEE9A299647B797452C9EE9CBB50939AF22@KWDMXV41.landg.net 12346 61 17_Handouts at IDUGs13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Wed, 31 Mar 2010 11:23:17 -0400392_iso-8859-1 Each time I present at IDUG, at some point I am asked "why are there no handouts" by at least a couple of people, so this year for IDUG North America in Tampa I decided to bring my own - or at least enough for the early-birds.

Well, I have two sessions - one presentation is 54 slides, the second is 48. I converted them to pdf files, two-up (per page) as notes pages. [...]58_4440F5DA00E3F3459BBCB97431B91B6611B00BAB@MAILR004.mail.lan 12408 161 36_[z/OS - DB2 V9] Access Path question18_Satish Srikakulapu26_Satish.Srikakulapu@APS.COM31_Wed, 31 Mar 2010 08:29:06 -0700443_us-ascii Hello Listers:

Environment:
z/OS - V 1.10
DB2 - V9.1 CM

Question:

We are migrating to V9.1 CM in a couple of days. We want to preserve the current access paths in Production (Version 8). I saw that there is REBIND option PLANMGMT that would allow me to keep the previous version of access path. But, in our shop we do BINDs of all our programs with every install (and this happens once in two months). [...]55_D42E68651088914B9B327A4EEA8433ACA6CCF15D@VM251.apsc.com 12570 515 40_Re: [z/OS - DB2 V9] Access Path question12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Wed, 31 Mar 2010 10:43:08 -0500463_us-ascii Satish:

If you use the EXTENDED feature for PLAN MANAGEMNT then you will keep the
original bind in reserve. However, once you do a bind you will discard all
of the saved data. The only option available is to set hints.

We have a lot of experience with this because of migration issues. If you
want to discuss the particulars we can set up a web session. There are
papers from IDUG presentations about this on our web site. [...]35_005601cad0e8$dd019920$9704cb60$@com 13086 440 40_Re: [z/OS - DB2 V9] Access Path question14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Wed, 31 Mar 2010 11:44:04 -0400400_us-ascii Satish,

If you have to preserve access paths, then you need to either institued package bind management in DB2V9 or preserve all your RUNSTATS from the last time you got a good bind.

PLAN_TABLE and DSN_STATEMENT_TABLE **DO NOT** preserve access paths unless you're using OPTHINT in your binds, and then it's not guaranteed. They are for documentation
and OPTHINT only. [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC46782@MAIL02.fisalan.nycnet 13527 518 40_Re: [z/OS - DB2 V9] Access Path question13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Wed, 31 Mar 2010 11:52:19 -0400531_us-ascii Satish

The way forward IS to use REBIND with plan management and to stop doing those unnecessary binds

Yes, there are ways to try and influence the optimiser (with hints) to get back to an earlier access path using plan_table data as input, but REBIND ... SWITCH is the ONLY guaranteed way to get back to a prior version of an access path
Phil Grainger
Cogito Ltd.
phil.grainger@cogito.co.uk
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk [...]58_4440F5DA00E3F3459BBCB97431B91B6611B00BB7@MAILR004.mail.lan 14046 570 40_Re: [z/OS - DB2 V9] Access Path question18_Satish Srikakulapu26_Satish.Srikakulapu@APS.COM31_Wed, 31 Mar 2010 09:10:47 -0700585_us-ascii Thank you, Phil Grainger, Phil Sevetson and Gerald Hodge.

From your experiences and others too, did anybody notice that accesspaths of the programs have gone south after running RUNSTATS (without KEYCARD) and doing a rebind of all the programs in DB2 V9.

Now that I brought up RUNSTATS, I would also like to know if running RUNSTATS WITH KEYCARD is recommended in DB2 V9. This is recommended by IBM but I want to know user experiences with this. We ran RUNSTATS WITH KEYCARD in DB2 V8 and found that few of the access paths have gone wrong horribly. So, we [...]55_D42E68651088914B9B327A4EEA8433ACA6CCF160@VM251.apsc.com 14617 512 40_Re: [z/OS - DB2 V9] Access Path question12_Hepp Shery C21_Shery.Hepp@SRPNET.COM31_Wed, 31 Mar 2010 09:15:21 -0700731_us-ascii Willie has an entry on his blog that might help you out:

http://it.toolbox.com/blogs/db2zos/db2-9-cm-rebind-best-practices-29136

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Satish
Srikakulapu
Sent: Wednesday, March 31, 2010 8:29 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] [z/OS - DB2 V9] Access Path question

Hello Listers:

Environment:

z/OS - V 1.10

DB2 - V9.1 CM

Question:

We are migrating to V9.1 CM in a couple of days. We want to preserve the
current access paths in Production (Version 8). I saw that there is
REBIND option PLANMGMT that would allow me to keep the previous version
of access path. But, in our shop we [...]55_4B518F9CD247DA458840B9A5B9435D1602F5BDB7@EXCV25.srp.gov 15130 533 40_Re: [z/OS - DB2 V9] Access Path question12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Wed, 31 Mar 2010 11:33:26 -0500354_us-ascii Satish:

When you move to V9 CM SPROC will be disabled until there is a rebind. (I am
explaining this and not responsible for the fact.) If you rebind with
EXTENDED and then fall back SPROC will remain enabled. It depends on your
environment as to what advantage or disadvantage this is.

Our suggested approach is to: [...]35_007301cad0ef$e3be6f70$ab3b4e50$@com 15664 930 40_Re: [z/OS - DB2 V9] Access Path question16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Wed, 31 Mar 2010 12:49:54 -0400400_us-ascii Hello Satish - one change for V9 compared to V8 is in fact the RUNSTATS.
It is recommended to do the RUNSTATS prior to any REBIND due to the
DATAREPEATFACTOR providing better decision for the Optimizer compared to
CLUSTERRATIOF.

When I compared all our packages between V8 and 9, it was not as bad as
going from V7 to V8. I noticed a lot of LIST PREFETCH going away. [...]56_0A18F096E689AC43BB2F52DAE5674D600808DD15@USILMS14.ca.com 16595 615 40_Re: [z/OS - DB2 V9] Access Path question18_Satish Srikakulapu26_Satish.Srikakulapu@APS.COM31_Wed, 31 Mar 2010 10:39:45 -0700702_us-ascii Hello Gerald,

Thank you very much for the detailed response. We did apply the compression PTF for compressing SPT01.

Regards,
Satish

________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Gerald Hodge
Sent: Wednesday, March 31, 2010 9:33 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] [z/OS - DB2 V9] Access Path question

Satish:

When you move to V9 CM SPROC will be disabled until there is a rebind. (I am explaining this and not responsible for the fact.) If you rebind with EXTENDED and then fall back SPROC will remain enabled. It depends on your environment as to what advantage or disadvantage [...]55_D42E68651088914B9B327A4EEA8433ACA6CCF162@VM251.apsc.com 17211 820 40_Re: [z/OS - DB2 V9] Access Path question18_Satish Srikakulapu26_Satish.Srikakulapu@APS.COM31_Wed, 31 Mar 2010 10:44:10 -0700303_us-ascii Hello Steen,

This is quite re-assuring to know that the accesspaths have not gone real bad after the migration (the case was not the same when we migrated from V7 to V8). We will do rebind first, verify the access paths and execution times with application teams and then go ahead. [...]55_D42E68651088914B9B327A4EEA8433ACA6CCF163@VM251.apsc.com 18032 45 54_Re: Question on Partition rotation in DB2 V8.1 on z/OS25_SUBSCRIBE DB2-L Anonymous23_SEKHAR.MEKALA@GMAIL.COM31_Wed, 31 Mar 2010 14:10:29 -0400652_UTF-8 Hi Phil,

Thanks for your prompt reply.

I have a question. You replied that DB2 will use normal DELETE while rotating the first logical partition to the last logical partition, so that the DELETES are logged and we have the ROLLBACK option. However, you confirmed that DB2 also deletes the compression dictionary for the last logical partition after rotation. Now my question is: if DB2 deletes the data using normal DELETE while partition rotation, why should I build the compression dictionary for the new logical partition after rotation? Normal DB2 DELETES will not remove the compression dictionary eventhough DELETES make [...]55_2559154120922695.WA.SEKHAR.MEKALAGMAIL.COM@www.idug.org 18078 1192 40_Re: [z/OS - DB2 V9] Access Path question16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Wed, 31 Mar 2010 14:35:35 -0400593_us-ascii I have used COLGROUP instead for those indexes where I have had queries
only referencing a subset of the index-columns where distribution stats
were skewed.

Steen Rasmussen
CA

Sr Engineering Services Architect

IBM Certified Database Associate - DB2 9 Fundamentals

IBM Certified Database Administrator - DB2 9 DBA for z/OS

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Satish
Srikakulapu
Sent: Wednesday, March 31, 2010 12:44 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] [z/OS - DB2 V9] Access Path question [...]56_0A18F096E689AC43BB2F52DAE5674D600808DDF9@USILMS14.ca.com 19271 50 21_ADMIN Anonymous AGAIN16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Wed, 31 Mar 2010 14:49:11 -0400372_utf-8 It seems that this needs to be repeated

This is a professional listserv and as such, the policy is 'Anonymous' (nicknames) are NOT allowed.

If you notice that is your 'name' on the listserv is anonymous, then PLEASE login to the web interface of the listserv (idug.org then listserv tab). Otherwise I will be forced to delete/suspend the account. [...]70_551C24F0D5EA4E47BA9B76E14D016DD5067D0801@nasa-dtw-ex005.nasa.cpwr.corp 19322 299 33_db2 9.1 roles and trusted context11_Diana Nagel16_dknagel@BEPC.COM31_Wed, 31 Mar 2010 14:13:05 -0500339_us-ascii Wondering if anyone has done this and how much work it was. I was hoping it would be easier....but not sure it will be.

Right now we assign perms to each user and use Racf.

I was hoping this would be a simple

1. As creating role.

2. Grant perms to role.

3. Create trusted context for role. [...]56_6454C4DAE553484980557DB37B06BC030127FEF6@HDQ153.bepc.net 19622 583 37_Re: db2 9.1 roles and trusted context13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Wed, 31 Mar 2010 15:16:58 -0400355_us-ascii Hi Diana

Not sure what your question is.....

True - it won't be as easy as the single GRANT you do today

BUT you will have MUCH more flexibility and MUCH more control using roles and trusted contexts

You'll do (1) then (2) then as many (3) as you want, depending on how granular you want the access control to be [...]58_4440F5DA00E3F3459BBCB97431B91B6611B00BD9@MAILR004.mail.lan 20206 988 40_Re: [z/OS - DB2 V9] Access Path question18_Satish Srikakulapu26_Satish.Srikakulapu@APS.COM31_Wed, 31 Mar 2010 13:20:20 -0700464_us-ascii Thank you Steen for the information. We will first run with RUNSTATS WITHOUT KEYCARD, and then run RUNSTATS with keycard and see if any of the accesspaths change for worse.

Regards,
Satish

________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Rasmussen, Steen
Sent: Wednesday, March 31, 2010 11:36 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] [z/OS - DB2 V9] Access Path question [...]55_D42E68651088914B9B327A4EEA8433ACA6CCF167@VM251.apsc.com 21195 247 18_Re: [LUW] SQL3132W12_Peter Suhner24_peter_suhner@HOTMAIL.COM31_Wed, 31 Mar 2010 22:59:39 +0200338_iso-8859-1 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. [...]43_SNT107-W278686BC67BF993C363B4AF11E0@phx.gbl 21443 150 33_Local Date exit on DB2 V9 NF MODE12_Asamoto, Roy25_Roy.Asamoto@STATEAUTO.COM31_Wed, 31 Mar 2010 17:00:03 -0400569_us-ascii Hi,

I am testing the local date exit. We want to be able to accept an input
of CCYYMMDD as a valid date. I found an IBM tachnote(FAQ) that seemed
to be exactly what we want. I asssebled DSNHDECM with DATE=ISO and
DATELEN=10 to enable a local date but not the default per the FAQ. I
assembled the DSNXVDTX exit and stopped and started the DB2 subsystem.
The exit works fine for input. We can load from our flat files and when
we retrieve it it shows up in the normal ISO (CCYY-MM-DD) format we
expect. We then tested retrieving [...]68_0915161C01220E479F8F96BA3A27C741010A3311@SACOLEX8.corp.stateauto.com 21594 167 37_Re: Local Date exit on DB2 V9 NF MODE18_B. L. "Tink" Tysor16_Tink@BLTYSOR.COM31_Wed, 31 Mar 2010 18:18:49 -0400621_UTF-8 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:

> Hi,
>
> I am testing the local date exit. We want to be able to accept an input of
> CCYYMMDD as a valid date. I found an IBM tachnote(FAQ) that seemed to be
> exactly what we want. I asssebled DSNHDECM with DATE=ISO and DATELEN=10 to
> enable a local date but not the default per the FAQ. I assembled the
> DSNXVDTX exit and stopped and [...]62_y2p105fd0281003311518m8b146439h437befc5e566632a@mail.gmail.com 21762 113 21_Re: Handouts at IDUGs35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Wed, 31 Mar 2010 15:28:44 -0400546_iso-8859-1 Hi Phil,

I just had copies made here at Staples, 50 copies of 28 pages = 1040
copies.
$104 US; .10/page

A bit less than you pay there ???

You can send them the PDF file online, and pick up the copies when you're in
Tampa...

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_D7509B9C4C7A4FE7A7AB71F535616491@DellNotebook3