Tablespace lockrule

Products

• Bind Analyzer for DB2 for z/OS
• SQL-Ease for DB2 for z/OS
• SYSVIEW Performance Management Option for DB2 for z/OS
• Plan Analyzer for DB2 for z/OS
• Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

User was having an issue with a batch job that ran against table space PSADB180. To get passed the issue he altered the lock size from ROW to ANY on the tablespace. Is there a specific LOCKRULE that should be applied to this tablespace? I see the original tablespace creation in the R18 0001 job had it set to LOCKRULE ROW.

Environment

Release:
Component: PSA

Resolution

There is no specific rule about the LOCKSIZE for all the PSA tablespaces.