DB2 z/OS v11 NFM How to change the database owner

Tim Wilkins

DB2 z/OS v11 NFM How to change the database owner

For audit purposes, we need to change the name of a database creator.

Has anyone done it outside of a drop/recreate?  Is CATMAINT a viable solution?

Kirk Hampton

DB2 z/OS v11 NFM How to change the database owner
(in response to Tim Wilkins)
I have done a couple of recent experiments with CATMAINT on a V10 system, with mixed results.
As long as what you are changing the Creator “TO”
is a name that is not already owner or creator of anything else,
then Yes, it works fine.
I was trying to get rid of more than one former DBA’s ID,
and change the Creator(s) to and existing RACF group name of DB2DBA,
But since that name already owned a few other tables, CATMAINT refused to do it,
I expect it was out of fear that it would create a duplicate entry in the catalog.

In the distant past, I have done the same by setting the undocumented bit in the ZPARMS
and running UPDATE SQL on the catalog. Be VERY careful, but it works great.

J. Kirk Hampton
DB2 z/OS Sysprog
HCL America
Frisco, Texas
817-228-6083


From: Tim Wilkins [mailto:[login to unmask email]
Sent: Thursday, April 20, 2017 8:43 AM
To: [login to unmask email]
Subject: [DB2-L] - DB2 z/OS v11 NFM How to change the database owner


For audit purposes, we need to change the name of a database creator.

Has anyone done it outside of a drop/recreate? Is CATMAINT a viable solution?

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


::DISCLAIMER::
----------------------------------------------------------------------------------------------------------------------------------------------------

The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted,
lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents
(with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates.
Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the
views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification,
distribution and / or publication of this message without the prior written consent of authorized representative of
HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately.
Before opening any email and/or attachments, please check them for viruses and other defects.

----------------------------------------------------------------------------------------------------------------------------------------------------

Jørn Thyssen

RE: DB2 z/OS v11 NFM How to change the database owner
(in response to Tim Wilkins)

Hi Tim,

Any chance you can postpone it to DB2 V12? It has a new SQL command TRANSFER OWNERSHIP for exactly this purpose. 

 

Best regards,

Jørn Thyssen

Works for IBM Denmark. Views are personal.