[FLUFF] RE: [DB2-L] DB2 z/OS : DSNDB06 RI

Philip Sevetson

[FLUFF] RE: [DB2-L] DB2 z/OS : DSNDB06 RI
Aurora,

Oh, my. What did he do to you, that you're revealing his dark secrets here?

--Phil Sevetson

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Dell'Anno, Aurora Emanuela
Sent: Friday, January 28, 2011 12:29 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 z/OS : DSNDB06 RI

Steen,

If you want your revenge on Raymond, call him an Aussie AND also call
him Ray...



Thanks.


Aurora




Aurora Emanuela Dell'Anno
CA Technology - MSC
Sr. Engineering Services Architect
Tel: +44 (0)1753 577 733
Mobile: +44 (0)7768 235 339
[login to unmask email]

CA Technology R&D Limited, Ditton Park, Riding Court Road, Datchet,
Slough, Berkshire, England SL3 9LL.

CA Technology R&D Limited is a company registered in England and Wales
under company registration number 07251836 with its registered office at
the address set out above. VAT number 697904179.


http://www.ca.com/



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







-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Bell, Raymond
Sent: 28 January 2011 08:45
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 z/OS : DSNDB06 RI

Aussie? AUSSIE? Aaaargh! ;o)

Seriously though, it might be interesting, but do you really want
user-defined RI on the Catalog? Or you just playing? My cobber
(geddit?) Phil's probably right in that it's a knock-on effect of those
imbedded pointers being removed from the Catalog. Wouldn't be surprised
to see that 'feature' closed in a PTF v. soon.

Dunno about a beer but it'll be time for a G&T later tonight.

Laters,


Raymond

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Rasmussen,
Steen
Sent: 27 January 2011 22:14
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 z/OS : DSNDB06 RI

Don't push it Raymond ;-)
I like excitement in life, so I want to dance with the devil !!

To continue Mr. Grainger's idea, I re-established my FK to SYSPACKAGE,
did a BIND PACKAGE and inserted the 71 rows from SYSIBM.SYSPACKSTMT into
my own version (now having a FK to SYSPACKAGE) - all went well.
Then I did a FREE PACKAGE - and voila - my personal version of
SYSPACKSTMT nicely cleaned up.

Time for a beer since it's Friday in Aussie land ;-)

Steen Rasmussen
CA Technologies
Sr Engineering Services Architect



-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Bell, Raymond
Sent: Thursday, January 27, 2011 2:50 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 z/OS : DSNDB06 RI

Ah, let those (ex) CA boys dance with the devil... ;o)

Hey, how about a new RI relationship where a user table is the parent of
Sysdatabase? On Delete Cascade, for a little extra frisson. Then
delete the row from your user table with a Creator of Sysibm.

Light blue touch paper, stand well back...

C'mon, it's Friday in NZ already.

Cheers,


Raymond

________________________________________
From: IDUG DB2-L [[login to unmask email] On Behalf Of McDonald, Ken
[[login to unmask email]
Sent: 27 January 2011 18:40
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 z/OS : DSNDB06 RI

Boy howdy... Y'all are really messing with Mother Nature...

Ken

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Rasmussen,
Steen
Sent: Thursday, January 27, 2011 12:29 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 z/OS : DSNDB06 RI

Good point Phil - so here we go (and it isn't even Friday).
I created the FK from my SYSPACKSTMT copy pointing to SYSPACKAGE (just
like the DB2 RI).
I tried to INSERT an "invalid" row in my SYSPACKSTMT version and
received SQL-530, so the RI is honored.
Guess this could be a method to avoid unintentional DROPs, FREE PACKAGE
etc. - don't try this at home :-)

Steen Rasmussen
CA Technologies
Sr Engineering Services Architect


-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Phil Grainger
Sent: Wednesday, January 26, 2011 9:23 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 z/OS : DSNDB06 RI

Steen

Have you actually tried to see if DB2 honours your RI constraint?

In the past it has been (accidentally) possible to add things to the
catalog that subsequently get ignored

I'm wondering though if this is a side effect of IBM removing all those
nasty links from the catalog and using DB2 RI instead

Phil Grainger
Cogito Ltd.
[login to unmask email]
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk

Attend IDUG 2011 - the premiere events for DB2 professionals.
IDUG North America, 2-6 May, Anaheim California IDUG EMEA, 14-18
November, Prague Czech Republic



-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Rasmussen,
Steen
Sent: 22 January 2011 21:30
To: [login to unmask email]
Subject: [DB2-L] DB2 z/OS : DSNDB06 RI

After having worked with DB2 for 26 years (and still learning), I was
very surprised yesterday. I'm working on an IDUG presentation and by
accident created a FK on my table to SYSIBM.SYSPACKAGE.
I was surprised I could do that, but since I used DELETE CASCADE, I
thought that could be the reason (had NO idea I could create FK's on the
catalog objects). Then I changed the constraint to have DELETE RESTRICT,
and I still was successful ???!!!

Am I the only one who didn't know you can create FK's from your own
tables to catalog PK's ??

Steen Rasmussen
CA Technologies
Sr Engineering Services Architect


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2
information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* 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 Listserv

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 *
http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is
it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 *
http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is
it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's Listserv
_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 *
http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is
it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 *
http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is
it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2
information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Lynne Flatley

Re: [FLUFF] RE: [DB2-L] DB2 z/OS : DSNDB06 RI
(in response to Philip Sevetson)
And more importantly, what's wrong with Australians?! Some of my best
friends are Australian... (really) :-)

On Fri, Jan 28, 2011 at 12:32 PM, Sevetson, Phil <[login to unmask email]>wrote:

> Aurora,
>
> Oh, my. What did he do to you, that you're revealing his dark secrets
> here?
>
> --Phil Sevetson
>
> -----Original Message-----
> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Dell'Anno,
> Aurora Emanuela
> Sent: Friday, January 28, 2011 12:29 PM
> To: [login to unmask email]
> Subject: Re: [DB2-L] DB2 z/OS : DSNDB06 RI
>
> Steen,
>
> If you want your revenge on Raymond, call him an Aussie AND also call
> him Ray...
>
>
>
> Thanks.
>
>
> Aurora
>
>
>
>
> Aurora Emanuela Dell'Anno
> CA Technology - MSC
> Sr. Engineering Services Architect
> Tel: +44 (0)1753 577 733
> Mobile: +44 (0)7768 235 339
> [login to unmask email]
>
> CA Technology R&D Limited, Ditton Park, Riding Court Road, Datchet,
> Slough, Berkshire, England SL3 9LL.
>
> CA Technology R&D Limited is a company registered in England and Wales
> under company registration number 07251836 with its registered office at
> the address set out above. VAT number 697904179.
>
>
> http://www.ca.com/
>
>
>
> P please don't print this e-mail unless you really need to!
>
>
>
>
>
>
>
> -----Original Message-----
> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Bell, Raymond
> Sent: 28 January 2011 08:45
> To: [login to unmask email]
> Subject: Re: [DB2-L] DB2 z/OS : DSNDB06 RI
>
> Aussie? AUSSIE? Aaaargh! ;o)
>
> Seriously though, it might be interesting, but do you really want
> user-defined RI on the Catalog? Or you just playing? My cobber
> (geddit?) Phil's probably right in that it's a knock-on effect of those
> imbedded pointers being removed from the Catalog. Wouldn't be surprised
> to see that 'feature' closed in a PTF v. soon.
>
> Dunno about a beer but it'll be time for a G&T later tonight.
>
> Laters,
>
>
> Raymond
>
> -----Original Message-----
> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Rasmussen,
> Steen
> Sent: 27 January 2011 22:14
> To: [login to unmask email]
> Subject: Re: [DB2-L] DB2 z/OS : DSNDB06 RI
>
> Don't push it Raymond ;-)
> I like excitement in life, so I want to dance with the devil !!
>
> To continue Mr. Grainger's idea, I re-established my FK to SYSPACKAGE,
> did a BIND PACKAGE and inserted the 71 rows from SYSIBM.SYSPACKSTMT into
> my own version (now having a FK to SYSPACKAGE) - all went well.
> Then I did a FREE PACKAGE - and voila - my personal version of
> SYSPACKSTMT nicely cleaned up.
>
> Time for a beer since it's Friday in Aussie land ;-)
>
> Steen Rasmussen
> CA Technologies
> Sr Engineering Services Architect
>
>
>
> -----Original Message-----
> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Bell, Raymond
> Sent: Thursday, January 27, 2011 2:50 PM
> To: [login to unmask email]
> Subject: Re: [DB2-L] DB2 z/OS : DSNDB06 RI
>
> Ah, let those (ex) CA boys dance with the devil... ;o)
>
> Hey, how about a new RI relationship where a user table is the parent of
> Sysdatabase? On Delete Cascade, for a little extra frisson. Then
> delete the row from your user table with a Creator of Sysibm.
>
> Light blue touch paper, stand well back...
>
> C'mon, it's Friday in NZ already.
>
> Cheers,
>
>
> Raymond
>
> ________________________________________
> From: IDUG DB2-L [[login to unmask email] On Behalf Of McDonald, Ken
> [[login to unmask email]
> Sent: 27 January 2011 18:40
> To: [login to unmask email]
> Subject: Re: [DB2-L] DB2 z/OS : DSNDB06 RI
>
> Boy howdy... Y'all are really messing with Mother Nature...
>
> Ken
>
> -----Original Message-----
> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Rasmussen,
> Steen
> Sent: Thursday, January 27, 2011 12:29 PM
> To: [login to unmask email]
> Subject: Re: [DB2-L] DB2 z/OS : DSNDB06 RI
>
> Good point Phil - so here we go (and it isn't even Friday).
> I created the FK from my SYSPACKSTMT copy pointing to SYSPACKAGE (just
> like the DB2 RI).
> I tried to INSERT an "invalid" row in my SYSPACKSTMT version and
> received SQL-530, so the RI is honored.
> Guess this could be a method to avoid unintentional DROPs, FREE PACKAGE
> etc. - don't try this at home :-)
>
> Steen Rasmussen
> CA Technologies
> Sr Engineering Services Architect
>
>
> -----Original Message-----
> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Phil Grainger
> Sent: Wednesday, January 26, 2011 9:23 AM
> To: [login to unmask email]
> Subject: Re: [DB2-L] DB2 z/OS : DSNDB06 RI
>
> Steen
>
> Have you actually tried to see if DB2 honours your RI constraint?
>
> In the past it has been (accidentally) possible to add things to the
> catalog that subsequently get ignored
>
> I'm wondering though if this is a side effect of IBM removing all those
> nasty links from the catalog and using DB2 RI instead
>
> Phil Grainger
> Cogito Ltd.
> [login to unmask email]
> +44 (0) 1298 872 148
> +44 (0) 7505 266 768
> www.cogito.co.uk
>
> Attend IDUG 2011 - the premiere events for DB2 professionals.
> IDUG North America, 2-6 May, Anaheim California IDUG EMEA, 14-18
> November, Prague Czech Republic
>
>
>
> -----Original Message-----
> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Rasmussen,
> Steen
> Sent: 22 January 2011 21:30
> To: [login to unmask email]
> Subject: [DB2-L] DB2 z/OS : DSNDB06 RI
>
> After having worked with DB2 for 26 years (and still learning), I was
> very surprised yesterday. I'm working on an IDUG presentation and by
> accident created a FK on my table to SYSIBM.SYSPACKAGE.
> I was surprised I could do that, but since I used DELETE CASCADE, I
> thought that could be the reason (had NO idea I could create FK's on the
> catalog objects). Then I changed the constraint to have DELETE RESTRICT,
> and I still was successful ???!!!
>
> Am I the only one who didn't know you can create FK's from your own
> tables to catalog PK's ??
>
> Steen Rasmussen
> CA Technologies
> Sr Engineering Services Architect
>
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 *
> http://IDUG.ORG/NA *
> * Your only source for independent, unbiased, and trusted DB2
> information. *
> ** The best DB2 technical sessions in the world
> ** Independent, not-for-profit, User Run - the IDUG difference!
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
> is the home of IDUG's Listserv
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 *
> http://IDUG.ORG/NA *
> * 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 Listserv
>
> _____________________________________________________________________
> * IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 *
> http://IDUG.ORG/EMEA *
> * If you are going to attend only one conference this year, this is
> it! *
> ** The best DB2 technical sessions in the world
> ** Independent, not-for-profit, User Run - the IDUG difference!
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
> is the home of IDUG's Listserv
>
> _____________________________________________________________________
> * IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 *
> http://IDUG.ORG/EMEA *
> * If you are going to attend only one conference this year, this is
> it! *
> ** The best DB2 technical sessions in the world
> ** Independent, not-for-profit, User Run - the IDUG difference!
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
> is the home of IDUG's Listserv
> _____________________________________________________________________
> * IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 *
> http://IDUG.ORG/EMEA *
> * If you are going to attend only one conference this year, this is
> it! *
> ** The best DB2 technical sessions in the world
> ** Independent, not-for-profit, User Run - the IDUG difference!
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
> is the home of IDUG's Listserv
>
> _____________________________________________________________________
> * IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 *
> http://IDUG.ORG/EMEA *
> * If you are going to attend only one conference this year, this is
> it! *
> ** The best DB2 technical sessions in the world
> ** Independent, not-for-profit, User Run - the IDUG difference!
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
> is the home of IDUG's Listserv
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 *
> http://IDUG.ORG/NA *
> * Your only source for independent, unbiased, and trusted DB2
> information. *
> ** DB2 certification -> no additional charge
> ** Meet fellow DB2 users and leading DB2 consultants
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
> is the home of IDUG's Listserv
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 *
> http://IDUG.ORG/NA *
> * Your only source for independent, unbiased, and trusted DB2
> information. *
> ** DB2 certification -> no additional charge
> ** Meet fellow DB2 users and leading DB2 consultants
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
> the home of IDUG's Listserv
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 *
> http://IDUG.ORG/NA *
> * Your only source for independent, unbiased, and trusted DB2
> information. *
> ** DB2 certification -> no additional charge
> ** Meet fellow DB2 users and leading DB2 consultants
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
> the home of IDUG's Listserv
>

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Aurora Dell'Anno

Re: [FLUFF] RE: [DB2-L] DB2 z/OS : DSNDB06 RI
(in response to Lynne Flatley)
"And more importantly, what's wrong with Australians?!" I don't know
really, you'd have to ask Raymond that ;-)

and he didn't do anything to me, I was probably being just naturally
catty, sorry.


Thanks.


Aurora


Aurora Emanuela Dell'Anno
CA Technology - MSC
Sr. Engineering Services Architect
Tel: +44 (0)1753 577 733
Mobile: +44 (0)7768 235 339
[login to unmask email]
<mailto:[login to unmask email]>
CA Technology R&D Limited, Ditton Park, Riding Court Road, Datchet,
Slough, Berkshire, England SL3 9LL.

CA Technology R&D Limited is a company registered in England and Wales
under company registration number 07251836 with its registered office at
the address set out above. VAT number 697904179.


http://www.ca.com/

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





________________________________

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Lynne Flatley
Sent: 28 January 2011 18:36
To: [login to unmask email]
Subject: Re: [DB2-L] [FLUFF] RE: [DB2-L] DB2 z/OS : DSNDB06 RI


And more importantly, what's wrong with Australians?! Some of my best
friends are Australian... (really) :-)




_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* 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, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv