1 IDUGDB2-L.ORG /home/listserv/home/db2-l June 2010, week 3 2 33 34_Q:What exactly does FORCEROLLUP do5_Steve21_malutjuta@HOTMAIL.COM31_Tue, 15 Jun 2010 02:40:46 -0400688_UTF-8 Hi,

Could I ask a dumb question (especially as I know of no other type of question)

When running (inline) RUNSTATS on a TS Partition in our DB2V9 for z/OS system
could I ask what exactly the directive FORCEROLLUP does?

regards,
Steve

_____________________________________________________________________
* IDUG Australasia * Sydney, Australia * 1-3 September 2010 * http://IDUG.ORG/AU *

* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________ [...]53_7057824507749351.WA.malutjutahotmail.com@www.idug.org 36 45 33_Q:How to increase IDMS Area size?14_Vivek Tripathi29_Vivek.Tripathi@IN.FUJITSU.COM31_Tue, 15 Jun 2010 12:46:25 +0530713_utf-8 Hello Listers,

IDMS DBA at my shop has retired and I have to increase the IDMS Area by 40%..I do not have any idea as I have only worked on application side..would appreciate the help.

Best Regards,

Vivek Tripathi
FUJITSU CONSULTING INDIA
Office: (+91) 120-4610-700 Ext: 2413
Mobile: +91 9999915441
E-mail: Vivek.Tripathi@in.fujitsu.com
U.S. Toll Free: (+1) 866-573-4404

DISCLAIMER:
This e-mail and any attached files may contain confidential and/or privileged material for the sole use of the intended recipient. Any review, use, distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive [...]71_7D0B4948BCFF3D48A1D1CAFBB94423EE02EE196A@delhi-mail1.india.rapidigm.com 82 197 38_Re: Q:What exactly does FORCEROLLUP do13_Michael Ebert18_mebert@AMADEUS.COM31_Tue, 15 Jun 2010 09:37:17 +0200630_ISO-8859-1 If I read the docu right:

This is for partitioned objects. For these, you have statistics per
partition and aggregate stats for the entire object. If you run a stats
update on one partition, DB2 will use the partition-level stats to update
the aggregate stats as well.

This assumes you have valid stats for all partitions. If that is not the
case, DB2 will update the aggregate stats ONLY if you specify FORCEROLLUP
YES (in the utility or by setting this as default during installation/in
ZPARMS). I guess this means that partitions without valid stats will be
treated either as [...]69_OF3E2ABE60.FED8A27E-ONC1257743.002942DA-C1257743.0029DE02@amadeus.com 280 307 46_AW: [DB2-L] Q:What exactly does FORCEROLLUP do35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM31_Tue, 15 Jun 2010 10:38:57 +0200442_iso-8859-1 Michael

"The easiest way is to run a RUNSTATS on the whole object right after creation, when it's empty. In that case, you don't need to worry about FORCEROLLUP."
The problem with this is, if you have static SQL and the table gets populated via inserts, you might get a bad access path, until you run runstats again and rebind your applications. That's the reason why we avoid running runstats against empty tables. [...]43_DB2-L%201006150439099051.1645@IDUGDB2-L.ORG 588 55 37_Re: Q:How to increase IDMS Area size?13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Tue, 15 Jun 2010 05:57:31 -0400582_utf-8 As this is a DB2 group, I'm not sure you will get any IDMS answers.....

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 - EMEA, 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 Vivek Tripathi
Sent: 15 June 2010 08:16
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] Q:How to increase IDMS Area size? [...]60_4440F5DA00E3F3459BBCB97431B91B6612B84D27DF@MAILR004.mail.lan 644 345 38_Re: Q:What exactly does FORCEROLLUP do13_Michael Ebert18_mebert@AMADEUS.COM31_Tue, 15 Jun 2010 12:22:34 +0200353_ISO-8859-1 That depends on how likely the combination "partitioned (=usually large)
object" + "initial LOAD via insert" + "access via static SQL" is. We
didn't have that at all . Using a bind with default stats doesn't
guarantee a good access path either. Binding static SQL against an empty
object is a separate (tricky) topic anyway. [...]69_OF1C68703F.9D5EF824-ONC1257743.00381F79-C1257743.00390004@amadeus.com 990 46 37_Re: Q:How to increase IDMS Area size?9_Tony Saul30_generalemaillists@YAHOO.COM.AU31_Tue, 15 Jun 2010 03:36:18 -0700668_iso-8859-1 The IDMS list is IDMS-L@LISTSERV.IUASSN.COM , signup with an e-mail to LISTSERV@LISTSERV.IUASSN.COM . I'm not sure if there is a web interface to signup or not.  Regards, Tony ----- Original Message ---- From: Vivek Tripathi To: DB2-L@IDUGDB2-L.ORG Sent: Tue, 15 June, 2010 4:46:25 PM Subject: [DB2-L] Q:How to increase IDMS Area size? Hello Listers, IDMS DBA at my shop has retired and I have to increase the IDMS Area by 40%..I do not have any idea as I have only worked on application side..would appreciate the help. Best Regards, Vivek Tripathi FUJITSU CONSULTING INDIA Office: (+91) 120-4610-700 Ext: 2413 Mobile: [...]43_802241.83148.qm@web34403.mail.mud.yahoo.com 1037 50 70_Urgent - Tablespace recovery - 00D70003 - Dataset unable to be deleted10_Teldb2kals22_teldb2kals@TELSTRA.COM31_Tue, 15 Jun 2010 08:06:23 -0400546_UTF-8 Hi,

We are trying to recover a tablespace that has gone into 4 datasets (A001-A004). But the revover utility is abending with 00D70003.

DSNT500I DSNUGBAC - RESOURCE UNAVAILABLE
REASON 00D70003
TYPE 00000220
NAME hlq.DSNDBC.dbname.tsname.I0001.A004

Displaying the datasets in TSO, I can see that the .A004 dataset is in use (in shrlevel OLD) by DB2, whereas the other 3 (A001-a003) have been defined by DB2 by the recover utility (the creation date for the .A004 dataset is 2 days older than the other 3). [...]54_3385132109810359.WA.teldb2kalstelstra.com@www.idug.org 1088 90 37_Re: Q:How to increase IDMS Area size?10_John Abell36_john.abell@INTNLSOFTWAREPRODUCTS.COM31_Tue, 15 Jun 2010 08:09:24 -0400470_US-ASCII Not many choices here. You could try an Expand Page as a temporary solution
but longer term you have some significant work to do. If we can help, let
me know but it wouldn't be free as there is considerable time required to
get to done and done right.

John T. Abell
President
International Software Products
Tel: 800-295-7608 Ext: 224
International: 1-416-593-5578 Ext: 224
Fax: 800-295-7609
International: 1-416-593-5579 [...]39_BC6DEF3A5ECC4E738154331CF31DE3FA@ISP10V 1179 65 74_Re: Urgent - Tablespace recovery - 00D70003 - Dataset unable to be deleted15_Lizette Koehler23_starsoul@MINDSPRING.COM31_Tue, 15 Jun 2010 08:49:28 -0400679_UTF-8 Have you listed the DB/TS for LOCKS or USE, Displayed Threads? Do they show anything?

And you could try the D GRS,RES=(hlq.DSNDBC.dbname.tsname.*) and see what GRS might think.

Lizette

> -----Original Message-----
> From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Teldb2kals
> Sent: Tuesday, June 15, 2010 8:06 AM
> To: DB2-L@IDUGDB2-L.ORG
> Subject: [DB2-L] Urgent - Tablespace recovery - 00D70003 - Dataset
> unable to be deleted
>
> Hi,
>
> We are trying to recover a tablespace that has gone into 4 datasets
> (A001-A004). But the revover utility is abending with 00D70003.
>
> DSNT500I DSNUGBAC [...]35_014901cb0c89$313f8390$93be8ab0$@com 1245 89 64_Re: Urgent - Tablespace recovery - 00D70003 - (NO longer urgent)10_Teldb2kals22_teldb2kals@TELSTRA.COM31_Tue, 15 Jun 2010 09:35:11 -0400711_UTF-8 Hi, thanks for your reply, but we finally stopped and restarted the subsystem to free the dataset, and successfully recoverd the tablespace.

In answer to your question, LOCKS and USE showed no thds. I didn't try the GRS command.

Regards,
Kals.
On Tue, 15 Jun 2010 08:49:28 -0400, Lizette Koehler wrote:

>Have you listed the DB/TS for LOCKS or USE, Displayed Threads? Do they show anything?
>
>And you could try the D GRS,RES=(hlq.DSNDBC.dbname.tsname.*) and see what GRS might think.
>
>Lizette
>
>
>> -----Original Message-----
>> From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Teldb2kals
>> Sent: Tuesday, [...]54_9533973176211095.WA.teldb2kalstelstra.com@www.idug.org 1335 25 38_Re: Q:What exactly does FORCEROLLUP do11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Tue, 15 Jun 2010 13:49:43 +0000605_- >Could I ask a dumb question >(especially as I know of no other type of question)

There are no dumb questions!
Just dumb answers!
-
Too busy driving to stop for gas!

_____________________________________________________________________
* IDUG Australasia * Sydney, Australia * 1-3 September 2010 * http://IDUG.ORG/AU *

* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________ [...]103_121833364-1276609756-cardhu_decombobulator_blackberry.rim.net-271577204-@bda026.bisx.prod.on.blackberry 1361 104 74_Re: Urgent - Tablespace recovery - 00D70003 - Dataset unable to be deleted0_37_ibasivireddy@DSTWORLDWIDESERVICES.COM31_Tue, 15 Jun 2010 19:48:53 +0530693_US-ASCII You can try STOP DATABASE SPACENAM command to close the open datasets.

Thanks,
Basivi R. Inaganti
DST Worldwide Services
Office +1 877-289-5154 Extn: 25543
+91 40-66125555 Extn: 25543
Cell +91 900-042-7770
ibasivireddy@dstworldwideservices.com

From: Teldb2kals

To: DB2-L@IDUGDB2-L.ORG

Date: 06/15/2010 05:38 PM

Subject: [DB2-L] Urgent - Tablespace recovery - 00D70003 - Dataset unable to be deleted

Sent by: IDUG DB2-L

Hi,

We are trying to recover a tablespace that has gone into 4 datasets
(A001-A004). But the revover utility is abending with 00D70003. [...]72_OF48D5EA16.48E0C354-ON65257743.004E54D7-65257743.004EA465@dstsystems.com 1466 270 34_[AD] a YLA and BMC free Web Event!18_Daniel L Luksetich25_Dan_Luksetich@YLASSOC.COM31_Tue, 15 Jun 2010 09:37:58 -0500621_us-ascii Wednesday, June 23rd, Web Event - Exploiting Indexes and Influencing DB2 on
z/OS Usage

For high performance DB2 applications, it is important not only to
understand how DB2 is optimizing its access to the data but also how well we
are using indexes. Because we spend a lot of time building and maintaining
indexes, it is important to use them wisely. Filtering as much as possible,
as soon as possible, is key to achieving high performance, and the more we
can filter via the indexes the better. In this session, we will discuss
index design issues and query performance topics, [...]35_00c001cb0c98$5a106fa0$0e314ee0$@com 1737 68 38_Re: Q:What exactly does FORCEROLLUP do15_Mike Dransfield38_Michael.Dransfield@BARCLAYSCAPITAL.COM31_Tue, 15 Jun 2010 11:42:58 -0400396_us-ascii Or, "The only dumb question is the one you fail to ask"...

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ted MacNEIL
Sent: Tuesday, June 15, 2010 9:50 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Q:What exactly does FORCEROLLUP do

>Could I ask a dumb question >(especially as I know of no other type of question) [...]76_1F3DCD8A1A1ADF4D99443C7A341695F62BA0B1D2@NYKPCMMGMB07.INTRANET.BARCAPINT.COM 1806 92 38_Re: Q:What exactly does FORCEROLLUP do14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 15 Jun 2010 12:04:26 -0400634_us-ascii It is better to
Ask a dumb question than to
Fix stupid mistakes

-ps

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mike Dransfield
Sent: Tuesday, June 15, 2010 11:43 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Q:What exactly does FORCEROLLUP do

Or, "The only dumb question is the one you fail to ask"...

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ted MacNEIL
Sent: Tuesday, June 15, 2010 9:50 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Q:What exactly does FORCEROLLUP do [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC46A17@MAIL02.fisalan.nycnet 1899 48 32_DB2 10 White Paper Now Available11_Dave Beulke19_dave@DAVEBEULKE.COM31_Tue, 15 Jun 2010 12:58:20 -04000_51_3005979531999401.WA.davedavebeulke.com@www.idug.org 1948 121 38_Re: Q:What exactly does FORCEROLLUP do15_Campbell, Wayne28_Wayne.Campbell@COURTS.WA.GOV31_Tue, 15 Jun 2010 15:24:14 -0700534_us-ascii I like that Quote.

It seems we spend too much time fixing stupid mistakes!
Especially when it could have been avoided bay asking a simple question.

Wayne Campbell
DB2 DBA
Administrative Office of the Courts
(360) 705-5268
Email: wayne.campbell@courts.wa.gov
-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sevetson, Phil
Sent: Tuesday, June 15, 2010 9:04 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Q:What exactly does FORCEROLLUP do [...]66_2A1B28C5CC983C4F8253CF1FA121853214CBC9F984@EXCHMAIL1.courts.wa.gov 2070 144 21_Re: [AD] QMF for z/OS20_Christopher J Pomasl19_pomasl@WILDBLUE.NET31_Tue, 15 Jun 2010 17:00:02 -0600364_ISO-8859-1 No retirement for a while Carol.
I'm still only 45.

CA Report Facility is a great alternative if you need to stay on z.

It is not a drop in replacement for QMF but has many features that QMF
lacks and by the same token lacks features that QMF has. Report
Facility is a true competitor with its own features and rich history. [...]29_4C1805F2.1040208@wildblue.net 2215 315 110_The DB2Night Show Episode #22 - Comparing DB2 LUW and Oracle with Burt Vialpando - Friday 18 June 10 am US CDT13_David Chapman24_David.Chapman@IAG.COM.AU31_Wed, 16 Jun 2010 15:07:23 +1000599_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 #22 - Comparing DB2 LUW and Oracle with Burt Vialpando

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 for 90 minutes. [...]43_DB2-L%201006160107382387.16EA@IDUGDB2-L.ORG 2531 35 38_Re: Q:What exactly does FORCEROLLUP do5_Steve21_malutjuta@HOTMAIL.COM31_Wed, 16 Jun 2010 01:21:39 -0400452_UTF-8 No it was a dumb question, really,

So for example with FORCEROLLUP YES option on a partition being REORGed or LOADed does the Utility subtract the old (previous) partition values from the aggregated value and then add the new partition value,

I'm guessing the columns affected SYSINDEXES.CLUSTERRATIO, NLEAF, NLEVELS
and similarly SYSTABLESPACE.NACTIVE/F, SPACE/F even calculate new AVGROWLEN
Any other columns affected? [...]53_2684872954026197.WA.malutjutahotmail.com@www.idug.org 2567 181 38_Re: Q:What exactly does FORCEROLLUP do13_Michael Ebert18_mebert@AMADEUS.COM31_Wed, 16 Jun 2010 09:37:05 +0200439_ISO-8859-1 My guess would be "no" - I'd think DB2 simply recalculates the aggregate
stats by "summing" or "averaging" all the existing partition-level stats.
You could test that by manually updating the aggregate stats so that a
value no longer is in line with the partition-level ones, and then doing a
RUNSTATS on one partition - is the inconsistency then fixed (=sum all) or
does it remain (=subtract old, add new)? [...]69_OFC39937EF.318E8A32-ONC1257744.00298B77-C1257744.0029D968@amadeus.com 2749 152 42_-311 dynamic SQL w variable i/p parameters27_peggy.donovan@citigroup.com27_peggy.donovan@CITIGROUP.COM31_Wed, 16 Jun 2010 15:28:52 -0400378_UTF-8 I'm coding a COBOL program to handle dynamic sql with variable input parms. Example -
SELECT * FROM TABLE.NAME WHERE COL1 = ? & COL2 < ?

A simple select without parms works - the o/p is fine. I started with the sample DSN8BCU1 & 2. The bug is DSN8BCU2, by the way, is that SQLN must be set to +750. For i/p variable parameters, I cloned the SQLDA as PARMDA [...]59_8286751636876051.WA.peggy.donovancitigroup.com@www.idug.org 2902 196 46_Re: -311 dynamic SQL w variable i/p parameters14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Wed, 16 Jun 2010 16:17:56 -0400538_us-ascii Peggy, did you mean to put content in this message?
-ps

________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of peggy.donovan@citigroup.com
Sent: Wednesday, June 16, 2010 3:29 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] -311 dynamic SQL w variable i/p parameters

________________________________

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC46A1A@MAIL02.fisalan.nycnet 3099 93 42_-311 dynamic SQL w variable i/p parameters27_peggy.donovan@citigroup.com27_peggy.donovan@CITIGROUP.COM31_Wed, 16 Jun 2010 16:26:32 -0400383_UTF-8 I'm coding a COBOL program to handle dynamic sql with variable input parm= s. Example - SELECT * FROM TABLE.NAME WHERE COL1 =3D ? & COL2 < ?

A simple select without parms works - the o/p is fine. I started with the= sample DSN8BCU1 & 2. The bug is DSN8BCU2, by the way, is that SQLN must = be set to +750. For i/p variable parameters, I cloned the SQLDA as PARMDA= [...]59_7689294849742988.WA.peggy.donovancitigroup.com@www.idug.org 3193 21 22_sorry for the misposts13_Peggy Donovan22_peggy.donovan@CITI.COM31_Wed, 16 Jun 2010 16:46:02 -0400584_UTF-8 my account was somehow messed up. Have re subscribed.

_____________________________________________________________________
* IDUG Europe * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EU *

* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** NEW - IBM hands-on labs -> no additional charge
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L54_2151338140011679.WA.peggy.donovanciti.com@www.idug.org 3215 94 42_-311 dynamic SQL w variable i/p parameters13_Peggy Donovan22_peggy.donovan@CITI.COM31_Wed, 16 Jun 2010 16:54:49 -0400377_UTF-8 I'm coding a COBOL program to handle dynamic sql with variable input parm= s. Example - SELECT * FROM TABLE.NAME WHERE COL1 = ? & COL2 < ?

A simple select without parms works - the o/p is fine. I started with the sample DSN8BCU1 & 2. The bug is DSN8BCU2, by the way, is that SQLN must be set to +750. For i/p variable parameters, I cloned the SQLDA as PARMDA [...]54_0671618223425117.WA.peggy.donovanciti.com@www.idug.org 3310 133 46_Re: -311 dynamic SQL w variable i/p parameters9_Mike Bell21_mbell11a1@VERIZON.NET31_Wed, 16 Jun 2010 16:52:59 -0500431_US-ASCII The -311 is simple - the description of the variable in the SQLDA for the
OPEN cursor USING SQLDA has a length specified that is longer than the
column description - usually the length in the SQLDA. This can be either a
varchar column that has an LL that is longer than the SQLDA specified length
or previous to V8 a fixed length column that the SQLDA specified a length
longer than the column length. [...]43_77034E0F708F4AAEB761867616989CCC@mikelaptop 3444 134 46_Re: -311 dynamic SQL w variable i/p parameters9_Mike Bell21_mbell11a1@VERIZON.NET31_Wed, 16 Jun 2010 17:05:19 -0500350_US-ASCII you do know that you have to set the address variables in the SQLDA right?
Example
SET SQL27-DATA (1) TO ADDRESS OF DCLPKLST-PLANNAME
SET SQL27-IND (1) TO ADDRESS OF WS-SQL-NULL-PGM

The first one is the address of the host variable in your program - the
second is the appropriate indiactor variable for a null value. [...]43_7A1859C217A9435A95999A76F4DE4392@mikelaptop 3579 249 56_DB2 for z/OS Optimizing Insert Performance part I and II12_Jose Antonio17_jamorcillo@CAM.ES31_Thu, 17 Jun 2010 09:21:02 +0200617_iso-8859-1 Hi group!

Does anybody know where to find this papers?

DB2 for z/OS Optimizing Insert Performance part I and II?

I have "DB2 for z/OS INSERT Performance" presented in DB2 GUIDE France 2008 but I know John presented that in Tampa.

Thanks a lot!!!!!!!!

José

Este correo electronico es confidencial. Si lo ha recibido por error, por favor
contacte con el remitente y destruya su contenido. Toda la informacion relativa a
la Proteccion de Datos de Caracter Personal, se encuentra a su disposicion en la
pagina web www.cam.es , en el apartado Aviso legal [...]57_78E5EB2B7326D240BBB670236211F9D3D5E4E6@SRVMAIL3.redcam.es 3829 31 157_AUTO: Norbert Jenninger/Germany/IBM is out of the office with limited access to his mailbox, will be back in the office Monday June 21 (returning 06/21/2010)17_Norbert Jenninger14_JEN@DE.IBM.COM31_Thu, 17 Jun 2010 10:01:22 +0200389_US-ASCII I am out of the office until 06/21/2010.

I am out of office with limited access to my mailbox and will be back in
the office Monday June 21,

Note: This is an automated response to your message "DB2-L Digest - 16 Jun
2010 to 17 Jun 2010 (#2010-165)" sent on 17/6/10 7:00:00.

This is the only notification you will receive while this person is away. [...]68_OF8CB1E1CC.3D42F36C-ONC1257745.002C1238-C1257745.002C1239@de.ibm.com 3861 129 16_z/OS White Paper11_Rob Barbour22_rbarbour@ESAIGROUP.COM31_Thu, 17 Jun 2010 14:37:16 -0400709_ISO-8859-1 Interesting read for the list. This was passed to me by one of my
friends in Germany.
It also has an interesting tidbit that I didn't know about on the start
of VMWare on p. 29.

*University of Tuebingen Link: *
http://tobias-lib.uni-tuebingen.de/volltexte/2010/4710/ (click on
the PDF link)

*Paper Description: * Many people still associate mainframes with
obsolete technology. Surprisingly, the opposite is true. Mainframes
feature many hardware, software, and system integration technologies,
that are either not at all, or only in an elementary form, available on
other server platforms. On the other hand, we know of no advanced server
features [...]30_4C1A6B5C.8010501@esaigroup.com 3991 22 41_Re: UDB tool to compare database schemas?7_R Mohan17_plenium@GMAIL.COM31_Thu, 17 Jun 2010 15:30:01 -0400521_- Any cheaper but popular tool out there to compare DB2 LUW schemas that you can recommend?

_____________________________________________________________________
* IDUG Australasia * Sydney, Australia * 1-3 September 2010 * http://IDUG.ORG/AU *

* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________ [...]49_5205657253148494.WA.pleniumgmail.com@www.idug.org 4014 53 13_DBA Task List4_Anil21_alisha_kale@YAHOO.COM31_Fri, 18 Jun 2010 01:08:53 -0400535_UTF-8 Hi All !

I am in the process of compiling a Task List and a Check List for a Application's DBA working on DB2 for z/os (Version 9). I would appreciate if if my fellow DBA's from across the world would take a moment and sharewhat you have. I am quite sure that by seeking inputs from the DBA community herein, I shall be able to create my document much faster.
I want to produce a document for
DB2 DBA Task List (Applications DBA)
- Daily Tasks to be performed by the DBA
- Weekly Tasks to be performed by [...]52_8868922441426641.WA.alishakaleyahoo.com@www.idug.org 4068 32 38_Re: Q:What exactly does FORCEROLLUP do5_Steve21_malutjuta@HOTMAIL.COM31_Fri, 18 Jun 2010 02:27:56 -0400850_UTF-8 Thanks Dr M,

FORCEROLLUP seems to clobber any manual outlandish value => sum ALL

and updates COLVALUE in SYSCOLDIST, SYSCOLDISTATS,SYSCOLSTATS although not all row STATSTIME values are updated, which is a little misleading

regards,
Steve

_____________________________________________________________________
* IDUG Europe * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EU *

* 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!
_____________________________________________________________________ [...]53_3735768664265975.WA.malutjutahotmail.com@www.idug.org 4101 68 53_Tom Glaser is out of the office, returning on Monday.10_Tom Glaser25_tom_glaser@MASTERCARD.COM31_Fri, 18 Jun 2010 04:19:00 -0500596_US-ASCII I will be out of the office starting 06/18/2010 and will not return until
06/21/2010.

Thanks, Tom

CONFIDENTIALITY NOTICE
This e-mail message and any attachments are only for the use of the intended recipient and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient, any disclosure, distribution or other use of this e-mail message or attachments is prohibited. If you have received this e-mail message in error, please delete and notify the sender immediately. Thank you. [...]72_OF0D0FC6F3.5FCC4561-ON86257746.00332DBE-86257746.00332DBE@mastercard.com 4170 80 41_Re: UDB tool to compare database schemas?10_Dave Nance16_dav1mo@YAHOO.COM31_Fri, 18 Jun 2010 06:42:48 -0700734_iso-8859-1 DB2LOOK and your favorite file comparison product is fairly cheap, though relies on the user.   David Nance 804-683-1507 ________________________________ From: R Mohan To: DB2-L@IDUGDB2-L.ORG Sent: Thu, June 17, 2010 3:30:01 PM Subject: Re: [DB2-L] UDB tool to compare database schemas? Any cheaper but popular tool out there to compare DB2 LUW schemas that you can recommend? _____________________________________________________________________ * IDUG Australasia * Sydney, Australia * 1-3 September 2010 *  http://IDUG.ORG/AU * *  Your only source for independent, unbiased, and trusted DB2 information.  * **    DB2 certification -> no additional charge **    Meet fellow DB2 users and leading [...]42_53384.60994.qm@web57803.mail.re3.yahoo.com 4251 29 41_Re: UDB tool to compare database schemas?13_Jim Wankowski23_jim.wankowski@QUEST.COM31_Fri, 18 Jun 2010 10:02:44 -0400762_UTF-8 Check out Toad for DB2's Schema Compare/Sync. Works with both LUW and z/OS.

http://www.quest.com/db2-on-luw/administration.aspx

Jim Wankowski
Quest Software

_____________________________________________________________________
* IDUG Europe * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EU *

* 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!
_____________________________________________________________________ [...]55_3791849819238426.WA.jim.wankowskiquest.com@www.idug.org 4281 48 41_Re: UDB tool to compare database schemas?0_19_galambos@ROGERS.COM31_Fri, 18 Jun 2010 14:24:30 +0000509_- Given that other ISVs have chimed in, I would be remiss not to add my voice

Have you ever looked into File-AID EX (new name for File-AID CS)? The compare has, as one of the its functions, the capability you are looking into. (Others include comparing XML, data, files etc)

www.compuware.com

-----------Original Message-----------
From: Jim Wankowski
To: IDUG DB2-L
ReplyTo: IDUG DB2-L
Date: Jun 18 10:03:08
Subject: Re: [DB2-L] UDB tool to compare database schemas? [...]104_348621266-1276871072-cardhu_decombobulator_blackberry.rim.net-1926008923-@bda274.bisx.prod.on.blackberry 4330 274 148_The DB2Night Show Episode #23 - DB2 LUW Storage Optimization Best Practices with Berni Schiefer and Robin Grosman, IBM - Friday 25 June 10 am US CDT13_David Chapman24_David.Chapman@IAG.COM.AU31_Mon, 21 Jun 2010 17:53:17 +1000596_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 #23 - DB2 LUW Storage Optimization Best Practices with Berni Schiefer and Robin Grosman, 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. [...]43_DB2-L%201006210353291269.1886@IDUGDB2-L.ORG 4605 247 57_Change of date - Next Cogito DB2 Tech Talk is on July 8th13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Mon, 21 Jun 2010 07:19:24 -0400296_us-ascii Although I am trying to fix the DB2 Tech Talks to the first Thursday of each month, I have had to reschedule the July one to July 8th

So join us for "It could happen to YOU - scary disaster stories, lessons learned, NOTHING is impossible" with Phil Grainger and Sally Fabian [...]60_4440F5DA00E3F3459BBCB97431B91B6612B84D2BB8@MAILR004.mail.lan 4853 43 77_Is there a way to define a function that only certain parameters can be null?15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM31_Mon, 21 Jun 2010 16:50:56 +0300319_us-ascii It seems that the function definition only has

"CALLED ON NULL INPUT"

Is there a way to say P1 and P2 are required but P3 is optional, or is the
only choice to say all are optional and have the function check all and issue
an error message for missing required parameters at execution time?42_6cru16lcacc7hi8gkso0epam2gaiieolg6@4ax.com 4897 29 81_Re: Is there a way to define a function that only certain parameters can be null?14_Peter Vanroose17_pvanroose@ABIS.BE31_Mon, 21 Jun 2010 17:40:39 -0400690_UTF-8 I guess the easiest way is to "overload" the function definition, i.e., to have the same function with two specific names, one with two parameters and one with three parameters.

-- Peter Vanroose
ABIS Training & Consulting,
Leuven, Belgium.

_____________________________________________________________________
* IDUG Australasia * Sydney, Australia * 1-3 September 2010 * http://IDUG.ORG/AU *

* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** NEW - IBM hands-on labs -> no additional charge
_____________________________________________________________________ [...]49_6949113747926566.WA.pvanrooseabis.be@www.idug.org 4927 58 81_Re: Is there a way to define a function that only certain parameters can be null?10_Todd Burch17_toddburch@MAC.COM31_Mon, 21 Jun 2010 16:52:42 -0500438_US-ASCII

I'm pretty sure you can write one function, issue two CREATE FUNCTION
statements with the same function name, one with 2 parms and one with
3 parms, and point both functions to the same physical routine and
give them different specific names. At runtime, the function can
determine how it was called (via its specific name in the parm list)
and parse the parms accordingly. [...]44_505963F4-6853-465D-8617-EF54640B4C1F@mac.com 4986 44 59_Checking for use of reserved words in existing applications10_Teldb2kals22_teldb2kals@TELSTRA.COM31_Mon, 21 Jun 2010 18:33:05 -0400486_UTF-8 Hi,

We are currently in the process of migrating to DB2 v9 on z/OS. I have read of lot of articles on reserved words, and most seem to suggest the use of reserved words may not necessarily fail, but still try to avoid using them.

But, what is the best way of actually checking code for use of reserved words ? Is it a case of just scanning all our application programs for use of the reserved words (as given in SQL Reference), or is there a more elegant way ? [...]54_5947152197140239.WA.teldb2kalstelstra.com@www.idug.org 5031 65 63_Re: Checking for use of reserved words in existing applications10_Todd Burch17_toddburch@MAC.COM31_Mon, 21 Jun 2010 19:25:33 -0500392_US-ASCII If I were tasked with this, I would let DB2 do the grunt work, and I
would re-precompile and rebind all apps into a dummy collection id.

If you wanted to kill two birds with one stone (and both are really
big birds), you could also explain everything while you were rebinding
and compare against existing access paths to check for regression and/
or changes. [...]44_2D9893C8-C6F1-4AA3-B97C-54CB866262C2@mac.com 5097 47 48_Can z/os USS web page display & update DB2 data?11_Max Brennan17_maxb390@YAHOO.COM31_Mon, 21 Jun 2010 23:19:55 -0400390_UTF-8 Hello,

Long time listener, first time poster :-)

I figure someone on this list will know the answer to this.
We have z/os 1.10. No Z/Linux - regrettably no possibility of Z/Linux either.
We have applications that are z/os only. They display webpages with
DB2 data (retrieve and manipulate DB2 data) via net.data.
They are very basic apps nothing fancy. [...]49_7603182850842503.WA.maxb390yahoo.com@www.idug.org