Wednesday, July 24, 2024

How to get max LOB size in column - DB2 database

 


SELECT MAX(LENGTHB(LOB_COLUMN)) FROM TABLE;

No comments:

Post a Comment

Is CPU issue ? troubleshooting workflow for oracle database performance issue with automation

✅ ✅ 1. CPU Troubleshooting Framework (Like iostat for CPU) Use: vmstat 2 5 or top 📊 ✅ 2. CPU Metrics Explained (vmstat / top) us sy id wa s...