Mainframe – Someone moving my DB2 Object to READ ONLY

15 pts.
IBM iSeries
How to know who is or which application moving my TS to READ ONLY in a z/OS environment?


Software/Hardware used:
Mainframe z/OS

Answer Wiki

Thanks. We'll let you know when a new response is added.

“moving TS to READ ONLY” – as in “START DB(name) SPACE(name) ACCESS(READ)”?

First, you might just ask around. Failing that…

Only a userid with the proper authority can do this. Or an application bound by someone with the authority.

an sqlid (userid) who is SYSADM, or DBADM, maybe DBMAINT, or an sqlid who is the owner (creator) of the space, or userid in a RACF group where the RACF group has the authority. These are the ones you are looking for.

So you might start off with investigating who has the authority. Check SYSIBM.SYSDBAUTH and also check SYSIBM.SYSUSERAUTH for who has these authorizations.

Offhand, I do not know the way to find who issues START DB commands, but I am sure that this info is somewhere in your DB2 monitor. I would bet on it. After all, SMF records everything. And a monitor is merely reading the SMF records.

So, go ask your DBA for a hand on identifying who is doing this. He can use the Db2 monitor (which ever one you have) to hunt down this information. It may (repeat may) require changing accounting classes (that is where the settings are for gathering information from a DB2 subsystem).

Good luck


Another thought – just in case this is not being caused by START DB(x) SPACE(y) ACCESS(READ) command… if you have done a LOAD of this tablespace and not done an IMAGE COPY, DB2 will not let you UPDATE any tables in this tablespace. Check this by issuing a DISPLAY DB command – look for COPYPEND (copy pending) flag to be set.

Discuss This Question: 1  Reply

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Geetika123
    Thanks for the quick turnaround and time to look into this. Several folks have that privielge and needless to ask, they won't do it. I am kind of thinking an MVS log will show something about it. May be time that someone logged in and did something. Alternatively, a suitable DB2 trace. Ohh yes, DB2 Monitor shoould help. Thnak you once again!
    15 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: