1 IDUGDB2-L.ORG /home/listserv/home/db2-l June 2010, week 1
2 93 50_AW: [DB2-L] Reorg with DISCARD - slow UNLOAD phase35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM30_Tue, 1 Jun 2010 09:28:55 +0200326_iso-8859-1 Hi Michael
I wasn't aware, that the unload-utility uses an index at all. My experience so far is, that the unload always uses a tablespace scan. Why should it use index access? Do you experience better elapsed time, when you omit the DISCARD-clause? And how did you know, that an index access was used? [...]43_DB2-L%201006010329065303.0F35@IDUGDB2-L.ORG
96 45 42_Re: Reorg with DISCARD - slow UNLOAD phase21_Devyani Sahasrabuddhe30_devyanisahasrabuddhe@GMAIL.COM30_Tue, 1 Jun 2010 03:36:40 -0400508_UTF-8 Hello,
Have you mentioned WHEN condition with DISCARDS option in the reorg. The unclustered index might have been picked up to selectively unload the records during unload phase and as it is not the appropriate index which is picked up as you said, unload phase is slow.
Specifying SORTDATA NO will only pick up clustered index to unload and sort in clustering sequence.Therefore there should not be any correlation between SORTDATA No and unclustered index picked up during unload. [...]62_5073680180372816.WA.devyanisahasrabuddhegmail.com@www.idug.org
142 103 42_Re: Reorg with DISCARD - slow UNLOAD phase10_Dave Nance16_dav1mo@YAHOO.COM30_Tue, 1 Jun 2010 02:37:07 -0700649_iso-8859-1 Are you sure it is "slow" one item I have seen people become concerned about is the unload phase count not increasing every time they hit enter on their monitor of choice. When what is actually occuring is there are a ton of discards occuring. David Nance ________________________________ From: Michael Kaplan To: DB2-L@IDUGDB2-L.ORG Sent: Sun, May 30, 2010 6:44:23 AM Subject: [DB2-L] Reorg with DISCARD - slow UNLOAD phase Hello, We have experienced a slow UNLOAD phase of REORG SHRLEVEL REFERENCE with DISCARD. Because SORTDATA NO was specified, UNLOAD algorithm choose one of 4 table indexes ( [...]43_693707.44293.qm@web57803.mail.re3.yahoo.com
246 221 47_Questions about Optimization Service Center....8_Bob Kota23_bob.kota@EXELONCORP.COM30_Tue, 1 Jun 2010 07:24:00 -0500403_us-ascii Hello,
We don't have a lot of experience with installing and using OSC. Does
it expect all of the following tables to be available at installation
time?
We have multiple subsystems and we'd like to know what
overhead/maintenance is involved with the EXPLAIN tables.
If there are any "How To" docs, potential "gotchas" out there, please
feel free to share. [...]67_DD59E34C48010348B1E1F51596A264F361F912@cccmsxch15.energy.power.corp
468 29 36_Default Value in Load Utility zOS V814_Gwyn Pritchard27_Gwyn.Pritchard@BARCLAYS.COM30_Tue, 1 Jun 2010 08:34:42 -0400687_UTF-8 We are converting a non IBM DB2 Load Utility Job to an IBM Load Utility and, surprisingly, I cannot see a way of assigining a fixed value to column.
Any thoughts anyone
(othern than post process the Table
Thanks in advance
Gwyn Pritchard
_____________________________________________________________________
* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** NEW - IBM hands-on labs -> no additional charge
_____________________________________________________________________ [...]59_0783913531694450.WA.Gwyn.PritchardBarclays.com@www.idug.org
498 41 40_Re: Default Value in Load Utility zOS V813_Bell, Raymond20_Raymond_Bell@BMC.COM30_Tue, 1 Jun 2010 06:55:34 -0600417_utf-8 Any chance to pre-process the load file? 'Cause without an ISV product I don't think there _is_ a way to provide literals in IBM Load utility jobs. Soz.
Cheers,
Raymond
-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Gwyn Pritchard
Sent: 01 June 2010 13:35
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] Default Value in Load Utility zOS V8 [...]67_78B3EFE2C0C5D74E9E7777D1D669D5420D09A511@PHXCCRPRD04.adprod.bmc.com
540 79 40_Re: Default Value in Load Utility zOS V810_Roger Hecq18_Roger.Hecq@UBS.COM30_Tue, 1 Jun 2010 08:56:46 -0400437_US-ASCII That is one of the features of the vendor product that you were using.
We have also used it for that feature.
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 Gwyn
Pritchard
Sent: Tuesday, June 01, 2010 8:35 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] Default Value in Load Utility zOS V8 [...]62_1A700EEF49343148A08879B1E3CA5BA6150900B9@NSTMC101PEX1.ubsw.net
620 195 138_AD: DB2 Tech Talk - DSNZPARM - Zee or Zed and Why Do I Care? with Phil Grainger and Sally Fabian on Thursday June 3rd at noon Eastern time13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Tue, 1 Jun 2010 09:15:28 -0400404_us-ascii This is the first Cogito DB2 Tech Talk webinar to result from a "listener suggestion"
The presentation starts with the basics of DSNZPARMs: What they are, why they are important and where they come from.
We will then take a look at a couple of suggested ways to manage ZPARM settings, before concluding with a look at some of the new dsnzparm parameters from DB2 V8 and DB2 9 [...]60_4440F5DA00E3F3459BBCB97431B91B6612B61DFBF4@MAILR004.mail.lan
816 442 51_Re: Questions about Optimization Service Center....11_Mike Turner19_mike.turner@GMX.COM30_Tue, 1 Jun 2010 14:17:48 +0100768_iso-8859-1 Hi Bob
The tables can be created as part of the install or created later through the OSC Workstation (user must have the necessary DB2 privileges). Have a look at the Redbook 'IBM DB2 9 for z/OS: New Tools for Query Optimization' SG24-7421 www.redbooks.ibm.com/abstracts/sg247421.html.
Regards
Mike Turner
Email: mike.turner@gmx.com
Tel: +44 (0)1565-873702
Web: www.michael-turner.ltd.uk
Michael Turner Ltd. Registered in England & Wales No. 1433722. Registered Office: 131 King Street, Knutsford, Cheshire, WA16 6EJ. VAT No. GB 338 4159 44.
----- Original Message -----
From: Bob Kota
Newsgroups: bit.listserv.db2-l
To: DB2-L@IDUGDB2-L.ORG
Sent: Tuesday, June 01, 2010 1:24 PM
Subject: [DB2-L] Questions [...]44_F9428357BE914905AE44482F451DBA94@ToshibaA300
1259 173 54_Baltmore/Washington DB2 Users' Group Meeting 6/9/2010!14_Henry L Nalven25_henry.nalven@MARRIOTT.COM30_Tue, 1 Jun 2010 10:07:43 -0400545_UTF-8 The Baltimore/Washington DB2 Users' Group
Meeting Schedule for June 9, 2010 (Wednesday)
When?
Wednesday, June 9, 2010 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: [...]57_4639963551354652.WA.henry.nalvenmarriott.com@www.idug.org
1433 65 40_Re: Default Value in Load Utility zOS V814_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Tue, 1 Jun 2010 10:08:17 -0400419_us-ascii Gwyn,
If it's a "cursor load", i.e. a LOAD from a CURSOR, you could specify the fixed value in the SELECT; if the input file is created from DSNTIAUL, you have a similar option. If you're willing to put a trigger on the table for INSERT, and specify ENFORCE CONSTRAINTS in the load (which will cost you a lot of CPU time), you can, I believe, specify the value there (I haven't tried that myself). [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC469B3@MAIL02.fisalan.nycnet
1499 40 28_Archiving/Purging strategies13_Andre LeBlanc30_AndreD.LeBlanc@CBSA-ASFC.GC.CA30_Tue, 1 Jun 2010 10:02:50 -0400327_UTF-8 Hi All,
What strategies do you use to archive or purge from a very large 24/7 OLTP system?
I was hoping to partition by month and ROTATE partitions after doing a dummy LOAD into oldest partition.
However, foreign key relationships result in CHECK PENDING. Same result if I use a REORG with DISCARD. [...]61_6145933233773745.WA.AndreD.LeBlancCBSAASFC.GC.CA@www.idug.org
1540 46 45_db2 LUW - multiple db2sysc processed in topas21_pcandella@metlife.com21_pcandella@METLIFE.COM30_Tue, 1 Jun 2010 11:31:35 -0400445_UTF-8 Hello,
I have what I believe to be a basic question for DB2 LUW. ( I am relatively new to this environment - so, apologies for a basic question).
This is In reference to db2 luw v8.1 fp14 running on AIX 5.3 - 32 bit EE
My question is about the db2sysc.
My understanding is that db2sysc is the process used for the main db2 system controller, and one of these processes should be running for each instance. [...]53_3396764992955997.WA.pcandellametlife.com@www.idug.org
1587 501 82_=?iso-8859-1?Q?=FA=F9=E5=E1=E4=3A_?=[DB2-L] Reorg with DISCARD - slow UNLOAD phase14_Michael Kaplan25_micaelkp@NETVISION.NET.IL30_Tue, 1 Jun 2010 19:06:26 +0300436_iso-8859-1 David,
I am sure it is slow. Two tables were reorged with DISCARD option. The first
one has index ( order_no), the second table has index ( card_number,
order-no).
WHEN condition was related to scope of ORDER_NO ( between … and.. ).
As I mentioned, with SORTDATA NO, the first REORG used index where ORDER_NO
is the first column and, really, I can observe quite long periods of
DISCARDs [...]38_ECE8D1590EF741EB8BE88BFFEFD4C690@MERAV
2089 159 49_Re: db2 LUW - multiple db2sysc processed in topas12_Peter Suhner24_peter_suhner@HOTMAIL.COM30_Tue, 1 Jun 2010 23:10:56 +0200586_Windows-1252 Patty,
I don't know Topas (it's kind of a monitor, right?), but to what concerns Solaris and HP-UX, most of the DB2 processes appear under the name of "db2sysc" when using "ps -ef". For such environments, you would use "db2ptree" to check the real process names.
Afaik, AIX displays the real process names - which is what you actually see in your "ps -ef" command output. But from the behavior described above, I would assume that Topas does the same thing as Solaris and HP-UX when it needs to derive process names - and struggles in the identical way. [...]43_SNT107-W257EDC3E35EEF8CC70BCB4F1EF0@phx.gbl
2249 70 58_Los Angeles DB2 Area User Group 6/3 & 6/4 in the OC and LA13_Mark DePledge20_mark.depledge@CA.COM30_Tue, 1 Jun 2010 17:12:59 -0400354_UTF-8 2 presentations from 10-2 repeated each day -
CA technologies is introducing CA Mainframe Chorus version 1 which is a DB2 Database Management (DBA for DB2) role that will offer the following major innovations and usability enhancements for DB2 database management, using the new CA Mainframe Chorus workspace and existing CA DB2 tools. [...]52_5331706177419840.WA.mark.depledgeca.com@www.idug.org
2320 277 122_The DB2Night Show Episode #20 - The DB2 LUW REDISTRIBUTE Command with guest Ergin Babani, IBM - Friday 4 June 10 am US CDT13_David Chapman24_David.Chapman@IAG.COM.AU30_Wed, 2 Jun 2010 18:27:33 +1000701_us-ascii _______________________________________________________________________________________
Note: This e-mail is subject to the disclaimer contained at the bottom of this message.
_______________________________________________________________________________________
Hi DB2 List,
The DB2Night Show Episode #20 - The DB2 LUW REDISTRIBUTE Command with guest Ergin Babani, IBM
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.. [...]43_DB2-L%201006020427457661.1003@IDUGDB2-L.ORG
2598 44 38_3 Ways You Can Be Appreciated as a DBA11_Dave Beulke19_dave@DAVEBEULKE.COM30_Wed, 2 Jun 2010 12:11:55 -04000_51_0492694257594889.WA.davedavebeulke.com@www.idug.org
2643 134 30_Soundex used in a create index10_Mark Stone17_mastone@GMAIL.COM30_Wed, 2 Jun 2010 09:20:05 -0700310_ISO-8859-1 I'm hoping someone can shine a light on the issue I'm having creating an
index to support the use of a soundex query. I have found examples in
various online documents that seem to indicate that soundex can be used as a
key expression, but the build is failing with a -356, reason 11. [...]60_AANLkTinQ_jOsfXa2pQtbYxV0ypBB39GwtnlnEKMsGye8@mail.gmail.com
2778 263 34_Re: Soundex used in a create index11_Suresh Sane21_data_arch@HOTMAIL.COM30_Wed, 2 Jun 2010 12:14:42 -0500471_iso-8859-1 Mark,
I have to admit that I am puzzled by the error as well. I assume CCSID for soundex is UNicode while your table is EBCDIC?
Try casting - should work - i.e.:
CREATE INDEX "FDBEL"."XRGMSTA"
ON "FDBEL"."REG_MASTER"
( CAST(SOUNDEX(LAST_NAME) AS CHAR) )
Thx
Suresh
Date: Wed, 2 Jun 2010 09:20:05 -0700
From: mastone@GMAIL.COM
Subject: [DB2-L] Soundex used in a create index
To: DB2-L@IDUGDB2-L.ORG [...]43_COL104-W4527A287C054E4BE8A2BF198D00@phx.gbl
3042 259 34_Re: Soundex used in a create index10_Mark Stone17_mastone@GMAIL.COM30_Wed, 2 Jun 2010 10:35:24 -0700592_ISO-8859-1 I did try the cast but the index doesn't get used, which I assume is
something to do with the way the query is matched against available indexes.
On Wed, Jun 2, 2010 at 10:14 AM, Suresh Sane wrote:
> Mark,
>
> I have to admit that I am puzzled by the error as well. I assume CCSID for
> soundex is UNicode while your table is EBCDIC?
>
> Try casting - should work - i.e.:
>
>
> CREATE INDEX "FDBEL"."XRGMSTA"
> ON "FDBEL"."REG_MASTER"
> ( CAST(SOUNDEX(LAST_NAME) AS CHAR) )
>
> Thx
> Suresh
> [...]60_AANLkTin3bRuCAqdO3A_136_T49ngLOeyUz64VuQK9B2F@mail.gmail.com
3302 127 34_Re: Soundex used in a create index0_24_carol.sutfin@REGIONS.COM30_Wed, 2 Jun 2010 13:10:47 -0500407_ISO-8859-1 Mark,
I am guessing here, but it probably has something to do with the difference
with the field definitions
The Soundex returns a CHAR(4) result and I am almost sure that does not
match your Last_name definition.
You may want to consider adding the Soundex key to your data.
There is a CICS macro that generates it based on the field you pass it
called DFHPHN. [...]71_OF2F50D07F.4B0A7626-ON86257736.0063799B-86257736.0063DD43@corp.rgbk.com
3430 879 34_Re: Soundex used in a create index13_David Simpson22_dsimpson@THEMISINC.COM30_Wed, 2 Jun 2010 14:44:39 -0400383_us-ascii Did you also cast the result of soundex in your WHERE clause? The
expression in the WHERE probably needs to match the index expression for
the index to be used.
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mark Stone
Sent: Wednesday, June 02, 2010 12:35 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Soundex used in a create index [...]67_7EC87535E7581C4C890F5BF1CF9A93740297BA49@THEMISSRV1.themisinc.local
4310 1202 34_Re: Soundex used in a create index16_Daniel Luksetich18_danl@DB2EXPERT.COM30_Wed, 2 Jun 2010 14:28:34 -0500666_us-ascii Hello,
This worked perfectly for me.
CREATE TYPE 2 INDEX DSN8910.XEMP3
ON DSN8910.EMP
(cast(soundex(lastname) as char(4) ccsid ebcdic) ASC )
USING STOGROUP DSN8G910
PRIQTY 12
ERASE NO
FREEPAGE 0
PCTFREE 10
BUFFERPOOL BP0
CLOSE NO
PIECESIZE 2097152 K;
select * from dsn8910.emp a where
cast(soundex(lastname) as char(4) ccsid ebcdic) = 'L232'
;
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of David Simpson
Sent: Wednesday, June 02, 2010 1:45 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: [SPAM] Re: Soundex used in a create index [...]35_053201cb0289$cbf70610$63e51230$@com
5513 1517 34_Re: Soundex used in a create index10_Mark Stone17_mastone@GMAIL.COM30_Wed, 2 Jun 2010 13:10:18 -0700464_us-ascii Daniel, can you give me an example of the where clause your using that uses
this index. I'm assuming it something like:
Where cast(soundex(last_name) as char(4)) = cast(soundex(?) as char(4))
Thanks
Mark.
_____
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Daniel Luksetich
Sent: Wednesday, June 02, 2010 12:29 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Soundex used in a create index [...]39_855776FF3B48455990F2F7D8119B1991@laptop
7031 779 45_Re: [SPAM] Re: Soundex used in a create index13_Dan Luksetich18_danl@DB2EXPERT.COM30_Wed, 2 Jun 2010 20:32:43 +0000421_Windows-1252 Keep reading. Its in the email I sent
Dan
Sent via BlackBerry from T-Mobile
-----Original Message-----
From: Mark Stone
Date: Wed, 2 Jun 2010 13:10:18
To:
Subject: [SPAM] Re: Soundex used in a create index
Daniel, can you give me an example of the where clause your using that uses
this index. I'm assuming it something like: [...]104_372731104-1275510799-cardhu_decombobulator_blackberry.rim.net-1313983910-@bda205.bisx.prod.on.blackberry
7811 1342 45_Re: [SPAM] Re: Soundex used in a create index10_Mark Stone17_mastone@GMAIL.COM30_Wed, 2 Jun 2010 13:42:26 -0700353_windows-1252 Thanks Dan, I missed the SQL. You do need to send both left and right sides
of the evaluation through the soundex for it to work, but with the cast in
the where block I'm now using the index.
If someone from IBM is reading this thread can they address the "why" of
such a cryptic approach for this particular function. [...]60_AANLkTilKjoa2hdN-rgif9b76bCXmXDyL1gofdYI0opu2@mail.gmail.com
9154 387 45_Re: [SPAM] Re: Soundex used in a create index13_David Simpson22_dsimpson@THEMISINC.COM30_Wed, 2 Jun 2010 16:08:29 -0500554_iso-8859-1 Yeah, what Dan said :)
-----Original Message-----
From: Dan Luksetich
Sent: Wednesday, June 02, 2010 4:07 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] [SPAM] Re: Soundex used in a create index
Keep reading. Its in the email I sent
Dan
Sent via BlackBerry from T-Mobile
-----Original Message-----
From: Mark Stone
Date: Wed, 2 Jun 2010 13:10:18
To:
Subject: [SPAM] Re: Soundex used in a create index [...]46_012201cb0297$b443d75e$0a0b010a@themisinc.local
9542 705 34_Re: Soundex used in a create index13_Dan Luksetich18_danl@DB2EXPERT.COM30_Wed, 2 Jun 2010 21:18:10 +0000446_Windows-1252 I got an index match without the cast on the right side.
I also had trouble with UPPER in an index, but IBM has a PTF for that one, which I have not been to test yet.
Dan
Sent via BlackBerry from T-Mobile
-----Original Message-----
From: Mark Stone
Date: Wed, 2 Jun 2010 13:42:26
To:
Subject: [SPAM] Re: [SPAM] Re: Soundex used in a create index [...]104_1053093252-1275513526-cardhu_decombobulator_blackberry.rim.net-497289637-@bda205.bisx.prod.on.blackberry
10248 190 42_Re: 3 Ways You Can Be Appreciated as a DBA10_Max Scarpa16_mscarpa@CESVE.IT30_Thu, 3 Jun 2010 11:18:22 +0200562_UTF-8 I think it's quite common situation, at least here in Italy. Some examples
.
In last company I suggested to change WLM goals to z/OS sysprogs (they had
90 as velocity goal and I worked a lot with WLM) but my boss z/OS sysprog
needed 'numbers'. Of course when I told him about redbook, papers and the
existence of 'skip clock' he was struck dumb with astonishment. I gave him
numbers, of course he wasn't able to read it.
To be short I wasn't able to convince him but you know it's easier Camel
Trophy passes the eye of the [...]66_OF3EAE8556.F03D0274-ONC1257737.002EDC23-C1257737.00331E31@cesve.it
10439 143 58_IDUG EU 2010 Vienna - Online Registration is Now Available10_Max Scarpa16_mscarpa@CESVE.IT30_Thu, 3 Jun 2010 13:20:24 +0200617_UTF-8 Esteemed listers,
Online Registration for IDUG 2010 Europe is Now Available ! Don't miss the
canche to obtain Cost Saving Opportunities attending European Conference:
* *Early Bird Discount**
Register by 11 October 2010 and receive a discount of EUR 275 on
your conference registration.
* *Multiple Delegate Discount**
For every three individuals who register from the same organization,
a fourth may attend at the discounted rate of EUR 730. To take advantage
of this discount, all individual
registration forms and payment(s) must be submitted together. [...]66_OFFF398B3B.4FE58D67-ONC1257737.003B81DF-C1257737.003E4A89@cesve.it
10583 146 58_IDUG EU 2010 Vienna - Online Registration is Now Available10_Max Scarpa16_mscarpa@CESVE.IT30_Thu, 3 Jun 2010 15:29:52 +0200460_UTF-8 Esteemed listers
I send it again as there was one mistake in previous post. For this
mistake IDUG EU Conference Planning Committee sentenced me to a hard
punishment, a dinner with Cindy Crawford in Vienna.
My apologies.
__________________
Esteemed listers,
Online Registration for IDUG 2010 Europe is Now Available ! Don't miss
the chance to obtain Cost Saving Opportunities attending European
Conference: [...]66_OFD32CD475.28A05EAA-ONC1257737.0049ED8E-C1257737.004A24E8@cesve.it
10730 193 62_Re: IDUG EU 2010 Vienna - Online Registration is Now Available7_Ed Long19_rdhm99a@PRODIGY.NET30_Thu, 3 Jun 2010 07:16:14 -0700572_utf-8 Do you need a food taster or someone to carry your briefcase?
Edward Long
--- On Thu, 6/3/10, Max Scarpa wrote:
From: Max Scarpa
Subject: [DB2-L] IDUG EU 2010 Vienna - Online Registration is Now Available
To: DB2-L@IDUGDB2-L.ORG
Date: Thursday, June 3, 2010, 9:29 AM
Esteemed listers
I send it  again  as there was one mistake in previous post.  For this mistake IDUG EU Conference Planning Committee sentenced me to a hard punishment, a dinner with Cindy Crawford in Vienna. [...]43_144761.80624.qm@web80203.mail.mud.yahoo.com
10924 145 62_Re: IDUG EU 2010 Vienna - Online Registration is Now Available10_Max Scarpa16_mscarpa@CESVE.IT30_Thu, 3 Jun 2010 16:46:05 +0200581_US-ASCII I'll take into consideration it, but you've to stay in Vienna
first....... With 275 euros discount you can have a nice dinner with us I
think :-).
Apologies again for mistake.
Max Scarpa
DB2 sysprog
Certified bikini structural engineer in spare time
Ed Long
Sent by: IDUG DB2-L
03/06/2010 16.17
Please respond to
IDUG DB2-L
To
DB2-L@IDUGDB2-L.ORG
cc
Subject
Re: [DB2-L] IDUG EU 2010 Vienna - Online Registration is Now Available [...]66_OF808A5CC9.B93F1438-ONC1257737.0050C7C2-C1257737.00511F61@cesve.it
11070 35 32_Re: Archiving/Purging strategies10_Dave Nance16_dav1mo@YAHOO.COM30_Thu, 3 Jun 2010 11:13:55 -0400571_UTF-8 Andre,
There are many different strategies and third party tools as well. Even with using the same tool/method, things are going to have to be built specifically around your DB and application requirements. With third party tools, they can be set up to archive based on some criteria, get all of the data via the RI relationships built in or add your own as well, then purge the data, in fact, they can even archive the table structures as well. That can come in very handy for a dynamic environment where the table structures change over a period of time, [...]48_1570110585706460.WA.dav1moyahoo.com@www.idug.org
11106 44 29_Increment Alphanumeric Values11_Akash Pilot13_akash@USA.COM30_Thu, 3 Jun 2010 12:30:47 -0400339_UTF-8 Dear Listers,
I want to increment (by 1) values in a column defined as CHAR(4) that contains alphanumeric characters. For example the column could contain values like '2283' or '01AD'. I am currently using a REXX script that handles the increment process as shown below (convert to DECIMAL, increment, Convert back to CHAR): [...]45_2785481717947114.WA.akashusa.com@www.idug.org
11151 58 18_jdbc type 4 driver0_21_BudGreenman@ONGOV.NET30_Thu, 3 Jun 2010 13:33:39 -0400347_US-ASCII Help
One of my developers needs a jdbc type4 driver for java 1.3. We have a DB2
connect license but are using a driver that is not compatible with that
level of java. She is trying to work with some old software that we are no
longer using she needs to get an application that was developed in it
moved to production. [...]67_OFCA452FAC.7B285C9E-ON85257737.005FED18-85257737.00607DDD@ongov.net
11210 91 22_Re: jdbc type 4 driver10_Mark Stone17_mastone@GMAIL.COM30_Thu, 3 Jun 2010 10:40:56 -0700606_ISO-8859-1 Have you tried datadirect.com
On Thu, Jun 3, 2010 at 10:33 AM, wrote:
> Help
> One of my developers needs a jdbc type4 driver for java 1.3. We have a DB2
> connect license but are using a driver that is not compatible with that
> level of java. She is trying to work with some old software that we are no
> longer using she needs to get an application that was developed in it moved
> to production.
>
>
> Bud Greenman
> Applications Programming Manager
> ------------------------------
>
> [image: IDUG Mentors - A [...]60_AANLkTik1hMXqbR0bGkhQCedEy-Ertjt_Xt9RAC5ufYsW@mail.gmail.com
11302 610 38_MDEL, SKPT, SKCT Suspensions - V8 z\OS12_Reavill, Jay27_Jay.C.Reavill@FISGLOBAL.COM30_Thu, 3 Jun 2010 13:31:38 -0500454_ISO-8859-1 Hello everyone,
We're seeing various suspensions on objects that we don't really have an
answer for. Most of the time they are minor (.0003 sec or so), but
sporadically when the system gets slammed with CICS transactions we see
them become more prevalent (i.e. 9 sec lock wait on a program that only
issues one SQL statement 'with ur' so we're assuming MDEL lock wait.
This was seen in Omegamon near term history.). [...]62_C90B7164E1511D499B3C479D8B7CEC9201FDA8E0@CMBFISLTC07.FNFIS.COM
11913 267 33_z/OS DB2 V9 Blobs and Compression15_Campbell, Wayne28_Wayne.Campbell@COURTS.WA.GOV30_Thu, 3 Jun 2010 12:02:50 -0700567_us-ascii We're starting to use Blobs data types in DB2. Current were storing them in ZFS (that's what the contractors knew). There is currently a project to improve the performance of this application, which includes moving these blobs from ZFS to DB2. We currently have about 100GB of data in ZFS and expect to add 75 to 100 GB of data this year. In the future when more users start using the system, we expect this to probably double. The data contains PDF, JPEGs, and Word documents and could contain any other form of data. The data are legal documents that [...]66_2A1B28C5CC983C4F8253CF1FA121853214C56BC7B1@EXCHMAIL1.courts.wa.gov
12181 38 55_Abend 0D3 when issuing SQL from a STC with REUSASID=YES15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM30_Thu, 3 Jun 2010 22:07:39 +030064_us-ascii Is there some PTF which tells DB2 to use SSAIR and PTI?42_g9vf06d8u2lu74du9snnok3pc8ddcngf1i@4ax.com
12220 27 33_Re: Increment Alphanumeric Values10_Dave Nance16_dav1mo@YAHOO.COM30_Thu, 3 Jun 2010 15:22:16 -0400270_UTF-8 How should the alpha char's be incremented? Is this supposed to be a hex value? Or you go a/z and do caps count? Also, I would suggest posting this on the DB2 board on DB Forums, they have a couple of guys over there that live for this kind of stuff.
Dave [...]48_5353375195161248.WA.dav1moyahoo.com@www.idug.org
12248 510 37_Re: z/OS DB2 V9 Blobs and Compression14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Thu, 3 Jun 2010 15:34:35 -0400339_us-ascii Wayne,
Do you have a duty of confidentiality about the legal docs? If so, you need to look at encryption-in-place for the docs as well. Roll-your-own is possible but there are at least two commercial solutions available on z/OS if you need something that's already debugged (IBM and Protegrity are the ones I know about). [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC469D1@MAIL02.fisalan.nycnet
12759 649 37_Re: z/OS DB2 V9 Blobs and Compression15_Campbell, Wayne28_Wayne.Campbell@COURTS.WA.GOV30_Thu, 3 Jun 2010 17:22:08 -0700609_us-ascii Phil,
Thanks for your reply. Currently we are not looking at encryption of stored data; we are starting to implement a requirement of data going out over the network is encrypted.
We currently perform nightly Image copies of all production tables for recovery and DR purposes. This table will also be copied. The decision for logging was made by the Business side. Some of these documents could be hard and time consuming to retrieve from the original source. Not having the document could result in cases be thrown out of court. If logging performance becomes an issue it will be [...]66_2A1B28C5CC983C4F8253CF1FA121853214C56BC7B2@EXCHMAIL1.courts.wa.gov
13409 174 37_Re: z/OS DB2 V9 Blobs and Compression12_Myron Miller22_myronwmiller@YAHOO.COM30_Thu, 3 Jun 2010 17:36:39 -0700522_utf-8 I'm not sure that logging will buy you that much. I'm assuming you'll be taking very frequent image copies. Will the Blobs be inserted at any time during the day or just specific times? Define your main table item for the BLOBs such that if you have a main table entry but don't have the BLOB for it, define the BLOB as NULL. Absolutely and I mean absolutely don't store "" or some such nonsense if the BLOB is empty. Store NULLS. It causes no end of problems if you store "" or " " or something like that. I'd [...]44_747387.68406.qm@web112114.mail.gq1.yahoo.com
13584 357 37_Re: z/OS DB2 V9 Blobs and Compression12_Myron Miller22_myronwmiller@YAHOO.COM30_Thu, 3 Jun 2010 18:43:13 -0700611_utf-8 Wayne, One very very major caveat. Make sure you are reasonably current with your V9 mainenance, especially with BLOBs. There is at least one PTF (issued about September/October of last year) that is absolutely critical for insert performance. If you don't have it, the insert of a BLOB will start at the first of the tablespace and check every single freespace element in the entire tablespace regardless of whether there is any space available or not. That causes the insert performance to degrade severely as the tablespace grows and grows. With it, DB2 will check the first freespace element and [...]44_841663.88676.qm@web112107.mail.gq1.yahoo.com
13942 62 33_Re: Increment Alphanumeric Values16_Gregory Palgrave28_gpalgrave@STAFF.IINET.NET.AU30_Fri, 4 Jun 2010 11:33:31 +0800383_utf-8 I haven't tested this on z/os, and assuming your CHAR(4) column should only contain valid hexadecimal values up to 'FFFF', but perhaps:
Create a sequence with a max value of 65535 (=x'FFFF')
Use the NEXT VALUE FOR sequence to increment the count
Convert the sequence number to hex using the HEX() function on the insert
e.g. HEX(NEXT VALUE FOR mysequence) [...]73_8522673947DF7D4394C962BFE441CD270509617476@PER-EXCHMBX.win2k.iinet.net.au
14005 36 37_Re: z/OS DB2 V9 Blobs and Compression12_Mark Chorley27_chorlem@NORWICH-UNION.CO.UK30_Fri, 4 Jun 2010 04:59:33 -0400571_UTF-8 Wayne,
have you considered using OAM to store these documents?
OAM splits the data into 32K chunks, depending on size (on 32K pages) or if the doc is less than 4K, it will store it on a 4K table.
It then recalls/reassembels them when needed.
This is used by Image+ and Content Manager, both IBM products.
Experience shows that this is a much easier way of handling documents than using lobs.
A lot easier to manage, including Image Copy strategy.
We store some very large documnets using OAM and it works very well, very little/no issues. [...]58_6412768296149375.WA.chorlemnorwichunion.co.uk@www.idug.org
14042 688 42_Re: MDEL, SKPT, SKCT Suspensions - V8 z\OS11_Mike Turner19_mike.turner@GMX.COM30_Fri, 4 Jun 2010 10:14:18 +0100282_iso-8859-1 Hi Jay
The Select ... With UR will take an S-mode MDEL lock. In V8 the only thing I am aware of that will take an X-mode MDEL lock is a mass delete (SQL Delete with no Where clause). In V9 the SQL statements Truncate and Exchange also take X-mode MDEL locks. [...]44_697F01598C3A48FDAFEBB488B5DBDF6D@ToshibaA300
14731 956 37_Re: z/OS DB2 V9 Blobs and Compression14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Fri, 4 Jun 2010 11:32:38 -0400490_us-ascii Wayne,
4000 documents a day x 60K average size yields an estimate of 240MB/day inserts, which I would consider a medium-large app. When you volume test, make sure to look at the logging issue and compare logged and not-logged performance and system loads; I *think* you'll find a significant difference. Also note Myron's comment about the V9 PTF for insert performance - I didn't know about that one but it would have a _big_ impact on your app if it weren't applied. [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC469D6@MAIL02.fisalan.nycnet
15688 208 15_Friday "survey"17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM30_Fri, 4 Jun 2010 16:32:46 +0100409_iso-8859-1 Hello lists,
I have recently been discussing sub-systems and DB performance with colleagues, and I would like to ask if you could spare a few minutes to read through the following questions and if you want reply (directly to me, offline please).
If you are interested in the results, I will post them on here once I think the "survey" has had as many replies as likely to get... [...]56_3D02E8610514C04F991CF832BA154C6612B6D94F@UKSLMS11.ca.com
15897 525 37_Re: z/OS DB2 V9 Blobs and Compression12_Myron Miller22_myronwmiller@YAHOO.COM30_Fri, 4 Jun 2010 16:38:25 -0700578_utf-8 Phil, Wayne, With V8 and especially in V9, Online Reorg does reclaim space. Shrlevel none does NOT. It works well to actually reclaim space. Use it freely. It's very worth doing. Also, I fully concur with Phil's recommendation to use 32k page sizes. They do make a performance difference with V9 versus 4k. You can measure the difference. My clients have been using Blobs extensively since V6 so I'm very familiar with all the issues, both good and bad. We run about 1-2gig per day on our BLOB inserts, all told between the various systems with blobs from 2k average [...]44_782402.53085.qm@web112118.mail.gq1.yahoo.com
16423 70 22_Re: jdbc type 4 driver12_Per Stricker22_Per.Stricker@ITGAIN.DE30_Mon, 7 Jun 2010 08:08:29 +0200447_US-ASCII Hi Bud,
try JDBC Drivers form older DB2 Versions. E.g. DB2 8 Fixpack 4 comes with
a driver with "major version number" "2D" which is JDK 1.1 compatible and
should work. Another option would be to download an old JDBC-ODBC bridge
driver e.g.
http://download.cnet.com/Easysoft-JDBC-ODBC-Bridge/3000-2065_4-10392636.html
As the DB2 CLI is an implementation of the ODBC Standard this could work
as well. [...]67_OF15B4928D.B3EE2802-ONC125773B.00218C10-C125773B.0021BCB3@itgain.de
16494 577 26_Invoke Table UDF from z/OS14_Galeos Antonis19_AGaleos@EUROBANK.GR30_Mon, 7 Jun 2010 11:14:54 +0300334_iso-8859-7 Dear Listers hi,
I'm trying to invoke a table UDF that resides on a DB2 on a windows platform from a Cobol program in z/OS with V8 DB2. Usually I receive a -104 error during bind process. Any ideas ?
The UDF is created like this :
CREATE FUNCTION "euro"."TEST_SELECT" ( "CAMP_TYPE" CHARACTER(2) ) [...]67_663D9F9F4DAC5746AC14B8406AB221D4034854A0@E1001EXVS2.eurobank.efg.gr
17072 56 30_Re: Invoke Table UDF from z/OS14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Mon, 7 Jun 2010 20:01:12 +1000559_ISO-8859-1 two open and only one close parenthesis.
James Campbell
On 7 Jun 2010 at 11:14, Galeos Antonis wrote:
>
> Dear Listers hi,
>
> I´m trying to invoke a table UDF that resides on a DB2 on a windows platform from a
> Cobol program in z/OS with V8 DB2. Usually I receive a -104 error during bind process.
> Any ideas ?
>
> The UDF is created like this :
>
>
> The SQL in Cobol is :
>
> EXEC SQL DECLARE FUNC1 CURSOR FOR
> SELECT ROW_ID,
> CARD_NUMBER,
> CON_CIF
> FROM [...]47_4C0D5008.8957.F197D5E@jacampbell.acslink.net.au
17129 693 30_Re: Invoke Table UDF from z/OS16_Daniel Luksetich18_danl@DB2EXPERT.COM30_Mon, 7 Jun 2010 05:21:29 -0500546_iso-8859-7 You are missing a right paren in your table expression.
FROM TABLE(euro.test_select ('02') AS TEST
Dan
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Galeos Antonis
Sent: Monday, June 07, 2010 3:15 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: [SPAM] Invoke Table UDF from z/OS
Dear Listers hi,
I'm trying to invoke a table UDF that resides on a DB2 on a windows platform
from a Cobol program in z/OS with V8 DB2. Usually I receive a -104 error
during bind process. Any ideas ? [...]35_039801cb062b$320f8770$962e9650$@com
17823 907 30_Re: Invoke Table UDF from z/OS14_Galeos Antonis19_AGaleos@EUROBANK.GR30_Mon, 7 Jun 2010 13:41:26 +0300455_iso-8859-7 I am so sorry for the inconvenience. In the program the invocation is correct with the right parenthesis, In the mail I wrote it wrong.
________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Daniel Luksetich
Sent: Monday, June 07, 2010 1:21 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Invoke Table UDF from z/OS
You are missing a right paren in your table expression. [...]67_663D9F9F4DAC5746AC14B8406AB221D403485658@E1001EXVS2.eurobank.efg.gr
18731 42 33_Re: Increment Alphanumeric Values11_Akash Pilot13_akash@USA.COM30_Mon, 7 Jun 2010 12:27:17 -0400345_UTF-8 Thanks for all the suggestions. Actually I realized even the REXX option that I cited won't work correctly all the time. For example when I have a value like '2999' the incremented value I get is '3000' instead of '3AAA' that I am looking for. I ended up creating a UDF using "C" and it is working fine. Thanks for all the responses. [...]45_3272949855631004.WA.akashusa.com@www.idug.org
18774 64 33_Re: Increment Alphanumeric Values14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Mon, 7 Jun 2010 12:32:49 -0400632_us-ascii Um, Akash? The Hex increment of 2999 is 299A...
-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Akash Pilot
Sent: Monday, June 07, 2010 12:27 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Increment Alphanumeric Values
Thanks for all the suggestions. Actually I realized even the REXX option that I cited won't work correctly all the time. For example when I have a value like '2999' the incremented value I get is '3000' instead of '3AAA' that I am looking for. I ended up creating a UDF using "C" and it is working fine. Thanks for all the responses. [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC469DA@MAIL02.fisalan.nycnet
18839 816 42_Re: MDEL, SKPT, SKCT Suspensions - V8 z\OS12_Reavill, Jay27_Jay.C.Reavill@FISGLOBAL.COM30_Mon, 7 Jun 2010 12:55:12 -0500985_ISO-8859-1 Haven't seen any responses... Anyone have any ideas?!?!
-------------------------------------------------------------
Jay Reavill
DBA
Fidelity National Information Services, Inc.
11601 Roosevelt Blvd.
St. Petersburg, FL. 33716
Office (727) 227-2144
Mobile (727) 215-5794
jay.c.reavill@fnisglobal.com
-------------------------------------------------------------
________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Reavill, Jay
Sent: Thursday, June 03, 2010 2:32 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] MDEL, SKPT, SKCT Suspensions - V8 z\OS
Hello everyone,
We're seeing various suspensions on objects that we don't really have an
answer for. Most of the time they are minor (.0003 sec or so), but
sporadically when the system gets slammed with CICS transactions we see
[...]62_C90B7164E1511D499B3C479D8B7CEC9201FDAE9F@CMBFISLTC07.FNFIS.COM
19656 28 33_Re: Increment Alphanumeric Values11_Akash Pilot13_akash@USA.COM30_Mon, 7 Jun 2010 14:09:47 -0400356_UTF-8 Phil,
In the example that I gave '2999' is a character value. Not Hex. Based on EBCDIC collating sequence (lower case, upper case, number) the next increment of '2999' is '3aaa'. However for my situation I am ignoring lower case values because my input data is always going to contain upper case. Therefore the next increment is indeed 3AAA. [...]45_3201290629294374.WA.akashusa.com@www.idug.org
19685 50 33_Re: Increment Alphanumeric Values14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Mon, 7 Jun 2010 14:18:05 -0400628_us-ascii Ah, right. Thanks for clarifying.
-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Akash Pilot
Sent: Monday, June 07, 2010 2:10 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Increment Alphanumeric Values
Phil,
In the example that I gave '2999' is a character value. Not Hex. Based on EBCDIC collating sequence (lower case, upper case, number) the next increment of '2999' is '3aaa'. However for my situation I am ignoring lower case values because my input data is always going to contain upper case. Therefore the next increment is indeed 3AAA. [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC469E1@MAIL02.fisalan.nycnet
19736 84 33_Re: Increment Alphanumeric Values14_Peter Backlund21_BacklundDB2@TELIA.COM30_Mon, 7 Jun 2010 20:49:21 +02000_26_4C0D3F31.1030307@telia.com
19821 113 30_Re: Invoke Table UDF from z/OS14_Larry Kintisch17_LKint@VERIZON.NET30_Mon, 7 Jun 2010 15:20:10 -0400662_iso-8859-1 Hi Antonis,
Please copy the entire bind error message with
the "tokens" it returns and let us see it.
Larry Kintisch Pres., ABLE Information Services 845-353-0885
At 04:14 AM 6/7/2010, you wrote:
>Dear Listers hi,
>
>I’m trying to invoke a table UDF that resides on
>a DB2 on a windows platform from a Cobol program
>in z/OS with V8 DB2. Usually I receive a -104
>error during bind process. Any ideas ?
>
>The UDF is created like this :
>
>CREATE FUNCTION "euro"."TEST_SELECT" ( "CAMP_TYPE" CHARACTER(2) )
> RETURNS TABLE (
> "ROW_ID" CHARACTER(15),
> "CAMPAIGN_TYPE" CHARACTER(2),
> [...]40_0L3N00881SE7QD60@vms173009.mailsrvcs.net
19935 31 33_Re: Increment Alphanumeric Values11_Akash Pilot13_akash@USA.COM30_Mon, 7 Jun 2010 15:40:50 -0400325_UTF-8 "Regardless of lower and upper case, the next value after x'2999' must be x'299A' as someone already remarked!"
Agreed. But we are not discussing Hex. If you read my reponse to Phil I said I am comparing the literal value '2999' not hex '2999'. You are talking about x'2999' while I am referring to '2999'. [...]45_0437543149276057.WA.akashusa.com@www.idug.org
19967 31 26_Temporary Tables and TCB=111_Gary Snider29_gsnider@CENTRAL-INSURANCE.COM30_Mon, 7 Jun 2010 16:13:09 -0400382_us-ascii We are running ZOS V9 and DB2 V8. When defining a new external stored procedure (COBOL) that uses temporary tables, we have a standard that they must be defined to an address space running with TCB=1. I have searched and cannot find any reason for this restriction (other than REXX..). Does anyone know why this may have been set up this way? Is this really required? [...]77_51251BC586E98B48BA703636AF45CAC929FE610E7C@vspvwexchg02.central-insurance.com
19999 26 26_Temporary Tables and TCB=111_Gary Snider29_gsnider@CENTRAL-INSURANCE.COM30_Mon, 7 Jun 2010 16:20:08 -0400379_UTF-8 We are running ZOS V9 and DB2 V8. When defining a new external stored procedure (COBOL) that uses temporary tables, we have a standard that they must be defined to an address space running with TCB=1. I have searched and cannot find any reason for this restriction (other than REXX..). Does anyone know why this may have been set up this way? Is this really required? [...]60_3682181261462604.WA.gsnidercentralinsurance.com@www.idug.org
20026 51 30_Re: Temporary Tables and TCB=113_Willie Favero21_wfavero@ATTGLOBAL.NET30_Mon, 7 Jun 2010 18:53:08 -0500380_UTF-8 It is true that you do have to use NUMTCB=1 for REXX...
However, that is NOT a restriction for COBOL... for COBOL, I have seen
values everywhere from 8 to 40.... Of course, I would suggest starting
out on the lower side... If you are DB2 V8 or above, WLM uses the NUMTCB
value as a max for the address space and adjust the number of TCB
accordingly. [...]30_4C0D8664.5080706@attglobal.net
20078 68 30_Re: Temporary Tables and TCB=112_Myron Miller22_myronwmiller@YAHOO.COM30_Mon, 7 Jun 2010 17:04:10 -0700677_us-ascii I have no clue why? we run all SQL external stored procedures that use temp tables in tcb=50 address spaces with no issues whatsoever. Been doing it for years.
________________________________
From: Gary Snider
To: DB2-L@IDUGDB2-L.ORG
Sent: Mon, June 7, 2010 4:13:09 PM
Subject: [DB2-L] Temporary Tables and TCB=1
We are running ZOS V9 and DB2 V8. When defining a new external stored procedure (COBOL) that uses temporary tables, we have a standard that they must be defined to an address space running with TCB=1. I have searched and cannot find any reason for this restriction (other than REXX..). Does [...]44_109590.98478.qm@web112102.mail.gq1.yahoo.com
20147 98 33_Re: Increment Alphanumeric Values10_Dave Nance16_dav1mo@YAHOO.COM30_Mon, 7 Jun 2010 18:30:26 -0700618_iso-8859-1 With those ranges wouldn't it be a lot less storage to just have one entry that covers a begin range of 0999 and ending range of 3800, since you cover the whole spectrum? David Nance ________________________________ From: Akash Pilot To: DB2-L@IDUGDB2-L.ORG Sent: Mon, June 7, 2010 12:27:17 PM Subject: Re: [DB2-L] Increment Alphanumeric Values Thanks for all the suggestions. Actually I realized even the REXX option that I cited won't work correctly all the time. For example when I have a value like '2999' the incremented value I get is '3000' instead of '3AAA' that I am looking [...]43_542264.85533.qm@web57804.mail.re3.yahoo.com