Db2 12 FL500 code level V12R1M506 - mapping tables for REORG

Aurora Emanuela Dellanno

Db2 12 FL500 code level V12R1M506 - mapping tables for REORG

Hi y'all,

 

I hope the question I am going to write will make sense because my brain is a bit mashed today:

 

any thoughts on NOT using an implicitly created table for online REORG, by specifying a DB value in REORG_MAPPING_DATABASE?

 

Thanks.

 

Aurora

 

PS stay safe and healthy

NB black lives matter

John Lynt

Db2 12 FL500 code level V12R1M506 - mapping tables for REORG
(in response to Aurora Emanuela Dellanno)
Yes, been running that way for many years now.

No longer have hard coded mapping TS & IDX objects.

Hit no issues whatsoever.

Simplified our REORG JCL.

Simplifies any/all Db2 upgrades.


Have many Db2 databases & with many apps.

No longer need to carry around the 2000+ hard coded specific mapping tables per each of our 23 labs/environments.


lpar ----------- Thread Terminator DSNZPARM Display ---------- 20/07/09 10:30
Command ====> Scroll ==> PAGE
LINE 205 OF 321
DB2 SSID ==> xxxx Lmod Name ==> xxxxPARM Assem Date ==>
-------------------------------------------------------------------------------
DESCRIPTION VALUE KEYWORD MACRO
------------------------------ ---------- ----------------- --------
Reorganize mapping database. DBMAPTBL REORG_MAPPING_DATABASE DSN6SPRM


We also isolated the REORG mapping table database to its own Bufferpool for TS & IDX as per below.

CREATE DATABASE DBMAPTBL
BUFFERPOOL BP48
INDEXBP BP49
CCSID EBCDIC;




-John Lynt

CBSA


________________________________
From: Aurora Emanuela Dellanno <[login to unmask email]>
Sent: July 9, 2020 9:54:18 AM
To: [login to unmask email]
Subject: [DB2-L] - Db2 12 FL500 code level V12R1M506 - mapping tables for REORG


Hi y'all,



I hope the question I am going to write will make sense because my brain is a bit mashed today:



any thoughts on NOT using an implicitly created table for online REORG, by specifying a DB value in REORG_MAPPING_DATABASE?



Thanks.



Aurora



PS stay safe and healthy

NB black lives matter

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

Aurora Emanuela Dellanno

RE: Db2 12 FL500 code level V12R1M506 - mapping tables for REORG
(in response to John Lynt)

Thanks John!

 

have a good weekend y'all.