1 IDUGDB2-L.ORG /home/listserv/home/db2-l August 2010, week 2 2 41 43_IDUG Members Get a Discount to IBM IOD 201019_McBride, Michael C.31_michael.mcbride@DOT.STATE.FL.US30_Sun, 8 Aug 2010 09:22:42 -0400347_UTF-8 Just wanted to remind everyone that IDUG members get a registration discount for the 2010 IBM Information On Demand Global Conference, October 24 - 28 in Las Vegas. As you know, IOD is the premier IBM event featuring leading-edge solutions from across IBM software, hardware and services, including DB2-related sessions and activities. [...]63_4408230067002172.WA.michael.mcbridedot.state.fl.us@www.idug.org 44 56 35_Quick survey: Auditing DB2 for z/OS14_Adrian Collett24_adriancollett@TISCALI.IT30_Sun, 8 Aug 2010 12:29:33 +0200399_ISO-8859-1 Hi,

we have a request to audit our "privileged users"(sysadmins, DBAs etc)
accesses to ALL production DB2 data.

I presume this is a regular activity in all shops and was wondering how
others handled it ?

Probably not the best time of year for it, but I thought I'd do a quick
survey - please reply to me OFF LIST and I'll post a summary of the results: [...]27_4C5E870D.6070901@tiscali.it 101 59 64_Re: How to Get the DB2 Creator ID and Index details in Run Time?15_Coleman, Troy L19_Troy.Coleman@CA.COM30_Sun, 8 Aug 2010 17:26:29 -0400376_utf-8 Great blog topic. I'm going to post this next week.

Depending on the object type you have different rules.
For ALIAS, AUX TABLE, CREATE GLOBAL TEMP TABLE, TABLE, VIEW

When unqualified the qualifier is the CURRENT SCHEMA and owner is CURRENT SQLID
When qualified the qualifier and owner are the same as the value used to qualify the object name. [...]56_F9576E62032243419E097FED5F0E75F3092A4F32@USILMS12.ca.com 161 56 23_Re: DBA job description16_David J Matthews25_djmatthews@WESTPAC.COM.AU30_Mon, 9 Aug 2010 09:26:16 +1000181_US-ASCII "Nobody knows what a DBA does but everybody has to have one, because
nobody can afford two."
(from "The IT Menagerie", IBM Systems Journal, circa 1990)

Thanks,72_OF2397BA80.E963BA71-ONCA257779.00808B29-CA257779.0080C014@westpac.com.au 218 21 64_Re: How to Get the DB2 Creator ID and Index details in Run Time?12_Amlan Prasad16_amlan_pd@MSN.COM30_Mon, 9 Aug 2010 02:15:13 -0400578_UTF-8 Thanks Troy. I will look forward to your further updates.

_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv47_6434686877716128.WA.amlanpdmsn.com@www.idug.org 240 142 62_Re: [OT] Where should I post new knowledge about CA-Scheduler?10_Max Scarpa16_mscarpa@CESVE.IT30_Mon, 9 Aug 2010 08:57:20 +0200434_US-ASCII IBM-MAIN is the right place (one of).

Max Scarpa

'If you want to plow a field with 64 chickens instead of one mule, then
yes the unit cost per chicken is less but herding chickens becomes the new
frontier.'

From a discussion about UNIX and mainframe

Attend IDUG 2010 - Europe, the premiere event for DB2 professionals.
8-12 November 2010, Vienna
Learn more at http://www.idug.org [...]66_OF8B94D56B.77EF1D2A-ONC125777A.0025B1AD-C125777A.00263288@cesve.it 383 30 51_RC=0000000C, REASON=00E30089 during display command21_SUBSCRIBE DB2-L sn.pr25_pourdarab_sanaz@YAHOO.COM30_Mon, 9 Aug 2010 03:29:35 -0400703_UTF-8 Dear Listers,

We have the message RC=0000000C, REASON=00E30089 when we try to display a database or any resource realted to It ,
The DB2 is V8.It was working before but It gives us this error condition now.

Could anyone share a light on this?

Regards
Sanaz P.

_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________ [...]56_1729778078097036.WA.pourdarabsanazyahoo.com@www.idug.org 414 416 26_Re: [OT] Hearding chickens13_Bell, Raymond20_Raymond_Bell@BMC.COM30_Mon, 9 Aug 2010 02:36:46 -0500330_us-ascii Max,

That's brilliant! I must try to remember that one, the next time someone tells me mainframes are so expensive. They are, but you don't need as many. I'm sure there's a joke in there somewhere about headless chickens but I'll save that for Friday.

Cheers. You've got my Monday off to a good start! [...]67_78B3EFE2C0C5D74E9E7777D1D669D54212043DE1@PHXCCRPRD04.adprod.bmc.com 831 71 55_Re: RC=0000000C, REASON=00E30089 during display command11_Enrico Haak21_eh@INSOFT-SOFTWARE.DE30_Mon, 9 Aug 2010 09:47:06 +0200584_UTF-8 Hi Sanaz,

have you tried the IBM support page?

I found three entries regarding this reason code.

*PQ86976: DSNT305I RC00E30089 AND RC00C90101 DSNIDSTT 5007 ON DISPLAY
NPI WITH 4096...*

...DB(SZI50D) SPACENAM(*) USE DSNT305I |DB7 SUBSYSTEM FAILURE DURING
DISPLAY DATABASE COMMAND PROCESSING. RC=0000000C, REASON=*00E30089*
DSN9023I |DB7 DSNTDDIS 'DISPLAY DATABASE' ABNORMAL COMPLETION - Also
rc00c90101 in dsnidstt erqual5007 vrace5007 ....
Last modified date: 5 May 2004 [...]35_4C5FB27A.2030209@insoft-software.de 903 28 55_Re: RC=0000000C, REASON=00E30089 during display command14_Peter Vanroose17_pvanroose@ABIS.BE30_Mon, 9 Aug 2010 03:56:10 -0400651_UTF-8 In the archives of this list, I found the following answer to a very similar question:
http://www.idug.org/cgi-bin/wa?A2=ind0207D&L=db2-l&D=0&O=A&P=30208

-- Peter Vanroose
ABIS Training & Consulting
http://www.abis.be/

_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________ [...]49_9020288454460536.WA.pvanrooseabis.be@www.idug.org 932 216 26_Re: [OT] Hearding chickens10_Max Scarpa16_mscarpa@CESVE.IT30_Mon, 9 Aug 2010 10:50:57 +0200662_UTF-8 Hi Raymond

As I wrote it was a phrase I read in a old post (I think in IBM_MAIN) so
it's not mine, but I reallly liked it as it depicts a real fact :-))

Max Scarpa

From: "Bell, Raymond"
To: DB2-L@IDUGDB2-L.ORG
Date: 09/08/2010 09.37
Subject: Re: [DB2-L] [OT] Hearding chickens
Sent by: IDUG DB2-L

Max,

That’s brilliant! I must try to remember that one, the next time someone
tells me mainframes are so expensive. They are, but you don’t need as
many. I’m sure there’s a joke in there somewhere about headless chickens
but I’ll save that [...]66_OFD9C9486F.F5E6E52C-ONC125777A.002A30EA-C125777A.0030997B@cesve.it 1149 521 34_AW: [DB2-L] [OT] Hearding chickens12_Peter, Georg15_G.Peter@DZBW.DE30_Mon, 9 Aug 2010 10:54:22 +0200309_iso-8859-1 'If you want to plow a field with 64 chickens instead of one mule, then yes the unit cost per chicken is less but herding chickens becomes the new frontier.'

Great, Max.

I've just put these words on a DIN A 2 (42,0 cm x 59,4 cm) paper and then I have printed a wonderful poster. [...]58_99E58D5AC1BE6D4CBF492AF72B942C3D061ADD1C@dzstus010.dzbw.de 1671 100 23_Re: DBA job description10_Max Scarpa16_mscarpa@CESVE.IT30_Mon, 9 Aug 2010 11:05:59 +0200605_US-ASCII She/he is DB2 lighting rod. And I'm not kidding.

Max Scarpa

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

From: David J Matthews
To: DB2-L@IDUGDB2-L.ORG
Date: 09/08/2010 01.37
Subject: Re: [DB2-L] DBA job description
Sent by: IDUG DB2-L

"Nobody knows what a DBA does but everybody has to have one, because
nobody can afford two."
(from "The IT Menagerie", IBM Systems Journal, circa 1990) [...]66_OFA6F327AF.064096C2-ONC125777A.0030D468-C125777A.0031F9F1@cesve.it 1772 313 38_Re: AW: [DB2-L] [OT] Hearding chickens10_Max Scarpa16_mscarpa@CESVE.IT30_Mon, 9 Aug 2010 11:24:06 +0200497_UTF-8 It's nice really ? Anyway it's not my own work but I simply propagate 'the
word' :-))

Have a great monday (even if it's not easy...). Now let's start to read
about great news in DB2 10..... S***** model what ?

Max Scarpa

Certified DBA (Dog's Basket Architect)

From: "Peter, Georg"
To: DB2-L@IDUGDB2-L.ORG
Date: 09/08/2010 11.07
Subject: [DB2-L] AW: [DB2-L] [OT] Hearding chickens
Sent by: IDUG DB2-L [...]66_OF7C9B91ED.5AD5533E-ONC125777A.00331661-C125777A.0033A252@cesve.it 2086 29 55_Re: RC=0000000C, REASON=00E30089 during display command21_SUBSCRIBE DB2-L sn.pr25_pourdarab_sanaz@YAHOO.COM30_Mon, 9 Aug 2010 07:23:28 -0400367_UTF-8 Dear Enrico,

Thanks for the response,I 've read the fixes from IBM, we do'nt have these conditions here.just one of them PK76282 , there is no extra dump in db2 to find other abends.In addition , the problem happens when I try to display database and related resources or
browse the tables.There is no problem with Stop /Start the database also. [...]56_2114016496103435.WA.pourdarabsanazyahoo.com@www.idug.org 2116 69 53_Error with XML column while using Object compare tool21_Devyani Sahasrabuddhe30_devyanisahasrabuddhe@GMAIL.COM30_Mon, 9 Aug 2010 08:04:02 -0400458_UTF-8 Dear List,

I am using DB2 object comparison tool to compare production and QA databases and trying to produce compare report and apply jobs for changes found. Couple of tables having XML columns giving error in compare step as below;

Column DB2_GENERATED_DOCID_FOR_XML
Conversion not supported for Col DB2_GENERATED_DOCID_FOR_XML (BIGINT to BIGINT)
(D)Type changed from BIGINT to BIGINT
(E)This type change is not supported [...]62_6437215218556805.WA.devyanisahasrabuddhegmail.com@www.idug.org 2186 63 57_Re: Error with XML column while using Object compare tool13_Robert VA3BXG19_galambos@ROGERS.COM30_Mon, 9 Aug 2010 12:08:25 +0000578_- 1) It would be nice if you told us which tool set you are using so we would get a better idea 2) And then you might have to d/l both tables to a flat file and compare them that way -----------Original Message----------- From: Devyani Sahasrabuddhe To: IDUG DB2-L ReplyTo: IDUG DB2-L Date: Aug 09 08:04:35 Subject: [DB2-L] Error with XML column while using Object compare tool Dear List, I am using DB2 object comparison tool to compare production and QA databases and trying to produce compare report and apply jobs for changes found. Couple of tables having XML columns [...]104_1373802644-1281355708-cardhu_decombobulator_blackberry.rim.net-189288970-@bda274.bisx.prod.on.blackberry 2250 24 57_Re: Error with XML column while using Object compare tool21_Devyani Sahasrabuddhe30_devyanisahasrabuddhe@GMAIL.COM30_Mon, 9 Aug 2010 08:27:21 -0400604_UTF-8 I am using DB2 Admin tool set Version 7 release 2.

Thank you.

Devyani

_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv62_0720441033541869.WA.devyanisahasrabuddhegmail.com@www.idug.org 2275 197 57_Re: Error with XML column while using Object compare tool9_Chris Tee25_chris.tee@NOVAMAGIC.CO.UK30_Mon, 9 Aug 2010 13:16:08 +0000585_iso-8859-1 Devyani does say he's using DB2 Object Comparison Tool. Looking at APAR PK73206, I think some of V9 NFM functionality isn't supported yet by Object Comparison Tool.

Chris

> Date: Mon, 9 Aug 2010 12:08:25 +0000
> From: galambos@ROGERS.COM
> Subject: Re: [DB2-L] Error with XML column while using Object compare tool
> To: DB2-L@IDUGDB2-L.ORG
>
> 1) It would be nice if you told us which tool set you are using so we would get a better idea
>
> 2) And then you might have to d/l both tables to a flat file and compare them that way
[...]43_COL121-W58F2C1F4D94241F2AE0478A6940@phx.gbl 2473 154 38_Re: AW: [DB2-L] [OT] Hearding chickens23_Parvathavardhini Kannan21_pkannan@INAUTIX.CO.IN30_Mon, 9 Aug 2010 19:10:18 +0530367_UTF-8 Max,

I have actaully become a fan of the quotes / phrases you use in your
signature.
I have started collecting them.

We were planing to create a DB2 magazine kind of thing for our developers
to remind of standards etc.
I was thinking whether I can include some of them in it as a lighter side
(of course with your permission). [...]71_OF0BA10A8B.6CA20BC1-ON6525777A.004A72B5-6525777A.004B1A65@inautix.co.in 2628 42 49_iSeries update statement help (Monday brain lock)6_Jeff G15_jgarmon@UGA.EDU30_Mon, 9 Aug 2010 11:49:20 -0400410_UTF-8 I'm suffering Monday brain lock. I have a table which consists of the following:

parent, child, numfielda

parent, child are unique in the table.

I want to update numfielda to indicate a sequence number for the child (1, 2, 3, etc...) for each parent.

This statement returns the value I want to use to update my field, simply the row number of each child for that parent: [...]47_8133775045447250.WA.jgarmonuga.edu@www.idug.org 2671 20 57_Re: Error with XML column while using Object compare tool21_Devyani Sahasrabuddhe30_devyanisahasrabuddhe@GMAIL.COM30_Mon, 9 Aug 2010 12:03:48 -0400542_UTF-8 Got it! Thank you. :)

_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv62_2531294433564559.WA.devyanisahasrabuddhegmail.com@www.idug.org 2692 35 53_Re: iSeries update statement help (Monday brain lock)14_Peter Vanroose17_pvanroose@ABIS.BE30_Mon, 9 Aug 2010 12:55:19 -0400756_UTF-8 Try this: (did not try it out myself, so there might be syntax errors or logical mistakes ;-)

UPDATE mytable T
SET numfielda =
( SELECT count(*)
FROM mytable
WHERE parent=T.parent
AND child <= T.child)

-- Peter Vanroose
ABIS Training & Consulting,
Leuven, Belgium.
http://www.abis.be/html/enindex.html

_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________ [...]49_6838259616776031.WA.pvanrooseabis.be@www.idug.org 2728 67 53_Re: iSeries update statement help (Monday brain lock)14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Mon, 9 Aug 2010 13:02:42 -0400501_us-ascii Jeff, your simplest approach is to use a cursor and a programming language (so that you can loop). The problem of mating up a "child" to a sequence number, within a "parent", is not easily solved even with a recursive approach.

--Phil S.

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jeff G
Sent: Monday, August 09, 2010 11:49 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] iSeries update statement help (Monday brain lock) [...]64_1BA00CBB414DA34AA25ED82F4647CDE203665DF8E7@MAIL02.fisalan.nycnet 2796 62 53_Re: iSeries update statement help (Monday brain lock)14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Mon, 9 Aug 2010 14:54:00 -0400524_us-ascii But DON'T do it with a large amount of data. Peter, do you normally leave volume-sensitive hand-grenades lying around for your victims to pick up? That's a great whacking lot of sub-selects, one for every child in the database.

;-)

--Phil S.

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Peter Vanroose
Sent: Monday, August 09, 2010 12:55 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] iSeries update statement help (Monday brain lock) [...]64_1BA00CBB414DA34AA25ED82F4647CDE203665DF8EA@MAIL02.fisalan.nycnet 2859 40 53_Re: iSeries update statement help (Monday brain lock)14_Peter Vanroose17_pvanroose@ABIS.BE30_Mon, 9 Aug 2010 15:34:27 -0400595_UTF-8 Phil Sevetson wrote:
> But DON'T do it with a large amount of data.

Agreed!
But with an index on the column pair (parent, child), this *should* be an index lookaside, which is nearly as efficient as a self-join on that pair of columns.

But I agree that a programmed cursor-based solution is better.
Unless... the "order by" in that cursor would conflict with the "for update", in which case you'll probably blindly switch to an out-of-cursor update and you're back at the "one subquery per child in the database", now *without* DB2 doing an index lookaside ... [...]49_0688775870954671.WA.pvanrooseabis.be@www.idug.org 2900 55 53_Re: iSeries update statement help (Monday brain lock)14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Mon, 9 Aug 2010 15:37:37 -0400483_us-ascii Peter,

No, no, I think you're okay with the cursor, because he's got an index on the "Parent" and "Child" columns, so the sort is avoided in the access path. That _should_ allow you a non-materialized return set.

--Phil

-----Original Message-----
From: Peter Vanroose [mailto:pvanroose@ABIS.BE]
Sent: Monday, August 09, 2010 3:34 PM
To: DB2-L@IDUGDB2-L.ORG; Sevetson, Phil
Subject: Re: iSeries update statement help (Monday brain lock) [...]64_1BA00CBB414DA34AA25ED82F4647CDE203665DF8EC@MAIL02.fisalan.nycnet 2956 24 53_Re: iSeries update statement help (Monday brain lock)14_Peter Vanroose17_pvanroose@ABIS.BE30_Mon, 9 Aug 2010 15:48:57 -0400547_UTF-8 This was not possible in earlier versions of DB2 for z/OS, so maybe it's still impossible with DB2 for iSeries...

-- Peter.

_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________ [...]49_7421255696857450.WA.pvanrooseabis.be@www.idug.org 2981 70 63_AUTO: Andre Gagnier is out of the office (returning 16/08/2010)0_24_agagnier@CMHC-SCHL.GC.CA30_Mon, 9 Aug 2010 16:26:04 -0400684_US-ASCII I am out of the office until 16/08/2010.

If your need is immediate please send email to it db2 request or contact
Maeve (2511) or Yvan (2788)

Note: This is an automated response to your message "DB2-L Digest - 8 Aug
2010 to 9 Aug 2010 (#2010-215)" sent on 8/9/2010 1:00:00 AM.

This is the only notification you will receive while this person is away.
_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
[...]73_OF0BB49FA3.3236F79F-ON8525777A.00704041-8525777A.00704041@cmhc-schl.gc.ca 3052 122 104_Re: [OT] Hearding chickens (and request for help or 'Subscribe DB2 social forums and save a life, mine')10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 10 Aug 2010 12:35:22 +0200394_US-ASCII > Max,
>
> I have actaully become a fan of the quotes / phrases you use in your
> signature.
> I have started collecting them.
>
> We were planing to create a DB2 magazine kind of thing for our
developers
> to remind of standards etc.
> I was thinking whether I can include some of them in it as a lighter
side
> (of course with your permission). [...]66_OFDC93ECBA.39605C37-ONC125777B.003807B3-C125777B.003A2B76@cesve.it 3175 41 64_How do I get a GRANT listing in a spreadsheet compatible output?10_Bruce Cain13_cainb@GAO.GOV31_Tue, 10 Aug 2010 09:01:19 -0400263_ISO-8859-1 Hi All,

My supervisor has told me that he has seen someone do that but he doesn't know how they did it. So,
he wants me to find out. Has anyone done this? Is there a manual that will point me in the right
direction?

Cheers,
Bruce24_4C614D9F.4050306@gao.gov 3217 46 68_Re: How do I get a GRANT listing in a spreadsheet compatible output?14_Doyle, Mark M223_mark.m2.doyle@CHASE.COM31_Tue, 10 Aug 2010 09:33:22 -0400634_us-ascii My supervisor has told me that he has seen someone do that but he doesn't know how they did it. So,
he wants me to find out. Has anyone done this? Is there a manual that will point me in the right
direction?

Bruce,
It depends on which platform, and exactly what your trying to do. For instance, on z/OS, you could use SPUFI to 'dump' the 10 auth tables (SYSTABAUTH,SYSCOLAUTH, SYSPLANAUTH, SYSDBAUTH, SYSRESAUTH, SYSUSERAUTH, SYSPACKAUTH, SYSSCHEMAAUTH, SYSROUTINEAUTH, SYSSEQUENCEAUTH) each to its own output file, file transfer to your windows desktop, & import to excel (or equivalent) as a delimited [...]75_0BF6D36E311EAB4BA3F891660E254C363C2D5926EE@EMARC124VS01.exchad.jpmchase.net 3264 88 78_Betr: [DB2-L] How do I get a GRANT listing in a spreadsheet compatible output?15_Marcel Harleman31_mam.harleman@BELASTINGDIENST.NL31_Tue, 10 Aug 2010 15:42:06 +0200425_us-ascii There are a couple of possibilities.

First (and most likely) that person did have a GUI for SQL queries (f.i.
SQL Explorer). SQL Explorer has an option to export the results to a
spreadsheet.

Other option (but unlikely): the person in question wrote a procedure using
the UNLOAD utility to write intermediate results to a csv-dataset, ftp it
and then open it in a spreadsheet program. [...]76_OFF5509385.5DF8F065-ONC125777B.004ABC72-C125777B.004B4453@belastingdienst.nl 3353 89 68_Re: How do I get a GRANT listing in a spreadsheet compatible output?11_Enrico Haak21_eh@INSOFT-SOFTWARE.DE31_Tue, 10 Aug 2010 15:44:07 +0200595_ISO-8859-1 Or you may use UNLOAD utility with DELIMITER option.

Have you got QMF? - save data as ... delimited will do.
QMF for Windows? - build your query and export the result into EXCEL.

Mit freundlichen Grüßen / Best Regards

Enrico Haak

___________________________________________________________________

InSoft Software GmbH, Derendorfer Str. 70, 40479 Düsseldorf / Germany
Tel. +49 211 44 03 166, Fax +49 211 48 80 33
Geschäftsführer: Colin Oakhill, Günther Wichmann
HRB 20486 DÜSSELDORF * UST-IDNR:DE 119253977 * www.insoft-software.de [...]35_4C6157A7.5000306@insoft-software.de 3443 142 68_Re: How do I get a GRANT listing in a spreadsheet compatible output?9_Chris Tee25_chris.tee@NOVAMAGIC.CO.UK31_Tue, 10 Aug 2010 13:46:19 +0000587_iso-8859-1 Bruce

The easiet way would be to run the query against the auth table(s) directly from your spreadsheet program.

Chris

> Date: Tue, 10 Aug 2010 09:01:19 -0400
> From: cainb@GAO.GOV
> Subject: [DB2-L] How do I get a GRANT listing in a spreadsheet compatible output?
> To: DB2-L@IDUGDB2-L.ORG
>
> Hi All,
>
> My supervisor has told me that he has seen someone do that but he doesn't know how they did it. So,
> he wants me to find out. Has anyone done this? Is there a manual that will point me in the right
> direction?
[...]43_COL121-W226B1F4376D9C53A94BF5DA6950@phx.gbl 3586 260 76_Re: Help needed for a SQL statement in DB2 f=?iso-8859-1?Q?=FCr_?=z/OS V8 CM14_Larry Kintisch17_LKint@VERIZON.NET31_Tue, 10 Aug 2010 09:57:30 -0400581_iso-8859-1 Correction. Sorry, but my cut and paste messed
up my re-write of the CASE expression in (A). It
Should read as (A1) below. Larry Kintisch

--(A1)
UPDATE LAIF.MASSNAHME AS M
SET M.ART_MASSNAHME=
(CASE M.ART_MASSNAHME ---I omitted this
WHEN '72' THEN '77'
WHEN '21' THEN '78'
WHEN '02' THEN '79'
END)
WHERE M.ART_MASSNAHME IN('02','21','72')
AND K.ART_KONTEXT='01'
AND EXISTS
(SELECT * FROM LAIF.MASSNAHMEKONTEXT AS K
WHERE M.MANDANT=K.MANDANT
AND M.PERSON_ID=K.PERSON_ID
AND M.MASS_KONTEXT_ID=K.MASS_KONTEXT_ID) [...]40_0L6X002J9W4GZK70@vms173011.mailsrvcs.net 3847 69 68_Re: How do I get a GRANT listing in a spreadsheet compatible output?14_Steurs Patrick21_Patrick.Steurs@NBB.BE31_Tue, 10 Aug 2010 16:39:25 +0200500_us-ascii Hi,

In Ms-excel, you can also use a DATASOURCE. Connect to it and use
Ms-query to execute your sql on db2 for z/Os and send the result-set to
your spreadsheet.

greetings,

Patrick Steurs

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Doyle, Mark
M2
Sent: dinsdag 10 augustus 2010 15:33
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] How do I get a GRANT listing in a spreadsheet
compatible output? [...]60_96DBEA7143ECD048905FAAA27D86E0D212E40790@VSRBEX10.LANPRD.NBB 3917 27 68_Re: How do I get a GRANT listing in a spreadsheet compatible output?19_Jardine, Lawrence J19_JardineLJ@AETNA.COM31_Tue, 10 Aug 2010 11:12:02 -0400418_us-ascii Or, if you have all of the "connect" pieces in place you can Import the data directly into Excel. (Data... Import External Data... New Database Query)

Larry Jardine
Aetna

This e-mail may contain confidential or privileged information. If you think you have received this e-mail in error, please advise the sender by reply e-mail and then delete this e-mail immediately. Thank you. Aetna [...]70_C7DCA78FAF334147B2FD39A220A4C50001A575D3EA@HFDPMSGCMS02.aeth.aetna.com 3945 43 73_New DB2 pureScale on Linux Expands DB2 Family Capabilities on zEnterprise11_Dave Beulke19_dave@DAVEBEULKE.COM31_Tue, 10 Aug 2010 11:19:07 -04000_51_1847151786020748.WA.davedavebeulke.com@www.idug.org 3989 27 8_DSNACCOR12_Matt Brinton27_matt.brinton@WELLSFARGO.COM31_Tue, 10 Aug 2010 14:15:05 -0400418_UTF-8 We are upgrading our DB2's to DB2v9 NFM. I have been told that DSNACCOR will not be reading the new real time stats tables (SYSIBM.*). I've been told that I have to start using DSNACCOX if I want to continue to use real time stats to determine maintenance needs. I have read in the DB2v9 manual and found that DSNACCOR will read the SYSIBM tables so I'm confused. Does anyone have any experience with this? [...]59_7846362172987002.WA.matt.brintonwellsfargo.com@www.idug.org 4017 34 68_Re: How do I get a GRANT listing in a spreadsheet compatible output?10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 10 Aug 2010 16:14:26 -0400433_UTF-8 In the past we used DB2 ODBC driver to extract DB2 for z/os data via Visual Basic in Excel format. If you have a DB2-compatible ODBC driver (IBM or 3rd party) you can execute needed queries to extract data directly into Excel.

UNLOAD with delimiters is another option. Or you can use SPUFI and modify output via REXX (we did it in the past) to create a csv file to be transferred via FTP (for instance) in your PC. [...]48_9405843861045420.WA.mscarpacesve.it@www.idug.org 4052 40 33_LPAR capacity and DB2 percentages12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 10 Aug 2010 18:37:39 -0400409_UTF-8 We are trying to understand the net benefit for DB2 10. I’d like to understand the range of DB2 workloads on a particular LPAR. The percentages I’d like to get are the fraction of work that is DB2 at the peak workload time. How much CPU time is in DB2 compared to the total capacity of the LPAR? If you have a number of different subsystems, it would be useful to see if there are differences. [...]51_1227447867180005.WA.millerrlus.ibm.com@www.idug.org 4093 383 194_The DB2Night Show Episode #25 =?Windows-1252?Q?=96_=93DB2_and_Oracle=3A_An_Autonomic_Computing_Compa?= =?Windows-1252?Q?rison=94=2C_with_Burt_Vialpando=2C_IBM_=96_?=Friday 13 August 10 am US CDT13_David Chapman24_David.Chapman@IAG.COM.AU31_Wed, 11 Aug 2010 16:56:48 +1000591_Windows-1252 _______________________________________________________________________________________

Note: This e-mail is subject to the disclaimer contained at the bottom of this message.
_______________________________________________________________________________________

Hi DB2 List,

The DB2Night Show Episode #25 – “DB2 and Oracle: An Autonomic Computing Comparison”, with Burt Vialpando, 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%201008110257552022.2E81@IDUGDB2-L.ORG 4477 27 23_Re: DBA job description13_Jack Campbell23_jackrcampbell@YAHOO.COM31_Wed, 11 Aug 2010 12:55:40 -0400581_UTF-8 The one I remember, is ...........

"If the DBA is doing his/her job correctly..........then you wonder why you need a DBA"

Regards

Jack

_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________ [...]55_8174264902460235.WA.jackrcampbellyahoo.com@www.idug.org 4505 33 12_Re: DSNACCOR12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 11 Aug 2010 13:54:57 -0400613_UTF-8 Here is a paste from the Information Center.
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db29.doc.perf/db2z_sp_dsnaccor.htm

The DB2® real-time statistics stored procedure (DSNACCOR) is a sample stored procedure that makes recommendations to help you maintain your DB2 databases. The DSNACCOX stored procedure replaces the DSNACCOR stored procedure and provides improved recommendations.

I'd suggest making the switch to DSNACCOX for the improvements.
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db29.doc.ugref/db2z_sp_dsnaccox.htm [...]51_0022749875106829.WA.millerrlus.ibm.com@www.idug.org 4539 23 57_Re: Error with XML column while using Object compare tool12_Joe Reynolds19_jreynold@US.IBM.COM31_Wed, 11 Aug 2010 14:12:54 -0400539_UTF-8 DB2 Object Comparison Tool V7.2 does support XML columns. The more current APAR to consider is PM10429.

Joe

_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________ [...]51_5555164105982829.WA.jreynoldus.ibm.com@www.idug.org 4563 41 68_Re: How do I get a GRANT listing in a spreadsheet compatible output?10_Bruce Cain13_cainb@GAO.GOV31_Wed, 11 Aug 2010 16:41:33 -0400254_ISO-8859-1 Hi All,

I want to thank everyone who has contributed solutions (Mark, Marcel, Enrico,Chris, Steurs, Lawrence
and Max). You guys have been very helpful. What I settled on was the UNLOAD with DELIMITER solution.

Cheers,
Bruce24_4C630AFD.5010904@gao.gov 4605 30 25_DB2 Archive Logs and IDRC13_Steve Runtsch26_steve.runtsch@ASSURANT.COM31_Wed, 11 Aug 2010 17:03:17 -0400318_UTF-8 I haven't seen any recent discussion about using IDRC for DB2 archive logs. We are considering using IDRC for all data that is written to our virtual tape device including DB2 archive logs. I suspect that the performance degredation which occurs when using real tape IDRC does not happen with virtual tape. [...]58_1015662923529510.WA.steve.runtschassurant.com@www.idug.org 4636 227 31_[JOB AD] DB2 Consultants Needed12_Kimberly May28_kim.may@THEFILLMOREGROUP.COM31_Wed, 11 Aug 2010 21:35:57 -0400464_us-ascii The Fillmore Group is looking to add experienced DB2 consultants to our
team. We are currently searching for consultants who have worked with:

DB2 on both z/OS and LUW (and some of those other databases don't hurt.as we
do a lot of heterogeneous database work)

DB2 replication technologies, particularly Q Replication and Data
Mirror/ICDC

Data federation tools, particularly InfoSphere Federation Server and
Attunity [...]41_4c635008.0f79e50a.30ce.2bc7@mx.google.com 4864 56 37_A question about PE statistics report15_Smartcurl Zhang19_smartcurl@GMAIL.COM31_Thu, 12 Aug 2010 11:29:20 +0800352_ISO-8859-1 Hi,all

In EDM POOL ACTIVITY session(DB2 V8) of PE statistics report,there is a
indicator named '% NON STEAL. PAGES IN USE',with which i can easily figure
out how many virtual storage i really need .But in same report for DB2
V9,they cross it out. How could i get that number now?
Thanks a lot.

Smartcurl Zhang [...]60_AANLkTimmuSY66h6MFNdM6mHCqNWf=bmpYegZp6m1sWDC@mail.gmail.com 4921 62 27_Call any HCL Tech Personnel13_Edward Benoit29_db2tech@RECOVERYKNOWLEDGE.COM31_Wed, 11 Aug 2010 23:01:40 -0700500_iso-8859-1 Hello Any HCL Personnel, We are attempting to contact Natarajan Balaji of HCL with no success. He has requested a software product and once we gave him a password he do not reply to any of our contacts. Natarajan submitted an invalid phone number and will not reply to any of our emails. Can anyone help us in contacting HCL management personnel to resolve this problem? Ed. Benoit Recovery Knowledge IBM Business Partner www.recoveryknowledge.com DB2 Automation is Our Only Business [...]46_353693.83220.qm@web1212.biz.mail.gq1.yahoo.com 4984 62 42_DB2 for z/OS - strange V9 space allocation12_Jim McAlpine22_jim.mcalpine@GMAIL.COM31_Thu, 12 Aug 2010 10:05:50 +0100433_ISO-8859-1 I have a lot of test tablespaces where the ddl has priqty 12 and secqty 12
and bufferpool BP32K. After I define the tablespace the vsam object has a 3
track allocation. After I define the associated table the space allocation
is 39 tracks and the vsam object has a primary space allocation of 3 tracks
and seconday of 18 tracks. In V8 these objects have a primary of 3 tracks
and secondary of 1 track. [...]60_AANLkTi=T0Xw34iKSoaPe_2QHe2Ftu85FTCxYGUQAvHQ1@mail.gmail.com 5047 41 46_Re: DB2 for z/OS - strange V9 space allocation14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Thu, 12 Aug 2010 22:34:41 +1000578_US-ASCII MGEXTSZ?

James Campbell

On 12 Aug 2010 at 10:05, Jim McAlpine wrote:

>
> I have a lot of test tablespaces where the ddl has priqty 12 and secqty 12 and bufferpool BP32K.
> After Idefine the tablespace the vsam object has a 3 track allocation.After I define the
> associated table the space allocation is 39 tracks and the vsam object has a primary space
> allocation of 3 tracks and seconday of 18 tracks. In V8 these objects have a primary of 3 tracks
> and secondary of 1 track.
>
> Is this change in behaviour expected [...]49_4C647701.16811.718B17C8@jacampbell.acslink.net.au 5089 87 46_Re: DB2 for z/OS - strange V9 space allocation13_Bright, Randy20_Randy_Bright@BMC.COM31_Thu, 12 Aug 2010 08:12:22 -0500361_us-ascii If the tablespace is segmented, one segment is reserved for each table as it is created. A 32K tablespace with SEGSIZE 64 and one table defined will contain 64 empty 32K pages once the table is defined. Plus the header page and space map will each be a 32K page. But this didn't change between V8 and V9 of DB2 (or for many releases before that). [...]69_476996CBBE9AF14285E09E63C370072A148CD87831@PHXCCRPRD01.adprod.bmc.com 5177 395 35_Re: [JOB AD] DB2 Consultants Needed14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Thu, 12 Aug 2010 10:37:01 -0400621_us-ascii Kim,
Client management just told us (the people on contract here at FISA who work for my employer of record) that they were going to "resolicit" all of our jobs. This is either bureaucratic foolishness, or a real risk of my not being renewed for whatever reason they have in their heads. (Supposedly this has happened before, with the "resolicited" position going to the incumbent, so we'll see.) Anyway, if I wind up on the bench, I'll ask you to consider me for your team. Updated resume at http://hotjobs.yahoo.com/resumes/psevetson/seniordba . Lots of DB2 z/OS, light Oracle, medium SQL Server 2005, [...]64_1BA00CBB414DA34AA25ED82F4647CDE203665DF916@MAIL02.fisalan.nycnet 5573 326 35_Re: [JOB AD] DB2 Consultants Needed14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Thu, 12 Aug 2010 10:38:14 -0400443_us-ascii Whoops! I'll forward my resume to Donna.

________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Kimberly May
Sent: Wednesday, August 11, 2010 9:36 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] [JOB AD] DB2 Consultants Needed

The Fillmore Group is looking to add experienced DB2 consultants to our team. We are currently searching for consultants who have worked with: [...]64_1BA00CBB414DA34AA25ED82F4647CDE203665DF917@MAIL02.fisalan.nycnet 5900 246 35_Re: [JOB AD] DB2 Consultants Needed14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Thu, 12 Aug 2010 10:39:13 -0400651_us-ascii I don't believe I just did that. My apologies, all.

________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sevetson, Phil
Sent: Thursday, August 12, 2010 10:37 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] [JOB AD] DB2 Consultants Needed

________________________________

[http://www.idug.org/images/stories/IDUG_Corporate/idug_corp_728.gif]

________________________________

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_1BA00CBB414DA34AA25ED82F4647CDE203665DF918@MAIL02.fisalan.nycnet 6147 69 46_Re: DB2 for z/OS - strange V9 space allocation12_Jim McAlpine22_jim.mcalpine@GMAIL.COM31_Thu, 12 Aug 2010 16:23:25 +0100775_ISO-8859-1 On Thu, Aug 12, 2010 at 1:34 PM, James Campbell
wrote:

> MGEXTSZ?
>
> James Campbell
>
>
>

Looks like that could be it. It seems that the default for that parameter
has changed from No in V8 to YES in V9.

Thanks for your help.

Jim McAlpine

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, [...]60_AANLkTikSf98sJtRGJQ-cnRQ9rrMJN=nAb1dOh_RYH6Rv@mail.gmail.com 6217 37 42_db2 luw (v9.1) - SMS tablespace size limit13_Jack Campbell23_jackrcampbell@YAHOO.COM31_Thu, 12 Aug 2010 12:14:42 -0400335_UTF-8 I am trying to find the maximum size in GB for a REGULAR SMS tablespace defined under db2 luw v9.1

In the manual I see limits for DMS spaces, and what appears to be the default for other tablespaces - the default indicates that there should be a max size of 256gb per db partition for a 16k SMS (regular) tablespace. [...]55_5630974312435836.WA.jackrcampbellyahoo.com@www.idug.org 6255 133 35_Re: [JOB AD] DB2 Consultants Needed10_Fred Edgar18_fredgarx@YAHOO.COM31_Thu, 12 Aug 2010 09:49:54 -0700833_utf-8 Me either.  I think you're the first one that's ever done that. 
 
Fred

--- On Thu, 8/12/10, Sevetson, Phil wrote:

From: Sevetson, Phil
Subject: Re: [DB2-L] [JOB AD] DB2 Consultants Needed
To: DB2-L@IDUGDB2-L.ORG
Date: Thursday, August 12, 2010, 9:39 AM

I don’t believe I just did that.  My apologies, all.
 

 

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in [...]43_243216.35126.qm@web30208.mail.mud.yahoo.com 6389 74 46_Re: db2 luw (v9.1) - SMS tablespace size limit13_Ian Bjorhovde23_ian.bjorhovde@GMAIL.COM31_Thu, 12 Aug 2010 11:21:41 -0700511_ISO-8859-1 Jack,

With SMS tablespaces the engine doesn't limit the size of a tablespace
per se -- any limits come from the underlying file system or operating
system -- because there is no logical address map for SMS tablespaces.
SMS tablespaces store data as files within a directory, so doesn't
have to use a logical address map to find out what page(s) within a
container to look at for the table's data, index, etc. DB2 simply
opens the file(s) associated with the table's ID. [...]60_AANLkTin8swf=ZL==ujO5FprY+QDi2dLDK=F3XVB5cuf6@mail.gmail.com 6464 140 18_JDBC type 4 driver0_18_renusharma@AOL.COM31_Thu, 12 Aug 2010 14:23:10 -0400286_us-ascii Hello Team

Is there a way we can pass block size parameter using JDBC type 4 driver. My scenario is db2 cube service to Db2 warehouse using JDBC type 4 driver.
Is there a way to some of the parameters which we set in db2cli.ini to pass using JDBC type 4 driver. [...]53_8CD08628D79F118-1AE0-7BE6@webmail-m079.sysops.aol.com 6605 119 46_Re: db2 luw (v9.1) - SMS tablespace size limit12_Martin Hubel17_Martin@MHUBEL.COM31_Thu, 12 Aug 2010 15:33:24 -04000_43_DB2-L%201008121533357530.2FA2@IDUGDB2-L.ORG 6725 33 35_Re: [JOB AD] DB2 Consultants Needed12_Martin Hubel17_Martin@MHUBEL.COM31_Thu, 12 Aug 2010 15:35:17 -04000_43_DB2-L%201008121535280344.2FA4@IDUGDB2-L.ORG 6759 49 46_Re: db2 luw (v9.1) - SMS tablespace size limit12_Phil Gunning19_pkgunning@GMAIL.COM31_Thu, 12 Aug 2010 22:26:04 +0000429_- LARGE tablespaces were introduced in 9.1, and is the default for newly created tablespaces. PG
------Original Message------
From: Jack Campbell
Sender: IDUG DB2-L
To: DB2-L@IDUGDB2-L.ORG
ReplyTo: IDUG DB2-L
Subject: [DB2-L] db2 luw (v9.1) - SMS tablespace size limit
Sent: Aug 12, 2010 12:14 PM

I am trying to find the maximum size in GB for a REGULAR SMS tablespace defined under db2 luw v9.1 [...]103_919666270-1281651966-cardhu_decombobulator_blackberry.rim.net-286537406-@bda628.bisx.prod.on.blackberry 6809 171 46_Re: db2 luw (v9.1) - SMS tablespace size limit16_Gregory Palgrave28_gpalgrave@STAFF.IINET.NET.AU31_Fri, 13 Aug 2010 09:52:51 +0800422_utf-8 Look in the Info Center under "Table space page sizes". This link is for 9.5, but should be the same values.

http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.admin.dbobj.doc/doc/c0052381.html

The maximum size is dependent on the page size of the tablespace. 16K SMS should be 256GB according to the docs. Perhaps your rough calculation was a bit too rough? :) [...]73_8522673947DF7D4394C962BFE441CD27050AB072B4@PER-EXCHMBX.win2k.iinet.net.au 6981 105 24_Re: Removing runstats ??9_Dee Reins21_rcwingman@COMCAST.NET31_Fri, 13 Aug 2010 17:10:46 +0000501_utf-8 Thank you Terry.

Would this be a good item for DB2 enhancements?

Dee
----- Original Message -----
From: "Terry Purcell"
To: DB2-L@IDUGDB2-L.ORG
Sent: Thursday, July 29, 2010 6:28:54 AM
Subject: Re: [DB2-L] Removing runstats ??

Hello Dee,

There is no capability in RUNSTATS to remove COLGROUP (or HISTOGRAM) statistics - although there is a way to remove FREQVAL stats (using COUNT 0) - although your question is for COLGROUP. [...]84_867519312.1195500.1281719446618.JavaMail.root@sz0025a.emeryville.ca.mail.comcast.net 7087 72 31_Re: Call any HCL Tech Personnel14_Avram Friedman25_ibmsysprog@GEEK-SITES.COM31_Fri, 13 Aug 2010 14:03:46 -0400662_UTF-8 US contact?
There are phone numbers on this HCL US visa application
http://www.hcltech.com/pdf/LCAs/07312009-LCA1.pdf

Don't know why they would post this on a public web site.

Need more phone numbers
Go to there web site http://www.hcltech.com
Select the tab for search anything
try TELEPHONE as a keyword

On Wed, 11 Aug 2010 23:01:40 -0700, Edward Benoit wrote:

>Hello Any HCL Personnel,
We are attempting to contact Natarajan Balaji of HCL with no success.
He has requested a software product and once we gave him a password he do not
reply to any of our contacts. [...]56_8566265494494182.WA.ibmsysproggeeksites.com@www.idug.org 7160 216 46_Re: db2 luw (v9.1) - SMS tablespace size limit9_Andy Hunt21_andy_hunt@YAHOO.CO.UK31_Fri, 13 Aug 2010 19:07:48 +0000714_iso-8859-1 I'm not sure I believe the info in the link... http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.admin.dbobj.doc/doc/c0052381.html I'd tend to agree with Ian Bjornhovde's earlier mail. At V9.5 we have run with  a multi-table 200GB+ SMS 4K tablespace. The limit that caught us out is the maximum page limit for a table in that tablespace. After discussions with IBM, they said this was 16777215 - which equates to 64Gb for a 4K tablespace (this is what I think the limit in the link actually means). We reached the 64Gb limit for a table in the tablespace and db2 failed to crash recover in the redo phase... 2010-04-30-23.40.29.8475744                    LEVEL: [...]43_542769.99603.qm@web25007.mail.ukl.yahoo.com 7377 57 55_Re: RC=0000000C, REASON=00E30089 during display command13_Campbell, Jim26_Jim.Campbell@COURTS.WA.GOV31_Fri, 13 Aug 2010 15:43:52 -0700362_utf-8 00E30089

Explanation: This code is used in the REASON parameter of the DSNT305I database command message to inform the requester that the execution unit supporting the database command processor has terminated. Other entries in the SYS1.LOGREC identify the source of the error. This abend reason code is issued by the following CSECT: DSNTDMSG [...]66_2A1B28C5CC983C4F8253CF1FA1218532159A061C64@EXCHMAIL1.courts.wa.gov