ICTYPE='M' and STYPE='R'

Bharath Nunepalli

ICTYPE='M' and STYPE='R'

Hi all,

we have an entry for a Tablespace in SYSCOPY as ICTYPE='M' and STYPE='R'.
I don't see the explanation for it in https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/cattab/src/tpc/db2z_sysibmsyscopytable.html

 

Does anyone know what ICTYPE='M' and STYPE='R' mean?

 

Bharath Nunepalli,

Senior DB2 DBA.

John Bucaria

ICTYPE='M' and STYPE='R'
(in response to Bharath Nunepalli)
Hi Bharath:

From the V11 Utility Guide:

“In most cases, MODIFY RECOVERY inserts a SYSIBM.SYSCOPY row with
ICTYPE='M' and STYPE='R' to record the RBA or LRSN of the most recently
deleted SYSCOPY or SYSLGRNX record.”

Regards,
John

From: Bharath Nunepalli <[login to unmask email]>
Sent: Wednesday, August 14, 2019 10:11 AM
To: [login to unmask email]
Subject: [DB2-L] - ICTYPE='M' and STYPE='R'


Hi all,

we have an entry for a Tablespace in SYSCOPY as ICTYPE='M' and STYPE='R'.
I don't see the explanation for it in https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/cattab/src/tpc/db2z_sysibmsyscopytable.html



Does anyone know what ICTYPE='M' and STYPE='R' mean?



Bharath Nunepalli,

Senior DB2 DBA.

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

Phil Grainger

ICTYPE='M' and STYPE='R'
(in response to Bharath Nunepalli)
???

The link you quoted says for ICTYPE “M - MODIFY RECOVERY utility” and STYPE “When ICTYPE = M and the MODIFY RECOVERY utility was executed to delete SYSCOPY and/or SYSLGRNX records, the value is R.”

So it’s business as usual – You ran MODIFY RECOVERY and it deleted records from SYSCOPY and/or SYSLGRNX

Or did I misunderstand your question?

Phil Grainger
Principal Enablement Manager

[BMC Exchange 2019 - Global Event Series - REGISTER] https://www.bmc.com/ami

Direct

+44 1189 218 000

Mobile

+44 7808 643 479

Email

[login to unmask email]

E2, Eskdale Road
Winnersh
Berkshire
United Kingdom
RG41 5TS
[image001 (002)] [cid:[login to unmask email] [https://acclaim-production-app.s3.amazonaws.com/images/2429c3cd-a1de-44fc-b4f3-bc762bb2f963/IBM%2BChampion%2B-%2BAnalytics%2B2018.png]



From: Bharath Nunepalli <[login to unmask email]>
Sent: 14 August 2019 15:11
To: [login to unmask email]
Subject: [EXTERNAL] [DB2-L] - ICTYPE='M' and STYPE='R'


Hi all,

we have an entry for a Tablespace in SYSCOPY as ICTYPE='M' and STYPE='R'.
I don't see the explanation for it in https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/cattab/src/tpc/db2z_sysibmsyscopytable.html



Does anyone know what ICTYPE='M' and STYPE='R' mean?



Bharath Nunepalli,

Senior DB2 DBA.

-----End Original Message-----
BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 1927903 The content of this email is confidential. If you are not the addressee, you may not distribute, copy or disclose any part of it. If you receive this message in error, please delete this from your system and notify the sender immediately.
Attachments

  • image001.jpg (49.7k)
  • image002.png (6.7k)
  • image003.jpg (1.6k)
  • image004.png (<1k)

Daniel Luksetich

ICTYPE='M' and STYPE='R'
(in response to Bharath Nunepalli)
When ICTYPE = M and the MODIFY RECOVERY utility

was executed to delete SYSCOPY and/or SYSLGRNX

records, the value is R.



+--------------------------------------+-----------------------------------------------------------+

| Daniel L Luksetich | IBM Certified Advanced Database Administrator – |

| IBM GOLD Consultant | Db2 10.1 for Linux UNIX and Windows |

| IDUG Content Committee Past-Chairman | IBM Certified Database Adminstrator – Db2 11 DBA for z/OS |

| IDUG DB2-L Administrator | IBM Certified System Administrator – Db2 11 for z/OS |

| URL: https://db2expert.com https://db2expert.com | IBM Certified Application Developer – Db2 11 for z/OS |

+--------------------------------------+-----------------------------------------------------------+





From: Bharath Nunepalli <[login to unmask email]>
Sent: Wednesday, August 14, 2019 9:11 AM
To: [login to unmask email]
Subject: [DB2-L] - ICTYPE='M' and STYPE='R'



Hi all,

we have an entry for a Tablespace in SYSCOPY as ICTYPE='M' and STYPE='R'.
I don't see the explanation for it in https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/cattab/src/tpc/db2z_sysibmsyscopytable.html



Does anyone know what ICTYPE='M' and STYPE='R' mean?



Bharath Nunepalli,

Senior DB2 DBA.



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

Attachments

  • image001.png (18.4k)
  • image002.png (16.2k)
  • image003.png (20k)
  • image004.png (21.4k)
  • image005.png (17.8k)
  • image006.png (17.4k)

Bharath Nunepalli

RE: ICTYPE='M' and STYPE='R'
(in response to Daniel Luksetich)

Thanks for the responses.

I wonder why the explanation is not mentioned in IBM knowledge center

 

Bharath Nunepalli,

Senior DB2 DBA.

Phil Grainger

ICTYPE='M' and STYPE='R'
(in response to Bharath Nunepalli)
It is – that’s where I found my answer (that I quoted). From the link you provided

Phil Grainger
Principal Enablement Manager

[BMC Exchange 2019 - Global Event Series - REGISTER] https://www.bmc.com/ami

Direct

+44 1189 218 000

Mobile

+44 7808 643 479

Email

[login to unmask email]

E2, Eskdale Road
Winnersh
Berkshire
United Kingdom
RG41 5TS
[image001 (002)] [cid:[login to unmask email] [https://acclaim-production-app.s3.amazonaws.com/images/2429c3cd-a1de-44fc-b4f3-bc762bb2f963/IBM%2BChampion%2B-%2BAnalytics%2B2018.png]



From: Bharath Nunepalli <[login to unmask email]>
Sent: 14 August 2019 15:42
To: [login to unmask email]
Subject: [EXTERNAL] [DB2-L] - RE: ICTYPE='M' and STYPE='R'


Thanks for the responses.

I wonder why the explanation is not mentioned in IBM knowledge center



Bharath Nunepalli,

Senior DB2 DBA.

-----End Original Message-----
BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 1927903 The content of this email is confidential. If you are not the addressee, you may not distribute, copy or disclose any part of it. If you receive this message in error, please delete this from your system and notify the sender immediately.
Attachments

  • image001.jpg (49.7k)
  • image002.png (6.7k)
  • image003.jpg (1.6k)
  • image004.png (<1k)

Bharath Nunepalli

RE: ICTYPE='M' and STYPE='R'
(in response to Phil Grainger)

That's very silly of me. I don't know how I missed that.
Thanks for responding.

Roy Boxwell

ICTYPE='M' and STYPE='R'
(in response to Bharath Nunepalli)
If I had a Euro for everything I have missed over the years! I could retire tomorrow!



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: <mailto:[login to unmask email]> [login to unmask email]
Web http://www.seg.de http://www.seg.de

https://www.seg.de/corporate/rechtliche-hinweise/datenschutz Link zur Datenschutzerklärung


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



From: Bharath Nunepalli [mailto:[login to unmask email]
Sent: Thursday, August 15, 2019 10:28 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: ICTYPE='M' and STYPE='R'



That's very silly of me. I don't know how I missed that.
Thanks for responding.



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

Attachments

  • smime.p7s (5.1k)