Due to our huge DW/Analytics environment in DB2 z we have a lot of tables created by users without details about tablespace and database, so these tables are created with default values of DB2. However, the locksize default is "ROW" and can not be changed for implicit tablespaces. This situation is causing a several issues because in some cases the user to create this kind of table and after that executes a massive insert of millions rows that affects the DB2 LOCK STRUCTURE and sometimes also harms another environment resources/applications.
Why is it useful?
|Who would benefit from this IDEA?||BANCO DO BRASIL|
How should it work?
We propose to create a new DB2 zparm to specify the locksize default for these cases.
|Priority Justification||High use level|
|Customer Name||BANCO DO BRASIL|
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "firstname.lastname@example.org" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions