Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Question about DB2 under Z/VSE

25 views
Skip to first unread message

Sergio Lima

unread,
Oct 2, 2023, 8:17:00 AM10/2/23
to
Hello List,

Does anyone know if DB2 Z/VSE accepts row LOCKS in tables?
We are having a lot of page LOCK problems.
Any information will be very welcome.

Thank you very much and Best Regards.

Sergio Lima Costa
HCL - São Paulo - Brazil

Jeremy Rickard

unread,
Oct 3, 2023, 1:28:05 AM10/3/23
to
Hi Sergio,

I know nothing of this product except that I thought it was discontinued years ago. Anyway, I did a bit of Googling:

1) The product End Of Support date was in fact 30/09/2023, so you are 3 days too late :-)
2) See the Quick Reference manual at https://www.ibm.com/support/pages/db2-server-vse-750-manuals-pdf for useful information.
3) From that manual, I see that the ALTER DBSPACE command can be used to set lock granularity to ROW, and that *possibly* catalog table SYSDBSPACES can be used to query the current lock granularity (column LOCKMODE?).

Good luck,

Jeremy Rickard

Sergio Lima

unread,
Oct 3, 2023, 6:48:02 AM10/3/23
to
Hi Jeremy, Thank you very much for your help.
Actually, I wrote it wrong, DB2 for Z/VSE has another name now:
ARI4028I SDB Server for VSEn Version 7 Release 6 Modification 0.
And the z/VSE product is no longer supported by IBM but by 21CSW.
I'll look at the documentation you mentioned.
Thank you very much again and greetings from the city of São Paulo, Brazil

Jeremy Rickard

unread,
Oct 4, 2023, 6:02:21 AM10/4/23
to
On Tuesday, 3 October 2023 at 23:48:02 UTC+13, Sergio Lima wrote:
> > Hi Sergio,
> >
> > I know nothing of this product except that I thought it was discontinued years ago. Anyway, I did a bit of Googling:
> >
> > 1) The product End Of Support date was in fact 30/09/2023, so you are 3 days too late :-)
> > 2) See the Quick Reference manual at https://www.ibm.com/support/pages/db2-server-vse-750-manuals-pdf for useful information.
> > 3) From that manual, I see that the ALTER DBSPACE command can be used to set lock granularity to ROW, and that *possibly* catalog table SYSDBSPACES can be used to query the current lock granularity (column LOCKMODE?).
> >
> > Good luck,
> >
> > Jeremy Rickard
> Hi Jeremy, Thank you very much for your help.
> Actually, I wrote it wrong, DB2 for Z/VSE has another name now:
> ARI4028I SDB Server for VSEn Version 7 Release 6 Modification 0.
> And the z/VSE product is no longer supported by IBM but by 21CSW.
> I'll look at the documentation you mentioned.
> Thank you very much again and greetings from the city of São Paulo, Brazil
> Sergio Lima Costa
> HCL - São Paulo - Brazil

Hi Sergio,

Hope it helped, and thanks for the information about z/VSE living on as VSEn (https://21cs.com/vsen/).

Greetings from Auckland, New Zealand :-)

Jeremy Rickard
0 new messages