[OT][FRIDAY] Check tables not in RW mode

Paul Ogborne

[OT][FRIDAY] Check tables not in RW mode
John,My spelling is atrocious at the best of times, but I would counter as follows on this occasion.( https://en.oxforddictionaries.com/definition/misspell ) and I actually live around ~10 miles from Oxford in England  ;o)Regards,Paul
Home British & World English  misspell
Definition of misspell in English:

-
 -
 -
 -

misspell

VERB
[WITH OBJECT]
- Spell (a word) wrongly.‘‘siege’ had been misspelt as ‘seige’’
-----Original Message-----
From: Bucaria, John <[login to unmask email]>
To: [login to unmask email] <[login to unmask email]>
Sent: Fri, 10 May 2019 18:01
Subject: [DB2-L] - RE: Check tables not in RW mode

&lt;!-- #yiv5634776864 _filtered #yiv5634776864 {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;} _filtered #yiv5634776864 {font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv5634776864 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv5634776864 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #yiv5634776864 {font-family:"Trebuchet MS";panose-1:2 11 6 3 2 2 2 2 2 4;} #yiv5634776864 #yiv5634776864 p.yiv5634776864MsoNormal, #yiv5634776864 li.yiv5634776864MsoNormal, #yiv5634776864 div.yiv5634776864MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri", sans-serif;} #yiv5634776864 a:link, #yiv5634776864 span.yiv5634776864MsoHyperlink {color:blue;text-decoration:underline;} #yiv5634776864 a:visited, #yiv5634776864 span.yiv5634776864MsoHyperlinkFollowed {color:purple;text-decoration:underline;} #yiv5634776864 p.yiv5634776864msonormal0, #yiv5634776864 li.yiv5634776864msonormal0, #yiv5634776864 div.yiv5634776864msonormal0 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;} #yiv5634776864 span.yiv5634776864apple-converted-space {} #yiv5634776864 span.yiv5634776864EmailStyle20 {font-family:"Calibri", sans-serif;color:windowtext;} #yiv5634776864 .yiv5634776864MsoChpDefault {font-size:10.0pt;} _filtered #yiv5634776864 {margin:1.0in 1.0in 1.0in 1.0in;} #yiv5634776864 div.yiv5634776864WordSection1 {} --&gt;You mean “misspelled” ��   From: Paul Ogborne <[login to unmask email]>
Sent: Friday, May 10, 2019 9:31 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: Check tables not in RW mode   Hi Phil,   I assumed that Raymond had misspelt and I was actually referring to a Mr ’Sivertsen’ and not your good self.   Best regards, Paul


On 10 May 2019, at 14:25, Sevetson, Phil <[login to unmask email]> wrote:   Paul O.,   I can’t tell whether that was to me, with my name misspelled (Sivertsen being phonetically similar to Sevetson), or to someone else. I also don’t recall discussing ACBLIBs outside of my team, so it’s even more puzzling… Is there a quick and easy explanation somewhere?   -phil (sevetson)   From: Paul Ogborne [mailto:[login to unmask email] 
Sent: Friday, May 10, 2019 9:17 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: Check tables not in RW mode   Raymond,   I used the REPAIR utility to sort the DBD out.  There are more options these days, but it still works I believe. It has probably become less popular though as the DBD no longer needs to be stored contiguously in the EDM Pool as it once did.   As for Mr Sivertsen, lest he has forgotten, please remind him that ACBLIB is optional for batch jobs. (If you can pass that on in a Canadian accent then he’ll understand!).   P.S. I tend to avoid liquid lunches these days, as at my age, the snoring tends to distract people in the afternoon ;)   Regards, Paul  


On 10 May 2019, at 13:56, Bell, Raymond (Hosting Services, Technology) <[login to unmask email]> wrote:   Paul,   Liquid lunch still on-going?  Yes, you did what?  Or were you talking to young Mr. Sevetson?   Fortunately I don’t have to worry about QMF these days.  ;o)   Cheers,     Raymond   From: Paul Ogborne [mailto:[login to unmask email] 
Sent: 10 May 2019 13:51
To: [login to unmask email]
Subject: [DB2-L] - RE: Check tables not in RW mode  
*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************



Raymond,   Yes I did although some time ago. If memory serves, I ended up REPAIRing the DBD to shrink it down again. For QMF it’s better to update users’ profiles so that they use their own table space for QMF objects; otherwise this problem tends to reoccur.   Regards, Paul



On 10 May 2019, at 13:27, Sevetson, Phil <[login to unmask email]> wrote:   Roy,   How long you been doing DB2, there, neighbor? :-D   I’ve been doing -DIS DB(*) SP(*) RES LIMIT(*) since 1992, V2.2 for MVS/XA. Never had a problem with it. Worked on a couple of fairly small-memory systems.   Has anyone run into this? Is it potentially a problem when a DBD is large (say, for an unmaintained DSQDBDEF.DSQTSDEF)?   -phil   From: Boxwell, Roy [mailto:[login to unmask email] 
Sent: Friday, May 10, 2019 2:04 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: Check tables not in RW mode   Doesn’t that have the “problem” of destroying the EDMPOOL by loading *all* DBD’s into memory? I vaguely remember that a -DIS DB(*) SP(*) was *not* recommended... Or has this disappeared over the years and releases??   Roy Boxwell 

SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development- 

Heinrichstrasse 83-85
40239 Duesseldorf/Germany 
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
Web  http://www.seg.de Link zur Datenschutzerklärung
Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert, Ulf Heinrich   From: Srinivas Adupa [mailto:[login to unmask email] 
Sent: Friday, May 10, 2019 7:04 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: Check tables not in RW mode   Hey Ron, -DIS DB(*) SP(*) RES   RES here means REStrict. All the objects that are NOT in RW status will be shown to you. I suggest you to use LIMIT(*) also as the last parameter so that Db2 will not limit the output to lesser objects while result is being displayed.    -DIS DB(*) SP(*) RES LIMIT(*)   Best regards, Srini.    On Fri, May 10, 2019 at 1:37 AM Ron Thomas <[login to unmask email]> wrote:

Hi all. we have 200 + tables in a schema , i would like to know whether there is any method to query to check the db2 system catalog and see what all tables are not in read write mode. Thanks
Ron T   -----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**  -----End Original Message----- -----End Original Message----- -----End Original Message----- -----End Original Message----- -----End Original Message----------End Original Message-----
Site Links: View post online   View mailing list online   Start new thread via email   Unsubscribe from this mailing list   Manage your subscription  

This email has been sent to: [login to unmask email] has well-regarded tools for Fast Cloning, Buffer Pool Tuning, Log Analysis, TDM & more.
BCV4, BCV5, BPA4DB2, ULT4DB2... modern power tools to get the job done faster & easier than ever.
http://www.ESAIGroup.com/idug

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2

John Bucaria

[OT][FRIDAY] Check tables not in RW mode
(in response to Paul Ogborne)
Funny, that’s the only example they give using “misspelt”. All of their other examples use “misspelled”.

From: Paul Ogborne <[login to unmask email]>
Sent: Friday, May 10, 2019 1:13 PM
To: [login to unmask email]
Subject: [DB2-L] - [OT][FRIDAY] RE: Check tables not in RW mode

John,
My spelling is atrocious at the best of times, but I would counter as follows on this occasion.
( https://en.oxforddictionaries.com/definition/misspell ) and I actually live around ~10 miles from Oxford in England ;o)
Regards,
Paul

Home https://en.oxforddictionaries.com British & World English https://en.oxforddictionaries.com/english misspell https://en.oxforddictionaries.com/definition/misspell
Definition of misspell in English:
·

·

·

·
misspell
VERB
[WITH OBJECT]
· Spell (a word) wrongly.
‘‘siege’ had been misspelt as ‘seige’’
-----Original Message-----
From: Bucaria, John <[login to unmask email]<mailto:[login to unmask email]>>
To: [login to unmask email]<mailto:[login to unmask email]> <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Fri, 10 May 2019 18:01
Subject: [DB2-L] - RE: Check tables not in RW mode
You mean “misspelled” ��

From: Paul Ogborne <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Friday, May 10, 2019 9:31 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Check tables not in RW mode

Hi Phil,

I assumed that Raymond had misspelt and I was actually referring to a Mr ’Sivertsen’ and not your good self.

Best regards,
Paul

On 10 May 2019, at 14:25, Sevetson, Phil <[login to unmask email]<mailto:[login to unmask email]>> wrote:

Paul O.,

I can’t tell whether that was to me, with my name misspelled (Sivertsen being phonetically similar to Sevetson), or to someone else. I also don’t recall discussing ACBLIBs outside of my team, so it’s even more puzzling… Is there a quick and easy explanation somewhere?

-phil (sevetson)

From: Paul Ogborne [mailto:[login to unmask email]
Sent: Friday, May 10, 2019 9:17 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Check tables not in RW mode

Raymond,

I used the REPAIR utility to sort the DBD out. There are more options these days, but it still works I believe.
It has probably become less popular though as the DBD no longer needs to be stored contiguously in the EDM Pool as it once did.

As for Mr Sivertsen, lest he has forgotten, please remind him that ACBLIB is optional for batch jobs.
(If you can pass that on in a Canadian accent then he’ll understand!).

P.S. I tend to avoid liquid lunches these days, as at my age, the snoring tends to distract people in the afternoon ;)

Regards,
Paul



On 10 May 2019, at 13:56, Bell, Raymond (Hosting Services, Technology) <[login to unmask email]<mailto:[login to unmask email]>> wrote:

Paul,

Liquid lunch still on-going? Yes, you did what? Or were you talking to young Mr. Sevetson?

Fortunately I don’t have to worry about QMF these days. ;o)

Cheers,


Raymond

From: Paul Ogborne [mailto:[login to unmask email]
Sent: 10 May 2019 13:51
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Check tables not in RW mode


*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************


Raymond,

Yes I did although some time ago.
If memory serves, I ended up REPAIRing the DBD to shrink it down again.
For QMF it’s better to update users’ profiles so that they use their own table space for QMF objects; otherwise this problem tends to reoccur.

Regards,
Paul



On 10 May 2019, at 13:27, Sevetson, Phil <[login to unmask email]<mailto:[login to unmask email]>> wrote:

Roy,

How long you been doing DB2, there, neighbor? :-D

I’ve been doing -DIS DB(*) SP(*) RES LIMIT(*) since 1992, V2.2 for MVS/XA. Never had a problem with it. Worked on a couple of fairly small-memory systems.

Has anyone run into this? Is it potentially a problem when a DBD is large (say, for an unmaintained DSQDBDEF.DSQTSDEF)?

-phil

From: Boxwell, Roy [mailto:[login to unmask email]
Sent: Friday, May 10, 2019 2:04 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Check tables not in RW mode

Doesn’t that have the “problem” of destroying the EDMPOOL by loading *all* DBD’s into memory? I vaguely remember that a -DIS DB(*) SP(*) was *not* recommended...
Or has this disappeared over the years and releases??

Roy Boxwell

SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-

Heinrichstrasse 83-85
40239 Duesseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]<mailto:[login to unmask email]>
Web http://www.seg.de http://www.seg.de
Link zur Datenschutzerklärung https://www.seg.de/corporate/rechtliche-hinweise/datenschutz

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert, Ulf Heinrich

From: Srinivas Adupa [mailto:[login to unmask email]
Sent: Friday, May 10, 2019 7:04 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Check tables not in RW mode

Hey Ron,
-DIS DB(*) SP(*) RES

RES here means REStrict. All the objects that are NOT in RW status will be shown to you. I suggest you to use LIMIT(*) also as the last parameter so that Db2 will not limit the output to lesser objects while result is being displayed.

-DIS DB(*) SP(*) RES LIMIT(*)

Best regards,
Srini.

On Fri, May 10, 2019 at 1:37 AM Ron Thomas <[login to unmask email]<mailto:[login to unmask email]>> wrote:

Hi all.
we have 200 + tables in a schema , i would like to know whether there is any method to query to check the db2 system catalog and see what all tables are not in read write mode.
Thanks
Ron T

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----
-----End Original Message-----
-----End Original Message-----
-----End Original Message-----
-----End Original Message-----
-----End Original Message-----
________________________________

-----End Original Message-----

Paul Ogborne

[OT][FRIDAY] Check tables not in RW mode
(in response to John Bucaria)
You must forgive them since their ‘mother’ tongue is likely to be Latin!!

> On 10 May 2019, at 18:31, Bucaria, John <[login to unmask email]> wrote:
>
> Funny, that’s the only example they give using “misspelt”. All of their other examples use “misspelled”.
>
> From: Paul Ogborne <[login to unmask email]>
> Sent: Friday, May 10, 2019 1:13 PM
> To: [login to unmask email]
> Subject: [DB2-L] - [OT][FRIDAY] RE: Check tables not in RW mode
>
> John,
> My spelling is atrocious at the best of times, but I would counter as follows on this occasion.
> ( https://en.oxforddictionaries.com/definition/misspell ) and I actually live around ~10 miles from Oxford in England ;o)
> Regards,
> Paul
>
> Home British & World English misspell
> Definition of misspell in English:
> ·
>
> ·
>
> ·
>
> ·
> misspell
> VERB
> [WITH OBJECT]
> · Spell (a word) wrongly.
> ‘‘siege’ had been misspelt as ‘seige’’
> -----Original Message-----
> From: Bucaria, John <[login to unmask email]>
> To: [login to unmask email] <[login to unmask email]>
> Sent: Fri, 10 May 2019 18:01
> Subject: [DB2-L] - RE: Check tables not in RW mode
>
> You mean “misspelled” ��
>
> From: Paul Ogborne <[login to unmask email]>
> Sent: Friday, May 10, 2019 9:31 AM
> To: [login to unmask email]
> Subject: [DB2-L] - RE: Check tables not in RW mode
>
> Hi Phil,
>
> I assumed that Raymond had misspelt and I was actually referring to a Mr ’Sivertsen’ and not your good self.
>
> Best regards,
> Paul
>
>
> On 10 May 2019, at 14:25, Sevetson, Phil <[login to unmask email]> wrote:
>
> Paul O.,
>
> I can’t tell whether that was to me, with my name misspelled (Sivertsen being phonetically similar to Sevetson), or to someone else. I also don’t recall discussing ACBLIBs outside of my team, so it’s even more puzzling… Is there a quick and easy explanation somewhere?
>
> -phil (sevetson)
>
> From: Paul Ogborne [mailto:[login to unmask email]
> Sent: Friday, May 10, 2019 9:17 AM
> To: [login to unmask email]
> Subject: [DB2-L] - RE: Check tables not in RW mode
>
> Raymond,
>
> I used the REPAIR utility to sort the DBD out. There are more options these days, but it still works I believe.
> It has probably become less popular though as the DBD no longer needs to be stored contiguously in the EDM Pool as it once did.
>
> As for Mr Sivertsen, lest he has forgotten, please remind him that ACBLIB is optional for batch jobs.
> (If you can pass that on in a Canadian accent then he’ll understand!).
>
> P.S. I tend to avoid liquid lunches these days, as at my age, the snoring tends to distract people in the afternoon ;)
>
> Regards,
> Paul
>
>
>
>
> On 10 May 2019, at 13:56, Bell, Raymond (Hosting Services, Technology) <[login to unmask email]> wrote:
>
> Paul,
>
> Liquid lunch still on-going? Yes, you did what? Or were you talking to young Mr. Sevetson?
>
> Fortunately I don’t have to worry about QMF these days. ;o)
>
> Cheers,
>
>
> Raymond
>
> From: Paul Ogborne [mailto:[login to unmask email]
> Sent: 10 May 2019 13:51
> To: [login to unmask email]
> Subject: [DB2-L] - RE: Check tables not in RW mode
>
>
> *********************************************
> " This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
> *********************************************
>
>
>
> Raymond,
>
> Yes I did although some time ago.
> If memory serves, I ended up REPAIRing the DBD to shrink it down again.
> For QMF it’s better to update users’ profiles so that they use their own table space for QMF objects; otherwise this problem tends to reoccur.
>
> Regards,
> Paul
>
>
>
>
> On 10 May 2019, at 13:27, Sevetson, Phil <[login to unmask email]> wrote:
>
> Roy,
>
> How long you been doing DB2, there, neighbor? :-D
>
> I’ve been doing -DIS DB(*) SP(*) RES LIMIT(*) since 1992, V2.2 for MVS/XA. Never had a problem with it. Worked on a couple of fairly small-memory systems.
>
> Has anyone run into this? Is it potentially a problem when a DBD is large (say, for an unmaintained DSQDBDEF.DSQTSDEF)?
>
> -phil
>
> From: Boxwell, Roy [mailto:[login to unmask email]
> Sent: Friday, May 10, 2019 2:04 AM
> To: [login to unmask email]
> Subject: [DB2-L] - RE: Check tables not in RW mode
>
> Doesn’t that have the “problem” of destroying the EDMPOOL by loading *all* DBD’s into memory? I vaguely remember that a -DIS DB(*) SP(*) was *not* recommended...
> Or has this disappeared over the years and releases??
>
> Roy Boxwell
>
> SOFTWARE ENGINEERING GmbH and SEGUS Inc.
> -Product Development-
>
> Heinrichstrasse 83-85
> 40239 Duesseldorf/Germany
> Tel. +49 (0)211 96149-675
> Fax +49 (0)211 96149-32
> Email: [login to unmask email]
> Web http://www.seg.de
> Link zur Datenschutzerklärung
>
> Software Engineering GmbH
> Amtsgericht Düsseldorf, HRB 37894
> Geschäftsführung: Gerhard Schubert, Ulf Heinrich
>
> From: Srinivas Adupa [mailto:[login to unmask email]
> Sent: Friday, May 10, 2019 7:04 AM
> To: [login to unmask email]
> Subject: [DB2-L] - RE: Check tables not in RW mode
>
> Hey Ron,
> -DIS DB(*) SP(*) RES
>
> RES here means REStrict. All the objects that are NOT in RW status will be shown to you. I suggest you to use LIMIT(*) also as the last parameter so that Db2 will not limit the output to lesser objects while result is being displayed.
>
> -DIS DB(*) SP(*) RES LIMIT(*)
>
> Best regards,
> Srini.
>
> On Fri, May 10, 2019 at 1:37 AM Ron Thomas <[login to unmask email]> wrote:
>
> Hi all.
> we have 200 + tables in a schema , i would like to know whether there is any method to query to check the db2 system catalog and see what all tables are not in read write mode.
> Thanks
> Ron T
>
> -----End Original Message-----
> **This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
> -----End Original Message-----
> -----End Original Message-----
> -----End Original Message-----
> -----End Original Message-----
> -----End Original Message-----
> -----End Original Message-----
> -----End Original Message-----
>
> Site Links: View post online View mailing list online Start new thread via email Unsubscribe from this mailing list Manage your subscription
>
> This email has been sent to: [login to unmask email]
> ESAi has well-regarded tools for Fast Cloning, Buffer Pool Tuning, Log Analysis, TDM & more.
> BCV4, BCV5, BPA4DB2, ULT4DB2... modern power tools to get the job done faster & easier than ever.
> http://www.ESAIGroup.com/idug
>
>
> Use of this email content is governed by the terms of service at:
> http://www.idug.org/p/cm/ld/fid=2
>